/// <summary>
/// 增加一条数据
/// </summary>
public int Add(MultiColorPen.Model.sys_menuinfo model, List <string> btncode)
{
List <CommandInfo> cmd_list = new List <CommandInfo>();
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into sys_menuinfo(");
strSql.Append("pmenucode,menucode,menuname,linkaddress,menuicon,menusort,isenable,createtime,createman,updatetime,updateman)");
strSql.Append(" values (");
strSql.Append("'{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}')");
strSql.Append(";");
string sql = "";
if (model.updatetime != null)
{
sql = string.Format(strSql.ToString(), model.pmenucode, model.menucode, model.menuname, model.linkaddress, model.menuicon, model.menusort, model.isenable, model.createtime, model.createman, model.updatetime, model.updateman);
}
else
{
StringBuilder strSql1 = new StringBuilder();
strSql1.Append("insert into sys_menuinfo(");
strSql1.Append("pmenucode,menucode,menuname,linkaddress,menuicon,menusort,isenable,createtime,createman)");
strSql1.Append(" values (");
strSql1.Append("'{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}')");
strSql1.Append(";");
sql = string.Format(strSql1.ToString(), model.pmenucode, model.menucode, model.menuname, model.linkaddress, model.menuicon, model.menusort, model.isenable, model.createtime, model.createman);
}
cmd_list.Add(new CommandInfo(sql, null));
for (int i = 0; i < btncode.Count; i++)
{
cmd_list.Add(new CommandInfo("insert into sys_menubutton(menucode,btncode) values('" + model.menucode + "','" + btncode[i].ToString() + "')", null));
}
return(DbHelperMySQL.ExecuteSqlTran(cmd_list));
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(MultiColorPen.Model.sys_menuinfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update sys_menuinfo set ");
strSql.Append("id=?id,");
strSql.Append("pmenucode=?pmenucode,");
strSql.Append("menuname=?menuname,");
strSql.Append("linkaddress=?linkaddress,");
strSql.Append("menuicon=?menuicon,");
strSql.Append("menusort=?menusort,");
strSql.Append("isenable=?isenable,");
strSql.Append("createtime=?createtime,");
strSql.Append("createman=?createman,");
strSql.Append("updatetime=?updatetime,");
strSql.Append("updateman=?updateman");
strSql.Append(" where menucode=?menucode ");
MySqlParameter[] parameters =
{
new MySqlParameter("?id", MySqlDbType.Int32, 11),
new MySqlParameter("?pmenucode", MySqlDbType.VarChar, 10),
new MySqlParameter("?menuname", MySqlDbType.VarChar, 20),
new MySqlParameter("?linkaddress", MySqlDbType.VarChar, 50),
new MySqlParameter("?menuicon", MySqlDbType.VarChar, 20),
new MySqlParameter("?menusort", MySqlDbType.Int32, 11),
new MySqlParameter("?isenable", MySqlDbType.Int32, 11),
new MySqlParameter("?createtime", MySqlDbType.DateTime),
new MySqlParameter("?createman", MySqlDbType.VarChar, 36),
new MySqlParameter("?updatetime", MySqlDbType.DateTime),
new MySqlParameter("?updateman", MySqlDbType.VarChar, 36),
new MySqlParameter("?menucode", MySqlDbType.VarChar, 10)
};
parameters[0].Value = model.id;
parameters[1].Value = model.pmenucode;
parameters[2].Value = model.menuname;
parameters[3].Value = model.linkaddress;
parameters[4].Value = model.menuicon;
parameters[5].Value = model.menusort;
parameters[6].Value = model.isenable;
parameters[7].Value = model.createtime;
parameters[8].Value = model.createman;
parameters[9].Value = model.updatetime;
parameters[10].Value = model.updateman;
parameters[11].Value = model.menucode;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public MultiColorPen.Model.sys_menuinfo DataRowToModel(DataRow row)
{
MultiColorPen.Model.sys_menuinfo model = new MultiColorPen.Model.sys_menuinfo();
if (row != null)
{
if (row["id"] != null && row["id"].ToString() != "")
{
model.id = int.Parse(row["id"].ToString());
}
if (row["pmenucode"] != null)
{
model.pmenucode = row["pmenucode"].ToString();
}
if (row["menucode"] != null)
{
model.menucode = row["menucode"].ToString();
}
if (row["menuname"] != null)
{
model.menuname = row["menuname"].ToString();
}
if (row["linkaddress"] != null)
{
model.linkaddress = row["linkaddress"].ToString();
}
if (row["menuicon"] != null)
{
model.menuicon = row["menuicon"].ToString();
}
if (row["menusort"] != null && row["menusort"].ToString() != "")
{
model.menusort = int.Parse(row["menusort"].ToString());
}
if (row["isenable"] != null && row["isenable"].ToString() != "")
{
model.isenable = int.Parse(row["isenable"].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_menuinfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into sys_menuinfo(");
strSql.Append("id,pmenucode,menucode,menuname,linkaddress,menuicon,menusort,isenable,createtime,createman,updatetime,updateman)");
strSql.Append(" values (");
strSql.Append("?id,?pmenucode,?menucode,?menuname,?linkaddress,?menuicon,?menusort,?isenable,?createtime,?createman,?updatetime,?updateman)");
MySqlParameter[] parameters =
{
new MySqlParameter("?id", MySqlDbType.Int32, 11),
new MySqlParameter("?pmenucode", MySqlDbType.VarChar, 10),
new MySqlParameter("?menucode", MySqlDbType.VarChar, 10),
new MySqlParameter("?menuname", MySqlDbType.VarChar, 20),
new MySqlParameter("?linkaddress", MySqlDbType.VarChar, 50),
new MySqlParameter("?menuicon", MySqlDbType.VarChar, 20),
new MySqlParameter("?menusort", MySqlDbType.Int32, 11),
new MySqlParameter("?isenable", MySqlDbType.Int32, 11),
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.pmenucode;
parameters[2].Value = model.menucode;
parameters[3].Value = model.menuname;
parameters[4].Value = model.linkaddress;
parameters[5].Value = model.menuicon;
parameters[6].Value = model.menusort;
parameters[7].Value = model.isenable;
parameters[8].Value = model.createtime;
parameters[9].Value = model.createman;
parameters[10].Value = model.updatetime;
parameters[11].Value = model.updateman;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public MultiColorPen.Model.sys_menuinfo GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select id,pmenucode,menucode,menuname,linkaddress,menuicon,menusort,isenable,createtime,createman,updatetime,updateman from sys_menuinfo ");
strSql.Append(" where id=" + id);
MultiColorPen.Model.sys_menuinfo model = new MultiColorPen.Model.sys_menuinfo();
DataSet ds = DbHelperMySQL.Query(strSql.ToString());
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(MultiColorPen.Model.sys_menuinfo model, List <string> btncode)
{
List <CommandInfo> cmd_list = new List <CommandInfo>();
StringBuilder strSql = new StringBuilder();
strSql.Append("update sys_menuinfo set ");
strSql.Append("pmenucode='{0}',");
strSql.Append("menuname='{1}',");
strSql.Append("linkaddress='{2}',");
strSql.Append("menuicon='{3}',");
strSql.Append("menusort='{4}',");
strSql.Append("isenable='{5}',");
strSql.Append("createtime='{6}',");
strSql.Append("createman='{7}',");
strSql.Append("updatetime='{8}',");
strSql.Append("updateman='{9}'");
strSql.Append(" where id='{10}'");
string sql = string.Format(strSql.ToString(), model.pmenucode, model.menuname, model.linkaddress, model.menuicon, model.menusort, model.isenable, model.createtime, model.createman, model.updatetime, model.updateman, model.id);
cmd_list.Add(new CommandInfo(sql, null));
cmd_list.Add(new CommandInfo(string.Format("delete from sys_menubutton where menucode='{0}'", model.menucode), null));
for (int i = 0; i < btncode.Count; i++)
{
cmd_list.Add(new CommandInfo(string.Format("insert into sys_menubutton(menucode,btncode) values('{0}','{1}')", model.menucode, btncode[i]), null));
}
int rows = DbHelperMySQL.ExecuteSqlTran(cmd_list);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public MultiColorPen.Model.sys_menuinfo GetModel(string menucode)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select id,pmenucode,menucode,menuname,linkaddress,menuicon,menusort,isenable,createtime,createman,updatetime,updateman from sys_menuinfo ");
strSql.Append(" where menucode=?menucode ");
MySqlParameter[] parameters =
{
new MySqlParameter("?menucode", MySqlDbType.VarChar, 10)
};
parameters[0].Value = menucode;
MultiColorPen.Model.sys_menuinfo model = new MultiColorPen.Model.sys_menuinfo();
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>
/// <param name="json"></param>
/// <returns></returns>
public string FunctionSave(string json)
{
ResultInfo result = new ResultInfo(false);
JObject jo = JObject.Parse(json);
LoginInfo userInfo = SessionHelper.ReadSession <LoginInfo>(SessionKeys.LoginInfoKey);
var bll = new MultiColorPen.BLL.sys_menuinfo();
//新增
if (jo["did"].ToString() == "-1")
{
string code = bll.GetMaxNo();
var model = new MultiColorPen.Model.sys_menuinfo
{
pmenucode = jo["pmenucode"].ToString(),
menucode = code,
menuname = jo["menuname"].ToString(),
menuicon = jo["menuicon"].ToString(),
linkaddress = jo["linkaddress"].ToString(),
isenable = 1,
createtime = DateTime.Now,
createman = userInfo.UserName
};
if (!string.IsNullOrEmpty(jo["menusort"].ToString()))
{
model.menusort = int.Parse(jo["menusort"].ToString());
}
else
{
model.menusort = 99;
}
var list = jo["btncode"];
List <string> btncode = new List <string>();
if (list != null && list.Count() > 0)
{
for (int i = 0; i < list.Count(); i++)
{
btncode.Add(list[i].ToString());
}
}
if (bll.Add(model, btncode) > 0)
{
result.IsSucceed = true;
result.Message = "Operation Successful!";
PublicClass.AddLog("Operating", "Add System Function" + model.menuname + "！");
}
else
{
result.IsSucceed = false;
result.Message = "Save Failed！";
}
}
//修改
else
{
int id = int.Parse(jo["did"].ToString());
var umodel = bll.GetModel(id);
umodel.pmenucode = jo["pmenucode"].ToString();
umodel.menuname = jo["menuname"].ToString();
umodel.menuicon = jo["menuicon"].ToString();
if (!string.IsNullOrEmpty(jo["menusort"].ToString()))
{
umodel.menusort = int.Parse(jo["menusort"].ToString());
}
else
{
umodel.menusort = 99;
}
umodel.linkaddress = jo["linkaddress"].ToString();
umodel.updateman = userInfo.UserName;
umodel.updatetime = DateTime.Now;
var list = jo["btncode"];
List <string> btncode = new List <string>();
if (list != null && list.Count() > 0)
{
for (int i = 0; i < list.Count(); i++)
{
btncode.Add(list[i].ToString());
}
}
if (bll.Update(umodel, btncode))
{
result.IsSucceed = true;
result.Message = "Operating Successful!";
PublicClass.AddLog("Operating", "Edit System Function" + umodel.menuname + "！");
}
else
{
result.IsSucceed = false;
result.Message = "Save Failed！";
}
}
return(JsonConvert.SerializeObject(result));
}
