瑞琪的,报废的生成入库单的时候把传的值 之前是=KCZT08_SYS 现在改成=KCZT001
乔一入库报表,生产报表
过滤条件 按照排产日期查询,加一个自定义条件
| | |
| | | } |
| | | #endregion |
| | | |
| | | #region ç产å
¥åºæ¥è¡¨ |
| | | [Route("MaterOutEntryReport/sc_ICOMRKReport")] |
| | | [HttpGet] |
| | | public object sc_ICOMRKReport(string sWhere) |
| | | { |
| | | try |
| | | { |
| | | string sql = "select * from h_v_sc_ICOMRKReport where 1=1 " + sWhere + " order by æ¥æ "; |
| | | |
| | | ds = oCN.RunProcReturn(sql, "h_v_sc_ICOMRKReport"); |
| | | |
| | | DataTable dt = ds.Tables[0]; |
| | | |
| | | //è·ååå |
| | | List<object> columnNameList = new List<object>(); |
| | | //æ·»å åå |
| | | foreach (DataColumn col in ds.Tables[0].Columns) |
| | | { |
| | | Type dataType = col.DataType; |
| | | string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}"; |
| | | columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//è·åå°DataColumnå对象çåå |
| | | } |
| | | |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "Sucessï¼"; |
| | | objJsonResult.list = columnNameList; |
| | | objJsonResult.data = dt; |
| | | return objJsonResult; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "Exceptionï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | #region ç产æ¥è®°æ¥è¡¨ |
| | | public class DayRkReport { |
| | | public string HBeginDate { get; set; } |
| | | public string HEndDate { get; set; } |
| | | public string HMaterNumber { get; set; } |
| | | public string HCustomerName { get; set; } |
| | | public string HProductName { get; set; } |
| | | } |
| | | [Route("MaterOutEntryReport/SC_DayRkReport")] |
| | | [HttpGet] |
| | | public object SC_DayRkReport(string sWhere,int num) |
| | | { |
| | | try |
| | | { |
| | | DayRkReport DayRkReportList = JsonConvert.DeserializeObject<DayRkReport>(sWhere); |
| | | |
| | | string sql = $"exec h_p_Gy_DayRkReport '{DayRkReportList.HBeginDate}','{DayRkReportList.HEndDate}','{DayRkReportList.HMaterNumber}'" + |
| | | $",'{DayRkReportList.HProductName}','{DayRkReportList.HCustomerName}'"; |
| | | ds = oCN.RunProcReturn(sql, "h_p_Gy_DayRkReport"); |
| | | |
| | | DataTable dt = null; |
| | | if (num == 1) |
| | | { |
| | | dt = ds.Tables[0]; |
| | | } |
| | | else if (num == 2) |
| | | { |
| | | dt = ds.Tables[1]; |
| | | } |
| | | |
| | | //è·ååå |
| | | List<object> columnNameList = new List<object>(); |
| | | if (num == 1) |
| | | { |
| | | //æ·»å åå |
| | | foreach (DataColumn col in ds.Tables[0].Columns) |
| | | { |
| | | Type dataType = col.DataType; |
| | | string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}"; |
| | | columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//è·åå°DataColumnå对象çåå |
| | | } |
| | | } |
| | | else if (num == 2) |
| | | { |
| | | //æ·»å åå |
| | | foreach (DataColumn col in ds.Tables[1].Columns) |
| | | { |
| | | Type dataType = col.DataType; |
| | | string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}"; |
| | | columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//è·åå°DataColumnå对象çåå |
| | | } |
| | | } |
| | | |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "Sucessï¼"; |
| | | objJsonResult.list = columnNameList; |
| | | objJsonResult.data = dt; |
| | | return objJsonResult; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "Exceptionï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | #endregion |
| | | |
| | | } |
| | |
| | | omdelMian = JsonConvert.DeserializeObject<Sc_WorkBillSortBillMain>(sWhere); |
| | | |
| | | ds = oCN.RunProcReturn($"exec h_p_JIT_Sc_WorkBillSortBill_Query '{omdelMian.HPlanBeginDate}',{(omdelMian.HProdORGID == null ? 0 : omdelMian.HProdORGID)},'{omdelMian.HSeOrderBillNo}'" + |
| | | $",'{omdelMian.HPlanEndDate.AddDays(1)}',{omdelMian.HMaterID},'{omdelMian.HICMOBillNo}',{omdelMian.HWorkShopID}", "h_p_JIT_Sc_WorkBillSortBill_Query"); |
| | | $",'{omdelMian.HPlanEndDate.AddDays(1)}',{omdelMian.HMaterID},'{omdelMian.HICMOBillNo}',{omdelMian.HWorkShopID}" + |
| | | $",'{omdelMian.HMastersDate}','{omdelMian.sWheres}'", "h_p_JIT_Sc_WorkBillSortBill_Query"); |
| | | |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | |
| | | { |
| | | SumCount += 1; |
| | | ////ä¿åå表 |
| | | |
| | | objJsonResult = AddBillSub(HInterID == 0 ? list[i]["hmainid"].ToString() : HInterID.ToString() |
| | | , HBillNo == "" ? list[i]["åæ®å·"].ToString() : HBillNo |
| | | , DateTime.Parse(DateTime.Now.AddDays(j).ToString("yyyy-MM-dd").ToString()) |
| | |
| | | } |
| | | |
| | | |
| | | int TrueCount = 0, SumCount = 0; |
| | | |
| | | |
| | | for (int i = 0; i < list.Count; i++) |
| | | { |
| | | int TrueCount = 0, SumCount = 0; |
| | | long HInterID = 0; |
| | | var HBillNo = ""; |
| | | if (list[i]["åæ®å·"].ToString() == "" && list[i]["hmainid"].ToString() == "") |
| | |
| | | var HMainSourceEntryID = list[i]["ICMOBillHEntryID"].ToString(); |
| | | var HSeOrderBillNo = list[i]["HSeOrderBillNo"].ToString(); |
| | | |
| | | ds = oCN.RunProcReturn($"select * from Sc_WorkBillSortBillMain where HMainSourceInterID={HMainSourceInterID}" + |
| | | $" and HMainSourceEntryID={HMainSourceEntryID} and HICMOBillNo='{HICMOBillNo}' and HICMOEntrySEQ={HICMOEntrySEQ} and HSourceID={HSourceID}", "Sc_WorkBillSortBillMain"); |
| | | string sql = $"select * from Sc_WorkBillSortBillMain where HMainSourceInterID={HMainSourceInterID}" + |
| | | $" and HMainSourceEntryID={HMainSourceEntryID} and HICMOBillNo='{HICMOBillNo}' and HICMOEntrySEQ={HICMOEntrySEQ} and HSourceID={HSourceID}"; |
| | | LogService.Write("sql:" + sql); |
| | | ds = oCN.RunProcReturn(sql, "Sc_WorkBillSortBillMain"); |
| | | if (ds.Tables[0].Rows.Count > 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | |
| | | |
| | | for (int j = 0; j < SumDay; j++) |
| | | { |
| | | LogService.Write("1:" + list[i][DateTime.Now.AddDays(j).ToString("yyyy-MM-dd")].ToString()); |
| | | LogService.Write("2:" + DateTime.Now.AddDays(j).ToString("yyyy-MM-dd")); |
| | | //主表åè¡¨é½ææ°æ® |
| | | if (list[i][DateTime.Now.AddDays(j).ToString("yyyy-MM-dd")].ToString() != "") |
| | | { |
| | |
| | | objJsonResult = AddBillSub(HInterID.ToString(), HBillNo, DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd").ToString()), 0); |
| | | } |
| | | } |
| | | if (TrueCount != SumCount) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = objJsonResult.Message; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | if (TrueCount != SumCount) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = objJsonResult.Message; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | |
| | | { |
| | | //è·åè¡¨æ ¼æ°æ® |
| | | ds = oCN.RunProcReturn($"select * from h_v_JIT_Sc_WorkBillSortBillList where åæ®å·='{HBillNo}'", "h_v_JIT_Sc_WorkBillSortBillList"); |
| | | |
| | | int count = 0; |
| | | if (ds.Tables[0].Rows.Count > 0) |
| | | { |
| | |
| | | FentityModel.Add("FSrcInterId", item["HSourceInterID"].ToString());// |
| | | FentityModel.Add("FBasePrdRealQty", item["æ°é"].ToString());// |
| | | FentityModel.Add("FIsFinished", "false");// |
| | | FentityModel.Add("FStockStatusId", new JObject() { ["FNumber"] = "KCZT08_SYS" }); // |
| | | FentityModel.Add("FStockStatusId", new JObject() { ["FNumber"] = "KCZT001" }); // |
| | | FentityModel.Add("FSrcEntrySeq", item["HSourceSeQ"].ToString());// æºååå½è¡å· |
| | | FentityModel.Add("FMOMAINENTRYID", item["HMOEntryID"].ToString());// |
| | | FentityModel.Add("FKeeperTypeId", "BD_KeeperOrg"); |
| | |
| | | [HttpGet] |
| | | public object ReportFromBillList(int page, int limit, string sWhere,string HSouceBillType,string HOrgID) |
| | | { |
| | | oSystemParameter.ShowBill(ref DBUtility.ClsPub.sExeReturnInfo); |
| | | List<object> columnNameList = new List<object>(); |
| | | try |
| | | { |
| | |
| | | break; |
| | | case "æ¶æéç¥å": |
| | | tabname = "h_v_IF_POInStockBillList_Source"; |
| | | count = new SQLHelper.ClsCN().RunProcReturn("select * from h_v_IF_POInStockBillList_Source " + sWhere + " order by åæ®å· desc,hsubid", tabname).Tables[0].Rows.Count; |
| | | sql = string.Format(@"select * from(select row_number() over (order by åæ®å· desc,hsubid) as HRowNumber,* from h_v_IF_POInStockBillList_Source " + sWhere + ") as A where HRowNumber >" + pageSize + " *(" + pageNum + "-1)"); |
| | | if (oSystemParameter.omodel.WMS_CampanyName == "çä¸ç¥º") |
| | | { |
| | | count = new SQLHelper.ClsCN().RunProcReturn("select top 1000 * from h_v_IF_POInStockBillList_Source " + sWhere + " order by åæ®å· desc,hsubid", tabname).Tables[0].Rows.Count; |
| | | sql = string.Format(@"select * from(select top 1000 row_number() over (order by åæ®å· desc,hsubid) as HRowNumber,* from h_v_IF_POInStockBillList_Source " + sWhere + ") as A where HRowNumber >" + pageSize + " *(" + pageNum + "-1)"); |
| | | } |
| | | else |
| | | { |
| | | count = new SQLHelper.ClsCN().RunProcReturn("select * from h_v_IF_POInStockBillList_Source " + sWhere + " order by åæ®å· desc,hsubid", tabname).Tables[0].Rows.Count; |
| | | sql = string.Format(@"select * from(select row_number() over (order by åæ®å· desc,hsubid) as HRowNumber,* from h_v_IF_POInStockBillList_Source " + sWhere + ") as A where HRowNumber >" + pageSize + " *(" + pageNum + "-1)"); |
| | | } |
| | | break; |
| | | case "å§å¤è®¢å": |
| | | tabname = "h_v_IF_EntrustOrderBillList_Source"; |
| | |
| | | |
| | | public object HSourceOrderList1(DataTable dt, HSouceOrderList ordrlist, string HBarCodeType,string HSourceBillType) |
| | | { |
| | | oSystemParameter.ShowBill(ref DBUtility.ClsPub.sExeReturnInfo); |
| | | for (int i = 0; i < dt.Rows.Count; i++) |
| | | { |
| | | ordrlist.HQty = dt.Rows[i]["æªçææ¡ç æ°é"].ToString(); |
| | |
| | | |
| | | if(HSourceBillType == "æ¶æéç¥å") |
| | | { |
| | | ordrlist.HFurnaceNO = dt.Rows[i]["çå·"].ToString(); |
| | | ordrlist.HCoilNO = dt.Rows[i]["é¢å·æå
å·"].ToString(); |
| | | ordrlist.HheatNO = dt.Rows[i]["çå¤ç"].ToString(); |
| | | if (oSystemParameter.omodel.WMS_CampanyName != "çä¸ç¥º") |
| | | { |
| | | ordrlist.HFurnaceNO = dt.Rows[i]["çå·"].ToString(); |
| | | ordrlist.HCoilNO = dt.Rows[i]["é¢å·æå
å·"].ToString(); |
| | | ordrlist.HheatNO = dt.Rows[i]["çå¤ç"].ToString(); |
| | | } |
| | | } |
| | | |
| | | if (HBarCodeType == "仪å¨å¤è´ä»¶æ¡ç 容å¨è§å") |
| | |
| | | #region ç产任å¡åè·åè½¦é´ |
| | | [Route("Sc_ICMOBill/GetHDeptList")] |
| | | [HttpGet] |
| | | public object GetHDeptList() |
| | | public object GetHDeptList(string HOrgID) |
| | | { |
| | | try |
| | | { |
| | | DataSet oDs = new DataSet(); |
| | | //========== |
| | | oDs = oCN.RunProcReturn("select HItemID,HName from Gy_Department", "Gy_Department"); |
| | | oDs = oCN.RunProcReturn("select HItemID,HName from Gy_Department where HUSEORGID="+ HOrgID, "Gy_Department"); |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "è·åæåï¼"; |
| | |
| | | public string HICMOEntryID_Sec { get; set; } |
| | | public string HOrderType { get; set; } |
| | | public string HMonthPlanFlag { get; set; } |
| | | public string HMastersDate { get; set; } |
| | | public string sWheres { get; set; } |
| | | } |
| | | } |