public DataTable GetBySSJD(string ssjd)
{
if (!string.IsNullOrWhiteSpace(ssjd))
{
return(baseDb.GetAllByPara(0, new KeyValuePair <string, object>("SSJD", ssjd)));
}
else
{
return(baseDb.GetAllByPara(0));
}
}
/// <summary>
/// 按父节点code获取子节点列表
/// </summary>
/// <param name="code">父节点code</param>
/// <returns></returns>
public DataTable GetListByCode(string code)
{
DataTable parent = BaseDb.GetAllByPara(0, new KeyValuePair <string, object>("Code", code));
if (parent.Rows.Count > 0)
{
return(BaseDb.GetAllByPara(0, new KeyValuePair <string, object>("ParentID", parent.Rows[0]["ID"])));
}
else
{
return(new DataTable());
}
}
/// <summary>
/// 获取当前用户的报送任务列表
/// </summary>
public List <string> GetCurrentUsersList()
{
List <string> list = new List <string>();
DataTable dt = baseDb.GetAllByPara(0, new KeyValuePair <string, object>("SenderID", UsersBLL.CurrentUserID), new KeyValuePair <string, object>("StepName", "物业报送"));
foreach (DataRow dr in dt.Rows)
{
if (!list.Contains((string)dr["InstanceID"]))
{
list.Add((string)dr["InstanceID"]);
}
}
return(list);
}
public DataTable GetByStringID(string id)
{
return(baseDb.GetAllByPara(0, new KeyValuePair <string, object>("ID", id), new KeyValuePair <string, object>("Status", RoadFlow.Data.Model.Status.Normal)));//0表示取所有，大于取前几条。
}
///// <summary>
///// 按组织获取楼栋变更权限列表
///// </summary>
///// <param name="organizeID">组织ID</param>
///// <returns></returns>
//public DataTable GetBuildingModifyByOrganizeID(Guid organizeID) {
// return GetByTypeAndOrganizeID(RoadFlow.Data.Model.ElementOrganizeType.EnterpriseTax, organizeID);
//}
//#endregion
/// <summary>
///
/// </summary>
/// <param name="type"></param>
/// <param name="organizeID">组织机构ID</param>
/// <returns></returns>
public DataTable GetByTypeAndOrganizeID(RoadFlow.Data.Model.ElementOrganizeType type, Guid organizeID)
{
return(baseDb.GetAllByPara(0, new KeyValuePair <string, object>("Type", type), new KeyValuePair <string, object>("OrganizeID", organizeID), new KeyValuePair <string, object>("Status", RoadFlow.Data.Model.Status.Normal)));
}
/// <summary>
/// 获取所有街道
/// </summary>
/// <returns></returns>
public DataTable GetAllStreet()
{
RoadFlow.Data.Model.OrganizeModel parent = baseDb.Get <RoadFlow.Data.Model.OrganizeModel>(new KeyValuePair <string, object>("Name", "街道办"));
return(baseDb.GetAllByPara(0, new KeyValuePair <string, object>("ParentID", parent.ID)));//0表示取所有，大于取前几条。
}