private void initConfig()
{
ssdV = new TSsdataVisit();
ssdV.birth_day = "birth_day";
ssdV.branch_id = "branch_id";
ssdV.hcode = "hcode";
ssdV.hcode_owner = "hcode_owner";
ssdV.hn_no = "hn_no";
ssdV.hn_yr = "hn_yr";
ssdV.pid = "pid";
ssdV.patient_fname = "patient_fname";
ssdV.patient_lname = "patient_lname";
ssdV.prefix = "prefix";
ssdV.pre_no = "pre_no";
ssdV.sex = "sex";
ssdV.ssdata_id = "ssdata_id";
ssdV.ssdata_visit_id = "ssdata_visit_id";
ssdV.visit_date = "visit_date";
ssdV.visit_time = "visit_time";
ssdV.vn = "vn";
ssdV.vn_no = "vn_no";
ssdV.vn_seq = "vn_seq";
ssdV.vn_sum = "vn_sum";
ssdV.active = "active";
ssdV.year_id = "year_id";
ssdV.month_id = "month_id";
ssdV.invno = "invno";
ssdV.billno = "billno";
ssdV.amount = "amount";
ssdV.paid = "paid";
ssdV.payplan = "payplan";
ssdV.claimamt = "claimamt";
ssdV.otherpayplan = "otherpayplan";
ssdV.otherpay = "otherpay";
ssdV.prescdt = "prescdt";
ssdV.dispdt = "dispdt";
ssdV.itemcnt = "itemcnt";
ssdV.prescb = "prescb";
ssdV.svid = "svid";
ssdV.ssdata_split_id = "ssdata_split_id";
ssdV.table = "t_ssdata_visit";
ssdV.pkField = "ssdata_visit_id";
}
public String insert(TSsdataVisit p)
{
String re = "";
String sql = "";
p.active = "1";
sql = "Insert Into " + ssdV.table + "(" + ssdV.active + "," + ssdV.birth_day + "," + ssdV.branch_id + "," +
ssdV.hcode + "," + ssdV.hcode_owner + "," + ssdV.hn_no + "," +
ssdV.hn_yr + "," + ssdV.pid + "," + ssdV.patient_fname + "," +
ssdV.patient_lname + "," + ssdV.prefix + "," + ssdV.pre_no + "," +
ssdV.sex + "," + ssdV.ssdata_id + "," + ssdV.visit_date + "," +
ssdV.visit_time + "," + ssdV.vn + "," + ssdV.vn_no + "," +
ssdV.vn_seq + "," + ssdV.vn_sum + "," + ssdV.year_id + "," +
ssdV.month_id + "," + ssdV.invno + "," + ssdV.billno + "," +
ssdV.amount + "," + ssdV.paid + "," + ssdV.payplan + "," +
ssdV.claimamt + "," + ssdV.otherpayplan + "," + ssdV.otherpay + "," +
ssdV.prescdt + "," + ssdV.dispdt + "," + ssdV.itemcnt + "," +
ssdV.prescb + "," + ssdV.svid + "," + ssdV.ssdata_split_id +
") " +
"Values('" + p.active + "','" + p.birth_day + "','" + p.branch_id + "','" +
p.hcode + "','" + p.hcode_owner + "','" + p.hn_no + "','" +
p.hn_yr + "','" + p.pid + "','" + p.patient_fname + "','" +
p.patient_lname + "','" + p.prefix + "','" + p.pre_no + "','" +
p.sex + "','" + p.ssdata_id + "','" + p.visit_date + "','" +
p.visit_time + "','" + p.vn + "','" + p.vn_no + "','" +
p.vn_seq + "','" + p.vn_sum + "','" + p.year_id + "','" +
p.month_id + "','" + p.invno + "','" + p.billno + "','" +
p.amount + "','" + p.paid + "','" + p.payplan + "','" +
p.claimamt + "','" + p.otherpayplan + "','" + p.otherpay + "','" +
p.prescdt + "','" + p.dispdt + "','" + p.itemcnt + "','" +
p.prescb + "','" + p.svid + "','" + p.ssdata_split_id +
"') ";
re = conn.ExecuteNonQueryNoClose(conn.connSSDataNoClose, sql);
return(re);
}
