private void initConfig() { //cf = new Config1(); //lw = new LogWriter(); //connBua = new ConnectDB("bangna"); //conn = new ConnectDB("mainhis"); labex = new LabEx(); labex.Active = "labex_active"; labex.Description = "description"; labex.Hn = "hn"; labex.Id = "labex_id"; labex.LabDate = "lab_date"; labex.LabExDate = "labex_date"; labex.PatientName = "patient_name"; labex.Remark = "remark"; labex.RowNumber = "row_number"; labex.VisitDate = "visit_date"; labex.VisitTime = "visit_time"; labex.Vn = "vn"; labex.YearId = "year_id"; labex.DoctorId = "doctor_id"; labex.LabTime = "lab_time"; labex.ReqNo = "req_no"; labex.DoctorName = "doctor_name"; labex.table = "labex"; labex.pkField = "labex_id"; }
public LabEx selectByPk(String Id) { LabEx item = new LabEx(); String sql = ""; DataTable dt = new DataTable(); sql = "Select * From " + labex.table + " Where " + labex.pkField + "='" + Id + "'"; //lw.WriteLog("LabExDB.selectByPk sql " + sql); //lw.WriteLog("LabExDB.selectByPk connBua.hostNameBua " + connBua.hostNameBua + " connBua.databaseNameBua " + connBua.databaseNameBua); //MessageBox.Show("111111 connBua.databaseNameBua " + connBua.databaseNameBua, "1111111"); //if (connBua.hostNameBua.Equals("")) //{ // lw.WriteLog("LabExDB.selectByPk connBua.hostNameBua if (connBua.hostNameBua.Equals" ); // IniFile iniFile = new IniFile("reportbangna.ini"); // connBua.databaseNameBua = iniFile.Read("database_name_bua"); // connBua.hostNameBua = iniFile.Read("host_name_bua"); // connBua.userNameBua = iniFile.Read("user_name_bua"); // connBua.passwordBua = iniFile.Read("password_bua"); // //MessageBox.Show("connBua.databaseNameBua " + connBua.databaseNameBua, ""); // //MessageBox.Show("connBua.hostNameBua " + connBua.hostNameBua, ""); // //MessageBox.Show("connBua.hostNameMainHIS " + connBua.hostNameMainHIS, ""); // //MessageBox.Show("connBua.hostNameMainHIS " + , ""); //} dt = conn.selectData(sql); if (dt.Rows.Count > 0) { item = setData(item, dt); } //lw.WriteLog("LabExDB.selectByPk End connBua.connMainHIS.State " + connBua.connMainHIS.State); return(item); }
public String update(LabEx 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 " + labex.table + " Set " + labex.Description + "='" + p.Description + "'," + labex.Hn + "='" + p.Hn + "'," + labex.LabDate + "='" + p.LabDate + "'," + labex.LabExDate + "='" + p.LabExDate + "'," + labex.PatientName + "='" + p.PatientName + "'," + labex.Remark + "='" + p.Remark + "'," + labex.RowNumber + "='" + p.RowNumber + "'," + labex.VisitDate + "='" + p.VisitDate + "'," + labex.VisitTime + "='" + p.VisitTime + "'," + labex.Vn + "='" + p.Vn + "'," + labex.YearId + "='" + p.YearId + "', " + labex.DoctorId + "='" + p.DoctorId + "', " + labex.LabTime + "='" + p.LabTime + "', " + labex.ReqNo + "='" + p.ReqNo + "', " + labex.DoctorName + "='" + p.DoctorName + "' " + "Where " + labex.pkField + "='" + p.Id + "'"; chk = conn.ExecuteNonQuery(sql); chk = p.RowNumber; } catch (Exception ex) { MessageBox.Show("Error " + ex.ToString(), "update LabEx"); } return(chk); }
private void initConfig() { fEdit = new Font(bc.iniC.grdViewFontName, bc.grdViewFontSize, FontStyle.Regular); fEditB = new Font(bc.iniC.grdViewFontName, bc.grdViewFontSize, FontStyle.Bold); le = new LabEx(); txtYearId.Value = DateTime.Now.Year.ToString(); btnHn.Click += BtnHn_Click; btnOpen1.Click += BtnOpen1_Click; btnOpen2.Click += BtnOpen2_Click; btnOpen3.Click += BtnOpen3_Click; btnOpen4.Click += BtnOpen4_Click; btnOpen5.Click += BtnOpen5_Click; btnOpen6.Click += BtnOpen6_Click; btnSave1.Click += BtnSave1_Click; btnSave2.Click += BtnSave2_Click; btnSave3.Click += BtnSave3_Click; btnSave4.Click += BtnSave4_Click; btnSave5.Click += BtnSave5_Click; btnSave6.Click += BtnSave6_Click; lbName1.DoubleClick += LbName1_DoubleClick; lbName2.DoubleClick += LbName2_DoubleClick; lbName3.DoubleClick += LbName3_DoubleClick; lbName4.DoubleClick += LbName4_DoubleClick; lbName5.DoubleClick += LbName5_DoubleClick; lbName6.DoubleClick += LbName6_DoubleClick; }
public String insertLabEx(LabEx p) { //LabEx item = new LabEx(); String chk = ""; //item = selectByPk(p.Id); if (p.Id == "") { chk = insert(p); } else { chk = update(p); } return(chk); }
private LabEx setData(LabEx p, DataTable dt) { p.Active = dt.Rows[0][labex.Active].ToString(); p.Description = dt.Rows[0][labex.Description].ToString(); p.Hn = dt.Rows[0][labex.Hn].ToString(); p.Id = dt.Rows[0][labex.Id].ToString(); p.LabDate = dt.Rows[0][labex.LabDate].ToString(); p.LabExDate = dt.Rows[0][labex.LabExDate].ToString(); p.PatientName = dt.Rows[0][labex.PatientName].ToString(); p.Remark = dt.Rows[0][labex.Remark].ToString(); p.RowNumber = dt.Rows[0][labex.RowNumber].ToString(); p.VisitDate = dt.Rows[0][labex.VisitDate].ToString(); p.VisitTime = dt.Rows[0][labex.VisitTime].ToString(); p.Vn = dt.Rows[0][labex.Vn].ToString(); p.YearId = dt.Rows[0][labex.YearId].ToString(); p.DoctorId = dt.Rows[0][labex.DoctorId].ToString(); p.LabTime = dt.Rows[0][labex.LabTime].ToString(); p.ReqNo = dt.Rows[0][labex.ReqNo].ToString(); p.DoctorName = dt.Rows[0][labex.DoctorName].ToString(); return(p); }
private String insert(LabEx p) { String sql = "", chk = ""; try { if (p.Id == "") { p.Id = p.getGenID(); } //p.monthId = "RIGHT('00' + CAST(month(GETDATE()) AS NVARCHAR), 2)"; //p.yearId = "CAST(year(GETDATE()) AS NVARCHAR)"; //p.dateCreate = " CAST(year(GETDATE()) AS NVARCHAR)+'-'+ RIGHT('00' + CAST(month(GETDATE()) AS NVARCHAR), 2)+'-'+ RIGHT('00' + CAST(day(GETDATE()) AS NVARCHAR), 2)" // + "' '+ RIGHT('00' + CAST(hour(GETDATE()) AS NVARCHAR), 2)+':'+ RIGHT('00' + CAST(minute(GETDATE()) AS NVARCHAR), 2)+':'+ RIGHT('00' + CAST(second(GETDATE()) AS NVARCHAR), 2)"; p.RowNumber = selectMaxRowNumber(p.YearId); p.Active = "1"; sql = "Insert Into " + labex.table + "(" + labex.pkField + "," + labex.Active + "," + labex.Description + "," + labex.Hn + "," + labex.LabDate + "," + labex.LabExDate + "," + labex.PatientName + "," + labex.Remark + "," + labex.RowNumber + "," + labex.VisitDate + "," + labex.VisitTime + "," + labex.Vn + "," + labex.YearId + "," + labex.DoctorId + "," + labex.LabTime + "," + labex.ReqNo + "," + labex.DoctorName + ") " + "Values('" + p.Id + "','" + p.Active + "','" + p.Description + "','" + p.Hn + "','" + p.LabDate + "','" + p.LabExDate + "','" + p.PatientName + "','" + p.Remark + "','" + p.RowNumber + "','" + p.VisitDate + "','" + p.VisitTime + "','" + p.Vn + "','" + p.YearId + "','" + p.DoctorId + "','" + p.LabTime + "','" + p.ReqNo + "','" + p.DoctorName + "') "; chk = conn.ExecuteNonQuery(sql); //chk = p.RowNumber; chk = p.Id; } catch (Exception ex) { MessageBox.Show("Error " + ex.ToString(), "insert LabEx"); } return(chk); }