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