/// <summary> /// 删除出库单据主表和细表 /// </summary> /// <param name="BillNo"></param> public void deleteOutBill(string BillNo) { using (PersistentManager persistentManager = new PersistentManager()) { UpdateUploadDao dao = new UpdateUploadDao(); string sql = string.Format("DELETE DWV_IWMS_OUT_STORE_BILL_DETAIL WHERE STORE_BILL_ID IN({0})", BillNo); dao.SetData(sql); sql = string.Format("DELETE DWV_IWMS_OUT_STORE_BILL WHERE STORE_BILL_ID IN({0})", BillNo); dao.SetData(sql); } }
/// <summary> /// 取消确认,修改中烟出库主表确认人、状态和时间 /// </summary> /// <param name="EmployeeCode"></param> /// <param name="BillNo"></param> public void outCancelAudot(string BillNo) { using (PersistentManager persistentManager = new PersistentManager()) { UpdateUploadDao dao = new UpdateUploadDao(); string sql = string.Format("UPDATE DWV_IWMS_OUT_STORE_BILL SET BILL_STATUS='3', AFFIRM_CODE='',AFFIRM_DATE=NULL WHERE STORE_BILL_ID='{0}'", BillNo); dao.SetData(sql); } }
/// <summary> /// 确认分配,修改中烟出库主表确认人、状态和时间 /// </summary> /// <param name="EmployeeCode"></param> /// <param name="BillNo"></param> public void outConfirmAudot(string EmployeeCode, string BillNo) { using (PersistentManager persistentManager = new PersistentManager()) { UpdateUploadDao dao = new UpdateUploadDao(); string sql = string.Format("UPDATE DWV_IWMS_OUT_STORE_BILL SET BILL_STATUS='4', AFFIRM_CODE='{0}',AFFIRM_DATE='{1}' WHERE STORE_BILL_ID='{2}'", EmployeeCode, System.DateTime.Now.ToString("yyyyMMddHHmmss"), BillNo); dao.SetData(sql); } }
/// <summary> /// 取消分配,修改中烟出库主表分配人、状态和时间,并删除分配表 /// </summary> /// <param name="EmployeeCode"></param> /// <param name="BillNo"></param> public void outDeleteAudot(string BillNo) { using (PersistentManager persistentManager = new PersistentManager()) { UpdateUploadDao dao = new UpdateUploadDao(); string sql = string.Format("DELETE FROM DWV_IWMS_OUT_BUSI_BILL WHERE BUSI_BILL_ID='{0}';UPDATE DWV_IWMS_OUT_STORE_BILL SET BILL_STATUS='2', ASSIGNER_CODE='',ASSIGN_DATE=NULL WHERE STORE_BILL_ID='{0}'", BillNo); dao.SetData(sql); } }
/// <summary> /// 审核,修改中烟出库主表审核人、状态和时间 /// </summary> /// <param name="EmployeeCode"></param> /// <param name="BillNo"></param> public void outBillAudot(string EmployeeCode, string BillNo) { using (PersistentManager persistentManager = new PersistentManager()) { UpdateUploadDao dao = new UpdateUploadDao(); string sql = string.Format("UPDATE DWV_IWMS_OUT_STORE_BILL SET BILL_STATUS='2', AUDITOR_CODE='{0}',AUDIT_DATE='{1}',QUANTITY_SUM=(select sum(quantity) from DWV_IWMS_OUT_STORE_BILL_DETAIL where STORE_BILL_ID='{2}') WHERE STORE_BILL_ID='{3}'", EmployeeCode, System.DateTime.Now.ToString("yyyyMMddHHmmss"), BillNo, BillNo); dao.SetData(sql); } }
/// <summary> /// 反核,修改中烟入库主表审核人、状态和时间 /// </summary> /// <param name="EmployeeCode"></param> /// <param name="BillNo"></param> public void inRevBillAudot(string BillNo) { using (PersistentManager persistentManager = new PersistentManager()) { UpdateUploadDao dao = new UpdateUploadDao(); string sql = string.Format("UPDATE DWV_IWMS_IN_STORE_BILL SET BILL_STATUS='1', AUDITOR_CODE='',AUDIT_DATE=NULL WHERE STORE_BILL_ID='{0}'", BillNo); dao.SetData(sql); } }
/// <summary> /// 分配,修改中烟出库主表分配人、状态和时间 /// </summary> /// <param name="EmployeeCode"></param> /// <param name="BillNo"></param> public void outUpdateAudot(string EmployeeCode, string BillNo) { string[] aryBillNo = BillNo.Split(','); string BillNoList = "''"; for (int i = 0; i < aryBillNo.Length; i++) { BillNoList += ",'" + aryBillNo[i] + "'"; } using (PersistentManager persistentManager = new PersistentManager()) { UpdateUploadDao dao = new UpdateUploadDao(); string sql = string.Format("UPDATE DWV_IWMS_OUT_STORE_BILL SET BILL_STATUS='3', ASSIGNER_CODE='{0}',ASSIGN_DATE='{1}' WHERE STORE_BILL_ID IN({2})", EmployeeCode, System.DateTime.Now.ToString("yyyyMMddHHmmss"), BillNoList); dao.SetData(sql); } }