/// <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);
}
}