/// <summary> /// 窗体加载事件 /// </summary> private void FrmProductionSchedule_Load(object sender, EventArgs e) { try { //ControlHandler.DevExpressStyle_ChangeControlLocation(checkAll.LookAndFeel.ActiveSkinName, new List<Control> { checkAll }); DateTime nowDate = BaseSQL.GetServerDateTime(); dateCurrentDateBegin.DateTime = nowDate.Date.AddDays(-SystemInfo.OrderQueryDate_DateIntervalDays); dateCurrentDateEnd.DateTime = nowDate.Date; datePlanDateBegin.DateTime = nowDate.Date; datePlanDateEnd.DateTime = nowDate.Date.AddDays(SystemInfo.OrderQueryDate_DateIntervalDays); checkPlanDate.Checked = false; searchLookUpCodeFileName.Properties.DataSource = commonDAO.QueryPartsCode(true); searchLookUpCodeFileName.Text = "全部"; comboBoxReqState.SelectedIndex = 0; ControlCommonInit ctlInit = new ControlCommonInit(); ctlInit.SearchLookUpEdit_UserInfo_ValueMember_EmpName(searchLookUpPrepared); searchLookUpPrepared.EditValue = SystemInfo.user.EmpName; repSearchCodeFileName.DataSource = commonDAO.QueryPartsCode(false); if (textCommon.Text == "") { psDAO.QueryProductionSchedule(dataSet_PSchedule.Tables[0], "", "", "", "", "", 0, "", -1, "", true); psDAO.QueryProductionScheduleBom(dataSet_PSchedule.Tables[1], "", true); } } catch (Exception ex) { ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex); } }
/// <summary> /// 窗体加载事件 /// </summary> private void FrmInventoryAdjustments_Load(object sender, EventArgs e) { try { ControlHandler.DevExpressStyle_ChangeControlLocation(btnListAdd.LookAndFeel.ActiveSkinName, new List <Control> { btnListAdd, checkAll }); DateTime nowDate = BaseSQL.GetServerDateTime(); dateIADateBegin.DateTime = nowDate.Date.AddDays(-SystemInfo.OrderQueryDate_DefaultDays); dateIADateEnd.DateTime = nowDate.Date; DataTable repertoryTable = commonDAO.QueryRepertoryInfo(false); DataTable repertoryAddAllTable = commonDAO.QueryRepertoryInfo(true); DataTable projectListAddAllTable = commonDAO.QueryProjectList(true); lookUpAdjustmentsRepertoryNo.Properties.DataSource = repertoryAddAllTable; lookUpAdjustmentsRepertoryNo.ItemIndex = 0; lookUpReqDep.Properties.DataSource = commonDAO.QueryDepartment(true); lookUpReqDep.ItemIndex = 0; lookUpPrepared.Properties.DataSource = commonDAO.QueryUserInfo(true); lookUpPrepared.EditValue = SystemInfo.user.EmpName; searchAdjustmentsProjectNo.Properties.DataSource = projectListAddAllTable; searchAdjustmentsProjectNo.Text = "全部"; repLookUpInRepertoryNo.DataSource = repertoryTable; repSearchAdjustmentsProjectNo.DataSource = commonDAO.QueryProjectList(false); repLookUpReqDep.DataSource = commonDAO.QueryDepartment(false); repSearchCodeFileName.DataSource = commonDAO.QueryPartsCode(false); repSearchOutShelfNo.DataSource = commonDAO.QueryShelfInfo(false); lookUpRepertoryNo.Properties.DataSource = repertoryAddAllTable; lookUpRepertoryNo.ItemIndex = 0; searchLookUpProjectNo.Properties.DataSource = projectListAddAllTable; searchLookUpProjectNo.Text = "全部"; searchLookUpCodeFileName.Properties.DataSource = commonDAO.QueryPartsCode(true); searchLookUpCodeFileName.Text = "全部"; repLookUpRepertoryNo.DataSource = repertoryTable; if (textCommon.Text == "") { iaDAO.QueryInventoryAdjustmentsHead(dataSet_IA.Tables[0], "", "", "", "", "", "", "", true); iaDAO.QueryInventoryAdjustmentsList(dataSet_IA.Tables[1], "", true); } } catch (Exception ex) { //ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex); ExceptionHandler.HandleException(this.Text + "--" + f.tsmiCtjzsjcw.Text, ex); } }
/// <summary> /// 窗体加载事件 /// </summary> private void FrmPrReqListDistributionQuery_Load(object sender, EventArgs e) { try { ControlCommonInit ctlInit = new ControlCommonInit(); ctlInit.SearchLookUpEdit_UserInfo_ValueMember_AutoId(searchLookUpArrangement); searchLookUpArrangement.EditValue = SystemInfo.user.AutoId; repLookUpCodeName.DataSource = commonDAO.QueryPartsCode(false); repLookUpOperator.DataSource = searchLookUpArrangement.Properties.DataSource; //if (!SystemInfo.PrListDistributionAllHandle) //{ // pnlTop.Visible = false; //} if (SystemInfo.DisableProjectNo) { colProjectNo.Visible = false; colStnNo.Visible = false; } btnQuery_Click(null, null); } catch (Exception ex) { ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex); } }
/// <summary> /// 窗体加载事件 /// </summary> private void FrmPrReqList_Overplus_Load(object sender, EventArgs e) { try { DateTime nowDate = BaseSQL.GetServerDateTime(); dateReqDateBegin.DateTime = nowDate.Date.AddDays(-SystemInfo.OrderQueryDate_DefaultDays); dateReqDateEnd.DateTime = nowDate.Date; lookUpReqDep.Properties.DataSource = commonDAO.QueryDepartment(true); lookUpReqDep.ItemIndex = 0; lookUpPurCategory.Properties.DataSource = commonDAO.QueryPurCategory(true); lookUpPurCategory.ItemIndex = 0; searchLookUpProjectNo.Properties.DataSource = commonDAO.QueryProjectList(true); searchLookUpProjectNo.Text = "全部"; searchLookUpCodeFileName.Properties.DataSource = commonDAO.QueryPartsCode(true); searchLookUpCodeFileName.Text = "全部"; comboBoxReqState.SelectedIndex = 0; repLookUpReqDep.DataSource = commonDAO.QueryDepartment(false); repLookUpPurCategory.DataSource = commonDAO.QueryPurCategory(false); repLookUpProjectNo.DataSource = commonDAO.QueryProjectList(false); gridBottomPrReq.pageRowCount = SystemInfo.OrderQueryGrid_PageRowCount; btnQuery_Click(null, null); } catch (Exception ex) { //ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex); ExceptionHandler.HandleException(this.Text + "--" + tsmiCt.Text, ex); } }
/// <summary> /// 窗体加载事件 /// </summary> private void FrmBomImport_Load(object sender, EventArgs e) { try { repSearchCodeFileName.DataSource = commonDAO.QueryPartsCode(false); } catch (Exception ex) { ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex); } }
/// <summary> /// 窗体加载事件 /// </summary> private void FrmBomPositiveExpand_Load(object sender, EventArgs e) { try { searchCodeFileName.Properties.DataSource = commonDAO.QueryPartsCode(false); } catch (Exception ex) { //ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex); ExceptionHandler.HandleException(this.Text + "--" + tsmiCtjzsj.Text, ex); } }
/// <summary> /// 窗体加载事件 /// </summary> private void FrmWarehouseNowInfo_Bom_Load(object sender, EventArgs e) { try { searchCodeFileName.Properties.DataSource = commonDAO.QueryPartsCode(false); lookUpRepertoryNo.Properties.DataSource = commonDAO.QueryRepertoryInfo(true); lookUpRepertoryNo.ItemIndex = 0; } catch (Exception ex) { ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex); } }
/// <summary> /// 窗体加载事件 /// </summary> private void FrmBomManagement_Load(object sender, EventArgs e) { try { ControlHandler.DevExpressStyle_ChangeControlLocation(btnListAdd.LookAndFeel.ActiveSkinName, new List <Control> { btnListAdd }); searchPartsCodeId.Properties.DataSource = commonDAO.QueryPartsCode(false); lookUpMaterieState.Properties.DataSource = bomDAO.QueryBomMaterieState(false); repSearchCodeFileName.DataSource = commonDAO.QueryPartsCode(false); searchCodeFileName.Properties.DataSource = commonDAO.QueryPartsCode(false); //RefreshTreeList(); Set_ButtonEditGrid_State(true, null); } catch (Exception ex) { //ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex); ExceptionHandler.HandleException(this.Text + "--" + f.tsmiCtjzsjcw.Text, ex); } }
/// <summary> /// 窗体加载事件 /// </summary> private void FrmWarehouseReceipt_Load(object sender, EventArgs e) { try { ControlHandler.DevExpressStyle_ChangeControlLocation(btnListAdd.LookAndFeel.ActiveSkinName, new List <Control> { btnListAdd, checkAll }); DateTime nowDate = BaseSQL.GetServerDateTime(); dateWRDateBegin.DateTime = nowDate.Date.AddDays(-SystemInfo.OrderQueryDate_DefaultDays); dateWRDateEnd.DateTime = nowDate.Date; lookUpReqDep.Properties.DataSource = commonDAO.QueryDepartment(true); lookUpReqDep.ItemIndex = 0; lookUpRepertoryNo.Properties.DataSource = commonDAO.QueryRepertoryInfo(true); lookUpRepertoryNo.ItemIndex = 0; lookUpWarehouseReceiptTypeNo.Properties.DataSource = wrDAO.QueryWarehouseReceiptType(true); lookUpWarehouseReceiptTypeNo.ItemIndex = 0; comboBoxWarehouseState.SelectedIndex = 0; lookUpPrepared.Properties.DataSource = commonDAO.QueryUserInfo(true); lookUpPrepared.EditValue = SystemInfo.user.EmpName; lookUpApprover.Properties.DataSource = commonDAO.QueryUserInfo(true); lookUpApprover.ItemIndex = -1; lookUpManufactureNo.Properties.DataSource = wrDAO.QueryManufactureInfo(true); lookUpManufactureNo.ItemIndex = 0; repLookUpReqDep.DataSource = commonDAO.QueryDepartment(false); repLookUpRepertoryNo.DataSource = commonDAO.QueryRepertoryInfo(false); repLookUpWRTypeNo.DataSource = wrDAO.QueryWarehouseReceiptType(false); repLookUpApprovalType.DataSource = commonDAO.QueryApprovalType(false); repLookUpManufactureNo.DataSource = wrDAO.QueryManufactureInfo(false); repSearchCodeFileName.DataSource = commonDAO.QueryPartsCode(false); repSearchShelfId.DataSource = commonDAO.QueryShelfInfo(false); repSearchProjectNo.DataSource = commonDAO.QueryProjectList(false); if (textCommon.Text == "") { wrDAO.QueryWarehouseReceiptHead(dataSet_WR.Tables[0], "", "", "", "", "", "", 0, "", -1, "", true); wrDAO.QueryWarehouseReceiptList(dataSet_WR.Tables[1], "", true); } } catch (Exception ex) { //ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex); ExceptionHandler.HandleException(this.Text + "--" + f.tsmiCtjzsjcw.Text, ex); } }
/// <summary> /// 窗体加载事件 /// </summary> private void FrmPBBomManagement_Load(object sender, EventArgs e) { try { searchCodeFileName.Properties.DataSource = commonDAO.QueryPartsCode(false); lookUpCatgName.Properties.DataSource = commonDAO.QueryPartNoCatg(true); lookUpCatgName.ItemIndex = 0; lookUpBrand.Properties.DataSource = commonDAO.QueryBrandCatg(true); lookUpBrand.ItemIndex = 0; btnEditAutoSalesOrderNo.Focus(); btnEditAutoSalesOrderNo.SelectAll(); } catch (Exception ex) { ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex); } }
/// <summary> /// 窗体加载事件 /// </summary> private void FrmOrderList_NoWarehousing_Days_Load(object sender, EventArgs e) { try { DateTime nowDate = BaseSQL.GetServerDateTime(); dateOrderDateBegin.DateTime = nowDate.Date.AddDays(-SystemInfo.OrderQueryDate_DefaultDays); dateOrderDateEnd.DateTime = nowDate.Date; datePlanDateBegin.DateTime = nowDate.Date; datePlanDateEnd.DateTime = nowDate.Date.AddDays(SystemInfo.OrderQueryDate_DefaultDays); checkPlanDate.Checked = false; lookUpReqDep.Properties.DataSource = commonDAO.QueryDepartment(true); lookUpReqDep.ItemIndex = 0; lookUpPurCategory.Properties.DataSource = commonDAO.QueryPurCategory(true); lookUpPurCategory.ItemIndex = 0; searchLookUpBussinessBaseNo.Properties.DataSource = commonDAO.QueryBussinessBaseInfo(true); searchLookUpBussinessBaseNo.Text = "全部"; comboBoxReqState.SelectedIndex = 0; searchLookUpProjectNo.Properties.DataSource = commonDAO.QueryProjectList(true); searchLookUpProjectNo.Text = "全部"; searchLookUpCodeFileName.Properties.DataSource = commonDAO.QueryPartsCode(true); searchLookUpCodeFileName.Text = "全部"; repLookUpReqDep.DataSource = commonDAO.QueryDepartment(false); repLookUpPurCategory.DataSource = commonDAO.QueryPurCategory(false); repSearchProjectNo.DataSource = commonDAO.QueryProjectList(false); repSearchBussinessBaseNo.DataSource = commonDAO.QueryBussinessBaseInfo(false); gridBottomOrderHead.pageRowCount = SystemInfo.OrderQueryGrid_PageRowCount; SetGridViewAppearance(); btnQuery_Click(null, null); } catch (Exception ex) { //ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex); ExceptionHandler.HandleException(this.Text + "--" + f.tsmiCtjzsjcw.Text, ex); } }
/// <summary> /// 窗体加载事件 /// </summary> private void FrmPrReq_Load(object sender, EventArgs e) { try { ControlHandler.DevExpressStyle_ChangeControlLocation(btnListAdd.LookAndFeel.ActiveSkinName, new List <Control> { btnListAdd, checkAll }); DateTime nowDate = BaseSQL.GetServerDateTime(); dateReqDateBegin.DateTime = nowDate.Date.AddDays(-SystemInfo.OrderQueryDate_DefaultDays); dateReqDateEnd.DateTime = nowDate.Date; lookUpReqDep.Properties.DataSource = commonDAO.QueryDepartment(true); lookUpReqDep.ItemIndex = 0; lookUpPurCategory.Properties.DataSource = commonDAO.QueryPurCategory(true); lookUpPurCategory.ItemIndex = 0; comboBoxReqState.SelectedIndex = 0; lookUpApplicant.Properties.DataSource = commonDAO.QueryUserInfo(true); lookUpApplicant.EditValue = SystemInfo.user.EmpName; lookUpApprover.Properties.DataSource = commonDAO.QueryUserInfo(true); lookUpApprover.ItemIndex = -1; repLookUpReqDep.DataSource = commonDAO.QueryDepartment(false); repLookUpPurCategory.DataSource = commonDAO.QueryPurCategory(false); repLookUpApprovalType.DataSource = commonDAO.QueryApprovalType(false); repSearchProjectNo.DataSource = commonDAO.QueryProjectList(false); repSearchCodeFileName.DataSource = commonDAO.QueryPartsCode(false); if (textCommon.Text == "") { prReqDAO.QueryPrReqHead(dataSet_PrReq.Tables[0], "", "", "", "", 0, "", -1, "", true); } } catch (Exception ex) { //ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex); ExceptionHandler.HandleException(this.Text + "--" + tsmiCtjz.Text, ex); } }
/// <summary> /// 窗体加载事件 /// </summary> private void FrmWarehouseWarrantList_NoSettlement_Load(object sender, EventArgs e) { try { DateTime nowDate = BaseSQL.GetServerDateTime(); dateWWDateBegin.DateTime = nowDate.Date.AddDays(-SystemInfo.OrderQueryDate_DefaultDays); dateWWDateEnd.DateTime = nowDate.Date; searchLookUpBussinessBaseNo.Properties.DataSource = commonDAO.QueryBussinessBaseInfo(true); searchLookUpBussinessBaseNo.Text = "全部"; lookUpRepertoryNo.Properties.DataSource = commonDAO.QueryRepertoryInfo(true); lookUpRepertoryNo.ItemIndex = 0; lookUpWarehouseWarrantTypeNo.Properties.DataSource = wwDAO.QueryWarehouseWarrantType(true); lookUpWarehouseWarrantTypeNo.ItemIndex = 0; lookUpReqDep.Properties.DataSource = commonDAO.QueryDepartment(true); lookUpReqDep.ItemIndex = 0; comboBoxWarehouseState.SelectedIndex = 0; searchLookUpProjectNo.Properties.DataSource = commonDAO.QueryProjectList(true); searchLookUpProjectNo.Text = "全部"; searchLookUpCodeFileName.Properties.DataSource = commonDAO.QueryPartsCode(true); searchLookUpCodeFileName.Text = "全部"; repLookUpReqDep.DataSource = commonDAO.QueryDepartment(false); repSearchBussinessBaseNo.DataSource = commonDAO.QueryBussinessBaseInfo(false); repLookUpRepertoryNo.DataSource = commonDAO.QueryRepertoryInfo(false); repLookUpWWTypeNo.DataSource = wwDAO.QueryWarehouseWarrantType(false); repLookUpShelfId.DataSource = commonDAO.QueryShelfInfo(false); gridBottomOrderHead.pageRowCount = SystemInfo.OrderQueryGrid_PageRowCount; btnQuery_Click(null, null); } catch (Exception ex) { //ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex); ExceptionHandler.HandleException(this.Text + "--" + f.tsmiCtjzsjcw.Text, ex); } }
/// <summary> /// 窗体加载事件 /// </summary> private void FrmWarehouseNowInfo_Load(object sender, EventArgs e) { try { lookUpRepertoryNo.Properties.DataSource = commonDAO.QueryRepertoryInfo(true); lookUpRepertoryNo.ItemIndex = 0; searchLookUpProjectNo.Properties.DataSource = commonDAO.QueryProjectList(true); searchLookUpProjectNo.Text = "全部"; searchLookUpCodeFileName.Properties.DataSource = commonDAO.QueryPartsCode(true); searchLookUpCodeFileName.Text = "全部"; searchLookUpShelf.Properties.DataSource = commonDAO.QueryShelfInfo(true); searchLookUpShelf.EditValue = 0; gridBottomWNowInfo.pageRowCount = SystemInfo.OrderQueryGrid_PageRowCount; repLookUpRepertoryNo.DataSource = commonDAO.QueryRepertoryInfo(false); } catch (Exception ex) { //ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex); ExceptionHandler.HandleException(this.Text + "--" + f.tsmiCtjzsjcw.Text, ex); } }
/// <summary> /// 窗体加载事件 /// </summary> private void FrmQueryStockDurationTotal_Load(object sender, EventArgs e) { try { DateTime nowDate = BaseSQL.GetServerDateTime(); dateDurBegin.DateTime = nowDate.Date.AddDays(-SystemInfo.OrderQueryDate_DefaultDays); dateDurEnd.DateTime = nowDate.Date; lookUpRepertoryNo.Properties.DataSource = commonDAO.QueryRepertoryInfo(true); lookUpRepertoryNo.ItemIndex = 0; searchLookUpProjectNo.Properties.DataSource = commonDAO.QueryProjectList(true); searchLookUpProjectNo.Text = "全部"; searchLookUpCodeFileName.Properties.DataSource = commonDAO.QueryPartsCode(true); searchLookUpCodeFileName.Text = "全部"; gridBottomWNowInfo.pageRowCount = SystemInfo.OrderQueryGrid_PageRowCount; repLookUpRepertoryNo.DataSource = commonDAO.QueryRepertoryInfo(false); } catch (Exception ex) { ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex); } }
private DataTable partsCodeTable_false = null; //不包含全部选项 /// <summary> /// SearchLookUpEdit零件信息控件初始化 /// </summary> public void SearchLookUpEdit_PartsCode(SearchLookUpEdit searchLookUp, bool addAllItem, string valueMemberStr = "AutoId", string displayMemberStr = "CodeName") { if (DataTypeConvert.GetString(searchLookUp.Properties.View.Tag) == "Init") { return; } GridColumn grdColAutoId = new GridColumn(); grdColAutoId.Caption = "AutoId"; grdColAutoId.FieldName = "AutoId"; grdColAutoId.Name = "grdColAutoId"; GridColumn grdColCodeFileName = new GridColumn(); grdColCodeFileName.Caption = "零件编号"; grdColCodeFileName.FieldName = "CodeFileName"; grdColCodeFileName.Name = "grdColCodeFileName"; grdColCodeFileName.AppearanceHeader.Options.UseTextOptions = true; grdColCodeFileName.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center; grdColCodeFileName.Visible = true; grdColCodeFileName.VisibleIndex = 0; GridColumn grdColCodeName = new GridColumn(); grdColCodeName.Caption = "零件名称"; grdColCodeName.FieldName = "CodeName"; grdColCodeName.Name = "grdColCodeName"; grdColCodeName.AppearanceHeader.Options.UseTextOptions = true; grdColCodeName.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center; grdColCodeName.Visible = true; grdColCodeName.VisibleIndex = 1; searchLookUp.Properties.View.Columns.AddRange(new GridColumn[] { grdColAutoId, grdColCodeFileName, grdColCodeName }); searchLookUp.Properties.NullText = ""; searchLookUp.EnterMoveNextControl = true; searchLookUp.Properties.ValueMember = valueMemberStr; searchLookUp.Properties.DisplayMember = displayMemberStr; if (addAllItem) { if (partsCodeTable_True == null) { partsCodeTable_True = commonDAO.QueryPartsCode(true); } searchLookUp.Properties.DataSource = partsCodeTable_True; } else { if (partsCodeTable_false == null) { partsCodeTable_false = commonDAO.QueryPartsCode(false); } searchLookUp.Properties.DataSource = partsCodeTable_false; } searchLookUp.Properties.View.IndicatorWidth = 60; searchLookUp.Properties.View.CustomDrawRowIndicator += searchLookUpView_CustomDrawRowIndicator; searchLookUp.Properties.View.Tag = "Init"; }