1.生产开包工末道工序传入入库条码
2.App工序检验提交接口修改
3.基本资料增加ERP接口:车间部门、仓库查询、用户信息
4.PC端报工、收料、工序检验提交接口增加入库条码字段
5.系统设置新增:条码规则生成(固定条码)接口
6.DapperHelper增加方法
7.增加App图标图片
已重命名1个文件
已添加3个文件
已修改26个文件
已删除161个文件
| | |
| | | { |
| | | [RoutePrefix(prefix: "api/AppProductionManagement")] |
| | | [ControllerGroup("Appç产管ç", "å¨çº¿æ¥å£")] |
| | | [ChannelActionFilterAttributeApp] |
| | | //[ChannelActionFilterAttributeApp] |
| | | public class AppProductionManagementController : ApiController |
| | | { |
| | | //å®ä¹å
¨å±ä¿¡æ¯è¿ååé |
| | |
| | | string stepseq = HttpContext.Current.Request["stepseq"].ToString();//å·¥åºåºå· |
| | | string stepcode = HttpContext.Current.Request["stepcode"].ToString();//å·¥åºç¼ç |
| | | string eqpcode = HttpContext.Current.Request["eqpcode"].ToString();//设å¤ç¼ç |
| | | string inbarcode = HttpContext.Current.Request["inbarcode"].ToString(); //å
¥åºæ¡ç |
| | | string reckway = HttpContext.Current.Request["reckway"].ToString(); //计件æ¹å¼(çç»:groupã个人:person) |
| | | string usergroupcode = HttpContext.Current.Request["usergroupcode"].ToString();//çç»ç¼ç |
| | | string reportuser = HttpContext.Current.Request["reportuser"].ToString();//æ¥å·¥äººå |
| | |
| | | string badcode = HttpContext.Current.Request["badcode"].ToString();//ä¸è¯åå ç¼ç |
| | | string remarks = HttpContext.Current.Request["remarks"].ToString();//夿³¨ |
| | | string username = HttpContext.Current.Request["admin"].ToString();//æä½äººå |
| | | mes = ProductionManagementBLL.SavaMesOrderStepReport(mesordercode, partcode, stepseq, stepcode, eqpcode, reckway,usergroupcode, reportuser, taskqty, startqty, reportqty, ngqty, badcode, remarks, username); |
| | | mes = ProductionManagementBLL.SavaMesOrderStepReport(mesordercode, partcode, stepseq, stepcode, eqpcode, inbarcode, reckway,usergroupcode, reportuser, taskqty, startqty, reportqty, ngqty, badcode, remarks, username); |
| | | return TJson.toJson(mes); |
| | | } |
| | | #endregion |
| | |
| | | string stepseq = HttpContext.Current.Request["stepseq"].ToString();//å·¥åºåºå· |
| | | string stepcode = HttpContext.Current.Request["stepcode"].ToString();//å·¥åºç¼ç |
| | | string wxcode = HttpContext.Current.Request["wxcode"].ToString();//å¤åä¾åºåç¼ç |
| | | string inbarcode = HttpContext.Current.Request["inbarcode"].ToString(); //å
¥åºæ¡ç |
| | | string inuser = HttpContext.Current.Request["inuser"].ToString();//æ¶æäººå |
| | | string taskqty = HttpContext.Current.Request["taskqty"].ToString();//任塿°é |
| | | string sqty = HttpContext.Current.Request["sqty"].ToString();//æ¶ææ°é |
| | |
| | | string badcode = HttpContext.Current.Request["badcode"].ToString();//ä¸è¯åå ç¼ç |
| | | string remarks = HttpContext.Current.Request["remarks"].ToString();//夿³¨ |
| | | string username = HttpContext.Current.Request["admin"].ToString();//æä½äººå |
| | | mes = ProductionManagementBLL.SavaMesOrderStepIn(mesordercode, partcode, stepseq, stepcode, wxcode, inuser, taskqty, sqty, ngqty, badcode, remarks, username); |
| | | mes = ProductionManagementBLL.SavaMesOrderStepIn(mesordercode, partcode, stepseq, stepcode, wxcode, inbarcode, inuser, taskqty, sqty, ngqty, badcode, remarks, username); |
| | | return TJson.toJson(mes); |
| | | } |
| | | #endregion |
| | |
| | | string ngqty = HttpContext.Current.Request["ngqty"].ToString();//ä¸åæ ¼æ°é |
| | | string checkitemcont = HttpContext.Current.Request["checkitemcont"].ToString();//æ£éªé¡¹ç®æ°æ® |
| | | string username = HttpContext.Current.Request["admin"].ToString();//æä½äººå |
| | | mes = ProductionManagementBLL.SaveMesOrderStepCheckItem(wocode, checkstandcode, check_type, sampmethod, partcode, qualitystatus, labqty, sampleqty, goodqty, ngqty, checkitemcont, username); |
| | | mes = ProductionManagementBLL.SaveMesOrderStepCheckItem(wocode,partcode,stepcode,checkstandcode,check_type,sampmethod,qualitystatus,labqty,sampleqty,goodqty,ngqty,checkitemcont,username); |
| | | return TJson.toJson(mes); |
| | | } |
| | | #endregion |
| | |
| | | return TJson.toJson(mes); |
| | | } |
| | | #endregion |
| | | |
| | | |
| | | |
| | | #region[ERPç产车é´/é¨é¨ä¿¡æ¯æ¥è¯¢] |
| | | /// <summary> |
| | | /// ERPç产车é´/é¨é¨ä¿¡æ¯æ¥è¯¢ |
| | | /// </summary> |
| | | /// <returns></returns> |
| | | [Route(template: "ErpWkshopDepartmentSelect")] |
| | | [HttpGet] |
| | | public HttpResponseMessage ErpWkshopDepartmentSelect() |
| | | { |
| | | mes = BaseDateBLL.ErpWkshopDepartmentSelect(); |
| | | return TJson.toJson(mes); |
| | | } |
| | | #endregion |
| | | |
| | | #region[ERPçä»åºä¿¡æ¯æ¥è¯¢] |
| | | /// <summary> |
| | | /// ERPçä»åºä¿¡æ¯æ¥è¯¢ |
| | | /// </summary> |
| | | /// <returns></returns> |
| | | [Route(template: "ErpWarehouseSelect")] |
| | | [HttpGet] |
| | | public HttpResponseMessage ErpWarehouseSelect() |
| | | { |
| | | mes = BaseDateBLL.ErpWarehouseSelect(); |
| | | return TJson.toJson(mes); |
| | | } |
| | | #endregion |
| | | |
| | | #region[ERPçç¨æ·ä¿¡æ¯æ¥è¯¢] |
| | | /// <summary> |
| | | /// ERPçç¨æ·ä¿¡æ¯æ¥è¯¢ |
| | | /// </summary> |
| | | /// <returns></returns> |
| | | [Route(template: "ErpUserSelect")] |
| | | [HttpGet] |
| | | public HttpResponseMessage ErpUserSelect() |
| | | { |
| | | mes = BaseDateBLL.ErpUserSelect(); |
| | | return TJson.toJson(mes); |
| | | } |
| | | #endregion |
| | | } |
| | | } |
| | |
| | | { |
| | | [RoutePrefix(prefix: "api/ProductionManagement")] |
| | | [ControllerGroup("ç产管ç", "å¨çº¿æ¥å£")] |
| | | [ChannelActionFilter] |
| | | //[ChannelActionFilter] |
| | | public class ProductionManagementController : ApiController |
| | | { |
| | | //å®ä¹å
¨å±ä¿¡æ¯è¿ååé |
| | |
| | | string stepseq = obj["stepseq"].ToString(); //å·¥åºåºå· |
| | | string stepcode = obj["stepcode"].ToString(); //å·¥åºç¼ç |
| | | string eqpcode = obj["eqpcode"].ToString(); //设å¤ç¼ç |
| | | string inbarcode = obj["inbarcode"].ToString(); //å
¥åºæ¡ç |
| | | string reckway = obj["reckway"].ToString(); //计件æ¹å¼(çç»:groupã个人:person) |
| | | string usergroupcode = obj["usergroupcode"].ToString(); //çç»ç¼ç |
| | | string reportuser = obj["reportuser"].ToString(); //æ¥å·¥äººå |
| | |
| | | string badcode = obj["badcode"].ToString(); //ä¸è¯åå ç¼ç |
| | | string remarks = obj["remarks"].ToString(); //夿³¨ |
| | | var username = HttpContext.Current.Request.Cookies["admin"].Value.ToString(); //æä½äººå |
| | | mes = ProductionManagementBLL.SavaMesOrderStepReport(mesordercode, partcode, stepseq, stepcode, eqpcode, reckway, usergroupcode, reportuser, taskqty, startqty, reportqty, ngqty, badcode, remarks, username); |
| | | mes = ProductionManagementBLL.SavaMesOrderStepReport(mesordercode, partcode, stepseq, stepcode, eqpcode, inbarcode, reckway, usergroupcode, reportuser, taskqty, startqty, reportqty, ngqty, badcode, remarks, username); |
| | | return TJson.toJson(mes); |
| | | } |
| | | #endregion |
| | |
| | | string stepseq = obj["stepseq"].ToString(); //å·¥åºåºå· |
| | | string stepcode = obj["stepcode"].ToString(); //å·¥åºç¼ç |
| | | string wxcode = obj["wxcode"].ToString(); //å¤åä¾åºåç¼ç |
| | | string inbarcode = obj["inbarcode"].ToString(); //å
¥åºæ¡ç |
| | | string inuser = obj["inuser"].ToString(); //æ¶æäººå |
| | | string taskqty = obj["taskqty"].ToString(); //任塿°é |
| | | string sqty = obj["sqty"].ToString(); //æ¶ææ°é |
| | |
| | | string badcode = obj["badcode"].ToString(); //ä¸è¯åå ç¼ç |
| | | string remarks = obj["remarks"].ToString(); //夿³¨ |
| | | var username = HttpContext.Current.Request.Cookies["admin"].Value.ToString(); //æä½äººå |
| | | mes = ProductionManagementBLL.SavaMesOrderStepIn(mesordercode, partcode, stepseq, stepcode, wxcode, inuser, taskqty, sqty, ngqty, badcode, remarks, username); |
| | | mes = ProductionManagementBLL.SavaMesOrderStepIn(mesordercode, partcode, stepseq, stepcode, wxcode, inbarcode, inuser, taskqty, sqty, ngqty, badcode, remarks, username); |
| | | return TJson.toJson(mes); |
| | | } |
| | | #endregion |
| | |
| | | string ngqty = obj["ngqty"].ToString();//ä¸åæ ¼æ°é |
| | | string checkitemcont = obj["checkitemcont"].ToString(); //æ£éªé¡¹ç®æ°æ® |
| | | var username = HttpContext.Current.Request.Cookies["admin"].Value.ToString(); //æä½äººå |
| | | mes = ProductionManagementBLL.SaveMesOrderStepCheckItem(wocode, partcode,stepcode, checkstandcode, check_type, sampmethod, qualitystatus, labqty, sampleqty, goodqty, ngqty, checkitemcont, username); |
| | | mes = ProductionManagementBLL.SaveMesOrderStepCheckItem(wocode, partcode, stepcode, checkstandcode, check_type, sampmethod, qualitystatus, labqty, sampleqty, goodqty, ngqty, checkitemcont, username); |
| | | return TJson.toJson(mes); |
| | | } |
| | | #endregion |
| | |
| | | return TJson.toJson(mes); |
| | | } |
| | | #endregion |
| | | |
| | | |
| | | |
| | | #region[ç产å
¥åºæ¡ç è¡¥æ] |
| | | /// <summary> |
| | | /// ç产å
¥åºæ¡ç è¡¥æ |
| | | /// </summary> |
| | | /// <param name="ordercode">å·¥åç¼å·</param> |
| | | /// <returns></returns> |
| | | [Route(template: "ProductInHouseLabCode")] |
| | | [HttpGet] |
| | | public HttpResponseMessage ProductInHouseLabCode(string ordercode) |
| | | { |
| | | mes = ProductionManagementBLL.ProductInHouseLabCode(ordercode); |
| | | return TJson.toJson(mes); |
| | | } |
| | | #endregion |
| | | |
| | | #region[ç产å
¥åºéè¿è½¦é´æ¥æ¾ç产订å] |
| | | /// <summary> |
| | | /// ç产å
¥åºéè¿è½¦é´æ¥æ¾ç产订å |
| | | /// </summary> |
| | | /// <param name="ordertype">åæ®ç±»å</param> |
| | | /// <param name="wkshopcode">车é´ç¼ç </param> |
| | | /// <returns></returns> |
| | | [Route(template: "ProductInHouseWkshopOrder")] |
| | | [HttpGet] |
| | | public HttpResponseMessage ProductInHouseWkshopOrder(string ordertype,string wkshopcode) |
| | | { |
| | | mes = ProductionManagementBLL.ProductInHouseWkshopOrder(ordertype, wkshopcode); |
| | | return TJson.toJson(mes); |
| | | } |
| | | #endregion |
| | | |
| | | #region[ç产å
¥åºä¿¡æ¯æ¥è¯¢] |
| | | /// <summary> |
| | | /// ç产å
¥åºä¿¡æ¯æ¥è¯¢ |
| | | /// </summary> |
| | | /// <param name="wkshopcode">车é´ç¼ç </param> |
| | | /// <param name="erpordercode">订åç¼å·</param> |
| | | /// <param name="mesordercode">å·¥åç¼å·</param> |
| | | /// <param name="partcode">产åç¼ç </param> |
| | | /// <param name="partname">产ååç§°</param> |
| | | /// <param name="partspec">è§æ ¼åå·</param> |
| | | /// <param name="orderdate">工忥æ</param> |
| | | /// <returns></returns> |
| | | [Route(template: "ProductInHouseOrderSearch")] |
| | | [HttpGet] |
| | | public HttpResponseMessage ProductInHouseOrderSearch(string wkshopcode, string erpordercode = null, string mesordercode = null, string partcode = null, string partname = null, string partspec = null, string orderdate = null) |
| | | { |
| | | string startorderdate = ""; //å·¥åå¼å§æ¶é´ |
| | | string endorderdate = ""; //å·¥åç»ææ¶é´ |
| | | if (orderdate != "" && orderdate != null) |
| | | { |
| | | startorderdate = orderdate.Split('~')[0].ToString(); |
| | | endorderdate = orderdate.Split('~')[1].ToString(); |
| | | } |
| | | mes = ProductionManagementBLL.ProductInHouseOrderSearch(wkshopcode,erpordercode, mesordercode, partcode, partname, partspec, startorderdate, endorderdate); |
| | | return TJson.toJson(mes); |
| | | } |
| | | #endregion |
| | | |
| | | #region[ç产å
¥åºè·ååæ®å·] |
| | | /// <summary> |
| | | /// ç产å
¥åºè·ååæ®å· |
| | | /// </summary> |
| | | /// <param name="rightcode">åè½ç¼ç </param> |
| | | /// <returns></returns> |
| | | [Route(template: "ProductInHouseOrderCodeSearch")] |
| | | [HttpPost] |
| | | public HttpResponseMessage ProductInHouseOrderCodeSearch(string rightcode) |
| | | { |
| | | mes = ProductionManagementBLL.ProductInHouseOrderCodeSearch(rightcode); |
| | | return TJson.toJson(mes); |
| | | } |
| | | #endregion |
| | | |
| | | #region[ç产å
¥åºæäº¤] |
| | | /// <summary> |
| | | /// ç产å
¥åºæäº¤ |
| | | /// </summary> |
| | | /// <param name="wkshp_code">车é´ç¼ç </param> |
| | | /// <param name="erporder_code">订åç¼å·</param> |
| | | /// <param name="wo_code">å·¥åç¼å·</param> |
| | | /// <param name="saleorder_code">éå®è®¢åå·</param> |
| | | /// <param name="orderdate">åæ®æ¥æ</param> |
| | | /// <param name="ordercode">åæ®ç¼ç </param> |
| | | /// <param name="storehousecode">ä»åºç¼ç </param> |
| | | /// <param name="obj">æç»æ°æ®</param> |
| | | /// <returns></returns> |
| | | [Route(template: "ProductInHouseOrderSeave")] |
| | | [HttpPost] |
| | | public HttpResponseMessage ProductInHouseOrderSeave([FromBody] JObject obj) |
| | | { |
| | | var username = HttpContext.Current.Request.Cookies["admin"].Value.ToString(); //æä½äººå |
| | | mes = ProductionManagementBLL.ProductInHouseOrderSeave(username, obj); |
| | | return TJson.toJson(mes); |
| | | } |
| | | #endregion |
| | | } |
| | | } |
| | |
| | | } |
| | | #endregion |
| | | |
| | | #region[è·åè§åçæçç¼ç ] |
| | | #region[è·åè§åçæçç¼ç (åºå®)] |
| | | /// <summary> |
| | | /// è·åè§åçæçç¼ç |
| | | /// </summary> |
| | |
| | | #endregion |
| | | |
| | | |
| | | #region[çæç³»ç»æ¡ç (èªå®ä¹)] |
| | | /// <summary> |
| | | /// çæç³»ç»æ¡ç (èªå®ä¹) |
| | | /// </summary> |
| | | /// <param name="rightcode">åè½ç¼ç </param> |
| | | /// <param name="partcode">ç©æç¼ç </param> |
| | | /// <param name="qty">æ°é</param> |
| | | /// <param name="onelabqty">åæ ç¾æ°é</param> |
| | | /// <returns></returns> |
| | | [Route(template: "LabelBarCode")] |
| | | [HttpGet] |
| | | public HttpResponseMessage LabelBarCode(string rightcode, string partcode, string qty, string onelabqty) |
| | | { |
| | | mes = SystemSettingBLL.LabelBarCode(rightcode, partcode, qty, onelabqty); |
| | | return TJson.toJson(mes); |
| | | } |
| | | #endregion |
| | | |
| | | |
| | | #region[车é´å
¬åå表] |
| | | /// <summary> |
| | |
| | | return BaseDateDAL.InventorySelect(param); |
| | | } |
| | | #endregion |
| | | |
| | | |
| | | |
| | | #region[ERPç产车é´/é¨é¨ä¿¡æ¯æ¥è¯¢] |
| | | public static ToMessage ErpWkshopDepartmentSelect() |
| | | { |
| | | return BaseDateDAL.ErpWkshopDepartmentSelect(); |
| | | } |
| | | #endregion |
| | | |
| | | #region[ERPçä»åºä¿¡æ¯æ¥è¯¢] |
| | | public static ToMessage ErpWarehouseSelect() |
| | | { |
| | | return BaseDateDAL.ErpWarehouseSelect(); |
| | | } |
| | | #endregion |
| | | |
| | | #region[ERPçç¨æ·ä¿¡æ¯æ¥è¯¢] |
| | | public static ToMessage ErpUserSelect() |
| | | { |
| | | return BaseDateDAL.ErpUserSelect(); |
| | | } |
| | | #endregion |
| | | } |
| | | } |
| | |
| | | using System; |
| | | using Newtonsoft.Json.Linq; |
| | | using System; |
| | | using System.Collections.Generic; |
| | | using System.Data; |
| | | using System.Linq; |
| | |
| | | #endregion |
| | | |
| | | #region[çäº§å¼æ¥å·¥,æ¥å·¥æäº¤] |
| | | public static ToMessage SavaMesOrderStepReport(string mesordercode, string partcode, string stepseq, string stepcode, string eqpcode,string reckway, string usergroupcode, string reportuser, string taskqty,string startqty, string reportqty,string ngqty, string badcode,string remarks, string username) |
| | | public static ToMessage SavaMesOrderStepReport(string mesordercode, string partcode, string stepseq, string stepcode, string eqpcode,string inbarcode, string reckway, string usergroupcode, string reportuser, string taskqty,string startqty, string reportqty,string ngqty, string badcode,string remarks, string username) |
| | | { |
| | | return ProductionManagementDAL.SavaMesOrderStepReport(mesordercode, partcode, stepseq, stepcode, eqpcode, reckway,usergroupcode, reportuser, taskqty, startqty, reportqty, ngqty, badcode, remarks, username); |
| | | return ProductionManagementDAL.SavaMesOrderStepReport(mesordercode, partcode, stepseq, stepcode, eqpcode, inbarcode, reckway,usergroupcode, reportuser, taskqty, startqty, reportqty, ngqty, badcode, remarks, username); |
| | | } |
| | | #endregion |
| | | |
| | |
| | | #endregion |
| | | |
| | | #region[çäº§å¼æ¥å·¥, æ¶ææäº¤] |
| | | public static ToMessage SavaMesOrderStepIn(string mesordercode, string partcode, string stepseq, string stepcode, string wxcode, string inuser, string taskqty, string sqty, string ngqty, string badcode,string remarks, string username) |
| | | public static ToMessage SavaMesOrderStepIn(string mesordercode, string partcode, string stepseq, string stepcode, string wxcode,string inbarcode, string inuser, string taskqty, string sqty, string ngqty, string badcode,string remarks, string username) |
| | | { |
| | | return ProductionManagementDAL.SavaMesOrderStepIn(mesordercode, partcode, stepseq, stepcode, wxcode, inuser, taskqty, sqty, ngqty, badcode, remarks, username); |
| | | return ProductionManagementDAL.SavaMesOrderStepIn(mesordercode, partcode, stepseq, stepcode, wxcode, inbarcode, inuser, taskqty, sqty, ngqty, badcode, remarks, username); |
| | | } |
| | | #endregion |
| | | |
| | |
| | | } |
| | | #endregion |
| | | |
| | | |
| | | #region[ç产å
¥åºæ¡ç è¡¥æ] |
| | | public static ToMessage ProductInHouseLabCode(string ordercode) |
| | | { |
| | | return ProductionManagementDAL.ProductInHouseLabCode(ordercode); |
| | | } |
| | | #endregion |
| | | |
| | | #region[ç产å
¥åºéè¿è½¦é´æ¥æ¾ç产订å] |
| | | public static ToMessage ProductInHouseWkshopOrder(string ordertype, string wkshopcode) |
| | | { |
| | | return ProductionManagementDAL.ProductInHouseWkshopOrder(ordertype, wkshopcode); |
| | | } |
| | | #endregion |
| | | |
| | | #region[ç产å
¥åºä¿¡æ¯æ¥è¯¢] |
| | | public static ToMessage ProductInHouseOrderSearch(string wkshopcode,string erpordercode, string mesordercode, string partcode, string partname, string partspec, string startorderdate, string endorderdate) |
| | | { |
| | | return ProductionManagementDAL.ProductInHouseOrderSearch(wkshopcode,erpordercode, mesordercode, partcode, partname, partspec, startorderdate, endorderdate); |
| | | } |
| | | #endregion |
| | | |
| | | #region[ç产å
¥åºè·ååæ®å·] |
| | | public static ToMessage ProductInHouseOrderCodeSearch(string rightcode) |
| | | { |
| | | return ProductionManagementDAL.ProductInHouseOrderCodeSearch(rightcode); |
| | | } |
| | | #endregion |
| | | |
| | | #region[ç产å
¥åºæäº¤] |
| | | public static ToMessage ProductInHouseOrderSeave(string username, JObject obj) |
| | | { |
| | | return ProductionManagementDAL.ProductInHouseOrderSeave(username, obj); |
| | | } |
| | | #endregion |
| | | |
| | | } |
| | | } |
| | |
| | | #endregion |
| | | |
| | | |
| | | #region[çæç³»ç»æ¡ç (èªå®ä¹)] |
| | | public static ToMessage LabelBarCode(string rightcode, string partcode, string qty, string onelabqty) |
| | | { |
| | | return SystemSettingDAL.LabelBarCode(rightcode,partcode,qty,onelabqty); |
| | | } |
| | | #endregion |
| | | |
| | | |
| | | #region[车é´å
¬åå表] |
| | | public static ToMessage SystemAnnouncementSearch(string wkspcode, string ancetitle, string ancecont, string cancel, string level, int startNum, int endNum, string prop, string order) |
| | | { |
| | |
| | | hbillno = djwo, |
| | | hbilltype = "1103", //éè´å°è´§åç±»å |
| | | hbarcode = json[i].children[j].labcode, |
| | | qualitystatus= json[i].hischeck=="Y"? "TS" : "CS", |
| | | qualitystatus = json[i].hischeck == "Y" ? "TS" : "CS", |
| | | hbarcodestatus = "Y", |
| | | hbarcodetype = "P", |
| | | hmaterialcode = json[i].children[j].partnumber, |
| | |
| | | string labcode = "";//æ ç¾ä¿¡æ¯ |
| | | decimal suminqty = 0; //åæ ç¾å
¥åºæ»æ°é |
| | | string batchno = ""; //æ¹æ¬¡å· |
| | | |
| | | |
| | | //æ¥è¯¢æ±æ»æ ç¾ä¿¡æ¯ |
| | | for (int j = 0; j < arra[i]["labcont"].Count(); j++)//循ç¯è·åæ ç¾ä¿¡æ¯ |
| | | { |
| | |
| | | hinqty = decimal.Parse(arra[i]["labcont"][j]["qty"].ToString()) |
| | | } |
| | | }); |
| | | labcode = labcode + arra[i]["labcont"][j]["labcode"].ToString() + ","; |
| | | |
| | | //åå
¥åºå表 |
| | | sql = @"insert into TK_WMS_Stock(labcode,materiel_code,batchno,storehouse_code,location_code,customercode,qty,lm_user,lm_date) |
| | | values(@labcode,materiel_code,batchno,storehouse_code,location_code,customercode,qty,lm_user,lm_date)"; |
| | | list.Add(new |
| | | { |
| | | str = sql, |
| | | parm = new |
| | | { |
| | | labcode = arra[i]["labcont"][j]["labcode"].ToString(), |
| | | materiel_code = arra[i]["partcode"].ToString(), |
| | | batchno = batchno, |
| | | storehouse_code = arra[i]["storehousecode"].ToString(), |
| | | location_code = arra[i]["warehousecode"].ToString(), |
| | | customercode = arra[i]["customercode"].ToString(), |
| | | qty = suminqty, |
| | | lm_user = username, |
| | | lm_date = datetime, |
| | | } |
| | | }); |
| | | |
| | | |
| | | //labcode = labcode + arra[i]["labcont"][j]["labcode"].ToString() + ","; |
| | | suminqty = suminqty + decimal.Parse(arra[i]["labcont"][j]["qty"].ToString()); |
| | | partlabqty = partlabqty + decimal.Parse(arra[i]["labcont"][j]["qty"].ToString()); |
| | | batchno = arra[i]["labcont"][j]["batch"].ToString(); |
| | | |
| | | } |
| | | |
| | | //æ´æ°éè´è®¢åå表å
¥åºæ°é |
| | |
| | | }); |
| | | |
| | | //åå
¥éè´å
¥åºåå表 |
| | | sql = @"insert into TK_WMS_Inwh_Sub(hbillno,labcode,rownumber,materiel_code,storehouse_code,location_code,qty,batchno) |
| | | values(@hbillno,@labcode,@rownumber,@materiel_code,@storehouse_code,@location_code,@qty,@batchno)"; |
| | | labcode = string.Format("'{0}'", labcode.Substring(0, labcode.Length - 1).Replace(",", "','")); |
| | | sql = @"insert into TK_WMS_Inwh_Sub(hbillno,rownumber,materiel_code,storehouse_code,location_code,qty,batchno) |
| | | values(@hbillno,@rownumber,@materiel_code,@storehouse_code,@location_code,@qty,@batchno)"; |
| | | //labcode = string.Format("'{0}'", labcode.Substring(0, labcode.Length - 1).Replace(",", "','")); |
| | | list.Add(new |
| | | { |
| | | str = sql, |
| | |
| | | batchno = batchno |
| | | } |
| | | }); |
| | | //åå
¥åºåè¡¨åæ¥è¯¢å½åç©æå¨åºåè¡¨ä¸æ¯å¦åå¨,åå
¥ææ´æ°åºå表 |
| | | sql = @"select * from TK_WMS_Stock where materiel_code=@materiel_code"; |
| | | dynamicParams.Add("@materiel_code", arra[i]["partcode"].ToString()); |
| | | var data1 = DapperHelper.selectdata(sql, dynamicParams); |
| | | if (data1.Rows.Count > 0) |
| | | { |
| | | sql = @"update TK_WMS_Stock set qty=qty+@suminqty |
| | | where materiel_code=@materiel_code"; |
| | | list.Add(new |
| | | { |
| | | str = sql, |
| | | parm = new |
| | | { |
| | | materiel_code = arra[i]["partcode"].ToString(), |
| | | suminqty = suminqty |
| | | } |
| | | }); |
| | | } |
| | | else |
| | | { |
| | | sql = @"insert into TK_WMS_Stock(materiel_code,batchno,storehouse_code,location_code,customercode,qty,lm_user,lm_date) |
| | | values(materiel_code,batchno,storehouse_code,location_code,customercode,qty,lm_user,lm_date)"; |
| | | list.Add(new |
| | | { |
| | | str = sql, |
| | | parm = new |
| | | { |
| | | materiel_code = arra[i]["partcode"].ToString(), |
| | | batchno = batchno, |
| | | storehouse_code= arra[i]["storehousecode"].ToString(), |
| | | location_code= arra[i]["warehousecode"].ToString(), |
| | | customercode= arra[i]["customercode"].ToString(), |
| | | qty= suminqty, |
| | | lm_user=username, |
| | | lm_date= datetime, |
| | | } |
| | | }); |
| | | } |
| | | |
| | | /*åå
¥ERPéè´å
¥åºå************ |
| | | * *********************** |
| | | * ********************** |
| | |
| | | str = sql, |
| | | parm = new |
| | | { |
| | | orderdate= datetime, |
| | | ordercode= djwo, |
| | | status="NEW", |
| | | departmentcode= arra[0]["departmentcode"].ToString(), |
| | | customercode= arra[0]["customercode"].ToString(), |
| | | saleorderid= orderid, |
| | | saleordercode=ordercode, |
| | | lm_user= username, |
| | | lm_date= datetime |
| | | orderdate = datetime, |
| | | ordercode = djwo, |
| | | status = "NEW", |
| | | departmentcode = arra[0]["departmentcode"].ToString(), |
| | | customercode = arra[0]["customercode"].ToString(), |
| | | saleorderid = orderid, |
| | | saleordercode = ordercode, |
| | | lm_user = username, |
| | | lm_date = datetime |
| | | } |
| | | }); |
| | | //æ ¹æ®æºå+ç©ææ¥è¯¢éè´è®¢åå°è´§æ»æ°ãå
¥åºæ»æ° |
| | |
| | | str = sql, |
| | | parm = new |
| | | { |
| | | hbarcodestatus="N", |
| | | hbarcodestatus = "N", |
| | | hsourcebillno = ordercode, |
| | | hbarcode = arra[i]["labcont"][j]["labcode"].ToString() |
| | | } |
| | |
| | | hinqty = decimal.Parse(arra[i]["labcont"][j]["qty"].ToString()) |
| | | } |
| | | }); |
| | | |
| | | //æ´æ°åºå表 |
| | | sql = @"update TK_WMS_Stock set qty=qty-@inqty |
| | | where materiel_code=@materiel_code and labcode=@labcode"; |
| | | list.Add(new |
| | | { |
| | | str = sql, |
| | | parm = new |
| | | { |
| | | labcode = arra[i]["labcont"][j]["labcode"].ToString(), |
| | | materiel_code = arra[i]["partcode"].ToString(), |
| | | inqty = decimal.Parse(arra[i]["labcont"][j]["qty"].ToString()) |
| | | } |
| | | }); |
| | | |
| | | labcode = labcode + arra[i]["labcont"][j]["labcode"].ToString() + ","; |
| | | suminqty = suminqty + decimal.Parse(arra[i]["labcont"][j]["qty"].ToString()); |
| | | partlabqty = partlabqty + decimal.Parse(arra[i]["labcont"][j]["qty"].ToString()); |
| | |
| | | batchno = batchno |
| | | } |
| | | }); |
| | | //åå
¥åºåè¡¨åæ¥è¯¢å½åç©æå¨åºåè¡¨ä¸æ¯å¦åå¨,åå
¥ææ´æ°åºå表 |
| | | sql = @"select * from TK_WMS_Stock where materiel_code=@materiel_code"; |
| | | dynamicParams.Add("@materiel_code", arra[i]["partcode"].ToString()); |
| | | var data1 = DapperHelper.selectdata(sql, dynamicParams); |
| | | if (data1.Rows.Count > 0) |
| | | { |
| | | sql = @"update TK_WMS_Stock set qty=qty-@suminqty |
| | | where materiel_code=@materiel_code"; |
| | | list.Add(new |
| | | { |
| | | str = sql, |
| | | parm = new |
| | | { |
| | | materiel_code = arra[i]["partcode"].ToString(), |
| | | suminqty = suminqty |
| | | } |
| | | }); |
| | | } |
| | | /*åå
¥ERPéè´éè´§å************ |
| | | * *********************** |
| | | * ********************** |
| | |
| | | return mes; |
| | | } |
| | | #endregion |
| | | |
| | | |
| | | |
| | | #region[ERPç产车é´/é¨é¨ä¿¡æ¯æ¥è¯¢] |
| | | public static ToMessage ErpWkshopDepartmentSelect() |
| | | { |
| | | string sql = ""; |
| | | try |
| | | { |
| | | //åå¨è¿ç¨å |
| | | sql = @"h_p_BASIC_Wkshop_Department"; |
| | | var data = DapperHelper.lissql(sql); |
| | | if (data.Rows.Count > 0) |
| | | { |
| | | mes.code = "200"; |
| | | mes.Message = "æ¥è¯¢æå!"; |
| | | mes.data = data; |
| | | } |
| | | else |
| | | { |
| | | mes.code = "300"; |
| | | mes.count = 0; |
| | | mes.Message = "erpç³»ç»ä¸æªç»´æ¤æ¤ä¿¡æ¯!"; |
| | | mes.data = null; |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | mes.code = "300"; |
| | | mes.count = 0; |
| | | mes.Message = e.Message; |
| | | mes.data = null; |
| | | } |
| | | return mes; |
| | | } |
| | | #endregion |
| | | |
| | | #region[ERPçä»åºä¿¡æ¯æ¥è¯¢] |
| | | public static ToMessage ErpWarehouseSelect() |
| | | { |
| | | string sql = ""; |
| | | try |
| | | { |
| | | //åå¨è¿ç¨å |
| | | sql = @"h_p_BASIC_Warehouse"; |
| | | var data = DapperHelper.lissql(sql); |
| | | if (data.Rows.Count > 0) |
| | | { |
| | | mes.code = "200"; |
| | | mes.Message = "æ¥è¯¢æå!"; |
| | | mes.data = data; |
| | | } |
| | | else |
| | | { |
| | | mes.code = "300"; |
| | | mes.count = 0; |
| | | mes.Message = "erpç³»ç»ä¸æªç»´æ¤æ¤ä¿¡æ¯!"; |
| | | mes.data = null; |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | mes.code = "300"; |
| | | mes.count = 0; |
| | | mes.Message = e.Message; |
| | | mes.data = null; |
| | | } |
| | | return mes; |
| | | } |
| | | #endregion |
| | | |
| | | #region[ERPçç¨æ·ä¿¡æ¯æ¥è¯¢] |
| | | public static ToMessage ErpUserSelect() |
| | | { |
| | | string sql = ""; |
| | | try |
| | | { |
| | | //åå¨è¿ç¨å |
| | | sql = @"h_p_BASIC_User"; |
| | | var data = DapperHelper.lissql(sql); |
| | | if (data.Rows.Count > 0) |
| | | { |
| | | mes.code = "200"; |
| | | mes.Message = "æ¥è¯¢æå!"; |
| | | mes.data = data; |
| | | } |
| | | else |
| | | { |
| | | mes.code = "300"; |
| | | mes.count = 0; |
| | | mes.Message = "erpç³»ç»ä¸æªç»´æ¤æ¤ä¿¡æ¯!"; |
| | | mes.data = null; |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | mes.code = "300"; |
| | | mes.count = 0; |
| | | mes.Message = e.Message; |
| | | mes.data = null; |
| | | } |
| | | return mes; |
| | | } |
| | | #endregion |
| | | } |
| | | } |
| | |
| | | }).ToList(); |
| | | for (int i = 0; i < data.Count; i++) |
| | | { |
| | | sql = @"select distinct mu.right_code as code,mu.right_name as name,mu.right_seq,mu.is_delete as flag,imgurl |
| | | sql = @"select * from( |
| | | select distinct mu.right_code as code,mu.right_name as name,mu.right_seq,mu.is_delete as flag,imgurl |
| | | from TRight mu |
| | | inner join TRoleRightRelation rl on mu.right_code=rl.right_code |
| | | inner join TUserRoleRelation ro on rl.role_code=ro.role_code |
| | | where mu.type=@usertype and ro.user_code=@usercode and mu.parent_id=@paent_id |
| | | order by mu.right_seq, mu.right_code"; |
| | | ) as AA order by CAST(AA.right_seq AS DECIMAL) ASC,AA.code"; |
| | | dynamicParams.Add("@usercode", usercode); |
| | | dynamicParams.Add("@usertype", usertype); |
| | | dynamicParams.Add("@paent_id", data[i].code); |
| | |
| | | try |
| | | { |
| | | //è·å设å¤ç±»åæ°æ® |
| | | sql = @"select code,name from T_Sec_Stck where is_delete<>'1'"; |
| | | sql = @"select erp_id, code,name from T_Sec_Stck where is_delete<>'1'"; |
| | | var data = DapperHelper.selecttable(sql); |
| | | mes.code = "200"; |
| | | mes.Message = "æ¥è¯¢æå!"; |
| | |
| | | } |
| | | //æ ¹æ®æ¡ä»¶æ¥è¯¢å·¥åå·¥åºä»»å¡(èªå¶å·¥åº) |
| | | sql = @"select A.status,A.wo_code,B.route_code,M.partcode,M.partname,M.partspec,A.seq,A.isbott,A.isend, |
| | | S.stepcode,S.stepname,S.descr,A.plan_qty,A.good_qty,A.ng_qty,A.bad_qty,A.plan_startdate,A.plan_enddate |
| | | S.stepcode,S.stepname,S.descr,A.plan_qty,A.good_qty,A.ng_qty,A.bad_qty,A.plan_startdate,A.plan_enddate,B.lm_date |
| | | from TK_Wrk_Step A |
| | | left join TK_Wrk_Man B on A.wo_code=B.wo_code |
| | | left join TMateriel_Info M on B.materiel_code=M.partcode |
| | |
| | | } |
| | | //æ ¹æ®æ¡ä»¶æ¥è¯¢å·¥åå·¥åºä»»å¡(èªå¶å·¥åº) |
| | | sql = @"select A.status,A.wo_code,B.route_code,M.partcode,M.partname,M.partspec,A.seq,A.isbott,A.isend, |
| | | S.stepcode,S.stepname,S.descr,A.plan_qty,A.good_qty,A.ng_qty,A.bad_qty,A.plan_startdate,A.plan_enddate |
| | | S.stepcode,S.stepname,S.descr,A.plan_qty,A.good_qty,A.ng_qty,A.bad_qty,A.plan_startdate,A.plan_enddate,B.lm_date |
| | | from TK_Wrk_Step A |
| | | left join TK_Wrk_Man B on A.wo_code=B.wo_code |
| | | left join TMateriel_Info M on B.materiel_code=M.partcode |
| | |
| | | } |
| | | //æ ¹æ®æ¡ä»¶æ¥è¯¢å·¥åå·¥åºä»»å¡,ä¸ä¸è¯æ°é大äº0 |
| | | sql = @"select A.wo_code,M.partcode,M.partname,M.partspec,A.seq,A.isend, |
| | | S.stepcode,S.stepname,S.descr,A.plan_qty,A.good_qty,A.ng_qty,A.bad_qty |
| | | S.stepcode,S.stepname,S.descr,A.plan_qty,A.good_qty,A.ng_qty,A.bad_qty,B.lm_date |
| | | from TK_Wrk_Step A |
| | | left join TK_Wrk_Man B on A.wo_code=B.wo_code |
| | | left join TMateriel_Info M on B.materiel_code=M.partcode |
| | |
| | | #endregion |
| | | |
| | | #region[çäº§å¼æ¥å·¥,æ¥å·¥æäº¤] |
| | | public static ToMessage SavaMesOrderStepReport(string mesordercode, string partcode, string stepseq, string stepcode, string eqpcode, string reckway, string usergroupcode, string reportuser, string taskqty, string startqty, string reportqty, string ngqty, string badcode, string remarks, string username) |
| | | public static ToMessage SavaMesOrderStepReport(string mesordercode, string partcode, string stepseq, string stepcode, string eqpcode, string inbarcode, string reckway, string usergroupcode, string reportuser, string taskqty, string startqty, string reportqty, string ngqty, string badcode, string remarks, string username) |
| | | { |
| | | var sql = ""; |
| | | //string[] arra = new string[] { }; |
| | |
| | | sql = @"select ISNULL(IDENT_CURRENT('TK_Wrk_Record')+1,1) as id"; |
| | | var dt = DapperHelper.selecttable(sql); |
| | | //åå
¥å¼æ¥å·¥è®°å½è¡¨ |
| | | sql = @"insert into TK_Wrk_Record(wo_code,step_seq,step_code,eqp_code,materiel_code,task_qty,start_qty,good_qty,ng_qty,style,lm_user,lm_date) |
| | | values(@mesordercode,@stepseq,@stepcode,@eqpcode,@partcode,@taskqty,@startqty,@reportqty,@ngqty,@style,@lm_user,@lm_date)"; |
| | | list.Add(new { str = sql, parm = new { mesordercode = mesordercode, stepseq = stepseq, stepcode = stepcode, eqpcode = eqpcode, partcode = partcode, taskqty = taskqty, startqty = startqty, reportqty = reportqty, ngqty = ngqty, style = "B", lm_user = username, lm_date = date } }); |
| | | sql = @"insert into TK_Wrk_Record(wo_code,step_seq,step_code,eqp_code,materiel_code,task_qty,start_qty,good_qty,ng_qty,style,lm_user,lm_date,inbarcode) |
| | | values(@mesordercode,@stepseq,@stepcode,@eqpcode,@partcode,@taskqty,@startqty,@reportqty,@ngqty,@style,@lm_user,@lm_date,@inbarcode)"; |
| | | list.Add(new { str = sql, parm = new { mesordercode = mesordercode, stepseq = stepseq, stepcode = stepcode, eqpcode = eqpcode, partcode = partcode, taskqty = taskqty, startqty = startqty, reportqty = reportqty, ngqty = ngqty, style = "B", lm_user = username, lm_date = date, inbarcode = inbarcode } }); |
| | | |
| | | //åå
¥å表 |
| | | for (int i = 0; i < arra.Count; i++) |
| | |
| | | sql = @"select ISNULL(IDENT_CURRENT('TK_Wrk_Record')+1,1) as id"; |
| | | var dt = DapperHelper.selecttable(sql); |
| | | //åå
¥å¼æ¥å·¥è®°å½è¡¨ |
| | | sql = @"insert into TK_Wrk_Record(wo_code,step_seq,step_code,eqp_code,materiel_code,task_qty,start_qty,good_qty,ng_qty,style,lm_user,lm_date) |
| | | values(@mesordercode,@stepseq,@stepcode,@eqpcode,@partcode,@taskqty,@startqty,@reportqty,@ngqty,@style,@lm_user,@lm_date)"; |
| | | list.Add(new { str = sql, parm = new { mesordercode = mesordercode, stepseq = stepseq, stepcode = stepcode, eqpcode = eqpcode, partcode = partcode, taskqty = taskqty, startqty = startqty, reportqty = reportqty, ngqty = ngqty, style = "B", lm_user = username, lm_date = date } }); |
| | | sql = @"insert into TK_Wrk_Record(wo_code,step_seq,step_code,eqp_code,materiel_code,task_qty,start_qty,good_qty,ng_qty,style,lm_user,lm_date,inbarcode) |
| | | values(@mesordercode,@stepseq,@stepcode,@eqpcode,@partcode,@taskqty,@startqty,@reportqty,@ngqty,@style,@lm_user,@lm_date,@inbarcode)"; |
| | | list.Add(new { str = sql, parm = new { mesordercode = mesordercode, stepseq = stepseq, stepcode = stepcode, eqpcode = eqpcode, partcode = partcode, taskqty = taskqty, startqty = startqty, reportqty = reportqty, ngqty = ngqty, style = "B", lm_user = username, lm_date = date, inbarcode = inbarcode } }); |
| | | |
| | | //åå
¥å表 |
| | | for (int i = 0; i < arra.Count; i++) |
| | |
| | | #endregion |
| | | |
| | | #region[çäº§å¼æ¥å·¥, æ¶ææäº¤] |
| | | public static ToMessage SavaMesOrderStepIn(string mesordercode, string partcode, string stepseq, string stepcode, string wxcode, string inuser, string taskqty, string sqty, string ngqty, string badcode, string remarks, string username) |
| | | public static ToMessage SavaMesOrderStepIn(string mesordercode, string partcode, string stepseq, string stepcode, string wxcode, string inbarcode, string inuser, string taskqty, string sqty, string ngqty, string badcode, string remarks, string username) |
| | | { |
| | | var sql = ""; |
| | | string[] arra1 = new string[] { }; |
| | |
| | | sql = @"select ISNULL(IDENT_CURRENT('TK_Wrk_OutRecord')+1,1) as id"; |
| | | var dt = DapperHelper.selecttable(sql); |
| | | //åå
¥å¤åè®°å½ä¸»è¡¨ |
| | | sql = @"insert into TK_Wrk_OutRecord(wo_code,step_seq,step_code,wx_code,materiel_code,style,sqty,ng_qty,lm_user,lm_date) |
| | | values(@mesordercode,@stepseq,@stepcode,@wx_code,@partcode,@style,@sqty,@ngqty,@lm_user,@lm_date)"; |
| | | list.Add(new { str = sql, parm = new { mesordercode = mesordercode, stepseq = stepseq, stepcode = stepcode, wx_code = wxcode, partcode = partcode, style = 'S', sqty = sqty, ngqty = ngqty, lm_user = username, lm_date = date } }); |
| | | sql = @"insert into TK_Wrk_OutRecord(wo_code,step_seq,step_code,wx_code,materiel_code,style,sqty,ng_qty,lm_user,lm_date,inbarcode) |
| | | values(@mesordercode,@stepseq,@stepcode,@wx_code,@partcode,@style,@sqty,@ngqty,@lm_user,@lm_date,@inbarcode)"; |
| | | list.Add(new { str = sql, parm = new { mesordercode = mesordercode, stepseq = stepseq, stepcode = stepcode, wx_code = wxcode, partcode = partcode, style = 'S', sqty = sqty, ngqty = ngqty, lm_user = username, lm_date = date, inbarcode = inbarcode } }); |
| | | |
| | | //åå
¥å¤åè®°å½å表 |
| | | sql = @"insert into TK_Wrk_OutRecordSub(m_id,wx_code,in_person,in_time,sqty,ng_qty,style,lm_user,lm_date) |
| | |
| | | sql = @"select ISNULL(IDENT_CURRENT('TK_Wrk_OutRecord')+1,1) as id"; |
| | | var dt = DapperHelper.selecttable(sql); |
| | | //åå
¥å¤åè®°å½ä¸»è¡¨ |
| | | sql = @"insert into TK_Wrk_OutRecord(wo_code,step_seq,step_code,wx_code,materiel_code,style,sqty,ng_qty,lm_user,lm_date) |
| | | values(@mesordercode,@stepseq,@stepcode,@wx_code,@partcode,@style,@sqty,@ngqty,@lm_user,@lm_date)"; |
| | | list.Add(new { str = sql, parm = new { mesordercode = mesordercode, stepseq = stepseq, stepcode = stepcode, wx_code = wxcode, partcode = partcode, style = 'S', sqty = sqty, ngqty = ngqty, lm_user = username, lm_date = date } }); |
| | | sql = @"insert into TK_Wrk_OutRecord(wo_code,step_seq,step_code,wx_code,materiel_code,style,sqty,ng_qty,lm_user,lm_date,inbarcode) |
| | | values(@mesordercode,@stepseq,@stepcode,@wx_code,@partcode,@style,@sqty,@ngqty,@lm_user,@lm_date,@inbarcode)"; |
| | | list.Add(new { str = sql, parm = new { mesordercode = mesordercode, stepseq = stepseq, stepcode = stepcode, wx_code = wxcode, partcode = partcode, style = 'S', sqty = sqty, ngqty = ngqty, lm_user = username, lm_date = date, inbarcode = inbarcode } }); |
| | | |
| | | //åå
¥å¤åè®°å½å表 |
| | | sql = @"insert into TK_Wrk_OutRecordSub(m_id,wx_code,in_person,in_time,sqty,ng_qty,style,lm_user,lm_date) |
| | |
| | | //list.Add(new { str = sql, parm = new { mesordercode = mesordercode, sqty = sqty, ngqty = ngqty } }); |
| | | |
| | | ////åå
¥ERPå
¥åºå |
| | | |
| | | |
| | | //夿æ¯å¦æ«éå·¥åºå®å·¥æ¥å·¥(èªå¨å
³éå·¥ååå·¥åºä»»å¡) |
| | | //list = AutosCloseOrder.AutosColseOrderReport(list, mesordercode, partcode, stepseq, stepcode, sqty, ngqty); |
| | | |
| | |
| | | |
| | | //åå
¥æ£éªè®°å½ä¸»è¡¨ |
| | | sql = @"insert into TStepCheckRecord(wo_code,partcode,step_code,checkstaned_code,check_user,check_type,check_typename,sampmethod,check_result,check_qty,good_qty,ng_qty,lm_user,lm_date) |
| | | values(@wo_code,@partcode,@checkstaned_code,@check_user,@check_type,@check_typename,@sampmethod,@check_result,@check_qty,@good_qty,@ng_qty,@lm_user,@lm_date)"; |
| | | values(@wo_code,@partcode,@step_code,@checkstaned_code,@check_user,@check_type,@check_typename,@sampmethod,@check_result,@check_qty,@good_qty,@ng_qty,@lm_user,@lm_date)"; |
| | | switch (check_type) |
| | | { |
| | | case "FirstCheck": |
| | |
| | | { |
| | | wo_code = wocode, |
| | | partcode = partcode, |
| | | step_code=stepcode, |
| | | step_code = stepcode, |
| | | checkstaned_code = checkstandcode, |
| | | check_user = username, |
| | | check_type = check_type, |
| | |
| | | lm_date = datetime |
| | | } |
| | | }); |
| | | sql = @"select ISNULL(IDENT_CURRENT('TStepCheckRecord')+1,1) as id"; |
| | | var dt = DapperHelper.selecttable(sql); |
| | | //åå
¥æ£éªè®°å½å表 |
| | | for (int j = 0; j < arra.Count; j++) |
| | | { |
| | | sql = @"insert into TStepCheckRecordSub(m_id,checknum,checkitem_seq,checkitem_code,checkitem_name,checkitem_descr,check_value,check_result,lm_user,lm_date) |
| | | values(@m_id,@checknum,@checkiem_seq,@checkitem_code,@checkitem_name,@checkitem_descr,@check_value,@check_result,@lm_user,@lm_date)"; |
| | | values(CONVERT(INT,IDENT_CURRENT('TStepCheckRecord')),@checknum,@checkiem_seq,@checkitem_code,@checkitem_name,@checkitem_descr,@check_value,@check_result,@lm_user,@lm_date)"; |
| | | list.Add(new |
| | | { |
| | | str = sql, |
| | | parm = new |
| | | { |
| | | m_id = int.Parse(dt.Rows[0]["ID"].ToString()), |
| | | checknum = arra[j]["checknum"].ToString(), |
| | | checkiem_seq = arra[j]["checkiem_seq"].ToString(), |
| | | checkitem_code = arra[j]["checkitem_code"].ToString(), |
| | |
| | | } |
| | | #endregion |
| | | |
| | | |
| | | |
| | | #region[ç产å
¥åºæ¡ç è¡¥æ] |
| | | public static ToMessage ProductInHouseLabCode(string ordercode) |
| | | { |
| | | string sql = ""; |
| | | var dynamicParams = new DynamicParameters(); |
| | | try |
| | | { |
| | | //è·åæ«éå·¥åºæ¥å·¥æ¡ç æ°æ® |
| | | sql = @"select * from( |
| | | select A.inbarcode,A.wo_code,P.partcode,P.partname,P.partspec, |
| | | A.good_qty,U.username,A.lm_date |
| | | from TK_Wrk_Record A |
| | | inner join TK_Wrk_Step S on A.wo_code=S.wo_code and A.step_code=S.step_code |
| | | inner join TMateriel_Info P on A.materiel_code=P.partcode |
| | | inner join TUser U on A.lm_user=U.usercode |
| | | where A.style='B' and S.isend='Y' and A.good_qty>0 |
| | | union all |
| | | select A.inbarcode,A.wo_code,P.partcode,P.partname,P.partspec, |
| | | A.sqty as sqty,U.username,A.lm_date |
| | | from TK_Wrk_OutRecord A |
| | | inner join TK_Wrk_Step S on A.wo_code=S.wo_code and A.step_code=S.step_code |
| | | inner join TMateriel_Info P on A.materiel_code=P.partcode |
| | | inner join TUser U on A.lm_user=U.usercode |
| | | where A.style='S' and S.isend='Y' and A.sqty>0 |
| | | ) as AA where AA.wo_code=@ordercode"; |
| | | dynamicParams.Add("@ordercode", ordercode); |
| | | var data = DapperHelper.selectdata(sql, dynamicParams); |
| | | mes.code = "200"; |
| | | mes.Message = "æ¥è¯¢æå!"; |
| | | mes.data = data; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | mes.code = "300"; |
| | | mes.count = 0; |
| | | mes.Message = e.Message; |
| | | mes.data = null; |
| | | } |
| | | return mes; |
| | | } |
| | | #endregion |
| | | |
| | | #region[ç产å
¥åºéè¿è½¦é´æ¥æ¾ç产订å] |
| | | public static ToMessage ProductInHouseWkshopOrder(string ordertype, string wkshopcode) |
| | | { |
| | | string sql = ""; |
| | | var dynamicParams = new DynamicParameters(); |
| | | try |
| | | { |
| | | if (ordertype == "Y") //ææºå |
| | | { |
| | | sql = @"select distinct AA.ordercode from ( |
| | | select A.m_po as ordercode |
| | | from TK_Wrk_Man A |
| | | inner join TK_Wrk_Step B on A.wo_code=B.wo_code |
| | | inner join TK_Wrk_Record S on B.wo_code=S.wo_code and B.step_code=S.step_code |
| | | where S.style='B' and B.isend='Y' and A.m_po<>'' and S.good_qty>0 and S.good_qty>isnull(S.inhouseqty,0) and A.wkshp_code=@wkshopcode |
| | | union all |
| | | select A.m_po as ordercode |
| | | from TK_Wrk_Man A |
| | | inner join TK_Wrk_Step B on A.wo_code=B.wo_code |
| | | inner join TK_Wrk_OutRecord S on B.wo_code=S.wo_code and B.step_code=S.step_code |
| | | where S.style='S' and B.isend='Y' and A.m_po<>'' and S.sqty>0 and S.sqty>isnull(S.inhouseqty,0) and A.wkshp_code=@wkshopcode |
| | | ) as AA"; |
| | | } |
| | | if (ordertype == "N") |
| | | { |
| | | sql = @"select distinct AA.ordercode from ( |
| | | select A.wo_code as ordercode |
| | | from TK_Wrk_Man A |
| | | inner join TK_Wrk_Step B on A.wo_code=B.wo_code |
| | | inner join TK_Wrk_Record S on B.wo_code=S.wo_code and B.step_code=S.step_code |
| | | where S.style='B' and B.isend='Y' and A.m_po='' and S.good_qty>0 and S.good_qty>isnull(S.inhouseqty,0) and A.wkshp_code=@wkshopcode |
| | | union all |
| | | select A.wo_code as ordercode |
| | | from TK_Wrk_Man A |
| | | inner join TK_Wrk_Step B on A.wo_code=B.wo_code |
| | | inner join TK_Wrk_OutRecord S on B.wo_code=S.wo_code and B.step_code=S.step_code |
| | | where S.style='S' and B.isend='Y' and A.m_po='' and S.sqty>0 and S.sqty>isnull(S.inhouseqty,0) and A.wkshp_code=@wkshopcode |
| | | ) as AA"; |
| | | } |
| | | |
| | | dynamicParams.Add("@wkshopcode", wkshopcode); |
| | | var data = DapperHelper.selectdata(sql, dynamicParams); |
| | | mes.code = "200"; |
| | | mes.Message = "æ¥è¯¢æå!"; |
| | | mes.data = data; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | mes.code = "300"; |
| | | mes.count = 0; |
| | | mes.Message = e.Message; |
| | | mes.data = null; |
| | | } |
| | | return mes; |
| | | } |
| | | #endregion |
| | | |
| | | #region[ç产å
¥åºä¿¡æ¯æ¥è¯¢] |
| | | public static ToMessage ProductInHouseOrderSearch(string wkshopcode, string erpordercode, string mesordercode, string partcode, string partname, string partspec, string startorderdate, string endorderdate) |
| | | { |
| | | var dynamicParams = new DynamicParameters(); |
| | | string search = ""; |
| | | try |
| | | { |
| | | if (wkshopcode != "" && wkshopcode != null) |
| | | { |
| | | search += "and AA.wkshp_code=@wkshopcode "; |
| | | dynamicParams.Add("@wkshopcode", wkshopcode); |
| | | } |
| | | if (erpordercode != "" && erpordercode != null) |
| | | { |
| | | search += "and AA.m_po like '%'+@erpordercode+'%' "; |
| | | dynamicParams.Add("@erpordercode", erpordercode); |
| | | } |
| | | if (mesordercode != "" && mesordercode != null) |
| | | { |
| | | search += "and AA.wo_code like '%'+@mesordercode+'%' "; |
| | | dynamicParams.Add("@mesordercode", mesordercode); |
| | | } |
| | | if (partcode != "" && partcode != null) |
| | | { |
| | | search += "and AA.partcode like '%'+@partcode+'%' "; |
| | | dynamicParams.Add("@partcode", partcode); |
| | | } |
| | | if (partname != "" && partname != null) |
| | | { |
| | | search += "and AA.partname like '%'+@partname+'%' "; |
| | | dynamicParams.Add("@partname", partname); |
| | | } |
| | | if (partspec != "" && partspec != null) |
| | | { |
| | | search += "and AA.partspec like '%'+@partspec+'%' "; |
| | | dynamicParams.Add("@partspec", partspec); |
| | | } |
| | | if (startorderdate != "" && startorderdate != null) |
| | | { |
| | | search += "and AA.lm_date between @startorderdate and @endorderdate "; |
| | | dynamicParams.Add("@opencheckdate", startorderdate + " 00:00:00"); |
| | | dynamicParams.Add("@endorderdate", endorderdate + " 23:59:59"); |
| | | } |
| | | // --------------æ¥è¯¢æå®æ°æ®-------------- |
| | | var total = 0; //æ»æ¡æ° |
| | | var sql = @"select * from( |
| | | select A.inbarcode,E.saleOrderid,isnull(E.saleOrderCode,'') as saleOrderCode,E.saleOrderDetailId,E.woid as mpoid,M.m_po,E.sbid,A.wo_code,E.materiel_id,P.partcode,P.partname,P.partspec,E.unitid,E.unitcode,E.unitname, |
| | | A.step_code,E.wkshp_id,M.wkshp_code,stck_id,K.code as stockcode,k.name as stockname, |
| | | E.saleOrderqty,E.qty,M.plan_qty,A.good_qty,isnull(A.inhouseqty,0) as inhouseqty,A.good_qty-isnull(A.inhouseqty,0) as stinhouseqty,M.lm_date,A.style |
| | | from TK_Wrk_Record A |
| | | inner join TK_Wrk_Step S on A.wo_code=S.wo_code and A.step_code=S.step_code |
| | | inner join TK_Wrk_Man M on S.wo_code=M.wo_code |
| | | inner join TMateriel_Info P on M.materiel_code=P.partcode |
| | | left join TKimp_Ewo E on M.sourceid=E.id |
| | | left join T_Sec_Stck K on E.stck_code=K.code |
| | | where A.style='B' and S.isend='Y' and A.good_qty>0 |
| | | union all |
| | | select A.inbarcode,E.saleOrderid,isnull(E.saleOrderCode,'') as saleOrderCode,E.saleOrderDetailId,E.woid as mpoid,M.m_po,E.sbid,A.wo_code,E.materiel_id,P.partcode,P.partname,P.partspec,E.unitid,E.unitcode,E.unitname, |
| | | A.step_code,E.wkshp_id,M.wkshp_code,stck_id,K.code as stockcode,k.name as stockname, |
| | | E.saleOrderqty,E.qty,M.plan_qty,A.sqty as sqty,isnull(A.inhouseqty,0) as inhouseqty,A.sqty-isnull(A.inhouseqty,0) as stinhouseqty,M.lm_date,A.style |
| | | from TK_Wrk_OutRecord A |
| | | inner join TK_Wrk_Step S on A.wo_code=S.wo_code and A.step_code=S.step_code |
| | | inner join TK_Wrk_Man M on S.wo_code=M.wo_code |
| | | inner join TMateriel_Info P on M.materiel_code=P.partcode |
| | | left join TKimp_Ewo E on M.sourceid=E.id |
| | | left join T_Sec_Stck K on E.stck_code=K.code |
| | | where A.style='S' and S.isend='Y' and A.sqty>0 |
| | | ) as AA where 1=1 " + search; |
| | | var data = DapperHelper.selectdata(sql, dynamicParams); |
| | | mes.code = "200"; |
| | | mes.Message = "æ¥è¯¢æå!"; |
| | | mes.count = total; |
| | | mes.data = data; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | mes.code = "300"; |
| | | mes.count = 0; |
| | | mes.Message = e.Message; |
| | | mes.data = null; |
| | | } |
| | | return mes; |
| | | } |
| | | #endregion |
| | | |
| | | #region[ç产å
¥åºè·ååæ®å·] |
| | | public static ToMessage ProductInHouseOrderCodeSearch(string rightcode) |
| | | { |
| | | try |
| | | { |
| | | mes = SeachEncodeJob.EncodingSeach(rightcode); |
| | | return mes; |
| | | |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | mes.code = "300"; |
| | | mes.count = 0; |
| | | mes.Message = e.Message; |
| | | mes.data = null; |
| | | } |
| | | return mes; |
| | | } |
| | | #endregion |
| | | |
| | | #region[ç产å
¥åºæäº¤] |
| | | public static ToMessage ProductInHouseOrderSeave(string username, JObject obj) |
| | | { |
| | | var sql = ""; |
| | | List<object> list = new List<object>(); |
| | | var dynamicParams = new DynamicParameters(); |
| | | var dynamicParams1 = new DynamicParameters(); |
| | | try |
| | | { |
| | | string sub = obj["sub"].ToString();//æç» |
| | | string subsum = obj["subsum"].ToString();//æ±æ» |
| | | //è·åæ¥å·¥æç» |
| | | JArray sub_arra = (JArray)Newtonsoft.Json.JsonConvert.DeserializeObject(sub); |
| | | //è·åæ±æ» |
| | | JArray subsum_arra = (JArray)Newtonsoft.Json.JsonConvert.DeserializeObject(subsum); |
| | | |
| | | //ååæ¥å·¥è®°å½ä¸»è¡¨ãå·¥åå·¥åºè¡¨å·²å
¥åºæ°éãåå
¥MESåºå表 |
| | | for (int i = 0; i < sub_arra.Count; i++) |
| | | { |
| | | if (sub_arra[i]["style"].ToString() == "B") |
| | | { |
| | | //ååæ¥å·¥è®°å½ä¸»è¡¨çå
¥åºæ°é |
| | | sql = @"update TK_Wrk_Record set inhouseqty=inhouseqty+@stinhouseqty where inbarcode=@inbarcode"; |
| | | list.Add(new |
| | | { |
| | | str = sql, |
| | | parm = new |
| | | { |
| | | stinhouseqty = decimal.Parse(sub_arra[i]["stinhouseqty"].ToString()), |
| | | inbarcode = sub_arra[i]["inbarcode"].ToString() |
| | | } |
| | | }); |
| | | } |
| | | if (sub_arra[i]["style"].ToString() == "S") |
| | | { |
| | | //ååå¤åæ¶æè®°å½ä¸»è¡¨çå
¥åºæ°é |
| | | sql = @"update TK_Wrk_OutRecord set inhouseqty=inhouseqty+@stinhouseqty where inbarcode=@inbarcode"; |
| | | list.Add(new |
| | | { |
| | | str = sql, |
| | | parm = new |
| | | { |
| | | stinhouseqty = decimal.Parse(sub_arra[i]["stinhouseqty"].ToString()), |
| | | inbarcode = sub_arra[i]["inbarcode"].ToString() |
| | | } |
| | | }); |
| | | } |
| | | //ååå·¥åå·¥åºè¡¨æ«éå·¥åºå·²å
¥åºæ°é |
| | | sql = @"update TK_Wrk_Step set inhouseqty=inhouseqty+@stinhouseqty where wo_code=@wo_code and step_code=@step_code and isend='Y'"; |
| | | list.Add(new |
| | | { |
| | | str = sql, |
| | | parm = new |
| | | { |
| | | stinhouseqty = decimal.Parse(sub_arra[i]["stinhouseqty"].ToString()), |
| | | wo_code = sub_arra[i]["wo_code"].ToString(), |
| | | step_code = sub_arra[i]["step_code"].ToString() |
| | | } |
| | | }); |
| | | //åå
¥MESåºå表 |
| | | sql = @"insert into TK_WMS_Stock(labcode,materiel_code,storehouse_code,qty,lm_user,lm_date) |
| | | values(@labcode,@materiel_code,@storehouse_code,@qty,@lm_user,@lm_date)"; |
| | | list.Add(new |
| | | { |
| | | str = sql, |
| | | parm = new |
| | | { |
| | | labcode=sub_arra[i]["inbarcode"].ToString(), |
| | | materiel_code = sub_arra[i]["partcode"].ToString(), |
| | | storehouse_code = sub_arra[i]["stockcode"].ToString(), |
| | | qty =decimal.Parse(sub_arra[i]["stinhouseqty"].ToString()), |
| | | lm_user = username, |
| | | lm_date = DateTime.Now.ToString() |
| | | } |
| | | }); |
| | | } |
| | | //åMESå
¥åºè®°å½ä¸»è¡¨ |
| | | sql = @"insert into TK_WMS_Inwh_Main(docu_typecode,hbillno,hsoucenillnoid,hsoucenillno,saleorderid,saleordercode,status,wkshpcode,lm_user,lm_date) |
| | | values(@docu_typecode,@hbillno,@hsoucenillnoid,@hsoucenillno,@saleorderid,@saleordercode,@status,@wkshpcode,@lm_user,@lm_date)"; |
| | | list.Add(new |
| | | { |
| | | str = sql, |
| | | parm = new |
| | | { |
| | | docu_typecode="1202", |
| | | hbillno= obj["head"]["hbillno"].ToString(), |
| | | hsoucenillnoid= obj["head"]["sourceVoucherId"].ToString(), |
| | | hsoucenillno = obj["head"]["sourceVoucherCode"].ToString(), |
| | | saleorderid = obj["head"]["saleOrderId"].ToString(), |
| | | saleordercode = obj["head"]["saleOrderCode"].ToString(), |
| | | status = "NEW", |
| | | wkshpcode = obj["head"]["wkshpcode"].ToString(), |
| | | lm_user = username, |
| | | lm_date= DateTime.Now.ToString() |
| | | } |
| | | }); |
| | | |
| | | //è·åERPå
¥åºè¡¨sql |
| | | //DataTable dt = DapperHelper.lissql("h_p_MesInErpProductWareHous"); |
| | | //åå
¥ERPå
¥åºè®°å½ä¸»è¡¨ |
| | | //sql = @"" + dt.Rows[0]["cname"].ToString() + ""; |
| | | //list.Add(new |
| | | //{ |
| | | // str = sql, |
| | | // parm = new |
| | | // { |
| | | // code = obj["head"]["hbillno"].ToString(), |
| | | // sourceVoucherId = obj["head"]["sourceVoucherId"].ToString(), |
| | | // sourceVoucherCode = obj["head"]["sourceVoucherCode"].ToString(), |
| | | // saleOrderId = obj["head"]["saleOrderId"].ToString(), |
| | | // saleOrderCode = obj["head"]["saleOrderCode"].ToString(), |
| | | // rdDirectionFlag = obj["head"]["rdDirectionFlag"].ToString(), |
| | | // makerid = obj["head"]["makerid"].ToString(), |
| | | // maker = obj["head"]["maker"].ToString(), |
| | | // accountingyear = obj["head"]["accountingyear"].ToString(), |
| | | // VoucherYear = obj["head"]["VoucherYear"].ToString(), |
| | | // VoucherPeriod = obj["head"]["VoucherPeriod"].ToString(), |
| | | // ManufactureOrderCode = obj["head"]["ManufactureOrderCode"].ToString(), |
| | | // idbusitype = obj["head"]["idbusitype"].ToString(), |
| | | // iddepartment = obj["head"]["iddepartment"].ToString(), |
| | | // idrdstyle = obj["head"]["idrdstyle"].ToString(), |
| | | // idwarehouse = obj["head"]["idwarehouse"].ToString(), |
| | | // voucherState = obj["head"]["voucherState"].ToString(), |
| | | // idvouchertype = obj["head"]["idvouchertype"].ToString(), |
| | | // voucherdate = obj["head"]["voucherdate"].ToString(), |
| | | // madedate = obj["head"]["madedate"].ToString(), |
| | | // createdtime = obj["head"]["createdtime"].ToString(), |
| | | // DataSource = obj["head"]["DataSource"].ToString(), |
| | | |
| | | // } |
| | | //}); |
| | | //åå
¥ERPãMESå
¥åºè®°å½å表 |
| | | for (int j = 0; j < subsum_arra.Count; j++) |
| | | { |
| | | //åå
¥ERPå
¥åºè®°å½å表 |
| | | //sql = @"" + dt.Rows[1]["cname"].ToString() + ""; |
| | | //list.Add(new |
| | | //{ |
| | | // str = sql, |
| | | // parm = new |
| | | // { |
| | | // code= subsum_arra[j]["code"].ToString(), |
| | | // arrivalQuantity = subsum_arra[j]["arrivalQuantity"].ToString(), |
| | | // quantity = subsum_arra[j]["quantity"].ToString(), |
| | | // compositionQuantity = subsum_arra[j]["compositionQuantity"].ToString(), |
| | | // baseQuantity = subsum_arra[j]["baseQuantity"].ToString(), |
| | | // sourceVoucherId = subsum_arra[j]["sourceVoucherId"].ToString(), |
| | | // sourceVoucherCode = subsum_arra[j]["sourceVoucherCode"].ToString(), |
| | | // sourceVoucherDetailId = subsum_arra[j]["sourceVoucherDetailId"].ToString(), |
| | | // idsourcevouchertype = subsum_arra[j]["idsourcevouchertype"].ToString(), |
| | | // saleOrderId = subsum_arra[j]["saleOrderId"].ToString(), |
| | | // saleOrderCode = subsum_arra[j]["saleOrderCode"].ToString(), |
| | | // saleOrderDetailId = subsum_arra[j]["saleOrderDetailId"].ToString(), |
| | | // ManufactureOrderId = subsum_arra[j]["ManufactureOrderId"].ToString(), |
| | | // ManufactureOrderCode = subsum_arra[j]["ManufactureOrderCode"].ToString(), |
| | | // ManufactureOrderDetailId = subsum_arra[j]["ManufactureOrderDetailId"].ToString(), |
| | | // idbusiTypeByMergedFlow = subsum_arra[j]["idbusiTypeByMergedFlow"].ToString(), |
| | | // idinventory = subsum_arra[j]["idinventory"].ToString(), |
| | | // idbaseunit = subsum_arra[j]["idbaseunit"].ToString(), |
| | | // idunit= subsum_arra[j]["idunit"].ToString(), |
| | | // idwarehouse = subsum_arra[j]["idwarehouse"].ToString(), |
| | | // SourceVoucherIdByMergedFlow = subsum_arra[j]["SourceVoucherIdByMergedFlow"].ToString(), |
| | | // SourceVoucherCodeByMergedFlow = subsum_arra[j]["SourceVoucherCodeByMergedFlow"].ToString(), |
| | | // SourceVoucherDetailIdByMergedFlow = subsum_arra[j]["SourceVoucherDetailIdByMergedFlow"].ToString(), |
| | | // idsourceVoucherTypeByMergedFlow = subsum_arra[j]["idsourceVoucherTypeByMergedFlow"].ToString(), |
| | | // createdtime = subsum_arra[j]["createdtime"].ToString(), |
| | | // DataSource = subsum_arra[j]["DataSource"].ToString() |
| | | // } |
| | | //}); |
| | | //åå
¥MESå
¥åºè®°å½å表 |
| | | sql = @"insert into TK_WMS_Inwh_Sub(hbillno,rownumber,materiel_code,storehouse_code,qty) |
| | | values(@hbillno,@rownumber,@materiel_code,@storehouse_code,@qty)"; |
| | | list.Add(new |
| | | { |
| | | str = sql, |
| | | parm = new |
| | | { |
| | | hbillno = obj["head"]["hbillno"].ToString(), |
| | | rownumber = subsum_arra[j]["rownumber"].ToString(), |
| | | materiel_code = subsum_arra[j]["materiel_code"].ToString(), |
| | | storehouse_code = subsum_arra[j]["warehouse"].ToString(), |
| | | qty = decimal.Parse(subsum_arra[j]["quantity"].ToString()) |
| | | } |
| | | }); |
| | | } |
| | | //æ´æ°åæ®æµæ°´å· |
| | | List<object> list1 = SeachEncodeJob.StrEncodingUpdate(obj["head"]["rightcode"].ToString(), obj["head"]["incbit"].ToString()); |
| | | list.Add(list1[0]); |
| | | bool aa = DapperHelper.DoTransaction(list); |
| | | if (aa) |
| | | { |
| | | mes.code = "200"; |
| | | mes.count = 0; |
| | | mes.Message = "æä½æå!"; |
| | | mes.data = null; |
| | | } |
| | | else |
| | | { |
| | | mes.code = "300"; |
| | | mes.count = 0; |
| | | mes.Message = "æä½å¤±è´¥!"; |
| | | mes.data = null; |
| | | } |
| | | |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | mes.code = "300"; |
| | | mes.count = 0; |
| | | mes.Message = e.Message; |
| | | mes.data = null; |
| | | } |
| | | return mes; |
| | | } |
| | | #endregion |
| | | } |
| | | } |
| | |
| | | var dynamicParams = new DynamicParameters(); |
| | | try |
| | | { |
| | | sql = @"select A.checkitem_seq,A.checkitem_code,A.checkitem_name,A.checkitem_descr,A.check_result,U.username as lm_user,A.lm_date |
| | | from TStepCheckRecordSub A |
| | | left join TUser U on A.lm_user=U.usercode |
| | | where A.m_id=@id"; |
| | | dynamicParams.Add("@id", id); |
| | | var data = DapperHelper.selectdata(sql, dynamicParams); |
| | | //sql = @"select A.checkitem_seq,A.checkitem_code,A.checkitem_name,A.checkitem_descr,A.check_result,U.username as lm_user,A.lm_date |
| | | // from TStepCheckRecordSub A |
| | | // left join TUser U on A.lm_user=U.usercode |
| | | // where A.m_id=@id"; |
| | | //dynamicParams.Add("@id", id); |
| | | //var data = DapperHelper.selectdata(sql, dynamicParams); |
| | | |
| | | mes.code = "200"; |
| | | mes.Message = "æ¥è¯¢æå!"; |
| | | mes.data = data; |
| | | //mes.code = "200"; |
| | | //mes.Message = "æ¥è¯¢æå!"; |
| | | //mes.data = data; |
| | | |
| | | //åå¨è¿ç¨å |
| | | sql = @"h_p_IFCLD_WuLiuCheckSubSelect"; |
| | | dynamicParams.Add("@checkid", id); |
| | | DataTable dt = DapperHelper.selectProcedure(sql, dynamicParams); |
| | | if (dt.Rows.Count > 0) |
| | | { |
| | | mes.code = "200"; |
| | | mes.count = 0; |
| | | mes.Message = "æ¥è¯¢æå!"; |
| | | mes.data = dt; |
| | | } |
| | | else |
| | | { |
| | | mes.code = "300"; |
| | | mes.count = 0; |
| | | mes.Message = "æ æ£éªæç»æ°æ®!"; |
| | | mes.data = null; |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | |
| | | var total = 0; //æ»æ¡æ° |
| | | var sql = @"select |
| | | CASE WHEN |
| | | ROW_NUMBER() OVER (PARTITION BY A.wo_code ORDER BY B.checkitem_code) = 1 THEN A.wo_code |
| | | ROW_NUMBER() OVER (PARTITION BY A.id ORDER BY B.id) = 1 THEN A.wo_code |
| | | ELSE ''END AS 'å·¥åå·', |
| | | CASE WHEN |
| | | ROW_NUMBER() OVER (PARTITION BY A.partcode ORDER BY B.checkitem_code) = 1 THEN M.partcode |
| | | CASE WHEN |
| | | ROW_NUMBER() OVER (PARTITION BY A.id ORDER BY B.id) = 1 THEN M.partcode |
| | | ELSE ''END AS '产åç¼ç ', |
| | | CASE WHEN |
| | | ROW_NUMBER() OVER (PARTITION BY A.partcode ORDER BY B.checkitem_code) = 1 THEN M.partname |
| | | CASE WHEN |
| | | ROW_NUMBER() OVER (PARTITION BY A.id ORDER BY B.id) = 1 THEN M.partname |
| | | ELSE ''END AS '产ååç§°', |
| | | CASE WHEN |
| | | ROW_NUMBER() OVER (PARTITION BY A.partcode ORDER BY B.checkitem_code) = 1 THEN M.partspec |
| | | CASE WHEN |
| | | ROW_NUMBER() OVER (PARTITION BY A.id ORDER BY B.id) = 1 THEN M.partspec |
| | | ELSE ''END AS 'è§æ ¼åå·', |
| | | CASE WHEN |
| | | ROW_NUMBER() OVER (PARTITION BY A.step_code ORDER BY B.checkitem_code) = 1 THEN S.stepname |
| | | CASE WHEN |
| | | ROW_NUMBER() OVER (PARTITION BY A.id ORDER BY B.id) = 1 THEN S.stepname |
| | | ELSE ''END AS 'å·¥åºåç§°', |
| | | CASE WHEN |
| | | ROW_NUMBER() OVER (PARTITION BY A.checkstaned_code ORDER BY B.checkitem_code) = 1 THEN A.checkstaned_code |
| | | CASE WHEN |
| | | ROW_NUMBER() OVER (PARTITION BY A.id ORDER BY B.id) = 1 THEN A.checkstaned_code |
| | | ELSE ''END AS 'æ åç¼ç ', |
| | | CASE WHEN |
| | | ROW_NUMBER() OVER (PARTITION BY A.checkstaned_code ORDER BY B.checkitem_code) = 1 THEN T.name |
| | | CASE WHEN |
| | | ROW_NUMBER() OVER (PARTITION BY A.id ORDER BY B.id) = 1 THEN T.name |
| | | ELSE ''END AS 'æ ååç§°', |
| | | CASE WHEN |
| | | ROW_NUMBER() OVER (PARTITION BY A.check_user ORDER BY B.checkitem_code) = 1 THEN U.username |
| | | ROW_NUMBER() OVER (PARTITION BY A.id ORDER BY B.id) = 1 THEN U.username |
| | | ELSE ''END AS 'æ£éªäººå', |
| | | CASE WHEN |
| | | ROW_NUMBER() OVER (PARTITION BY A.check_typename ORDER BY B.checkitem_code) = 1 THEN A.check_typename |
| | | CASE WHEN |
| | | ROW_NUMBER() OVER (PARTITION BY A.id ORDER BY B.id) = 1 THEN A.check_typename |
| | | ELSE ''END AS 'æ£éªç±»å', |
| | | CASE WHEN |
| | | ROW_NUMBER() OVER (PARTITION BY A.check_result ORDER BY B.checkitem_code) = 1 THEN A.check_result |
| | | CASE WHEN |
| | | ROW_NUMBER() OVER (PARTITION BY A.id ORDER BY B.id) = 1 THEN A.check_result |
| | | ELSE ''END AS 'æ£éªç»æ', |
| | | CASE WHEN |
| | | ROW_NUMBER() OVER (PARTITION BY A.check_descr ORDER BY B.checkitem_code) = 1 THEN A.check_descr |
| | | CASE WHEN |
| | | ROW_NUMBER() OVER (PARTITION BY A.id ORDER BY B.id) = 1 THEN A.check_descr |
| | | ELSE ''END AS 'æ£éªæè¿°', |
| | | CASE WHEN |
| | | ROW_NUMBER() OVER (PARTITION BY A.check_qty ORDER BY B.checkitem_code) = 1 THEN A.check_qty |
| | | END AS 'æ£éªæ°é', |
| | | CASE WHEN |
| | | ROW_NUMBER() OVER (PARTITION BY A.lm_date ORDER BY B.checkitem_code) = 1 THEN A.lm_date |
| | | CASE WHEN |
| | | ROW_NUMBER() OVER (PARTITION BY A.id ORDER BY B.id) = 1 THEN A.check_qty |
| | | END AS 'æ ·æ¬æ°é', |
| | | CASE WHEN |
| | | ROW_NUMBER() OVER (PARTITION BY A.id ORDER BY B.id) = 1 THEN A.lm_date |
| | | END AS 'æ£éªæ¶é´', |
| | | B.checkitem_seq as 'æ£éªé¡¹ç®åºå·',B.checkitem_code 'æ£éªé¡¹ç®ç¼ç ',B.checkitem_name 'æ£éªé¡¹ç®åç§°',B.checkitem_descr 'æ£éªé¡¹ç®æè¿°',B.check_result 'æ£éªé¡¹ç®ç»æ' |
| | | B.checknum as æ£éªä»¶æ¬¡,B.checkitem_seq as 'æ£éªé¡¹ç®åºå·',B.checkitem_code 'æ£éªé¡¹ç®ç¼ç ',B.checkitem_name 'æ£éªé¡¹ç®åç§°',B.checkitem_descr 'æ£éªé¡¹ç®æè¿°',B.check_result 'æ£éªé¡¹ç®ç»æ', |
| | | C.standvalue as 'æ åå¼',C.uppervalue as 'ä¸éå¼',C.lowervalue as 'ä¸éå¼',B.check_value as '宿µå¼' |
| | | from TStepCheckRecord A |
| | | left join TStepCheckRecordSub B on A.id=B.m_id |
| | | left join TMateriel_Info M on A.partcode=M.partcode |
| | | left join TStep S on A.step_code=S.stepcode |
| | | left join TStepCheckStandard T on A.checkstaned_code=T.code |
| | | left join TStepCheckStandardSub C on A.checkstaned_code=C.stepstaned_code and B.checkitem_code=C.stepcheckitem_code |
| | | left join TUser U on A.check_user=U.usercode |
| | | where A.check_type in('FirstCheck','PatroCheck','EndCheck') " + search; |
| | | DataTable data = DapperHelper.selectdata(sql, dynamicParams); |
| | |
| | | #endregion |
| | | |
| | | |
| | | |
| | | #region[çæç³»ç»æ¡ç (èªå®ä¹)] |
| | | public static ToMessage LabelBarCode(string rightcode, string partcode, string qty, string onelabqty) |
| | | { |
| | | mes = AppLableBarCode.EncodingSeach(rightcode, partcode, qty, onelabqty); |
| | | return mes; |
| | | } |
| | | #endregion |
| | | |
| | | |
| | | |
| | | #region[车é´å
¬åå表] |
| | | public static ToMessage SystemAnnouncementSearch(string wkspcode, string ancetitle, string ancecont, string cancel, string level, int startNum, int endNum, string prop, string order) |
| | | { |
| | |
| | | <Project ToolsVersion="4.0" xmlns="http://schemas.microsoft.com/developer/msbuild/2003"> |
| | | <PropertyGroup> |
| | | <_PublishTargetUrl>D:\ç½ç«åå¸\XKDMesApi</_PublishTargetUrl> |
| | | <History>True|2023-05-19T05:58:21.8716077Z;True|2023-05-19T13:43:04.0108113+08:00;True|2023-05-18T14:00:14.2429421+08:00;True|2023-05-18T14:00:00.5235856+08:00;True|2023-05-18T13:50:34.8609414+08:00;True|2023-05-18T13:43:21.0316462+08:00;True|2023-05-18T10:19:05.7358704+08:00;True|2023-05-16T14:51:14.2413890+08:00;True|2023-05-11T16:12:03.5847312+08:00;True|2023-05-11T14:51:24.9777508+08:00;True|2023-05-11T14:22:01.5250259+08:00;True|2023-05-11T14:18:25.5821570+08:00;True|2023-05-09T19:30:19.2882714+08:00;True|2023-05-08T18:08:56.2476136+08:00;True|2023-05-08T18:07:15.2514972+08:00;True|2023-05-08T18:04:38.8770595+08:00;True|2023-05-08T17:47:24.7720275+08:00;True|2023-05-08T17:34:16.2613338+08:00;True|2023-05-08T17:31:32.9125441+08:00;True|2023-05-08T17:24:27.5765230+08:00;True|2023-05-08T17:18:32.6186281+08:00;True|2023-05-08T16:41:34.1978109+08:00;True|2023-05-08T16:38:10.1042972+08:00;True|2023-05-08T16:35:13.8108245+08:00;True|2023-05-08T16:05:00.4230119+08:00;True|2023-05-08T15:52:54.8659373+08:00;True|2023-05-08T15:27:59.7369215+08:00;True|2023-05-08T13:48:29.4669255+08:00;True|2023-05-06T09:21:10.0166182+08:00;True|2023-05-05T14:14:36.8872753+08:00;True|2023-04-25T09:53:42.9989490+08:00;True|2023-04-25T09:29:47.9359947+08:00;True|2023-04-21T10:10:47.7408362+08:00;True|2023-04-19T10:05:32.2323010+08:00;True|2023-04-19T08:47:02.1943920+08:00;True|2023-04-19T08:36:23.7737952+08:00;True|2023-04-19T08:27:33.3238877+08:00;True|2023-04-13T16:59:39.7958192+08:00;True|2023-04-13T16:34:45.9951848+08:00;True|2023-04-13T16:27:59.7386867+08:00;False|2023-04-13T16:23:36.7558189+08:00;True|2023-04-12T16:31:46.6724339+08:00;True|2023-04-12T16:23:35.3177339+08:00;True|2023-04-11T12:49:48.0246851+08:00;True|2023-04-11T12:46:56.0293166+08:00;True|2023-04-11T11:13:00.9841554+08:00;True|2023-04-10T16:53:41.8964649+08:00;True|2023-04-07T08:30:18.4653189+08:00;True|2023-04-06T17:29:55.4388629+08:00;True|2023-04-06T16:45:39.5573964+08:00;True|2023-04-04T15:41:18.1582540+08:00;True|2023-04-04T15:33:47.4319210+08:00;True|2023-04-04T15:24:23.0417772+08:00;True|2023-04-04T15:05:34.8694589+08:00;True|2023-04-04T13:51:06.6709099+08:00;True|2023-04-04T08:51:53.0379573+08:00;True|2023-04-04T08:26:14.1581736+08:00;True|2023-04-04T08:09:40.3919185+08:00;True|2023-04-04T08:03:47.3773358+08:00;True|2023-03-29T10:59:42.8557249+08:00;True|2023-03-29T10:32:37.1829423+08:00;True|2023-03-24T15:23:09.2950637+08:00;True|2023-03-22T17:52:59.0162624+08:00;True|2023-03-22T17:44:51.7892593+08:00;True|2023-03-22T17:41:41.7366750+08:00;True|2023-03-22T17:30:45.1983751+08:00;True|2023-03-22T17:25:48.0681920+08:00;True|2023-03-22T17:16:16.5578143+08:00;True|2023-03-22T16:36:15.7695476+08:00;True|2023-03-22T10:21:58.5145068+08:00;True|2023-03-20T17:21:47.4459321+08:00;True|2023-03-20T17:21:27.0468975+08:00;True|2023-03-20T16:58:02.8681774+08:00;True|2023-03-20T16:34:42.1058692+08:00;True|2023-03-20T16:23:47.7801897+08:00;True|2023-03-03T08:56:05.4730255+08:00;True|2023-03-02T16:23:31.6756396+08:00;True|2023-03-01T15:52:28.2849007+08:00;True|2023-03-01T15:35:55.8647024+08:00;True|2023-03-01T15:21:23.8133690+08:00;True|2023-02-28T16:00:01.5165754+08:00;True|2023-02-28T14:53:18.0954404+08:00;True|2023-02-28T14:45:14.0183407+08:00;True|2023-02-15T15:10:18.1493103+08:00;True|2023-02-15T14:45:42.3134512+08:00;True|2023-02-15T14:38:34.6207896+08:00;True|2023-02-15T14:28:47.3494779+08:00;True|2023-02-15T14:06:19.8843387+08:00;True|2023-02-15T12:37:06.8372351+08:00;True|2023-02-15T09:18:28.2740085+08:00;True|2023-02-14T16:38:24.2037803+08:00;False|2023-02-14T16:35:10.9291528+08:00;True|2023-02-13T14:56:38.5856100+08:00;True|2023-02-13T12:50:51.9358444+08:00;True|2023-02-11T10:08:39.6831781+08:00;True|2023-02-11T09:54:32.8160454+08:00;True|2023-02-11T09:54:21.9971913+08:00;True|2023-02-11T02:11:17.5904204+08:00;True|2023-02-11T02:04:19.4213456+08:00;True|2023-02-10T13:03:57.4443981+08:00;True|2023-02-09T21:55:13.8322950+08:00;True|2023-02-09T21:34:49.3120350+08:00;True|2023-02-07T10:08:39.5582710+08:00;True|2023-02-03T08:25:45.7718782+08:00;True|2023-01-30T12:40:37.6820386+08:00;True|2023-01-30T08:45:34.0836363+08:00;True|2023-01-11T10:13:36.4366183+08:00;True|2023-01-11T09:37:39.6235517+08:00;True|2023-01-11T09:37:05.7608583+08:00;True|2023-01-11T09:14:36.0337347+08:00;True|2023-01-10T16:29:20.9791940+08:00;True|2023-01-10T16:09:20.2950245+08:00;True|2023-01-10T14:43:30.8069585+08:00;True|2023-01-10T14:43:14.0392269+08:00;True|2023-01-10T13:30:42.7077204+08:00;True|2023-01-10T13:09:48.9547948+08:00;True|2023-01-10T12:18:02.7207328+08:00;True|2023-01-06T16:33:28.2963933+08:00;True|2023-01-06T16:27:31.9342782+08:00;True|2023-01-06T16:23:33.0323708+08:00;True|2023-01-06T14:06:25.7389071+08:00;True|2023-01-06T13:50:39.1399992+08:00;True|2023-01-06T11:55:24.5609585+08:00;True|2023-01-06T11:08:53.3862603+08:00;True|2023-01-06T10:35:25.4696330+08:00;True|2023-01-06T10:27:54.7687528+08:00;True|2023-01-06T09:34:11.0798818+08:00;True|2023-01-05T16:47:28.7063631+08:00;True|2023-01-04T15:09:12.6813075+08:00;True|2023-01-04T15:06:20.1259155+08:00;True|2022-12-27T15:22:00.8719157+08:00;True|2022-12-27T15:18:56.4183337+08:00;True|2022-12-27T11:13:35.0250651+08:00;True|2022-12-26T14:12:52.3868526+08:00;True|2022-12-26T10:35:25.9712626+08:00;True|2022-12-20T09:02:47.7097031+08:00;True|2022-12-19T14:40:38.5851369+08:00;True|2022-12-14T12:51:44.0399559+08:00;True|2022-12-14T10:59:36.5250039+08:00;True|2022-12-14T10:54:23.0704819+08:00;True|2022-12-14T10:54:11.5744699+08:00;True|2022-12-14T10:53:33.7127244+08:00;True|2022-12-14T10:47:34.9597966+08:00;True|2022-12-08T15:06:12.8416810+08:00;True|2022-12-07T16:44:49.7931793+08:00;True|2022-11-26T11:05:21.2315179+08:00;True|2022-11-26T10:56:49.3021067+08:00;True|2022-11-25T13:00:54.9138172+08:00;True|2022-11-25T12:43:01.0212012+08:00;True|2022-11-25T12:36:22.2745198+08:00;True|2022-11-25T12:33:27.1942331+08:00;True|2022-11-25T11:07:23.5860394+08:00;True|2022-11-25T10:36:26.1052993+08:00;True|2022-11-24T16:50:49.0061385+08:00;True|2022-11-24T16:47:23.6152654+08:00;True|2022-11-24T15:36:20.0275278+08:00;True|2022-11-24T15:25:29.2391337+08:00;True|2022-11-24T15:25:19.7988304+08:00;True|2022-11-24T15:06:48.3860466+08:00;True|2022-11-24T14:52:24.7879819+08:00;True|2022-11-24T10:12:41.0992839+08:00;True|2022-11-21T15:13:29.3527873+08:00;True|2022-11-21T10:42:28.8298039+08:00;True|2022-11-18T11:10:34.9917493+08:00;True|2022-11-18T11:10:11.7210670+08:00;True|2022-11-18T10:59:20.7515137+08:00;True|2022-11-18T10:52:33.2724652+08:00;True|2022-11-18T09:22:10.0215858+08:00;True|2022-11-18T09:16:35.0644453+08:00;True|2022-11-16T10:30:33.9013342+08:00;True|2022-11-16T09:55:08.7555656+08:00;True|2022-10-29T11:48:17.9164445+08:00;True|2022-10-29T10:27:39.6224331+08:00;True|2022-10-29T09:25:19.4865788+08:00;True|2022-10-29T09:01:58.2237798+08:00;True|2022-10-29T08:57:17.1749942+08:00;True|2022-10-28T14:44:10.4595607+08:00;True|2022-10-28T14:41:10.8050513+08:00;True|2022-10-28T14:39:02.0096359+08:00;True|2022-10-28T14:27:52.1679095+08:00;True|2022-10-28T14:19:07.6073425+08:00;True|2022-10-28T14:16:46.4140421+08:00;True|2022-10-28T14:06:54.5820895+08:00;True|2022-10-28T14:06:20.4765666+08:00;True|2022-10-28T14:00:01.8073205+08:00;True|2022-10-28T13:56:40.6320465+08:00;True|2022-10-28T12:52:46.3086338+08:00;True|2022-10-28T11:31:08.7626713+08:00;True|2022-10-28T11:28:25.3391022+08:00;True|2022-10-27T17:13:49.3276407+08:00;True|2022-10-27T17:09:49.3362372+08:00;True|2022-10-27T14:49:20.9922482+08:00;True|2022-10-27T11:08:32.7803317+08:00;True|2022-10-27T09:19:17.9537933+08:00;True|2022-10-27T09:14:00.6751533+08:00;True|2022-10-27T09:08:05.5814368+08:00;True|2022-10-27T09:04:21.1435873+08:00;True|2022-10-26T16:47:26.8255243+08:00;True|2022-10-26T16:29:26.3405800+08:00;False|2022-10-26T16:28:18.6237074+08:00;True|2022-10-26T14:29:39.8852546+08:00;True|2022-10-26T14:11:14.0537705+08:00;True|2022-10-26T10:56:16.7897290+08:00;True|2022-10-26T10:29:02.5303566+08:00;True|2022-10-26T10:28:29.9192643+08:00;True|2022-10-26T10:28:16.5901050+08:00;True|2022-10-26T10:22:02.2019236+08:00;True|2022-10-26T10:17:08.3009992+08:00;True|2022-10-20T18:19:28.0452517+08:00;True|2022-10-20T18:14:36.1031080+08:00;True|2022-10-20T16:49:08.1312509+08:00;True|2022-10-20T10:11:30.3988252+08:00;True|2022-10-20T09:52:55.2879279+08:00;True|2022-10-20T09:07:20.5119842+08:00;True|2022-10-20T08:55:23.9003542+08:00;True|2022-10-19T17:56:47.0600040+08:00;True|2022-10-19T17:26:22.4420642+08:00;True|2022-10-19T17:15:09.2591171+08:00;True|2022-10-19T17:00:58.0407123+08:00;True|2022-10-19T16:53:20.8393084+08:00;True|2022-10-19T16:49:09.6859302+08:00;True|2022-10-19T16:40:53.2090492+08:00;True|2022-10-19T16:35:02.0381742+08:00;True|2022-10-19T16:30:49.8415090+08:00;True|2022-10-19T16:05:14.3522346+08:00;True|2022-10-19T15:50:08.9509925+08:00;True|2022-10-19T15:36:28.6015003+08:00;True|2022-10-19T15:33:26.7861204+08:00;True|2022-10-19T15:27:02.8006070+08:00;True|2022-10-19T15:16:31.4065993+08:00;True|2022-10-19T15:14:34.8724996+08:00;True|2022-10-18T18:12:15.5930366+08:00;True|2022-10-18T18:06:54.1679240+08:00;True|2022-10-18T18:02:12.3473981+08:00;True|2022-10-18T17:39:10.7104222+08:00;True|2022-10-18T17:35:14.3679319+08:00;True|2022-10-18T17:32:18.8020932+08:00;True|2022-10-18T17:09:35.5170795+08:00;True|2022-10-18T17:02:58.3933082+08:00;True|2022-10-18T16:46:19.9647705+08:00;True|2022-10-18T11:28:23.1151472+08:00;True|2022-10-17T16:44:34.9653103+08:00;True|2022-10-16T01:53:49.3818533+08:00;True|2022-10-16T01:46:58.7626854+08:00;True|2022-10-16T01:35:19.3037353+08:00;True|2022-10-15T14:31:57.4587818+08:00;True|2022-10-15T14:22:52.4245457+08:00;True|2022-10-14T15:32:59.8175195+08:00;True|2022-10-14T15:24:23.9954226+08:00;True|2022-10-14T15:24:02.4438281+08:00;True|2022-10-14T11:07:04.2629220+08:00;True|2022-10-13T16:44:07.8507864+08:00;True|2022-10-13T16:34:20.4037866+08:00;True|2022-10-13T15:07:55.6527739+08:00;True|2022-10-12T14:59:51.4425162+08:00;True|2022-10-12T11:14:22.2463823+08:00;True|2022-10-12T08:53:16.5351204+08:00;True|2022-10-12T08:24:28.2157523+08:00;False|2022-10-12T08:23:56.2743080+08:00;True|2022-10-12T08:12:38.4791356+08:00;False|2022-10-12T08:12:14.9860966+08:00;True|2022-10-12T08:08:31.1437091+08:00;True|2022-10-11T18:10:13.8327911+08:00;True|2022-10-10T16:21:33.7622381+08:00;True|2022-10-10T09:56:53.1134309+08:00;False|2022-10-10T09:56:18.9153013+08:00;True|2022-10-10T08:46:48.2842004+08:00;True|2022-10-09T16:25:10.1147763+08:00;True|2022-10-08T16:54:50.7779806+08:00;True|2022-10-08T16:35:23.1960956+08:00;True|2022-10-08T16:06:16.5635598+08:00;True|2022-10-08T16:01:24.5889763+08:00;True|2022-10-08T13:11:34.8631266+08:00;True|2022-09-29T15:59:52.7749027+08:00;True|2022-09-28T18:13:25.7208132+08:00;True|2022-09-27T14:01:52.5493804+08:00;True|2022-09-27T08:32:48.3460557+08:00;True|2022-09-23T16:12:28.0271396+08:00;True|2022-09-23T13:50:16.4039745+08:00;True|2022-09-23T13:49:02.0464589+08:00;True|2022-09-23T13:47:12.4458913+08:00;True|2022-09-23T13:42:58.0795715+08:00;True|2022-09-23T13:32:34.2909297+08:00;True|2022-09-23T13:31:14.5573692+08:00;True|2022-09-23T13:27:32.1842906+08:00;True|2022-09-23T12:50:51.2811202+08:00;True|2022-09-22T17:31:41.3605592+08:00;True|2022-09-22T17:25:44.2386416+08:00;True|2022-09-22T09:47:22.9767826+08:00;True|2022-09-16T14:31:58.5334673+08:00;True|2022-09-16T09:04:53.3449040+08:00;True|2022-09-15T15:15:18.3159768+08:00;True|2022-09-14T17:46:23.0171281+08:00;True|2022-09-14T17:43:44.4370239+08:00;True|2022-09-14T17:34:30.3167863+08:00;True|2022-09-14T17:33:00.5148855+08:00;True|2022-09-14T17:06:32.0879029+08:00;True|2022-09-14T16:50:12.7189783+08:00;True|2022-09-14T16:47:48.3868826+08:00;True|2022-09-14T16:42:35.3830356+08:00;True|2022-09-14T16:41:37.8545801+08:00;True|2022-09-14T16:36:47.0944090+08:00;True|2022-09-14T16:26:00.8638173+08:00;True|2022-09-14T16:13:43.6329252+08:00;True|2022-09-14T16:04:16.8093275+08:00;True|2022-09-14T16:02:54.4702614+08:00;True|2022-09-14T15:57:15.9623104+08:00;True|2022-09-14T15:54:23.8745601+08:00;True|2022-09-14T15:49:40.1730864+08:00;True|2022-09-14T15:42:08.2811334+08:00;True|2022-09-14T15:26:40.0417771+08:00;True|2022-09-14T15:24:30.2187269+08:00;True|2022-09-14T15:16:30.3856771+08:00;True|2022-09-14T15:09:22.4313367+08:00;True|2022-09-14T14:59:14.3795036+08:00;True|2022-09-14T14:53:26.8923244+08:00;True|2022-09-14T14:44:00.6688344+08:00;True|2022-09-14T14:41:53.3908108+08:00;True|2022-09-14T14:40:40.3787118+08:00;True|2022-09-14T14:28:39.2273279+08:00;True|2022-09-14T14:27:13.3566861+08:00;True|2022-09-14T14:25:25.4360688+08:00;True|2022-09-14T14:20:42.9734032+08:00;True|2022-09-14T13:51:39.1303401+08:00;True|2022-09-14T13:25:34.8906041+08:00;True|2022-09-14T13:19:28.9172079+08:00;True|2022-09-14T13:18:09.5900815+08:00;True|2022-09-14T10:58:58.0910068+08:00;True|2022-09-14T10:57:11.4834444+08:00;True|2022-09-14T10:45:39.8943674+08:00;True|2022-09-14T10:38:15.2282286+08:00;True|2022-09-14T10:36:54.8259640+08:00;True|2022-09-14T10:14:12.1218790+08:00;True|2022-09-14T10:13:20.0625618+08:00;True|2022-09-14T10:10:15.3538379+08:00;True|2022-09-14T10:07:09.4796434+08:00;True|2022-09-14T10:06:02.0382235+08:00;True|2022-09-14T09:57:12.0082796+08:00;True|2022-09-14T09:52:29.4689029+08:00;True|2022-09-14T09:47:26.7205193+08:00;True|2022-09-14T09:38:56.4089520+08:00;True|2022-09-14T09:32:34.9863473+08:00;True|2022-09-12T13:07:40.5119225+08:00;True|2022-09-09T15:21:48.4251654+08:00;True|2022-09-09T14:45:54.9315147+08:00;True|2022-09-09T11:01:18.2619729+08:00;True|2022-09-09T09:35:40.9779148+08:00;True|2022-09-09T09:26:51.9854326+08:00;True|2022-09-09T09:11:48.8023373+08:00;True|2022-09-09T09:05:45.5528883+08:00;True|2022-09-08T17:47:35.2628987+08:00;True|2022-09-08T17:43:32.6700813+08:00;True|2022-09-08T17:01:23.6259930+08:00;True|2022-09-08T16:55:57.2305777+08:00;True|2022-09-08T16:35:37.3631720+08:00;True|2022-09-08T16:19:13.9122228+08:00;True|2022-09-08T16:04:07.7348285+08:00;True|2022-09-08T16:00:49.9961701+08:00;True|2022-09-08T15:16:03.0110619+08:00;True|2022-09-08T10:19:46.2872822+08:00;True|2022-09-08T10:11:15.5386438+08:00;True|2022-09-08T08:19:02.5242539+08:00;True|2022-09-08T08:18:11.7308721+08:00;True|2022-09-07T11:39:27.2463573+08:00;True|2022-09-07T10:40:57.8877369+08:00;True|2022-09-07T10:37:10.1517098+08:00;True|2022-09-07T10:30:08.7782107+08:00;True|2022-09-07T10:23:52.8534200+08:00;True|2022-09-07T10:09:31.6994230+08:00;True|2022-09-07T10:01:16.2683112+08:00;True|2022-09-07T09:51:47.6282546+08:00;True|2022-09-06T19:11:45.1701913+08:00;True|2022-09-06T18:29:29.2671862+08:00;True|2022-09-06T16:41:04.2719822+08:00;True|2022-09-06T14:17:31.6896132+08:00;True|2022-09-06T13:14:39.9657702+08:00;True|2022-09-05T13:34:47.0627238+08:00;True|2022-09-05T11:07:59.2835592+08:00;True|2022-09-02T14:01:56.1233378+08:00;True|2022-08-31T23:40:49.5468281+08:00;True|2022-08-31T22:15:50.0388123+08:00;True|2022-08-31T19:20:24.7693742+08:00;True|2022-08-31T19:00:06.8271626+08:00;True|2022-08-31T18:45:08.6483670+08:00;True|2022-08-31T16:59:34.8244511+08:00;True|2022-08-31T15:39:51.0653019+08:00;True|2022-08-31T15:25:32.5277796+08:00;True|2022-08-31T13:31:48.5734692+08:00;True|2022-08-31T12:59:02.1022191+08:00;True|2022-08-31T10:06:03.2043884+08:00;True|2022-08-30T17:36:34.5932064+08:00;True|2022-08-30T17:18:12.4582841+08:00;True|2022-08-30T12:55:16.4084322+08:00;True|2022-08-30T10:12:08.0975252+08:00;True|2022-08-30T09:12:46.2845546+08:00;True|2022-08-30T08:58:47.8389468+08:00;True|2022-08-29T17:21:17.7779579+08:00;True|2022-08-29T17:17:49.5334583+08:00;True|2022-08-29T16:53:46.6019453+08:00;True|2022-08-29T16:46:50.8158231+08:00;True|2022-08-29T12:25:19.0140888+08:00;True|2022-08-26T17:02:52.4614637+08:00;True|2022-08-26T16:52:47.8585471+08:00;True|2022-08-26T16:47:02.5766798+08:00;True|2022-08-26T16:36:15.5793109+08:00;True|2022-08-26T16:15:55.1795297+08:00;True|2022-08-26T16:00:22.2697361+08:00;False|2022-08-26T15:58:16.7347649+08:00;True|2022-08-26T15:22:29.6367466+08:00;True|2022-08-25T20:02:24.4685508+08:00;True|2022-08-25T19:50:42.8601696+08:00;True|2022-08-25T15:56:20.3615518+08:00;True|2022-08-25T15:48:16.9923580+08:00;True|2022-08-25T15:27:07.9474640+08:00;True|2022-08-25T13:11:36.9626131+08:00;True|2022-08-24T14:10:58.2790665+08:00;True|2022-08-24T11:43:10.4463552+08:00;True|2022-08-24T08:02:17.9871411+08:00;True|2022-08-23T22:50:41.0238571+08:00;True|2022-08-23T22:16:20.9249814+08:00;True|2022-08-23T21:59:21.1909300+08:00;True|2022-08-23T21:50:40.8106496+08:00;True|2022-08-23T21:06:55.6611505+08:00;True|2022-08-23T19:49:07.0507418+08:00;True|2022-08-23T19:03:15.9808046+08:00;True|2022-08-23T18:58:57.1700899+08:00;True|2022-08-23T18:54:26.8058591+08:00;True|2022-08-23T18:45:39.1928602+08:00;True|2022-08-23T17:32:10.6125039+08:00;True|2022-08-23T15:58:34.9205174+08:00;True|2022-08-23T15:49:21.3383764+08:00;True|2022-08-23T15:14:21.0775398+08:00;True|2022-08-23T15:04:07.8829410+08:00;True|2022-08-23T14:59:17.5143895+08:00;True|2022-08-23T14:55:17.0069050+08:00;True|2022-08-23T14:41:41.0884731+08:00;True|2022-08-23T14:41:06.5045325+08:00;True|2022-08-23T14:28:54.7390570+08:00;True|2022-08-23T13:56:59.3670549+08:00;True|2022-08-23T13:56:38.8588174+08:00;True|2022-08-22T20:48:56.2180227+08:00;True|2022-08-22T19:07:12.1093584+08:00;True|2022-08-22T19:04:07.7837887+08:00;True|2022-08-22T14:38:00.9342884+08:00;True|2022-08-22T10:59:23.2073567+08:00;True|2022-08-22T10:53:58.0920733+08:00;True|2022-08-22T10:53:10.2446944+08:00;True|2022-08-22T10:43:35.3791396+08:00;True|2022-08-18T09:45:46.4643950+08:00;True|2022-08-18T09:40:55.2601145+08:00;True|2022-08-16T16:17:14.3399134+08:00;True|2022-08-15T17:58:16.1460123+08:00;True|2022-08-15T17:55:55.7137518+08:00;True|2022-08-15T17:44:37.6024482+08:00;True|2022-08-15T17:44:21.9583041+08:00;True|2022-08-15T17:43:23.1305690+08:00;True|2022-08-15T17:29:31.1670490+08:00;True|2022-08-15T17:26:42.9269470+08:00;True|2022-08-15T17:23:27.0940168+08:00;True|2022-08-15T17:07:32.9192045+08:00;True|2022-08-15T16:47:03.8611076+08:00;True|2022-08-15T16:41:50.6843705+08:00;True|2022-08-15T16:38:26.7407413+08:00;True|2022-08-15T16:31:49.0805578+08:00;True|2022-08-15T16:27:33.6712012+08:00;True|2022-08-15T16:24:35.1042794+08:00;True|2022-08-15T16:21:57.2757683+08:00;True|2022-08-15T16:18:17.3545368+08:00;True|2022-08-15T16:15:04.2645412+08:00;True|2022-08-15T14:44:09.3078026+08:00;True|2022-08-15T11:20:09.2930712+08:00;True|2022-08-15T10:42:12.2991587+08:00;True|2022-08-15T10:41:38.3711025+08:00;True|2022-08-15T10:19:06.9974383+08:00;True|2022-08-12T17:15:09.2133281+08:00;True|2022-08-12T10:48:05.8776009+08:00;True|2022-08-12T10:26:16.4183447+08:00;True|2022-08-12T08:33:01.9502005+08:00;True|2022-08-11T09:06:08.8394009+08:00;True|2022-08-11T08:39:06.2534634+08:00;True|2022-08-11T08:05:13.6919725+08:00;True|2022-08-08T14:48:16.3637965+08:00;True|2022-08-05T15:44:02.3797448+08:00;True|2022-08-05T09:57:55.7744103+08:00;True|2022-08-04T15:24:38.8785046+08:00;True|2022-08-04T15:11:16.7054147+08:00;True|2022-08-04T14:53:52.7239932+08:00;True|2022-08-04T14:48:35.6115863+08:00;True|2022-08-04T14:39:16.1113507+08:00;True|2022-08-04T12:26:39.4998322+08:00;True|2022-08-04T10:34:23.9626503+08:00;True|2022-08-04T08:12:51.4305728+08:00;True|2022-08-03T15:43:09.2317512+08:00;True|2022-08-02T19:17:55.0460145+08:00;True|2022-08-02T19:08:13.5872184+08:00;True|2022-08-02T18:50:12.1280167+08:00;True|2022-08-02T18:05:53.6540810+08:00;True|2022-08-02T16:13:26.3567210+08:00;True|2022-08-02T15:27:59.9264333+08:00;True|2022-07-25T15:35:49.6958399+08:00;True|2022-07-25T15:30:40.4444876+08:00;True|2022-07-25T13:33:38.4068153+08:00;True|2022-07-22T15:00:56.7326322+08:00;True|2022-07-22T14:51:18.0169121+08:00;True|2022-07-22T14:26:08.4246205+08:00;True|2022-07-22T14:23:05.0897016+08:00;True|2022-07-22T14:18:18.7806854+08:00;True|2022-07-22T14:09:29.7924367+08:00;True|2022-07-22T14:02:26.6403133+08:00;True|2022-07-22T13:56:40.0887615+08:00;True|2022-07-22T13:50:10.7852190+08:00;True|2022-07-22T11:38:25.6671780+08:00;True|2022-07-22T10:55:36.7947659+08:00;True|2022-07-21T17:53:41.1464086+08:00;True|2022-07-21T17:43:33.5311479+08:00;True|2022-07-21T16:09:07.7687640+08:00;True|2022-07-21T16:04:47.9317019+08:00;True|2022-07-21T15:58:21.2359033+08:00;True|2022-07-21T15:56:07.7425829+08:00;True|2022-07-21T15:51:34.7108381+08:00;True|2022-07-21T15:48:57.5735708+08:00;True|2022-07-21T15:44:25.8205030+08:00;True|2022-07-21T15:25:51.4222269+08:00;True|2022-07-21T15:22:36.8818295+08:00;True|2022-07-21T15:19:28.8532774+08:00;True|2022-07-21T14:57:45.7532568+08:00;True|2022-07-21T11:16:12.0900762+08:00;True|2022-07-21T10:10:40.4714948+08:00;True|2022-07-21T10:00:19.5258058+08:00;True|2022-07-14T14:34:28.5093226+08:00;True|2022-07-14T13:59:59.7754985+08:00;True|2022-07-14T12:46:29.6685284+08:00;True|2022-07-14T09:22:25.9079652+08:00;True|2022-07-14T09:22:04.6797478+08:00;True|2022-07-14T09:10:45.0177607+08:00;True|2022-07-14T08:41:43.3026713+08:00;True|2022-07-14T08:27:32.7454972+08:00;True|2022-07-14T08:21:58.6572366+08:00;True|2022-07-14T08:17:59.2904747+08:00;True|2022-07-14T08:12:39.8483472+08:00;True|2022-06-30T15:04:41.6941982+08:00;True|2022-06-24T16:39:01.1080301+08:00;True|2022-06-17T13:23:15.1455451+08:00;True|2022-06-17T13:22:18.5517557+08:00;True|2022-06-17T13:19:27.7323818+08:00;True|2022-06-17T13:12:24.1252779+08:00;True|2022-06-17T13:09:20.4234258+08:00;True|2022-06-17T13:06:49.9869509+08:00;True|2022-06-17T12:58:54.6964621+08:00;False|2022-06-17T12:58:10.6767711+08:00;False|2022-06-17T12:57:08.9747950+08:00;False|2022-06-17T12:56:18.4650121+08:00;False|2022-06-17T12:55:57.9981927+08:00;True|2022-06-13T14:21:36.5610928+08:00;True|2022-06-13T11:41:39.4210151+08:00;True|2022-06-11T02:35:03.4727934+08:00;True|2022-06-11T02:31:13.7362660+08:00;True|2022-06-11T02:30:58.3616790+08:00;True|2022-06-11T01:57:04.4951468+08:00;True|2022-06-10T13:27:13.2097124+08:00;</History> |
| | | <History>True|2023-06-01T06:26:02.6848804Z;True|2023-06-01T14:19:16.3265332+08:00;True|2023-06-01T14:16:05.2116409+08:00;True|2023-06-01T10:01:38.0207095+08:00;True|2023-05-31T17:43:08.6664074+08:00;True|2023-05-31T09:32:41.4859615+08:00;True|2023-05-31T08:50:06.8160700+08:00;True|2023-05-31T08:39:32.5791756+08:00;True|2023-05-30T09:26:09.0240070+08:00;True|2023-05-29T15:53:12.8817788+08:00;True|2023-05-29T14:30:52.6220697+08:00;True|2023-05-29T13:55:41.1669399+08:00;True|2023-05-29T13:03:44.0769099+08:00;True|2023-05-24T17:48:23.4103747+08:00;True|2023-05-24T17:01:18.3893985+08:00;True|2023-05-23T17:59:07.2228623+08:00;True|2023-05-23T16:58:18.9767570+08:00;True|2023-05-23T16:30:49.1123047+08:00;True|2023-05-23T16:25:44.7175437+08:00;True|2023-05-23T16:24:50.0077522+08:00;True|2023-05-23T14:12:34.7299476+08:00;True|2023-05-23T14:12:08.0362065+08:00;True|2023-05-23T13:10:13.3230173+08:00;True|2023-05-23T13:04:26.6307618+08:00;True|2023-05-23T09:44:34.5544370+08:00;True|2023-05-23T09:22:40.7420990+08:00;True|2023-05-19T13:58:21.8716077+08:00;True|2023-05-19T13:43:04.0108113+08:00;True|2023-05-18T14:00:14.2429421+08:00;True|2023-05-18T14:00:00.5235856+08:00;True|2023-05-18T13:50:34.8609414+08:00;True|2023-05-18T13:43:21.0316462+08:00;True|2023-05-18T10:19:05.7358704+08:00;True|2023-05-16T14:51:14.2413890+08:00;True|2023-05-11T16:12:03.5847312+08:00;True|2023-05-11T14:51:24.9777508+08:00;True|2023-05-11T14:22:01.5250259+08:00;True|2023-05-11T14:18:25.5821570+08:00;True|2023-05-09T19:30:19.2882714+08:00;True|2023-05-08T18:08:56.2476136+08:00;True|2023-05-08T18:07:15.2514972+08:00;True|2023-05-08T18:04:38.8770595+08:00;True|2023-05-08T17:47:24.7720275+08:00;True|2023-05-08T17:34:16.2613338+08:00;True|2023-05-08T17:31:32.9125441+08:00;True|2023-05-08T17:24:27.5765230+08:00;True|2023-05-08T17:18:32.6186281+08:00;True|2023-05-08T16:41:34.1978109+08:00;True|2023-05-08T16:38:10.1042972+08:00;True|2023-05-08T16:35:13.8108245+08:00;True|2023-05-08T16:05:00.4230119+08:00;True|2023-05-08T15:52:54.8659373+08:00;True|2023-05-08T15:27:59.7369215+08:00;True|2023-05-08T13:48:29.4669255+08:00;True|2023-05-06T09:21:10.0166182+08:00;True|2023-05-05T14:14:36.8872753+08:00;True|2023-04-25T09:53:42.9989490+08:00;True|2023-04-25T09:29:47.9359947+08:00;True|2023-04-21T10:10:47.7408362+08:00;True|2023-04-19T10:05:32.2323010+08:00;True|2023-04-19T08:47:02.1943920+08:00;True|2023-04-19T08:36:23.7737952+08:00;True|2023-04-19T08:27:33.3238877+08:00;True|2023-04-13T16:59:39.7958192+08:00;True|2023-04-13T16:34:45.9951848+08:00;True|2023-04-13T16:27:59.7386867+08:00;False|2023-04-13T16:23:36.7558189+08:00;True|2023-04-12T16:31:46.6724339+08:00;True|2023-04-12T16:23:35.3177339+08:00;True|2023-04-11T12:49:48.0246851+08:00;True|2023-04-11T12:46:56.0293166+08:00;True|2023-04-11T11:13:00.9841554+08:00;True|2023-04-10T16:53:41.8964649+08:00;True|2023-04-07T08:30:18.4653189+08:00;True|2023-04-06T17:29:55.4388629+08:00;True|2023-04-06T16:45:39.5573964+08:00;True|2023-04-04T15:41:18.1582540+08:00;True|2023-04-04T15:33:47.4319210+08:00;True|2023-04-04T15:24:23.0417772+08:00;True|2023-04-04T15:05:34.8694589+08:00;True|2023-04-04T13:51:06.6709099+08:00;True|2023-04-04T08:51:53.0379573+08:00;True|2023-04-04T08:26:14.1581736+08:00;True|2023-04-04T08:09:40.3919185+08:00;True|2023-04-04T08:03:47.3773358+08:00;True|2023-03-29T10:59:42.8557249+08:00;True|2023-03-29T10:32:37.1829423+08:00;True|2023-03-24T15:23:09.2950637+08:00;True|2023-03-22T17:52:59.0162624+08:00;True|2023-03-22T17:44:51.7892593+08:00;True|2023-03-22T17:41:41.7366750+08:00;True|2023-03-22T17:30:45.1983751+08:00;True|2023-03-22T17:25:48.0681920+08:00;True|2023-03-22T17:16:16.5578143+08:00;True|2023-03-22T16:36:15.7695476+08:00;True|2023-03-22T10:21:58.5145068+08:00;True|2023-03-20T17:21:47.4459321+08:00;True|2023-03-20T17:21:27.0468975+08:00;True|2023-03-20T16:58:02.8681774+08:00;True|2023-03-20T16:34:42.1058692+08:00;True|2023-03-20T16:23:47.7801897+08:00;True|2023-03-03T08:56:05.4730255+08:00;True|2023-03-02T16:23:31.6756396+08:00;True|2023-03-01T15:52:28.2849007+08:00;True|2023-03-01T15:35:55.8647024+08:00;True|2023-03-01T15:21:23.8133690+08:00;True|2023-02-28T16:00:01.5165754+08:00;True|2023-02-28T14:53:18.0954404+08:00;True|2023-02-28T14:45:14.0183407+08:00;True|2023-02-15T15:10:18.1493103+08:00;True|2023-02-15T14:45:42.3134512+08:00;True|2023-02-15T14:38:34.6207896+08:00;True|2023-02-15T14:28:47.3494779+08:00;True|2023-02-15T14:06:19.8843387+08:00;True|2023-02-15T12:37:06.8372351+08:00;True|2023-02-15T09:18:28.2740085+08:00;True|2023-02-14T16:38:24.2037803+08:00;False|2023-02-14T16:35:10.9291528+08:00;True|2023-02-13T14:56:38.5856100+08:00;True|2023-02-13T12:50:51.9358444+08:00;True|2023-02-11T10:08:39.6831781+08:00;True|2023-02-11T09:54:32.8160454+08:00;True|2023-02-11T09:54:21.9971913+08:00;True|2023-02-11T02:11:17.5904204+08:00;True|2023-02-11T02:04:19.4213456+08:00;True|2023-02-10T13:03:57.4443981+08:00;True|2023-02-09T21:55:13.8322950+08:00;True|2023-02-09T21:34:49.3120350+08:00;True|2023-02-07T10:08:39.5582710+08:00;True|2023-02-03T08:25:45.7718782+08:00;True|2023-01-30T12:40:37.6820386+08:00;True|2023-01-30T08:45:34.0836363+08:00;True|2023-01-11T10:13:36.4366183+08:00;True|2023-01-11T09:37:39.6235517+08:00;True|2023-01-11T09:37:05.7608583+08:00;True|2023-01-11T09:14:36.0337347+08:00;True|2023-01-10T16:29:20.9791940+08:00;True|2023-01-10T16:09:20.2950245+08:00;True|2023-01-10T14:43:30.8069585+08:00;True|2023-01-10T14:43:14.0392269+08:00;True|2023-01-10T13:30:42.7077204+08:00;True|2023-01-10T13:09:48.9547948+08:00;True|2023-01-10T12:18:02.7207328+08:00;True|2023-01-06T16:33:28.2963933+08:00;True|2023-01-06T16:27:31.9342782+08:00;True|2023-01-06T16:23:33.0323708+08:00;True|2023-01-06T14:06:25.7389071+08:00;True|2023-01-06T13:50:39.1399992+08:00;True|2023-01-06T11:55:24.5609585+08:00;True|2023-01-06T11:08:53.3862603+08:00;True|2023-01-06T10:35:25.4696330+08:00;True|2023-01-06T10:27:54.7687528+08:00;True|2023-01-06T09:34:11.0798818+08:00;True|2023-01-05T16:47:28.7063631+08:00;True|2023-01-04T15:09:12.6813075+08:00;True|2023-01-04T15:06:20.1259155+08:00;True|2022-12-27T15:22:00.8719157+08:00;True|2022-12-27T15:18:56.4183337+08:00;True|2022-12-27T11:13:35.0250651+08:00;True|2022-12-26T14:12:52.3868526+08:00;True|2022-12-26T10:35:25.9712626+08:00;True|2022-12-20T09:02:47.7097031+08:00;True|2022-12-19T14:40:38.5851369+08:00;True|2022-12-14T12:51:44.0399559+08:00;True|2022-12-14T10:59:36.5250039+08:00;True|2022-12-14T10:54:23.0704819+08:00;True|2022-12-14T10:54:11.5744699+08:00;True|2022-12-14T10:53:33.7127244+08:00;True|2022-12-14T10:47:34.9597966+08:00;True|2022-12-08T15:06:12.8416810+08:00;True|2022-12-07T16:44:49.7931793+08:00;True|2022-11-26T11:05:21.2315179+08:00;True|2022-11-26T10:56:49.3021067+08:00;True|2022-11-25T13:00:54.9138172+08:00;True|2022-11-25T12:43:01.0212012+08:00;True|2022-11-25T12:36:22.2745198+08:00;True|2022-11-25T12:33:27.1942331+08:00;True|2022-11-25T11:07:23.5860394+08:00;True|2022-11-25T10:36:26.1052993+08:00;True|2022-11-24T16:50:49.0061385+08:00;True|2022-11-24T16:47:23.6152654+08:00;True|2022-11-24T15:36:20.0275278+08:00;True|2022-11-24T15:25:29.2391337+08:00;True|2022-11-24T15:25:19.7988304+08:00;True|2022-11-24T15:06:48.3860466+08:00;True|2022-11-24T14:52:24.7879819+08:00;True|2022-11-24T10:12:41.0992839+08:00;True|2022-11-21T15:13:29.3527873+08:00;True|2022-11-21T10:42:28.8298039+08:00;True|2022-11-18T11:10:34.9917493+08:00;True|2022-11-18T11:10:11.7210670+08:00;True|2022-11-18T10:59:20.7515137+08:00;True|2022-11-18T10:52:33.2724652+08:00;True|2022-11-18T09:22:10.0215858+08:00;True|2022-11-18T09:16:35.0644453+08:00;True|2022-11-16T10:30:33.9013342+08:00;True|2022-11-16T09:55:08.7555656+08:00;True|2022-10-29T11:48:17.9164445+08:00;True|2022-10-29T10:27:39.6224331+08:00;True|2022-10-29T09:25:19.4865788+08:00;True|2022-10-29T09:01:58.2237798+08:00;True|2022-10-29T08:57:17.1749942+08:00;True|2022-10-28T14:44:10.4595607+08:00;True|2022-10-28T14:41:10.8050513+08:00;True|2022-10-28T14:39:02.0096359+08:00;True|2022-10-28T14:27:52.1679095+08:00;True|2022-10-28T14:19:07.6073425+08:00;True|2022-10-28T14:16:46.4140421+08:00;True|2022-10-28T14:06:54.5820895+08:00;True|2022-10-28T14:06:20.4765666+08:00;True|2022-10-28T14:00:01.8073205+08:00;True|2022-10-28T13:56:40.6320465+08:00;True|2022-10-28T12:52:46.3086338+08:00;True|2022-10-28T11:31:08.7626713+08:00;True|2022-10-28T11:28:25.3391022+08:00;True|2022-10-27T17:13:49.3276407+08:00;True|2022-10-27T17:09:49.3362372+08:00;True|2022-10-27T14:49:20.9922482+08:00;True|2022-10-27T11:08:32.7803317+08:00;True|2022-10-27T09:19:17.9537933+08:00;True|2022-10-27T09:14:00.6751533+08:00;True|2022-10-27T09:08:05.5814368+08:00;True|2022-10-27T09:04:21.1435873+08:00;True|2022-10-26T16:47:26.8255243+08:00;True|2022-10-26T16:29:26.3405800+08:00;False|2022-10-26T16:28:18.6237074+08:00;True|2022-10-26T14:29:39.8852546+08:00;True|2022-10-26T14:11:14.0537705+08:00;True|2022-10-26T10:56:16.7897290+08:00;True|2022-10-26T10:29:02.5303566+08:00;True|2022-10-26T10:28:29.9192643+08:00;True|2022-10-26T10:28:16.5901050+08:00;True|2022-10-26T10:22:02.2019236+08:00;True|2022-10-26T10:17:08.3009992+08:00;True|2022-10-20T18:19:28.0452517+08:00;True|2022-10-20T18:14:36.1031080+08:00;True|2022-10-20T16:49:08.1312509+08:00;True|2022-10-20T10:11:30.3988252+08:00;True|2022-10-20T09:52:55.2879279+08:00;True|2022-10-20T09:07:20.5119842+08:00;True|2022-10-20T08:55:23.9003542+08:00;True|2022-10-19T17:56:47.0600040+08:00;True|2022-10-19T17:26:22.4420642+08:00;True|2022-10-19T17:15:09.2591171+08:00;True|2022-10-19T17:00:58.0407123+08:00;True|2022-10-19T16:53:20.8393084+08:00;True|2022-10-19T16:49:09.6859302+08:00;True|2022-10-19T16:40:53.2090492+08:00;True|2022-10-19T16:35:02.0381742+08:00;True|2022-10-19T16:30:49.8415090+08:00;True|2022-10-19T16:05:14.3522346+08:00;True|2022-10-19T15:50:08.9509925+08:00;True|2022-10-19T15:36:28.6015003+08:00;True|2022-10-19T15:33:26.7861204+08:00;True|2022-10-19T15:27:02.8006070+08:00;True|2022-10-19T15:16:31.4065993+08:00;True|2022-10-19T15:14:34.8724996+08:00;True|2022-10-18T18:12:15.5930366+08:00;True|2022-10-18T18:06:54.1679240+08:00;True|2022-10-18T18:02:12.3473981+08:00;True|2022-10-18T17:39:10.7104222+08:00;True|2022-10-18T17:35:14.3679319+08:00;True|2022-10-18T17:32:18.8020932+08:00;True|2022-10-18T17:09:35.5170795+08:00;True|2022-10-18T17:02:58.3933082+08:00;True|2022-10-18T16:46:19.9647705+08:00;True|2022-10-18T11:28:23.1151472+08:00;True|2022-10-17T16:44:34.9653103+08:00;True|2022-10-16T01:53:49.3818533+08:00;True|2022-10-16T01:46:58.7626854+08:00;True|2022-10-16T01:35:19.3037353+08:00;True|2022-10-15T14:31:57.4587818+08:00;True|2022-10-15T14:22:52.4245457+08:00;True|2022-10-14T15:32:59.8175195+08:00;True|2022-10-14T15:24:23.9954226+08:00;True|2022-10-14T15:24:02.4438281+08:00;True|2022-10-14T11:07:04.2629220+08:00;True|2022-10-13T16:44:07.8507864+08:00;True|2022-10-13T16:34:20.4037866+08:00;True|2022-10-13T15:07:55.6527739+08:00;True|2022-10-12T14:59:51.4425162+08:00;True|2022-10-12T11:14:22.2463823+08:00;True|2022-10-12T08:53:16.5351204+08:00;True|2022-10-12T08:24:28.2157523+08:00;False|2022-10-12T08:23:56.2743080+08:00;True|2022-10-12T08:12:38.4791356+08:00;False|2022-10-12T08:12:14.9860966+08:00;True|2022-10-12T08:08:31.1437091+08:00;True|2022-10-11T18:10:13.8327911+08:00;True|2022-10-10T16:21:33.7622381+08:00;True|2022-10-10T09:56:53.1134309+08:00;False|2022-10-10T09:56:18.9153013+08:00;True|2022-10-10T08:46:48.2842004+08:00;True|2022-10-09T16:25:10.1147763+08:00;True|2022-10-08T16:54:50.7779806+08:00;True|2022-10-08T16:35:23.1960956+08:00;True|2022-10-08T16:06:16.5635598+08:00;True|2022-10-08T16:01:24.5889763+08:00;True|2022-10-08T13:11:34.8631266+08:00;True|2022-09-29T15:59:52.7749027+08:00;True|2022-09-28T18:13:25.7208132+08:00;True|2022-09-27T14:01:52.5493804+08:00;True|2022-09-27T08:32:48.3460557+08:00;True|2022-09-23T16:12:28.0271396+08:00;True|2022-09-23T13:50:16.4039745+08:00;True|2022-09-23T13:49:02.0464589+08:00;True|2022-09-23T13:47:12.4458913+08:00;True|2022-09-23T13:42:58.0795715+08:00;True|2022-09-23T13:32:34.2909297+08:00;True|2022-09-23T13:31:14.5573692+08:00;True|2022-09-23T13:27:32.1842906+08:00;True|2022-09-23T12:50:51.2811202+08:00;True|2022-09-22T17:31:41.3605592+08:00;True|2022-09-22T17:25:44.2386416+08:00;True|2022-09-22T09:47:22.9767826+08:00;True|2022-09-16T14:31:58.5334673+08:00;True|2022-09-16T09:04:53.3449040+08:00;True|2022-09-15T15:15:18.3159768+08:00;True|2022-09-14T17:46:23.0171281+08:00;True|2022-09-14T17:43:44.4370239+08:00;True|2022-09-14T17:34:30.3167863+08:00;True|2022-09-14T17:33:00.5148855+08:00;True|2022-09-14T17:06:32.0879029+08:00;True|2022-09-14T16:50:12.7189783+08:00;True|2022-09-14T16:47:48.3868826+08:00;True|2022-09-14T16:42:35.3830356+08:00;True|2022-09-14T16:41:37.8545801+08:00;True|2022-09-14T16:36:47.0944090+08:00;True|2022-09-14T16:26:00.8638173+08:00;True|2022-09-14T16:13:43.6329252+08:00;True|2022-09-14T16:04:16.8093275+08:00;True|2022-09-14T16:02:54.4702614+08:00;True|2022-09-14T15:57:15.9623104+08:00;True|2022-09-14T15:54:23.8745601+08:00;True|2022-09-14T15:49:40.1730864+08:00;True|2022-09-14T15:42:08.2811334+08:00;True|2022-09-14T15:26:40.0417771+08:00;True|2022-09-14T15:24:30.2187269+08:00;True|2022-09-14T15:16:30.3856771+08:00;True|2022-09-14T15:09:22.4313367+08:00;True|2022-09-14T14:59:14.3795036+08:00;True|2022-09-14T14:53:26.8923244+08:00;True|2022-09-14T14:44:00.6688344+08:00;True|2022-09-14T14:41:53.3908108+08:00;True|2022-09-14T14:40:40.3787118+08:00;True|2022-09-14T14:28:39.2273279+08:00;True|2022-09-14T14:27:13.3566861+08:00;True|2022-09-14T14:25:25.4360688+08:00;True|2022-09-14T14:20:42.9734032+08:00;True|2022-09-14T13:51:39.1303401+08:00;True|2022-09-14T13:25:34.8906041+08:00;True|2022-09-14T13:19:28.9172079+08:00;True|2022-09-14T13:18:09.5900815+08:00;True|2022-09-14T10:58:58.0910068+08:00;True|2022-09-14T10:57:11.4834444+08:00;True|2022-09-14T10:45:39.8943674+08:00;True|2022-09-14T10:38:15.2282286+08:00;True|2022-09-14T10:36:54.8259640+08:00;True|2022-09-14T10:14:12.1218790+08:00;True|2022-09-14T10:13:20.0625618+08:00;True|2022-09-14T10:10:15.3538379+08:00;True|2022-09-14T10:07:09.4796434+08:00;True|2022-09-14T10:06:02.0382235+08:00;True|2022-09-14T09:57:12.0082796+08:00;True|2022-09-14T09:52:29.4689029+08:00;True|2022-09-14T09:47:26.7205193+08:00;True|2022-09-14T09:38:56.4089520+08:00;True|2022-09-14T09:32:34.9863473+08:00;True|2022-09-12T13:07:40.5119225+08:00;True|2022-09-09T15:21:48.4251654+08:00;True|2022-09-09T14:45:54.9315147+08:00;True|2022-09-09T11:01:18.2619729+08:00;True|2022-09-09T09:35:40.9779148+08:00;True|2022-09-09T09:26:51.9854326+08:00;True|2022-09-09T09:11:48.8023373+08:00;True|2022-09-09T09:05:45.5528883+08:00;True|2022-09-08T17:47:35.2628987+08:00;True|2022-09-08T17:43:32.6700813+08:00;True|2022-09-08T17:01:23.6259930+08:00;True|2022-09-08T16:55:57.2305777+08:00;True|2022-09-08T16:35:37.3631720+08:00;True|2022-09-08T16:19:13.9122228+08:00;True|2022-09-08T16:04:07.7348285+08:00;True|2022-09-08T16:00:49.9961701+08:00;True|2022-09-08T15:16:03.0110619+08:00;True|2022-09-08T10:19:46.2872822+08:00;True|2022-09-08T10:11:15.5386438+08:00;True|2022-09-08T08:19:02.5242539+08:00;True|2022-09-08T08:18:11.7308721+08:00;True|2022-09-07T11:39:27.2463573+08:00;True|2022-09-07T10:40:57.8877369+08:00;True|2022-09-07T10:37:10.1517098+08:00;True|2022-09-07T10:30:08.7782107+08:00;True|2022-09-07T10:23:52.8534200+08:00;True|2022-09-07T10:09:31.6994230+08:00;True|2022-09-07T10:01:16.2683112+08:00;True|2022-09-07T09:51:47.6282546+08:00;True|2022-09-06T19:11:45.1701913+08:00;True|2022-09-06T18:29:29.2671862+08:00;True|2022-09-06T16:41:04.2719822+08:00;True|2022-09-06T14:17:31.6896132+08:00;True|2022-09-06T13:14:39.9657702+08:00;True|2022-09-05T13:34:47.0627238+08:00;True|2022-09-05T11:07:59.2835592+08:00;True|2022-09-02T14:01:56.1233378+08:00;True|2022-08-31T23:40:49.5468281+08:00;True|2022-08-31T22:15:50.0388123+08:00;True|2022-08-31T19:20:24.7693742+08:00;True|2022-08-31T19:00:06.8271626+08:00;True|2022-08-31T18:45:08.6483670+08:00;True|2022-08-31T16:59:34.8244511+08:00;True|2022-08-31T15:39:51.0653019+08:00;True|2022-08-31T15:25:32.5277796+08:00;True|2022-08-31T13:31:48.5734692+08:00;True|2022-08-31T12:59:02.1022191+08:00;True|2022-08-31T10:06:03.2043884+08:00;True|2022-08-30T17:36:34.5932064+08:00;True|2022-08-30T17:18:12.4582841+08:00;True|2022-08-30T12:55:16.4084322+08:00;True|2022-08-30T10:12:08.0975252+08:00;True|2022-08-30T09:12:46.2845546+08:00;True|2022-08-30T08:58:47.8389468+08:00;True|2022-08-29T17:21:17.7779579+08:00;True|2022-08-29T17:17:49.5334583+08:00;True|2022-08-29T16:53:46.6019453+08:00;True|2022-08-29T16:46:50.8158231+08:00;True|2022-08-29T12:25:19.0140888+08:00;True|2022-08-26T17:02:52.4614637+08:00;True|2022-08-26T16:52:47.8585471+08:00;True|2022-08-26T16:47:02.5766798+08:00;True|2022-08-26T16:36:15.5793109+08:00;True|2022-08-26T16:15:55.1795297+08:00;True|2022-08-26T16:00:22.2697361+08:00;False|2022-08-26T15:58:16.7347649+08:00;True|2022-08-26T15:22:29.6367466+08:00;True|2022-08-25T20:02:24.4685508+08:00;True|2022-08-25T19:50:42.8601696+08:00;True|2022-08-25T15:56:20.3615518+08:00;True|2022-08-25T15:48:16.9923580+08:00;True|2022-08-25T15:27:07.9474640+08:00;True|2022-08-25T13:11:36.9626131+08:00;True|2022-08-24T14:10:58.2790665+08:00;True|2022-08-24T11:43:10.4463552+08:00;True|2022-08-24T08:02:17.9871411+08:00;True|2022-08-23T22:50:41.0238571+08:00;True|2022-08-23T22:16:20.9249814+08:00;True|2022-08-23T21:59:21.1909300+08:00;True|2022-08-23T21:50:40.8106496+08:00;True|2022-08-23T21:06:55.6611505+08:00;True|2022-08-23T19:49:07.0507418+08:00;True|2022-08-23T19:03:15.9808046+08:00;True|2022-08-23T18:58:57.1700899+08:00;True|2022-08-23T18:54:26.8058591+08:00;True|2022-08-23T18:45:39.1928602+08:00;True|2022-08-23T17:32:10.6125039+08:00;True|2022-08-23T15:58:34.9205174+08:00;True|2022-08-23T15:49:21.3383764+08:00;True|2022-08-23T15:14:21.0775398+08:00;True|2022-08-23T15:04:07.8829410+08:00;True|2022-08-23T14:59:17.5143895+08:00;True|2022-08-23T14:55:17.0069050+08:00;True|2022-08-23T14:41:41.0884731+08:00;True|2022-08-23T14:41:06.5045325+08:00;True|2022-08-23T14:28:54.7390570+08:00;True|2022-08-23T13:56:59.3670549+08:00;True|2022-08-23T13:56:38.8588174+08:00;True|2022-08-22T20:48:56.2180227+08:00;True|2022-08-22T19:07:12.1093584+08:00;True|2022-08-22T19:04:07.7837887+08:00;True|2022-08-22T14:38:00.9342884+08:00;True|2022-08-22T10:59:23.2073567+08:00;True|2022-08-22T10:53:58.0920733+08:00;True|2022-08-22T10:53:10.2446944+08:00;True|2022-08-22T10:43:35.3791396+08:00;True|2022-08-18T09:45:46.4643950+08:00;True|2022-08-18T09:40:55.2601145+08:00;True|2022-08-16T16:17:14.3399134+08:00;True|2022-08-15T17:58:16.1460123+08:00;True|2022-08-15T17:55:55.7137518+08:00;True|2022-08-15T17:44:37.6024482+08:00;True|2022-08-15T17:44:21.9583041+08:00;True|2022-08-15T17:43:23.1305690+08:00;True|2022-08-15T17:29:31.1670490+08:00;True|2022-08-15T17:26:42.9269470+08:00;True|2022-08-15T17:23:27.0940168+08:00;True|2022-08-15T17:07:32.9192045+08:00;True|2022-08-15T16:47:03.8611076+08:00;True|2022-08-15T16:41:50.6843705+08:00;True|2022-08-15T16:38:26.7407413+08:00;True|2022-08-15T16:31:49.0805578+08:00;True|2022-08-15T16:27:33.6712012+08:00;True|2022-08-15T16:24:35.1042794+08:00;True|2022-08-15T16:21:57.2757683+08:00;True|2022-08-15T16:18:17.3545368+08:00;True|2022-08-15T16:15:04.2645412+08:00;True|2022-08-15T14:44:09.3078026+08:00;True|2022-08-15T11:20:09.2930712+08:00;True|2022-08-15T10:42:12.2991587+08:00;True|2022-08-15T10:41:38.3711025+08:00;True|2022-08-15T10:19:06.9974383+08:00;True|2022-08-12T17:15:09.2133281+08:00;True|2022-08-12T10:48:05.8776009+08:00;True|2022-08-12T10:26:16.4183447+08:00;True|2022-08-12T08:33:01.9502005+08:00;True|2022-08-11T09:06:08.8394009+08:00;True|2022-08-11T08:39:06.2534634+08:00;True|2022-08-11T08:05:13.6919725+08:00;True|2022-08-08T14:48:16.3637965+08:00;True|2022-08-05T15:44:02.3797448+08:00;True|2022-08-05T09:57:55.7744103+08:00;True|2022-08-04T15:24:38.8785046+08:00;True|2022-08-04T15:11:16.7054147+08:00;True|2022-08-04T14:53:52.7239932+08:00;True|2022-08-04T14:48:35.6115863+08:00;True|2022-08-04T14:39:16.1113507+08:00;True|2022-08-04T12:26:39.4998322+08:00;True|2022-08-04T10:34:23.9626503+08:00;True|2022-08-04T08:12:51.4305728+08:00;True|2022-08-03T15:43:09.2317512+08:00;True|2022-08-02T19:17:55.0460145+08:00;True|2022-08-02T19:08:13.5872184+08:00;True|2022-08-02T18:50:12.1280167+08:00;True|2022-08-02T18:05:53.6540810+08:00;True|2022-08-02T16:13:26.3567210+08:00;True|2022-08-02T15:27:59.9264333+08:00;True|2022-07-25T15:35:49.6958399+08:00;True|2022-07-25T15:30:40.4444876+08:00;True|2022-07-25T13:33:38.4068153+08:00;True|2022-07-22T15:00:56.7326322+08:00;True|2022-07-22T14:51:18.0169121+08:00;True|2022-07-22T14:26:08.4246205+08:00;True|2022-07-22T14:23:05.0897016+08:00;True|2022-07-22T14:18:18.7806854+08:00;True|2022-07-22T14:09:29.7924367+08:00;True|2022-07-22T14:02:26.6403133+08:00;True|2022-07-22T13:56:40.0887615+08:00;True|2022-07-22T13:50:10.7852190+08:00;True|2022-07-22T11:38:25.6671780+08:00;True|2022-07-22T10:55:36.7947659+08:00;True|2022-07-21T17:53:41.1464086+08:00;True|2022-07-21T17:43:33.5311479+08:00;True|2022-07-21T16:09:07.7687640+08:00;True|2022-07-21T16:04:47.9317019+08:00;True|2022-07-21T15:58:21.2359033+08:00;True|2022-07-21T15:56:07.7425829+08:00;True|2022-07-21T15:51:34.7108381+08:00;True|2022-07-21T15:48:57.5735708+08:00;True|2022-07-21T15:44:25.8205030+08:00;True|2022-07-21T15:25:51.4222269+08:00;True|2022-07-21T15:22:36.8818295+08:00;True|2022-07-21T15:19:28.8532774+08:00;True|2022-07-21T14:57:45.7532568+08:00;True|2022-07-21T11:16:12.0900762+08:00;True|2022-07-21T10:10:40.4714948+08:00;True|2022-07-21T10:00:19.5258058+08:00;True|2022-07-14T14:34:28.5093226+08:00;True|2022-07-14T13:59:59.7754985+08:00;True|2022-07-14T12:46:29.6685284+08:00;True|2022-07-14T09:22:25.9079652+08:00;True|2022-07-14T09:22:04.6797478+08:00;True|2022-07-14T09:10:45.0177607+08:00;True|2022-07-14T08:41:43.3026713+08:00;True|2022-07-14T08:27:32.7454972+08:00;True|2022-07-14T08:21:58.6572366+08:00;True|2022-07-14T08:17:59.2904747+08:00;True|2022-07-14T08:12:39.8483472+08:00;True|2022-06-30T15:04:41.6941982+08:00;True|2022-06-24T16:39:01.1080301+08:00;True|2022-06-17T13:23:15.1455451+08:00;True|2022-06-17T13:22:18.5517557+08:00;True|2022-06-17T13:19:27.7323818+08:00;True|2022-06-17T13:12:24.1252779+08:00;True|2022-06-17T13:09:20.4234258+08:00;True|2022-06-17T13:06:49.9869509+08:00;True|2022-06-17T12:58:54.6964621+08:00;False|2022-06-17T12:58:10.6767711+08:00;False|2022-06-17T12:57:08.9747950+08:00;False|2022-06-17T12:56:18.4650121+08:00;False|2022-06-17T12:55:57.9981927+08:00;True|2022-06-13T14:21:36.5610928+08:00;True|2022-06-13T11:41:39.4210151+08:00;True|2022-06-11T02:35:03.4727934+08:00;True|2022-06-11T02:31:13.7362660+08:00;True|2022-06-11T02:30:58.3616790+08:00;True|2022-06-11T01:57:04.4951468+08:00;True|2022-06-10T13:27:13.2097124+08:00;</History> |
| | | </PropertyGroup> |
| | | <ItemGroup> |
| | | <File Include="Areas/HelpPage/HelpPage.css"> |
| | |
| | | <publishTime>12/24/2021 15:38:29</publishTime> |
| | | </File> |
| | | <File Include="bin/VueWebApi.dll"> |
| | | <publishTime>05/19/2023 13:58:17</publishTime> |
| | | <publishTime>06/01/2023 14:25:56</publishTime> |
| | | </File> |
| | | <File Include="bin/VueWebApi.dll.config"> |
| | | <publishTime>06/15/2022 15:31:43</publishTime> |
| | | </File> |
| | | <File Include="bin/VueWebApi.pdb"> |
| | | <publishTime>05/19/2023 13:58:17</publishTime> |
| | | <publishTime>06/01/2023 14:25:56</publishTime> |
| | | </File> |
| | | <File Include="bin/VueWebApi.xml"> |
| | | <publishTime>05/19/2023 13:58:17</publishTime> |
| | | <publishTime>06/01/2023 14:25:56</publishTime> |
| | | </File> |
| | | <File Include="bin/WebActivatorEx.dll"> |
| | | <publishTime>02/08/2013 16:42:28</publishTime> |
| | |
| | | <publishTime>08/11/2022 08:20:52</publishTime> |
| | | </File> |
| | | <File Include="Image/app_1.png"> |
| | | <publishTime>08/30/2022 10:11:46</publishTime> |
| | | <publishTime>08/11/2022 16:01:00</publishTime> |
| | | </File> |
| | | <File Include="Image/app_1_1.png"> |
| | | <publishTime>08/30/2022 10:11:46</publishTime> |
| | | <publishTime>08/11/2022 17:50:13</publishTime> |
| | | </File> |
| | | <File Include="Image/app_1_2.png"> |
| | | <publishTime>08/30/2022 10:11:46</publishTime> |
| | | <publishTime>08/11/2022 17:52:44</publishTime> |
| | | </File> |
| | | <File Include="Image/app_1_3.png"> |
| | | <publishTime>05/24/2023 08:22:19</publishTime> |
| | | </File> |
| | | <File Include="Image/app_2.png"> |
| | | <publishTime>08/30/2022 10:11:46</publishTime> |
| | | <publishTime>08/11/2022 16:26:50</publishTime> |
| | | </File> |
| | | <File Include="Image/app_3.png"> |
| | | <publishTime>08/30/2022 10:11:46</publishTime> |
| | | <publishTime>08/11/2022 16:36:55</publishTime> |
| | | </File> |
| | | <File Include="Image/app_3_1.png"> |
| | | <publishTime>08/30/2022 10:11:46</publishTime> |
| | | <publishTime>08/11/2022 17:56:50</publishTime> |
| | | </File> |
| | | <File Include="Image/app_3_2.png"> |
| | | <publishTime>08/30/2022 10:11:46</publishTime> |
| | | <publishTime>08/11/2022 17:58:41</publishTime> |
| | | </File> |
| | | <File Include="Image/app_4.png"> |
| | | <publishTime>08/30/2022 10:11:46</publishTime> |
| | | <publishTime>08/11/2022 16:45:29</publishTime> |
| | | </File> |
| | | <File Include="Image/app_4_1.png"> |
| | | <publishTime>08/30/2022 10:11:46</publishTime> |
| | | <publishTime>08/11/2022 18:21:11</publishTime> |
| | | </File> |
| | | <File Include="Image/app_4_2.png"> |
| | | <publishTime>08/30/2022 10:11:46</publishTime> |
| | | <publishTime>08/11/2022 18:34:58</publishTime> |
| | | </File> |
| | | <File Include="Image/app_4_3.png"> |
| | | <publishTime>08/30/2022 10:11:46</publishTime> |
| | | <publishTime>08/15/2022 10:56:14</publishTime> |
| | | </File> |
| | | <File Include="Image/app_4_4.png"> |
| | | <publishTime>08/30/2022 10:11:46</publishTime> |
| | | <publishTime>08/15/2022 11:10:31</publishTime> |
| | | </File> |
| | | <File Include="Image/app_4_5.png"> |
| | | <publishTime>09/26/2022 13:30:58</publishTime> |
| | | </File> |
| | | <File Include="Image/app_5.png"> |
| | | <publishTime>08/30/2022 10:11:46</publishTime> |
| | | <publishTime>08/11/2022 16:49:33</publishTime> |
| | | </File> |
| | | <File Include="Image/app_5_1.png"> |
| | | <publishTime>08/30/2022 10:11:46</publishTime> |
| | | <publishTime>08/19/2022 08:43:07</publishTime> |
| | | </File> |
| | | <File Include="Image/app_5_2.png"> |
| | | <publishTime>08/30/2022 10:11:46</publishTime> |
| | | <publishTime>08/19/2022 08:50:32</publishTime> |
| | | </File> |
| | | <File Include="Image/app_5_3.png"> |
| | | <publishTime>08/30/2022 10:11:46</publishTime> |
| | | <publishTime>08/19/2022 09:06:09</publishTime> |
| | | </File> |
| | | <File Include="Image/app_5_4.png"> |
| | | <publishTime>08/30/2022 10:11:46</publishTime> |
| | | <publishTime>08/19/2022 09:08:44</publishTime> |
| | | </File> |
| | | <File Include="Image/app_5_5.png"> |
| | | <publishTime>08/30/2022 10:11:46</publishTime> |
| | | <publishTime>08/19/2022 09:11:02</publishTime> |
| | | </File> |
| | | <File Include="Image/app_5_6.png"> |
| | | <publishTime>08/30/2022 10:11:46</publishTime> |
| | | <publishTime>08/19/2022 09:20:23</publishTime> |
| | | </File> |
| | | <File Include="Image/app_5_7.png"> |
| | | <publishTime>08/30/2022 10:11:46</publishTime> |
| | | <publishTime>08/19/2022 09:22:07</publishTime> |
| | | </File> |
| | | <File Include="Image/app_5_8.png"> |
| | | <publishTime>08/30/2022 10:11:46</publishTime> |
| | | <publishTime>08/19/2022 09:44:32</publishTime> |
| | | </File> |
| | | <File Include="Image/app_5_9.png"> |
| | | <publishTime>08/30/2022 10:11:46</publishTime> |
| | | <publishTime>08/19/2022 09:45:37</publishTime> |
| | | </File> |
| | | <File Include="Image/app_6.png"> |
| | | <publishTime>08/30/2022 10:11:46</publishTime> |
| | | <publishTime>08/11/2022 17:06:12</publishTime> |
| | | </File> |
| | | <File Include="Image/app_6_1.png"> |
| | | <publishTime>08/30/2022 10:11:46</publishTime> |
| | | <publishTime>08/19/2022 10:21:21</publishTime> |
| | | </File> |
| | | <File Include="Image/app_6_10.png"> |
| | | <publishTime>08/30/2022 10:11:46</publishTime> |
| | | <publishTime>08/19/2022 11:44:16</publishTime> |
| | | </File> |
| | | <File Include="Image/app_6_11.png"> |
| | | <publishTime>08/30/2022 10:11:46</publishTime> |
| | | <publishTime>08/22/2022 11:40:51</publishTime> |
| | | </File> |
| | | <File Include="Image/app_6_12.png"> |
| | | <publishTime>08/30/2022 10:11:46</publishTime> |
| | | <publishTime>08/22/2022 11:35:34</publishTime> |
| | | </File> |
| | | <File Include="Image/app_6_13.png"> |
| | | <publishTime>08/30/2022 10:11:46</publishTime> |
| | | <publishTime>08/22/2022 12:04:47</publishTime> |
| | | </File> |
| | | <File Include="Image/app_6_14.png"> |
| | | <publishTime>08/30/2022 10:11:46</publishTime> |
| | | <publishTime>08/22/2022 12:07:20</publishTime> |
| | | </File> |
| | | <File Include="Image/app_6_2.png"> |
| | | <publishTime>08/30/2022 10:11:46</publishTime> |
| | | <publishTime>08/19/2022 10:23:11</publishTime> |
| | | </File> |
| | | <File Include="Image/app_6_3.png"> |
| | | <publishTime>08/30/2022 10:11:46</publishTime> |
| | | <publishTime>08/19/2022 10:40:17</publishTime> |
| | | </File> |
| | | <File Include="Image/app_6_4.png"> |
| | | <publishTime>08/30/2022 10:11:46</publishTime> |
| | | <publishTime>08/19/2022 10:43:18</publishTime> |
| | | </File> |
| | | <File Include="Image/app_6_5.png"> |
| | | <publishTime>08/30/2022 10:11:46</publishTime> |
| | | <publishTime>08/19/2022 10:54:32</publishTime> |
| | | </File> |
| | | <File Include="Image/app_6_6.png"> |
| | | <publishTime>08/30/2022 10:11:46</publishTime> |
| | | <publishTime>08/19/2022 10:57:24</publishTime> |
| | | </File> |
| | | <File Include="Image/app_6_7.png"> |
| | | <publishTime>08/30/2022 10:11:46</publishTime> |
| | | <publishTime>08/19/2022 11:03:26</publishTime> |
| | | </File> |
| | | <File Include="Image/app_6_8.png"> |
| | | <publishTime>08/30/2022 10:11:46</publishTime> |
| | | <publishTime>08/19/2022 11:09:23</publishTime> |
| | | </File> |
| | | <File Include="Image/app_6_9.png"> |
| | | <publishTime>08/30/2022 10:11:46</publishTime> |
| | | <publishTime>08/19/2022 11:22:26</publishTime> |
| | | </File> |
| | | <File Include="Image/app_7.png"> |
| | | <publishTime>08/30/2022 10:11:46</publishTime> |
| | | <publishTime>08/11/2022 17:11:08</publishTime> |
| | | </File> |
| | | <File Include="Image/app_7_1.png"> |
| | | <publishTime>08/30/2022 10:11:46</publishTime> |
| | | <publishTime>08/30/2022 09:55:08</publishTime> |
| | | </File> |
| | | <File Include="Image/app_7_2.png"> |
| | | <publishTime>08/30/2022 10:11:44</publishTime> |
| | | <publishTime>08/30/2022 10:10:08</publishTime> |
| | | </File> |
| | | <File Include="Image/app_7_3.png"> |
| | | <publishTime>08/30/2022 10:11:46</publishTime> |
| | | <publishTime>08/30/2022 09:36:11</publishTime> |
| | | </File> |
| | | <File Include="Image/app_7_4.png"> |
| | | <publishTime>08/30/2022 10:11:46</publishTime> |
| | | <publishTime>08/30/2022 09:46:50</publishTime> |
| | | </File> |
| | | <File Include="Image/app_8.png"> |
| | | <publishTime>08/30/2022 10:11:46</publishTime> |
| | | <publishTime>08/11/2022 17:29:21</publishTime> |
| | | </File> |
| | | <File Include="Image/app_8_1.png"> |
| | | <publishTime>05/17/2023 09:22:00</publishTime> |
| | | <publishTime>05/25/2023 10:50:06</publishTime> |
| | | </File> |
| | | <File Include="Image/app_8_2.png"> |
| | | <publishTime>05/25/2023 10:50:55</publishTime> |
| | | </File> |
| | | <File Include="Image/app_8_3.png"> |
| | | <publishTime>05/17/2023 09:19:44</publishTime> |
| | | </File> |
| | | <File Include="Image/app_8_7.png"> |
| | | <publishTime>04/04/2023 15:22:25</publishTime> |
| | | <publishTime>04/04/2023 15:18:56</publishTime> |
| | | </File> |
| | | <File Include="Image/app_9.png"> |
| | | <publishTime>08/30/2022 10:11:46</publishTime> |
| | | <publishTime>08/11/2022 17:36:50</publishTime> |
| | | </File> |
| | | <File Include="Image/app_9_1.png"> |
| | | <publishTime>01/03/2023 11:11:06</publishTime> |
| | | <publishTime>01/03/2023 10:54:40</publishTime> |
| | | </File> |
| | | <File Include="Image/app_9_2.png"> |
| | | <publishTime>05/17/2023 09:07:41</publishTime> |
| | | <publishTime>05/17/2023 08:46:43</publishTime> |
| | | </File> |
| | | <File Include="Image/app_9_3.png"> |
| | | <publishTime>05/17/2023 09:07:41</publishTime> |
| | | <publishTime>05/17/2023 09:04:42</publishTime> |
| | | </File> |
| | | <File Include="Image/app_9_4.png"> |
| | | <publishTime>05/17/2023 09:07:41</publishTime> |
| | | <publishTime>05/17/2023 09:02:12</publishTime> |
| | | </File> |
| | | <File Include="Image/app_9_5.png"> |
| | | <publishTime>05/17/2023 09:07:41</publishTime> |
| | | <publishTime>05/17/2023 08:24:38</publishTime> |
| | | </File> |
| | | <File Include="Image/index_1.png"> |
| | | <publishTime>08/30/2022 10:11:46</publishTime> |
| | | <publishTime>08/15/2022 14:13:17</publishTime> |
| | | </File> |
| | | <File Include="Image/index_2.png"> |
| | | <publishTime>08/30/2022 10:11:46</publishTime> |
| | | <publishTime>08/15/2022 14:13:29</publishTime> |
| | | </File> |
| | | <File Include="index.html"> |
| | | <publishTime>06/30/2022 14:02:46</publishTime> |
| | |
| | | <publishTime>06/10/2022 08:20:24</publishTime> |
| | | </File> |
| | | <File Include="Web.config"> |
| | | <publishTime>05/19/2023 13:58:21</publishTime> |
| | | <publishTime>06/01/2023 14:26:01</publishTime> |
| | | </File> |
| | | </ItemGroup> |
| | | </Project> |
| | |
| | | } |
| | | return result; |
| | | } |
| | | /// <summary> |
| | | /// æ§è¡sqlæ§è¡è¯å¥,è¿åå符串 |
| | | /// </summary> |
| | | /// <param name="sql"></param> |
| | | /// <returns></returns> |
| | | public static string sqlstr(String sql) |
| | | { |
| | | |
| | | string result = ""; |
| | | using (IDbConnection conn = sqlConnection()) |
| | | { |
| | | try |
| | | { |
| | | if (result == "") |
| | | { |
| | | result = conn.Query<string>(sql).First(); |
| | | } |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | //å建æ¥å¿è®°å½ç»ä»¶å®ä¾ |
| | | LogHelper.WriteLog(ex); |
| | | throw ex; |
| | | } |
| | | finally |
| | | { |
| | | conn.Dispose(); |
| | | conn.Close(); |
| | | } |
| | | } |
| | | return result; |
| | | } |
| | | |
| | | public static DataTable lissql(string sql) |
| | | { |
| | | //sqlè¯å¥ |
| | | using (IDbConnection conn = sqlConnection()) |
| | | { |
| | | try |
| | | { |
| | | DataTable table = new DataTable(); |
| | | //var data = conn.ExecuteReader(sql, parm); |
| | | var res = conn.ExecuteReader(sql);//sql åå¨è¿ç¨ |
| | | table.Load(res); |
| | | return table; |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | //å建æ¥å¿è®°å½ç»ä»¶å®ä¾ |
| | | LogHelper.WriteLog(ex); |
| | | throw ex; |
| | | } |
| | | finally |
| | | { |
| | | conn.Dispose(); |
| | | conn.Close(); |
| | | } |
| | | } |
| | | } |
| | | } |
| | | } |
| ¶Ô±ÈÐÂÎļþ |
| | |
| | | using Dapper; |
| | | using System; |
| | | using System.Collections.Generic; |
| | | using System.Linq; |
| | | using System.Web; |
| | | |
| | | namespace VueWebApi.Tools |
| | | { |
| | | public class SeachEncodeJob |
| | | { |
| | | public static ToMessage mes = new ToMessage(); //å®ä¹å
¨å±è¿åä¿¡æ¯å¯¹è±¡ |
| | | |
| | | #region [è·åè§åç¼ç çæçæ¡ç ] |
| | | /// <summary> |
| | | /// æ ¹æ®åè½ç¼ç è·åææ°è§åç¼ç |
| | | /// </summary> |
| | | /// <param name="rightcode">åè½ç¼ç </param> |
| | | /// <returns></returns> |
| | | public static ToMessage EncodingSeach(string rightcode) |
| | | { |
| | | string sql, year, month, day, fdate, q, cunm2, Encode; |
| | | int digit2, value2, digit3, digitdiff; |
| | | bool stf; |
| | | List<object> list = new List<object>(); |
| | | List<string> listdt = new List<string>(); |
| | | var dynamicParams = new DynamicParameters(); |
| | | try |
| | | { |
| | | sql = @"select prefix,filingdate,incbit,value from T_CodeRules where rightcode=@rightcode"; |
| | | dynamicParams.Add("@rightcode", rightcode); |
| | | var data = DapperHelper.selectdata(sql, dynamicParams); |
| | | if (data.Rows.Count > 0) |
| | | { |
| | | string prefix = data.Rows[0]["PREFIX"].ToString(); //åºå®å段 |
| | | string filingdate = data.Rows[0]["FILINGDATE"].ToString(); //æäº¤æ¥æ |
| | | int incbit = int.Parse(data.Rows[0]["INCBIT"].ToString()); //èªå¢ä½æ° |
| | | string value = data.Rows[0]["VALUE"].ToString(); //æµæ°´å· |
| | | if (int.Parse(value) > 0) //夿æ¯å¦ä¸ºé¦æ¬¡è·å |
| | | { |
| | | switch (filingdate) |
| | | { |
| | | case "å¹´ææ¥": |
| | | year = DateTime.Now.Year.ToString().Substring(2, 2);//è·åå¹´(2ä½) |
| | | month = DateTime.Now.Month.ToString().PadLeft(2, '0');//è·åæ(2ä½) |
| | | day = DateTime.Now.Day.ToString().PadLeft(2, '0');//è·åæ¥(2ä½) |
| | | fdate = year + month + day; |
| | | digit2 = value.Length;//è·åstringç±»å使° |
| | | value2 = int.Parse(value) + 1;// å°stringç±»å转å为intèªå¢1 |
| | | digit3 = value2.ToString().Length; //è·å转ååintåç使° |
| | | digitdiff = digit2 - digit3; //使°ä¹å·® |
| | | q = ""; |
| | | if (digitdiff < 0) //使°å·®ä¸ºè´æ°éè¦è¿è¡¥ä½ |
| | | { |
| | | cunm2 = value2.ToString();//æç»æµæ°´å· |
| | | } |
| | | else |
| | | { |
| | | for (int i = 1; i <= digitdiff; i++) |
| | | { |
| | | q = q + "0"; |
| | | } |
| | | cunm2 = q + value2.ToString();//æç»æµæ°´å· |
| | | } |
| | | Encode = prefix + fdate + cunm2; //æç»ç¼ç |
| | | listdt.Add(Encode); |
| | | listdt.Add(cunm2); |
| | | mes.code = "200"; |
| | | mes.Message = "æå!"; |
| | | mes.data = listdt; |
| | | break; |
| | | case "å¹´æ": |
| | | year = DateTime.Now.Year.ToString().Substring(2, 2);//è·åå¹´(2ä½) |
| | | month = DateTime.Now.Month.ToString().PadLeft(2, '0');//è·åæ(2ä½) |
| | | fdate = year + month; |
| | | digit2 = value.Length;//è·åstringç±»å使° |
| | | value2 = int.Parse(value) + 1;// å°stringç±»å转å为intèªå¢1 |
| | | digit3 = value2.ToString().Length; //è·å转ååintåç使° |
| | | digitdiff = digit2 - digit3; //使°ä¹å·® |
| | | q = ""; |
| | | if (digitdiff < 0) //使°å·®ä¸ºè´æ°éè¦è¿è¡¥ä½ |
| | | { |
| | | cunm2 = value2.ToString();//æç»æµæ°´å· |
| | | } |
| | | else |
| | | { |
| | | for (int i = 1; i <= digitdiff; i++) |
| | | { |
| | | q = q + "0"; |
| | | } |
| | | cunm2 = q + value2.ToString();//æç»æµæ°´å· |
| | | } |
| | | Encode = prefix + fdate + cunm2; //æç»ç¼ç |
| | | listdt.Add(Encode); |
| | | listdt.Add(cunm2); |
| | | mes.code = "200"; |
| | | mes.Message = "æå!"; |
| | | mes.data = listdt; |
| | | break; |
| | | case "å¹´": |
| | | year = DateTime.Now.Year.ToString().Substring(2, 2);//è·åå¹´(2ä½) |
| | | fdate = year; |
| | | digit2 = value.Length;//è·åstringç±»å使° |
| | | value2 = int.Parse(value) + 1;// å°stringç±»å转å为intèªå¢1 |
| | | digit3 = value2.ToString().Length; //è·å转ååintåç使° |
| | | digitdiff = digit2 - digit3; //使°ä¹å·® |
| | | q = ""; |
| | | if (digitdiff < 0) //使°å·®ä¸ºè´æ°éè¦è¿è¡¥ä½ |
| | | { |
| | | cunm2 = value2.ToString();//æç»æµæ°´å· |
| | | } |
| | | else |
| | | { |
| | | for (int i = 1; i <= digitdiff; i++) |
| | | { |
| | | q = q + "0"; |
| | | } |
| | | cunm2 = q + value2.ToString();//æç»æµæ°´å· |
| | | } |
| | | Encode = prefix + fdate + cunm2; //æç»ç¼ç |
| | | |
| | | listdt.Add(Encode); |
| | | listdt.Add(cunm2); |
| | | mes.code = "200"; |
| | | mes.Message = "æå!"; |
| | | mes.data = listdt; |
| | | |
| | | break; |
| | | default: |
| | | break; |
| | | } |
| | | } |
| | | else |
| | | { |
| | | switch (filingdate) |
| | | { |
| | | case "å¹´ææ¥": |
| | | year = DateTime.Now.Year.ToString().Substring(2, 2);//è·åå¹´(2ä½) |
| | | month = DateTime.Now.Month.ToString().PadLeft(2, '0');//è·åæ(2ä½) |
| | | day = DateTime.Now.Day.ToString().PadLeft(2, '0');//è·åæ¥(2ä½) |
| | | fdate = year + month + day; |
| | | digit2 = value.Length;//è·åstringç±»å使° |
| | | value2 = int.Parse(value) + 1;// å°stringç±»å转å为intèªå¢1 |
| | | digit3 = value2.ToString().Length; //è·å转ååintåç使° |
| | | digitdiff = digit2 - digit3; //使°ä¹å·® |
| | | q = ""; |
| | | if (digitdiff < 0) //使°å·®ä¸ºè´æ°éè¦è¿è¡¥ä½ |
| | | { |
| | | cunm2 = value2.ToString();//æç»æµæ°´å· |
| | | } |
| | | else |
| | | { |
| | | for (int i = 1; i <= digitdiff; i++) |
| | | { |
| | | q = q + "0"; |
| | | } |
| | | cunm2 = q + value2.ToString();//æç»æµæ°´å· |
| | | } |
| | | Encode = prefix + fdate + cunm2; //æç»ç¼ç |
| | | |
| | | listdt.Add(Encode); |
| | | listdt.Add(cunm2); |
| | | mes.code = "200"; |
| | | mes.Message = "æå!"; |
| | | mes.data = listdt; |
| | | break; |
| | | case "å¹´æ": |
| | | year = DateTime.Now.Year.ToString().Substring(2, 2);//è·åå¹´(2ä½) |
| | | month = DateTime.Now.Month.ToString().PadLeft(2, '0');//è·åæ(2ä½) |
| | | fdate = year + month; |
| | | digit2 = value.Length;//è·åstringç±»å使° |
| | | value2 = int.Parse(value) + 1;// å°stringç±»å转å为intèªå¢1 |
| | | digit3 = value2.ToString().Length; //è·å转ååintåç使° |
| | | digitdiff = digit2 - digit3; //使°ä¹å·® |
| | | q = ""; |
| | | if (digitdiff < 0) //使°å·®ä¸ºè´æ°éè¦è¿è¡¥ä½ |
| | | { |
| | | cunm2 = value2.ToString();//æç»æµæ°´å· |
| | | } |
| | | else |
| | | { |
| | | for (int i = 1; i <= digitdiff; i++) |
| | | { |
| | | q = q + "0"; |
| | | } |
| | | cunm2 = q + value2.ToString();//æç»æµæ°´å· |
| | | } |
| | | Encode = prefix + fdate + cunm2; //æç»ç¼ç |
| | | |
| | | |
| | | listdt.Add(Encode); |
| | | listdt.Add(cunm2); |
| | | mes.code = "200"; |
| | | mes.Message = "æå!"; |
| | | mes.data = listdt; |
| | | break; |
| | | case "å¹´": |
| | | year = DateTime.Now.Year.ToString().Substring(2, 2);//è·åå¹´(2ä½) |
| | | fdate = year; |
| | | digit2 = value.Length;//è·åstringç±»å使° |
| | | value2 = int.Parse(value) + 1;// å°stringç±»å转å为intèªå¢1 |
| | | digit3 = value2.ToString().Length; //è·å转ååintåç使° |
| | | digitdiff = digit2 - digit3; //使°ä¹å·® |
| | | q = ""; |
| | | if (digitdiff < 0) //使°å·®ä¸ºè´æ°éè¦è¿è¡¥ä½ |
| | | { |
| | | cunm2 = value2.ToString();//æç»æµæ°´å· |
| | | } |
| | | else |
| | | { |
| | | for (int i = 1; i <= digitdiff; i++) |
| | | { |
| | | q = q + "0"; |
| | | } |
| | | cunm2 = q + value2.ToString();//æç»æµæ°´å· |
| | | } |
| | | Encode = prefix + fdate + cunm2; //æç»ç¼ç |
| | | |
| | | listdt.Add(Encode); |
| | | listdt.Add(cunm2); |
| | | mes.code = "200"; |
| | | mes.Message = "æå!"; |
| | | mes.data = listdt; |
| | | break; |
| | | default: |
| | | break; |
| | | } |
| | | } |
| | | } |
| | | else |
| | | { |
| | | mes.code = "300"; |
| | | mes.count = 0; |
| | | mes.Message = "æªè®¾ç½®ç¼ç è§å,çæåå·å¤±è´¥,请设置ç¼ç 为ã" + rightcode + "ãçç¼ç è§å!"; |
| | | mes.data = null; |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | mes.code = "300"; |
| | | mes.count = 0; |
| | | mes.Message = e.Message; |
| | | mes.data = null; |
| | | } |
| | | return mes; |
| | | } |
| | | #endregion |
| | | |
| | | #region[æ´æ°æ¡ç è§å表] |
| | | /// <summary> |
| | | /// æ´æ°æ¡ç è§å表 |
| | | /// </summary> |
| | | /// <param name="rightcode">åè½ç¼ç </param> |
| | | /// <param name="incbit">æµæ°´å·</param> |
| | | /// <returns></returns> |
| | | public static List<object> StrEncodingUpdate(string rightcode,string incbit) |
| | | { |
| | | List<object> list = new List<object>(); |
| | | list.Clear(); |
| | | string sql = @"update T_CodeRules set value=@cunm2,incbit=@incbit where rightcode=@rightcode"; |
| | | list.Add(new { str = sql, parm = new { rightcode = rightcode, cunm2 = Convert.ToInt32(incbit), incbit=incbit.Length } }); |
| | | return list; |
| | | } |
| | | #endregion |
| | | } |
| | | } |
| | |
| | | <Compile Include="Tools\ScanStartReport.cs" /> |
| | | <Compile Include="Tools\SchedulingMethod.cs" /> |
| | | <Compile Include="Tools\SeachEncode.cs" /> |
| | | <Compile Include="Tools\SeachEncodeJob.cs" /> |
| | | <Compile Include="Tools\SessionControllerRouteHandler.cs" /> |
| | | <Compile Include="Tools\SessionRouteHandler.cs" /> |
| | | <Compile Include="Tools\TJson.cs" /> |
| | |
| | | <Content Include="Image\app_1.png" /> |
| | | <Content Include="Image\app_1_1.png" /> |
| | | <Content Include="Image\app_1_2.png" /> |
| | | <Content Include="Image\app_1_3.png" /> |
| | | <Content Include="Image\app_2.png" /> |
| | | <Content Include="Image\app_3.png" /> |
| | | <Content Include="Image\app_3_1.png" /> |
| | |
| | | <Content Include="Image\app_7_4.png" /> |
| | | <Content Include="Image\app_8.png" /> |
| | | <Content Include="Image\app_8_1.png" /> |
| | | <Content Include="Image\app_8_2.png" /> |
| | | <Content Include="Image\app_8_3.png" /> |
| | | <Content Include="Image\app_8_7.png" /> |
| | | <Content Include="Image\app_9.png" /> |
| | | <Content Include="Image\app_9_1.png" /> |
| | |
| | | <param name="param">åè´§ä¿¡æ¯</param> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:VueWebApi.Controllers.BaseDateController.ErpWkshopDepartmentSelect"> |
| | | <summary> |
| | | ERPç产车é´/é¨é¨ä¿¡æ¯æ¥è¯¢ |
| | | </summary> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:VueWebApi.Controllers.BaseDateController.ErpWarehouseSelect"> |
| | | <summary> |
| | | ERPçä»åºä¿¡æ¯æ¥è¯¢ |
| | | </summary> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:VueWebApi.Controllers.BaseDateController.ErpUserSelect"> |
| | | <summary> |
| | | ERPçç¨æ·ä¿¡æ¯æ¥è¯¢ |
| | | </summary> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:VueWebApi.Controllers.PurchaseOrderController.PurchaseOrderSearch(System.String,System.String,System.String,System.String,System.String,System.String,System.String,System.String,System.Int32,System.Int32,System.String,System.String)"> |
| | | <summary> |
| | | éè´è®¢åæ¥è¯¢ |
| | |
| | | </summary> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:VueWebApi.Controllers.ProductionManagementController.ProductInHouseLabCode(System.String)"> |
| | | <summary> |
| | | ç产å
¥åºæ¡ç è¡¥æ |
| | | </summary> |
| | | <param name="ordercode">å·¥åç¼å·</param> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:VueWebApi.Controllers.ProductionManagementController.ProductInHouseWkshopOrder(System.String,System.String)"> |
| | | <summary> |
| | | ç产å
¥åºéè¿è½¦é´æ¥æ¾ç产订å |
| | | </summary> |
| | | <param name="ordertype">åæ®ç±»å</param> |
| | | <param name="wkshopcode">车é´ç¼ç </param> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:VueWebApi.Controllers.ProductionManagementController.ProductInHouseOrderSearch(System.String,System.String,System.String,System.String,System.String,System.String,System.String)"> |
| | | <summary> |
| | | ç产å
¥åºä¿¡æ¯æ¥è¯¢ |
| | | </summary> |
| | | <param name="wkshopcode">车é´ç¼ç </param> |
| | | <param name="erpordercode">订åç¼å·</param> |
| | | <param name="mesordercode">å·¥åç¼å·</param> |
| | | <param name="partcode">产åç¼ç </param> |
| | | <param name="partname">产ååç§°</param> |
| | | <param name="partspec">è§æ ¼åå·</param> |
| | | <param name="orderdate">工忥æ</param> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:VueWebApi.Controllers.ProductionManagementController.ProductInHouseOrderCodeSearch(System.String)"> |
| | | <summary> |
| | | ç产å
¥åºè·ååæ®å· |
| | | </summary> |
| | | <param name="rightcode">åè½ç¼ç </param> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:VueWebApi.Controllers.ProductionManagementController.ProductInHouseOrderSeave(Newtonsoft.Json.Linq.JObject)"> |
| | | <summary> |
| | | ç产å
¥åºæäº¤ |
| | | </summary> |
| | | <param name="wkshp_code">车é´ç¼ç </param> |
| | | <param name="erporder_code">订åç¼å·</param> |
| | | <param name="wo_code">å·¥åç¼å·</param> |
| | | <param name="saleorder_code">éå®è®¢åå·</param> |
| | | <param name="orderdate">åæ®æ¥æ</param> |
| | | <param name="ordercode">åæ®ç¼ç </param> |
| | | <param name="storehousecode">ä»åºç¼ç </param> |
| | | <param name="obj">æç»æ°æ®</param> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:VueWebApi.Controllers.ProductModelController.StockTypeSelect"> |
| | | <summary> |
| | | åè´§ç±»åæ¥å£ |
| | |
| | | <param name="rightcode">åè½ç¼ç </param> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:VueWebApi.Controllers.SystemSettingController.LabelBarCode(System.String,System.String,System.String,System.String)"> |
| | | <summary> |
| | | çæç³»ç»æ¡ç (èªå®ä¹) |
| | | </summary> |
| | | <param name="rightcode">åè½ç¼ç </param> |
| | | <param name="partcode">ç©æç¼ç </param> |
| | | <param name="qty">æ°é</param> |
| | | <param name="onelabqty">åæ ç¾æ°é</param> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:VueWebApi.Controllers.SystemSettingController.SystemAnnouncementSearch(System.String,System.String,System.String,System.String,System.String,System.Int32,System.Int32,System.String,System.String)"> |
| | | <summary> |
| | | 车é´å
¬åå表 |
| | |
| | | <param name="tableName">å¾
æå
¥æ°æ®ç表å</param> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:VueWebApi.Tools.DapperHelper.sqlstr(System.String)"> |
| | | <summary> |
| | | æ§è¡sqlæ§è¡è¯å¥,è¿åå符串 |
| | | </summary> |
| | | <param name="sql"></param> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:VueWebApi.Tools.DataOperator.ExecuteSqlTran(System.Collections.Generic.List{System.String},System.Data.SqlClient.SqlParameter[])"> |
| | | <summary> |
| | | æ§è¡å¤æ¡SQLè¯å¥ï¼å®ç°æ°æ®åºäºå¡ã |
| | |
| | | <param name="type"></param> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:VueWebApi.Tools.SeachEncodeJob.EncodingSeach(System.String)"> |
| | | <summary> |
| | | æ ¹æ®åè½ç¼ç è·åææ°è§åç¼ç |
| | | </summary> |
| | | <param name="rightcode">åè½ç¼ç </param> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:VueWebApi.Tools.SeachEncodeJob.StrEncodingUpdate(System.String,System.String)"> |
| | | <summary> |
| | | æ´æ°æ¡ç è§å表 |
| | | </summary> |
| | | <param name="rightcode">åè½ç¼ç </param> |
| | | <param name="incbit">æµæ°´å·</param> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="T:VueWebApi.Util.ObjectValueParser`1"> |
| | | <summary> |
| | | å¼è½¬æ¢å¨ |
| | |
| | | a846e011ebe7b9ff1188f24629019f1e16661320 |
| | | 1c4b4f2804c74f11be580bba6c3a92f91327bca8 |