/// <summary>
/// 得到资产信息(分页)
/// </summary>
/// <param name="start">起始页</param>
/// <param name="max">最大条数</param>
/// <returns></returns>
public static DataTable getLogList(int start, int max, string departId, string power)
{
sqlHandler sh = new sqlHandler();
string sql = "";
if (power == "0" || power == "1")
{
sql = "select * from View_FixLog order by 流水号";
}
else if (power == "2")
{
sql = string.Format("select * from View_FixLog where 部门编号 like '{0}%'order by 流水号", departId.Substring(0, 2));
}
else
{
sql = string.Format("select * from View_FixLog where 部门编号='{0}'order by 流水号", departId);
}
DataTable dt = sh.GetDataTable_Page(sql, start, max);
if (dt != null)
{
return(dt);
}
else
{
return(null);
}
}
/// <summary>
/// 得到资产信息(分页)
/// </summary>
/// <param name="start">起始页</param>
/// <param name="max">最大条数</param>
/// <returns></returns>
public static DataTable getEqList(int start, int max)
{
sqlHandler sh = new sqlHandler();
string sql = "select * from view_eqInfo select * from view_eqInfo order by 资产编号 desc ";
DataTable dt = sh.GetDataTable_Page(sql, start, max);
if (dt != null)
{
return(dt);
}
else
{
return(null);
}
}
/// <summary>
/// 得到筛选资产信息(分页)
/// </summary>
/// <param name="start">起始页</param>
/// <param name="max">最大条数</param>
/// <returns></returns>
public static DataTable getSortEqList(int start, int max, string departId, string power, List <string> SelectedColumns, Dictionary <String, String> SortsString, string OrderString)
{
string selectItem = "";
foreach (string field in SelectedColumns)
{
if (field.Contains("/") || field.Contains("("))
{
selectItem += "[" + field + "]" + ", ";
}
else
{
selectItem += field + ", ";
}
}
selectItem = selectItem.Substring(0, selectItem.Length - 2);
string sortSet = "";
int index = 0;
foreach (KeyValuePair <string, string> kvp in SortsString)
{
if (string.IsNullOrEmpty(kvp.Value))
{
continue;
}
if (index == 0)
{
sortSet = kvp.Value;
}
else
{
sortSet = sortSet + " and " + kvp.Value;
}
index++;
}
sqlHandler sh = new sqlHandler();
string sql = "";
if (string.IsNullOrEmpty(sortSet))
{
if (string.IsNullOrEmpty(OrderString))
{
if (power == "0" || power == "1")
{
sql = string.Format("select {0} from View_FixLog order by 流水号", selectItem);
}
else if (power == "2")
{
sql = string.Format("select {1} from View_FixLog where 部门编号 like '{0}%'order by 流水号", departId.Substring(0, 2), selectItem);
}
else
{
sql = string.Format("select {1} from View_FixLog where 部门编号='{0}'order by 流水号", departId, selectItem);
}
}
else
{
if (power == "0" || power == "1")
{
sql = string.Format("select {0} from View_FixLog order by {1}", selectItem, OrderString);
}
else if (power == "2")
{
sql = string.Format("select {1} from View_FixLog where 部门编号 like '{0}%'order by {2}", departId.Substring(0, 2), selectItem, OrderString);
}
else
{
sql = string.Format("select {1} from View_FixLog where 部门编号='{0}'order by {2}", departId, selectItem, OrderString);
}
}
}
else
{
if (string.IsNullOrEmpty(OrderString))
{
if (power == "0" || power == "1")
{
sql = string.Format("select {0} from View_FixLog where {1} order by 流水号", selectItem, sortSet);
}
else if (power == "2")
{
sql = string.Format("select {1} from View_FixLog where 部门编号 like '{0}%' and {2} order by 流水号", departId.Substring(0, 2), selectItem, sortSet);
}
else
{
sql = string.Format("select {1} from View_FixLog where 部门编号='{0}'and {2} order by 流水号", departId, selectItem, sortSet);
}
}
else
{
if (power == "0" || power == "1")
{
sql = string.Format("select {0} from View_FixLog where {1} order by {2}", selectItem, sortSet, OrderString);
}
else if (power == "2")
{
sql = string.Format("select {1} from View_FixLog where 部门编号 like '{0}%' and {2} order by {3}", departId.Substring(0, 2), selectItem, sortSet, OrderString);
}
else
{
sql = string.Format("select {1} from View_FixLog where 部门编号='{0}' and {2} order by {3}", departId, selectItem, sortSet, OrderString);
}
}
}
DataTable dt = sh.GetDataTable_Page(sql, start, max);
if (dt != null)
{
return(dt);
}
else
{
return(null);
}
}
