/// <summary> /// 增加一条数据 /// </summary> public bool AddReportDetail(ReportDetailModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("INSERT INTO ARCHIVE_REPORT_DETAIL("); strSql.Append("ReportID,ReportName,ExportType,ColumnName,ColumnValue,Seq,Col1,Col2,Col3)"); strSql.Append(" VALUES ("); strSql.Append("@ReportID,@ReportName,@ExportType,@ColumnName,@ColumnValue,@Seq,@Col1,@Col2,@Col3)"); MySqlParameter[] parameters = { new MySqlParameter("@ReportID", MySqlDbType.Int32, 11), new MySqlParameter("@ReportName", MySqlDbType.VarChar, 50), new MySqlParameter("@ExportType", MySqlDbType.VarChar, 1), new MySqlParameter("@ColumnName", MySqlDbType.VarChar, 50), new MySqlParameter("@ColumnValue", MySqlDbType.VarChar, 500), new MySqlParameter("@Seq", MySqlDbType.Int32, 11), new MySqlParameter("@Col1", MySqlDbType.VarChar, 255), new MySqlParameter("@Col2", MySqlDbType.VarChar, 255), new MySqlParameter("@Col3", MySqlDbType.VarChar, 255) }; parameters[0].Value = model.ReportID; parameters[1].Value = model.ReportName; parameters[2].Value = model.ExportType; parameters[3].Value = model.ColumnName; parameters[4].Value = model.ColumnValue; parameters[5].Value = model.Seq; parameters[6].Value = model.Col1; parameters[7].Value = model.Col2; parameters[8].Value = model.Col3; return(MySQLHelper.ExecuteSql(strSql.ToString(), parameters) > 0 ? true : false); }
/// <summary> /// 添加报表明细 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool AddReportDetail(ReportDetailModel model) { return(dal.AddReportDetail(model)); }