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