public int Add(CsPrice model) { var strSql = new StringBuilder(); strSql.Append("INSERT INTO CrabShop.dbo.[CsPrice] ("); strSql.Append("PriceNumber,ProductId,PriceDate"); strSql.Append(") VALUES ("); strSql.Append("@PriceNumber,@ProductId,@PriceDate);"); strSql.Append("SELECT @@IDENTITY"); return(DbClient.ExecuteScalar <int>(strSql.ToString(), model)); }
public int Add(CsSystemUsers model) { var strSql = new StringBuilder(); strSql.Append("INSERT INTO CrabShop.dbo.[CsSystemUsers] ("); strSql.Append("SysUserName,SysUserPassword,SysUserType,SysUserState,SysUserDate,DeleteDate,DeleteDescribe"); strSql.Append(") VALUES ("); strSql.Append("@SysUserName,@SysUserPassword,@SysUserType,@SysUserState,@SysUserDate,@DeleteDate,@DeleteDescribe);"); strSql.Append("SELECT @@IDENTITY"); return(DbClient.ExecuteScalar <int>(strSql.ToString(), model)); }
public int Add(CsOrder model) { var strSql = new StringBuilder(); strSql.Append("INSERT INTO CrabShop.dbo.[CsOrder] ("); strSql.Append("OrderNumber,UserId,TotalMoney,DiscountMoney,ActualMoney,OrderDate,OrderState,OrderAddress,SendAddress,OrderDelivery,CargoNumber,OrderCopies,TotalWeight,BillWeight,RowStatus,DeleteDate,DeleteDescribe,PrepaymentId,ExpressMoney,ServiceMoney,IsInvoice,OrderRemarks"); strSql.Append(") VALUES ("); strSql.Append("@OrderNumber,@UserId,@TotalMoney,@DiscountMoney,@ActualMoney,@OrderDate,@OrderState,@OrderAddress,@SendAddress,@OrderDelivery,@CargoNumber,@OrderCopies,@TotalWeight,@BillWeight,@RowStatus,@DeleteDate,@DeleteDescribe,@PrepaymentId,@ExpressMoney,@ServiceMoney,@IsInvoice,@OrderRemarks);"); strSql.Append("SELECT @@IDENTITY"); return(DbClient.ExecuteScalar <int>(strSql.ToString(), model)); }
public int Add(CsMenus model) { var strSql = new StringBuilder(); strSql.Append("INSERT INTO CrabShop.dbo.[CsMenus] ("); strSql.Append("MenuName,MenuUrl,MenuIcon,MenuParId,MenuState,Remarks,MenuOrder"); strSql.Append(") VALUES ("); strSql.Append("@MenuName,@MenuUrl,@MenuIcon,@MenuParId,@MenuState,@Remarks,@MenuOrder);"); strSql.Append("SELECT @@IDENTITY"); return(DbClient.ExecuteScalar <int>(strSql.ToString(), model)); }
public int Add(CsRebate model) { var strSql = new StringBuilder(); strSql.Append("INSERT INTO CrabShop.dbo.[CsRebate] ("); strSql.Append("UserId,RebateMoney,RebateWeight,RebateTime"); strSql.Append(") VALUES ("); strSql.Append("@UserId,@RebateMoney,@RebateWeight,@RebateTime);"); strSql.Append("SELECT @@IDENTITY"); return(DbClient.ExecuteScalar <int>(strSql.ToString(), model)); }
public int Add(CsOrderDetail model) { var strSql = new StringBuilder(); strSql.Append("INSERT INTO CrabShop.dbo.[CsOrderDetail] ("); strSql.Append("OrderId,ProductId,UnitPrice,ProductNumber,TotalPrice,ChoseType"); strSql.Append(") VALUES ("); strSql.Append("@OrderId,@ProductId,@UnitPrice,@ProductNumber,@TotalPrice,@ChoseType);"); strSql.Append("SELECT @@IDENTITY"); return(DbClient.ExecuteScalar <int>(strSql.ToString(), model)); }
public int Add(CsSend model) { var strSql = new StringBuilder(); strSql.Append("INSERT INTO CrabShop.dbo.[CsSend] ("); strSql.Append("CompanyName,SendPerson,ConSex,TelPhone,SendAddress,UserId,IsDefault"); strSql.Append(") VALUES ("); strSql.Append("@CompanyName,@SendPerson,@ConSex,@TelPhone,@SendAddress,@UserId,@IsDefault);"); strSql.Append("SELECT @@IDENTITY"); return(DbClient.ExecuteScalar <int>(strSql.ToString(), model)); }
public int Add(CsAddress model) { var strSql = new StringBuilder(); strSql.Append("INSERT INTO CrabShop.dbo.[CsAddress] ("); strSql.Append("UserId,CompanyName,Consignee,Mobile,Details,TelPhone,ConSex,IsDefault,AddressState"); strSql.Append(") VALUES ("); strSql.Append("@UserId,@CompanyName,@Consignee,@Mobile,@Details,@TelPhone,@ConSex,@IsDefault,@AddressState);"); strSql.Append("SELECT @@IDENTITY"); return(DbClient.ExecuteScalar <int>(strSql.ToString(), model)); }
public int Add(CsCart model) { var strSql = new StringBuilder(); strSql.Append("INSERT INTO CrabShop.dbo.[CsCart] ("); strSql.Append("OpenId,ProductId,ProductNumber,ChoseType"); strSql.Append(") VALUES ("); strSql.Append("@OpenId,@ProductId,@ProductNumber,@ChoseType);"); strSql.Append("SELECT @@IDENTITY"); return(DbClient.ExecuteScalar <int>(strSql.ToString(), model)); }
public int Add(CsDistrict model) { var strSql = new StringBuilder(); strSql.Append("INSERT INTO CrabShop.dbo.[CsDistrict] ("); strSql.Append("Name,ParentId,Code,Sort,FirstPrice,FllowPrice"); strSql.Append(") VALUES ("); strSql.Append("@Name,@ParentId,@Code,@Sort,@FirstPrice,@FllowPrice);"); strSql.Append("SELECT @@IDENTITY"); return(DbClient.ExecuteScalar <int>(strSql.ToString(), model)); }
public int Add(CsUsers model) { var strSql = new StringBuilder(); strSql.Append("INSERT INTO CrabShop.dbo.[CsUsers] ("); strSql.Append("UserName,UserPhone,UserSex,UserState,OpenId,Remarks,UserBalance,TotalWight"); strSql.Append(") VALUES ("); strSql.Append("@UserName,@UserPhone,@UserSex,@UserState,@OpenId,@Remarks,@UserBalance,@TotalWight);"); strSql.Append("SELECT @@IDENTITY"); return(DbClient.ExecuteScalar <int>(strSql.ToString(), model)); }
public string GetPrepaymentId(int orderId) { string strSql = $"select top 1 PrepaymentId from CsOrder where OrderId={orderId}"; return(DbClient.ExecuteScalar <string>(strSql)); }