public object GetWorkFlowCaseByCaseId(string caseId, string actid)
{
List<FX_AttachMent> listAttachment = new List<FX_AttachMent>();
List<B_OA_Supervision> listSupervision = new List<B_OA_Supervision>();
DataTable ngbm = new DataTable();
IDbTransaction tran = Utility.Database.BeginDbTransaction();
try
{
//工作流信息
StringBuilder strSql = new StringBuilder();
strSql.AppendFormat(@"
select * from FX_WorkFlowBusAct where CaseID = '{0}' and SendDate is not null ORDER BY SendDate DESC", caseId);
var ds = Utility.Database.ExcuteDataSet(strSql.ToString(), tran);
List<FX_WorkFlowBusAct> listWork =
JsonConvert.DeserializeObject<List<FX_WorkFlowBusAct>>(JsonConvert.SerializeObject(ds.Tables[0]));
//附件信息
FX_AttachMent attachment = new FX_AttachMent();
attachment.Condition.Add("CaseID = " + caseId);
listAttachment = Utility.Database.QueryList<FX_AttachMent>(attachment, tran);
//督办信息
B_OA_Supervision supervision = new B_OA_Supervision();
supervision.Condition.Add("caseId = " + caseId);
supervision.OrderInfo = "createDate desc";
listSupervision = Utility.Database.QueryList<B_OA_Supervision>(supervision, tran);
//获取附件路径
string dir = IWorkFlow.Host.Utility.config.get("FileDir");
dir = dir.Replace("\\", "/");
//拟稿人和拟稿部门
if (!string.IsNullOrEmpty(actid))
{
ngbm = GetUserNameAndDepartNameByActId(caseId, actid, tran);
}
//关闭连接池
Utility.Database.Commit(tran);
return new
{
listAttachment = listAttachment,
listWork = listWork,
listSupervision = listSupervision,
dir = dir,
ngbm = ngbm
};
}
catch (Exception ex)
{
ComBase.Logger(ex);
throw (new Exception("获取数据失败！", ex));
}
}
public B_OA_Supervision GetSupervisionInforByCaseId(string caseid, IDbTransaction tran)
{
B_OA_Supervision supervision = new B_OA_Supervision();
supervision.Condition.Add("caseId = " + caseid);
supervision = Utility.Database.QueryObject<B_OA_Supervision>(supervision, tran);
return supervision;
}
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 en = new B_OA_Supervision();
en.Condition.Add("caseId=" + caseId);
data.supervisionBaseInfo = Utility.Database.QueryObject<B_OA_Supervision>(en);
B_OA_Supervision_Bill supervisionBill = new B_OA_Supervision_Bill();
supervisionBill.Condition.Add("caseid =" + caseId);
data.supervisionBill = Utility.Database.QueryObject<B_OA_Supervision_Bill>(supervisionBill);
if (data.supervisionBaseInfo == null)
{
var baseInfo = new B_OA_Supervision();
baseInfo.createDate = DateTime.Now.ToString();
baseInfo.supervisionManId = userid;
baseInfo.status = "1";//未读取的督办
baseInfo.supervisionManName = ComClass.GetUserInfo(userid).CnName;
data.supervisionBaseInfo = baseInfo;
//督办通知单据
B_OA_Supervision_Bill supervisionBill_ad = new B_OA_Supervision_Bill();
supervisionBill_ad.content = GetSupervisionBill("notice");
supervisionBill_ad.year = DateTime.Now.Year.ToString();
supervisionBill_ad.createDate = DateTime.Now.ToString("yyyy年MM月dd日");
data.supervisionBill = supervisionBill_ad;
}
return data;
}
public List<B_OA_Supervision> GetSupervisionList(string caseid, IDbTransaction tran)
{
List<B_OA_Supervision> listSupervision = new List<B_OA_Supervision>();
B_OA_Supervision supervision = new B_OA_Supervision();
supervision.Condition.Add("relationCaseId =" + caseid);
listSupervision = Utility.Database.QueryList(supervision, tran);
return listSupervision;
}