public int GetCount(Modules.Helper.ChangeTrackingList <Modules.Helper.EntitySearcher> changeTrackingList)
{
StringBuilder str = new StringBuilder();
str.Append("SELECT records= count(*) ");
str.Append("FROM ");
str.Append("(select distinct FlowID FROM vw_oa_flowauthority WHERE 1=1 ");
if (changeTrackingList.Count > 0)
{
str.Append(" AND ");
str.Append(JointSearcher.BuidSQL(changeTrackingList));
}
str.Append(" ) as t");
int count = 0;
try
{
DataTable dt = DbHelperSQL.Query(str.ToString()).Tables[0];
count = int.Parse(dt.Rows[0]["records"].ToString());
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return(count);
}
public List <Modules.OA_FlowSort> GetList(Modules.Helper.ChangeTrackingList <Modules.Helper.EntitySearcher> changeTrackingList, int start, int records)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT * ");
strSql.Append("FROM OA_FlowSort WHERE 1=1 ");
if (changeTrackingList.Count > 0)
{
strSql.Append(" AND ");
strSql.Append(JointSearcher.BuidSQL(changeTrackingList));
}
List <Modules.OA_FlowSort> list = new List <Modules.OA_FlowSort>();
try
{
DataTable dt = DbHelperSQL.GetList(strSql.ToString(), start, records).Tables[0];
list = FineOffice.Common.CollectionHelper.ConvertTo <FineOffice.Modules.OA_FlowSort>(dt) as List <FineOffice.Modules.OA_FlowSort>;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return(list);
}
public List <Modules.CNS_CensusMember> GetList(Modules.Helper.ChangeTrackingList <Modules.Helper.EntitySearcher> changeTrackingList)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT * ");
strSql.Append("FROM vw_cns_censusmember WHERE 1=1 ");
if (changeTrackingList.Count > 0)
{
strSql.Append(" AND ");
strSql.Append(JointSearcher.BuidSQL(changeTrackingList));
}
List <Modules.CNS_CensusMember> list = new List <Modules.CNS_CensusMember>();
try
{
DataTable dt = DbHelperSQL.Query(strSql.ToString()).Tables[0];
list = FineOffice.Common.CollectionHelper.ConvertTo <FineOffice.Modules.CNS_CensusMember>(dt) as List <FineOffice.Modules.CNS_CensusMember>;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return(list);
}
public List <Modules.OA_Flow> GetList(Modules.Helper.ChangeTrackingList <Modules.Helper.EntitySearcher> changeTrackingList, int start, int records)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * from vw_oa_flow where ID in ( select distinct FlowID from vw_oa_flowauthority where 1=1 ");
if (changeTrackingList.Count > 0)
{
strSql.Append(" AND ");
strSql.Append(JointSearcher.BuidSQL(changeTrackingList));
}
strSql.Append(" ) ");
List <Modules.OA_Flow> list = new List <Modules.OA_Flow>();
try
{
DataTable dt = DbHelperSQL.GetList(strSql.ToString(), start, records).Tables[0];
list = FineOffice.Common.CollectionHelper.ConvertTo <FineOffice.Modules.OA_Flow>(dt) as List <FineOffice.Modules.OA_Flow>;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return(list);
}
public List <Modules.OA_WorkFlow> GetList(Modules.Helper.ChangeTrackingList <Modules.Helper.EntitySearcher> changeTrackingList, int start, int records)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT * ");
strSql.Append("FROM Vw_WorkFlow WHERE 1=1 ");
if (changeTrackingList.Count > 0)
{
foreach (Modules.Helper.EntitySearcher searcher in changeTrackingList)
{
strSql.Append("AND ");
if (searcher.Operator.Equals("LIKE") || searcher.Operator.Equals("NOT LIKE"))
{
strSql.Append(searcher.Field + " " + searcher.Operator + " '%" + searcher.Content + "%' ");
}
else
{
strSql.Append(searcher.Field + " " + searcher.Operator + " '" + searcher.Content + "' ");
}
}
}
List <Modules.OA_WorkFlow> list = new List <Modules.OA_WorkFlow>();
try
{
DataTable dt = SqlHelper.GetList(strSql.ToString(), start, records).Tables[0];
list = BX.Common.CollectionHelper.ConvertTo <BX.Entity.OA_WorkFlow>(dt) as List <BX.Modules.OA_WorkFlow>;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return(list);
}
/// <summary>
/// ListToTrackingList
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="list"></param>
/// <returns></returns>
public static Modules.Helper.ChangeTrackingList <T> ConvertToChangeTrackingList <T>(IList <T> list) where T : ITrackable, INotifyPropertyChanged
{
Modules.Helper.ChangeTrackingList <T> trackingList = new Modules.Helper.ChangeTrackingList <T>();
foreach (T item in list)
{
trackingList.Add(item);
}
return(trackingList);
}
/// <summary>
/// 批量新增
/// </summary>
/// <param name="list"></param>
public void AddAll(Modules.Helper.ChangeTrackingList <Modules.OA_FlowForm> list)
{
dal.Initialization();
List <Entity.OA_FlowForm> entityList = (from temp in list
select new FineOffice.Entity.OA_FlowForm
{
FlowID = temp.FlowID,
ID = temp.ID,
FormID = temp.FormID,
ProcessID = temp.ProcessID,
}).ToList();
dal.Add(entityList);
dal.Dispose();
}
public int GetCount(Modules.Helper.ChangeTrackingList <Modules.Helper.EntitySearcher> changeTrackingList)
{
StringBuilder str = new StringBuilder();
str.Append("SELECT records= count(ID) ");
str.Append("FROM HR_Department WHERE 1=1 ");
int count = 0;
if (changeTrackingList.Count > 0)
{
str.Append(" AND ");
str.Append(JointSearcher.BuidSQL(changeTrackingList));
}
try
{
DataTable dt = DbHelperSQL.Query(str.ToString()).Tables[0];
count = int.Parse(dt.Rows[0]["records"].ToString());
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return(count);
}
public int GetCount(Modules.Helper.ChangeTrackingList <Modules.Helper.EntitySearcher> changeTrackingList)
{
return(dal.GetCount(changeTrackingList));
}
/// <summary>
/// 分页sql方式查询
/// </summary>
public List <Modules.OA_Flow> GetList(Modules.Helper.ChangeTrackingList <Modules.Helper.EntitySearcher> changeTrackingList, int start, int records)
{
return(dal.GetList(changeTrackingList, start, records));
}
/// <summary>
/// sql方式查询
/// </summary>
/// <param name="changeTrackingList"></param>
/// <returns></returns>
public List <Modules.OA_Flow> GetList(Modules.Helper.ChangeTrackingList <Modules.Helper.EntitySearcher> changeTrackingList)
{
return(dal.GetList(changeTrackingList));
}
/// <summary>
/// sql方式查询
/// </summary>
/// <param name="changeTrackingList"></param>
/// <returns></returns>
public List <Modules.HD_Attachment> GetList(Modules.Helper.ChangeTrackingList <Modules.Helper.EntitySearcher> changeTrackingList)
{
return(dal.GetList(changeTrackingList));
}
/// <summary>
/// 分页sql方式查询
/// </summary>
/// <param name="changeTrackingList"></param>
/// <param name="start"></param>
/// <param name="records"></param>
/// <returns></returns>
public List <Modules.CNS_CensusRegister> GetList(Modules.Helper.ChangeTrackingList <Modules.Helper.EntitySearcher> changeTrackingList, int start, int records)
{
return(dal.GetList(changeTrackingList, start, records));
}
/// <summary>
/// sql方式查询
/// </summary>
/// <param name="changeTrackingList"></param>
/// <returns></returns>
public List <Modules.CNS_CensusRegister> GetList(Modules.Helper.ChangeTrackingList <Modules.Helper.EntitySearcher> changeTrackingList)
{
return(dal.GetList(changeTrackingList));
}
/// <summary>
/// sql方式查询
/// </summary>
/// <param name="changeTrackingList"></param>
/// <returns></returns>
public List <Modules.SYS_PageAuthority> GetList(Modules.Helper.ChangeTrackingList <Modules.Helper.EntitySearcher> changeTrackingList)
{
return(dal.GetList(changeTrackingList));
}
/// <summary>
/// sql方式查询
/// </summary>
/// <param name="changeTrackingList"></param>
/// <returns></returns>
public List <Modules.HR_Personnel> GetList(Modules.Helper.ChangeTrackingList <Modules.Helper.EntitySearcher> changeTrackingList)
{
return(dal.GetList(changeTrackingList));
}
