/// <summary> /// 窗体加载事件 /// </summary> private void FrmSpecialWarehouseReceiptQuery_Load(object sender, EventArgs e) { try { DateTime nowDate = BaseSQL.GetServerDateTime(); dateSWRDateBegin.DateTime = nowDate.Date.AddDays(-SystemInfo.OrderQueryDate_DefaultDays); dateSWRDateEnd.DateTime = nowDate.Date; lookUpReqDep.Properties.DataSource = commonDAO.QueryDepartment(true); lookUpReqDep.ItemIndex = 0; lookUpRepertoryNo.Properties.DataSource = commonDAO.QueryRepertoryInfo(true); lookUpRepertoryNo.ItemIndex = 0; comboBoxWarehouseState.SelectedIndex = 0; lookUpPrepared.Properties.DataSource = commonDAO.QueryUserInfo(true); lookUpPrepared.EditValue = SystemInfo.user.EmpName; repLookUpReqDep.DataSource = commonDAO.QueryDepartment(false); repLookUpRepertoryNo.DataSource = commonDAO.QueryRepertoryInfo(false); repLookUpApprovalType.DataSource = commonDAO.QueryApprovalType(false); gridBottomOrderHead.pageRowCount = SystemInfo.OrderQueryGrid_PageRowCount; btnQuery_Click(null, null); } catch (Exception ex) { ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex); } }
/// <summary> /// 窗体加载事件 /// </summary> private void FrmInventoryAdjustmentsQuery_Load(object sender, EventArgs e) { try { ControlCommonInit ctlInit = new ControlCommonInit(); DateTime nowDate = BaseSQL.GetServerDateTime(); dateIADateBegin.DateTime = nowDate.Date.AddDays(-SystemInfo.OrderQueryDate_DateIntervalDays); dateIADateEnd.DateTime = nowDate.Date; DataTable departmentTable_t = commonDAO.QueryDepartment(true); DataTable repertoryTable_t = commonDAO.QueryRepertoryInfo(true); lookUpReqDep.Properties.DataSource = departmentTable_t; lookUpReqDep.ItemIndex = 0; lookUpRepertoryId.Properties.DataSource = repertoryTable_t; lookUpRepertoryId.ItemIndex = 0; //SearchLocationId.Properties.DataSource = locationTable_t; //SearchLocationId.EditValue = 0; ctlInit.SearchLookUpEdit_RepertoryLocationInfo(SearchLocationId, true); SearchLocationId.EditValue = 0; //searchProjectNo.Properties.DataSource = projectTable_t; //searchProjectNo.Text = "全部"; ctlInit.SearchLookUpEdit_ProjectList(searchProjectNo, true); searchProjectNo.Text = "全部"; ctlInit.ComboBoxEdit_WarehouseState(comboBoxWarehouseState); comboBoxWarehouseState.SelectedIndex = 0; ctlInit.SearchLookUpEdit_UserInfo_ValueMember_AutoId(searchLookUpCreator); searchLookUpCreator.EditValue = SystemInfo.user.AutoId; //repLookUpReqDep.DataSource = commonDAO.QueryDepartment(false); //repLookUpRepertoryId.DataSource = commonDAO.QueryRepertoryInfo(false); //repLookUpLocationId.DataSource = commonDAO.QueryRepertoryLocationInfo(false); //repSearchProjectNo.DataSource = commonDAO.QueryProjectList(false); repLookUpReqDep.DataSource = departmentTable_t; repLookUpRepertoryId.DataSource = repertoryTable_t; repLookUpLocationId.DataSource = SearchLocationId.Properties.DataSource; repSearchProjectNo.DataSource = searchProjectNo.Properties.DataSource; repLookUpCreator.DataSource = searchLookUpCreator.Properties.DataSource; repLookUpApprovalType.DataSource = commonDAO.QueryApprovalType(false); if (SystemInfo.DisableProjectNo) { labProjectNo.Visible = false; searchProjectNo.Visible = false; colProjectNo.Visible = false; } gridBottomIA.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 FrmOrderQuery_Load(object sender, EventArgs e) { try { DataTable departmentTable_t = commonDAO.QueryDepartment(true); DataTable bussInfoTable_t = commonDAO.QueryBussinessBaseInfo(true); DataTable purCateTable_t = commonDAO.QueryPurCategory(true); lookUpReqDep.Properties.DataSource = departmentTable_t; lookUpReqDep.ItemIndex = 0; searchLookUpBussinessBaseNo.Properties.DataSource = bussInfoTable_t; searchLookUpBussinessBaseNo.Text = "全部"; lookUpPurCategory.Properties.DataSource = purCateTable_t; lookUpPurCategory.ItemIndex = 0; ControlCommonInit ctlInit = new ControlCommonInit(); ctlInit.SearchLookUpEdit_UserInfo_ValueMember_AutoId(searchLookUpCreator); searchLookUpCreator.EditValue = SystemInfo.user.AutoId; ctlInit.ComboBoxEdit_OrderState_Submit(comboBoxReqState); comboBoxReqState.SelectedIndex = 0; //repLookUpReqDep.DataSource = commonDAO.QueryDepartment(false); //repSearchBussinessBaseNo.DataSource = commonDAO.QueryBussinessBaseInfo(false); //repLookUpPurCategory.DataSource = commonDAO.QueryPurCategory(false); repLookUpReqDep.DataSource = departmentTable_t; repSearchBussinessBaseNo.DataSource = bussInfoTable_t; repLookUpPurCategory.DataSource = purCateTable_t; repSearchProjectNo.DataSource = commonDAO.QueryProjectList(false); repLookUpApprovalType.DataSource = commonDAO.QueryApprovalType(false); repLookUpPayTypeNo.DataSource = commonDAO.QueryPayType(false); repLookUpCreator.DataSource = searchLookUpCreator.Properties.DataSource; DateTime nowDate = BaseSQL.GetServerDateTime(); dateOrderDateBegin.DateTime = nowDate.Date.AddDays(-SystemInfo.OrderQueryDate_DateIntervalDays); dateOrderDateEnd.DateTime = nowDate.Date; datePlanDateBegin.DateTime = nowDate.Date; datePlanDateEnd.DateTime = nowDate.Date.AddDays(SystemInfo.OrderQueryDate_DateIntervalDays); checkPlanDate.Checked = false; if (SystemInfo.DisableProjectNo) { colProjectNo.Visible = false; colStnNo.Visible = 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 FrmWarehouseWarrantQuery_Load(object sender, EventArgs e) { try { ControlCommonInit ctlInit = new ControlCommonInit(); DateTime nowDate = BaseSQL.GetServerDateTime(); dateWWDateBegin.DateTime = nowDate.Date.AddDays(-SystemInfo.OrderQueryDate_DateIntervalDays); dateWWDateEnd.DateTime = nowDate.Date; DataTable departmentTable_t = commonDAO.QueryDepartment(true); DataTable bussInfoTable_t = commonDAO.QueryBussinessBaseInfo(true); DataTable repertoryTable_t = commonDAO.QueryRepertoryInfo(true); DataTable wwTypeTable_t = wwDAO.QueryWarehouseWarrantType(true); lookUpReqDep.Properties.DataSource = departmentTable_t; lookUpReqDep.ItemIndex = 0; searchLookUpBussinessBaseNo.Properties.DataSource = bussInfoTable_t; searchLookUpBussinessBaseNo.Text = "全部"; lookUpRepertoryId.Properties.DataSource = repertoryTable_t; lookUpRepertoryId.ItemIndex = 0; //SearchLocationId.Properties.DataSource = locationTable_t; //SearchLocationId.EditValue = 0; ctlInit.SearchLookUpEdit_RepertoryLocationInfo(SearchLocationId, true); SearchLocationId.EditValue = 0; lookUpWarehouseWarrantTypeNo.Properties.DataSource = wwTypeTable_t; lookUpWarehouseWarrantTypeNo.ItemIndex = 0; ctlInit.ComboBoxEdit_WarehouseState(comboBoxWarehouseState, true); comboBoxWarehouseState.SelectedIndex = 0; ctlInit.SearchLookUpEdit_UserInfo_ValueMember_AutoId(searchLookUpCreator); searchLookUpCreator.EditValue = SystemInfo.user.AutoId; //repLookUpReqDep.DataSource = commonDAO.QueryDepartment(false); //repSearchBussinessBaseNo.DataSource = commonDAO.QueryBussinessBaseInfo(false); //repLookUpRepertoryId.DataSource = commonDAO.QueryRepertoryInfo(false); //repLookUpRepertoryLocationId.DataSource = commonDAO.QueryRepertoryLocationInfo(false); //repLookUpWWTypeNo.DataSource = wwDAO.QueryWarehouseWarrantType(false); repLookUpReqDep.DataSource = departmentTable_t; repSearchBussinessBaseNo.DataSource = bussInfoTable_t; repLookUpRepertoryId.DataSource = repertoryTable_t; repLookUpRepertoryLocationId.DataSource = SearchLocationId.Properties.DataSource; repLookUpWWTypeNo.DataSource = wwTypeTable_t; repLookUpApprovalType.DataSource = commonDAO.QueryApprovalType(false); repLookUpCreator.DataSource = searchLookUpCreator.Properties.DataSource; 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 FrmApprovalList_Load(object sender, EventArgs e) { try { FrmCommonDAO commonDAO = new FrmCommonDAO(); repItemLookUpTypeNo.DataSource = commonDAO.QueryApprovalType(false); repItemLookUpApprover.DataSource = commonDAO.QueryUserInfo_OnlyColumn(false); } 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 FrmSettlementQuery_Load(object sender, EventArgs e) { try { ControlCommonInit ctlInit = new ControlCommonInit(); DateTime nowDate = BaseSQL.GetServerDateTime(); dateSettlementDateBegin.DateTime = nowDate.Date.AddDays(-SystemInfo.OrderQueryDate_DateIntervalDays); dateSettlementDateEnd.DateTime = nowDate.Date; datePayDateBegin.DateTime = nowDate.Date; datePayDateEnd.DateTime = nowDate.Date.AddDays(SystemInfo.OrderQueryDate_DateIntervalDays); checkPayDate.Checked = false; searchLookUpBussinessBaseNo.Properties.DataSource = commonDAO.QueryBussinessBaseInfo(true); searchLookUpBussinessBaseNo.Text = "全部"; lookUpReqDep.Properties.DataSource = commonDAO.QueryDepartment(true); lookUpReqDep.ItemIndex = 0; ctlInit.ComboBoxEdit_WarehouseState(comboBoxWarehouseState, true); comboBoxWarehouseState.SelectedIndex = 0; ctlInit.SearchLookUpEdit_UserInfo_ValueMember_AutoId(searchLookUpCreator); searchLookUpCreator.EditValue = SystemInfo.user.AutoId; repSearchBussinessBaseNo.DataSource = commonDAO.QueryBussinessBaseInfo(false); repLookUpReqDep.DataSource = commonDAO.QueryDepartment(false); repLookUpApprovalType.DataSource = commonDAO.QueryApprovalType(false); repLookUpCreator.DataSource = searchLookUpCreator.Properties.DataSource; gridBottomOrderHead.pageRowCount = SystemInfo.OrderQueryGrid_PageRowCount; if (textCommon.Text == "") { btnQuery_Click(null, null); } } catch (Exception ex) { //ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex); ExceptionHandler.HandleException(this.Text + "--" + tsmiCtjz.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 FrmApprovalList_Load(object sender, EventArgs e) { try { FrmCommonDAO commonDAO = new FrmCommonDAO(); repItemLookUpTypeNo.DataSource = commonDAO.QueryApprovalType(false); repItemLookUpApprover.DataSource = commonDAO.QueryUserInfo(false); if (editForm == null) { editForm = new FrmBaseEdit(); editForm.FormBorderStyle = FormBorderStyle.None; editForm.TopLevel = false; editForm.TableName = "PUR_ApprovalList"; editForm.TableCaption = "审批信息设置"; editForm.Sql = string.Format("select * from PUR_ApprovalList where typeNo='{0}' Order by AppSequence", TypeNoStr); editForm.PrimaryKeyColumn = "AutoId"; editForm.MasterDataSet = dSApprovalList; editForm.MasterBindingSource = bSApprovalList; //editForm.MasterEditPanel = pnlEdit; editForm.BrowseXtraGridView = gridViewApprovalList; editForm.CheckControl += CheckControl; editForm.SaveRowBefore += SaveRowBefore; editForm.DeleteRowBefore += DeleteRowBefore; editForm.ButtonList.Add(btnUp); editForm.ButtonList.Add(btnDown); editForm.DeleteAfterRefresh = true; //editForm.btnSaveExcel.Visible = false; editForm.VisibleSearchContrl = false; this.pnlToolBar.Controls.Add(editForm); editForm.Dock = DockStyle.Fill; editForm.Show(); } } catch (Exception ex) { //ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex); ExceptionHandler.HandleException(this.Text + "--" + f.tsmiCtjzsjcw.Text, ex); } }
/// <summary> /// 窗体加载事件 /// </summary> private void FrmPSBomToPrReq_Load(object sender, EventArgs e) { try { textPbBomNo.Text = pbBomNoStr; lookUpReqDep.Properties.DataSource = commonDAO.QueryDepartment(false); lookUpReqDep.EditValue = SystemInfo.user.DepartmentNo; searchLookUpProjectNo.Properties.DataSource = commonDAO.QueryProjectList(false); searchLookUpProjectNo.Text = projectNoStr; DataTable tempTable = commonDAO.QueryStnList(projectNoStr); searchLookUpStnNo.Properties.DataSource = tempTable; if (tempTable.Rows.Count > 0) { searchLookUpStnNo.EditValue = tempTable.Rows[0]["StnNo"]; } lookUpPurCategory.Properties.DataSource = commonDAO.QueryPurCategory(false); lookUpPurCategory.ItemIndex = 0; lookUpEditApprovalType.Properties.DataSource = commonDAO.QueryApprovalType(false); lookUpEditApprovalType.ItemIndex = 0; DataTable psBomTable = PStoPRDAO.Query_NoPr_PSBom(pbBomNoStr, bomListAutoIdInt); gridControlPSBom.DataSource = psBomTable; if (psBomTable.Rows.Count == 0) { MessageHandler.ShowMessageBox("当前选中的制作Bom信息没有生产计划,不能生成请购单。"); this.Close(); return; } } catch (Exception ex) { ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex); } }
/// <summary> /// 窗体加载事件错误 /// </summary> private void FrmOrderQuery_Load(object sender, EventArgs e) { try { lookUpReqDep.Properties.DataSource = commonDAO.QueryDepartment(true); lookUpReqDep.ItemIndex = 0; lookUpPurCategory.Properties.DataSource = commonDAO.QueryPurCategory(true); lookUpPurCategory.ItemIndex = 0; comboBoxReqState.SelectedIndex = 0; lookUpPrepared.Properties.DataSource = commonDAO.QueryUserInfo(true); lookUpPrepared.EditValue = SystemInfo.user.EmpName; searchLookUpBussinessBaseNo.Properties.DataSource = commonDAO.QueryBussinessBaseInfo(true); searchLookUpBussinessBaseNo.Text = "全部"; repLookUpReqDep.DataSource = commonDAO.QueryDepartment(false); repLookUpPurCategory.DataSource = commonDAO.QueryPurCategory(false); repSearchProjectNo.DataSource = commonDAO.QueryProjectList(false); repSearchBussinessBaseNo.DataSource = commonDAO.QueryBussinessBaseInfo(false); repLookUpApprovalType.DataSource = commonDAO.QueryApprovalType(false); repLookUpPayTypeNo.DataSource = commonDAO.QueryPayType(false); 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; 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 FrmWarehouseWarrantQuery_Load(object sender, EventArgs e) { try { DateTime nowDate = BaseSQL.GetServerDateTime(); dateWWDateBegin.DateTime = nowDate.Date.AddDays(-SystemInfo.OrderQueryDate_DefaultDays); dateWWDateEnd.DateTime = nowDate.Date; lookUpReqDep.Properties.DataSource = commonDAO.QueryDepartment(true); lookUpReqDep.ItemIndex = 0; 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; comboBoxWarehouseState.SelectedIndex = 0; lookUpPrepared.Properties.DataSource = commonDAO.QueryUserInfo(true); lookUpPrepared.EditValue = SystemInfo.user.EmpName; repLookUpReqDep.DataSource = commonDAO.QueryDepartment(false); repLookUpRepertoryNo.DataSource = commonDAO.QueryRepertoryInfo(false); repLookUpWWTypeNo.DataSource = wwDAO.QueryWarehouseWarrantType(false); repSearchBussinessBaseNo.DataSource = commonDAO.QueryBussinessBaseInfo(false); repLookUpApprovalType.DataSource = commonDAO.QueryApprovalType(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); } }