/// <summary>
/// 得到一个对象实体
/// </summary>
public MultiColorPen.Model.base_userinfo GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select id, pid, username, password, usercode, rolecode, isenable, pname, sex, age, birthday, phone, avatar, qq, wechat, email, token, remark, createtime, createman, updatetime, updateman ");
strSql.Append(" from base_userinfo ");
strSql.Append(" where id=" + id);
MultiColorPen.Model.base_userinfo model = new MultiColorPen.Model.base_userinfo();
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 MultiColorPen.Model.base_userinfo GetModel(string username)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select id,pid,username,password,usercode,rolecode,isenable,pname,sex,age,birthday,phone,avatar,qq,wechat,email,token,remark,createtime,createman,updatetime,updateman from base_userinfo ");
strSql.Append(" where username=?username ");
MySqlParameter[] parameters =
{
new MySqlParameter("?username", MySqlDbType.VarChar, 20)
};
parameters[0].Value = username;
MultiColorPen.Model.base_userinfo model = new MultiColorPen.Model.base_userinfo();
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>
public bool Add(MultiColorPen.Model.base_userinfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into base_userinfo(");
strSql.Append("id,pid,username,password,usercode,rolecode,isenable,pname,sex,age,birthday,phone,avatar,qq,wechat,email,token,remark,createtime,createman,updatetime,updateman)");
strSql.Append(" values (");
strSql.Append("?id,?pid,?username,?password,?usercode,?rolecode,?isenable,?pname,?sex,?age,?birthday,?phone,?avatar,?qq,?wechat,?email,?token,?remark,?createtime,?createman,?updatetime,?updateman)");
MySqlParameter[] parameters =
{
new MySqlParameter("?id", MySqlDbType.Int32, 11),
new MySqlParameter("?pid", MySqlDbType.Int32, 11),
new MySqlParameter("?username", MySqlDbType.VarChar, 20),
new MySqlParameter("?password", MySqlDbType.VarChar, 50),
new MySqlParameter("?usercode", MySqlDbType.VarChar, 36),
new MySqlParameter("?rolecode", MySqlDbType.VarChar, 10),
new MySqlParameter("?isenable", MySqlDbType.Int32, 11),
new MySqlParameter("?pname", MySqlDbType.VarChar, 10),
new MySqlParameter("?sex", MySqlDbType.VarChar, 2),
new MySqlParameter("?age", MySqlDbType.VarChar, 2),
new MySqlParameter("?birthday", MySqlDbType.DateTime),
new MySqlParameter("?phone", MySqlDbType.VarChar, 20),
new MySqlParameter("?avatar", MySqlDbType.Text),
new MySqlParameter("?qq", MySqlDbType.VarChar, 20),
new MySqlParameter("?wechat", MySqlDbType.VarChar, 50),
new MySqlParameter("?email", MySqlDbType.VarChar, 50),
new MySqlParameter("?token", MySqlDbType.VarChar, 50),
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.pid;
parameters[2].Value = model.username;
parameters[3].Value = model.password;
parameters[4].Value = model.usercode;
parameters[5].Value = model.rolecode;
parameters[6].Value = model.isenable;
parameters[7].Value = model.pname;
parameters[8].Value = model.sex;
parameters[9].Value = model.age;
parameters[10].Value = model.birthday;
parameters[11].Value = model.phone;
parameters[12].Value = model.avatar;
parameters[13].Value = model.qq;
parameters[14].Value = model.wechat;
parameters[15].Value = model.email;
parameters[16].Value = model.token;
parameters[17].Value = model.remark;
parameters[18].Value = model.createtime;
parameters[19].Value = model.createman;
parameters[20].Value = model.updatetime;
parameters[21].Value = model.updateman;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public MultiColorPen.Model.base_userinfo DataRowToModel(DataRow row)
{
MultiColorPen.Model.base_userinfo model = new MultiColorPen.Model.base_userinfo();
if (row != null)
{
if (row["id"] != null && row["id"].ToString() != "")
{
model.id = int.Parse(row["id"].ToString());
}
if (row["pid"] != null && row["pid"].ToString() != "")
{
model.pid = int.Parse(row["pid"].ToString());
}
if (row["username"] != null)
{
model.username = row["username"].ToString();
}
if (row["password"] != null)
{
model.password = row["password"].ToString();
}
if (row["usercode"] != null)
{
model.usercode = row["usercode"].ToString();
}
if (row["rolecode"] != null)
{
model.rolecode = row["rolecode"].ToString();
}
if (row["isenable"] != null && row["isenable"].ToString() != "")
{
model.isenable = int.Parse(row["isenable"].ToString());
}
if (row["pname"] != null)
{
model.pname = row["pname"].ToString();
}
if (row["sex"] != null)
{
model.sex = row["sex"].ToString();
}
if (row["age"] != null)
{
model.age = row["age"].ToString();
}
if (row["birthday"] != null && row["birthday"].ToString() != "")
{
model.birthday = DateTime.Parse(row["birthday"].ToString());
}
if (row["phone"] != null)
{
model.phone = row["phone"].ToString();
}
if (row["avatar"] != null)
{
model.avatar = row["avatar"].ToString();
}
if (row["qq"] != null)
{
model.qq = row["qq"].ToString();
}
if (row["wechat"] != null)
{
model.wechat = row["wechat"].ToString();
}
if (row["email"] != null)
{
model.email = row["email"].ToString();
}
if (row["token"] != null)
{
model.token = row["token"].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 Update(MultiColorPen.Model.base_userinfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update base_userinfo set ");
strSql.Append("id=?id,");
strSql.Append("pid=?pid,");
strSql.Append("password=?password,");
strSql.Append("usercode=?usercode,");
strSql.Append("rolecode=?rolecode,");
strSql.Append("isenable=?isenable,");
strSql.Append("pname=?pname,");
strSql.Append("sex=?sex,");
strSql.Append("age=?age,");
strSql.Append("birthday=?birthday,");
strSql.Append("phone=?phone,");
strSql.Append("avatar=?avatar,");
strSql.Append("qq=?qq,");
strSql.Append("wechat=?wechat,");
strSql.Append("email=?email,");
strSql.Append("token=?token,");
strSql.Append("remark=?remark,");
strSql.Append("createtime=?createtime,");
strSql.Append("createman=?createman,");
strSql.Append("updatetime=?updatetime,");
strSql.Append("updateman=?updateman");
strSql.Append(" where username=?username ");
MySqlParameter[] parameters =
{
new MySqlParameter("?id", MySqlDbType.Int32, 11),
new MySqlParameter("?pid", MySqlDbType.Int32, 11),
new MySqlParameter("?password", MySqlDbType.VarChar, 50),
new MySqlParameter("?usercode", MySqlDbType.VarChar, 36),
new MySqlParameter("?rolecode", MySqlDbType.VarChar, 10),
new MySqlParameter("?isenable", MySqlDbType.Int32, 11),
new MySqlParameter("?pname", MySqlDbType.VarChar, 10),
new MySqlParameter("?sex", MySqlDbType.VarChar, 2),
new MySqlParameter("?age", MySqlDbType.VarChar, 2),
new MySqlParameter("?birthday", MySqlDbType.DateTime),
new MySqlParameter("?phone", MySqlDbType.VarChar, 20),
new MySqlParameter("?avatar", MySqlDbType.Text),
new MySqlParameter("?qq", MySqlDbType.VarChar, 20),
new MySqlParameter("?wechat", MySqlDbType.VarChar, 50),
new MySqlParameter("?email", MySqlDbType.VarChar, 50),
new MySqlParameter("?token", MySqlDbType.VarChar, 50),
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("?username", MySqlDbType.VarChar, 20)
};
parameters[0].Value = model.id;
parameters[1].Value = model.pid;
parameters[2].Value = model.password;
parameters[3].Value = model.usercode;
parameters[4].Value = model.rolecode;
parameters[5].Value = model.isenable;
parameters[6].Value = model.pname;
parameters[7].Value = model.sex;
parameters[8].Value = model.age;
parameters[9].Value = model.birthday;
parameters[10].Value = model.phone;
parameters[11].Value = model.avatar;
parameters[12].Value = model.qq;
parameters[13].Value = model.wechat;
parameters[14].Value = model.email;
parameters[15].Value = model.token;
parameters[16].Value = model.remark;
parameters[17].Value = model.createtime;
parameters[18].Value = model.createman;
parameters[19].Value = model.updatetime;
parameters[20].Value = model.updateman;
parameters[21].Value = model.username;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 保存Admin
/// </summary>
/// <param name="json"></param>
/// <returns></returns>
public string AdminManageSave(string json)
{
ResultInfo result = new ResultInfo(false);
JObject jo = JObject.Parse(json);
LoginInfo userInfo = SessionHelper.ReadSession <LoginInfo>(SessionKeys.LoginInfoKey);
var bll = new MultiColorPen.BLL.base_userinfo();
bool avatar = false;
string folderName = Server.MapPath("~/Upload/Avatar");
if (Directory.Exists(folderName) == false)
{
Directory.CreateDirectory(folderName);
}
string fileName = Guid.NewGuid().ToString("N");
string filePath = folderName + "/" + fileName + ".jpg";
if (jo["avatar"].ToString() == "-1" && jo["base64"].ToString() != "-1" && StringToFile(jo["base64"].ToString(), filePath))
{
avatar = true;
}
try
{
//新增
if (jo["id"].ToString() == "-1")
{
var list = bll.GetModelList("username='******' and A.isenable=1");
if (list.Count > 0)
{
result.IsSucceed = false;
result.Message = "Duplicate login name！";
}
else
{
var model = new MultiColorPen.Model.base_userinfo
{
usercode = bll.GetMaxNo(),
username = jo["username"].ToString(),
phone = jo["phone"].ToString(),
pname = jo["pname"].ToString(),
rolecode = jo["rolecode"].ToString(),
wechat = jo["wechat"].ToString(),
password = "******",
avatar = avatar ? fileName : jo["avatar"].ToString() == "-1" ? "" : jo["avatar"].ToString(),
isenable = 1,
createtime = DateTime.Now,
createman = userInfo.UserName
};
if (bll.Add(model) > 0)
{
result.IsSucceed = true;
result.Message = "Save success, the initial password is 888888！";
PublicClass.AddLog("Operating", "Add insiders " + model.username + "," + model.pname + "！");
}
else
{
result.IsSucceed = false;
result.Message = "Save failed！";
}
}
}
//修改
else
{
int id = int.Parse(jo["id"].ToString());
var list = bll.GetModelList("username='******' and A.id!=" + id + " and A.isenable=1");
if (list.Count > 0)
{
result.IsSucceed = false;
result.Message = "Duplicate login name！";
}
else
{
var umodel = bll.GetModel(id);
string oldstr = JsonHelper.GetObjectToJSON(umodel);
umodel.phone = jo["phone"].ToString();
umodel.pname = jo["pname"].ToString();
umodel.wechat = jo["wechat"].ToString();
umodel.rolecode = jo["rolecode"].ToString();
umodel.avatar = avatar ? fileName : jo["avatar"].ToString() == "-1" ? "" : jo["avatar"].ToString();
umodel.updateman = userInfo.UserName;
umodel.updatetime = DateTime.Now;
string newstr = JsonHelper.GetObjectToJSON(umodel);
if (bll.Update(umodel) > 0)
{
result.IsSucceed = true;
result.Message = "Saved successfully！";
PublicClass.AddLog("Operating", "Modify internal staff " + umodel.username + "！", "", "", "base_userinfo", umodel.id.ToString(), oldstr, newstr);
}
else
{
result.IsSucceed = false;
result.Message = "Save failed！";
}
}
}
return(JsonConvert.SerializeObject(result));
}
catch (Exception ex)
{
result.IsSucceed = false;
result.Message = ex.Message;
return(JsonConvert.SerializeObject(result));
}
}
