/// <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));
}
