public static List <object> GetSubUserItems(string strPost_Dept, string strUserID)
{
List <object> listResult = new List <object>();
DataTable dt = new DataTable();
TSysUserVo objUser = new TSysUserVo();
objUser.IS_DEL = "0";
dt = new TSysUserLogic().SelectByTableUnderDept(strPost_Dept, 0, 0);
DataTable dtItems = new DataTable();
dtItems = dt.Copy();
dtItems.Clear();
if (strUserID.Length > 0)
{
for (int i = 0; i < strUserID.Split(',').Length; i++)
{
DataRow[] dr = dt.Select("ID='" + strUserID.Split(',')[i] + "'");
if (dr != null)
{
foreach (DataRow Temrow in dr)
{
Temrow.Delete();
dt.AcceptChanges();
}
}
}
}
dtItems = dt.Copy();
listResult = LigerGridSelectDataToJson(dtItems, dtItems.Rows.Count);
return(listResult);
}
public static List <object> GetMonitorSubItems(string strStandId, string strCondtionId, string strMonitor)
{
List <object> reslut = new List <object>();
DataTable dtSt = new DataTable();
TBaseEvaluationConItemVo objtd = new TBaseEvaluationConItemVo();
objtd.IS_DEL = "0";
objtd.MONITOR_ID = strMonitor;
objtd.STANDARD_ID = strStandId;
objtd.CONDITION_ID = strCondtionId;
dtSt = new TBaseEvaluationConItemLogic().SelectByTable(objtd);
DataTable dt = new DataTable();
TBaseItemInfoVo objitem = new TBaseItemInfoVo();
objitem.MONITOR_ID = strMonitor;
objitem.IS_DEL = "0";
dt = new TBaseItemInfoLogic().SelectByTable(objitem);
DataTable dtItem = new DataTable();
dtItem = dt.Copy();
dtItem.Clear();
if (dtSt.Rows.Count > 0)
{
for (int i = 0; i < dtSt.Rows.Count; i++)
{
if (!String.IsNullOrEmpty(dtSt.Rows[i]["ITEM_ID"].ToString()))
{
DataRow[] dr = dt.Select("ID='" + dtSt.Rows[i]["ITEM_ID"].ToString() + "'");
if (dr != null)
{
foreach (DataRow Temrow in dr)
{
Temrow.Delete();
dt.AcceptChanges();
}
}
}
}
}
dtItem = dt.Copy();
reslut = LigerGridSelectDataToJson(dtItem, dtItem.Rows.Count);
//reslut = gridDataToJson(dtSt, dtSt.Rows.Count, objtd);
return(reslut);
}
public static List <object> GetSubUserItems(string strPost_Dept, string strItemID, string strDutyType)
{
DataTable dt = new TSysUserLogic().SelectByTableUnderDept(strPost_Dept, 0, 0);
TSysDutyVo objItems = new TSysDutyVo();
objItems.MONITOR_ITEM_ID = strItemID;
objItems.DICT_CODE = strDutyType;
DataTable dtDuty = new TSysDutyLogic().SelectByUnionTableForWhere(objItems, 0, 0);
DataTable dtItems = new DataTable();
dtItems = dt.Copy();
dtItems.Clear();
if (dtDuty.Rows.Count > 0)
{
for (int i = 0; i < dtDuty.Rows.Count; i++)
{
if (!String.IsNullOrEmpty(dtDuty.Rows[i]["ID"].ToString()))
{
DataRow[] dr = dt.Select("ID='" + dtDuty.Rows[i]["ID"].ToString() + "'");
if (dr != null)
{
foreach (DataRow Temrow in dr)
{
Temrow.Delete();
dt.AcceptChanges();
}
}
}
}
}
dtItems = dt.Copy();
List <object> listResult = LigerGridSelectDataToJson(dtItems, dtItems.Rows.Count);
return(listResult);
}
public static List <object> GetSubUserItems(string strPost_Dept, string strMonitorId, string strDutyType)
{
List <object> listResult = new List <object>();
DataTable dt = new DataTable();
DataTable dtDuty = new DataTable();
dt = new TSysUserLogic().SelectByTableUnderDept(strPost_Dept, 0, 0);
dtDuty = new TSysUserDutyLogic().SelectUserDuty(strDutyType, strMonitorId);
DataTable dtItems = new DataTable();
dtItems = dt.Copy();
dtItems.Clear();
if (dtDuty.Rows.Count > 0)
{
for (int i = 0; i < dtDuty.Rows.Count; i++)
{
if (!String.IsNullOrEmpty(dtDuty.Rows[i]["USERID"].ToString()))
{
DataRow[] dr = dt.Select("ID='" + dtDuty.Rows[i]["USERID"].ToString() + "'");
if (dr != null)
{
foreach (DataRow Temrow in dr)
{
Temrow.Delete();
dt.AcceptChanges();
}
}
}
}
}
dtItems = dt.Copy();
listResult = LigerGridSelectDataToJson(dtItems, dtItems.Rows.Count);
return(listResult);
}
