using System;
|
using System.Collections.Generic;
|
using System.Text;
|
using System.Data;
|
using SQLHelper;
|
|
namespace BLL
|
{
|
class ClsGy_OpenTmp_Ctl
|
{
|
private string _mvarItemKey;
|
|
public string MvarItemKey
|
{
|
get { return _mvarItemKey; }
|
set { _mvarItemKey = value; }
|
}
|
private string _mvarReportTitle;
|
|
public string MvarReportTitle
|
{
|
get { return _mvarReportTitle; }
|
set { _mvarReportTitle = value; }
|
}
|
ClsCN oCN = new ClsCN();
|
public ClsGy_OpenTmp_Model oModel = new ClsGy_OpenTmp_Model();
|
//原代码 用于 替换子项目
|
public string HOldNumber;
|
//新增
|
public bool AddNew()
|
{
|
try
|
{
|
oCN.BeginTran();
|
oCN.RunProc("Insert into Gy_OpenTmp " +
|
" (HNumber,HModel,HName) " +
|
" Values('" + oModel.HNumber + "','" + oModel.HModel + "','" + oModel.HName + "')", ref DBUtility.ClsPub.sExeReturnInfo);
|
//修改上级为非末级代码
|
//oCN.RunProc("Update Gy_OpenTmp set HEndflag=0 where HItemID=" + oModel.HParentID, ref ClsPub.sExeReturnInfo);
|
oCN.Commit();
|
return true;
|
}
|
catch (Exception e)
|
{
|
oCN.RollBack();
|
return false;
|
}
|
}
|
|
//修改
|
public bool ModifyByID(long sItemID)
|
{
|
try
|
{
|
oCN.BeginTran();
|
oCN.RunProc("Update Gy_OpenTmp set " +
|
" HNumber='" + oModel.HNumber +
|
"',HName='" + oModel.HName + "'", ref DBUtility.ClsPub.sExeReturnInfo);
|
|
oCN.Commit();
|
return true;
|
}
|
catch (Exception e)
|
{
|
oCN.RollBack();
|
return false;
|
}
|
}
|
|
#region 固定代码
|
//是否存在子项目
|
public bool HavChildCodes(long sItemID)
|
{
|
DataSet DS;
|
try
|
{
|
DS = oCN.RunProcReturn("Select HItemID from Gy_OpenTmp Where HParentID='" + sItemID + "'", "Gy_OpenTmp", ref DBUtility.ClsPub.sExeReturnInfo);
|
if (DS.Tables[0].Rows.Count == 0)
|
return false;
|
else
|
{
|
return true;
|
}
|
}
|
catch (Exception e)
|
{
|
return false;
|
}
|
}
|
//根据代码判断信息
|
public bool HavParentCode(string sCode, long sItemID)
|
{
|
DataSet DS;
|
try
|
{
|
DS = oCN.RunProcReturn("Select * from Gy_OpenTmp Where HStopflag=0 and HNumber='" + sCode + "' and HItemID<>'" + sItemID + "'", "Gy_OpenTmp", ref DBUtility.ClsPub.sExeReturnInfo);
|
if (DS.Tables[0].Rows.Count == 0)
|
return false;
|
else
|
{
|
oModel.HItemID = Convert.ToInt64(DS.Tables[0].Rows[0]["HItemID"]);
|
oModel.HNumber = DS.Tables[0].Rows[0]["HNumber"].ToString().Trim();
|
oModel.HName = DS.Tables[0].Rows[0]["HName"].ToString().Trim();
|
return true;
|
}
|
}
|
catch (Exception e)
|
{
|
return false;
|
}
|
}
|
//重复代码
|
public bool HavSameNumber(long sItemID,string sNumber)
|
{
|
DataSet DS;
|
try
|
{
|
DS = oCN.RunProcReturn("Select HItemID from Gy_OpenTmp Where HItemID<>'" + sItemID + "' and HNumber='" + sNumber + "'", "Gy_OpenTmp", ref DBUtility.ClsPub.sExeReturnInfo);
|
if (DS.Tables[0].Rows.Count == 0)
|
return false;
|
else
|
{
|
return true;
|
}
|
}
|
catch (Exception e)
|
{
|
return false;
|
}
|
}
|
//删除
|
public bool DeleteByID(long sItemID)
|
{
|
try
|
{
|
oCN.RunProc("Delete from Gy_OpenTmp where HItemID='" + sItemID + "'", ref DBUtility.ClsPub.sExeReturnInfo);
|
return true;
|
}
|
catch (Exception e)
|
{
|
return false;
|
}
|
}
|
//构造函数
|
public ClsGy_OpenTmp_Ctl()
|
{
|
MvarItemKey="Gy_OpenTmp";
|
MvarReportTitle = "打印模板设置";
|
}
|
#endregion
|
}
|
}
|
