/// <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);
}
/// <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())
{
CheckBillDetailDao dao = new CheckBillDetailDao();
return(dao.GetData(sql));
}
}