| | |
| | | } |
| | | #endregion |
| | | |
| | | #region[ERPè®¢åæ¹éä¸è¾¾] |
| | | /// <summary> |
| | | /// ERPè®¢åæ¹éä¸è¾¾ |
| | | /// </summary> |
| | | /// <param name="obj">æäº¤æ°æ®</param> |
| | | /// <returns></returns> |
| | | [Route(template: "MarkBatchSaveErpOrder")] |
| | | [HttpPost] |
| | | public HttpResponseMessage MarkBatchSaveErpOrder(List<ErpOrderBatch> obj) |
| | | { |
| | | var username = HttpContext.Current.Request.Cookies["admin"].Value.ToString(); //æä½äººå |
| | | mes = ProductionManagementBLL.MarkBatchSaveErpOrder(obj, username); |
| | | return TJson.toJson(mes); |
| | | } |
| | | #endregion |
| | | |
| | | #region[ERP订åå
³é] |
| | | /// <summary> |
| | | /// ERP订åå
³é |
| | |
| | | } |
| | | #endregion |
| | | |
| | | #region[ERPè®¢åæ¹éä¸è¾¾] |
| | | public static ToMessage MarkBatchSaveErpOrder(List<ErpOrderBatch> obj, string username) |
| | | { |
| | | return ProductionManagementDAL.MarkBatchSaveErpOrder(obj,username); |
| | | } |
| | | #endregion |
| | | |
| | | #region[ERP订åå
³é] |
| | | public static ToMessage ClosedErpOrder(string erporderid, string erpordercode, string username) |
| | | { |
| | |
| | | |
| | | |
| | | #region[MESå·¥åæ¥è¯¢] |
| | | public static ToMessage MesOrderSearch(string stu_torgcode,string stu_torgtypecode,string mesorderstus, string mesordercode,string saleordercode, string sourceorder,string ordertype, string partcode, string partname, string partspec, int startNum, string creatuser, string createdate, int endNum, string prop, string order) |
| | | public static ToMessage MesOrderSearch(string stu_torgcode,string stu_torgtypecode,string mesorderstus, string mesordercode, string sourceorder, string saleordercode,string ordertype, string partcode, string partname, string partspec, int startNum, string creatuser, string createdate, int endNum, string prop, string order) |
| | | { |
| | | return ProductionManagementDAL.MesOrderSearch(stu_torgcode, stu_torgtypecode,mesorderstus, mesordercode, sourceorder, saleordercode, ordertype, partcode, partname, partspec, startNum, creatuser, createdate, endNum, prop, order); |
| | | } |
| | |
| | | |
| | | |
| | | #region[ERPè®¢åæ¥è¯¢] |
| | | public static ToMessage ErpOrderSearch(string stu_torgcode,string stu_torgtypecode,string erporderstus, string erpordercode,string saleordercode, string partcode, string partname, string partspec, int startNum, string paydatestartdate, string paydateenddate, string paydatestartdate1, string paydateenddate2, string creatuser, int endNum, string prop, string order) |
| | | public static ToMessage ErpOrderSearch(string stu_torgcode, string stu_torgtypecode, string erporderstus, string erpordercode, string saleordercode, string partcode, string partname, string partspec, int startNum, string paydatestartdate, string paydateenddate, string paydatestartdate1, string paydateenddate2, string creatuser, int endNum, string prop, string order) |
| | | { |
| | | var dynamicParams = new DynamicParameters(); |
| | | string search = ""; |
| | |
| | | #endregion |
| | | |
| | | #region[ERP订åä¸è¾¾] |
| | | public static ToMessage MarkSaveErpOrder(string erporderid, string erpordercode,string saleordercode, string partcode, string wkshopcode, string warehousecode, string erpqty, string markqty, string ordernum, string relse_qty, string saleOrderDeliveryDate, string username) |
| | | public static ToMessage MarkSaveErpOrder(string erporderid, string erpordercode, string saleordercode, string partcode, string wkshopcode, string warehousecode, string erpqty, string markqty, string ordernum, string relse_qty, string saleOrderDeliveryDate, string username) |
| | | { |
| | | var sql = ""; |
| | | List<object> list = new List<object>(); |
| | |
| | | m_po = erpordercode, |
| | | username = username, |
| | | CreateDate = DateTime.Now.ToString(), |
| | | saleOrderCode=saleordercode, |
| | | saleOrderCode = saleordercode, |
| | | saleOrderDeliveryDate = Convert.ToDateTime(saleOrderDeliveryDate) |
| | | } |
| | | }); |
| | |
| | | m_po = erpordercode, |
| | | username = username, |
| | | CreateDate = DateTime.Now.ToString(), |
| | | saleOrderCode=saleordercode, |
| | | saleOrderCode = saleordercode, |
| | | saleOrderDeliveryDate = Convert.ToDateTime(saleOrderDeliveryDate) |
| | | } |
| | | }); |
| | |
| | | mes.Message = "ä¸è¾¾MESå·¥åæå失败!"; |
| | | 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 MarkBatchSaveErpOrder(List<ErpOrderBatch> obj, string username) |
| | | { |
| | | var sql = ""; |
| | | List<object> list = new List<object>(); |
| | | var dynamicParams = new DynamicParameters(); |
| | | |
| | | try |
| | | { |
| | | list.Clear(); |
| | | |
| | | var groupedModels = obj.GroupBy(m => m.erpordercode); |
| | | foreach (var group in groupedModels) |
| | | { |
| | | string erpordercode = group.Key; |
| | | int count = 1; |
| | | foreach (var model in group) |
| | | { |
| | | //è·åå½åæå¤§å·¥åå· |
| | | sql = @"select isnull(max(cast(substring(wo_code,charindex('_',wo_code)+1,len(wo_code)-charindex('_',wo_code)) as numeric)),0) as worknumb |
| | | from TK_Wrk_Man where m_po=@erpordercode"; |
| | | dynamicParams.Add("@erpordercode", model.erpordercode); |
| | | var data = DapperHelper.selectdata(sql, dynamicParams); |
| | | int num = Convert.ToInt32(data.Rows[0]["WORKNUMB"].ToString()); |
| | | string wo = model.erpordercode + "_" + (num + count); |
| | | //åå
¥å·¥å表 |
| | | sql = @"insert into TK_Wrk_Man(wo_code,wotype,status,wkshp_code,plan_qty,stck_code,materiel_code,sourceid,m_po,lm_user,lm_date,saleOrderCode,saleOrderDeliveryDate) values(@wo_code,@wotype,@status,@wkshp_code,@plan_qty,@stck_code,@materiel_code,@sourceid,@m_po,@username,@CreateDate,@saleOrderCode,@saleOrderDeliveryDate)"; |
| | | list.Add(new |
| | | { |
| | | str = sql, |
| | | parm = new |
| | | { |
| | | wo_code = wo, |
| | | wotype = "PO", |
| | | status = "NEW", |
| | | wkshp_code = model.wkshopcode, |
| | | plan_qty = decimal.Parse(model.erpqty), //è®¢åæ°é |
| | | stck_code = model.warehousecode, |
| | | materiel_code = model.partcode, |
| | | sourceid = model.erporderid, |
| | | m_po = model.erpordercode, |
| | | username = username, |
| | | CreateDate = DateTime.Now.ToString(), |
| | | saleOrderCode = model.saleordercode, |
| | | saleOrderDeliveryDate = Convert.ToDateTime(model.saleOrderDeliveryDate) |
| | | } |
| | | }); |
| | | |
| | | //æ´æ°è®¢åç¶æ |
| | | sql = @"update TKimp_Ewo set status='CREATED',saleOrderDeliveryDate=@saleOrderDeliveryDate,relse_qty=relse_qty+@sumqty where wo=@wo and id=@erporderid"; |
| | | list.Add(new |
| | | { |
| | | str = sql, |
| | | parm = new |
| | | { |
| | | wo = model.erpordercode, |
| | | erporderid = model.erporderid, |
| | | sumqty = decimal.Parse(model.markqty), |
| | | saleOrderDeliveryDate = Convert.ToDateTime(model.saleOrderDeliveryDate) |
| | | } |
| | | }); |
| | | count++; |
| | | } |
| | | } |
| | | |
| | | |
| | | |
| | | bool aa = DapperHelper.DoTransaction(list); |
| | | if (aa) |
| | | { |
| | | mes.code = "200"; |
| | | mes.count = 0; |
| | | mes.Message = "æ¹éä¸è¾¾MESå·¥åæå!"; |
| | | mes.data = null; |
| | | } |
| | | else |
| | | { |
| | | mes.code = "300"; |
| | | mes.count = 0; |
| | | mes.Message = "æ¹éä¸è¾¾MESå·¥åæå失败!"; |
| | | mes.data = null; |
| | | } |
| | | |
| | | } |
| | | catch (Exception e) |
| | | { |
| | |
| | | |
| | | |
| | | #region[MESå·¥åæ¥è¯¢] |
| | | public static ToMessage MesOrderSearch(string stu_torgcode,string stu_torgtypecode,string mesorderstus, string mesordercode, string sourceorder,string saleordercode, string ordertype, string partcode, string partname, string partspec, int startNum, string creatuser, string createdate, int endNum, string prop, string order) |
| | | public static ToMessage MesOrderSearch(string stu_torgcode, string stu_torgtypecode, string mesorderstus, string mesordercode, string sourceorder, string saleordercode, string ordertype, string partcode, string partname, string partspec, int startNum, string creatuser, string createdate, int endNum, string prop, string order) |
| | | { |
| | | var dynamicParams = new DynamicParameters(); |
| | | string search = ""; |
| | |
| | | #endregion |
| | | |
| | | #region[MESæ¥åºè¡¥åå·¥åæ¥è¯¢] |
| | | public static ToMessage MesBadOrderSearch(string mesordercode, string sourceorder,string saleordercode, string partcode, string partname, string partspec, int startNum, string creatuser, string createdate, int endNum, string prop, string order) |
| | | public static ToMessage MesBadOrderSearch(string mesordercode, string sourceorder, string saleordercode, string partcode, string partname, string partspec, int startNum, string creatuser, string createdate, int endNum, string prop, string order) |
| | | { |
| | | var dynamicParams = new DynamicParameters(); |
| | | string search = ""; |
| | |
| | | #endregion |
| | | |
| | | #region[产åç¼ç æ¥æ¾å·¥èºè·¯çº¿ä¸ææ¥å£] |
| | | public static ToMessage PartSelectRoute(string partcode,string wkshopcode) |
| | | public static ToMessage PartSelectRoute(string partcode, string wkshopcode) |
| | | { |
| | | string sql = ""; |
| | | var dynamicParams = new DynamicParameters(); |
| | |
| | | #endregion |
| | | |
| | | #region[å·¥èºè·¯çº¿æ¥æ¾è½¦é´ä¸ææ¥å£] |
| | | public static ToMessage RouteSelectWkshop(string stu_torgcode,string stu_torgtypecode,string partcode) |
| | | public static ToMessage RouteSelectWkshop(string stu_torgcode, string stu_torgtypecode, string partcode) |
| | | { |
| | | string sql = ""; |
| | | string search = ""; |
| | |
| | | inner join TEqpInfo E on D.eqp_code=E.code |
| | | left join TOrganization F on E.wksp_code=F.org_code |
| | | left join TOrganization L on F.parent_id=L.id |
| | | where M.materiel_code=@partcode and E.enable='Y' "+search; |
| | | where M.materiel_code=@partcode and E.enable='Y' " + search; |
| | | dynamicParams.Add("@partcode", partcode); |
| | | var data = DapperHelper.selectdata(sql, dynamicParams); |
| | | mes.code = "200"; |
| | |
| | | #endregion |
| | | |
| | | #region[工忴¾å鿩工èºè·¯çº¿æéæ©çäº§è½¦é´æ¶å¤æç»å®æ¡ä»¶] |
| | | public static ToMessage SelectRouteOrWkshop(string partcode, string routecode, string wkshopcode,string is_steprice) |
| | | public static ToMessage SelectRouteOrWkshop(string partcode, string routecode, string wkshopcode, string is_steprice) |
| | | { |
| | | string sql = ""; |
| | | var dynamicParams = new DynamicParameters(); |
| | |
| | | #endregion |
| | | |
| | | #region[çäº§å¼æ¥å·¥æ«ç è·åå·¥å对åºå·¥åºä»»å¡(èªå¶)] |
| | | public static ToMessage MesOrderStepSearch(string stu_torgcode,string stu_torgtypecode, string orderstepqrcode, int startNum, int endNum, string prop, string order) |
| | | public static ToMessage MesOrderStepSearch(string stu_torgcode, string stu_torgtypecode, string orderstepqrcode, int startNum, int endNum, string prop, string order) |
| | | { |
| | | var sql = ""; |
| | | string search = ""; |
| | |
| | | #endregion |
| | | |
| | | #region[çäº§å¼æ¥å·¥æ«ç è·åå·¥å对åºå·¥åºä»»å¡(å¤å)] |
| | | public static ToMessage MesOrderWxStepSearch(string stu_torgcode,string stu_torgtypecode,string orderstepqrcode, int startNum, int endNum, string prop, string order) |
| | | public static ToMessage MesOrderWxStepSearch(string stu_torgcode, string stu_torgtypecode, string orderstepqrcode, int startNum, int endNum, string prop, string order) |
| | | { |
| | | var sql = ""; |
| | | string search = ""; |
| | |
| | | #endregion |
| | | |
| | | #region[çäº§å¼æ¥å·¥æ«ç è·åå·¥å对åºå·¥åºä»»å¡(ä¸è¯)] |
| | | public static ToMessage MesOrderNgStepSearch(string stu_torgcode,string stu_torgtypecode,string orderstepqrcode, int startNum, int endNum, string prop, string order) |
| | | public static ToMessage MesOrderNgStepSearch(string stu_torgcode, string stu_torgtypecode, string orderstepqrcode, int startNum, int endNum, string prop, string order) |
| | | { |
| | | var sql = ""; |
| | | string search = ""; |
| | |
| | | #endregion |
| | | |
| | | #region [çäº§å¼æ¥å·¥ï¼å¼å·¥(å¼å§/æ¥å·¥)/å¤ååææ¶æ¡ä»¶å¤æåæ°æ®è¿åæ¥å£] |
| | | public static ToMessage MesOrderStepStart(string OperType,string stu_torgcode, string SelectType, string orderstepqrcode) |
| | | public static ToMessage MesOrderStepStart(string OperType, string stu_torgcode, string SelectType, string orderstepqrcode) |
| | | { |
| | | var sql = ""; |
| | | string search = ""; |
| | |
| | | switch (OperType) |
| | | { |
| | | case "ZZ": |
| | | mes = ScanStartReport.ZZEncodingSeach(stu_torgcode, SelectType,ordercode, stepcode); |
| | | mes = ScanStartReport.ZZEncodingSeach(stu_torgcode, SelectType, ordercode, stepcode); |
| | | break; |
| | | case "WX": |
| | | mes = ScanStartReport.WXEncodingSeach(stu_torgcode,SelectType, ordercode, stepcode); |
| | | mes = ScanStartReport.WXEncodingSeach(stu_torgcode, SelectType, ordercode, stepcode); |
| | | break; |
| | | default: |
| | | break; |
| | |
| | | mes.Message = "æ¥è¯¢æå!"; |
| | | mes.data = data; |
| | | } |
| | | else |
| | | else |
| | | { |
| | | mes.code = "300"; |
| | | mes.Message = "å½åå·¥åºæªå
³èç产设å¤!"; |
| | |
| | | #endregion |
| | | |
| | | #region[çäº§å¼æ¥å·¥ï¼æ¥å·¥æ¶è·åç产çç»ä¸ææ¡] |
| | | public static ToMessage MesOrderStepReportSelectUserGroup(string stu_torgcode,string stu_torgtypecode,string wkshopcode) |
| | | public static ToMessage MesOrderStepReportSelectUserGroup(string stu_torgcode, string stu_torgtypecode, string wkshopcode) |
| | | { |
| | | string sql = ""; |
| | | string search = ""; |
| | |
| | | sql = @"select group_code,group_name from TGroup A |
| | | left join TOrganization T on A.torg_code=T.org_code |
| | | left join TOrganization as L on T.parent_id=L.id |
| | | where 1=1 "+search; |
| | | where 1=1 " + search; |
| | | var data = DapperHelper.selectdata(sql, dynamicParams); |
| | | mes.code = "200"; |
| | | mes.Message = "æ¥è¯¢æå!"; |
| | |
| | | JArray arra = (JArray)Newtonsoft.Json.JsonConvert.DeserializeObject(reportuser); |
| | | //夿æ¯å¦æä¸è¯æ°æ® |
| | | var groupedItems = defectobjs.GroupBy(item => item.defect_code) // æç¼ç codeåç» |
| | | .Select(group => new { defect_code = group.Key, badqty = group.Sum(item =>Convert.ToDecimal(item.badqty)) }).ToList(); // æ±æ»æ°éqty |
| | | .Select(group => new { defect_code = group.Key, badqty = group.Sum(item => Convert.ToDecimal(item.badqty)) }).ToList(); // æ±æ»æ°éqty |
| | | if (groupedItems.Count <= 0) |
| | | { |
| | | ngqty = 0; |
| | |
| | | }); |
| | | |
| | | } |
| | | if (groupedItems.Count>0) |
| | | if (groupedItems.Count > 0) |
| | | { |
| | | //åå
¥ç¼ºé·è®°å½è¡¨ |
| | | for (int i = 0; i < groupedItems.Count; i++) |
| | | { |
| | | sql = @"insert into CSR_WorkRecord_Defect(record_id,wo_code,partnumber,step_seq,step_code,defect_qty,defect_pendqty,defect_code,remarks,style,lm_user,lm_date) |
| | | values(@record_id,@wo_code,@partcode,@stepseq,@stepcode,@ngqty,@defect_pendqty,@defect_code,@remarks,@style,@lm_user,@lm_date)"; |
| | | list.Add(new { str = sql, parm = new { record_id = int.Parse(dt.Rows[0]["ID"].ToString()), wo_code = mesordercode, partcode = partcode, stepseq = stepseq, stepcode = stepcode, ngqty = groupedItems[i].badqty, defect_pendqty= groupedItems[i].badqty, defect_code = groupedItems[i].defect_code, remarks = remarks, style = "B", lm_user = username, lm_date = date } }); |
| | | list.Add(new { str = sql, parm = new { record_id = int.Parse(dt.Rows[0]["ID"].ToString()), wo_code = mesordercode, partcode = partcode, stepseq = stepseq, stepcode = stepcode, ngqty = groupedItems[i].badqty, defect_pendqty = groupedItems[i].badqty, defect_code = groupedItems[i].defect_code, remarks = remarks, style = "B", lm_user = username, lm_date = date } }); |
| | | |
| | | } |
| | | } |
| | |
| | | { |
| | | sql = @"insert into CSR_WorkRecord_Defect(record_id,wo_code,partnumber,step_seq,step_code,defect_qty,defect_pendqty,defect_code,remarks,style,lm_user,lm_date) |
| | | values(@record_id,@wo_code,@partcode,@stepseq,@stepcode,@ngqty,@defect_pendqty,@defect_code,@remarks,@style,@lm_user,@lm_date)"; |
| | | list.Add(new { str = sql, parm = new { record_id = int.Parse(dt.Rows[0]["ID"].ToString()), wo_code = mesordercode, partcode = partcode, stepseq = stepseq, stepcode = stepcode, ngqty = groupedItems[i].badqty, defect_pendqty= groupedItems[i].badqty, defect_code = groupedItems[i].defect_code, remarks = remarks, style = "B", lm_user = username, lm_date = date } }); |
| | | list.Add(new { str = sql, parm = new { record_id = int.Parse(dt.Rows[0]["ID"].ToString()), wo_code = mesordercode, partcode = partcode, stepseq = stepseq, stepcode = stepcode, ngqty = groupedItems[i].badqty, defect_pendqty = groupedItems[i].badqty, defect_code = groupedItems[i].defect_code, remarks = remarks, style = "B", lm_user = username, lm_date = date } }); |
| | | |
| | | } |
| | | } |
| | |
| | | values(@m_id,@wxcode,@in_person,@in_time,@sqty,@ng_qty,@style,@lm_user,@lm_date)"; |
| | | list.Add(new { str = sql, parm = new { m_id = int.Parse(dt.Rows[0]["ID"].ToString()), wxcode = wxcode, in_person = inuser, in_time = date, sqty = sqty, ng_qty = ngqty, style = "S", lm_user = username, lm_date = date } }); |
| | | |
| | | if (groupedItems.Count>0) |
| | | if (groupedItems.Count > 0) |
| | | { |
| | | //åå
¥ç¼ºé·è®°å½è¡¨ |
| | | for (int i = 0; i < groupedItems.Count; i++) |
| | | { |
| | | sql = @"insert into CSR_WorkRecord_Defect(record_id,wo_code,partnumber,step_seq,step_code,defect_qty,defect_pendqty,defect_code,remarks,style,lm_user,lm_date) |
| | | values(@record_id,@wo_code,@partcode,@stepseq,@stepcode,@ngqty,@defect_pendqty,@defect_code,@remarks,@style,@lm_user,@lm_date)"; |
| | | list.Add(new { str = sql, parm = new { record_id = int.Parse(dt.Rows[0]["ID"].ToString()), wo_code = mesordercode, partcode = partcode, stepseq = stepseq, stepcode = stepcode, ngqty = groupedItems[i].badqty, defect_pendqty= groupedItems[i].badqty, defect_code = groupedItems[i].defect_code, remarks = remarks, style = "S", lm_user = username, lm_date = date } }); |
| | | list.Add(new { str = sql, parm = new { record_id = int.Parse(dt.Rows[0]["ID"].ToString()), wo_code = mesordercode, partcode = partcode, stepseq = stepseq, stepcode = stepcode, ngqty = groupedItems[i].badqty, defect_pendqty = groupedItems[i].badqty, defect_code = groupedItems[i].defect_code, remarks = remarks, style = "S", lm_user = username, lm_date = date } }); |
| | | |
| | | } |
| | | } |
| | |
| | | { |
| | | sql = @"insert into CSR_WorkRecord_Defect(record_id,wo_code,partnumber,step_seq,step_code,defect_qty,defect_pendqty,defect_code,remarks,style,lm_user,lm_date) |
| | | values(@record_id,@wo_code,@partcode,@stepseq,@stepcode,@ngqty,@defect_pendqty,@defect_code,@remarks,@style,@lm_user,@lm_date)"; |
| | | list.Add(new { str = sql, parm = new { record_id = int.Parse(dt.Rows[0]["ID"].ToString()), wo_code = mesordercode, partcode = partcode, stepseq = stepseq, stepcode = stepcode, ngqty = groupedItems[i].badqty, defect_pendqty= groupedItems[i].badqty, defect_code = groupedItems[i].defect_code, remarks = remarks, style = "S", lm_user = username, lm_date = date } }); |
| | | list.Add(new { str = sql, parm = new { record_id = int.Parse(dt.Rows[0]["ID"].ToString()), wo_code = mesordercode, partcode = partcode, stepseq = stepseq, stepcode = stepcode, ngqty = groupedItems[i].badqty, defect_pendqty = groupedItems[i].badqty, defect_code = groupedItems[i].defect_code, remarks = remarks, style = "S", lm_user = username, lm_date = date } }); |
| | | |
| | | } |
| | | } |
| | |
| | | #endregion |
| | | |
| | | #region[å·¥åºæ£éª,æäº¤] |
| | | public static ToMessage SaveMesOrderStepCheckItem(string stu_torgcode,string wocode, string partcode, string stepcode, string checkstandcode, string check_type, string sampmethod, string qualitystatus, string labqty, string sampleqty, string goodqty, string ngqty, string checkitemcont, string username) |
| | | public static ToMessage SaveMesOrderStepCheckItem(string stu_torgcode, string wocode, string partcode, string stepcode, string checkstandcode, string check_type, string sampmethod, string qualitystatus, string labqty, string sampleqty, string goodqty, string ngqty, string checkitemcont, string username) |
| | | { |
| | | var sql = ""; |
| | | string checktypename = ""; |
| | |
| | | |
| | | |
| | | #region[MES工忹éå
³éæ¥è¯¢] |
| | | public static ToMessage MesOrderBitchClosedSearch(string stu_torgcode,string stu_torgtypecode,string mesorderstus, string mesordercode, string sourceorder, string ordertype, string partcode, string partname, string partspec, int startNum, string creatuser, string createdate, int endNum, string prop, string order) |
| | | public static ToMessage MesOrderBitchClosedSearch(string stu_torgcode, string stu_torgtypecode, string mesorderstus, string mesordercode, string sourceorder, string ordertype, string partcode, string partname, string partspec, int startNum, string creatuser, string createdate, int endNum, string prop, string order) |
| | | { |
| | | var dynamicParams = new DynamicParameters(); |
| | | string search = ""; |
| ¶Ô±ÈÐÂÎļþ |
| | |
| | | using System; |
| | | using System.Collections.Generic; |
| | | using System.Linq; |
| | | using System.Web; |
| | | |
| | | namespace VueWebApi.Models |
| | | { |
| | | public class ErpOrderBatch |
| | | { |
| | | /// <summary> |
| | | /// 订åid |
| | | /// </summary> |
| | | public string erporderid { get; set; } |
| | | /// <summary> |
| | | /// 订åç¼å· |
| | | /// </summary> |
| | | public string erpordercode { get; set; } |
| | | /// <summary> |
| | | /// éå®è®¢åç¼å· |
| | | /// </summary> |
| | | public string saleordercode { get; set; } |
| | | /// <summary> |
| | | /// 产åç¼ç |
| | | /// </summary> |
| | | public string partcode { get; set; } |
| | | /// <summary> |
| | | /// 车é´ç¼ç |
| | | /// </summary> |
| | | public string wkshopcode { get; set; } |
| | | /// <summary> |
| | | /// ä»åºç¼ç |
| | | /// </summary> |
| | | public string warehousecode { get; set; } |
| | | /// <summary> |
| | | /// è®¢åæ°é |
| | | /// </summary> |
| | | public string erpqty { get; set; } |
| | | /// <summary> |
| | | /// ä¸åæ°é |
| | | /// </summary> |
| | | public string markqty { get; set; } |
| | | /// <summary> |
| | | /// ä¸ååæ° |
| | | /// </summary> |
| | | public string ordernum { get; set; } |
| | | /// <summary> |
| | | /// å·²ä¸åæ°é |
| | | /// </summary> |
| | | public string relse_qty { get; set; } |
| | | /// <summary> |
| | | /// äº¤ä»æ¶é´ |
| | | /// </summary> |
| | | public string saleOrderDeliveryDate { get; set; } |
| | | } |
| | | } |
| | |
| | | <Project ToolsVersion="4.0" xmlns="http://schemas.microsoft.com/developer/msbuild/2003"> |
| | | <PropertyGroup> |
| | | <_PublishTargetUrl>D:\ç½ç«åå¸\MESæ£æ¸
æ²³</_PublishTargetUrl> |
| | | <History>True|2023-10-10T02:34:01.3167190Z;True|2023-10-10T10:28:48.9531906+08:00;True|2023-10-10T09:54:43.0218459+08:00;True|2023-10-10T09:43:57.3542420+08:00;True|2023-09-27T07:47:41.5372303+08:00;True|2023-09-21T18:22:16.9575605+08:00;True|2023-09-21T18:09:09.2828591+08:00;True|2023-09-21T17:57:05.3919457+08:00;True|2023-09-21T17:40:17.7722883+08:00;True|2023-09-21T17:24:20.7004108+08:00;True|2023-09-21T17:14:30.5230341+08:00;True|2023-09-21T15:14:11.3019288+08:00;True|2023-09-20T09:47:15.7375677+08:00;True|2023-09-12T14:37:37.0665432+08:00;True|2023-08-16T16:52:02.7063729+08:00;True|2023-08-11T10:35:11.9236725+08:00;True|2023-08-07T10:34:44.0844087+08:00;True|2023-08-07T10:28:56.2230477+08:00;True|2023-07-31T11:18:06.9546379+08:00;True|2023-07-03T10:38:22.8080444+08:00;True|2023-06-26T08:15:27.3611577+08:00;True|2023-06-25T15:36:41.8736654+08:00;True|2023-06-25T14:33:49.5287543+08:00;True|2023-06-13T10:24:59.6876648+08:00;</History> |
| | | <History>True|2023-10-30T09:10:12.6270482Z;True|2023-10-30T14:52:35.6311299+08:00;True|2023-10-30T11:08:33.1712753+08:00;True|2023-10-13T12:07:07.3822225+08:00;True|2023-10-10T10:34:01.3167190+08:00;True|2023-10-10T10:28:48.9531906+08:00;True|2023-10-10T09:54:43.0218459+08:00;True|2023-10-10T09:43:57.3542420+08:00;True|2023-09-27T07:47:41.5372303+08:00;True|2023-09-21T18:22:16.9575605+08:00;True|2023-09-21T18:09:09.2828591+08:00;True|2023-09-21T17:57:05.3919457+08:00;True|2023-09-21T17:40:17.7722883+08:00;True|2023-09-21T17:24:20.7004108+08:00;True|2023-09-21T17:14:30.5230341+08:00;True|2023-09-21T15:14:11.3019288+08:00;True|2023-09-20T09:47:15.7375677+08:00;True|2023-09-12T14:37:37.0665432+08:00;True|2023-08-16T16:52:02.7063729+08:00;True|2023-08-11T10:35:11.9236725+08:00;True|2023-08-07T10:34:44.0844087+08:00;True|2023-08-07T10:28:56.2230477+08:00;True|2023-07-31T11:18:06.9546379+08:00;True|2023-07-03T10:38:22.8080444+08:00;True|2023-06-26T08:15:27.3611577+08:00;True|2023-06-25T15:36:41.8736654+08:00;True|2023-06-25T14:33:49.5287543+08:00;True|2023-06-13T10:24:59.6876648+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>10/10/2023 10:33:56</publishTime> |
| | | <publishTime>10/30/2023 17:10:04</publishTime> |
| | | </File> |
| | | <File Include="bin/VueWebApi.pdb"> |
| | | <publishTime>10/10/2023 10:33:56</publishTime> |
| | | <publishTime>10/30/2023 17:10:04</publishTime> |
| | | </File> |
| | | <File Include="bin/VueWebApi.xml"> |
| | | <publishTime>10/10/2023 10:33:56</publishTime> |
| | | <publishTime>10/30/2023 17:10:03</publishTime> |
| | | </File> |
| | | <File Include="bin/WebActivatorEx.dll"> |
| | | <publishTime>02/08/2013 16:42:28</publishTime> |
| | |
| | | <publishTime>06/16/2022 13:39:23</publishTime> |
| | | </File> |
| | | <File Include="Web.config"> |
| | | <publishTime>10/10/2023 10:34:00</publishTime> |
| | | <publishTime>10/30/2023 17:10:11</publishTime> |
| | | </File> |
| | | </ItemGroup> |
| | | </Project> |
| | |
| | | <Compile Include="Models\ChanjetEncryptMsg.cs" /> |
| | | <Compile Include="Models\DeviceRepair.cs" /> |
| | | <Compile Include="Models\EqpRepair.cs" /> |
| | | <Compile Include="Models\ErpOrderBatch.cs" /> |
| | | <Compile Include="Models\ExcelErro.cs" /> |
| | | <Compile Include="Models\GroupUser.cs" /> |
| | | <Compile Include="Models\MaterialRout.cs" /> |
| | |
| | | <param name="obj">æäº¤æ°æ®</param> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:VueWebApi.Controllers.ProductionManagementController.MarkBatchSaveErpOrder(System.Collections.Generic.List{VueWebApi.Models.ErpOrderBatch})"> |
| | | <summary> |
| | | ERPè®¢åæ¹éä¸è¾¾ |
| | | </summary> |
| | | <param name="obj">æäº¤æ°æ®</param> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:VueWebApi.Controllers.ProductionManagementController.ClosedErpOrder(System.String,System.String)"> |
| | | <summary> |
| | | ERP订åå
³é |
| | |
| | | ç»ææ¥æ |
| | | </summary> |
| | | </member> |
| | | <member name="P:VueWebApi.Models.ErpOrderBatch.erporderid"> |
| | | <summary> |
| | | 订åid |
| | | </summary> |
| | | </member> |
| | | <member name="P:VueWebApi.Models.ErpOrderBatch.erpordercode"> |
| | | <summary> |
| | | 订åç¼å· |
| | | </summary> |
| | | </member> |
| | | <member name="P:VueWebApi.Models.ErpOrderBatch.saleordercode"> |
| | | <summary> |
| | | éå®è®¢åç¼å· |
| | | </summary> |
| | | </member> |
| | | <member name="P:VueWebApi.Models.ErpOrderBatch.partcode"> |
| | | <summary> |
| | | 产åç¼ç |
| | | </summary> |
| | | </member> |
| | | <member name="P:VueWebApi.Models.ErpOrderBatch.wkshopcode"> |
| | | <summary> |
| | | 车é´ç¼ç |
| | | </summary> |
| | | </member> |
| | | <member name="P:VueWebApi.Models.ErpOrderBatch.warehousecode"> |
| | | <summary> |
| | | ä»åºç¼ç |
| | | </summary> |
| | | </member> |
| | | <member name="P:VueWebApi.Models.ErpOrderBatch.erpqty"> |
| | | <summary> |
| | | è®¢åæ°é |
| | | </summary> |
| | | </member> |
| | | <member name="P:VueWebApi.Models.ErpOrderBatch.markqty"> |
| | | <summary> |
| | | ä¸åæ°é |
| | | </summary> |
| | | </member> |
| | | <member name="P:VueWebApi.Models.ErpOrderBatch.ordernum"> |
| | | <summary> |
| | | ä¸ååæ° |
| | | </summary> |
| | | </member> |
| | | <member name="P:VueWebApi.Models.ErpOrderBatch.relse_qty"> |
| | | <summary> |
| | | å·²ä¸åæ°é |
| | | </summary> |
| | | </member> |
| | | <member name="P:VueWebApi.Models.ErpOrderBatch.saleOrderDeliveryDate"> |
| | | <summary> |
| | | äº¤ä»æ¶é´ |
| | | </summary> |
| | | </member> |
| | | <member name="M:VueWebApi.TimeTick.QuartzUtil.AddJob``1(System.String,System.String,System.Collections.Generic.Dictionary{System.String,System.Object})"> |
| | | <summary> |
| | | æ·»å Job å¹¶ä¸ä»¥å®ç¹çå½¢å¼è¿è¡ |
| | |
| | | <param name="obj">æäº¤æ°æ®</param> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:VueWebApi.Controllers.ProductionManagementController.MarkBatchSaveErpOrder(System.Collections.Generic.List{VueWebApi.Models.ErpOrderBatch})"> |
| | | <summary> |
| | | ERPè®¢åæ¹éä¸è¾¾ |
| | | </summary> |
| | | <param name="obj">æäº¤æ°æ®</param> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:VueWebApi.Controllers.ProductionManagementController.ClosedErpOrder(System.String,System.String)"> |
| | | <summary> |
| | | ERP订åå
³é |
| | |
| | | ç»ææ¥æ |
| | | </summary> |
| | | </member> |
| | | <member name="P:VueWebApi.Models.ErpOrderBatch.erporderid"> |
| | | <summary> |
| | | 订åid |
| | | </summary> |
| | | </member> |
| | | <member name="P:VueWebApi.Models.ErpOrderBatch.erpordercode"> |
| | | <summary> |
| | | 订åç¼å· |
| | | </summary> |
| | | </member> |
| | | <member name="P:VueWebApi.Models.ErpOrderBatch.saleordercode"> |
| | | <summary> |
| | | éå®è®¢åç¼å· |
| | | </summary> |
| | | </member> |
| | | <member name="P:VueWebApi.Models.ErpOrderBatch.partcode"> |
| | | <summary> |
| | | 产åç¼ç |
| | | </summary> |
| | | </member> |
| | | <member name="P:VueWebApi.Models.ErpOrderBatch.wkshopcode"> |
| | | <summary> |
| | | 车é´ç¼ç |
| | | </summary> |
| | | </member> |
| | | <member name="P:VueWebApi.Models.ErpOrderBatch.warehousecode"> |
| | | <summary> |
| | | ä»åºç¼ç |
| | | </summary> |
| | | </member> |
| | | <member name="P:VueWebApi.Models.ErpOrderBatch.erpqty"> |
| | | <summary> |
| | | è®¢åæ°é |
| | | </summary> |
| | | </member> |
| | | <member name="P:VueWebApi.Models.ErpOrderBatch.markqty"> |
| | | <summary> |
| | | ä¸åæ°é |
| | | </summary> |
| | | </member> |
| | | <member name="P:VueWebApi.Models.ErpOrderBatch.ordernum"> |
| | | <summary> |
| | | ä¸ååæ° |
| | | </summary> |
| | | </member> |
| | | <member name="P:VueWebApi.Models.ErpOrderBatch.relse_qty"> |
| | | <summary> |
| | | å·²ä¸åæ°é |
| | | </summary> |
| | | </member> |
| | | <member name="P:VueWebApi.Models.ErpOrderBatch.saleOrderDeliveryDate"> |
| | | <summary> |
| | | äº¤ä»æ¶é´ |
| | | </summary> |
| | | </member> |
| | | <member name="M:VueWebApi.TimeTick.QuartzUtil.AddJob``1(System.String,System.String,System.Collections.Generic.Dictionary{System.String,System.Object})"> |
| | | <summary> |
| | | æ·»å Job å¹¶ä¸ä»¥å®ç¹çå½¢å¼è¿è¡ |
| | |
| | | a3528039de7d3c9a92bd6117d6e773fa8a56138f |
| | | b90c6f82dbf3e50172d09203c0771abe2e02f434 |
| | |
| | | D:\æ°å¯è¿ªMES\MES项ç®\MESæ£æ¸
æ²³\VueWebApi\VueWebApi\bin\zh-Hans\System.Web.WebPages.resources.dll |
| | | D:\æ°å¯è¿ªMES\MES项ç®\MESæ£æ¸
æ²³\VueWebApi\VueWebApi\bin\zh-Hans\System.Web.WebPages.Deployment.resources.dll |
| | | D:\æ°å¯è¿ªMES\MES项ç®\MESæ£æ¸
æ²³\VueWebApi\VueWebApi\bin\zh-Hans\System.Web.WebPages.Razor.resources.dll |
| | | D:\æ°å¯è¿ªMES\MES项ç®\MESæ£æ¸
æ²³\VueWebApi\VueWebApi\obj\Release\VueWebApi.csproj.AssemblyReference.cache |
| | | D:\æ°å¯è¿ªMES\MES项ç®\MESæ£æ¸
æ²³\VueWebApi\VueWebApi\obj\Release\VueWebApi.csproj.CoreCompileInputs.cache |
| | | D:\æ°å¯è¿ªMES\MES项ç®\MESæ£æ¸
æ²³\VueWebApi\VueWebApi\obj\Release\VueWebApi.csproj.CopyComplete |
| | | D:\æ°å¯è¿ªMES\MES项ç®\MESæ£æ¸
æ²³\VueWebApi\VueWebApi\obj\Release\VueWebApi.dll |