private bool Save(out string strMessage)
{
Boolean result = false;
strMessage = string.Empty;
Model_SysRole mcd = setModel(check_dict_id);
try
{
if (check_dict_id != "")
{
if (CheckExists(mcd, "2"))
{
strMessage = "已存在此项。";
}
else
{
//MS.Authority.clsAuth.AddLogFromBS("Drug_CheckAddOrUpdate", "【修改】【SysRole字典】【操作人】" + txtUserName.Text.Trim() + "【操作内容】：" + mcd.SysRole_Name + "");
result = dal.UpdateSysRoleByID(mcd);
if (result)
{
StringBuilder strLog = new StringBuilder();
strLog.AppendFormat("【修改角色】【ID】： {0}【角色名】：{1} ", mcd.SysRole_ID, mcd.SysRole_Name);
new BLL_clsAuth().AddLogFromBS(Module_Id, strLog.ToString());
}
}
}
else
{
if (txtName.Text.Trim() != "")
{
if (CheckExists(mcd, "1"))
{
strMessage = "已存在此项。";
}
else
{
//MS.Authority.clsAuth.AddLogFromBS("Drug_CheckAddOrUpdate", "【添加】【SysRole字典】【操作人】" + txtUserName.Text.Trim() + "【操作内容】：" + mcd.SysRole_Name + "");
result = dal.AddSysRole(mcd);
if (result)
{
StringBuilder strLog = new StringBuilder();
strLog.AppendFormat("【添加角色】【ID】： {0}【角色名】：{1} ", mcd.SysRole_ID, mcd.SysRole_Name);
new BLL_clsAuth().AddLogFromBS(Module_Id, strLog.ToString());
}
}
}
else
{
strMessage = "名称为空。";
result = false;
}
}
}
catch
{
throw;
}
return(result);
}
public bool Update(Model_SysRole model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update SysRole set ");
builder.Append("SysRole_ID=@SysRole_ID,");
builder.Append("SysRole_Name=@SysRole_Name,");
builder.Append("SysRole_Order=@SysRole_Order,");
builder.Append("SysRole_Enable=@SysRole_Enable,");
builder.Append("SysRole_Remark=@SysRole_Remark,");
builder.Append("CreateTime=@CreateTime,");
builder.Append("CreateUser=@CreateUser,");
builder.Append("UpdateTime=@UpdateTime,");
builder.Append("UpdateUser=@UpdateUser");
builder.Append(" where ");
SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@SysRole_ID", SqlDbType.Char, 0x24), new SqlParameter("@SysRole_Name", SqlDbType.NVarChar, 100), new SqlParameter("@SysRole_Order", SqlDbType.Int, 4), new SqlParameter("@SysRole_Enable", SqlDbType.Bit, 1), new SqlParameter("@SysRole_Remark", SqlDbType.NVarChar, 0x3e8), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@CreateUser", SqlDbType.Char, 0x24), new SqlParameter("@UpdateTime", SqlDbType.DateTime), new SqlParameter("@UpdateUser", SqlDbType.Char, 0x24) };
cmdParms[0].Value = model.SysRole_ID;
cmdParms[1].Value = model.SysRole_Name;
cmdParms[2].Value = model.SysRole_Order;
cmdParms[3].Value = model.SysRole_Enable;
cmdParms[4].Value = model.SysRole_Remark;
cmdParms[5].Value = model.CreateTime;
cmdParms[6].Value = model.CreateUser;
cmdParms[7].Value = model.UpdateTime;
cmdParms[8].Value = model.UpdateUser;
return(DbHelperSQL.ExecuteSql(builder.ToString(), cmdParms) > 0);
}
public Model_SysRole GetSysRoleModel(string SysRole_ID)
{
StringBuilder builder = new StringBuilder();
builder.Append("select top 1 * from SysRole ");
builder.Append(" where SysRole_ID=@SysRole_ID ");
SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@SysRole_ID", SqlDbType.Char, 0x24) };
cmdParms[0].Value = SysRole_ID;
Model_SysRole role = new Model_SysRole();
DataSet set = DbHelperSQL.Query(builder.ToString(), cmdParms);
if (set.Tables[0].Rows.Count <= 0)
{
return(null);
}
if ((set.Tables[0].Rows[0]["SysRole_ID"] != null) && (set.Tables[0].Rows[0]["SysRole_ID"].ToString() != ""))
{
role.SysRole_ID = set.Tables[0].Rows[0]["SysRole_ID"].ToString();
}
if ((set.Tables[0].Rows[0]["SysRole_Name"] != null) && (set.Tables[0].Rows[0]["SysRole_Name"].ToString() != ""))
{
role.SysRole_Name = set.Tables[0].Rows[0]["SysRole_Name"].ToString();
}
if ((set.Tables[0].Rows[0]["SysRole_Order"] != null) && (set.Tables[0].Rows[0]["SysRole_Order"].ToString() != ""))
{
role.SysRole_Order = new int?(int.Parse(set.Tables[0].Rows[0]["SysRole_Order"].ToString()));
}
if ((set.Tables[0].Rows[0]["SysRole_Enable"] != null) && (set.Tables[0].Rows[0]["SysRole_Enable"].ToString() != ""))
{
if ((set.Tables[0].Rows[0]["SysRole_Enable"].ToString() == "1") || (set.Tables[0].Rows[0]["SysRole_Enable"].ToString().ToLower() == "true"))
{
role.SysRole_Enable = true;
}
else
{
role.SysRole_Enable = false;
}
}
if ((set.Tables[0].Rows[0]["SysRole_Remark"] != null) && (set.Tables[0].Rows[0]["SysRole_Remark"].ToString() != ""))
{
role.SysRole_Remark = set.Tables[0].Rows[0]["SysRole_Remark"].ToString();
}
if ((set.Tables[0].Rows[0]["CreateTime"] != null) && (set.Tables[0].Rows[0]["CreateTime"].ToString() != ""))
{
role.CreateTime = new DateTime?(DateTime.Parse(set.Tables[0].Rows[0]["CreateTime"].ToString()));
}
if ((set.Tables[0].Rows[0]["CreateUser"] != null) && (set.Tables[0].Rows[0]["CreateUser"].ToString() != ""))
{
role.CreateUser = set.Tables[0].Rows[0]["CreateUser"].ToString();
}
if ((set.Tables[0].Rows[0]["UpdateTime"] != null) && (set.Tables[0].Rows[0]["UpdateTime"].ToString() != ""))
{
role.UpdateTime = new DateTime?(DateTime.Parse(set.Tables[0].Rows[0]["UpdateTime"].ToString()));
}
if ((set.Tables[0].Rows[0]["UpdateUser"] != null) && (set.Tables[0].Rows[0]["UpdateUser"].ToString() != ""))
{
role.UpdateUser = set.Tables[0].Rows[0]["UpdateUser"].ToString();
}
return(role);
}
public List <Model_SysRole> DataTableToList(DataTable dt)
{
List <Model_SysRole> list = new List <Model_SysRole>();
int count = dt.Rows.Count;
if (count > 0)
{
for (int i = 0; i < count; i++)
{
Model_SysRole item = new Model_SysRole();
if ((dt.Rows[i]["SysRole_ID"] != null) && (dt.Rows[i]["SysRole_ID"].ToString() != ""))
{
item.SysRole_ID = dt.Rows[i]["SysRole_ID"].ToString();
}
if ((dt.Rows[i]["SysRole_Name"] != null) && (dt.Rows[i]["SysRole_Name"].ToString() != ""))
{
item.SysRole_Name = dt.Rows[i]["SysRole_Name"].ToString();
}
if ((dt.Rows[i]["SysRole_Order"] != null) && (dt.Rows[i]["SysRole_Order"].ToString() != ""))
{
item.SysRole_Order = new int?(int.Parse(dt.Rows[i]["SysRole_Order"].ToString()));
}
if ((dt.Rows[i]["SysRole_Enable"] != null) && (dt.Rows[i]["SysRole_Enable"].ToString() != ""))
{
if ((dt.Rows[i]["SysRole_Enable"].ToString() == "1") || (dt.Rows[i]["SysRole_Enable"].ToString().ToLower() == "true"))
{
item.SysRole_Enable = true;
}
else
{
item.SysRole_Enable = false;
}
}
if ((dt.Rows[i]["SysRole_Remark"] != null) && (dt.Rows[i]["SysRole_Remark"].ToString() != ""))
{
item.SysRole_Remark = dt.Rows[i]["SysRole_Remark"].ToString();
}
if ((dt.Rows[i]["CreateTime"] != null) && (dt.Rows[i]["CreateTime"].ToString() != ""))
{
item.CreateTime = new DateTime?(DateTime.Parse(dt.Rows[i]["CreateTime"].ToString()));
}
if ((dt.Rows[i]["CreateUser"] != null) && (dt.Rows[i]["CreateUser"].ToString() != ""))
{
item.CreateUser = dt.Rows[i]["CreateUser"].ToString();
}
if ((dt.Rows[i]["UpdateTime"] != null) && (dt.Rows[i]["UpdateTime"].ToString() != ""))
{
item.UpdateTime = new DateTime?(DateTime.Parse(dt.Rows[i]["UpdateTime"].ToString()));
}
if ((dt.Rows[i]["UpdateUser"] != null) && (dt.Rows[i]["UpdateUser"].ToString() != ""))
{
item.UpdateUser = dt.Rows[i]["UpdateUser"].ToString();
}
list.Add(item);
}
}
return(list);
}
/// <summary>
/// 判断是否存在
/// </summary>
/// <param name="type">1添加时，2修改时</param>
/// <returns>已存在返回true</returns>
private bool CheckExists(Model_SysRole mcd, string type)
{
try
{
return(new Rc.Cloud.BLL.BLL_SysRole().ExistsSysRole(mcd, type));
}
catch (Exception)
{
return(true);
}
}
public Model_SysRole DataRowToModel(DataRow row)
{
Model_SysRole role = new Model_SysRole();
if (row != null)
{
if (row["SysRole_ID"] != null)
{
role.SysRole_ID = row["SysRole_ID"].ToString();
}
if (row["SysRole_Name"] != null)
{
role.SysRole_Name = row["SysRole_Name"].ToString();
}
if ((row["SysRole_Order"] != null) && (row["SysRole_Order"].ToString() != ""))
{
role.SysRole_Order = new int?(int.Parse(row["SysRole_Order"].ToString()));
}
if ((row["SysRole_Enable"] != null) && (row["SysRole_Enable"].ToString() != ""))
{
if ((row["SysRole_Enable"].ToString() == "1") || (row["SysRole_Enable"].ToString().ToLower() == "true"))
{
role.SysRole_Enable = true;
}
else
{
role.SysRole_Enable = false;
}
}
if (row["SysRole_Remark"] != null)
{
role.SysRole_Remark = row["SysRole_Remark"].ToString();
}
if ((row["CreateTime"] != null) && (row["CreateTime"].ToString() != ""))
{
role.CreateTime = new DateTime?(DateTime.Parse(row["CreateTime"].ToString()));
}
if (row["CreateUser"] != null)
{
role.CreateUser = row["CreateUser"].ToString();
}
if ((row["UpdateTime"] != null) && (row["UpdateTime"].ToString() != ""))
{
role.UpdateTime = new DateTime?(DateTime.Parse(row["UpdateTime"].ToString()));
}
if (row["UpdateUser"] != null)
{
role.UpdateUser = row["UpdateUser"].ToString();
}
}
return(role);
}
public List <Model_SysRole> DataTableToList(DataTable dt)
{
List <Model_SysRole> list = new List <Model_SysRole>();
int count = dt.Rows.Count;
if (count > 0)
{
for (int i = 0; i < count; i++)
{
Model_SysRole item = this.dal.DataRowToModel(dt.Rows[i]);
if (item != null)
{
list.Add(item);
}
}
}
return(list);
}
private Model_SysRole setModel(string Check_Dict_ID)
{
Model_SysRole mcd = new Model_SysRole();
if (Check_Dict_ID != "" && D_type == "")
{
mcd.SysRole_ID = Check_Dict_ID;
mcd.SysRole_Name = txtName.Text.Trim();
mcd.CreateTime = DateTime.Now;
}
else
{
mcd.SysRole_ID = Guid.NewGuid().ToString();
mcd.SysRole_Name = txtName.Text.Trim();
mcd.CreateTime = DateTime.Now;
}
return(mcd);
}
public bool ExistsSysRole(Model_SysRole mcd, string type)
{
StringBuilder builder = new StringBuilder();
bool flag = false;
if (type == "1")
{
builder.AppendFormat("SELECT COUNT(*) FROM SysRole WHERE SysRole_Name='{0}'", mcd.SysRole_Name);
}
else if (type == "2")
{
builder.AppendFormat("SELECT COUNT(*) FROM SysRole WHERE SysRole_ID<>'{0}' and SysRole_Name='{1}'", mcd.SysRole_ID, mcd.SysRole_Name);
}
if (int.Parse(DbHelperSQL.GetSingle(builder.ToString()).ToString()) > 0)
{
flag = true;
}
return(flag);
}
public bool Add(Model_SysRole model)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into SysRole(");
builder.Append("SysRole_ID,SysRole_Name,SysRole_Order,SysRole_Enable,SysRole_Remark,CreateTime,CreateUser,UpdateTime,UpdateUser)");
builder.Append(" values (");
builder.Append("@SysRole_ID,@SysRole_Name,@SysRole_Order,@SysRole_Enable,@SysRole_Remark,@CreateTime,@CreateUser,@UpdateTime,@UpdateUser)");
SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@SysRole_ID", SqlDbType.Char, 0x24), new SqlParameter("@SysRole_Name", SqlDbType.NVarChar, 100), new SqlParameter("@SysRole_Order", SqlDbType.Int, 4), new SqlParameter("@SysRole_Enable", SqlDbType.Bit, 1), new SqlParameter("@SysRole_Remark", SqlDbType.NVarChar, 0x3e8), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@CreateUser", SqlDbType.Char, 0x24), new SqlParameter("@UpdateTime", SqlDbType.DateTime), new SqlParameter("@UpdateUser", SqlDbType.Char, 0x24) };
cmdParms[0].Value = model.SysRole_ID;
cmdParms[1].Value = model.SysRole_Name;
cmdParms[2].Value = model.SysRole_Order;
cmdParms[3].Value = model.SysRole_Enable;
cmdParms[4].Value = model.SysRole_Remark;
cmdParms[5].Value = model.CreateTime;
cmdParms[6].Value = model.CreateUser;
cmdParms[7].Value = model.UpdateTime;
cmdParms[8].Value = model.UpdateUser;
return(DbHelperSQL.ExecuteSql(builder.ToString(), cmdParms) > 0);
}
public bool Add(Model_SysRole model)
{
return(this.dal.Add(model));
}
public bool Update(Model_SysRole model)
{
return(this.dal.Update(model));
}
public bool ExistsSysRole(Model_SysRole mcd, string type)
{
return(this.dal.ExistsSysRole(mcd, type));
}
