private void btnUpdate_Click(object sender, EventArgs e) //更新此项成果
{
if (MyDatabase.TestMyDatabaseConnect() == false) //数据库连接失败
{
MessageBox.Show("数据库连接失败！", "提示");
return;
}
frmAchievementUpdate achievement_update = new frmAchievementUpdate(txt_achievement_name); //实例化成果更新窗体
achievement_update.ShowDialog(); //成果更新窗体以模式对话框的方式打开
#region 更新DataGridView控件内的内容
try
{
DataTable dt = MyDatabase.GetDataSetBySql(sql_backup);
if (dt == null) //数据库连接失败
{
btnDelete.Enabled = false; //删除此项成果按钮不可点击
btnUpdate.Enabled = false; //更新此项成果按钮不可点击
btnOutToFile.Text = "导出此检索成果到文件"; //导出此检索成果到文件按钮显示内容
btnOutToFile.Enabled = false; //导出此检索成果到文件按钮不可点击
txt_achievement_name = string.Empty; //记录数据库内主键的值为空
sql_backup = string.Empty;
this.dgvData.DataSource = null; //DataGridView控件显示数据
MessageBox.Show("数据库连接失败！", "提示");
return;
}
if (dt.Rows.Count == 0) //未检索到符合要求的成果信息
{
btnDelete.Enabled = false; //删除此项成果按钮不可点击
btnUpdate.Enabled = false; //更新此项成果按钮不可点击
btnOutToFile.Text = "导出此检索成果到文件"; //导出此检索成果到文件按钮显示内容
btnOutToFile.Enabled = false; //导出此检索成果到文件按钮不可点击
txt_achievement_name = string.Empty; //记录数据库内主键的值为空
sql_backup = string.Empty;
this.dgvData.DataSource = null; //DataGridView控件显示数据
return;
}
btnDelete.Enabled = true; //删除此项成果按钮可点击
btnUpdate.Enabled = true; //更新此项成果按钮可点击
btnOutToFile.Text = "导出此检索成果到文件"; //导出此检索成果到文件按钮显示内容
btnOutToFile.Enabled = true; //导出此检索成果到文件按钮可点击
this.dgvData.DataSource = null; //先置为null，否则在右键删除DataGridView后再次检索后显示的字段顺序会有误
this.dgvData.DataSource = dt; //DataGridView控件显示数据
this.txt_achievement_name = this.dgvData.Rows[0].Cells[0].Value.ToString().Trim();
return;
}
catch (Exception ex)
{
btnDelete.Enabled = false; //删除此项成果按钮不可点击
btnUpdate.Enabled = false; //更新此项成果按钮不可点击
btnOutToFile.Text = "导出此检索成果到文件"; //导出此检索成果到文件按钮显示内容
btnOutToFile.Enabled = false; //导出此检索成果到文件按钮不可点击
txt_achievement_name = string.Empty; //记录数据库内主键的值为空
sql_backup = string.Empty;
this.dgvData.DataSource = null; //DataGridView控件显示数据
return;
}
#endregion
}
private void btnUpdate_Click(object sender, EventArgs e) //更新
{
if (MyDatabase.TestMyDatabaseConnect() == false) //数据库连接失败
{
MessageBox.Show("数据库连接失败！", "提示");
return;
}
if (this.txtAchievementName.Text.ToString().Trim() == string.Empty || this.txtAchievementType.Text.ToString().Trim() == string.Empty || this.dtpAchievementDate.Text.ToString().Trim() == string.Empty || this.txtAchievementAuthor.Text.ToString().Trim() == string.Empty || this.txtAchievementCompany.Text.ToString().Trim() == string.Empty || this.txtAchievementMoney.Text.ToString().Trim() == string.Empty)//是否所有数据均未改动检测
{
MessageBox.Show("信息输入不完整，请重新检查之后再重试！", "提示");
return;
}
try//对成果时间和成果支撑基金的数据格式进行检测(如数据有误会throw异常，程序进入catch捕捉代码中)
{
Convert.ToDateTime(this.dtpAchievementDate.Text.ToString().Trim());
Convert.ToDouble(this.txtAchievementMoney.Text.ToString().Trim());
}
catch (Exception ex)
{
MessageBox.Show("信息输入格式有误，请重新检查之后再重试！", "提示");
//throw new Exception(ex.Message);
return;
}
//所有数据的合法性均检测完毕
string sql_1 = string.Format("update datainfo set AchievementName='{0}', AchievementType='{1}', AchievementDate='{2}', AchievementAuthor='{3}', AchievementCompany='{4}', AchievementMoney={5} where AchievementName='{6}';", this.txtAchievementName.Text.ToString().Trim(), this.txtAchievementType.Text.ToString().Trim(), Convert.ToDateTime(this.dtpAchievementDate.Text.ToString().Trim()), this.txtAchievementAuthor.Text.ToString().Trim(), this.txtAchievementCompany.Text.ToString().Trim(), Convert.ToDouble(this.txtAchievementMoney.Text.ToString().Trim()), txt_achievement_name); //sql语句
if (MyDatabase.UpdateDataBySql(sql_1)) //更新成功
{
//更新DataGridView控件内的内容
txt_achievement_name = this.txtAchievementName.Text.ToString().Trim();
string sql_2 = string.Format("select datainfo.AchievementName as '成果名称', datainfo.AchievementType as '成果类型', datainfo.AchievementDate as '时间', datainfo.AchievementAuthor as '作者', datainfo.AchievementCompany as '单位', datainfo.AchievementMoney as '支撑基金' from datainfo where AchievementName='{0}';", txt_achievement_name);
DataSet ds = MyDatabase.GetDataSetBySql(sql_2);
if (ds == null)//数据库连接失败
{
MessageBox.Show("数据库连接失败！", "提示");
return;
}
this.dgvData.AutoGenerateColumns = true; //自动
this.dgvData.DataSource = ds.Tables[0]; //DataGridView控件显示数据
this.dgvData.Columns[0].ReadOnly = true; //设为只读
this.dgvData.Columns[1].ReadOnly = true; //设为只读
this.dgvData.Columns[2].ReadOnly = true; //设为只读
this.dgvData.Columns[3].ReadOnly = true; //设为只读
this.dgvData.Columns[4].ReadOnly = true; //设为只读
this.dgvData.Columns[5].ReadOnly = true; //设为只读
MessageBox.Show("更新成功！", "提示");
}
else//更新失败
{
MessageBox.Show("更新失败！", "提示");
}
}
private string txt_achievement_name = string.Empty; //存储数据库内的主键的值，用于更新记录和删除记录
private void frmAchievementUpdate_Load(object sender, EventArgs e) //窗体载入时初始化
{
btnOutToExcel.Enabled = true; //导出此项结果到Excel按钮可点击
btnOutToExcel.Text = "导出此项结果到Excel"; //导出此项结果到Excel按钮显示内容
if (MyDatabase.TestMyDatabaseConnect() == false) //数据库连接失败
{
btnOutToExcel.Enabled = false; //导出此项结果到Excel按钮不可点击
MessageBox.Show("数据库连接失败！", "提示");
return;
}
try
{
string sql = string.Format("select datainfo.AchievementName as '成果名称', datainfo.AchievementType as '成果类型', datainfo.AchievementDate as '时间', datainfo.AchievementAuthor as '作者', datainfo.AchievementCompany as '单位', datainfo.AchievementMoney as '支撑基金' from datainfo where AchievementName='{0}';", txt_achievement_name);
DataSet ds = MyDatabase.GetDataSetBySql(sql);
if (ds == null) //数据库连接失败
{
btnOutToExcel.Enabled = false; //导出此项结果到Excel按钮不可点击
btnOutToExcel.Text = "导出此项结果到Excel"; //导出此项结果到Excel按钮显示内容
this.dgvData.DataSource = null; //DataGridView控件显示数据
MessageBox.Show("数据库连接失败！", "提示");
return;
}
this.dgvData.AutoGenerateColumns = true; //自动
this.dgvData.DataSource = ds.Tables[0]; //DataGridView控件显示数据
this.dgvData.Columns[0].ReadOnly = true; //设为只读
this.dgvData.Columns[1].ReadOnly = true; //设为只读
this.dgvData.Columns[2].ReadOnly = true; //设为只读
this.dgvData.Columns[3].ReadOnly = true; //设为只读
this.dgvData.Columns[4].ReadOnly = true; //设为只读
this.dgvData.Columns[5].ReadOnly = true; //设为只读
txtAchievementName.Text = txt_achievement_name;
txtAchievementType.Text = this.dgvData.Rows[0].Cells[1].Value.ToString().Trim();
dtpAchievementDate.Text = this.dgvData.Rows[0].Cells[2].Value.ToString().Trim();
txtAchievementAuthor.Text = this.dgvData.Rows[0].Cells[3].Value.ToString().Trim();
txtAchievementCompany.Text = this.dgvData.Rows[0].Cells[4].Value.ToString().Trim();
txtAchievementMoney.Text = this.dgvData.Rows[0].Cells[5].Value.ToString().Trim();
return;
}
catch (Exception ex)
{
btnOutToExcel.Enabled = false; //导出此项结果到Excel按钮不可点击
btnOutToExcel.Text = "导出此项结果到Excel"; //导出此项结果到Excel按钮显示内容
this.dgvData.DataSource = null; //DataGridView控件显示数据
MessageBox.Show("更新界面初始化！", "提示");
return;
}
}
private string txt_achievement_name = string.Empty; //存储数据库内的主键的值，用于删除记录
private void frmAchievementAddByWrite_Load(object sender, EventArgs e) //窗体载入时初始化
{
txt_achievement_name = string.Empty;
txtAchievementType.Visible = false; //成果类型编辑框不可见
btnDelete.Enabled = false; //删除此项成果按钮不可点击
btnOutToFile.Text = "导出此项成果到文件"; //导出此项成果到文件按钮显示内容
btnOutToFile.Enabled = false; //导出此项成果到文件按钮不可点击
this.dgvData.DataSource = null; //DataGridView控件显示数据
this.dgvData.AllowUserToAddRows = false; //不允许用户添加新行
#region 成果类型组合框初始化
if (MyDatabase.TestMyDatabaseConnect() == false)//数据库连接失败
{
MessageBox.Show("数据库连接失败！", "提示");
return;
}
try
{
DataTable dt = MyDatabase.GetDataSetBySql("select distinct AchievementType from datainfo;");
if (dt == null)//数据库连接失败
{
MessageBox.Show("数据库连接失败！", "提示");
return;
}
for (int i = 0; i < dt.Rows.Count; i++)
{
this.cboAchievementType.Items.Add(dt.Rows[i][0].ToString().Trim());
}
this.cboAchievementType.Items.Add("(其他)");
this.cboAchievementType.SelectedIndex = 0;
//防止数据库中没有任何成果类型而使得成果类型中只有"(其他)"而使得永远无法触发cboAchievementType_SelectedIndexChanged函数使得成果类型编辑框永远不可见，所以加入以下判断代码在初始化代码中
if (string.Compare(this.cboAchievementType.SelectedItem.ToString(), "(其他)") == 0)
{
txtAchievementType.Visible = true;//成果类型编辑框可见
}
else
{
txtAchievementType.Visible = false;//成果类型编辑框不可见
}
}
catch (Exception ex)//数据库可能连接不上，MyDatabase.GetDataSetBySql函数会出错，返回的DataSet值为null，导致下面引用DataSet具体值时会抛出异常(后经改进在DataSet具体值使用之前加入了值是否为null的判断，后又经过改进在每次事件处理前均加入了检测能否成功连接的函数)
{
MessageBox.Show(ex.Message);
}
#endregion
}
private string txt_achievement_type = string.Empty; //存储数据库内的成果类型的值，用于更新记录和删除记录之后的更新DataGridView控件内的数据
private void frmAchievementSearchEasy_Load(object sender, EventArgs e) //窗体载入时初始化
{
txt_achievement_name = string.Empty;
txt_achievement_type = string.Empty;
btnUpdate.Enabled = false; //更新此项成果按钮不可点击
btnDelete.Enabled = false; //删除此项成果按钮不可点击
btnOutToFile.Text = "导出此检索结果到文件"; //导出此检索结果到文件按钮显示内容
btnOutToFile.Enabled = false; //导出此检索结果到文件按钮不可点击
dgvData.DataSource = null; //DataGridView控件显示数据
this.dgvData.AllowUserToAddRows = false; //不允许用户添加新行
#region 成果类型组合框初始化
if (MyDatabase.TestMyDatabaseConnect() == false)//数据库连接失败
{
MessageBox.Show("数据库连接失败！", "提示");
return;
}
try
{
DataTable dt = MyDatabase.GetDataSetBySql("select distinct AchievementType from datainfo;");
if (dt == null)//数据库连接失败
{
MessageBox.Show("数据库连接失败！", "提示");
return;
}
for (int i = 0; i < dt.Rows.Count; i++)
{
this.cboAchievementType.Items.Add(dt.Rows[i][0].ToString().Trim());
}
try//检测数据库中是否没有任何成果类型
{
this.cboAchievementType.SelectedIndex = 0;
}
catch (Exception ex)
{
MessageBox.Show("无任何成果类型，无法检索！", "提示");
return;
}
}
catch (Exception ex)//数据库可能连接不上，MyDatabase.GetDataSetBySql函数会出错，返回的DataSet值为null，导致下面引用DataSet具体值时会抛出异常(后经改进在DataSet具体值使用之前加入了值是否为null的判断，后又经过改进在每次事件处理前均加入了检测能否成功连接的函数)
{
MessageBox.Show(ex.Message);
}
#endregion
}
private string txt_achievement_name = string.Empty; //存储数据库内的主键的值，用于更新记录和删除记录
private void frmAchievementUpdate_Load(object sender, EventArgs e) //窗体载入时初始化
{
btnOutToFile.Enabled = true; //导出此项结果到文件按钮可点击
btnOutToFile.Text = "导出此项结果到文件"; //导出此项结果到文件按钮显示内容
this.dgvData.AllowUserToAddRows = false; //不允许用户添加新行
if (MyDatabase.TestMyDatabaseConnect() == false) //数据库连接失败
{
btnOutToFile.Enabled = false; //导出此项结果到文件按钮不可点击
MessageBox.Show("数据库连接失败！", "提示");
return;
}
try
{
string sql = string.Format("select datainfo.AchievementName as '成果名称', datainfo.AchievementType as '成果类型', datainfo.AchievementDate as '时间', datainfo.AchievementAuthor as '作者', datainfo.AchievementCompany as '单位', datainfo.AchievementMoney as '支撑基金' from datainfo where AchievementName='{0}';", txt_achievement_name);
DataTable dt = MyDatabase.GetDataSetBySql(sql);
if (dt == null) //数据库连接失败
{
btnOutToFile.Enabled = false; //导出此项结果到文件按钮不可点击
btnOutToFile.Text = "导出此项结果到文件"; //导出此项结果到文件按钮显示内容
this.dgvData.DataSource = null; //DataGridView控件显示数据
MessageBox.Show("数据库连接失败！", "提示");
return;
}
this.dgvData.DataSource = null; //先置为null，否则在右键删除DataGridView后再次检索后显示的字段顺序会有误
this.dgvData.DataSource = dt; //DataGridView控件显示数据
txtAchievementName.Text = txt_achievement_name;
txtAchievementType.Text = MyDatabase.CharFilter(this.dgvData.Rows[0].Cells[1].Value.ToString().Trim());
dtpAchievementDate.Text = this.dgvData.Rows[0].Cells[2].Value.ToString().Trim();
txtAchievementAuthor.Text = MyDatabase.CharFilter(this.dgvData.Rows[0].Cells[3].Value.ToString().Trim());
txtAchievementCompany.Text = MyDatabase.CharFilter(this.dgvData.Rows[0].Cells[4].Value.ToString().Trim());
txtAchievementMoney.Text = MyDatabase.CharFilter(this.dgvData.Rows[0].Cells[5].Value.ToString().Trim());
return;
}
catch (Exception ex)
{
btnOutToFile.Enabled = false; //导出此项结果到文件按钮不可点击
btnOutToFile.Text = "导出此项结果到文件"; //导出此项结果到文件按钮显示内容
this.dgvData.DataSource = null; //DataGridView控件显示数据
MessageBox.Show("更新界面初始化失败！", "提示");
return;
}
}
private void btnUpdate_Click(object sender, EventArgs e) //更新机械图信息
{
if (MyDatabase.TestMyDatabaseConnect() == false) //数据库连接失败
{
MessageBox.Show("数据库连接失败！", "提示");
return;
}
try
{
if (txtSaveDirectory.Text == string.Empty) //判断成果保存目录是否为空
{
txtSaveDirectory.Text = "(Null)"; //成果保存目录如果为空，则置其值为(Null)(数据库中默认值)
}
string sql_1 = string.Format("update mechanicaldrawing set mechanicaldrawing.AchievementName='{0}', mechanicaldrawing.Software='{1}', mechanicaldrawing.SaveDirectory='{2}', mechanicaldrawing.PartNum={3}, mechanicaldrawing.AssemblyNum={4}, mechanicaldrawing.DrawingNum={5} where mechanicaldrawing.AchievementName='{6}';", MyDatabase.CharFilter(this.txtAchievementName.Text.ToString().Trim()), MyDatabase.CharFilter(this.cboSoftware.Text.ToString().Trim()), MyDatabase.CharFilter(this.txtSaveDirectory.Text.ToString().Trim()), Convert.ToInt32(MyDatabase.CharFilter(this.txtPartNum.Text.ToString().Trim())), Convert.ToInt32(MyDatabase.CharFilter(this.txtAssemblyNum.Text.ToString().Trim())), Convert.ToInt32(MyDatabase.CharFilter(this.txtDrawingNum.Text.ToString().Trim())), MyDatabase.CharFilter(this.txtAchievementName.Text.ToString().Trim())); //sql语句
if (MyDatabase.UpdateDataBySql(sql_1)) //更新成功
{
//更新DataGridView控件内的内容
string sql_2 = "select datainfo.AchievementName as '成果名称', datainfo.AchievementType as '成果类型', datainfo.AchievementDate as '时间', datainfo.AchievementAuthor as '作者', datainfo.AchievementCompany as '单位', datainfo.AchievementMoney as '支撑基金', mechanicaldrawing.Software as '所用软件', mechanicaldrawing.SaveDirectory as '成果保存目录', mechanicaldrawing.PartNum as '零件图个数', mechanicaldrawing.AssemblyNum as '装配图个数', mechanicaldrawing.DrawingNum as '工程图纸个数' from datainfo join mechanicaldrawing on datainfo.AchievementName=mechanicaldrawing.AchievementName;";
DataTable dt_2 = MyDatabase.GetDataSetBySql(sql_2);
this.dgvData.DataSource = dt_2; //机械图信息显示DataGridView控件显示数据
btnUpdate.Enabled = true; //更新机械图信息按钮可点击
btnOutToFile.Text = "导出此视图内容到文件"; //设置导出此视图内容到文件按钮显示内容
btnOutToFile.Enabled = true; //设置导出此视图内容到文件按钮可点击
MessageBox.Show("更新成功！", "提示");
return;
}
else//更新失败
{
MessageBox.Show("更新失败！", "提示");
return;
}
}
catch (Exception ex)
{
MessageBox.Show("更新失败！", "提示");
return;
}
}
private void btnAdd_Click(object sender, EventArgs e) //录入此项成果
{
if (MyDatabase.TestMyDatabaseConnect() == false) //数据库连接失败
{
MessageBox.Show("数据库连接失败！", "提示");
return;
}
if (this.txtAchievementName.Text.ToString().Trim() == string.Empty || this.dtpAchievementDate.Text.ToString().Trim() == string.Empty || this.txtAchievementAuthor.Text.ToString().Trim() == string.Empty || this.txtAchievementCompany.Text.ToString().Trim() == string.Empty || this.txtAchievementMoney.Text.ToString().Trim() == string.Empty)//数据是否为空检测
{
MessageBox.Show("信息输入不完整，请重新检查之后再重试！", "提示");
return;
}
if (string.Compare(this.cboAchievementType.SelectedItem.ToString(), "(其他)") == 0)//对成果类型数据是否为空进行单独判断
{
if (this.txtAchievementType.Text.ToString().Trim() == string.Empty)
{
MessageBox.Show("信息输入不完整，请重新检查之后再重试！", "提示");
return;
}
}
try //对成果时间和成果支撑基金的数据格式进行检测(如数据有误会throw异常，程序进入catch捕捉代码中)
{
Convert.ToDateTime(this.dtpAchievementDate.Text.ToString().Trim()).ToString("yyyy-MM-dd"); //最后加入ToString("yyyy-MM-dd")是为了去除时间只留下日期
Convert.ToDouble(this.txtAchievementMoney.Text.ToString().Trim());
}
catch (Exception ex)
{
MessageBox.Show("信息输入格式有误，请重新检查之后再重试！", "提示");
//throw new Exception(ex.Message);
return;
}
//所有数据的合法性均检测完毕
string sql_1 = string.Empty;
if (string.Compare(this.cboAchievementType.SelectedItem.ToString(), "(其他)") == 0) //对成果类型数据进行判断
{
sql_1 = string.Format("insert into datainfo values('{0}', '{1}', '{2}', '{3}', '{4}', {5});", this.txtAchievementName.Text.ToString().Trim(), this.txtAchievementType.Text.ToString().Trim(), Convert.ToDateTime(this.dtpAchievementDate.Text.ToString().Trim()).ToString("yyyy-MM-dd"), this.txtAchievementAuthor.Text.ToString().Trim(), this.txtAchievementCompany.Text.ToString().Trim(), Convert.ToDouble(this.txtAchievementMoney.Text.ToString().Trim())); //sql语句
}
else
{
sql_1 = string.Format("insert into datainfo values('{0}', '{1}', '{2}', '{3}', '{4}', {5});", this.txtAchievementName.Text.ToString().Trim(), this.cboAchievementType.SelectedItem.ToString().Trim(), Convert.ToDateTime(this.dtpAchievementDate.Text.ToString().Trim()).ToString("yyyy-MM-dd"), this.txtAchievementAuthor.Text.ToString().Trim(), this.txtAchievementCompany.Text.ToString().Trim(), Convert.ToDouble(this.txtAchievementMoney.Text.ToString().Trim())); //sql语句
}
if (MyDatabase.UpdateDataBySql(sql_1)) //添加成功
{
btnDelete.Enabled = true; //删除此项成果按钮可点击
btnOutToFile.Text = "导出此项成果到文件"; //导出此项成果到文件按钮显示内容
btnOutToFile.Enabled = true; //导出此项成果到文件按钮可点击
txt_achievement_name = this.txtAchievementName.Text.ToString().Trim(); //记录数据库内主键的值
string sql_2 = string.Format("select datainfo.AchievementName as '成果名称', datainfo.AchievementType as '成果类型', datainfo.AchievementDate as '时间', datainfo.AchievementAuthor as '作者', datainfo.AchievementCompany as '单位', datainfo.AchievementMoney as '支撑基金' from datainfo where AchievementName='{0}';", this.txtAchievementName.Text.ToString().Trim());
DataSet ds = MyDatabase.GetDataSetBySql(sql_2);
if (ds == null) //数据库连接失败
{
btnDelete.Enabled = false; //删除此项成果按钮不可点击
btnOutToFile.Text = "导出此项成果到文件"; //导出此项成果到文件按钮显示内容
btnOutToFile.Enabled = false; //导出此项成果到文件按钮不可点击
txt_achievement_name = string.Empty; //记录数据库内主键的值为空
this.dgvData.DataSource = null; //DataGridView控件显示数据
MessageBox.Show("数据库连接失败！", "提示");
return;
}
this.dgvData.AutoGenerateColumns = true; //自动
this.dgvData.DataSource = ds.Tables[0]; //DataGridView控件显示数据
this.dgvData.Columns[0].ReadOnly = true; //设为只读
this.dgvData.Columns[1].ReadOnly = true; //设为只读
this.dgvData.Columns[2].ReadOnly = true; //设为只读
this.dgvData.Columns[3].ReadOnly = true; //设为只读
this.dgvData.Columns[4].ReadOnly = true; //设为只读
this.dgvData.Columns[5].ReadOnly = true; //设为只读
MessageBox.Show("添加成功！", "提示");
}
else//添加失败
{
btnDelete.Enabled = false;//删除此项成果按钮不可点击
btnOutToFile.Text = "导出此项成果到文件"; //导出此项成果到文件按钮显示内容
btnOutToFile.Enabled = false; //导出此项成果到文件按钮不可点击
txt_achievement_name = string.Empty; //记录数据库内主键的值为空
this.dgvData.DataSource = null; //DataGridView控件显示数据
MessageBox.Show("添加失败！", "提示");
}
}
private void btnSearch_Click(object sender, EventArgs e) //检索
{
if (MyDatabase.TestMyDatabaseConnect() == false) //数据库连接失败
{
MessageBox.Show("数据库连接失败！", "提示");
return;
}
if (cbAchievementMoney.Checked == false) //支撑基金不限制未选中
{
if (txtAchievementMoney.Text.ToString().Trim() == string.Empty) //支撑基金为空
{
MessageBox.Show("如果检索不打算限制支撑基金，请将支撑基金后面的不限制选中，否则请输入支撑基金，支撑基金不能为空！", "提示");
return;
}
try//对支撑基金数据格式进行校检
{
Convert.ToDouble(this.txtAchievementMoney.Text.ToString().Trim());
}
catch (Exception ex)
{
MessageBox.Show("支撑基金信息输入格式有误，请重新检查之后再重试！", "提示");
//MessageBox.Show(ex.Message);
//throw new Exception(ex.Message);
return;
}
}
if (cbAchievementDate.Checked == false) //成果时间不限制未选中
{
try //对成果时间数据格式进行校检
{
Convert.ToDateTime(this.dtpAchievementDate.Text.ToString().Trim()).ToString("yyyy-MM-dd"); //最后加入ToString("yyyy-MM-dd")是为了去除时间只留下日期
}
catch (Exception ex)
{
MessageBox.Show("时间信息输入格式有误，请重新检查之后再重试！", "提示");
//MessageBox.Show(ex.Message);
//throw new Exception(ex.Message);
return;
}
}
string sql_result = string.Empty; //最终搜索的sql语句
string sql_temp = string.Empty; //生成最终搜索sql语句过程中的临时sql语句字符串变量
sql_result = "select datainfo.AchievementName as '成果名称', datainfo.AchievementType as '成果类型', datainfo.AchievementDate as '时间', datainfo.AchievementAuthor as '作者', datainfo.AchievementCompany as '单位', datainfo.AchievementMoney as '支撑基金' from datainfo where";
sql_temp = string.Format(" AchievementName like '%{0}%' ", this.txtAchievementName.Text.ToString().Trim());
sql_result = sql_result + sql_temp + this.cboLogic.SelectedItem.ToString().Trim();
sql_temp = string.Format(" AchievementType like '%{0}%' ", this.txtAchievementType.Text.ToString().Trim());
sql_result = sql_result + sql_temp + this.cboLogic.SelectedItem.ToString().Trim();
if (cbAchievementDate.Checked == false)//成果时间不限制未选中
{
sql_temp = string.Format(" AchievementDate like '%{0}%' ", Convert.ToDateTime(this.dtpAchievementDate.Text.ToString().Trim()).ToString("yyyy-MM-dd"));
sql_result = sql_result + sql_temp + this.cboLogic.SelectedItem.ToString().Trim();
}
sql_temp = string.Format(" AchievementAuthor like '%{0}%' ", this.txtAchievementAuthor.Text.ToString().Trim());
sql_result = sql_result + sql_temp + this.cboLogic.SelectedItem.ToString().Trim();
sql_temp = string.Format(" AchievementCompany like '%{0}%'", this.txtAchievementCompany.Text.ToString().Trim());
sql_result = sql_result + sql_temp;
if (cbAchievementMoney.Checked == false)//支撑基金不限制未选中
{
sql_result = sql_result + " " + this.cboLogic.SelectedItem.ToString().Trim();
sql_temp = string.Format(" (AchievementMoney between {0} and {1})", Convert.ToDouble(this.txtAchievementMoney.Text.ToString().Trim()) - 0.01, Convert.ToDouble(this.txtAchievementMoney.Text.ToString().Trim()) + 0.01);
sql_result = sql_result + sql_temp;
}
sql_result = sql_result + ";";
try
{
DataSet ds = MyDatabase.GetDataSetBySql(sql_result);
if (ds == null) //数据库连接失败
{
btnDelete.Enabled = false; //删除此项成果按钮不可点击
btnUpdate.Enabled = false; //更新此项成果按钮不可点击
btnOutToExcel.Text = "导出此检索成果到Excel"; //导出此检索成果到Excel按钮显示内容
btnOutToExcel.Enabled = false; //导出此检索成果到Excel按钮不可点击
txt_achievement_name = string.Empty; //记录数据库内主键的值为空
sql_backup = string.Empty;
this.dgvData.DataSource = null; //DataGridView控件显示数据
MessageBox.Show("数据库连接失败！", "提示");
return;
}
if (ds.Tables[0].Rows.Count == 0) //未检索到符合要求的成果信息
{
btnDelete.Enabled = false; //删除此项成果按钮不可点击
btnUpdate.Enabled = false; //更新此项成果按钮不可点击
btnOutToExcel.Text = "导出此检索成果到Excel"; //导出此检索成果到Excel按钮显示内容
btnOutToExcel.Enabled = false; //导出此检索成果到Excel按钮不可点击
txt_achievement_name = string.Empty; //记录数据库内主键的值为空
sql_backup = string.Empty;
this.dgvData.DataSource = null; //DataGridView控件显示数据
MessageBox.Show("未检索到符合要求的成果信息！", "提示");
return;
}
btnDelete.Enabled = true; //删除此项成果按钮可点击
btnUpdate.Enabled = true; //更新此项成果按钮可点击
btnOutToExcel.Text = "导出此检索成果到Excel"; //导出此检索成果到Excel按钮显示内容
btnOutToExcel.Enabled = true; //导出此检索成果到Excel按钮可点击
this.dgvData.AutoGenerateColumns = true; //自动
this.dgvData.DataSource = ds.Tables[0]; //DataGridView控件显示数据
this.dgvData.Columns[0].ReadOnly = true; //设为只读
this.dgvData.Columns[1].ReadOnly = true; //设为只读
this.dgvData.Columns[2].ReadOnly = true; //设为只读
this.dgvData.Columns[3].ReadOnly = true; //设为只读
this.dgvData.Columns[4].ReadOnly = true; //设为只读
this.dgvData.Columns[5].ReadOnly = true; //设为只读
this.txt_achievement_name = this.dgvData.Rows[0].Cells[0].Value.ToString().Trim();
sql_backup = sql_result;
MessageBox.Show("检索成功！", "提示");
return;
}
catch (Exception ex)
{
btnDelete.Enabled = false; //删除此项成果按钮不可点击
btnUpdate.Enabled = false; //更新此项成果按钮不可点击
btnOutToExcel.Text = "导出此检索成果到Excel"; //导出此检索成果到Excel按钮显示内容
btnOutToExcel.Enabled = false; //导出此检索成果到Excel按钮不可点击
txt_achievement_name = string.Empty; //记录数据库内主键的值为空
sql_backup = string.Empty;
this.dgvData.DataSource = null; //DataGridView控件显示数据
MessageBox.Show("检索失败！", "提示");
return;
}
}
private void btnDelete_Click(object sender, EventArgs e) //删除此项成果
{
if (MyDatabase.TestMyDatabaseConnect() == false) //数据库连接失败
{
MessageBox.Show("数据库连接失败！", "提示");
return;
}
DialogResult result = MessageBox.Show("是否确定删除此项成果？", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
if (result == DialogResult.OK)//确定
{
if (txt_achievement_name != string.Empty)
{
string sql_1 = string.Format("delete from datainfo where datainfo.AchievementName='{0}';", txt_achievement_name); //sql语句
if (MyDatabase.UpdateDataBySql(sql_1)) //删除成功
{
#region 更新DataGridView控件内的内容
try
{
DataSet ds = MyDatabase.GetDataSetBySql(sql_backup);
if (ds == null) //数据库连接失败
{
btnDelete.Enabled = false; //删除此项成果按钮不可点击
btnUpdate.Enabled = false; //更新此项成果按钮不可点击
btnOutToExcel.Text = "导出此检索成果到Excel"; //导出此检索成果到Excel按钮显示内容
btnOutToExcel.Enabled = false; //导出此检索成果到Excel按钮不可点击
txt_achievement_name = string.Empty; //记录数据库内主键的值为空
sql_backup = string.Empty;
this.dgvData.DataSource = null; //DataGridView控件显示数据
MessageBox.Show("数据库连接失败！", "提示");
return;
}
if (ds.Tables[0].Rows.Count == 0) //未检索到符合要求的成果信息
{
btnDelete.Enabled = false; //删除此项成果按钮不可点击
btnUpdate.Enabled = false; //更新此项成果按钮不可点击
btnOutToExcel.Text = "导出此检索成果到Excel"; //导出此检索成果到Excel按钮显示内容
btnOutToExcel.Enabled = false; //导出此检索成果到Excel按钮不可点击
txt_achievement_name = string.Empty; //记录数据库内主键的值为空
sql_backup = string.Empty;
this.dgvData.DataSource = null; //DataGridView控件显示数据
return;
}
btnDelete.Enabled = true; //删除此项成果按钮可点击
btnUpdate.Enabled = true; //更新此项成果按钮可点击
btnOutToExcel.Text = "导出此检索成果到Excel"; //导出此检索成果到Excel按钮显示内容
btnOutToExcel.Enabled = true; //导出此检索成果到Excel按钮可点击
this.dgvData.AutoGenerateColumns = true; //自动
this.dgvData.DataSource = ds.Tables[0]; //DataGridView控件显示数据
this.dgvData.Columns[0].ReadOnly = true; //设为只读
this.dgvData.Columns[1].ReadOnly = true; //设为只读
this.dgvData.Columns[2].ReadOnly = true; //设为只读
this.dgvData.Columns[3].ReadOnly = true; //设为只读
this.dgvData.Columns[4].ReadOnly = true; //设为只读
this.dgvData.Columns[5].ReadOnly = true; //设为只读
this.txt_achievement_name = this.dgvData.Rows[0].Cells[0].Value.ToString().Trim();
return;
}
catch (Exception ex)
{
btnDelete.Enabled = false; //删除此项成果按钮不可点击
btnUpdate.Enabled = false; //更新此项成果按钮不可点击
btnOutToExcel.Text = "导出此检索成果到Excel"; //导出此检索成果到Excel按钮显示内容
btnOutToExcel.Enabled = false; //导出此检索成果到Excel按钮不可点击
txt_achievement_name = string.Empty; //记录数据库内主键的值为空
sql_backup = string.Empty;
this.dgvData.DataSource = null; //DataGridView控件显示数据
return;
}
#endregion
}
}
MessageBox.Show("删除失败！", "提示");
return;
}
else//取消
{
return;
}
}
private void btnUpdate_Click(object sender, EventArgs e) //更新此项成果
{
if (MyDatabase.TestMyDatabaseConnect() == false) //数据库连接失败
{
MessageBox.Show("数据库连接失败！", "提示");
return;
}
frmAchievementUpdate achievement_update = new frmAchievementUpdate(txt_achievement_name); //实例化成果更新窗体
achievement_update.ShowDialog(); //成果更新窗体以模式对话框的方式打开
#region 更新DataGridView控件内的内容
try
{
DataSet ds = MyDatabase.GetDataSetBySql(sql_backup);
if (ds == null) //数据库连接失败
{
btnDelete.Enabled = false; //删除此项成果按钮不可点击
btnUpdate.Enabled = false; //更新此项成果按钮不可点击
btnOutToExcel.Text = "导出此检索成果到Excel"; //导出此检索成果到Excel按钮显示内容
btnOutToExcel.Enabled = false; //导出此检索成果到Excel按钮不可点击
txt_achievement_name = string.Empty; //记录数据库内主键的值为空
sql_backup = string.Empty;
this.dgvData.DataSource = null; //DataGridView控件显示数据
MessageBox.Show("数据库连接失败！", "提示");
return;
}
if (ds.Tables[0].Rows.Count == 0) //未检索到符合要求的成果信息
{
btnDelete.Enabled = false; //删除此项成果按钮不可点击
btnUpdate.Enabled = false; //更新此项成果按钮不可点击
btnOutToExcel.Text = "导出此检索成果到Excel"; //导出此检索成果到Excel按钮显示内容
btnOutToExcel.Enabled = false; //导出此检索成果到Excel按钮不可点击
txt_achievement_name = string.Empty; //记录数据库内主键的值为空
sql_backup = string.Empty;
this.dgvData.DataSource = null; //DataGridView控件显示数据
return;
}
btnDelete.Enabled = true; //删除此项成果按钮可点击
btnUpdate.Enabled = true; //更新此项成果按钮可点击
btnOutToExcel.Text = "导出此检索成果到Excel"; //导出此检索成果到Excel按钮显示内容
btnOutToExcel.Enabled = true; //导出此检索成果到Excel按钮可点击
this.dgvData.AutoGenerateColumns = true; //自动
this.dgvData.DataSource = ds.Tables[0]; //DataGridView控件显示数据
this.dgvData.Columns[0].ReadOnly = true; //设为只读
this.dgvData.Columns[1].ReadOnly = true; //设为只读
this.dgvData.Columns[2].ReadOnly = true; //设为只读
this.dgvData.Columns[3].ReadOnly = true; //设为只读
this.dgvData.Columns[4].ReadOnly = true; //设为只读
this.dgvData.Columns[5].ReadOnly = true; //设为只读
this.txt_achievement_name = this.dgvData.Rows[0].Cells[0].Value.ToString().Trim();
return;
}
catch (Exception ex)
{
btnDelete.Enabled = false; //删除此项成果按钮不可点击
btnUpdate.Enabled = false; //更新此项成果按钮不可点击
btnOutToExcel.Text = "导出此检索成果到Excel"; //导出此检索成果到Excel按钮显示内容
btnOutToExcel.Enabled = false; //导出此检索成果到Excel按钮不可点击
txt_achievement_name = string.Empty; //记录数据库内主键的值为空
sql_backup = string.Empty;
this.dgvData.DataSource = null; //DataGridView控件显示数据
return;
}
#endregion
}
private void btnSearch_Click(object sender, EventArgs e) //检索
{
if (MyDatabase.TestMyDatabaseConnect() == false) //数据库连接失败
{
MessageBox.Show("数据库连接失败！", "提示");
return;
}
try//防止将所有成果类型均删除后，成果类型为空时检索，会导致未引用的异常
{
if (this.cboAchievementType.SelectedItem.ToString() == string.Empty)
{
MessageBox.Show("成果类型选择有误", "提示");
return;
}
}
catch (Exception ex)
{
MessageBox.Show("无任何待检索成果类型，检索失败！", "提示");
return;
}
try
{
string sql = string.Format("select datainfo.AchievementName as '成果名称', datainfo.AchievementType as '成果类型', datainfo.AchievementDate as '时间', datainfo.AchievementAuthor as '作者', datainfo.AchievementCompany as '单位', datainfo.AchievementMoney as '支撑基金' from datainfo where AchievementType='{0}';", this.cboAchievementType.SelectedItem.ToString().Trim());
DataSet ds = MyDatabase.GetDataSetBySql(sql);
if (ds == null) //数据库连接失败
{
btnDelete.Enabled = false; //删除此项成果按钮不可点击
btnUpdate.Enabled = false; //更新此项成果按钮不可点击
btnOutToExcel.Text = "导出此检索成果到Excel"; //导出此检索成果到Excel按钮显示内容
btnOutToExcel.Enabled = false; //导出此检索成果到Excel按钮不可点击
txt_achievement_name = string.Empty; //记录数据库内主键的值为空
txt_achievement_type = string.Empty;
this.dgvData.DataSource = null; //DataGridView控件显示数据
MessageBox.Show("数据库连接失败！", "提示");
return;
}
if (ds.Tables[0].Rows.Count == 0) //未检索到符合要求的成果信息
{
btnDelete.Enabled = false; //删除此项成果按钮不可点击
btnUpdate.Enabled = false; //更新此项成果按钮不可点击
btnOutToExcel.Text = "导出此检索成果到Excel"; //导出此检索成果到Excel按钮显示内容
btnOutToExcel.Enabled = false; //导出此检索成果到Excel按钮不可点击
txt_achievement_name = string.Empty; //记录数据库内主键的值为空
txt_achievement_type = string.Empty;
this.dgvData.DataSource = null; //DataGridView控件显示数据
MessageBox.Show("未检索到符合要求的成果信息！", "提示");
return;
}
btnDelete.Enabled = true; //删除此项成果按钮可点击
btnUpdate.Enabled = true; //更新此项成果按钮可点击
btnOutToExcel.Text = "导出此检索成果到Excel"; //导出此检索成果到Excel按钮显示内容
btnOutToExcel.Enabled = true; //导出此检索成果到Excel按钮可点击
this.dgvData.AutoGenerateColumns = true; //自动
this.dgvData.DataSource = ds.Tables[0]; //DataGridView控件显示数据
this.dgvData.Columns[0].ReadOnly = true; //设为只读
this.dgvData.Columns[1].ReadOnly = true; //设为只读
this.dgvData.Columns[2].ReadOnly = true; //设为只读
this.dgvData.Columns[3].ReadOnly = true; //设为只读
this.dgvData.Columns[4].ReadOnly = true; //设为只读
this.dgvData.Columns[5].ReadOnly = true; //设为只读
this.txt_achievement_name = this.dgvData.Rows[0].Cells[0].Value.ToString().Trim();
this.txt_achievement_type = this.dgvData.Rows[0].Cells[1].Value.ToString().Trim();
MessageBox.Show("检索成功！", "提示");
return;
}
catch (Exception ex)
{
btnDelete.Enabled = false; //删除此项成果按钮不可点击
btnUpdate.Enabled = false; //更新此项成果按钮不可点击
btnOutToExcel.Text = "导出此检索成果到Excel"; //导出此检索成果到Excel按钮显示内容
btnOutToExcel.Enabled = false; //导出此检索成果到Excel按钮不可点击
txt_achievement_name = string.Empty; //记录数据库内主键的值为空
txt_achievement_type = string.Empty;
this.dgvData.DataSource = null; //DataGridView控件显示数据
MessageBox.Show("检索失败！", "提示");
return;
}
}
private void btnDelete_Click(object sender, EventArgs e) //删除此项成果
{
if (MyDatabase.TestMyDatabaseConnect() == false) //数据库连接失败
{
MessageBox.Show("数据库连接失败！", "提示");
return;
}
DialogResult result = MessageBox.Show("是否确定删除此项成果？", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
if (result == DialogResult.OK)//确定
{
if (txt_achievement_name != string.Empty)
{
string sql_1 = string.Format("delete from datainfo where datainfo.AchievementName='{0}';", txt_achievement_name); //sql语句
if (MyDatabase.UpdateDataBySql(sql_1)) //删除成功
{
//更新删除后DataGridView控件内的数据
try
{
string sql_2 = string.Format("select datainfo.AchievementName as '成果名称', datainfo.AchievementType as '成果类型', datainfo.AchievementDate as '时间', datainfo.AchievementAuthor as '作者', datainfo.AchievementCompany as '单位', datainfo.AchievementMoney as '支撑基金' from datainfo where AchievementType='{0}';", txt_achievement_type);
DataSet ds_2 = MyDatabase.GetDataSetBySql(sql_2);
if (ds_2.Tables[0].Rows.Count == 0) //删除此条成果后数据库中已无此成果类型的成果
{
btnDelete.Enabled = false; //删除此项成果按钮不可点击
btnUpdate.Enabled = false; //更新此项成果按钮不可点击
btnOutToExcel.Text = "导出此检索成果到Excel"; //导出此检索成果到Excel按钮显示内容
btnOutToExcel.Enabled = false; //导出此检索成果到Excel按钮不可点击
txt_achievement_name = string.Empty; //记录数据库内主键的值为空
txt_achievement_type = string.Empty;
this.dgvData.DataSource = null; //DataGridView控件显示数据
#region 成果类型组合框更新
if (MyDatabase.TestMyDatabaseConnect() == false)//数据库连接失败
{
MessageBox.Show("数据库连接失败！", "提示");
return;
}
try
{
this.cboAchievementType.Items.Clear(); //清空combox内所有选项
DataSet ds_3 = MyDatabase.GetDataSetBySql("select distinct AchievementType from datainfo;");
if (ds_3.Tables[0].Rows.Count == 0) //删除此条成果后数据库中已无其他成果类型
{
btnDelete.Enabled = false; //删除此项成果按钮不可点击
btnUpdate.Enabled = false; //更新此项成果按钮不可点击
btnOutToExcel.Text = "导出此检索成果到Excel"; //导出此检索成果到Excel按钮显示内容
btnOutToExcel.Enabled = false; //导出此检索成果到Excel按钮不可点击
txt_achievement_name = string.Empty; //记录数据库内主键的值为空
txt_achievement_type = string.Empty;
this.dgvData.DataSource = null; //DataGridView控件显示数据
MessageBox.Show("删除成功！", "提示");
return;
}
for (int i = 0; i < ds_3.Tables[0].Rows.Count; i++)
{
this.cboAchievementType.Items.Add(ds_3.Tables[0].Rows[i][0].ToString().Trim());
}
this.cboAchievementType.SelectedIndex = 0;
}
catch (Exception ex)//数据库可能连接不上，MyDatabase.GetDataSetBySql函数会出错，返回的DataSet值为null，导致下面引用DataSet具体值时会抛出异常(后经改进在DataSet具体值使用之前加入了值是否为null的判断，后又经过改进在每次事件处理前均加入了检测能否成功连接的函数)
{
MessageBox.Show(ex.Message);
}
#endregion
MessageBox.Show("删除成功！", "提示");
return;
}
btnDelete.Enabled = true; //删除此项成果按钮可点击
btnUpdate.Enabled = true; //更新此项成果按钮可点击
btnOutToExcel.Text = "导出此检索成果到Excel"; //导出此检索成果到Excel按钮显示内容
btnOutToExcel.Enabled = true; //导出此检索成果到Excel按钮可点击
this.dgvData.AutoGenerateColumns = true; //自动
this.dgvData.DataSource = ds_2.Tables[0]; //DataGridView控件显示数据
this.dgvData.Columns[0].ReadOnly = true; //设为只读
this.dgvData.Columns[1].ReadOnly = true; //设为只读
this.dgvData.Columns[2].ReadOnly = true; //设为只读
this.dgvData.Columns[3].ReadOnly = true; //设为只读
this.dgvData.Columns[4].ReadOnly = true; //设为只读
this.dgvData.Columns[5].ReadOnly = true; //设为只读
txt_achievement_name = this.dgvData.Rows[0].Cells[0].Value.ToString().Trim();
txt_achievement_type = this.dgvData.Rows[0].Cells[1].Value.ToString().Trim();
MessageBox.Show("删除成功！", "提示");
return;
}
catch (Exception ex)
{
btnDelete.Enabled = false; //删除此项成果按钮不可点击
btnUpdate.Enabled = false; //更新此项成果按钮不可点击
btnOutToExcel.Text = "导出此检索成果到Excel"; //导出此检索成果到Excel按钮显示内容
btnOutToExcel.Enabled = false; //导出此检索成果到Excel按钮不可点击
txt_achievement_name = string.Empty; //记录数据库内主键的值为空
txt_achievement_type = string.Empty;
this.dgvData.DataSource = null; //DataGridView控件显示数据
MessageBox.Show("删除失败！", "提示");
return;
}
}
}
MessageBox.Show("删除失败！", "提示");
return;
}
else//取消
{
return;
}
}
private void btnUpdate_Click(object sender, EventArgs e) //更新此项成果
{
if (MyDatabase.TestMyDatabaseConnect() == false) //数据库连接失败
{
MessageBox.Show("数据库连接失败！", "提示");
return;
}
frmAchievementUpdate achievement_update = new frmAchievementUpdate(txt_achievement_name); //实例化成果更新窗体
achievement_update.ShowDialog(); //成果更新窗体以模式对话框的方式打开
#region 成果类型组合框更新
if (MyDatabase.TestMyDatabaseConnect() == false) //数据库连接失败
{
MessageBox.Show("数据库连接失败！", "提示");
return;
}
try
{
this.cboAchievementType.Items.Clear(); //清空combox内所有选项
DataSet ds_1 = MyDatabase.GetDataSetBySql("select distinct AchievementType from datainfo;");
if (ds_1.Tables[0].Rows.Count == 0) //数据库中已无任何成果类型
{
btnDelete.Enabled = false; //删除此项成果按钮不可点击
btnUpdate.Enabled = false; //更新此项成果按钮不可点击
btnOutToExcel.Text = "导出此检索成果到Excel"; //导出此检索成果到Excel按钮显示内容
btnOutToExcel.Enabled = false; //导出此检索成果到Excel按钮不可点击
txt_achievement_name = string.Empty; //记录数据库内主键的值为空
txt_achievement_type = string.Empty;
this.dgvData.DataSource = null; //DataGridView控件显示数据
return;
}
for (int i = 0; i < ds_1.Tables[0].Rows.Count; i++)
{
this.cboAchievementType.Items.Add(ds_1.Tables[0].Rows[i][0].ToString().Trim());
}
bool checkresult = false;
for (int i = 0; i < this.cboAchievementType.Items.Count; i++)
{
if (string.Compare(cboAchievementType.GetItemText(cboAchievementType.Items[i]), txt_achievement_type) == 0)//成果类型combox中还有之前的成果类型
{
this.cboAchievementType.SelectedIndex = i;
checkresult = true;
break;
}
}
if (checkresult == false)//成果类型combox中已无之前的成果类型
{
this.cboAchievementType.SelectedIndex = 0;
btnDelete.Enabled = false; //删除此项成果按钮不可点击
btnUpdate.Enabled = false; //更新此项成果按钮不可点击
btnOutToExcel.Text = "导出此检索成果到Excel"; //导出此检索成果到Excel按钮显示内容
btnOutToExcel.Enabled = false; //导出此检索成果到Excel按钮不可点击
txt_achievement_name = string.Empty; //记录数据库内主键的值为空
txt_achievement_type = string.Empty;
dgvData.DataSource = null;
return;
}
}
catch (Exception ex)//数据库可能连接不上，MyDatabase.GetDataSetBySql函数会出错，返回的DataSet值为null，导致下面引用DataSet具体值时会抛出异常(后经改进在DataSet具体值使用之前加入了值是否为null的判断，后又经过改进在每次事件处理前均加入了检测能否成功连接的函数)
{
MessageBox.Show(ex.Message);
}
#endregion
#region DataGridView控件内容更新
try
{
string sql_2 = string.Format("select datainfo.AchievementName as '成果名称', datainfo.AchievementType as '成果类型', datainfo.AchievementDate as '时间', datainfo.AchievementAuthor as '作者', datainfo.AchievementCompany as '单位', datainfo.AchievementMoney as '支撑基金' from datainfo where AchievementType='{0}';", txt_achievement_type);
DataSet ds_2 = MyDatabase.GetDataSetBySql(sql_2);
this.dgvData.DataSource = ds_2.Tables[0]; //DataGridView控件显示数据
this.dgvData.Columns[0].ReadOnly = true; //设为只读
this.dgvData.Columns[1].ReadOnly = true; //设为只读
this.dgvData.Columns[2].ReadOnly = true; //设为只读
this.dgvData.Columns[3].ReadOnly = true; //设为只读
this.dgvData.Columns[4].ReadOnly = true; //设为只读
this.dgvData.Columns[5].ReadOnly = true; //设为只读
txt_achievement_name = this.dgvData.Rows[0].Cells[0].Value.ToString().Trim();
txt_achievement_type = this.dgvData.Rows[0].Cells[1].Value.ToString().Trim();
return;
}
catch (Exception ex)
{
MessageBox.Show("数据更新出错！");
return;
}
#endregion
}
private void frmMechanicalDrawing_Load(object sender, EventArgs e) //窗体载入时初始化
{
txtAchievementName.Text = string.Empty; //成果名称显示内容
txtSaveDirectory.Text = string.Empty; //成果保存目录显示内容
txtPartNum.Text = "0"; //零件图个数显示内容
txtAssemblyNum.Text = "0"; //装配图个数显示内容
txtDrawingNum.Text = "0"; //工程图纸个数显示内容
this.dgvData.DataSource = null; //机械图信息显示DataGridView控件显示数据
this.dgvData.AllowUserToAddRows = false; //不允许用户添加新行
btnCount.Text = "开始统计个数信息"; //设置开始统计个数信息按钮显示内容
btnCount.Enabled = true; //开始统计个数信息按钮可点击
btnOutToFile.Text = "导出此视图内容到文件"; //设置导出此视图内容到文件按钮显示内容
btnOutToFile.Enabled = false; //设置导出此视图内容到文件按钮不可点击
btnUpdate.Enabled = false; //更新机械图信息按钮不可点击
#region 所用软件组合框初始化
this.cboSoftware.Items.Clear();//清空combox内所有选项
this.cboSoftware.Items.Add("CAD");
this.cboSoftware.Items.Add("UG");
this.cboSoftware.Items.Add("Solidworks");
this.cboSoftware.Items.Add("Inventor");
this.cboSoftware.Items.Add("ProE");
this.cboSoftware.Items.Add("Catia");
this.cboSoftware.Items.Add("(其他)");
this.cboSoftware.Items.Add("(Unknown)"); //所用软件未知，数据库内该字段的默认值
this.cboSoftware.SelectedIndex = 7; //选中默认值"(Unknown)"
#endregion
if (MyDatabase.TestMyDatabaseConnect() == false)//数据库连接失败
{
MessageBox.Show("数据库连接失败！", "提示");
return;
}
try
{
string sql_1 = "select datainfo.AchievementName as '成果名称', datainfo.AchievementType as '成果类型', datainfo.AchievementDate as '时间', datainfo.AchievementAuthor as '作者', datainfo.AchievementCompany as '单位', datainfo.AchievementMoney as '支撑基金' from datainfo where AchievementType='机械图';";
DataTable dt_1 = MyDatabase.GetDataSetBySql(sql_1);
if (dt_1.Rows.Count == 0) //未检索到任何机械图成果
{
this.dgvData.DataSource = null; //机械图信息显示DataGridView控件显示数据
btnUpdate.Enabled = false; //更新机械图信息按钮不可点击
btnOutToFile.Text = "导出此视图内容到文件"; //设置导出此视图内容到文件按钮显示内容
btnOutToFile.Enabled = false; //设置导出此视图内容到文件按钮不可点击
MessageBox.Show("目前未有任何机械图成果，请先添加机械图成果！", "提示");
return;
}
for (int i = 0; i < dt_1.Rows.Count; i++)//对所有在mechanicaldrawing表中没有的机械图成果自动添加所有值为默认值的记录
{
string sql_2 = string.Format("select mechanicaldrawing.AchievementName as '成果名称', mechanicaldrawing.SaveDirectory as '成果保存目录', mechanicaldrawing.PartNum as '零件图个数', mechanicaldrawing.AssemblyNum as '装配图个数', mechanicaldrawing.DrawingNum as '工程图纸个数' from mechanicaldrawing where mechanicaldrawing.AchievementName='{0}';", MyDatabase.CharFilter(dt_1.Rows[i][0].ToString().Trim()));
DataTable dt_2 = MyDatabase.GetDataSetBySql(sql_2);
if (dt_2.Rows.Count == 0)//此机械图成果在mechanicaldrawing表无记录，添加所有值为默认值的记录
{
string sql_3 = string.Format("insert into mechanicaldrawing values('{0}', '(Unknown)', '(Null)', 0, 0, 0);", MyDatabase.CharFilter(dt_1.Rows[i][0].ToString().Trim()));
if (MyDatabase.UpdateDataBySql(sql_3) == false) //添加失败
{
this.dgvData.DataSource = null; //机械图信息显示DataGridView控件显示数据
btnUpdate.Enabled = false; //更新机械图信息按钮不可点击
btnOutToFile.Text = "导出此视图内容到文件"; //设置导出此视图内容到文件按钮显示内容
btnOutToFile.Enabled = false; //设置导出此视图内容到文件按钮不可点击
MessageBox.Show("获取数据初始化时失败！", "提示");
return;
}
}
}
string sql_4 = "select datainfo.AchievementName as '成果名称', datainfo.AchievementType as '成果类型', datainfo.AchievementDate as '时间', datainfo.AchievementAuthor as '作者', datainfo.AchievementCompany as '单位', datainfo.AchievementMoney as '支撑基金', mechanicaldrawing.Software as '所用软件', mechanicaldrawing.SaveDirectory as '成果保存目录', mechanicaldrawing.PartNum as '零件图个数', mechanicaldrawing.AssemblyNum as '装配图个数', mechanicaldrawing.DrawingNum as '工程图纸个数' from datainfo join mechanicaldrawing on datainfo.AchievementName=mechanicaldrawing.AchievementName;";
DataTable dt_4 = MyDatabase.GetDataSetBySql(sql_4);
this.dgvData.DataSource = null; //先置为null，否则在右键删除DataGridView后再次检索后显示的字段顺序会有误
this.dgvData.DataSource = dt_4; //机械图信息显示DataGridView控件显示数据
btnUpdate.Enabled = true; //更新机械图信息按钮可点击
btnOutToFile.Text = "导出此视图内容到文件"; //设置导出此视图内容到文件按钮显示内容
btnOutToFile.Enabled = true; //设置导出此视图内容到文件按钮可点击
this.txtAchievementName.Text = MyDatabase.CharFilter(this.dgvData.Rows[0].Cells[0].Value.ToString().Trim());
this.cboSoftware.Text = MyDatabase.CharFilter(this.dgvData.Rows[0].Cells[6].Value.ToString().Trim());
this.txtSaveDirectory.Text = MyDatabase.CharFilter(this.dgvData.Rows[0].Cells[7].Value.ToString().Trim());
this.txtPartNum.Text = MyDatabase.CharFilter(this.dgvData.Rows[0].Cells[8].Value.ToString().Trim());
this.txtAssemblyNum.Text = MyDatabase.CharFilter(this.dgvData.Rows[0].Cells[9].Value.ToString().Trim());
this.txtDrawingNum.Text = MyDatabase.CharFilter(this.dgvData.Rows[0].Cells[10].Value.ToString().Trim());
return;
}
catch (Exception ex)
{
this.dgvData.DataSource = null; //机械图信息显示DataGridView控件显示数据
btnUpdate.Enabled = false; //更新机械图信息按钮不可点击
btnOutToFile.Text = "导出此视图内容到文件"; //设置导出此视图内容到文件按钮显示内容
btnOutToFile.Enabled = false; //设置导出此视图内容到文件按钮不可点击
MessageBox.Show("机械图管理界面初始化失败！", "提示");
return;
}
}