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