/// <summary> /// 我的单据新增 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool AddPersonalRecordList(T_PF_PERSONALRECORD model) { try { PersonalRecordDAL dal = new PersonalRecordDAL(); string recordID = dal.GetExistRecord(model.SYSTYPE, model.MODELCODE, model.MODELID, model.OWNERID, model.OWNERCOMPANYID, model.ISFORWARD); if (recordID != "") { return dal.UpdatePersonalRecord(model, recordID); } else { var bol= dal.AddPersonalRecord(model); if (bol) { PersonnelWS.PersonnelServiceClient HRClient = new PersonnelWS.PersonnelServiceClient(); var user = HRClient.GetEmployeeByID(model.OWNERID); SendEmail("你有新的单据请登录系统查看!", user.EMAIL); Log.WriteLog("FormID=" + model.MODELID + ";MODELDESCRIPTION=" + model.MODELDESCRIPTION + ";接收EMAIL=" + user.EMAIL+";所属人ID="+user.OWNERID); } return bol; } } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
/// <summary> /// 我的单据新增 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool AddPersonalRecord(T_PF_PERSONALRECORD model) { try { PersonalRecordDAL dal = new PersonalRecordDAL(); string recordID = dal.GetExistDoTask(model.MODELCODE, model.MODELID, model.OWNERID, model.OWNERCOMPANYID); if (model.CHECKSTATE == "0" && string.IsNullOrWhiteSpace(recordID)) { SMTEngine.EngineWcfGlobalFunctionClient client = new SMTEngine.EngineWcfGlobalFunctionClient(); client.TaskCacheReflesh(model.OWNERID); return dal.AddDoTask(model); } else { return true; //修改状态该为流程来做 } } catch (Exception ex) { Tracer.Debug("新增我的代办 CHECKSTATE=" + model.MODELCODE + "Exception:"+ex.Message); throw new Exception(ex.Message, ex); } }
/// <summary> /// 返回我的单据实体列表[longkc] /// </summary> /// <param name="pageIndex"></param> /// <param name="strOrderBy"></param> /// <param name="checkstate"></param> /// <param name="filterString"></param> /// <param name="ownerid"></param> /// <param name="Isforward"></param> /// <param name="BeginDate"></param> /// <param name="EndDate"></param> /// <param name="pageCount"></param> /// <returns></returns> public List<T_PF_PERSONALRECORD> GetPersonalRecordListNew(int pageIndex, string strOrderBy, string checkstate, string filterString, string ownerid, string Isforward, string BeginDate, string EndDate, ref int pageCount) { PersonalRecordDAL dal = new PersonalRecordDAL(); string filter = ""; if (!string.IsNullOrEmpty(checkstate)) { filter += " AND CHECKSTATE=" + checkstate + ""; } if (!string.IsNullOrEmpty(ownerid)) { filter += " AND OWNERID='" + ownerid + "'"; } if (!string.IsNullOrEmpty(Isforward)) { filter += " AND ISFORWARD=" + Isforward + ""; } if (!string.IsNullOrEmpty(BeginDate)) { filter += " AND createdate>=to_date('" + BeginDate + "','yyyy-MM-dd')"; } if (!string.IsNullOrEmpty(EndDate)) { filter += " AND createdate<=to_date('" + EndDate + "','yyyy-MM-dd')"; } if (!string.IsNullOrEmpty(filterString)) { filter += filterString; } return dal.GetPersonalRecordList(Config.pageSize, filter, pageIndex, strOrderBy, ref pageCount); }
/// <summary> /// 返回我的单据实体列表(未提交,转发两种状态的) /// </summary> /// <param name="pageIndex"></param> /// <param name="strOrderBy"></param> /// <param name="checkstate"></param> /// <param name="filterString"></param> /// <param name="strCreateID"></param> /// <param name="Isforward"></param> /// <param name="BeginDate"></param> /// <param name="EndDate"></param> /// <param name="pageCount"></param> /// <returns></returns> public List<T_PF_PERSONALRECORD> GetPersonalRecordList(int pageIndex, string strOrderBy, string checkstate, string filterString, string strCreateID, string Isforward, string BeginDate, string EndDate, ref int pageCount) { PersonalRecordDAL dal = new PersonalRecordDAL(); string filter = ""; if (!string.IsNullOrEmpty(checkstate)) { filter += " AND CHECKSTATE=" + checkstate + ""; } if (!string.IsNullOrEmpty(strCreateID)) { filter += " AND OWNERID='" + strCreateID + "'"; } if (!string.IsNullOrEmpty(Isforward)) { filter += " AND ISFORWARD=" + Isforward + ""; } if (!string.IsNullOrEmpty(filterString)) { filter += filterString; } return dal.GetPersonalRecordList(Config.pageSize, filter, pageIndex, strOrderBy, ref pageCount); }
/// <summary> /// 返回我的单据实体 /// </summary> /// <param name="_sysType"></param> /// <param name="_modelCode"></param> /// <param name="_modelID"></param> /// <param name="_IsForward"></param> /// <returns></returns> public T_PF_PERSONALRECORD GetPersonalRecordModelByModelID(string _sysType, string _modelCode, string _modelID, string _IsForward) { if (string.IsNullOrWhiteSpace(_sysType) && string.IsNullOrWhiteSpace(_modelCode) && string.IsNullOrWhiteSpace(_modelID) && string.IsNullOrWhiteSpace(_IsForward)) { return null; } else { PersonalRecordDAL dal = new PersonalRecordDAL(); return dal.GetEntity(_sysType, _modelCode, _modelID, _IsForward); } }
/// <summary> /// 返回我的单据实体 /// </summary> /// <param name="_personalrecordID"></param> /// <returns></returns> public T_PF_PERSONALRECORD GetPersonalRecordModelByID(string _personalrecordID) { if (string.IsNullOrWhiteSpace(_personalrecordID)) { return null; } else { PersonalRecordDAL dal = new PersonalRecordDAL(); return dal.GetEntity(_personalrecordID); } }
/// <summary> /// 删除我的单据 /// </summary> /// <param name="_personalrecordID"></param> /// <returns></returns> public bool DeletePersonalRecord(string _personalrecordID) { if (string.IsNullOrWhiteSpace(_personalrecordID)) { return false; } else { PersonalRecordDAL dal = new PersonalRecordDAL(); T_PF_PERSONALRECORD ent = dal.GetEntity("", "", _personalrecordID, ""); SMTEngine.EngineWcfGlobalFunctionClient client = new SMTEngine.EngineWcfGlobalFunctionClient(); client.TaskCacheReflesh(ent.OWNERID); return dal.DeletePersonalRecord(_personalrecordID); } }
/// <summary> /// 修改的单据 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool UpdatePersonalRecord(T_PF_PERSONALRECORD model) { PersonalRecordDAL dal = new PersonalRecordDAL(); if (string.IsNullOrWhiteSpace(model.PERSONALRECORDID)) { string recordID = dal.GetExistRecord(model.SYSTYPE, model.MODELCODE, model.MODELID, model.OWNERID, model.OWNERCOMPANYID, model.ISFORWARD); return dal.UpdatePersonalRecord(model, recordID); } else { return dal.UpdatePersonalRecord(model, model.PERSONALRECORDID); } }