public int GetRowCount(string filter)
{
using (PersistentManager persistentManager = new PersistentManager())
{
ProfitLossBillMasterDao dao = new ProfitLossBillMasterDao();
return(dao.GetRowCount(strTableView, filter));
}
}
public DataSet QueryProfitLossBillMaster(int pageIndex, int pageSize, string filter, string OrderByFields)
{
using (PersistentManager persistentManager = new PersistentManager())
{
ProfitLossBillMasterDao dao = new ProfitLossBillMasterDao();
return(dao.Query(strTableView, strPrimaryKey, strQueryFields, pageIndex, pageSize, OrderByFields, filter, strTableView));
}
}
public bool Delete(DataSet dataSet)
{
bool flag = false;
using (PersistentManager persistentManager = new PersistentManager())
{
ProfitLossBillMasterDao dao = new ProfitLossBillMasterDao();
dao.DeleteEntity(dataSet);
flag = true;
}
return(flag);
}
/// <summary>
/// ÉóºËͨ¹ý£¬¸üпâ´æ
/// </summary>
/// <param name="BillNo"></param>
/// <param name="EmployeeCode"></param>
/// <returns></returns>
public bool Validate(string BillNo, string EmployeeCode)
{
bool flag = false;
using (PersistentManager persistentManager = new PersistentManager())
{
ProfitLossBillMasterDao dao = new ProfitLossBillMasterDao();
DataSet dsTemp = dao.GetData("select * from v_wms_PL_billdetail where BILLNO='" + BillNo + "'");
StringBuilder sb = new StringBuilder();
foreach (DataRow row in dsTemp.Tables[0].Rows)
{
sb.Append(string.Format("update WMS_WH_CELL SET QUANTITY=QUANTITY+({1}) WHERE CELLCODE='{0}';", row["CELLCODE"].ToString(), row["QUANTITY"]));
}
sb.Append(string.Format("update WMS_PL_BILLMASTER SET STATUS='2', VALIDATEPERSON='{0}',VALIDATEDATE='{1}' WHERE BILLNO='{2}';", EmployeeCode, System.DateTime.Now.ToString("yyyy-MM-dd"), BillNo));
dao.SetData(sb.ToString());
flag = true;
}
return(flag);
}
public bool Update()
{
bool flag = false;
using (PersistentManager persistentManager = new PersistentManager())
{
ProfitLossBillMasterDao dao = new ProfitLossBillMasterDao();
string sql = string.Format("update WMS_PL_BILLMASTER set BILLTYPE='{1}',WH_CODE='{2}',CHECKBILLNO='{3}',BILLDATE='{4}',OPERATEPERSON='{5}',STATUS='{6}',MEMO='{7}' where BILLNO='{0}'"
, this.BILLNO,
this.BILLTYPE,
this.WH_CODE,
this.CHECKBILLNO,
this.BILLDATE,
this.OPERATEPERSON,
this.STATUS,
this.MEMO);
dao.SetData(sql);
flag = true;
}
return(flag);
}
public bool Insert()
{
bool flag = false;
using (PersistentManager persistentManager = new PersistentManager())
{
ProfitLossBillMasterDao dao = new ProfitLossBillMasterDao();
string sql = string.Format("Insert into WMS_PL_BILLMASTER (BILLNO,BILLTYPE,WH_CODE,CHECKBILLNO,BILLDATE,OPERATEPERSON,STATUS,MEMO) values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}')"
, this.BILLNO,
this.BILLTYPE,
this.WH_CODE,
this.CHECKBILLNO,
this.BILLDATE,
this.OPERATEPERSON,
this.STATUS,
this.MEMO);
dao.SetData(sql);
flag = true;
}
return(flag);
}
