/// <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 inCancelAllot(string BillNo) { using (PersistentManager persistentManager = new PersistentManager()) { UpdateUploadDao dao = new UpdateUploadDao(); string sql = string.Format("UPDATE DWV_IWMS_IN_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 inBillAudot(string EmployeeCode, string BillNo) { using (PersistentManager persistentManager = new PersistentManager()) { UpdateUploadDao dao = new UpdateUploadDao(); string sql = string.Format("UPDATE DWV_IWMS_IN_STORE_BILL SET BILL_STATUS='2', AUDITOR_CODE='{0}',AUDIT_DATE='{1}',QUANTITY_SUM=(select sum(quantity) from DWV_IWMS_IN_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 inDeleteAllot(string BillNo) { using (PersistentManager persistentManager = new PersistentManager()) { UpdateUploadDao dao = new UpdateUploadDao(); string sql = string.Format("DELETE FROM DWV_IWMS_IN_BUSI_BILL WHERE BUSI_BILL_ID='{0}';UPDATE DWV_IWMS_IN_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 inConfirmAllot(string EmployeeCode, string BillNo) { using (PersistentManager persistentManager = new PersistentManager()) { UpdateUploadDao dao = new UpdateUploadDao(); string sql = string.Format("UPDATE DWV_IWMS_IN_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 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); } }
/// <summary> /// ���ˣ������̳�����������ˡ�״̬��ʱ�� /// </summary> /// <param name="EmployeeCode"></param> /// <param name="BillNo"></param> public void outReBbillAudot(string BillNo) { using (PersistentManager persistentManager = new PersistentManager()) { UpdateUploadDao dao = new UpdateUploadDao(); string sql = string.Format("UPDATE DWV_IWMS_OUT_STORE_BILL SET BILL_STATUS='1', AUDITOR_CODE='',AUDIT_DATE=NULL WHERE STORE_BILL_ID='{0}'", BillNo); dao.SetData(sql); } }