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