private void initConfig()
{
fmtp = new FMethodPayment();
fmtp.method_payment_id = "f_method_payment_id";
fmtp.method_payment_code = "f_method_payment_code";
fmtp.method_payment_name_e = "f_method_payment_name_e";
fmtp.method_payment_name_t = "f_method_payment_name_t";
fmtp.status_app = "status_app";
fmtp.sort1 = "sort1";
fmtp.active = "active";
fmtp.date_create = "date_create";
fmtp.date_modi = "date_modi";
fmtp.date_cancel = "date_cancel";
fmtp.user_create = "user_create";
fmtp.user_modi = "user_modi";
fmtp.user_cancel = "user_cancel";
//tmn.status_app = "status_app";
fmtp.remark = "remark";
fmtp.table = "f_method_payment";
fmtp.pkField = "f_method_payment_id";
lMtp = new List <FMethodPayment>();
//getlMtp();
}
public FMethodPayment selectByPk1(String copId)
{
FMethodPayment cop1 = new FMethodPayment();
DataTable dt = new DataTable();
String sql = "select mtp.* " +
"From " + fmtp.table + " mtp " +
//"Left Join t_ssdata_visit ssv On ssv.ssdata_visit_id = bd.ssdata_visit_id " +
"Where mtp." + fmtp.pkField + " ='" + copId + "' ";
dt = conn.selectData(conn.conn, sql);
cop1 = setExpn(dt);
return(cop1);
}
public void getlMtp()
{
//lDept = new List<Department>();
lMtp.Clear();
DataTable dt = new DataTable();
dt = selectAll();
foreach (DataRow row in dt.Rows)
{
FMethodPayment mtp1 = new FMethodPayment();
mtp1.method_payment_id = row[fmtp.method_payment_id].ToString();
mtp1.method_payment_code = row[fmtp.method_payment_code].ToString();
mtp1.method_payment_name_e = row[fmtp.method_payment_name_e].ToString();
mtp1.method_payment_name_t = row[fmtp.method_payment_name_t].ToString();
lMtp.Add(mtp1);
}
}
private FMethodPayment setExpn(DataTable dt)
{
FMethodPayment expn1 = new FMethodPayment();
if (dt.Rows.Count > 0)
{
expn1.method_payment_id = dt.Rows[0][fmtp.method_payment_id].ToString();
expn1.method_payment_code = dt.Rows[0][fmtp.method_payment_code].ToString();
expn1.method_payment_name_e = dt.Rows[0][fmtp.method_payment_name_e].ToString();
expn1.method_payment_name_t = dt.Rows[0][fmtp.method_payment_name_t].ToString();
expn1.active = dt.Rows[0][fmtp.active].ToString();
expn1.date_cancel = dt.Rows[0][fmtp.date_cancel].ToString();
expn1.date_create = dt.Rows[0][fmtp.date_create].ToString();
expn1.date_modi = dt.Rows[0][fmtp.date_modi].ToString();
expn1.user_cancel = dt.Rows[0][fmtp.user_cancel].ToString();
expn1.user_create = dt.Rows[0][fmtp.user_create].ToString();
expn1.user_modi = dt.Rows[0][fmtp.user_modi].ToString();
//pti1.status_app = dt.Rows[0][tmn.status_app].ToString();
expn1.remark = dt.Rows[0][fmtp.remark].ToString();
expn1.sort1 = dt.Rows[0][fmtp.sort1].ToString();
}
return(expn1);
}
