private void btnUnhidden_Click(object sender, EventArgs e) { if (MessageBox.Show("取消隐藏将会自动保存比对结果,是否继续?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No) { return; } //saveResult(); BLL.business_feedback bll = new BLL.business_feedback(); bll.UpdateAll("is_hidden=0"); DTV.Business business = new DTV.Business(); //载入出入境反馈数据 dgvFeedback.DataSource = business.LoadFeedback(query_id); dgvFeedback.Refresh(); }
private void dgvFeedback_CellContentClick(object sender, DataGridViewCellEventArgs e) { if (e.RowIndex > -1 && e.ColumnIndex > -1) { if (dgvFeedback.Columns[e.ColumnIndex] is DataGridViewButtonColumn) { string feeFullName = dgvFeedback.Rows[e.RowIndex].Cells["fee_full_name"].Value.ToString(); string feeBusName = dgvFeedback.Rows[e.RowIndex].Cells["fee_bus_name"].Value.ToString(); DataTable dtReport = (DataTable)dgvReport.DataSource; if (dgvFeedback.Rows[e.RowIndex].Cells["fee_is_match"] != null && Convert.ToBoolean(dgvFeedback.Rows[e.RowIndex].Cells["fee_is_match"].Value)) { MessageBox.Show("本记录已匹配成功,不能添加或隐藏!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); dgvFeedback.ClearSelection(); return; } if (dgvFeedback.Columns[e.ColumnIndex].Name == "btnHidden") { int feedback_id; int.TryParse(dgvFeedback.Rows[e.RowIndex].Cells["fee_id"].Value.ToString(), out feedback_id); BLL.business_feedback bll = new BLL.business_feedback(); Model.business_feedback model = bll.GetModel(feedback_id); model.is_hidden = true; bll.Update(model); DTV.Business business = new DTV.Business(); //载入反馈数据 DataTable dt = (DataTable)dgvFeedback.DataSource; dt.Rows.Remove(dt.Select(string.Format("id={0}", feedback_id))[0]); dgvFeedback.DataSource = dt; dgvFeedback.Refresh(); } if (dgvFeedback.Columns[e.ColumnIndex].Name == "btnToReport")//左移 { if (dtReport.Select(string.Format("full_name='{0}' and bus_name='{1}'", feeFullName, feeBusName)).Length > 0) { MessageBox.Show("个人报告数据中已有记录,不能添加!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); dgvFeedback.ClearSelection(); return; } //添加数据到个人报告数据表中 DataRow drReport = dtReport.NewRow(); drReport["id"] = 0; drReport["query_id"] = dgvFeedback.Rows[e.RowIndex].Cells["fee_query_id"].Value; drReport["full_name"] = dgvFeedback.Rows[e.RowIndex].Cells["fee_full_name"].Value; drReport["bus_name"] = dgvFeedback.Rows[e.RowIndex].Cells["fee_bus_name"].Value; drReport["bus_type"] = dgvFeedback.Rows[e.RowIndex].Cells["fee_bus_type"].Value; drReport["subscribe"] = dgvFeedback.Rows[e.RowIndex].Cells["fee_subscribe"].Value; drReport["proportion"] = dgvFeedback.Rows[e.RowIndex].Cells["fee_proportion"].Value; drReport["office"] = dgvFeedback.Rows[e.RowIndex].Cells["fee_office"].Value; drReport["status"] = dgvFeedback.Rows[e.RowIndex].Cells["fee_status"].Value; drReport["is_match"] = true; drReport["is_import"] = false; drReport["feedback_id"] = dgvFeedback.Rows[e.RowIndex].Cells["fee_id"].Value; dtReport.Rows.Add(drReport); dtReport.DefaultView.Sort = "feedback_id"; dgvReport.DataSource = dtReport; dgvFeedback.ClearSelection(); dgvReport.ClearSelection(); //添加数据到匹配数据表中 DataTable dtCompare = (DataTable)dgvCompare.DataSource; DataRow drCompare = dtCompare.NewRow(); drCompare["id"] = 0; drCompare["query_id"] = Convert.ToInt32(dgvFeedback.Rows[e.RowIndex].Cells["fee_query_id"].Value); drCompare["report_id"] = drReport["id"]; drCompare["feedback_id"] = Convert.ToInt32(dgvFeedback.Rows[e.RowIndex].Cells["fee_id"].Value); drCompare["rep_full_name"] = drReport["full_name"]; drCompare["rep_bus_name"] = drReport["bus_name"]; drCompare["rep_bus_type"] = drReport["bus_type"]; drCompare["rep_subscribe"] = drReport["subscribe"]; drCompare["rep_proportion"] = drReport["proportion"]; drCompare["rep_office"] = drReport["office"]; drCompare["rep_status"] = drReport["status"]; drCompare["fee_full_name"] = dgvFeedback.Rows[e.RowIndex].Cells["fee_full_name"].Value; drCompare["fee_bus_name"] = dgvFeedback.Rows[e.RowIndex].Cells["fee_bus_name"].Value; drCompare["fee_bus_type"] = dgvFeedback.Rows[e.RowIndex].Cells["fee_bus_type"].Value; drCompare["fee_subscribe"] = dgvFeedback.Rows[e.RowIndex].Cells["fee_subscribe"].Value; drCompare["fee_proportion"] = dgvFeedback.Rows[e.RowIndex].Cells["fee_proportion"].Value; drCompare["fee_office"] = dgvFeedback.Rows[e.RowIndex].Cells["fee_office"].Value; drCompare["fee_status"] = dgvFeedback.Rows[e.RowIndex].Cells["fee_status"].Value; drCompare["compare_type"] = "一致"; drCompare["less_value"] = 0; dtCompare.Rows.Add(drCompare); dgvCompare.DataSource = dtCompare; dgvCompare.ClearSelection(); dgvFeedback.Rows[e.RowIndex].Cells["fee_is_match"].Value = true; GetCompareResult(); } } } }