public void CreateReview(ReviewInfo oInfo) { try { TransactionOptions options = new TransactionOptions(); options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted; options.Timeout = TransactionManager.DefaultTimeout; using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options)) { //һ���û�ÿ�����ֻ�ܷ���5������ int reviewCount = GetCustomerReviewCountByDate(oInfo.CustomerIP); if (reviewCount >= 5) throw new BizException("ͬһ��IPÿ�����ֻ�ܷ���5�����ۣ�"); this.InsertReviewMaster(oInfo); //���붩����Ʒ��ϸ if (oInfo.ReferenceType == (int)AppEnum.ReviewReferenceType.Product) { foreach (ReviewC3ItemScoreInfo item in oInfo.ReviewC3ItemScoreHash.Values) { item.ReviewSysNo = oInfo.SysNo; this.InsertReviewC3ItemScore(item); } } scope.Complete(); } } catch (Exception ex) { oInfo.SysNo = AppConst.IntNull; throw ex; } }
private void map(ReviewInfo oParam, DataRow tempdr) { oParam.SysNo = Util.TrimIntNull(tempdr["SysNo"]); oParam.ReviewType = Util.TrimIntNull(tempdr["ReviewType"]); oParam.Title = Util.TrimNull(tempdr["Title"]); oParam.Content1 = Util.TrimNull(tempdr["Content1"]); oParam.Content2 = Util.TrimNull(tempdr["Content2"]); oParam.Content3 = Util.TrimNull(tempdr["Content3"]); oParam.Score = Util.TrimIntNull(tempdr["Score"]); oParam.OwnedType = Util.TrimIntNull(tempdr["OwnedType"]); oParam.UnderstandingType = Util.TrimIntNull(tempdr["UnderstandingType"]); oParam.NickName = Util.TrimNull(tempdr["NickName"]); oParam.ReferenceType = Util.TrimIntNull(tempdr["ReferenceType"]); oParam.ReferenceSysNo = Util.TrimIntNull(tempdr["ReferenceSysNo"]); oParam.IsTop = Util.TrimIntNull(tempdr["IsTop"]); oParam.IsGood = Util.TrimIntNull(tempdr["IsGood"]); oParam.TotalRemarkCount = Util.TrimIntNull(tempdr["TotalRemarkCount"]); oParam.TotalHelpfulRemarkCount = Util.TrimIntNull(tempdr["TotalHelpfulRemarkCount"]); oParam.TotalComplainCount = Util.TrimIntNull(tempdr["TotalComplainCount"]); oParam.Status = Util.TrimIntNull(tempdr["Status"]); oParam.CreateCustomerSysNo = Util.TrimIntNull(tempdr["CreateCustomerSysNo"]); oParam.CreateDate = Util.TrimDateNull(tempdr["CreateDate"]); oParam.LastEditUserSysNo = Util.TrimIntNull(tempdr["LastEditUserSysNo"]); oParam.LastEditDate = Util.TrimDateNull(tempdr["LastEditDate"]); oParam.CustomerIP = Util.TrimNull(tempdr["CustomerIP"]); }
public int UpdateReviewMaster(ReviewInfo oParam) { return new ReviewDac().Update(oParam); }
public ReviewInfo LoadReviewMaster(int ReviewSysNo) { string sql = "select * from review_master where sysno=" + ReviewSysNo; DataSet ds = SqlHelper.ExecuteDataSet(sql); if (Util.HasMoreRow(ds)) { ReviewInfo o = new ReviewInfo(); map(o, ds.Tables[0].Rows[0]); return o; } else return null; }
public int InsertReviewMaster(ReviewInfo oParam) { oParam.SysNo = SequenceDac.GetInstance().Create("Review_Sequence"); return new ReviewDac().Insert(oParam); }
public int Insert(ReviewInfo oParam) { string sql = @"INSERT INTO Review_Master ( SysNo, ReviewType, Title, Content1, Content2, Content3, Score, OwnedType, UnderstandingType, NickName, ReferenceType, ReferenceSysNo, IsTop, IsGood, TotalRemarkCount, TotalHelpfulRemarkCount, TotalComplainCount, Status, CreateCustomerSysNo, CreateDate, LastEditUserSysNo, LastEditDate,CustomerIP ) VALUES ( @SysNo, @ReviewType, @Title, @Content1, @Content2, @Content3, @Score, @OwnedType, @UnderstandingType, @NickName, @ReferenceType, @ReferenceSysNo, @IsTop, @IsGood, @TotalRemarkCount, @TotalHelpfulRemarkCount, @TotalComplainCount, @Status, @CreateCustomerSysNo, @CreateDate, @LastEditUserSysNo, @LastEditDate,@CustomerIP )"; SqlCommand cmd = new SqlCommand(sql); SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4); SqlParameter paramReviewType = new SqlParameter("@ReviewType", SqlDbType.Int, 4); SqlParameter paramTitle = new SqlParameter("@Title", SqlDbType.NVarChar, 200); SqlParameter paramContent1 = new SqlParameter("@Content1", SqlDbType.NVarChar, 1000); SqlParameter paramContent2 = new SqlParameter("@Content2", SqlDbType.NVarChar, 1000); SqlParameter paramContent3 = new SqlParameter("@Content3", SqlDbType.NVarChar, 1000); SqlParameter paramScore = new SqlParameter("@Score", SqlDbType.Int, 4); SqlParameter paramOwnedType = new SqlParameter("@OwnedType", SqlDbType.Int, 4); SqlParameter paramUnderstandingType = new SqlParameter("@UnderstandingType", SqlDbType.Int, 4); SqlParameter paramNickName = new SqlParameter("@NickName", SqlDbType.NVarChar, 50); SqlParameter paramReferenceType = new SqlParameter("@ReferenceType", SqlDbType.Int, 4); SqlParameter paramReferenceSysNo = new SqlParameter("@ReferenceSysNo", SqlDbType.Int, 4); SqlParameter paramIsTop = new SqlParameter("@IsTop", SqlDbType.Int, 4); SqlParameter paramIsGood = new SqlParameter("@IsGood", SqlDbType.Int, 4); SqlParameter paramTotalRemarkCount = new SqlParameter("@TotalRemarkCount", SqlDbType.Int, 4); SqlParameter paramTotalHelpfulRemarkCount = new SqlParameter("@TotalHelpfulRemarkCount", SqlDbType.Int, 4); SqlParameter paramTotalComplainCount = new SqlParameter("@TotalComplainCount", SqlDbType.Int, 4); SqlParameter paramStatus = new SqlParameter("@Status", SqlDbType.Int, 4); SqlParameter paramCreateCustomerSysNo = new SqlParameter("@CreateCustomerSysNo", SqlDbType.Int, 4); SqlParameter paramCreateDate = new SqlParameter("@CreateDate", SqlDbType.DateTime); SqlParameter paramLastEditUserSysNo = new SqlParameter("@LastEditUserSysNo", SqlDbType.Int, 4); SqlParameter paramLastEditDate = new SqlParameter("@LastEditDate", SqlDbType.DateTime); SqlParameter paramCustomerIP = new SqlParameter("@CustomerIP", SqlDbType.NVarChar, 30); if (oParam.SysNo != AppConst.IntNull) paramSysNo.Value = oParam.SysNo; else paramSysNo.Value = System.DBNull.Value; if (oParam.ReviewType != AppConst.IntNull) paramReviewType.Value = oParam.ReviewType; else paramReviewType.Value = System.DBNull.Value; if (oParam.Title != AppConst.StringNull) paramTitle.Value = oParam.Title; else paramTitle.Value = System.DBNull.Value; if (oParam.Content1 != AppConst.StringNull) paramContent1.Value = oParam.Content1; else paramContent1.Value = System.DBNull.Value; if (oParam.Content2 != AppConst.StringNull) paramContent2.Value = oParam.Content2; else paramContent2.Value = System.DBNull.Value; if (oParam.Content3 != AppConst.StringNull) paramContent3.Value = oParam.Content3; else paramContent3.Value = System.DBNull.Value; if (oParam.Score != AppConst.IntNull) paramScore.Value = oParam.Score; else paramScore.Value = System.DBNull.Value; if (oParam.OwnedType != AppConst.IntNull) paramOwnedType.Value = oParam.OwnedType; else paramOwnedType.Value = System.DBNull.Value; if (oParam.UnderstandingType != AppConst.IntNull) paramUnderstandingType.Value = oParam.UnderstandingType; else paramUnderstandingType.Value = System.DBNull.Value; if (oParam.NickName != AppConst.StringNull) paramNickName.Value = oParam.NickName; else paramNickName.Value = System.DBNull.Value; if (oParam.ReferenceType != AppConst.IntNull) paramReferenceType.Value = oParam.ReferenceType; else paramReferenceType.Value = System.DBNull.Value; if (oParam.ReferenceSysNo != AppConst.IntNull) paramReferenceSysNo.Value = oParam.ReferenceSysNo; else paramReferenceSysNo.Value = System.DBNull.Value; if (oParam.IsTop != AppConst.IntNull) paramIsTop.Value = oParam.IsTop; else paramIsTop.Value = System.DBNull.Value; if (oParam.IsGood != AppConst.IntNull) paramIsGood.Value = oParam.IsGood; else paramIsGood.Value = System.DBNull.Value; if (oParam.TotalRemarkCount != AppConst.IntNull) paramTotalRemarkCount.Value = oParam.TotalRemarkCount; else paramTotalRemarkCount.Value = System.DBNull.Value; if (oParam.TotalHelpfulRemarkCount != AppConst.IntNull) paramTotalHelpfulRemarkCount.Value = oParam.TotalHelpfulRemarkCount; else paramTotalHelpfulRemarkCount.Value = System.DBNull.Value; if (oParam.TotalComplainCount != AppConst.IntNull) paramTotalComplainCount.Value = oParam.TotalComplainCount; else paramTotalComplainCount.Value = System.DBNull.Value; if (oParam.Status != AppConst.IntNull) paramStatus.Value = oParam.Status; else paramStatus.Value = System.DBNull.Value; if (oParam.CreateCustomerSysNo != AppConst.IntNull) paramCreateCustomerSysNo.Value = oParam.CreateCustomerSysNo; else paramCreateCustomerSysNo.Value = System.DBNull.Value; if (oParam.CreateDate != AppConst.DateTimeNull) paramCreateDate.Value = oParam.CreateDate; else paramCreateDate.Value = System.DBNull.Value; if (oParam.LastEditUserSysNo != AppConst.IntNull) paramLastEditUserSysNo.Value = oParam.LastEditUserSysNo; else paramLastEditUserSysNo.Value = System.DBNull.Value; if (oParam.LastEditDate != AppConst.DateTimeNull) paramLastEditDate.Value = oParam.LastEditDate; else paramLastEditDate.Value = System.DBNull.Value; if (oParam.CustomerIP != AppConst.StringNull) paramCustomerIP.Value = oParam.CustomerIP; else paramCustomerIP.Value = System.DBNull.Value; cmd.Parameters.Add(paramSysNo); cmd.Parameters.Add(paramReviewType); cmd.Parameters.Add(paramTitle); cmd.Parameters.Add(paramContent1); cmd.Parameters.Add(paramContent2); cmd.Parameters.Add(paramContent3); cmd.Parameters.Add(paramScore); cmd.Parameters.Add(paramOwnedType); cmd.Parameters.Add(paramUnderstandingType); cmd.Parameters.Add(paramNickName); cmd.Parameters.Add(paramReferenceType); cmd.Parameters.Add(paramReferenceSysNo); cmd.Parameters.Add(paramIsTop); cmd.Parameters.Add(paramIsGood); cmd.Parameters.Add(paramTotalRemarkCount); cmd.Parameters.Add(paramTotalHelpfulRemarkCount); cmd.Parameters.Add(paramTotalComplainCount); cmd.Parameters.Add(paramStatus); cmd.Parameters.Add(paramCreateCustomerSysNo); cmd.Parameters.Add(paramCreateDate); cmd.Parameters.Add(paramLastEditUserSysNo); cmd.Parameters.Add(paramLastEditDate); cmd.Parameters.Add(paramCustomerIP); return SqlHelper.ExecuteNonQuery(cmd); }