/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(MultiColorPen.Model.sys_buttoninfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update sys_buttoninfo set ");
strSql.Append("btncode=?btncode,");
strSql.Append("btnname=?btnname,");
strSql.Append("btnclass=?btnclass,");
strSql.Append("btnicon=?btnicon,");
strSql.Append("btnmethod=?btnmethod,");
strSql.Append("btnsort=?btnsort,");
strSql.Append("isenable=?isenable,");
strSql.Append("createtime=?createtime,");
strSql.Append("createman=?createman,");
strSql.Append("updatetime=?updatetime,");
strSql.Append("updateman=?updateman");
strSql.Append(" where id=?id");
MySqlParameter[] parameters =
{
new MySqlParameter("?btncode", MySqlDbType.VarChar, 10),
new MySqlParameter("?btnname", MySqlDbType.VarChar, 10),
new MySqlParameter("?btnclass", MySqlDbType.VarChar, 30),
new MySqlParameter("?btnicon", MySqlDbType.VarChar, 30),
new MySqlParameter("?btnmethod", MySqlDbType.VarChar, 30),
new MySqlParameter("?btnsort", 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("?id", MySqlDbType.Int32, 11)
};
parameters[0].Value = model.btncode;
parameters[1].Value = model.btnname;
parameters[2].Value = model.btnclass;
parameters[3].Value = model.btnicon;
parameters[4].Value = model.btnmethod;
parameters[5].Value = model.btnsort;
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.id;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public MultiColorPen.Model.sys_buttoninfo DataRowToModel(DataRow row)
{
MultiColorPen.Model.sys_buttoninfo model = new MultiColorPen.Model.sys_buttoninfo();
if (row != null)
{
if (row["id"] != null && row["id"].ToString() != "")
{
model.id = int.Parse(row["id"].ToString());
}
if (row["btncode"] != null)
{
model.btncode = row["btncode"].ToString();
}
if (row["btnname"] != null)
{
model.btnname = row["btnname"].ToString();
}
if (row["btnclass"] != null)
{
model.btnclass = row["btnclass"].ToString();
}
if (row["btnicon"] != null)
{
model.btnicon = row["btnicon"].ToString();
}
if (row["btnmethod"] != null)
{
model.btnmethod = row["btnmethod"].ToString();
}
if (row["btnsort"] != null && row["btnsort"].ToString() != "")
{
model.btnsort = int.Parse(row["btnsort"].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_buttoninfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into sys_buttoninfo(");
strSql.Append("btncode,btnname,btnclass,btnicon,btnmethod,btnsort,isenable,createtime,createman,updatetime,updateman)");
strSql.Append(" values (");
strSql.Append("?btncode,?btnname,?btnclass,?btnicon,?btnmethod,?btnsort,?isenable,?createtime,?createman,?updatetime,?updateman)");
MySqlParameter[] parameters =
{
new MySqlParameter("?btncode", MySqlDbType.VarChar, 10),
new MySqlParameter("?btnname", MySqlDbType.VarChar, 10),
new MySqlParameter("?btnclass", MySqlDbType.VarChar, 30),
new MySqlParameter("?btnicon", MySqlDbType.VarChar, 30),
new MySqlParameter("?btnmethod", MySqlDbType.VarChar, 30),
new MySqlParameter("?btnsort", 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.btncode;
parameters[1].Value = model.btnname;
parameters[2].Value = model.btnclass;
parameters[3].Value = model.btnicon;
parameters[4].Value = model.btnmethod;
parameters[5].Value = model.btnsort;
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;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public MultiColorPen.Model.sys_buttoninfo GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select id,btncode,btnname,btnclass,btnicon,btnmethod,btnsort,isenable,createtime,createman,updatetime,updateman from sys_buttoninfo ");
strSql.Append(" where id=?id");
MySqlParameter[] parameters =
{
new MySqlParameter("?id", MySqlDbType.Int32)
};
parameters[0].Value = id;
MultiColorPen.Model.sys_buttoninfo model = new MultiColorPen.Model.sys_buttoninfo();
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 BtnManageSave(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_buttoninfo();
//新增
if (jo["id"].ToString() == "-1")
{
var model = new MultiColorPen.Model.sys_buttoninfo
{
btncode = bll.GetMaxNo(),
btnname = jo["btnname"].ToString(),
btnclass = jo["btnclass"].ToString(),
btnicon = jo["btnicon"].ToString(),
btnmethod = jo["btnmethod"].ToString(),
isenable = 1,
createtime = DateTime.Now,
createman = userInfo.UserName
};
if (!string.IsNullOrEmpty(jo["btnsort"].ToString()))
{
model.btnsort = int.Parse(jo["btnsort"].ToString());
}
else
{
model.btnsort = 99;
}
if (bll.Add(model) > 0)
{
result.IsSucceed = true;
result.Message = "Save Successful!";
PublicClass.AddLog("Operating", "Add Button！" + model.btnname + "！");
}
else
{
result.IsSucceed = false;
result.Message = "Save Failed!";
}
}
//修改
else
{
int id = int.Parse(jo["id"].ToString());
var umodel = bll.GetModel(id);
umodel.btnname = jo["btnname"].ToString();
umodel.btnclass = jo["btnclass"].ToString();
umodel.btnicon = jo["btnicon"].ToString();
umodel.btnmethod = jo["btnmethod"].ToString();
if (!string.IsNullOrEmpty(jo["btnsort"].ToString()))
{
umodel.btnsort = int.Parse(jo["btnsort"].ToString());
}
else
{
umodel.btnsort = 99;
}
umodel.updateman = userInfo.UserName;
umodel.updatetime = DateTime.Now;
if (bll.Update(umodel))
{
result.IsSucceed = true;
result.Message = "Save Successful!";
PublicClass.AddLog("Operating", "Edit Button！" + umodel.btnname + "！");
}
else
{
result.IsSucceed = false;
result.Message = "Save Failed!";
}
}
return(JsonConvert.SerializeObject(result));
}
