public bool Insert()
{
bool flag = false;
using (PersistentManager persistentManager = new PersistentManager())
{
CheckBillDetailDao dao = new CheckBillDetailDao();
string sql = string.Format("Insert into wms_check_billdetail (BILLNO,CELLCODE,PRODUCTCODE,UNITCODE,RECORDQUANTITY,STATUS,MEMO) values('{0}','{1}','{2}','{3}','{4}','{5}','{6}')"
, this.BILLNO,
this.CELLCODE,
this.PRODUCTCODE,
this.UNITCODE,
this.RECORDQUANTITY,
this.STATUS,
this.MEMO);
dao.SetData(sql);
flag = true;
}
return(flag);
}
public bool Update()
{
bool flag = false;
using (PersistentManager persistentManager = new PersistentManager())
{
CheckBillDetailDao dao = new CheckBillDetailDao();
string sql = string.Format("update wms_check_billdetail set BILLNO='{1}',CELLCODE='{2}',PRODUCTCODE='{3}',UNITCODE='{4}',RECORDQUANTITY='{5}',COUNTQUANTITY='{6}',STATUS='{7}',MEMO='{8}' where ID='{0}'"
, this.ID,
this.BILLNO,
this.CELLCODE,
this.PRODUCTCODE,
this.UNITCODE,
this.RECORDQUANTITY,
0,//this.COUNTQUANTITY,
this.STATUS,
this.MEMO);
dao.SetData(sql);
flag = true;
}
return(flag);
}