C# VipSoft类代码示例

OStack程序员社区-中国程序员成长平台 › 门户 › 编程› c#›C#教程

原作者: [db:作者] 来自: [db:来源] 收藏邀请

本文整理汇总了C#中VipSoft类的典型用法代码示例。如果您正苦于以下问题：C# VipSoft类的具体用法？C# VipSoft怎么用？C# VipSoft使用的例子？那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。

VipSoft类属于命名空间，在下文中一共展示了VipSoft类的20个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于我们的系统推荐出更棒的C#代码示例。

示例1: Add

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(VipSoft.Model.PointLog model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into PointLog(");
            strSql.Append("CardID,MemName,Point,Type,CreateDateTime,ShopID,ShopName)");
            strSql.Append(" values (");
            strSql.Append("@CardID,@MemName,@Point,@Type,@CreateDateTime,@ShopID,@ShopName)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
                    new SqlParameter("@CardID", SqlDbType.VarChar,50),
                    new SqlParameter("@MemName", SqlDbType.VarChar,50),
                    new SqlParameter("@Point", SqlDbType.Int,4),
                    new SqlParameter("@Type", SqlDbType.Int,4),
                    new SqlParameter("@CreateDateTime", SqlDbType.DateTime),
                    new SqlParameter("@ShopID", SqlDbType.Int,4),
                    new SqlParameter("@ShopName", SqlDbType.VarChar,50)};
            parameters[0].Value = model.CardID;
            parameters[1].Value = model.MemName;
            parameters[2].Value = model.Point;
            parameters[3].Value = model.Type;
            parameters[4].Value = model.CreateDateTime;
            parameters[5].Value = model.ShopID;
            parameters[6].Value = model.ShopName;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
            if (obj == null)
            {
                return 0;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }

开发者ID:freedomwork，项目名称:playground，代码行数:37，代码来源:PointLog.cs

示例2: Add

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(VipSoft.Model.SysLog model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into SysLog(");
            strSql.Append("MasterAccount,MasterName,Area,Detail,CreateDateTime,ShopID,ShopName)");
            strSql.Append(" values (");
            strSql.Append("@MasterAccount,@MasterName,@Area,@Detail,@CreateDateTime,@ShopID,@ShopName)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
                    new SqlParameter("@MasterAccount", SqlDbType.VarChar,50),
                    new SqlParameter("@MasterName", SqlDbType.VarChar,50),
                    new SqlParameter("@Area", SqlDbType.VarChar,50),
                    new SqlParameter("@Detail", SqlDbType.VarChar,255),
                    new SqlParameter("@CreateDateTime", SqlDbType.DateTime),
                    new SqlParameter("@ShopID", SqlDbType.Int,4),
                    new SqlParameter("@ShopName", SqlDbType.VarChar,50)};
            parameters[0].Value = model.MasterAccount;
            parameters[1].Value = model.MasterName;
            parameters[2].Value = model.Area;
            parameters[3].Value = model.Detail;
            parameters[4].Value = model.CreateDateTime;
            parameters[5].Value = model.ShopID;
            parameters[6].Value = model.ShopName;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
            if (obj == null)
            {
                return 0;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }

开发者ID:freedebug，项目名称:xcode，代码行数:37，代码来源:SysLog.cs

示例3: Add

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(VipSoft.Model.CardLevel model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into CardLevel(");
            strSql.Append("LevelName,NeedPoint,Point,Percent,ShopID,ShopName)");
            strSql.Append(" values (");
            strSql.Append("@LevelName,@NeedPoint,@Point,@Percent,@ShopID,@ShopName)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
                    new SqlParameter("@LevelName", SqlDbType.VarChar,50),
                    new SqlParameter("@NeedPoint", SqlDbType.Int,4),
                    new SqlParameter("@Point", SqlDbType.Int,4),
                    new SqlParameter("@Percent", SqlDbType.Float,8),
                    new SqlParameter("@ShopID", SqlDbType.Int,4),
                    new SqlParameter("@ShopName", SqlDbType.VarChar,50)};
            parameters[0].Value = model.LevelName;
            parameters[1].Value = model.NeedPoint;
            parameters[2].Value = model.Point;
            parameters[3].Value = model.Percent;
            parameters[4].Value = model.ShopID;
            parameters[5].Value = model.ShopName;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
            if (obj == null)
            {
                return 0;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }

开发者ID:freedebug，项目名称:xcode，代码行数:35，代码来源:CardLevel.cs

示例4: Add

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(VipSoft.Model.XExtensionValue model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into XExtensionValue(");
            strSql.Append("ParentID,RecordID,ExtValue0)");
            strSql.Append(" values (");
            strSql.Append("@ParentID,@RecordID,@ExtValue0)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
                    new SqlParameter("@ParentID", SqlDbType.Int,4),
                    new SqlParameter("@RecordID", SqlDbType.Int,4),
                    new SqlParameter("@ExtValue0", SqlDbType.VarChar,255)};
            parameters[0].Value = model.ParentID;
            parameters[1].Value = model.RecordID;
            parameters[2].Value = model.ExtValue0;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
            if (obj == null)
            {
                return 0;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }

开发者ID:freedebug，项目名称:xcode，代码行数:29，代码来源:XExtensionValue.cs

示例5: Add

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public bool Add(VipSoft.Model.MoneyRule model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into MoneyRule(");
            strSql.Append("ID,Name,OneHour,SecondHour,ThirdHour,ThanTime)");
            strSql.Append(" values (");
            strSql.Append("@ID,@Name,@OneHour,@SecondHour,@ThirdHour,@ThanTime)");
            SqlParameter[] parameters = {
                    new SqlParameter("@ID", SqlDbType.Int,4),
                    new SqlParameter("@Name", SqlDbType.VarChar,50),
                    new SqlParameter("@OneHour", SqlDbType.Money,8),
                    new SqlParameter("@SecondHour", SqlDbType.Money,8),
                    new SqlParameter("@ThirdHour", SqlDbType.Money,8),
                    new SqlParameter("@ThanTime", SqlDbType.Int,4)};
            parameters[0].Value = model.ID;
            parameters[1].Value = model.Name;
            parameters[2].Value = model.OneHour;
            parameters[3].Value = model.SecondHour;
            parameters[4].Value = model.ThirdHour;
            parameters[5].Value = model.ThanTime;

            int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
            if (rows > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }

开发者ID:freedebug，项目名称:xcode，代码行数:34，代码来源:MoneyRule.cs

示例6: Add

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(VipSoft.Model.GoodsClass model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into GoodsClass(");
            strSql.Append("ClassName,ParentID,ShopID,ShopName)");
            strSql.Append(" values (");
            strSql.Append("@ClassName,@ParentID,@ShopID,@ShopName)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
                    new SqlParameter("@ClassName", SqlDbType.VarChar,50),
                    new SqlParameter("@ParentID", SqlDbType.Int,4),
                    new SqlParameter("@ShopID", SqlDbType.Int,4),
                    new SqlParameter("@ShopName", SqlDbType.VarChar,50)};
            parameters[0].Value = model.ClassName;
            parameters[1].Value = model.ParentID;
            parameters[2].Value = model.ShopID;
            parameters[3].Value = model.ShopName;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
            if (obj == null)
            {
                return 0;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }

开发者ID:freedomwork，项目名称:playground，代码行数:31，代码来源:GoodsClass.cs

示例7: Add

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(VipSoft.Model.CardType model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into CardType(");
            strSql.Append("Type,IsExpenseGoods,IsExpensePoint,IsPointAuto)");
            strSql.Append(" values (");
            strSql.Append("@Type,@IsExpenseGoods,@IsExpensePoint,@IsPointAuto)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
                    new SqlParameter("@Type", SqlDbType.Int,4),
                    new SqlParameter("@IsExpenseGoods", SqlDbType.Bit,1),
                    new SqlParameter("@IsExpensePoint", SqlDbType.Bit,1),
                    new SqlParameter("@IsPointAuto", SqlDbType.Bit,1)};
            parameters[0].Value = model.Type;
            parameters[1].Value = model.IsExpenseGoods;
            parameters[2].Value = model.IsExpensePoint;
            parameters[3].Value = model.IsPointAuto;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
            if (obj == null)
            {
                return 0;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }

开发者ID:freedebug，项目名称:xcode，代码行数:31，代码来源:CardType.cs

示例8: Add

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public bool Add(VipSoft.Model.SysParameter model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into SysParameter(");
            strSql.Append("ID,KeyName,Title,Type,MaxLength,GroupTitle,Value,Description)");
            strSql.Append(" values (");
            strSql.Append("@ID,@KeyName,@Title,@Type,@MaxLength,@GroupTitle,@Value,@Description)");
            SqlParameter[] parameters = {
                    new SqlParameter("@ID", SqlDbType.Int,4),
                    new SqlParameter("@KeyName", SqlDbType.VarChar,255),
                    new SqlParameter("@Title", SqlDbType.VarChar,255),
                    new SqlParameter("@Type", SqlDbType.Int,4),
                    new SqlParameter("@MaxLength", SqlDbType.Int,4),
                    new SqlParameter("@GroupTitle", SqlDbType.VarChar,50),
                    new SqlParameter("@Value", SqlDbType.VarChar,50),
                    new SqlParameter("@Description", SqlDbType.VarChar,255)};
            parameters[0].Value = model.ID;
            parameters[1].Value = model.KeyName;
            parameters[2].Value = model.Title;
            parameters[3].Value = model.Type;
            parameters[4].Value = model.MaxLength;
            parameters[5].Value = model.GroupTitle;
            parameters[6].Value = model.Value;
            parameters[7].Value = model.Description;

            int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
            if (rows > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }

开发者ID:freedebug，项目名称:xcode，代码行数:38，代码来源:SysParameter.cs

示例9: Add

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(VipSoft.Model.Shop model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into Shop(");
            strSql.Append("Name,TelPhone,ShopLink,Remark)");
            strSql.Append(" values (");
            strSql.Append("@Name,@TelPhone,@ShopLink,@Remark)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
                    new SqlParameter("@Name", SqlDbType.VarChar,50),
                    new SqlParameter("@TelPhone", SqlDbType.VarChar,20),
                    new SqlParameter("@ShopLink", SqlDbType.VarChar,50),
                    new SqlParameter("@Remark", SqlDbType.VarChar,1000)};
            parameters[0].Value = model.Name;
            parameters[1].Value = model.TelPhone;
            parameters[2].Value = model.ShopLink;
            parameters[3].Value = model.Remark;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
            if (obj == null)
            {
                return 0;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }

开发者ID:freedebug，项目名称:xcode，代码行数:31，代码来源:Shop.cs

示例10: Add

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(VipSoft.Model.CouponDetail model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into CouponDetail(");
            strSql.Append("CouponID,CouponNumber,State,UsedTime)");
            strSql.Append(" values (");
            strSql.Append("@CouponID,@CouponNumber,@State,@UsedTime)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
                    new SqlParameter("@CouponID", SqlDbType.Int,4),
                    new SqlParameter("@CouponNumber", SqlDbType.VarChar,20),
                    new SqlParameter("@State", SqlDbType.Int,4),
                    new SqlParameter("@UsedTime", SqlDbType.DateTime)};
            parameters[0].Value = model.CouponID;
            parameters[1].Value = model.CouponNumber;
            parameters[2].Value = model.State;
            parameters[3].Value = model.UsedTime;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
            if (obj == null)
            {
                return 0;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }

开发者ID:freedebug，项目名称:xcode，代码行数:31，代码来源:CouponDetail.cs

示例11: Add

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(VipSoft.Model.XDataNode model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into XDataNode(");
            strSql.Append("ParentID,NodeType,Name,FieldPosition)");
            strSql.Append(" values (");
            strSql.Append("@ParentID,@NodeType,@Name,@FieldPosition)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
                    new SqlParameter("@ParentID", SqlDbType.Int,4),
                    new SqlParameter("@NodeType", SqlDbType.Int,4),
                    new SqlParameter("@Name", SqlDbType.VarChar,255),
                    new SqlParameter("@FieldPosition", SqlDbType.Int,4)};
            parameters[0].Value = model.ParentID;
            parameters[1].Value = model.NodeType;
            parameters[2].Value = model.Name;
            parameters[3].Value = model.FieldPosition;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
            if (obj == null)
            {
                return 0;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }

开发者ID:freedebug，项目名称:xcode，代码行数:31，代码来源:XDataNode.cs

示例12: Add

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(VipSoft.Model.XDataProperty model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into XDataProperty(");
            strSql.Append("DataNodeID,PropertyType,PropertyValue)");
            strSql.Append(" values (");
            strSql.Append("@DataNodeID,@PropertyType,@PropertyValue)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
                    new SqlParameter("@DataNodeID", SqlDbType.Int,4),
                    new SqlParameter("@PropertyType", SqlDbType.Int,4),
                    new SqlParameter("@PropertyValue", SqlDbType.VarChar,1000)};
            parameters[0].Value = model.DataNodeID;
            parameters[1].Value = model.PropertyType;
            parameters[2].Value = model.PropertyValue;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
            if (obj == null)
            {
                return 0;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }

开发者ID:freedebug，项目名称:xcode，代码行数:29，代码来源:XDataProperty.cs

示例13: Add

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(VipSoft.Model.Gift model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into Gift(");
            strSql.Append("GiftCode,Name,Photo,Point,Number,ExchangeNumber)");
            strSql.Append(" values (");
            strSql.Append("@GiftCode,@Name,@Photo,@Point,@Number,@ExchangeNumber)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
                    new SqlParameter("@GiftCode", SqlDbType.VarChar,50),
                    new SqlParameter("@Name", SqlDbType.VarChar,50),
                    new SqlParameter("@Photo", SqlDbType.VarChar,50),
                    new SqlParameter("@Point", SqlDbType.Int,4),
                    new SqlParameter("@Number", SqlDbType.Int,4),
                    new SqlParameter("@ExchangeNumber", SqlDbType.Int,4)};
            parameters[0].Value = model.GiftCode;
            parameters[1].Value = model.Name;
            parameters[2].Value = model.Photo;
            parameters[3].Value = model.Point;
            parameters[4].Value = model.Number;
            parameters[5].Value = model.ExchangeNumber;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
            if (obj == null)
            {
                return 0;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }

开发者ID:freedomwork，项目名称:playground，代码行数:35，代码来源:Gift.cs

示例14: Add

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(VipSoft.Model.GoodsLog model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into GoodsLog(");
            strSql.Append("GoodsID,Type,Number,MasterID,MasterName,CreateDateTime,Remark)");
            strSql.Append(" values (");
            strSql.Append("@GoodsID,@Type,@Number,@MasterID,@MasterName,@CreateDateTime,@Remark)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
                    new SqlParameter("@GoodsID", SqlDbType.Int,4),
                    new SqlParameter("@Type", SqlDbType.Int,4),
                    new SqlParameter("@Number", SqlDbType.Int,4),
                    new SqlParameter("@MasterID", SqlDbType.Int,4),
                    new SqlParameter("@MasterName", SqlDbType.VarChar,50),
                    new SqlParameter("@CreateDateTime", SqlDbType.DateTime),
                    new SqlParameter("@Remark", SqlDbType.VarChar,1000)};
            parameters[0].Value = model.GoodsID;
            parameters[1].Value = model.Type;
            parameters[2].Value = model.Number;
            parameters[3].Value = model.MasterID;
            parameters[4].Value = model.MasterName;
            parameters[5].Value = model.CreateDateTime;
            parameters[6].Value = model.Remark;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
            if (obj == null)
            {
                return 0;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }

开发者ID:freedebug，项目名称:xcode，代码行数:37，代码来源:GoodsLog.cs

示例15: ExpResult

        public ExpResult(decimal _totalMoney, bool _isTravelerMember, VipSoft.Model.MemCard _memInfo)
        {
            totalMoney = _totalMoney;
            isTravelerMember = _isTravelerMember;
            memInfo = _memInfo;

            InitializeComponent();
        }

开发者ID:freedomwork，项目名称:playground，代码行数:8，代码来源:ExpResult.cs

示例16: SysLog

 /// <summary>
 /// 构造函数
 /// </summary>
 /// <param name="master"></param>
 /// <param name="area"></param>
 /// <param name="detail"></param>
 /// <param name="createdatetime"></param>
 /// <param name="shopid"></param>
 /// <param name="shopname"></param>
 public SysLog(VipSoft.Model.Master master,string area,string detail,DateTime createdatetime)
 {
     _masteraccount = master.Account;
     _mastername = master.Name;
     _area = area;
     _detail = detail;
     _createdatetime = createdatetime;
     _shopid = master.ShopID;
     _shopname = master.ShopName;
 }

开发者ID:freedomwork，项目名称:playground，代码行数:19，代码来源:SysLog.cs

示例17: Add

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(VipSoft.Model.Goods model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into Goods(");
            strSql.Append("GoodsCode,Name,NameCode,Unit,Number,SaleNumber,ClassID,Price,BuyPrice,Point,MinPercent,GoodsType,PointType,CreateDateTime,ShopID,ShopName,Remark)");
            strSql.Append(" values (");
            strSql.Append("@GoodsCode,@Name,@NameCode,@Unit,@Number,@SaleNumber,@ClassID,@Price,@BuyPrice,@Point,@MinPercent,@GoodsType,@PointType,@CreateDateTime,@ShopID,@ShopName,@Remark)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
                    new SqlParameter("@GoodsCode", SqlDbType.VarChar,50),
                    new SqlParameter("@Name", SqlDbType.VarChar,50),
                    new SqlParameter("@NameCode", SqlDbType.VarChar,50),
                    new SqlParameter("@Unit", SqlDbType.VarChar,20),
                    new SqlParameter("@Number", SqlDbType.Int,4),
                    new SqlParameter("@SaleNumber", SqlDbType.Int,4),
                    new SqlParameter("@ClassID", SqlDbType.Int,4),
                    new SqlParameter("@Price", SqlDbType.Money,8),
                    new SqlParameter("@BuyPrice", SqlDbType.Money,8),
                    new SqlParameter("@Point", SqlDbType.Int,4),
                    new SqlParameter("@MinPercent", SqlDbType.Float,8),
                    new SqlParameter("@GoodsType", SqlDbType.Bit,1),
                    new SqlParameter("@PointType", SqlDbType.Int,4),
                    new SqlParameter("@CreateDateTime", SqlDbType.DateTime),
                    new SqlParameter("@ShopID", SqlDbType.Int,4),
                    new SqlParameter("@ShopName", SqlDbType.VarChar,50),
                    new SqlParameter("@Remark", SqlDbType.VarChar,1000)};
            parameters[0].Value = model.GoodsCode;
            parameters[1].Value = model.Name;
            parameters[2].Value = model.NameCode;
            parameters[3].Value = model.Unit;
            parameters[4].Value = model.Number;
            parameters[5].Value = model.SaleNumber;
            parameters[6].Value = model.ClassID;
            parameters[7].Value = model.Price;
            parameters[8].Value = model.BuyPrice;
            parameters[9].Value = model.Point;
            parameters[10].Value = model.MinPercent;
            parameters[11].Value = model.GoodsType;
            parameters[12].Value = model.PointType;
            parameters[13].Value = model.CreateDateTime;
            parameters[14].Value = model.ShopID;
            parameters[15].Value = model.ShopName;
            parameters[16].Value = model.Remark;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
            if (obj == null)
            {
                return 0;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }

开发者ID:freedebug，项目名称:xcode，代码行数:57，代码来源:Goods.cs

示例18: Add

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(VipSoft.Model.OrderLog model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into OrderLog(");
            strSql.Append("OrderCode,OrderType,MemID,CardID,MemName,TotalNumber,TotalMoney,DisCountMoney,PayInfo,Point,CreateDateTime,PayType,MasterID,MasterName,ShopID,ShopName)");
            strSql.Append(" values (");
            strSql.Append("@OrderCode,@OrderType,@MemID,@CardID,@MemName,@TotalNumber,@TotalMoney,@DisCountMoney,@PayInfo,@Point,@CreateDateTime,@PayType,@MasterID,@MasterName,@ShopID,@ShopName)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
                    new SqlParameter("@OrderCode", SqlDbType.NChar,10),
                    new SqlParameter("@OrderType", SqlDbType.Int,4),
                    new SqlParameter("@MemID", SqlDbType.Int,4),
                    new SqlParameter("@CardID", SqlDbType.VarChar,50),
                    new SqlParameter("@MemName", SqlDbType.VarChar,20),
                    new SqlParameter("@TotalNumber", SqlDbType.Int,4),
                    new SqlParameter("@TotalMoney", SqlDbType.Money,8),
                    new SqlParameter("@DisCountMoney", SqlDbType.Money,8),
                    new SqlParameter("@PayInfo", SqlDbType.VarChar,50),
                    new SqlParameter("@Point", SqlDbType.Int,4),
                    new SqlParameter("@CreateDateTime", SqlDbType.DateTime),
                    new SqlParameter("@PayType", SqlDbType.Int,4),
                    new SqlParameter("@MasterID", SqlDbType.Int,4),
                    new SqlParameter("@MasterName", SqlDbType.VarChar,50),
                    new SqlParameter("@ShopID", SqlDbType.Int,4),
                    new SqlParameter("@ShopName", SqlDbType.VarChar,50)};
            parameters[0].Value = model.OrderCode;
            parameters[1].Value = model.OrderType;
            parameters[2].Value = model.MemID;
            parameters[3].Value = model.CardID;
            parameters[4].Value = model.MemName;
            parameters[5].Value = model.TotalNumber;
            parameters[6].Value = model.TotalMoney;
            parameters[7].Value = model.DisCountMoney;
            parameters[8].Value = model.PayInfo;
            parameters[9].Value = model.Point;
            parameters[10].Value = model.CreateDateTime;
            parameters[11].Value = model.PayType;
            parameters[12].Value = model.MasterID;
            parameters[13].Value = model.MasterName;
            parameters[14].Value = model.ShopID;
            parameters[15].Value = model.ShopName;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
            if (obj == null)
            {
                return 0;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }

开发者ID:freedomwork，项目名称:playground，代码行数:55，代码来源:OrderLog.cs

示例19: Add

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(VipSoft.Model.OrderGoods model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into OrderGoods(");
            strSql.Append("GoodsID,GoodsCode,GoodsName,type,GoodsUnit,Price,Number,TotalMoney,MasterID,MasterName,ShopID,ShopName,CreateTime)");
            strSql.Append(" values (");
            strSql.Append("@GoodsID,@GoodsCode,@GoodsName,@type,@GoodsUnit,@Price,@Number,@TotalMoney,@MasterID,@MasterName,@ShopID,@ShopName,@CreateTime)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
                    new SqlParameter("@GoodsID", SqlDbType.Int,4),
                    new SqlParameter("@GoodsCode", SqlDbType.VarChar,50),
                    new SqlParameter("@GoodsName", SqlDbType.VarChar,50),
                    new SqlParameter("@type", SqlDbType.Int,4),
                    new SqlParameter("@GoodsUnit", SqlDbType.VarChar,20),
                    new SqlParameter("@Price", SqlDbType.Money,8),
                    new SqlParameter("@Number", SqlDbType.Int,4),
                    new SqlParameter("@TotalMoney", SqlDbType.Money,8),
                    new SqlParameter("@MasterID", SqlDbType.Int,4),
                    new SqlParameter("@MasterName", SqlDbType.VarChar,50),
                    new SqlParameter("@ShopID", SqlDbType.Int,4),
                    new SqlParameter("@ShopName", SqlDbType.VarChar,50),
                    new SqlParameter("@CreateTime", SqlDbType.DateTime)
                                        };
            parameters[0].Value = model.GoodsID;
            parameters[1].Value = model.GoodsCode;
            parameters[2].Value = model.GoodsName;
            parameters[3].Value = model.type;
            parameters[4].Value = model.GoodsUnit;
            parameters[5].Value = model.Price;
            parameters[6].Value = model.Number;
            parameters[7].Value = model.TotalMoney;
            parameters[8].Value = model.MasterID;
            parameters[9].Value = model.MasterName;
            parameters[10].Value = model.ShopID;
            parameters[11].Value = model.ShopName;
            parameters[12].Value = model.CreateTime;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
            if (obj == null)
            {
                return 0;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }

开发者ID:freedomwork，项目名称:playground，代码行数:50，代码来源:OrderGoods.cs

示例20: Add

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(VipSoft.Model.ExchangeLog model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into ExchangeLog(");
            strSql.Append("MemID,CardID,Name,GiftID,GiftCode,GiftName,Number,Point,MasterID,MasterName,ShopID,ShopName)");
            strSql.Append(" values (");
            strSql.Append("@MemID,@CardID,@Name,@GiftID,@GiftCode,@GiftName,@Number,@Point,@MasterID,@MasterName,@ShopID,@ShopName)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
                    new SqlParameter("@MemID", SqlDbType.Int,4),
                    new SqlParameter("@CardID", SqlDbType.VarChar,50),
                    new SqlParameter("@Name", SqlDbType.VarChar,50),
                    new SqlParameter("@GiftID", SqlDbType.Int,4),
                    new SqlParameter("@GiftCode", SqlDbType.VarChar,20),
                    new SqlParameter("@GiftName", SqlDbType.VarChar,50),
                    new SqlParameter("@Number", SqlDbType.Int,4),
                    new SqlParameter("@Point", SqlDbType.Int,4),
                    new SqlParameter("@MasterID", SqlDbType.Int,4),
                    new SqlParameter("@MasterName", SqlDbType.VarChar,50),
                    new SqlParameter("@ShopID", SqlDbType.Int,4),
                    new SqlParameter("@ShopName", SqlDbType.VarChar,50)};
            parameters[0].Value = model.MemID;
            parameters[1].Value = model.CardID;
            parameters[2].Value = model.Name;
            parameters[3].Value = model.GiftID;
            parameters[4].Value = model.GiftCode;
            parameters[5].Value = model.GiftName;
            parameters[6].Value = model.Number;
            parameters[7].Value = model.Point;
            parameters[8].Value = model.MasterID;
            parameters[9].Value = model.MasterName;
            parameters[10].Value = model.ShopID;
            parameters[11].Value = model.ShopName;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
            if (obj == null)
            {
                return 0;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }

开发者ID:freedomwork，项目名称:playground，代码行数:47，代码来源:ExchangeLog.cs

注：本文中的VipSoft类示例整理自Github/MSDocs等源码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。

鲜花

握手

雷人

路过

鸡蛋

该文章已有0人参与评论

请发表评论

全部评论

专题导读

More+

10-27 六六分期app的软件客服如何联系？(六六分期

11-06 可心卡盟:win10系统火狐flash插件崩溃怎么

11-06 亲亲特价:怎么删除回收站图标

11-06 济南大学虚拟社区:鲁大师节能降温的具体办

11-06 xlueops.exe:无线网络安装向导

11-06 女斗合众国:win7系统cf与主机连接不稳定怎

11-06 0xc000022-[cf烟雾头]cf怎么调烟雾头

11-06 qizideyouhuo:应用程序无法正常启动0xc0000

11-06 ipz-185:win7系统vcf文件怎么打开

11-06 傻哥蹦迪:win10系统s4怎么打开usb调试

11-06 八神浩树gtaste:回收站清空了怎么恢复

11-06 妖尾之黑色守护:win10系统电脑没有1440x900

11-06 校园至尊魔王小说:win7系统浏览网页时字体

11-06 女斗合众国:win10系统访问共享文件夹提示请

11-06 tokyo hot n0654:恢复win7系统默认字体一招

11-06 雨酷仙境:设置win7系统转移临时文件夹腾出

11-06 阿穆纳伊之杖:win7系统开始菜单在右边还原

11-06 tunespotting:win10系统火狐flash插件总是

11-06 甘尔葛分析师：计谋网站seo关键词暴涨有什

11-06 蔡贵霖: 计谋网站seo关键词暴涨有什么秘密

11-06 博益网首页:ao3网页版进入不了解决方法

11-06 漏斗子专栏: 网站数据分析小白易懂精华篇

11-06 见证双虹怎么做:win7系统开启telnet命令的

11-06 颾狐蝶蜋:系统资源不足无法完成请求的服务

11-06 国光中学校歌:提交网站到alexa查询详细步骤

11-06 西安有情天:静态网页和动态网页的区别

11-06 红木雅尚斋:外部链接构造对网站的好处

11-06 前官礼遇：防止域名劫持–增强域安全性的10

11-06 密传二转答案: 中文分词算法有哪些

11-06 金泉家园邮编:百度快照劫持的表现及应对方

C# Catalog.Model类代码示例发布时间：2022-05-24

C# VimKey类代码示例发布时间：2022-05-24

剪的笔顺,诠释剪的笔画,认识剪的部首

1 六六分期app的软件客服如何联系？(六六分期

六六分期app的软件客服如何联系？不知道吗？加qq群【895510560】即可！标题：六六分期

阅读：19159|2023-10-27

2 可心卡盟:win10系统火狐flash插件崩溃怎么

今天小编告诉大家如何处理win10系统火狐flash插件总是崩溃的问题，可能很多用户都不知

阅读：9981|2022-11-06

3 亲亲特价:怎么删除回收站图标

今天小编告诉大家如何对win10系统删除桌面回收站图标进行设置，可能很多用户都不知道

阅读：8320|2022-11-06

4 济南大学虚拟社区:鲁大师节能降温的具体办

今天小编告诉大家如何对win10系统电脑设置节能降温的设置方法，想必大家都遇到过需要

阅读：8690|2022-11-06

5 xlueops.exe:无线网络安装向导

我们在使用xp系统的过程中,经常需要对xp系统无线网络安装向导设置进行设置，可能很多

阅读：8634|2022-11-06

6 女斗合众国:win7系统cf与主机连接不稳定怎

今天小编告诉大家如何处理win7系统玩cf老是与主机连接不稳定的问题，可能很多用户都不

阅读：9649|2022-11-06

7 0xc000022-[cf烟雾头]cf怎么调烟雾头

电脑对日常生活的重要性小编就不多说了，可是一旦碰到win7系统设置cf烟雾头的问题，很

阅读：8617|2022-11-06

8 qizideyouhuo:应用程序无法正常启动0xc0000

我们在日常使用电脑的时候，有的小伙伴们可能在打开应用的时候会遇见提示应用程序无法

阅读：7994|2022-11-06

9 ipz-185:win7系统vcf文件怎么打开

今天小编告诉大家如何对win7系统打开vcf文件进行设置，可能很多用户都不知道怎么对win

阅读：8648|2022-11-06

10 傻哥蹦迪:win10系统s4怎么打开usb调试

今天小编告诉大家如何对win10系统s4开启USB调试模式进行设置，可能很多用户都不知道怎

阅读：7531|2022-11-06

客服电话

电子邮件

C# VipSoft类代码示例

示例1: Add

示例2: Add

示例3: Add

示例4: Add

示例5: Add

示例6: Add

示例7: Add

示例8: Add

示例9: Add

示例10: Add

示例11: Add

示例12: Add

示例13: Add

示例14: Add

示例15: ExpResult

示例16: SysLog

示例17: Add

示例18: Add

示例19: Add

示例20: Add

请发表评论

全部评论

上一篇：

下一篇：

jaredks/rumps: Ridiculously Uncomplicate

CVE-2022-23003

armancodv/building-energy-model-matlab:

FGRibreau/import-tweets-to-mastodon: How

[转载]matlab 多元回归分析的例子

剪的笔顺,诠释剪的笔画,认识剪的部首

六六分期app的软件客服如何联系？(六六分期

florent37/ViewAnimator: A fluent Android

florent37/Shrine-MaterialDesign2: implem

CVE-2020-36276

SimpleSoftwareIO/simple-sms: Send and re

关于我们

产品与服务

解决方案

139-2527-9053