/// <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; } }