public void DeleteExhibition_B(Exhibition obj) { StringBuilder sql = new StringBuilder(); sql = SqlBuilder.Delete(obj); List<SqlParameter> parameter = new List<SqlParameter>() { new SqlParameter() {ParameterName = "@Exhibition_ID", Value= obj.Exhibition_ID} }; ConnectDBToSendData(sql, parameter); }
public void CreateExhibition_B(Exhibition obj) { StringBuilder sql = new StringBuilder(); sql = SqlBuilder.Insert(obj); List<SqlParameter> parameter = new List<SqlParameter>() { new SqlParameter() {ParameterName = "@Exhibition_Detail", Value= obj.Exhibition_Detail}, new SqlParameter() {ParameterName = "@Exhibition_Enddatetime", Value = obj.Exhibition_Enddatetime}, new SqlParameter() {ParameterName = "@Exhibition_Otherpeople", Value = obj.Exhibition_Otherpeople}, new SqlParameter() {ParameterName = "@Exhibition_Picture", Value = obj.Exhibition_Picture}, new SqlParameter() {ParameterName = "@Exhibition_Place", Value = obj.Exhibition_Place}, new SqlParameter() {ParameterName = "@Exhibition_Startdatetime", Value = obj.Exhibition_Startdatetime}, new SqlParameter() {ParameterName = "@Exhibition_Title", Value = obj.Exhibition_Title} }; ConnectDBToSendData(sql, parameter); }
public object UpdateExhibitiondata_B(Exhibition objPara) { BEXModel.UpdateExhibition_B(objPara); object objData = true; return objData; }