public void SumTotal() { DataTable contrast = CostApply.GetContrast(base.Request["ic"]); if (contrast.Rows.Count > 0) { System.Collections.Generic.Dictionary <string, decimal> dictionary = new System.Collections.Generic.Dictionary <string, decimal>(); string text = "ThisAmount"; decimal value = decimal.Parse(contrast.Compute("sum(" + text + ")", "1=1").ToString()); dictionary.Add(text, value); DataTable dataTable = contrast.Clone(); int num = -1; foreach (DataRow dataRow in contrast.Rows) { num++; if (num <= 0 || !(dataRow["CBSCode"].ToString() == contrast.Rows[num - 1]["CBSCode"].ToString())) { DataRow dataRow2 = dataTable.NewRow(); dataRow2.ItemArray = dataRow.ItemArray; dataTable.Rows.Add(dataRow2); } } decimal value2 = decimal.Parse((dataTable.Compute("SUM(MonthAmount)", "1=1") == null) ? 0m.ToString() : dataTable.Compute("SUM(MonthAmount)", "1=1").ToString()); dictionary.Add("MonthAmount", value2); decimal value3 = decimal.Parse(dataTable.Compute("SUM(PrjAmount)", "1=1").ToString()); dictionary.Add("PrjAmount", value3); decimal value4 = decimal.Parse(dataTable.Compute("SUM(PrjAlreadyAmount)", "1=1").ToString()); dictionary.Add("PrjAlreadyAmount", value4); this.ViewState["sum"] = dictionary; } }
public void DBTestMethod() { int costId = TimeTools.Timestamp(); List <cost_detail> details = new List <cost_detail> { new cost_detail { cost_id = costId, cost_type = "出差", money = 1213 }, new cost_detail { cost_id = costId, cost_type = "住宿", money = 2324 } }; cost_main costMain = new cost_main { applicant = "test", apply_money = 1213.12M, apply_time = DateTime.Now, approver = "test", id = costId, cost_detail = details, status = 1, approval_time = DateTime.Now, approval_money = 131 }; CostApply costApply = new CostApply(); int a = costApply.InsertBill(costMain); Console.WriteLine(a); }
protected void BindRptContrast() { DataTable contrast = CostApply.GetContrast(base.Request["ic"]); this.rptContrast.DataSource = contrast; this.rptContrast.DataBind(); if (contrast.Rows.Count == 0) { base.RegisterScript("$('#rptContrast tr:last-child').remove();"); } }