public void AddBill3(DataRow masterRow, DataTable detailTable)
{
using (PersistentManager pm = new PersistentManager())
{
try
{
BillDao billDao = new BillDao();
ProductStateDao stateDao = new ProductStateDao();
pm.BeginTransaction();
string billNo = billDao.FindNewBillNo("P", masterRow["BILLDATE"].ToString());
masterRow["BILLNO"] = billNo;
//���뵥������
billDao.InsertMaster(masterRow);
stateDao.Insert(billNo, detailTable);
pm.Commit();
}
catch (Exception e)
{
pm.Rollback();
throw new Exception(e.Message);
}
}
}
public int AddProductState(string billNo, string scheduleNo, int itemNo, string productCode, string quantity, string userID, string mixID)
{
using (PersistentManager pm = new PersistentManager())
{
ProductStateDao psDao = new ProductStateDao();
return psDao.Insert(billNo, scheduleNo, itemNo, productCode, quantity, userID, mixID);
}
}
public void AddBill(DataRow masterRow, DataTable detailTable, Dictionary<string, DataTable> productState, string prefix, string billDate)
{
using (PersistentManager pm = new PersistentManager())
{
try
{
BillDao billDao = new BillDao();
ProductStateDao stateDao = new ProductStateDao();
ScheduleDao scheduleDao = new ScheduleDao();
pm.BeginTransaction();
string billNo = billDao.FindNewBillNo(prefix, billDate);
masterRow["BILLNO"] = billNo;
//���뵥������
billDao.InsertMaster(masterRow);
//���뵥����ϸ��
billDao.InsertDetail(billNo, detailTable);
if (productState != null)
{
//����ProductState��
int itemNo = 1;
foreach (DataTable stateTable in productState.Values)
{
stateDao.Insert(masterRow["SCHEDULENO"].ToString(),
billNo,
stateTable,
ref itemNo);
}
}
pm.Commit();
}
catch (Exception e)
{
pm.Rollback();
throw new Exception(e.Message);
}
}
}
public void TaskOutBill(DataRow masterRow, string tasker)
{
using (PersistentManager pm = new PersistentManager())
{
try
{
pm.BeginTransaction();
string billNo = masterRow["BILLNO"].ToString();
DataTable detailTable = palletDao.FindDetail(billNo);
string billType = masterRow["BILLTYPE"].ToString();
string taskType = billType == "001" ? "1" : "2";
string target = billType == "001" ? "" : "3";
ProductStateDao stateDao = new ProductStateDao();
int itemNo = 1;
stateDao.Insert("", billNo, detailTable, ref itemNo);
BillDao billDao = new BillDao();
billDao.TaskOutBill(billNo);
palletDao.UpdateTasker(billNo, tasker);
pm.Commit();
}
catch (Exception e)
{
pm.Rollback();
throw new Exception(e.Message);
}
}
}
/// <summary>
/// ������ҵ
/// </summary>
/// <param name="billNo"></param>
/// <param name="userID"></param>
/// <param name="date"></param>
public DataTable TaskBill(string billNo, string status, string userID, string date)
{
DataTable table = null;
using (PersistentManager pm = new PersistentManager())
{
BillDao billDao = new BillDao();
ProductStateDao stateDao = new ProductStateDao();
TaskDao taskDao = new TaskDao();
try
{
pm.BeginTransaction();
DataTable masterTable = billDao.FindMaster(billNo);
if (masterTable.Rows.Count != 0)
{
string scheduleNo = masterTable.Rows[0]["SCHEDULENO"].ToString();
//PRODUCTSTATE��û������
if (stateDao.FindDetail(billNo).Rows.Count == 0)
{
DataTable detailTable = billDao.FindDetail(billNo);
int item = 1;
stateDao.Insert(scheduleNo, billNo, detailTable, ref item);
}
string result = billDao.TaskOutBill(billNo);
if (result != "0")
throw new Exception("û��Ϊ��Ʒ�ҵ���λ���⡣");
ScheduleDao scheduleDao = new ScheduleDao();
scheduleDao.UpdateOutSchedule(scheduleNo);
////����billmaster״̬
billDao.UpdateMasterState(billNo, "3", "TASKER", userID, "TASKDATE", date);
//���ij����ܰ���
int packageCount = taskDao.FindTaskCount(billNo);
scheduleDao.UpdatePackageCount(scheduleNo, packageCount);
}
else
throw new Exception(string.Format("δ�ҵ����ݺ�Ϊ'{0}'�ĵ��ݡ�", billNo));
table = stateDao.FindDetail(billNo);
pm.Commit();
return table;
}
catch (Exception e)
{
pm.Rollback();
throw new Exception(e.Message);
}
}
}
/// <summary>
/// �����ҵ
/// </summary>
/// <param name="billNo"></param>
/// <param name="stateTable"></param>
/// <param name="userID"></param>
/// <param name="date"></param>
public void TaskBill(string billNo, DataTable stateTable, string userID, string date)
{
using (PersistentManager pm = new PersistentManager())
{
BillDao billDao = new BillDao();
ProductStateDao stateDao = new ProductStateDao();
TaskDao taskDao = new TaskDao();
try
{
pm.BeginTransaction();
DataTable masterTable = billDao.FindMaster(billNo);
if (masterTable.Rows.Count != 0)
{
string scheduleNo = masterTable.Rows[0]["SCHEDULENO"].ToString();
string taskType = masterTable.Rows[0]["TTYPE"].ToString();
string taskLevel = masterTable.Rows[0]["TASKLEVEL"].ToString();
string target = masterTable.Rows[0]["TARGET"].ToString();
//�жϵ�ǰ�����Ƿ���productstaet��������������Ǹ���billdetail����
if (stateTable.Rows.Count == 0)
{
DataTable detailTable = billDao.FindDetail(billNo);
int item = 1;
stateDao.Insert(scheduleNo, billNo, detailTable, ref item);
}
stateDao.UpdateBarcode(billNo);
//����task��ҵ��
taskDao.Insert(billNo, taskType, taskLevel, target);
////����billmaster״̬
billDao.UpdateMasterState(billNo, "3", "TASKER", userID, "TASKDATE", date);
}
else
throw new Exception(string.Format("δ�ҵ����ݺ�Ϊ'{0}'�ĵ��ݡ�", billNo));
pm.Commit();
}
catch (Exception e)
{
pm.Rollback();
throw new Exception(e.Message);
}
}
}
public void SaveBill3(DataRow masterRow, DataTable stateTable)
{
using (PersistentManager pm = new PersistentManager())
{
try
{
BillDao billDao = new BillDao();
ProductStateDao stateDao = new ProductStateDao();
string billNo = masterRow["BILLNO"].ToString();
pm.BeginTransaction();
//���뵥������
billDao.UpdateMaster(masterRow);
//���뵥����ϸ��
stateDao.Delete(billNo);
stateDao.Insert(billNo, stateTable);
pm.Commit();
}
catch (Exception e)
{
pm.Rollback();
throw new Exception(e.Message);
}
}
}
public void SaveAlcoholizeBill(DataRow masterRow, DataTable detailTable, Dictionary<string, DataTable> productState, string userID)
{
using (PersistentManager pm = new PersistentManager())
{
try
{
BillDao billDao = new BillDao();
ProductStateDao stateDao = new ProductStateDao();
ScheduleDao scheduleDao = new ScheduleDao();
string billNo = masterRow["BILLNO"].ToString();
pm.BeginTransaction();
//���뵥������
billDao.UpdateMaster2(masterRow);
//���뵥����ϸ��
billDao.SaveAlcoholizeDetail(billNo, detailTable);
//����ProductState��
if (productState != null)
{
foreach (string productCode in productState.Keys)
{
DataTable stateTable = productState[productCode];
//stateDao.Delete(billNo, productCode);
stateDao.Insert(billNo,
masterRow["SCHEDULENO"].ToString(),
stateTable,
userID);
}
}
pm.Commit();
}
catch (Exception e)
{
pm.Rollback();
throw new Exception(e.Message);
}
}
}
public string GenBillFromTask(string billNo, string billType, string userID, string sysDate)
{
string newNo = null;
using (PersistentManager pm = new PersistentManager())
{
BillDao billDao = new BillDao();
ProductStateDao stateDao = new ProductStateDao();
try
{
pm.BeginTransaction();
DataTable stateTable = stateDao.FindBillDetail(billNo);
DataTable masterTable = billDao.FindMaster(billNo);
if (masterTable.Rows.Count != 0)
{
DataRow masterRow = masterTable.Rows[0];
string target = "";
if (billType == "002")//���ɵĵ���Ϊ���ⵥ
target = "3";
newNo = billDao.FindNewBillNo("P", sysDate);
billDao.InsertMaster(newNo, sysDate, billType, masterRow["SCHEDULENO"].ToString(),
masterRow["BILLNO"].ToString(), masterRow["WAREHOUSECODE"].ToString(),
target, "0", "1", userID);
int itemNo = 1;
foreach (DataRow stateRow in stateTable.Rows)
{
if (stateRow["REALQUANTITY"].ToString().Trim().Length != 0)
{
stateRow["REALQUANTITY"] = 0;
stateDao.Insert(newNo, billType, itemNo++, stateRow);
}
}
if (itemNo == 1)
throw new Exception("û���̰��ѳ��⣬����Ҫ�����˿ⵥ");
DataTable detailTable = stateDao.Find(newNo);
billDao.InsertDetail(newNo, detailTable);
}
pm.Commit();
}
catch (Exception e)
{
pm.Rollback();
throw new Exception(e.Message);
}
}
return newNo;
}
