惯性聚合 高效追踪和阅读你感兴趣的博客、新闻、科技资讯
阅读原文 在惯性聚合中打开

推荐订阅源

Google DeepMind News
Google DeepMind News
Stack Overflow Blog
Stack Overflow Blog
Hugging Face - Blog
Hugging Face - Blog
博客园_首页
T
The Blog of Author Tim Ferriss
博客园 - 叶小钗
N
Netflix TechBlog - Medium
腾讯CDC
C
Check Point Blog
P
Proofpoint News Feed
Engineering at Meta
Engineering at Meta
GbyAI
GbyAI
S
SegmentFault 最新的问题
F
Fortinet All Blogs
美团技术团队
U
Unit 42
freeCodeCamp Programming Tutorials: Python, JavaScript, Git & More
博客园 - 司徒正美
F
Full Disclosure
Recorded Future
Recorded Future
D
DataBreaches.Net
博客园 - 【当耐特】
Martin Fowler
Martin Fowler
J
Java Code Geeks
I
InfoQ
Y
Y Combinator Blog
A
About on SuperTechFans
AI
AI
爱范儿
爱范儿
Exploit-DB.com RSS Feed
Exploit-DB.com RSS Feed
Forbes - Security
Forbes - Security
W
WeLiveSecurity
M
MIT News - Artificial intelligence
雷峰网
雷峰网
cs.CV updates on arXiv.org
cs.CV updates on arXiv.org
Simon Willison's Weblog
Simon Willison's Weblog
Schneier on Security
Schneier on Security
The GitHub Blog
The GitHub Blog
Security Archives - TechRepublic
Security Archives - TechRepublic
aimingoo的专栏
aimingoo的专栏
Cyber Security Advisories - MS-ISAC
Cyber Security Advisories - MS-ISAC
G
GRAHAM CLULEY
Know Your Adversary
Know Your Adversary
Latest news
Latest news
Threat Intelligence Blog | Flashpoint
Threat Intelligence Blog | Flashpoint
D
Docker
Recent Commits to openclaw:main
Recent Commits to openclaw:main
量子位
V2EX - 技术
V2EX - 技术
Project Zero
Project Zero

博客园 - ☆用心生活☆

BI-日期维度表-SQL SERVER SQL SERVER 2014 缺少Business Intelligence 解决办法 有未提交的事务。是否要在关闭窗口之前提交这些事务? 获取对象属性和值 日志记录 MSSQL之2005版本之后的行号分区妙用:row_number() over(PARTITION BY X1,X2.. ORDER BY X1,X2... ) IIS发布服务时候无法浏览,提示需要MIME注册 深浅COPY之我所理解,望拍砖交流。 windows developer preview 安装体验。 MSSQL之自增列丢失ID找回--粗略解决方案 水晶报表之分页预留空白方便打印信纸 DataGridView数据呈现之行信息--HitTestInfo--用于选择呈现第一行 SQLMETAL使用LINQ自动代码生成工具命令残参数详解 aspnet_compiler.exe 命令参数详解 妙用MSSQL的REVERSE()反转函数显示文件路径的文件名称 2011年上半年总结 windows phone 7 学习初旅1 MSSQL自定义函数之数据格式化为千分位格式 MSSQL获取指定表的列名信息,描述,数据类型,长度 The product level is insufficient for component "Data Conversion 1"
datagirdview进行数据统计
☆用心生活☆ · 2011-08-20 · via 博客园 - ☆用心生活☆

因为BOSS需要查看销售单退货的情况,不只需要看到退货的明细,而且还要看到退货的总计,以及各个单据对应业务员的关系。因此需要对数据进行统计计算。

以下代码是自己根据自己项目开发中需要用到的地方。 

     /// <summary>
       
/// 对DATAGRIDVIEW设置汇总统计信息
       
/// </summary>

        private void setSumInfo()
        {
           
double RMBrealInit = 0
;
           
double USDrealInit = 0
;
           
double HKDrealInit = 0
;
           
double EURrealInit = 0
;
           
double totalQty = 0;//总消退数

            double totalPcs = 0;//件数
            object obj;
            Object obj2;
           
object
obj3;
           
for (int i = 0; i < dgvSummary.Rows.Count; i++
)
            {
                obj
= dgvSummary.Rows[i].Cells["N_totalBackMoneyQty"
].Value;
                
//循环计算RMB的值

                if (Convert.ToString(dgvSummary.Rows[i].Cells["N_TransactionMoneyTypeDetail"].Value) == "RMB")
                {
                   
if (obj == null
)
                    {
                        RMBrealInit
+= 0
;
                    }
                   
else

                    {
                        RMBrealInit
+= Convert.ToDouble(dgvSummary.Rows[i].Cells["N_totalBackMoneyQty"].Value);
                    }
                }
//循环计算港币

                else if (Convert.ToString(dgvSummary.Rows[i].Cells["N_TransactionMoneyTypeDetail"].Value) == "HKD")
                {
                   
if (obj == null
)
                    {
                        HKDrealInit
+= 0
;

                    }

else
                    {
                        HKDrealInit
+= Convert.ToDouble(dgvSummary.Rows[i].Cells["N_totalBackMoneyQty"].Value);
                    }
                }
//美金

                else if (Convert.ToString(dgvSummary.Rows[i].Cells["N_TransactionMoneyTypeDetail"].Value) == "USD")
                {
                   
if (obj == null
)
                    {
                        USDrealInit
+= 0
;

                    }

else

                    {
                        USDrealInit
+= Convert.ToDouble(dgvSummary.Rows[i].Cells["N_totalBackMoneyQty"].Value);
                    }
                }
//欧元

                else if (Convert.ToString(dgvSummary.Rows[i].Cells["N_TransactionMoneyTypeDetail"].Value) == "EUR")
                {
                   
if (obj == null
)
                    {
                        EURrealInit
+= 0
;

                    }

else

                    {
                        EURrealInit
+= Convert.ToDouble(dgvSummary.Rows[i].Cells["N_totalBackMoneyQty"].Value);
                    }
                }
               
//计算总总量,若需考虑单位,请考虑兑换比例

                obj2 = dgvSummary.Rows[i].Cells["N_TotalBackqty"].Value;
               
if (obj2 == null
)
                {
                    totalQty
+= 0
;
                }
               
else

                {
                    totalQty
+= Convert.ToDouble(dgvSummary.Rows[i].Cells["N_TotalBackqty"].Value);
                }
               
//计算总件数

                obj3 = dgvSummary.Rows[i].Cells["N_TotalBackPcs"].Value;
               
if (obj3 == null
)
                {
                    totalPcs
+= 0
;
                }
               
else

                {
                    totalPcs
+= Convert.ToDouble(dgvSummary.Rows[i].Cells["N_TotalBackPcs"].Value);
                }

            }

/*格式化数字为货币形式*/

            System.Globalization.CultureInfo rmbCultureInfo
= new System.Globalization.CultureInfo("zh-CN");//
            System.Globalization.CultureInfo usdCultureInfo = new System.Globalization.CultureInfo("en-US"
);
            System.Globalization.CultureInfo hkdCultureInfo
= new System.Globalization.CultureInfo("zh-HK"
);
           
this.txtSumRMB.Text = RMBrealInit.ToString("C"
, rmbCultureInfo);
          
// this.txtSumHKD.Text = HKDrealInit.ToString("C", hkdCultureInfo);//此代码显示复数的时候,用括号表示,不知何因由

            this.txtSumHKD.Text ="HK$"+ HKDrealInit.ToString("N2", hkdCultureInfo);
           
this.txtSumUSD.Text = USDrealInit.ToString("C"
, usdCultureInfo);
           
this.txtSumEUR.Text = "" + EURrealInit.ToString("N3"
);
           
this.txtSumWeightQty.Text = totalQty.ToString("N0"
);
           
this.txtTotalPcs.Text = totalPcs.ToString("N0"
);
        }