private void btnStat_Click(object sender, EventArgs e) { //保存报销明细汇总到报销单 bll_BXD.Save_BXMX_Stat_To_BXD(Convert.ToInt32(lbBXDid.Text), Convert.ToInt32(nudAttNumber.Value)); if (this.BxdUpdated != null) { BxdSelectedEventArgs arg = new BxdSelectedEventArgs(); arg.BxdId = Convert.ToInt32(lbBXDid.Text); this.BxdUpdated(this, arg); } //创建报销凭证。 MRS.Model.BXWarrantTable warrant = bll_BXD.CreateBXWarrantTable(Convert.ToInt32(lbBXDid.Text)); gvWarrant.DataSource = warrant; gvWarrant.Columns["序号"].Visible = false; foreach (DataGridViewColumn column in gvWarrant.Columns) { column.SortMode = DataGridViewColumnSortMode.NotSortable; } btnStat.Enabled = false; btnPrint1.Enabled = true; btnNextPerson.Enabled = true; }
private void InitDrawWarrantGraphic() { BaoXiaoDan = new MRS.Model.BXD(); WarrantTable = new MRS.Model.BXWarrantTable(); //WarrantSite = new Point(); MarginTop = 0; MarginLeft = 15; //单元格内字与左边框的间距 TextFont = new Font("宋体", 12); TitleFont = new Font("黑体", 16); LineHeight = 30; }
public MRS.Model.BXWarrantTable CreateBXWarrantTable(int BXDId) { MRS.Model.BXWarrantTable wTable = new MRS.Model.BXWarrantTable(); SqlParameter bxdid_parm = new SqlParameter(DSL.BXD.BXDID_PARM, SqlDbType.Int); bxdid_parm.Value = BXDId; SqlParameter[] parms = new SqlParameter[1]; parms.SetValue(bxdid_parm, 0); using (SqlDataReader reader = SqlHelper.ExecuteReader(ConnectionString.ConnectionStringMRS, CommandType.StoredProcedure, CommandText.CREATE_BX_WARRANT, parms)) { while (reader.Read()) { DataRow row = wTable.NewRow(); row["OrderIndex"] = reader[DSL.BXWarrantTable.ORDER_INDEX_FIELD].ToString().Trim(); row["JZFS"] = reader[DSL.BXWarrantTable.JZFS_FIELD].ToString().Trim(); row["YYF"] = reader[DSL.BXWarrantTable.YYF_FIELD].ToString().Trim(); row["BXJE"] = reader[DSL.BXWarrantTable.BXJE_FIELD].ToString().Trim(); row["ZLF"] = reader[DSL.BXWarrantTable.ZLF_FIELD].ToString().Trim(); row["TCJJ"] = reader[DSL.BXWarrantTable.TCJJ_FIELD].ToString().Trim(); row["GRZFei"] = reader[DSL.BXWarrantTable.GRZFEI_FIELD].ToString().Trim(); row["GRZFu"] = reader[DSL.BXWarrantTable.GRZFU_FIELD].ToString().Trim(); wTable.Rows.Add(row); } } wTable.Columns["OrderIndex"].ColumnName = "序号"; wTable.Columns["JZFS"].ColumnName = "就诊方式"; wTable.Columns["YYF"].ColumnName = "医药费"; wTable.Columns["BXJE"].ColumnName = "公司补助"; wTable.Columns["ZLF"].ColumnName = "自理费"; wTable.Columns["TCJJ"].ColumnName = "统筹基金"; wTable.Columns["GRZFei"].ColumnName = "个人自费"; wTable.Columns["GRZFu"].ColumnName = "个人自付"; return(wTable); }