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);
}
