public LabM01 setLabM01(DataTable dt) { LabM01 labM01 = new LabM01(); if (dt.Rows.Count > 0) { labM01.MNC_LB_CD = dt.Rows[0]["MNC_LB_CD"].ToString(); labM01.MNC_LB_DSC = dt.Rows[0]["MNC_LB_DSC"].ToString(); labM01.MNC_LB_TYP_CD = dt.Rows[0]["MNC_LB_TYP_CD"].ToString(); labM01.MNC_LB_GRP_CD = dt.Rows[0]["MNC_LB_GRP_CD"].ToString(); labM01.MNC_LB_DIS_STS = dt.Rows[0]["MNC_LB_DIS_STS"].ToString(); labM01.MNC_SCH_ACT = dt.Rows[0]["MNC_SCH_ACT"].ToString(); labM01.MNC_STAMP_DAT = dt.Rows[0]["MNC_STAMP_DAT"].ToString(); labM01.MNC_STAMP_TIM = dt.Rows[0]["MNC_STAMP_TIM"].ToString(); labM01.MNC_SPC_CD = dt.Rows[0]["MNC_SPC_CD"].ToString(); labM01.MNC_LB_STS = dt.Rows[0]["MNC_LB_STS"].ToString(); labM01.MNC_USR_ADD = dt.Rows[0]["MNC_USR_ADD"].ToString(); labM01.MNC_USR_UPD = dt.Rows[0]["MNC_USR_UPD"].ToString(); labM01.MNC_LB_CTL_CD = dt.Rows[0]["MNC_LB_CTL_CD"].ToString(); labM01.MNC_LB_OLD_CD = dt.Rows[0]["MNC_LB_OLD_CD"].ToString(); labM01.MNC_DEC_CD = dt.Rows[0]["MNC_DEC_CD"].ToString(); labM01.MNC_DEC_NO = dt.Rows[0]["MNC_DEC_NO"].ToString(); labM01.MNC_LB_PRI = dt.Rows[0]["MNC_LB_PRI"].ToString(); labM01.mnc_res_flg = dt.Rows[0]["mnc_res_flg"].ToString(); labM01.MNC_HL7_CODE = dt.Rows[0]["mnc_res_flg"].ToString(); labM01.ucep_code = dt.Rows[0]["ucep_code"].ToString(); labM01.price = dt.Rows[0]["mnc_lb_pri01"].ToString(); } else { setLabM01(labM01); } return(labM01); }
private void initConfig() { labM01 = new LabM01(); labM01.MNC_LB_CD = "MNC_LB_CD"; labM01.MNC_LB_DSC = "MNC_LB_DSC"; labM01.MNC_LB_TYP_CD = "MNC_LB_TYP_CD"; labM01.MNC_LB_GRP_CD = "MNC_LB_GRP_CD"; labM01.MNC_LB_DIS_STS = "MNC_LB_DIS_STS"; labM01.MNC_SCH_ACT = "MNC_SCH_ACT"; labM01.MNC_STAMP_DAT = "MNC_DOC_CD"; labM01.MNC_STAMP_TIM = "MNC_DOC_CD"; labM01.MNC_SPC_CD = "MNC_DOC_CD"; labM01.MNC_LB_STS = "MNC_DOC_CD"; labM01.MNC_USR_ADD = "MNC_DOC_CD"; labM01.MNC_USR_UPD = "MNC_DOC_CD"; labM01.MNC_LB_CTL_CD = "MNC_DOC_CD"; labM01.MNC_LB_OLD_CD = "MNC_DOC_CD"; labM01.MNC_DEC_CD = "MNC_DOC_CD"; labM01.MNC_DEC_NO = "MNC_DOC_CD"; labM01.MNC_LB_PRI = "MNC_DOC_CD"; labM01.mnc_res_flg = "MNC_DOC_CD"; labM01.MNC_HL7_CODE = "MNC_DOC_CD"; labM01.ucep_code = "ucep_code"; labM01.price = "mnc_lb_pri01"; }
public LabM01 setLabM01(LabM01 p) { p.MNC_LB_CD = ""; p.MNC_LB_DSC = ""; p.MNC_LB_TYP_CD = ""; p.MNC_LB_GRP_CD = ""; p.MNC_LB_DIS_STS = ""; p.MNC_SCH_ACT = ""; p.MNC_STAMP_DAT = ""; p.MNC_STAMP_TIM = ""; p.MNC_SPC_CD = ""; p.MNC_LB_STS = ""; p.MNC_USR_ADD = ""; p.MNC_USR_UPD = ""; p.MNC_LB_CTL_CD = ""; p.MNC_LB_OLD_CD = ""; p.MNC_DEC_CD = ""; p.MNC_DEC_NO = ""; p.MNC_LB_PRI = ""; p.mnc_res_flg = ""; p.MNC_HL7_CODE = ""; p.ucep_code = ""; p.price = "0"; return(p); }
public LabM01 SelectByPk(String labcode) { DataTable dt = new DataTable(); LabM01 labM01 = new LabM01(); String sql = "select lab_m01.*, lab_m02.mnc_lb_pri01 " + "From lab_m01 " + "Left join lab_m02 on lab_m01.mnc_lb_cd = lab_m02.mnc_lb_cd " + "Where lab_m01.mnc_lb_cd = '" + labcode + "' " + " "; dt = conn.selectData(sql); labM01 = setLabM01(dt); return(labM01); }