private void LY_Production_order_Mange_Load(object sender, EventArgs e) { //this.Location = this.ownerForm.PointToScreen(new Point(this.ownerForm.Location .X+10 ,this .ownerForm .Location .Y+5 )); //this .Width =this .ownerForm.Width-20 ; //this .Height =360; //MakeDropdownlist(); this.WindowState = FormWindowState.Maximized; //this.dateTimePicker1.Text = DateTime.Today.AddMonths(-1).Date.ToString(); this.dateTimePicker1.Text = "2009-01-01"; this.dateTimePicker2.Text = DateTime.Today.AddDays(1).Date.ToString(); this.lY_qualityDebug_historyInfoTableAdapter.Connection.ConnectionString = SQLDatabase.Connectstring; //this.ly_sales_test_detail1TableAdapter.Fill(this.lYSalseMange.ly_sales_test_detail1,DateTime.Parse(this.dateTimePicker1.Text).Date, DateTime.Parse(this.dateTimePicker2.Text).Date); this.lY_qualityDebug_historyInfoTableAdapter.Fill(this.lYSalseMange.LY_qualityDebug_historyInfo, DateTime.Parse(this.dateTimePicker1.Text).Date, DateTime.Parse(this.dateTimePicker2.Text).Date); /////////////////////// DataGridViewColumnSelector cs = new DataGridViewColumnSelector(lY_qualityDebug_historyInfoDataGridView, this.Text); cs.MaxHeight = 180; cs.Width = 800; cs.Set_dgvColumns(); //////////////////////////////// }
//private void lY_productiontask_periodBindingNavigatorSaveItem_Click(object sender, EventArgs e) //{ // this.Validate(); // this.lY_productiontask_periodBindingSource.EndEdit(); // this.tableAdapterManager.UpdateAll(this.lYProductMange); //} //private void fillToolStripButton_Click(object sender, EventArgs e) //{ // try // { // this.lY_productiontask_periodTableAdapter.Fill(this.lYProductMange.LY_productiontask_period, new System.Nullable<System.DateTime>(((System.DateTime)(System.Convert.ChangeType(begindateToolStripTextBox.Text, typeof(System.DateTime))))), new System.Nullable<System.DateTime>(((System.DateTime)(System.Convert.ChangeType(enddateToolStripTextBox.Text, typeof(System.DateTime))))), selcodeToolStripTextBox.Text); // } // catch (System.Exception ex) // { // System.Windows.Forms.MessageBox.Show(ex.Message); // } //} //private void fillToolStripButton_Click_1(object sender, EventArgs e) //{ // try // { // this.ly_production_submit_periodTableAdapter.Fill(this.lYProductMange.ly_production_submit_period, new System.Nullable<System.DateTime>(((System.DateTime)(System.Convert.ChangeType(begindateToolStripTextBox.Text, typeof(System.DateTime))))), new System.Nullable<System.DateTime>(((System.DateTime)(System.Convert.ChangeType(enddateToolStripTextBox.Text, typeof(System.DateTime)))))); // } // catch (System.Exception ex) // { // System.Windows.Forms.MessageBox.Show(ex.Message); // } //} private void LY_Product_MonthReport_Load(object sender, EventArgs e) { DateTime nowdate = SQLDatabase.GetNowdate(); int nowday = 0 - nowdate.Day + 1; this.dateTimePicker5.Text = nowdate.AddDays(nowday).Date.ToString(); this.dateTimePicker6.Text = nowdate.AddDays(nowday).AddMonths(1).AddDays(-1).Date.ToString(); /////////////////////// DataGridViewColumnSelector cs = new DataGridViewColumnSelector(ly_production_detail_viewSingleDataGridView, this.Text); cs.MaxHeight = 180; cs.Width = 800; cs.Set_dgvColumns(); //////////////////////////////// this.ly_production_detail_viewSingleTableAdapter.Connection.ConnectionString = SQLDatabase.Connectstring; this.ly_production_submit_periodTableAdapter.Connection.ConnectionString = SQLDatabase.Connectstring; this.ly_production_detail_viewTableAdapter.Connection.ConnectionString = SQLDatabase.Connectstring; this.ly_production_detail_viewTableAdapter.Fill(this.lYProductMange.ly_production_detail_view, this.dateTimePicker5.Value, this.dateTimePicker6.Value.AddDays(1)); this.ly_production_submit_periodTableAdapter.Fill(this.lYProductMange.ly_production_submit_period, this.dateTimePicker5.Value, this.dateTimePicker6.Value.AddDays(1)); }
private void LY_StockTake_Load(object sender, EventArgs e) { SetFormState("View"); this.ly_stocktake_detail_ONline_Explode01TableAdapter.Connection.ConnectionString = SQLDatabase.Connectstring; this.ly_stocktake_detail_ONline_Explode02TableAdapter.Connection.ConnectionString = SQLDatabase.Connectstring; this.ly_stocktake_detail_ONline_Explode03TableAdapter.Connection.ConnectionString = SQLDatabase.Connectstring; this.ly_stocktake_detail_ONline01TableAdapter.Connection.ConnectionString = SQLDatabase.Connectstring; this.ly_stocktake_detail_ONline02TableAdapter.Connection.ConnectionString = SQLDatabase.Connectstring; this.ly_stocktake_detail_ONline03TableAdapter.Connection.ConnectionString = SQLDatabase.Connectstring; this.ly_stocktake_detailTableAdapter.Connection.ConnectionString = SQLDatabase.Connectstring; this.ly_stocktake_mainTableAdapter.Connection.ConnectionString = SQLDatabase.Connectstring; this.ly_stocktake_mainTableAdapter.Fill(this.lYStoreMange.ly_stocktake_main); _ly_stocktake_detail_ONline_Explode01TotalTableAdapter.Connection.ConnectionString = SQLDatabase.Connectstring; _ly_stocktake_detail_ONline_Explode02TotalTableAdapter.Connection.ConnectionString = SQLDatabase.Connectstring; /////////////////////// DataGridViewColumnSelector cs = new DataGridViewColumnSelector(ly_stocktake_detailDataGridView, this.Text); cs.MaxHeight = 180; cs.Width = 800; cs.Set_dgvColumns(); //////////////////////////////// }
private void LY_MaterialMange_Load(object sender, EventArgs e) { //NewFrm.Show(this); this.dateTimePicker5.Text = "1900" + "-01" + "-01"; this.dateTimePicker6.Text = SQLDatabase.GetNowdate().AddDays(0).Date.ToString(); this.average_Cost_ViewTableAdapter.Connection.ConnectionString = SQLDatabase.Connectstring; this.f_Item_dynamicpriceTableAdapter.Connection.ConnectionString = SQLDatabase.Connectstring; this.f_Item_dynamicpriceBTableAdapter.Connection.ConnectionString = SQLDatabase.Connectstring; this.ly_plan_getmaterialTableAdapter.Connection.ConnectionString = SQLDatabase.Connectstring; this.ly_store_in_ylTableAdapter.Connection.ConnectionString = SQLDatabase.Connectstring; this.ly_store_in_yl_financialTableAdapter.Connection.ConnectionString = SQLDatabase.Connectstring; this.ly_store_outquery_fiancialTableAdapter.Connection.ConnectionString = SQLDatabase.Connectstring; this.ly_plan_getmaterialTableAdapter.Connection.ConnectionString = SQLDatabase.Connectstring; this.f_Item_dynamicpriceTableAdapter.Connection.ConnectionString = SQLDatabase.Connectstring; this.ly_store_outqueryTableAdapter.Connection.ConnectionString = SQLDatabase.Connectstring; this.lY_Inventory_query_financialTableAdapter.Connection.ConnectionString = SQLDatabase.Connectstring; // this.LY_Inventory_query_financialTableAdapter.Fill(this.lYStoreMange.LY_Inventory_query_financial , SQLDatabase.NowUserID); SetRowBackground(); /////////////////////// DataGridViewColumnSelector cs = new DataGridViewColumnSelector(ly_inma0010DataGridView, this.Text); cs.MaxHeight = 180; cs.Width = 800; cs.Set_dgvColumns(); //////////////////////////////// CountMoney(lY_Inventory_query_financialBindingSource, ly_inma0010DataGridView); SetRowBackground(); //NewFrm.Hide(this); }
private void SetHavePricerIGHT() { if (SQLDatabase.CheckHaveRight(SQLDatabase.NowUserID, "单价金额查看")) { DataGridViewColumnSelector cs = new DataGridViewColumnSelector(ly_inma0010DataGridView, this.Text); cs.MaxHeight = 180; cs.Width = 800; cs.Set_dgvColumns(); //////////////////////////////// CountMoney(ly_inma0010BindingSource, ly_inma0010DataGridView); ly_inma0010DataGridView.Columns["入库金额"].Visible = true; ly_inma0010DataGridView.Columns["出库金额"].Visible = true; ly_inma0010DataGridView.Columns["库存单价"].Visible = true; ly_inma0010DataGridView.Columns["库存金额"].Visible = true; ly_inma0010DataGridView.Columns["计划出库金额"].Visible = true; ly_inma0010DataGridView.Columns["计划库存金额"].Visible = true; ly_inma0010DataGridView.Columns["dynamic_price"].Visible = true; ly_inma0010DataGridView.Columns["machine_price"].Visible = true; ly_inma0010DataGridView.Columns["assembly_price"].Visible = true; ly_inma0010DataGridView.Columns["outsource_price"].Visible = true; ly_inma0010DataGridView.Columns["machine_outsource_price"].Visible = true; } else { ly_inma0010DataGridView.Columns["入库金额"].Visible = false; ly_inma0010DataGridView.Columns["出库金额"].Visible = false; ly_inma0010DataGridView.Columns["库存单价"].Visible = false; ly_inma0010DataGridView.Columns["库存金额"].Visible = false; ly_inma0010DataGridView.Columns["计划出库金额"].Visible = false; ly_inma0010DataGridView.Columns["计划库存金额"].Visible = false; ly_inma0010DataGridView.Columns["dynamic_price"].Visible = false; ly_inma0010DataGridView.Columns["machine_price"].Visible = false; ly_inma0010DataGridView.Columns["assembly_price"].Visible = false; ly_inma0010DataGridView.Columns["outsource_price"].Visible = false; ly_inma0010DataGridView.Columns["machine_outsource_price"].Visible = false; this.tabPage6.Parent = null; this.tabPage4.Parent = null; this.tabPage7.Parent = null; this.tabPage8.Parent = null; this.tabPage9.Parent = null; } }
private void LY_MaterialMange_Load(object sender, EventArgs e) { this.tabPage2.Parent = null; this.tabPage6.Parent = null; this.dateTimePicker1.Text = SQLDatabase.GetNowdate().AddDays(0).Date.ToString(); //SetHavePricerIGHT(); DataGridViewColumnSelector cs = new DataGridViewColumnSelector(ly_inma0010DataGridView, this.Text); cs.MaxHeight = 180; cs.Width = 800; cs.Set_dgvColumns(); NewFrm.Show(this); Thread.Sleep(100); this.f_Item_dynamicpriceTableAdapter.Connection.ConnectionString = SQLDatabase.Connectstring; this.ly_plan_getmaterialTableAdapter.Connection.ConnectionString = SQLDatabase.Connectstring; this.ly_store_in_Maintenance_newTableAdapter.Connection.ConnectionString = SQLDatabase.Connectstring; this.ly_store_out_Maintenancequery_newTableAdapter.Connection.ConnectionString = SQLDatabase.Connectstring; this.lY_InventoryMaintenance_query_newTableAdapter.Connection.ConnectionString = SQLDatabase.Connectstring; // this.lY_InventoryMaintenance_queryTableAdapter.Fill(this.lYStoreMange.LY_InventoryMaintenance_query, this .toolStripComboBox1.Text); SetRowBackground(); SetRowBackground(); NewFrm.Hide(this); }
private void LY_MaterialMange_Load(object sender, EventArgs e) { NewFrm.Show(this); this.Text = this.nowsort + "库存"; this.ly_plan_getmaterialTableAdapter.Connection.ConnectionString = SQLDatabase.Connectstring; this.ly_store_in_ylTableAdapter.Connection.ConnectionString = SQLDatabase.Connectstring; this.ly_store_outqueryTableAdapter.Connection.ConnectionString = SQLDatabase.Connectstring; this.lY_Inventory_queryClassTableAdapter.Connection.ConnectionString = SQLDatabase.Connectstring; this.lY_Inventory_queryClassTableAdapter.Fill(this.lYStoreMange.LY_Inventory_queryClass, this.nowsortcode); SetRowBackground(); /////////////////////// DataGridViewColumnSelector cs = new DataGridViewColumnSelector(ly_inma0010DataGridView, this.Text); cs.MaxHeight = 180; cs.Width = 800; cs.Set_dgvColumns(); //////////////////////////////// this.lY_Inventory_queryClassTableAdapter.Fill(this.lYStoreMange.LY_Inventory_queryClass, this.nowsortcode); CountMoney(lY_Inventory_queryClassBindingSource, ly_inma0010DataGridView); SetRowBackground(); NewFrm.Hide(this); }