private void initConfig()
{
opdc = new OPDCheckUP();
btnPrintLicenseDriver.Click += BtnPrintLicenseDriver_Click;
txtHn.KeyUp += TxtHn_KeyUp;
txtDoctorId.KeyUp += TxtDoctorId_KeyUp;
chk1.CheckedChanged += Chk1_CheckedChanged;
chk2.CheckedChanged += Chk2_CheckedChanged;
chk3.CheckedChanged += Chk3_CheckedChanged;
chk4.CheckedChanged += Chk4_CheckedChanged;
setControl("");
}
public OPDCheckUP selectByHn(String hn)
{
OPDCheckUP item = new OPDCheckUP();
String sql = "";
DataTable dt = new DataTable();
sql = "Select * From " + opdc.table + " Where " + opdc.HN + "='" + hn + "' and " + opdc.Active + "='1'";
dt = conn.selectData(sql);
if (dt.Rows.Count > 0)
{
item = setData(item, dt);
}
return(item);
}
public OPDCheckUP selectByPk(String id)
{
OPDCheckUP item = new OPDCheckUP();
String sql = "";
DataTable dt = new DataTable();
sql = "Select * From " + opdc.table + " Where " + opdc.pkField + "='" + id + "'";
dt = conn.selectData(sql);
if (dt.Rows.Count > 0)
{
item = setData(item, dt);
}
return(item);
}
public String insertOPDCheckUP(OPDCheckUP p)
{
OPDCheckUP item = new OPDCheckUP();
String chk = "";
item = selectByPk(p.Id);
if (item.Id == "")
{
chk = insert(p);
}
else
{
chk = update(p);
}
return(chk);
}
private void setControl(String hn)
{
if (hn.Equals(""))
{
return;
}
opdc = bc.bcDB.opdcDB.selectByHn(hn);
if (!opdc.Id.Equals(""))
{
txtABOGroup.Text = opdc.ABOGroup;
txtAddr1.Text = opdc.Addr1;
txtAddr2.Text = opdc.Addr2;
txtAge.Text = opdc.Age;
//txtAllergisOther.Text = opdc.AllergicOther;
txtBloodPressure.Text = opdc.BloodPressure;
txtBreath.Text = opdc.Breath;
txtHeight.Text = opdc.Height;
//txtHisOther.Text = opdc.HistOther;
txtHn.Text = opdc.HN;
//txtOROther.Text = opdcOROther;
txtPatientName.Text = opdc.Name;
txtPhone.Text = opdc.Phone;
txtPulse.Text = opdc.Pulse;
//txtResult.Text = opdc.Result;
txtRhgroup.Text = opdc.RhGroup;
txtSex.Text = opdc.Sex;
//txtSgotN.Text = opdc.SgotN;
//txtSgotResult.Text = opdc.SgotResult;
//txtSgotSuggest.Text = opdc.SgotSuggest;
//txtSgotV.Text = opdc.SgotV;
//txtSgptN.Text = opdc.SgptN;
//txtSgptV.Text = opdc.SgptV;
//txtSuggest.Text = opdc.Suggest;
txtTempu.Text = opdc.Tempu;
txtWeight.Text = opdc.Weight;
}
else
{
String date = "";
date = System.DateTime.Today.Year + "-" + System.DateTime.Today.ToString("MM-dd");
System.Data.DataTable dt = bc.bcDB.vsDB.selectVisitByHn2(hn, date);
//DataTable dtor = bc.selectOPDViewOR(hn);
if (dt.Rows.Count <= 0)
{
clearControl();
return;
}
txtABOGroup.Text = dt.Rows[0]["mnc_blo_grp"].ToString();
txtAddr1.Text = dt.Rows[0]["mnc_full_add"].ToString() != "" ? dt.Rows[0]["mnc_full_add"].ToString() : dt.Rows[0]["mnc_dom_add"].ToString() + " " + dt.Rows[0]["mnc_tum_dsc"].ToString() + " " + dt.Rows[0]["mnc_amp_dsc"].ToString() + " " + dt.Rows[0]["mnc_chw_dsc"].ToString() + " " + dt.Rows[0]["mnc_cur_poc"].ToString();
txtAddr2.Text = "";
txtAge.Text = dt.Rows[0]["MNC_AGE"].ToString();
//txtAllergisOther.Text = dt.Rows[0][bc.opdcdb.opdc.AllergicOther].ToString();
//txtBloodPressure.Text = dt.Rows[0][bc.opdcdb.opdc.BloodPressure].ToString();
txtBreath.Text = dt.Rows[0]["mnc_breath"].ToString();
txtPulse.Text = dt.Rows[0]["mnc_ratios"].ToString();
txtHeight.Text = dt.Rows[0]["mnc_high"].ToString();
//txtHisOther.Text = dt.Rows[0][bc.opdcdb.opdc.HistOther].ToString();
txtHn.Text = dt.Rows[0]["MNC_HN_NO"].ToString();
//txtOROther.Text = dt.Rows[0]["MNC_HN_NO"].ToString();
txtPatientName.Text = dt.Rows[0]["prefix"].ToString() + " " + dt.Rows[0]["MNC_FNAME_T"].ToString() + " " + dt.Rows[0]["MNC_LNAME_T"].ToString();
txtPhone.Text = dt.Rows[0]["mnc_cur_tel"].ToString();
txtBloodPressure.Text = dt.Rows[0]["mnc_bp1_l"].ToString();
//txtResult.Text = dt.Rows[0][bc.opdcdb.opdc.Result].ToString();
txtRhgroup.Text = dt.Rows[0]["mnc_blo_rh"].ToString();
txtSex.Text = dt.Rows[0]["mnc_sex"].ToString();
//txtSuggest.Text = dt.Rows[0][bc.opdcdb.opdc.Suggest].ToString();
txtTempu.Text = dt.Rows[0]["mnc_temp"].ToString();
txtWeight.Text = dt.Rows[0]["mnc_weight"].ToString();
txtVn.Text = dt.Rows[0]["MNC_VN_NO"].ToString() + "." + dt.Rows[0]["MNC_VN_SEQ"].ToString() + "." + dt.Rows[0]["MNC_VN_SUM"].ToString();
}
}
private void initConfig()
{
opdc = new OPDCheckUP();
setControl("");
}
public String update(OPDCheckUP 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 " + opdc.table + " Set " +// opdc.AddrE + "='" + p.AddrE + "'," +
opdc.Addr1 + "='" + p.Addr1 + "'," +
opdc.Addr2 + "='" + p.Addr2 + "'," +
opdc.Sex + "='" + p.Sex + "'," +
opdc.Age + "='" + p.Age + "'," +
opdc.AllergicOther + "='" + p.AllergicOther + "'," +
opdc.AllergicStatus + "='" + p.AllergicStatus + "'," +
opdc.BloodPressure + "='" + p.BloodPressure + "'," +
opdc.Breath + "='" + p.Breath + "'," +
opdc.CBCAtrLyN + "='" + p.CBCAtrLyN + "'," +
opdc.CBCAtrLyR + "='" + p.CBCAtrLyR + "'," +
opdc.CBCAtrLyV + "='" + p.CBCAtrLyV + "'," +
opdc.CBCBasN + "='" + p.CBCBasN + "'," +
opdc.CBCBasR + "='" + p.CBCBasR + "'," +
opdc.CBCBasV + "='" + p.CBCBasV + "'," +
opdc.CBCEosN + "='" + p.CBCEosN + "'," +
opdc.CBCEosR + "='" + p.CBCEosR + "'," +
opdc.CBCEosV + "='" + p.CBCEosV + "'," +
opdc.CBCHbN + "='" + p.CBCHbN + "'," +
opdc.CBCHbR + "='" + p.CBCHbR + "'," +
opdc.CBCHbV + "='" + p.CBCHbV + "'," +
opdc.CBCHctN + "='" + p.CBCHctN + "'," +
opdc.CBCHctR + "='" + p.CBCHctR + "'," +
opdc.CBCHctV + "='" + p.CBCHctV + "'," +
opdc.CBCLyN + "='" + p.CBCLyN + "'," +
opdc.CBCLyR + "='" + p.CBCLyR + "'," +
opdc.CBCLyV + "='" + p.CBCLyV + "'," +
opdc.CBCMchcN + "='" + p.CBCMchcN + "'," +
opdc.CBCMchcR + "='" + p.CBCMchcR + "'," +
opdc.CBCMchcV + "='" + p.CBCMchcV + "'," +
opdc.CBCMchN + "='" + p.CBCMchN + "'," +
opdc.CBCMchR + "='" + p.CBCMchR + "'," +
opdc.CBCMchV + "='" + p.CBCMchV + "'," +
opdc.CBCMcvN + "='" + p.CBCMcvN + "'," +
opdc.CBCMcvR + "='" + p.CBCMcvR + "'," +
opdc.CBCMcvV + "='" + p.CBCMcvV + "'," +
opdc.CBCMonoN + "='" + p.CBCMonoN + "'," +
opdc.CBCMonoR + "='" + p.CBCMonoR + "'," +
opdc.CBCMonoV + "='" + p.CBCMonoV + "'," +
opdc.CBCOtherCellN + "='" + p.CBCOtherCellN + "'," +
opdc.CBCOtherCellR + "='" + p.CBCOtherCellR + "'," +
opdc.CBCOtherCellV + "='" + p.CBCOtherCellV + "'," +
opdc.CBCPlaCntN + "='" + p.CBCPlaCntN + "'," +
opdc.CBCPlaCntR + "='" + p.CBCPlaCntR + "'," +
opdc.CBCPlaCntV + "='" + p.CBCPlaCntV + "'," +
opdc.CBCPLaSmeN + "='" + p.CBCPLaSmeN + "'," +
opdc.CBCPlaSmeR + "='" + p.CBCPlaSmeR + "'," +
opdc.CBCPlaSmeV + "='" + p.CBCPlaSmeV + "'," +
opdc.CBCPmnN + "='" + p.CBCPmnN + "'," +
opdc.CBCPmnR + "='" + p.CBCPmnR + "'," +
opdc.CBCPmnV + "='" + p.CBCPmnV + "'," +
opdc.CBCRBCCntN + "='" + p.CBCRBCCntN + "'," +
opdc.CBCRBCCntR + "='" + p.CBCRBCCntR + "'," +
opdc.CBCRBCCntV + "='" + p.CBCRBCCntV + "'," +
opdc.CBCRBCMorN + "='" + p.CBCRBCMorN + "'," +
opdc.CBCRBCMorR + "='" + p.CBCRBCMorR + "'," +
opdc.CBCRBCMorV + "='" + p.CBCRBCMorV + "'," +
opdc.CBCResult + "='" + p.CBCResult + "'," +
opdc.CBCSuggest + "='" + p.CBCSuggest + "'," +
opdc.CBCWBCCntN + "='" + p.CBCWBCCntN + "'," +
opdc.CBCWBCCntR + "='" + p.CBCWBCCntR + "'," +
opdc.CBCWBCCntV + "='" + p.CBCWBCCntV + "'," +
opdc.CheckDate + "='" + p.CheckDate + "'," +
opdc.CholN + "='" + p.CholN + "'," +
opdc.CholR + "='" + p.CholR + "'," +
opdc.CholResult + "='" + p.CholResult + "'," +
opdc.CholSuggest + "='" + p.CholSuggest + "'," +
opdc.CholV + "='" + p.CholV + "'," +
opdc.CreatiN + "='" + p.CreatiN + "'," +
opdc.CreatiR + "='" + p.CreatiR + "'," +
opdc.CreatiResult + "='" + p.CreatiResult + "'," +
opdc.CreatiSuggest + "='" + p.CreatiSuggest + "'," +
opdc.CreatiV + "='" + p.CreatiV + "'," +
opdc.FBSN + "='" + p.FBSN + "'," +
opdc.FBSR + "='" + p.FBSR + "'," +
opdc.FBSResult + "='" + p.FBSResult + "'," +
opdc.FBSSuggest + "='" + p.FBSSuggest + "'," +
opdc.FBSV + "='" + p.FBSV + "'," +
opdc.Height + "='" + p.Height + "'," +
opdc.HistOther + "='" + p.HistOther + "'," +
opdc.HistStatus + "='" + p.HistStatus + "'," +
opdc.HN + "='" + p.HN + "'," +
//opdc.Id + "='" + p.AddrE + "'," +
opdc.Name + "='" + p.Name + "'," +
opdc.OROther + "='" + p.OROther + "'," +
opdc.ORStatus + "='" + p.ORStatus + "'," +
opdc.Phone + "='" + p.Phone + "'," +
opdc.Pulse + "='" + p.Pulse + "'," +
opdc.RhGroup + "='" + p.RhGroup + "'," +
opdc.Sex + "='" + p.Sex + "'," +
opdc.SgotN + "='" + p.SgotN + "'," +
opdc.SgotR + "='" + p.SgotR + "'," +
opdc.SgotResult + "='" + p.SgotResult + "'," +
opdc.SgotSuggest + "='" + p.SgotSuggest + "'," +
opdc.SgotV + "='" + p.SgotV + "'," +
opdc.SgptN + "='" + p.SgptN + "'," +
opdc.SgptR + "='" + p.SgptR + "'," +
opdc.SgptV + "='" + p.SgptV + "'," +
opdc.Tempu + "='" + p.Tempu + "'," +
opdc.VN + "='" + p.VN + "'," +
opdc.PreNo + "='" + p.PreNo + "'," +
opdc.Weight + "='" + p.Weight + "' " +
"Where " + opdc.pkField + "='" + p.Id + "'";
chk = conn.ExecuteNonQuery(sql);
chk = p.Id;
}
catch (Exception ex)
{
MessageBox.Show("Error " + ex.ToString(), "update OPDCheckUP");
}
return(chk);
}
private String insert(OPDCheckUP 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 " + opdc.table + "(" + opdc.pkField + "," + opdc.ABOGroup + "," + opdc.Active + "," +
opdc.Addr1 + "," + opdc.Addr2 + "," + opdc.Sex + "," +
opdc.Age + "," + opdc.AllergicOther + "," + opdc.AllergicStatus + "," +
opdc.BloodPressure + "," + opdc.Breath + "," + opdc.CBCAtrLyN + "," +
opdc.CBCAtrLyR + "," + opdc.CBCAtrLyV + "," + opdc.CBCBasN + "," +
opdc.CBCBasR + "," + opdc.CBCBasV + "," + opdc.CBCEosN + "," +
opdc.CBCEosR + "," + opdc.CBCEosV + "," + opdc.CBCHbN + "," +
opdc.CBCHbR + "," + opdc.CBCHbV + "," + opdc.CBCHctN + "," +
opdc.CBCHctR + "," + opdc.CBCHctV + "," + opdc.CBCLyN + "," +
opdc.CBCLyR + "," + opdc.CBCLyV + "," + opdc.CBCMchcN + "," +
opdc.CBCMchcR + "," + opdc.CBCMchcV + "," + opdc.CBCMchN + "," +
opdc.CBCMchR + "," + opdc.CBCMchV + "," + opdc.CBCMcvN + "," +
opdc.CBCMcvR + "," + opdc.CBCMcvV + "," + opdc.CBCMonoN + "," +
opdc.CBCMonoR + "," + opdc.CBCMonoV + "," + opdc.CBCOtherCellN + "," +
opdc.CBCOtherCellR + "," + opdc.CBCOtherCellV + "," + opdc.CBCPlaCntN + "," +
opdc.CBCPlaCntR + "," + opdc.CBCPlaCntV + "," + opdc.CBCPLaSmeN + "," +
opdc.CBCPlaSmeR + "," + opdc.CBCPlaSmeV + "," + opdc.CBCPmnN + "," +
opdc.CBCPmnR + "," + opdc.CBCPmnV + "," + opdc.CBCRBCCntN + "," +
opdc.CBCRBCCntR + "," + opdc.CBCRBCCntV + "," + opdc.CBCRBCMorN + "," +
opdc.CBCRBCMorR + "," + opdc.CBCRBCMorV + "," + opdc.CBCResult + "," +
opdc.CBCSuggest + "," + opdc.CBCWBCCntN + "," + opdc.CBCWBCCntR + "," +
opdc.CBCWBCCntV + "," + opdc.CheckDate + "," + opdc.CholN + "," +
opdc.CholR + "," + opdc.CholResult + "," + opdc.CholSuggest + "," +
opdc.CholV + "," + opdc.CreatiN + "," + opdc.CreatiR + "," +
opdc.CreatiResult + "," + opdc.CreatiSuggest + "," + opdc.CreatiV + "," +
opdc.FBSN + "," + opdc.FBSR + "," + opdc.FBSResult + "," +
opdc.FBSSuggest + "," + opdc.FBSV + "," + opdc.Height + "," +
opdc.HistOther + "," + opdc.HistStatus + "," + opdc.HN + "," +
opdc.Name + "," + opdc.OROther + "," + opdc.ORStatus + "," +
opdc.Phone + "," + opdc.Pulse + "," + opdc.RhGroup + "," +
opdc.Sex + "," + opdc.SgotN + "," + opdc.SgotR + "," +
opdc.SgotResult + "," + opdc.SgotSuggest + "," + opdc.SgotV + "," +
opdc.SgptN + "," + opdc.SgptR + "," + opdc.SgptV + "," +
opdc.Tempu + "," + opdc.VN + "," + opdc.Weight +
opdc.Result + "," + opdc.Suggest + "," + opdc.PreNo + ") " +
"Values('" + p.Id + "','" + p.ABOGroup + "','" + p.Active + "','" +
p.Addr1 + "','" + p.Addr2 + "','" + p.Sex + "','" +
p.Age + "','" + p.AllergicOther + "','" + p.AllergicStatus + "','" +
p.BloodPressure + "','" + p.Breath + "','" + p.CBCAtrLyN + "','" +
p.CBCAtrLyR + "','" + p.CBCAtrLyV + "','" + p.CBCBasN + "','" +
p.CBCBasR + "','" + p.CBCBasV + "','" + p.CBCEosN + "','" +
p.CBCEosR + "','" + p.CBCEosV + "','" + p.CBCHbN + "','" +
p.CBCHbR + "','" + p.CBCHbV + "','" + p.CBCHctN + "','" +
p.CBCHctR + "','" + p.CBCHctV + "','" + p.CBCLyN + "','" +
p.CBCLyR + "','" + p.CBCLyV + "','" + p.CBCMchcN + "','" +
p.CBCMchcR + "','" + p.CBCMchcV + "','" + p.CBCMchN + "','" +
p.CBCMchR + "','" + p.CBCMchV + "','" + p.CBCMcvN + "','" +
p.CBCMcvR + "','" + p.CBCMcvV + "','" + p.CBCMonoN + "','" +
p.CBCMonoR + "','" + p.CBCMonoV + "','" + p.CBCOtherCellN + "','" +
p.CBCOtherCellR + "','" + p.CBCOtherCellV + "','" + p.CBCPlaCntN + "','" +
p.CBCPlaCntR + "','" + p.CBCPlaCntV + "','" + p.CBCPLaSmeN + "','" +
p.CBCPlaSmeR + "','" + p.CBCPlaSmeV + "','" + p.CBCPmnN + "','" +
p.CBCPmnR + "','" + p.CBCPmnV + "','" + p.CBCRBCCntN + "','" +
p.CBCRBCCntR + "','" + p.CBCRBCCntV + "','" + p.CBCRBCMorN + "','" +
p.CBCRBCMorR + "','" + p.CBCRBCMorV + "','" + p.CBCResult + "','" +
p.CBCSuggest + "','" + p.CBCWBCCntN + "','" + p.CBCWBCCntR + "','" +
p.CBCWBCCntV + "','" + p.CheckDate + "','" + p.CholN + "','" +
p.CholR + "','" + p.CholResult + "','" + p.CholSuggest + "','" +
p.CholV + "','" + p.CreatiN + "','" + p.CreatiR + "','" +
p.CreatiResult + "','" + p.CreatiSuggest + "','" + p.CreatiV + "','" +
p.FBSN + "','" + p.FBSR + "','" + p.FBSResult + "','" +
p.FBSSuggest + "','" + p.FBSV + "','" + p.Height + "','" +
p.HistOther + "','" + p.HistStatus + "','" + p.HN + "','" +
p.Name + "','" + p.OROther + "','" + p.ORStatus + "','" +
p.Phone + "','" + p.Pulse + "','" + p.RhGroup + "','" +
p.Sex + "','" + p.SgotN + "','" + p.SgotR + "','" +
p.SgotResult + "','" + p.SgotSuggest + "','" + p.SgotV + "','" +
p.SgptN + "','" + p.SgptR + "','" + p.SgptV + "','" +
p.Tempu + "','" + p.VN + "','" + p.Weight + "','" +
p.Result + "','" + p.Suggest + "','" + p.PreNo + "') ";
chk = conn.ExecuteNonQuery(sql);
//chk = p.RowNumber;
chk = p.Id;
}
catch (Exception ex)
{
MessageBox.Show("Error " + ex.ToString(), "insert OPDCheckUP");
}
return(chk);
}
private void initConfig()
{
//connMainHIS = new ConnectDB("mainhis");
opdc = new OPDCheckUP();
opdc.ABOGroup = "ab_group";
opdc.Active = "active";
opdc.Addr1 = "addr1";
opdc.Addr2 = "addr2";
opdc.Sex = "sex";
opdc.Age = "age";
opdc.AllergicOther = "AllergicOther";
opdc.AllergicStatus = "AllergicStatus";
opdc.BloodPressure = "bloodpressure";
opdc.Breath = "breath";
opdc.CBCAtrLyN = "CBCAtrLyN";
opdc.CBCAtrLyR = "CBCAtrLyR";
opdc.CBCAtrLyV = "CBCAtrLyV";
opdc.CBCBasN = "CBCBasN";
opdc.CBCBasR = "CBCBasR";
opdc.CBCBasV = "CBCBasV";
opdc.CBCEosN = "CBCEosN";
opdc.CBCEosR = "CBCEosR";
opdc.CBCEosV = "CBCEosV";
opdc.CBCHbN = "CBCHbN";
opdc.CBCHbR = "CBCHbR";
opdc.CBCHbV = "CBCHbV";
opdc.CBCHctN = "CBCHctN";
opdc.CBCHctR = "CBCHctR";
opdc.CBCHctV = "CBCHctV";
opdc.CBCLyN = "CBCLyN";
opdc.CBCLyR = "CBCLyR";
opdc.CBCLyV = "CBCLyV";
opdc.CBCMchcN = "CBCMchcN";
opdc.CBCMchcR = "CBCMchcR";
opdc.CBCMchcV = "CBCMchcV";
opdc.CBCMchN = "CBCMchN";
opdc.CBCMchR = "CBCMchR";
opdc.CBCMchV = "CBCMchV";
opdc.CBCMcvN = "CBCMcvN";
opdc.CBCMcvR = "CBCMcvR";
opdc.CBCMcvV = "CBCMcvV";
opdc.CBCMonoN = "CBCMonoN";
opdc.CBCMonoR = "CBCMonoR";
opdc.CBCMonoV = "CBCMonoV";
opdc.CBCOtherCellN = "CBCOtherCellN";
opdc.CBCOtherCellR = "CBCOtherCellR";
opdc.CBCOtherCellV = "CBCOtherCellV";
opdc.CBCPlaCntN = "CBCPlaCntN";
opdc.CBCPlaCntR = "CBCPlaCntR";
opdc.CBCPlaCntV = "CBCPlaCntV";
opdc.CBCPLaSmeN = "CBCPLaSmeN";
opdc.CBCPlaSmeR = "CBCPlaSmeR";
opdc.CBCPlaSmeV = "CBCPlaSmeV";
opdc.CBCPmnN = "CBCPmnN";
opdc.CBCPmnR = "CBCPmnR";
opdc.CBCPmnV = "CBCPmnV";
opdc.CBCRBCCntN = "CBCRBCCntN";
opdc.CBCRBCCntR = "CBCRBCCntR";
opdc.CBCRBCCntV = "CBCRBCCntV";
opdc.CBCRBCMorN = "CBCRBCMorN";
opdc.CBCRBCMorR = "CBCRBCMorR";
opdc.CBCRBCMorV = "CBCRBCMorV";
opdc.CBCResult = "CBCResult";
opdc.CBCSuggest = "CBCSuggest";
opdc.CBCWBCCntN = "CBCWBCCntN";
opdc.CBCWBCCntR = "CBCWBCCntR";
opdc.CBCWBCCntV = "CBCWBCCntV";
opdc.CheckDate = "checkup_date";
opdc.CholN = "CholN";
opdc.CholR = "CholR";
opdc.CholResult = "CholResult";
opdc.CholSuggest = "CholSuggest";
opdc.CholV = "CholV";
opdc.CreatiN = "CreatiN";
opdc.CreatiR = "CreatiR";
opdc.CreatiResult = "CreatiResult";
opdc.CreatiSuggest = "CreatiSuggest";
opdc.CreatiV = "CreatiV";
opdc.FBSN = "FBSN";
opdc.FBSR = "FBSR";
opdc.FBSResult = "FBSResult";
opdc.FBSSuggest = "FBSSuggest";
opdc.FBSV = "FBSV";
opdc.Height = "height";
opdc.HistOther = "HistOther";
opdc.HistStatus = "HistStatus";
opdc.HN = "hn";
opdc.Id = "opdcheckup_id";
opdc.Name = "name";
opdc.OROther = "OROther";
opdc.ORStatus = "ORStatus";
opdc.Phone = "phone";
opdc.Pulse = "pulse";
opdc.RhGroup = "rh_group";
opdc.Sex = "sex";
opdc.SgotN = "SgotN";
opdc.SgotR = "SgotR";
opdc.SgotResult = "SgotResult";
opdc.SgotSuggest = "SgotSuggest";
opdc.SgotV = "SgotV";
opdc.SgptN = "SgptN";
opdc.SgptR = "SgptR";
opdc.SgptV = "SgptV";
opdc.Tempu = "tempu";
opdc.VN = "vn";
opdc.Weight = "weight";
opdc.Result = "result";
opdc.Suggest = "suggest";
opdc.PreNo = "preno";
opdc.table = "opdcheckup";
opdc.pkField = "opdcheckup_id";
}
private OPDCheckUP setData(OPDCheckUP p, DataTable dt)
{
opdc.ABOGroup = dt.Rows[0][opdc.ABOGroup].ToString();
opdc.Active = dt.Rows[0][opdc.Active].ToString();
opdc.Addr1 = dt.Rows[0][opdc.Addr1].ToString();
opdc.Addr2 = dt.Rows[0][opdc.Addr2].ToString();
opdc.Sex = dt.Rows[0][opdc.Sex].ToString();
opdc.Age = dt.Rows[0][opdc.Age].ToString();
opdc.AllergicOther = dt.Rows[0][opdc.AllergicOther].ToString();
opdc.AllergicStatus = dt.Rows[0][opdc.AllergicStatus].ToString();
opdc.BloodPressure = dt.Rows[0][opdc.BloodPressure].ToString();
opdc.Breath = dt.Rows[0][opdc.Breath].ToString();
opdc.CBCAtrLyN = dt.Rows[0][opdc.CBCAtrLyN].ToString();
opdc.CBCAtrLyR = dt.Rows[0][opdc.CBCAtrLyR].ToString();
opdc.CBCAtrLyV = dt.Rows[0][opdc.CBCAtrLyV].ToString();
opdc.CBCBasN = dt.Rows[0][opdc.CBCBasN].ToString();
opdc.CBCBasR = dt.Rows[0][opdc.CBCBasR].ToString();
opdc.CBCBasV = dt.Rows[0][opdc.CBCBasV].ToString();
opdc.CBCEosN = dt.Rows[0][opdc.CBCEosN].ToString();
opdc.CBCEosR = dt.Rows[0][opdc.CBCEosR].ToString();
opdc.CBCEosV = dt.Rows[0][opdc.CBCEosV].ToString();
opdc.CBCHbN = dt.Rows[0][opdc.CBCHbN].ToString();
opdc.CBCHbR = dt.Rows[0][opdc.CBCHbR].ToString();
opdc.CBCHbV = dt.Rows[0][opdc.CBCHbV].ToString();
opdc.CBCHctN = dt.Rows[0][opdc.CBCHctN].ToString();
opdc.CBCHctR = dt.Rows[0][opdc.CBCHctR].ToString();
opdc.CBCHctV = dt.Rows[0][opdc.CBCHctV].ToString();
opdc.CBCLyN = dt.Rows[0][opdc.CBCLyN].ToString();
opdc.CBCLyR = dt.Rows[0][opdc.CBCLyR].ToString();
opdc.CBCLyV = dt.Rows[0][opdc.CBCLyV].ToString();
opdc.CBCMchcN = dt.Rows[0][opdc.CBCMchcN].ToString();
opdc.CBCMchcR = dt.Rows[0][opdc.CBCMchcR].ToString();
opdc.CBCMchcV = dt.Rows[0][opdc.CBCMchcV].ToString();
opdc.CBCMchN = dt.Rows[0][opdc.CBCMchN].ToString();
opdc.CBCMchR = dt.Rows[0][opdc.CBCMchR].ToString();
opdc.CBCMchV = dt.Rows[0][opdc.CBCMchV].ToString();
opdc.CBCMcvN = dt.Rows[0][opdc.CBCMcvN].ToString();
opdc.CBCMcvR = dt.Rows[0][opdc.CBCMcvR].ToString();
opdc.CBCMcvV = dt.Rows[0][opdc.CBCMcvV].ToString();
opdc.CBCMonoN = dt.Rows[0][opdc.CBCMonoN].ToString();
opdc.CBCMonoR = dt.Rows[0][opdc.CBCMonoR].ToString();
opdc.CBCMonoV = dt.Rows[0][opdc.CBCMonoV].ToString();
opdc.CBCOtherCellN = dt.Rows[0][opdc.CBCOtherCellN].ToString();
opdc.CBCOtherCellR = dt.Rows[0][opdc.CBCOtherCellR].ToString();
opdc.CBCOtherCellV = dt.Rows[0][opdc.CBCOtherCellV].ToString();
opdc.CBCPlaCntN = dt.Rows[0][opdc.CBCPlaCntN].ToString();
opdc.CBCPlaCntR = dt.Rows[0][opdc.CBCPlaCntR].ToString();
opdc.CBCPlaCntV = dt.Rows[0][opdc.CBCPlaCntV].ToString();
opdc.CBCPLaSmeN = dt.Rows[0][opdc.CBCPLaSmeN].ToString();
opdc.CBCPlaSmeR = dt.Rows[0][opdc.CBCPlaSmeR].ToString();
opdc.CBCPlaSmeV = dt.Rows[0][opdc.CBCPlaSmeV].ToString();
opdc.CBCPmnN = dt.Rows[0][opdc.CBCPmnN].ToString();
opdc.CBCPmnR = dt.Rows[0][opdc.CBCPmnR].ToString();
opdc.CBCPmnV = dt.Rows[0][opdc.CBCPmnV].ToString();
opdc.CBCRBCCntN = dt.Rows[0][opdc.CBCRBCCntN].ToString();
opdc.CBCRBCCntR = dt.Rows[0][opdc.CBCRBCCntR].ToString();
opdc.CBCRBCCntV = dt.Rows[0][opdc.CBCRBCCntV].ToString();
opdc.CBCRBCMorN = dt.Rows[0][opdc.CBCRBCMorN].ToString();
opdc.CBCRBCMorR = dt.Rows[0][opdc.CBCRBCMorR].ToString();
opdc.CBCRBCMorV = dt.Rows[0][opdc.CBCRBCMorV].ToString();
opdc.CBCResult = dt.Rows[0][opdc.CBCResult].ToString();
opdc.CBCSuggest = dt.Rows[0][opdc.CBCSuggest].ToString();
opdc.CBCWBCCntN = dt.Rows[0][opdc.CBCWBCCntN].ToString();
opdc.CBCWBCCntR = dt.Rows[0][opdc.CBCWBCCntR].ToString();
opdc.CBCWBCCntV = dt.Rows[0][opdc.CBCWBCCntV].ToString();
opdc.CheckDate = dt.Rows[0][opdc.CheckDate].ToString();
opdc.CholN = dt.Rows[0][opdc.CholN].ToString();
opdc.CholR = dt.Rows[0][opdc.CholR].ToString();
opdc.CholResult = dt.Rows[0][opdc.CholResult].ToString();
opdc.CholSuggest = dt.Rows[0][opdc.CholSuggest].ToString();
opdc.CholV = dt.Rows[0][opdc.CholV].ToString();
opdc.CreatiN = dt.Rows[0][opdc.CreatiN].ToString();
opdc.CreatiR = dt.Rows[0][opdc.CreatiR].ToString();
opdc.CreatiResult = dt.Rows[0][opdc.CreatiResult].ToString();
opdc.CreatiSuggest = dt.Rows[0][opdc.CreatiSuggest].ToString();
opdc.CreatiV = dt.Rows[0][opdc.CreatiV].ToString();
opdc.FBSN = dt.Rows[0][opdc.FBSN].ToString();
opdc.FBSR = dt.Rows[0][opdc.FBSR].ToString();
opdc.FBSResult = dt.Rows[0][opdc.FBSResult].ToString();
opdc.FBSSuggest = dt.Rows[0][opdc.FBSSuggest].ToString();
opdc.FBSV = dt.Rows[0][opdc.FBSV].ToString();
opdc.Height = dt.Rows[0][opdc.Height].ToString();
opdc.HistOther = dt.Rows[0][opdc.HistOther].ToString();
opdc.HistStatus = dt.Rows[0][opdc.HistStatus].ToString();
opdc.HN = dt.Rows[0][opdc.HN].ToString();
opdc.Id = dt.Rows[0][opdc.Id].ToString();
opdc.Name = dt.Rows[0][opdc.Name].ToString();
opdc.OROther = dt.Rows[0][opdc.OROther].ToString();
opdc.ORStatus = dt.Rows[0][opdc.ORStatus].ToString();
opdc.Phone = dt.Rows[0][opdc.Phone].ToString();
opdc.Pulse = dt.Rows[0][opdc.Pulse].ToString();
opdc.RhGroup = dt.Rows[0][opdc.RhGroup].ToString();
opdc.Sex = dt.Rows[0][opdc.Sex].ToString();
opdc.SgotN = dt.Rows[0][opdc.SgotN].ToString();
opdc.SgotR = dt.Rows[0][opdc.SgotR].ToString();
opdc.SgotResult = dt.Rows[0][opdc.SgotResult].ToString();
opdc.SgotSuggest = dt.Rows[0][opdc.SgotSuggest].ToString();
opdc.SgotV = dt.Rows[0][opdc.SgotV].ToString();
opdc.SgptN = dt.Rows[0][opdc.SgptN].ToString();
opdc.SgptR = dt.Rows[0][opdc.SgptR].ToString();
opdc.SgptV = dt.Rows[0][opdc.SgptV].ToString();
opdc.Tempu = dt.Rows[0][opdc.Tempu].ToString();
opdc.VN = dt.Rows[0][opdc.VN].ToString();
opdc.Weight = dt.Rows[0][opdc.Weight].ToString();
opdc.Result = dt.Rows[0][opdc.Result].ToString();
opdc.Suggest = dt.Rows[0][opdc.Suggest].ToString();
opdc.PreNo = dt.Rows[0][opdc.PreNo].ToString();
return(p);
}