SRM-API-HK.git - Gitblit

			@@ -2181,6 +2181,7 @@
			public object DeltetBarCodeBill([FromBody] JObject oData)
			{
			SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();

			try
			{
			var _value = oData["oData"].ToString();
			@@ -2189,7 +2190,14 @@
			string HInter = sArray[0].ToString();
			string HInterID = HInter.Replace("\"", "");
			string HUserName = sArray[1].ToString();

			if (!DBUtility.ClsPub.Security_Log("Gy_SupMaterPack_Delete", 1, false, HUserName))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "无保存权限！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			string FCusName = oSystemParameter.GetSingleSystemParameter("WMS_CampanyName", ref DBUtility.ClsPub.sExeReturnInfo);
			string sql = "select HItemID,HBarCode,HSourceInterID,HSourceEntryID,HQty,HBarCodeType,HSourceBillType from Gy_BarCodeBill where HItemID in(" + HInterID + ") ";
			//LogService.Write("删除sql:" + sql);

			@@ -35,6 +35,14 @@
			string VsWhere = sWhere;
			SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
			DataSet ds;
			if (!DBUtility.ClsPub.Security_Log("Gy_SupMaterPack_Query", 1, false, user))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "无保存权限！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			//其他过滤
			//string sql = " where 1 = 1 " + sqlWhere;
			////转换特殊字符
			@@ -576,8 +584,15 @@
			objJsonResult.data = null;
			return objJsonResult;
			}

			oCN.BeginTran();
			if (!DBUtility.ClsPub.Security_Log("Gy_SupMaterPack_Delete", 1, false, user))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "无保存权限！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			oCN.BeginTran();

			// oCN.RunProc("delete from Gy_UserMaterRelation where HInterID = " + HItemID);
			oCN.RunProc("delete from Gy_UserMaterRelation where HItemID='" + HItemID + "'");

	WebAPI/Controllers/BarCodeController.cs	10 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	WebAPI/Controllers/MaterialHandingController.cs	19 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史