public static Result GetInfo() { var result = new Result <List <Style> >(); DbHelperV2 dbhelperv2 = new DbHelperV2(); //此处需优化,参数化处理 var sqltextFomat = "select * from [clothes].[dbo].[style]"; var dt = dbhelperv2.ExecuteDataTable(sqltextFomat); if (dt == null || dt.Rows.Count == 0) { //Error todo result.Code = 403; result.Message = "查无此人!"; //result.Message = "查无此人!"; result.IsTrue = false; result.Data = new List <Style>(); return(result); } var dts = dt.ToStyles(); result.Code = 200; result.Message = "成功!"; result.Data = dts; result.IsTrue = true; return(result); }
public static Result GetInfoById(string userId) { DbHelperV2 dbhelperv2 = new DbHelperV2(); var result = new Result <Figure>(); //此处需优化,参数化处理 var sqltextFomat = "select * from [clothes].[dbo].[figure] where userId={0}"; var dt = dbhelperv2.ExecuteDataTable(string.Format(sqltextFomat, userId)); if (dt == null || dt.Rows.Count == 0) { //Error todo result.Code = 403; //result.Message = "查无此人!"; result.IsTrue = false; result.Data = new Figure(); return(result); } var figures = dt.ToFigures(); result.Code = 200; result.Message = "成功!"; result.Data = figures[0]; result.IsTrue = true; return(result); }
public static Result getClothByIds(string ids) { var result = new Result <List <Cloth> >(); //此处需优化,参数化处理 var sqltextFomat = "SELECT a.*, b.type from [clothes].[dbo].[cloth] as a, [clothes].[dbo].[clothType] as b where a.id in ({0}) and a.clothTypeId = b.id"; DbHelperV2 dbhelperv2 = new DbHelperV2(); var dt = dbhelperv2.ExecuteDataTable(string.Format(sqltextFomat, ids)); var dts = dt.ToCloths(); result.Code = 200; result.Message = "成功!"; result.Data = dts; result.IsTrue = true; return(result); }
public Result share_all_get() { var result = new Result <List <Share> >(); //此处需优化,参数化处理 var sqltextFomat = "select a.id, clothId, a.userId, date, belong, describe, b.clothName, b.imgUrl from [clothes].[dbo].[share] as a, [clothes].[dbo].[cloth] as b where a.clothId=b.id"; var dt = dbhelperv2.ExecuteDataTable(string.Format(sqltextFomat)); if (dt == null || dt.Rows.Count == 0) { //Error todo result.Code = 200; result.Message = "暂无数据!"; result.IsTrue = false; result.Data = new List <Share>(); return(result); } var shares = dt.ToShares(); result.Code = 200; result.Message = "成功!"; result.Data = shares; result.IsTrue = true; return(result); }
public Result collection_get(int userId) { var result = new Result <List <Collection> >(); //此处需优化,参数化处理 var sqltextFomat = "select a.id, a.userId, clothId, startTime, a.endTime, b.clothName, b.imgUrl from [clothes].[dbo].[collection] as a, [clothes].[dbo].[cloth] as b where a.clothId=b.id"; var dt = dbhelperv2.ExecuteDataTable(string.Format(sqltextFomat, userId)); if (dt == null || dt.Rows.Count == 0) { //Error todo result.Code = 200; result.Message = "没有收藏记录!"; result.IsTrue = false; result.Data = new List <Collection>(); return(result); } var collections = dt.ToCollections(); result.Code = 200; result.Message = "成功!"; result.Data = collections; result.IsTrue = true; return(result); }
public static Result GetInfoByTypeOrName(string typeid, string name, string userId, string id) { var result = new Result <List <Cloth> >(); var whereexp = "a.clothTypeId = b.id"; if (!string.IsNullOrEmpty(userId)) { whereexp = whereexp + " and a.userId=" + userId; } if (!string.IsNullOrEmpty(id)) { whereexp = whereexp + " and a.id=" + id; } if (typeid != "") { whereexp = whereexp + " and clothTypeId=" + typeid; } if (!string.IsNullOrEmpty(name)) { whereexp = whereexp + " and clothName LIKE '%" + name + "%'"; } //此处需优化,参数化处理 var sqltextFomat = "select a.*, b.type from [clothes].[dbo].[cloth] as a, [clothes].[dbo].[clothType] as b where {0}"; DbHelperV2 dbhelperv2 = new DbHelperV2(); var dt = dbhelperv2.ExecuteDataTable(string.Format(sqltextFomat, whereexp)); if (dt == null || dt.Rows.Count == 0) { //Error todo result.Code = 200; result.Message = "查无此人!"; result.IsTrue = false; result.Data = new List <Cloth>(); return(result); } var dts = dt.ToCloths(); result.Code = 200; result.Message = "成功!"; result.Data = dts; result.IsTrue = true; return(result); }
public Result Thumb_up_delete(int id) { /// <summary> /// 登录 /// </summary> /// <param name="userId"></param> /// <returns></returns> DbHelperV2 dbhelperv2 = new DbHelperV2(); var result = new Result <List <Link> >(); //此处需优化,参数化处理 var sqltextFomat = "delete from [clothes].[dbo].[link] where id='{0}'"; var dt = dbhelperv2.ExecuteDataTable(string.Format(sqltextFomat, id)); result.Code = 200; result.Message = "成功!"; result.IsTrue = true; return(result); }
public Result Thumb_insert(int userId, int clothId) { /// <summary> /// 登录 /// </summary> /// <param name="userId"></param> /// <returns></returns> DbHelperV2 dbhelperv2 = new DbHelperV2(); var result = new Result <List <Link> >(); //此处需优化,参数化处理 var sqltextFomat = "insert into [clothes].[dbo].[link] (userId, clothId) values ('{0}', '{1}') "; dbhelperv2.ExecuteDataTable(string.Format(sqltextFomat, userId, clothId)); result.Code = 200; result.Message = "成功!"; result.IsTrue = true; return(result); }
public static Result GetInfoByTypeOrName(string styeid, string name, string userId) { DbHelperV2 dbhelperv2 = new DbHelperV2(); var result = new Result <List <Chuanda> >(); var whereexp = " userId=" + userId; if (!string.IsNullOrEmpty(styeid)) { whereexp = whereexp + " and styleId=" + styeid; } if (!string.IsNullOrEmpty(name)) { whereexp = whereexp + " and name LIKE '%" + name + "%'"; } //此处需优化,参数化处理 var sqltextFomat = @"SELECT TOP 1000 cd.[id] ,[styleId] ,[clothIds] ,cd.[describe] ,[userId] ,[createTime] ,[endTime] ,cd.[name] ,sl.sName ,sl.describe as styledescribe FROM [clothes].[dbo].[chuanda] cd inner join [clothes].[dbo].[style] sl on {0} and cd.styleId= sl.id"; var dt = dbhelperv2.ExecuteDataTable(string.Format(sqltextFomat, whereexp)); var dts = dt.ToChuanDa(); //result.Code = 200; //result.Message = "成功!"; //result.Data = dts; //result.IsTrue = true; //return result; return(new Result <List <Chuanda> > { Code = 200, IsTrue = true, Message = "成功", Data = dts }); }
/// <summary> /// 登录 /// </summary> /// <param name="loginName"></param> /// <param name="loginPsw"></param> /// <returns></returns> private Result LoginClothes(string loginName, string loginPsw) { var result = new Result <List <User> >(); //此处需优化,参数化处理 var sqltextFomat = "select * from [clothes].[dbo].[user] where userName='******' and password='******'"; var dt = dbhelperv2.ExecuteDataTable(string.Format(sqltextFomat, loginName, loginPsw)); if (dt == null || dt.Rows.Count == 0) { //Error todo result.Code = 403; result.Message = "查无此人!"; result.IsTrue = false; result.Data = new List <User>(); return(result); } var users = dt.ToUsers(); result.Code = 200; result.Message = "成功!"; result.Data = users; result.IsTrue = true; return(result); }
private Result getUser(string id) { var result = new Result <List <User> >(); //此处需优化,参数化处理 var sqltextFomat = "select * from [clothes].[dbo].[user] where id={0}"; var dt = dbhelperv2.ExecuteDataTable(string.Format(sqltextFomat, id)); if (dt == null || dt.Rows.Count == 0) { //Error todo result.Code = 403; result.Message = "查无此人!"; result.IsTrue = false; result.Data = new List <User>(); return(result); } var users = dt.ToUsers(); result.Code = 200; result.Message = "成功!"; result.Data = users; result.IsTrue = true; return(result); }