/// <summary> /// 注册 /// </summary> /// <param name="loginName"></param> /// <param name="loginPsw"></param> /// <param name="alias"></param> /// <param name="age"></param> /// <returns></returns> private Result RegisterClothes(string loginName, string loginPsw, string alias, string age) { var result = new Result <List <User> >(); //此处需优化,参数化处理 var sqltextFomat = "insert into [clothes].[dbo].[user] (userName,password,age,alias) values ('{0}','{1}','{2}','{3}') "; var sqlText = string.Format(sqltextFomat, loginName, loginPsw, age, alias); dbhelperv2.ExecuteNonQuery(new List <string> { sqlText }); result.Code = 200; result.Message = "成功!"; result.IsTrue = true; return(result); }
/// <summary> /// 注册 /// </summary> /// <param name="loginName"></param> /// <param name="loginPsw"></param> /// <param name="alias"></param> /// <param name="age"></param> /// <returns></returns> private Result updateUser(string loginName, string loginPsw, string alias, string age, string id) { var result = new Result <List <User> >(); //此处需优化,参数化处理 var sqltextFomat = "update [clothes].[dbo].[user] set userName='******',password='******',age='{2}',alias='{3}' where id={4} "; var sqlText = string.Format(sqltextFomat, loginName, loginPsw, age, alias, id); dbhelperv2.ExecuteNonQuery(new List <string> { sqlText }); result.Code = 200; result.Message = "成功!"; result.IsTrue = true; return(result); }
public static Result DeleteClothById(int id) { var result = new Result(); DbHelperV2 dbhelperv2 = new DbHelperV2(); //此处需优化,参数化处理 var sqltextFomat = "delete from [clothes].[dbo].[cloth] where id={0} "; var sqlText = string.Format(sqltextFomat, id); dbhelperv2.ExecuteNonQuery(new List <string> { sqlText }); result.Code = 200; result.Message = "成功!"; result.IsTrue = true; return(result); }
public static Result EditCloth(Cloth model, int id) { var result = new Result(); DbHelperV2 dbhelperv2 = new DbHelperV2(); //此处需优化,参数化处理 var sqltextFomat = "update [clothes].[dbo].[cloth] set userId='{0}',clothTypeId='{1}',clothName='{2}',price='{3}',brand='{4}',fabric='{5}',season='{6}',size='{7}',color='{8}',imgUrl='{9}',createTime='{10}',endTime='{11}' where id={12} "; var sqlText = string.Format(sqltextFomat, model.userId, model.clothTypeId, model.clothName, model.price, model.brand, model.fabric, model.season, model.size, model.color, model.imgUrl, model.createTime, model.endTime, id); dbhelperv2.ExecuteNonQuery(new List <string> { sqlText }); result.Code = 200; result.Message = "成功!"; result.IsTrue = true; return(result); }
public static Result AddCloth(Cloth model) { var result = new Result(); DbHelperV2 dbhelperv2 = new DbHelperV2(); //此处需优化,参数化处理 var sqltextFomat = "insert into [clothes].[dbo].[cloth] (userId,clothTypeId,clothName,price,brand,fabric,season,size,color,imgUrl,createTime,endTime) values ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}') "; var sqlText = string.Format(sqltextFomat, model.userId, model.clothTypeId, model.clothName, model.price, model.brand, model.fabric, model.season, model.size, model.color, model.imgUrl, model.createTime, model.endTime); dbhelperv2.ExecuteNonQuery(new List <string> { sqlText }); result.Code = 200; result.Message = "成功!"; result.IsTrue = true; return(result); }
public static Result EditStyleType(int id, string sName, string describe) { var result = new Result(); //此处需优化,参数化处理 var sqltextFomat = "update [clothes].[dbo].[style] set sName='{0}',describe='{1}' where id={2} "; var sqlText = string.Format(sqltextFomat, sName, describe, id); DbHelperV2 dbhelperv2 = new DbHelperV2(); dbhelperv2.ExecuteNonQuery(new List <string> { sqlText }); result.Code = 200; result.Message = "成功!"; result.IsTrue = true; return(result); }
public static Result AddStyleType(string sName, string describe) { var result = new Result(); //此处需优化,参数化处理 var sqltextFomat = "insert into [clothes].[dbo].[style] (sName,describe) values ('{0}','{1}') "; var sqlText = string.Format(sqltextFomat, sName, describe); DbHelperV2 dbhelperv2 = new DbHelperV2(); dbhelperv2.ExecuteNonQuery(new List <string> { sqlText }); result.Code = 200; result.Message = "成功!"; result.IsTrue = true; return(result); }
public static Result EditClothType(string type, int id) { var result = new Result(); DbHelperV2 dbhelperv2 = new DbHelperV2(); //此处需优化,参数化处理 var sqltextFomat = "update [clothes].[dbo].[ClothType] set type='{0}' where id={1} "; var sqlText = string.Format(sqltextFomat, type, id); dbhelperv2.ExecuteNonQuery(new List <string> { sqlText }); result.Code = 200; result.Message = "成功!"; result.IsTrue = true; return(result); }
public static Result EditFigure(int userId, string weight, string stature, string chestSize, string waistSize, string hiplineSize, int id) { var result = new Result(); DbHelperV2 dbhelperv2 = new DbHelperV2(); //此处需优化,参数化处理 var sqltextFomat = "update [clothes].[dbo].[figure] set userId='{0}',weight='{1}',stature='{2}',chestSize='{3}',waistSize='{4}',hiplineSize='{5}' where id={6} "; var sqlText = string.Format(sqltextFomat, userId, weight, stature, chestSize, waistSize, hiplineSize, id); dbhelperv2.ExecuteNonQuery(new List <string> { sqlText }); result.Code = 200; result.Message = "成功!"; result.IsTrue = true; return(result); }
public static Result AddFigure(string userId, string weight, string stature, string chestSize, string waistSize, string hiplineSize) { var result = new Result(); DbHelperV2 dbhelperv2 = new DbHelperV2(); //此处需优化,参数化处理 var sqltextFomat = "insert into [clothes].[dbo].[figure] (userId,weight,stature,chestSize,waistSize,hiplineSize) values ('{0}','{1}','{2}','{3}','{4}','{5}') "; var sqlText = string.Format(sqltextFomat, userId, weight, stature, chestSize, waistSize, hiplineSize); dbhelperv2.ExecuteNonQuery(new List <string> { sqlText }); result.Code = 200; result.Message = "成功!"; result.IsTrue = true; return(result); }
public static Result AddChuanDa(string userId, string name, string styleId, string clothIds, string describe, string createTime, string endTime) { var result = new Result(); DbHelperV2 dbhelperv2 = new DbHelperV2(); //此处需优化,参数化处理 var sqltextFomat = "insert into [clothes].[dbo].[chuanda] (userId,name,styleId,clothIds,describe,createTime,endTime) values ('{0}','{1}','{2}','{3}','{4}','{5}', '{6}') "; var sqlText = string.Format(sqltextFomat, userId, name, styleId, clothIds, describe, createTime, endTime); dbhelperv2.ExecuteNonQuery(new List <string> { sqlText }); result.Code = 200; result.Message = "成功!"; result.IsTrue = true; return(result); }
public static Result EditChuanDa(string id, string userId, string name, string styleId, string clothIds, string describe, string createTime, string endTime) { var intid = Convert.ToInt32(id); var result = new Result(); DbHelperV2 dbhelperv2 = new DbHelperV2(); //此处需优化,参数化处理 var sqltextFomat = "update [clothes].[dbo].[chuanda] set name='{0}',styleId='{1}',clothIds='{2}',describe='{3}',createTime='{4}',endTime='{5}', userId='{6}' where id={7} "; var sqlText = string.Format(sqltextFomat, name, styleId, clothIds, describe, createTime, endTime, userId, intid); dbhelperv2.ExecuteNonQuery(new List <string> { sqlText }); result.Code = 200; result.Message = "成功!"; result.IsTrue = true; return(result); }