/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(webs_YueyxShop.Model.ProductSEOBase model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into ProductSEOBase(");
strSql.Append("p_ID,pseo_Title,pseo_Content,pseo_Keys,pseo_PicAlt,pseo_PicTitle)");
strSql.Append(" values (");
strSql.Append("@p_ID,@pseo_Title,@pseo_Content,@pseo_Keys,@pseo_PicAlt,@pseo_PicTitle)");
SqlParameter[] parameters = {
new SqlParameter("@p_ID", SqlDbType.Int,4),
new SqlParameter("@pseo_Title", SqlDbType.NVarChar,20),
new SqlParameter("@pseo_Content", SqlDbType.NVarChar,300),
new SqlParameter("@pseo_Keys", SqlDbType.NVarChar,100),
new SqlParameter("@pseo_PicAlt", SqlDbType.NVarChar,50),
new SqlParameter("@pseo_PicTitle", SqlDbType.NVarChar,50)};
parameters[0].Value = model.p_ID;
parameters[1].Value = model.pseo_Title;
parameters[2].Value = model.pseo_Content;
parameters[3].Value = model.pseo_Keys;
parameters[4].Value = model.pseo_PicAlt;
parameters[5].Value = model.pseo_PicTitle;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(webs_YueyxShop.Model.RolesInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into RolesInfo(");
strSql.Append("r_ID,r_MingCh,r_MiaoS,r_PaiX,r_CreatedOn,r_CreatedBy,r_StateCode,r_DeleteStateCode)");
strSql.Append(" values (");
strSql.Append("@r_ID,@r_MingCh,@r_MiaoS,@r_PaiX,@r_CreatedOn,@r_CreatedBy,@r_StateCode,@r_DeleteStateCode)");
SqlParameter[] parameters = {
new SqlParameter("@r_ID", SqlDbType.UniqueIdentifier,16),
new SqlParameter("@r_MingCh", SqlDbType.NVarChar,20),
new SqlParameter("@r_MiaoS", SqlDbType.NVarChar,200),
new SqlParameter("@r_PaiX", SqlDbType.Int,4),
new SqlParameter("@r_CreatedOn", SqlDbType.DateTime),
new SqlParameter("@r_CreatedBy", SqlDbType.UniqueIdentifier,16),
new SqlParameter("@r_StateCode", SqlDbType.Int,4),
new SqlParameter("@r_DeleteStateCode", SqlDbType.Int,4)};
parameters[0].Value = model.r_ID;
parameters[1].Value = model.r_MingCh;
parameters[2].Value = model.r_MiaoS;
parameters[3].Value = model.r_PaiX;
parameters[4].Value = model.r_CreatedOn;
parameters[5].Value = model.r_CreatedBy;
parameters[6].Value = model.r_StateCode;
parameters[7].Value = model.r_DeleteStateCode;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(webs_YueyxShop.Model.VipCollectionBase model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into VipCollectionBase(");
strSql.Append("sku_ID,m_ID,vc_CreateOn,vc_IsDel)");
strSql.Append(" values (");
strSql.Append("@sku_ID,@m_ID,@vc_CreateOn,@vc_IsDel)");
SqlParameter[] parameters = {
new SqlParameter("@sku_ID", SqlDbType.Int,4),
new SqlParameter("@m_ID", SqlDbType.Int,4),
new SqlParameter("@vc_CreateOn", SqlDbType.DateTime),
new SqlParameter("@vc_IsDel", SqlDbType.Bit,1)};
parameters[0].Value = model.sku_ID;
parameters[1].Value = model.m_ID;
parameters[2].Value = model.vc_CreateOn;
parameters[3].Value = model.vc_IsDel;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(webs_YueyxShop.Model.SysLogBase model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into SysLogBase(");
strSql.Append("sl_LeiX,sl_ShiJ,sl_DiZh,sl_MiaoSh,sl_LeiX_CaoZ)");
strSql.Append(" values (");
strSql.Append("@sl_LeiX,@sl_ShiJ,@sl_DiZh,@sl_MiaoSh,@sl_LeiX_CaoZ)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@sl_LeiX", SqlDbType.Int,4),
new SqlParameter("@sl_ShiJ", SqlDbType.DateTime),
new SqlParameter("@sl_DiZh", SqlDbType.VarChar,100),
new SqlParameter("@sl_MiaoSh", SqlDbType.NVarChar,500),
new SqlParameter("@sl_LeiX_CaoZ", SqlDbType.VarChar,30)};
parameters[0].Value = model.sl_LeiX;
parameters[1].Value = model.sl_ShiJ;
parameters[2].Value = model.sl_DiZh;
parameters[3].Value = model.sl_MiaoSh;
parameters[4].Value = model.sl_LeiX_CaoZ;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(webs_YueyxShop.Model.OrderStatusBase model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into OrderStatusBase(");
strSql.Append("o_ID,o_Status,os_ModifyOn,os_IsDel)");
strSql.Append(" values (");
strSql.Append("@o_ID,@o_Status,@os_ModifyOn,@os_IsDel)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@o_ID", SqlDbType.Int,4),
new SqlParameter("@o_Status", SqlDbType.Int,4),
new SqlParameter("@os_ModifyOn", SqlDbType.DateTime),
new SqlParameter("@os_IsDel", SqlDbType.Bit,1)};
parameters[0].Value = model.o_ID;
parameters[1].Value = model.o_Status;
parameters[2].Value = model.os_ModifyOn;
parameters[3].Value = model.os_IsDel;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(webs_YueyxShop.Model.ProductRecommendDetail model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into ProductRecommendDetail(");
strSql.Append("prt_ID,p_ID,prd_Status,prd_IsDelete)");
strSql.Append(" values (");
strSql.Append("@prt_ID,@p_ID,@prd_Status,@prd_IsDelete)");
SqlParameter[] parameters = {
new SqlParameter("@prt_ID", SqlDbType.Int,4),
new SqlParameter("@p_ID", SqlDbType.Int,4),
new SqlParameter("@prd_Status", SqlDbType.Bit,1),
new SqlParameter("@prd_IsDelete", SqlDbType.Bit,1)};
parameters[0].Value = model.prt_ID;
parameters[1].Value = model.p_ID;
parameters[2].Value = model.prd_Status;
parameters[3].Value = model.prd_IsDelete;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(webs_YueyxShop.Model.vw_EmpRoleFun model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into vw_EmpRoleFun(");
strSql.Append("f_BianM,f_ID,e_ID,r_ID)");
strSql.Append(" values (");
strSql.Append("@f_BianM,@f_ID,@e_ID,@r_ID)");
SqlParameter[] parameters = {
new SqlParameter("@f_BianM", SqlDbType.VarChar,30),
new SqlParameter("@f_ID", SqlDbType.UniqueIdentifier,16),
new SqlParameter("@e_ID", SqlDbType.UniqueIdentifier,16),
new SqlParameter("@r_ID", SqlDbType.UniqueIdentifier,16)};
parameters[0].Value = model.f_BianM;
parameters[1].Value = Guid.NewGuid();
parameters[2].Value = Guid.NewGuid();
parameters[3].Value = Guid.NewGuid();
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(webs_YueyxShop.Model.ProductRecommendTypeBase model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into ProductRecommendTypeBase(");
strSql.Append("prt_Name,prt_Title,prt_Status,prt_IsDelete,prt_Directions)");
strSql.Append(" values (");
strSql.Append("@prt_Name,@prt_Title,@prt_Status,@prt_IsDelete,@prt_Directions)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@prt_Name", SqlDbType.NVarChar,20),
new SqlParameter("@prt_Title", SqlDbType.NVarChar,200),
new SqlParameter("@prt_Status", SqlDbType.Bit,1),
new SqlParameter("@prt_IsDelete", SqlDbType.Bit,1),
new SqlParameter("@prt_Directions", SqlDbType.VarChar,200)};
parameters[0].Value = model.prt_Name;
parameters[1].Value = model.prt_Title;
parameters[2].Value = model.prt_Status;
parameters[3].Value = model.prt_IsDelete;
parameters[4].Value = model.prt_Directions;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(webs_YueyxShop.Model.ProductImgBase model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into ProductImgBase(");
strSql.Append("sku_ID,pi_Url,pi_Type,pi_StatusCode,pi_IsDel)");
strSql.Append(" values (");
strSql.Append("@sku_ID,@pi_Url,@pi_Type,@pi_statuscode,@pi_isdel)");
SqlParameter[] parameters = {
new SqlParameter("@sku_ID", SqlDbType.Int,4),
new SqlParameter("@pi_Url", SqlDbType.VarChar,100),
new SqlParameter("@pi_Type", SqlDbType.Bit),
new SqlParameter("@pi_statuscode", SqlDbType.Int,4),
new SqlParameter("@pi_isdel", SqlDbType.Bit)};
parameters[0].Value = model.sku_ID;
parameters[1].Value = model.pi_Url;
parameters[2].Value = model.pi_Type;
parameters[3].Value = model.pi_StatusCode;
parameters[4].Value = model.pi_IsDel;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(webs_YueyxShop.Model.OrderSKUDetail model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into OrderSKUDetail(");
strSql.Append("sku_ID,o_ID,os_pCount,os_Price,os_IsGP,os_chima,os_yanse)");
strSql.Append(" values (");
strSql.Append("@sku_ID,@o_ID,@os_pCount,@os_Price,@os_IsGP,@os_chima,@os_yanse)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@sku_ID", SqlDbType.Int,4),
new SqlParameter("@o_ID", SqlDbType.Int,4),
new SqlParameter("@os_pCount", SqlDbType.Int,4),
new SqlParameter("@os_Price", SqlDbType.Decimal,5),
new SqlParameter("@os_IsGP", SqlDbType.Bit,1),
new SqlParameter("@os_chima", SqlDbType.VarChar,50),
new SqlParameter("@os_yanse", SqlDbType.VarChar,50)};
parameters[0].Value = model.sku_ID;
parameters[1].Value = model.o_ID;
parameters[2].Value = model.os_pCount;
parameters[3].Value = model.os_Price;
parameters[4].Value = model.os_IsGP;
parameters[5].Value=model.os_chima;
parameters[6].Value=model.os_yanse;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return false;
}
else
{
return true;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(webs_YueyxShop.Model.PaymentBase model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into PaymentBase(");
strSql.Append("pay_Name,pay_Url,pay_IsDel,pay_isPhone)");
strSql.Append(" values (");
strSql.Append("@pay_Name,@pay_Url,@pay_IsDel,@pay_isPhone)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@pay_Name", SqlDbType.VarChar,20),
new SqlParameter("@pay_Url", SqlDbType.VarChar,30),
new SqlParameter("@pay_IsDel", SqlDbType.Bit,1),
new SqlParameter("@pay_isPhone", SqlDbType.Bit,1)};
parameters[0].Value = model.pay_Name;
parameters[1].Value = model.pay_Url;
parameters[2].Value = model.pay_IsDel;
parameters[3].Value = model.pay_isPhone;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return false;
}
else
{
return true;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(webs_YueyxShop.Model.ProductConsultBase model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into ProductConsultBase(");
strSql.Append("sku_ID,pc_CreatedOn,pc_Type,pc_Content,pc_CreatedBy,pc_StatusCode,pc_huifu,pc_IsDel)");
strSql.Append(" values (");
strSql.Append("@sku_ID,@pc_CreatedOn,@pc_Type,@pc_Content,@pc_CreatedBy,@pc_StatusCode,@pc_huifu,@pc_IsDel)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@sku_ID", SqlDbType.Int,4),
new SqlParameter("@pc_CreatedOn", SqlDbType.DateTime),
new SqlParameter("@pc_Type", SqlDbType.VarChar,30),
new SqlParameter("@pc_Content", SqlDbType.NVarChar,500),
new SqlParameter("@pc_CreatedBy", SqlDbType.Int,4),
new SqlParameter("@pc_StatusCode", SqlDbType.Int,4),
new SqlParameter("@pc_huifu", SqlDbType.Int,4),
new SqlParameter("@pc_IsDel", SqlDbType.Bit,1)};
parameters[0].Value = model.sku_ID;
parameters[1].Value = model.pc_CreatedOn;
parameters[2].Value = model.pc_Type;
parameters[3].Value = model.pc_Content;
parameters[4].Value = model.pc_CreatedBy;
parameters[5].Value = model.pc_StatusCode;
parameters[6].Value = model.pc_huifu;
parameters[7].Value = model.pc_IsDel;
int obj = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
return obj;
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(webs_YueyxShop.Model.ProductReplyBase model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into ProductReplyBase(");
strSql.Append("pc_ID,pr_Content,pr_CreatedBy,pr_CreatedOn,pr_StatusCode,pr_IsDel)");
strSql.Append(" values (");
strSql.Append("@pc_ID,@pr_Content,@pr_CreatedBy,@pr_CreatedOn,@pr_StatusCode,@pr_IsDel)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@pc_ID", SqlDbType.Int,4),
new SqlParameter("@pr_Content", SqlDbType.NVarChar,500),
new SqlParameter("@pr_CreatedBy", SqlDbType.UniqueIdentifier,16),
new SqlParameter("@pr_CreatedOn", SqlDbType.DateTime),
new SqlParameter("@pr_StatusCode", SqlDbType.Int,4),
new SqlParameter("@pr_IsDel", SqlDbType.Bit,1)};
parameters[0].Value = model.pc_ID;
parameters[1].Value = model.pr_Content;
parameters[2].Value = Guid.NewGuid();
parameters[3].Value = model.pr_CreatedOn;
parameters[4].Value = model.pr_StatusCode;
parameters[5].Value = model.pr_IsDel;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(webs_YueyxShop.Model.RejectionSKUDetail model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into RejectionSKUDetail(");
strSql.Append("sku_ID,r_ID,rs_pCount)");
strSql.Append(" values (");
strSql.Append("@sku_ID,@r_ID,@rs_pCount)");
SqlParameter[] parameters = {
new SqlParameter("@sku_ID", SqlDbType.Int,4),
new SqlParameter("@r_ID", SqlDbType.Int,4),
new SqlParameter("@rs_pCount", SqlDbType.Int,4)};
parameters[0].Value = model.sku_ID;
parameters[1].Value = model.r_ID;
parameters[2].Value = model.rs_pCount;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(webs_YueyxShop.Model.RegionBase model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into RegionBase(");
strSql.Append("reg_Code,reg_PId,reg_Name)");
strSql.Append(" values (");
strSql.Append("@reg_Code,@reg_PId,@reg_Name)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@reg_Code", SqlDbType.Int,4),
new SqlParameter("@reg_PId", SqlDbType.Int,4),
new SqlParameter("@reg_Name", SqlDbType.VarChar,15)};
parameters[0].Value = model.reg_Code;
parameters[1].Value = model.reg_PId;
parameters[2].Value = model.reg_Name;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(webs_YueyxShop.Model.EmployeeBase model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into EmployeeBase(");
strSql.Append(
"e_ID,d_ID,e_YongHM,e_MiM,e_MingC,e_GongH,e_XingB,e_ShengR,e_QQ,e_EMail,e_ShouJ,e_CreatedBy,e_CreatedOn,e_StateCode,e_DeleteStateCode,e_LeiB)");
strSql.Append(" values (");
strSql.Append(
"@e_ID,@d_ID,@e_YongHM,@e_MiM,@e_MingC,@e_GongH,@e_XingB,@e_ShengR,@e_QQ,@e_EMail,@e_ShouJ,@e_CreatedBy,@e_CreatedOn,@e_StateCode,@e_DeleteStateCode,@e_LeiB)");
SqlParameter[] parameters =
{
new SqlParameter("@e_ID", SqlDbType.UniqueIdentifier, 16),
new SqlParameter("@d_ID", SqlDbType.UniqueIdentifier, 16),
new SqlParameter("@e_YongHM", SqlDbType.VarChar, 50),
new SqlParameter("@e_MiM", SqlDbType.VarChar, 200),
new SqlParameter("@e_MingC", SqlDbType.NVarChar, 20),
new SqlParameter("@e_GongH", SqlDbType.VarChar, 50),
new SqlParameter("@e_XingB", SqlDbType.Int, 4),
new SqlParameter("@e_ShengR", SqlDbType.DateTime),
new SqlParameter("@e_QQ", SqlDbType.VarChar, 30),
new SqlParameter("@e_EMail", SqlDbType.VarChar, 200),
new SqlParameter("@e_ShouJ", SqlDbType.VarChar, 100),
new SqlParameter("@e_CreatedBy", SqlDbType.UniqueIdentifier, 16),
new SqlParameter("@e_CreatedOn", SqlDbType.DateTime),
new SqlParameter("@e_StateCode", SqlDbType.Int, 4),
new SqlParameter("@e_DeleteStateCode", SqlDbType.Int, 4),
new SqlParameter("@e_LeiB", SqlDbType.Int, 4)
};
parameters[0].Value = Guid.NewGuid();
parameters[1].Value = model.d_ID; //Guid.NewGuid();
parameters[2].Value = model.e_YongHM;
parameters[3].Value = model.e_MiM;
parameters[4].Value = model.e_MingC;
parameters[5].Value = model.e_GongH;
parameters[6].Value = model.e_XingB;
parameters[7].Value = model.e_ShengR;
parameters[8].Value = model.e_QQ;
parameters[9].Value = model.e_EMail;
parameters[10].Value = model.e_ShouJ;
parameters[11].Value = model.e_CreatedBy;
parameters[12].Value = model.e_CreatedOn;
parameters[13].Value = model.e_StateCode;
parameters[14].Value = model.e_DeleteStateCode;
parameters[15].Value = model.e_LeiB;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(webs_YueyxShop.Model.ProductBase model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into ProductBase(");
strSql.Append("b_ID,pt_ID,ct_ID,p_Name,p_Sort,p_MeasurementUnit,p_Province,p_City,p_County,p_CreatedOn,p_CreatedBy,p_ModifyOn,p_ModifyBy,p_StatusCode,p_IsDel,p_sellStatus)");
strSql.Append(" values (");
strSql.Append("@b_ID,@pt_ID,@ct_ID,@p_Name,@p_Sort,@p_MeasurementUnit,@p_Province,@p_City,@p_County,@p_CreatedOn,@p_CreatedBy,@p_ModifyOn,@p_ModifyBy,@p_StatusCode,@p_IsDel,@p_sellStatus)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@b_ID", SqlDbType.Int,4),
new SqlParameter("@pt_ID", SqlDbType.Int,4),
new SqlParameter("@ct_ID", SqlDbType.Int,4),
new SqlParameter("@p_Name", SqlDbType.NVarChar,20),
new SqlParameter("@p_Sort", SqlDbType.Int,4),
new SqlParameter("@p_MeasurementUnit", SqlDbType.VarChar,20),
new SqlParameter("@p_Province", SqlDbType.Int,4),
new SqlParameter("@p_City", SqlDbType.Int,4),
new SqlParameter("@p_County", SqlDbType.Int,4),
new SqlParameter("@p_CreatedOn", SqlDbType.DateTime),
new SqlParameter("@p_CreatedBy", SqlDbType.UniqueIdentifier,16),
new SqlParameter("@p_ModifyOn", SqlDbType.DateTime),
new SqlParameter("@p_ModifyBy", SqlDbType.UniqueIdentifier,16),
new SqlParameter("@p_StatusCode", SqlDbType.SmallInt,2),
new SqlParameter("@p_IsDel", SqlDbType.Bit,1),
new SqlParameter("@p_sellStatus", SqlDbType.Int,2)};
parameters[0].Value = model.b_ID;
parameters[1].Value = model.pt_ID;
parameters[2].Value = model.ct_ID;
parameters[3].Value = model.p_Name;
parameters[4].Value = model.p_Sort;
parameters[5].Value = model.p_MeasurementUnit;
parameters[6].Value = model.p_Province;
parameters[7].Value = model.p_City;
parameters[8].Value = model.p_County;
parameters[9].Value = model.p_CreatedOn;
parameters[10].Value = Guid.NewGuid();
parameters[11].Value = model.p_ModifyOn;
parameters[12].Value = Guid.NewGuid();
parameters[13].Value = model.p_StatusCode;
parameters[14].Value = model.p_IsDel;
parameters[15].Value = model.p_SellStatus;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(webs_YueyxShop.Model.SKUBase model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into SKUBase(");
strSql.Append("p_ID,sku_Price,sku_CostPrice,sku_Stock,sku_SalesCount,sku_Code,sku_CreatedOn,sku_CreatedBy,sku_ModifyOn,sku_ModifyBy,sku_StatusCode,sku_IsDel,sku_scPric,sku_IsMoren,sku_tdcode)");
strSql.Append(" values (");
strSql.Append("@p_ID,@sku_Price,@sku_CostPrice,@sku_Stock,@sku_SalesCount,@sku_Code,@sku_CreatedOn,@sku_CreatedBy,@sku_ModifyOn,@sku_ModifyBy,@sku_StatusCode,@sku_IsDel,@sku_scPric,@sku_IsMoren,@sku_tdcode)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@p_ID", SqlDbType.Int,4),
new SqlParameter("@sku_Price", SqlDbType.Decimal,5),
new SqlParameter("@sku_CostPrice", SqlDbType.Decimal,5),
new SqlParameter("@sku_Stock", SqlDbType.Int,4),
new SqlParameter("@sku_SalesCount", SqlDbType.Int,4),
new SqlParameter("@sku_Code", SqlDbType.VarChar,30),
new SqlParameter("@sku_CreatedOn", SqlDbType.DateTime),
new SqlParameter("@sku_CreatedBy", SqlDbType.UniqueIdentifier,16),
new SqlParameter("@sku_ModifyOn", SqlDbType.DateTime),
new SqlParameter("@sku_ModifyBy", SqlDbType.UniqueIdentifier,16),
new SqlParameter("@sku_StatusCode", SqlDbType.Int,4),
new SqlParameter("@sku_IsDel", SqlDbType.Bit,1),
new SqlParameter("@sku_scPric", SqlDbType.Decimal,5),
new SqlParameter("@sku_IsMoren", SqlDbType.Bit,1),
new SqlParameter("@sku_tdcode", SqlDbType.VarChar,100)};
parameters[0].Value = model.p_ID;
parameters[1].Value = model.sku_Price;
parameters[2].Value = model.sku_CostPrice;
parameters[3].Value = model.sku_Stock;
parameters[4].Value = model.sku_SalesCount;
parameters[5].Value = model.sku_Code;
parameters[6].Value = model.sku_CreatedOn;
parameters[7].Value = Guid.NewGuid();
parameters[8].Value = model.sku_ModifyOn;
parameters[9].Value = Guid.NewGuid();
parameters[10].Value = model.sku_StatusCode;
parameters[11].Value = model.sku_IsDel;
parameters[12].Value = model.sku_scPric;
parameters[13].Value = model.sku_IsMoren;
parameters[14].Value = model.sku_tdcode;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(webs_YueyxShop.Model.CarriageBase model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into CarriageBase(");
strSql.Append("ct_ID,st_ID,car_measurementUnits,car_shouCount,car_shouCarriage,car_xuCount,car_xuCarriage,car_area,car_CreateOn,car_CreateBy,car_ModifyOn,car_ModifyBy,car_Ismoren,car_StatusCode,car_IsDel)");
strSql.Append(" values (");
strSql.Append("@ct_ID,@st_ID,@car_measurementUnits,@car_shouCount,@car_shouCarriage,@car_xuCount,@car_xuCarriage,@car_area,@car_CreateOn,@car_CreateBy,@car_ModifyOn,@car_ModifyBy,@car_Ismoren,@car_StatusCode,@car_IsDel)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@ct_ID", SqlDbType.Int,4),
new SqlParameter("@st_ID", SqlDbType.Char,20),
new SqlParameter("@car_measurementUnits", SqlDbType.Int,4),
new SqlParameter("@car_shouCount", SqlDbType.Int,4),
new SqlParameter("@car_shouCarriage", SqlDbType.Decimal,5),
new SqlParameter("@car_xuCount", SqlDbType.Int,4),
new SqlParameter("@car_xuCarriage", SqlDbType.Decimal,5),
new SqlParameter("@car_area", SqlDbType.VarChar,500),
new SqlParameter("@car_CreateOn", SqlDbType.DateTime),
new SqlParameter("@car_CreateBy", SqlDbType.UniqueIdentifier,16),
new SqlParameter("@car_ModifyOn", SqlDbType.DateTime),
new SqlParameter("@car_ModifyBy", SqlDbType.UniqueIdentifier,16),
new SqlParameter("@car_Ismoren", SqlDbType.Bit,1),
new SqlParameter("@car_StatusCode", SqlDbType.Int,4),
new SqlParameter("@car_IsDel", SqlDbType.Bit,1)};
parameters[0].Value = model.ct_ID;
parameters[1].Value = model.St_ID;
parameters[2].Value = model.car_measurementUnits;
parameters[3].Value = model.car_shouCount;
parameters[4].Value = model.car_shouCarriage;
parameters[5].Value = model.car_xuCount;
parameters[6].Value = model.car_xuCarriage;
parameters[7].Value = model.car_area;
parameters[8].Value = model.car_CreateOn;
parameters[9].Value = Guid.NewGuid();
parameters[10].Value = model.car_ModifyOn;
parameters[11].Value = Guid.NewGuid();
parameters[12].Value = model.car_Ismoren;
parameters[13].Value = model.car_StatusCode;
parameters[14].Value = model.car_IsDel;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(webs_YueyxShop.Model.MenuBase model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into MenuBase(");
strSql.Append("m_ID,m_BianM,m_MingCh,m_CengJ,m_PaiX,m_ParentId,m_CreatedOn,m_CreatedBy,m_StateCode,m_DeleteStateCode,m_Path,m_Type,m_IsShow,m_PageType)");
strSql.Append(" values (");
strSql.Append("@m_ID,@m_BianM,@m_MingCh,@m_CengJ,@m_PaiX,@m_ParentId,@m_CreatedOn,@m_CreatedBy,@m_StateCode,@m_DeleteStateCode,@m_Path,@m_Type,@m_IsShow,@m_PageType)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@m_ID", SqlDbType.UniqueIdentifier,16),
new SqlParameter("@m_BianM", SqlDbType.VarChar,30),
new SqlParameter("@m_MingCh", SqlDbType.NVarChar,20),
new SqlParameter("@m_CengJ", SqlDbType.Int,4),
new SqlParameter("@m_PaiX", SqlDbType.Int,4),
new SqlParameter("@m_ParentId", SqlDbType.UniqueIdentifier,16),
new SqlParameter("@m_CreatedOn", SqlDbType.DateTime),
new SqlParameter("@m_CreatedBy", SqlDbType.UniqueIdentifier,16),
new SqlParameter("@m_StateCode", SqlDbType.Int,4),
new SqlParameter("@m_DeleteStateCode", SqlDbType.Int,4),
new SqlParameter("@m_Path", SqlDbType.NVarChar,100),
new SqlParameter("@m_Type", SqlDbType.Int,4),
new SqlParameter("@m_IsShow", SqlDbType.Bit,1),
new SqlParameter("@m_PageType", SqlDbType.VarChar,30)};
parameters[0].Value = model.m_ID;
parameters[1].Value = model.m_BianM;
parameters[2].Value = model.m_MingCh;
parameters[3].Value = model.m_CengJ;
parameters[4].Value = model.m_PaiX;
parameters[5].Value = model.m_ParentId;
parameters[6].Value = model.m_CreatedOn;
parameters[7].Value = model.m_CreatedBy;
parameters[8].Value = model.m_StateCode;
parameters[9].Value = model.m_DeleteStateCode;
parameters[10].Value = model.m_Path;
parameters[11].Value = model.m_Type;
parameters[12].Value = model.m_IsShow;
parameters[13].Value = model.m_PageType;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(webs_YueyxShop.Model.OrderBase model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into OrderBase(");
strSql.Append("c_ID,m_ID,o_Code,o_CreateOn,o_Pric,o_Zhek,o_StatusCode,o_Mark,o_IsDel,pay_ID,st_ID,o_AlipayNo,o_LogisticsNo,o_Score)");
strSql.Append(" values (");
strSql.Append("@c_ID,@m_ID,@o_Code,@o_CreateOn,@o_Pric,@o_Zhek,@o_StatusCode,@o_Mark,@o_IsDel,@pay_ID,@st_ID,@o_AlipayNo,@o_LogisticsNo,@o_Score)");
strSql.Append(";select SCOPE_IDENTITY()");
SqlParameter[] parameters = {
new SqlParameter("@c_ID", SqlDbType.Int,4),
new SqlParameter("@m_ID", SqlDbType.Int,4),
new SqlParameter("@o_Code", SqlDbType.VarChar,30),
new SqlParameter("@o_CreateOn", SqlDbType.DateTime),
new SqlParameter("@o_Pric", SqlDbType.Decimal,5),
new SqlParameter("@o_Zhek", SqlDbType.Decimal,5),
new SqlParameter("@o_StatusCode", SqlDbType.Int,4),
new SqlParameter("@o_Mark", SqlDbType.VarChar,200),
new SqlParameter("@o_IsDel", SqlDbType.Bit,1),
new SqlParameter("@pay_ID", SqlDbType.Int,4),
new SqlParameter("@st_ID", SqlDbType.Int,4),
new SqlParameter("@o_AlipayNo", SqlDbType.VarChar,30),
new SqlParameter("@o_LogisticsNo", SqlDbType.VarChar,30),
new SqlParameter("@o_Score", SqlDbType.Int,4)};
parameters[0].Value = model.c_ID;
parameters[1].Value = model.m_ID;
parameters[2].Value = model.o_Code;
parameters[3].Value = model.o_CreateOn;
parameters[4].Value = model.o_Pric;
parameters[5].Value = model.o_Zhek;
parameters[6].Value = model.o_StatusCode;
parameters[7].Value = model.o_Mark;
parameters[8].Value = model.o_IsDel;
parameters[9].Value = model.pay_ID;
parameters[10].Value = model.st_ID;
parameters[11].Value = model.o_AlipayNo;
parameters[12].Value = model.o_LogisticsNo;
parameters[13].Value = model.o_Score;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(webs_YueyxShop.Model.FunctionBase model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into FunctionBase(");
strSql.Append(
"f_ID,f_BianM,f_MingCh,f_CengJ,f_ParentId,f_MiaoSh,f_ZhuJM,f_PaiX,f_CreatedOn,f_CreatedBy,f_StatusCode,f_DeleteStateCode)");
strSql.Append(" values (");
strSql.Append(
"@f_ID,@f_BianM,@f_MingCh,@f_CengJ,@f_ParentId,@f_MiaoSh,@f_ZhuJM,@f_PaiX,@f_CreatedOn,@f_CreatedBy,@f_StatusCode,@f_DeleteStateCode)");
SqlParameter[] parameters =
{
new SqlParameter("@f_ID", SqlDbType.UniqueIdentifier, 16),
new SqlParameter("@f_BianM", SqlDbType.VarChar, 30),
new SqlParameter("@f_MingCh", SqlDbType.NVarChar, 20),
new SqlParameter("@f_CengJ", SqlDbType.Int, 4),
new SqlParameter("@f_ParentId", SqlDbType.UniqueIdentifier, 16),
new SqlParameter("@f_MiaoSh", SqlDbType.NVarChar, 200),
new SqlParameter("@f_ZhuJM", SqlDbType.VarChar, 30),
new SqlParameter("@f_PaiX", SqlDbType.Int, 4),
new SqlParameter("@f_CreatedOn", SqlDbType.DateTime),
new SqlParameter("@f_CreatedBy", SqlDbType.UniqueIdentifier, 16),
new SqlParameter("@f_StatusCode", SqlDbType.Int, 4),
new SqlParameter("@f_DeleteStateCode", SqlDbType.Int, 4)
};
parameters[0].Value = Guid.NewGuid();
parameters[1].Value = model.f_BianM;
parameters[2].Value = model.f_MingCh;
parameters[3].Value = model.f_CengJ;
parameters[4].Value = model.f_ParentId; // Guid.NewGuid();
parameters[5].Value = model.f_MiaoSh;
parameters[6].Value = model.f_ZhuJM;
parameters[7].Value = model.f_PaiX;
parameters[8].Value = model.f_CreatedOn;
parameters[9].Value = model.f_CreatedBy; // Guid.NewGuid();
parameters[10].Value = model.f_StatusCode;
parameters[11].Value = model.f_DeleteStateCode;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(webs_YueyxShop.Model.ProductAttributesBase model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into ProductAttributesBase(");
strSql.Append("pa_Name,pa_Alias,pa_Type,pa_Layer,pa_Code,pa_Sort,pa_SelectType,pa_StatusCode,pa_CreatedOn,pa_CreatedBy,pa_IsDel,pa_ParentID,pt_Id)");
strSql.Append(" values (");
strSql.Append("@pa_Name,@pa_Alias,@pa_Type,@pa_Layer,@pa_Code,@pa_Sort,@pa_SelectType,@pa_StatusCode,@pa_CreatedOn,@pa_CreatedBy,@pa_IsDel,@pa_ParentId,@pt_Id)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@pa_Name", SqlDbType.NVarChar,20),
new SqlParameter("@pa_Alias", SqlDbType.NVarChar,20),
new SqlParameter("@pa_Type", SqlDbType.SmallInt,2),
new SqlParameter("@pa_Layer", SqlDbType.Int,4),
new SqlParameter("@pa_Code", SqlDbType.VarChar,30),
new SqlParameter("@pa_Sort", SqlDbType.Int,4),
new SqlParameter("@pa_SelectType", SqlDbType.Int,4),
new SqlParameter("@pa_StatusCode", SqlDbType.Int,4),
new SqlParameter("@pa_CreatedOn", SqlDbType.DateTime),
new SqlParameter("@pa_CreatedBy", SqlDbType.UniqueIdentifier,16),
new SqlParameter("@pa_IsDel", SqlDbType.Bit,1),
new SqlParameter("@pa_ParentId", SqlDbType.Int,4),
new SqlParameter("@pt_Id", SqlDbType.Int,4)};
parameters[0].Value = model.pa_Name;
parameters[1].Value = model.pa_Alias;
parameters[2].Value = model.pa_Type;
parameters[3].Value = model.pa_Layer;
parameters[4].Value = model.pa_Code;
parameters[5].Value = model.pa_Sort;
parameters[6].Value = model.pa_SelectType;
parameters[7].Value = model.pa_StatusCode;
parameters[8].Value = model.pa_CreatedOn;
parameters[9].Value = Guid.NewGuid();
parameters[10].Value = model.pa_IsDel;
parameters[11].Value = model.pa_ParentId;
parameters[12].Value = model.pt_Id;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(webs_YueyxShop.Model.GroupPurchaseBase model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into GroupPurchaseBase(");
strSql.Append("sku_ID,gp_StartTime,gp_EndTime,gp_pCount,gp_pPric,gp_CreateOn,gp_CreateBy,gp_StatusCode,gp_IsDel,gp_Logo,gp_Slogan,gp_SaleCount)");
strSql.Append(" values (");
strSql.Append("@sku_ID,@gp_StartTime,@gp_EndTime,@gp_pCount,@gp_pPric,@gp_CreateOn,@gp_CreateBy,@gp_StatusCode,@gp_IsDel,@gp_Logo,@gp_Slogan,@gp_SaleCount)");
SqlParameter[] parameters = {
new SqlParameter("@sku_ID", SqlDbType.Int,4),
new SqlParameter("@gp_StartTime", SqlDbType.DateTime),
new SqlParameter("@gp_EndTime", SqlDbType.DateTime),
new SqlParameter("@gp_pCount", SqlDbType.Int,4),
new SqlParameter("@gp_pPric", SqlDbType.Decimal,5),
new SqlParameter("@gp_CreateOn", SqlDbType.DateTime),
new SqlParameter("@gp_CreateBy", SqlDbType.UniqueIdentifier,16),
new SqlParameter("@gp_StatusCode", SqlDbType.Int,4),
new SqlParameter("@gp_IsDel", SqlDbType.Bit,1),
new SqlParameter("@gp_Logo", SqlDbType.NVarChar,20),
new SqlParameter("@gp_Slogan", SqlDbType.NVarChar,200),
new SqlParameter("@gp_SaleCount", SqlDbType.Int,4)};
parameters[0].Value = model.sku_ID;
parameters[1].Value = model.gp_StartTime;
parameters[2].Value = model.gp_EndTime;
parameters[3].Value = model.gp_pCount;
parameters[4].Value = model.gp_pPric;
parameters[5].Value = model.gp_CreateOn;
parameters[6].Value = model.gp_CreateBy;
parameters[7].Value = model.gp_StatusCode;
parameters[8].Value = model.gp_IsDel;
parameters[9].Value = model.gp_Logo;
parameters[10].Value = model.gp_Slogan;
parameters[11].Value = model.gp_SaleCount;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(webs_YueyxShop.Model.DepartmentBase model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into DepartmentBase(");
strSql.Append("d_ID,cs_ID,d_BianM,d_MingCh,d_ParentId,d_CengJ,d_ZhuYDH,d_ChuanZ,d_YouX,d_CreatedBy,d_CreatedOn,d_StateCode,d_DeleteStateCode)");
strSql.Append(" values (");
strSql.Append("@d_ID,@cs_ID,@d_BianM,@d_MingCh,@d_ParentId,@d_CengJ,@d_ZhuYDH,@d_ChuanZ,@d_YouX,@d_CreatedBy,@d_CreatedOn,@d_StateCode,@d_DeleteStateCode)");
SqlParameter[] parameters = {
new SqlParameter("@d_ID", SqlDbType.UniqueIdentifier,16),
new SqlParameter("@cs_ID", SqlDbType.Int,4),
new SqlParameter("@d_BianM", SqlDbType.VarChar,30),
new SqlParameter("@d_MingCh", SqlDbType.NVarChar,30),
new SqlParameter("@d_ParentId", SqlDbType.UniqueIdentifier,16),
new SqlParameter("@d_CengJ", SqlDbType.Int,4),
new SqlParameter("@d_ZhuYDH", SqlDbType.VarChar,50),
new SqlParameter("@d_ChuanZ", SqlDbType.VarChar,50),
new SqlParameter("@d_YouX", SqlDbType.VarChar,100),
new SqlParameter("@d_CreatedBy", SqlDbType.UniqueIdentifier,16),
new SqlParameter("@d_CreatedOn", SqlDbType.DateTime),
new SqlParameter("@d_StateCode", SqlDbType.Int,4),
new SqlParameter("@d_DeleteStateCode", SqlDbType.Int,4)};
parameters[0].Value = model.d_ID;
parameters[1].Value = model.cs_ID;
parameters[2].Value = model.d_BianM;
parameters[3].Value = model.d_MingCh;
parameters[4].Value = model.d_ParentId;
parameters[5].Value = model.d_CengJ;
parameters[6].Value = model.d_ZhuYDH;
parameters[7].Value = model.d_ChuanZ;
parameters[8].Value = model.d_YouX;
parameters[9].Value = model.d_CreatedBy;
parameters[10].Value = model.d_CreatedOn;
parameters[11].Value = model.d_StateCode;
parameters[12].Value = model.d_DeleteStateCode;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(webs_YueyxShop.Model.ConsigneeInfoBase model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into ConsigneeInfoBase(");
strSql.Append("m_ID,c_Name,c_Telephone,c_Mobilephone,c_Provice,c_City,c_Count,c_Zipcode,c_Moren,c_StatusCode,c_IsDel,c_FullAddress)");
strSql.Append(" values (");
strSql.Append("@m_ID,@c_Name,@c_Telephone,@c_Mobilephone,@c_Provice,@c_City,@c_Count,@c_Zipcode,@c_Moren,@c_StatusCode,@c_IsDel,@c_FullAddress)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@m_ID", SqlDbType.Int,4),
new SqlParameter("@c_Name", SqlDbType.VarChar,10),
new SqlParameter("@c_Telephone", SqlDbType.VarChar,11),
new SqlParameter("@c_Mobilephone", SqlDbType.VarChar,12),
new SqlParameter("@c_Provice", SqlDbType.Int,4),
new SqlParameter("@c_City", SqlDbType.Int,4),
new SqlParameter("@c_Count", SqlDbType.Int,4),
new SqlParameter("@c_Zipcode", SqlDbType.VarChar,7),
new SqlParameter("@c_Moren", SqlDbType.Int,4),
new SqlParameter("@c_StatusCode", SqlDbType.Int,4),
new SqlParameter("@c_IsDel", SqlDbType.Int,4),
new SqlParameter("@c_FullAddress", SqlDbType.NVarChar,200)};
parameters[0].Value = model.m_ID;
parameters[1].Value = model.c_Name;
parameters[2].Value = model.c_Telephone;
parameters[3].Value = model.c_Mobilephone;
parameters[4].Value = model.c_Provice;
parameters[5].Value = model.c_City;
parameters[6].Value = model.c_Count;
parameters[7].Value = model.c_Zipcode;
parameters[8].Value = model.c_Moren;
parameters[9].Value = model.c_StatusCode;
parameters[10].Value = model.c_IsDel;
parameters[11].Value = model.c_FullAddress;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(webs_YueyxShop.Model.vm_RPDetails model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into vm_RPDetails(");
strSql.Append("rp_ID,p_ID,rp_StartTime,rp_EndTiime,rp_pCount,rp_pPric,rp_CreateOn,rp_CreateBy,rp_StatusCode,rp_isdel,p_Name)");
strSql.Append(" values (");
strSql.Append("@rp_ID,@p_ID,@rp_StartTime,@rp_EndTiime,@rp_pCount,@rp_pPric,@rp_CreateOn,@rp_CreateBy,@rp_StatusCode,@rp_isdel,@p_Name)");
SqlParameter[] parameters = {
new SqlParameter("@rp_ID", SqlDbType.Int,4),
new SqlParameter("@p_ID", SqlDbType.Int,4),
new SqlParameter("@rp_StartTime", SqlDbType.DateTime),
new SqlParameter("@rp_EndTiime", SqlDbType.DateTime),
new SqlParameter("@rp_pCount", SqlDbType.Int,4),
new SqlParameter("@rp_pPric", SqlDbType.Decimal,5),
new SqlParameter("@rp_CreateOn", SqlDbType.DateTime),
new SqlParameter("@rp_CreateBy", SqlDbType.UniqueIdentifier,16),
new SqlParameter("@rp_StatusCode", SqlDbType.Int,4),
new SqlParameter("@rp_isdel", SqlDbType.Bit,1),
new SqlParameter("@p_Name", SqlDbType.NVarChar,20)};
parameters[0].Value = model.rp_ID;
parameters[1].Value = model.p_ID;
parameters[2].Value = model.rp_StartTime;
parameters[3].Value = model.rp_EndTiime;
parameters[4].Value = model.rp_pCount;
parameters[5].Value = model.rp_pPric;
parameters[6].Value = model.rp_CreateOn;
parameters[7].Value = Guid.NewGuid();
parameters[8].Value = model.rp_StatusCode;
parameters[9].Value = model.rp_isdel;
parameters[10].Value = model.p_Name;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(webs_YueyxShop.Model.SysCodeBase model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into SysCodeBase(");
strSql.Append("sc_ID,sc_BianM,sc_MingCh,sc_CengJ,sc_ParentId,sc_CreatedBy,sc_CreatedOn,sc_StateCode,sc_DeleteStateCode,sc_LeiB,sc_SuoSMK)");
strSql.Append(" values (");
strSql.Append("@sc_ID,@sc_BianM,@sc_MingCh,@sc_CengJ,@sc_ParentId,@sc_CreatedBy,@sc_CreatedOn,@sc_StateCode,@sc_DeleteStateCode,@sc_LeiB,@sc_SuoSMK)");
SqlParameter[] parameters = {
new SqlParameter("@sc_ID", SqlDbType.UniqueIdentifier,16),
new SqlParameter("@sc_BianM", SqlDbType.VarChar,30),
new SqlParameter("@sc_MingCh", SqlDbType.NVarChar,20),
new SqlParameter("@sc_CengJ", SqlDbType.Int,4),
new SqlParameter("@sc_ParentId", SqlDbType.UniqueIdentifier,16),
new SqlParameter("@sc_CreatedBy", SqlDbType.UniqueIdentifier,16),
new SqlParameter("@sc_CreatedOn", SqlDbType.DateTime),
new SqlParameter("@sc_StateCode", SqlDbType.Int,4),
new SqlParameter("@sc_DeleteStateCode", SqlDbType.Int,4),
new SqlParameter("@sc_LeiB", SqlDbType.SmallInt,2),
new SqlParameter("@sc_SuoSMK", SqlDbType.NVarChar,50)};
parameters[0].Value = Guid.NewGuid();
parameters[1].Value = model.sc_BianM;
parameters[2].Value = model.sc_MingCh;
parameters[3].Value = model.sc_CengJ;
parameters[4].Value = model.sc_ParentId;
parameters[5].Value = model.sc_CreatedBy;
parameters[6].Value = model.sc_CreatedOn;
parameters[7].Value = model.sc_StateCode;
parameters[8].Value = model.sc_DeleteStateCode;
parameters[9].Value = model.sc_LeiB;
parameters[10].Value = model.sc_SuoSMK;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(webs_YueyxShop.Model.ShoppingCartBase model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into ShoppingCartBase(");
strSql.Append("sku_ID,m_ID,sc_pCount,sc_pPric,sc_CreateOn,sc_IsDel,sc_Status,sc_IsGP,sc_chima,sc_yanse)");
strSql.Append(" values (");
strSql.Append("@sku_ID,@m_ID,@sc_pCount,@sc_pPric,@sc_CreateOn,@sc_IsDel,@sc_Status,@sc_IsGP,@sc_chima,@sc_yanse)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@sku_ID", SqlDbType.Int,4),
new SqlParameter("@m_ID", SqlDbType.Int,4),
new SqlParameter("@sc_pCount", SqlDbType.Int,4),
new SqlParameter("@sc_pPric", SqlDbType.Decimal,5),
new SqlParameter("@sc_CreateOn", SqlDbType.DateTime),
new SqlParameter("@sc_IsDel", SqlDbType.Bit,1),
new SqlParameter("@sc_Status", SqlDbType.Bit,1),
new SqlParameter("@sc_IsGP", SqlDbType.Bit,1),
new SqlParameter("@sc_chima", SqlDbType.VarChar,50),
new SqlParameter("@sc_yanse", SqlDbType.VarChar,50)};
parameters[0].Value = model.sku_ID;
parameters[1].Value = model.m_ID;
parameters[2].Value = model.sc_pCount;
parameters[3].Value = model.sc_pPric;
parameters[4].Value = model.sc_CreateOn;
parameters[5].Value = model.sc_IsDel;
parameters[6].Value = model.sc_Status;
parameters[7].Value = model.sc_IsGP;
parameters[8].Value = model.sc_chima;
parameters[9].Value = model.sc_yanse;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(webs_YueyxShop.Model.ProductInfoBase model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into ProductInfoBase(");
strSql.Append("p_ID,pin_Type,pin_Title,pin_Content,pin_CreatedOn,pin_CreatedBy,pin_ModifyOn,pin_MoidfyBy,pin_StatusCode,pin_IsDel)");
strSql.Append(" values (");
strSql.Append("@p_ID,@pin_Type,@pin_Title,@pin_Content,@pin_CreatedOn,@pin_CreatedBy,@pin_ModifyOn,@pin_MoidfyBy,@pin_StatusCode,@pin_IsDel)");
SqlParameter[] parameters = {
new SqlParameter("@p_ID", SqlDbType.Int,4),
new SqlParameter("@pin_Type", SqlDbType.NVarChar,30),
new SqlParameter("@pin_Title", SqlDbType.NVarChar,30),
new SqlParameter("@pin_Content", SqlDbType.Text),
new SqlParameter("@pin_CreatedOn", SqlDbType.DateTime),
new SqlParameter("@pin_CreatedBy", SqlDbType.UniqueIdentifier,16),
new SqlParameter("@pin_ModifyOn", SqlDbType.DateTime),
new SqlParameter("@pin_MoidfyBy", SqlDbType.UniqueIdentifier,16),
new SqlParameter("@pin_StatusCode", SqlDbType.Int,4),
new SqlParameter("@pin_IsDel", SqlDbType.Bit,1)};
parameters[0].Value = model.p_ID;
parameters[1].Value = model.pin_Type;
parameters[2].Value = model.pin_Title;
parameters[3].Value = model.pin_Content;
parameters[4].Value = model.pin_CreatedOn;
parameters[5].Value = Guid.NewGuid();
parameters[6].Value = model.pin_ModifyOn;
parameters[7].Value = Guid.NewGuid();
parameters[8].Value = model.pin_StatusCode;
parameters[9].Value = model.pin_IsDel;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
