/// <summary> /// 修改送货信息 /// </summary> /// <param name="model">model</param> /// <returns></returns> public bool ChangSndGoodsUserInfor(MsendGoodsUser model) { //// sql语句 string sql = "update sendGoodsUser set userName = ?userName,phone=?phone,sex=?sex where id = ?id"; List <MySqlParameter> parameterList = new List <MySqlParameter>(); MySqlParameter parameter = new MySqlParameter("?userName", MySqlDbType.VarChar, 500); parameter.Value = Base64.EncodeBase64(model.userName); parameterList.Add(parameter); parameter = new MySqlParameter("?phone", MySqlDbType.VarChar, 50); parameter.Value = model.phone; parameterList.Add(parameter); parameter = new MySqlParameter("?sex", MySqlDbType.Int16, 1); parameter.Value = model.sex; parameterList.Add(parameter); parameter = new MySqlParameter("?id", MySqlDbType.VarChar, 25); parameter.Value = model.id; parameterList.Add(parameter); //// 执行操作 return(PKMySqlHelper.ExecuteNonQuery(sql, parameterList.ToArray()) > 0); }
/// <summary> /// 根据商品的上下架状态 /// </summary> /// <param name="productid"></param> /// <param name="shelfstate"></param> /// <returns></returns> public bool UpdateProductShelfstate(string productid, int shelfstate) { string sql = string.Empty; if (shelfstate == 9999) { sql = "update product set shelfstate=-shelfstate where productid=?productid;"; } else { sql = "update product set shelfstate=?shelfstate where productid=?productid;"; } List <MySqlParameter> parameterList = new List <MySqlParameter>(); MySqlParameter parameter = new MySqlParameter("?shelfstate", MySqlDbType.Int32); parameter.Value = shelfstate; parameterList.Add(parameter); parameter = new MySqlParameter("?productid", MySqlDbType.VarChar, 25); parameter.Value = productid; parameterList.Add(parameter); //// 执行操作 return(PKMySqlHelper.ExecuteNonQuery(sql, parameterList.ToArray()) > 0); }
/// <summary> /// 新增 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool Add(Mcoupon model) { //// sql语句 string sql = "INSERT INTO coupon (id,name,price,consumAmount,effectiveStart,effectiveEnd,creatCount,useCount,isDelete,isEffective,great_time,modify_time) " + "VALUES (?id,?name,?price,?consumAmount,?effectiveStart,?effectiveEnd,?creatCount,?useCount,?isDelete,?isEffective,?great_time,?modify_time)"; List <MySqlParameter> parameterList = GetMySqlParameterListByModel(model); //// 执行操作 return(PKMySqlHelper.ExecuteNonQuery(sql, parameterList.ToArray()) > 0); }
/// <summary> /// 新增微信菜单 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool AddWxmenu(Mwxmenu model) { //// sql语句 string sql = "INSERT INTO wxmenu(id,superId,menuName,type,url,sortNum,isDelete,isEffective,great_time,modify_time) " + "VALUES (?id,?superId,?menuName,?type,?url,?sortNum,?isDelete,?isEffective,?great_time,?modify_time)"; List <MySqlParameter> parameterList = GetMySqlParameterListByModel(model); //// 执行操作 return(PKMySqlHelper.ExecuteNonQuery(sql, parameterList.ToArray()) > 0); }
/// <summary> /// 新增 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool AddNews(Mnews model) { //// sql语句 string sql = "INSERT INTO news (id,type,title,`value`,isDelete,isEffective,great_time,modify_time,img,url,sortNum) " + "VALUES (?id,?type,?title,?value,?isDelete,?isEffective,?great_time,?modify_time,?img,?url,?sortNum)"; List<MySqlParameter> parameterList = GetMySqlParameterListByModel(model); //// 执行操作 return PKMySqlHelper.ExecuteNonQuery(sql, parameterList.ToArray()) > 0; }
/// <summary> /// 新增微信用户 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool AddWXuser(MWXUserInfo model) { //// sql语句 string sql = "INSERT INTO wxuser(wxuserid,subscribe,openid,nickname,sex,sexdes,city,country,province,language,headimgurl,subscribe_time,remark,tagid_list,subscribe_scene,subscribe_scene_des,isDelete,isEffective,great_time,modify_time) " + "VALUES (?wxuserid,?subscribe,?openid,?nickname,?sex,?sexdes,?city,?country,?province,?language,?headimgurl,?subscribe_time,?remark,?tagid_list,?subscribe_scene,?subscribe_scene_des,?isDelete,?isEffective,?great_time,?modify_time)"; List <MySqlParameter> parameterList = GetMySqlParameterListByModel(model); //// 执行操作 return(PKMySqlHelper.ExecuteNonQuery(sql, parameterList.ToArray()) > 0); }
/// <summary> /// 根据ID删除微信才菜单 /// </summary> /// <param name="productid"></param> /// <returns></returns> public bool DeleteNews(string id) { string sql = "delete from news where id=?id;"; List<MySqlParameter> parameterList = new List<MySqlParameter>(); MySqlParameter parameter = new MySqlParameter("?id", MySqlDbType.VarChar, 25); parameter.Value = id; parameterList.Add(parameter); //// 执行操作 return PKMySqlHelper.ExecuteNonQuery(sql, parameterList.ToArray()) > 0; }
/// <summary> /// 根据ID删除 /// </summary> /// <param name="productid"></param> /// <returns></returns> public bool Delete(string id) { string sql = "update coupon set isDelete=1 where id=?id;"; List <MySqlParameter> parameterList = new List <MySqlParameter>(); MySqlParameter parameter = new MySqlParameter("?id", MySqlDbType.VarChar, 25); parameter.Value = id; parameterList.Add(parameter); //// 执行操作 return(PKMySqlHelper.ExecuteNonQuery(sql, parameterList.ToArray()) > 0); }
/// <summary> /// 根据ID删除一个产品信息 /// </summary> /// <param name="productid"></param> /// <returns></returns> public bool DeleteProduct(string productid) { string sql = "update product set isDelete=1 where productid=?productid;delete from shoppingCart where productId=?productid"; List <MySqlParameter> parameterList = new List <MySqlParameter>(); MySqlParameter parameter = new MySqlParameter("?productid", MySqlDbType.VarChar, 25); parameter.Value = productid; parameterList.Add(parameter); //// 执行操作 return(PKMySqlHelper.ExecuteNonQuery(sql, parameterList.ToArray()) > 0); }
/// <summary> /// 删除用户信息 /// </summary> /// <param name="adminuserid"></param> /// <returns></returns> public bool DeleteAdminUser(string adminuserid) { //// sql语句 string sql = "delete from adminuser where adminuserid=?adminuserid"; List <MySqlParameter> parameterList = new List <MySqlParameter>(); MySqlParameter parameter = new MySqlParameter("?adminuserid", MySqlDbType.VarChar, 25); parameter.Value = adminuserid; parameterList.Add(parameter); //// 执行操作 return(PKMySqlHelper.ExecuteNonQuery(sql, parameterList.ToArray()) > 0); }
/// <summary> /// 新增管理员 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool AddAdminUser(Madminuser model) { //// sql语句 string sql = "INSERT INTO adminuser (adminuserid,account,name,password,sex,isDelete,isEffective,great_time,modify_time) " + "VALUES(?adminuserid, ?account, ?name, ?password, ?sex, ?isDelete, ?isEffective, ?great_time, ?modify_time)"; List <MySqlParameter> parameterList = new List <MySqlParameter>(); MySqlParameter parameter = new MySqlParameter("?adminuserid", MySqlDbType.VarChar, 25); parameter.Value = model.adminuserid; parameterList.Add(parameter); parameter = new MySqlParameter("?account", MySqlDbType.VarChar, 50); parameter.Value = model.account; parameterList.Add(parameter); parameter = new MySqlParameter("?name", MySqlDbType.VarChar, 50); parameter.Value = model.name; parameterList.Add(parameter); parameter = new MySqlParameter("?password", MySqlDbType.VarChar, 50); parameter.Value = model.password; parameterList.Add(parameter); parameter = new MySqlParameter("?sex", MySqlDbType.Int16, 1); parameter.Value = model.sex; 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); //// 执行操作 return(PKMySqlHelper.ExecuteNonQuery(sql, parameterList.ToArray()) > 0); }
/// <summary> /// 根据id删除购物车信息 /// </summary> /// <param name="shoppingCartId"></param> /// <returns></returns> public bool DeleteShoppingCartById(string[] shoppingCartId, string userId) { string sql = "delete from shoppingCart where shoppingCartId in ?shoppingCartId and userId=?userId;"; List <MySqlParameter> parameterList = new List <MySqlParameter>(); MySqlParameter parameter = new MySqlParameter("?shoppingCartId", MySqlDbType.VarChar, 25); parameter.Value = "'" + string.Join("','", shoppingCartId) + "'"; parameterList.Add(parameter); parameter = new MySqlParameter("?userId", MySqlDbType.VarChar, 25); parameter.Value = userId; parameterList.Add(parameter); //// 执行操作 return(PKMySqlHelper.ExecuteNonQuery(sql, parameterList.ToArray()) > 0); }
/// <summary> /// 更新商品的是否推荐 /// </summary> /// <param name="productid"></param> /// <param name="recommend"></param> /// <returns></returns> public bool UpdateProductRecommend(string productid, int recommend) { string sql = "update product set recommend=?recommend where productid=?productid;"; List <MySqlParameter> parameterList = new List <MySqlParameter>(); MySqlParameter parameter = new MySqlParameter("?recommend", MySqlDbType.Int32); parameter.Value = recommend; parameterList.Add(parameter); parameter = new MySqlParameter("?productid", MySqlDbType.VarChar, 25); parameter.Value = productid; parameterList.Add(parameter); //// 执行操作 return(PKMySqlHelper.ExecuteNonQuery(sql, parameterList.ToArray()) > 0); }
/// <summary> /// 删除邮寄地址 /// </summary> /// <param name="userId"></param> /// <param name="addressId"></param> /// <returns></returns> public bool DeleteMailAddress(string userId, string addressId) { string sql = "delete mailAddress set where userId=?userId and addressId=?addressId; "; List <MySqlParameter> parameterList = new List <MySqlParameter>(); MySqlParameter parameter = new MySqlParameter("?userId", MySqlDbType.VarChar, 25); parameter.Value = userId; parameterList.Add(parameter); parameter = new MySqlParameter("?addressId", MySqlDbType.VarChar, 25); parameter.Value = addressId; parameterList.Add(parameter); //// 执行操作 return(PKMySqlHelper.ExecuteNonQuery(sql, parameterList.ToArray()) > 0); }
/// <summary> /// 删除商品分类 /// </summary> /// <param name="classid"></param> /// <returns></returns> public bool DeleteProductclass(int classid, int supclassid) { ///// 实现步骤 //// 1、首先根据classid到产品表中查询是否有数据 //// 2、如果查询到数据,那么不允许删除 //// 3、如果没查询到数据,那么直接删除其第一的类以及其子类 //// 说明删除主分类 int hasThisClassProductNum = 0; if (supclassid == 0) { hasThisClassProductNum = new ProductDal().CetProductBySupClassid(supclassid); } else { hasThisClassProductNum = new ProductDal().CetProductByClassid(classid); } if (hasThisClassProductNum > 0) { return(false); } //// sql语句 string sql = string.Empty; if (supclassid == 0) { //// sql语句 删除其本身子分类 sql = "delete from productclass where supclassid=?classid or classid=?classid"; } else { //// 删除自己 sql = "delete from productclass where classid=?classid"; } MySqlParameter[] parameterList = new MySqlParameter[1]; parameterList[0] = new MySqlParameter("?classid", MySqlDbType.Int32); parameterList[0].Value = classid; //// 执行操作 return(PKMySqlHelper.ExecuteNonQuery(sql, parameterList) > 0); }
/// <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 bool AddSndGoodsUser(MsendGoodsUser model) { //// sql语句 string sql = "INSERT INTO sendGoodsUser (id,userName,sex,phone,isDelete,isEffective,great_time,modify_time) " + "VALUES(?id, ?userName,?sex, ?phone, ?isDelete, ?isEffective, ?great_time, ?modify_time)"; List <MySqlParameter> parameterList = new List <MySqlParameter>(); MySqlParameter parameter = new MySqlParameter("?id", MySqlDbType.VarChar, 25); parameter.Value = model.id; parameterList.Add(parameter); parameter = new MySqlParameter("?userName", MySqlDbType.VarChar, 500); parameter.Value = Base64.EncodeBase64(model.userName); parameterList.Add(parameter); parameter = new MySqlParameter("?phone", MySqlDbType.VarChar, 50); parameter.Value = model.phone; parameterList.Add(parameter); parameter = new MySqlParameter("?sex", MySqlDbType.Int16, 1); parameter.Value = model.sex; 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); //// 执行操作 return(PKMySqlHelper.ExecuteNonQuery(sql, parameterList.ToArray()) > 0); }
/// <summary> /// 修改密码 /// </summary> /// <param name="adminuserid"></param> /// <param name="newPass"></param> /// <returns></returns> public bool ChangAdminUserPass(string adminuserid, string newPass) { //// sql语句 string sql = "update adminuser set password = ?password where adminuserid = ?adminuserid"; List <MySqlParameter> parameterList = new List <MySqlParameter>(); MySqlParameter parameter = new MySqlParameter("?password", MySqlDbType.VarChar, 50); parameter.Value = newPass; parameterList.Add(parameter); parameter = new MySqlParameter("?adminuserid", MySqlDbType.VarChar, 25); parameter.Value = adminuserid; parameterList.Add(parameter); //// 执行操作 return(PKMySqlHelper.ExecuteNonQuery(sql, parameterList.ToArray()) > 0); }
/// <summary> /// 根据id获取openId更新用户信息 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool UpdateWXUserInfo(MWXUserInfo model) { string sql = "update wxuser set subscribe=?subscribe,nickname=?nickname,sex=?sex,sexdes=?sexdes,city=?city,country=?country,province=?province,language=?language,headimgurl=?headimgurl,tagid_list=?tagid_list,subscribe_scene=?subscribe_scene,subscribe_scene_des=?subscribe_scene_des,qr_scene_str=?qr_scene_str,qr_scene=?qr_scene where 1=1 "; if (!string.IsNullOrEmpty(model.wxuserid)) { sql = sql + " and wxuserid=?wxuserid"; } if (!string.IsNullOrEmpty(model.openid)) { sql = sql + " and openid=?openid"; } List <MySqlParameter> parameterList = GetMySqlParameterListByModel(model); return(PKMySqlHelper.ExecuteNonQuery(sql, parameterList.ToArray()) > 0); }
/// <summary> /// 更新用户的默认地址 /// </summary> /// <param name="userId"></param> /// <param name="addressId"></param> /// <returns></returns> public bool UpdateMailAddressDefault(string userId, string addressId) { //// 首先清空默认地址,然后在将需要设置的默认地址数据设置为默认地址 string sql = "update mailAddress set isDefault=0 where userId=?userId;update mailAddress set isDefault=1 where userId=?userId and addressId=?addressId; "; List <MySqlParameter> parameterList = new List <MySqlParameter>(); MySqlParameter parameter = new MySqlParameter("?userId", MySqlDbType.VarChar, 25); parameter.Value = userId; parameterList.Add(parameter); parameter = new MySqlParameter("?addressId", MySqlDbType.VarChar, 25); parameter.Value = addressId; parameterList.Add(parameter); //// 执行操作 return(PKMySqlHelper.ExecuteNonQuery(sql, parameterList.ToArray()) > 0); }
/// <summary> /// 根据id更新新闻信息 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool UpdateNews(Mnews model) { string sql = "update news set title=?title,value=?value where id=?id "; List<MySqlParameter> parameterList = new List<MySqlParameter>(); MySqlParameter parameter = new MySqlParameter("?id", MySqlDbType.VarChar, 25); parameter.Value = model.id; parameterList.Add(parameter); parameter = new MySqlParameter("?title", MySqlDbType.VarChar, 100); parameter.Value = model.title; parameterList.Add(parameter); parameter = new MySqlParameter("?value", MySqlDbType.Text); parameter.Value = model.value; parameterList.Add(parameter); return PKMySqlHelper.ExecuteNonQuery(sql, parameterList.ToArray()) > 0; }
/// <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> /// <param name="shoppingCartId"></param> /// <param name="origPrice"></param> /// <param name="sellPrice"></param> /// <param name="totalPrice"></param> /// <param name="buyNum"></param> /// <returns></returns> public bool UpdatePriceAndNum(string shoppingCartId, string userId, decimal origPrice, decimal sellPrice, decimal totalPrice, int buyNum) { string sql = "update shoppingCart set origPrice=?origPrice, sellPrice=?sellPrice, totalPrice=?totalPrice "; if (buyNum != 0) { sql = sql + ",buyNum=buyNum+?buyNum "; } sql = sql + " where shoppingCartId=?shoppingCartId and userId=?userId;"; List <MySqlParameter> parameterList = new List <MySqlParameter>(); MySqlParameter parameter = new MySqlParameter("?shoppingCartId", MySqlDbType.VarChar, 25); parameter.Value = shoppingCartId; parameterList.Add(parameter); parameter = new MySqlParameter("?userId", MySqlDbType.VarChar, 25); parameter.Value = userId; parameterList.Add(parameter); parameter = new MySqlParameter("?buyNum", MySqlDbType.Int32); parameter.Value = buyNum; parameterList.Add(parameter); parameter = new MySqlParameter("?origPrice", MySqlDbType.Decimal); parameter.Value = origPrice; parameterList.Add(parameter); parameter = new MySqlParameter("?sellPrice", MySqlDbType.Decimal); parameter.Value = sellPrice; parameterList.Add(parameter); parameter = new MySqlParameter("?totalPrice", MySqlDbType.Decimal); parameter.Value = totalPrice; parameterList.Add(parameter); //// 执行操作 return(PKMySqlHelper.ExecuteNonQuery(sql, parameterList.ToArray()) > 0); }
/// <summary> /// 修改用户信息 /// </summary> /// <param name="model">model</param> /// <returns></returns> public bool ChangAdminUserInfor(Madminuser model) { //// sql语句 string sql = "update adminuser set name = ?name,sex=?sex where adminuserid = ?adminuserid"; List <MySqlParameter> parameterList = new List <MySqlParameter>(); MySqlParameter parameter = new MySqlParameter("?name", MySqlDbType.VarChar, 50); parameter.Value = model.name; parameterList.Add(parameter); parameter = new MySqlParameter("?sex", MySqlDbType.Int16, 1); parameter.Value = model.sex; parameterList.Add(parameter); parameter = new MySqlParameter("?adminuserid", MySqlDbType.VarChar, 25); parameter.Value = model.adminuserid; parameterList.Add(parameter); //// 执行操作 return(PKMySqlHelper.ExecuteNonQuery(sql, parameterList.ToArray()) > 0); }
/// <summary> /// 更新菜单信息 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool UpdateWxmenu(Mwxmenu model) { string sql = "update wxmenu set menuName=?menuName,url=?url,sortNum=?sortNum where id=?id;"; List <MySqlParameter> parameterList = new List <MySqlParameter>(); MySqlParameter parameter = new MySqlParameter("?id", MySqlDbType.VarChar, 25); parameter.Value = model.id; parameterList.Add(parameter); parameter = new MySqlParameter("?sortNum", MySqlDbType.VarChar, 25); parameter.Value = model.sortNum; parameterList.Add(parameter); parameter = new MySqlParameter("?menuName", MySqlDbType.VarChar, 50); parameter.Value = model.menuName; parameterList.Add(parameter); parameter = new MySqlParameter("?url", MySqlDbType.VarChar, 1000); parameter.Value = model.url; parameterList.Add(parameter); //// 执行操作 return(PKMySqlHelper.ExecuteNonQuery(sql, parameterList.ToArray()) > 0); }
/// <summary> /// 新增产品类别 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool AddProduct(Mproduct model) { //// sql语句 string sql = "INSERT INTO product(productid,classid,supclassid,className,supclassName,productname,productformat,productformatunit,origprice,sellprice,stock,shelfstate,hassellnum,productdetails,productimgurl,priority,isDelete,isEffective,great_time,modify_time,recommend) " + "VALUES (?productid,?classid,?supclassid,(select classname from productclass where classid=?classid),(select classname from productclass where classid=?supclassid),?productname,?productformat,?productformatunit,?origprice,?sellprice,?stock,?shelfstate,?hassellnum,?productdetails,?productimgurl,?priority,?isDelete,?isEffective,?great_time,?modify_time,recommend)"; List <MySqlParameter> parameterList = new List <MySqlParameter>(); MySqlParameter parameter = new MySqlParameter("?productid", MySqlDbType.VarChar, 25); parameter.Value = model.productid; parameterList.Add(parameter); 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("?productname", MySqlDbType.VarChar, 100); parameter.Value = model.productname; parameterList.Add(parameter); parameter = new MySqlParameter("?productformat", MySqlDbType.VarChar, 20); parameter.Value = model.productformat; parameterList.Add(parameter); parameter = new MySqlParameter("?productformatunit", MySqlDbType.VarChar, 50); parameter.Value = model.productformatunit; parameterList.Add(parameter); parameter = new MySqlParameter("?origprice", MySqlDbType.Decimal); parameter.Value = model.origprice; parameterList.Add(parameter); parameter = new MySqlParameter("?sellprice", MySqlDbType.Decimal); parameter.Value = model.sellprice; parameterList.Add(parameter); parameter = new MySqlParameter("?stock", MySqlDbType.Int32); parameter.Value = model.stock; parameterList.Add(parameter); parameter = new MySqlParameter("?shelfstate", MySqlDbType.Int32); parameter.Value = model.shelfstate; parameterList.Add(parameter); parameter = new MySqlParameter("?hassellnum", MySqlDbType.Int32); parameter.Value = 0; parameterList.Add(parameter); parameter = new MySqlParameter("?productdetails", MySqlDbType.Text); parameter.Value = model.productdetails; parameterList.Add(parameter); parameter = new MySqlParameter("?productimgurl", MySqlDbType.VarChar, 100); parameter.Value = model.productimgurl; parameterList.Add(parameter); parameter = new MySqlParameter("?priority", MySqlDbType.Int32); parameter.Value = model.priority; parameterList.Add(parameter); parameter = new MySqlParameter("?isDelete", MySqlDbType.Int32); parameter.Value = 0; parameterList.Add(parameter); parameter = new MySqlParameter("?isEffective", MySqlDbType.Int32); parameter.Value = 1; 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("?recommend", MySqlDbType.Int32); parameter.Value = model.recommend; parameterList.Add(parameter); //// 执行操作 return(PKMySqlHelper.ExecuteNonQuery(sql, parameterList.ToArray()) > 0); }
/// <summary> /// 根据产品的价格、库存信息 /// </summary> /// <param name="productid"></param> /// <param name="origprice"></param> /// <param name="sellprice"></param> /// <param name="stock"></param> /// <returns></returns> public bool UpdateProdctPrice(string productid, decimal origprice, decimal sellprice, int stock, int priority, Mproduct mproduct) { string sql = "update product set "; if (origprice > 0) { sql = sql + " origprice = ?origprice,"; } if (sellprice > 0) { sql = sql + " sellprice = ?sellprice,"; } if (stock >= 0) { sql = sql + " stock = ?stock,"; } if (priority > 0) { sql = sql + " priority = ?priority,"; } if (!string.IsNullOrEmpty(mproduct.productimgurl)) { sql = sql + " productimgurl = ?productimgurl,"; } if (mproduct.supclassid > 0) { sql = sql + " supclassid = " + mproduct.supclassid + ","; sql = sql + " supclassName = (select classname from productclass where classid=" + mproduct.supclassid + "),"; } if (mproduct.classid > 0) { sql = sql + " classid = " + mproduct.classid + ","; sql = sql + " className = (select classname from productclass where classid=" + mproduct.classid + "),"; } if (!string.IsNullOrEmpty(mproduct.productname)) { sql = sql + " productname = ?productname,"; } sql = sql + " productformat = ?productformat,"; sql = sql + " productformatunit = ?productformatunit,"; sql = sql + " origprice = ?origprice,"; sql = sql + " sellprice = ?sellprice,"; sql = sql + " stock = ?stock,"; sql = sql + " shelfstate = ?shelfstate,"; sql = sql + " priority = ?priority,"; sql = sql + " productdetails = ?productdetails,"; sql = sql.TrimEnd(',') + " where productid=?productid;"; List <MySqlParameter> parameterList = new List <MySqlParameter>(); MySqlParameter parameter = new MySqlParameter("?productid", MySqlDbType.VarChar, 25); parameter.Value = productid; parameterList.Add(parameter); parameter = new MySqlParameter("?origprice", MySqlDbType.Decimal); parameter.Value = origprice; parameterList.Add(parameter); parameter = new MySqlParameter("?sellprice", MySqlDbType.Decimal); parameter.Value = sellprice; parameterList.Add(parameter); parameter = new MySqlParameter("?stock", MySqlDbType.Int32); parameter.Value = stock; parameterList.Add(parameter); parameter = new MySqlParameter("?productformat", MySqlDbType.VarChar, 20); parameter.Value = mproduct.productformat; parameterList.Add(parameter); parameter = new MySqlParameter("?productformatunit", MySqlDbType.VarChar, 50); parameter.Value = mproduct.productformatunit; parameterList.Add(parameter); parameter = new MySqlParameter("?shelfstate", MySqlDbType.Int32); parameter.Value = mproduct.shelfstate; parameterList.Add(parameter); parameter = new MySqlParameter("?productdetails", MySqlDbType.Text); parameter.Value = mproduct.productdetails; parameterList.Add(parameter); parameter = new MySqlParameter("?productimgurl", MySqlDbType.VarChar, 100); parameter.Value = mproduct.productimgurl; parameterList.Add(parameter); parameter = new MySqlParameter("?priority", MySqlDbType.Int32); parameter.Value = mproduct.priority; parameterList.Add(parameter); parameter = new MySqlParameter("?productname", MySqlDbType.VarChar, 100); parameter.Value = mproduct.productname; parameterList.Add(parameter); //// 执行操作 return(PKMySqlHelper.ExecuteNonQuery(sql, parameterList.ToArray()) > 0); }
/// <summary> /// 使用优惠券 /// </summary> /// <param name="id"></param> /// <param name="orderId"></param> /// <returns></returns> public int UseCoupon(string id, string orderId) { string sql = $"update usercoupon set isUse=1,orderId='{orderId}',useTime='{System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")}',modify_time='{System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")}' where id='{id}'"; return(PKMySqlHelper.ExecuteNonQuery(sql)); }
/// <summary> /// 新增地址 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool AddMailAddress(MmailAddress model) { //// sql语句 string sql = ""; if (model.isDefault == "1") { sql = "update mailAddress set isDefault=0 where userId=?userId;"; } sql += "INSERT INTO mailAddress (addressId,userId,userName,province,city,area,detailedAddress,contactName,contactTell,isDefault,isDelete,isEffective,great_time,modify_time) " + "VALUES(?addressId,?userId,?userName,?province,?city,?area,?detailedAddress,?contactName,?contactTell,?isDefault,?isDelete,?isEffective,?great_time,?modify_time)"; List <MySqlParameter> parameterList = new List <MySqlParameter>(); MySqlParameter parameter = new MySqlParameter("?addressId", MySqlDbType.VarChar, 25); parameter.Value = model.addressId; parameterList.Add(parameter); parameter = new MySqlParameter("?userId", MySqlDbType.VarChar, 25); parameter.Value = model.userId; parameterList.Add(parameter); parameter = new MySqlParameter("?userName", MySqlDbType.VarChar, 500); parameter.Value = Base64.EncodeBase64(model.userName); parameterList.Add(parameter); parameter = new MySqlParameter("?province", MySqlDbType.VarChar, 30); parameter.Value = string.IsNullOrEmpty(model.province)?"": model.province; parameterList.Add(parameter); parameter = new MySqlParameter("?city", MySqlDbType.VarChar, 30); parameter.Value = string.IsNullOrEmpty(model.city) ? "" : model.city; parameterList.Add(parameter); parameter = new MySqlParameter("?area", MySqlDbType.VarChar, 30); parameter.Value = string.IsNullOrEmpty(model.area) ? "" : model.area; parameterList.Add(parameter); parameter = new MySqlParameter("?detailedAddress", MySqlDbType.VarChar, 200); parameter.Value = model.detailedAddress; parameterList.Add(parameter); parameter = new MySqlParameter("?contactName", MySqlDbType.VarChar, 30); parameter.Value = model.contactName; parameterList.Add(parameter); parameter = new MySqlParameter("?contactTell", MySqlDbType.VarChar, 20); parameter.Value = model.contactTell; parameterList.Add(parameter); parameter = new MySqlParameter("?isDefault", MySqlDbType.Int16, 1); parameter.Value = model.isDefault; parameterList.Add(parameter); parameter = new MySqlParameter("?isDelete", MySqlDbType.Int16, 1); parameter.Value = 0; parameterList.Add(parameter); parameter = new MySqlParameter("?isEffective", MySqlDbType.Int16, 1); parameter.Value = 1; 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); //// 执行操作 return(PKMySqlHelper.ExecuteNonQuery(sql, parameterList.ToArray()) > 0); }
/// <summary> /// 新增订单 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool Add(MshoppingCart model) { //// sql语句 string sql = "INSERT INTO shoppingCart (shoppingCartId,userId,userName,productId,productname,productformat,buyNum,origPrice,sellPrice,totalPrice,isDelete,isEffective,great_time,modify_time) " + "VALUES(?shoppingCartId, ?userId, ?userName, ?productId, ?productname, ?productformat, ?buyNum, ?origPrice, ?sellPrice, ?totalPrice, ?isDelete, ?isEffective, ?great_time, ?modify_time)"; List <MySqlParameter> parameterList = new List <MySqlParameter>(); MySqlParameter parameter = new MySqlParameter("?shoppingCartId", MySqlDbType.VarChar, 25); parameter.Value = model.shoppingCartId; parameterList.Add(parameter); parameter = new MySqlParameter("?userId", MySqlDbType.VarChar, 25); parameter.Value = model.userId; parameterList.Add(parameter); parameter = new MySqlParameter("?userName", MySqlDbType.VarChar, 500); parameter.Value = Base64.EncodeBase64(model.userName); parameterList.Add(parameter); parameter = new MySqlParameter("?productId", MySqlDbType.VarChar, 25); parameter.Value = model.productId; parameterList.Add(parameter); parameter = new MySqlParameter("?productname", MySqlDbType.VarChar, 100); parameter.Value = model.productname; parameterList.Add(parameter); parameter = new MySqlParameter("?productformat", MySqlDbType.VarChar, 50); parameter.Value = model.productformat; parameterList.Add(parameter); parameter = new MySqlParameter("?buyNum", MySqlDbType.Int32); parameter.Value = model.buyNum; parameterList.Add(parameter); parameter = new MySqlParameter("?origPrice", MySqlDbType.Decimal); parameter.Value = model.origPrice; parameterList.Add(parameter); parameter = new MySqlParameter("?sellPrice", MySqlDbType.Decimal); parameter.Value = model.sellPrice; parameterList.Add(parameter); parameter = new MySqlParameter("?totalPrice", MySqlDbType.Decimal); parameter.Value = model.totalPrice; parameterList.Add(parameter); parameter = new MySqlParameter("?isDelete", MySqlDbType.Int16, 1); parameter.Value = 0; parameterList.Add(parameter); parameter = new MySqlParameter("?isEffective", MySqlDbType.Int16, 1); parameter.Value = 1; 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); //// 执行操作 return(PKMySqlHelper.ExecuteNonQuery(sql, parameterList.ToArray()) > 0); }