using System;
|
using System.Collections.Generic;
|
using System.Text;
|
using System.Data;
|
using SQLHelper;
|
|
namespace BLL
|
{
|
class ClsXt_Xtgnb
|
{
|
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 long id;
|
public string gnbm;
|
public string gnsy;
|
public string gnmc;
|
public string gnms;
|
public string sjgnbm;
|
public bool mjbz;
|
public bool MenuList;
|
public bool RightFlag;
|
public bool useflag;
|
public bool NetMenuList;
|
//原代码 用于 替换子项目
|
public string HOldNumber;
|
//新增
|
public bool AddNew()
|
{
|
try
|
{
|
oCN.BeginTran();
|
oCN.RunProc("Insert into Xt_Xtgnb " +
|
" (gnbm,gnsy,gnmc" +
|
",gnms,sjgnbm,mjbz" +
|
",MenuList,RightFlag,useflag,NetMenuList) " +
|
" Values('" + this.gnbm + "','" + this.gnsy + "','" + this.gnmc +
|
"','" + this.gnms + "','" + this.sjgnbm + "'," + Convert.ToString(this.mjbz ? 1 : 0) +
|
"," + Convert.ToString(this.MenuList ? 1 : 0) + "," + Convert.ToString(this.RightFlag ? 1 : 0) + "," + Convert.ToString(this.useflag ? 1 : 0) + "," + Convert.ToString(this.NetMenuList ? 1 : 0) + ")");
|
//修改上级为非末级代码
|
//oCN.RunProc("Update Xt_Xtgnb set HEndflag=0 where HItemID=" + this.HParentID);
|
oCN.Commit();
|
return true;
|
}
|
catch (Exception e)
|
{
|
oCN.RollBack();
|
return false;
|
}
|
}
|
|
//修改
|
public bool ModifyByID(long sItemID)
|
{
|
try
|
{
|
oCN.BeginTran();
|
oCN.RunProc("Update Xt_Xtgnb set " +
|
" gnbm='" + this.gnbm + "'" +
|
",gnsy='" + this.gnsy + "'" +
|
",gnmc='" + this.gnmc + "'" +
|
",gnms='" + this.gnms + "'" +
|
",sjgnbm='" + this.sjgnbm + "'" +
|
",mjbz=" + Convert.ToString(this.mjbz ? 1 : 0) +
|
",MenuList=" + Convert.ToString(this.MenuList ? 1 : 0) +
|
",RightFlag=" + Convert.ToString(this.RightFlag ? 1 : 0) +
|
",useflag=" + Convert.ToString(this.useflag ? 1 : 0) +
|
",NetMenuList= " + Convert.ToString(this.NetMenuList ? 1 : 0) + " Where id=" + sItemID);
|
|
oCN.Commit();
|
return true;
|
}
|
catch (Exception e)
|
{
|
oCN.RollBack();
|
return false;
|
}
|
}
|
|
#region 固定代码
|
//是否存在子项目
|
public bool HavChildCodes(long sItemID)
|
{
|
DataSet DS ;
|
try
|
{
|
DS = oCN.RunProcReturn("Select id from Xt_Xtgnb Where sjgnbm='" + sItemID + "'", "Xt_Xtgnb");
|
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 Xt_Xtgnb Where gnbm='" + sCode + "' and id<>'" + sItemID + "'", "Xt_Xtgnb");
|
if (DS.Tables[0].Rows.Count == 0)
|
return false;
|
else
|
{
|
id = Convert.ToInt64(DS.Tables[0].Rows[0]["id"]);
|
gnbm = DS.Tables[0].Rows[0]["gnbm"].ToString().Trim();
|
gnsy = DS.Tables[0].Rows[0]["gnsy"].ToString().Trim();
|
gnmc = DS.Tables[0].Rows[0]["gnmc"].ToString().Trim();
|
gnms = DS.Tables[0].Rows[0]["gnms"].ToString().Trim();
|
sjgnbm = DS.Tables[0].Rows[0]["sjgnbm"].ToString().Trim();
|
mjbz = (bool)DS.Tables[0].Rows[0]["mjbz"];
|
MenuList = (bool)DS.Tables[0].Rows[0]["MenuList"];
|
RightFlag = (bool)DS.Tables[0].Rows[0]["RightFlag"];
|
useflag = (bool)DS.Tables[0].Rows[0]["useflag"];
|
NetMenuList = (bool)DS.Tables[0].Rows[0]["NetMenuList"];
|
return true;
|
}
|
}
|
catch (Exception e)
|
{
|
return false;
|
}
|
}
|
//重复代码
|
public bool HavSameNumber(long sItemID, string sNumber)
|
{
|
DataSet DS ;
|
try
|
{
|
DS = oCN.RunProcReturn("Select id from Xt_Xtgnb Where id<>'" + sItemID + "' and gnbm='" + sNumber + "'", "Xt_Xtgnb");
|
if (DS.Tables[0].Rows.Count == 0)
|
return false;
|
else
|
{
|
return true;
|
}
|
}
|
catch (Exception e)
|
{
|
return false;
|
}
|
}
|
//删除
|
public bool DeleteByID(long sItemID,ref string s)
|
{
|
try
|
{
|
oCN.RunProc("Delete from Xt_Xtgnb where id='" + sItemID + "'");
|
return true;
|
}
|
catch (Exception e)
|
{
|
s = e.Message;
|
return false;
|
}
|
}
|
//构造函数
|
public ClsXt_Xtgnb()
|
{
|
MvarItemKey = "Xt_Xtgnb";
|
MvarReportTitle = "系统功能表设置";
|
}
|
#endregion
|
}
|
}
|
