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