/// <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="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="_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="_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="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));
}
}
/// <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 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)
{
LogHelper.WriteLog("新增我的代办 CHECKSTATE=" + model.MODELCODE + "Exception:" + ex.Message);
throw new Exception(ex.Message, ex);
}
}
/// <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));
}
