public OldPackageDeposit setNote(DataTable dt)
{
OldPackageDeposit ostkd1 = new OldPackageDeposit();
if (dt.Rows.Count > 0)
{
ostkd1.active = dt.Rows[0][oPkgdp.active].ToString();
ostkd1.date_cancel = dt.Rows[0][oPkgdp.date_cancel].ToString();
ostkd1.date_create = dt.Rows[0][oPkgdp.date_create].ToString();
ostkd1.date_modi = dt.Rows[0][oPkgdp.date_modi].ToString();
ostkd1.remark = dt.Rows[0][oPkgdp.remark].ToString();
ostkd1.user_cancel = dt.Rows[0][oPkgdp.user_cancel].ToString();
ostkd1.user_create = dt.Rows[0][oPkgdp.user_create].ToString();
ostkd1.user_modi = dt.Rows[0][oPkgdp.user_modi].ToString();
ostkd1.PCKDPSID = dt.Rows[0][oPkgdp.PCKDPSID].ToString();
ostkd1.PCKSID = dt.Rows[0][oPkgdp.PCKSID].ToString();
ostkd1.PID = dt.Rows[0][oPkgdp.PID].ToString();
ostkd1.ItemType = dt.Rows[0][oPkgdp.ItemType].ToString();
ostkd1.ItemID = dt.Rows[0][oPkgdp.ItemID].ToString();
ostkd1.ItemName = dt.Rows[0][oPkgdp.ItemName].ToString();
ostkd1.QTY = dt.Rows[0][oPkgdp.QTY].ToString();
ostkd1.QTYused = dt.Rows[0][oPkgdp.QTYused].ToString();
ostkd1.isPCKclosed = dt.Rows[0][oPkgdp.isPCKclosed].ToString();
}
else
{
setNote1(ostkd1);
}
return(ostkd1);
}
public String insertPackageDeposit(OldPackageDeposit p, String userId)
{
String re = "";
if (p.PCKDPSID.Equals(""))
{
re = insert(p, "");
}
else
{
re = update(p, "");
}
return(re);
}
private void chkNull(OldPackageDeposit p)
{
long chk = 0;
Decimal chk1 = 0;
p.date_modi = p.date_modi == null ? "" : p.date_modi;
p.date_cancel = p.date_cancel == null ? "" : p.date_cancel;
p.user_create = p.user_create == null ? "" : p.user_create;
p.user_modi = p.user_modi == null ? "" : p.user_modi;
p.user_cancel = p.user_cancel == null ? "" : p.user_cancel;
p.remark = p.remark == null ? "" : p.remark;
p.ItemType = p.ItemType == null ? "0" : p.ItemType;
p.isPCKclosed = p.isPCKclosed == null ? "" : p.isPCKclosed;
p.ItemName = p.ItemName == null ? "" : p.ItemName;
p.PCKSID = long.TryParse(p.PCKSID, out chk) ? chk.ToString() : "0";
p.PID = long.TryParse(p.PID, out chk) ? chk.ToString() : "0";
p.ItemID = long.TryParse(p.ItemID, out chk) ? chk.ToString() : "0";
//p.b_service_point_id = long.TryParse(p.b_service_point_id, out chk) ? chk.ToString() : "0";
}
private OldPackageDeposit setNote1(OldPackageDeposit stf1)
{
stf1.active = "";
stf1.date_cancel = "";
stf1.date_create = "";
stf1.date_modi = "";
stf1.remark = "";
stf1.user_cancel = "";
stf1.user_create = "";
stf1.user_modi = "";
stf1.PCKDPSID = "";
stf1.PCKSID = "";
stf1.PID = "";
stf1.ItemType = "";
stf1.ItemID = "";
stf1.ItemName = "";
stf1.QTY = "";
stf1.QTYused = "";
stf1.isPCKclosed = "";
return(stf1);
}
public String insert(OldPackageDeposit p, String userId)
{
String re = "";
String sql = "";
p.active = "1";
//p.ssdata_id = "";
int chk = 0;
chkNull(p);
sql = "Insert Into " + oPkgdp.table + " Set " +
" " + oPkgdp.PCKSID + " = '" + p.PCKSID + "'" +
"," + oPkgdp.PID + "= '" + p.PID + "'" +
"," + oPkgdp.remark + "= '" + p.remark.Replace("'", "''") + "'" +
"," + oPkgdp.date_create + "= now() " +
"," + oPkgdp.date_cancel + "= '" + p.date_cancel + "'" +
"," + oPkgdp.date_modi + "= '" + p.date_modi + "'" +
"," + oPkgdp.user_cancel + "= '" + p.user_cancel + "'" +
"," + oPkgdp.user_create + "= '" + userId + "'" +
"," + oPkgdp.user_modi + "= '" + p.user_modi + "'" +
"," + oPkgdp.ItemType + "= '" + p.ItemType + "'" +
"," + oPkgdp.active + "= '" + p.active + "'" +
"," + oPkgdp.ItemID + "= '" + p.ItemID + "'" +
"," + oPkgdp.ItemName + "= '" + p.ItemName.Replace("'", "''") + "'" +
"," + oPkgdp.QTY + "= '" + p.QTY + "'" +
"," + oPkgdp.QTYused + "= '" + p.QTYused + "'" +
"," + oPkgdp.isPCKclosed + "= '" + p.isPCKclosed + "'" +
"";
try
{
re = conn.ExecuteNonQuery(conn.conn, sql);
}
catch (Exception ex)
{
sql = ex.Message + " " + ex.InnerException;
}
return(re);
}
private void initConfig()
{
oPkgdp = new OldPackageDeposit();
oPkgdp.PCKDPSID = "PCKDPSID";
oPkgdp.PCKSID = "PCKSID";
oPkgdp.PID = "PID";
oPkgdp.ItemType = "ItemType";
oPkgdp.ItemID = "ItemID";
oPkgdp.ItemName = "ItemName";
oPkgdp.QTY = "QTY";
oPkgdp.QTYused = "QTYused";
oPkgdp.isPCKclosed = "isPCKclosed";
oPkgdp.date_cancel = "date_cancel";
oPkgdp.date_create = "date_create";
oPkgdp.date_modi = "date_modi";
oPkgdp.user_cancel = "user_cancel";
oPkgdp.user_create = "user_create";
oPkgdp.user_modi = "user_modi";
oPkgdp.remark = "remark";
oPkgdp.active = "active";
oPkgdp.table = "PackageDeposit";
oPkgdp.pkField = "PCKDPSID";
}
