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