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);
}
