/// <summary>
///
/// </summary>
/// <returns></returns>
public DataTable GetBianMa()
{
dataWork dw = new dataWork();
StringBuilder str = new StringBuilder();
str.Append(" select top 1* from BuildingEquipmentBase ");
str.Append(" where be_DeleteStateCode=0 and b_ID>87 order by b_ID asc ");
string sql = string.Format(str.ToString());
DataTable dt = dw.GetDS(sql.ToString()).Tables[0];
return dt;
}
/// <summary>
/// 根据部门ID获取部门名称
/// </summary>
/// <param name="e_ID"></param>
/// <returns></returns>
public string GetE_NameCh(Guid e_ID)
{
string value = "";
dataWork dw = new dataWork();
string sql = "select top 1 d_MingCh from DepartmentBase where d_ID='" + e_ID + "' and d_DeleteStateCode=0 ";
DataTable dt = dw.GetDS(sql.ToString()).Tables[0];
if (dt.Rows.Count > 0)
{
value = dt.Rows[0]["d_MingCh"].ToString();
}
return value;
}
