/// <summary>
/// ÉóºËͨ¹ý£¬¸üпâ´æ
/// </summary>
/// <param name="BillNo"></param>
/// <param name="EmployeeCode"></param>
/// <returns></returns>
public bool Validate(string BillNo, string EmployeeCode)
{
bool flag = false;
using (PersistentManager persistentManager = new PersistentManager())
{
ProfitLossBillMasterDao dao = new ProfitLossBillMasterDao();
DataSet dsTemp = dao.GetData("select * from v_wms_PL_billdetail where BILLNO='" + BillNo + "'");
StringBuilder sb = new StringBuilder();
foreach (DataRow row in dsTemp.Tables[0].Rows)
{
sb.Append(string.Format("update WMS_WH_CELL SET QUANTITY=QUANTITY+({1}) WHERE CELLCODE='{0}';", row["CELLCODE"].ToString(), row["QUANTITY"]));
}
sb.Append(string.Format("update WMS_PL_BILLMASTER SET STATUS='2', VALIDATEPERSON='{0}',VALIDATEDATE='{1}' WHERE BILLNO='{2}';", EmployeeCode, System.DateTime.Now.ToString("yyyy-MM-dd"), BillNo));
dao.SetData(sb.ToString());
flag = true;
}
return(flag);
}
