private void grdReviews_ItemDataBound(object sender, DataGridItemEventArgs e) { ReviewInfo reviewInfo = e.Item.DataItem as ReviewInfo; if (reviewInfo != null) { // Update edit link using this item's ID HyperLink linkEdit = (e.Item.FindControl("linkEdit") as HyperLink); if (linkEdit != null) { StringDictionary replaceParams = new StringDictionary { ["ReviewID"] = reviewInfo.ReviewID.ToString() }; linkEdit.NavigateUrl = _nav.GetNavigationUrl(replaceParams); } // Add rating images PlaceHolder phRating = (e.Item.FindControl("phRating") as PlaceHolder); if (phRating != null) { phRating.Controls.Add(GetRatingImages(reviewInfo.Rating)); } } }
public string PostReview(ReviewInfo review) { ReviewDatabase db = ReviewDatabase.getInstance(); JObject status = db.addReview(review); return(status.ToString()); }
public List <ReviewInfo> GetReviewsByAuthor(string authorName) { List <ReviewInfo> reviews = new List <ReviewInfo>(); var revs = from r in brde.Reviews from a in r.Book.Authors where a.AuthorName.Equals(authorName) select new { r.Book.BookTitle, r.Reviewer.ReviewerLastName, r.ReviewTitle, r.ReviewDate, r.ReviewRating, r.ReviewText }; foreach (var v in revs) { ReviewInfo info = new ReviewInfo(); info.BookTitle = v.BookTitle; info.ReviewTitle = v.ReviewTitle; info.ReviewerName = v.ReviewerLastName; info.ReviewDate = v.ReviewDate; info.BookRating = v.ReviewRating; info.ReviewBody = v.ReviewText; reviews.Add(info); } return(reviews); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(FishEntity.OutboundOrderEntity model, string name) { Hashtable SQLString = new Hashtable( ); SQLString = ReviewInfo.getSQLString(name, model.code, string.Empty, SQLString); StringBuilder strSql = new StringBuilder( ); strSql.Append("insert into t_outboundorder("); strSql.Append("seNumber,code,unit,type,shipName,weight,pileNum,codeNum,codeNumContract,date,waseHouse,speci,billName,pageNum,remark,notice,ware,receive,FishMealId,Country,Brands)"); strSql.Append(" values ("); strSql.Append("@seNumber,@code,@unit,@type,@shipName,@weight,@pileNum,@codeNum,@codeNumContract,@date,@waseHouse,@speci,@billName,@pageNum,@remark,@notice,@ware,@receive,@FishMealId,@Country,@Brands)"); MySqlParameter [] parameters = { new MySqlParameter("@seNumber", MySqlDbType.VarChar, 45), new MySqlParameter("@code", MySqlDbType.VarChar, 45), new MySqlParameter("@unit", MySqlDbType.VarChar, 45), new MySqlParameter("@type", MySqlDbType.VarChar, 45), new MySqlParameter("@shipName", MySqlDbType.VarChar, 45), new MySqlParameter("@weight", MySqlDbType.Decimal, 10), new MySqlParameter("@pileNum", MySqlDbType.VarChar, 45), new MySqlParameter("@codeNum", MySqlDbType.VarChar, 45), new MySqlParameter("@codeNumContract", MySqlDbType.VarChar, 45), new MySqlParameter("@date", MySqlDbType.Date), new MySqlParameter("@waseHouse", MySqlDbType.VarChar, 45), new MySqlParameter("@speci", MySqlDbType.VarChar, 45), new MySqlParameter("@billName", MySqlDbType.VarChar, 45), new MySqlParameter("@pageNum", MySqlDbType.Int32, 11), new MySqlParameter("@remark", MySqlDbType.VarChar, 225), new MySqlParameter("@notice", MySqlDbType.VarChar, 45), new MySqlParameter("@ware", MySqlDbType.Decimal, 10), new MySqlParameter("@receive", MySqlDbType.VarChar, 45), new MySqlParameter("@FishMealId", MySqlDbType.VarChar, 50), new MySqlParameter("@Country", MySqlDbType.VarChar, 50), new MySqlParameter("@Brands", MySqlDbType.VarChar, 50) }; parameters [0].Value = model.seNumber; parameters [1].Value = model.code; parameters [2].Value = model.unit; parameters [3].Value = model.type; parameters [4].Value = model.shipName; parameters [5].Value = model.weight; parameters [6].Value = model.pileNum; parameters [7].Value = model.codeNum; parameters [8].Value = model.codeNumContract; parameters [9].Value = model.date; parameters [10].Value = model.waseHouse; parameters [11].Value = model.speci; parameters [12].Value = model.billName; parameters [13].Value = model.pageNum; parameters [14].Value = model.remark; parameters [15].Value = model.notice; parameters [16].Value = model.ware; parameters [17].Value = model.receive; parameters [18].Value = model.FishMealId; parameters [19].Value = model.Country; parameters [20].Value = model.Brands; SQLString.Add(strSql, parameters); return(MySqlHelper.ExecuteSqlTran(SQLString)); }
public void InsertReview(ReviewInfo review) { try { Conn.Open(); string query = "INSERT INTO [VolunteerReview] (CareRecipientID, VolunteerID, Content, Rating, RatingTime) VALUES (@recipientId, @volunteerId, @content, @rating, @ratingTime)"; using (SqlCommand insertReview = new SqlCommand(query, Conn)) { insertReview.Parameters.AddWithValue("@recipientId", review.CareRecipientId); insertReview.Parameters.AddWithValue("@volunteerId", review.VolunteerId); insertReview.Parameters.AddWithValue("@content", review.Review ?? ""); insertReview.Parameters.AddWithValue("@rating", review.StarAmount); insertReview.Parameters.AddWithValue("@ratingTime", DateTime.Now); insertReview.ExecuteNonQuery(); } } catch (SqlException ex) { throw new ArgumentException("Insert review failed."); } finally { Conn.Close(); } }
/// <summary> /// Grant the reviewer review experience for the review /// </summary> private void GrantReviewerExperience(ReviewInfo info) { foreach (ReviewAlgorithmBase reviewAlgorithm in Algorithms.OfType <ReviewAlgorithmBase>()) { reviewAlgorithm.AddReviewScore(info.Reviewer, info.Filenames, info.When); } }
protected void Page_Load(object sender, EventArgs e) { try { autoId = Request["AutoId"]; if (!string.IsNullOrEmpty(autoId)) { reviewInfo = bll.Get <BLLJIMP.Model.ReviewInfo>(string.Format(" AutoId={0}", autoId)); if (reviewInfo != null) { reviewInfo.Pv++; bll.Update(reviewInfo); } } ForwardingRecord record = bll.Get <BLLJIMP.Model.ForwardingRecord>(string.Format(" FUserID='{0}' AND RUserID='{1}' AND WebsiteOwner='{2}' AND TypeName='话题赞'", bll.GetCurrentUserInfo().UserID, autoId, bll.WebsiteOwner)); if (record != null) { isPraise = true; } } catch (Exception ex) { Response.Write(ex.Message); Response.End(); } }
/// <summary> /// 增加数据 /// </summary> /// <param name="_model"></param> /// <param name="_modelsList"></param> /// <returns></returns> public bool Add(FishEntity.BatchSheetEntity _model, List <FishEntity.BatchSheetsEntity> _modelsList, string name) { Hashtable SQLString = new Hashtable( ); SQLString = ReviewInfo.getSQLString(name, _model.code, string.Empty, SQLString); StringBuilder strSql = new StringBuilder( ); strSql.Append("insert into t_batchsheet("); strSql.Append("code,productionDate)"); strSql.Append(" values ("); strSql.Append("@code,@productionDate)"); MySqlParameter [] parameters = { new MySqlParameter("@code", MySqlDbType.VarChar, 45), new MySqlParameter("@productionDate", MySqlDbType.Date) }; parameters [0].Value = _model.code; parameters [1].Value = _model.productionDate; SQLString.Add(strSql, parameters); foreach (FishEntity.BatchSheetsEntity model in _modelsList) { add(SQLString, strSql, model); } return(MySqlHelper.ExecuteSqlTran(SQLString)); }
/// <summary> /// Store in DB that the reviewer is a possible reviewer in this bug/change. /// </summary> protected void ProcessReviewInfo(ReviewInfo info) { using (ExpertiseDBEntities repository = new ExpertiseDBEntities()) { Bug theBug = repository.Bugs.Single(bug => bug.ChangeId == info.ChangeId && bug.RepositoryId == RepositoryId); bool fBugDirty = false; foreach (string primaryName in NameConsolidator.DeanonymizeAuthor(info.Reviewer)) // this is usually just one { if (theBug.ActualReviewers.Any(reviewer => string.Equals(reviewer.Reviewer, primaryName, StringComparison.InvariantCultureIgnoreCase))) { continue; // the reviewer is already in the list } theBug.ActualReviewers.Add(new ActualReviewer() { ActivityId = info.ActivityId, Bug = theBug, Reviewer = primaryName }); fBugDirty = true; } if (fBugDirty) { repository.SaveChanges(); } } }
public void ProcessRequest(HttpContext context) { string autoId = context.Request["id"]; if (string.IsNullOrEmpty(autoId)) { apiResp.code = (int)BLLJIMP.Enums.APIErrCode.IsNotFound; apiResp.msg = "id 为必填项,请检查"; bllReview.ContextResponse(context, apiResp); return; } ReviewInfo model = bllReview.GetReviewByAutoId(int.Parse(autoId)); if (model == null) { apiResp.code = (int)BLLJIMP.Enums.APIErrCode.IsNotFound; apiResp.msg = "评论已经删除"; bllReview.ContextResponse(context, apiResp); return; } if (bllReview.Delete(new ReviewInfo(), string.Format(" WebsiteOwner='{0}' AND AutoID={1}", bllReview.WebsiteOwner, int.Parse(autoId))) > 0) { apiResp.status = true; apiResp.msg = "ok"; int reviewCount = bllReview.GetReviewCount(BLLJIMP.Enums.ReviewTypeKey.AppointmentComment, model.ForeignkeyId, model.UserId); bllJuActivity.Update(new JuActivityInfo(), string.Format(" CommentCount={0} AND CommentAndReplayCount='{0}' ", reviewCount), string.Format(" JuActivityID={0}", model.ForeignkeyId)); } else { apiResp.msg = "删除评论失败"; apiResp.code = (int)BLLJIMP.Enums.APIErrCode.OperateFail; } bllReview.ContextResponse(context, apiResp); }
/// <summary> /// Receives a ReviewInfo object as a parameter and /// Saves the review to the database with the company name as the key /// </summary> /// <param name="review">The review to be saved</param> /// <returns>returns a JSON object indicating if it was successful or not</returns> public JObject addReview(ReviewInfo review) { string jsonstring = "{'companyName':'" + review.companyName + "','username':'******','review':'" + review.review + "','stars':" + review.stars + ",'timestamp':" + review.timestamp + "}"; JObject newReview = new JObject(JObject.Parse(jsonstring)); string query = "INSERT INTO " + dbname + ".companyReviews(companyName, reviews) " + "VALUES ('" + review.companyName + "','" + newReview + "');"; if (openConnection() == true) { MySqlCommand command = new MySqlCommand(query, connection); command.ExecuteNonQuery(); command.CommandText = "SELECT * FROM " + dbname + ".companyReviews WHERE id = LAST_INSERT_ID();"; MySqlDataReader reader = command.ExecuteReader(); if (reader.Read() == true) { reader.Close(); closeConnection(); return(JObject.Parse("{\"response\":\"success\"}")); } else { reader.Close(); closeConnection(); return(JObject.Parse("{\"response\":\"failure\"}")); } } else { throw new Exception("Could not connect to database"); } }
/// <summary> /// 删除回复 /// </summary> /// <param name="context"></param> /// <returns></returns> private string DelReview(HttpContext context) { string ids = context.Request["ids"]; List <string> IdList = ids.Split(',').Distinct().ToList(); for (int i = 0; i < IdList.Count; i++) { if (string.IsNullOrWhiteSpace(IdList[i])) { continue; } ReviewInfo re = bllReview.GetReviewInfo(int.Parse(IdList[i])); if (bllReview.DelReview(IdList[i])) { if (re.ReviewType == "Answer") { bllUser.AddUserScoreDetail(re.UserId, EnumStringHelper.ToString(ScoreDefineType.DelAnswer), bll.WebsiteOwner, null, null); } else if (re.ReviewType == "ArticleComment" || re.ReviewType == "CommentReply") { bllUser.AddUserScoreDetail(re.UserId, EnumStringHelper.ToString(ScoreDefineType.DelReview), bll.WebsiteOwner, null, null); } } } resp.Status = 1; resp.Msg = "删除完成"; return(Common.JSONHelper.ObjectToJson(resp)); }
public ActionResult Review() { string username = Request.QueryString["username"]; ReviewInfo Model = new ReviewInfo(); Model.username = username; return(View(Model)); }
protected virtual void OnReviewInfoImported(ReviewInfo d) { EventHandler <ReviewInfo> handler = ReviewInfoImported; if (handler != null) { handler(this, d); } }
public void InsertReview() { Assert.AreEqual(0, _reviewLogic.GetAllReviewsWithVolunteerId(1).Count); ReviewInfo reviewInfo = new ReviewInfo(1, 1, 1, "test", 5); _reviewLogic.InsertReview(reviewInfo); Assert.AreEqual(1, _reviewLogic.GetAllReviewsWithVolunteerId(1).Count); }
public ReviewViewModel(ReviewInfo review) { ReviewId = review.ReviewId; VolunteerId = review.VolunteerId; CareRecipientId = review.CareRecipientId; Review = review.Review; StarAmount = review.StarAmount; VolunteerName = review.VolFirstName + " " + review.VolLastName; CareRecipientName = review.CareFirstName + " " + review.CareLastName; }
protected void Page_Load(object sender, EventArgs e) { _nav = new AdminNavigation(Request.QueryString); try { // Get the Review ID ReviewInfo review = new ReviewInfo(); if (!Page.IsPostBack) { cmdDelete.Attributes.Add("onClick", "javascript:return confirm('" + Localization.GetString("DeleteItem") + "');"); if (_nav.ReviewID != Null.NullInteger) { ReviewController controller = new ReviewController(); review = controller.GetReview(PortalId, _nav.ReviewID); if (review != null) { cmdDelete.Visible = true; divApproval.Visible = true; cmbRating.SelectedValue = review.Rating.ToString(); txtComments.Text = review.Comments; chkAuthorized.Checked = review.Authorized; txtUserName.Text = review.UserName; } else { if (UserId != -1) { txtUserName.Text = UserInfo.DisplayName; } else { txtUserName.Text = Localization.GetString("Anonymous.Text", LocalResourceFile); } } } } // Which controls do we display? if (CanManageReviews()) { txtUserName.Enabled = false; cmbRating.Enabled = false; divAuthorized.Visible = true; divApproval.Visible = false; } } catch (Exception ex) { Exceptions.ProcessModuleLoadException(this, ex); } }
public void ProcessRequest(HttpContext context) { string title = context.Request["Title"]; string content = context.Request["Context"]; if (string.IsNullOrEmpty(title)) { apiResp.msg = "标题不能为空"; context.Response.Write(Common.JSONHelper.ObjectToJson(apiResp)); return; } if (string.IsNullOrEmpty(content)) { apiResp.msg = "内容不能为空"; context.Response.Write(Common.JSONHelper.ObjectToJson(apiResp)); return; } currentWebsteInfo = bllUser.GetWebsiteInfoModelFromDataBase(); if (currentWebsteInfo.IsEnableUserReleaseReview == 0) { apiResp.msg = "暂不开放发布话题功能"; context.Response.Write(Common.JSONHelper.ObjectToJson(apiResp)); return; } ReviewInfo model = new ReviewInfo { ForeignkeyId = bllUser.WebsiteOwner, ForeignkeyName = bllUser.WebsiteOwner, UserId = CurrentUserInfo.UserID, UserName = CurrentUserInfo.TrueName, ReviewPower = 0, InsertDate = DateTime.Now, ReviewTitle = title, ReviewContent = content, WebsiteOwner = bllUser.WebsiteOwner, PraiseNum = 0, StepNum = 0, ReviewType = "话题", CategoryType = "", ReplyDateTiem = DateTime.Now }; if (bllReview.Add(model)) { BLLRedis.ClearReviewList(bllUser.WebsiteOwner); apiResp.status = true; } else { apiResp.msg = "发布失败"; } context.Response.Write(Common.JSONHelper.ObjectToJson(apiResp)); }
/// <summary> /// 填充回复信息相关关系数据 /// </summary> /// <param name="item">回复数据</param> /// <param name="currUserId">用户id</param> /// <returns></returns> public ReviewInfo FilterReviewInfo(ReviewInfo item, string currUserId, bool showStatistic = true, bool showReplayToUser = true) { if (item == null) { return(null); } if (showStatistic) { if (!string.IsNullOrWhiteSpace(currUserId)) { //当前用户是否收藏和点赞 item.CurrUserIsFavorite = bLLCommRelation.ExistRelation(Enums.CommRelationType.ReviewFavorite, item.ReviewMainId.ToString(), currUserId); item.CurrUserIsPraise = bLLCommRelation.ExistRelation(Enums.CommRelationType.ReviewPraise, item.ReviewMainId.ToString(), currUserId); } //回复数,点赞数,收藏数 if (item.ReviewType == CommonPlatform.Helper.EnumStringHelper.ToString(Enums.ReviewTypeKey.ArticleComment)) { item.ReplyCount = GetCount <ReviewInfo>(string.Format(" ForeignkeyId = '{0}' AND ReviewType = '{1}' ", item.ReviewMainId, CommonPlatform.Helper.EnumStringHelper.ToString(Enums.ReviewTypeKey.CommentReply)) ); } if (item.ReviewType == CommonPlatform.Helper.EnumStringHelper.ToString(Enums.ReviewTypeKey.CommentReply)) { item.ReplyCount = GetCount <ReviewInfo>(string.Format(" ParentId = '{0}' AND ReviewType = '{1}' ", item.ReviewMainId, CommonPlatform.Helper.EnumStringHelper.ToString(Enums.ReviewTypeKey.CommentReply)) ); } item.PraiseCount = bLLCommRelation.GetRelationCount(Enums.CommRelationType.ReviewPraise, item.ReviewMainId.ToString(), ""); item.FavoriteCount = bLLCommRelation.GetRelationCount(Enums.CommRelationType.ReviewFavorite, item.ReviewMainId.ToString(), ""); } item.PubUser = bllUser.GetUserInfo(item.UserId); if (showReplayToUser && item.ParentId > 0) { var reviewInfo = GetReviewInfo(item.ParentId); if (reviewInfo != null) { item.ReplayToUser = bllUser.GetUserInfo(reviewInfo.UserId); } } return(item); }
private string GetReviewContent(ReviewInfo review) { string result = ""; result += review.Name + "\r\n"; result += review.ShortDesc + "\r\n"; result += review.LongDesc + "\r\n"; result += "标签是:" + review.Labels + "\r\n"; return(result); }
private static ReviewInfo ToDB(Review r) { ReviewInfo rInfo = new ReviewInfo { ReviewId = r.ReviewId, RestaurantId = r.RestaurantId, Name = r.Name, Summary = r.Summary, Rating = r.Rating }; return(rInfo); }
private void lstReviews_ItemDataBound(object sender, DataListItemEventArgs e) { ReviewInfo reviewInfo = e.Item.DataItem as ReviewInfo; if (reviewInfo != null) { PlaceHolder phRating = (e.Item.FindControl("plhRating") as PlaceHolder); if (phRating != null) { phRating.Controls.Add(GetRatingImages(reviewInfo.Rating)); } } }
private static Review ToWeb(ReviewInfo rInfo) { Review r = new Review { ReviewId = rInfo.ReviewId, RestaurantId = rInfo.RestaurantId, Name = rInfo.Name, Summary = rInfo.Summary, Rating = rInfo.Rating, }; return(r); }
protected void Page_Load(object sender, EventArgs e) { if (string.IsNullOrEmpty(Request["ReviewId"])) { Response.Write("ReviewId 参数必传"); Response.End(); } Review = bllReview.Get <ReviewInfo>(string.Format(" AutoId={0}", Request["ReviewId"])); if (Review == null) { Response.Write("ReviewId 参数错误"); Response.End(); } }
public EmpWithRevInfo_Cat(ReviewInfo b, Employee employee) { // TODO: Complete member initialization try { this.Rating = (int)b.Rating; this.Name = employee.Name; this.Comment = b.Comments; this.ID = employee.EmpID; } catch { } }
public ActionResult IdentityReviewList(int pageIndex, int state) { string state1 = state.ToString(); ReviewInfo Model = new ReviewInfo(); Model.pageIndex = pageIndex; int clientPlatform = 4; viewLite viewLite = new viewLite { frameName = "EcrpMain", viewName = "InspectView" }; sortInfo sortInfo = new sortInfo { sortType = 6 }; ConditionInfo ConditionInfo = new ConditionInfo { columnName = "state", conditionKind = 0, columnValue = state1 }; List <ConditionInfo> conditions = new List <ConditionInfo>(); conditions.Add(ConditionInfo); searchInfo searchInfo = new searchInfo { allowDrop = false, pageCount = 4, pageIndex = pageIndex, sortInfo = sortInfo, conditions = conditions };; Dictionary <string, object> parameters = new Dictionary <string, object>(); parameters.Add("clientPlatform", clientPlatform); parameters.Add("viewLite", viewLite); parameters.Add("searchInfo", searchInfo); string jsonStr = ToJson.ScriptSerialize(parameters); string url = "Http://61.155.203.29:60214/service.svc/ReadDatasBySearchInfo2"; string resultStr = HttpCode.Post(url, jsonStr); Dictionary <string, object> obj = JsonTo.ScriptDeserialize(resultStr); object objvalue = obj["value"]; if (objvalue == null) { Model.list = null; Model.count = 0; } else { string value = obj["value"].ToString(); List <Dictionary <string, object> > val = JsonTo.ScriptDeserializeList(value); Model.list = val; Model.count = val.Count(); } return(PartialView(Model)); }
public void SetReview([NotNull] IMitigation mitigation, [NotNull] ReviewInfo info) { ReviewInfo result = null; var propertyType = GetReviewPropertyType(); if (propertyType != null) { var property = mitigation.GetProperty(propertyType) ?? mitigation.AddProperty(propertyType, null); if (property is IPropertyJsonSerializableObject jsonSerializableObject) { jsonSerializableObject.Value = info; } } }
/// <summary> /// 增加评论接口 /// </summary> /// <param name="context"></param> /// <returns></returns> private string AddComment(HttpContext context) { if (!bllUser.IsLogin) { resp.errcode = (int)APIErrCode.UserIsNotLogin; resp.errmsg = "请先登录"; return(ZentCloud.Common.JSONHelper.ObjectToJson(resp)); } else { currentUserInfo = bllUser.GetCurrentUserInfo(); } string voteObjectId = context.Request["vote_object_id"]; //选手id string commentContent = context.Request["comment_content"]; //评论内容 if (string.IsNullOrEmpty(voteObjectId)) { resp.errcode = 1; resp.errmsg = "选手id不能为空"; return(ZentCloud.Common.JSONHelper.ObjectToJson(resp)); } if (string.IsNullOrEmpty(commentContent)) { resp.errcode = 1; resp.errmsg = "评论内容不能为空"; return(ZentCloud.Common.JSONHelper.ObjectToJson(resp)); } ReviewInfo model = new ReviewInfo(); model.ReviewType = "todaybeautify"; model.ForeignkeyId = voteObjectId; model.Expand1 = currentUserInfo.WXHeadimgurlLocal; model.Ex2 = currentUserInfo.WXNickname; model.ReviewContent = commentContent; model.WebsiteOwner = bllVote.WebsiteOwner; model.InsertDate = DateTime.Now; if (bllVote.Add(model)) { resp.errcode = 0; resp.errmsg = "ok"; } else { resp.errcode = 1; resp.errmsg = "评论失败"; } return(ZentCloud.Common.JSONHelper.ObjectToJson(resp)); }
public override bool Equals(object obj) { if (obj == null) { return(false); } if (obj.GetType() != this.GetType()) { return(false); } ReviewInfo other = (ReviewInfo)obj; return(Id.Equals(other.Id) && string.Compare(Uri.AbsoluteUri, other.Uri.AbsoluteUri, true) == 0); }
/// <summary> /// 保存初审信息 /// </summary> /// yaoy 16.08.29 /// <param name="data"></param> /// <returns></returns> public bool SaveCreditExamineReportData(string data) { var result = true; var _review = new Finance.Review(); var _finance = new Finance.Finance(); var _creditExamine = new Finance.CreditExamineReport(); JObject jo = (JObject)JsonConvert.DeserializeObject(data); StringReader sr1 = new StringReader(jo["D3"]["CreditExamineReportInfo"].ToString()); CreditExamineReportInfo creditExamine = (CreditExamineReportInfo)_serializer.Deserialize(new JsonTextReader(sr1), typeof(CreditExamineReportInfo)); StringReader sr2 = new StringReader(jo["D4"]["ReviewInfo"].ToString()); ReviewInfo reviewInfo = (ReviewInfo)_serializer.Deserialize(new JsonTextReader(sr2), typeof(ReviewInfo)); using (TransactionScope scope = new TransactionScope()) { if (_creditExamine.Get(creditExamine.FinanceId) == null) { result &= _creditExamine.Add(creditExamine); } else { result &= _creditExamine.Modify(creditExamine); } reviewInfo.ReviewType = (byte)ReviewType.初审; if (_review.Get(reviewInfo.FinanceId) == null) { // 初审添加 result &= _review.Add(reviewInfo); } else { // 初审修改 result &= _review.Modify(reviewInfo); } if (result) { scope.Complete(); } } return(result); }
public void ImportReviewInfoData(ReviewInfo d) { string filepath = Path.Combine(projectFolder, @"review.import.sqlite.sql"); string sql = File.ReadAllText(filepath); SQLiteCommand cmd = new SQLiteCommand(sql, m_dbConnection); cmd.Parameters.AddWithValue("@docno", d.DocumentNumber); cmd.Parameters.AddWithValue("@version", d.DocumentVersion); cmd.Parameters.AddWithValue("@review_date", d.ReviewDate); cmd.Parameters.AddWithValue("@review_status", d.ReviewStatus); cmd.Parameters.AddWithValue("@review_note", d.ReviewNote); cmd.Parameters.AddWithValue("@reviewed_by", d.ReviewedBy); cmd.ExecuteNonQuery(); cmd.Dispose(); }
public List<ReviewInfo> GetShowByVenue(string venueName) { List<ReviewInfo> review = new List<ReviewInfo>(); var rev = from ve in ste.Shows where ve.Venue.VenueName.Equals(venueName) select new { ve.ShowName, ve.ShowDate, ve.ShowTime }; foreach (var v in rev) { ReviewInfo info = new ReviewInfo(); info.ShowName = v.ShowName; info.ShowDate = v.ShowDate.ToString(); info.ShowTime = v.ShowTime.ToString(); review.Add(info); } return review; }
public List<ReviewInfo> GetShowByArtist(string artistName) { List<ReviewInfo> review = new List<ReviewInfo>(); var rev = from s in ste.Shows from sd in ste.ShowDetails from ve in ste.Venues where sd.Artist.ArtistName.Equals(artistName) select new { s.ShowName, s.ShowDate, s.ShowTime, ve.VenueName }; foreach (var v in rev) { ReviewInfo info = new ReviewInfo(); info.ShowName = v.ShowName; info.ShowDate = v.ShowDate.ToString(); info.ShowTime = v.ShowTime.ToString(); info.VenueName = v.VenueName; review.Add(info); } return review; }
public bool InsertReviewInfo(ReviewInfo r) { try { if (context.ReviewInfoes.Any(e => (e.ReviewId == r.ReviewId && e.CategoryID == r.CategoryID))) { context.ReviewInfoes.Attach(r); context.ObjectStateManager.ChangeObjectState(r, EntityState.Modified); } else { context.ReviewInfoes.AddObject(r); } context.SaveChanges(); return true; } catch (Exception ex) { //Include catch blocks for specific exceptions first, //and handle or log the error as appropriate in each. //Include a generic catch block like this one last. throw ex; return false; } }
public CommonStepDefinitions(ReviewInfo reviewInfo, CommonContext contextContext) : base(reviewInfo, contextContext) { }