/// <summary>
/// 删除代理设置信息
/// </summary>
/// <param name="AgentSetId">代理ID</param>
/// <returns></returns>
public bool DeleteAgentSet(string[] AgentSetId)
{
try
{
AgentManagementDAL Amd = new AgentManagementDAL();
var entitys = from ent in Amd.GetTable().ToList()
where AgentSetId.Contains(ent.AGENTSETID)
select ent;
if (entitys.Count() > 0)
{
foreach (var obj in entitys)
{
dal.DeleteFromContext(obj);
}
int i = dal.SaveContextChanges();
return(i > 0 ? true : false);
}
return(false);
}
catch (Exception ex)
{
Tracer.Debug("代理岗位设置ProxySettingsBLL-DeleteAgentSet" + System.DateTime.Now.ToString() + " " + ex.ToString());
return(false);
throw (ex);
}
}
public T_OA_AGENTSET GetQueryAgent(string UserId, string ModCode)
{
try
{
AgentManagementDAL Amd = new AgentManagementDAL();
var ents = from a in dal.GetObjects()
where a.MODELCODE == ModCode && a.USERID == UserId
select a;
if (ents.Count() > 0)
{
return(ents.FirstOrDefault());
}
else
{
return(null);
}
}
catch (Exception ex)
{
Tracer.Debug("代理岗位设置ProxySettingsBLL-GetQueryAgent" + System.DateTime.Now.ToString() + " " + ex.ToString());
return(null);
throw (ex);
}
}
public bool IsExistAGENTForUser(string UserId)
{
try
{
AgentManagementDAL Amd = new AgentManagementDAL();
DateTime Now = System.DateTime.Now;
var entity = from ent in dal.GetObjects <T_OA_AGENTDATESET>()
where Now >= ent.EFFECTIVEDATE && Now <= ent.PLANEXPIRATIONDATE &&
ent.EXPIRATIONDATE == null && ent.USERID == UserId
select ent;
if (entity.Count() > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
Tracer.Debug("代理岗位设置ProxySettingsBLL-IsExistAGENTForUser" + System.DateTime.Now.ToString() + " " + ex.ToString());
throw (ex);
}
}
/// <summary>
/// 获取代理设置信息
/// </summary>
/// <param name="userID">用户ID</param>
/// <returns></returns>
public List <T_OA_AGENTSET> GetAgentSetInfo(int pageIndex, int pageSize, string sort, string filterString, IList <object> paras, ref int pageCount, string userID)
{
try
{
AgentManagementDAL Amd = new AgentManagementDAL();
var ents = from a in dal.GetObjects()
select a;
if (ents.Count() > 0)
{
List <object> queryParas = new List <object>();
queryParas.AddRange(paras);
UtilityClass.SetOrganizationFilter(ref filterString, ref queryParas, userID, "T_OA_AGENTSET");
if (!string.IsNullOrEmpty(filterString))
{
ents = ents.ToList().AsQueryable().Where(filterString, queryParas.ToArray());
}
ents = ents.OrderBy(sort);
ents = Utility.Pager <T_OA_AGENTSET>(ents, pageIndex, pageSize, ref pageCount);
return(ents.ToList());
}
return(null);
}
catch (Exception ex)
{
Tracer.Debug("代理岗位设置ProxySettingsBLL-GetAgentSetInfo" + System.DateTime.Now.ToString() + " " + ex.ToString());
return(null);
throw (ex);
}
}
/// <summary>
/// 检查是否存在该代理设置信息
/// </summary>
/// <param name="sysCode">系统代码</param>
/// <param name="modelCode">模块代码</param>
/// <returns></returns>
public bool IsExistAgentSet(string sysCode, string modelCode)
{
AgentManagementDAL Amd = new AgentManagementDAL();
bool IsExist = false;
var q = from cnt in Amd.GetTable()
where cnt.SYSCODE == sysCode && cnt.MODELCODE == modelCode
orderby cnt.CREATEUSERID
select cnt;
if (q.Count() > 0)
{
IsExist = true;
}
return(IsExist);
}
/// <summary>
/// 修改代理设置信息
/// </summary>
/// <param name="contraApproval">代理设置实体</param>
/// <returns></returns>
public bool UpdateAgentSet(T_OA_AGENTSET AgentSet)
{
bool result = false;
try
{
AgentManagementDAL Amd = new AgentManagementDAL();
var users = from ent in Amd.GetTable()
where ent.AGENTSETID == AgentSet.AGENTSETID
select ent;
if (users.Count() > 0)
{
var user = users.FirstOrDefault();
AgentSet.UPDATEDATE = Convert.ToDateTime(DateTime.Now.ToShortDateString());
user.SYSCODE = AgentSet.SYSCODE; //系统代码
user.MODELCODE = AgentSet.MODELCODE; //代理模块
user.AGENTPOSTID = AgentSet.AGENTPOSTID; //代理岗位
user.UPDATEUSERID = AgentSet.UPDATEUSERID; //修改人ID
user.UPDATEUSERNAME = AgentSet.UPDATEUSERNAME; //修改人姓名
int asUpdate = Amd.Update(user);
if (asUpdate > 0)
{
result = true;
}
}
return(result);
}
catch (Exception ex)
{
Tracer.Debug("代理岗位设置ProxySettingsBLL-UpdateAgentSet" + System.DateTime.Now.ToString() + " " + ex.ToString());
throw (ex);
}
}