private void chkNull(OldJobLabDetail p) { long chk = 0; decimal chk1 = 0; p.PIDS = p.PIDS == null ? "" : p.PIDS; p.VN = p.VN == null ? "" : p.VN; p.FileName = p.FileName == null ? "" : p.FileName; p.Worker1 = p.Worker1 == null ? "" : p.Worker1; p.Worker2 = p.Worker2 == null ? "" : p.Worker2; p.Worker3 = p.Worker3 == null ? "" : p.Worker3; p.Worker4 = p.Worker4 == null ? "" : p.Worker4; p.SP1V = p.SP1V == null ? "" : p.SP1V; p.SP2V = p.SP2V == null ? "" : p.SP2V; p.SP3V = p.SP3V == null ? "" : p.SP3V; p.SP4V = p.SP4V == null ? "" : p.SP4V; p.SP5V = p.SP5V == null ? "" : p.SP5V; p.SP6V = p.SP6V == null ? "" : p.SP6V; p.SP7V = p.SP7V == null ? "" : p.SP7V; p.Extra = p.Extra == null ? "" : p.Extra; p.result = p.result == null ? "" : p.result; p.method = p.method == null ? "" : p.method; p.unit = p.unit == null ? "" : p.unit; p.result_remark = p.result_remark == null ? "" : p.result_remark; p.normal_value = p.normal_value == null ? "" : p.normal_value; p.date_cancel = p.date_cancel == null ? "" : p.date_cancel; p.date_create = p.date_create == null ? "" : p.date_create; p.date_modi = p.date_modi == null ? "" : p.date_modi; p.user_cancel = p.user_cancel == null ? "" : p.user_cancel; p.user_create = p.user_create == null ? "" : p.user_create; p.user_modi = p.user_modi == null ? "" : p.user_modi; p.status_show_qty = p.status_show_qty == null ? "0" : p.status_show_qty; p.status_nurse = p.status_nurse == null ? "0" : p.status_nurse; p.status_cashier = p.status_cashier == null ? "0" : p.status_cashier; p.status_result = p.status_result == null ? "0" : p.status_result; p.status_amt = p.status_amt == null ? "1" : p.status_amt; p.status_order_group = p.status_order_group == null ? "0" : p.status_order_group; p.LGID = long.TryParse(p.LGID, out chk) ? chk.ToString() : "0"; p.QTY = long.TryParse(p.QTY, out chk) ? chk.ToString() : "0"; p.SubItem = long.TryParse(p.SubItem, out chk) ? chk.ToString() : "0"; p.PID = long.TryParse(p.PID, out chk) ? chk.ToString() : "0"; p.Status = long.TryParse(p.Status, out chk) ? chk.ToString() : "0"; p.Extra = long.TryParse(p.Extra, out chk) ? chk.ToString() : "0"; p.PID = long.TryParse(p.PID, out chk) ? chk.ToString() : "0"; p.row1 = long.TryParse(p.row1, out chk) ? chk.ToString() : "0"; p.lab_order_id = long.TryParse(p.lab_order_id, out chk) ? chk.ToString() : "0"; p.req_id = long.TryParse(p.req_id, out chk) ? chk.ToString() : "0"; p.pckdid = long.TryParse(p.pckdid, out chk) ? chk.ToString() : "0"; p.Price = decimal.TryParse(p.Price, out chk1) ? chk1.ToString() : "0"; p.price1 = decimal.TryParse(p.price1, out chk1) ? chk1.ToString() : "0"; }
private void initConfig() { jlabD = new OldJobLabDetail(); jlabD.ID = "ID"; jlabD.VN = "VN"; jlabD.LID = "LID"; jlabD.Extra = "Extra"; jlabD.Price = "Price"; jlabD.Status = "Status"; jlabD.PID = "PID"; jlabD.PIDS = "PIDS"; jlabD.LName = "LName"; jlabD.SP1V = "SP1V"; jlabD.SP2V = "SP2V"; jlabD.SP3V = "SP3V"; jlabD.SP4V = "SP4V"; jlabD.SP5V = "SP5V"; jlabD.SP6V = "SP6V"; jlabD.SP7V = "SP7V"; jlabD.SubItem = "SubItem"; jlabD.FileName = "FileName"; jlabD.Worker1 = "Worker1"; jlabD.Worker2 = "Worker2"; jlabD.Worker3 = "Worker3"; jlabD.Worker4 = "Worker4"; jlabD.LGID = "LGID"; jlabD.QTY = "QTY"; jlabD.row1 = "row1"; jlabD.status_show_qty = "status_show_qty"; jlabD.status_nurse = "status_nurse"; jlabD.status_cashier = "status_cashier"; jlabD.status_result = "status_result"; jlabD.result = "result"; jlabD.method = "method"; jlabD.unit = "unit"; jlabD.result_remark = "result_remark"; jlabD.normal_value = "normal_value"; jlabD.date_cancel = "date_cancel"; jlabD.date_create = "date_create"; jlabD.date_modi = "date_modi"; jlabD.user_cancel = "user_cancel"; jlabD.user_create = "user_create"; jlabD.user_modi = "user_modi"; jlabD.status_amt = "status_amt"; jlabD.status_order_group = "status_order_group"; jlabD.lab_order_id = "lab_order_id"; jlabD.req_id = "req_id"; jlabD.price1 = "price1"; jlabD.pckdid = "pckdid"; jlabD.table = "JobLabDetail"; jlabD.pkField = "ID"; }
public OldJobLabDetail selectByPk1(String pttId) { DataTable dt = new DataTable(); OldJobLabDetail ojld = new OldJobLabDetail(); String sql = "select jlabD.* " + "From " + jlabD.table + " jlabD " + "Where jlabD." + jlabD.pkField + " ='" + pttId + "' "; dt = conn.selectData(conn.conn, sql); ojld = setJobLabDetail(dt); return(ojld); }
public OldJobLabDetail setJobLabDetail(DataTable dt) { OldJobLabDetail lbReq1 = new OldJobLabDetail(); if (dt.Rows.Count > 0) { lbReq1.ID = dt.Rows[0][jlabD.ID].ToString(); lbReq1.VN = dt.Rows[0][jlabD.VN].ToString(); lbReq1.LID = dt.Rows[0][jlabD.LID].ToString(); lbReq1.Extra = dt.Rows[0][jlabD.Extra].ToString(); lbReq1.Price = dt.Rows[0][jlabD.Price].ToString(); lbReq1.Status = dt.Rows[0][jlabD.Status].ToString(); lbReq1.PID = dt.Rows[0][jlabD.PID].ToString(); lbReq1.PIDS = dt.Rows[0][jlabD.PIDS].ToString(); lbReq1.LName = dt.Rows[0][jlabD.LName].ToString(); lbReq1.SP1V = dt.Rows[0][jlabD.SP1V].ToString(); lbReq1.SP2V = dt.Rows[0][jlabD.SP2V].ToString(); lbReq1.SP3V = dt.Rows[0][jlabD.SP3V].ToString(); lbReq1.SP4V = dt.Rows[0][jlabD.SP4V].ToString(); lbReq1.SP5V = dt.Rows[0][jlabD.SP5V].ToString(); lbReq1.SP6V = dt.Rows[0][jlabD.SP6V].ToString(); lbReq1.SP7V = dt.Rows[0][jlabD.SP7V].ToString(); lbReq1.SubItem = dt.Rows[0][jlabD.SubItem].ToString(); lbReq1.FileName = dt.Rows[0][jlabD.FileName].ToString(); lbReq1.Worker1 = dt.Rows[0][jlabD.Worker1].ToString(); lbReq1.Worker2 = dt.Rows[0][jlabD.Worker2].ToString(); lbReq1.Worker3 = dt.Rows[0][jlabD.Worker3].ToString(); lbReq1.Worker4 = dt.Rows[0][jlabD.Worker4].ToString(); lbReq1.LGID = dt.Rows[0][jlabD.LGID].ToString(); lbReq1.QTY = dt.Rows[0][jlabD.QTY].ToString(); lbReq1.row1 = dt.Rows[0][jlabD.row1].ToString(); lbReq1.status_show_qty = dt.Rows[0][jlabD.status_show_qty].ToString(); lbReq1.status_nurse = dt.Rows[0][jlabD.status_nurse].ToString(); lbReq1.status_cashier = dt.Rows[0][jlabD.status_cashier].ToString(); lbReq1.status_result = dt.Rows[0][jlabD.status_result].ToString(); lbReq1.result = dt.Rows[0][jlabD.result].ToString(); lbReq1.method = dt.Rows[0][jlabD.method].ToString(); lbReq1.unit = dt.Rows[0][jlabD.unit].ToString(); lbReq1.result_remark = dt.Rows[0][jlabD.result_remark].ToString(); lbReq1.normal_value = dt.Rows[0][jlabD.normal_value].ToString(); lbReq1.date_cancel = dt.Rows[0][jlabD.date_cancel].ToString(); lbReq1.date_create = dt.Rows[0][jlabD.date_create].ToString(); lbReq1.date_modi = dt.Rows[0][jlabD.date_modi].ToString(); lbReq1.user_cancel = dt.Rows[0][jlabD.user_cancel].ToString(); lbReq1.user_modi = dt.Rows[0][jlabD.user_modi].ToString(); lbReq1.status_amt = dt.Rows[0][jlabD.status_amt].ToString(); lbReq1.status_order_group = dt.Rows[0][jlabD.status_order_group].ToString(); lbReq1.lab_order_id = dt.Rows[0][jlabD.lab_order_id].ToString(); lbReq1.req_id = dt.Rows[0][jlabD.req_id].ToString(); lbReq1.price1 = dt.Rows[0][jlabD.price1].ToString(); lbReq1.pckdid = dt.Rows[0][jlabD.pckdid].ToString(); } else { lbReq1.ID = ""; lbReq1.VN = "N"; lbReq1.LID = ""; lbReq1.Extra = ""; lbReq1.Price = ""; lbReq1.Status = ""; lbReq1.PID = ""; lbReq1.PIDS = ""; lbReq1.LName = ""; lbReq1.SP1V = ""; lbReq1.SP2V = ""; lbReq1.SP3V = ""; lbReq1.SP4V = ""; lbReq1.SP5V = ""; lbReq1.SP6V = ""; lbReq1.SP7V = ""; lbReq1.SubItem = ""; lbReq1.FileName = ""; lbReq1.Worker1 = ""; lbReq1.Worker2 = ""; lbReq1.Worker3 = ""; lbReq1.Worker4 = ""; lbReq1.LGID = ""; lbReq1.QTY = ""; lbReq1.row1 = ""; lbReq1.status_show_qty = ""; lbReq1.status_nurse = ""; lbReq1.status_cashier = ""; lbReq1.status_result = ""; lbReq1.result = ""; lbReq1.method = ""; lbReq1.unit = ""; lbReq1.result_remark = ""; lbReq1.normal_value = ""; lbReq1.date_cancel = ""; lbReq1.date_create = ""; lbReq1.date_modi = ""; lbReq1.user_cancel = ""; lbReq1.user_create = ""; lbReq1.user_modi = ""; lbReq1.status_amt = ""; lbReq1.status_order_group = ""; lbReq1.lab_order_id = ""; lbReq1.req_id = ""; lbReq1.price1 = ""; lbReq1.pckdid = ""; } return(lbReq1); }
public String insert(OldJobLabDetail p, String userId) { String re = ""; String sql = ""; p.active = "1"; //p.ssdata_id = ""; int chk = 0; chkNull(p); //lbReq.form_a_id = "form_a_id"; //p.req_code = genReqDoc(); sql = "Insert Into " + jlabD.table + " Set " + " " + jlabD.VN + " = '" + p.VN + "'" + "," + jlabD.LID + "= '" + p.LID + "'" + "," + jlabD.Extra + "= '" + p.Extra + "'" + "," + jlabD.Price + "= '" + p.Price + "'" + "," + jlabD.Status + "= '" + p.Status + "'" + "," + jlabD.PID + "= '" + p.PID + "'" + "," + jlabD.PIDS + "= '" + p.PIDS + "'" + "," + jlabD.LName + "= '" + p.LName.Replace("'", "''") + "'" + "," + jlabD.SP1V + "= '" + p.SP1V.Replace("'", "''") + "'" + "," + jlabD.SP2V + "= '" + p.SP2V.Replace("'", "''") + "'" + "," + jlabD.SP3V + "= '" + p.SP3V.Replace("'", "''") + "'" + "," + jlabD.SP4V + "= '" + p.SP4V.Replace("'", "''") + "'" + "," + jlabD.SP5V + "= '" + p.SP5V.Replace("'", "''") + "'" + "," + jlabD.SP6V + "= '" + p.SP6V.Replace("'", "''") + "'" + "," + jlabD.SP7V + "= '" + p.SP7V.Replace("'", "''") + "'" + "," + jlabD.SubItem + "= '" + p.SubItem + "'" + "," + jlabD.FileName + "= '" + p.FileName.Replace("'", "''") + "'" + "," + jlabD.Worker1 + "= '" + p.Worker1.Replace("'", "''") + "'" + "," + jlabD.Worker2 + "= '" + p.Worker2.Replace("'", "''") + "'" + "," + jlabD.Worker3 + "= '" + p.Worker3.Replace("'", "''") + "'" + "," + jlabD.Worker4 + "= '" + p.Worker4.Replace("'", "''") + "'" + "," + jlabD.LGID + "= '" + p.LGID.Replace("'", "''") + "'" + "," + jlabD.QTY + "= '" + p.QTY.Replace("'", "''") + "'" + "," + jlabD.row1 + "= '" + p.row1.Replace("'", "''") + "'" + "," + jlabD.status_show_qty + "= '" + p.status_show_qty.Replace("'", "''") + "'" + "," + jlabD.status_nurse + "= '" + p.status_nurse.Replace("'", "''") + "'" + "," + jlabD.status_cashier + "= '" + p.status_cashier.Replace("'", "''") + "'" + "," + jlabD.status_result + "= '" + p.status_result.Replace("'", "''") + "'" + "," + jlabD.result + "= '" + p.result.Replace("'", "''") + "'" + "," + jlabD.method + "= '" + p.method.Replace("'", "''") + "'" + "," + jlabD.unit + "= '" + p.unit.Replace("'", "''") + "'" + "," + jlabD.result_remark + "= '" + p.result_remark.Replace("'", "''") + "'" + "," + jlabD.normal_value + "= '" + p.normal_value.Replace("'", "''") + "'" + "," + jlabD.date_cancel + "= ''" + "," + jlabD.date_create + "= now()" + "," + jlabD.date_modi + "= ''" + "," + jlabD.user_cancel + "= ''" + "," + jlabD.user_create + "= '" + userId + "'" + "," + jlabD.user_modi + "= ''" + "," + jlabD.status_amt + "= '" + p.status_amt.Replace("'", "''") + "'" + "," + jlabD.status_order_group + "= '" + p.status_order_group.Replace("'", "''") + "'" + "," + jlabD.lab_order_id + "= '" + p.lab_order_id + "'" + "," + jlabD.price1 + "= '" + p.price1 + "'" + "," + jlabD.pckdid + "= '" + p.pckdid + "'" + ""; try { if (sql.IndexOf("SubItem= '0'") > 0) { sql = sql.Replace("SubItem= '0'", "SubItem = null"); } re = conn.ExecuteNonQuery(conn.conn, sql); } catch (Exception ex) { sql = ex.Message + " " + ex.InnerException; } return(re); }