/// <summary> /// 更新评论支持 /// </summary> /// <param name="model">评论支持模型数据</param> /// <returns>成功系统号记录</returns> /// <remarks>2013-08-27 杨晗 创建</remarks> public override int Update(FeCommentSupport model) { return(Context.Update <FeCommentSupport>("FeCommentSupport", model) .AutoMap(x => x.SysNo) .Where(x => x.SysNo) .Execute()); }
/// <summary> /// 更新评论支持 /// </summary> /// <param name="isSupport">是否是支持</param> /// <param name="feCommentSysNo">评论表系统编号</param> /// <param name="customerSysNo">操作人</param> /// <param name="context">数据库操作上下文(用于共用数据库连接)</param> /// <returns>返回 true:成功 false:失败</returns> /// <remarks>2013-08-13 邵斌 创建</remarks> public override bool Update(bool isSupport, int feCommentSysNo, int customerSysNo, IDbContext context = null) { //判断并获取默认数据库操作上下文 context = context ?? Context; //如果为空就先插入新对象 if (!Exist(feCommentSysNo, customerSysNo, context)) { //插入前检查数据是否完整 if (feCommentSysNo != 0 && customerSysNo != 0) { FeCommentSupport tempMode = new FeCommentSupport(); tempMode.ProductCommentSysNo = feCommentSysNo; //判断是支持+1 还是不支持+1 if (isSupport) { tempMode.SupportCount = 1; } else { tempMode.UnSupportCount = 1; } //初始化其他数据 tempMode = new FeCommentSupport(); tempMode.CustomerSysNo = customerSysNo; tempMode.CreatedBy = customerSysNo; tempMode.CreateDate = DateTime.Now; tempMode.LastUpdateBy = customerSysNo; tempMode.LastUpdateDate = DateTime.Now; //添加新对象 Add(tempMode, context); } else { //错误提示 throw new HytException("添加评论支持失败,没有正确设置评论人或评论商品对象"); } } string sql; //判断是支持+1 还是不支持+1 //因为没有时间戳,所以采用动态更新方式,以避免并发问题 if (isSupport) { sql = "update FeProductComment set SupportCount = SupportCount+1 where sysno=@0"; } else { sql = "update FeProductComment set UnSupportCount = UnSupportCount+1 where sysno=@0"; } //返回结果 return(context.Sql(sql, feCommentSysNo).Execute() > 0); }
/// <summary> /// 操作有用或没用(有用SupportCount传1,UnSupportCount传0,否则相反) /// </summary> /// <param name="model">评论支持模型数据</param> /// <returns>操作成功true,否则false</returns> public string Step(FeCommentSupport model) { var m = IFeCommentSupportDao.Instance.GetModel(model.ProductCommentSysNo, model.CustomerSysNo); if (model.SupportCount == 1) { if (IsSupportCount(model.ProductCommentSysNo, model.CustomerSysNo)) { return("您已经顶过了"); } else { if (m != null) { m.SupportCount = 1; int edit = IFeCommentSupportDao.Instance.Update(m); return(edit > 0 ? "操作成功" : "操作失败"); } else { int ins = IFeCommentSupportDao.Instance.Insert(model); return(ins > 0 ? "操作成功" : "操作失败"); } } } else { if (IsUnSupportCount(model.ProductCommentSysNo, model.CustomerSysNo)) { return("您已经踩过了"); } else { if (m != null) { m.UnSupportCount = 1; int edit = IFeCommentSupportDao.Instance.Update(m); return(edit > 0 ? "操作成功" : "操作失败"); } else { int ins = IFeCommentSupportDao.Instance.Insert(model); return(ins > 0 ? "操作成功" : "操作失败"); } } } }
/// <summary> /// 添加评论支持 /// </summary> /// <param name="model">评论支持数据模型</param> /// <param name="context">数据库操作上下文(用于共用数据库连接)</param> /// <returns>返回 true:成功 false:失败</returns> /// <remarks>2013-08-13 邵斌 创建</remarks> public override bool Add(FeCommentSupport model, IDbContext context = null) { //判断并获取默认数据库操作上下文 context = context ?? Context; //添加数据库 model.SysNo = context.Insert <FeCommentSupport>("FeCommentSupport", model).AutoMap(fc => fc.SysNo).ExecuteReturnLastId <int>("SysNo"); //返回结果 return(model.SysNo > 0); }
private void AddBaseTaskObjectToList(List <BaseTask> listObject) { BaseTask bsAT = new BsArea(); BaseTask bsDP = new BsDeliveryPayment(); BaseTask bsPT = new BsPaymentType(); BaseTask bsCode = new BsCode(); BaseTask bsOrganization = new BsOrganization(); BaseTask bsOrganizationWarehouse = new BsOrganizationWarehouse(); BaseTask crCustomer = new CrCustomer(); BaseTask crCL = new CrCustomerLevel(); BaseTask crCQ = new CrCustomerQuestion(); BaseTask crRA = new CrReceiveAddress(); BaseTask dsMallType = new DsMallType(); BaseTask dsDealerLevel = new DsDealerLevel(); BaseTask feArticle = new FeArticle(); BaseTask feAC = new FeArticleCategory(); BaseTask feCS = new FeCommentSupport(); BaseTask fepc = new FeProductComment(); BaseTask fePCI = new FeProductCommentImage(); BaseTask fePCR = new FeProductCommentReply(); BaseTask feSearchKeyword = new FeSearchKeyword(); BaseTask feadvertgroup = new FeAdvertGroup(); BaseTask feadvertitem = new FeAdvertItem(); BaseTask feproductgroup = new FeProductGroup(); BaseTask feproductitem = new FeProductItem(); BaseTask fnIT = new FnInvoiceType(); BaseTask fninvoice = new FnInvoice(); BaseTask fnpv = new FnReceiptVoucher(); BaseTask fnReceiptVoucherItem = new FnReceiptVoucherItem(); BaseTask fnop = new FnOnlinePayment(); BaseTask fnPaymentVoucher = new FnPaymentVoucher(); BaseTask fnPaymentVoucherItem = new FnPaymentVoucherItem(); BaseTask lgDelivery = new LgDelivery(); BaseTask lgDI = new LgDeliveryItem(); BaseTask lgDS = new LgDeliveryScope(); BaseTask lgDT = new LgDeliveryType(); BaseTask lgDUC = new LgDeliveryUserCredit(); BaseTask lgPT = new LgPickupType(); BaseTask lgsettlement = new LgSettlement(); BaseTask lgSI = new LgSettlementItem(); BaseTask lgDeliveryPrintTemplate = new LgDeliveryPrintTemplate(); BaseTask pdAttribute = new PdAttribute(); BaseTask pdAG = new PdAttributeGroup(); BaseTask pdAGA = new PdAttributeGroupAssociation(); BaseTask pdAO = new PdAttributeOption(); BaseTask pdBrand = new PdBrand(); BaseTask pdCGA = new PdCatAttributeGroupAso(); BaseTask pdCategory = new PdCategory(); BaseTask pdCA = new PdCategoryAssociation(); BaseTask pdPrice = new PdPrice(); BaseTask pdProduct = new PdProduct(); BaseTask pdPA = new PdProductAssociation(); BaseTask pdProductAttribute = new PdProductAttribute(); BaseTask pdPI = new PdProductImage(); BaseTask pdTemplate = new PdTemplate(); BaseTask pdProductStatistics = new PdProductStatistics(); BaseTask soOrder = new SoOrder(); BaseTask soOrderItem = new SoOrderItem(); BaseTask soRA = new SoReceiveAddress(); BaseTask SyUG = new SyUserGroup(); BaseTask syGU = new SyGroupUser(); BaseTask syMenu = new SyMenu(); BaseTask syMenuPrivilege = new SyMenuPrivilege(); BaseTask syPrivilege = new SyPrivilege(); BaseTask syRole = new SyRole(); BaseTask syRoleMenu = new SyRoleMenu(); BaseTask syRolePrivilege = new SyRolePrivilege(); BaseTask syPermission = new SyPermission(); BaseTask syUser = new SyUser(); BaseTask syUW = new SyUserWarehouse(); BaseTask syMyMenu = new SyMyMenu(); BaseTask spcombo = new SpCombo(); BaseTask spComboItem = new SpComboItem(); BaseTask spcopon = new spcoupon(); BaseTask sqpromotion = new SPpromotion(); BaseTask spromotiongift = new SPpromotiongift(); BaseTask sppromotionoverlay = new SPpromotionoverlay(); BaseTask sppromotionrule = new SPpromotionrule(); BaseTask sppromotionrulecondition = new SPpromotionrulecondition(); BaseTask sppromotionrulekeyvalue = new SPpromotionrulekeyvalue(); BaseTask syTaskConfig = new SyTaskConfig(); BaseTask whStockOut = new WhStockOut(); BaseTask whStockOutItem = new WhstockOutItem(); BaseTask whwarehouse = new WhWarehouse(); BaseTask whwa = new WHwarehousearea(); BaseTask whwdy = new WHwarehouseDeliveryType(); BaseTask whWPT = new WhWarehousePickupType(); BaseTask whstockin = new WhStockIn(); BaseTask whstockinItem = new WHStockinItem(); BaseTask rcReturn = new RCReturn(); BaseTask rcReturnItem = new RcReturnItem(); listObject.Add(bsAT); listObject.Add(bsDP); listObject.Add(bsPT); listObject.Add(bsCode); listObject.Add(bsOrganization); listObject.Add(bsOrganizationWarehouse); listObject.Add(crCustomer); listObject.Add(crCL); listObject.Add(crCQ); listObject.Add(crRA); listObject.Add(dsMallType); listObject.Add(dsDealerLevel); listObject.Add(feArticle); listObject.Add(feAC); listObject.Add(feCS); listObject.Add(fePCI); listObject.Add(fePCR); listObject.Add(fepc); listObject.Add(feSearchKeyword); listObject.Add(feadvertgroup); listObject.Add(feadvertitem); listObject.Add(feproductgroup); listObject.Add(feproductitem); listObject.Add(fnIT); listObject.Add(fnpv); listObject.Add(fnReceiptVoucherItem); listObject.Add(fnop); listObject.Add(fninvoice); listObject.Add(fnPaymentVoucher); listObject.Add(fnPaymentVoucherItem); listObject.Add(lgDelivery); listObject.Add(lgDI); listObject.Add(lgDS); listObject.Add(lgDT); listObject.Add(lgPT); listObject.Add(lgsettlement); listObject.Add(lgSI); listObject.Add(lgDeliveryPrintTemplate); listObject.Add(pdAttribute); listObject.Add(pdAG); listObject.Add(pdAGA); listObject.Add(pdAO); listObject.Add(pdBrand); listObject.Add(pdCGA); listObject.Add(pdCategory); listObject.Add(pdCA); listObject.Add(pdPrice); listObject.Add(pdProduct); listObject.Add(pdPA); listObject.Add(pdProductAttribute); listObject.Add(pdTemplate); listObject.Add(pdProductStatistics); listObject.Add(soOrder); listObject.Add(soOrderItem); listObject.Add(spcombo); listObject.Add(spComboItem); listObject.Add(spcopon); listObject.Add(sqpromotion); listObject.Add(spromotiongift); //listObject.Add(sppromotionoverlay); listObject.Add(sppromotionrule); listObject.Add(sppromotionrulecondition); listObject.Add(sppromotionrulekeyvalue); listObject.Add(syGU); listObject.Add(syUW); listObject.Add(SyUG); listObject.Add(syMenu); listObject.Add(syUser); listObject.Add(syPermission); listObject.Add(syMenuPrivilege); listObject.Add(syPrivilege); listObject.Add(syRole); listObject.Add(syRoleMenu); listObject.Add(syRolePrivilege); listObject.Add(syMyMenu); listObject.Add(syTaskConfig); listObject.Add(whStockOut); listObject.Add(whStockOutItem); listObject.Add(whwarehouse); listObject.Add(whwa); listObject.Add(whwdy); listObject.Add(whWPT); listObject.Add(whstockin); listObject.Add(whstockinItem); listObject.Add(rcReturn); listObject.Add(rcReturnItem); listObject.Add(lgDUC); listObject.Add(pdPI); listObject.Add(soRA); }
/// <summary> /// 增加评论支持 /// </summary> /// <param name="model">评论支持模型数据</param> /// <returns>成功系统号记录</returns> /// <remarks>2013-08-27 杨晗 创建</remarks> public int Insert(FeCommentSupport model) { return(IFeCommentSupportDao.Instance.Insert(model)); }
/// <summary> /// 二期基础数据 /// </summary> /// <param name="listObject"></param> private void AddBaseTaskObject2ToList1(List <BaseTask> listObject) { BaseTask bsAT = new BsArea(); BaseTask crCustomer = new CrCustomer(); BaseTask crCL = new CrCustomerLevel(); BaseTask crCQ = new CrCustomerQuestion(); BaseTask crRA = new CrReceiveAddress(); BaseTask feArticle = new FeArticle(); BaseTask feAC = new FeArticleCategory(); BaseTask feCS = new FeCommentSupport(); BaseTask fepc = new FeProductComment(); BaseTask fePCI = new FeProductCommentImage(); BaseTask fePCR = new FeProductCommentReply(); BaseTask lgDS = new LgDeliveryScope(); BaseTask lgDUC = new LgDeliveryUserCredit(); BaseTask pdAttribute = new PdAttribute(); BaseTask pdAG = new PdAttributeGroup(); BaseTask pdAGA = new PdAttributeGroupAssociation(); BaseTask pdAO = new PdAttributeOption(); BaseTask pdBrand = new PdBrand(); BaseTask pdCGA = new PdCatAttributeGroupAso(); BaseTask pdCategory = new PdCategory(); BaseTask pdCA = new PdCategoryAssociation(); BaseTask pdPrice = new PdPrice(); BaseTask pdProduct = new PdProduct(); BaseTask pdPA = new PdProductAssociation(); BaseTask pdProductAttribute = new PdProductAttribute(); //BaseTask pdPI = new PdProductImage(); BaseTask pdTemplate = new PdTemplate(); BaseTask soRA = new SoReceiveAddress(); BaseTask syUser = new SyUser(); BaseTask syUW = new SyUserWarehouse(); BaseTask whwarehouse = new WhWarehouse(); BaseTask whwa = new WHwarehousearea(); listObject.Add(bsAT); listObject.Add(crCustomer); listObject.Add(crCL); listObject.Add(crCQ); listObject.Add(crRA); listObject.Add(feArticle); listObject.Add(feAC); listObject.Add(feCS); listObject.Add(fepc); listObject.Add(fePCI); listObject.Add(fePCR); listObject.Add(lgDS); listObject.Add(lgDUC); listObject.Add(pdAttribute); listObject.Add(pdAG); listObject.Add(pdAGA); listObject.Add(pdAO); listObject.Add(pdBrand); listObject.Add(pdCGA); listObject.Add(pdCategory); listObject.Add(pdCA); listObject.Add(pdPrice); listObject.Add(pdProduct); listObject.Add(pdPA); listObject.Add(pdProductAttribute); listObject.Add(pdTemplate); //listObject.Add(pdPI); listObject.Add(soRA); listObject.Add(syUW); listObject.Add(syUser); listObject.Add(whwarehouse); listObject.Add(whwa); }
/// <summary> /// 添加评论支持 /// </summary> /// <param name="model">评论支持数据模型</param> /// <param name="context">数据库操作上下文(用于共用数据库连接)</param> /// <returns>返回 true:成功 false:失败</returns> /// <remarks>2013-08-13 邵斌 创建</remarks> public abstract bool Add(FeCommentSupport model, IDbContext context = null);
/// <summary> /// 增加评论支持 /// </summary> /// <param name="model">评论支持模型数据</param> /// <returns>成功系统号记录</returns> /// <remarks>2013-08-27 杨晗 创建</remarks> public override int Insert(FeCommentSupport model) { return(Context.Insert <FeCommentSupport>("FeCommentSupport", model) .AutoMap(x => x.SysNo) .ExecuteReturnLastId <int>("Sysno")); }
/// <summary> /// 更新评论支持 /// </summary> /// <param name="model">评论支持模型数据</param> /// <returns>成功系统号记录</returns> /// <remarks>2013-08-27 杨晗 创建</remarks> public abstract int Update(FeCommentSupport model);
/// <summary> /// 增加评论支持 /// </summary> /// <param name="model">评论支持模型数据</param> /// <returns>成功系统号记录</returns> /// <remarks>2013-08-27 杨晗 创建</remarks> public abstract int Insert(FeCommentSupport model);