public object GetData(string userid, string caseId, string baid)
{
//只有待办箱才有设置为已读
if (!String.IsNullOrEmpty(baid)) engineAPI.SetIsReaded(caseId, baid, userid);
GetDataModel data = new GetDataModel();
B_OA_Supervision_Delay_Apply en = new B_OA_Supervision_Delay_Apply();
en.Condition.Add("caseId=" + caseId);
data.delayApplyBaseInfor = Utility.Database.QueryObject<B_OA_Supervision_Delay_Apply>(en);
if (data.delayApplyBaseInfor == null)
{
var baseInfo = new B_OA_Supervision_Delay_Apply();
baseInfo.createDate = DateTime.Now.ToString();
baseInfo.applyManId = userid;
baseInfo.applyManName = ComClass.GetUserInfo(userid).CnName;
data.delayApplyBaseInfor = baseInfo;
}
data.userid = userid;
return data;
}
/// <summary>
/// 创建一个Word数据
/// </summary>
/// <param name="caseid"></param>
/// <returns></returns>
private Dictionary<string, Object> CreateWrodData(string caseId, IDbTransaction tran)
{
B_OA_Supervision_Delay_Apply en = new B_OA_Supervision_Delay_Apply();
en.Condition.Add("caseId = " + caseId);//设置查询条件
en = Utility.Database.QueryObject<B_OA_Supervision_Delay_Apply>(en);
Dictionary<string, Object> list = new Dictionary<string, Object> {
{"title",en.title },//收文日期
{"delayReson",en.applyReason},//延期理由
{"delayDate",en.delayDate.ToString()},//延期时间
};
//读取签发图片
StringBuilder strSql = new StringBuilder();
strSql.AppendFormat(@"select s.*,u.CnName from B_OA_Sighture as s
LEFT JOIN FX_UserInfo as u on s.userid = u.UserID
where s.caseid='{0}' and s.tableName='{1}' and s.type='{2}'", caseId, "B_OA_Supervision_Delay_Apply", "0");
DataSet sightureDs = Utility.Database.ExcuteDataSet(strSql.ToString());
string jsonData = JsonConvert.SerializeObject(sightureDs.Tables[0]);
List<B_OA_Sighture> listSighture = (List<B_OA_Sighture>)JsonConvert.DeserializeObject(jsonData, typeof(List<B_OA_Sighture>));
if (listSighture.Count > 0)
{
var leaderList = new List<B_OA_Sighture>();
var assitantList = new List<B_OA_Sighture>();
for (int i = 0; i < listSighture.Count; i++)
{
//领导批示
if (listSighture[i].columnName == "learderApproval")
{
leaderList.Add(listSighture[i]);
}
else if (listSighture[i].columnName == "assitanLeaderSighture")
{
assitantList.Add(listSighture[i]);
}
}
var leaderSightureStr = new OpenXmlHelper.ImageTextArray[leaderList.Count];
var assitanSightureStr = new OpenXmlHelper.ImageTextArray[assitantList.Count];
for (var j = 0; j < leaderList.Count; j++)
{
B_OA_Sighture sighture_leader = new B_OA_Sighture();
sighture_leader = leaderList[j];
string rootPath = HttpContext.Current.Server.MapPath("/");
rootPath = rootPath.Replace("\\", "/");
string path = rootPath + sighture_leader.path;
if (File.Exists(path))
{
leaderSightureStr[j] = new OpenXmlHelper.ImageTextArray();
leaderSightureStr[j].Images = System.Drawing.Image.FromFile(path);
leaderSightureStr[j].Foots = sighture_leader.CnName + " " + Convert.ToDateTime(sighture_leader.createtime).ToString("yyyy年MM月dd日");
leaderSightureStr[j].FootAlign = DocumentFormat.OpenXml.Wordprocessing.JustificationValues.Right;
}
}
for (var k = 0; k < assitantList.Count; k++)
{
B_OA_Sighture sighture_assistant = new B_OA_Sighture();
sighture_assistant = assitantList[k];
string rootPath = HttpContext.Current.Server.MapPath("/");
rootPath = rootPath.Replace("\\", "/");
string path = rootPath + sighture_assistant.path;
if (File.Exists(path))
{
assitanSightureStr[k] = new OpenXmlHelper.ImageTextArray();
assitanSightureStr[k].Images = System.Drawing.Image.FromFile(path);
assitanSightureStr[k].Foots = sighture_assistant.CnName + " " + Convert.ToDateTime(sighture_assistant.createtime).ToString("yyyy年MM月dd日");
assitanSightureStr[k].FootAlign = DocumentFormat.OpenXml.Wordprocessing.JustificationValues.Right;
}
}
if (assitanSightureStr.Count() > 0)
{
list.Add("assistanSiggestion", assitanSightureStr);
}
if (leaderSightureStr.Count() > 0)
{
list.Add("leaderSuggesion", leaderSightureStr);
}
}
strSql.Clear();
strSql.AppendFormat("select CaseId,ActID,UserName,ReceDate,Remark from FX_WorkFlowBusAct where CaseID = '{0}' order by ReceDate asc", caseId);
DataSet busSet = Utility.Database.ExcuteDataSet(strSql.ToString());
string jsonData_bus = JsonConvert.SerializeObject(busSet.Tables[0]);
List<FX_WorkFlowBusAct> wfbaList = (List<FX_WorkFlowBusAct>)JsonConvert.DeserializeObject(jsonData_bus, typeof(List<FX_WorkFlowBusAct>));
List<string> listString = new List<string>();
for (int i = 0; i < wfbaList.Count; i++)
{
// 拟稿部门负责人核稿wfbaList[i].ActID == "A002" ||
if (wfbaList[i].ActID == "A004")
{
listString.Add(wfbaList[i].Remark + "--" + wfbaList[i].UserName + " " + wfbaList[i].ReceDate.ToString("yyyy年MM月dd日 hh:mm"));
}
}
if (listString.Count > 0)
{
list.Add("officeSuggesion", listString);
}
return list;
}
public void SetLimiteData(string caseid, IDbTransaction tran)
{
B_OA_Supervision_Delay_Apply delay = new B_OA_Supervision_Delay_Apply();
delay.Condition.Add("caseId = " + caseid);
delay = Utility.Database.QueryObject<B_OA_Supervision_Delay_Apply>(delay, tran);
StringBuilder strSql = new StringBuilder();
strSql.AppendFormat(@"select * from B_OA_Supervision where caseId =(
select relationCaseId from B_OA_Supervision_Delay_Apply where caseId = '{0}')", delay.caseId);
DataSet sightureDs = Utility.Database.ExcuteDataSet(strSql.ToString());
string jsonData = JsonConvert.SerializeObject(sightureDs.Tables[0]);
List<B_OA_Supervision> supervision = (List<B_OA_Supervision>)JsonConvert.DeserializeObject(jsonData, typeof(List<B_OA_Supervision>));
for (int i = 0; i < supervision.Count; i++)
{
supervision[i].limiteDate = delay.delayDate;
supervision[i].Condition.Add("id = " + supervision[i].id);
Utility.Database.Update(supervision[i], tran);
}
}
