public HistoryUC()
{
InitializeComponent();
TranslateDataGridView();
Spinetester.instance.ArrowTaken += OnArrowTaken;
columnSelector = new DataGridViewColumnSelector(historyView);
GlobalEventManager.instance.AddToHistory += AddArrow;
GlobalEventManager.instance.RemoveFromHistory += OnRemoveFromHistory;
GlobalEventManager.instance.ClearHistory += OnClearHistory;
GlobalEventManager.instance.ExportHistory += OnExportHistory;
GlobalEventManager.instance.SaveHistory += OnSaveHistory;
GlobalEventManager.instance.LoadHistory += OnLoadHistory;
SetHistoryViewColumnVisibility();
//var r = new System.Random(System.DateTime.Now.Millisecond);
//while (CurrentSet.Index < 50)
//{
// ArrowData newArrow = new ArrowData();
// newArrow.Spine.Value1 = r.Next(30, 40);
// newArrow.Spine.Value2 = r.Next(30, 40);
// newArrow.Weight.Left = r.Next(100, 200);
// newArrow.Weight.Right = r.Next(100, 200);
// newArrow.Straightness.Set(new double[] { 0.01 });
// AddArrow(newArrow);
//}
}
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 SetColumnSelectors()
{
DataGridViewColumnSelector cs = new DataGridViewColumnSelector(this.OutputDataGridView);
cs.MaxHeight = 100;
cs.Width = 110;
}
//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 btStart_Click(object sender, EventArgs e)
{
if (isNumeric(tbTimeOut.Text) == true)
{
port = 0;
btnStart.Enabled = false;
btnStop.Enabled = true;
tbIPStart.Enabled = false;
tbIPEnd.Enabled = false;
cbNIC.Enabled = false;
cbUseSubnet.Enabled = false;
cbNIC.Enabled = false;
rbNames.Enabled = false;
rbDescription.Enabled = false;
tbPort.Enabled = false;
ips.Clear();
timeout = Convert.ToInt32(tbTimeOut.Text);
GetHosts();
dataGridView1.DataSource = ips;
DataGridViewColumnSelector dgvCS = new DataGridViewColumnSelector();
dgvCS.DataGridView = dataGridView1;
dataGridView1.ReadOnly = true;
dataGridView1.AllowUserToAddRows = false;
dataGridView1.Columns["Hostname"].Visible = false;
dataGridView1.Columns["First_Seen"].DefaultCellStyle.Format = "dd/MM HH:mm:ss";
dataGridView1.Columns["Last_Seen"].DefaultCellStyle.Format = "dd/MM HH:mm:ss";
dataGridView1.Columns["Last_Checked"].DefaultCellStyle.Format = "dd/MM HH:mm:ss";
dataGridView1.Columns["Last_Checked"].Visible = false;
dataGridView1.Columns["RunningCheck"].Visible = false;
dataGridView1.Columns["CountChecks"].Visible = false;
timer1.Start();
}
else
{
MessageBox.Show("Enter valid Timeout!");
}
if (tbPort.Text != "" && IpHelpers.IsValidPort(tbPort.Text) == true)
{
port = Convert.ToInt32(tbPort.Text);
dataGridView1.Columns["PortOpen"].Visible = true;
}
else if (tbPort.Text != "" && IpHelpers.IsValidPort(tbPort.Text) == false)
{
MessageBox.Show("Enter valid Port or leave empty");
dataGridView1.Columns["PortOpen"].Visible = false;
}
else
{
dataGridView1.Columns["PortOpen"].Visible = false;
}
}
internal Controller(MainWindow parent)
{
_parent = parent;
_categories = new List <CategoryDto>();
_dates = new List <DateDto>();
_dataGridView = _parent.dataGridView;
_dataTable = new WorkoutDataTable();
_columnSelector = new DataGridViewColumnSelector(_dataTable.DateColumnName, _parent.dataGridView);
EraseDataTable();
LoadCategoriesFromFile();
}
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);
}
