/// <summary>
/// 保存订单明细到虚拟表，创联
/// </summary>
/// <param name="dr"></param>
/// <returns></returns>
public DataSet SaveSortingOrderDetails(DataTable detaildt)
{
DownSortingOrderDao dao = new DownSortingOrderDao();
DataTable unitList = dao.GetUnitProduct();
DataSet ds = this.GenerateEmptyTables();
try
{
int i = 0;
foreach (DataRow row in detaildt.Rows)
{
DataRow detailrow = ds.Tables["DWV_OUT_ORDER_DETAIL"].NewRow();
i++;
detailrow["order_detail_id"] = row["ORDER_DETAIL_ID"].ToString().Trim() + i;
detailrow["order_id"] = row["ORDER_ID"].ToString().Trim();
detailrow["product_code"] = row["BRAND_CODE"].ToString().Trim();
detailrow["product_name"] = row["BRAND_NAME"].ToString().Trim();
detailrow["unit_code"] = row["BRAND_UNIT_CODE"].ToString();
detailrow["unit_name"] = row["BRAND_UNIT_NAME"].ToString().Trim();;
detailrow["demand_quantity"] = Convert.ToDecimal(row["QUANTITY"]);
detailrow["real_quantity"] = Convert.ToDecimal(row["QUANTITY"]);
detailrow["price"] = Convert.ToDecimal(row["PRICE"]);
detailrow["amount"] = Convert.ToDecimal(row["AMOUNT"]);
detailrow["unit_quantity"] = 50;
ds.Tables["DWV_OUT_ORDER_DETAIL"].Rows.Add(detailrow);
}
return(ds);
}
catch (Exception e)
{
string s = e.Message;
return(null);
}
}
/// <summary>
/// 手动下载
/// </summary>
/// <param name="billno"></param>
/// <returns></returns>
public string GetSortingOrderById(string orderid)
{
string tag = "true";
using (PersistentManager dbPm = new PersistentManager())
{
DownSortingOrderDao dao = new DownSortingOrderDao();
dao.SetPersistentManager(dbPm);
try
{
orderid = "ORDER_ID IN (" + orderid + ")";
DataTable masterdt = this.GetSortingOrder(orderid);
DataTable detaildt = this.GetSortingOrderDetail(orderid);
if (masterdt.Rows.Count > 0 && detaildt.Rows.Count > 0)
{
DataSet masterds = this.SaveSortingOrder(masterdt);
DataSet detailds = this.SaveSortingOrderDetail(detaildt);
this.Insert(masterds, detailds);
}
else
{
return("没有数据可下载！");
}
}
catch (Exception e)
{
tag = e.Message;
}
}
return(tag);
}
/// <summary>
/// 自动下载订单
/// </summary>
/// <returns></returns>
public string DownSortingOrder()
{
string tag = "true";
using (PersistentManager dbpm = new PersistentManager())
{
DownSortingOrderDao dao = new DownSortingOrderDao();
dao.SetPersistentManager(dbpm);
try
{
DataTable orderdt = this.GetOrderId();
string orderlist = UtinString.StringMake(orderdt, "ORDER_ID");
orderlist = UtinString.StringMake(orderlist);
orderlist = "ORDER_ID NOT IN(" + orderlist + ")";
DataTable masterdt = this.GetSortingOrder(orderlist);
DataTable detaildt = this.GetSortingOrderDetail(orderlist);
if (masterdt.Rows.Count > 0 && detaildt.Rows.Count > 0)
{
DataSet masterds = this.SaveSortingOrder(masterdt);
DataSet detailds = this.SaveSortingOrderDetail(detaildt);
this.Insert(masterds, detailds);
}
else
{
return("没有可用的数据下载！");
}
}
catch (Exception e)
{
tag = e.Message;
}
}
return(tag);
}
/// <summary>
/// 查询4天之内的分拣订单
/// </summary>
/// <returns></returns>
public DataTable GetOrderId(string orderDate)
{
using (PersistentManager dbpm = new PersistentManager())
{
DownSortingOrderDao dao = new DownSortingOrderDao();
return(dao.GetOrderId(orderDate));
}
}
/// <summary>
/// 根据用户选择的订单下载分拣线订单明细表 创联
/// </summary>
/// <returns></returns>
public DataTable GetSortingOrderDetails(string orderid)
{
using (PersistentManager dbpm = new PersistentManager("YXConnection"))
{
DownSortingOrderDao dao = new DownSortingOrderDao();
dao.SetPersistentManager(dbpm);
return(dao.GetSortingOrderDetails(orderid));
}
}
/// <summary>
/// 查询4天之内的分拣订单
/// </summary>
/// <returns></returns>
public DataTable GetOrderId()
{
using (PersistentManager dbpm = new PersistentManager())
{
DownSortingOrderDao dao = new DownSortingOrderDao();
dao.SetPersistentManager(dbpm);
return(dao.GetOrderId());
}
}
/// <summary>
/// 查询营销系统分拣明细表数据
/// </summary>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="inBillNo"></param>
/// <returns></returns>
public DataTable GetSortingOrderDetail(int pageIndex, int pageSize, string inBillNo)
{
using (PersistentManager dbpm = new PersistentManager("YXConnection"))
{
DownSortingOrderDao dao = new DownSortingOrderDao();
dao.SetPersistentManager(dbpm);
inBillNo = "ORDER_ID = '" + inBillNo + "'";
return(dao.GetSortingOrderDetail(inBillNo));
}
}
/// <summary>
/// 查询营销系统分拣订单主表数据进行下载
/// </summary>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <returns></returns>
public DataTable GetSortingOrder(int pageIndex, int pageSize)
{
using (PersistentManager dbpm = new PersistentManager("YXConnection"))
{
DownSortingOrderDao dao = new DownSortingOrderDao();
dao.SetPersistentManager(dbpm);
DataTable orderdt = this.GetOrderId();
string orderlist = UtinString.StringMake(orderdt, "ORDER_ID");
orderlist = UtinString.StringMake(orderlist);
orderlist = "ORDER_ID NOT IN(" + orderlist + ")";
return(dao.GetSortingOrder(orderlist));
}
}
/// <summary>
/// 把下载的数据添加到数据库。
/// </summary>
/// <param name="masterds"></param>
/// <param name="detailds"></param>
public void Insert(DataSet masterds, DataSet detailds)
{
using (PersistentManager pm = new PersistentManager())
{
DownSortingOrderDao dao = new DownSortingOrderDao();
if (masterds.Tables["DWV_OUT_ORDER"].Rows.Count > 0)
{
dao.InsertSortingOrder(masterds);
}
if (detailds.Tables["DWV_OUT_ORDER_DETAIL"].Rows.Count > 0)
{
dao.InsertSortingOrderDetail(detailds);
}
}
}
/// <summary>
/// 根据时间查询营销系统分拣订单主表数据进行下载
/// </summary>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <returns></returns>
public DataTable GetSortingOrder(int pageIndex, int pageSize, string startDate, string endDate)
{
using (PersistentManager dbpm = new PersistentManager("YXConnection"))
{
DownSortingOrderDao dao = new DownSortingOrderDao();
dao.SetPersistentManager(dbpm);
DataTable orderdt = this.GetOrderId();
string orderlist = UtinString.StringMake(orderdt, "ORDER_ID");
orderlist = UtinString.StringMake(orderlist);
//orderlist = "ORDER_DATE>='" + startDate + "' AND ORDER_DATE<='" + endDate + "' AND ORDER_ID NOT IN(" + orderlist + ")";
orderlist = "ORDER_ID NOT IN(" + orderlist + ")";
DataTable masert = dao.GetSortingOrder("ORDER_ID NOT IN('')");
DataRow[] orderdr = masert.Select(orderlist);
return(this.SaveSortingOrder(orderdr).Tables[0]);
}
}
/// <summary>
/// 选择日期从营销系统下载分拣信息 创联
/// </summary>
/// <param name="orderDate"></param>
/// <param name="endDate"></param>
/// <returns></returns>
public bool GetSortingOrderDates(string orderDate, string endDate, out string errorInfo)
{
bool tag = false;
errorInfo = string.Empty;
using (PersistentManager dbpm = new PersistentManager())
{
DownSortingOrderDao dao = new DownSortingOrderDao();
try
{
//查询仓库7天内的订单号
DataTable orderdt = this.GetOrderId(orderDate);
string orderlist = UtinString.MakeString(orderdt, "order_id");
string orderlistDate = "ORDER_DATE ='" + orderDate + "' AND ORDER_ID NOT IN(" + orderlist + ")";
DataTable masterdt = this.GetSortingOrders(orderlistDate); //根据时间查询订单信息
string ordermasterlist = UtinString.MakeString(masterdt, "ORDER_ID"); //取得根据时间查询的订单号
ordermasterlist = "ORDER_ID IN (" + ordermasterlist + ")";
DataTable detaildt = this.GetSortingOrderDetails(ordermasterlist); //根据订单号查询明细
if (masterdt.Rows.Count > 0 && detaildt.Rows.Count > 0)
{
DataSet masterds = this.SaveSortingOrders(masterdt);
DataSet detailds = this.SaveSortingOrderDetails(detaildt);
this.Insert(masterds, detailds);
//上报分拣订单
//upload.uploadSort(masterds, detailds);
tag = true;
}
else
{
errorInfo = "没有可用的数据下载！";
}
}
catch (Exception e)
{
errorInfo = "错误：" + e.Message;
}
}
return(tag);
}
/// <summary>
/// 保存订单明细到虚拟表，传来DataTable
/// </summary>
/// <param name="dr"></param>
/// <returns></returns>
public DataSet SaveSortingOrderDetail(DataRow[] detaildt)
{
DownSortingOrderDao dao = new DownSortingOrderDao();
DataTable unitList = dao.GetUnitProduct();
DataSet ds = this.GenerateEmptyTables();
try
{
int i = 0;
foreach (DataRow row in detaildt)
{
DataRow[] list = unitList.Select(string.Format("unit_list_code='{0}'", row["BRANDCODE"].ToString().Trim()));
DataRow detailrow = ds.Tables["DWV_OUT_ORDER_DETAIL"].NewRow();
i++;
string newcode = i.ToString();
for (int j = 0; j < 5 - i.ToString().Length; j++)
{
newcode = "0" + newcode;
}
detailrow["order_detail_id"] = row["ORDER_DETAIL_ID"].ToString().Trim() + newcode;
detailrow["order_id"] = row["ORDERID"].ToString().Trim();
detailrow["product_code"] = row["BRANDCODE"].ToString().Trim();
detailrow["product_name"] = row["BRAND_NAME"].ToString().Trim();
detailrow["unit_code"] = list[0]["unit_code02"].ToString();
detailrow["unit_name"] = row["BRAND_UNIT_NAME"].ToString().Trim();;
detailrow["demand_quantity"] = Convert.ToDecimal(row["QUANTITY"]);
detailrow["real_quantity"] = Convert.ToDecimal(row["QUANTITY"]);
detailrow["price"] = Convert.ToDecimal(row["PRICE"]);
detailrow["amount"] = Convert.ToDecimal(row["AMOUNT"]);
detailrow["unit_quantity"] = 50;
ds.Tables["DWV_OUT_ORDER_DETAIL"].Rows.Add(detailrow);
}
return(ds);
}
catch (Exception e)
{
string s = e.Message;
return(null);
}
}
/// <summary>
/// 选择日期从营销系统下载分拣信息
/// </summary>
/// <param name="orderDate"></param>
/// <param name="endDate"></param>
/// <returns></returns>
public bool GetSortingOrderDate(string orderDate, string endDate, out string errorInfo)
{
bool tag = false;
errorInfo = string.Empty;
using (PersistentManager dbpm = new PersistentManager())
{
DownSortingOrderDao dao = new DownSortingOrderDao();
try
{
//查询仓库7天内的订单号
DataTable orderdt = this.GetOrderId(orderDate);
string orderlist = UtinString.MakeString(orderdt, "order_id");
string orderlistDate = "ORDER_DATE ='" + orderDate + "'";
DataTable masterdt = this.GetSortingOrder(orderlistDate); //根据时间查询主表数据
DataRow[] masterdr = masterdt.Select("ORDERID NOT IN(" + orderlist + ")"); //排除已经下载的数据
string ordermasterlist = UtinString.MakeString(masterdr, "ORDERID"); //获取未下载主表单据的数据字符
DataTable detaildt = this.GetSortingOrderDetail(orderlistDate); //根据时间查询细表数据
DataRow[] detaildr = detaildt.Select("ORDERID IN (" + ordermasterlist + ")"); //查询未下载的细单数据
if (masterdr.Length > 0 && detaildr.Length > 0)
{
DataSet masterds = this.SaveSortingOrder(masterdr);
DataSet detailds = this.SaveSortingOrderDetail(detaildr);
this.Insert(masterds, detailds);
//上报分拣订单
//upload.uploadSort(masterds, detailds);
tag = true;
}
else
{
errorInfo = "没有可用的数据下载！";
}
}
catch (Exception e)
{
errorInfo = "下载分拣数据失败！原因：" + e.Message;
}
}
return(tag);
}
/// <summary>
/// 选择日期从营销系统下载分拣信息
/// </summary>
/// <param name="startDate"></param>
/// <param name="endDate"></param>
/// <returns></returns>
public string GetSortingOrderDate(string startDate, string endDate)
{
string tag = "true";
using (PersistentManager dbpm = new PersistentManager())
{
DownSortingOrderDao dao = new DownSortingOrderDao();
dao.SetPersistentManager(dbpm);
try
{
//查询仓库7天内的订单号
DataTable orderdt = this.GetOrderId();
string orderlist = UtinString.StringMake(orderdt, "ORDER_ID");
orderlist = UtinString.StringMake(orderlist);
string orderlistDate = "ORDER_DATE>='" + startDate + "' AND ORDER_DATE<='" + endDate + "' AND ORDER_ID NOT IN(" + orderlist + ")";
DataTable masterdt = this.GetSortingOrder(orderlistDate); //根据时间查询订单信息
string ordermasterlist = UtinString.StringMake(masterdt, "ORDER_ID"); //取得根据时间查询的订单号
string ordermasterid = UtinString.StringMake(ordermasterlist);
ordermasterid = "ORDER_ID IN (" + ordermasterid + ")";
DataTable detaildt = this.GetSortingOrderDetail(ordermasterid);//根据订单号查询明细
if (masterdt.Rows.Count > 0 && detaildt.Rows.Count > 0)
{
DataSet masterds = this.SaveSortingOrder(masterdt);
DataSet detailds = this.SaveSortingOrderDetail(detaildt);
this.Insert(masterds, detailds);
}
else
{
return("没有可用的数据下载！");
}
}
catch (Exception e)
{
tag = e.Message;
}
}
return(tag);
}
