/// <summary>
 ///  ����һ������
 /// </summary>
 public void Add(NoName.NetShop.Model.OrderModel model)
 {
     Database db = DatabaseFactory.CreateDatabase();
     DbCommand dbCommand = db.GetStoredProcCommand("UP_spOrder_ADD");
     db.AddInParameter(dbCommand, "UserId", DbType.Int32, model.UserId);
     db.AddInParameter(dbCommand, "OrderId", DbType.Int32, model.OrderId);
     db.AddInParameter(dbCommand, "OrderStatus", DbType.Byte, model.OrderStatus);
     db.AddInParameter(dbCommand, "PayMethod", DbType.Byte, model.PayMethod);
     db.AddInParameter(dbCommand, "ShipMethod", DbType.Byte, model.ShipMethod);
     db.AddInParameter(dbCommand, "PayStatus", DbType.Byte, model.PayStatus);
     db.AddInParameter(dbCommand, "Paysum", DbType.Decimal, model.Paysum);
     db.AddInParameter(dbCommand, "ShipFee", DbType.Decimal, model.ShipFee);
     db.AddInParameter(dbCommand, "ProductFee", DbType.Decimal, model.ProductFee);
     db.AddInParameter(dbCommand, "DerateFee", DbType.Decimal, model.DerateFee);
     db.AddInParameter(dbCommand, "AddressId", DbType.Int32, model.AddressId);
     db.AddInParameter(dbCommand, "RecieverName", DbType.AnsiString, model.RecieverName);
     db.AddInParameter(dbCommand, "RecieverEmail", DbType.AnsiString, model.RecieverEmail);
     db.AddInParameter(dbCommand, "RecieverPhone", DbType.AnsiString, model.RecieverPhone);
     db.AddInParameter(dbCommand, "Postalcode", DbType.AnsiString, model.Postalcode);
     db.AddInParameter(dbCommand, "RecieverCity", DbType.AnsiString, model.RecieverCity);
     db.AddInParameter(dbCommand, "RecieverProvince", DbType.AnsiString, model.RecieverProvince);
     db.AddInParameter(dbCommand, "AddressDetial", DbType.AnsiString, model.AddressDetial);
     db.AddInParameter(dbCommand, "ChangeTime", DbType.DateTime, model.ChangeTime);
     db.AddInParameter(dbCommand, "PayTime", DbType.DateTime, model.PayTime);
     db.AddInParameter(dbCommand, "CreateTime", DbType.DateTime, model.CreateTime);
     db.AddInParameter(dbCommand, "OrderType", DbType.Byte, model.OrderType);
     db.ExecuteNonQuery(dbCommand);
 }
 /// <summary>
 ///  ����һ������
 /// </summary>
 public void Add(NoName.NetShop.Model.RoleModel model)
 {
     Database db = DatabaseFactory.CreateDatabase();
     DbCommand dbCommand = db.GetStoredProcCommand("UP_maRole_ADD");
     db.AddInParameter(dbCommand, "RoleId", DbType.Int32, model.RoleId);
     db.AddInParameter(dbCommand, "RoleName", DbType.AnsiString, model.RoleName);
     db.ExecuteNonQuery(dbCommand);
 }
 /// <summary>
 ///  ����һ������
 /// </summary>
 public void Add(NoName.NetShop.Model.ProductExtModel model)
 {
     Database db = DatabaseFactory.CreateDatabase();
     DbCommand dbCommand = db.GetStoredProcCommand("UP_pdProductExt_ADD");
     db.AddInParameter(dbCommand, "ProductId", DbType.Int32, model.ProductId);
     db.AddInParameter(dbCommand, "ProductDesc", DbType.String, model.ProductDesc);
     db.ExecuteNonQuery(dbCommand);
 }
 /// <summary>
 ///  ����һ������
 /// </summary>
 public void Add(NoName.NetShop.Model.ContentModel model)
 {
     Database db = DatabaseFactory.CreateDatabase();
     DbCommand dbCommand = db.GetStoredProcCommand("UP_cmsContent_ADD");
     db.AddInParameter(dbCommand, "CmsTagId", DbType.Int32, model.CmsTagId);
     db.AddInParameter(dbCommand, "Content", DbType.String, model.Content);
     db.AddInParameter(dbCommand, "LastModifyTime", DbType.DateTime, model.LastModifyTime);
     db.ExecuteNonQuery(dbCommand);
 }
 /// <summary>
 ///  ����һ������
 /// </summary>
 public void Add(NoName.NetShop.Model.SalesProductModel model)
 {
     Database db = DatabaseFactory.CreateDatabase();
     DbCommand dbCommand = db.GetStoredProcCommand("UP_pdSalesProduct_ADD");
     db.AddInParameter(dbCommand, "ProductId", DbType.Int32, model.ProductId);
     db.AddInParameter(dbCommand, "SaleType", DbType.Byte, model.SaleType);
     db.AddInParameter(dbCommand, "SiteId", DbType.Int32, model.SiteId);
     db.ExecuteNonQuery(dbCommand);
 }
 /// <summary>
 ///  ����һ������
 /// </summary>
 public void Add(NoName.NetShop.Model.LoginLogModel model)
 {
     Database db = DatabaseFactory.CreateDatabase();
     DbCommand dbCommand = db.GetStoredProcCommand("UP_umLoginLog_ADD");
     db.AddInParameter(dbCommand, "UserId", DbType.Int32, model.UserId);
     db.AddInParameter(dbCommand, "LoginTime", DbType.DateTime, model.LoginTime);
     db.AddInParameter(dbCommand, "IP", DbType.AnsiString, model.IP);
     db.ExecuteNonQuery(dbCommand);
 }
 /// <summary>
 ///  ����һ������
 /// </summary>
 public void Add(NoName.NetShop.Model.AuctionLogModel model)
 {
     Database db = DatabaseFactory.CreateDatabase();
     DbCommand dbCommand = db.GetStoredProcCommand("UP_auAuctionLog_ADD");
     db.AddInParameter(dbCommand, "AuctionId", DbType.Int32, model.AuctionId);
     db.AddInParameter(dbCommand, "UserName", DbType.AnsiString, model.UserName);
     db.AddInParameter(dbCommand, "AuctionTime", DbType.DateTime, model.AuctionTime);
     db.AddInParameter(dbCommand, "AutionPrice", DbType.Decimal, model.AutionPrice);
     db.ExecuteNonQuery(dbCommand);
 }
 /// <summary>
 ///  ����һ������
 /// </summary>
 public void Add(NoName.NetShop.Model.CommendModel model)
 {
     Database db = DatabaseFactory.CreateDatabase();
     DbCommand dbCommand = db.GetStoredProcCommand("UP_ssCommend_ADD");
     db.AddInParameter(dbCommand, "SchemeId", DbType.Int32, model.SchemeId);
     db.AddInParameter(dbCommand, "CateId", DbType.Int32, model.CateId);
     db.AddInParameter(dbCommand, "ProductId", DbType.Int32, model.ProductId);
     db.AddInParameter(dbCommand, "Quantity", DbType.Int32, model.Quantity);
     db.ExecuteNonQuery(dbCommand);
 }
 /// <summary>
 ///  ����һ������
 /// </summary>
 public void Add(NoName.NetShop.Model.OrderChangeLogModel model)
 {
     Database db = DatabaseFactory.CreateDatabase();
     DbCommand dbCommand = db.GetStoredProcCommand("UP_spOrderChangeLog_ADD");
     db.AddInParameter(dbCommand, "OrderId", DbType.Int32, model.OrderId);
     db.AddInParameter(dbCommand, "ChangeTime", DbType.DateTime, model.ChangeTime);
     db.AddInParameter(dbCommand, "Remark", DbType.AnsiString, model.Remark);
     db.AddInParameter(dbCommand, "Operator", DbType.AnsiString, model.Operator);
     db.ExecuteNonQuery(dbCommand);
 }
 /// <summary>
 ///  ����һ������
 /// </summary>
 public void Add(NoName.NetShop.Model.VoteGroupModel model)
 {
     Database db = DatabaseFactory.CreateDatabase();
     DbCommand dbCommand = db.GetStoredProcCommand("UP_voVoteGroup_ADD");
     db.AddInParameter(dbCommand, "VoteGroupId", DbType.Int32, model.VoteGroupId);
     db.AddInParameter(dbCommand, "VoteId", DbType.Int32, model.VoteId);
     db.AddInParameter(dbCommand, "GroupType", DbType.Byte, model.GroupType);
     db.AddInParameter(dbCommand, "Subject", DbType.AnsiString, model.Subject);
     db.AddInParameter(dbCommand, "Content", DbType.AnsiString, model.Content);
     db.ExecuteNonQuery(dbCommand);
 }
 /// <summary>
 ///  ����һ������
 /// </summary>
 public void Add(NoName.NetShop.Model.VoteItemsModel model)
 {
     Database db = DatabaseFactory.CreateDatabase();
     DbCommand dbCommand = db.GetStoredProcCommand("UP_voVoteItems_ADD");
     db.AddInParameter(dbCommand, "VoteGroupId", DbType.Int32, model.VoteGroupId);
     db.AddInParameter(dbCommand, "VoteId", DbType.Int32, model.VoteId);
     db.AddInParameter(dbCommand, "ItemId", DbType.Int32, model.ItemId);
     db.AddInParameter(dbCommand, "ItemContent", DbType.AnsiString, model.ItemContent);
     db.AddInParameter(dbCommand, "VoteCount", DbType.Int32, model.VoteCount);
     db.ExecuteNonQuery(dbCommand);
 }
 /// <summary>
 ///  ����һ������
 /// </summary>
 public void Add(NoName.NetShop.Model.VoteRemarkModel model)
 {
     Database db = DatabaseFactory.CreateDatabase();
     DbCommand dbCommand = db.GetStoredProcCommand("UP_voVoteRemark_ADD");
     db.AddInParameter(dbCommand, "VoteId", DbType.Int32, model.VoteId);
     db.AddInParameter(dbCommand, "UserId", DbType.Int32, model.UserId);
     db.AddInParameter(dbCommand, "Remark", DbType.AnsiString, model.Remark);
     db.AddInParameter(dbCommand, "VoteTime", DbType.DateTime, model.VoteTime);
     db.AddInParameter(dbCommand, "VoteIP", DbType.AnsiString, model.VoteIP);
     db.ExecuteNonQuery(dbCommand);
 }
 /// <summary>
 ///  ����һ������
 /// </summary>
 public void Add(NoName.NetShop.Model.UserModel model)
 {
     Database db = DatabaseFactory.CreateDatabase();
     DbCommand dbCommand = db.GetStoredProcCommand("UP_maUser_ADD");
     db.AddInParameter(dbCommand, "UserId", DbType.Int32, model.UserId);
     db.AddInParameter(dbCommand, "UserName", DbType.AnsiString, model.UserName);
     db.AddInParameter(dbCommand, "UserEmail", DbType.AnsiString, model.UserEmail);
     db.AddInParameter(dbCommand, "Password", DbType.AnsiString, model.Password);
     db.AddInParameter(dbCommand, "LastLoginTime", DbType.DateTime, model.LastLoginTime);
     db.ExecuteNonQuery(dbCommand);
 }
 /// <summary>
 ///  ����һ������
 /// </summary>
 public void Add(NoName.NetShop.Model.SuitSchemeModel model)
 {
     Database db = DatabaseFactory.CreateDatabase();
     DbCommand dbCommand = db.GetStoredProcCommand("UP_ssSuitScheme_ADD");
     db.AddInParameter(dbCommand, "SchemeId", DbType.Int32, model.SchemeId);
     db.AddInParameter(dbCommand, "SchemeName", DbType.AnsiString, model.SchemeName);
     db.AddInParameter(dbCommand, "CreateTime", DbType.DateTime, model.CreateTime);
     db.AddInParameter(dbCommand, "Status", DbType.Byte, model.Status);
     db.AddInParameter(dbCommand, "SchemeDesc", DbType.AnsiString, model.SchemeDesc);
     db.ExecuteNonQuery(dbCommand);
 }
 /// <summary>
 ///  ����һ������
 /// </summary>
 public void Add(NoName.NetShop.Model.SuitProductModel model)
 {
     Database db = DatabaseFactory.CreateDatabase();
     DbCommand dbCommand = db.GetStoredProcCommand("UP_pdSuitProduct_ADD");
     db.AddInParameter(dbCommand, "SuitProductId", DbType.Int32, model.SuitProductId);
     db.AddInParameter(dbCommand, "ProductId", DbType.Int32, model.ProductId);
     db.AddInParameter(dbCommand, "SuitName", DbType.AnsiString, model.SuitName);
     db.AddInParameter(dbCommand, "MerchantPrice", DbType.Decimal, model.MerchantPrice);
     db.AddInParameter(dbCommand, "TradePrice", DbType.Decimal, model.TradePrice);
     db.AddInParameter(dbCommand, "Status", DbType.Byte, model.Status);
     db.ExecuteNonQuery(dbCommand);
 }
 /// <summary>
 ///  ����һ������
 /// </summary>
 public void Add(NoName.NetShop.Model.BrandModel model)
 {
     Database db = DatabaseFactory.CreateDatabase();
     DbCommand dbCommand = db.GetStoredProcCommand("UP_pdBrand_ADD");
     db.AddInParameter(dbCommand, "BrandId", DbType.Int32, model.BrandId);
     db.AddInParameter(dbCommand, "BrandName", DbType.AnsiString, model.BrandName);
     db.AddInParameter(dbCommand, "CateId", DbType.Int32, model.CateId);
     db.AddInParameter(dbCommand, "CatePath", DbType.AnsiString, model.CatePath);
     db.AddInParameter(dbCommand, "BrandLogo", DbType.AnsiString, model.BrandLogo);
     db.AddInParameter(dbCommand, "Brief", DbType.AnsiString, model.Brief);
     db.ExecuteNonQuery(dbCommand);
 }
 /// <summary>
 ///  ����һ������
 /// </summary>
 public void Add(NoName.NetShop.Model.ProductImageModel model)
 {
     Database db = DatabaseFactory.CreateDatabase();
     DbCommand dbCommand = db.GetStoredProcCommand("UP_pdProductImage_ADD");
     db.AddInParameter(dbCommand, "ImageId", DbType.Int32, model.ImageId);
     db.AddInParameter(dbCommand, "ProductId", DbType.Int32, model.ProductId);
     db.AddInParameter(dbCommand, "SmallImage", DbType.AnsiString, model.SmallImage);
     db.AddInParameter(dbCommand, "LargeImage", DbType.AnsiString, model.LargeImage);
     db.AddInParameter(dbCommand, "OriginImage", DbType.AnsiString, model.OriginImage);
     db.AddInParameter(dbCommand, "Title", DbType.AnsiString, model.Title);
     db.ExecuteNonQuery(dbCommand);
 }
 /// <summary>
 ///  ����һ������
 /// </summary>
 public void Add(NoName.NetShop.Model.PagesModel model)
 {
     Database db = DatabaseFactory.CreateDatabase();
     DbCommand dbCommand = db.GetStoredProcCommand("UP_cmsPages_ADD");
     db.AddInParameter(dbCommand, "PageId", DbType.Int32, model.PageId);
     db.AddInParameter(dbCommand, "TemplateFile", DbType.AnsiString, model.TemplateFile);
     db.AddInParameter(dbCommand, "PageUrl", DbType.AnsiString, model.PageUrl);
     db.AddInParameter(dbCommand, "PagePhyPath", DbType.AnsiString, model.PagePhyPath);
     db.AddInParameter(dbCommand, "Status", DbType.Byte, model.Status);
     db.AddInParameter(dbCommand, "LastPubTime", DbType.DateTime, model.LastPubTime);
     db.ExecuteNonQuery(dbCommand);
 }
 /// <summary>
 ///  ����һ������
 /// </summary>
 public void Add(NoName.NetShop.Model.AnswerModel model)
 {
     Database db = DatabaseFactory.CreateDatabase();
     DbCommand dbCommand = db.GetStoredProcCommand("UP_qaAnswer_ADD");
     db.AddInParameter(dbCommand, "QuestionId", DbType.Int32, model.QuestionId);
     db.AddInParameter(dbCommand, "AnswerId", DbType.Int32, model.AnswerId);
     db.AddInParameter(dbCommand, "Title", DbType.AnsiString, model.Title);
     db.AddInParameter(dbCommand, "Brief", DbType.AnsiString, model.Brief);
     db.AddInParameter(dbCommand, "Content", DbType.String, model.Content);
     db.AddInParameter(dbCommand, "AnswerTime", DbType.DateTime, model.AnswerTime);
     db.ExecuteNonQuery(dbCommand);
 }
 /// <summary>
 ///  ����һ������
 /// </summary>
 public void Add(NoName.NetShop.Model.TagsModel model)
 {
     Database db = DatabaseFactory.CreateDatabase();
     DbCommand dbCommand = db.GetStoredProcCommand("UP_cmsTags_ADD");
     db.AddInParameter(dbCommand, "CmsTagId", DbType.Int32, model.CmsTagId);
     db.AddInParameter(dbCommand, "CmsTagName", DbType.AnsiString, model.CmsTagName);
     db.AddInParameter(dbCommand, "TagBrief", DbType.AnsiString, model.TagBrief);
     db.AddInParameter(dbCommand, "DefaultContent", DbType.AnsiString, model.DefaultContent);
     db.AddInParameter(dbCommand, "TagType", DbType.AnsiString, model.TagType);
     db.AddInParameter(dbCommand, "TagParas", DbType.AnsiString, model.TagParas);
     db.ExecuteNonQuery(dbCommand);
 }
 /// <summary>
 ///  ����һ������
 /// </summary>
 public void Add(NoName.NetShop.Model.CategoryModel model)
 {
     Database db = DatabaseFactory.CreateDatabase();
     DbCommand dbCommand = db.GetStoredProcCommand("UP_pdCategory_ADD");
     db.AddInParameter(dbCommand, "CateId", DbType.Int32, model.CateId);
     db.AddInParameter(dbCommand, "CateName", DbType.AnsiString, model.CateName);
     db.AddInParameter(dbCommand, "CatePath", DbType.AnsiString, model.CatePath);
     db.AddInParameter(dbCommand, "Status", DbType.Byte, model.Status);
     db.AddInParameter(dbCommand, "PriceRange", DbType.AnsiString, model.PriceRange);
     db.AddInParameter(dbCommand, "IsHide", DbType.Boolean, model.IsHide);
     db.AddInParameter(dbCommand, "CateLevel", DbType.Byte, model.CateLevel);
     db.ExecuteNonQuery(dbCommand);
 }
 /// <summary>
 ///  ����һ������
 /// </summary>
 public void Add(NoName.NetShop.Model.FavoriteModel model)
 {
     Database db = DatabaseFactory.CreateDatabase();
     DbCommand dbCommand = db.GetStoredProcCommand("UP_umFavorite_ADD");
     db.AddInParameter(dbCommand, "UserId", DbType.Int32, model.UserId);
     db.AddInParameter(dbCommand, "FavoriteId", DbType.Int32, model.FavoriteId);
     db.AddInParameter(dbCommand, "FavoriteUrl", DbType.AnsiString, model.FavoriteUrl);
     db.AddInParameter(dbCommand, "FavoriteName", DbType.AnsiString, model.FavoriteName);
     db.AddInParameter(dbCommand, "InsertTime", DbType.DateTime, model.InsertTime);
     db.AddInParameter(dbCommand, "ContentId", DbType.Int32, model.ContentId);
     db.AddInParameter(dbCommand, "ContentType", DbType.Byte, model.ContentType);
     db.ExecuteNonQuery(dbCommand);
 }
 /// <summary>
 /// 增加一条数据
 /// </summary>
 public void Add(NoName.NetShop.Comment.QuestionModel model)
 {
     Database db = CommDataAccess.DbReader;
     if (model.QuestionId == 0)
         model.QuestionId = CommDataHelper.GetNewSerialNum(AppType.Other);
     DbCommand dbCommand = db.GetStoredProcCommand("UP_qaQuestion_ADD");
     db.AddInParameter(dbCommand, "QuestionId", DbType.Int32, model.QuestionId);
     db.AddInParameter(dbCommand, "UserId", DbType.AnsiString, model.UserId);
     db.AddInParameter(dbCommand, "ContentId", DbType.Int32, model.ContentId);
     db.AddInParameter(dbCommand, "Title", DbType.AnsiString, model.Title);
     db.AddInParameter(dbCommand, "Content", DbType.AnsiString, model.Content);
     db.AddInParameter(dbCommand, "@contentType", DbType.Int16, (int)model.ContentType);
        db.ExecuteNonQuery(dbCommand);
 }
 /// <summary>
 ///  ����һ������
 /// </summary>
 public void Add(NoName.NetShop.Model.OrderItemModel model)
 {
     Database db = DatabaseFactory.CreateDatabase();
     DbCommand dbCommand = db.GetStoredProcCommand("UP_spOrderItem_ADD");
     db.AddInParameter(dbCommand, "OrderId", DbType.Int32, model.OrderId);
     db.AddInParameter(dbCommand, "OrderItem", DbType.Int32, model.OrderItem);
     db.AddInParameter(dbCommand, "ProductId", DbType.Int32, model.ProductId);
     db.AddInParameter(dbCommand, "ProductFee", DbType.Decimal, model.ProductFee);
     db.AddInParameter(dbCommand, "Quantity", DbType.Int32, model.Quantity);
     db.AddInParameter(dbCommand, "DerateFee", DbType.Decimal, model.DerateFee);
     db.AddInParameter(dbCommand, "MerchantPrice", DbType.Decimal, model.MerchantPrice);
     db.AddInParameter(dbCommand, "TotalFee", DbType.Decimal, model.TotalFee);
     db.ExecuteNonQuery(dbCommand);
 }
 /// <summary>
 ///  ����һ������
 /// </summary>
 public void Add(NoName.NetShop.Model.SupplyDemandModel model)
 {
     Database db = DatabaseFactory.CreateDatabase();
     DbCommand dbCommand = db.GetStoredProcCommand("UP_sdSupplyDemand_ADD");
     db.AddInParameter(dbCommand, "sdId", DbType.Int32, model.sdId);
     db.AddInParameter(dbCommand, "sdType", DbType.Byte, model.sdType);
     db.AddInParameter(dbCommand, "userId", DbType.Int32, model.userId);
     db.AddInParameter(dbCommand, "Title", DbType.AnsiString, model.Title);
     db.AddInParameter(dbCommand, "Content", DbType.AnsiString, model.Content);
     db.AddInParameter(dbCommand, "InsertTime", DbType.DateTime, model.InsertTime);
     db.AddInParameter(dbCommand, "ModifyTime", DbType.DateTime, model.ModifyTime);
     db.AddInParameter(dbCommand, "Status", DbType.Byte, model.Status);
     db.ExecuteNonQuery(dbCommand);
 }
Пример #26
0
        /// <summary>
        ///  增加一条数据
        /// </summary>
        public void Add(NoName.NetShop.Comment.ReplyModel model)
        {
            Database db = CommDataAccess.DbWriter;
            DbCommand dbCommand = db.GetStoredProcCommand("UP_qaReply_ADD");
            if (model.ReplyId == 0)
                model.ReplyId = NetShop.Common.CommDataHelper.GetNewSerialNum(AppType.Other);

            db.AddInParameter(dbCommand, "TopicId", DbType.Int32, model.TopicId);
            db.AddInParameter(dbCommand, "ReplyId", DbType.Int32, model.ReplyId);
            db.AddInParameter(dbCommand, "Title", DbType.AnsiString, model.Title);
            db.AddInParameter(dbCommand, "Content", DbType.String, model.Content);
            db.AddInParameter(dbCommand, "UserId", DbType.String, model.UserId);
            db.ExecuteNonQuery(dbCommand);
        }
 /// <summary>
 ///  ����һ������
 /// </summary>
 public void Add(NoName.NetShop.Model.CategoryParaModel model)
 {
     Database db = DatabaseFactory.CreateDatabase();
     DbCommand dbCommand = db.GetStoredProcCommand("UP_pdCategoryPara_ADD");
     db.AddInParameter(dbCommand, "ParaId", DbType.Int32, model.ParaId);
     db.AddInParameter(dbCommand, "CateId", DbType.Int32, model.CateId);
     db.AddInParameter(dbCommand, "ParaName", DbType.AnsiString, model.ParaName);
     db.AddInParameter(dbCommand, "ParaType", DbType.Byte, model.ParaType);
     db.AddInParameter(dbCommand, "Status", DbType.Byte, model.Status);
     db.AddInParameter(dbCommand, "ParaGroupId", DbType.Int32, model.ParaGroupId);
     db.AddInParameter(dbCommand, "ParaValues", DbType.AnsiString, model.ParaValues);
     db.AddInParameter(dbCommand, "DefaultValue", DbType.AnsiString, model.DefaultValue);
     db.ExecuteNonQuery(dbCommand);
 }
 /// <summary>
 ///  ����һ������
 /// </summary>
 public void Add(NoName.NetShop.Model.MessageModel model)
 {
     Database db = DatabaseFactory.CreateDatabase();
     DbCommand dbCommand = db.GetStoredProcCommand("UP_imMessage_ADD");
     db.AddInParameter(dbCommand, "UserId", DbType.Int32, model.UserId);
     db.AddInParameter(dbCommand, "MsgId", DbType.Int32, model.MsgId);
     db.AddInParameter(dbCommand, "MsgType", DbType.Byte, model.MsgType);
     db.AddInParameter(dbCommand, "Subject", DbType.AnsiString, model.Subject);
     db.AddInParameter(dbCommand, "Content", DbType.AnsiString, model.Content);
     db.AddInParameter(dbCommand, "SenderId", DbType.Int32, model.SenderId);
     db.AddInParameter(dbCommand, "InsertTime", DbType.DateTime, model.InsertTime);
     db.AddInParameter(dbCommand, "ReadTime", DbType.DateTime, model.ReadTime);
     db.AddInParameter(dbCommand, "Status", DbType.Int32, model.Status);
     db.ExecuteNonQuery(dbCommand);
 }
Пример #29
0
 public void Save(NoName.NetShop.Member.Model.AddressModel model)
 {
     if (model.AddressId == 0)
     {
         model.AddressId = Common.CommDataHelper.GetNewSerialNum(AppType.Address);
     }
     if (dal.Exists(model.AddressId))
     {
         dal.Update(model);
     }
     else
     {
         dal.Add(model);
     }
 }
 /// <summary>
 ///  ����һ������
 /// </summary>
 public void Add(NoName.NetShop.Model.VoteTopicModel model)
 {
     Database db = DatabaseFactory.CreateDatabase();
     DbCommand dbCommand = db.GetStoredProcCommand("UP_voVoteTopic_ADD");
     db.AddInParameter(dbCommand, "VoteId", DbType.Int32, model.VoteId);
     db.AddInParameter(dbCommand, "ContentId", DbType.Int32, model.ContentId);
     db.AddInParameter(dbCommand, "ContentType", DbType.Byte, model.ContentType);
     db.AddInParameter(dbCommand, "Topic", DbType.AnsiString, model.Topic);
     db.AddInParameter(dbCommand, "Remark", DbType.AnsiString, model.Remark);
     db.AddInParameter(dbCommand, "StartTime", DbType.DateTime, model.StartTime);
     db.AddInParameter(dbCommand, "EndTime", DbType.DateTime, model.EndTime);
     db.AddInParameter(dbCommand, "IsRegUser", DbType.Boolean, model.IsRegUser);
     db.AddInParameter(dbCommand, "VoteUserNum", DbType.Int32, model.VoteUserNum);
     db.ExecuteNonQuery(dbCommand);
 }
Пример #31
0
    // Use this for initialization
    void Start()
    {
        level = 0;
        LoadLevel();
        SetTextGUI();
        SetFillAmuontGarbage();
        noname = GameObject.Find("Canvas").GetComponentInChildren <NoName>();
        if (noname == null)
        {
            Debug.Log("Khong the tim thay NoName");
        }
        ListDelete     = new List <GameObject>();
        listMouse      = new List <GameObject>();
        listLoangDau   = new List <List <GameObject> >();
        listConect     = new List <GameObject>();
        activeAddtime  = false;
        activeTimeHelp = true;
        RandomGem();// random hinh anh khi moi dua vao game o vi tri ItweenPos
        CheckListInvalid();

        _countGround = 20;
    }
Пример #32
0
 public void UpdateCheckPoint(string id, string status)
 {
     checkPoint = new NoName(id, status);
 }