public UnitedReturn UpdateUser(long id, object data) { UserInfo um = new UserInfo(); if (data.ToString() != "System.object" && data.ToString() != "1") { um = JsonConvert.DeserializeObject <UserInfo>(JsonConvert.SerializeObject(data)); } string sql = $"update UserInfo set UserName='******',UserPhoto='{um.UserPhoto}',UserSex={um.UserSex},ShopId={um.ShopId},UserNumder='{um.UserNumder}',UserAge={um.UserAge},UserIDNumber='{um.UserIDNumber}' where UserNumder='{id}'"; var res = helpx.ExecuteNonQuery(sql); UnitedReturn united = new UnitedReturn(); if (res > 0) { united.data = res; united.msg = "修改成功!"; united.res = 1; } else { united.data = null; united.msg = "修改失败!"; united.res = 0; } return(united); }
/// <summary> /// 用户登录 /// data 是统一参数值 /// UnitedReturn 是统一返回的类型 /// </summary> /// <param name="data"></param> /// <returns></returns> public UnitedReturn UserLogin(object data)//这是模板 登录重新写账号密码 此类只作为参考 { //把data转换成类的类型 UserInfo userInfo = JsonConvert.DeserializeObject <UserInfo>(data.ToString()); //sql语句 var sql = string.Format($"select u.UserName from UserInfo u where u.UserNumder='{userInfo.UserNumder}' and u.UserPass='******'"); //返回值 var res = dBHelper.ExecuteScalar(sql); UnitedReturn united = new UnitedReturn(); //如果登陆成功 给统一返回类型的model赋值 if (res != null) { //给统一返回类型的model赋值 united.data = res; //返回的数据 united.msg = "登陆成功"; //返回的字符串 united.res = 1; //返回的int值 } else { //给统一返回类型的model赋值 united.data = null; united.msg = "登陆失败"; united.res = 0; } return(united); }
/// <summary> /// 修改订单并接受返回数据 /// </summary> /// <returns></returns> public UnitedReturn UpdateOrderDataAndReturnData(object data) { UnitedReturn unitedReturn = new UnitedReturn(); if (data != null || data.ToString() != "System.object") { var info = JsonConvert.DeserializeObject <Orderform>(data.ToString()); string sql = string.Format($"update Orderform set CommodityCount={info.CommodityCount} where OrderformId={info.OrderformId}"); var res = YxDBHelper.ExecuteNonQuery(sql); string sqls = string.Format($"update UserInfo set UserName='******', UserNumder='{info.UserNumder}' where UserId='{info.UserId}'"); var ress = YxDBHelper.ExecuteNonQuery(sqls); if (res > 0 && ress > 0) { unitedReturn.data = null; unitedReturn.res = 1; unitedReturn.msg = "修改成功"; } else { unitedReturn.data = null; unitedReturn.res = 0; unitedReturn.msg = "修改失败"; } } else { unitedReturn.res = 0; } return(unitedReturn); }
/// <summary> /// 修改密码 /// </summary> /// <param name="data"></param> /// <returns></returns> public UnitedReturn UpdatePwd(object data) { UnitedReturn unitedReturn = new UnitedReturn(); if (data != null || data.ToString() != "System.object") { var info = JsonConvert.DeserializeObject <UserInfo>(data.ToString()); info.UserPass = GenerateMD5(info.UserPass); string sql = string.Format($"update UserInfo set UserPass='******' where UserName='******'"); var res = YxDBHelper.ExecuteNonQuery(sql); if (res > 0) { unitedReturn.data = null; unitedReturn.res = 1; unitedReturn.msg = "修改成功"; } else { unitedReturn.data = null; unitedReturn.res = 0; unitedReturn.msg = "修改失败"; } } else { unitedReturn.data = null; unitedReturn.res = 0; unitedReturn.msg = "修改失败"; } return(unitedReturn); }
/// <summary> /// 关闭店铺 /// </summary> /// <param name="data"></param> /// <returns></returns> public UnitedReturn UpdatShopInfo(object data) { ShopInfo Info = JsonConvert.DeserializeObject <ShopInfo>(data.ToString()); UnitedReturn united = new UnitedReturn(); if (Convert.ToInt32(data) > 0) { var sql = string.Format($"update [dbo].[ShopInfo] set ShopState=1 where ShopId='{Convert.ToInt32(data)}')"); var res = dBHelper.ExecuteNonQuery(sql); if (res > 0) { //给统一返回类型的model赋值 united.data = null; //返回的数据 united.msg = "添加成功"; //返回的字符串 united.res = 1; //返回的int值 } } else { //给统一返回类型的model赋值 united.data = null; united.msg = "添加失败"; united.res = 0; } return(united); }
/// <summary> /// 获取集合数据 /// </summary> /// <returns></returns> public UnitedReturn PersonalInformation(object data) { try { var textSql = "exec UserInfo_proc_Select"; List <UserInfo> ListT = helpX.GetToList <UserInfo>(textSql); UnitedReturn united = new UnitedReturn(); if (ListT != null && ListT.Count > 0) { united.data = ListT; united.msg = "成功!"; united.res = 1; } else { united.data = null; united.msg = "失败!"; united.res = 0; } return(united); } catch (Exception ex) { return(new UnitedReturn() { data = ex.InnerException.Message, res = -1, msg = ex.Message }); } //Ycx_Helper help = new Ycx_Helper(); ////string textSql = "exec UserInfo_proc_Select"; //List<UserInfo> list = help.Getlist<UserInfo>(textSql); //return list.ToList(); }
public UnitedReturn Add(object data) { UserInfo um = new UserInfo(); if (data.ToString() != "System.object" && data.ToString() != "1") { um = JsonConvert.DeserializeObject <UserInfo>(JsonConvert.SerializeObject(data)); } string sql = $"insert into UserInfo values('{um.UserName}','{um.UserPhoto}',{um.UserSex},{um.ShopId},'{um.UserNumder}',{um.UserAge},'{um.UserIDNumber}')"; var res = helpx.ExecuteNonQuery(sql); UnitedReturn united = new UnitedReturn(); if (res > 0) { united.data = res; united.msg = "添加成功!"; united.res = 1; } else { united.data = null; united.msg = "添加失败!"; united.res = 0; } return(united); }
/// <summary> /// 查询密码 /// </summary> /// <param name="data"></param> /// <returns></returns> public UnitedReturn UserPass(object data) { UserInfo Info = JsonConvert.DeserializeObject <UserInfo>(data.ToString()); //sql语句 var sql = string.Format($"select UserPass from UserInfo where UserNumder='{0}'", Info.UserNumder); //返回值 var res = dBHelper.ExecuteScalar(sql); UnitedReturn united = new UnitedReturn(); if (res != null) { //给统一返回类型的model赋值 united.data = res; //返回的数据 united.msg = "登陆成功"; //返回的字符串 united.res = 1; //返回的int值 } else { //给统一返回类型的model赋值 united.data = null; united.msg = "登陆失败"; united.res = 0; } return(united); }
/// <summary> /// 下架操作 /// </summary> /// <param name="data"></param> /// <returns></returns> public UnitedReturn OutCommodity(object data) { try { var sql = String.Format($"Update CommodityInfo set CommodityState=0,OutTime=GETDATE() where CommodityId='{Convert.ToInt32(data)}'"); var res = DBHelper.ExecuteNonQuery(sql); UnitedReturn united = new UnitedReturn(); if (res > 0) { united.data = null; united.msg = "已下架!"; united.res = 1; } else { united.data = null; united.msg = "下架失败!"; united.res = 0; } return(united); } catch (Exception ex) { //错误日志 log4net //1请求接口 //2请求参数 //3错误信息 //4请求时间 return(new UnitedReturn() { data = ex.InnerException.Message, res = -1, msg = ex.Message }); } }
/// <summary> /// 商品类型 /// </summary> /// <param name="data"></param> /// <returns></returns> public UnitedReturn SelCommodityType(object data) { try { var sql = String.Format($"select * from TypeInfo"); var res = DBHelper.GetToList <TypeInfo>(sql); UnitedReturn united = new UnitedReturn(); if (res != null && res.Count > 0) { united.data = res; united.msg = "成功!"; united.res = 1; } else { united.data = null; united.msg = "失败!"; united.res = 0; } return(united); } catch (Exception ex) { //错误日志 log4net //1请求接口 //2请求参数 //3错误信息 //4请求时间 return(new UnitedReturn() { data = ex.InnerException.Message, res = -1, msg = ex.Message }); } }
/// <summary> /// 手机号验证 /// </summary> /// <param name="phone"></param> /// <returns></returns> public UnitedReturn IsExistPhone(object data) { UnitedReturn united = new UnitedReturn(); if (data != null || data.ToString() != "System.object") { UserInfo Info = JsonConvert.DeserializeObject <UserInfo>(data.ToString()); string sql = string.Format("select count(*) from UserInfo where UserNumder='{0}'", Info.UserNumder); var res = Convert.ToInt32(dBHelper.ExecuteScalar(sql)); if (res > 0) { //给统一返回类型的model赋值 united.data = null; //返回的数据 united.msg = "手机号已存在"; //返回的字符串 united.res = 1; //返回的int值 } else { //给统一返回类型的model赋值 united.data = null; united.msg = "查询失败"; united.res = 0; } } else { united.res = 0; } return(united);; }
/// <summary> /// 编辑个人信息 ycx /// </summary> /// <param name="model"></param> /// <param name="id"></param> /// <returns></returns> public UnitedReturn ExitPersonalInformation(UserInfo model, int id, object data) { try { var sql = $"exec UserInfo_proc_Exit {id},'{model.UserName}','{model.UserPhoto}',{model.UserSex},{model.ShopId},'{model.UserNumder}','{model.UserAge}','{model.UserIDNumber}'"; var res = helpX.ExecuteNonQuery(sql); UnitedReturn united = new UnitedReturn(); if (res > 0) { united.data = res; united.msg = "修改成功"; united.res = 1; } else { united.data = null; united.msg = "修改失败"; united.res = 0; } return(united); } catch (Exception ex) { return(new UnitedReturn() { data = ex.InnerException.Message, res = -1, msg = ex.Message }); } //string sql = $"exec UserInfo_proc_Exit {id},'{model.UserName}','{model.UserPhoto}',{model.UserSex},{model.ShopId},'{model.UserNumder}','{model.UserAge}','{model.UserIDNumber}'"; //Ycx_Helper help = new Ycx_Helper(); //int result = help.GetLine(sql); //return result; }
public UnitedReturn SelectType(object data) { string sql = "select * from ShopInfo "; UserInfo User = new UserInfo(); //object初始值是System.object 所以判断一下 if (data.ToString() != "System.object" && data.ToString() != "1") { User = JsonConvert.DeserializeObject <UserInfo>(data.ToString()); } List <ShopInfo> list = helpx.Getlist <ShopInfo>(sql); UnitedReturn united = new UnitedReturn(); if (list.Count > 0 && list != null) { united.data = list; united.res = 1; united.msg = "获取信息成功"; } else { united.data = null; united.res = 0; united.msg = "获取信息失败"; } return(united); }
/// <summary> /// 已下架商品展示 /// </summary> /// <param name="data"></param> /// <param name="paging"></param> /// <param name="name"></param> /// <param name="id"></param> /// <returns></returns> public UnitedReturn SelOutCommodity(object data) { try { CommodityInfo orderforms = new CommodityInfo(); //object初始值是System.object 所以判断一下 if (data.ToString() != "System.object" && data.ToString() != "1") { orderforms = JsonConvert.DeserializeObject <CommodityInfo>(data.ToString()); } string sql = string.Format($"select c.CommodityId,s.ShopName,c.CommodityName,c.ComndityImg,t.TypeName,c.CommditySum,c.Price from CommodityInfo as c join ShopInfo as s on c.ShopId = s.ShopId join TypeInfo as t on t.TypeId = c.TypeId where c.CommodityState = 0"); if (orderforms.TypeId > 0) { sql += $"and c.TypeId={orderforms.TypeId}"; } if (orderforms.ShopId > 0) { sql += $"and c.ShopId={orderforms.ShopId}"; } sql += "ORDER BY c.CommodityId DESC"; var datas = DBHelper.GetToList <CommodityInfo>(sql); if (!string.IsNullOrEmpty(orderforms.CommodityName)) { datas = datas.Where(s => s.CommodityName.Contains(orderforms.CommodityName)).ToList(); } UnitedReturn unitedReturn = new UnitedReturn(); if (datas.Count > 0 && datas != null) { unitedReturn.data = datas; unitedReturn.res = 1; unitedReturn.msg = "获取信息成功"; } else { unitedReturn.data = null; unitedReturn.res = 0; unitedReturn.msg = "获取信息失败"; } return(unitedReturn); } catch (Exception ex) { //错误日志 log4net //1请求接口 //2请求参数 //3错误信息 //4请求时间 return(new UnitedReturn() { data = ex.InnerException.Message, res = -1, msg = ex.Message }); } }
/// <summary> /// 下架 /// </summary> /// <returns></returns> public JsonResult UpdateCommodityOut() { var data = Request["data"]; var UpdateOrderState = clientHelper.Post("api/XXM_Commodity/OutCommodity", data); var list = new UnitedReturn(); if (UpdateOrderState != null) { list = JsonConvert.DeserializeObject <UnitedReturn>(UpdateOrderState.ToString()); } return(Json(list, JsonRequestBehavior.AllowGet)); }
public JsonResult EnUser() { var GetList = clientHelper.Post("api/User/SelectUser", 1); List <Ycx_User> GetData = new List <Ycx_User>(); UnitedReturn united = new UnitedReturn(); if (GetList != null) { united = JsonConvert.DeserializeObject <UnitedReturn>(GetList.ToString()); GetData = JsonConvert.DeserializeObject <List <Ycx_User> >(JsonConvert.SerializeObject(united.data)); } return(Json(GetData.ToList())); }
/// <summary> /// 修改密码 /// </summary> /// <returns></returns> public JsonResult UpdatePwd() { try { UnitedReturn united = new UnitedReturn(); var request = Request["Data"]; if (request != null) { var res = clientHelper.Post("api/YxApi/UpdatePwd", request); united = JsonConvert.DeserializeObject <UnitedReturn>(res.ToString()); } return(Json(united, JsonRequestBehavior.AllowGet)); } catch (Exception) { logHelper.WriteLog("UpdatePwd", "修改密码"); throw; } }
/// <summary> /// 修改订单状态 /// </summary> /// <returns></returns> public JsonResult UpdateOrderState() { try { var data = Request["data"]; var UpdateOrderState = clientHelper.Post("api/YxApi/UpdateOrderState", data); var list = new UnitedReturn(); if (UpdateOrderState != null) { list = JsonConvert.DeserializeObject <UnitedReturn>(UpdateOrderState.ToString()); } return(Json(list, JsonRequestBehavior.AllowGet)); } catch (Exception) { log.WriteLog("UpdateOrderState", "修改订单状态"); throw; } }
public ActionResult Z_SelectShop() { var GetList = clientHelper.Post("api/User/SelectType", 1); List <ShopInfo> shopSee = new List <ShopInfo>(); UnitedReturn united = new UnitedReturn(); if (GetList != null) { united = JsonConvert.DeserializeObject <UnitedReturn>(GetList.ToString()); shopSee = JsonConvert.DeserializeObject <List <ShopInfo> >(JsonConvert.SerializeObject(united.data)); List <Upload> items = new List <Upload>(); items.Add(new Upload() { text = "请选择", value = "0", Selected = true }); ViewData["DromDownlist"] = items; } return(View(shopSee.ToList())); }
public void ExUser(int id, Ycx_User um) { try { ////查看上传的文件 //HttpFileCollectionBase files = Request.Files; //// true 有文件 //// false 无文件 //HttpPostedFileBase file = files["UserPhoto"]; //string fullName = file.FileName; //FileInfo fi = new FileInfo(fullName); //string nameFile = fi.Name; //string uploadPath = Server.MapPath("\\UserPhoto"); //file.SaveAs(uploadPath + "\\" + nameFile); long ids = Convert.ToInt64(id); var data = JsonConvert.SerializeObject(um); UnitedReturn united = new UnitedReturn(); var res = clientHelper.Post($"api/User/UpdateUser?id=" + ids, data); united = JsonConvert.DeserializeObject <UnitedReturn>(res.ToString()); GetName name = new GetName(); name.Name = united.msg; if (united.res > 0) { Response.Write("<script>alert('修改成功');location.href='/YcxCode/Z_SelectUser'</script>"); } else { Response.Write("<script>alert('修改失败');</script>"); } } catch (Exception) { throw; } }
/// <summary> /// 快递下拉 /// </summary> /// <param name="data"></param> /// <returns></returns> public UnitedReturn DropListLogistics(object data) { UnitedReturn unitedReturn = new UnitedReturn(); string sql = string.Format("select * from LogisticsInfo"); var res = YxDBHelper.GetToList <List <LogisticsInfo> >(sql); if (res != null) { unitedReturn.data = res; unitedReturn.res = 1; unitedReturn.msg = "查询成功"; } else { unitedReturn.data = null; unitedReturn.res = 0; unitedReturn.msg = "查询失败"; } return(unitedReturn); }
public UnitedReturn UserLogin(object data) { var res = System.Web.Configuration.WebConfigurationManager.AppSettings["token"]; UnitedReturn united = new UnitedReturn(); var datas = JsonConvert.DeserializeObject <UserInfo>(data.ToString()); var str = '"' + res.ToString() + '"'; var token = datas.token; if (str == token) { return(bll.UserLogin(data)); } else { united.msg = "非法token"; united.res = 0; united.data = null; return(united); } }
/// <summary> /// 发货公司下拉列表 /// </summary> /// <param name="data"></param> /// <returns></returns> public UnitedReturn LogisticsShow(object data) { string sql = string.Format("select * from LogisticsInfo "); var res = YxDBHelper.GetToList <Orderform>(sql); UnitedReturn unitedReturn = new UnitedReturn(); if (res.Count > 0 && res != null) { unitedReturn.data = res; unitedReturn.res = 1; unitedReturn.msg = "获取信息成功"; } else { unitedReturn.data = null; unitedReturn.res = 0; unitedReturn.msg = "获取信息失败"; } return(unitedReturn); }
/// <summary> /// 添加商品 /// </summary> /// <param name="data"></param> /// <returns></returns> public UnitedReturn Commodity(object data) { try { CommodityInfo commodity = new CommodityInfo(); if (data.ToString() != "System.object" && data.ToString() != "1") { commodity = JsonConvert.DeserializeObject <CommodityInfo>(data.ToString()); } var sql = String.Format($"insert into CommodityInfo (CommodityName,TypeId,ComndityImg,Price,CommditySum,CommodityState,Descride,CommditySize,Testuer,PutawayTime,ShopId) values('{commodity.CommodityName}','{commodity.TypeId}','{commodity.ComndityImg}','{commodity.Price}','{commodity.CommditySum}',1,'{commodity.Descride}','{commodity.CommditySize}','{commodity.Testuer}',GETDATE(),'{commodity.ShopId}')"); var res = DBHelper.ExecuteNonQuery(sql); UnitedReturn united = new UnitedReturn(); if (res > 0) { united.data = res; united.msg = "添加成功!"; united.res = 1; } else { united.data = null; united.msg = "添加失败!"; united.res = 0; } return(united); } catch (Exception ex) { //错误日志 log4net //1请求接口 //2请求参数 //3错误信息 //4请求时间 return(new UnitedReturn() { data = ex.InnerException.Message, res = -1, msg = ex.Message }); } }
public void UserAdd(Ycx_User um) { try { var data = JsonConvert.SerializeObject(um); var request = Request["data"]; UnitedReturn united = new UnitedReturn(); var res = clientHelper.Post("api/User/Add", data); united = JsonConvert.DeserializeObject <UnitedReturn>(res.ToString()); GetName name = new GetName(); name.Name = united.msg; if (united.res > 0) { Response.Write("<script>alert('添加成功');location.href='/YcxCode/ExUser'</script>"); } else { Response.Write("<script>alert('添加失败');</script>"); } } catch (Exception) { throw; } //var data = Request["data"]; //string url = "http://localhost:55041/ycx/Z_Add"; //HttpClient client = new HttpClient(); //string str = JsonConvert.SerializeObject(um); //HttpContent content = new StringContent(str); //content.Headers.ContentType = new System.Net.Http.Headers.MediaTypeHeaderValue("application/json"); //HttpResponseMessage message = client.PostAsync(url, content).Result; //string result = message.Content.ReadAsStringAsync().Result; //GetName name = new GetName(); //name.Name = result; //return Json(name, JsonRequestBehavior.AllowGet); }
/// <summary> /// 店铺列表 /// </summary> /// <param name="data"></param> /// <returns></returns> public UnitedReturn GetShopInfo(object data) { var sql = string.Format("select s.ShopName, from [dbo].[UserInfo] as u join [dbo].[ShopInfo] as s on u.ShopId=s.ShopId where s.ShopState=2"); var res = dBHelper.GetToList <ShopInfo>(sql); UnitedReturn united = new UnitedReturn(); if (res.Count > 0 && res != null) { //给统一返回类型的model赋值 united.data = res; //返回的数据 united.msg = "获取店铺信息成功"; //返回的字符串 united.res = 1; //返回的int值 } else { //给统一返回类型的model赋值 united.data = null; united.msg = "获取店铺信息失败"; united.res = 0; } return(united); }
/// <summary> /// 获取行 /// </summary> /// <param name="model"></param> /// <returns></returns> public UnitedReturn addpersonalinformation(UserInfo model, object data) { try { //if (data.ToString()!="System.object" && data.ToString()!="1") //{ // model = JsonConvert.DeserializeObject<UserInfo>(JsonConvert.SerializeObject(data)); //} var textsql = $"exec userinfo_proc_add '{model.UserName}','{model.UserPhoto}',{model.UserSex},{model.ShopId},'{model.UserNumder}','{model.UserAge}','{model.UserIDNumber}'"; var result = helpX.ExecuteNonQuery(textsql); UnitedReturn united = new UnitedReturn(); if (result > 0) { united.data = result; united.msg = "添加成功"; united.res = 1; } else { united.data = null; united.msg = "添加失败"; united.res = 0; } return(united); } catch (Exception ex) { return(new UnitedReturn() { data = ex.InnerException.Message, res = -1, msg = ex.Message }); } //string textsql = $"exec userinfo_proc_add '{model.UserName}','{model.UserPhoto}',{model.UserSex},{model.ShopId},'{model.UserNumder}','{model.UserAge}','{model.UserIDNumber}'"; //int result = help.GetLine(textsql); }
/// <summary> /// 修改订单状态 发货 State=1 待付款 2 待发货 3 已发货 4 已签收 5 已完成 /// </summary>11 /// <param name="data"></param> /// <returns></returns> public UnitedReturn UpdateOrderState(object data) { UnitedReturn unitedReturn = new UnitedReturn(); if (Convert.ToInt32(data) > 0) { string sql = string.Format($"Update Orderform set OrderState=3 where OrderformId='{Convert.ToInt32(data)}'"); var res = YxDBHelper.ExecuteNonQuery(sql); if (res > 0) { unitedReturn.data = null; unitedReturn.res = 1; unitedReturn.msg = "发货成功"; } } else { unitedReturn.data = null; unitedReturn.res = 0; unitedReturn.msg = "请选择要发货的订单"; } return(unitedReturn); }
/// <summary> /// 用户注册 /// </summary> /// <param name="data"></param> /// <returns></returns> public UnitedReturn UserAdd(object data) { UserInfo Info = JsonConvert.DeserializeObject <UserInfo>(data.ToString()); var sql = string.Format($"insert into UserInfo (UserName,UserPass,UserNumder) values('{Info.UserName}','{Info.UserPass}','{Info.UserNumder}')"); var res = dBHelper.ExecuteNonQuery(sql); UnitedReturn united = new UnitedReturn(); if (res > 0) { //给统一返回类型的model赋值 united.data = null; //返回的数据 united.msg = "注册成功"; //返回的字符串 united.res = 1; //返回的int值 } else { //给统一返回类型的model赋值 united.data = null; united.msg = "注册失败"; united.res = 0; } return(united); }
/// <summary> /// 添加店铺 /// </summary> /// <param name="data"></param> /// <returns></returns> public UnitedReturn AddShopInfo(object data) { ShopInfo Info = JsonConvert.DeserializeObject <ShopInfo>(data.ToString()); var sql = string.Format($"insert into [dbo].[ShopInfo] values('{Info.ShopName}')"); var res = dBHelper.ExecuteNonQuery(sql); UnitedReturn united = new UnitedReturn(); if (res > 0) { //给统一返回类型的model赋值 united.data = null; //返回的数据 united.msg = "添加成功"; //返回的字符串 united.res = 1; //返回的int值 } else { //给统一返回类型的model赋值 united.data = null; united.msg = "添加失败"; united.res = 0; } return(united); }