本文整理汇总了C#中ShowShop类的典型用法代码示例。如果您正苦于以下问题：C# ShowShop类的具体用法？C# ShowShop怎么用？C# ShowShop使用的例子？那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
ShowShop类属于命名空间，在下文中一共展示了ShowShop类的20个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于我们的系统推荐出更棒的C#代码示例。
示例1: Amend
/// <summary>
/// 更新一条数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public void Amend(ShowShop.Model.Accessories.Leaveword model)
{
SqlParameter[] paras = (SqlParameter[])this.ValueParas(model);
StringBuilder strSql = new StringBuilder();
strSql.Append("update yxs_leaveword set ");
strSql.Append("[type][email protected],");
strSql.Append("[username][email protected],");
strSql.Append("[telephone][email protected],");
strSql.Append("[qq][email protected],");
strSql.Append("[msn][email protected],");
strSql.Append("[email][email protected],");
strSql.Append("[title][email protected],");
strSql.Append("[ip][email protected],");
strSql.Append("[isreguser][email protected],");
strSql.Append("[content][email protected],");
strSql.Append("[adddate][email protected],");
strSql.Append("[isread][email protected],");
strSql.Append("[replycontent][email protected],");
strSql.Append("[isreply][email protected],");
strSql.Append("[replydate][email protected],");
strSql.Append("[isauditing][email protected],");
strSql.Append("[storeid][email protected],");
strSql.Append("[address][email protected]");
strSql.Append(" where [id][email protected] ");
ChangeHope.DataBase.SQLServerHelper.ExecuteSql(strSql.ToString(), paras);
}
开发者ID:qq358292363，项目名称:showShop，代码行数:31，代码来源:Leaveword.cs
示例2: Add
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(ShowShop.Model.SystemInfo.MailSetting model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into yxs_MailSetting(");
strSql.Append("SmtpServerIP,SmtpServerPort,MailId,MailPassword)");
strSql.Append(" values (");
strSql.Append("@SmtpServerIP,@SmtpServerPort,@MailId,@MailPassword)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@SmtpServerIP", SqlDbType.VarChar,50),
new SqlParameter("@SmtpServerPort", SqlDbType.Int,4),
new SqlParameter("@MailId", SqlDbType.VarChar,50),
new SqlParameter("@MailPassword", SqlDbType.VarChar,50)};
parameters[0].Value = model.SmtpServerIP;
parameters[1].Value = model.SmtpServerPort;
parameters[2].Value = model.MailId;
parameters[3].Value = model.MailPassword;
object obj = ChangeHope.DataBase.SQLServerHelper.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return 1;
}
else
{
return Convert.ToInt32(obj);
}
}
开发者ID:qq358292363，项目名称:showShop，代码行数:31，代码来源:MailSetting.cs
示例3: Add
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(ShowShop.Model.Admin.AdminLoginLog model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Adminloginlog(");
strSql.Append("AdminName,PassWord,LogininTime,LoginoutTime,LoginIP,HostComputerName,OperateNote)");
strSql.Append(" values (");
strSql.Append("@AdminName,@PassWord,@LogininTime,@LoginoutTime,@LoginIP,@HostComputerName,@OperateNote)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@AdminName", SqlDbType.NVarChar,50),
new SqlParameter("@PassWord", SqlDbType.VarChar,50),
new SqlParameter("@LogininTime", SqlDbType.DateTime),
new SqlParameter("@LoginoutTime", SqlDbType.DateTime),
new SqlParameter("@LoginIP", SqlDbType.VarChar,50),
new SqlParameter("@HostComputerName", SqlDbType.VarChar,50),
new SqlParameter("@OperateNote", SqlDbType.VarChar,4000)};
parameters[0].Value = model.AdminName;
parameters[1].Value = model.PassWord;
parameters[2].Value = model.LoginInTime;
parameters[3].Value = model.LoginOutTime;
parameters[4].Value = model.LoginIp;
parameters[5].Value = model.HostComputerName;
parameters[6].Value = model.OperateNote;
object obj = ChangeHope.DataBase.SQLServerHelper.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return 1;
}
else
{
return Convert.ToInt32(obj);
}
}
开发者ID:qq358292363，项目名称:showShop，代码行数:37，代码来源:AdminLoginLog.cs
示例4: Amend
/// <summary>
/// 更新一条数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public void Amend(ShowShop.Model.Accessories.Outofstock model)
{
SqlParameter[] paras = (SqlParameter[])this.ValueParas(model);
StringBuilder strSql = new StringBuilder();
strSql.Append("update yxs_outofstock set ");
strSql.Append("[proid][email protected],");
strSql.Append("[proclassandname][email protected],");
strSql.Append("[addtime][email protected],");
strSql.Append("[addip][email protected],");
strSql.Append("[username][email protected],");
strSql.Append("[issreguser][email protected],");
strSql.Append("[telphone][email protected],");
strSql.Append("[mobile][email protected],");
strSql.Append("[qq][email protected],");
strSql.Append("[email][email protected],");
strSql.Append("[msn][email protected],");
strSql.Append("[neednum][email protected],");
strSql.Append("[content][email protected],");
strSql.Append("[state][email protected],");
strSql.Append("[isdeal][email protected],");
strSql.Append("[dealtime][email protected],");
strSql.Append("[dealremark][email protected]");
strSql.Append(" where [email protected] ");
ChangeHope.DataBase.SQLServerHelper.ExecuteSql(strSql.ToString(), paras);
}
开发者ID:qq358292363，项目名称:showShop，代码行数:30，代码来源:Outofstock.cs
示例5: Add
public int Add(ShowShop.Model.Member.Integral model)
{
if (model.IntegralClass != 1)
{
model.OrderId = string.Empty;
}
return dal.Add(model);
}
开发者ID:qq358292363，项目名称:showShop，代码行数:8，代码来源:Integral.cs
示例6: Add
public int Add(ShowShop.Model.Product.ScanInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into yxs_scaninfo( ");
strSql.Append("uid,productId,scanTime) values ( ");
strSql.Append("@uid,@productId,@scanTime )");
SqlParameter[] parameters = (SqlParameter[])this.ValueParam(model);
return ChangeHope.DataBase.SQLServerHelper.ExecuteSql(strSql.ToString(),parameters);
}
开发者ID:qq358292363，项目名称:showShop，代码行数:9，代码来源:ScanInfo.cs
示例7: Add
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(ShowShop.Model.Member.MemberAccount model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into yxs_memberaccount(");
strSql.Append("UserType,UserGroup,UserId,PassWord,Signed,Question,Answer,Email,State,RegisterDate,RegisterIP,LastLoginDate,LastLoginIP,LoginTimes,Capital,Coupons,Points,PeriodOfValidity)");
strSql.Append(" values (");
strSql.Append("@UserType,@UserGroup,@UserId,@PassWord,@Signed,@Question,@Answer,@Email,@State,@RegisterDate,@RegisterIP,@LastLoginDate,@LastLoginIP,@LoginTimes,@Capital,@Coupons,@Points,@PeriodOfValidity)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@UserType", SqlDbType.Int,4),
new SqlParameter("@UserGroup", SqlDbType.Int,4),
new SqlParameter("@UserId", SqlDbType.VarChar,50),
new SqlParameter("@PassWord", SqlDbType.VarChar,50),
new SqlParameter("@Signed", SqlDbType.VarChar,5000),
new SqlParameter("@Question", SqlDbType.NVarChar,50),
new SqlParameter("@Answer", SqlDbType.NVarChar,50),
new SqlParameter("@Email", SqlDbType.VarChar,50),
new SqlParameter("@State", SqlDbType.Int,4),
new SqlParameter("@RegisterDate", SqlDbType.DateTime),
new SqlParameter("@RegisterIP", SqlDbType.VarChar,50),
new SqlParameter("@LastLoginDate", SqlDbType.DateTime),
new SqlParameter("@LastLoginIP", SqlDbType.VarChar,50),
new SqlParameter("@LoginTimes", SqlDbType.Int,4),
new SqlParameter("@Capital", SqlDbType.Float,8),
new SqlParameter("@Coupons", SqlDbType.Float,8),
new SqlParameter("@Points", SqlDbType.Float,8),
new SqlParameter("@PeriodOfValidity", SqlDbType.DateTime)};
parameters[0].Value = model.UserType;
parameters[1].Value = model.UserGroup;
parameters[2].Value = model.UserId;
parameters[3].Value = ChangeHope.Common.DEncryptHelper.Encrypt(model.PassWord, 1);
parameters[4].Value = model.Signed;
parameters[5].Value = model.Question;
parameters[6].Value = model.Answer;
parameters[7].Value = model.Email;
parameters[8].Value = model.State;
parameters[9].Value = model.RegisterDate;
parameters[10].Value = model.RegisterIP;
parameters[11].Value = model.LastLoginDate;
parameters[12].Value = model.LastLoginIP;
parameters[13].Value = model.LoginTimes;
parameters[14].Value = model.Capital;
parameters[15].Value = model.Coupons;
parameters[16].Value = model.Points;
parameters[17].Value = model.PeriodOfValidity;
int obj = ChangeHope.DataBase.SQLServerHelper.ExecuteSql(strSql.ToString(), parameters);
if (obj >0)
{
return obj;
}
else
{
return 0;
}
}
开发者ID:qq358292363，项目名称:showShop，代码行数:58，代码来源:MemberAccount.cs
示例8: AddOrUpdate
public void AddOrUpdate(ShowShop.Model.SystemInfo.WebSetting model)
{
if (model.Id > 0)
{
Update(model);
}
else
{
Add(model);
}
}
开发者ID:qq358292363，项目名称:showShop，代码行数:11，代码来源:WebSetting.cs
示例9: Add
public int Add(ShowShop.Model.Member.Integral model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into [yxs_integral](");
strSql.Append("userId,orderid,integralClass,origin,integral,gainDate,noteDate,noteName,remark,integralStatus) ");
strSql.Append("values(");
strSql.Append("@userId,@orderid,@integralClass,@origin,@integral,@gainDate,@noteDate,@noteName,@remark,@integralStatus )");
SqlParameter[] parameters = (SqlParameter[])this.ValueParams(model);
int count = 0;
count = ChangeHope.DataBase.SQLServerHelper.ExecuteSql(strSql.ToString(),parameters);
return count;
}
开发者ID:qq358292363，项目名称:showShop，代码行数:12，代码来源:Integral.cs
示例10: Amend
/// <summary>
/// 更新一条数据
/// </summary>
public void Amend(ShowShop.Model.Order.OrderLeave model)
{
SqlParameter[] paras = (SqlParameter[])this.ValueParas(model);
StringBuilder strSql = new StringBuilder();
strSql.Append("update yxs_orderleave set ");
strSql.Append("[email protected],");
strSql.Append("[email protected],");
strSql.Append("[email protected],");
strSql.Append("[email protected],");
strSql.Append("[email protected]");
strSql.Append(" where [email protected] ");
ChangeHope.DataBase.SQLServerHelper.ExecuteSql(strSql.ToString(), paras);
}
开发者ID:qq358292363，项目名称:showShop，代码行数:16，代码来源:OrderLeave.cs
示例11: Amend
/// <summary>
/// 更新一条数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public void Amend(ShowShop.Model.Accessories.Collection model)
{
SqlParameter[] paras = (SqlParameter[])this.ValueParas(model);
StringBuilder strSql = new StringBuilder();
strSql.Append("update yxs_collection set ");
strSql.Append("[collectiontype][email protected],");
strSql.Append("[collectionid][email protected],");
strSql.Append("[collectionname][email protected],");
strSql.Append("[collectiondate][email protected],");
strSql.Append("[collectionuid][email protected]");
strSql.Append(" where [id][email protected] ");
ChangeHope.DataBase.SQLServerHelper.ExecuteSql(strSql.ToString(), paras);
}
开发者ID:qq358292363，项目名称:showShop，代码行数:18，代码来源:Collection.cs
示例12: Add
/// <summary>
/// 新增数据
/// </summary>
/// <remarks></remarks>
public int Add(ShowShop.Model.Product.ProductBrand model)
{
SqlParameter[] paras = (SqlParameter[])this.ValueParas(model);
string sequel = "Insert into yxs_productbrand (name,sort) Values(@name,@sort) ;select @@IDENTITY ";
object obj = ChangeHope.DataBase.SQLServerHelper.GetSingle(sequel, paras);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
开发者ID:qq358292363，项目名称:showShop，代码行数:18，代码来源:ProductBrand.cs
示例13: Add
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(ShowShop.Model.Member.MemberRank model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into yxs_MemberRank(");
strSql.Append("Name,LogoPic,Discount,MinScore,MaxScore,Priority,IsSpecial,IsShowPrice,Article,Product,ArticleAuditing,ProductAuditing,MaxMoney,UpgradeMoney,IsUpgrade)");
strSql.Append(" values (");
strSql.Append("@Name,@LogoPic,@Discount,@MinScore,@MaxScore,@Priority,@IsSpecial,@IsShowPrice,@Article,@Product,@ArticleAuditing,@ProductAuditing,@MaxMoney,@UpgradeMoney,@IsUpgrade)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@Name", SqlDbType.NVarChar,50),
new SqlParameter("@LogoPic", SqlDbType.NVarChar,200),
new SqlParameter("@Discount", SqlDbType.Float,8),
new SqlParameter("@MinScore", SqlDbType.Float,8),
new SqlParameter("@MaxScore", SqlDbType.Float,8),
new SqlParameter("@Priority", SqlDbType.Int,4),
new SqlParameter("@IsSpecial", SqlDbType.Int,4),
new SqlParameter("@IsShowPrice", SqlDbType.Int,4),
new SqlParameter("@Article", SqlDbType.Int,4),
new SqlParameter("@Product", SqlDbType.Int,4),
new SqlParameter("@ArticleAuditing", SqlDbType.Int,4),
new SqlParameter("@ProductAuditing", SqlDbType.Int,4),
new SqlParameter("@MaxMoney", SqlDbType.Float,8),
new SqlParameter("@UpgradeMoney", SqlDbType.Float,8),
new SqlParameter("@IsUpgrade", SqlDbType.Int,4)};
parameters[0].Value = model.Name;
parameters[1].Value = model.LogoPic;
parameters[2].Value = model.Discount;
parameters[3].Value = model.MinScore;
parameters[4].Value = model.MaxScore;
parameters[5].Value = model.Priority;
parameters[6].Value = model.IsSpecial;
parameters[7].Value = model.IsShowPrice;
parameters[8].Value = model.Article;
parameters[9].Value = model.Product;
parameters[10].Value = model.ArticleAuditing;
parameters[11].Value = model.ProductAuditing;
parameters[12].Value = model.MaxMoney;
parameters[13].Value = model.UpgradeMoney;
parameters[14].Value = model.IsUpgrade;
object obj = ChangeHope.DataBase.SQLServerHelper.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return 1;
}
else
{
return Convert.ToInt32(obj);
}
}
开发者ID:qq358292363，项目名称:showShop，代码行数:53，代码来源:MemberRank.cs
示例14: Amend
/// <summary>
/// 更新一条数据
/// </summary>
public void Amend(ShowShop.Model.Member.MailInfo model)
{
SqlParameter[] paras = (SqlParameter[])this.ValueParas(model);
StringBuilder strSql = new StringBuilder();
strSql.Append("update yxs_mailinfo set ");
strSql.Append("[email protected],");
strSql.Append("[email protected],");
strSql.Append("[email protected],");
strSql.Append("[email protected],");
strSql.Append("[email protected],");
strSql.Append("[email protected]");
strSql.Append(" where [email protected] ");
ChangeHope.DataBase.SQLServerHelper.ExecuteSql(strSql.ToString(), paras);
}
开发者ID:qq358292363，项目名称:showShop，代码行数:17，代码来源:Mailinfo.cs
示例15: Amend
/// <summary>
/// 将一个持久化对象的修改保存到数据库, 并提供事务支持
/// </summary>
/// <remarks></remarks>
public int Amend(ShowShop.Model.Product.ProductAuction model)
{
string sequel = "Update [yxs_productauction] set ";
sequel = sequel + "[auctionname] [email protected] ,[description] [email protected] ,[productid][email protected] ,[productname] [email protected] ,[starttime] [email protected] ,[endtime] [email protected] ,[price] [email protected],[pricerange] [email protected],[deposit] [email protected],[putoutid] [email protected],[putouttypeid][email protected]";
sequel = sequel + UpdateWhereSequel;
object obj = ChangeHope.DataBase.SQLServerHelper.ExecuteSql(sequel, (SqlParameter[])this.ValueParas(model));
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
开发者ID:qq358292363，项目名称:showShop，代码行数:19，代码来源:ProductAuction.cs
示例16: Amend
/// <summary>
/// 将一个持久化对象的修改保存到数据库, 并提供事务支持
/// </summary>
/// <remarks></remarks>
public int Amend(ShowShop.Model.Product.ProductBrand model)
{
string sequel = "Update [yxs_productbrand] set ";
sequel = sequel + "[commontypes] [email protected] ,[name] [email protected] ,[image][email protected] ,[attirbute] [email protected] ,[description] [email protected] ,[sort] [email protected] ,[isrecommend] [email protected]";
sequel = sequel + UpdateWhereSequel;
object obj = ChangeHope.DataBase.SQLServerHelper.ExecuteSql(sequel, (SqlParameter[])this.ValueParas(model));
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
开发者ID:qq358292363，项目名称:showShop，代码行数:19，代码来源:ProductBrand.cs
示例17: Amend
/// <summary>
/// 将一个持久化对象的修改保存到数据库, 并提供事务支持
/// </summary>
/// <remarks></remarks>
public int Amend(ShowShop.Model.Product.ProductAlbum model)
{
string sequel = "Update [yxs_productalbum] set ";
sequel = sequel + "[productid] [email protected] ,[thumbnailaddress] [email protected] ,[originaladdress][email protected] ,[descriptoin] [email protected]";
sequel = sequel + UpdateWhereSequel;
object obj = ChangeHope.DataBase.SQLServerHelper.ExecuteSql(sequel, (SqlParameter[])this.ValueParas(model));
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
开发者ID:qq358292363，项目名称:showShop，代码行数:19，代码来源:ProductAlbum.cs
示例18: Amend
/// <summary>
/// 将一个持久化对象的修改保存到数据库, 并提供事务支持
/// </summary>
/// <remarks></remarks>
public int Amend(ShowShop.Model.Member.Role model)
{
string sequel = "Update [yxs_role] set ";
sequel = sequel + "[name] [email protected] , [description] [email protected]";
sequel = sequel + UpdateWhereSequel;
object obj = ChangeHope.DataBase.SQLServerHelper.ExecuteSql(sequel, (SqlParameter[])this.ValueParas(model));
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
开发者ID:qq358292363，项目名称:showShop，代码行数:19，代码来源:Role.cs
示例19: Amend
/// <summary>
/// 更新一条数据
/// </summary>
public void Amend(ShowShop.Model.Product.Express model)
{
SqlParameter[] paras = (SqlParameter[])this.ValueParas(model);
StringBuilder strSql = new StringBuilder();
strSql.Append("update yxs_express set ");
strSql.Append("[email protected],");
strSql.Append("[email protected],");
strSql.Append("[email protected],");
strSql.Append("[email protected],");
strSql.Append("[email protected],");
strSql.Append("[email protected],");
strSql.Append("[email protected]");
strSql.Append(" where [email protected] ");
ChangeHope.DataBase.SQLServerHelper.ExecuteSql(strSql.ToString(), paras);
}
开发者ID:qq358292363，项目名称:showShop，代码行数:18，代码来源:Express.cs
示例20: ValueParam
public IDbDataParameter[] ValueParam(ShowShop.Model.Product.ScanInfo model)
{
SqlParameter[] parameters ={
new SqlParameter("@id",SqlDbType.Int,4),
new SqlParameter("@uid",SqlDbType.Int,4),
new SqlParameter("@productId",SqlDbType.Int,4),
new SqlParameter("@scanTime",SqlDbType.DateTime,8)
};
parameters[0].Value = model.Id;
parameters[1].Value = model.Uid;
parameters[2].Value = model.ProductId;
parameters[3].Value = model.ScanTime;
return parameters;
}
开发者ID:qq358292363，项目名称:showShop，代码行数:15，代码来源:ScanInfo.cs
注：本文中的ShowShop类示例整理自Github/MSDocs等源码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。 |
客服电话
APP下载
官方微信
请发表评论