| | |
| | | public string HMainSourceBillType; |
| | | public Int64 HMainSourceInterID; |
| | | public Int64 HMainSourceEntryID; |
| | | public Int64 HProcExchInterID; |
| | | public Int64 HProcExchEntryID; |
| | | public string HProcExchBillNo; |
| | | public string HMainSourceBillNo; |
| | | public int HPrintQty; |
| | | public int HItemMainID; |
| | |
| | | ",HSellManID,HSellMan,HDeptID,HDept " + |
| | | ",HWhID,HWHName,HSupID,HSupName " + |
| | | ",HSCWHID,HSCWHName " + |
| | | ",HCloudUserName,HCloudUserPsd,HUSEORGID) " + |
| | | ",HCloudUserName,HCloudUserPsd,HUSEORGID,HProcID" + |
| | | ",HGroupID,HSourceID) " + |
| | | "values ('" + lsmain[0].Czybm.ToString() + "','" + lsmain[0].Czymc.ToString() + "','" + ClsPub.StrToPsd(lsmain[0].Czmm.ToString()) + "','" + lsmain[0].Explain.ToString() + "','" + lsmain[0].HEmpID.ToString() + "',"+ lsmain[0].HK3UserID.ToString() + "" + |
| | | ","+ lsmain[0].HKeeperID.ToString() + ",'"+ lsmain[0].HKeeper.ToString() + "',"+ lsmain[0].HSecManagerID.ToString() + ",'"+ lsmain[0].HSecManager.ToString() + "'" + |
| | | "," + lsmain[0].HSellManID.ToString() + ",'" + lsmain[0].HSellMan.ToString() + "'," + lsmain[0].HDeptID.ToString() + ",'" + lsmain[0].HDept.ToString() + "'" + |
| | | "," + lsmain[0].HWhID.ToString() + ",'" + lsmain[0].HWHName.ToString() + "'," + lsmain[0].HSupID.ToString() + ",'" + lsmain[0].HSupName.ToString() + "'" + |
| | | "," + lsmain[0].HSCWHID.ToString() + ",'" + lsmain[0].HSCWHName.ToString() + "'" + |
| | | ",'" + lsmain[0].HCloudUserName.ToString() + "','" + lsmain[0].HCloudUserPsd.ToString() + "',"+ lsmain[0].HOrgID.ToString() + ")"); |
| | | ",'" + lsmain[0].HCloudUserName.ToString() + "','" + lsmain[0].HCloudUserPsd.ToString() + "',"+ lsmain[0].HOrgID.ToString() + "," + lsmain[0].HProcID.ToString() + "" + |
| | | ","+ lsmain[0].HGroupID.ToString() + ","+ lsmain[0].HSourceID.ToString() + ")"); |
| | | |
| | | //æ°å¢åæ¥è¯¢ ç¡®ä¿æ°æ®æ·»å æå |
| | | ds = oCN.RunProcReturn("Select * from Gy_Czygl where Czybm='" + lsmain[0].Czybm.ToString() + "'", "Gy_Czygl"); |
| | |
| | | ",HSCWHID=" + lsmain[0].HSCWHID.ToString() + |
| | | ",HSCWHName='" + lsmain[0].HSCWHName.ToString() + "'" + |
| | | ",HSupID=" + lsmain[0].HSupID.ToString() + |
| | | ",HProcID=" + lsmain[0].HProcID.ToString() + |
| | | ",HSourceID=" + lsmain[0].HSourceID.ToString() + |
| | | ",HGroupID=" + lsmain[0].HGroupID.ToString() + |
| | | ",HSupName='" + lsmain[0].HSupName.ToString() + "'" + |
| | | ",HCloudUserName='" + lsmain[0].HCloudUserName.ToString() + "'" + |
| | | ",HCloudUserPsd='" + lsmain[0].HCloudUserPsd.ToString() + "'" + |
| | |
| | | ",HSCWHID=" + lsmain[0].HSCWHID.ToString() + |
| | | ",HSCWHName='" + lsmain[0].HSCWHName.ToString() + "'" + |
| | | ",HSupID=" + lsmain[0].HSupID.ToString() + |
| | | ",HProcID=" + lsmain[0].HProcID.ToString() + |
| | | ",HSourceID=" + lsmain[0].HSourceID.ToString() + |
| | | ",HGroupID=" + lsmain[0].HGroupID.ToString() + |
| | | ",HSupName='" + lsmain[0].HSupName.ToString() + "'" + |
| | | ",HCloudUserName='" + lsmain[0].HCloudUserName.ToString() + "'" + |
| | | ",HCloudUserPsd='" + lsmain[0].HCloudUserPsd.ToString() + "'" + |
| | |
| | | } |
| | | |
| | | ds = oCN.RunProcReturn("select * from gy_czygl where czymc='" + user + "'", "gy_czygl"); |
| | | string HProcID = ds.Tables[0].Rows[0]["HProcID"].ToString(); |
| | | |
| | | ds = oCN.RunProcReturn(@"exec h_p_Gy_BarCodeBillBomList '" + HBarCode + "'," + ds.Tables[0].Rows[0]["HProcID"].ToString(), "h_p_Gy_BarCodeBillBomList"); |
| | | ds = oCN.RunProcReturn(@"exec h_p_Gy_BarCodeBillBomList '" + HBarCode + "'," + HProcID, "h_p_Gy_BarCodeBillBomList"); |
| | | if (ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "é
ä»¶æ¸
åæ¥æ æ°æ®ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | DataSet dataSet = oCN.RunProcReturn(@"exec h_p_Sc_ProcessExchangeBillList '" + HBarCode + "'," + HProcID, "h_p_Sc_ProcessExchangeBillList"); |
| | | |
| | | if (dataSet.Tables[0].Rows.Count > 0) |
| | | { |
| | | objJsonResult.code = "2"; |
| | | objJsonResult.count = 2; |
| | | objJsonResult.Message = ""; |
| | | objJsonResult.data = dataSet.Tables[0]; |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "é
ä»¶æ¸
åæ¥æ æ°æ®ï¼,å¯è½æ¯å½åç¨æ·å·¥åºä¸æ£ç¡®æè
æµè½¬å¡è¾å
¥é误!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | else |
| | | { |
| | |
| | | if (tempList.Count == 0) { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ æ°æ®!"; |
| | | objJsonResult.Message = "æ é
ä»¶æ°æ®!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | |
| | | sub = JsonConvert.DeserializeObject<List<Model.ClsSc_AssemblyBillSub>>(sSubStr); |
| | | |
| | | |
| | | ds = oCN.RunProcReturn("select * from h_v_Gy_QualifiedRecordsList where äº§åæ¡ç ='" + omodel.HBarCode_P + "'", "h_v_Gy_QualifiedRecordsList"); |
| | | ds = oCN.RunProcReturn("select * from h_v_Gy_QualifiedRecordsList where äº§åæ¡ç ='" + omodel.HBarCode_P + "' and HProcExchInterID="+ omodel .HProcExchInterID+ " and HProcExchEntryID="+ omodel.HProcExchEntryID + " and HProcID="+ omodel.HProcID, "h_v_Gy_QualifiedRecordsList"); |
| | | if (ds.Tables[0].Rows.Count > 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | |
| | | |
| | | //ååå·¥åºåºç«åçä¸è¯æ°é |
| | | oCN.RunProc("update Sc_StationOutBillMain set HBadCount-=1 where HProcExchInterID='" + HProcExchInterID + "' and HProcExchEntryID=" + HProcExchEntryID); |
| | | //ååæµè½¬å¡ç¶æ |
| | | oCN.RunProc("update Gy_BarCodeBill set HStatus='' where HBarCode='" + HBarCode + "'"); |
| | | |
| | | |
| | | oCN.Commit(); |
| | |
| | | return objJsonResult; |
| | | } |
| | | |
| | | if (ds.Tables[0].Rows[0]["HProcID"].ToString() != HProcID) |
| | | int num = 0; |
| | | for (int i = 0; i < ds.Tables[0].Rows.Count; i++) |
| | | { |
| | | if (ds.Tables[0].Rows[i]["HProcID"].ToString() == HProcID) |
| | | { |
| | | num = 1; |
| | | } |
| | | } |
| | | if (num == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | |
| | | ({model.HInterID},{(ds.Tables[0].Rows.Count == 0 ? 1 : int.Parse(ds.Tables[0].Rows[0]["HEntryID"].ToString()) + 1)},'{model.HBillNo}','',{temp.HProcExchInterID} |
| | | ,{temp.HProcExchEntryID},'{temp.HProcExchBillNo}','',{temp.HMaterID},0,'{temp.HBarCode}','{temp.HBatchNo}')"); |
| | | |
| | | |
| | | ds = oCN.RunProcReturn("select * from Sc_SourceLineRepairBillSub where HInterID=" + model.HInterID, "Sc_SourceLineRepairBillSub"); |
| | | |
| | | if (ds.Tables[0].Rows[0]["HRepairResult"].ToString() == "OK") { |
| | | |
| | | //ç产工åºåºç«SNæ°æ® |
| | | ds = oCN.RunProcReturn("select top 1 HInterID,HBillNo from Sc_StationOutBillMain where HProcExchInterID=" + temp.HProcExchInterID + " and HProcExchEntryID=" + temp.HProcExchEntryID + " and HBadCount<>0 order by HInterID desc", "Sc_StationOutBillMain"); |
| | | |
| | | string HInterIDSN = ds.Tables[0].Rows[0]["HInterID"].ToString(); |
| | | string HBillNoSN = ds.Tables[0].Rows[0]["HBillNo"].ToString(); |
| | | |
| | | ds = oCN.RunProcReturn("select * from Sc_StationOutBillSub_SN where HInterID=" + HInterIDSN , "Sc_StationOutBillSub_SN"); |
| | | |
| | | oCN.RunProc($@"insert into Sc_StationOutBillSub_SN(HInterID,HBillNo_bak,HEntryID,HBarCode,HBarCodeQty,HMakeTime,HRemark,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney) |
| | | values({HInterIDSN}, '{HBillNoSN}', {ds.Tables[0].Rows.Count + 1}, '{model.HBarCode}', 1, GETDATE(), '', "+ temp.HProcExchInterID + ","+ temp.HProcExchEntryID+ ", '"+ temp.HProcExchBillNo+ "', '', 0, 0)"); |
| | | //ååå·¥åºåºç«å 主表 ä¸è¯æ°é å åæ ¼æ°é |
| | | oCN.RunProc("update Sc_StationOutBillMain set HQty+=1,HBadCount-=1 where HInterID='" + HInterIDSN + "'"); |
| | | } |
| | | |
| | | //ä¿®æ¹äº§çº¿è¿½æº¯åç»å®çæ¡ç æ¹å· |
| | | oCN.RunProc("update Sc_AssemblyBillSub set HBarCode='" + temp.HBarCode + "' where HInterID=" + temp.HInterID + " and HEntryID=" + temp.HEntryID); |
| | | //oCN.RunProc("exec h_p_AssemblyBill_Temp '" + temp.HProcExchBillNo + "'," + model.HProcess + "," + temp.HMaterID + ",'" + temp.HBatchNo + "'"); |
| | |
| | | |
| | | if (HResult == "OK") |
| | | { |
| | | ds = oCN.RunProcReturn("select * from Sc_SourceLineRepairBillSub where HInterID=" + model.HInterID, "Sc_SourceLineRepairBillSub"); |
| | | |
| | | if (ds.Tables[0].Rows[0]["HRepairResult"].ToString() == "OK") |
| | | { |
| | | |
| | | //ç产工åºåºç«SNæ°æ® |
| | | ds = oCN.RunProcReturn("select top 1 HInterID,HBillNo from Sc_StationOutBillMain where HProcExchInterID=" + model.HProcExchInterID + " and HProcExchEntryID=" + model.HProcExchEntryID + " and HBadCount<>0 order by HInterID desc", "Sc_StationOutBillMain"); |
| | | |
| | | string HInterIDSN = ds.Tables[0].Rows[0]["HInterID"].ToString(); |
| | | string HBillNoSN = ds.Tables[0].Rows[0]["HBillNo"].ToString(); |
| | | |
| | | ds = oCN.RunProcReturn("select * from Sc_StationOutBillSub_SN where HInterID=" + HInterIDSN, "Sc_StationOutBillSub_SN"); |
| | | |
| | | oCN.RunProc($@"insert into Sc_StationOutBillSub_SN(HInterID,HBillNo_bak,HEntryID,HBarCode,HBarCodeQty,HMakeTime,HRemark,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney) |
| | | values({HInterIDSN}, '{HBillNoSN}', {ds.Tables[0].Rows.Count + 1}, '{model.HBarCode}', 1, GETDATE(), '', " + model.HProcExchInterID + "," + model.HProcExchEntryID + ", '" + model.HProcExchBillNo + "', '', 0, 0)"); |
| | | //ååå·¥åºåºç«å 主表 ä¸è¯æ°é å åæ ¼æ°é |
| | | oCN.RunProc("update Sc_StationOutBillMain set HQty+=1,HBadCount-=1 where HInterID='" + HInterIDSN + "'"); |
| | | } |
| | | |
| | | oCN.RunProc("update Gy_BarCodeBill set HStatus='' where HBarCode='" + model.HBarCode + "'"); |
| | | } |
| | | } |
| | |
| | | } |
| | | #endregion |
| | | |
| | | #region å·¥åºååè¿ç« åæ ¼è¿½æº¯æ¥è¯¢æ¥è¡¨ |
| | | [Route("Cj_SingleStation/RetrospectiveQueryReport")] |
| | | [HttpGet] |
| | | public object RetrospectiveQueryReport(string HBardCode, string HProcExchBillNo, string HICMOBillNo, string sWhere, string user) |
| | | { |
| | | try |
| | | { |
| | | |
| | | List<object> columnNameList = new List<object>(); |
| | | |
| | | string sql = @"exec h_p_RetrospectiveQueryReport '" + sWhere + "', '" + HBardCode + "', '" + HProcExchBillNo + "','" + HICMOBillNo + "' "; |
| | | ds = oCN.RunProcReturn(sql, "h_p_RetrospectiveQueryReport"); |
| | | |
| | | //æ·»å åå |
| | | 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.data = ds.Tables[0]; |
| | | objJsonResult.list = columnNameList; |
| | | return objJsonResult; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | oCN.RollBack(); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "Exceptionï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | #region å·¥åºååè¿ç« ä¸è¯è¿½æº¯æ¥è¯¢æ¥è¡¨ |
| | | [Route("Cj_SingleStation/BadQueryReport")] |
| | | [HttpGet] |
| | | public object BadQueryReport(string HBardCode, string HProcExchBillNo, string HICMOBillNo, string sWhere, string user) |
| | | { |
| | | try |
| | | { |
| | | |
| | | List<object> columnNameList = new List<object>(); |
| | | |
| | | string sql = @"exec h_p_BadQueryReport '" + sWhere + "', '" + HBardCode + "', '" + HProcExchBillNo + "','" + HICMOBillNo + "' "; |
| | | ds = oCN.RunProcReturn(sql, "h_p_BadQueryReport"); |
| | | |
| | | //æ·»å åå |
| | | 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.data = ds.Tables[0]; |
| | | objJsonResult.list = columnNameList; |
| | | return objJsonResult; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | oCN.RollBack(); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "Exceptionï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | } |
| | | } |
| | |
| | | public string HCustomerName { get; set; } |
| | | public string HProductName { get; set; } |
| | | public string HOtherSearch { get; set; } |
| | | public string HEmpName { get; set; } |
| | | } |
| | | [Route("MaterOutEntryReport/SC_DayRkReport")] |
| | | [HttpGet] |
| | |
| | | } |
| | | #endregion |
| | | |
| | | #region[设å¤ç¹æ£è®¡å表ç¼è¾æ¶è·åè¡¨ä½æ°æ®--ç¹æ£è®¡å] |
| | | [Route("Sb_EquipDotCheckPlanBill/GetPlanList")] |
| | | [HttpGet] |
| | | public object GetPlanList(string sqlWhere) |
| | | { |
| | | DataSet ds; |
| | | try |
| | | { |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | if (sqlWhere == null || sqlWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_Sb_EquipDotCheckPlanList", "h_v_Sb_EquipDotCheckPlanList"); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "è·åä¿¡æ¯æåï¼"; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_Sb_EquipDotCheckPlanList where 1 = 1 "; |
| | | string sql = sql1 + sqlWhere; |
| | | ds = oCN.RunProcReturn(sql, "h_v_Sb_EquipDotCheckPlanList"); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "è·åä¿¡æ¯æåï¼"; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "没æè¿åä»»ä½è®¡åï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | } |
| | | return objJsonResult; |
| | | } |
| | | #endregion |
| | | |
| | | #region 设å¤ç¹æ£è®¡ååå®¡æ ¸/åå®¡æ ¸åè½ |
| | | [Route("Sb_EquipDotCheckPlanBill/CheckSb_EquipDotCheckPlanBill")] |
| | | [HttpGet] |
| | |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | //èªå¨çæç¹æ£è®¡åå |
| | | oCN.RunProc("exec h_p_Sb_EquipDotCheckPlan_Auto " + HInterID); |
| | | } |
| | | else |
| | | { |
| | |
| | | { |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | |
| | | string sql1 = @"select ç¹æ£é¡¹ç®ID HDotCheckItemID,ç¹æ£é¡¹ç® HDotCheckItem,ç¹æ£é¨ä½ HDotCheckPart,å
·ä½è¦æ± HClaim,è´è´£äººID HManagerID,è´è´£äººä»£ç HManagerNumber,è´è´£äºº HManagerName,å夿³¨ HRemark,b.HNumber ç¹æ£é¡¹ç®ä»£ç from h_v_Sb_EquipDotCheckRuleList a |
| | | string sql1 = @"select * from h_v_Sb_EquipDotCheckRuleList a |
| | | left join Gy_QCCheckItem b on a.ç¹æ£é¡¹ç®ID =b.HItemID where 1 = 1 "; |
| | | string sql = sql1 + sqlWhere; |
| | | ds = oCN.RunProcReturn(sql, "h_v_Sb_EquipDotCheckRuleList"); |
| | |
| | | } |
| | | #endregion |
| | | |
| | | #region[设å¤ä¿å
»è®¡å表ç¼è¾æ¶è·åè¡¨ä½æ°æ®--ä¿å
»è®¡å] |
| | | [Route("Sb_EquipMaintainPlanBill/GetPlanList")] |
| | | [HttpGet] |
| | | public object GetPlanList(string sqlWhere) |
| | | { |
| | | DataSet ds; |
| | | try |
| | | { |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | if (sqlWhere == null || sqlWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_Sb_EquipMaintainPlanList", "h_v_Sb_EquipMaintainPlanList"); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "è·åä¿¡æ¯æåï¼"; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_Sb_EquipMaintainPlanList where 1 = 1 "; |
| | | string sql = sql1 + sqlWhere; |
| | | ds = oCN.RunProcReturn(sql, "h_v_Sb_EquipMaintainPlanList"); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "è·åä¿¡æ¯æåï¼"; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "没æè¿åä»»ä½è®¡åï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | } |
| | | return objJsonResult; |
| | | } |
| | | #endregion |
| | | |
| | | #region 设å¤ä¿å
»è®¡ååå®¡æ ¸/åå®¡æ ¸åè½ |
| | | [Route("Sb_EquipMaintainPlanBill/CheckSb_EquipMaintainPlanBill")] |
| | | [HttpGet] |
| | |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | //èªå¨çæç¹æ£è®¡åå |
| | | oCN.RunProc("exec h_p_Sb_EquipMaintainPlan_Auto " + HInterID); |
| | | } |
| | | else |
| | | { |
| | |
| | | { |
| | | try |
| | | { |
| | | if (HInterID == 0 || HBillType.Equals("")) |
| | | List<object> columnNameList = new List<object>(); |
| | | |
| | | string sReturn = ""; |
| | | string sql = ""; |
| | | if (oSystemParameter.ShowBill(ref sReturn)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "åæ°ä¸å
¨ï¼è·åæºåä¿¡æ¯å¤±è´¥ï¼HInterIDï¼" + HInterID + "ï¼HEntryIDï¼" + HEntryID + "ï¼HBillTypeï¼" + HBillType + "ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | switch (oSystemParameter.omodel.QC_ProcessCheckBill_QCSchemeSource) |
| | | { |
| | | case "å·¥åº": |
| | | sql = "exec h_p_QC_GetInfoByICMOStatusBill " + "'å·¥åº'," + HInterID + "," + HEntryID + "," + HBillType; |
| | | break; |
| | | case "ç©æ": |
| | | sql = "exec h_p_QC_GetInfoByICMOStatusBill " + "'ç©æ'," + HInterID + "," + HEntryID + "," + HBillType; |
| | | break; |
| | | case "å·¥èºè·¯çº¿": |
| | | sql = "exec h_p_QC_GetInfoByICMOStatusBill " + "'å·¥èºè·¯çº¿'," + HInterID + "," + HEntryID + "," + HBillType; |
| | | break; |
| | | } |
| | | |
| | | } |
| | | ds = oCN.RunProcReturn(sql, "h_p_QC_GetInfoByICMOStatusBill"); |
| | | |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | |
| | | } |
| | | else |
| | | { |
| | | ds = oCN.RunProcReturn("exec h_p_QC_GetInfoByICMOStatusBill " + HInterID + "," + HEntryID + "," + HBillType, "h_p_QC_GetInfoByICMOStatusBill"); |
| | | //æ·»å åå |
| | | 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å对象çåå |
| | | } |
| | | } |
| | | |
| | | //if (HInterID == 0 || HBillType.Equals("")) |
| | | //{ |
| | | // objJsonResult.code = "0"; |
| | | // objJsonResult.count = 0; |
| | | // objJsonResult.Message = "åæ°ä¸å
¨ï¼è·åæºåä¿¡æ¯å¤±è´¥ï¼HInterIDï¼" + HInterID + "ï¼HEntryIDï¼" + HEntryID + "ï¼HBillTypeï¼" + HBillType + "ï¼"; |
| | | // objJsonResult.data = null; |
| | | // return objJsonResult; |
| | | //} |
| | | //else |
| | | //{ |
| | | // ds = oCN.RunProcReturn("exec h_p_QC_GetInfoByICMOStatusBill " + HInterID + "," + HEntryID + "," + HBillType, "h_p_QC_GetInfoByICMOStatusBill"); |
| | | //} |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "è¿åè®°å½æåï¼"; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | objJsonResult.list = columnNameList; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | |
| | | { |
| | | try |
| | | { |
| | | List<object> columnNameList = new List<object>(); |
| | | |
| | | if (HInterID == 0 || HBillType.Equals("")) |
| | | { |
| | | objJsonResult.code = "0"; |
| | |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | |
| | | string sReturn = ""; |
| | | string sql = ""; |
| | | if (oSystemParameter.ShowBill(ref sReturn)) |
| | | { |
| | | ds = oCN.RunProcReturn("exec h_p_QC_GetInfoByICMOStatusBill " + HInterID + "," + HEntryID + "," + HBillType, "h_p_QC_GetInfoByICMOStatusBill"); |
| | | switch (oSystemParameter.omodel.QC_FirstPieceCheckBill_QCSchemeSource) |
| | | { |
| | | case "ç©æ": |
| | | sql = "exec h_p_QC_GetInfoByICMOStatusBill " + "'ç©æ'" + "," + HInterID + "," + HEntryID + "," + HBillType; |
| | | break; |
| | | } |
| | | |
| | | } |
| | | |
| | | ds = oCN.RunProcReturn(sql, "h_p_QC_GetInfoByICMOStatusBill"); |
| | | |
| | | //æ·»å åå |
| | | 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å对象çåå |
| | | } |
| | | |
| | | |
| | | |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ¥è¯¢æ°æ®å¼å¸¸ï¼è¯·ä¸ç®¡çåèç³»ï¼"; |
| | | objJsonResult.Message = "没æ¥è¯¢å°æ°æ®ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "è¿åè®°å½æåï¼"; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | objJsonResult.list = columnNameList; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | |
| | | public string HSCWHName; |
| | | public int HSupID; |
| | | public string HSupName; |
| | | public int HProcID; |
| | | public int HGroupID; |
| | | public int HSourceID; |
| | | } |
| | | } |
| | |
| | | <!--<add key="sUrl" value="http://47.96.97.237/WEBS-WMS/WebService1.asmx"/> --> <!--æµè¯æå¡å¨--> |
| | | <!--<add key="sUrl" value="http://localhost:8082/WEBS/WebService1.asmx"/> æ¬å°--> |
| | | <!--<add key="sUrl" value="http://192.168.56.1:81/web/WebService1.asmx"/>--> <!--éé¯éæ¬å°é
ç½®--> |
| | | <add key="sUrl" value="http://192.168.1.57:8082/WEBS-WMS/WebService1.asmx"/><!--ä¹è±--> |
| | | |
| | | <add key="webpages:Version" value="3.0.0.0" /> |
| | | <add key="webpages:Enabled" value="false" /> |
| | | <add key="ClientValidationEnabled" value="true" /> |
| | |
| | | </basicHttpBinding> |
| | | </bindings> |
| | | <client> |
| | | <endpoint address="http://192.168.63.20/WEBS-WMS/WebService1.asmx" binding="basicHttpBinding" |
| | | <endpoint address="http://192.168.1.57:8082/WEBS-WMS/WebService1.asmx" binding="basicHttpBinding" |
| | | bindingConfiguration="WebService1Soap" contract="Webs1.WebService1Soap" |
| | | name="WebService1Soap" /> |
| | | </client> |
| | |
| | | <applicationSettings> |
| | | <WebAPI.Properties.Settings> |
| | | <setting name="WebAPI_WebS_WebService1" serializeAs="String"> |
| | | <value>http://192.168.63.20/WEBS-WMS/WebService1.asmx</value> |
| | | <value>http://192.168.1.57:8082/WEBS-WMS/WebService1.asmx</value> |
| | | </setting> |
| | | </WebAPI.Properties.Settings> |
| | | </applicationSettings> |