/// <summary> /// post worker selected order data /// </summary> /// <param name="worker_no">worker_no</param> /// <param name="wkaOrders">order which match to the order</param> /// <returns>worker selected order data</returns> public bool PostWorkerSelectedOrderData(string worker_no, List <Dictionary <string, string> > wkaOrders) { IMainDal dal = new MainDal(); if (string.IsNullOrWhiteSpace(worker_no)) { return(false); } if (wkaOrders == null || wkaOrders.Count == 0) { return(false); } try { wkaOrders.ForEach(a => { Dictionary <string, object> pms = new Dictionary <string, object>(); pms.Add("wka_no", a.Keys.Contains("wka_no") ? a["wka_no"] : string.Empty); pms.Add("mo_no", a.Keys.Contains("mo_no") ? a["mo_no"] : string.Empty); pms.Add("worker_no", worker_no); dal.CUDByPms("Operator", "PostWorkerSelectedOrderData", pms); }); return(true); } catch (Exception ex) { LogTool.Error(ex); return(false); } }
/// <summary> /// post all wkc has been selected by worker /// </summary> /// <param name="worker_no">current worker no</param> /// <param name="wkaNos">wka has been selected</param> /// <returns>is post action success</returns> public bool PostWorkerSelectedWka(string worker_no, List <string> wkaNos) { IMainDal dal = new MainDal(); Dictionary <string, object> pms = new Dictionary <string, object>(); pms.Add("worker_no", worker_no); pms.Add("wka_no", wkaNos); return(dal.CUDByPms("Operator", "PostWorkerSelectedWka", pms) > 0); }
/// <summary> /// query int /// </summary> /// <param name="sqlFileName">sql file name</param> /// <param name="sqlId">sql id</param> /// <param name="pmsList">query parameter list</param> /// <returns>int result</returns> public virtual int QueryInt(string sqlFileName, string sqlId, List <Dictionary <string, object> > pmsList) { IMainDal dal = new MainDal(); return(dal.CUDByPms(sqlFileName, sqlId, pmsList)); }