/// <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
});
}
