private void btOk_Click(object sender, EventArgs e) { Class.ClinicDayBalanceNew obj = null; for (int i = 0; i < neuSpread1_Sheet1.Rows.Count; i++) { if (this.neuSpread1_Sheet1.Cells[i, 0].Text != "True") { continue; } if (this.neuSpread1_Sheet1.Rows[i].Tag == null) { continue; } obj = this.neuSpread1_Sheet1.Rows[i].Tag as Class.ClinicDayBalanceNew; balanceNO += obj.BlanceNO + ","; } if (balanceNO == string.Empty) { MessageBox.Show("请选择要汇总的数据!"); return; } balanceNO = balanceNO.Substring(0, balanceNO.LastIndexOf(",")); this.FindForm().DialogResult = DialogResult.OK; this.FindForm().Close(); }
public new ClinicDayBalanceNew Clone() { ClinicDayBalanceNew obj = base.Clone() as ClinicDayBalanceNew; obj.Oper = this.Oper.Clone(); obj.InvoiceNO = this.InvoiceNO.Clone(); return(obj); }
/// <summary> /// 设置单个金额实体(只存一个金额或数量) /// </summary> /// <param name="InvoiceID">统计大类编码</param> /// <param name="InvoiceName">统计大类名称</param> /// <param name="Money">金额</param> /// <param name="typeStr">类别</param> private void SetOneCellDayBalance(string InvoiceID, string InvoiceName, decimal Money, string typeStr) { dayBalance = new Neusoft.Report.Finance.FinOpb.Class.ClinicDayBalanceNew(); dayBalance.InvoiceNO.ID = InvoiceID; dayBalance.InvoiceNO.Name = InvoiceName; dayBalance.TotCost = Money; dayBalance.TypeStr = typeStr; dayBalance.SortID = InvoiceID + "|" + "TOT_COST"; this.SetDayBalance(); }
/// <summary> /// 获得日结实体 /// </summary> private void SetDayBalanceData() { FarPoint.Win.Spread.SheetView sheet = this.ucClinicDayBalanceReportNew1.neuSpread1_Sheet1; string strValue = string.Empty; #region 起止发票号 dayBalance = new Neusoft.Report.Finance.FinOpb.Class.ClinicDayBalanceNew(); dayBalance.InvoiceNO.ID = "A001"; dayBalance.InvoiceNO.Name = "起始结束票据号"; strValue = GetOneCellText(sheet, "A00101"); dayBalance.BegionInvoiceNO = strValue; strValue = GetOneCellText(sheet, "A00102"); dayBalance.EndInvoiceNo = strValue; //设置Cell显示数据的Tag和字段名称 dayBalance.SortID = "A00101|EXTENT_FIELD2、A00102|EXTENT_FIELD3"; dayBalance.TypeStr = "5"; this.SetDayBalance(); #endregion #region 票据总数 strValue = GetOneCellText(sheet, "A002"); this.SetOneCellDayBalance("A002", "票据总数", NConvert.ToDecimal(strValue), "5"); #endregion #region 效票据 strValue = GetOneCellText(sheet, "A003"); this.SetOneCellDayBalance("A003", "有效票据", NConvert.ToDecimal(strValue), "5"); #endregion #region 退费票据 dayBalance = new Neusoft.Report.Finance.FinOpb.Class.ClinicDayBalanceNew(); dayBalance.InvoiceNO.ID = "A004"; dayBalance.InvoiceNO.Name = "退费票据"; //票据数 strValue = this.GetOneCellText(sheet, "A00401"); dayBalance.TotCost = NConvert.ToDecimal(strValue); //票据号 strValue = this.GetOneCellText(sheet, "A00402"); dayBalance.CancelInvoiceNo = strValue; dayBalance.TypeStr = "5"; dayBalance.SortID = "A00401|TOT_COST、A00402|EXTENT_FIELD5"; this.SetDayBalance(); #endregion #region 作废票据 dayBalance = new Neusoft.Report.Finance.FinOpb.Class.ClinicDayBalanceNew(); dayBalance.InvoiceNO.ID = "A005"; dayBalance.InvoiceNO.Name = "作废票据"; strValue = this.GetOneCellText(sheet, "A00501"); dayBalance.TotCost = NConvert.ToDecimal(strValue); strValue = this.GetOneCellText(sheet, "A00502"); dayBalance.FalseInvoiceNo = strValue; dayBalance.TypeStr = "5"; dayBalance.SortID = "A00501|TOT_COST、A00502|EXTENT_FIELD4"; this.SetDayBalance(); #endregion #region 退费金额 strValue = GetOneCellText(sheet, "A006"); this.SetOneCellDayBalance("A006", "退费金额", NConvert.ToDecimal(strValue), "5"); #endregion #region 作废金额 strValue = GetOneCellText(sheet, "A007"); this.SetOneCellDayBalance("A007", "作废金额", NConvert.ToDecimal(strValue), "5"); #endregion #region 暂时无数据 #region 押金金额 strValue = GetOneCellText(sheet, "A008"); this.SetOneCellDayBalance("A008", "押金金额", NConvert.ToDecimal(strValue), "5"); #endregion #region 退押金额 strValue = GetOneCellText(sheet, "A009"); this.SetOneCellDayBalance("A009", "退押金额", NConvert.ToDecimal(strValue), "5"); #endregion #region 减免金额 strValue = GetOneCellText(sheet, "A010"); this.SetOneCellDayBalance("A010", "减免金额", NConvert.ToDecimal(strValue), "5"); #endregion #endregion #region 四舍五入 strValue = GetOneCellText(sheet, "A011"); this.SetOneCellDayBalance("A011", "四舍五入", NConvert.ToDecimal(strValue), "5"); #endregion #region 公费医疗 strValue = this.GetOneCellText(sheet, "A012"); SetOneCellDayBalance("A012", "公费医疗", NConvert.ToDecimal(strValue), "6"); #endregion #region 公费自付 strValue = this.GetOneCellText(sheet, "A013"); SetOneCellDayBalance("A013", "公费自费", NConvert.ToDecimal(strValue), "6"); #endregion #region 公费账户 strValue = this.GetOneCellText(sheet, "A026"); SetOneCellDayBalance("A026", "公费账户", NConvert.ToDecimal(strValue), "6"); #endregion #region 市保自付 strValue = this.GetOneCellText(sheet, "A014"); SetOneCellDayBalance("A014", "市保自费", NConvert.ToDecimal(strValue), "6"); #endregion #region 市保账户 strValue = this.GetOneCellText(sheet, "A015"); SetOneCellDayBalance("A015", "市保账户", NConvert.ToDecimal(strValue), "6"); #endregion #region 市保统筹 strValue = this.GetOneCellText(sheet, "A016"); SetOneCellDayBalance("A016", "市保统筹", NConvert.ToDecimal(strValue), "6"); #endregion #region 市保大额 strValue = this.GetOneCellText(sheet, "A017"); SetOneCellDayBalance("A017", "市保大额", NConvert.ToDecimal(strValue), "6"); #endregion #region 省保自付 strValue = this.GetOneCellText(sheet, "A018"); SetOneCellDayBalance("A018", "省保自费", NConvert.ToDecimal(strValue), "6"); #endregion #region 省保账户 strValue = this.GetOneCellText(sheet, "A019"); SetOneCellDayBalance("A019", "省保账户", NConvert.ToDecimal(strValue), "6"); #endregion #region 省保统筹 strValue = this.GetOneCellText(sheet, "A020"); SetOneCellDayBalance("A020", "省保统筹", NConvert.ToDecimal(strValue), "6"); #endregion #region 省保大额 strValue = this.GetOneCellText(sheet, "A021"); SetOneCellDayBalance("A021", "省保大额", NConvert.ToDecimal(strValue), "6"); #endregion #region 省公务员 strValue = this.GetOneCellText(sheet, "A022"); SetOneCellDayBalance("A022", "省公务员", NConvert.ToDecimal(strValue), "6"); #endregion #region 缴现金额 strValue = this.GetOneCellText(sheet, "A023"); SetOneCellDayBalance("A023", "上缴现金额", NConvert.ToDecimal(strValue), "6"); #endregion #region 缴支票额 strValue = this.GetOneCellText(sheet, "A024"); SetOneCellDayBalance("A024", "上缴支票额", NConvert.ToDecimal(strValue), "6"); #endregion #region 缴银联额 strValue = this.GetOneCellText(sheet, "A025"); SetOneCellDayBalance("A025", "上缴银联额", NConvert.ToDecimal(strValue), "6"); #endregion }
/// <summary> /// 设置显示项目数据 /// </summary> /// <param name="table"></param> protected virtual void SetDetial(DataTable table) { if (table.Rows.Count == 0) { return; } //清除数据 if (ucClinicDayBalanceReportNew1.neuSpread1_Sheet1.Rows.Count > 0) { ucClinicDayBalanceReportNew1.neuSpread1_Sheet1.Rows.Remove(0, ucClinicDayBalanceReportNew1.neuSpread1_Sheet1.Rows.Count - 1); } //设置Farpoint的行数 int count = table.Rows.Count; decimal countMoney = 0; if (count % 2 == 0) { ucClinicDayBalanceReportNew1.neuSpread1_Sheet1.Rows.Count = Convert.ToInt32(count / 2); } else { ucClinicDayBalanceReportNew1.neuSpread1_Sheet1.Rows.Count = Convert.ToInt32(count / 2) + 1; } //显示项目数据 for (int i = 0; i < count; i++) { int index = Convert.ToInt32(i / 2); int intMod = (i + 1) % 2; if (intMod > 0) { ucClinicDayBalanceReportNew1.neuSpread1_Sheet1.Models.Span.Add(index, 0, 1, 2); ucClinicDayBalanceReportNew1.neuSpread1_Sheet1.Cells[index, 0].Text = table.Rows[i][1].ToString(); ucClinicDayBalanceReportNew1.neuSpread1_Sheet1.Cells[index, 2].Text = table.Rows[i][2].ToString(); } else { ucClinicDayBalanceReportNew1.neuSpread1_Sheet1.Models.Span.Add(index, 3, 1, 2); ucClinicDayBalanceReportNew1.neuSpread1_Sheet1.Cells[index, 3].Text = table.Rows[i][1].ToString(); ucClinicDayBalanceReportNew1.neuSpread1_Sheet1.Cells[index, 5].Text = table.Rows[i][2].ToString(); } #region 设置实体 dayBalance = new Neusoft.Report.Finance.FinOpb.Class.ClinicDayBalanceNew(); dayBalance.InvoiceNO.ID = table.Rows[i][0].ToString(); dayBalance.InvoiceNO.Name = table.Rows[i][1].ToString(); dayBalance.TotCost = NConvert.ToDecimal(table.Rows[i][2]); dayBalance.TypeStr = "4"; dayBalance.SortID = "TOT_COST"; this.SetDayBalance(); #endregion countMoney += Convert.ToDecimal(table.Rows[i][2]); } if (count % 2 > 0) { ucClinicDayBalanceReportNew1.neuSpread1_Sheet1.Models.Span.Add(ucClinicDayBalanceReportNew1.neuSpread1_Sheet1.Rows.Count - 1, 3, 1, 2); } //显示合计 ucClinicDayBalanceReportNew1.neuSpread1_Sheet1.Rows.Count += 1; count = ucClinicDayBalanceReportNew1.neuSpread1_Sheet1.Rows.Count; ucClinicDayBalanceReportNew1.neuSpread1_Sheet1.Models.Span.Add(count - 1, 0, 1, 2); ucClinicDayBalanceReportNew1.neuSpread1_Sheet1.Cells[count - 1, 0].Text = "合计:"; ucClinicDayBalanceReportNew1.neuSpread1_Sheet1.Models.Span.Add(count - 1, 2, 1, 4); ucClinicDayBalanceReportNew1.neuSpread1_Sheet1.Cells[count - 1, 2].Text = countMoney.ToString(); this.d合计 = countMoney; }