public List <OldPackageDetail> selectListPackage(String pttId)
{
loPkgD.Clear();
DataTable dt = new DataTable();
String sql = "select oPkgD.*" + " " +
"From " + oPkgD.table + " oPkgD " +
"Where oPkgD." + oPkgD.PCKID + " ='" + pttId + "' and active = '1'" +
"Order By oPkgD." + oPkgD.ItemName;
dt = conn.selectData(conn.conn, sql);
if (dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
OldPackageDetail ostkd1 = new OldPackageDetail();
ostkd1.ID = row[oPkgD.ID].ToString();
ostkd1.PCKID = row[oPkgD.PCKID].ToString();
ostkd1.ItemType = row[oPkgD.ItemType].ToString();
ostkd1.ItemName = row[oPkgD.ItemName].ToString();
ostkd1.ItemID = row[oPkgD.ItemID].ToString();
ostkd1.QTY = row[oPkgD.QTY].ToString();
ostkd1.active = row[oPkgD.active].ToString();
ostkd1.qty_use = row[oPkgD.qty_use].ToString();
loPkgD.Add(ostkd1);
}
}
return(loPkgD);
}
public String update(OldPackageDetail p, String userId)
{
String re = "";
String sql = "";
chkNull(p);
sql = "Update " + oPkgD.table + " Set " +
" " + oPkgD.ItemType + " = '" + p.ItemType.Replace("'", "''") + "'" +
"," + oPkgD.ItemName + "= '" + p.ItemName.Replace("'", "''") + "'" +
"," + oPkgD.PCKID + "= '" + p.PCKID.Replace("'", "''") + "'" +
//"," + oPkgD.date_create + "= now() " +
//"," + note.date_cancel + "= '" + p.date_cancel + "'" +
//"," + note.date_modi + "= '" + p.date_modi + "'" +
//"," + note.user_cancel + "= '" + p.user_cancel + "'" +
//"," + note.user_create + "= '" + userId + "'" +
//"," + note.user_modi + "= '" + p.user_modi + "'" +
"," + oPkgD.ItemID + "= '" + p.ItemID + "'" +
//"," + oPkgD.active + "= '" + p.active + "'" +
"," + oPkgD.QTY + "= '" + p.QTY + "'" +
"Where " + oPkgD.pkField + "='" + p.ID + "'";
try
{
re = conn.ExecuteNonQuery(conn.conn, sql);
}
catch (Exception ex)
{
sql = ex.Message + " " + ex.InnerException;
}
return(re);
}
//private void CboGrp_SelectedIndexChanged(object sender, EventArgs e)
//{
// //throw new NotImplementedException();
// ic.ivfDB.oLabiDB.setCboLabItem(cboItm, "");
//}
private void setPackageDetail(String itmtype, String itmname, String itmid, String qty)
{
ic.cStf.staff_id = "";
if (txtID.Text.Equals(""))
{
MessageBox.Show("ไม่พบรหัส Package", "");
return;
}
Decimal qty1 = 0;
if (!Decimal.TryParse(qty, out qty1))
{
MessageBox.Show("ไม่พบจำนวน ", "");
return;
}
//FrmPasswordConfirm frm = new FrmPasswordConfirm(ic);
//frm.ShowDialog(this);
//if (!ic.cStf.staff_id.Equals(""))
//{
OldPackageDetail oPkgD = new OldPackageDetail();
oPkgD.ID = "";
oPkgD.PCKID = txtID.Text;
oPkgD.ItemType = itmtype;
oPkgD.ItemName = itmname;
oPkgD.ItemID = itmid;
oPkgD.QTY = qty;
ic.ivfDB.oPkgdDB.insertPackageDetail(oPkgD, ic.cStf.staff_id);
setGrfPkgD(txtID.Text);
//}
}
private OldPackageDetail setNote1(OldPackageDetail stf1)
{
stf1.ID = "";
stf1.PCKID = "";
stf1.ItemType = "";
stf1.ItemName = "";
stf1.ItemID = "";
stf1.QTY = "";
stf1.active = "";
stf1.qty_use = "";
return(stf1);
}
public String insertPackageDetail(OldPackageDetail p, String userId)
{
String re = "";
if (p.ID.Equals(""))
{
re = insert(p, "");
}
else
{
re = update(p, "");
}
return(re);
}
public OldPackageDetail setNote(DataTable dt)
{
OldPackageDetail ostkd1 = new OldPackageDetail();
if (dt.Rows.Count > 0)
{
ostkd1.ID = dt.Rows[0][oPkgD.ID].ToString();
ostkd1.PCKID = dt.Rows[0][oPkgD.PCKID].ToString();
ostkd1.ItemType = dt.Rows[0][oPkgD.ItemType].ToString();
ostkd1.ItemName = dt.Rows[0][oPkgD.ItemName].ToString();
ostkd1.ItemID = dt.Rows[0][oPkgD.ItemID].ToString();
ostkd1.QTY = dt.Rows[0][oPkgD.QTY].ToString();
ostkd1.active = dt.Rows[0][oPkgD.active].ToString();
ostkd1.qty_use = dt.Rows[0][oPkgD.qty_use].ToString();
}
else
{
setNote1(ostkd1);
}
return(ostkd1);
}
private void chkNull(OldPackageDetail 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 ? "" : p.ItemType;
p.ItemName = p.ItemName == null ? "" : p.ItemName;
//p.note_2 = p.note_2 == null ? "" : p.note_2;
p.PCKID = long.TryParse(p.PCKID, out chk) ? chk.ToString() : "0";
p.ItemID = long.TryParse(p.ItemID, out chk) ? chk.ToString() : "0";
p.QTY = Decimal.TryParse(p.QTY, out chk1) ? chk1.ToString() : "0";
p.qty_use = Decimal.TryParse(p.qty_use, out chk1) ? chk1.ToString() : "0";
}
private void initConfig()
{
oPkgD = new OldPackageDetail();
oPkgD.ID = "ID";
oPkgD.PCKID = "PCKID";
oPkgD.ItemType = "ItemType";
oPkgD.ItemName = "ItemName";
oPkgD.ItemID = "ItemID";
oPkgD.QTY = "QTY";
oPkgD.active = "active";
oPkgD.qty_use = "qty_use";
oPkgD.date_create = "date_create";
oPkgD.date_modi = "date_modi";
oPkgD.date_cancel = "date_cancel";
oPkgD.user_create = "user_create";
oPkgD.user_modi = "user_modi";
oPkgD.user_cancel = "user_cancel";
oPkgD.table = "PackageDetail";
oPkgD.pkField = "ID";
loPkgD = new List <OldPackageDetail>();
}
public String insert(OldPackageDetail p, String userId)
{
String re = "";
String sql = "";
p.active = "1";
//p.ssdata_id = "";
int chk = 0;
chkNull(p);
sql = "Insert Into " + oPkgD.table + " Set " +
" " + oPkgD.ItemType + " = '" + p.ItemType.Replace("'", "''") + "'" +
"," + oPkgD.ItemName + "= '" + p.ItemName.Replace("'", "''") + "'" +
"," + oPkgD.PCKID + "= '" + p.PCKID.Replace("'", "''") + "'" +
//"," + oPkgD.date_create + "= now() " +
//"," + note.date_cancel + "= '" + p.date_cancel + "'" +
//"," + note.date_modi + "= '" + p.date_modi + "'" +
//"," + note.user_cancel + "= '" + p.user_cancel + "'" +
//"," + note.user_create + "= '" + userId + "'" +
//"," + note.user_modi + "= '" + p.user_modi + "'" +
"," + oPkgD.ItemID + "= '" + p.ItemID + "'" +
"," + oPkgD.active + "= '" + p.active + "'" +
"," + oPkgD.QTY + "= '" + p.QTY + "'" +
"," + oPkgD.qty_use + "= '0'" +
"";
try
{
re = conn.ExecuteNonQuery(conn.conn, sql);
}
catch (Exception ex)
{
sql = ex.Message + " " + ex.InnerException;
}
return(re);
}
