/// <summary>
/// 批量插入盘点明细
/// </summary>
/// <param name="tableCell"></param>
/// <param name="EmployeeCode"></param>
/// <returns></returns>
public bool BatchInsertBill(DataTable tableCell, string EmployeeCode)
{
bool flag = false;
using (PersistentManager persistentManager = new PersistentManager())
{
//if(tableCell)
CheckBillMasterDao dao = new CheckBillMasterDao();
CheckBillDetailDao daoDetail = new CheckBillDetailDao();
string billNo = GetNewBillNo();
string wh_code = tableCell.Rows[0]["WH_CODE"].ToString();
string sql = string.Format("Insert into wms_check_billmaster (BILLNO,WH_CODE,BILLTYPE,BILLDATE,OPERATEPERSON,STATUS,MEMO) values('{0}','{1}','{2}','{3}','{4}','{5}','{6}')"
, billNo, wh_code, "401", System.DateTime.Now.ToString("yyyy-MM-dd"), EmployeeCode, "1", "");
dao.SetData(sql);
DataTable tableTmep = daoDetail.GetData("select * from wms_check_billdetail where 1=0").Tables[0];
foreach (DataRow row in tableCell.Rows)
{
DataRow newRow = tableTmep.NewRow();
newRow["BILLNO"] = billNo;
newRow["CELLCODE"] = row["CELLCODE"];
string p = row["CURRENTPRODUCT"].ToString();
newRow["PRODUCTCODE"] = p;
newRow["UNITCODE"] = row["UNITCODE"];
newRow["RECORDQUANTITY"] = row["QUANTITY"];
newRow["COUNTQUANTITY"] = 0;//row["QUANTITY"];//盘点数量默认为账面数量
newRow["STATUS"] = "0";
tableTmep.Rows.Add(newRow);
}
daoDetail.BatchInsertDetail(tableTmep);
flag = true;
}
return(flag);
}
public int GetRowCount(string filter)
{
using (PersistentManager persistentManager = new PersistentManager())
{
CheckBillDetailDao dao = new CheckBillDetailDao();
return(dao.GetRowCount(strTableView, filter));
}
}
public DataSet QueryCheckBillDetail(int pageIndex, int pageSize, string filter, string OrderByFields)
{
using (PersistentManager persistentManager = new PersistentManager())
{
CheckBillDetailDao dao = new CheckBillDetailDao();
return(dao.Query(strTableView, strPrimaryKey, strQueryFields, pageIndex, pageSize, OrderByFields, filter, strTableView));
}
}
public bool Delete(DataSet dataSet)
{
bool flag = false;
using (PersistentManager persistentManager = new PersistentManager())
{
CheckBillDetailDao dao = new CheckBillDetailDao();
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", strQueryFields, strTableView, BillNoList);
using (PersistentManager persistentManager = new PersistentManager())
{
CheckBillDetailDao dao = new CheckBillDetailDao();
return(dao.Query(sql, strTableView, pageIndex, pageSize));
}
}
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);
}
