public String update(BillDispItems p)
{
String re = "";
String sql = "";
sql = "Update " + bdI.table + " Set " +
" " + bdI.chargeamt + "='" + p.chargeamt + "' " +
", " + bdI.claimcat + "='" + p.claimcat + "' " +
", " + bdI.claimcont + "='" + p.claimcont + "' " +
", " + bdI.dfscode + "='" + p.dfscode + "' " +
", " + bdI.dfstext + "='" + p.dfstext + "' " +
", " + bdI.dispid + "='" + p.dispid + "' " +
", " + bdI.drgid + "='" + p.drgid + "' " +
", " + bdI.hospdrgid + "='" + p.hospdrgid + "' " +
", " + bdI.multidisp + "='" + p.multidisp + "' " +
", " + bdI.packsize + "='" + p.packsize + "' " +
", " + bdI.prdcat + "='" + p.prdcat + "' " +
", " + bdI.prdsecode + "='" + p.prdsecode + "' " +
", " + bdI.quantity + "='" + p.quantity + "' " +
", " + bdI.reimbamt + "='" + p.reimbamt + "' " +
", " + bdI.reimbprice + "='" + p.reimbprice + "' " +
", " + bdI.sigcode + "='" + p.sigcode + "' " +
", " + bdI.sigtext + "='" + p.sigtext + "' " +
", " + bdI.supplyfor + "='" + p.supplyfor + "' " +
", " + bdI.unitprice + "='" + p.unitprice + "' " +
"Where " + bdI.pkField + "='" + p.billdisp_items_id + "'";
re = conn.ExecuteNonQuery1(conn.connSSData, sql);
return(re);
}
public String insert(BillDispItems p)
{
String re = "";
String sql = "";
//p.active = "1";
sql = "Insert Into " + bdI.table + "(" + bdI.billdisp_id + "," + bdI.chargeamt + "," + bdI.claimcat + "," +
bdI.claimcont + "," + bdI.dfscode + "," + bdI.dfstext + "," +
bdI.dispid + "," + bdI.drgid + "," + bdI.hospdrgid + "," +
bdI.multidisp + "," + bdI.packsize + "," + bdI.prdcat + "," +
bdI.prdsecode + "," + bdI.quantity + "," + bdI.reimbamt + "," +
bdI.reimbprice + "," + bdI.sigcode + "," +
bdI.sigtext + "," + bdI.supplyfor + "," + bdI.unitprice + " " +
") " +
"Values('" + p.billdisp_id + "','" + p.chargeamt + "','" + p.claimcat + "','" +
p.claimcont + "','" + p.dfscode + "','" + p.dfstext.Replace("'", "''") + "','" +
p.dispid + "','" + p.drgid + "','" + p.hospdrgid + "','" +
p.multidisp + "','" + p.packsize + "','" + p.prdcat + "','" +
p.prdsecode + "','" + p.quantity + "','" + p.reimbamt + "','" +
p.reimbprice + "','" + p.sigcode + "','" +
p.sigtext.Replace("'", "''") + "','" + p.supplyfor + "','" + p.unitprice + "'" +
") ";
re = conn.ExecuteNonQueryNoClose(conn.connSSDataNoClose, sql);
return(re);
}
private void initConfig()
{
bdI = new BillDispItems();
bdI.billdisp_id = "billdisp_id";
bdI.billdisp_items_id = "billdisp_items_id";
bdI.chargeamt = "chargeamt";
bdI.claimcat = "claimcat";
bdI.claimcont = "claimcont";
bdI.dfscode = "dfscode";
bdI.dfstext = "dfstext";
bdI.dispid = "dispid";
bdI.drgid = "drgid";
bdI.hospdrgid = "hospdrgid";
bdI.multidisp = "multidisp";
bdI.packsize = "packsize";
bdI.prdcat = "prdcat";
bdI.prdsecode = "prdsecode";
bdI.quantity = "quantity";
bdI.reimbamt = "reimbamt";
bdI.reimbprice = "reimbprice";
bdI.sigcode = "sigcode";
bdI.sigtext = "sigtext";
bdI.supplyfor = "supplyfor";
bdI.unitprice = "unitprice";
bdI.table = "t_billdisp_items";
bdI.pkField = "billdisp_items_id";
}
private void initConfig(SSDataControl sc)
{
sC = sc;
bd = new BillDisp();
bdI = new BillDispItems();
fEdit = grdView.Font;
fEdit = new Font(fEdit, FontStyle.Bold);
//setGrdViewH();
setGrdView();
}
private void btnOk_Click(object sender, EventArgs e)
{
for (int i = 0; i < grdView.Sheets[0].RowCount; i++)
{
String edit = "";
edit = grdView.Sheets[0].Cells[i, coledit].Value.ToString();
if (edit.Equals("1"))
{
BillDispItems bdi = new BillDispItems();
bdi.dispid = grdView.Sheets[0].Cells[i, coldispid].Value.ToString();
bdi.prdcat = grdView.Sheets[0].Cells[i, colprdcat].Value.ToString();
bdi.hospdrgid = grdView.Sheets[0].Cells[i, colhospdrgid].Value.ToString();
bdi.drgid = grdView.Sheets[0].Cells[i, coldrgid].Value.ToString();
bdi.dfscode = grdView.Sheets[0].Cells[i, coldfscode].Value.ToString();
bdi.dfstext = grdView.Sheets[0].Cells[i, coldfstext].Value.ToString();
bdi.packsize = grdView.Sheets[0].Cells[i, colpacksize].Value.ToString();
bdi.sigcode = grdView.Sheets[0].Cells[i, colsigcode].Value.ToString();
bdi.sigtext = grdView.Sheets[0].Cells[i, colsigtext].Value.ToString();
bdi.quantity = grdView.Sheets[0].Cells[i, colquantity].Value.ToString();
bdi.unitprice = grdView.Sheets[0].Cells[i, colunitprice].Value.ToString();
bdi.chargeamt = grdView.Sheets[0].Cells[i, colchargeamt].Value.ToString();
bdi.reimbprice = grdView.Sheets[0].Cells[i, colreimbprice].Value.ToString();
bdi.reimbamt = grdView.Sheets[0].Cells[i, colreimbamt].Value.ToString();
bdi.prdsecode = grdView.Sheets[0].Cells[i, colprdsecode].Value.ToString();
bdi.claimcont = grdView.Sheets[0].Cells[i, colclaimcont].Value.ToString();
bdi.claimcat = grdView.Sheets[0].Cells[i, colclaimcat].Value.ToString();
bdi.multidisp = grdView.Sheets[0].Cells[i, colmultidisp].Value.ToString();
bdi.supplyfor = grdView.Sheets[0].Cells[i, colsupplyfor].Value.ToString();
bdi.billdisp_items_id = grdView.Sheets[0].Cells[i, colId].Value.ToString();
bdi.billdisp_id = grdView.Sheets[0].Cells[i, colbdid].Value.ToString();
String re = sC.mHisDB.bdIDB.update(bdi);
if (re.Equals("1"))
{
grdView.Sheets[0].Cells[i, 0, i, colCnt - 1].BackColor = Color.GreenYellow;
}
}
}
}
