DBUtility/obj/Release/DBUtility.csproj.AssemblyReference.cacheBinary files differ
DBUtility/obj/Release/DBUtility.csproj.ResolveComReference.cacheBinary files differ
Model/obj/x86/Release/Model.csproj.AssemblyReference.cacheBinary files differ
SQLHelper/obj/Release/SQLHelper.csproj.AssemblyReference.cacheBinary files differ
SQLHelper/obj/x86/Release/SQLHelper.csproj.AssemblyReference.cacheBinary files differ
WebAPI/Controllers/BaseSet/Gy_MaterialController.cs
@@ -383,12 +383,12 @@ } if (sWhere == null || sWhere.Equals("")) { ds = oCN.RunProcReturn("select * from h_v_Gy_MouldFileList " + sWhere + "order by hmainid desc", "h_v_Gy_MouldFileList"); ds = oCN.RunProcReturn("select * from h_v_Gy_MouldFileList " + sWhere + "order by æ¥æ desc", "h_v_Gy_MouldFileList"); } else { string sql1 = "select * from h_v_Gy_MouldFileList where 1 = 1 "; string sql = sql1 + sWhere + "order by hmainid desc"; string sql = sql1 + sWhere + "order by æ¥æ desc"; ds = oCN.RunProcReturn(sql, "h_v_Gy_MouldFileList"); } WebAPI/Controllers/MateOutController.cs
@@ -501,7 +501,7 @@ } } /// <summary> /// çæçäº§é¢æå(红å) /// çæç产éæå /// </summary> /// <returns></returns> [Route("MateOut/set_SaveMateOutBackBill_Json")] @@ -536,6 +536,7 @@ websLsmain.HEmpID = lsmain[0].HEmpID; websLsmain.HRemark = lsmain[0].HRemark; websLsmain.HMaker = lsmain[0].HMaker; websLsmain.HBillType = "1244";//åºå®å¼ if (webserver.set_SaveMateOutBackBill_New(websLsmain, sSourceBillType, ref DBUtility.ClsPub.sErrInfo)) { WebAPI/Controllers/Sc_ProcessMangementController.cs
@@ -223,7 +223,7 @@ foreach (DataRow item in ds.Tables[0].Rows) { JObject FentityModel = new JObject(); FentityModel.Add("FReportType", "BD_OwnerOrg");//çäº§æ±æ¥ç±»å FentityModel.Add("FReportType", "103852");//çäº§æ±æ¥ç±»å FentityModel.Add("FTimeUnitId", "1");//æ¶é´åä½ FentityModel.Add("FWorkshipId", new JObject() { ["Fnumber"] = dr1["FWorkShopNUM"].ToString() }); // çäº§è½¦é´ FentityModel.Add("FStandHourUnitId", "3600"); // å使 åå·¥æ¶åä½ WebAPI/Controllers/²Ö´æ¹ÜÀí/ÁìÁÏ·¢»õ/Kf_MateOutBackBillController.cs
@@ -589,10 +589,10 @@ oItemSub.HEntryCloseDate = DBUtility.ClsPub.isDate(DateTime.Now); oItemSub.HCloseType = false; //å ³éç±»å //oItemSub.HRemark = ""; //夿³¨ oItemSub.HSourceInterID = 0; // æºå主å ç oItemSub.HSourceEntryID = 0; //æºååå ç //oItemSub.HSourceBillNo = ""; //æºååå· //oItemSub.HSourceBillType = ""; //æºåç±»å oItemSub.HSourceInterID = lsmain[0].HSourceInterID; // æºå主å ç oItemSub.HSourceEntryID = lsmain[0].HSourceEntryID; //æºååå ç oItemSub.HSourceBillNo = lsmain[0].HSourceBillNo; //æºååå· oItemSub.HSourceBillType = lsmain[0].HSourceBillType; //æºåç±»å //oItemSub.HRelationQty = 0; //å ³èæ°é //oItemSub.HRelationMoney = 0; //å ³èéé¢ //oItemSub.HRepairID = 0; //ç»´ä¿®é¡¹ç® WebAPI/Controllers/»ù´¡×ÊÁÏ/»ù´¡×ÊÁÏ/Gy_StockCheckItemBillController.cs
@@ -406,6 +406,7 @@ { var HBarCode = item.HBarCode; var HItemID = item.HItemID; string HDate = item.HMakeDate; string HBillNo = ""; Int64 HInterID = 0;//æ¾ç¤ºçåæ®µ DataSet ds1 = new DataSet(); @@ -422,7 +423,7 @@ ",HSupID,HSupTypeID,HWHID,HSCWHID,HEmpID,HManagerID,HSecManagerID" + ",HKeeperID,HDeptID,HInnerBillNo,HRedBlueFlag" + ") " + " values('3814','3814'," + HInterID + ",'" + HBillNo + "',getdate()" + " values('3814','3814'," + HInterID + ",'" + HBillNo + "','" + HDate+"'"+ ", '" + user + "',getdate()" + ", " + dr["HSupID"].ToString() + ", 1," + dr["HNowSupID"].ToString() + ",0,0,0,0" + ", 0," + dr["HDeptID"].ToString() + ",' ',0" + @@ -490,6 +491,7 @@ var HBarCode = item.HBarCode; var HItemID = item.HItemID; string HBillNo = ""; string HDate = item.HMakeDate; Int64 HInterID = 0;//æ¾ç¤ºçåæ®µ DataSet ds1 = new DataSet(); ds = oCn.RunProcReturn("select * from Gy_MouldFileMain where HBarCode='" + HBarCode + "'", "Gy_MouldFileMain"); @@ -504,7 +506,7 @@ ",HSupID,HSupTypeID,HWHID,HSCWHID,HEmpID,HManagerID,HSecManagerID" + ",HKeeperID,HDeptID,HInnerBillNo,HRedBlueFlag" + ") " + " values('3827','3827'," + HInterID + ",'" + HBillNo + "',getdate()" + " values('3827','3827'," + HInterID + ",'" + HBillNo + "','" + HDate + "'" + ", '" + user + "',getdate()" + ", " + dr1["HCorrespondentID"].ToString() + "," + dr1["HCorrespondentTypeID"].ToString() + ",isnull('" + dr["HNowSupID"].ToString() + "',0),0,0,0,0" + ", 0," + dr["HDeptID"].ToString() + ",'',0" + @@ -572,6 +574,7 @@ var HBarCode = item.HBarCode; var HItemID = item.HItemID; string HBillNo = ""; string HDate = item.HMakeDate; Int64 HInterID = 0;//æ¾ç¤ºçåæ®µ DataSet ds1 = new DataSet(); ds = oCn.RunProcReturn("select * from Gy_MouldFileMain where HBarCode='" + HBarCode + "'", "Gy_MouldFileMain"); @@ -587,7 +590,7 @@ ",HSupID,HSupTypeID,HWHID,HSCWHID,HEmpID,HManagerID,HSecManagerID" + ",HKeeperID,HDeptID,HInnerBillNo,HRedBlueFlag" + ") " + " values('3832','3832'," + HInterID + ",'" + HBillNo + "',getdate()" + " values('3832','3832'," + HInterID + ",'" + HBillNo + "','" + HDate + "'" + ", '" + user + "',getdate()" + ", " + dr1["HCorrespondentID"].ToString() + "," + dr1["HCorrespondentTypeID"].ToString() + "," + dr["HNowSupID"].ToString() + ",0,0,0,0" + ", 0," + dr["HDeptID"].ToString() + ",' ',0" + @@ -653,6 +656,7 @@ var HBarCode = item.HBarCode; var HItemID = item.HItemID; string HBillNo = ""; string HDate = item.HMakeDate; Int64 HInterID = 0;//æ¾ç¤ºçåæ®µ DataSet ds1 = new DataSet(); ds = oCn.RunProcReturn("select * from Gy_MouldFileMain where HBarCode='" + HBarCode + "'", "Gy_MouldFileMain"); @@ -668,7 +672,7 @@ ",HSupID,HSupTypeID,HWHID,HSCWHID,HEmpID,HManagerID,HSecManagerID" + ",HKeeperID,HDeptID,HInnerBillNo,HRedBlueFlag" + ") " + " values('3802','3802'," + HInterID + ",'" + HBillNo + "',getdate()" + " values('3802','3802'," + HInterID + ",'" + HBillNo + "','" + HDate + "'" + ", '" + user + "',getdate()" + ", " + dr1["HCorrespondentID"].ToString() + "," + dr1["HCorrespondentTypeID"].ToString() + "," + dr["HNowSupID"].ToString() + ",0,0,0,0" + ", 0," + dr["HDeptID"].ToString() + ",' ',0" + @@ -733,6 +737,7 @@ var HBarCode = item.HBarCode; var HItemID = item.HItemID; string HBillNo = ""; string HDate = item.HMakeDate; Int64 HInterID = 0;//æ¾ç¤ºçåæ®µ DataSet ds1 = new DataSet(); ds = oCn.RunProcReturn("select * from Gy_MouldFileMain where HBarCode='" + HBarCode + "'", "Gy_MouldFileMain"); @@ -748,7 +753,7 @@ ",HSupID,HSupTypeID,HWHID,HSCWHID,HEmpID,HManagerID,HSecManagerID" + ",HKeeperID,HDeptID,HInnerBillNo,HRedBlueFlag" + ") " + " values('3803','3803'," + HInterID + ",'" + HBillNo + "',getdate()" + " values('3803','3803'," + HInterID + ",'" + HBillNo + "','" + HDate + "'" + ", '" + user + "',getdate()" + ", " + dr["HNowSupID"].ToString() + "," + dr["HNowSupTypeID"].ToString() + "," + dr["HNowSupID"].ToString() + ",0,0,0,0" + ", 0," + dr["HDeptID"].ToString() + ",' ',0" + WebAPI/Models/ClsKf_ICStockBillMain.cs
@@ -48,6 +48,10 @@ public Int64 HPAYORGID; // int --仿¬¾ç»ç®ç»ç» public string HOWNERTYPEID; // varchar(100) --货主类å public string HStockStyle; // varchar(100) --åºåç±»å //æºåä¿¡æ¯ public string HSourceBillNo; public string HSourceBillType; public Int64 HSourceInterID; public Int64 HSourceEntryID; } } WebAPI/Models/Cls_InventoryAnalysisList.cs
@@ -15,5 +15,6 @@ public string HRealPot; public string HBookPotType; public string HBookPot; public string HMakeDate; } }