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); }