public IList<AssociationEvent> GetAssociationEventListData() { StringBuilder sql = new StringBuilder(); AssociationEvent obj = new AssociationEvent(); sql = SqlBuilder.Query(obj); DataTable table = ConnectDBToGetData(sql); return DataTableToList<AssociationEvent>(table); }
public void CreateAssociationEvent_B(AssociationEvent obj) { StringBuilder sql = new StringBuilder(); sql = SqlBuilder.Insert(obj); List<SqlParameter> parameter = new List<SqlParameter>() { new SqlParameter() {ParameterName = "@AssociationEvent_Title", Value= obj.AssociationEvent_Title}, new SqlParameter() {ParameterName = "@AssociationEvent_Detail", Value = obj.AssociationEvent_Detail}, new SqlParameter() {ParameterName = "@AssociationEvent_Date", Value = obj.AssociationEvent_Date}, new SqlParameter() {ParameterName = "@AssociationEvent_Picture", Value = obj.AssociationEvent_Picture}, new SqlParameter() {ParameterName = "@AssociationEvent_Modifier", Value = obj.AssociationEvent_Modifier}, new SqlParameter() {ParameterName = "@AssociationEvent_Modificationdatetime", Value = obj.AssociationEvent_Modificationdatetime} }; ConnectDBToSendData(sql, parameter); }
public object UpdateAssociationEventdata_B(AssociationEvent objPara) { BAEModel.UpdateAssociationEvent_B(objPara); object objData = true; return objData; }