MES-WEB-API.git

New file
			@@ -0,0 +1,104 @@
			using System;
			using System.Collections.Generic;
			using System.Text;
			using System.Data;

			namespace WebAPI.DLL
			{
			public class ClsSc_PackUnionBillBarCode_temp_Ctl : DBUtility.ClsGy_Base_Ctl
			{
			SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
			//原代码用于替换子项目
			public string HOldNumber;
			public Model.ClsSc_PackUnionBillBarCode_temp_Model oModel = new Model.ClsSc_PackUnionBillBarCode_temp_Model();
			//新增
			public bool AddNew(ref string sReturn)
			{
			//
			try
			{
			oCn.BeginTran();

			oCn.RunProc("Insert into " + MvarItemKey + " " +
			" (HMaterNumber,HMaterName,HSupBarCodeNumber,HLDM,HSupNumber" +
			",HCustomerMaterNumber,HCountryType,HGrossWeight,HPARTNAME,HSupPartName,HUSEORGID,HMakeEmp,HMakeTime) " +
			" Values('" + oModel.HMaterNumber + "','" + oModel.HMaterName + "','" + oModel.HSupBarCodeNumber + "','" + oModel.HLDM + "','" + oModel.HSupNumber.ToString() +
			"','','" + oModel.HCountryType + "','" + oModel.HGrossWeight + "','" + oModel.HPARTNAME + "','" + oModel.HSupPartName + "','" + oModel.HUSEORGID + "','" + oModel.HMakeEmp + "',getdate())", ref DBUtility.ClsPub.sExeReturnInfo);

			oCn.Commit();
			return true;
			}
			catch (Exception e)
			{
			oCn.RollBack();
			throw (e);
			}
			}

			//修改
			public bool ModifyByID(Int64 sItemID, ref string sReturn)
			{
			try
			{

			oCn.BeginTran();



			oCn.RunProc("Update " + MvarItemKey + " set " +
			" HMaterNumber='" + oModel.HMaterNumber + "'" +
			",HMaterName='" + oModel.HMaterName + "'" +
			",HSupBarCodeNumber='" + oModel.HSupBarCodeNumber + "'" +
			",HLDM='" + oModel.HLDM + "'" +
			",HSupNumber='" + oModel.HSupNumber + "'" +
			",HCountryType='" + oModel.HCountryType + "'" +
			",HGrossWeight ='" + oModel.HGrossWeight + "'" +
			",HModifyTime=getdate()" +
			",HPARTNAME ='" + oModel.HPARTNAME + "'" +
			",HModifyEmp ='" + oModel.HMakeEmp + "'" +
			",HSupPartName='" + oModel.HSupPartName + "'" +
			",HUSEORGID= '" + oModel.HUSEORGID + "' Where HInterID=" + sItemID, ref DBUtility.ClsPub.sExeReturnInfo);



			oCn.Commit();
			return true;
			}
			catch (Exception e)
			{
			oCn.RollBack();
			throw (e);
			}
			}
			//根据代码判断信息
			public override bool HavParentCode(string sCode, Int64 sItemID)
			{
			DataSet DS;
			try
			{
			DS = oCn.RunProcReturn("Select * from " + MvarItemKey + " Where HStopflag=0 and HNumber='" + sCode + "' and HItemID<>" + sItemID, MvarItemKey, ref Pub_Class.ClsPub.sExeReturnInfo);
			if (DS.Tables[0].Rows.Count == 0)
			return false;
			else
			{
			oModel.HItemID = Convert.ToInt64(DS.Tables[0].Rows[0]["HItemID"]);
			return true;
			}
			}
			catch (Exception e)
			{
			throw (e);
			}
			}
			//构造函数
			public ClsSc_PackUnionBillBarCode_temp_Ctl()
			{
			MvarItemKey = "Sc_PackUnionBillBarCode_temp";
			MvarReportTitle = "白标基础信息表";
			oModel = new Model.ClsSc_PackUnionBillBarCode_temp_Model();
			}



			}
			}