private void btn_SelectData_Click(object sender, EventArgs e)
{
//---------点击查询前，先清理表格上的数据
grid.Reset();
SelectData();
progressBar1.Value = 0;
sqlstr = System.Configuration.ConfigurationManager.AppSettings["R_materialConnString"];
m.Catalog = DealData.RetSubstringBracket(txbList.Text);
SqlConnection sqlConn = new SqlConnection(sqlstr);
sqlConn.Open();
string selectStr = "select * from tb_Resource where Catalog = ('" + m.Catalog + "')";
SqlCommand sc = new SqlCommand(selectStr, sqlConn);
SqlDataReader reader = sc.ExecuteReader();
row = 0;
int k = 1;
dataload();
progressBar1.Value = 5;
while (reader.Read())
{
worksheet[row, 0] = false;
worksheet[row, 1] = k; //序号
worksheet[row, 2] = reader["Title"]; //显示名称2
worksheet[row, 4] = DealData.SelectString(resultRSORTList, Convert.ToInt32(reader["ResourceStyle"])); //资源类型10
worksheet[row, 5] = txbCe.Text.Split('_')[0] + "_" + txbCe.Text.Split('_')[1]; //教材名称
worksheet[row, 6] = txbList.Text; //教材目录
worksheet[row, 7] = reader["KeyWords"]; //关键字12
worksheet[row, 8] = reader["Description"]; //描述16
int copyright = Convert.ToInt32(reader["Copyright"]);
worksheet[row, 11] = banquanMirror[copyright];
worksheet[row, 12] = reader["ResourceClass"];
worksheet[row, 13] = reader["FileID"];
k++;
row++;
if (progressBar1.Value < 95)
{
progressBar1.Value += 5;
}
}
for (int i = 1; i < reader.FieldCount; i++)
{
worksheet.SetColumnsWidth(i, reader.FieldCount, 150);
//worksheet.AutoFitColumnWidth(i, true);
worksheet.HideColumns(13, 1);
}
progressBar1.Value = 100;
}
