public object GetData(string userid, string caseId, string baid) { //只有待办箱才有设置为已读 if (!String.IsNullOrEmpty(baid)) engineAPI.SetIsReaded(caseId, baid, userid); GetDataModel data = new GetDataModel(); B_OA_SupervisionReminder en = new B_OA_SupervisionReminder(); en.Condition.Add("caseId=" + caseId); data.reminderBaseInfor = Utility.Database.QueryObject<B_OA_SupervisionReminder>(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.reminderBaseInfor == null) { var baseInfo = new B_OA_SupervisionReminder(); baseInfo.createDate = DateTime.Now.ToString(); baseInfo.reminderManId = userid; baseInfo.reminderManName = ComClass.GetUserInfo(userid).CnName; data.reminderBaseInfor = baseInfo; //督办通知单据 B_OA_Supervision_Bill supervisionBill_ad = new B_OA_Supervision_Bill(); supervisionBill_ad.content = GetSupervisionBill(); supervisionBill_ad.year = DateTime.Now.Year.ToString(); supervisionBill_ad.createDate = DateTime.Now.ToString("yyyy年MM月dd日"); data.supervisionBill = supervisionBill_ad; } return data; }
//保存督办申请单 public void SaveSupervisionNoticeBill(B_OA_Supervision_Bill supervisionBill, string caseid, IDbTransaction tran) { if (supervisionBill.id == 0) { //编号 string code = CommonFunctional.getCommonCode("supervisionNoticeCode", tran).code; supervisionBill.code = code; //督办类别 0为督办申请单 supervisionBill.type = 0; supervisionBill.caseid = caseid; Utility.Database.Insert(supervisionBill, tran); //strSql.Clear(); //strSql.AppendFormat(@"select @@IDENTITY"); //int id = Utility.Database.QueryObject<int>(strSql.ToString(), tran); //data.supervisionBaseInfo.id = id; } else { Utility.Database.Update(supervisionBill, tran); } }
//保存督办申请单 public void SaveSupervisionNoticeBill(B_OA_Supervision_Bill supervisionBill, string caseid, IDbTransaction tran) { if (supervisionBill.id == 0) { //编号 string code = CommonFunctional.getCommonCode("supervisionDocCode", tran).code; supervisionBill.code = code; //督办类别 0为督办申请单 supervisionBill.type = 0; supervisionBill.caseid = caseid; Utility.Database.Insert(supervisionBill, tran); } else { Utility.Database.Update(supervisionBill, tran); } }