/// <summary>
/// ѡ�����ڴ�Ӫ��ϵͳ���س��ⵥ��
/// </summary>
/// <param name="startDate"></param>
/// <param name="endDate"></param>
/// <returns></returns>
public bool GetOutBill(string startDate, string endDate, string EmployeeCode, out string errorInfo, string wareCode, string billType)
{
bool tag = true;
Employee = EmployeeCode;
errorInfo = string.Empty;
using (PersistentManager dbpm = new PersistentManager())
{
DownOutBillDao dao = new DownOutBillDao();
DataTable emply = dao.FindEmployee(EmployeeCode);
DataTable outBillNoTable = this.GetOutBillNo(startDate);
string outBillList = UtinString.MakeString(outBillNoTable, "bill_no");
outBillList = string.Format("ORDER_DATE ='{0}' AND ORDER_ID NOT IN({1}) ", startDate, outBillList);
DataTable masterdt = this.GetOutBillMaster(outBillList);
string outDetailList = UtinString.MakeString(masterdt, "ORDER_ID");
outDetailList = "ORDER_ID IN(" + outDetailList + ")";
DataTable detaildt = this.GetOutBillDetail(outDetailList);
if (masterdt.Rows.Count > 0 && detaildt.Rows.Count > 0)
{
try
{
string billno = this.GetNewBillNo();
DataSet middleds = this.MiddleTable(masterdt,billno);
//DataSet masterds = this.OutBillMaster(masterdt, emply.Rows[0]["employee_id"].ToString(), wareCode, billType);
DataSet detailds = this.OutBillDetail(detaildt, emply.Rows[0]["employee_id"].ToString(), wareCode, billType, startDate,billno);
this.Insert(detailds, middleds);
}
catch (Exception e)
{
errorInfo += e.Message;
tag = false;
}
}
else
{
errorInfo = "û�п����صij������ݣ�";
tag = false;
}
}
return tag;
}
