//确定按钮事件 private void dgvyjsq_CellContentClick(object sender, DataGridViewCellEventArgs e) { try { //comment by wangzhi 2010-10-20 //DataTable tb = (DataTable)dgvyjsq.DataSource; //int nrow = e.RowIndex; //if ( tb.Columns[e.ColumnIndex].ColumnName == "FEE" ) //{ // string bjlzt = tb.Rows[nrow]["bjlzt"].ToString(); // if ( bjlzt == "1" ) // return; // string YZID = tb.Rows[nrow]["yzid"].ToString(); // string YZZXID = tb.Rows[nrow]["YZZXID"].ToString(); // string YJSQID = tb.Rows[nrow]["YJSQID"].ToString(); // string YJQRID = tb.Rows[nrow]["YJQRID"].ToString(); // int zxks = Convert.ToInt32( tb.Rows[nrow]["zxks"] ); // frmfy frmfy = new frmfy( YZID.ToString() , Convertor.IsNull( YZZXID , Guid.Empty.ToString() ) , YJSQID.ToString() , YJQRID.ToString() , zxks , InstanceForm.BDatabase , Convert.ToInt32( cmbjgbm.SelectedValue ) ); // frmfy.ShowDialog(); // DataTable tbfee = select.SelectFee( 2 , new Guid( YZID ) , Guid.Empty , new Guid( Convertor.IsNull( YJQRID , Guid.Empty.ToString() ) ) , InstanceForm.BDatabase ); // decimal zje = Convert.ToDecimal( Convertor.IsNull( tbfee.Compute( "sum(ACVALUE)" , "" ) , "0" ) ); // tb.Rows[nrow]["je"] = zje.ToString(); // dataGridView1.DataSource = tbfee; //} //end comment //add by wangzhi 2010-10-20 DataView dv = (DataView)dgvyjsq.DataSource; if (dgvyjsq.Columns[e.ColumnIndex].Name == 费用.Name) { if (e.RowIndex == -1) { return; } string bjlzt = dv[e.RowIndex]["bjlzt"].ToString(); if (bjlzt == "1") { return; } string YZID = dv[e.RowIndex]["yzid"].ToString(); string YZZXID = dv[e.RowIndex]["YZZXID"].ToString(); string YJSQID = dv[e.RowIndex]["YJSQID"].ToString(); string YJQRID = dv[e.RowIndex]["YJQRID"].ToString(); int zxks = Convert.ToInt32(dv[e.RowIndex]["zxks"]); frmfy frmfy = new frmfy(YZID.ToString(), Convertor.IsNull(YZZXID, Guid.Empty.ToString()), YJSQID.ToString(), YJQRID.ToString(), zxks, InstanceForm.BDatabase, Convert.ToInt32(cmbjgbm.SelectedValue)); //Modify By Tany 2016-01-21 是否允许冲减 if (!_isCj) { frmfy.btdel.Enabled = false; } frmfy.ShowDialog(); DataTable tbfee = select.SelectFee(2, new Guid(YZID), Guid.Empty, new Guid(Convertor.IsNull(YJQRID, Guid.Empty.ToString())), InstanceForm.BDatabase); decimal zje = Convert.ToDecimal(Convertor.IsNull(tbfee.Compute("sum(ACVALUE)", ""), "0")); dv[e.RowIndex]["je"] = zje.ToString(); dv.Table.AcceptChanges(); dataGridView1.DataSource = tbfee; } //end add } catch (System.Exception err) { MessageBox.Show(err.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
//确定按钮事件 private void dgvyjsq_CellContentClick(object sender, DataGridViewCellEventArgs e) { try { DataTable tb = (DataTable)dgvyjsq.DataSource; int nrow = e.RowIndex; if (tb.Columns[e.ColumnIndex].ColumnName == "FEE") { string YZID = tb.Rows[nrow]["yzid"].ToString(); string YZZXID = tb.Rows[nrow]["yzzxid"].ToString(); string YJSQID = tb.Rows[nrow]["YJSQID"].ToString(); string YJQRID = ""; string btfbz = tb.Rows[nrow]["btfbz"].ToString(); int zxks = Convert.ToInt32(tb.Rows[nrow]["zxks"]); frmfy frmfy = new frmfy(YZID.ToString(), Convertor.IsNull(YZZXID, Guid.Empty.ToString()), YJSQID.ToString(), YJQRID.ToString(), zxks, InstanceForm.BDatabase, Convert.ToInt32(cmbjgbm.SelectedValue)); if (btfbz == "1") { frmfy.btcancel.Enabled = false; frmfy.btadd.Enabled = false; frmfy.btdel.Enabled = false; } //Modify By Tany 2016-01-08 是否允许冲减 if (!_isCj) { frmfy.btdel.Enabled = false; } frmfy.ShowDialog(); DataTable tbfee = select.SelectFee(0, new Guid(YZID), new Guid(YZZXID), new Guid(Convertor.IsNull(YJQRID, Guid.Empty.ToString())), InstanceForm.BDatabase); decimal zje = Convert.ToDecimal(Convertor.IsNull(tbfee.Compute("sum(ACVALUE)", ""), "0")); tb.Rows[nrow]["je"] = zje.ToString(); dataGridView1.DataSource = tbfee; } else if (tb.Columns[e.ColumnIndex].ColumnName == "SELECTED") { int selected = Convert.IsDBNull(tb.Rows[nrow]["SELECTED"]) ? 0 : Convert.ToInt32(tb.Rows[nrow]["SELECTED"]); if (selected == 1) { selected = 0; } else { selected = 1; } //Modify by jchl 2016-12-28----------------------------------------- if (selected == 1) { //勾选 确认 string order_id = tb.Rows[nrow]["yzid"].ToString(); string ssql = "select * from zy_inpatient(nolock) where inpatient_id in (select INPATIENT_ID from ZY_ORDERRECORD(nolock) where ORDER_ID='" + order_id + "')"; DataTable tbpa = InstanceForm.BDatabase.GetDataTable(ssql); if (tbpa == null || tbpa.Rows.Count <= 0) { MessageBox.Show("未找到该医嘱对应的病人信息!", "", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } //年底大调价,医保病人不允许跨年冲正2016记账费用 modify by jchl 2016-12-28 string _yblx = tbpa.Rows[0]["YBLX"].ToString().Trim(); if (_yblx.Trim().Equals("1")) { DateTime serDate = DateManager.ServerDateTimeByDBType(InstanceForm.BDatabase); DateTime dtMin = DateTime.Parse("2016-12-31 18:00:00"); DateTime dtMax = DateTime.Parse("2017-01-01 00:10:00"); if (serDate >= dtMin && serDate <= dtMax) { MessageBox.Show("因为年底大调价,根据医院的统一部署安排,12月31日 18点 至 次日0:10分 医保病人不允许操作费用!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } } } tb.Rows[nrow]["SELECTED"] = selected; //tb.AcceptChanges(); } } catch (System.Exception err) { MessageBox.Show(err.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error); } }