/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(MultiColorPen.Model.sys_roleinfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update sys_roleinfo set ");
strSql.Append("id=?id,");
strSql.Append("rolename=?rolename,");
strSql.Append("roletype=?roletype,");
strSql.Append("isenable=?isenable,");
strSql.Append("rolesort=?rolesort,");
strSql.Append("remark=?remark,");
strSql.Append("createtime=?createtime,");
strSql.Append("createman=?createman,");
strSql.Append("updatetime=?updatetime,");
strSql.Append("updateman=?updateman");
strSql.Append(" where rolecode=?rolecode ");
MySqlParameter[] parameters =
{
new MySqlParameter("?id", MySqlDbType.Int32, 11),
new MySqlParameter("?rolename", MySqlDbType.VarChar, 10),
new MySqlParameter("?roletype", MySqlDbType.VarChar, 10),
new MySqlParameter("?isenable", MySqlDbType.Int32, 11),
new MySqlParameter("?rolesort", MySqlDbType.Int32, 11),
new MySqlParameter("?remark", MySqlDbType.VarChar, 200),
new MySqlParameter("?createtime", MySqlDbType.DateTime),
new MySqlParameter("?createman", MySqlDbType.VarChar, 36),
new MySqlParameter("?updatetime", MySqlDbType.DateTime),
new MySqlParameter("?updateman", MySqlDbType.VarChar, 36),
new MySqlParameter("?rolecode", MySqlDbType.VarChar, 10)
};
parameters[0].Value = model.id;
parameters[1].Value = model.rolename;
parameters[2].Value = model.roletype;
parameters[3].Value = model.isenable;
parameters[4].Value = model.rolesort;
parameters[5].Value = model.remark;
parameters[6].Value = model.createtime;
parameters[7].Value = model.createman;
parameters[8].Value = model.updatetime;
parameters[9].Value = model.updateman;
parameters[10].Value = model.rolecode;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public MultiColorPen.Model.sys_roleinfo DataRowToModel(DataRow row)
{
MultiColorPen.Model.sys_roleinfo model = new MultiColorPen.Model.sys_roleinfo();
if (row != null)
{
if (row["id"] != null && row["id"].ToString() != "")
{
model.id = int.Parse(row["id"].ToString());
}
if (row["rolecode"] != null)
{
model.rolecode = row["rolecode"].ToString();
}
if (row["rolename"] != null)
{
model.rolename = row["rolename"].ToString();
}
if (row["roletype"] != null)
{
model.roletype = row["roletype"].ToString();
}
if (row["isenable"] != null && row["isenable"].ToString() != "")
{
model.isenable = int.Parse(row["isenable"].ToString());
}
if (row["rolesort"] != null && row["rolesort"].ToString() != "")
{
model.rolesort = int.Parse(row["rolesort"].ToString());
}
if (row["remark"] != null)
{
model.remark = row["remark"].ToString();
}
if (row["createtime"] != null && row["createtime"].ToString() != "")
{
model.createtime = DateTime.Parse(row["createtime"].ToString());
}
if (row["createman"] != null)
{
model.createman = row["createman"].ToString();
}
if (row["updatetime"] != null && row["updatetime"].ToString() != "")
{
model.updatetime = DateTime.Parse(row["updatetime"].ToString());
}
if (row["updateman"] != null)
{
model.updateman = row["updateman"].ToString();
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(MultiColorPen.Model.sys_roleinfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into sys_roleinfo(");
strSql.Append("id,rolecode,rolename,roletype,isenable,rolesort,remark,createtime,createman,updatetime,updateman)");
strSql.Append(" values (");
strSql.Append("?id,?rolecode,?rolename,?roletype,?isenable,?rolesort,?remark,?createtime,?createman,?updatetime,?updateman)");
MySqlParameter[] parameters =
{
new MySqlParameter("?id", MySqlDbType.Int32, 11),
new MySqlParameter("?rolecode", MySqlDbType.VarChar, 10),
new MySqlParameter("?rolename", MySqlDbType.VarChar, 10),
new MySqlParameter("?roletype", MySqlDbType.VarChar, 10),
new MySqlParameter("?isenable", MySqlDbType.Int32, 11),
new MySqlParameter("?rolesort", MySqlDbType.Int32, 11),
new MySqlParameter("?remark", MySqlDbType.VarChar, 200),
new MySqlParameter("?createtime", MySqlDbType.DateTime),
new MySqlParameter("?createman", MySqlDbType.VarChar, 36),
new MySqlParameter("?updatetime", MySqlDbType.DateTime),
new MySqlParameter("?updateman", MySqlDbType.VarChar, 36)
};
parameters[0].Value = model.id;
parameters[1].Value = model.rolecode;
parameters[2].Value = model.rolename;
parameters[3].Value = model.roletype;
parameters[4].Value = model.isenable;
parameters[5].Value = model.rolesort;
parameters[6].Value = model.remark;
parameters[7].Value = model.createtime;
parameters[8].Value = model.createman;
parameters[9].Value = model.updatetime;
parameters[10].Value = model.updateman;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public MultiColorPen.Model.sys_roleinfo GetModel(string rolecode)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select id,rolecode,rolename,roletype,isenable,rolesort,remark,createtime,createman,updatetime,updateman from sys_roleinfo ");
strSql.Append(" where rolecode=?rolecode ");
MySqlParameter[] parameters =
{
new MySqlParameter("?rolecode", MySqlDbType.VarChar, 10)
};
parameters[0].Value = rolecode;
MultiColorPen.Model.sys_roleinfo model = new MultiColorPen.Model.sys_roleinfo();
DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 新增、修改角色保存
/// </summary>
/// <returns></returns>
public string RoleSave(string json)
{
ResultInfo result = new ResultInfo(false);
JObject jo = JObject.Parse(json);
LoginInfo userInfo = SessionHelper.ReadSession <LoginInfo>(SessionKeys.LoginInfoKey);
BLL.sys_roleinfo bll = new BLL.sys_roleinfo();
//新增
if (jo["id"].ToString() == "-1")
{
MultiColorPen.Model.sys_roleinfo model = new MultiColorPen.Model.sys_roleinfo
{
rolecode = bll.GetMaxNo(),
rolename = jo["rolename"].ToString(),
isenable = 1,
remark = jo["remark"].ToString(),
createtime = DateTime.Now,
createman = userInfo.UserName
};
if (!string.IsNullOrEmpty(jo["rolesort"].ToString()))
{
model.rolesort = int.Parse(jo["rolesort"].ToString());
}
else
{
model.rolesort = 99;
}
if (bll.Add(model) > 0)
{
result.IsSucceed = true;
result.Message = "Save Successful!";
PublicClass.AddLog("Operating", "Add Role" + model.rolename + "！");
}
else
{
result.IsSucceed = false;
result.Message = "Save Failed!";
}
}
else//修改
{
string id = jo["id"].ToString();
var umodel = bll.GetModel(id);
umodel.rolename = jo["rolename"].ToString();
if (!string.IsNullOrEmpty(jo["rolesort"].ToString()))
{
umodel.rolesort = int.Parse(jo["rolesort"].ToString());
}
else
{
umodel.rolesort = 99;
}
umodel.remark = jo["remark"].ToString();
umodel.updateman = userInfo.UserName;
umodel.updatetime = DateTime.Now;
if (bll.Update(umodel))
{
result.IsSucceed = true;
result.Message = "Save Successful!";
PublicClass.AddLog("Operating", "Edit Role" + umodel.rolename + "！");
}
else
{
result.IsSucceed = false;
result.Message = "Save Failed!";
}
}
return(JsonConvert.SerializeObject(result));
}
