1.组织架构增加是否末道工序报工字段:islastreport
2.报工调整增加工序编码查询字段:stepcode
3.报工调整增加批量改价接口
4.SOP上传增加文件大小校验
| | |
| | | string storgcode = obj["storgcode"].ToString(); //æå±ç»ç»ç¼ç |
| | | string torg_seq = obj["torg_seq"].ToString(); //æåºåºå· |
| | | string status = obj["status"].ToString(); //ç¶æ |
| | | string islastreport= obj["islastreport"].ToString(); //æ¯å¦æ«éå·¥åºæ¥å·¥(Y/N) |
| | | string OperType = obj["OperType"].ToString(); //æä½ç±»å |
| | | mes = BasicSettingBLL.AddUpdateOrganization(OrganCode, OrganName, leve, parent_id, storgcode, torg_seq, status, OperType, us); |
| | | mes = BasicSettingBLL.AddUpdateOrganization(OrganCode, OrganName, leve, parent_id, storgcode, torg_seq, status, islastreport, OperType, us); |
| | | return Json(mes); |
| | | } |
| | | #endregion |
| | |
| | | /// <param name="partnumber">产åç¼ç </param> |
| | | /// <param name="partname">产ååç§°</param> |
| | | /// <param name="partspec">产åè§æ ¼</param> |
| | | /// <param name="stepcode">å·¥åºç¼ç </param> |
| | | /// <param name="reportuser">æ¥å·¥äººå</param> |
| | | /// <param name="reportdate">æ¥å·¥æ¶é´</param> |
| | | /// <param name="page">页ç </param> |
| | |
| | | /// <returns></returns> |
| | | [Route(template: "MesOrderStepVerifySearch")] |
| | | [HttpGet] |
| | | public JsonResult MesOrderStepVerifySearch(string wkshopcode=null, string wo_code = null, string partnumber = null, string partname = null, string partspec = null, string reportuser = null, string reportdate = null, int page = 0, int rows = 0, string prop = null, string order = null) |
| | | public JsonResult MesOrderStepVerifySearch(string wkshopcode=null, string wo_code = null, string partnumber = null, string partname = null, string partspec = null,string stepcode=null, string reportuser = null, string reportdate = null, int page = 0, int rows = 0, string prop = null, string order = null) |
| | | { |
| | | string reportdateopendate = ""; //æ¥å·¥å¼å§æ¶é´ |
| | | string reportdateclosedate = ""; //æ¥å·¥ç»ææ¶é´ |
| | |
| | | } |
| | | int startNum = rows * (page - 1) + 1; //èµ·å§è®°å½rowNum |
| | | int endNum = rows * page; //ç»æè®°å½ rowNum |
| | | mes = WorkOrderBLL.MesOrderStepVerifySearch(wkshopcode,wo_code, partnumber, partname, partspec, reportuser, reportdateopendate, reportdateclosedate, startNum, endNum, prop, order); |
| | | mes = WorkOrderBLL.MesOrderStepVerifySearch(wkshopcode,wo_code, partnumber, partname, partspec,stepcode,reportuser, reportdateopendate, reportdateclosedate, startNum, endNum, prop, order); |
| | | return Json(mes); |
| | | } |
| | | #endregion |
| | |
| | | } |
| | | #endregion |
| | | |
| | | #region[ç产æ§è¡,æ¥å·¥è°æ´æ¹éæ¹ä»·æ°æ®æäº¤] |
| | | /// <summary> |
| | | /// ç产æ§è¡,æ¥å·¥è°æ´æ¹éæ¹ä»·æ°æ®æäº¤ |
| | | /// </summary> |
| | | /// <param name="json">æäº¤æ°æ®</param> |
| | | /// <returns></returns> |
| | | [Route(template: "MesOrderStepPriceBatchUpdateSeave")] |
| | | [HttpPost] |
| | | public JsonResult MesOrderStepPriceBatchUpdateSeave(List<BatchPrice> json) |
| | | { |
| | | var token = HttpContext.Request.Headers["Token"].ToString(); |
| | | User us = JwtTools.Denocode(token.ToString()); |
| | | mes = WorkOrderBLL.MesOrderStepPriceBatchUpdateSeave(us, json); |
| | | return Json(mes); |
| | | } |
| | | #endregion |
| | | |
| | | |
| | | |
| | | #region[ç产æ§è¡,æ¥å·¥å®¡æ ¸åè¡¨æ°æ®æ¥è¯¢æ¥å£] |
| | |
| | | #endregion |
| | | |
| | | #region [ç»ç»æ¶ææ°å¢ç¼è¾] |
| | | public static ToMessage AddUpdateOrganization(string OrganCode, string OrganName, string leve, string parent_id,string storgcode, string torg_seq, string status, string OperType, User us) |
| | | public static ToMessage AddUpdateOrganization(string OrganCode, string OrganName, string leve, string parent_id,string storgcode, string torg_seq, string status,string islastreport, string OperType, User us) |
| | | { |
| | | return BasicSettingDAL.AddUpdateOrganization(OrganCode, OrganName, leve, parent_id, storgcode, torg_seq, status, OperType, us); |
| | | return BasicSettingDAL.AddUpdateOrganization(OrganCode, OrganName, leve, parent_id, storgcode, torg_seq, status, islastreport, OperType, us); |
| | | } |
| | | #endregion |
| | | |
| | |
| | | |
| | | |
| | | #region[ç产æ§è¡,æ¥å·¥è°æ´æ°æ®æ¥è¯¢æ¥å£] |
| | | public static ToMessage MesOrderStepVerifySearch(string wkshopcode,string wo_code, string partnumber, string partname, string partspec, string reportuser, string reportdateopendate, string reportdateclosedate, int startNum, int endNum, string prop, string order) |
| | | public static ToMessage MesOrderStepVerifySearch(string wkshopcode,string wo_code, string partnumber, string partname, string partspec,string stepcode, string reportuser, string reportdateopendate, string reportdateclosedate, int startNum, int endNum, string prop, string order) |
| | | { |
| | | return WorkOrderDAL.MesOrderStepVerifySearch(wkshopcode,wo_code, partnumber, partname, partspec, reportuser, reportdateopendate, reportdateclosedate, startNum, endNum, prop, order); |
| | | return WorkOrderDAL.MesOrderStepVerifySearch(wkshopcode,wo_code, partnumber, partname, partspec, stepcode, reportuser, reportdateopendate, reportdateclosedate, startNum, endNum, prop, order); |
| | | } |
| | | #endregion |
| | | |
| | |
| | | } |
| | | #endregion |
| | | |
| | | #region[ç产æ§è¡,æ¥å·¥è°æ´æ¹éæ¹ä»·æ°æ®æäº¤] |
| | | public static ToMessage MesOrderStepPriceBatchUpdateSeave(User us, List<BatchPrice> json) |
| | | { |
| | | return WorkOrderDAL.MesOrderStepPriceBatchUpdateSeave(us, json); |
| | | } |
| | | #endregion |
| | | |
| | | |
| | | #region[ç产æ§è¡,æ¥å·¥å®¡æ ¸åè¡¨æ°æ®æ¥è¯¢æ¥å£] |
| | | public static ToMessage MesOrderStepReportVerifySearch(string reviewstatus, string wkshopcode, string wo_code, string partnumber, string partname, string partspec, string stepname, string reportuser, string reportdateopendate, string reportdateclosedate, int startNum, int endNum, string prop, string order) |
| | |
| | | dynamicParams.Add("@storg_name", storg_name); |
| | | } |
| | | var sql = @"select T.id,T.parent_id,T.torg_code,T.torg_name,T.status,T.leve,T.torg_seq, |
| | | T.lm_user as usercode,U.username,T.lm_date |
| | | T.lm_user as usercode,U.username,T.lm_date,T.islastreport |
| | | from TOrganization T |
| | | left join TUser U on T.lm_user=U.usercode |
| | | where 1=1" + search + " order by T.lm_date desc"; |
| | |
| | | #endregion |
| | | |
| | | #region[æ°å¢ç¼è¾ç»ç»æ¶æ] |
| | | public static ToMessage AddUpdateOrganization(string OrganCode, string OrganName, string leve, string parent_id, string storgcode, string torg_seq, string status, string OperType, User us) |
| | | public static ToMessage AddUpdateOrganization(string OrganCode, string OrganName, string leve, string parent_id, string storgcode, string torg_seq, string status,string islastreport, string OperType, User us) |
| | | { |
| | | string sql = ""; |
| | | List<object> list = new List<object>(); |
| | |
| | | return mes; |
| | | } |
| | | |
| | | sql = @"insert into TOrganization(parent_id,torg_code,torg_name,status,leve,torg_seq,lm_user,lm_date) |
| | | values(@parent_id,@torg_code,@torg_name,@status,@leve,@torg_seq,@lm_user,@lm_date)"; |
| | | sql = @"insert into TOrganization(parent_id,torg_code,torg_name,status,leve,torg_seq,lm_user,lm_date,islastreport) |
| | | values(@parent_id,@torg_code,@torg_name,@status,@leve,@torg_seq,@lm_user,@lm_date,@islastreport)"; |
| | | list.Add(new |
| | | { |
| | | str = sql, |
| | |
| | | leve = leve, |
| | | torg_seq = torg_seq, |
| | | lm_user = us.usercode, |
| | | lm_date = DateTime.Now.ToString() |
| | | lm_date = DateTime.Now.ToString(), |
| | | islastreport= islastreport |
| | | } |
| | | }); |
| | | |
| | |
| | | } |
| | | |
| | | //ä¿®æ¹å½åç»ç»æ°æ® |
| | | sql = @"update TOrganization set parent_id=@parent_id,torg_name=@torg_name,leve=@leve,torg_seq=@torg_seq,lm_user=@lm_user,lm_date=@lm_date |
| | | sql = @"update TOrganization set parent_id=@parent_id,torg_name=@torg_name,leve=@leve,torg_seq=@torg_seq,lm_user=@lm_user,lm_date=@lm_date,islastreport=@islastreport |
| | | where torg_code=@torg_code"; |
| | | list.Add(new |
| | | { |
| | |
| | | leve = leve, |
| | | torg_seq = torg_seq, |
| | | lm_user = us.usercode, |
| | | lm_date = DateTime.Now.ToString() |
| | | lm_date = DateTime.Now.ToString(), |
| | | islastreport= islastreport |
| | | } |
| | | }); |
| | | //é彿´æ°ç¶æ,å½åé䏿°æ®åå级 |
| | |
| | | from TOrganization AS t |
| | | inner join CTE AS c ON t.parent_id = c.torg_code |
| | | ) |
| | | update TOrganization set status=@status |
| | | update TOrganization set status=@status,islastreport=@islastreport |
| | | where torg_code in (select torg_code from CTE)"; |
| | | list.Add(new |
| | | { |
| | |
| | | parm = new |
| | | { |
| | | OrganCode = OrganCode, |
| | | status = status |
| | | status = status, |
| | | islastreport= islastreport |
| | | } |
| | | }); |
| | | |
| | |
| | | } |
| | | else |
| | | { |
| | | //夿ä¸ä¼ æä»¶å¤§å°æ¯å¦è¶
è¿10M |
| | | if (file.Length > 1024 * 1024 * 10) |
| | | { |
| | | mes.code = "300"; |
| | | mes.message = "æä»¶å¤§å°ä¸è½è¶
è¿10MBï¼"; |
| | | return mes; |
| | | } |
| | | //è·åä¸ä¼ æä»¶,ç»ååå¨è·¯å¾ |
| | | string FileName = "SOP" + DateTime.Now.ToString("yyyyMMddhhmmss"); |
| | | string filePath = "wwwroot/ProcessSopFile/" + FileName + file.FileName; //éè¿æ¤å¯¹è±¡è·åæä»¶å(åæä»¶å°å) |
| | |
| | | } |
| | | // --------------æ¥è¯¢æå®æ°æ®-------------- |
| | | var total = 0; //æ»æ¡æ° |
| | | var sql = @"select A.id, A.status,A.wotype,A.wo_code,A.materiel_code as partcode,B.partname,B.partspec,A.route_code,B.default_route,R.name as route_name,A.plan_qty,A.wkshp_code,C.torg_name as wkshp_name, |
| | | var sql = @"select A.id, A.status,A.wotype,A.wo_code,A.materiel_code as partcode,B.partname,B.partspec,A.route_code,B.default_route,R.name as route_name,A.plan_qty,A.wkshp_code,C.torg_name as wkshp_name,C.islastreport, |
| | | A.stck_code,D.name as stck_name,A.plan_startdate,A.plan_enddate,A.piroque,A.sourceid,A.m_po,A.saleOrderDeliveryDate,W.saleOrderCode,U.username as lm_user,A.lm_date,A.data_sources,A.isstep,A.clerkuser, |
| | | B.priuserdefnvc1,B.priuserdefnvc2,B.priuserdefnvc3,B.priuserdefnvc4,B.priuserdefnvc5,B.priuserdefnvc6,A.printcount |
| | | from TK_Wrk_Man A |
| | |
| | | } |
| | | // --------------æ¥è¯¢æå®æ°æ®-------------- |
| | | var total = 0; //æ»æ¡æ° |
| | | var sql = @"select A.id, A.status,A.wotype,A.wo_code,A.materiel_code as partcode,B.partname,B.partspec,A.plan_qty,A.wkshp_code,C.torg_name as wkshp_name, |
| | | var sql = @"select A.id, A.status,A.wotype,A.wo_code,A.materiel_code as partcode,B.partname,B.partspec,A.plan_qty,A.wkshp_code,C.torg_name as wkshp_name,C.islastreport, |
| | | A.stck_code,D.name as stck_name,A.plan_startdate,A.plan_enddate,A.piroque,A.sourceid,A.m_po,A.saleOrderDeliveryDate,W.saleOrderCode,U.username as lm_user,A.lm_date,S.laborbad_qty,S.materielbad_qty, |
| | | B.priuserdefnvc1,B.priuserdefnvc2,B.priuserdefnvc3,B.priuserdefnvc4,B.priuserdefnvc5,B.priuserdefnvc6 |
| | | from TK_Wrk_Man A |
| | |
| | | } |
| | | // --------------æ¥è¯¢æå®æ°æ®-------------- |
| | | var total = 0; //æ»æ¡æ° |
| | | var sql = @"select A.id, A.status,A.wotype,A.wo_code,A.materiel_code as partcode,B.partname,B.partspec,A.plan_qty,A.wkshp_code,C.torg_name as wkshp_name, |
| | | var sql = @"select A.id, A.status,A.wotype,A.wo_code,A.materiel_code as partcode,B.partname,B.partspec,A.plan_qty,A.wkshp_code,C.torg_name as wkshp_name,C.islastreport, |
| | | A.stck_code,D.name as stck_name,A.plan_startdate,A.plan_enddate,A.piroque,A.sourceid,A.m_po,A.saleOrderDeliveryDate,W.saleOrderCode,U.username as lm_user,A.lm_date,A.data_sources, |
| | | B.priuserdefnvc1,B.priuserdefnvc2,B.priuserdefnvc3,B.priuserdefnvc4,B.priuserdefnvc5,B.priuserdefnvc6 |
| | | from TK_Wrk_Man A |
| | |
| | | |
| | | |
| | | #region[ç产æ§è¡,æ¥å·¥è°æ´æ°æ®æ¥è¯¢æ¥å£] |
| | | public static ToMessage MesOrderStepVerifySearch(string wkshopcode, string wo_code, string partnumber, string partname, string partspec, string reportuser, string reportdateopendate, string reportdateclosedate, int startNum, int endNum, string prop, string order) |
| | | public static ToMessage MesOrderStepVerifySearch(string wkshopcode, string wo_code, string partnumber, string partname, string partspec,string stepcode, string reportuser, string reportdateopendate, string reportdateclosedate, int startNum, int endNum, string prop, string order) |
| | | { |
| | | var dynamicParams = new DynamicParameters(); |
| | | string search = ""; |
| | |
| | | search += "and AA.partspec like '%'+@partspec+'%' "; |
| | | dynamicParams.Add("@partspec", partspec); |
| | | } |
| | | if (stepcode != "" && stepcode != null) |
| | | { |
| | | search += "and AA.step_code=@stepcode "; |
| | | dynamicParams.Add("@stepcode", stepcode); |
| | | } |
| | | if (reportuser != "" && reportuser != null) |
| | | { |
| | | search += "and AA.usercode like '%'+@reportuser+'%' "; |
| | |
| | | var total = 0; //æ»æ¡æ° |
| | | var sql = @"select * from( |
| | | select A.id,B.id as sbid,A.wo_code,A.materiel_code as partnumber,P.partname,P.partspec,K.plan_quantity,K.plan_qty as task_qty,M.wkshp_code,T.torg_name as wkshp_name,A.eqp_code,E.name as eqp_name, |
| | | A.step_seq,A.step_code,S.stepname,S.flwtype as steptype,k.isbott as first_choke,k.isend as last_choke,A.step_price,B.reckway,B.usergroup_code,G.usergroupname as usergroup_name, |
| | | A.step_seq,A.step_code,S.stepname,S.flwtype as steptype,A.style,k.isbott as first_choke,k.isend as last_choke,A.step_price,B.reckway,B.usergroup_code,G.usergroupname as usergroup_name, |
| | | B.report_person as usercode, |
| | | STUFF((SELECT ',' + U.username |
| | | FROM TUser U |
| | |
| | | where A.style='B' and B.style='B' and M.status<>'CLOSED' and A.verify='N' |
| | | union all |
| | | select A.id,B.id as sbid,A.wo_code,A.materiel_code as partnumber,P.partname,P.partspec,K.plan_quantity,K.plan_qty as task_qty,M.wkshp_code,T.torg_name as wkshp_name,A.wx_code as eqp_code,E.name as eqp_name, |
| | | A.step_seq,A.step_code,S.stepname,S.flwtype as steptype,k.isbott as first_choke,k.isend as last_choke,A.step_price,'person' as reckway,'' as usergroup_code,'' as usergroup_name, |
| | | A.step_seq,A.step_code,S.stepname,S.flwtype as steptype,A.style,k.isbott as first_choke,k.isend as last_choke,A.step_price,'person' as reckway,'' as usergroup_code,'' as usergroup_name, |
| | | B.in_person as usercode, |
| | | STUFF((SELECT ',' + U.username |
| | | FROM TUser U |
| | |
| | | } |
| | | #endregion |
| | | |
| | | #region[ç产æ§è¡,æ¥å·¥è°æ´æ¹éæ¹ä»·æ°æ®æäº¤] |
| | | public static ToMessage MesOrderStepPriceBatchUpdateSeave(User us, List<BatchPrice> json) |
| | | { |
| | | string sql = ""; |
| | | List<object> list = new List<object>(); |
| | | var dynamicParams = new DynamicParameters(); |
| | | try |
| | | { |
| | | if (json.Count > 0) |
| | | { |
| | | // 使ç¨Lambda表达å¼å¤æç±»ååå¸:å
¨é¨æ¥å·¥æè
å
¨é¨æ¶æ |
| | | bool allB = json.All(p => p.type == "B"); |
| | | bool allS = json.All(p => p.type == "S"); |
| | | if (allB)//å
¨é¨æ¥å·¥ |
| | | { |
| | | //å°List<BatchPrice>ä¸çidåæ®µè½¬æ¢ä¸ºå符串æ°ç» |
| | | string[] idArray = json.Select(bp => bp.id).ToArray(); |
| | | //åå对åºçæ¥å·¥è®°å½ä¸»è¡¨å·¥ä»· |
| | | sql = @"update TK_Wrk_Record set step_price=@step_price where id in @idArray and style='B'"; |
| | | list.Add(new |
| | | { |
| | | str = sql, |
| | | parm = new |
| | | { |
| | | step_price = decimal.Parse(json[0].price), |
| | | idArray = idArray |
| | | } |
| | | }); |
| | | } |
| | | else if (allS)//å
¨é¨æ¶æ |
| | | { |
| | | //å°List<BatchPrice>ä¸çidåæ®µè½¬æ¢ä¸ºå符串æ°ç» |
| | | string[] idArray = json.Select(bp => bp.id).ToArray(); |
| | | //åå对åºçæ¥å·¥è®°å½ä¸»è¡¨å·¥ä»· |
| | | sql = @"update TK_Wrk_OutRecord set step_price=@step_price where id in @idArray and style='S'"; |
| | | list.Add(new |
| | | { |
| | | str = sql, |
| | | parm = new |
| | | { |
| | | step_price = decimal.Parse(json[0].price), |
| | | idArray = idArray |
| | | } |
| | | }); |
| | | } |
| | | else // æ··åæ
åµ |
| | | { |
| | | //å°List<BatchPrice>ä¸ä¸ºæ¥å·¥çidåæ®µè½¬æ¢ä¸ºå符串æ°ç» |
| | | var bList = json.Where(p => p.type == "B").ToList(); |
| | | string[] idBArray = bList.Select(bp => bp.id).ToArray(); |
| | | //åå对åºçæ¥å·¥è®°å½ä¸»è¡¨å·¥ä»· |
| | | sql = @"update TK_Wrk_Record set step_price=@step_price where id in @idBArray and style='B'"; |
| | | list.Add(new |
| | | { |
| | | str = sql, |
| | | parm = new |
| | | { |
| | | step_price = decimal.Parse(json[0].price), |
| | | idBArray = idBArray |
| | | } |
| | | }); |
| | | //å°List<BatchPrice>ä¸ä¸ºæ¶æçidåæ®µè½¬æ¢ä¸ºå符串æ°ç» |
| | | var sList = json.Where(p => p.type == "S").ToList(); |
| | | string[] idSArray = sList.Select(bp => bp.id).ToArray(); |
| | | //åå对åºçæ¥å·¥è®°å½ä¸»è¡¨å·¥ä»· |
| | | sql = @"update TK_Wrk_OutRecord set step_price=@step_price where id in @idSArray and style='S'"; |
| | | list.Add(new |
| | | { |
| | | str = sql, |
| | | parm = new |
| | | { |
| | | step_price = decimal.Parse(json[0].price), |
| | | idSArray = idSArray |
| | | } |
| | | }); |
| | | } |
| | | bool aa = DapperHelper.DoTransaction(list); |
| | | if (aa) |
| | | { |
| | | //åå
¥æä½è®°å½è¡¨ |
| | | LogHelper.DbOperateLog(us.usercode, "æ¹éä¿®æ¹å·¥ä»·", "æ¥å·¥ID:" + string.Join(",", json.Select(bp => bp.id).ToArray()) + ",æä½ç±»å:" + string.Join(",", json.Select(bp => bp.type).ToArray()), us.usertype); |
| | | mes.code = "200"; |
| | | mes.count = 0; |
| | | mes.message = "æä½æå!"; |
| | | mes.data = null; |
| | | } |
| | | else |
| | | { |
| | | mes.code = "300"; |
| | | mes.count = 0; |
| | | mes.message = "æä½å¤±è´¥!"; |
| | | mes.data = null; |
| | | } |
| | | } |
| | | else |
| | | { |
| | | mes.code = "300"; |
| | | mes.count = 0; |
| | | mes.message = "è¯·éæ©éè¦æ¹éè°æ´å·¥ä»·çæ¥å·¥è®°å½!"; |
| | | mes.data = null; |
| | | return mes; |
| | | } |
| | | return mes; |
| | | } |
| | | catch (Exception) |
| | | { |
| | | |
| | | throw; |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | |
| | | |
| | | #region[ç产æ§è¡,æ¥å·¥å®¡æ ¸åè¡¨æ°æ®æ¥è¯¢æ¥å£] |
| ¶Ô±ÈÐÂÎļþ |
| | |
| | | using System; |
| | | using System.Collections.Generic; |
| | | using System.Linq; |
| | | using System.Threading.Tasks; |
| | | |
| | | namespace VueWebCoreApi.Models |
| | | { |
| | | public class BatchPrice |
| | | { |
| | | /// <summary> |
| | | /// æ¥å·¥è®°å½ä¸»è¡¨id |
| | | /// </summary> |
| | | public string id { get; set; } |
| | | /// <summary> |
| | | /// 工价 |
| | | /// </summary> |
| | | public string price { get; set; } |
| | | /// <summary> |
| | | /// æ¥å·¥ç±»å:B(æ¥å·¥)/S(æ¶æ) |
| | | /// </summary> |
| | | public string type { get; set; } |
| | | } |
| | | } |
| | |
| | | // è·åæè®¾ç½®ä»»ä½è¯·æ±æ£æçæå¤§å
许大å°ï¼ä»¥åè为åä½ï¼ã 设置为 null æ¶ï¼æå¤§è¯·æ±æ£æå¤§å°ä¸åéå¶ |
| | | // é»è®¤ä¸º 30000000 åè 大约为 28.6MB |
| | | |
| | | options.Limits.MaxRequestBodySize = 1073741824; //éå¶1G |
| | | options.Limits.MaxRequestBodySize = 10485760; //éå¶10M |
| | | //options.Limits.MaxRequestBodySize = null; //表示ä¸éå¶ |
| | | }); |
| | | webBuilder.UseStartup<Startup>(); |
| | |
| | | |
| | | try |
| | | { |
| | | string logContent = $"{DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")}_{dateTime.ToString("yyyy-MM-dd HH:mm:ss")}_{(string.IsNullOrEmpty(httpMessage) ? "OK" : httpMessage)}\r\n"; |
| | | string logContent = $"æå°ï¼{DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")}_{dateTime.ToString("yyyy-MM-dd HH:mm:ss")}_{(string.IsNullOrEmpty(httpMessage) ? "OK" : httpMessage)}\r\n"; |
| | | FileHelper.WriteFile(FileQuartz.LogPath + taskOptions.GroupName + "\\", $"{taskOptions.TaskName}.txt", logContent, true); |
| | | //await _hubContext.Clients.All.SendAsync("SendMessageç³»ç»éç¥:"+$"ææ°æ¶æ¯{DateTime.Now}"); |
| | | //await _hubContext.Clients.All.SendAll(logContent); |
| | | //æ¥æ¾ç³»ç»ç¨æ· |
| | | var sql = @"select usercode as code,username as name |
| | | from TUser |
| | | where is_delete='0' and enable='Y' and password='123'"; |
| | | where status='Y' and password='123'"; |
| | | var data = DapperHelper.selecttable(sql); |
| | | var departmentIDs = data.AsEnumerable().Select(x => x.Field<string>("code")).ToList();//è·åæ¨é人åç¼ç |
| | | var FindPublicBaseDic = UserIdsStore.Ids.Where(d => departmentIDs.Contains(d.Value)).Select(x => x.Key).ToList(); //å¹é
å·²ç»ç»å½çæ¨é人åconnectionIds |
| | |
| | | //å
许ä¸ä¼ 大æä»¶ |
| | | services.Configure<IISServerOptions>(options => |
| | | { |
| | | options.MaxRequestBodySize = 1073741824;//æ¤å¤é嶿大1G |
| | | options.MaxRequestBodySize = 10485760;//æ¤å¤é嶿大10M |
| | | }); |
| | | services.Configure<KestrelServerOptions>(options => |
| | | { |
| | | options.Limits.MaxRequestBodySize = 10485760; // 10M |
| | | }); |
| | | //è§£å³æä»¶ä¸ä¼ Multipart body length limit 134217728 exceeded. |
| | | services.Configure<FormOptions>(x => |
| | | { |
| | | //// 设置å个表åå¼çæå¤§é¿åº¦ |
| | | x.ValueLengthLimit = int.MaxValue; |
| | | x.MultipartBodyLengthLimit = 1073741824; //æ¤å¤é嶿大1G |
| | | // 设置å¤é¨åæ 头çé¿åº¦éå¶ |
| | | x.MultipartHeadersLengthLimit = int.MaxValue; |
| | | //设置æ´ä¸ª multipart 表åçæå¤§é¿åº¦ï¼å
³é®è®¾ç½®ï¼ |
| | | x.MultipartBodyLengthLimit = 10485760; //æ¤å¤é嶿大10M |
| | | }); |
| | | #endregion å
许大æä»¶ä¸ä¼ |
| | | } |
| | |
| | | } |
| | | }); |
| | | app.UseStaticFiles(); |
| | | app.Use(async (context, next) => |
| | | { |
| | | context.Request.EnableBuffering(); // ç¡®ä¿è¯·æ±å¯ä»¥è¢«å¤æ¬¡è¯»å |
| | | await next(); |
| | | }); |
| | | // 设置请æ±ä½å¤§å°éå¶ |
| | | app.Use(async (context, next) => |
| | | { |
| | | if (context.Request.ContentLength > 10 * 1024 * 1024) // 10MB |
| | | { |
| | | var message = new ToMessage |
| | | { |
| | | code = "300", |
| | | message = "请æ±ä½è¿å¤§ï¼è¯·æ£æ¥æä»¶å¤§å°ã" |
| | | }; |
| | | |
| | | // 设置æ£ç¡®çç¶æç å¹¶è¿ååºåååçJSON |
| | | context.Response.StatusCode = 300; // ä½¿ç¨ 413 Request Entity Too Large |
| | | context.Response.ContentType = "application/json; charset=utf-8"; // æç¡®å
容类å |
| | | |
| | | // å°å¯¹è±¡åºåå为JSONå符串 |
| | | string jsonResponse = System.Text.Json.JsonSerializer.Serialize(message); |
| | | await context.Response.WriteAsync(jsonResponse); |
| | | |
| | | return; // éè¦ï¼ç´æ¥è¿åï¼ä¸åè°ç¨åç»ä¸é´ä»¶ |
| | | } |
| | | await next(); // 妿æªè¶
éï¼åç»§ç»æ§è¡ç®¡éä¸çä¸ä¸ä¸ªä¸é´ä»¶ |
| | | }); |
| | | //è·¨å |
| | | app.UseCors("cors"); |
| | | //ç¨æ·sessionæå¡ |
| | |
| | | { |
| | | "DetailedErrors": true, |
| | | "Logging": { |
| | | "LogLevel": { |
| | | "Default": "Information", |