private void initConfig()
{
lolItm = new List <OldLabItem>();
labI = new OldLabItem();
labI.LID = "LID";
labI.LGID = "LGID";
labI.LName = "LName";
labI.WorkTime = "WorkTime";
labI.Price = "Price";
labI.SP1N = "SP1N";
labI.SP1T = "SP1T";
labI.SP2N = "SP2N";
labI.SP2T = "SP2T";
labI.SP3N = "SP3N";
labI.SP3T = "SP3T";
labI.SP4N = "SP4N";
labI.SP4T = "SP4T";
labI.SP5N = "SP5N";
labI.SP5T = "SP5T";
labI.SP6N = "SP6N";
labI.SP6T = "SP6T";
labI.SP7N = "SP7N";
labI.SP7T = "SP7T";
labI.SubItem = "SubItem";
labI.WorkerGroup1 = "WorkerGroup1";
labI.WorkerGroup2 = "WorkerGroup2";
labI.WorkerGroup3 = "WorkerGroup3";
labI.WorkerGroup4 = "WorkerGroup4";
labI.QTY = "QTY";
labI.active = "active";
labI.status_show_qty = "status_show_qty";
labI.status_order_group = "status_order_group";
labI.unit = "unit";
labI.normal_vaule = "normal_vaule";
labI.method = "method";
labI.status_outlab = "status_outlab";
labI.num_barcode = "num_barcode";
labI.lab_unit_id = "lab_unit_id";
labI.method_id = "method_id";
labI.datatype_decimal = "datatype_decimal";
labI.status_datatype_result = "status_datatype_result";
labI.status_interpret = "status_interpret";
labI.remark = "remark";
labI.lis_max_value = "lis_max_value";
labI.lis_min_value = "lis_min_value";
labI.status_send_request = "status_send_request";
labI.sort1 = "sort1";
labI.item_code = "item_code";
labI.date_cancel = "date_cancel";
labI.date_create = "date_create";
labI.date_modi = "date_modi";
labI.user_cancel = "user_cancel";
labI.user_create = "user_create";
labI.user_modi = "user_modi";
labI.table = "LabItem";
labI.pkField = "LID";
}
public OldLabItem setLabItem(DataTable dt)
{
OldLabItem vsold1 = new OldLabItem();
if (dt.Rows.Count > 0)
{
vsold1.LID = dt.Rows[0][labI.LID].ToString();
vsold1.LGID = dt.Rows[0][labI.LGID].ToString();
vsold1.LName = dt.Rows[0][labI.LName].ToString();
vsold1.WorkTime = dt.Rows[0][labI.WorkTime].ToString();
vsold1.Price = dt.Rows[0][labI.Price].ToString();
vsold1.SP1N = dt.Rows[0][labI.SP1N].ToString();
vsold1.SP2N = dt.Rows[0][labI.SP2N].ToString();
vsold1.SP3N = dt.Rows[0][labI.SP3N].ToString();
vsold1.SP4N = dt.Rows[0][labI.SP4N].ToString();
vsold1.SP5N = dt.Rows[0][labI.SP5N].ToString();
vsold1.SP6N = dt.Rows[0][labI.SP6N].ToString();
vsold1.SP7N = dt.Rows[0][labI.SP7N].ToString();
vsold1.SP1T = dt.Rows[0][labI.SP1T].ToString();
vsold1.SP2T = dt.Rows[0][labI.SP2T].ToString();
vsold1.SP3T = dt.Rows[0][labI.SP3T].ToString();
vsold1.SP4T = dt.Rows[0][labI.SP4T].ToString();
vsold1.SP5T = dt.Rows[0][labI.SP5T].ToString();
vsold1.SP6T = dt.Rows[0][labI.SP6T].ToString();
vsold1.SP7T = dt.Rows[0][labI.SP7T].ToString();
vsold1.SubItem = dt.Rows[0][labI.SubItem].ToString();
vsold1.WorkerGroup1 = dt.Rows[0][labI.WorkerGroup1].ToString();
vsold1.WorkerGroup2 = dt.Rows[0][labI.WorkerGroup2].ToString();
vsold1.WorkerGroup3 = dt.Rows[0][labI.WorkerGroup3].ToString();
vsold1.WorkerGroup4 = dt.Rows[0][labI.WorkerGroup4].ToString();
vsold1.QTY = dt.Rows[0][labI.QTY].ToString();
vsold1.status_show_qty = dt.Rows[0][labI.status_show_qty].ToString();
vsold1.status_order_group = dt.Rows[0][labI.status_order_group].ToString();
vsold1.unit = dt.Rows[0][labI.unit].ToString();
vsold1.normal_vaule = dt.Rows[0][labI.normal_vaule].ToString();
vsold1.method = dt.Rows[0][labI.method].ToString();
vsold1.status_outlab = dt.Rows[0][labI.status_outlab].ToString();
vsold1.num_barcode = dt.Rows[0][labI.num_barcode].ToString();
vsold1.method_id = dt.Rows[0][labI.method_id].ToString();
vsold1.lab_unit_id = dt.Rows[0][labI.lab_unit_id].ToString();
vsold1.status_datatype_result = dt.Rows[0][labI.status_datatype_result].ToString();
vsold1.datatype_decimal = dt.Rows[0][labI.datatype_decimal].ToString();
vsold1.status_interpret = dt.Rows[0][labI.status_interpret].ToString();
vsold1.remark = dt.Rows[0][labI.remark].ToString();
vsold1.lis_max_value = dt.Rows[0][labI.lis_max_value].ToString();
vsold1.lis_min_value = dt.Rows[0][labI.lis_min_value].ToString();
vsold1.status_send_request = dt.Rows[0][labI.status_send_request].ToString();
vsold1.sort1 = dt.Rows[0][labI.sort1].ToString();
vsold1.item_code = dt.Rows[0][labI.item_code].ToString();
}
else
{
setLabItem1(vsold1);
}
return(vsold1);
}
public String update(OldLabItem p, String userId)
{
String re = "";
String sql = "";
chkNull(p);
sql = "Update " + labI.table + " Set " +
" " + labI.LName + " = '" + p.LName.Replace("'", "''") + "'" +
"," + labI.Price + "= '" + p.Price + "'" +
//"," + labI.WorkTime + "= '" + p.WorkTime + "'" +
//"," + labI.SP1N + "= '" + p.SP1N + "'" +
//"," + labI.SP1T + "= '" + p.SP1T + "'" +
//"," + labI.SP2N + "= '" + p.SP2N + "'" +
//"," + labI.SP2T + "= '" + p.SP2T + "'" +
//"," + labI.SP3N + "= '" + p.SP3N + "'" +
//"," + labI.SP3T + "= '" + p.SP3T + "'" +
//"," + labI.SP4N + "= '" + p.SP4N + "'" +
//"," + labI.SP4T + "= '" + p.SP4T + "'" +
//"," + labI.SP5N + "= '" + p.SP5N + "'" +
//"," + labI.SP5T + "= '" + p.SP5T + "'" +
//"," + labI.SP6N + "= '" + p.SP6N + "'" +
//"," + labI.SP6T + "= '" + p.SP6T + "'" +
//"," + labI.SP7N + "= '" + p.SP7N + "'" +
//"," + labI.SP7T + "= '" + p.SP7T + "'" +
"," + labI.status_interpret + "= '" + p.status_interpret + "'" +
"," + labI.status_datatype_result + "= '" + p.status_datatype_result + "'" +
"," + labI.datatype_decimal + "= '" + p.datatype_decimal + "'" +
"," + labI.lab_unit_id + "= '" + p.lab_unit_id + "'" +
"," + labI.method_id + "= '" + p.method_id + "'" +
"," + labI.QTY + "= '" + p.QTY + "'" +
"," + labI.LGID + "= '" + p.LGID + "'" +
"," + labI.status_show_qty + "= '" + p.status_show_qty + "'" +
"," + labI.status_order_group + "= '" + p.status_order_group + "'" +
"," + labI.normal_vaule + "= '" + p.normal_vaule.Replace("'", "''") + "'" +
"," + labI.method + "= '" + p.method.Replace("'", "''") + "'" +
"," + labI.unit + "= '" + p.unit.Replace("'", "''") + "'" +
"," + labI.status_outlab + "= '" + p.status_outlab.Replace("'", "''") + "'" +
"," + labI.num_barcode + "= '" + p.num_barcode.Replace("'", "''") + "'" +
"," + labI.remark + "= '" + p.remark.Replace("'", "''") + "'" +
"," + labI.lis_max_value + "= '" + p.lis_max_value.Replace("'", "''") + "'" +
"," + labI.lis_min_value + "= '" + p.lis_min_value.Replace("'", "''") + "'" +
"," + labI.status_send_request + "= '" + p.status_send_request.Replace("'", "''") + "'" +
"," + labI.sort1 + "= '" + p.sort1.Replace("'", "''") + "'" +
"Where " + labI.pkField + "='" + p.LID + "'";
try
{
re = conn.ExecuteNonQuery(conn.conn, sql);
}
catch (Exception ex)
{
sql = ex.Message + " " + ex.InnerException;
}
return(re);
}
public OldLabItem selectByPk1(String pttId)
{
OldLabItem labi1 = new OldLabItem();
DataTable dt = new DataTable();
String sql = "select labI.* " +
"From " + labI.table + " labI " +
"Where labI." + labI.pkField + " ='" + pttId + "' ";
dt = conn.selectData(conn.conn, sql);
labi1 = setLabItem(dt);
return(labi1);
}
public String insertLabItem(OldLabItem p, String userId)
{
String re = "";
if (p.LID.Equals(""))
{
re = insert(p, "");
}
else
{
re = update(p, "");
}
return(re);
}
private OldLabItem setLabItem1(OldLabItem stf1)
{
stf1.LID = "";
stf1.LGID = "";
stf1.LName = "";
stf1.WorkTime = "";
stf1.Price = "";
stf1.SP1N = "";
stf1.SP1T = "";
stf1.SP2N = "";
stf1.SP2T = "";
stf1.SP3N = "";
stf1.SP3T = "";
stf1.SP4N = "";
stf1.SP4T = "";
stf1.SP5N = "";
stf1.SP5T = "";
stf1.SP6N = "";
stf1.SP6T = "";
stf1.SP7N = "";
stf1.SP7T = "";
stf1.SubItem = "";
stf1.WorkerGroup1 = "";
stf1.WorkerGroup2 = "";
stf1.WorkerGroup3 = "";
stf1.WorkerGroup4 = "";
stf1.QTY = "";
stf1.status_show_qty = "";
stf1.status_order_group = "";
stf1.method = "";
stf1.unit = "";
stf1.normal_vaule = "";
stf1.status_outlab = "";
stf1.num_barcode = "";
stf1.lab_unit_id = "";
stf1.method_id = "";
stf1.status_datatype_result = "";
stf1.datatype_decimal = "";
stf1.status_interpret = "";
stf1.remark = "";
stf1.lis_min_value = "";
stf1.lis_max_value = "";
stf1.status_send_request = "";
stf1.sort1 = "";
stf1.item_code = "";
return(stf1);
}
private void setControl(String posiId)
{
labI = ic.ivfDB.oLabiDB.selectByPk1(posiId);
ic.setC1Combo(cboLabGroup, labI.LGID);
txtID.Value = labI.LID;
txtLabName.Value = labI.LName;
txtPrice.Value = labI.Price;
chkShowQty.Checked = labI.status_show_qty.Equals("1") ? true : false;
chkOutLab.Checked = labI.status_outlab.Equals("1") ? true : false;
chkOrderGroup.Checked = labI.status_order_group.Equals("1") ? true : false;
txtNormalValue.Value = labI.normal_vaule;
ic.setC1Combo(cboUnit, labI.lab_unit_id);
ic.setC1Combo(cboMethod, labI.method_id);
txtQty.Value = labI.QTY;
chkDataTypeText.Checked = labI.status_datatype_result.Equals("1") ? true : false;
chkDataTypeInt.Checked = labI.status_datatype_result.Equals("2") ? true : false;
chkDataTypeDec.Checked = labI.status_datatype_result.Equals("3") ? true : false;
chkDataTypeCbo.Checked = labI.status_datatype_result.Equals("4") ? true : false;
txtDataTypeDec.Value = labI.datatype_decimal;
cboDataTypeCbo.Items.Clear();
if (labI.status_datatype_result.Equals("4"))
{
ic.ivfDB.lbDtDB.setCboLabDataTypeComboBox(cboDataTypeCbo, "", txtID.Text);
}
chkInterpretText.Checked = labI.status_interpret.Equals("0") ? true : false;
chkInterpretCbo.Checked = labI.status_interpret.Equals("1") ? true : false;
if (chkInterpretCbo.Checked)
{
setControlEnableInterpret(true);
setGrfInterpret();
}
else
{
setControlEnableInterpret(false);
}
txtlisMaxValue.Value = labI.lis_max_value;
txtlisMinValue.Value = labI.lis_min_value;
chkReqNurseScr.Checked = labI.status_send_request.Equals("0") ? true : false;
chkReqLabFormA.Checked = labI.status_send_request.Equals("1") ? true : false;
txtSort1.Value = labI.sort1;
}
private void initConfig()
{
labI = new OldLabItem();
fEdit = new Font(ic.iniC.grdViewFontName, ic.grdViewFontSize, FontStyle.Regular);
fEditB = new Font(ic.iniC.grdViewFontName, ic.grdViewFontSize, FontStyle.Bold);
color = ColorTranslator.FromHtml(ic.iniC.grfRowColor);
C1ThemeController.ApplicationTheme = ic.iniC.themeApplication;
theme1.Theme = C1ThemeController.ApplicationTheme;
theme1.SetTheme(sB, "BeigeOne");
bg = txtLabName.BackColor;
fc = txtLabName.ForeColor;
ff = txtLabName.Font;
ic.ivfDB.olabgDB.setCboBloodGroup(cboLabGroup, "");
ic.ivfDB.lbuDB.setCboLabUnit(cboUnit, "");
ic.ivfDB.lbmDB.setCboLabMethod(cboMethod, "");
//ic.ivfDB.lbDtDB.setCboLabDataTypeComboBox(cboDataTypeCbo, "");
txtPasswordVoid.KeyUp += TxtPasswordVoid_KeyUp;
btnNew.Click += BtnNew_Click;
btnEdit.Click += BtnEdit_Click;
btnSave.Click += BtnSave_Click;
btnDataTypePlus.Click += BtnDataTypePlus_Click;
chkInterpretCbo.Click += ChkInterpretCbo_Click;
chkInterpretText.Click += ChkInterpretText_Click;
btnInterpretPlus.Click += BtnInterpretPlus_Click;
btnInterpretMinus.Click += BtnInterpretMinus_Click;
btnInterpretSave.Click += BtnInterpretSave_Click;
initGrfLabItem();
setGrfLabItem();
setControlEnable(false);
setFocusColor();
initGrfInterpret();
sB1.Text = "";
btnVoid.Hide();
txtPasswordVoid.Hide();
stt = new C1SuperTooltip();
sep = new C1SuperErrorProvider();
}
public void getloLabItem()
{
//lDept = new List<Position>();
lolItm.Clear();
DataTable dt = new DataTable();
dt = selectAll();
foreach (DataRow row in dt.Rows)
{
OldLabItem itm1 = new OldLabItem();
itm1.LID = row[labI.LID].ToString();
itm1.LGID = row[labI.LGID].ToString();
itm1.LName = row[labI.LName].ToString();
itm1.WorkTime = row[labI.WorkTime].ToString();
itm1.Price = row[labI.Price].ToString();
itm1.QTY = row[labI.QTY].ToString();
lolItm.Add(itm1);
}
}
private void ContextMenu_edit(object sender, System.EventArgs e)
{
String chk1 = "", name = "", id = "", vsid = "", resid = "";
if (grfReq.Row < 0)
{
return;
}
id = grfReq[grfReq.Row, colReqId] != null ? grfReq[grfReq.Row, colReqId].ToString() : "";
vsid = grfReq[grfReq.Row, colReqVsId] != null ? grfReq[grfReq.Row, colReqVsId].ToString() : "";
if (id.Length <= 0)
{
return;
}
ic.cStf.staff_id = "";
FrmPasswordConfirm frm1 = new FrmPasswordConfirm(ic);
frm1.ShowDialog(this);
if (!ic.cStf.staff_id.Equals(""))
{
LabRequest req = new LabRequest();
req = ic.ivfDB.lbReqDB.selectByPk1(id);
if (req.status_req.Equals("2") || req.status_req.Equals("4"))
{
// มีคนอื่น double click รับ request ไปแล้ว ที่ ดัก status เพราะ กัน รับ request แล้ว เกิด record ซ้อนกัน 2 record
}
else
{
DataTable dtVs = new DataTable();
dtVs = ic.ivfDB.lbReqDB.selectLabBloodByVsid(vsid);
foreach (DataRow rowVs in dtVs.Rows)
{
String id1 = "";
id1 = rowVs[ic.ivfDB.lbReqDB.lbReq.req_id].ToString();
LabRequest lbreq = new LabRequest();
lbreq = ic.ivfDB.lbReqDB.selectByPk1(id1);
if (lbreq.req_id.Length <= 0)
{
continue;
}
Lis lis = new Lis();
lis.lis_id = "";
lis.barcode = "";
lis.req_id = lbreq.req_id;
lis.visit_vn = lbreq.vn;
if (lbreq.name_female.Length > 0)
{
lis.patient_name = lbreq.name_female;
lis.visit_hn = lbreq.hn_female;
}
else
{
lis.patient_name = lbreq.name_male;
lis.visit_hn = lbreq.hn_male;
}
lis.visit_id = lbreq.visit_id;
lis.message_lis = "";
lis.active = "";
lis.remark = "";
lis.date_create = "";
lis.date_modi = "";
lis.date_cancel = "";
lis.user_create = "";
lis.user_modi = "";
lis.user_cancel = "";
lis.statis_lis = "";
lis.date_time_receive = "";
lis.date_time_finish = "";
lis.lab_id = lbreq.item_id;
String re = "", re1 = "", re2 = "";
long chk = 0, chk2 = 0;
re1 = ic.ivfDB.lisDB.insertLis(lis, ic.cStf.staff_id);
if (long.TryParse(re1, out chk))
{
LabResult lbRes = new LabResult();
OldLabItem labi = new OldLabItem();
labi = ic.ivfDB.oLabiDB.selectByPk1(lbreq.item_id);
lbRes.result_id = "";
lbRes.lis_id = re1;
lbRes.req_id = lbreq.req_id;
lbRes.visit_id = lbreq.visit_id;
lbRes.patient_id = "";
lbRes.lab_id = lbreq.item_id;
lbRes.result = "";
lbRes.method = "";
lbRes.active = "";
lbRes.remark = "";
lbRes.date_create = "";
lbRes.date_modi = "";
lbRes.date_cancel = "";
lbRes.user_create = "";
lbRes.user_modi = "";
lbRes.user_cancel = "";
lbRes.unit = "";
lbRes.sort1 = "";
lbRes.staff_id_result = "";
lbRes.staff_id_approve = "";
lbRes.date_time_result = "";
lbRes.date_time_approve = "";
lbRes.normal_value = labi.normal_vaule;
lbRes.interpret = "";
lbRes.status_result = "1";
lbRes.row1 = "0";
DateTime date1 = new DateTime();
DateTime.TryParse(lbreq.req_time, out date1);
//lbRes.req_date_time = date1.Year+"-"+ date1.ToString("MM-dd")+" " + date1.ToString("HH:mm:ss");
lbRes.req_date_time = lbreq.req_time;
lbRes.date_time_receive = System.DateTime.Now.Year + "-" + System.DateTime.Now.ToString("MM-dd HH:mm:ss");
lbRes.doctor_id = lbreq.doctor_id;
lbRes.date_time_collect = lbRes.req_date_time;
lbRes.remark_nurse = lbreq.remark;
re2 = ic.ivfDB.lbresDB.insertLabResult(lbRes, ic.cStf.staff_id);
if (long.TryParse(re2, out chk2))
{
resid = re2;
re = ic.ivfDB.lbReqDB.UpdateStatusRequestAccept(lbreq.req_id, ic.cStf.staff_id);
chk = 0;
if (long.TryParse(re, out chk))
{
// ยังไม่ได้ต่อ LIS 62-08-03
//try
//{
// SetDefaultPrinter(ic.iniC.printerSticker);
// Lis lis1 = new Lis();
// lis1 = ic.ivfDB.lisDB.selectByPk(re1);
// Visit vs = new Visit();
// vs = ic.ivfDB.vsDB.selectByVn(lis1.visit_vn);
// Patient ptt = new Patient();
// ptt = ic.ivfDB.pttDB.selectByPk1(vs.t_patient_id);
// DataTable dt = new DataTable();
// dt.Columns.Add("hn", typeof(String));
// dt.Columns.Add("name", typeof(String));
// dt.Columns.Add("age", typeof(String));
// dt.Columns.Add("vn", typeof(String));
// DataRow row11 = dt.NewRow();
// row11["hn"] = lis1.visit_hn;
// row11["name"] = lis1.patient_name;
// row11["age"] = "Age " + ptt.AgeStringShort() + " [" + ic.datetoShow(ptt.patient_birthday) + "]";
// row11["vn"] = lis1.barcode;
// dt.Rows.Add(row11);
// FrmReport frm = new FrmReport(ic);
// frm.setStickerPatientThemalLIS(dt);
// frm.ShowDialog(this);
// SetDefaultPrinter(ic.iniC.printerSticker);
//}
//catch (Exception ex)
//{
// MessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
// return;
//}
// ยังไม่ได้ต่อ LIS 62-08-03
}
}
}
}
}
}
//String id = "";
//id = grfProc[grfProc.Row, colRsId] != null ? grfProc[grfProc.Row, colRsId].ToString() : "";
FrmLabBloodAdd frm = new FrmLabBloodAdd(ic, resid);
frm.ShowDialog(this);
setGrfReq();
//chk = grfReq[grfReq.Row, colRqReqNum] != null ? grfReq[grfReq.Row, colRqReqNum].ToString() : "";
//name = grfReq[grfReq.Row, colRqName] != null ? grfReq[grfReq.Row, colRqName].ToString() : "";
////if (MessageBox.Show("ต้องการ ป้อน LAB OPU \n req number " + chk+" \n name "+ name, "", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button2) == DialogResult.OK)
////{
////grfReq.Rows.Remove(grfReq.Row);
//Cursor curOld;
//curOld = this.Cursor;
//this.Cursor = Cursors.WaitCursor;
//openLabOPUNew(id, name);
//setGrfReq();
//setGrfProc("");
//this.Cursor = curOld;
//}
}
public String insert(OldLabItem 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 " + labI.table + " Set " +
" " + labI.LName + " = '" + p.LName.Replace("'", "''") + "'" +
"," + labI.Price + "= '" + p.Price + "'" +
"," + labI.WorkTime + "= '" + p.WorkTime + "'" +
"," + labI.SP1N + "= '" + p.SP1N + "'" +
"," + labI.SP1T + "= '" + p.SP1T + "'" +
"," + labI.SP2N + "= '" + p.SP2N + "'" +
"," + labI.SP2T + "= '" + p.SP2T + "'" +
"," + labI.SP3N + "= '" + p.SP3N + "'" +
"," + labI.SP3T + "= '" + p.SP3T + "'" +
"," + labI.SP4N + "= '" + p.SP4N + "'" +
"," + labI.SP4T + "= '" + p.SP4T + "'" +
"," + labI.SP5N + "= '" + p.SP5N + "'" +
"," + labI.SP5T + "= '" + p.SP5T + "'" +
"," + labI.SP6N + "= '" + p.SP6N + "'" +
"," + labI.SP6T + "= '" + p.SP6T + "'" +
"," + labI.SP7N + "= '" + p.SP7N + "'" +
"," + labI.SP7T + "= '" + p.SP7T + "'" +
"," + labI.SubItem + "= '" + p.SubItem + "'" +
"," + labI.WorkerGroup1 + "= '" + p.WorkerGroup1 + "'" +
"," + labI.WorkerGroup2 + "= '" + p.WorkerGroup2 + "'" +
"," + labI.WorkerGroup3 + "= '" + p.WorkerGroup3 + "'" +
"," + labI.WorkerGroup4 + "= '" + p.WorkerGroup4 + "'" +
"," + labI.QTY + "= '" + p.QTY + "'" +
"," + labI.active + "= '1'" +
"," + labI.LGID + "= '" + p.LGID + "'" +
"," + labI.status_show_qty + "= '" + p.status_show_qty + "'" +
"," + labI.status_order_group + "= '" + p.status_order_group + "'" +
"," + labI.normal_vaule + "= '" + p.normal_vaule.Replace("'", "''") + "'" +
"," + labI.method + "= '" + p.method.Replace("'", "''") + "'" +
"," + labI.unit + "= '" + p.unit.Replace("'", "''") + "'" +
"," + labI.status_outlab + "= '" + p.status_outlab.Replace("'", "''") + "'" +
"," + labI.num_barcode + "= '" + p.num_barcode.Replace("'", "''") + "'" +
"," + labI.lab_unit_id + "= '" + p.lab_unit_id.Replace("'", "''") + "'" +
"," + labI.method_id + "= '" + p.method_id.Replace("'", "''") + "'" +
"," + labI.status_datatype_result + "= '" + p.status_datatype_result.Replace("'", "''") + "'" +
"," + labI.datatype_decimal + "= '" + p.datatype_decimal.Replace("'", "''") + "'" +
"," + labI.status_interpret + "= '" + p.status_interpret.Replace("'", "''") + "'" +
"," + labI.remark + "= '" + p.remark.Replace("'", "''") + "'" +
"," + labI.lis_max_value + "= '" + p.lis_max_value.Replace("'", "''") + "'" +
"," + labI.lis_min_value + "= '" + p.lis_min_value.Replace("'", "''") + "'" +
"," + labI.status_send_request + "= '" + p.status_send_request.Replace("'", "''") + "'" +
"," + labI.sort1 + "= '" + p.sort1.Replace("'", "''") + "'" +
"";
try
{
re = conn.ExecuteNonQuery(conn.conn, sql);
}
catch (Exception ex)
{
sql = ex.Message + " " + ex.InnerException;
}
return(re);
}
private void chkNull(OldLabItem p)
{
long chk = 0;
Decimal chk1 = 0;
p.date_modi = p.date_modi == null ? "" : p.date_modi;
p.date_cancel = p.date_cancel == null ? "" : p.date_cancel;
p.user_create = p.user_create == null ? "" : p.user_create;
p.user_modi = p.user_modi == null ? "" : p.user_modi;
p.user_cancel = p.user_cancel == null ? "" : p.user_cancel;
//p.prefix_id = int.TryParse(p.prefix_id, out chk) ? chk.ToString() : "0";
//p.posi_id = int.TryParse(p.posi_id, out chk) ? chk.ToString() : "0";
//p.posi_id = int.TryParse(p.posi_id, out chk) ? chk.ToString() : "0";
p.LName = p.LName == null ? "" : p.LName;
p.SP1N = p.SP1N == null ? "" : p.SP1N;
p.SP1T = p.SP1T == null ? "" : p.SP1T;
p.SP2N = p.SP2N == null ? "" : p.SP2N;
p.SP2T = p.SP2T == null ? "" : p.SP2T;
p.SP3N = p.SP3N == null ? "" : p.SP3N;
p.SP3T = p.SP3T == null ? "" : p.SP3T;
p.SP4N = p.SP4N == null ? "" : p.SP4N;
p.SP4T = p.SP4T == null ? "" : p.SP4T;
p.SP5N = p.SP5N == null ? "" : p.SP5N;
p.SP5T = p.SP5T == null ? "" : p.SP5T;
p.SP6N = p.SP6N == null ? "" : p.SP6N;
p.SP6T = p.SP6T == null ? "" : p.SP6T;
p.SP7N = p.SP7N == null ? "" : p.SP7N;
p.SP7T = p.SP7T == null ? "" : p.SP7T;
p.WorkerGroup1 = p.WorkerGroup1 == null ? "" : p.WorkerGroup1;
p.WorkerGroup2 = p.WorkerGroup2 == null ? "" : p.WorkerGroup2;
p.WorkerGroup3 = p.WorkerGroup3 == null ? "" : p.WorkerGroup3;
p.WorkerGroup4 = p.WorkerGroup4 == null ? "" : p.WorkerGroup4;
p.active = p.active == null ? "" : p.active;
p.method = p.method == null ? "" : p.method;
p.unit = p.unit == null ? "" : p.unit;
p.normal_vaule = p.normal_vaule == null ? "" : p.normal_vaule;
p.num_barcode = p.num_barcode == null ? "0" : p.num_barcode;
p.status_datatype_result = p.status_datatype_result == null ? "0" : p.status_datatype_result;
p.datatype_decimal = p.datatype_decimal == null ? "0" : p.datatype_decimal;
p.remark = p.remark == null ? "" : p.remark;
p.lis_max_value = p.lis_max_value == null ? "" : p.lis_max_value;
p.lis_min_value = p.lis_min_value == null ? "" : p.lis_min_value;
p.status_show_qty = p.status_show_qty == null ? "0" : p.status_show_qty;
p.status_order_group = p.status_order_group == null ? "0" : p.status_order_group;
p.status_outlab = p.status_outlab == null ? "0" : p.status_outlab;
p.status_interpret = p.status_interpret.Equals("") ? "0" : p.status_interpret;
p.status_send_request = p.status_send_request.Equals("") ? "0" : p.status_send_request;
p.sort1 = p.sort1.Equals("") ? "999999999" : p.sort1;
p.LGID = long.TryParse(p.LGID, out chk) ? chk.ToString() : "0";
p.SubItem = long.TryParse(p.SubItem, out chk) ? chk.ToString() : "0";
p.QTY = long.TryParse(p.QTY, out chk) ? chk.ToString() : "1";
p.lab_unit_id = long.TryParse(p.lab_unit_id, out chk) ? chk.ToString() : "0";
p.method_id = long.TryParse(p.method_id, out chk) ? chk.ToString() : "0";
p.Price = Decimal.TryParse(p.Price, out chk1) ? chk1.ToString() : "0";
//p.QTY = Decimal.TryParse(p.QTY, out chk1) ? chk1.ToString() : "0";
//p.user_cancel = p.user_cancel == null ? "" : p.user_cancel;
if (p.QTY.Equals("0"))
{
p.QTY = "1";
}
}
