/// <summary> /// 保存按钮事件 /// </summary> private void btnStnListSave_Click(object sender, EventArgs e) { try { if (!FrmMainDAO.QueryUserButtonPower(this.Name, this.Text, sender, true)) { return; } if (TableStnList.Rows.Count == 0 || bindingSource_StnList.Current == null) { return; } if (btnStnListSave.Text != "保存") { //DataRow headRow = ((DataRowView)bindingSource_StnList.Current).Row; //int autoIdInt = DataTypeConvert.GetInt(headRow["AutoId"]); //if (ssDAO.CheckStnList_IsModule(null, autoIdInt)) // return; Set_ButtonEditGrid_State(false); textEditStnNo.Focus(); } else { bindingSource_StnList.EndEdit(); DataRow headRow = ((DataRowView)bindingSource_StnList.Current).Row; if (textEditStnNo.Text.Trim() == "") { MessageHandler.ShowMessageBox("站号不能为空,请重新操作。"); textEditStnNo.Focus(); return; } string autoQuotationNoStr = btnEditAutoQuotationNo.Text; int ret = ssDAO.SaveStnSummaryList(autoQuotationNoStr, headRow, ref lastNewStnListAutoId); switch (ret) { case -1: break; case 1: break; case 0: return; } btnRefresh_Click(null, null); } } catch (Exception ex) { ExceptionHandler.HandleException(this.Text + "--保存按钮事件错误。", ex); } }
/// <summary> /// 查询任务进度信息 /// </summary> private void btnQueryTask_Click(object sender, EventArgs e) { try { if (!FrmMainDAO.QueryUserButtonPower(this.Name, this.Text, sender, true)) { return; } string projectNoStr = DataTypeConvert.GetString(searchLookUpProjectNo.EditValue) != "全部" ? DataTypeConvert.GetString(searchLookUpProjectNo.EditValue) : ""; string taskNoStr = searchLookUpRSTaskNo.Text.Trim() == "" ? "" : DataTypeConvert.GetString(searchLookUpRSTaskNo.EditValue); string projectUserStr = DataTypeConvert.GetString(searchLookUpRSProjectUser.EditValue) != "0" ? DataTypeConvert.GetString(searchLookUpRSProjectUser.EditValue) : ""; string commonStr = textCommon.Text.Trim(); dSRegisterSchedule.Tables[0].Rows.Clear(); taskSRDAO.QueryProjectPlanTask(dSRegisterSchedule.Tables[0], projectNoStr, taskNoStr, projectUserStr, commonStr, checkNoComplete.Checked, false); SetButtonAndColumnState(false); } catch (Exception ex) { ExceptionHandler.HandleException(this.Text + "--查询任务进度信息错误。", ex); } }
/// <summary> /// 设定付款类型信息 /// </summary> private void btnPayTypeList_Click(object sender, EventArgs e) { try { if (!FrmMainDAO.QueryUserButtonPower(this.Name, this.Text, sender, true)) { return; } if (!editForm.EditState) { DataRow dr = gridViewPayType.GetFocusedDataRow(); FrmPayTypeList ptList = new FrmPayTypeList(DataTypeConvert.GetString(dr["PayTypeNo"]), DataTypeConvert.GetString(dr["PayTypeNoText"])); ptList.ShowDialog(); } else { MessageHandler.ShowMessageBox(f.tsmiQxbchzjx.Text);// ("请先保存后再进行其他操作。"); } } catch (Exception ex) { ExceptionHandler.HandleException(this.Text + "--设定付款类型信息错误。", ex); } }
/// <summary> /// 取消按钮事件 /// </summary> private void btnCancel_Click(object sender, EventArgs e) { try { if (!FrmMainDAO.QueryUserButtonPower(this.Name, this.Text, sender, true)) return; if (bindingSource_SalesOrder.Current != null) { bindingSource_SalesOrder.CancelEdit(); ((DataRowView)bindingSource_SalesOrder.Current).Row.RejectChanges(); if (gridViewSalesOrder.GetFocusedDataRow() != null) gridViewSalesOrder.GetFocusedDataRow().RejectChanges(); Set_ButtonEditGrid_State(true); gridViewSalesOrder_FocusedRowChanged(null, null); } //if (gridViewSalesOrder.GetDataRow(headFocusedLineNo).RowState != DataRowState.Unchanged) //{ // if (DataTypeConvert.GetString(gridViewSalesOrder.GetDataRow(headFocusedLineNo)["AutoSalesOrderNo"]) == "") // { // gridViewSalesOrder.DeleteRow(headFocusedLineNo); // } // else // { // gridViewSalesOrder.GetFocusedDataRow().RejectChanges(); // } //} } catch (Exception ex) { ExceptionHandler.HandleException(this.Text + "--取消按钮事件错误。", ex); } }
/// <summary> /// 查询按钮事件 /// </summary> private void btnQuery_Click(object sender, EventArgs e) { try { if (!FrmMainDAO.QueryUserButtonPower(this.Name, this.Text, sender, true)) return; if (dateSalesOrderDateBegin.EditValue == null || dateSalesOrderDateEnd.EditValue == null) { MessageHandler.ShowMessageBox("登记日期不能为空,请设置后重新进行查询。"); if (dateSalesOrderDateBegin.EditValue == null) dateSalesOrderDateBegin.Focus(); else dateSalesOrderDateEnd.Focus(); return; } string recordDateBeginStr = dateSalesOrderDateBegin.DateTime.ToString("yyyy-MM-dd"); string recordDateEndStr = dateSalesOrderDateEnd.DateTime.AddDays(1).ToString("yyyy-MM-dd"); string bussinessBaseNoStr = DataTypeConvert.GetString(searchLookUpBussinessBaseNo.EditValue) != "全部" ? DataTypeConvert.GetString(searchLookUpBussinessBaseNo.EditValue) : ""; string commonStr = textCommon.Text.Trim(); dataSet_SalesOrder.Tables[0].Rows.Clear(); soDAO.QuerySalesOrder(dataSet_SalesOrder.Tables[0], recordDateBeginStr, recordDateEndStr, bussinessBaseNoStr, "", 0, commonStr, false); Set_ButtonEditGrid_State(true); } catch (Exception ex) { ExceptionHandler.HandleException(this.Text + "--查询按钮事件错误。", ex); } }
/// <summary> /// 修改供货明细事件 /// </summary> private void btnDDSave_Click(object sender, EventArgs e) { try { if (!FrmMainDAO.QueryUserButtonPower(this.Name, this.Text, sender, true)) { return; } if (dataSet_StnModule.Tables[0].Rows.Count == 0 || bindingSource_StnModule.Current == null) { return; } DataRow focusedRow = gridViewDeliveryDetail.GetFocusedDataRow(); if (focusedRow == null) { return; } string smNoStr = DataTypeConvert.GetString(gridViewStnModule.GetFocusedDataRow()["SMNo"]); int autoIdInt = DataTypeConvert.GetInt(focusedRow["AutoId"]); FrmDeliveryDetail ddForm = new FrmDeliveryDetail(); FrmDeliveryDetail.querySMNo = smNoStr; FrmDeliveryDetail.queryAutoIdInt = autoIdInt; ddForm.ShowDialog(); QueryDeliveryDetail(smNoStr); } catch (Exception ex) { ExceptionHandler.HandleException(this.Text + "--修改供货明细事件错误。", ex); } }
/// <summary> /// 新增按钮事件 /// </summary> private void btnNew_Click(object sender, EventArgs e) { try { if (!FrmMainDAO.QueryUserButtonPower(this.Name, this.Text, sender, true)) { return; } DataRow baseRow = TableStnModule.NewRow(); TableStnModule.Rows.Add(baseRow); bindingSource_StnModule.MoveLast(); ColumnView headView = (ColumnView)gridControlStnModule.FocusedView; gridViewStnModule.FocusedRowHandle = headView.FocusedRowHandle; copyRow = null; Set_ButtonEditGrid_State(false); textFunctionDesc.Focus(); QueryDeliveryDetail(""); } catch (Exception ex) { ExceptionHandler.HandleException(this.Text + "--新增按钮事件错误。", ex); } }
/// <summary> /// 新增按钮事件 /// </summary> private void btnNew_Click(object sender, EventArgs e) { try { if (!FrmMainDAO.QueryUserButtonPower(this.Name, this.Text, sender, true)) { return; } TableQuotationBaseInfo.Rows.Clear(); DataRow baseRow = TableQuotationBaseInfo.NewRow(); TableQuotationBaseInfo.Rows.Add(baseRow); bindingSource_BaseInfo.MoveLast(); TableQuotationPriceInfo.Clear(); //gridViewQuotationPriceInfo.AddNewRow(); DataRow priceRow = TableQuotationPriceInfo.NewRow(); TableQuotationPriceInfo.Rows.Add(priceRow); FocusedListView(false, "CurrencyCate", gridViewQuotationPriceInfo.GetFocusedDataSourceRowIndex()); gridViewQuotationPriceInfo.RefreshData(); Set_ButtonEditGrid_State(false); textRFQNO.Focus(); } catch (Exception ex) { ExceptionHandler.HandleException(this.Text + "--新增按钮事件错误。", ex); } }
/// <summary> /// 取消按钮事件 /// </summary> private void btnCancel_Click(object sender, EventArgs e) { try { if (!FrmMainDAO.QueryUserButtonPower(this.Name, this.Text, sender, true)) { return; } if (TableQuotationBaseInfo.Rows.Count == 0 || bindingSource_BaseInfo.Current == null) { return; } if (bindingSource_BaseInfo.Current != null) { bindingSource_BaseInfo.CancelEdit(); ((DataRowView)bindingSource_BaseInfo.Current).Row.RejectChanges(); btnRefresh_Click(null, null); } } catch (Exception ex) { ExceptionHandler.HandleException(this.Text + "--取消按钮事件错误。", ex); } }
/// <summary> /// 查询按钮事件 /// </summary> private void btnRefresh_Click(object sender, EventArgs e) { try { if (!FrmMainDAO.QueryUserButtonPower(this.Name, this.Text, sender, true)) { return; } dSWorkFlow.Tables[0].Clear(); if (currentAutoIdInt != 0) { wfEditDAO.QueryWorkFlow(dSWorkFlow.Tables[0], currentAutoIdInt); } else { wfEditDAO.QueryWorkFlow_LastOne(dSWorkFlow.Tables[0]); if (dSWorkFlow.Tables[0].Rows.Count > 0) { currentAutoIdInt = DataTypeConvert.GetInt(dSWorkFlow.Tables[0].Rows[0]["AutoId"]); } } QueryWorkFlowAllInfo(); Set_ButtonAndControl_State(true); } catch (Exception ex) { ExceptionHandler.HandleException(this.Text + "--查询按钮事件错误。", ex); } }
/// <summary> /// 查询下一条信息事件 /// </summary> private void btnDown_Click(object sender, EventArgs e) { try { if (!FrmMainDAO.QueryUserButtonPower(this.Name, this.Text, sender, true)) { return; } DataTable tmpTable = new DataTable(); wfEditDAO.QueryWorkFlow_DownOne(tmpTable, currentAutoIdInt); if (tmpTable.Rows.Count > 0) { dSWorkFlow.Tables[0].Rows.Clear(); dSWorkFlow.Tables[0].ImportRow(tmpTable.Rows[0]); currentAutoIdInt = DataTypeConvert.GetInt(tmpTable.Rows[0]["AutoId"]); QueryWorkFlowAllInfo(); Set_ButtonAndControl_State(true); } } catch (Exception ex) { ExceptionHandler.HandleException(this.Text + "--查询下一条信息事件错误。", ex); } }
/// <summary> /// 清空执行人 /// </summary> private void btnClearArrangement_Click(object sender, EventArgs e) { try { if (!FrmMainDAO.QueryUserButtonPower(this.Name, this.Text, sender, true)) { return; } int[] rowint = gridViewPrReqList.GetSelectedRows(); if (rowint.Length == 0) { MessageHandler.ShowMessageBox("请先选择要设定的请购明细记录。"); return; } List <int> autoIdList = new List <int>(); foreach (int i in rowint) { autoIdList.Add(DataTypeConvert.GetInt(gridViewPrReqList.GetDataRow(i)["AutoId"])); } if (prReqDAO.ClearArrangement(autoIdList)) { MessageHandler.ShowMessageBox(string.Format("清空{0}条请购明细记录的执行人成功。", autoIdList.Count)); btnQuery_Click(null, null); } } catch (Exception ex) { ExceptionHandler.HandleException(this.Text + "--设定执行人错误。", ex); } }
/// <summary> /// 查询按钮事件 /// </summary> private void btnQuery_Click(object sender, EventArgs e) { try { if (!FrmMainDAO.QueryUserButtonPower(this.Name, this.Text, sender, true)) { return; } string projectNoStr = searchLookUpProjectNo.Text != "全部" ? DataTypeConvert.GetString(searchLookUpProjectNo.EditValue) : ""; //string codeFileNameStr = searchLookUpCodeFileName.Text != "全部" ? DataTypeConvert.GetString(searchLookUpCodeFileName.EditValue) : ""; int codeIdInt = DataTypeConvert.GetInt(searchLookUpCodeFileName.EditValue); int creatorInt = DataTypeConvert.GetInt(searchLookUpCreator.EditValue); string commonStr = textCommon.Text.Trim(); dataSet_DesignBom.Tables[0].Rows.Clear(); string querySqlStr = bomDAO.Query_DesignBomList_SQL(projectNoStr, codeIdInt, checkIsUse.Checked, creatorInt, commonStr, false); lastQuerySqlStr = querySqlStr; string countSqlStr = commonDAO.QuerySqlTranTotalCountSql(querySqlStr); gridBottomOrderHead.QueryGridData(ref dataSet_DesignBom, "DesignBom", querySqlStr, countSqlStr, true); } catch (Exception ex) { ExceptionHandler.HandleException(this.Text + "--查询按钮事件错误。", ex); } }
/// <summary> /// 查询用户流程信息 /// </summary> private void btnQuery_Click(object sender, EventArgs e) { try { if (!FrmMainDAO.QueryUserButtonPower(this.Name, this.Text, sender, true)) { return; } dataSet_UserWF.Tables[0].Rows.Clear(); userWFDAO.QueryUserWorkFlow(dataSet_UserWF.Tables[0]); PageHandle.Text = string.Format("待处理信息 ({0})", dataSet_UserWF.Tables[0].Rows.Count); dataSet_Reject.Tables[0].Rows.Clear(); userWFDAO.QueryRejectOrder(dataSet_Reject.Tables[0]); PageReject.Text = string.Format("被拒绝信息 ({0})", dataSet_Reject.Tables[0].Rows.Count); if (dataSet_Reject.Tables[0].Rows.Count > 0 && dataSet_UserWF.Tables[0].Rows.Count == 0) { xtraTabCtl.SelectedTabPageIndex = 1; } else { xtraTabCtl.SelectedTabPageIndex = 0; } } catch (Exception ex) { ExceptionHandler.HandleException(this.Text + "--查询用户流程信息错误。", ex); } }
/// <summary> /// 新增按钮事件 /// </summary> private void btnNew_Click(object sender, EventArgs e) { try { if (!FrmMainDAO.QueryUserButtonPower(this.Name, this.Text, sender, true)) { return; } DataRow baseRow = TableQuotationBaseInfo.NewRow(); TableQuotationBaseInfo.Rows.Add(baseRow); bindingSource_BaseInfo.MoveLast(); ColumnView headView = (ColumnView)gridControlQuotation.FocusedView; gridViewQuotation.FocusedRowHandle = headView.FocusedRowHandle; TableCORInfo.Rows.Clear(); PageCORInfo.PageVisible = false; xtraTabBottom.SelectedTabPageIndex = 0; TableQuotationPriceInfo.Clear(); //gridViewQuotationPriceInfo.AddNewRow(); DataRow priceRow = TableQuotationPriceInfo.NewRow(); TableQuotationPriceInfo.Rows.Add(priceRow); FocusedListView(false, "CurrencyCate", gridViewQuotationPriceInfo.GetFocusedDataSourceRowIndex()); gridViewQuotationPriceInfo.RefreshData(); Set_ButtonEditGrid_State(false); textRFQNO.Focus(); } catch (Exception ex) { ExceptionHandler.HandleException(this.Text + "--新增按钮事件错误。", ex); } }
/// <summary> /// 修改生产计划信息 /// </summary> private void btnAlterPSBom_Click(object sender, EventArgs e) { try { if (!FrmMainDAO.QueryUserButtonPower(this.Name, this.Text, sender, true)) { return; } DataRow dr = gridViewPSBom.GetFocusedDataRow(); if (dr == null) { MessageHandler.ShowMessageBox("请选择要修改的生产计划Bom信息。"); return; } if (DataTypeConvert.GetString(dr["PrReqNo"]) != "") { MessageHandler.ShowMessageBox("当前修改的生产计划信息已经生成请购单,不可以进行操作。"); return; } FrmProductionScheduleBom_InputSingle.bomListAutoId = DataTypeConvert.GetInt(dr["BomListAutoId"]); FrmProductionScheduleBom_InputSingle.psBomAutoId = DataTypeConvert.GetInt(dr["AutoId"]); FrmProductionScheduleBom_InputSingle psBomForm = new FrmProductionScheduleBom_InputSingle(); if (psBomForm.ShowDialog() == DialogResult.OK) { RefreshPSBomInfo(); } } catch (Exception ex) { ExceptionHandler.HandleException(this.Text + "--双击查询明细错误。", ex); } }
/// <summary> /// 取消关闭报价单 /// </summary> private void btnRecover_Click(object sender, EventArgs e) { try { if (!FrmMainDAO.QueryUserButtonPower(this.Name, this.Text, sender, true)) { return; } if (TableQuotationBaseInfo.Rows.Count == 0 || bindingSource_BaseInfo.Current == null) { MessageHandler.ShowMessageBox("当前没有报价信息记录,不能进行取消关闭。"); return; } if (!CheckState(true, false)) { return; } DataRow headRow = ((DataRowView)bindingSource_BaseInfo.Current).Row; string autoQuotationNoStr = DataTypeConvert.GetString(headRow["AutoQuotationNo"]); if (MessageHandler.ShowMessageBox_YesNo("确定要取消关闭当前选中的记录吗?") != DialogResult.Yes) { return; } quoDAO.RecoverQuotationInfo(headRow, autoQuotationNoStr); gridViewQuotation_FocusedRowChanged(null, null); } catch (Exception ex) { ExceptionHandler.HandleException(this.Text + "--取消关闭报价单错误。", ex); } }
/// <summary> /// 查询结果存为Excel /// </summary> private void btnSaveExcel_Click(object sender, EventArgs e) { try { if (!FrmMainDAO.QueryUserButtonPower(this.Name, this.Text, sender, true)) { return; } //FileHandler.SaveDevGridControlExportToExcel(gridViewSalesOrder); //int result = new CustomXtraMessageBoxForm().ShowMessageBox("请选择要存为 Excel 的查询记录:", new string[] { "当前页面记录", "全部查询记录", "取消" }); //MessageHandler.ShowMessageBox(result.ToString()); if (gridBottomOrderHead.pageCount <= 1) { FileHandler.SaveDevGridControlExportToExcel(gridViewSalesOrder); } else { commonDAO.SaveExcel_QueryAllData(dataSet_SalesOrder.Tables[0], lastQuerySqlStr, gridViewSalesOrder); } } catch (Exception ex) { ExceptionHandler.HandleException(this.Text + "--查询结果存为Excel错误。", ex); } }
/// <summary> /// 删除供货明细事件 /// </summary> private void btnDDDelete_Click(object sender, EventArgs e) { try { if (!FrmMainDAO.QueryUserButtonPower(this.Name, this.Text, sender, true)) { return; } if (dataSet_StnModule.Tables[0].Rows.Count == 0 || bindingSource_StnModule.Current == null) { return; } DataRow focusedRow = gridViewDeliveryDetail.GetFocusedDataRow(); if (focusedRow == null) { return; } string smNoStr = DataTypeConvert.GetString(gridViewStnModule.GetFocusedDataRow()["SMNo"]); int autoIdInt = DataTypeConvert.GetInt(focusedRow["AutoId"]); if (MessageHandler.ShowMessageBox_YesNo("确定要删除当前选中的供货明细吗?") != DialogResult.Yes) { return; } if (new FrmDeliveryDetailDAO().DeleteDeliveryDetail(autoIdInt)) { MessageHandler.ShowMessageBox("删除供货明细成功。"); QueryDeliveryDetail(smNoStr); } } catch (Exception ex) { ExceptionHandler.HandleException(this.Text + "--删除供货明细事件错误。", ex); } }
/// <summary> /// 保存公司信息 /// </summary> private void BtnSave_Click(object sender, EventArgs e) { try { if (!FrmMainDAO.QueryUserButtonPower(this.Name, this.Text, sender, true)) { return; } bindingSource_CompanyInfo.EndEdit(); DataRow headRow = ((DataRowView)bindingSource_CompanyInfo.Current).Row; if (companyDAO.SaveCompanyInfo(headRow)) { MessageHandler.ShowMessageBox("保存公司信息成功。"); QueryCompanyInfo(); companyDAO.RefreshCompanyInfo(); } else { MessageHandler.ShowMessageBox("保存失败。"); } } catch (Exception ex) { ExceptionHandler.HandleException(this.Text + "--保存系统设定错误。", ex); } }
/// <summary> /// 取消按钮事件 /// </summary> private void btnCancel_Click(object sender, EventArgs e) { try { if (!FrmMainDAO.QueryUserButtonPower(this.Name, this.Text, sender, true)) { return; } if (bindingSource_StnModule.Current != null) { bindingSource_StnModule.CancelEdit(); ((DataRowView)bindingSource_StnModule.Current).Row.RejectChanges(); if (gridViewStnModule.GetFocusedDataRow() != null) { gridViewStnModule.GetFocusedDataRow().RejectChanges(); } if (copyRow != null) { copyRow = null; } Set_ButtonEditGrid_State(true); gridViewStnModule_FocusedRowChanged(null, null); } } catch (Exception ex) { ExceptionHandler.HandleException(this.Text + "--取消按钮事件错误。", ex); } }
/// <summary> /// 查询按钮事件 /// </summary> private void btnQuery_Click(object sender, EventArgs e) { try { if (!FrmMainDAO.QueryUserButtonPower(this.Name, this.Text, sender, true)) { return; } int repertoryIdInt = lookUpRepertoryId.ItemIndex > 0 ? DataTypeConvert.GetInt(lookUpRepertoryId.EditValue) : 0; int locationIdInt = DataTypeConvert.GetInt(SearchLocationId.EditValue); //string codeFileNameStr = searchLookUpCodeFileName.Text != "全部" ? DataTypeConvert.GetString(searchLookUpCodeFileName.EditValue) : ""; int codeIdInt = DataTypeConvert.GetInt(searchLookUpCodeFileName.EditValue); string projectNameStr = searchLookUpProjectNo.Text != "全部" ? searchLookUpProjectNo.Text : ""; int ShelfIdInt = searchLookUpShelfId.Text != "全部" ? DataTypeConvert.GetInt(searchLookUpShelfId.EditValue) : 0; string commonStr = textCommon.Text.Trim(); string querySqlStr = wNowInfoDAO.QueryWarehouseNowInfo_SQL(codeIdInt, repertoryIdInt, locationIdInt, projectNameStr, ShelfIdInt, commonStr, !checkZero.Checked); lastQuerySqlStr = querySqlStr; string countSqlStr = commonDAO.QuerySqlTranTotalCountSql(querySqlStr); gridBottomWNowInfo.QueryGridData(ref dataSet_WNowInfo, "WNowInfo", querySqlStr, countSqlStr, true); } catch (Exception ex) { //ExceptionHandler.HandleException(this.Text + "--查询按钮事件错误。", ex); ExceptionHandler.HandleException(this.Text + "--" + f.tsmiCxansjcw.Text, ex); } }
/// <summary> /// COR生成新的报价单 /// </summary> private void BtnCOR_Click(object sender, EventArgs e) { try { if (!FrmMainDAO.QueryUserButtonPower(this.Name, this.Text, sender, true)) return; if (TableSalesOrder.Rows.Count == 0 || bindingSource_SalesOrder.Current == null) { MessageHandler.ShowMessageBox("请选择要生成COR的销售订单。"); return; } DataRow headRow = ((DataRowView)bindingSource_SalesOrder.Current).Row; string parentAutoSalesOrderNoStr = DataTypeConvert.GetString(headRow["ParentAutoSalesOrderNo"]); if (parentAutoSalesOrderNoStr != "") { MessageHandler.ShowMessageBox("当前销售订单就是COR订单,不能再生成COR报价单。"); return; } FrmQuotationInfo_History.newParentAutoQuotationNoStr = DataTypeConvert.GetString(headRow["AutoQuotationNo"]); FrmQuotationInfo_History.newParentAutoSalesOrderNoStr = DataTypeConvert.GetString(headRow["AutoSalesOrderNo"]); FrmQuotationInfo_History.newParentProjectNoStr = DataTypeConvert.GetString(headRow["ProjectNo"]); ViewHandler.ShowRightWindow("FrmQuotationInfo_History"); } catch (Exception ex) { ExceptionHandler.HandleException(this.Text + "--COR生成新的报价单错误。", ex); } }
/// <summary> /// 设定默认类型 /// </summary> private void btnSetDefault_Click(object sender, EventArgs e) { try { if (!FrmMainDAO.QueryUserButtonPower(this.Name, this.Text, sender, true)) { return; } if (!editForm.EditState) { DataRow dr = gridViewWarehouseReceiptType.GetFocusedDataRow(); if (dr != null) { if (wwDAO.Update_WarehouseType_Default(DataTypeConvert.GetString(dr["WarehouseReceiptTypeNo"]), "BS_WarehouseReceiptType", "WarehouseReceiptTypeNo", "出库类别")) { MessageHandler.ShowMessageBox(tsmiSdmrcklbcg.Text);// ("设定默认出库类别成功。"); editForm.btnRefresh_Click(null, null); } } } else { MessageHandler.ShowMessageBox(f.tsmiQxbchzjx.Text);// ("请先保存后再进行其他操作。"); } } catch (Exception ex) { //ExceptionHandler.HandleException(this.Text + "--设定默认类型事件错误。", ex); ExceptionHandler.HandleException(this.Text + "--" + f.tsmiSdmrlxsjcw.Text, ex); } }
/// <summary> /// 查询结果存为Excel /// </summary> private void btnSaveExcel_Click(object sender, EventArgs e) { try { if (!FrmMainDAO.QueryUserButtonPower(this.Name, this.Text, sender, true)) { return; } //FileHandler.SaveDevGridControlExportToExcel(gridViewSettlementHead); if (gridBottomOrderHead.pageCount <= 1) { FileHandler.SaveDevGridControlExportToExcel(gridViewSettlementHead); } else { commonDAO.SaveExcel_QueryAllData(dataSet_Settlement.Tables[0], lastQuerySqlStr, gridViewSettlementHead); } } catch (Exception ex) { //ExceptionHandler.HandleException(this.Text + "--查询结果存为Excel错误。", ex); ExceptionHandler.HandleException(this.Text + "--" + tsmiCxjgcw.Text, ex); } }
/// <summary> /// 批量修改零件信息 /// </summary> private void btnMultiUpdate_Click(object sender, EventArgs e) { try { if (!FrmMainDAO.QueryUserButtonPower(this.Name, this.Text, sender, true)) { return; } FrmPartsCode_MultiUpdate multiUpdateForm = new FrmPartsCode_MultiUpdate(); multiUpdateForm.partsCodeTable = TablePartsCode; multiUpdateForm.typeInt = 2; if (multiUpdateForm.ShowDialog() == DialogResult.OK) { lastQueryWhereSqlStr = multiUpdateForm.queryWhereSqlStr; editForm.Sql = pcDAO.GetQueryPartsCodeSQL_WhereSQL(lastQueryWhereSqlStr); editForm.btnRefresh_Click(null, null); editForm.Sql = pcDAO.GetQueryPartsCodeSQL_Standard(); } } catch (Exception ex) { ExceptionHandler.HandleException(this.Text + "--批量修改零件信息错误。", ex); } }
/// <summary> /// 设定项目人员信息 /// </summary> private void btnSetProjectUser_Click(object sender, EventArgs e) { try { if (!FrmMainDAO.QueryUserButtonPower(this.Name, this.Text, sender, true)) { return; } if (DataTypeConvert.GetString(searchLookUpProjectNo.EditValue) == "") { MessageHandler.ShowMessageBox("请先选择要配置的项目号。"); searchLookUpProjectNo.Focus(); return; } FrmSelectUserList userList = new FrmSelectUserList(); FrmSelectUserList.SelectUserAutoIdList.Clear(); for (int i = 0; i < gridViewProjectUser.DataRowCount; i++) { FrmSelectUserList.SelectUserAutoIdList.Add(DataTypeConvert.GetInt(gridViewProjectUser.GetDataRow(i)["UserId"])); } if (userList.ShowDialog() == DialogResult.OK) { string projectNoStr = DataTypeConvert.GetString(searchLookUpProjectNo.EditValue); taskTypeDAO.SaveProjectUser(projectNoStr, userList.OkSelectUserAutoIdList); RefreshProjectUser(projectNoStr); } } catch (Exception ex) { ExceptionHandler.HandleException(this.Text + "--设定项目人员信息错误。", ex); } }
/// <summary> /// 新增按钮事件 /// </summary> private void btnNew_Click(object sender, EventArgs e) { try { if (!FrmMainDAO.QueryUserButtonPower(this.Name, this.Text, sender, true)) { return; } ClearHeadGridAllSelect(); //gridViewPrReqHead.PostEditor(); gridViewPSchedule.AddNewRow(); FocusedHeadView("CodeFileName"); dataSet_PSchedule.Tables[1].Clear(); //gridViewPScheduleBOM.AddNewRow(); //FocusedListView(false, "CodeFileName", gridViewPScheduleBOM.GetFocusedDataSourceRowIndex()); //gridViewPScheduleBOM.RefreshData(); SetButtonAndColumnState(true); headFocusedLineNo = gridViewPSchedule.DataRowCount; } catch (Exception ex) { ExceptionHandler.HandleException(this.Text + "--新增按钮事件错误。", ex); } }
/// <summary> /// 增加当前选中设计Bom信息数量 /// </summary> private void btnAdd_Click(object sender, EventArgs e) { try { if (!FrmMainDAO.QueryUserButtonPower(this.Name, this.Text, sender, true)) { return; } TreeListNode focusedNode = OperateDesignBomCheck(); if (focusedNode == null) { return; } if (DataTypeConvert.GetInt(focusedNode["IsUse"]) == 0) { MessageHandler.ShowMessageBox("当前选中的设计Bom信息已经停用,不可以操作。"); return; } Dictionary <int, string> codeIdList = new Dictionary <int, string>(); codeIdList.Add(DataTypeConvert.GetInt(focusedNode["CodeId"]), DataTypeConvert.GetString(focusedNode["CodeFileName"])); float qty = FrmPBDesignBom_InputNumber.Show_FrmPBDesignBom_InputNumber("输入增加数量", "增加数量", 1, salesOrderNoStr, codeIdList, false); if (qty != 0) { bomDAO.SaveDesignBom(salesOrderNoStr, codeIdList, qty); RefreshDesignBomInfo(focusedNode); } } catch (Exception ex) { ExceptionHandler.HandleException(this.Text + "--增加当前选中设计Bom信息数量错误。", ex); } }
/// <summary> /// 新增按钮事件 /// </summary> private void btnStnListNew_Click(object sender, EventArgs e) { try { if (!FrmMainDAO.QueryUserButtonPower(this.Name, this.Text, sender, true)) { return; } if (btnEditAutoQuotationNo.Text.Trim() == "") { MessageHandler.ShowMessageBox("请先查询报价单号,确定要操作的报价单,再进行工位信息登记。"); return; } //TableStnList.Rows.Clear(); DataRow baseRow = TableStnList.NewRow(); TableStnList.Rows.Add(baseRow); bindingSource_StnList.MoveLast(); Set_ButtonEditGrid_State(false); textEditStnNo.Focus(); } catch (Exception ex) { ExceptionHandler.HandleException(this.Text + "--新增按钮事件错误。", ex); } }