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