public String insertLabT02(LabT02 p, String userId)
{
String sql = "", re = "";
chkNull(p);
sql = "Insert Into lab_t02 " +
"(MNC_REQ_YR,MNC_REQ_NO,MNC_REQ_DAT,MNC_REQ_STS" +
",MNC_LB_CD,MNC_LB_RMK,MNC_LB_COS,MNC_LB_PRI" +
",MNC_LB_RFN, MNC_SPC_SEND_DAT, MNC_SPC_SEND_TM,MNC_STAMP_DAT" +
",MNC_STAMP_TIM,MNC_SPC_TYP,MNC_RESULT_DAT,MNC_RESULT_TIM" +
",MNC_USR_RESULT,MNC_USR_RESULT_REPORT,MNC_USR_RESULT_APPROVE,MNC_CANCEL_STS" +
",MNC_USR_UPD,MNC_SND_OUT_STS,MNC_LB_STS" +
")" +
"Values ('" + p.MNC_REQ_YR + "','" + p.MNC_REQ_NO + "','" + p.MNC_REQ_DAT + "','" + p.MNC_REQ_STS + "'" +
",'" + p.MNC_LB_CD + "','" + p.MNC_LB_RMK + "','" + p.MNC_LB_COS + "','" + p.MNC_LB_PRI + "'" +
",'" + p.MNC_LB_RFN + "','" + p.MNC_SPC_SEND_DAT + "','" + p.MNC_SPC_SEND_TM + "',convert(varchar(10), GETDATE(),23)" +
",replace(left(convert(varchar(100),getdate(),108),5),':',''),'" + p.MNC_SPC_TYP + "','" + p.MNC_RESULT_DAT + "','" + p.MNC_RESULT_TIM + "'" +
",'" + p.MNC_USR_RESULT + "','" + p.MNC_USR_RESULT_REPORT + "','" + p.MNC_USR_RESULT_APPROVE + "','" + p.MNC_CANCEL_STS + "'" +
",'" + p.MNC_USR_UPD + "','" + p.MNC_SND_OUT_STS + "','" + p.MNC_LB_STS + "'" +
")";
try
{
re = conn.ExecuteNonQuery(conn.connMainHIS, sql);
//new LogWriter("d", "PharmacyT02 insertPharmacyT02 sql " + sql);
}
catch (Exception ex)
{
sql = ex.Message + " " + ex.InnerException;
new LogWriter("e", "LabT02 insertLabT02 " + ex.InnerException);
}
return(re);
}
public LabT02 setLabT02(LabT02 p)
{
p.MNC_REQ_YR = "";
p.MNC_REQ_NO = "";
p.MNC_REQ_DAT = "";
p.MNC_LB_CD = "";
p.MNC_REQ_STS = "";
p.MNC_LB_RMK = "";
p.MNC_LB_COS = "";
p.MNC_LB_PRI = "";
p.MNC_SPC_SEND_DAT = "";
p.MNC_SPC_SEND_TM = "";
p.MNC_SPC_TYP = "";
p.MNC_RESULT_DAT = "";
p.MNC_RESULT_TIM = "";
p.MNC_STAMP_DAT = "";
p.MNC_STAMP_TIM = "";
p.MNC_USR_RESULT = "";
p.MNC_USR_RESULT_REPORT = "";
p.MNC_USR_RESULT_APPROVE = "";
p.MNC_CANCEL_STS = "";
p.MNC_USR_UPD = "";
p.MNC_SND_OUT_STS = "";
p.MNC_LB_STS = "";
return(p);
}
private void initConfig()
{
labT02 = new LabT02();
labT02.MNC_REQ_YR = "MNC_REQ_YR";
labT02.MNC_REQ_NO = "MNC_REQ_NO";
labT02.MNC_REQ_DAT = "MNC_REQ_DAT";
labT02.MNC_LB_CD = "MNC_LB_CD";
labT02.MNC_REQ_STS = "MNC_REQ_STS";
labT02.MNC_LB_RMK = "MNC_LB_RMK";
labT02.MNC_LB_COS = "MNC_LB_COS";
labT02.MNC_LB_PRI = "MNC_LB_PRI";
labT02.MNC_LB_RFN = "MNC_LB_RFN";
labT02.MNC_SPC_SEND_DAT = "MNC_SPC_SEND_DAT";
labT02.MNC_SPC_SEND_TM = "MNC_SPC_SEND_TM";
labT02.MNC_SPC_TYP = "MNC_SPC_TYP";
labT02.MNC_RESULT_DAT = "MNC_RESULT_DAT";
labT02.MNC_RESULT_TIM = "MNC_RESULT_TIM";
labT02.MNC_STAMP_DAT = "MNC_STAMP_DAT";
labT02.MNC_STAMP_TIM = "MNC_STAMP_TIM";
labT02.MNC_USR_RESULT = "MNC_USR_RESULT";
labT02.MNC_USR_RESULT_REPORT = "MNC_USR_RESULT_REPORT";
labT02.MNC_USR_RESULT_APPROVE = "MNC_USR_RESULT_APPROVE";
labT02.MNC_CANCEL_STS = "MNC_CANCEL_STS";
labT02.MNC_USR_UPD = "MNC_USR_UPD";
labT02.MNC_SND_OUT_STS = "MNC_SND_OUT_STS";
labT02.MNC_LB_STS = "MNC_LB_STS";
}
public LabT02 setLabT02(DataTable dt)
{
LabT02 labT02 = new LabT02();
if (dt.Rows.Count > 0)
{
labT02.MNC_REQ_YR = dt.Rows[0]["MNC_REQ_YR"].ToString();
labT02.MNC_REQ_NO = dt.Rows[0]["MNC_REQ_NO"].ToString();
labT02.MNC_REQ_DAT = dt.Rows[0]["MNC_REQ_DAT"].ToString();
labT02.MNC_LB_CD = dt.Rows[0]["MNC_LB_CD"].ToString();
labT02.MNC_REQ_STS = dt.Rows[0]["MNC_REQ_STS"].ToString();
labT02.MNC_LB_RMK = dt.Rows[0]["MNC_LB_RMK"].ToString();
labT02.MNC_LB_COS = dt.Rows[0]["MNC_LB_COS"].ToString();
labT02.MNC_LB_PRI = dt.Rows[0]["MNC_LB_PRI"].ToString();
labT02.MNC_LB_RFN = dt.Rows[0]["MNC_LB_RFN"].ToString();
labT02.MNC_SPC_SEND_DAT = dt.Rows[0]["MNC_SPC_SEND_DAT"].ToString();
labT02.MNC_SPC_SEND_TM = dt.Rows[0]["MNC_SPC_SEND_TM"].ToString();
labT02.MNC_SPC_TYP = dt.Rows[0]["MNC_SPC_TYP"].ToString();
labT02.MNC_RESULT_DAT = dt.Rows[0]["MNC_RESULT_DAT"].ToString();;
labT02.MNC_RESULT_TIM = dt.Rows[0]["MNC_RESULT_TIM"].ToString();
labT02.MNC_STAMP_DAT = dt.Rows[0]["MNC_STAMP_DAT"].ToString();
labT02.MNC_STAMP_TIM = dt.Rows[0]["MNC_STAMP_TIM"].ToString();
labT02.MNC_USR_RESULT = dt.Rows[0]["MNC_USR_RESULT"].ToString();
labT02.MNC_USR_RESULT_REPORT = dt.Rows[0]["MNC_USR_RESULT_REPORT"].ToString();
labT02.MNC_USR_RESULT_APPROVE = dt.Rows[0]["MNC_USR_RESULT_APPROVE"].ToString();
labT02.MNC_CANCEL_STS = dt.Rows[0]["MNC_CANCEL_STS"].ToString();
labT02.MNC_USR_UPD = dt.Rows[0]["MNC_USR_UPD"].ToString();
labT02.MNC_SND_OUT_STS = dt.Rows[0]["MNC_SND_OUT_STS"].ToString();
labT02.MNC_LB_STS = dt.Rows[0]["MNC_LB_STS"].ToString();
}
else
{
setLabT02(labT02);
}
return(labT02);
}
private void chkNull(LabT02 p)
{
long chk = 0;
int chk1 = 0;
decimal chk2 = 0;
}
