/// <summary> /// 将DataRedar转换为List /// </summary> private List <RoadFlow.Data.Model.WorkFlowTask> DataReaderToList(SqlDataReader dataReader) { List <RoadFlow.Data.Model.WorkFlowTask> List = new List <RoadFlow.Data.Model.WorkFlowTask>(); RoadFlow.Data.Model.WorkFlowTask model = null; while (dataReader.Read()) { model = new RoadFlow.Data.Model.WorkFlowTask(); model.ID = dataReader.GetGuid(0); model.PrevID = dataReader.GetGuid(1); model.PrevStepID = dataReader.GetGuid(2); model.FlowID = dataReader.GetGuid(3); model.StepID = dataReader.GetGuid(4); model.StepName = dataReader.GetString(5); model.InstanceID = dataReader.GetString(6); model.GroupID = dataReader.GetGuid(7); model.Type = dataReader.GetInt32(8); model.Title = dataReader.GetString(9); model.SenderID = dataReader.GetGuid(10); model.SenderName = dataReader.GetString(11); model.SenderTime = dataReader.GetDateTime(12); model.ReceiveID = dataReader.GetGuid(13); model.ReceiveName = dataReader.GetString(14); model.ReceiveTime = dataReader.GetDateTime(15); if (!dataReader.IsDBNull(16)) { model.OpenTime = dataReader.GetDateTime(16); } if (!dataReader.IsDBNull(17)) { model.CompletedTime = dataReader.GetDateTime(17); } if (!dataReader.IsDBNull(18)) { model.CompletedTime1 = dataReader.GetDateTime(18); } if (!dataReader.IsDBNull(19)) { model.Comment = dataReader.GetString(19); } if (!dataReader.IsDBNull(20)) { model.IsSign = dataReader.GetInt32(20); } model.Status = dataReader.GetInt32(21); if (!dataReader.IsDBNull(22)) { model.Note = dataReader.GetString(22); } model.Sort = dataReader.GetInt32(23); if (!dataReader.IsDBNull(24)) { model.SubFlowGroupID = dataReader.GetGuid(24); } List.Add(model); } return(List); }
/// <summary> /// 添加记录 /// </summary> /// <param name="model">RoadFlow.Data.Model.WorkFlowTask实体类</param> /// <returns>操作所影响的行数</returns> public int Add(RoadFlow.Data.Model.WorkFlowTask model) { string sql = @"INSERT INTO WorkFlowTask (ID,PrevID,PrevStepID,FlowID,StepID,StepName,InstanceID,GroupID,Type,Title,SenderID,SenderName,SenderTime,ReceiveID,ReceiveName,ReceiveTime,OpenTime,CompletedTime,CompletedTime1,Comment1,IsSign,Status,Note,Sort,SubFlowGroupID) VALUES(:ID,:PrevID,:PrevStepID,:FlowID,:StepID,:StepName,:InstanceID,:GroupID,:Type,:Title,:SenderID,:SenderName,:SenderTime,:ReceiveID,:ReceiveName,:ReceiveTime,:OpenTime,:CompletedTime,:CompletedTime1,:Comment1,:IsSign,:Status,:Note,:Sort,:SubFlowGroupID)" ; OracleParameter[] parameters = new OracleParameter[] { new OracleParameter(":ID", OracleDbType.Varchar2, 40) { Value = model.ID }, new OracleParameter(":PrevID", OracleDbType.Varchar2, 40) { Value = model.PrevID }, new OracleParameter(":PrevStepID", OracleDbType.Varchar2, 40) { Value = model.PrevStepID }, new OracleParameter(":FlowID", OracleDbType.Varchar2, 40) { Value = model.FlowID }, new OracleParameter(":StepID", OracleDbType.Varchar2, 40) { Value = model.StepID }, new OracleParameter(":StepName", OracleDbType.NVarchar2, 1000) { Value = model.StepName }, new OracleParameter(":InstanceID", OracleDbType.Varchar2, 50) { Value = model.InstanceID }, new OracleParameter(":GroupID", OracleDbType.Varchar2, 40) { Value = model.GroupID }, new OracleParameter(":Type", OracleDbType.Int32) { Value = model.Type }, new OracleParameter(":Title", OracleDbType.NVarchar2, 4000) { Value = model.Title }, new OracleParameter(":SenderID", OracleDbType.Varchar2, 40) { Value = model.SenderID }, new OracleParameter(":SenderName", OracleDbType.NVarchar2, 100) { Value = model.SenderName }, new OracleParameter(":SenderTime", OracleDbType.Date, 8) { Value = model.SenderTime }, new OracleParameter(":ReceiveID", OracleDbType.Varchar2, 40) { Value = model.ReceiveID }, new OracleParameter(":ReceiveName", OracleDbType.NVarchar2, 100) { Value = model.ReceiveName }, new OracleParameter(":ReceiveTime", OracleDbType.Date, 8) { Value = model.ReceiveTime }, model.OpenTime == null ? new OracleParameter(":OpenTime", OracleDbType.Date, 8) { Value = DBNull.Value } : new OracleParameter(":OpenTime", OracleDbType.Date, 8) { Value = model.OpenTime }, model.CompletedTime == null ? new OracleParameter(":CompletedTime", OracleDbType.Date, 8) { Value = DBNull.Value } : new OracleParameter(":CompletedTime", OracleDbType.Date, 8) { Value = model.CompletedTime }, model.CompletedTime1 == null ? new OracleParameter(":CompletedTime1", OracleDbType.Date, 8) { Value = DBNull.Value } : new OracleParameter(":CompletedTime1", OracleDbType.Date, 8) { Value = model.CompletedTime1 }, model.Comment == null ? new OracleParameter(":Comment1", OracleDbType.Clob) { Value = DBNull.Value } : new OracleParameter(":Comment1", OracleDbType.Clob) { Value = model.Comment }, model.IsSign == null ? new OracleParameter(":IsSign", OracleDbType.Int32) { Value = DBNull.Value } : new OracleParameter(":IsSign", OracleDbType.Int32) { Value = model.IsSign }, new OracleParameter(":Status", OracleDbType.Int32) { Value = model.Status }, model.Note == null ? new OracleParameter(":Note", OracleDbType.NVarchar2) { Value = DBNull.Value } : new OracleParameter(":Note", OracleDbType.NVarchar2) { Value = model.Note }, new OracleParameter(":Sort", OracleDbType.Int32) { Value = model.Sort }, model.SubFlowGroupID == null ? new OracleParameter(":SubFlowGroupID", OracleDbType.Varchar2) { Value = DBNull.Value } : new OracleParameter(":SubFlowGroupID", OracleDbType.Varchar2) { Value = model.SubFlowGroupID } }; return(dbHelper.Execute(sql, parameters)); }
/// <summary> /// 添加记录 /// </summary> /// <param name="model">RoadFlow.Data.Model.WorkFlowTask实体类</param> /// <returns>操作所影响的行数</returns> public int Add(RoadFlow.Data.Model.WorkFlowTask model) { string sql = @"INSERT INTO WorkFlowTask (ID,PrevID,PrevStepID,FlowID,StepID,StepName,InstanceID,GroupID,Type,Title,SenderID,SenderName,SenderTime,ReceiveID,ReceiveName,ReceiveTime,OpenTime,CompletedTime,CompletedTime1,Comment,IsSign,Status,Note,Sort,SubFlowGroupID) VALUES(@ID,@PrevID,@PrevStepID,@FlowID,@StepID,@StepName,@InstanceID,@GroupID,@Type,@Title,@SenderID,@SenderName,@SenderTime,@ReceiveID,@ReceiveName,@ReceiveTime,@OpenTime,@CompletedTime,@CompletedTime1,@Comment,@IsSign,@Status,@Note,@Sort,@SubFlowGroupID)" ; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1) { Value = model.ID }, new SqlParameter("@PrevID", SqlDbType.UniqueIdentifier, -1) { Value = model.PrevID }, new SqlParameter("@PrevStepID", SqlDbType.UniqueIdentifier, -1) { Value = model.PrevStepID }, new SqlParameter("@FlowID", SqlDbType.UniqueIdentifier, -1) { Value = model.FlowID }, new SqlParameter("@StepID", SqlDbType.UniqueIdentifier, -1) { Value = model.StepID }, new SqlParameter("@StepName", SqlDbType.NVarChar, 1000) { Value = model.StepName }, new SqlParameter("@InstanceID", SqlDbType.VarChar, 50) { Value = model.InstanceID }, new SqlParameter("@GroupID", SqlDbType.UniqueIdentifier, -1) { Value = model.GroupID }, new SqlParameter("@Type", SqlDbType.Int, -1) { Value = model.Type }, new SqlParameter("@Title", SqlDbType.NVarChar, 4000) { Value = model.Title }, new SqlParameter("@SenderID", SqlDbType.UniqueIdentifier, -1) { Value = model.SenderID }, new SqlParameter("@SenderName", SqlDbType.NVarChar, 100) { Value = model.SenderName }, new SqlParameter("@SenderTime", SqlDbType.DateTime, 8) { Value = model.SenderTime }, new SqlParameter("@ReceiveID", SqlDbType.UniqueIdentifier, -1) { Value = model.ReceiveID }, new SqlParameter("@ReceiveName", SqlDbType.NVarChar, 100) { Value = model.ReceiveName }, new SqlParameter("@ReceiveTime", SqlDbType.DateTime, 8) { Value = model.ReceiveTime }, model.OpenTime == null ? new SqlParameter("@OpenTime", SqlDbType.DateTime, 8) { Value = DBNull.Value } : new SqlParameter("@OpenTime", SqlDbType.DateTime, 8) { Value = model.OpenTime }, model.CompletedTime == null ? new SqlParameter("@CompletedTime", SqlDbType.DateTime, 8) { Value = DBNull.Value } : new SqlParameter("@CompletedTime", SqlDbType.DateTime, 8) { Value = model.CompletedTime }, model.CompletedTime1 == null ? new SqlParameter("@CompletedTime1", SqlDbType.DateTime, 8) { Value = DBNull.Value } : new SqlParameter("@CompletedTime1", SqlDbType.DateTime, 8) { Value = model.CompletedTime1 }, model.Comment == null ? new SqlParameter("@Comment", SqlDbType.VarChar, -1) { Value = DBNull.Value } : new SqlParameter("@Comment", SqlDbType.VarChar, -1) { Value = model.Comment }, model.IsSign == null ? new SqlParameter("@IsSign", SqlDbType.Int, -1) { Value = DBNull.Value } : new SqlParameter("@IsSign", SqlDbType.Int, -1) { Value = model.IsSign }, new SqlParameter("@Status", SqlDbType.Int, -1) { Value = model.Status }, model.Note == null ? new SqlParameter("@Note", SqlDbType.NVarChar, -1) { Value = DBNull.Value } : new SqlParameter("@Note", SqlDbType.NVarChar, -1) { Value = model.Note }, new SqlParameter("@Sort", SqlDbType.Int, -1) { Value = model.Sort }, model.SubFlowGroupID == null ? new SqlParameter("@SubFlowGroupID", SqlDbType.UniqueIdentifier, -1) { Value = DBNull.Value } : new SqlParameter("@SubFlowGroupID", SqlDbType.UniqueIdentifier, -1) { Value = model.SubFlowGroupID } }; return(dbHelper.Execute(sql, parameters)); }
public static void Hasten(string types, string users, string contents, RoadFlow.Data.Model.WorkFlowTask task, string othersParams = "") { if (users.IsNullOrEmpty() || types.IsNullOrEmpty() || task == null) { return; } string[] strArray = users.Split(','); Guid guid = Guid.NewGuid(); List <RoadFlow.Data.Model.WorkFlowTask> all = new WorkFlowTask().GetNextTaskList(task.ID).FindAll((Predicate <RoadFlow.Data.Model.WorkFlowTask>)(p => p.Status.In(0, 1))); string str1 = !(HttpContext.Current.Request.Url != (Uri)null) || !HttpContext.Current.Request.Url.AbsolutePath.EndsWith(".aspx", StringComparison.CurrentCultureIgnoreCase) ? "/WorkFlowRun/Index" : "/Platform/WorkFlowRun/Default.aspx"; string str2 = types; char[] chArray = new char[1] { ',' }; foreach (string str3 in str2.Split(chArray)) { int test; if (str3.IsInt(out test)) { foreach (string id in strArray) { Guid userGuid; if (Users.RemovePrefix(id).IsGuid(out userGuid)) { RoadFlow.Data.Model.WorkFlowTask workFlowTask = all.Find((Predicate <RoadFlow.Data.Model.WorkFlowTask>)(p => p.ReceiveID == userGuid)); string str4; if (workFlowTask != null) { str4 = "javascript:openApp('" + str1 + "?flowid=" + (object)workFlowTask.FlowID + "&stepid=" + (object)workFlowTask.StepID + "&instanceid=" + workFlowTask.InstanceID + "&taskid=" + (object)workFlowTask.ID + "&groupid=" + (object)workFlowTask.GroupID + "',0,'" + workFlowTask.Title.Replace1(",", "") + "','tab_" + (object)workFlowTask.ID + "');closeMessage('" + (object)guid + "');"; } else { str4 = ""; } string linkUrl = str4; switch (test) { case 1: SMSLog.SendSMS(new Users().GetMobileNumber(userGuid), contents); continue; case 2: Email.Send(userGuid, "任务催办", contents, ""); continue; case 3: RoadFlow.Data.Model.Users users1 = new Users().Get(userGuid); if (users1 != null) { ShortMessage.Send(users1.ID, users1.Name, "任务催办", contents, 0, linkUrl, task.ID.ToString(), guid.ToString()); continue; } continue; case 4: RoadFlow.Data.Model.Users users2 = new Users().Get(userGuid); if (users2 != null) { new Message().SendText(contents, users2.Account, "", "", 0, new Agents().GetAgentIDByCode("weixinagents_waittasks"), true); continue; } continue; default: continue; } } } } } new HastenLog().Add(new RoadFlow.Data.Model.HastenLog() { Contents = contents, ID = Guid.NewGuid(), SendTime = DateTimeNew.Now, SendUser = Users.CurrentUserID, SendUserName = Users.CurrentUserName, OthersParams = othersParams.IsNullOrEmpty() ? task.ID.ToString() : othersParams, Types = types, Users = users }); }