📄 moduleinfo.cs
字号:
using System;
using System.Text;
using System.Data;
namespace BusinessRules
{
/// <summary>
/// ModuleInfo 的摘要说明。
/// </summary>
public class ModuleInfo:IDataBaseClass
{
public ModuleInfo()
{
//
// TODO: 在此处添加构造函数逻辑
//
}
string mModuleInfoID; //模块ID
string mModuleInfoName; //模块名称
string mPagePath; //页面路径
string mOrderNumber; //顺序号
string mRemark; //备注
string mSpareDec1; //备用数字1
string mSpareDec2; //备用数字2
string mSpareNvar1; //备用字符1
string mSpareNvar2; //备用字符2
string mSpareNvar3; //备用字符3
#region 属性定义
/// <summary>
/// ModuleInfoID 模块ID
/// </summary>
public string ModuleInfoID
{
get
{
return mModuleInfoID;
}
set
{
mModuleInfoID=value;
}
}
/// <summary>
/// ModuleInfoName 模块名称
/// </summary>
public string ModuleInfoName
{
get
{
return mModuleInfoName;
}
set
{
mModuleInfoName=value;
}
}
/// <summary>
/// PagePath 页面路径
/// </summary>
public string PagePath
{
get
{
return mPagePath;
}
set
{
mPagePath=value;
}
}
/// <summary>
/// OrderNumber 顺序号
/// </summary>
public string OrderNumber
{
get
{
return mOrderNumber;
}
set
{
mOrderNumber=value;
}
}
/// <summary>
/// Remark 备注
/// </summary>
public string Remark
{
get
{
return mRemark;
}
set
{
mRemark=value;
}
}
/// <summary>
/// SpareDec1 备用数字1
/// </summary>
public string SpareDec1
{
get
{
return mSpareDec1;
}
set
{
mSpareDec1=value;
}
}
/// <summary>
/// SpareDec2 备用数字2
/// </summary>
public string SpareDec2
{
get
{
return mSpareDec2;
}
set
{
mSpareDec2=value;
}
}
/// <summary>
/// SpareNvar1 备用字符1
/// </summary>
public string SpareNvar1
{
get
{
return mSpareNvar1;
}
set
{
mSpareNvar1=value;
}
}
/// <summary>
/// SpareNvar2 备用字符2
/// </summary>
public string SpareNvar2
{
get
{
return mSpareNvar2;
}
set
{
mSpareNvar2=value;
}
}
/// <summary>
/// SpareNvar3 备用字符3
/// </summary>
public string SpareNvar3
{
get
{
return mSpareNvar3;
}
set
{
mSpareNvar3=value;
}
}
#endregion
#region 接口要求的方法
#region 无条件查询 Query()
/// <summary>
/// 无条件查询
/// </summary>
public DataTable Query()
{
DataSet ds=null;
try
{
DB db=new DB();
ds=db.GetSqlDataSet(this.GetSqlString(""));
}
catch(Exception e)
{
throw(e);
}
return ds.Tables[0];
}
#endregion
#region 有条件查询 Query(string condition)
/// <summary>
/// 有条件查询
/// </summary>
public DataTable Query(string condition)
{
DataSet ds=null;
try
{
DB db=new DB();
ds=db.GetSqlDataSet(this.GetSqlString(condition));
}
catch(Exception e)
{
throw e;
}
return ds.Tables[0];
}
#endregion
#region 根据主键查询 QueryWithKey(string keyValue)
/// <summary>
/// 根据主键查询
/// </summary>
public void QueryWithKey(string keyValue)
{
DataSet ds=null;
try
{
string cond="ModuleInfoID='"+ format(keyValue)+"'" ;
DB db=new DB();
ds=db.GetSqlDataSet(this.GetSqlString(cond));
mModuleInfoID=ds.Tables[0].Rows[0]["ModuleInfoID"].ToString();
mModuleInfoName=ds.Tables[0].Rows[0]["ModuleInfoName"].ToString();
mPagePath=ds.Tables[0].Rows[0]["PagePath"].ToString();
mOrderNumber=ds.Tables[0].Rows[0]["OrderNumber"].ToString();
mRemark=ds.Tables[0].Rows[0]["Remark"].ToString();
mSpareDec1=ds.Tables[0].Rows[0]["SpareDec1"].ToString();
mSpareDec2=ds.Tables[0].Rows[0]["SpareDec2"].ToString();
mSpareNvar1=ds.Tables[0].Rows[0]["SpareNvar1"].ToString();
mSpareNvar2=ds.Tables[0].Rows[0]["SpareNvar2"].ToString();
mSpareNvar3=ds.Tables[0].Rows[0]["SpareNvar3"].ToString();
}
catch(Exception e)
{
throw(e);
}
}
#endregion
#region 添加一条记录 Insert()
/// <summary>
///添加一条记录
/// </summary>
public int Insert()
{
StringBuilder sql=new StringBuilder();
DB db=new DB();
try
{
sql.Append("INSERT ModuleInfo");
sql.Append("(ModuleInfoID,ModuleInfoName,PagePath,OrderNumber,Remark,SpareDec1,SpareDec2,SpareNvar1,SpareNvar2,SpareNvar3) ");
sql.Append(" VALUES(");
sql.Append("'"+ format(mModuleInfoID) +"'");
sql.Append(",'"+ format(mModuleInfoName) +"'");
sql.Append(",'"+ format(mPagePath) +"'");
sql.Append(",'"+ format(mOrderNumber) +"'");
sql.Append(",'"+ format(mRemark) +"'");
sql.Append(",'"+ format(mSpareDec1) +"'");
sql.Append(",'"+ format(mSpareDec2) +"'");
sql.Append(",'"+ format(mSpareNvar1) +"'");
sql.Append(",'"+ format(mSpareNvar2) +"'");
sql.Append(",'"+ format(mSpareNvar3) +"'");
sql.Append(")");
}
catch(Exception e)
{
throw(e);
}
return db.ExecuteSql(sql.ToString());
}
#endregion
#region 能否删除 string IsDelete(string keyValue)
/// <summary>
/// 能否删除,返回为null时，表示可以删除
/// 返回不为空，表示为不能删除的原因
/// </summary>
public string IsDelete(string keyValue)
{
string temp=null;
RoleModule myRoleModule=new RoleModule();
try
{
string cond=" ModuleInfoID='" + keyValue+"'";
if(myRoleModule.IsExist(cond))//判断在RoleModule表中是否存在" ModuleInfoID='" + keyValue+"'"
{
temp="在角色模块表中存在ModuleInfoID=" + keyValue +"的值";
}
}
catch(Exception e)
{
throw(e);
}
return temp;
}
#endregion
#region 删除一条记录 boll Delete(string keyValue)
/// <summary>
/// 要求在调用IsDelete（）后使用
/// 返回为true时，表示删除成功
/// 返回为false时，表示删除失败
/// </summary>
public bool Delete(string keyValue)
{
StringBuilder sql=new StringBuilder();
DB db=new DB();
try
{
sql.Append(" DELETE FROM ModuleInfo ");
sql.Append(" WHERE ModuleInfoID='" + keyValue+"'");
db.ExecuteSql(sql.ToString());
}
catch(Exception e)
{
throw(e);
}
return true;
}
#endregion
#region 有条件删除 int DeleteWithCondition(string condition)
/// <summary>
/// 要求在调用IsDelete（）后使用
/// 返回为true时，表示删除成功
/// 返回为false时，表示删除失败
/// 返回值为删除的记录数
/// 能否删除，完全依靠程序员的判断，
/// 一般用于和其他表没有约束关系的表
/// 说明：出现删除异常时并不表示一个都没有删除
/// </summary>
public int DeleteWithCondition(string condition)
{
StringBuilder sql=new StringBuilder();
DB db=new DB();
try
{
sql.Append(" DELETE FROM ModuleInfo ");
sql.Append(" WHERE " + condition);
}
catch(Exception e)
{
throw(e);
}
return db.ExecuteSql(sql.ToString());
}
#endregion
#region 更新 Update(string condition)
/// <summary>
/// 根据条件更新
/// 返回值为int 为影响多少行
/// </summary>
public int Update(string condition)
{
StringBuilder sql=new StringBuilder();
DB db=new DB();
try
{
sql.Append("UPDATE ModuleInfo SET ");
sql.Append("ModuleInfoName='"+ format(mModuleInfoName) + "'" );
sql.Append(",PagePath='"+ format(mPagePath) + "'" );
sql.Append(",OrderNumber='"+ format(mOrderNumber) + "'" );
sql.Append(",Remark='"+ format(mRemark) + "'" );
sql.Append(",SpareDec1='"+ format(mSpareDec1) + "'" );
sql.Append(",SpareDec2='"+ format(mSpareDec2) + "'" );
sql.Append(",SpareNvar1='"+ format(mSpareNvar1) + "'" );
sql.Append(",SpareNvar2='"+ format(mSpareNvar2) + "'" );
sql.Append(",SpareNvar3='"+ format(mSpareNvar3) + "'" );
sql.Append(" WHERE " + condition);
}
catch(Exception e)
{
throw(e);
}
return db.ExecuteSql(sql.ToString());
}
#endregion
#region 通过主键更新 UpdateWithKey(string keyValue)
/// <summary>
/// 通过主键更新
/// </summary>
public int UpdateWithKey(string keyValue)
{
StringBuilder sql=new StringBuilder();
DB db=new DB();
try
{
sql.Append("UPDATE ModuleInfo SET ");
sql.Append("ModuleInfoName='"+ format(mModuleInfoName) + "'" );
sql.Append(",PagePath='"+ format(mPagePath) + "'" );
sql.Append(",OrderNumber='"+ format(mOrderNumber) + "'" );
sql.Append(",Remark='"+ format(mRemark) + "'" );
sql.Append(",SpareDec1='"+ format(mSpareDec1) + "'" );
sql.Append(",SpareDec2='"+ format(mSpareDec2) + "'" );
sql.Append(",SpareNvar1='"+ format(mSpareNvar1) + "'" );
sql.Append(",SpareNvar2='"+ format(mSpareNvar2) + "'" );
sql.Append(",SpareNvar3='"+ format(mSpareNvar3) + "'" );
sql.Append(" WHERE ModuleInfoID='" + keyValue+"'");
}
catch(Exception e)
{
throw(e);
}
return db.ExecuteSql(sql.ToString());
}
#endregion
#region 单引号的处理 format(string myString)
/// <summary>
/// 单引号的处理
/// </summary>
public string format(string myString)
{
return myString.Replace("'","''");
}
#endregion
#region 是否存在 IsExist(string myString)
/// <summary>
/// 是否存在
///返回值为true表示存在
///返回值为false表示不存在
/// </summary>
public bool IsExist(string condition)
{
StringBuilder sql=new StringBuilder();
DB db=new DB();
DataSet ds;
try
{
sql.Append(" SELECT ModuleInfoID FROM ModuleInfo ");
sql.Append(" WHERE " + condition);
ds=db.GetSqlDataSet(sql.ToString());
}
catch(Exception e)
{
throw(e);
}
if(ds.Tables[0]!=null && ds.Tables[0].Rows.Count>0)
{
return true;
}
else
{
return false;
}
}
#endregion
#region 获取查询Sql GetSqlString(string condition)
/// <summary>
/// 获取查询Sql
/// </summary>
public string GetSqlString(string condition)
{
StringBuilder sql=new StringBuilder();
try
{
sql.Append("SELECT ");
sql.Append(" ModuleInfoID,ModuleInfoName,PagePath,OrderNumber,Remark,SpareDec1,SpareDec2,SpareNvar1,SpareNvar2,SpareNvar3 ");
sql.Append(" FROM ModuleInfo");
if(condition!="" && condition!=null)
{
sql.Append(" WHERE " + condition);
}
}
catch(Exception e)
{
throw(e);
}
return sql.ToString();
}
#endregion
#endregion
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -