public Dictionary <int, SYS_PrivilegeMod> GetAdminPrivilege(int AdminSysNo)
{
DataTable table = new DataTable();
Dictionary <int, SYS_PrivilegeMod> dictionary = new Dictionary <int, SYS_PrivilegeMod>();
using (SQLData data = new SQLData())
{
StringBuilder builder = new StringBuilder();
builder.Append("select SysNo,[Name],url from SYS_Privilege where SysNo in (select Privilege_SysNo from REL_Admin_Privilege where Admin_SysNo=").Append(AdminSysNo).Append(") and DR=").Append((int)AppEnum.State.normal);
try
{
table = data.CmdtoDataTable(builder.ToString());
}
catch (Exception exception)
{
throw exception;
}
}
if (table.Rows.Count > 0)
{
for (int i = 0; i < table.Rows.Count; i++)
{
SYS_PrivilegeMod mod = new SYS_PrivilegeMod();
mod.Name = table.Rows[i]["Name"].ToString();
mod.SysNo = int.Parse(table.Rows[i]["SysNo"].ToString());
mod.URL = table.Rows[i]["url"].ToString();
dictionary.Add(int.Parse(table.Rows[i]["SysNo"].ToString()), mod);
}
}
return(dictionary);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(SYS_PrivilegeMod model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into SYS_Privilege(");
strSql.Append("Name,TS,DR,URL)");
strSql.Append(" values (");
strSql.Append("@Name,@TS,@DR,@URL)");
strSql.Append(";select @@IDENTITY");
SqlCommand cmd = new SqlCommand(strSql.ToString());
SqlParameter[] parameters =
{
new SqlParameter("@Name", SqlDbType.NVarChar, 20),
new SqlParameter("@TS", SqlDbType.DateTime),
new SqlParameter("@DR", SqlDbType.TinyInt, 1),
new SqlParameter("@URL", SqlDbType.VarChar, 100),
};
if (model.Name != AppConst.StringNull)
{
parameters[0].Value = model.Name;
}
else
{
parameters[0].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[0]);
if (model.TS != AppConst.DateTimeNull)
{
parameters[1].Value = model.TS;
}
else
{
parameters[1].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[1]);
if (model.DR != AppConst.IntNull)
{
parameters[2].Value = model.DR;
}
else
{
parameters[2].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[2]);
if (model.URL != AppConst.StringNull)
{
parameters[3].Value = model.URL;
}
else
{
parameters[3].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[3]);
return(SqlHelper.ExecuteNonQuery(cmd, parameters));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(SYS_PrivilegeMod model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into SYS_Privilege(");
strSql.Append("Name,TS,DR,URL)");
strSql.Append(" values (");
strSql.Append("@Name,@TS,@DR,@URL)");
strSql.Append(";select @@IDENTITY");
SqlCommand cmd = new SqlCommand(strSql.ToString());
SqlParameter[] parameters = {
new SqlParameter("@Name",SqlDbType.NVarChar,20),
new SqlParameter("@TS",SqlDbType.DateTime),
new SqlParameter("@DR",SqlDbType.TinyInt,1),
new SqlParameter("@URL",SqlDbType.VarChar,100),
};
if (model.Name != AppConst.StringNull)
parameters[0].Value = model.Name;
else
parameters[0].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[0]);
if (model.TS != AppConst.DateTimeNull)
parameters[1].Value = model.TS;
else
parameters[1].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[1]);
if (model.DR != AppConst.IntNull)
parameters[2].Value = model.DR;
else
parameters[2].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[2]);
if (model.URL != AppConst.StringNull)
parameters[3].Value = model.URL;
else
parameters[3].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[3]);
return SqlHelper.ExecuteNonQuery(cmd, parameters);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public SYS_PrivilegeMod GetModel(int SysNo)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select SysNo, Name, TS, DR, URL from SYS_Privilege");
strSql.Append(" where SysNo=@SysNo ");
SqlParameter[] parameters =
{
new SqlParameter("@SysNo", SqlDbType.Int, 4)
};
parameters[0].Value = SysNo;
SYS_PrivilegeMod model = new SYS_PrivilegeMod();
DataSet ds = SqlHelper.ExecuteDataSet(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["SysNo"].ToString() != "")
{
model.SysNo = int.Parse(ds.Tables[0].Rows[0]["SysNo"].ToString());
}
model.Name = ds.Tables[0].Rows[0]["Name"].ToString();
if (ds.Tables[0].Rows[0]["TS"].ToString() != "")
{
model.TS = DateTime.Parse(ds.Tables[0].Rows[0]["TS"].ToString());
}
if (ds.Tables[0].Rows[0]["DR"].ToString() != "")
{
model.DR = int.Parse(ds.Tables[0].Rows[0]["DR"].ToString());
}
model.URL = ds.Tables[0].Rows[0]["URL"].ToString();
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(SYS_PrivilegeMod model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update SYS_Privilege set ");
strSql.Append("Name=@Name,");
strSql.Append("TS=@TS,");
strSql.Append("DR=@DR,");
strSql.Append("URL=@URL");
strSql.Append(" where SysNo=@SysNo ");
SqlCommand cmd = new SqlCommand(strSql.ToString());
SqlParameter[] parameters =
{
new SqlParameter("@SysNo", SqlDbType.Int, 4),
new SqlParameter("@Name", SqlDbType.NVarChar, 20),
new SqlParameter("@TS", SqlDbType.DateTime),
new SqlParameter("@DR", SqlDbType.TinyInt, 1),
new SqlParameter("@URL", SqlDbType.VarChar, 100)
};
if (model.SysNo != AppConst.IntNull)
{
parameters[0].Value = model.SysNo;
}
else
{
parameters[0].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[0]);
if (model.Name != AppConst.StringNull)
{
parameters[1].Value = model.Name;
}
else
{
parameters[1].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[1]);
if (model.TS != AppConst.DateTimeNull)
{
parameters[2].Value = model.TS;
}
else
{
parameters[2].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[2]);
if (model.DR != AppConst.IntNull)
{
parameters[3].Value = model.DR;
}
else
{
parameters[3].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[3]);
if (model.URL != AppConst.StringNull)
{
parameters[4].Value = model.URL;
}
else
{
parameters[4].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[4]);
return(SqlHelper.ExecuteNonQuery(cmd, parameters));
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(SYS_PrivilegeMod model)
{
dal.Update(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(SYS_PrivilegeMod model)
{
return dal.Add(model);
}
public Dictionary<int, SYS_PrivilegeMod> GetAdminPrivilege(int AdminSysNo)
{
DataTable table = new DataTable();
Dictionary<int, SYS_PrivilegeMod> dictionary = new Dictionary<int, SYS_PrivilegeMod>();
using (SQLData data = new SQLData())
{
StringBuilder builder = new StringBuilder();
builder.Append("select SysNo,[Name],url from SYS_Privilege where SysNo in (select Privilege_SysNo from REL_Admin_Privilege where Admin_SysNo=").Append(AdminSysNo).Append(") and DR=").Append((int)AppEnum.State.normal);
try
{
table = data.CmdtoDataTable(builder.ToString());
}
catch (Exception exception)
{
throw exception;
}
}
if (table.Rows.Count > 0)
{
for (int i = 0; i < table.Rows.Count; i++)
{
SYS_PrivilegeMod mod = new SYS_PrivilegeMod();
mod.Name =table.Rows[i]["Name"].ToString();
mod.SysNo = int.Parse(table.Rows[i]["SysNo"].ToString());
mod.URL = table.Rows[i]["url"].ToString();
dictionary.Add(int.Parse(table.Rows[i]["SysNo"].ToString()), mod);
}
}
return dictionary;
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(SYS_PrivilegeMod model)
{
dal.Update(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(SYS_PrivilegeMod model)
{
return(dal.Add(model));
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(SYS_PrivilegeMod model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update SYS_Privilege set ");
strSql.Append("Name=@Name,");
strSql.Append("TS=@TS,");
strSql.Append("DR=@DR,");
strSql.Append("URL=@URL");
strSql.Append(" where SysNo=@SysNo ");
SqlCommand cmd = new SqlCommand(strSql.ToString());
SqlParameter[] parameters = {
new SqlParameter("@SysNo",SqlDbType.Int,4),
new SqlParameter("@Name",SqlDbType.NVarChar,20),
new SqlParameter("@TS",SqlDbType.DateTime),
new SqlParameter("@DR",SqlDbType.TinyInt,1),
new SqlParameter("@URL",SqlDbType.VarChar,100)
};
if (model.SysNo != AppConst.IntNull)
parameters[0].Value = model.SysNo;
else
parameters[0].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[0]);
if (model.Name != AppConst.StringNull)
parameters[1].Value = model.Name;
else
parameters[1].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[1]);
if (model.TS != AppConst.DateTimeNull)
parameters[2].Value = model.TS;
else
parameters[2].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[2]);
if (model.DR != AppConst.IntNull)
parameters[3].Value = model.DR;
else
parameters[3].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[3]);
if (model.URL != AppConst.StringNull)
parameters[4].Value = model.URL;
else
parameters[4].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[4]);
return SqlHelper.ExecuteNonQuery(cmd, parameters);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public SYS_PrivilegeMod GetModel(int SysNo)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select SysNo, Name, TS, DR, URL from SYS_Privilege");
strSql.Append(" where SysNo=@SysNo ");
SqlParameter[] parameters = {
new SqlParameter("@SysNo", SqlDbType.Int,4 )
};
parameters[0].Value = SysNo;
SYS_PrivilegeMod model = new SYS_PrivilegeMod();
DataSet ds = SqlHelper.ExecuteDataSet(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["SysNo"].ToString() != "")
{
model.SysNo = int.Parse(ds.Tables[0].Rows[0]["SysNo"].ToString());
}
model.Name = ds.Tables[0].Rows[0]["Name"].ToString();
if (ds.Tables[0].Rows[0]["TS"].ToString() != "")
{
model.TS = DateTime.Parse(ds.Tables[0].Rows[0]["TS"].ToString());
}
if (ds.Tables[0].Rows[0]["DR"].ToString() != "")
{
model.DR = int.Parse(ds.Tables[0].Rows[0]["DR"].ToString());
}
model.URL = ds.Tables[0].Rows[0]["URL"].ToString();
return model;
}
else
{
return null;
}
}
