public DataTable selectByPk1(String id)
{
AccCreditBank cop1 = new AccCreditBank();
DataTable dt = new DataTable();
String sql = "select * " +
"From " + act.table + " act " +
//"Left Join f_patient_prefix pfx On stf.prefix_id = pfx.f_patient_prefix_id " +
"Where dsc." + act.pkField + " ='" + id + "' " +
"Order By credit_bank_id ";
dt = conn.selectData(conn.conn, sql);
return(dt);
}
public AccCreditBank setAccCashTransfer(AccCreditBank dgs1)
{
dgs1.credit_bank_id = "";
dgs1.credit_bank_name = "";
dgs1.charge = "";
dgs1.active = "";
dgs1.remark = "";
dgs1.date_create = "";
dgs1.date_modi = "";
dgs1.date_cancel = "";
dgs1.user_create = "";
dgs1.user_modi = "";
dgs1.user_cancel = "";
return(dgs1);
}
public void getlActCashTransfer()
{
//lDept = new List<Position>();
lFpf.Clear();
DataTable dt = new DataTable();
dt = selectAll();
foreach (DataRow row in dt.Rows)
{
AccCreditBank itm1 = new AccCreditBank();
itm1.credit_bank_id = row[act.credit_bank_id].ToString();
itm1.credit_bank_name = row[act.credit_bank_name].ToString();
itm1.charge = row[act.charge].ToString();
lFpf.Add(itm1);
}
}
private void initConfig()
{
lFpf = new List <AccCreditBank>();
act = new AccCreditBank();
act.credit_bank_id = "credit_bank_id";
act.credit_bank_name = "credit_bank_name";
act.charge = "charge";
act.active = "active";
act.remark = "remark";
act.date_create = "date_create";
act.date_modi = "date_modi";
act.date_cancel = "date_cancel";
act.user_create = "user_create";
act.user_modi = "user_modi";
act.user_cancel = "user_cancel";
act.table = "b_acc_credit_bank";
act.pkField = "credit_bank_id";
}
public AccCreditBank setAccCashTransfer(DataTable dt)
{
AccCreditBank dgs1 = new AccCreditBank();
if (dt.Rows.Count > 0)
{
dgs1.credit_bank_id = dt.Rows[0][act.credit_bank_id].ToString();
dgs1.credit_bank_name = dt.Rows[0][act.credit_bank_name].ToString();
dgs1.charge = dt.Rows[0][act.charge].ToString();
dgs1.active = dt.Rows[0][act.active].ToString();
dgs1.remark = dt.Rows[0][act.remark].ToString();
dgs1.date_create = dt.Rows[0][act.date_create].ToString();
dgs1.date_modi = dt.Rows[0][act.date_modi].ToString();
dgs1.date_cancel = dt.Rows[0][act.date_cancel].ToString();
dgs1.user_create = dt.Rows[0][act.user_create].ToString();
dgs1.user_modi = dt.Rows[0][act.user_modi].ToString();
dgs1.user_cancel = dt.Rows[0][act.user_cancel].ToString();
}
else
{
setAccCashTransfer(dgs1);
}
return(dgs1);
}
