| | |
| | | <Compile Include="æºå\éè¶æºå\Cls_S_Sc_ICMOBillList_K3.cs" /> |
| | | <Compile Include="æºå\éè¶æºå\Cls_S_K3_EntrustInBillList.cs" /> |
| | | <Compile Include="æºå\éè¶æºå\Cls_S_KF_ChangeBoxBillList.cs" /> |
| | | <Compile Include="ç产管ç\ClsGy_SourceWorkStationSet.cs" /> |
| | | <Compile Include="ç产管ç\ClsSc_ChangeNoteBill.cs" /> |
| | | <Compile Include="ç产管ç\ClsSc_WIPStockChangeBill.cs" /> |
| | | <Compile Include="ç产管ç\ClsSc_WIPStockCheckBill.cs" /> |
New file |
| | |
| | | using System; |
| | | using System.Collections.Generic; |
| | | using System.Text; |
| | | using System.Data; |
| | | |
| | | namespace DAL |
| | | { |
| | | public class ClsGy_SourceWorkStationSet : DBUtility.ClsGy_Base_Ctl |
| | | { |
| | | SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); |
| | | public Model.ClsGy_SourceWorkStationSet oModel = new Model.ClsGy_SourceWorkStationSet(); |
| | | //æé 彿° |
| | | public ClsGy_SourceWorkStationSet() |
| | | { |
| | | MvarItemKey = "Gy_SourceWorkStationSet"; |
| | | MvarReportTitle = "产线工ä½"; |
| | | oModel = new Model.ClsGy_SourceWorkStationSet(); |
| | | } |
| | | |
| | | //æ°å¢ |
| | | public override bool AddNew() |
| | | { |
| | | try |
| | | { |
| | | string ssql = "Insert into " + MvarItemKey + " " + |
| | | "(HMacAddr,HSourceID,HProdOrgID,HWorkStationID,HProcID," + |
| | | " HType,HVideo,HRemark,HCreateDate,HCreator)" + |
| | | " Values('" + oModel.HMacAddr + "'," + oModel.HSourceID + "," + oModel.HProdOrgID + "," + oModel.HWorkStationID + "," |
| | | + oModel.HProcID + ",'" + oModel.HType + "'," + oModel.HVideo + ",'" + oModel.HRemark + "','" |
| | | + oModel.HCreateDate + "','" + oModel.HCreator + "')"; |
| | | oCn.BeginTran(); |
| | | oCn.RunProc(ssql, ref DBUtility.ClsPub.sExeReturnInfo); |
| | | oCn.Commit(); |
| | | return true; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | oCn.RollBack(); |
| | | throw (e); |
| | | } |
| | | } |
| | | |
| | | //ä¿®æ¹ |
| | | public override bool ModifyByID(Int64 sItemID) |
| | | { |
| | | try |
| | | { |
| | | string ssql = "Update " + MvarItemKey + " set " + |
| | | "HMacAddr='" + oModel.HMacAddr + "'" + |
| | | ",HSourceID='" + oModel.HSourceID + "'" + |
| | | ",HProdOrgID='" + oModel.HProdOrgID + "'" + |
| | | ",HWorkStationID= '" + oModel.HWorkStationID + "'" + |
| | | ",HProcID='" + oModel.HProcID + "'" + |
| | | ",HType='" + oModel.HType + "'" + |
| | | ",HVideo='" + oModel.HVideo +"' Where HItemID = " + sItemID; |
| | | oCn.BeginTran(); |
| | | oCn.RunProc(ssql, ref DBUtility.ClsPub.sExeReturnInfo); |
| | | oCn.Commit(); |
| | | return true; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | oCn.RollBack(); |
| | | throw (e); |
| | | } |
| | | } |
| | | } |
| | | } |
| | |
| | | ",HYear,HPeriod,HRemark" + |
| | | ",HSourceID,HICMOInterID,HICMOBillNo,HICMOQty,HProcExchInterID,HProcExchEntryID" + |
| | | ",HProcExchBillNo,HProcExchQty,HMaterID,HFirstCheckEmp,HLastResult" + |
| | | ",HMainSourceInterID,HMainSourceEntryID,HMainSourceBillNo,HMainSourceBillType,HICMOEntryID" + |
| | | ",HMainSourceInterID,HMainSourceEntryID,HMainSourceBillNo,HMainSourceBillType,HICMOEntryID,HQCSchemeID" + |
| | | ") " + |
| | | " values('" + this.BillType + "','" + this.HBillSubType + "'," + omodel.HInterID.ToString() + ",'" + omodel.HBillNo + "'," + omodel.HBillStatus.ToString() + ",'" + omodel.HDate + "','" + omodel.HMaker + "',getdate()" + |
| | | "," + omodel.HYear.ToString() + "," + omodel.HPeriod.ToString() + ",'" + omodel.HRemark + "'" + |
| | | "," + omodel.HSourceID.ToString() + "," + omodel.HICMOInterID.ToString() + ",'" + omodel.HICMOBillNo + "'," + omodel.HICMOQty.ToString() + "," + omodel.HProcExchInterID.ToString() + "," + omodel.HProcExchEntryID.ToString() + |
| | | ",'" + omodel.HProcExchBillNo + "'," + omodel.HProcExchQty.ToString() + "," + omodel.HMaterID.ToString() + "," + omodel.HFirstCheckEmp.ToString() + ", " + DBUtility.ClsPub.BoolToString(omodel.HLastResult) + |
| | | "," + omodel.HMainSourceInterID + "," + omodel.HMainSourceEntryID + ",'" + omodel.HMainSourceBillNo + "','" + omodel.HMainSourceBillType + "'," + omodel.HICMOEntryID + |
| | | "," + omodel.HMainSourceInterID + "," + omodel.HMainSourceEntryID + ",'" + omodel.HMainSourceBillNo + "','" + omodel.HMainSourceBillType + "'," + omodel.HICMOEntryID + "," + omodel.HQCSchemeID + |
| | | ") "); |
| | | //æå
¥å表 |
| | | foreach (Model.ClsQC_FirstPieceCheckBillSub oSub in DetailColl) |
| | |
| | | ",HBarCode,HLBatchNo,HCusID,HSortBillNo,HContrctBatchNo" + |
| | | ",HProdAreaID,HProdTypeID,HProdStoveNo,HRecipeID,HDiameter1" + |
| | | ",HDiameter2,HRoutingInterID,HDrawingDireID,HPackTypeID" + |
| | | ",HMainSourceInterID,HMainSourceEntryID,HMainSourceBillNo,HMainSourceBillType,HICMOEntryID" + |
| | | ",HMainSourceInterID,HMainSourceEntryID,HMainSourceBillNo,HMainSourceBillType,HICMOEntryID,HQCSchemeID" + |
| | | ") " + |
| | | " values('" + this.BillType + "','" + this.HBillSubType + "'," + omodel.HInterID.ToString() + ",'" + omodel.HBillNo + "'," + omodel.HBillStatus.ToString() + ",'" + omodel.HDate + "','" + omodel.HMaker + "',getdate()" + |
| | | "," + omodel.HYear.ToString() + "," + omodel.HPeriod.ToString() + ",'" + omodel.HRemark + "'"+ |
| | |
| | | ",'" + omodel.HBarCode + "','" + omodel.HLBatchNo + "'," + omodel.HCusID.ToString() + ",'" + omodel.HSortBillNo + "','" + omodel.HContrctBatchNo + "'" + |
| | | "," + omodel.HProdAreaID.ToString() + "," + omodel.HProdTypeID.ToString() + ",'" + omodel.HProdStoveNo + "'," + omodel.HRecipeID.ToString() + "," + omodel.HDiameter1.ToString() + |
| | | "," + omodel.HDiameter2.ToString() + "," + omodel.HRoutingInterID.ToString() + ",'" + omodel.HDrawingDireID + "'," + omodel.HPackTypeID.ToString() + |
| | | "," + omodel.HMainSourceInterID + "," + omodel.HMainSourceEntryID + ",'" + omodel.HMainSourceBillNo + "','" + omodel.HMainSourceBillType + "'," + omodel.HICMOEntryID + |
| | | "," + omodel.HMainSourceInterID + "," + omodel.HMainSourceEntryID + ",'" + omodel.HMainSourceBillNo + "','" + omodel.HMainSourceBillType + "'," + omodel.HICMOEntryID + "," + omodel.HQCSchemeID + |
| | | ") "); |
| | | //æå
¥å表 |
| | | foreach (Model.ClsQC_ProcessCheckBillSub oSub in DetailColl) |
| | |
| | | <Compile Include="åºç¡èµæ\åºç¡èµæ\ClsGy_TechnologyParameter_Model.cs" /> |
| | | <Compile Include="ææ¬ç®¡ç\ClsKf_ICBal.cs" /> |
| | | <Compile Include="ææ¬ç®¡ç\ClsKf_WIPBal.cs" /> |
| | | <Compile Include="ç产管ç\ClsGy_SourceWorkStationSet.cs" /> |
| | | <Compile Include="ç产管ç\ClsSc_ChangeNoteBillMain.cs" /> |
| | | <Compile Include="ç产管ç\ClsSc_ChangeNoteBillSub.cs" /> |
| | | <Compile Include="ç产管ç\ClsSc_MateWasterRequestBillMain.cs" /> |
New file |
| | |
| | | using System; |
| | | using System.Collections.Generic; |
| | | using System.Text; |
| | | |
| | | namespace Model |
| | | { |
| | | public class ClsGy_SourceWorkStationSet : DBUtility.ClsGy_Base_Model |
| | | { |
| | | public string HMacAddr; //MACå· |
| | | public Int64 HSourceID; //çäº§èµæº(Gy_Source) |
| | | public Int64 HProdOrgID; //ç产ç»ç»() |
| | | public Int64 HWorkStationID; //å·¥ä½ï¼Gy_WorkStationï¼ |
| | | public Int64 HProcID; //å·¥åº(Gy_Process) |
| | | public string HType; //å¹é
ç±»åï¼æå·¥ä½å¹é
ï¼æå·¥åºå¹é
ï¼æå·¥ä½+å·¥åºå¹é
ï¼ |
| | | public Int64 HVideo; //æ¯å¦é»è®¤ææ¾è§é¢ |
| | | public DateTime HCreateDate; //åå»ºæ¥æ |
| | | public string HCreator; //å建人ï¼åHUserName ä¸è´ï¼ |
| | | } |
| | | } |
| | |
| | | public String HBackRemark; |
| | | public Int64 HPrintQty; |
| | | public Int64 HICMOEntryID; |
| | | public Int64 HQCSchemeID; |
| | | |
| | | } |
| | | } |
| | |
| | | public Int64 HItemID; |
| | | public Int64 HSEQ; |
| | | public String HInSpectResult; |
| | | public decimal HInSpectValue; |
| | | public double HInSpectValue; |
| | | public Int64 HInSpectValueB; |
| | | public String HInSpectValueT; |
| | | } |
| | |
| | | public String HDrawingDireID; |
| | | public Int64 HPackTypeID; |
| | | public Int64 HICMOEntryID; |
| | | |
| | | public Int64 HQCSchemeID; |
| | | |
| | | } |
| | | } |
| | |
| | | public Int64 HItemID; |
| | | public Int64 HSEQ; |
| | | public String HInSpectResult; |
| | | public decimal HInSpectValue; |
| | | public double HInSpectValue; |
| | | public Int64 HInSpectValueB; |
| | | public String HInSpectValueT; |
| | | } |
| | |
| | | #region[ç¨æ·å表æ¥è¯¢] |
| | | [Route("Xt_User/list")] |
| | | [HttpGet] |
| | | public object list(string sWhere) |
| | | public object list(string sWhere,string user) |
| | | { |
| | | try |
| | | { |
| | | if (!DBUtility.ClsPub.Security_Log_second("Xt_User_Query", 1, false, user)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ æ¥çæéï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_IF_UserList " + sWhere, "h_v_IF_UserList"); |
New file |
| | |
| | | using Newtonsoft.Json; |
| | | using Newtonsoft.Json.Linq; |
| | | using Pub_Class; |
| | | using System; |
| | | using System.Collections; |
| | | using System.Collections.Generic; |
| | | using System.Data; |
| | | using System.Data.SqlClient; |
| | | using System.Web.Http; |
| | | using WebAPI.Models; |
| | | |
| | | namespace WebAPI.Controllers |
| | | { |
| | | public class Gy_SourceWorkStationSetController : ApiController |
| | | { |
| | | public DBUtility.ClsPub.Enum_BillStatus BillStatus; |
| | | |
| | | private json objJsonResult = new json(); |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | DataSet ds; |
| | | |
| | | /// <summary> |
| | | /// è¿åç产工ä½å表 |
| | | ///åæ°ï¼string sqlã |
| | | ///è¿åå¼ï¼objectã |
| | | /// </summary> |
| | | [Route("Gy_SourceWorkStationSet/list")] |
| | | [HttpGet] |
| | | public object list(string sWhere, string user) |
| | | { |
| | | try |
| | | { |
| | | List<object> columnNameList = new List<object>(); |
| | | //ç¼è¾æé |
| | | if (!DBUtility.ClsPub.Security_Log_second("Gy_SourceWorkStationSet_Query", 1, false, user)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ æ¥çæéï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | string sql1 = string.Format(@"select * from h_v_Gy_SourceWorkStationSetList where 1 = 1"); |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn(sql1 + sWhere + " order by HItemID ", "h_v_Gy_SourceWorkStationSetList"); |
| | | } |
| | | else |
| | | { |
| | | string sql = sql1 + sWhere + " order by HItemID "; |
| | | ds = oCN.RunProcReturn(sql, "h_v_Gy_SourceWorkStationSetList"); |
| | | } |
| | | |
| | | //æ·»å åå |
| | | 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) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "Exceptionï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | #region 产线工ä½ä¿å |
| | | [Route("Gy_SourceWorkStationSet/Save")] |
| | | [HttpPost] |
| | | public object set_SaveBill([FromBody] JObject oMain) |
| | | { |
| | | var _value = oMain["oMain"].ToString(); |
| | | string msg1 = _value.ToString(); |
| | | //ä¿ååæ® |
| | | return objJsonResult = AddBillMain(msg1); |
| | | } |
| | | |
| | | public json AddBillMain(string msg1) |
| | | { |
| | | string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); |
| | | string msg2 = sArray[0].ToString(); |
| | | string user = sArray[1].ToString(); //ç¨æ· |
| | | bool bResult; |
| | | try |
| | | { |
| | | //夿æé |
| | | if (!DBUtility.ClsPub.Security_Log("Gy_SourceWorkStationSet_Edit", 1, false, user)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ ä¿åæé"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | msg2 = "[" + msg2.ToString() + "]"; |
| | | List<Model.ClsGy_SourceWorkStationSet> mainList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsGy_SourceWorkStationSet>>(msg2); |
| | | DAL.ClsGy_SourceWorkStationSet BillNew = new DAL.ClsGy_SourceWorkStationSet(); |
| | | //夿ä¼è®¡ææ¯å¦åç |
| | | string s = ""; |
| | | int sYear = 0; |
| | | int sPeriod = 0; |
| | | DateTime HDate = mainList[0].HCreateDate;//æ¥æ |
| | | if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod(HDate, ref sYear, ref sPeriod, ref s) == false) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = s; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | //åºå®èµå¼================================= |
| | | BillNew.oModel.HMacAddr = mainList[0].HMacAddr; |
| | | BillNew.oModel.HSourceID = mainList[0].HSourceID; |
| | | BillNew.oModel.HProdOrgID = mainList[0].HProdOrgID; |
| | | BillNew.oModel.HWorkStationID = mainList[0].HWorkStationID; |
| | | BillNew.oModel.HProcID = mainList[0].HProcID; |
| | | BillNew.oModel.HType = ClsPub.isStrNull(mainList[0].HType); |
| | | BillNew.oModel.HVideo = ClsPub.isLong(mainList[0].HVideo); |
| | | BillNew.oModel.HCreateDate = ClsPub.isDate(mainList[0].HCreateDate); |
| | | BillNew.oModel.HCreator = ClsPub.isStrNull(mainList[0].HCreator); |
| | | |
| | | //ä¿å宿¯åå¤ç |
| | | if (mainList[0].HItemID == 0) |
| | | { |
| | | bResult = BillNew.AddNew(); |
| | | } |
| | | else |
| | | { |
| | | bResult = BillNew.ModifyByID(mainList[0].HItemID); |
| | | } |
| | | //æç¤º |
| | | if (bResult == true) |
| | | { |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | //objJsonResult.Message = "åæ®åç宿¯!åæ®å·:" + mainList[0].HBillNo.Trim(); |
| | | objJsonResult.Message = "ä¿åæå!" + ClsPub.sExeReturnInfo; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "ä¿å失败!åå :" + ClsPub.sExeReturnInfo; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "Exceptionï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | } |
| | | } |
| | |
| | | BillNew.omodel.HMainSourceEntryID = ClsPub.isLong(mainList[0].HMainSourceEntryID); |
| | | BillNew.omodel.HMainSourceBillNo = ClsPub.isStrNull(mainList[0].HMainSourceBillNo); |
| | | BillNew.omodel.HMainSourceBillType = ClsPub.isStrNull(mainList[0].HMainSourceBillType); |
| | | BillNew.omodel.HQCSchemeID = ClsPub.isLong(mainList[0].HQCSchemeID); |
| | | BillNew.omodel.HBillStatus = 1; |
| | | BillNew.omodel.HProcID = ClsPub.isLong(mainList[0].HProcID); |
| | | List<Model.ClsQC_ProcessCheckBillSub> subList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsQC_ProcessCheckBillSub>>(msg3); |
| | |
| | | oSub_Value.HEntryID = HEntryID; |
| | | oSub_Value.HSEQ = i + 1; |
| | | oSub_Value.HInSpectResult = ClsPub.isStrNull(valueList[i].HInSpectResult); |
| | | oSub_Value.HInSpectValue = ClsPub.isLong(valueList[i].HInSpectValue); |
| | | oSub_Value.HInSpectValue = ClsPub.isDoule(valueList[i].HInSpectValue); |
| | | oSub_Value.HInSpectValueB = ClsPub.isLong(valueList[i].HInSpectValueB); |
| | | oSub_Value.HInSpectValueT = ClsPub.isStrNull(valueList[i].HInSpectValueT); |
| | | |
| | |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | /// <summary> |
| | | ///è¿åæ£éªå¼å表 |
| | | /// </summary> |
| | | /// <param name="sWhere"></param> |
| | | /// <returns></returns> |
| | | [Route("QC_ValueTable_ProcessCheck/getValueList")] |
| | | [HttpGet] |
| | | public object getValueList(Int64 HInterID, Int64 HEntryID, string user) |
| | | { |
| | | DataSet ds; |
| | | try |
| | | { |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | |
| | | ds = oCN.RunProcReturn("select * from QC_ProcessCheckBillSub_ValueGrid where HInterID=" + HInterID + " and HEntryID=" + HEntryID, "QC_ProcessCheckBillSub_ValueGrid"); |
| | | |
| | | if (ds.Tables[0].Rows.Count > 0) |
| | | { |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "Sucessï¼"; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ²¡ææ¥è¯¢å°æ°æ®ï¼"; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "没æè¿åä»»ä½è®°å½ï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | } |
| | | } |
| | |
| | | BillNew.omodel.HMainSourceEntryID = ClsPub.isLong(mainList[0].HMainSourceEntryID); |
| | | BillNew.omodel.HMainSourceBillNo = ClsPub.isStrNull(mainList[0].HMainSourceBillNo); |
| | | BillNew.omodel.HMainSourceBillType = ClsPub.isStrNull(mainList[0].HMainSourceBillType); |
| | | BillNew.omodel.HQCSchemeID = ClsPub.isLong(mainList[0].HQCSchemeID); |
| | | BillNew.omodel.HBillStatus = 1; |
| | | List<Model.ClsQC_FirstPieceCheckBillSub> subList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsQC_FirstPieceCheckBillSub>>(msg3); |
| | | BillNew.DetailColl = new List<Model.ClsQC_FirstPieceCheckBillSub>(); |
| | |
| | | oSub_Value.HEntryID = HEntryID; |
| | | oSub_Value.HSEQ = i + 1; |
| | | oSub_Value.HInSpectResult = ClsPub.isStrNull(valueList[i].HInSpectResult); |
| | | oSub_Value.HInSpectValue = ClsPub.isLong(valueList[i].HInSpectValue); |
| | | oSub_Value.HInSpectValue = ClsPub.isDoule(valueList[i].HInSpectValue); |
| | | oSub_Value.HInSpectValueB = ClsPub.isLong(valueList[i].HInSpectValueB); |
| | | oSub_Value.HInSpectValueT = ClsPub.isStrNull(valueList[i].HInSpectValueT); |
| | | |
| | |
| | | try |
| | | { |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | List<object> columnNameList = new List<object>(); |
| | | |
| | | ds = oCN.RunProcReturn("select * from QC_FirstPieceCheckBillSub_ValueGrid where HInterID="+ HInterID + " and HEntryID="+ HEntryID, "h_v_QC_FirstPieceCheckBillList"); |
| | | |
| | | //æ·»å åå |
| | | 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.Tables[0].Rows.Count > 0) |
| | | { |
| | |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "Sucessï¼"; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | objJsonResult.list = columnNameList; |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ²¡ææ¥è¯¢å°æ°æ®ï¼"; |
| | | objJsonResult.Message = "æ æ£æµå¼æ°æ®ï¼"; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | return objJsonResult; |
| | | } |
| | |
| | | <Compile Include="Controllers\SBGL\SBTC\Sb_EquipWorkBeforeCheckBillController.cs" /> |
| | | <Compile Include="Controllers\SBGL\Sb_EquipWorkBeforeCheckSBillController.cs" /> |
| | | <Compile Include="Controllers\SBGL\Sb_EquipStockInCheckBillSController.cs" /> |
| | | <Compile Include="Controllers\SCGL\Gy_SourceWorkStationSetController.cs" /> |
| | | <Compile Include="Controllers\SCGL\Sc_ComplementGoodBill_ZXBZController.cs" /> |
| | | <Compile Include="Controllers\SCGL\æ¥è®¡å管ç\DataHelper.cs" /> |
| | | <Compile Include="Controllers\SCGL\æ¥è®¡å管ç\JIT_Cg_PODemandPlanBillController.cs" /> |
| | |
| | | <Folder Include="Views\Gy_RoutingGroup\" /> |
| | | <Folder Include="Views\Gy_SettleStyle\" /> |
| | | <Folder Include="Views\Gy_SOPBill\" /> |
| | | <Folder Include="Views\Gy_SourceWorkStationSet\" /> |
| | | <Folder Include="Views\Gy_SplitBarCode\" /> |
| | | <Folder Include="Views\Gy_Staff\" /> |
| | | <Folder Include="Views\Gy_StdMinPickQty\" /> |