using System; using System.Collections.Generic; using System.Text; using System.Data; namespace BLL { public class ClsGy_BarCodeRuleBill_Ctl:DBUtility.ClsGy_Base_Ctl { SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); //原代码 用于 替换子项目 public string HOldNumber; public ClsGy_BarCodeRuleBill_Model oModel = new ClsGy_BarCodeRuleBill_Model(); //新增 public override bool AddNew() { try { oCn.BeginTran(); oCn.RunProc("Insert into " + MvarItemKey + " " + " (HNumber,HName,HBarCodeType,HBeginStr,HMaterType" + ",HMaterLen,HBatchTyp,HTotalLen,HLen,HIDNow) " + " Values('" + oModel.HNumber + "','" + oModel.HName + "','" + oModel.HBarCodeType + "','" + oModel.HBeginStr + "','" + oModel.HMaterType + "'" + "," + oModel.HMaterLen.ToString() + ",'" + oModel.HBatchTyp + "'," + oModel.HTotalLen.ToString() + "," + oModel.HLen.ToString() + "," + oModel.HIDNow.ToString() + ")", ref DBUtility.ClsPub.sExeReturnInfo); oCn.Commit(); return true; } catch (Exception e) { oCn.RollBack(); throw (e); } } //修改 public override bool ModifyByID(Int64 sItemID) { try { oCn.BeginTran(); oCn.RunProc("Update " + MvarItemKey + " set " + " HNumber='" + oModel.HNumber + "'" + ",HName='" + oModel.HName + "'" + ",HBarCodeType='" + oModel.HBarCodeType + "'" + ",HBeginStr='" + oModel.HBeginStr + "'" + ",HMaterType='" + oModel.HMaterType + "'" + ",HMaterLen=" + oModel.HMaterLen.ToString() + ",HBatchTyp='" + oModel.HBatchTyp + "'" + ",HTotalLen=" + oModel.HTotalLen.ToString() + ",HLen=" + oModel.HLen.ToString() + ",HIDNow= " + oModel.HIDNow.ToString() + " Where HItemID=" + 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 ClsGy_BarCodeRuleBill_Ctl() { MvarItemKey = "Gy_BarCodeRuleBill"; MvarReportTitle = "条码规则表设置"; oModel = new ClsGy_BarCodeRuleBill_Model(); } } }