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; } } } }