/// <summary>
/// 审核通过，锁定货位
/// </summary>
/// <param name="BillNo"></param>
/// <param name="EmployeeCode"></param>
/// <returns></returns>
public bool Validate(string BillNo, string EmployeeCode)
{
bool flag = false;
using (PersistentManager persistentManager = new PersistentManager())
{
CheckBillMasterDao dao = new CheckBillMasterDao();
DataSet dsTemp = dao.GetData("select * from v_wms_CHECK_billdetail where BILLNO='" + BillNo + "'");
StringBuilder sb = new StringBuilder();
foreach (DataRow row in dsTemp.Tables[0].Rows)
{
sb.Append(string.Format("update WMS_WH_CELL SET ISLOCKED='1' WHERE CELLCODE='{0}';", row["CELLCODE"].ToString()));
}
sb.Append(string.Format("update WMS_CHECK_BILLMASTER SET STATUS='2', VALIDATEPERSON='{0}',VALIDATEDATE='{1}' WHERE BILLNO='{2}';", EmployeeCode, System.DateTime.Now.ToString("yyyy-MM-dd"), BillNo));
dao.SetData(sb.ToString());
flag = true;
}
return(flag);
}
/// <summary>
/// 下载入库主表 创联
/// </summary>
/// <param name="startDate"></param>
/// <param name="endDate"></param>
/// <param name="EmployeeCode"></param>
/// <param name="wareCode"></param>
/// <param name="billtype"></param>
/// <param name="errorInfo"></param>
/// <returns></returns>
public bool GetInBills(string startDate, string endDate, string EmployeeCode, string wareCode, string billtype, out string errorInfo)
{
bool tag = false;
Employee = EmployeeCode;
errorInfo = string.Empty;
using (PersistentManager pm = new PersistentManager())
{
try
{
DownInBillDao dao = new DownInBillDao();
DataTable emply = dao.FindEmployee(EmployeeCode);
DataTable inMasterBillNo = this.GetInBillNo();
string billnolist = UtinString.MakeString(inMasterBillNo, "bill_no");
string billnolistStr = string.Format("ORDER_DATE >='{0}' AND ORDER_DATE <='{1}'", startDate, endDate);
DataTable masterdt = this.InBillMaster(billnolistStr);
DataRow[] masterdr = masterdt.Select("ORDER_ID NOT IN(" + billnolist + ")");
string inDetailList = UtinString.MakeString(masterdr, "ORDER_ID");
inDetailList = "ORDER_ID IN(" + inDetailList + ")";
DataTable detaildt = this.InBillDetail(inDetailList);
if (masterdr.Length > 0 && detaildt.Rows.Count > 0)
{
DataSet masterds = this.InBillMaster(masterdr, emply.Rows[0]["employee_id"].ToString(), wareCode, billtype);
DataSet detailds = this.InBillDetail(detaildt);
this.Insert(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 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}) AND ORDER_TYPE='70'", 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
{
DataSet middleds = this.MiddleTable(masterdt);
//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);
this.Insert(detailds, middleds);
}
catch (Exception e)
{
errorInfo += e.Message;
tag = false;
}
}
else
{
errorInfo = "没有可下载的出库数据！";
tag = false;
}
}
return(tag);
}
/// <summary>
/// 更新已经执行分配的入库单状态
/// </summary>
/// <param name="BillNo"></param>
/// <returns></returns>
public bool UpdateAlloted(string BillNo, string EmployeeCode)
{
string[] aryBillNo = BillNo.Split(',');
string BillNoList = "''";
for (int i = 0; i < aryBillNo.Length; i++)
{
BillNoList += ",'" + aryBillNo[i] + "'";
}
bool flag = false;
using (PersistentManager persistentManager = new PersistentManager())
{
DeliveryBillMasterDao dao = new DeliveryBillMasterDao();
string sql = string.Format("update WMS_OUT_BILLMASTER SET STATUS='3' where BILLNO in ({0}) ", BillNoList);
dao.SetData(sql);
flag = true;
}
return(flag);
}
public bool Insert()
{
bool flag = false;
using (PersistentManager persistentManager = new PersistentManager())
{
EntryBillDetailDao dao = new EntryBillDetailDao();
string sql = string.Format("Insert into WMS_IN_BILLDETAIL (ID,BILLNO,PRODUCTCODE,PRICE,QUANTITY,INPUTQUANTITY,UNITCODE,MEMO) values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}')"
, this.ID, this.BILLNO,
this.PRODUCTCODE,
this.PRICE,
this.QUANTITY,
this.INPUTQUANTITY,
this.UNITCODE,
this.MEMO);
dao.SetData(sql);
flag = true;
}
return(flag);
}
// Use this for initialization
void Awake()
{
Process foo = new Process();
foo.StartInfo.FileName = "startServer.bat";
// //string path = @"..\startServer.bat";
// //string path = "@" + s;
// //UnityEngine.Debug.Log(path);
PersistentManager pm = GameObject.Find("PersistentManager").GetComponent <PersistentManager>();
//string path = pm.location()+@"startServer.bat";
//string path = System.IO.Directory.GetCurrentDirectory() + @"\startServer.bat";
//foo.StartInfo.Arguments = path;
foo.StartInfo.WindowStyle = ProcessWindowStyle.Hidden;
foo.Start();
// //foo.CloseMainWindow();
// //foo.WaitForExit();
// //int ExitCode = foo.ExitCode;
// //print(ExitCode);
}
/// <summary>
/// 修改
/// </summary>
/// <returns></returns>
public bool Update()
{
bool flag = false;
using (PersistentManager persistentManager = new PersistentManager())
{
SortingGroupDao dao = new SortingGroupDao();
string date = DateTime.Now.Date.ToString("yyyyMMdd");
string sql = string.Format("update DWV_DPS_SORTING set SORTING_NAME='{1}',SORTING_TYPE='{2}',ISACTIVE='{3}',UPDATE_DATE='{4}' where SORTING_CODE='{0}'"
, this.SORTING_CODE1,
this.SORTING_NAME1,
this.SORTING_TYPE1,
this.ISACTIVE1, date
);
dao.SetData(sql);
flag = true;
}
return(flag);
}
public bool Update()
{
bool flag = false;
using (PersistentManager persistentManager = new PersistentManager())
{
AlarmDao dao = new AlarmDao();
string sql = string.Format("update WMS_ALARM set PRODUCTCODE='{1}',MAX_LIMITED='{2}',MIN_LIMITED='{3}',MEMO='{4}' where ID='{0}'"
, this.ID,
this.PRODUCTCODE,
this.MAX_LIMITED,
this.MIN_LIMITED,
this.MEMO);
dao.SetData(sql);
flag = true;
}
return(flag);
}
public bool Insert()
{
bool flag = false;
using (PersistentManager persistentManager = new PersistentManager())
{
BillTypeDao dao = new BillTypeDao();
string sql = string.Format("Insert into WMS_BILLTYPE (TYPECODE,TYPENAME,BUSINESS,ISNEEDCELL,MEMO) values('{0}','{1}','{2}','{3}','{4}')"
, this.TYPECODE,
this.TYPENAME,
this.BUSINESS,
this.ISNEEDCELL,
this.MEMO);
dao.SetData(sql);
flag = true;
}
return(flag);
}
public bool Update()
{
bool flag = false;
using (PersistentManager persistentManager = new PersistentManager())
{
DeliveryBillMasterDao dao = new DeliveryBillMasterDao();
string sql = string.Format("update WMS_OUT_BILLMASTER set BILLDATE='{1}',BILLTYPE='{2}',WH_CODE='{3}',OPERATEPERSON='{4}',STATUS='{5}',MEMO='{6}' where BILLNO='{0}'"
, this.BILLNO,
this.BILLDATE.ToString("yyyy-MM-dd HH:mm"),
this.BILLTYPE,
this.WH_CODE,
this.OPERATEPERSON,
this.STATUS,
this.MEMO);
dao.SetData(sql);
flag = true;
}
return(flag);
}
public void SaveParameter(Dictionary <string, string> parameters)
{
using (PersistentManager pm = new PersistentManager())
{
try
{
SysSystemParameterDao parameterDao = new SysSystemParameterDao();
pm.BeginTransaction();
foreach (string key in parameters.Keys)
{
parameterDao.UpdateEntity(key, parameters[key]);
}
pm.Commit();
}
catch
{
pm.Rollback();
}
}
}
public void Scan(string text, string cigaretteCode, string barcode)
{
using (PersistentManager pm = new PersistentManager())
{
StockOutDao outDao = new StockOutDao();
SupplyDao supplyDao = new SupplyDao();
if (barcode != string.Empty && supplyDao.Exist(barcode))
{
return;
}
DataTable table = supplyDao.FindCigaretteAll(cigaretteCode);
if (table.Rows.Count > 0)
{
THOK.AS.Stocking.View.ScanDialog scanDialog = new THOK.AS.Stocking.View.ScanDialog(table);
scanDialog.setInformation(text, barcode);
if (scanDialog.ShowDialog() == DialogResult.OK)
{
if (scanDialog.IsPass && scanDialog.Barcode.Length == 6)
{
cigaretteCode = scanDialog.SelectedCigaretteCode;
barcode = scanDialog.Barcode;
using (PersistentManager pmServer = new PersistentManager("ServerConnection"))
{
ServerDao serverDao = new ServerDao();
serverDao.SetPersistentManager(pmServer);
serverDao.UpdateCigaretteToServer(barcode, cigaretteCode);
}
outDao.UpdateCigarette(barcode, cigaretteCode);
}
else
{
MessageBox.Show("验证码错误！", "消息", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
}
}
public bool Update()
{
bool flag = false;
using (PersistentManager persistentManager = new PersistentManager())
{
BillTypeDao dao = new BillTypeDao();
string sql = string.Format("update WMS_BILLTYPE set TYPECODE='{1}',TYPENAME='{2}',BUSINESS='{3}',ISNEEDCELL='{4}',MEMO='{5}' where ID='{0}'"
, this.ID,
this.TYPECODE,
this.TYPENAME,
this.BUSINESS,
this.ISNEEDCELL,
this.MEMO);
dao.SetData(sql);
flag = true;
}
return(flag);
}
public bool Insert()
{
bool flag = false;
using (PersistentManager persistentManager = new PersistentManager())
{
DeliveryBillMasterDao dao = new DeliveryBillMasterDao();
string sql = string.Format("Insert into WMS_OUT_BILLMASTER (BILLNO,BILLDATE,BILLTYPE,WH_CODE,OPERATEPERSON,STATUS,MEMO) values('{0}','{1}','{2}','{3}','{4}','{5}','{6}')"
, this.BILLNO,
this.BILLDATE.ToString("yyyy-MM-dd HH:mm"),
this.BILLTYPE,
this.WH_CODE,
this.OPERATEPERSON,
this.STATUS,
this.MEMO);
dao.SetData(sql);
flag = true;
}
return(flag);
}
public bool Insert()
{
bool flag = false;
using (PersistentManager persistentManager = new PersistentManager())
{
MoveBillDetailDao dao = new MoveBillDetailDao();
string sql = string.Format("Insert into wms_move_billdetail (BILLNO,OUT_CELLCODE,IN_CELLCODE,PRODUCTCODE,UNITCODE,QUANTITY,STATUS) values('{0}','{1}','{2}','{3}','{4}','{5}','{6}')"
, this.BILLNO,
this.OUT_CELLCODE,
this.IN_CELLCODE,
this.PRODUCTCODE,
this.UNITCODE,
this.QUANTITY,
this.STATUS);
dao.SetData(sql);
flag = true;
}
return(flag);
}
public bool Update()
{
bool flag = false;
using (PersistentManager persistentManager = new PersistentManager())
{
EntryBillDetailDao dao = new EntryBillDetailDao();
string sql = string.Format("update WMS_IN_BILLDETAIL set BILLNO='{1}',PRODUCTCODE='{2}',PRICE='{3}',QUANTITY='{4}',INPUTQUANTITY='{5}',UNITCODE='{6}',MEMO='{7}' where ID='{0}'"
, this.ID, this.BILLNO,
this.PRODUCTCODE,
this.PRICE,
this.QUANTITY,
this.INPUTQUANTITY,
this.UNITCODE,
this.MEMO);
dao.SetData(sql);
flag = true;
}
return(flag);
}
public bool Update()
{
bool flag = false;
using (PersistentManager persistentManager = new PersistentManager())
{
DepartmentDao dao = new DepartmentDao();
string sql = string.Format("update BI_DEPARTMENT set DEPTNAME='{1}',DEPTLEADER='{2}',ISACTIVE='{3}',WARECODE='{4}',MEMO='{5}' where DEPTCODE='{0}'"
, this.DEPTCODE,
this.DEPTNAME,
this.DEPTLEADER,
this.ISACTIVE,
this.WARECODE,
this.MEMO);
dao.SetData(sql);
flag = true;
}
return(flag);
}
public bool Update()
{
bool flag = false;
using (PersistentManager persistentManager = new PersistentManager())
{
CheckBillMasterDao dao = new CheckBillMasterDao();
string sql = string.Format("update wms_check_billmaster set WH_CODE='{1}',BILLTYPE='{2}',BILLDATE='{3}',OPERATEPERSON='{4}',STATUS='{5}',MEMO='{6}' where BILLNO='{0}'"
, this.BILLNO,
this.WH_CODE,
this.BILLTYPE,
this.BILLDATE,
this.OPERATEPERSON,
this.STATUS,
this.MEMO);
dao.SetData(sql);
flag = true;
}
return(flag);
}
public bool Insert()
{
bool flag = false;
using (PersistentManager persistentManager = new PersistentManager())
{
UnitDao dao = new UnitDao();
string sql = string.Format("Insert into WMS_UNIT (UNITCODE,UNITNAME,ISDEFAULT,ISACTIVE,STANDARDRATE,MEMO) values('{0}','{1}','{2}','{3}','{4}','{5}')"
, this.UNITCODE,
this.UNITNAME,
this.ISDEFAULT,
this.ISACTIVE,
this.STANDARDRATE,
this.MEMO);
dao.SetData(sql);
flag = true;
}
return(flag);
}
public bool Insert()
{
bool flag = false;
using (PersistentManager persistentManager = new PersistentManager())
{
DepartmentDao dao = new DepartmentDao();
string sql = string.Format("Insert into BI_DEPARTMENT (DEPTCODE,DEPTNAME,DEPTLEADER,ISACTIVE,WARECODE,MEMO) values('{0}','{1}','{2}','{3}','{4}','{5}')"
, this.DEPTCODE,
this.DEPTNAME,
this.DEPTLEADER,
this.ISACTIVE,
this.WARECODE,
this.MEMO);
dao.SetData(sql);
flag = true;
}
return(flag);
}
public bool UpdateBatch()
{
bool flag = false;
using (PersistentManager persistentManager = new PersistentManager())
{
WarehouseCellDao dao = new WarehouseCellDao();
string sql = string.Format("update WMS_WH_CELL set ISACTIVE='{1}',ASSIGNEDPRODUCT='{2}',ISVIRTUAL='{3}',UNITCODE='{4}' where CELL_ID='{0}'"
, this.CELL_ID,
this.ISACTIVE,
this.ASSIGNEDPRODUCT,
this.ISVIRTUAL,
this.UNITCODE);
dao.SetData(sql);
dao.SetData("update wms_wh_cell set assignedproduct=null where assignedproduct=''");
flag = true;
}
return(flag);
}
public bool Insert()
{
bool flag = false;
using (PersistentManager persistentManager = new PersistentManager())
{
CheckBillDetailDao dao = new CheckBillDetailDao();
string sql = string.Format("Insert into wms_check_billdetail (BILLNO,CELLCODE,PRODUCTCODE,UNITCODE,RECORDQUANTITY,STATUS,MEMO) values('{0}','{1}','{2}','{3}','{4}','{5}','{6}')"
, this.BILLNO,
this.CELLCODE,
this.PRODUCTCODE,
this.UNITCODE,
this.RECORDQUANTITY,
this.STATUS,
this.MEMO);
dao.SetData(sql);
flag = true;
}
return(flag);
}
private void Awake()
{
if (GameObject.FindGameObjectsWithTag("PersistentManager").Length > 1)
{
if (this != Instance)
{
Destroy(gameObject);
} //Kermit if multiple persistent managers have been made and I'm not the first one.
}
LoadGame();
if (maxUnlockedLevel < 1)
{
maxUnlockedLevel = 1;
}
Instance = this;
DontDestroyOnLoad(gameObject);
SetVolumes();
}
/// <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>
/// 选择日期从营销系统下载分拣信息
/// </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="masterds"></param>
/// <param name="detailds"></param>
public void Insert(DataSet masterds, DataSet detailds)
{
try
{
using (PersistentManager pm = new PersistentManager())
{
DownDecidePlanDao dao = new DownDecidePlanDao();
if (masterds.Tables["WMS_IN_BILLMASTER"].Rows.Count > 0)
{
dao.InsertInBillMaster(masterds);
}
if (detailds.Tables["WMS_IN_BILLDETAIL"].Rows.Count > 0)
{
dao.InsertInBillDetail(detailds);
}
}
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
public bool Update()
{
bool flag = false;
using (PersistentManager persistentManager = new PersistentManager())
{
EmployeeDao dao = new EmployeeDao();
string sql = string.Format("update BI_EMPLOYEE set EMPLOYEENAME='{1}',SEX='{2}',DEPTCODE='{3}',POSITION='{4}',STATUS='{5}',MEMO='{6}',TEL='{7}' where EMPLOYEECODE='{0}'"
, this.EMPLOYEECODE,
this.EMPLOYEENAME,
this.SEX,
this.DEPTCODE,
this.POSITION,
this.STATUS,
this.MEMO, this.Tel);
dao.SetData(sql);
flag = true;
}
return(flag);
}
public bool Update()
{
bool flag = false;
using (PersistentManager persistentManager = new PersistentManager())
{
ProfitLossBillMasterDao dao = new ProfitLossBillMasterDao();
string sql = string.Format("update WMS_PL_BILLMASTER set BILLTYPE='{1}',WH_CODE='{2}',CHECKBILLNO='{3}',BILLDATE='{4}',OPERATEPERSON='{5}',STATUS='{6}',MEMO='{7}' where BILLNO='{0}'"
, this.BILLNO,
this.BILLTYPE,
this.WH_CODE,
this.CHECKBILLNO,
this.BILLDATE,
this.OPERATEPERSON,
this.STATUS,
this.MEMO);
dao.SetData(sql);
flag = true;
}
return(flag);
}
/// <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);
}
public bool Insert()
{
bool flag = false;
using (PersistentManager persistentManager = new PersistentManager())
{
ProfitLossBillMasterDao dao = new ProfitLossBillMasterDao();
string sql = string.Format("Insert into WMS_PL_BILLMASTER (BILLNO,BILLTYPE,WH_CODE,CHECKBILLNO,BILLDATE,OPERATEPERSON,STATUS,MEMO) values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}')"
, this.BILLNO,
this.BILLTYPE,
this.WH_CODE,
this.CHECKBILLNO,
this.BILLDATE,
this.OPERATEPERSON,
this.STATUS,
this.MEMO);
dao.SetData(sql);
flag = true;
}
return(flag);
}
