//功能:读取密码信息
private static void ReadCase(ZbAreaConfig zbareaconfig, DataRow Row)
{
zbareaconfig.strID = Row["strID"].ToString();
zbareaconfig.UnitID = PageBase.static_ext_int(Row["UnitID"].ToString());
zbareaconfig.ApanageID = PageBase.static_ext_int(Row["ApanageID"].ToString());
zbareaconfig.TrackID = PageBase.static_ext_int(Row["TrackID"].ToString());
}
//功能:获得所有整备场手持机密码信息
public static List <ZbAreaConfig> getZbAreaConfigList(int unitid, int apanageid)
{
List <ZbAreaConfig> ZbAreaConfigList = new List <ZbAreaConfig>();
string strSql = "select * from TAB_ZbcAreaConfig where UnitID=@UnitID and ApanageID=@ApanageID";
SqlParameter[] sqlParams =
{
new SqlParameter("UnitID", unitid),
new SqlParameter("ApanageID", apanageid)
};
DataTable dtZbAreaConfig = SqlHelper.ExecuteDataset(searchmaster.GetSqlConnConfig("57"), CommandType.Text, strSql, sqlParams).Tables[0];
foreach (DataRow dr in dtZbAreaConfig.Rows)
{
ZbAreaConfig zbareaconfig = new ZbAreaConfig();
ZbAreaConfig.ReadCase(zbareaconfig, dr);
ZbAreaConfigList.Add(zbareaconfig);
}
return(ZbAreaConfigList);
}