public int GetRowCount(string filter) { using (PersistentManager persistentManager = new PersistentManager()) { DeliveryBillDetailDao dao = new DeliveryBillDetailDao(); return(dao.GetRowCount(strTableView, filter)); } }
public DataSet QueryByID(string id) { string sql = string.Format("SELECT {1} FROM {2} where ID='{0}' ", id.ToString(), strQueryFields, strTableView); using (PersistentManager persistentManager = new PersistentManager()) { DeliveryBillDetailDao dao = new DeliveryBillDetailDao(); return(dao.GetData(sql)); } }
public bool Delete(DataSet dataSet) { bool flag = false; using (PersistentManager persistentManager = new PersistentManager()) { DeliveryBillDetailDao dao = new DeliveryBillDetailDao(); dao.DeleteEntity(dataSet); flag = true; } return(flag); }
public DataSet QueryByBillNo(string BillNo, int pageIndex, int pageSize) { string[] aryBillNo = BillNo.Split(','); string BillNoList = "''"; for (int i = 0; i < aryBillNo.Length; i++) { BillNoList += ",'" + aryBillNo[i] + "'"; } string sql = string.Format("SELECT {0} from {1} where BILLNO in ({2}) ORDER BY BILLNO DESC,PRODUCTCODE ASC", strQueryFields, strTableView, BillNoList); using (PersistentManager persistentManager = new PersistentManager()) { DeliveryBillDetailDao dao = new DeliveryBillDetailDao(); return(dao.Query(sql, strTableView, pageIndex, pageSize)); } }
/// <summary> /// 根据主表单号查询明细 /// </summary> /// <param name="BillNo">单据编号,可以多个用逗号隔开</param> /// <returns></returns> public DataSet QueryByBillNo(string BillNo) { string[] aryBillNo = BillNo.Split(','); string BillNoList = "''"; for (int i = 0; i < aryBillNo.Length; i++) { BillNoList += ",'" + aryBillNo[i] + "'"; } string sql = string.Format("select {0} from {1} where BILLNO in ({2}) ORDER BY BILLNO DESC", strQueryFields, strTableView, BillNoList); using (PersistentManager persistentManager = new PersistentManager()) { DeliveryBillDetailDao dao = new DeliveryBillDetailDao(); return(dao.GetData(sql)); } }
public bool Insert() { bool flag = false; using (PersistentManager persistentManager = new PersistentManager()) { DeliveryBillDetailDao dao = new DeliveryBillDetailDao(); string sql = string.Format("Insert into WMS_OUT_BILLDETAIL (ID,BILLNO,PRODUCTCODE,PRICE,QUANTITY,OUTPUTQUANTITY,UNITCODE,MEMO) values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}')" , this.ID, this.BILLNO, this.PRODUCTCODE, this.PRICE, this.QUANTITY, this.OUTPUTQUANTITY, this.UNITCODE, this.MEMO); dao.SetData(sql); flag = true; } return(flag); }
public bool Update() { bool flag = false; using (PersistentManager persistentManager = new PersistentManager()) { DeliveryBillDetailDao dao = new DeliveryBillDetailDao(); string sql = string.Format("update WMS_OUT_BILLDETAIL set BILLNO='{1}',PRODUCTCODE='{2}',PRICE='{3}',QUANTITY='{4}',OUTPUTQUANTITY='{5}',UNITCODE='{6}',MEMO='{7}' where ID='{0}'" , this.ID, this.BILLNO, this.PRODUCTCODE, this.PRICE, this.QUANTITY, this.OUTPUTQUANTITY, this.UNITCODE, this.MEMO); dao.SetData(sql); flag = true; } return(flag); }