/// <summary>
/// 用职位编号获取设备信息
/// </summary>
/// <param name="sbbh">职位编号</param>
/// <returns>DataTable</returns>
public SYS.Model.ZWB Get_zwxx_by_bh(int zwbh)
{
string sql = "select * from ZWB where zwbh=@zwbh";
SqlParameter[] spr =
{
new SqlParameter("@zwbh", zwbh)
};
try
{
SYS.Model.ZWB sb = new SYS.Model.ZWB();
DataTable dt = new DataTable();
dt = DBHelperSQL.GetDataTable(sql, CommandType.Text, spr);
if (dt.Rows.Count > 0)
{
sb.ZWBH = int.Parse(dt.Rows[0]["ZWBH"].ToString());
sb.ZWQX = int.Parse(dt.Rows[0]["ZWQX"].ToString());
sb.ZWMC = dt.Rows[0]["ZWMC"].ToString();
sb.ZWSM = dt.Rows[0]["ZWSM"].ToString();
}
return(sb);
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// 用username/ygbh获取信息
/// </summary>
/// <param name="sbbh">username/ygbh</param>
/// <returns>bool</returns>
public string getZwmcbyZwbh(int zwbh)
{
string sql = "select * from ZWB where ZWBH=@ZWBH";
SqlParameter[] spr =
{
new SqlParameter("@ZWBH", zwbh)
};
try
{
SYS.Model.ZWB sb = new SYS.Model.ZWB();
DataTable dt = new DataTable();
dt = DBHelperSQL.GetDataTable(sql, CommandType.Text, spr);
if (dt.Rows.Count > 0)
{
sb.ZWMC = dt.Rows[0]["ZWMC"].ToString();
}
return(sb.ZWMC);
}
catch (Exception)
{
throw;
}
}
