public String insert(XrayT04 p) { String sql = "", chk = ""; try { chkNull(p); sql = "Insert Into " + xrt04.table + "(" + xrt04.MNC_REQ_YR + "," + xrt04.MNC_REQ_NO + "," + xrt04.MNC_REQ_DAT + "," + xrt04.MNC_XR_CD + "," + xrt04.MNC_STS + "," + xrt04.MNC_XR_TYP + "," + xrt04.MNC_GRP_NO + "," + xrt04.MNC_XR_DSC + "," + xrt04.MNC_RES + "," + xrt04.MNC_XR_USR + "," + xrt04.MNC_DOT_DF_CD + "," + xrt04.MNC_DOT_GRP_CD + "," + xrt04.MNC_STAMP_DAT + "," + xrt04.MNC_STAMP_TIM + "" + ") " + "Values('" + p.MNC_REQ_YR + "','" + p.MNC_REQ_NO + "','" + p.MNC_REQ_DAT + "','" + p.MNC_XR_CD + "','" + p.MNC_STS + "','" + p.MNC_XR_TYP + "','" + p.MNC_GRP_NO + "','" + p.MNC_XR_DSC.Replace("'", "''") + "','" + p.MNC_RES.Replace("'", "''") + "','" + p.MNC_XR_USR + "','" + p.MNC_DOT_DF_CD + "','0'," + "convert(VARCHAR(20),getdate(),20),'0'" + ") "; chk = conn.ExecuteNonQuery(conn.connMainHIS, sql); } catch (Exception ex) { chk = ex.Message + " " + ex.InnerException; new LogWriter("e", "insert Insert sql " + sql + " ex " + chk); } return(chk); }
private void chkNull(XrayT04 p) { long chk = 0; int 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.MNC_REQ_YR = p.MNC_REQ_YR == null ? "" : p.MNC_REQ_YR; p.MNC_REQ_DAT = p.MNC_REQ_DAT == null ? "" : p.MNC_REQ_DAT; p.MNC_XR_CD = p.MNC_XR_CD == null ? "" : p.MNC_XR_CD; p.MNC_STS = p.MNC_STS == null ? "" : p.MNC_STS; p.MNC_XR_TYP = p.MNC_XR_TYP == null ? "" : p.MNC_XR_TYP; p.MNC_GRP_NO = p.MNC_GRP_NO == null ? "" : p.MNC_GRP_NO; p.MNC_XR_DSC = p.MNC_XR_DSC == null ? "" : p.MNC_XR_DSC; p.MNC_XR_USR = p.MNC_XR_USR == null ? "" : p.MNC_XR_USR; p.MNC_RES = p.MNC_RES == null ? "" : p.MNC_RES; p.MNC_XR_USR = p.MNC_XR_USR == null ? "" : p.MNC_XR_USR; p.MNC_DOT_DF_CD = p.MNC_DOT_DF_CD == null ? "" : p.MNC_DOT_DF_CD; p.MNC_DOT_GRP_CD = p.MNC_DOT_GRP_CD == null ? "" : p.MNC_DOT_GRP_CD; p.MNC_STAMP_DAT = p.MNC_STAMP_DAT == null ? "" : p.MNC_STAMP_DAT; //p.MNC_STAMP_TIM = p.MNC_STAMP_TIM == null ? "" : p.MNC_STAMP_TIM; p.MNC_XR_DSC1 = p.MNC_XR_DSC1 == null ? "" : p.MNC_XR_DSC1; p.MNC_REQ_NO = long.TryParse(p.MNC_REQ_NO, out chk) ? chk.ToString() : "0"; p.MNC_STAMP_TIM = long.TryParse(p.MNC_STAMP_TIM, out chk) ? chk.ToString() : "0"; p.MNC_GRP_NO = long.TryParse(p.MNC_GRP_NO, out chk) ? chk.ToString() : "0"; }
public String update(XrayT04 p) { String sql = "", chk = ""; try { //p.dateModi = " CAST(year(GETDATE()) AS NVARCHAR)+'-'+ RIGHT('00' + CAST(month(GETDATE()) AS NVARCHAR), 2)+'-'+ RIGHT('00' + CAST(day(GETDATE()) AS NVARCHAR), 2)"; sql = "Update " + xrt04.table + " Set " + xrt04.MNC_XR_DSC + "= '" + p.MNC_XR_DSC + "'," + xrt04.MNC_STAMP_DAT + "= convert(VARCHAR(20),getdate(),20)," + "Where " + xrt04.MNC_REQ_YR + "='" + p.MNC_REQ_YR + "' and " + xrt04.MNC_REQ_NO + "='" + p.MNC_REQ_NO + "' and " + xrt04.MNC_REQ_DAT + "='" + p.MNC_REQ_DAT + "' and " + xrt04.MNC_XR_CD + "='" + p.MNC_XR_CD + "' "; chk = conn.ExecuteNonQuery(conn.connMainHIS, sql); } catch (Exception ex) { //MessageBox.Show("Error " + ex.ToString(), "update LabEx"); } return(chk); }
private void initConfig() { xrt04 = new XrayT04(); xrt04.MNC_REQ_YR = "MNC_REQ_YR"; xrt04.MNC_REQ_NO = "MNC_REQ_NO"; xrt04.MNC_REQ_DAT = "MNC_REQ_DAT"; xrt04.MNC_XR_CD = "MNC_XR_CD"; xrt04.MNC_STS = "MNC_STS"; xrt04.MNC_XR_TYP = "MNC_XR_TYP"; xrt04.MNC_GRP_NO = "MNC_GRP_NO"; xrt04.MNC_XR_DSC = "MNC_XR_DSC"; xrt04.MNC_RES = "MNC_RES"; xrt04.MNC_XR_USR = "******"; xrt04.MNC_DOT_DF_CD = "MNC_DOT_DF_CD"; xrt04.MNC_DOT_GRP_CD = "MNC_DOT_GRP_CD"; xrt04.MNC_STAMP_DAT = "MNC_STAMP_DAT"; xrt04.MNC_STAMP_TIM = "MNC_STAMP_TIM"; xrt04.MNC_XR_DSC1 = "MNC_XR_DSC1"; xrt04.table = "XRAY_T04"; xrt04.pkField = "MNC_REQ_YR,MNC_REQ_NO,MNC_REQ_DAT,MNC_XR_CD"; }