public static int Insert(HocsinhInfo hocsinhInfo)
{
var dbConn = new SqlConnection(AppEnv.ConnectionString);
var dbCmd = new SqlCommand("Solart_Hocsinh_Insert", dbConn)
{
CommandType = CommandType.StoredProcedure
};
dbCmd.Parameters.AddWithValue("@Hocsinh_Name", hocsinhInfo.Hocsinh_Name);
dbCmd.Parameters.AddWithValue("@Hocsinh_Parent", hocsinhInfo.Hocsinh_Parent);
dbCmd.Parameters.AddWithValue("@Hocsinh_Email", hocsinhInfo.Hocsinh_Email);
dbCmd.Parameters.AddWithValue("@Hocsinh_Tel", hocsinhInfo.Hocsinh_Tel);
dbCmd.Parameters.AddWithValue("@Hocsinh_Address", hocsinhInfo.Hocsinh_Address);
dbCmd.Parameters.AddWithValue("@Hocsinh_Birthday", hocsinhInfo.Hocsinh_Birthday);
dbCmd.Parameters.AddWithValue("@Hocsinh_Note", hocsinhInfo.Hocsinh_Note);
dbCmd.Parameters.AddWithValue("@Hocsinh_CreateDate", hocsinhInfo.Hocsinh_CreateDate);
dbCmd.Parameters.AddWithValue("@Hocsinh_IsLearning", hocsinhInfo.Hocsinh_IsLearning);
dbCmd.Parameters.AddWithValue("@RETURN_VALUE", SqlDbType.Int).Direction = ParameterDirection.ReturnValue;
try
{
dbConn.Open();
dbCmd.ExecuteNonQuery();
return((int)dbCmd.Parameters["@RETURN_VALUE"].Value);
}
finally
{
dbConn.Close();
}
}
public static void Update(HocsinhInfo hocsinhInfo)
{
var dbConn = new SqlConnection(AppEnv.ConnectionString);
var dbCmd = new SqlCommand("Solart_Hocsinh_Update", dbConn)
{
CommandType = CommandType.StoredProcedure
};
dbCmd.Parameters.AddWithValue("@Hocsinh_ID", hocsinhInfo.Hocsinh_ID);
dbCmd.Parameters.AddWithValue("@Hocsinh_Name", hocsinhInfo.Hocsinh_Name);
dbCmd.Parameters.AddWithValue("@Hocsinh_Parent", hocsinhInfo.Hocsinh_Parent);
dbCmd.Parameters.AddWithValue("@Hocsinh_Email", hocsinhInfo.Hocsinh_Email);
dbCmd.Parameters.AddWithValue("@Hocsinh_Tel", hocsinhInfo.Hocsinh_Tel);
dbCmd.Parameters.AddWithValue("@Hocsinh_Address", hocsinhInfo.Hocsinh_Address);
dbCmd.Parameters.AddWithValue("@Hocsinh_Birthday", hocsinhInfo.Hocsinh_Birthday);
dbCmd.Parameters.AddWithValue("@Hocsinh_Note", hocsinhInfo.Hocsinh_Note);
dbCmd.Parameters.AddWithValue("@Hocsinh_CreateDate", hocsinhInfo.Hocsinh_CreateDate);
dbCmd.Parameters.AddWithValue("@Hocsinh_IsLearning", hocsinhInfo.Hocsinh_IsLearning);
try
{
dbConn.Open();
dbCmd.ExecuteNonQuery();
}
finally
{
dbConn.Close();
}
}
public static HocsinhInfo GetInfo(int hocsinh_ID)
{
HocsinhInfo retVal = null;
var dbConn = new SqlConnection(AppEnv.ConnectionString);
var dbCmd = new SqlCommand("Solart_Hocsinh_GetInfo", dbConn)
{
CommandType = CommandType.StoredProcedure
};
dbCmd.Parameters.AddWithValue("@Hocsinh_ID", hocsinh_ID);
try
{
dbConn.Open();
var dr = dbCmd.ExecuteReader();
if (dr.Read())
{
retVal = new HocsinhInfo();
retVal.Hocsinh_ID = ConvertUtility.ToInt32(dr["Hocsinh_ID"]);
retVal.Hocsinh_Name = ConvertUtility.ToString(dr["Hocsinh_Name"]);
retVal.Hocsinh_Parent = ConvertUtility.ToString(dr["Hocsinh_Parent"]);
retVal.Hocsinh_Email = ConvertUtility.ToString(dr["Hocsinh_Email"]);
retVal.Hocsinh_Tel = ConvertUtility.ToString(dr["Hocsinh_Tel"]);
retVal.Hocsinh_Address = ConvertUtility.ToString(dr["Hocsinh_Address"]);
retVal.Hocsinh_Birthday = ConvertUtility.ToString(dr["Hocsinh_Birthday"]);
retVal.Hocsinh_Note = ConvertUtility.ToString(dr["Hocsinh_Note"]);
retVal.Hocsinh_CreateDate = ConvertUtility.ToDateTime(dr["Hocsinh_CreateDate"]);
retVal.Hocsinh_IsLearning = ConvertUtility.ToBoolean(dr["Hocsinh_IsLearning"]);
}
if (dr != null)
{
dr.Close();
}
}
finally
{
dbConn.Close();
}
return(retVal);
}
private static HocsinhInfo CreateEntityFromReader(IDataReader reader)
{
var item = new HocsinhInfo();
try { if (!reader.IsDBNull(reader.GetOrdinal("Hocsinh_ID")))
{
item.Hocsinh_ID = ConvertUtility.ToInt32(reader["Hocsinh_ID"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("Hocsinh_Name")))
{
item.Hocsinh_Name = ConvertUtility.ToString(reader["Hocsinh_Name"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("Hocsinh_Parent")))
{
item.Hocsinh_Parent = ConvertUtility.ToString(reader["Hocsinh_Parent"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("Hocsinh_Email")))
{
item.Hocsinh_Email = ConvertUtility.ToString(reader["Hocsinh_Email"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("Hocsinh_Tel")))
{
item.Hocsinh_Tel = ConvertUtility.ToString(reader["Hocsinh_Tel"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("Hocsinh_Address")))
{
item.Hocsinh_Address = ConvertUtility.ToString(reader["Hocsinh_Address"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("Hocsinh_Birthday")))
{
item.Hocsinh_Birthday = ConvertUtility.ToString(reader["Hocsinh_Birthday"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("Hocsinh_Note")))
{
item.Hocsinh_Note = ConvertUtility.ToString(reader["Hocsinh_Note"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("Hocsinh_CreateDate")))
{
item.Hocsinh_CreateDate = ConvertUtility.ToDateTime(reader["Hocsinh_CreateDate"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("Hocsinh_IsLearning")))
{
item.Hocsinh_IsLearning = ConvertUtility.ToBoolean(reader["Hocsinh_IsLearning"]);
}
}
catch { }
return(item);
}