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

推荐订阅源

TaoSecurity Blog
TaoSecurity Blog
Jina AI
Jina AI
雷峰网
雷峰网
月光博客
月光博客
The GitHub Blog
The GitHub Blog
WordPress大学
WordPress大学
B
Blog RSS Feed
美团技术团队
C
CXSECURITY Database RSS Feed - CXSecurity.com
小众软件
小众软件
Security Latest
Security Latest
Microsoft Azure Blog
Microsoft Azure Blog
Threat Intelligence Blog | Flashpoint
Threat Intelligence Blog | Flashpoint
C
Cybersecurity and Infrastructure Security Agency CISA
Last Week in AI
Last Week in AI
A
Arctic Wolf
Latest news
Latest news
Attack and Defense Labs
Attack and Defense Labs
I
Intezer
F
Fortinet All Blogs
罗磊的独立博客
MongoDB | Blog
MongoDB | Blog
Webroot Blog
Webroot Blog
S
Secure Thoughts
Help Net Security
Help Net Security
Apple Machine Learning Research
Apple Machine Learning Research
博客园_首页
V
Visual Studio Blog
P
Proofpoint News Feed
博客园 - 【当耐特】
P
Privacy International News Feed
V
Vulnerabilities – Threatpost
Stack Overflow Blog
Stack Overflow Blog
Know Your Adversary
Know Your Adversary
云风的 BLOG
云风的 BLOG
Hacker News: Ask HN
Hacker News: Ask HN
L
LINUX DO - 最新话题
H
Help Net Security
爱范儿
爱范儿
酷 壳 – CoolShell
酷 壳 – CoolShell
S
SegmentFault 最新的问题
Forbes - Security
Forbes - Security
T
Tailwind CSS Blog
量子位
奇客Solidot–传递最新科技情报
奇客Solidot–传递最新科技情报
T
Tenable Blog
Cloudbric
Cloudbric
N
News and Events Feed by Topic
cs.AI updates on arXiv.org
cs.AI updates on arXiv.org
Hugging Face - Blog
Hugging Face - Blog

博客园 - ☆用心生活☆

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"
);
        }