public String insertXrayT02(XrayT02 p, String userId)
{
String sql = "", re = "";
chkNull(p);
sql = "Insert Into xray_t02 " +
"(MNC_REQ_YR,MNC_REQ_NO,MNC_REQ_DAT,MNC_REQ_STS" +
",MNC_XR_CD,MNC_XR_RMK,MNC_XR_COS,MNC_XR_PRI" +
",MNC_XR_RFN, MNC_XR_PRI_R, MNC_FLG_K,MNC_STAMP_DAT" +
",MNC_STAMP_TIM,MNC_XR_COS_R,MNC_DOT_CD_DF,MNC_DOT_GRP_CD" +
",MNC_ACT_DAT,MNC_ACT_TIM,MNC_CANCEL_STS,MNC_USR_UPD" +
",MNC_SND_OUT_STS,MNC_XR_STS,status_pacs" +
")" +
"Values ('" + p.MNC_REQ_YR + "','" + p.MNC_REQ_NO + "','" + p.MNC_REQ_DAT + "','" + p.MNC_REQ_STS + "'" +
",'" + p.MNC_XR_CD + "','" + p.MNC_XR_RMK + "','" + p.MNC_XR_COS + "','" + p.MNC_XR_PRI + "'" +
",'" + p.MNC_XR_RFN + "','" + p.MNC_XR_PRI_R + "','" + p.MNC_FLG_K + "',convert(varchar(10), GETDATE(),23)" +
",replace(left(convert(varchar(100),getdate(),108),5),':',''),'" + p.MNC_XR_COS_R + "','" + p.MNC_DOT_CD_DF + "','" + p.MNC_DOT_GRP_CD + "'" +
",'" + p.MNC_ACT_DAT + "','" + p.MNC_ACT_TIM + "','" + p.MNC_CANCEL_STS + "','" + p.MNC_USR_UPD + "'" +
",'" + p.MNC_SND_OUT_STS + "','" + p.MNC_XR_STS + "','" + p.status_pacs + "'" +
")";
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", "XrayT02 insertXrayT02 " + ex.InnerException);
}
return(re);
}
public XrayT02 setXrayT02(XrayT02 p)
{
p.MNC_REQ_YR = "";
p.MNC_REQ_NO = "";
p.MNC_REQ_DAT = "";
p.MNC_REQ_STS = "";
p.MNC_XR_CD = "";
p.MNC_XR_RMK = "";
p.MNC_XR_COS = "";
p.MNC_XR_PRI = "";
p.MNC_XR_RFN = "";
p.MNC_XR_PRI_R = "";
p.MNC_FLG_K = "";
p.MNC_STAMP_DAT = "";
p.MNC_STAMP_TIM = "";
p.MNC_XR_COS_R = "";
p.MNC_DOT_CD_DF = "";
p.MNC_DOT_GRP_CD = "";
p.MNC_ACT_DAT = "";
p.MNC_ACT_TIM = "";
p.MNC_CANCEL_STS = "";
p.MNC_USR_UPD = "";
p.MNC_SND_OUT_STS = "";
p.MNC_XR_STS = "";
p.status_pacs = "";
return(p);
}
private void initConfig()
{
XrayT02 = new XrayT02();
XrayT02.MNC_REQ_YR = "MNC_REQ_YR";
XrayT02.MNC_REQ_NO = "MNC_REQ_NO";
XrayT02.MNC_REQ_DAT = "MNC_REQ_DAT";
XrayT02.MNC_REQ_STS = "MNC_REQ_STS";
XrayT02.MNC_XR_CD = "MNC_XR_CD";
XrayT02.MNC_XR_RMK = "MNC_XR_RMK";
XrayT02.MNC_XR_COS = "MNC_XR_COS";
XrayT02.MNC_XR_PRI = "MNC_XR_PRI";
XrayT02.MNC_XR_RFN = "MNC_XR_RFN";
XrayT02.MNC_XR_PRI_R = "MNC_XR_PRI_R";
XrayT02.MNC_FLG_K = "MNC_FLG_K";
XrayT02.MNC_STAMP_DAT = "MNC_STAMP_DAT";
XrayT02.MNC_STAMP_TIM = "MNC_STAMP_TIM";
XrayT02.MNC_XR_COS_R = "MNC_XR_COS_R";
XrayT02.MNC_DOT_CD_DF = "MNC_DOT_CD_DF";
XrayT02.MNC_DOT_GRP_CD = "MNC_DOT_GRP_CD";
XrayT02.MNC_ACT_DAT = "MNC_ACT_DAT";
XrayT02.MNC_ACT_TIM = "MNC_ACT_TIM";
XrayT02.MNC_CANCEL_STS = "MNC_CANCEL_STS";
XrayT02.MNC_USR_UPD = "MNC_USR_UPD";
XrayT02.MNC_SND_OUT_STS = "MNC_SND_OUT_STS";
XrayT02.MNC_XR_STS = "MNC_XR_STS";
XrayT02.status_pacs = "status_pacs";
}
public XrayT02 setXrayT02(DataTable dt)
{
XrayT02 xrayT02 = new XrayT02();
if (dt.Rows.Count > 0)
{
xrayT02.MNC_REQ_YR = dt.Rows[0]["MNC_REQ_YR"].ToString();
xrayT02.MNC_REQ_NO = dt.Rows[0]["MNC_REQ_NO"].ToString();;
xrayT02.MNC_REQ_DAT = dt.Rows[0]["MNC_REQ_DAT"].ToString();
xrayT02.MNC_REQ_STS = dt.Rows[0]["MNC_REQ_STS"].ToString();;
xrayT02.MNC_XR_CD = dt.Rows[0]["MNC_XR_CD"].ToString();
xrayT02.MNC_XR_RMK = dt.Rows[0]["MNC_XR_RMK"].ToString();
xrayT02.MNC_XR_COS = dt.Rows[0]["MNC_XR_COS"].ToString();
xrayT02.MNC_XR_PRI = dt.Rows[0]["MNC_XR_PRI"].ToString();
xrayT02.MNC_XR_RFN = dt.Rows[0]["MNC_XR_RFN"].ToString();
xrayT02.MNC_XR_PRI_R = dt.Rows[0]["MNC_XR_PRI_R"].ToString();
xrayT02.MNC_FLG_K = dt.Rows[0]["MNC_FLG_K"].ToString();
xrayT02.MNC_STAMP_DAT = dt.Rows[0]["MNC_STAMP_DAT"].ToString();
xrayT02.MNC_STAMP_TIM = dt.Rows[0]["MNC_STAMP_TIM"].ToString();
xrayT02.MNC_XR_COS_R = dt.Rows[0]["MNC_XR_COS_R"].ToString();
xrayT02.MNC_DOT_CD_DF = dt.Rows[0]["MNC_DOT_CD_DF"].ToString();
xrayT02.MNC_DOT_GRP_CD = dt.Rows[0]["MNC_DOT_GRP_CD"].ToString();
xrayT02.MNC_ACT_DAT = dt.Rows[0]["MNC_ACT_DAT"].ToString();
xrayT02.MNC_ACT_TIM = dt.Rows[0]["MNC_ACT_TIM"].ToString();
xrayT02.MNC_CANCEL_STS = dt.Rows[0]["MNC_CANCEL_STS"].ToString();
xrayT02.MNC_USR_UPD = dt.Rows[0]["MNC_USR_UPD"].ToString();
xrayT02.MNC_SND_OUT_STS = dt.Rows[0]["MNC_SND_OUT_STS"].ToString();
xrayT02.MNC_XR_STS = dt.Rows[0]["MNC_XR_STS"].ToString();
xrayT02.status_pacs = dt.Rows[0]["status_pacs"].ToString();
}
else
{
setXrayT02(xrayT02);
}
return(xrayT02);
}
private void chkNull(XrayT02 p)
{
long chk = 0;
int chk1 = 0;
decimal chk2 = 0;
}
