~yxj/MES-WEB-API.git

			@@ -11,6 +11,10 @@
			//原代码用于替换子项目
			public string HOldNumber;
			public Model.ClsGy_BarCodeBill_WMS_Model oModel = new Model.ClsGy_BarCodeBill_WMS_Model();
			public const string ModRightName = "Gy_BarCodeBillList";
			public const string ModRightNameEdit = ModRightName + "_Edit"; //删除
			public const string ModRightNameDelete = ModRightName + "_Delete"; //作废
			public const string ModRightNamePrint = ModRightName + "_Print"; //打印
			//新增
			public override bool AddNew()
			{
			@@ -220,6 +224,202 @@
			}
			}


			//删除条码
			public bool DeleteBill(long sHItemID, string sHBarCode, string CurUserName, ref string sReturn)
			{
			//编辑权限
			if (!DBUtility.ClsPub.Security_Log(ModRightNameEdit, 1, false, CurUserName))
			{
			sReturn = "您没有删除权限！";
			return true;
			}
			try
			{
			DataSet DS = oCn.RunProcReturn("exec h_p_Gy_BarCodeBill_Delete " + sHItemID + ",'" + sHBarCode + "','" + CurUserName + "','" + DBUtility.ClsPub.ComputerName + "','" + DBUtility.ClsPub.IPAddress + "'", "h_p_Gy_BarCodeBill_Delete", ref DBUtility.ClsPub.sExeReturnInfo);
			if (DS == null \|\| DS.Tables[0].Rows.Count <= 0)
			{
			oCn.CnClose();
			oCn.CnDispose();
			sReturn = "删除条码时发生错误！";
			return true;
			}
			else
			{
			//删除失败
			if (DBUtility.ClsPub.isStrNull(DS.Tables[0].Rows[0][0]) == "1")
			{
			oCn.CnClose();
			oCn.CnDispose();
			sReturn = DBUtility.ClsPub.isStrNull(DS.Tables[0].Rows[0]["HRemark"]);
			return true;
			}
			else
			//删除成功
			{
			oCn.CnClose();
			oCn.CnDispose();
			sReturn = DBUtility.ClsPub.isStrNull(DS.Tables[0].Rows[0]["HRemark"]);
			return false;
			}
			}
			}
			catch (Exception e)
			{
			oCn.RollBack();
			throw (e);
			}
			}

			//批量删除条码
			public bool MulDeleteBill(string sHItemID, string sHBarCode, string CurUserName, ref string sReturn)
			{
			//编辑权限
			if (!DBUtility.ClsPub.Security_Log(ModRightNameEdit, 1, false, CurUserName))
			{
			sReturn = "您没有删除权限！";
			return true;
			}
			try
			{
			DataSet DS = oCn.RunProcReturn("exec h_p_Gy_BarCodeBill_MulDelete '" + sHItemID + "','" + sHBarCode + "','" + CurUserName + "','" + DBUtility.ClsPub.ComputerName + "','" + DBUtility.ClsPub.IPAddress + "'", "h_p_Gy_BarCodeBill_MulDelete", ref DBUtility.ClsPub.sExeReturnInfo);
			if (DS == null \|\| DS.Tables[0].Rows.Count <= 0)
			{
			oCn.CnClose();
			oCn.CnDispose();
			sReturn = "批量删除条码时发生错误！";
			return true;
			}
			else
			{
			//批量删除失败
			if (DBUtility.ClsPub.isStrNull(DS.Tables[0].Rows[0][0]) == "1")
			{
			oCn.CnClose();
			oCn.CnDispose();
			sReturn = DBUtility.ClsPub.isStrNull(DS.Tables[0].Rows[0]["HRemark"]);
			return true;
			}
			else
			//批量删除成功
			{
			oCn.CnClose();
			oCn.CnDispose();
			sReturn = DBUtility.ClsPub.isStrNull(DS.Tables[0].Rows[0]["HRemark"]);
			return false;
			}
			}
			}
			catch (Exception e)
			{
			oCn.RollBack();
			throw (e);
			}
			}





			//条码生成模块调用条码打印前，条码打印次数控制（是否超过允许可打印次数）
			public bool Set_CheckPrintQty_SD(Int64 HInterID, long PrintQty, ref string sReturn)
			{
			DataSet DS;
			string sBarCode = "";
			DS = oCn.RunProcReturn("select stuff((select ','+HBarCode from Gy_BarCodeBill with(nolock) where HPrintQty >=" + PrintQty + " and HBarCodeType = '唯一条码' and HInterID = " + HInterID + " for xml path('')),1,1,'')", "Gy_BarCodeBill");
			if (DS == null \|\| DS.Tables[0].Rows.Count == 0)
			{
			sReturn = "正常！";
			return false;
			}
			else
			{
			sBarCode = DBUtility.ClsPub.isStrNull(DS.Tables[0].Rows[0][0]);
			if (sBarCode == "")
			{
			sReturn = "正常！";
			return false;
			}
			else
			{
			sReturn = "条码编号：" + DBUtility.ClsPub.isStrNull(DS.Tables[0].Rows[0][0]) + "，已打印" + PrintQty + " 次，不允许再次预览打印！";
			return true;
			}
			}
			}

			//条码档案列表模块调用条码打印前，条码打印次数控制（是否超过允许可打印次数）
			public bool Set_CheckPrintQty(string sBarCodeItemID,long PrintQty, ref string sReturn)
			{
			DataSet DS;
			string sBarCode = "";
			DS = oCn.RunProcReturn("select stuff((select ','+HBarCode from Gy_BarCodeBill with(nolock) where HPrintQty >=" + PrintQty + " and HBarCodeType = '唯一条码' and HItemID in (" + sBarCodeItemID + ") for xml path('')),1,1,'')", "Gy_BarCodeBill");
			if (DS == null \|\| DS.Tables[0].Rows.Count == 0)
			{
			sReturn = "正常！";
			return false;
			}
			else
			{
			sBarCode = DBUtility.ClsPub.isStrNull(DS.Tables[0].Rows[0][0]);
			if (sBarCode == "")
			{
			sReturn = "正常！";
			return false;
			}
			else
			{
			sReturn = "条码编号：" + DBUtility.ClsPub.isStrNull(DS.Tables[0].Rows[0][0]) + "，已打印" + PrintQty + " 次，不允许再次预览打印！";
			return true;
			}
			}
			}

			//条码生成模块调用条码打印后，更新条码打印次数
			public bool Set_UpdatePrintQty_SD(Int64 HInterID)
			{
			try
			{
			oCn.BeginTran();
			//更新条码打印次数
			oCn.RunProc("update Gy_BarCodeBill set HPrintQty=isnull(HPrintQty,0)+1 where HInterID = " + HInterID, ref DBUtility.ClsPub.sExeReturnInfo);
			oCn.Commit();
			return true;
			}
			catch (Exception e)
			{
			oCn.RollBack();
			throw (e);
			}
			}

			//条码档案列表模块调用条码打印后，更新条码打印次数
			public bool Set_UpdatePrintQty(string sBarCodeItemID)
			{
			try
			{
			oCn.BeginTran();
			//更新条码打印次数
			oCn.RunProc("update Gy_BarCodeBill set HPrintQty=isnull(HPrintQty,0)+1 where HItemID in (" + sBarCodeItemID + ")", ref DBUtility.ClsPub.sExeReturnInfo);
			oCn.Commit();
			return true;
			}
			catch (Exception e)
			{
			oCn.RollBack();
			throw (e);
			}
			}










			//构造函数
			public ClsGy_BarCodeBill_Ctl()
			{