/// <summary> /// 更新记录 /// </summary> /// <param name="model">FoWoSoft.Data.Model.WorkFlowComment实体类</param> public int Update(FoWoSoft.Data.Model.WorkFlowComment model) { string sql = @"UPDATE WorkFlowComment SET MemberID=@MemberID,Comment=@Comment,Type=@Type,Sort=@Sort WHERE ID=@ID" ; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@MemberID", SqlDbType.VarChar, -1) { Value = model.MemberID }, new SqlParameter("@Comment", SqlDbType.NVarChar, 1000) { Value = model.Comment }, new SqlParameter("@Type", SqlDbType.Int, -1) { Value = model.Type }, new SqlParameter("@Sort", SqlDbType.Int, -1) { Value = model.Sort }, new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1) { Value = model.ID } }; return(dbHelper.Execute(sql, parameters)); }
/// <summary> /// 添加记录 /// </summary> /// <param name="model">FoWoSoft.Data.Model.WorkFlowComment实体类</param> /// <returns>操作所影响的行数</returns> public int Add(FoWoSoft.Data.Model.WorkFlowComment model) { string sql = @"INSERT INTO WorkFlowComment (ID,MemberID,Comment,Type,Sort) VALUES(@ID,@MemberID,@Comment,@Type,@Sort)" ; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1) { Value = model.ID }, new SqlParameter("@MemberID", SqlDbType.VarChar, -1) { Value = model.MemberID }, new SqlParameter("@Comment", SqlDbType.NVarChar, 1000) { Value = model.Comment }, new SqlParameter("@Type", SqlDbType.Int, -1) { Value = model.Type }, new SqlParameter("@Sort", SqlDbType.Int, -1) { Value = model.Sort } }; return(dbHelper.Execute(sql, parameters)); }
/// <summary> /// 将DataRedar转换为List /// </summary> private List <FoWoSoft.Data.Model.WorkFlowComment> DataReaderToList(SqlDataReader dataReader) { List <FoWoSoft.Data.Model.WorkFlowComment> List = new List <FoWoSoft.Data.Model.WorkFlowComment>(); FoWoSoft.Data.Model.WorkFlowComment model = null; while (dataReader.Read()) { model = new FoWoSoft.Data.Model.WorkFlowComment(); model.ID = dataReader.GetGuid(0); model.MemberID = dataReader.GetString(1); model.Comment = dataReader.GetString(2); model.Type = dataReader.GetInt32(3); model.Sort = dataReader.GetInt32(4); List.Add(model); } return(List); }
/// <summary> /// 更新 /// </summary> public int Update(FoWoSoft.Data.Model.WorkFlowComment model) { return(dataWorkFlowComment.Update(model)); }
/// <summary> /// 新增 /// </summary> public int Add(FoWoSoft.Data.Model.WorkFlowComment model) { return(dataWorkFlowComment.Add(model)); }
protected void Page_Load(object sender, EventArgs e) { FoWoSoft.Platform.WorkFlowComment bworkFlowComment = new FoWoSoft.Platform.WorkFlowComment(); FoWoSoft.Data.Model.WorkFlowComment workFlowComment = null; string id = Request.QueryString["id"]; string member = string.Empty; string comment = string.Empty; string sort = string.Empty; bool isOneSelf = "1" == Request.QueryString["isoneself"]; if (isOneSelf) { this.usermemberid.Visible = false; } Guid commentID; if (id.IsGuid(out commentID)) { workFlowComment = bworkFlowComment.Get(commentID); member = workFlowComment.MemberID; comment = workFlowComment.Comment; sort = workFlowComment.Sort.ToString(); } string oldXML = workFlowComment.Serialize(); if (IsPostBack) { member = isOneSelf ? FoWoSoft.Platform.Users.PREFIX + FoWoSoft.Platform.Users.CurrentUserID.ToString() : Request.Form["Member"]; comment = Request.Form["Comment"]; sort = Request.Form["Sort"]; bool isAdd = !id.IsGuid(); if (workFlowComment == null) { workFlowComment = new FoWoSoft.Data.Model.WorkFlowComment(); workFlowComment.ID = Guid.NewGuid(); workFlowComment.Type = isOneSelf ? 1 : 0; } workFlowComment.MemberID = member.IsNullOrEmpty() ? "" : member.Trim(); workFlowComment.Comment = comment.IsNullOrEmpty() ? "" : comment.Trim(); workFlowComment.Sort = sort.IsInt() ? sort.ToInt() : bworkFlowComment.GetManagerMaxSort(); if (isAdd) { bworkFlowComment.Add(workFlowComment); FoWoSoft.Platform.Log.Add("添加了流程意见", workFlowComment.Serialize(), FoWoSoft.Platform.Log.Types.流程相关); } else { bworkFlowComment.Update(workFlowComment); FoWoSoft.Platform.Log.Add("修改了流程意见", "", FoWoSoft.Platform.Log.Types.流程相关, oldXML, workFlowComment.Serialize()); } bworkFlowComment.RefreshCache(); Page.ClientScript.RegisterStartupScript(Page.GetType(), "ok", "new RoadUI.Window().reloadOpener();alert('保存成功!'); new RoadUI.Window().close();", true); } if (workFlowComment != null) { this.Comment.Value = workFlowComment.Comment; this.Member.Value = workFlowComment.MemberID; this.Sort.Value = workFlowComment.Sort.ToString(); } }