/// <summary> /// 根据类别ID获取model /// </summary> /// <param name="classid">classid</param> /// <returns></returns> public Mproductclass GetMproductclassByClassid(int classid) { string sql = " SELECT classid,supclassid,classname,priority,isDelete,isEffective,great_time,modify_time,imgpath from productclass where 1=1 and classid = ?classid;"; MySqlParameter[] parameterList = new MySqlParameter[1]; parameterList[0] = new MySqlParameter("?classid", MySqlDbType.Int32); parameterList[0].Value = classid; using (MySqlDataReader sqlDataReader = PKMySqlHelper.ExecuteReader(sql, parameterList)) { if (sqlDataReader != null) { if (sqlDataReader.Read()) { Mproductclass model = new Mproductclass(); model.classid = sqlDataReader["classid"] != DBNull.Value ? Convert.ToInt32(sqlDataReader["classid"].ToString()) : 0; model.supclassid = sqlDataReader["supclassid"] != DBNull.Value ? Convert.ToInt32(sqlDataReader["supclassid"].ToString()) : 0; model.priority = sqlDataReader["priority"] != DBNull.Value ? Convert.ToInt32(sqlDataReader["priority"].ToString()) : 0; model.classname = sqlDataReader["classname"] != DBNull.Value ? sqlDataReader["classname"].ToString() : string.Empty; model.great_time = sqlDataReader["great_time"] != DBNull.Value ? Convert.ToDateTime(sqlDataReader["great_time"].ToString()) : DateTime.MinValue; model.modify_time = sqlDataReader["modify_time"] != DBNull.Value ? Convert.ToDateTime(sqlDataReader["modify_time"].ToString()) : DateTime.MinValue; model.imgpath = sqlDataReader["imgpath"] != DBNull.Value ? sqlDataReader["imgpath"].ToString() : string.Empty; return(model); } } } return(null); }
/// <summary> /// 新增产品分类方法接口 /// </summary> /// <returns></returns> public string AddProductclassMeth(Mproductclass model) { if (!base.CheckIsLogin()) { return("-1"); } HttpPostedFileBase productimgurl = Request.Files["productimgurl"]; return(new ProductBus().AddProductclasses(model, productimgurl, Server.MapPath("/"))); }
/// <summary> /// 新增产品类别 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool AddProductclass(Mproductclass model) { //// sql语句 string sql = "INSERT INTO productclass(supclassid,classname,priority,isDelete,isEffective,great_time,modify_time,imgpath) " + "VALUES (?supclassid,?classname,?priority,?isDelete,?isEffective,?great_time,?modify_time,?imgpath)"; List <MySqlParameter> parameterList = new List <MySqlParameter>(); MySqlParameter parameter = new MySqlParameter("?supclassid", MySqlDbType.Int32); parameter.Value = model.supclassid; parameterList.Add(parameter); parameter = new MySqlParameter("?classname", MySqlDbType.VarChar, 50); parameter.Value = model.classname; parameterList.Add(parameter); parameter = new MySqlParameter("?priority", MySqlDbType.Int32); parameter.Value = model.priority; parameterList.Add(parameter); parameter = new MySqlParameter("?isDelete", MySqlDbType.Int16, 1); parameter.Value = model.isDelete; parameterList.Add(parameter); parameter = new MySqlParameter("?isEffective", MySqlDbType.Int16, 1); parameter.Value = model.isEffective; parameterList.Add(parameter); DateTime dateTime = System.DateTime.Now; parameter = new MySqlParameter("?great_time", MySqlDbType.DateTime); parameter.Value = dateTime; parameterList.Add(parameter); parameter = new MySqlParameter("?modify_time", MySqlDbType.DateTime); parameter.Value = dateTime; parameterList.Add(parameter); parameter = new MySqlParameter("?imgpath", MySqlDbType.VarChar, 255); parameter.Value = model.imgpath; parameterList.Add(parameter); //// 执行操作 return(PKMySqlHelper.ExecuteNonQuery(sql, parameterList.ToArray()) > 0); }
/// <summary> /// 编辑产品类别 /// </summary> /// <param name="model"></param> /// <returns></returns> public string EditProductclass(Mproductclass model, HttpPostedFileBase productimgurl, string path) { MwxResult mwxResult = new MwxResult() { errcode = -1 }; try { //// 数据合法性检查 if (model == null || model.classid < 1 || string.IsNullOrEmpty(model.classname)) { mwxResult.errmsg = "操作失败,新增数据不能为空!"; } if (productimgurl != null) { string savePath = string.Empty; string fileSave = FileOpert.UploadImg(productimgurl, path + "uploadFile\\" + System.DateTime.Now.ToString("yyyy") + "\\", out savePath); if (string.IsNullOrEmpty(fileSave)) { model.imgpath = savePath.Replace(path, ""); } } //// 数据落地入库 if (!new ProductclassService().EditProductclass(model)) { mwxResult.errmsg = "操作失败"; } else { mwxResult.errcode = 0; mwxResult.errmsg = "操作成功"; CacheData.allProductClass = null; } } catch (Exception ex) { mwxResult.errmsg = "操作失败:系统异常!"; } return(JsonHelper.GetJson <MwxResult>(mwxResult)); }
/// <summary> /// 产品类别编辑页面 /// </summary> /// <returns></returns> public ActionResult EditProductclass(string classid) { if (!base.CheckIsLogin()) { return(RedirectToAction("Index", "Login")); } int id = 0; int.TryParse(classid, out id); ViewData["AllPersonClass"] = new ProductBus().GetProductclassesBySupclassid(0); Mproductclass model = new ProductBus().GetMproductclassById(id); if (model == null) { model = new Mproductclass(); } return(View(model)); }
/// <summary> /// 编辑产品类别 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool EditProductclass(Mproductclass model) { //// sql语句 string sql = "update productclass set supclassid=?supclassid, classname=?classname,priority=?priority ,modify_time=?modify_time"; if (!string.IsNullOrEmpty(model.imgpath)) { sql = sql + ",imgpath=?imgpath "; } sql = sql + " where classid=?classid;"; List <MySqlParameter> parameterList = new List <MySqlParameter>(); MySqlParameter parameter = new MySqlParameter("?classid", MySqlDbType.Int32); parameter.Value = model.classid; parameterList.Add(parameter); parameter = new MySqlParameter("?supclassid", MySqlDbType.Int32); parameter.Value = model.supclassid; parameterList.Add(parameter); parameter = new MySqlParameter("?classname", MySqlDbType.VarChar, 50); parameter.Value = model.classname; parameterList.Add(parameter); parameter = new MySqlParameter("?priority", MySqlDbType.Int32); parameter.Value = model.priority; parameterList.Add(parameter); parameter = new MySqlParameter("?modify_time", MySqlDbType.DateTime); parameter.Value = System.DateTime.Now; parameterList.Add(parameter); parameter = new MySqlParameter("?imgpath", MySqlDbType.VarChar, 255); parameter.Value = model.imgpath; parameterList.Add(parameter); //// 执行操作 return(PKMySqlHelper.ExecuteNonQuery(sql, parameterList.ToArray()) > 0); }
/// <summary> /// 直接获取所有分类 /// </summary> /// <returns></returns> public List <Mproductclass> GetMproductclasses(int supclassid) { string sql = " SELECT classid,supclassid,classname,priority,isDelete,isEffective,great_time,modify_time,imgpath from productclass where 1=1 "; if (supclassid >= 0) { sql = sql + " and supclassid = ?supclassid "; } sql = sql + " order by priority asc;"; MySqlParameter[] parameterList = new MySqlParameter[1]; parameterList[0] = new MySqlParameter("?supclassid", MySqlDbType.Int32); parameterList[0].Value = supclassid; List <Mproductclass> listModel = null; using (MySqlDataReader sqlDataReader = PKMySqlHelper.ExecuteReader(sql, parameterList)) { if (sqlDataReader != null) { listModel = new List <Mproductclass>(); while (sqlDataReader.Read()) { Mproductclass model = new Mproductclass(); model.classid = sqlDataReader["classid"] != DBNull.Value ? Convert.ToInt32(sqlDataReader["classid"].ToString()) : 0; model.supclassid = sqlDataReader["supclassid"] != DBNull.Value ? Convert.ToInt32(sqlDataReader["supclassid"].ToString()) : 0; model.priority = sqlDataReader["priority"] != DBNull.Value ? Convert.ToInt32(sqlDataReader["priority"].ToString()) : 0; model.classname = sqlDataReader["classname"] != DBNull.Value ? sqlDataReader["classname"].ToString() : string.Empty; model.great_time = sqlDataReader["great_time"] != DBNull.Value ? Convert.ToDateTime(sqlDataReader["great_time"].ToString()) : DateTime.MinValue; model.modify_time = sqlDataReader["modify_time"] != DBNull.Value ? Convert.ToDateTime(sqlDataReader["modify_time"].ToString()) : DateTime.MinValue; model.imgpath = sqlDataReader["imgpath"] != DBNull.Value ? sqlDataReader["imgpath"].ToString() : string.Empty; listModel.Add(model); } } } return(listModel); }
/// <summary> /// 新增产品类别 /// </summary> /// <param name="model"></param> /// <returns></returns> public string AddProductclasses(Mproductclass model, HttpPostedFileBase productimgurl, string path) { MwxResult mwxResult = new MwxResult() { errcode = -1 }; try { //// 数据合法性检查 if (model == null || string.IsNullOrEmpty(model.classname)) { mwxResult.errmsg = "操作失败,新增数据不能为空!"; } if (productimgurl == null) { mwxResult.errmsg = "图片不能为空!"; return(JsonHelper.GetJson <MwxResult>(mwxResult)); } string savePath = string.Empty; //// 存图片 string fileSave = FileOpert.UploadImg(productimgurl, path + "uploadFile\\" + System.DateTime.Now.ToString("yyyy") + "\\", out savePath); if (string.IsNullOrEmpty(fileSave)) { model.imgpath = savePath.Replace(path, ""); } else { //// 构建错误信息并返回 mwxResult.errmsg = fileSave; return(JsonHelper.GetJson <MwxResult>(mwxResult)); } //// 时间相关参数赋值 model.great_time = System.DateTime.Now; model.modify_time = model.great_time; model.isDelete = 0; model.isEffective = 1; //// 数据落地入库 if (!new ProductclassService().AddProductclass(model)) { mwxResult.errmsg = "操作失败"; } else { mwxResult.errcode = 0; mwxResult.errmsg = "操作成功"; CacheData.allProductClass = null; } } catch (Exception ex) { mwxResult.errmsg = "操作失败:系统异常!"; } return(JsonHelper.GetJson <MwxResult>(mwxResult)); }
/// <summary> /// 编辑产品类别 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool EditProductclass(Mproductclass model) { return(opertService.EditProductclass(model)); }
/// <summary> /// 新增产品类别 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool AddProductclass(Mproductclass model) { return(opertService.AddProductclass(model)); }