private void initConfig()
{
jobpx = new OldJobPx();
lJobPx = new List <OldJobPx>();
jobpx.VN = "VN";
jobpx.Status = "Status";
jobpx.Include_Pkg_Price = "Include_Pkg_Price";
jobpx.Extra_Pkg_Price = "Extra_Pkg_Price";
jobpx.Total_Price = "Total_Price";
jobpx.Date = "Date";
jobpx.PID = "PID";
jobpx.PIDS = "PIDS";
jobpx.table = "JobPx";
jobpx.pkField = "VN";
}
private void chkNull(OldJobPx p)
{
long chk = 0;
decimal chk1 = 0;
//p.Status = p.Status == null ? "" : p.Status;
//p.Include_Pkg_Price = p.Include_Pkg_Price == null ? "" : p.PID;
p.PIDS = p.PIDS == null ? "" : p.PIDS;
//p.VN = p.VN == null ? "0" : p.VN;
//p.Extra_Pkg_Price = p.Extra_Pkg_Price == null ? "" : p.Extra_Pkg_Price;
p.Date = p.Date == null ? "" : p.Date;
p.remark = p.remark == null ? "" : p.remark;
p.Status = long.TryParse(p.Status, out chk) ? chk.ToString() : "0";
p.PID = long.TryParse(p.PID, out chk) ? chk.ToString() : "0";
//p.Total_Price = long.TryParse(p.Total_Price, out chk) ? chk.ToString() : "0";
p.VN = long.TryParse(p.VN, out chk) ? chk.ToString() : "0";
p.Include_Pkg_Price = decimal.TryParse(p.Include_Pkg_Price, out chk1) ? chk.ToString() : "0";
p.Extra_Pkg_Price = decimal.TryParse(p.Extra_Pkg_Price, out chk1) ? chk.ToString() : "0";
p.Total_Price = decimal.TryParse(p.Total_Price, out chk1) ? chk.ToString() : "0";
}
public void getlStf()
{
//lDept = new List<Position>();
lJobPx.Clear();
DataTable dt = new DataTable();
dt = selectAll();
foreach (DataRow row in dt.Rows)
{
OldJobPx itm1 = new OldJobPx();
itm1.VN = row[jobpx.VN].ToString();
itm1.Status = row[jobpx.Status].ToString();
itm1.Include_Pkg_Price = row[jobpx.Include_Pkg_Price].ToString();
itm1.Extra_Pkg_Price = row[jobpx.Extra_Pkg_Price].ToString();
itm1.Total_Price = row[jobpx.Total_Price].ToString();
itm1.Date = row[jobpx.Date].ToString();
itm1.PID = row[jobpx.PID].ToString();
itm1.PIDS = row[jobpx.PIDS].ToString();
lJobPx.Add(itm1);
}
}
