There are 3 class:
- CommonData class
- BussinessRule or System class
- DataAccess or DB class
Example of CommonData class:
public class GugusData
{
private string _kdggs;
public string Kdggs
{
get { return _kdggs; }
set { _kdggs = value; }
}
private string _nmggs;
public string Nmggs
{
get { return _nmggs; }
set { _nmggs = value; }
}
}
Example of System class:
public List< GugusData > GetGugus ( string kdggs )
{
return new DosenTutorialAccess().GetGugus(string kdggs);
}
Example of DataAccess class:
public List
{
List
GugusData itemGugus = new GugusData();
string spName = "spr_tutorial_load_gugus";
SqlParameter[] parameters = new SqlParameter[1];
parameters[0] = new SqlParameter("@kdggs", SqlDbType.Char, 2);
parameters[0].Direction = ParameterDirection.Input;
parameters[0].Value = kdggs;
using (SqlDataReader reader = SqlHelper.ExecuteReader(UserManagementConfiguration.TutorialConnectionString, CommandType.StoredProcedure, spName, parameters))
{
if (reader.HasRows)
{
while (reader.Read())
{
itemGugus = new GugusData();
itemGugus.Kdggs = reader["kdggs"].ToString().Trim();
itemGugus.Nmggs = reader["nmggs"].ToString().Trim() ;
listGugus.Add(itemGugus);
}
}
}
return listGugus;
}
Note: SqlHelper is a function using Microsoft.ApplicationBlocks.Data;
No comments:
Post a Comment