/// <summary> /// 增加一条数据 /// </summary> public bool Add(MultiColorPen.Model.customer model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into customer("); strSql.Append("name,address,tel,is_del,person,mark)"); strSql.Append(" values ("); strSql.Append("?name,?address,?tel,?is_del,?person,?mark)"); MySqlParameter[] parameters = { new MySqlParameter("?name", MySqlDbType.VarChar, 100), new MySqlParameter("?address", MySqlDbType.VarChar, 150), new MySqlParameter("?tel", MySqlDbType.VarChar, 20), new MySqlParameter("?is_del", MySqlDbType.VarChar, 2), new MySqlParameter("?person", MySqlDbType.VarChar, 20), new MySqlParameter("?mark", MySqlDbType.VarChar, 255) }; parameters[0].Value = model.name; parameters[1].Value = model.address; parameters[2].Value = model.tel; parameters[3].Value = model.is_del; parameters[4].Value = model.person; parameters[5].Value = model.mark; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
public string SaveCustomer(string json) { ResultInfo result = new ResultInfo(false); JObject jo = JObject.Parse(json); LoginInfo userInfo = SessionHelper.ReadSession <LoginInfo>(SessionKeys.LoginInfoKey); var bll = new MultiColorPen.BLL.customer(); //新增 if (jo["id"].ToString() == "-1") { var model = new MultiColorPen.Model.customer { name = jo["name"].ToString(), address = jo["address"].ToString(), tel = jo["tel"].ToString(), person = jo["person"].ToString(), is_del = "0", mark = jo["mark"].ToString() }; if (bll.Add(model)) { result.IsSucceed = true; result.Message = "操作成功!"; PublicClass.AddLog("Operating", "新增商家" + model.name + "!"); } else { result.IsSucceed = false; result.Message = "新增失败!"; } } //修改 else { int id = int.Parse(jo["id"].ToString()); var umodel = bll.GetModel(id); umodel.name = jo["name"].ToString(); umodel.address = jo["address"].ToString(); umodel.tel = jo["tel"].ToString(); umodel.person = jo["person"].ToString(); umodel.mark = jo["mark"].ToString(); List <string> btncode = new List <string>(); if (bll.Update(umodel)) { result.IsSucceed = true; result.Message = "操作成功!"; PublicClass.AddLog("Operating", "编辑商家信息" + umodel.name + "!"); } else { result.IsSucceed = false; result.Message = "修改失败!"; } } return(JsonConvert.SerializeObject(result)); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(MultiColorPen.Model.customer model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update customer set "); strSql.Append("name=?name,"); strSql.Append("address=?address,"); strSql.Append("tel=?tel,"); strSql.Append("is_del=?is_del,"); strSql.Append("person=?person,"); strSql.Append("mark=?mark"); strSql.Append(" where id=?id"); MySqlParameter[] parameters = { new MySqlParameter("?name", MySqlDbType.VarChar, 100), new MySqlParameter("?address", MySqlDbType.VarChar, 150), new MySqlParameter("?tel", MySqlDbType.VarChar, 20), new MySqlParameter("?is_del", MySqlDbType.VarChar, 2), new MySqlParameter("?person", MySqlDbType.VarChar, 20), new MySqlParameter("?mark", MySqlDbType.VarChar, 255), new MySqlParameter("?id", MySqlDbType.Int32, 11) }; parameters[0].Value = model.name; parameters[1].Value = model.address; parameters[2].Value = model.tel; parameters[3].Value = model.is_del; parameters[4].Value = model.person; parameters[5].Value = model.mark; parameters[6].Value = model.id; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public MultiColorPen.Model.customer DataRowToModel(DataRow row) { MultiColorPen.Model.customer model = new MultiColorPen.Model.customer(); if (row != null) { if (row["id"] != null && row["id"].ToString() != "") { model.id = int.Parse(row["id"].ToString()); } if (row["name"] != null) { model.name = row["name"].ToString(); } if (row["address"] != null) { model.address = row["address"].ToString(); } if (row["tel"] != null) { model.tel = row["tel"].ToString(); } if (row["is_del"] != null) { model.is_del = row["is_del"].ToString(); } if (row["person"] != null) { model.person = row["person"].ToString(); } if (row["mark"] != null) { model.mark = row["mark"].ToString(); } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public MultiColorPen.Model.customer GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select id,name,address,tel,is_del,person,mark from customer "); strSql.Append(" where id=?id"); MySqlParameter[] parameters = { new MySqlParameter("?id", MySqlDbType.Int32) }; parameters[0].Value = id; MultiColorPen.Model.customer model = new MultiColorPen.Model.customer(); DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }