/// <summary>
/// 预览事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
void UCWareHouseManager_ViewEvent(object sender, EventArgs e)
{
DataTable dtData = dgvWareHouseList.DataSource as DataTable;
if (dtData != null)
{
businessPrint.Preview(dtData);
}
}
void UCDictionaryManager_ViewEvent(object sender, EventArgs e)
{
DataTable dtData = dgvDicList.GetBoundData();
if (dtData != null)
{
businessPrint.Preview(dtData);
}
}
/// <summary>
/// 预览事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
void UCWorkingTimeManager_ViewEvent(object sender, EventArgs e)
{
DataTable dtData = gvWorkList.DataSource as DataTable;
if (dtData != null)
{
businessPrint.Preview(dtData);
}
}
//打印预览事件
void UCOrganizationManager_ViewEvent(object sender, EventArgs e)
{
DataTable dtData = this.dgvorganization.GetBoundData();
if (dtData != null)
{
businessPrint.Preview(dtData);
}
}
//打印预览
void UCPersonnelManager_ViewEvent(object sender, EventArgs e)
{
DataTable dtData = dgvUser.GetBoundData();
if (dtData != null)
{
businessPrint.Preview(dtData);
}
}
/// <summary>
/// 预览事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
void UCSupplierManager_ViewEvent(object sender, EventArgs e)
{
//ViewData();
DataTable dtData = dgvSupplierList.GetBoundData();
if (dtData != null)
{
businessPrint.Preview(dtData);
}
}
//预览事件
void UCAccountVerificationManage_ViewEvent(object sender, EventArgs e)
{
//ViewData();
if (!isPreview)
{
dtData.DataTableToDate("order_date");
dtData.DateTableToEnum("order_type", typeof(DataSources.EnumAccountVerification));
dtData.DateTableToEnum("order_status", typeof(DataSources.EnumAuditStatus));
isPreview = true;
}
businessPrint.Preview(dtData);
}
// 预览
void UC_ViewEvent(object sender, EventArgs e)
{
//if (this.dgvRecord.CurrentRow == null)
//{
// MessageBoxEx.Show("请选择预览记录！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
// return;
//}
//DataRow dr = (this.dgvRecord.CurrentRow.DataBoundItem as DataRowView).Row;
//string id = dr["announcement_id"].ToString();
//UCBulletinView uc = new UCBulletinView(dr, this.Name);
//base.addUserControl(uc, "公告管理-浏览", "BulletinView" + id, this.Tag.ToString(), this.Name);
businessPrint.Preview(dgvRecord.GetBoundData());
}
void UCPurchaseBillManangView_ViewEvent(object sender, EventArgs e)
{
if (tabControlEx1.SelectedIndex == 0)
{
printObject = "tb_pur_bill_s";
printTitle = "按采购开单查询";
businessPrint = new BusinessPrint(gvPurchaseOrderList, printObject, printTitle, paperSize, listNotPrint);
businessPrint.Preview(gvPurchaseOrderList.GetBoundData());
}
else if (tabControlEx1.SelectedIndex == 1)
{
printObject = "tb_pur_bill_search";
printTitle = "采购开按配件或供应商查询";
businessPrint = new BusinessPrint(gvPurchaseList2, printObject, printTitle, paperSize, listNotPrint);
businessPrint.Preview(gvPurchaseList2.GetBoundData());
}
}
void UCSaleBillManang_ViewEvent(object sender, EventArgs e)
{
if (tabControlEx1.SelectedIndex == 0)
{
printObject = "tb_parts_sale_billing_s";
printTitle = "按销售开单查询";
businessPrint = new BusinessPrint(gvPurchaseOrderList, printObject, printTitle, paperSize, listNotPrint);
businessPrint.Preview(gvPurchaseOrderList.GetBoundData());
}
else if (tabControlEx1.SelectedIndex == 1)
{
printObject = "tb_parts_sale_billing_search";
printTitle = "销售开单按配件或客户查询";
businessPrint = new BusinessPrint(gvPurchaseList2, printObject, printTitle, paperSize, listNotPrint);
businessPrint.Preview(gvPurchaseList2.GetBoundData());
}
}
void UCOldPartsReceiptQueryManager_ViewEvent(object sender, EventArgs e)
{
if (tcQuery.SelectedIndex == 0)
{
printObject = "tb_maintain_oldpart_receiv_send_r";
printTitle = "旧件收货单查询";
businessPrint = new BusinessPrint(dgvRData, printObject, printTitle, paperSize, listNotPrint);
businessPrint.Preview(dgvRData.GetBoundData());
}
else if (tcQuery.SelectedIndex == 1)
{
printObject = "tb_maintain_oldpart_receiv_send_s";
printTitle = "按配件查询旧件收货单";
businessPrint = new BusinessPrint(dgvPartsData, printObject, printTitle, paperSize, listNotPrint);
businessPrint.Preview(dgvPartsData.GetBoundData());
}
}
void UCYTManagerView_ViewEvent(object sender, EventArgs e)
{
if (tabControlEx1.SelectedIndex == 0)
{
printObject = "tb_parts_purchase_order_s";
printTitle = "按宇通采购订单查询";
businessPrint = new BusinessPrint(gvYTPurchaseOrderList, printObject, printTitle, paperSize, listNotPrint);
businessPrint.Preview(gvYTPurchaseOrderList.GetBoundData());
}
else if (tabControlEx1.SelectedIndex == 1)
{
printObject = "purchase_order_parts_search";
printTitle = "按配件或供应商查询";
businessPrint = new BusinessPrint(gvPurchaseList2, printObject, printTitle, paperSize, listNotPrint);
businessPrint.Preview(gvPurchaseList2.GetBoundData());
}
}
//预览事件
void UCReceivableManage_ViewEvent(object sender, EventArgs e)
{
//ViewData();
if (!isPreview)
{
dtData.DataTableToDate("order_date");
if (orderType == DataSources.EnumOrderType.RECEIVABLE)
{
dtData.DateTableToEnum("payment_type", typeof(DataSources.EnumReceivableType));
}
else
{
dtData.DateTableToEnum("payment_type", typeof(DataSources.EnumPaymentType));
}
dtData.DateTableToEnum("order_status", typeof(DataSources.EnumAuditStatus));
isPreview = true;
}
businessPrint.Preview(dtData);
}
/// <summary>
/// 预览事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
void UCSupplierManager_ViewEvent(object sender, EventArgs e)
{
//ViewData();
DataTable dtData = dgvSupplierList.DataSource as DataTable;
if (dtData != null)
{
//dtData.DataTableToDate("order_date");
//if (orderType == DataSources.EnumOrderType.RECEIVABLE)
//{
// dtData.DateTableToEnum("payment_type", typeof(DataSources.EnumReceivableType));
//}
//else
//{
// dtData.DateTableToEnum("payment_type", typeof(DataSources.EnumPaymentType));
//}
//dtData.DateTableToEnum("order_status", typeof(DataSources.EnumAuditStatus));
businessPrint.Preview(dtData);
}
}
void UCOldPartsReceiptManager_ViewEvent(object sender, EventArgs e)
{
businessPrint.Preview(dgvRData.GetBoundData());
}
//查看事件
void UCContactsManage_ViewEvent(object sender, EventArgs e)
{
businessPrint.Preview(dgvContacts.GetBoundData());
}
void UCOldPartsReceiptQueryManager_ViewEvent(object sender, EventArgs e)
{
if (tcQuery.SelectedIndex == 0)
{
printObject = "tb_maintain_oldpart_receiv_send_r";
printTitle = "旧件收货单查询";
businessPrint = new BusinessPrint(dgvRData, printObject, printTitle, paperSize, listNotPrint);
businessPrint.Preview(dgvRData.GetBoundData());
}
else if (tcQuery.SelectedIndex == 1)
{
printObject = "tb_maintain_oldpart_receiv_send_s";
printTitle = "按配件查询旧件收货单";
businessPrint = new BusinessPrint(dgvPartsData, printObject, printTitle, paperSize, listNotPrint);
businessPrint.Preview(dgvPartsData.GetBoundData());
}
}
// 预览
void UC_ViewEvent(object sender, EventArgs e)
{
businessPrint.Preview(dgvRecord.GetBoundData());
}
BusinessPrint businessPrint;//业务打印功能
#endregion
#region Method -- 方法
//初始化
private void Init()
{
dgvQData.MultiSelect = false; //不允许多选操作
SetUCBaseFuncationVisible();
#region 初始化时间控件值
dtpCBSTime.Value = DateTime.Now.AddMonths(-1);
dtpCBETime.Value = DateTime.Now.AddDays(+1);
#endregion
#region 初始化下拉框数据绑定
CommonCtrl.BindComboBoxByDictionarr(cboCBType, "sys_callback_type", true); //绑定反馈类型
CommonCtrl.BindComboBoxByDictionarr(cboCBMode, "sys_callback_mode", true); //绑定反馈方式
#endregion
#region 注册功能按钮事件
#region 清除查询条件
btnClear.Click += delegate
{
txtCBTitle.Caption = String.Empty;
cboCBType.SelectedValue = String.Empty;
cboCBMode.SelectedValue = String.Empty;
dtpCBSTime.Value = DateTime.Now.AddMonths(-1);
dtpCBETime.Value = DateTime.Now.AddDays(+1);
txtCustomerName.Text = String.Empty;
txtCBPerson.Text = String.Empty;
};
#endregion
#region 导出事件
btnExport.Click += delegate
{
if (this.dgvQData.Rows.Count == 0)
{
return;
}
try
{
string fileName = "信息反馈" + DateTime.Now.ToString("yyyy-MM-dd") + ".xls";
ExcelHandler.ExportExcel(fileName, dgvQData);
}
catch (Exception ex)
{
Utility.Log.Log.writeLineToLog("【信息反馈】" + ex.Message, "server");
MessageBoxEx.ShowWarning("导出失败！");
}
};
#endregion
#region 预览事件
btnView.Click += delegate
{
businessPrint.Preview(dgvQData.GetBoundData());
};
#endregion
#region 打印事件
btnPrint.Click += delegate
{
businessPrint.Print(dgvQData.GetBoundData());
};
#endregion
#region 设置事件
btnSet.Click += delegate
{
businessPrint.PrintSet(dgvQData);
};
#endregion
#region 查询
btnQuery.Click += delegate
{
BindPageData();
};
#endregion
#region 择客户信息
txtCustomerName.ChooserClick += delegate
{
var frmCustomer = new frmCustomerInfo();
var result = frmCustomer.ShowDialog();
if (result == DialogResult.OK)
{
txtCustomerName.Text = frmCustomer.strCustomerName;
txtCustomerName.Tag = frmCustomer.strCustomerId;
}
};
#endregion
#region 择反馈人
txtCBPerson.ChooserClick += delegate
{
var frmContacts = new frmContacts();
var result = frmContacts.ShowDialog();
if (result == DialogResult.OK)
{
txtCBPerson.Text = frmContacts.contName;
txtCBPerson.Tag = frmContacts.contID;
}
};
#endregion
#region 数据翻页
pageQ.PageIndexChanged += delegate
{
BindPageData();
};
#endregion
#region 数据表数据选择
dgvQData.CellDoubleClick += delegate
{
if (dgvQData.SelectedRows.Count > 0)
{
var uc = new UCFeedbackAddOrEdit();
uc.windowStatus = WindowStatus.View;
uc.UCFeedbakcManager = this;
var selectedData = dgvQData.SelectedRows[0];
uc.FeedbackId = selectedData.Cells["drtxt_Feedback_id"].Value.ToString();
var callbackInfo = DBHelper.GetTable("查询反馈信息", "tb_CustomerSer_Feedback", "*",
"Feedback_id = '" + uc.FeedbackId + "'", "",
"");
if (callbackInfo != null && callbackInfo.DefaultView.Count != 0)
{
uc.CustId = callbackInfo.DefaultView[0]["corp_id"].ToString();
uc.ContId = callbackInfo.DefaultView[0]["Feedback_by"].ToString();
uc.HandleId = callbackInfo.DefaultView[0]["handle_name"].ToString();
}
uc.addUserControl(uc, "信息反馈-详细", "UCFeedbackView", Tag.ToString(), Name);
}
};
#endregion
#region 数据表格数据格式化
dgvQData.CellFormatting += delegate(object sender, DataGridViewCellFormattingEventArgs args)
{
UIAssistants.DgvCellDataConvert2Table(dgvQData, args, "Feedback_by", "tb_contacts", "cont_id", "cont_name");
UIAssistants.DgvCellDataConvert2Table(dgvQData, args, "handle_name", "sys_user", "user_id", "user_name");
UIAssistants.DgvCellDataConvert2Table(dgvQData, args, "corp_id", "tb_customer", "cust_id", "cust_name");
UIAssistants.DgvCellDataConvert2Datetime(dgvQData, args, "Feedback_time");
UIAssistants.DgvCellDataConvert2DicData(dgvQData, args, "Feedback_type"); //反馈类型
UIAssistants.DgvCellDataConvert2DicData(dgvQData, args, "Feedback_mode"); //反馈形式
};
#endregion
#region 新增数据
AddEvent += delegate
{
var uc = new UCFeedbackAddOrEdit();
uc.UCFeedbakcManager = this;
uc.windowStatus = WindowStatus.Add;
uc.addUserControl(uc, "信息反馈-新增", "UCFeedbackAdd", Tag.ToString(), Name);
};
#endregion
#region 编辑数据
EditEvent += delegate
{
if (dgvQData.SelectedRows.Count > 0)
{
var uc = new UCFeedbackAddOrEdit();
uc.windowStatus = WindowStatus.Edit;
uc.UCFeedbakcManager = this;
var dataView = GetSelectedRowData();
var listField = GetCheckRows();
if (dataView != null && listField.Count > 0)
{
var selectedData = dataView[0];
uc.FeedbackId = CommonCtrl.IsNullToString(selectedData["Feedback_id"]);
var callbackInfo = DBHelper.GetTable("查询反馈信息", "tb_CustomerSer_Feedback", "*",
"Feedback_id = '" + uc.FeedbackId + "'", "",
"");
if (callbackInfo != null && callbackInfo.DefaultView.Count != 0)
{
uc.CustId = callbackInfo.DefaultView[0]["corp_id"].ToString();
uc.ContId = callbackInfo.DefaultView[0]["Feedback_by"].ToString();
uc.HandleId = callbackInfo.DefaultView[0]["handle_name"].ToString();
}
uc.addUserControl(uc, "信息反馈-编辑", "UCFeedbackEdit", Tag.ToString(), Name);
}
}
BindPageData("1=1");
};
#endregion
#region 除数据
DeleteEvent += delegate
{
try
{
if (dgvQData.SelectedRows.Count == 0)
{
MessageBoxEx.Show("请选择删除记录！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
var result = MessageBoxEx.Show("此操作将永久删除选定信息。\n若要继续，请单击“确定”。", "您确认要删除此条信息吗？", MessageBoxButtons.OKCancel,
MessageBoxIcon.Warning);
if (result == DialogResult.OK)
{
var dataView = GetSelectedRowData();
var listField = GetCheckRows();
if (dataView != null && listField.Count > 0)
{
var selectedData = dataView[0];
var id = CommonCtrl.IsNullToString(selectedData["Feedback_id"]);
var flag = DBHelper.DeleteDataByID("删除反馈信息", "tb_CustomerSer_Feedback", "Feedback_id",
id);
if (flag)
{
BindPageData();
MessageBoxEx.Show("删除成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
BindPageData();
}
else
{
MessageBoxEx.Show("删除失败！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
}
}
catch (Exception ex)
{
MessageBoxEx.Show("删除失败！" + ex.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
BindPageData("1=1");
};
#endregion
#region 根据选择的数据判断功能按钮的显示状态
dgvQData.CellMouseUp += delegate
{
var dataView = GetSelectedRowData();
var listField = GetCheckRows();
btnStatus.Enabled = false;
btnEdit.Enabled = false;
btnDelete.Enabled = false;
if (dataView == null || listField.Count == 0)
{
}
else
{
#region 编辑
if (listField.Count == 1)
{
btnEdit.Enabled = true;
btnDelete.Enabled = true;
}
#endregion
}
};
#endregion
#endregion
BindPageData();
}
void RepairQueryManager_ViewEvent(object sender, EventArgs e)
{
if (tcQuery.SelectedIndex == 0)
{
printObject = "tb_maintain_info_Q";
printTitle = "按维修单查询";
businessPrint = new BusinessPrint(dgvQData, printObject, printTitle, paperSize, listNotPrint);
businessPrint.Preview(dgvQData.GetBoundData());
}
else if (tcQuery.SelectedIndex == 1)
{
printObject = "tb_maintain_info_P";
printTitle = "按维修项目查询";
businessPrint = new BusinessPrint(dgvProjectData, printObject, printTitle, paperSize, listNotPrint);
businessPrint.Preview(dgvProjectData.GetBoundData());
}
else if (tcQuery.SelectedIndex == 2)
{
printObject = "tb_maintain_info_M";
printTitle = "按维修用料查询";
businessPrint = new BusinessPrint(dgvYlData, printObject, printTitle, paperSize, listNotPrint);
businessPrint.Preview(dgvYlData.GetBoundData());
}
}
/// <summary>
/// 预览事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
void UCRoleManager_ViewEvent(object sender, EventArgs e)
{
businessPrint.Preview(dgvRole.GetBoundData());
}
void UCOldPartsInventoryQuery_ViewEvent(object sender, EventArgs e)
{
businessPrint.Preview(dgvRData.GetBoundData());
}
void UCYTManagerView_ViewEvent(object sender, EventArgs e)
{
if (tabControlEx1.SelectedIndex == 0)
{
printObject = "tb_parts_purchase_order_s";
printTitle = "按宇通采购订单查询";
businessPrint = new BusinessPrint(gvYTPurchaseOrderList, printObject, printTitle, paperSize, listNotPrint);
businessPrint.Preview(gvYTPurchaseOrderList.GetBoundData());
}
else if (tabControlEx1.SelectedIndex == 1)
{
printObject = "purchase_order_parts_search";
printTitle = "按配件或供应商查询";
businessPrint = new BusinessPrint(gvPurchaseList2, printObject, printTitle, paperSize, listNotPrint);
businessPrint.Preview(gvPurchaseList2.GetBoundData());
}
}
void UCSaleBillManang_ViewEvent(object sender, EventArgs e)
{
if (tabControlEx1.SelectedIndex == 0)
{
printObject = "tb_parts_sale_billing_s";
printTitle = "按销售开单查询";
businessPrint = new BusinessPrint(gvPurchaseOrderList, printObject, printTitle, paperSize, listNotPrint);
businessPrint.Preview(gvPurchaseOrderList.GetBoundData());
}
else if (tabControlEx1.SelectedIndex == 1)
{
printObject = "tb_parts_sale_billing_search";
printTitle = "销售开单按配件或客户查询";
businessPrint = new BusinessPrint(gvPurchaseList2, printObject, printTitle, paperSize, listNotPrint);
businessPrint.Preview(gvPurchaseList2.GetBoundData());
}
}
void UCFetchMaterialManager_ViewEvent(object sender, EventArgs e)
{
businessPrint.Preview(dgvRData.GetBoundData());
}
void UCSalePlanManagerSearch_ViewEvent(object sender, EventArgs e)
{
businessPrint.Preview(gvSalePlanList.GetBoundData());
}
private void FuncationRegiste() //事件注册
{
#region 数据表数据选择
//单元格数据转换
dgv_table.CellFormatting += (sender, args) => ConvertDataGridColumnsData(args);
//数据行双击事件
dgv_table.CellDoubleClick += delegate(object sender, DataGridViewCellEventArgs e)
{
try
{
if (e.RowIndex < 0)
{
return;
}
var value = dgv_table.Rows[e.RowIndex].Cells[cust_id.Name].Value;
if (value == null)
{
return;
}
var id = value.ToString();
var ucCustomerView = new UCCustomerViews
{
Id = id,
UCCustomerManager = this
};
addUserControl(ucCustomerView, "客户详细信息", "UCCustomerViews" + id, Tag.ToString(), Name);
}
catch (Exception ex)
{
LogService4Customer.WriteLog(1, ex);
}
};
//ViewEvent += delegate
//{
// try
// {
// if (dgv_table.SelectedRows.Count != 1) return;
// var value = dgv_table.SelectedRows[0].Cells[cust_id.Name].Value;
// if (value == null) return;
// var id = value.ToString();
// var ucCustomerView = new UCCustomerViews
// {
// Id = id,
// UCCustomerManager = this
// };
// addUserControl(ucCustomerView, "客户详细信息", "UCCustomerViews" + id, Tag.ToString(), Name);
// }
// catch (Exception ex)
// {
// LogService4Customer.WriteLog(1, ex);
// }
//};
#endregion
#region 数据翻页
pageQ.PageIndexChanged += delegate
{
BindPageData();
};
#endregion
#region 清除按钮事件
btn_clear.Click += delegate
{
try
{
UIAssistants.ClearQueryControlValue(pnl_query);
}
catch (Exception ex)
{
LogService4Customer.WriteLog(1, ex);
}
};
#endregion
#region 查询
btn_query.Click += (sender, args) =>
{
pageQ.PageIndex = 1;
pageQ.RecordCount = 0;
BindPageData();
};
#endregion
#region 预览事件
btnView.Click += delegate
{
businessPrint.Preview(dgv_table.GetBoundData());
}
;
#endregion
#region 打印事件
btnPrint.Click += delegate
{
businessPrint.Print(dgv_table.GetBoundData());
};
#endregion
#region 设置事件
btnSet.Click += delegate
{
businessPrint.PrintSet(dgv_table);
}
;
#endregion
#region 导出事件
btnExport.Click += delegate
{
if (this.dgv_table.Rows.Count == 0)
{
return;
}
try
{
string fileName = "客户档案" + DateTime.Now.ToString("yyyy-MM-dd") + ".xls";
ExcelHandler.ExportExcel(fileName, dgv_table);
}
catch (Exception ex)
{
Utility.Log.Log.writeLineToLog("【客户档案】" + ex.Message, "server");
MessageBoxEx.ShowWarning("导出失败！");
}
};
#endregion
#region 新增
btnAdd.Click += delegate
{
try
{
var ucCustomerAddOrEdit = new UCCustomerAddOrEdit {
UCCustomerManager = this, windowStatus = WindowStatus.Add
};
addUserControl(ucCustomerAddOrEdit, "客户信息新增", "UCCustomerAddOrEdit-Add", Tag.ToString(), Name);
}
catch (Exception ex)
{
LogService4Customer.WriteLog(1, ex);
}
};
#endregion
#region 制
btnCopy.Click += delegate
{
try
{
var id = "";
var dataView = UIAssistants.GetDataGridCheckRows(dgv_table, colCheck, cust_id, TableName);
if (dataView == null)
{
return;
}
foreach (DataRowView rowView in dataView)
{
id = rowView["cust_id"].ToString();
break;
}
var ucCustomerAddOrEdit = new UCCustomerAddOrEdit
{
UCCustomerManager = this,
windowStatus = WindowStatus.Copy,
Id = id
};
addUserControl(ucCustomerAddOrEdit, "客户信息拷贝", "UCCustomerAddOrEdit-Copy" + ucCustomerAddOrEdit.Id, Tag.ToString(), Name);
}
catch (Exception ex)
{
LogService4Customer.WriteLog(1, ex);
}
};
#endregion
#region 编辑
btnEdit.Click += delegate
{
try
{
var id = "";
var dataView = UIAssistants.GetDataGridCheckRows(dgv_table, colCheck, cust_id, TableName);
if (dataView == null)
{
return;
}
foreach (DataRowView rowView in dataView)
{
id = rowView["cust_id"].ToString();
break;
}
var ucCustomerAddOrEdit = new UCCustomerAddOrEdit
{
UCCustomerManager = this,
windowStatus = WindowStatus.Edit,
Id = id
};
addUserControl(ucCustomerAddOrEdit, "客户信息编辑", "UCCustomerAddOrEdit-Edit" + ucCustomerAddOrEdit.Id, Tag.ToString(), Name);
}
catch (Exception ex)
{
LogService4Customer.WriteLog(1, ex);
}
};
#endregion
#region 除
btnDelete.Click += delegate
{
try
{
var selectedRows = UIAssistants.GetDataGridCheckRows(dgv_table, colCheck, cust_id);
if (selectedRows.Count == 0)
{
MessageBoxEx.Show("请选择删除记录！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (MessageBoxEx.Show("确认要删除吗?", "提示", MessageBoxButtons.OKCancel) != DialogResult.OK)
{
return;
}
//var comField = new Dictionary<string, string> { { "enable_flag", "0" } };
//flag = DBHelper.BatchUpdateDataByIn("删除三包服务单", TableName, comField, "tg_id", selectedRows.ToArray());
var comField = new Dictionary <string, string> {
{ "enable_flag", "0" }
};
var flag = DBHelper.BatchUpdateDataByIn("批量删除客户档案", "tb_customer", comField, "cust_id", selectedRows.ToArray());
foreach (var selectedRow in selectedRows)
{
var crmIdDt = DBHelper.GetTable("查询客户档案信息", "tb_customer", "cust_crm_guid",
String.Format("cust_id = '{0}'", selectedRow), "", "");
if (crmIdDt != null && crmIdDt.Rows.Count == 1)
{
BeginInvoke(new MethodInvoker(delegate()
{
DBHelper.WebServHandler("删除客户档案", EnumWebServFunName.UpLoadCustomer,
new tb_customer
{
cust_crm_guid = CommonCtrl.IsNullToString(crmIdDt.Rows[0][0]),
status = "1",
accessories_discount = 0,
agency = "",
bank_account = "",
bank_account_person = "",
billing_account = "",
billing_address = "",
billing_name = "",
business_scope = "",
city = "",
com_constitution = "",
country = "",
county = "",
create_by = "",
create_time = 0,
credit_account_period = 0,
credit_line = 0,
credit_rating = "",
cust_address = "",
cust_code = "",
cust_email = "",
cust_fax = "",
cust_id = "",
cust_name = "",
cust_phone = "",
cust_quick_code = "",
cust_relation = "",
cust_remark = "",
cust_short_name = "",
cust_tel = "",
cust_type = "",
cust_website = "",
data_source = "",
enable_flag = "",
ent_qualification = "",
enterprise_nature = "",
indepen_legalperson = "",
institution_code = "",
is_member = "",
legal_person = "",
market_segment = "",
member_class = "",
member_number = "",
member_period_validity = 0,
open_bank = "",
price_type = "",
province = "",
registered_capital = "",
sap_code = "",
tax_num = "",
update_by = "",
update_time = 0,
vehicle_structure = "",
workhours_discount = 0,
yt_customer_manager = "",
yt_sap_code = "",
zip_code = ""
});
}));
}
}
if (flag)
{
BindPageData();
if (dgv_table.Rows.Count > 0)
{
dgv_table.CurrentCell = dgv_table.Rows[0].Cells[0];
}
MessageBoxEx.Show("删除成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBoxEx.Show("删除失败！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
catch (Exception ex)
{
LogService4Customer.WriteLog(1, ex);
MessageBoxEx.Show("删除失败！" + ex.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
};
#endregion
#region 省市区联动
cboprovince.SelectedIndexChanged += delegate
{
try
{
if (!string.IsNullOrEmpty(cboprovince.SelectedValue.ToString()))
{
CommonFuncCall.BindCityComBox(cbocity, cboprovince.SelectedValue.ToString(), "市");
CommonFuncCall.BindCountryComBox(cbocounty, cbocity.SelectedValue.ToString(), "区/县");
}
else
{
CommonFuncCall.BindCityComBox(cbocity, "", "市");
CommonFuncCall.BindCountryComBox(cbocounty, "", "区/县");
}
}
catch (Exception ex)
{
LogService4Customer.WriteLog(1, ex);
}
};
cbocity.SelectedIndexChanged += delegate
{
try
{
if (!string.IsNullOrEmpty(cbocity.SelectedValue.ToString()))
{
CommonFuncCall.BindCountryComBox(cbocounty, cbocity.SelectedValue.ToString(), "区/县");
}
else
{
CommonFuncCall.BindCountryComBox(cbocounty, "", "区/县");
}
}
catch (Exception ex)
{
LogService4Customer.WriteLog(1, ex);
}
};
#endregion
#region 启用停用事件
StatusEvent += delegate
{
try
{
var listSql = new List <SQLObj>();
const string opName = "修改客户档案状态";
var strStatus = Convert.ToInt16(_eStatus).ToString(CultureInfo.InvariantCulture);
string msg;
if (_eStatus == DataSources.EnumStatus.Start) //启用
{
StatusSql(listSql, _tiList, strStatus); //停用的ti_list改为启用
msg = "启用";
}
else//停用
{
StatusSql(listSql, _qiList, strStatus);//启用的qi_list 改为停用
msg = "停用";
}
if (MessageBoxEx.Show("确认要" + msg + "吗?", "提示", MessageBoxButtons.OKCancel) != DialogResult.OK)
{
return;
}
if (DBHelper.BatchExeSQLMultiByTrans(opName, listSql))
{
btnStatus.Enabled = false;
BindPageData();
MessageBoxEx.Show(msg + "成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBoxEx.Show(msg + "失败！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
catch (Exception ex)
{
LogService4Customer.WriteLog(1, ex);
}
};
#endregion
#region 数据表格事件
dgv_table.CellContentClick += delegate(object sender, DataGridViewCellEventArgs e)
{
try
{
if (e.ColumnIndex != 0)
{
return;
}
_qiList.Clear();
_tiList.Clear();
_eStatus = new DataSources.EnumStatus();
foreach (DataGridViewRow row in dgv_table.Rows)
{
if (!Convert.ToBoolean(row.Cells[0].EditedFormattedValue))
{
continue;
}
if (row.Cells["status"].EditedFormattedValue.ToString() == DataSources.EnumStatus.Start.GetDescription()) //表格中是启用
{
_qiList.Add(row.Cells["cust_id"].EditedFormattedValue.ToString());
}
else//表格中是停用
{
_tiList.Add(row.Cells["cust_id"].EditedFormattedValue.ToString());
}
}
BtnStatus(_qiList, _tiList);
}
catch (Exception ex)
{
LogService4Customer.WriteLog(1, ex);
}
};
dgv_table.HeadCheckChanged += delegate
{
try
{
_qiList.Clear();
_tiList.Clear();
_eStatus = new DataSources.EnumStatus();
foreach (DataGridViewRow row in dgv_table.Rows)
{
if (Convert.ToBoolean(row.Cells[0].Value))
{
if (row.Cells["status"].Value.ToString() == DataSources.EnumStatus.Start.GetDescription())//表格中是启用
{
_qiList.Add(row.Cells["cust_id"].Value.ToString());
}
else//表格中是停用
{
_tiList.Add(row.Cells["cust_id"].Value.ToString());
}
}
}
BtnStatus(_qiList, _tiList);
}
catch (Exception ex)
{
LogService4Customer.WriteLog(1, ex);
}
};
#endregion
#region 根据选择的数据判断功能按钮的显示状态
dgv_table.CellMouseUp += delegate
{
try
{
var dataView = UIAssistants.GetDataGridCheckRows(dgv_table, colCheck, cust_id, TableName);
if (dataView == null)
{
btnCopy.Enabled = false;
btnEdit.Enabled = false;
btnDelete.Enabled = false;
return;
}
var isYt = dataView.Cast <DataRowView>().Any(rowView => CommonCtrl.IsNullToString(rowView["data_source"]) == "2");
var listField = UIAssistants.GetDataGridCheckRows(dgv_table, colCheck, cust_id);
if (listField.Count == 0)
{
btnCopy.Enabled = false;
btnEdit.Enabled = false;
btnDelete.Enabled = false;
}
else
{
btnCopy.Enabled = true;
btnEdit.Enabled = true;
btnDelete.Enabled = true;
}
if (isYt)
{
btnEdit.Enabled = false;
btnDelete.Enabled = false;
}
}
catch (Exception ex)
{
LogService4Customer.WriteLog(1, ex);
}
};
#endregion
}
void UCReserveOrderQuery_ViewEvent(object sender, EventArgs e)
{
businessPrint.Preview(dgvRData.GetBoundData());
}
void UCVehicleManage_ViewEvent(object sender, EventArgs e)
{
businessPrint.Preview(dgvData.GetBoundData());
}
void UCOldPartsPalautusQueryManage_ViewEvent(object sender, EventArgs e)
{
businessPrint.Preview(dgvRData.GetBoundData());
}
void UCSaleOrderManager_ViewEvent(object sender, EventArgs e)
{
businessPrint.Preview(gvPurchaseOrderList.GetBoundData());
}
void UCRepairBalanceManager_ViewEvent(object sender, EventArgs e)
{
businessPrint.Preview(dgvRData.GetBoundData());
}
void UCPurchaseBillManangView_ViewEvent(object sender, EventArgs e)
{
if (tabControlEx1.SelectedIndex == 0)
{
printObject = "tb_pur_bill_s";
printTitle = "按采购开单查询";
businessPrint = new BusinessPrint(gvPurchaseOrderList, printObject, printTitle, paperSize, listNotPrint);
businessPrint.Preview(gvPurchaseOrderList.GetBoundData());
}
else if (tabControlEx1.SelectedIndex == 1)
{
printObject = "tb_pur_bill_search";
printTitle = "采购开按配件或供应商查询";
businessPrint = new BusinessPrint(gvPurchaseList2, printObject, printTitle, paperSize, listNotPrint);
businessPrint.Preview(gvPurchaseList2.GetBoundData());
}
}