using System;
|
using System.Collections.Generic;
|
using System.Text;
|
using System.Data;
|
|
namespace DAL
|
{
|
/// <summary>
|
/// 说明：包装方式的数据库操作模块
|
/// 创建人：王健均 创建时间：2017-12-18 12:29:11
|
/// 修改人： 修改时间：
|
/// </summary>
|
public class ClsGy_PackType_Ctl:DBUtility.ClsGy_Base_Ctl
|
{
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
//原代码 用于 替换子项目
|
public string HItemID;
|
public string HOldNumber;
|
public Model.ClsGy_PackType_Model oModel = new Model.ClsGy_PackType_Model();
|
//新增
|
public override bool AddNew()
|
{
|
|
try
|
{
|
string ssql = "Insert into " + MvarItemKey + " " +
|
"(HNumber,HName,HShortNumber,HParentID,HLevel," +
|
" HEndFlag,HStopflag,HRemark, HHelpCode,HUseFlag,HMakeTime," +
|
" HMakeEmp,HPackMaterial,HLenhth,HWidth,HHeight) " +
|
" Values('" + oModel.HNumber + "','" + oModel.HName + "','" + oModel.HShortNumber + "','"
|
+ oModel.HParentID + "','" + oModel.HLevel + "','" + Convert.ToString(oModel.HEndFlag ? 1 : 0) + "','" + Convert.ToString(oModel.HStopflag ? 1 : 0) + "','"
|
+ oModel.HRemark + "','" + oModel.HHelpCode + "','" + oModel.HUseFlag + "','" + oModel.HMakeTime + "','"
|
+ oModel.HMakeEmp + "','" + oModel.HPackMaterial + "','" + oModel.HLenhth + "','" + +oModel.HWidth + "','" +
|
+oModel.HHeight
|
+ "')";
|
oCn.BeginTran();
|
oCn.RunProc(ssql, ref DBUtility.ClsPub.sExeReturnInfo);
|
//修改上级为非末级代码
|
oCn.RunProc("Update " + MvarItemKey + " set HEndflag=0 where HItemID=" + oModel.HItemID, ref DBUtility.ClsPub.sExeReturnInfo);
|
oCn.Commit();
|
return true;
|
}
|
catch (Exception e)
|
{
|
oCn.RollBack();
|
throw (e);
|
}
|
}
|
|
//修改
|
public override bool ModifyByID(Int64 sItemID)
|
{
|
try
|
{
|
string ssql = "Update " + MvarItemKey + " set " +
|
"HNumber='" + oModel.HNumber + "'" +
|
|
",HName='" + oModel.HName + "'" +
|
",HShortNumber='" + oModel.HShortNumber + "'" +
|
",HParentID= '" + oModel.HParentID + "'" +
|
",HLevel='" + oModel.HLevel.ToString() + "'" +
|
",HEndFlag='" + oModel.HEndFlag + "'" +
|
",HStopflag='" + oModel.HStopflag + "'" +
|
",HRemark='" + oModel.HRemark.ToString() + "'" +
|
",HHelpCode='" + oModel.HHelpCode + "'" +
|
|
",HUseFlag='" + oModel.HUseFlag + "'" +
|
",HMakeTime='" + oModel.HMakeTime + "'" +
|
",HMakeEmp='" + oModel.HMakeEmp + "'" +
|
",HPackMaterial='" + oModel.HPackMaterial.ToString() + "'"+
|
",HLenhth='" + oModel.HLenhth +"'"+
|
|
",HWidth='" + oModel.HWidth +"'"+
|
",HHeight='" + oModel.HHeight + "' Where HItemID = ";
|
oCn.BeginTran();
|
oCn.RunProc(ssql+ sItemID, ref DBUtility.ClsPub.sExeReturnInfo);
|
//修改子项目代码
|
|
oCn.RunProc("exec h_p_Gy_UpdateNumber '" + MvarItemKey + "','" +
|
|
oModel.HNumber + ".','" + this.HItemID + ".'", ref DBUtility.ClsPub.sExeReturnInfo);
|
//将上级 为非末级
|
oCn.RunProc("Update " + MvarItemKey + " set HEndflag=0 where HItemID=" +oModel.HItemID, 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_PackType_Ctl()
|
{
|
MvarItemKey = "Gy_PackType";
|
MvarReportTitle = "包装方式";
|
oModel = new Model.ClsGy_PackType_Model();
|
}
|
}
|
}
|
