public static KindergartenInfo GetKindergartenInfoByName(string name) { var Info = new KindergartenInfo(); var Sql = string.Empty; var dt = new DataTable(); try { Sql = string.Format(GetScriptServiceInstance().GetKindergartenListByName, BznsBase.BrandID, name); dt = MySqlHelper.GetDataSet(BznsBase.GetConnectionString, BznsBase.GetCommandType, Sql, null).Tables[0]; if (dt.Rows.Count > 0) { Info.Id = dt.Rows[0]["kindergarten_id"].ToString(); Info.Name = dt.Rows[0]["kindergarten_nm"].ToString(); } } catch (Exception) { throw; } finally { dt = null; } return(Info); }
public static KindergartenInfo GetKindergartenInfo() { var Info = new KindergartenInfo(); var Kindergarten = new DataTable(); string Sql = string.Empty; try { Sql = string.Format(InitObject.GetScriptServiceInstance().GetKindergartenListById, BznsBase.KindergartenId); Kindergarten = MySqlHelper.GetDataSet(BznsBase.GetConnectionString, BznsBase.GetCommandType, Sql, null).Tables[0]; if (Kindergarten.Rows.Count > 0) { DataRow dr = Kindergarten.Rows[0]; Info.Id = dr["kindergarten_id"].ToString(); Info.Code = dr["kindergarten_number"].ToString(); Info.Name = dr["kindergarten_nm"].ToString(); } } catch (Exception) { throw; } finally { Kindergarten = null; } return(Info); }