📄 organization.cs
字号:
using System;
using System.Text;
using System.Data;
namespace BusinessRules
{
/// <summary>
/// Organization 的摘要说明。
/// </summary>
public class Organization:IDataBaseClass
{
public Organization()
{
//
// TODO: 在此处添加构造函数逻辑
//
}
string mOrganizationID; //组织机构ID
string mOrganizationTypeID; //机构类别ID
string mSuperiorID; //上级组织机构ID
string mOrganizationName; //组织机构名称
string mRemark; //注释
#region 属性定义
/// <summary>
/// OrganizationID 组织机构ID
/// </summary>
public string OrganizationID
{
get
{
return mOrganizationID;
}
set
{
mOrganizationID=value;
}
}
/// <summary>
/// OrganizationTypeID 机构类别ID
/// </summary>
public string OrganizationTypeID
{
get
{
return mOrganizationTypeID;
}
set
{
mOrganizationTypeID=value;
}
}
/// <summary>
/// SuperiorID 上级组织机构ID
/// </summary>
public string SuperiorID
{
get
{
return mSuperiorID;
}
set
{
mSuperiorID=value;
}
}
/// <summary>
/// OrganizationName 组织机构名称
/// </summary>
public string OrganizationName
{
get
{
return mOrganizationName;
}
set
{
mOrganizationName=value;
}
}
/// <summary>
/// Remark 注释
/// </summary>
public string Remark
{
get
{
return mRemark;
}
set
{
mRemark=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)
{
try
{
DB db=new DB();
DataSet ds=db.GetSqlDataSet(this.GetSqlString(condition));
return ds.Tables[0];
}
catch(Exception e)
{
throw(e);
}
}
#endregion
#region 根据主键查询 QueryWithKey(string keyValue)
/// <summary>
/// 根据主键查询
/// </summary>
public void QueryWithKey(string keyValue)
{
try
{
string cond="OrganizationID='"+ format(keyValue)+"'" ;
DB db=new DB();
DataSet ds=db.GetSqlDataSet(this.GetSqlString(cond));
mOrganizationID=ds.Tables[0].Rows[0]["OrganizationID"].ToString();
mOrganizationTypeID=ds.Tables[0].Rows[0]["OrganizationTypeID"].ToString();
mSuperiorID=ds.Tables[0].Rows[0]["SuperiorID"].ToString();
mOrganizationName=ds.Tables[0].Rows[0]["OrganizationName"].ToString();
mRemark=ds.Tables[0].Rows[0]["Remark"].ToString();
}
catch(Exception e)
{
throw(e);
}
}
#endregion
#region 添加一条记录 Insert()
/// <summary>
///添加一条记录
/// </summary>
public int Insert()
{
try
{
Organization myOrganization=new Organization();
string cond=" OrganizationID='"+format(mSuperiorID)+"'";
if(myOrganization.IsExist(cond))//只有满足mSuperiorID 在已有的OrganizationID
{ //才能被添加,这里做了判断
StringBuilder sql=new StringBuilder();
sql.Append("INSERT Organization");
sql.Append("(OrganizationID,OrganizationTypeID,SuperiorID,OrganizationName,Remark) ");
sql.Append(" VALUES(");
sql.Append("'"+ format(mOrganizationID) +"'");
sql.Append(",'"+ format(mOrganizationTypeID) +"'");
sql.Append(",'"+ format(mSuperiorID) +"'");
sql.Append(",'"+ format(mOrganizationName) +"'");
sql.Append(",'"+ format(mRemark) +"'");
sql.Append(")");
DB db=new DB();
return db.ExecuteSql(sql.ToString());
}
else
{
return -1;
}
}
catch(Exception e)
{
throw(e);
}
}
#endregion
#region 能否删除 string IsDelete(string keyValue)
/// <summary>
/// 能否删除,返回为null时，表示可以删除
/// 返回不为空，表示为不能删除的原因
/// </summary>
public string IsDelete(string keyValue)
{
try
{
string temp=null;
string cond=" OrganizationID='" + keyValue+"'";
StudentInfo myStudent=new StudentInfo();
if(myStudent.IsExist(cond))
{
temp="在学生基本信息表中存在OrganizationID=" + keyValue +"的值";
}
//return temp;
//判断在组织机构表OrganizationID是(其它的)上级组织机构ID(SuperiorID)
Organization myOrganization=new Organization();
string cond2=" SuperiorID='"+keyValue+"'";
if(myOrganization.IsExist(cond2))
{
temp += "在组织机构表中存在OrganizationID=" + keyValue +"是(其它的)上级组织机构ID";
}
return temp;
}
catch(Exception e)
{
throw(e);
}
}
#endregion
#region 删除一条记录 bool Delete(string keyValue)
/// <summary>
/// 要求在调用IsDelete（）后使用
/// 返回为true时，表示删除成功
/// 返回为false时，表示删除失败
/// </summary>
public bool Delete(string keyValue)
{
try
{
StringBuilder sql=new StringBuilder();
sql.Append(" DELETE FROM Organization ");
sql.Append(" WHERE OrganizationID='" + keyValue+"'");
DB db=new DB();
db.ExecuteSql(sql.ToString());
return true;
}
catch(Exception e)
{
throw(e);
}
}
#endregion
#region 有条件删除 int DeleteWithCondition(string condition)
/// <summary>
/// 返回值为删除的记录数
/// 能否删除，完全依靠程序员的判断，
/// 一般用于和其他表没有约束关系的表
/// 说明：出现删除异常时并不表示一个都没有删除
/// </summary>
public int DeleteWithCondition(string condition)
{
try
{
StringBuilder sql=new StringBuilder();
sql.Append("DELETE FROM Organization ");
sql.Append(" WHERE " + condition);
DB db=new DB();
return db.ExecuteSql(sql.ToString());
}
catch(Exception e)
{
throw(e);
}
}
#endregion
#region 更新 Update(string condition)
/// <summary>
/// 根据条件 更新 //当SuperiorID==null时,修改语句中不应该有SuperiorID='"+ format(mSuperiorID) + "'"
/// </summary> //其实条件可以不用做判断，因为根据参数改这种复杂的表情况极少.
public int Update(string condition)
{
try
{
Organization myOrganization=new Organization();
string cond=" SuperiorID is null";
StringBuilder sql=new StringBuilder();
sql.Append("UPDATE Organization SET ");
sql.Append("OrganizationTypeID='"+ format(mOrganizationTypeID) + "'" );
if(myOrganization.IsExist(cond)==false)//判断SuperiorID是否null
{
sql.Append(",SuperiorID='"+ format(mSuperiorID) + "'" );
}
sql.Append(",OrganizationName='"+ format(mOrganizationName) + "'" );
sql.Append(",Remark='"+ format(mRemark) + "'" );
sql.Append(" WHERE " + condition);
DB db=new DB();
return db.ExecuteSql(sql.ToString());
}
catch(Exception e)
{
throw(e);
}
}
#endregion
#region 通过主键更新 UpdateWithKey(string keyValue)
/// <summary>
/// 通过主键更新 //当SuperiorID==null时,修改语句中不应该有SuperiorID='"+ format(mSuperiorID) + "'"
/// </summary>
public int UpdateWithKey(string keyValue)
{
try
{
Organization myOrganization=new Organization();
string cond=" SuperiorID is null";
StringBuilder sql=new StringBuilder();
sql.Append("UPDATE Organization SET ");
sql.Append("OrganizationTypeID='"+ format(mOrganizationTypeID) + "'" );
if(myOrganization.IsExist(cond)==false)//判断SuperiorID是否null 存在SuperiorID不为空时才能修改SuperiorID
{
sql.Append(",SuperiorID='"+ format(mSuperiorID) + "'" );
}
sql.Append(",OrganizationName='"+ format(mOrganizationName) + "'" );
sql.Append(",Remark='"+ format(mRemark) + "'" );
sql.Append(" WHERE OrganizationID='" + keyValue+"'");
DB db=new DB();
return db.ExecuteSql(sql.ToString());
}
catch(Exception e)
{
throw(e);
}
}
#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)
{
try
{
StringBuilder sql=new StringBuilder();
sql.Append(" SELECT OrganizationID FROM Organization ");
sql.Append(" WHERE " + condition);
DB db=new DB();
DataSet ds;
ds=db.GetSqlDataSet(sql.ToString());
if(ds.Tables[0]!=null && ds.Tables[0].Rows.Count>0)
{
return true;
}
else
{
return false;
}
}
catch(Exception e)
{
throw(e);
}
}
#endregion
#region 获取查询Sql GetSqlString(string condition)
/// <summary>
/// 获取查询Sql
/// </summary>
public string GetSqlString(string condition)
{
try
{
StringBuilder sql=new StringBuilder();
sql.Append("SELECT ");
sql.Append(" OrganizationID,OrganizationTypeID,SuperiorID,OrganizationName,Remark ");
sql.Append(" FROM Organization");
if(condition!="" && condition!=null)
{
sql.Append(" WHERE " + condition);
}
return sql.ToString();
}
catch(Exception e)
{
throw(e);
}
}
#endregion
#endregion
#region 自定义方法
#region 通过主键更新最高层 UpdateForSuper(string keyValue)
/// <summary>
/// 通过主键更新最高层 //当SuperiorID==null时,调用该方法,修改除SuperiorID以外的字段
/// </summary> //调用该方法 可以先判断SuperiorID=是否为空null
public int UpdateForSuper(string keyValue)
{
try
{
Organization myOrganization=new Organization();
string cond=" SuperiorID is null";
StringBuilder sql=new StringBuilder();
if(myOrganization.IsExist(cond)==true)
{
sql.Append("UPDATE Organization SET ");
sql.Append("OrganizationTypeID='"+ format(mOrganizationTypeID) + "'" );
sql.Append(",OrganizationName='"+ format(mOrganizationName) + "'" );
sql.Append(",Remark='"+ format(mRemark) + "'" );
sql.Append(" WHERE OrganizationID='" + keyValue+"'");
}
DB db=new DB();
return db.ExecuteSql(sql.ToString());
}
catch(Exception e)
{
throw(e);
}
}
#endregion
#endregion
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -