public IList<AssociationHistory> GetAssociationHistoryListData()
{
StringBuilder sql = new StringBuilder();
AssociationHistory obj= new AssociationHistory();
sql = SqlBuilder.Query(obj);
DataTable table = ConnectDBToGetData(sql);
return DataTableToList<AssociationHistory>(table);
}
public void DeleteAssociationHistory_B(AssociationHistory obj)
{
StringBuilder sql = new StringBuilder();
sql = SqlBuilder.Delete(obj);
List<SqlParameter> parameter = new List<SqlParameter>()
{
new SqlParameter() {ParameterName = "@AssociationHistory_ID", Value= obj.AssociationHistory_ID}
};
ConnectDBToSendData(sql, parameter);
}
public void CreateAssociationHistory_B(AssociationHistory obj)
{
StringBuilder sql = new StringBuilder();
sql = SqlBuilder.Insert(obj);
List<SqlParameter> parameter = new List<SqlParameter>()
{
new SqlParameter() {ParameterName = "@AssociationHistory_Detail", Value= obj.AssociationHistory_Detail},
new SqlParameter() {ParameterName = "@AssociationHistory_Modifier", Value = obj.AssociationHistory_Modifier},
new SqlParameter() {ParameterName = "@AssociationHistory_Modificationdatetime", Value = obj.AssociationHistory_Modificationdatetime}
};
ConnectDBToSendData(sql, parameter);
}
public object CreateAssociationHistorydata_B(AssociationHistory objPara)
{
BAHModel.CreateAssociationHistory_B(objPara);
object objData = true;
return objData;
}