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