public OldJobSpecial selectByPk1(String copId)
{
OldJobSpecial cop1 = new OldJobSpecial();
DataTable dt = new DataTable();
String sql = "select oJS.* " +
"From " + oJS.table + " oJS " +
"Where oJS." + oJS.pkField + " ='" + copId + "' ";
dt = conn.selectData(conn.conn, sql);
cop1 = setVisitOld(dt);
return(cop1);
}
private OldJobSpecial setVisitOld1(OldJobSpecial stf1)
{
stf1.VN = "";
stf1.Status = "";
stf1.Include_Pkg_Price = "";
stf1.Extra_Pkg_Price = "";
stf1.Total_Price = "";
stf1.Date = "";
stf1.PID = "";
stf1.PIDS = "";
stf1.status_req = "";
return(stf1);
}
private void initConfig()
{
oJS = new OldJobSpecial();
oJS.VN = "VN";
oJS.Status = "Status";
oJS.Include_Pkg_Price = "Include_Pkg_Price";
oJS.Extra_Pkg_Price = "Extra_Pkg_Price";
oJS.Total_Price = "Total_Price";
oJS.Date = "Date";
oJS.PID = "PID";
oJS.PIDS = "PIDS";
oJS.status_req = "status_req";
oJS.table = "JobSpecial";
oJS.pkField = "VN";
}
public OldJobSpecial setVisitOld(DataTable dt)
{
OldJobSpecial vsold1 = new OldJobSpecial();
if (dt.Rows.Count > 0)
{
vsold1.VN = dt.Rows[0][oJS.VN].ToString();
vsold1.Status = dt.Rows[0][oJS.Status].ToString();
vsold1.Include_Pkg_Price = dt.Rows[0][oJS.Include_Pkg_Price].ToString();
vsold1.Extra_Pkg_Price = dt.Rows[0][oJS.Extra_Pkg_Price].ToString();
vsold1.Total_Price = dt.Rows[0][oJS.Total_Price].ToString();
vsold1.Date = dt.Rows[0][oJS.Date].ToString();
vsold1.PID = dt.Rows[0][oJS.PID].ToString();
vsold1.PIDS = dt.Rows[0][oJS.PIDS].ToString();
vsold1.status_req = dt.Rows[0][oJS.status_req].ToString();
}
else
{
setVisitOld1(vsold1);
}
return(vsold1);
}
