public List <Model.ApproverInfo> GetApprovers(int flowId, string appType)
{
List <Model.ApproverInfo> list = new List <Model.ApproverInfo>();
string sql = @"select al.UID,al.isgroup,al.seqNo from ApproverList al
where al.flowId=@flowId and al.approveType=@appType
order by al.seqNo";
SqlParameter[] parameters = new SqlParameter[] {
new SqlParameter("@flowId", flowId),
new SqlParameter("@appType", appType)
};
using (SqlDataReader reader = SqlHelper.ExecuteReader(sql, parameters))
{
while (reader.Read())
{
Model.ApproverInfo a = new Model.ApproverInfo
{
UID = reader["UID"].ToString(),
IsGroup = int.Parse(reader["isgroup"].ToString()),
SeqNo = int.Parse(reader["seqNo"].ToString()),
};
list.Add(a);
}
}
return(list);
}
public List <Model.ApproverInfo> GetApprovers(int flowId)
{
List <Model.ApproverInfo> list = new List <Model.ApproverInfo>();
string sql = @"select al.UID,al.approveType,w.displayName,w.mail,al.isgroup,al.seqNo
from ApproverList al
left join WinADUser w on al.UID=w.userid
where flowId=@flowId
order by al.flowId,al.approvetype,al.seqNo";
SqlParameter para = new SqlParameter("@flowId", flowId);
using (SqlDataReader reader = SqlHelper.ExecuteReader(sql, para))
{
while (reader.Read())
{
Model.ApproverInfo a = new Model.ApproverInfo
{
UID = reader["UID"].ToString(),
DisplayName = reader["displayName"].ToString(),
Mail = reader["mail"].ToString(),
ApproveType = reader["approveType"].ToString(),
IsGroup = int.Parse(reader["isgroup"].ToString()),
SeqNo = int.Parse(reader["seqNo"].ToString()),
};
list.Add(a);
}
}
return(list);
}
public void AddApprover(Model.ApproverInfo approverInfo)
{
string cmdText = @"insert into [ApproverList] (flowId,[UID],approveType,isgroup,seqNo)
values (@flowId,@UID,@approveType,@isgroup,@seqNo)";
SqlParameter[] parameters = new SqlParameter[] {
new SqlParameter("@flowId", approverInfo.FlowId),
new SqlParameter("@UID", approverInfo.UID),
new SqlParameter("@approveType", approverInfo.ApproveType),
new SqlParameter("@isgroup", approverInfo.IsGroup),
new SqlParameter("@seqNo", approverInfo.SeqNo),
};
SqlHelper.ExecuteNonQuery(cmdText, parameters);
}
public Model.ApproverInfo GetLastEngApprover(int flowId)
{
Model.ApproverInfo lastApprover = null;
string sql = "select top 1 * from ApproverList where flowId=@flowId and approveType='eng' order by seqNo desc";
SqlParameter para = new SqlParameter("@flowId", flowId);
using (SqlDataReader reader = SqlHelper.ExecuteReader(sql, para))
{
if (reader.Read())
{
lastApprover = new Model.ApproverInfo
{
SNO = int.Parse(reader["SNO"].ToString()),
FlowId = int.Parse(reader["flowId"].ToString()),
UID = reader["UID"].ToString(),
SeqNo = int.Parse(reader["seqNo"].ToString()),
ApproveType = reader["approveType"].ToString(),
IsGroup = int.Parse(reader["isgroup"].ToString())
};
}
}
return(lastApprover);
}
