public MaterialBalenceofExtrusionProcess(mySystem.MainForm mainform, int Id) : base(mainform) { InitializeComponent(); connOle = Parameter.connOle; fill_printer(); getPeople(); setUserState(); searchId = Id; readOuterBind(searchId); removeOuterBind(); outerBind(); //get othertime will use current instruction Id getInstructionInfo(); getOtherData(); 重新读取并计算(); if (!mySystem.Parameter.isSqlOk) { daOuter.Update((DataTable)bsOuter.DataSource); } else { daOutersql.Update((DataTable)bsOuter.DataSource); } readOuterBind(searchId); removeOuterBind(); outerBind(); setFormState(); setEnableReadOnly(); }
public PTVBag_batchproduction(mySystem.MainForm mainform) : base(mainform) { InitializeComponent(); fillPrinter(); _生产指令ID = mySystem.Parameter.ptvbagInstruID; _生产指令 = mySystem.Parameter.ptvbagInstruction; tb生产指令编号.Text = _生产指令; init(); getPeople(); setUseState(); readOuterData(_生产指令ID); outerBind(); if (dtOuter.Rows.Count == 0) { DataRow dr = dtOuter.NewRow(); dr = writeOuterDefault(dr); dtOuter.Rows.Add(dr); //if (((DataTable)bsOuter.DataSource).Rows[0]["审核是否通过"] == DBNull.Value) // ((DataTable)bsOuter.DataSource).Rows[0]["审核是否通过"] = 0; daOuter.Update((DataTable)bsOuter.DataSource); readOuterData(_生产指令ID); outerBind(); } setFormState(); setEnableReadOnly(); }
public wasterecord(mySystem.MainForm mainform) : base(mainform) { titleleft = 200; titletop = 30; btnleft = 520; btntop = 30; addLayout(); filltop = 80; InitializeComponent(); datatab = new DataTable(); datashw = new DataTable(); drawdatab(); drawsel(); drawsel(); drawsel(); drawshow(); function_inni(); //addItem(); //addItem(); //addItem(); functions.SelectedValueChanged += new EventHandler(functions_SelectedValueChanged); fill.CellClick += new DataGridViewCellEventHandler(fill_CellClick); getsel.CellClick += new DataGridViewCellEventHandler(getsel_CellClick); }
public 生产领料申请单(mySystem.MainForm mainform, Int32 ID, DataTable dt生产指令构造, DataTable dt物料代码数量构造, SqlConnection conn构造, OleDbConnection connOle构造) : base(mainform) { isSaveClicked = true; InitializeComponent(); //从基类继承各种函数 conn = conn构造; connOle = connOle构造; variableInit(dt生产指令构造); getProductInfo(dt物料代码数量构造); //从参数中获取物料代码以及数量 fill_printer(); //添加打印机 getPeople(); // 获取操作员和审核员 setUserState(); // 根据登录人,设置stat_user //getOtherData(); //______获取申请单号 addOtherEvnetHandler(); // 其他事件,datagridview:DataError、CellEndEdit、DataBindingComplete addDataEventHandler(); // 设置读取数据的事件,比如生产检验记录的 “产品代码”的SelectedIndexChanged // 读取外表数据 readOuterData(ID); outerBind(); _id = Convert.ToInt32(dt记录.Rows[0]["ID"]); readInnerData(_id); dataGridView1.Columns.Clear(); setDataGridViewColumns(); innerBind(); // 设置状态和控件可用性 setFormState(); setEnableReadOnly(); // 事件部分 addComputerEventHandler(); }
public PTVBag_batchproduction(mySystem.MainForm mainform, int id) : base(mainform) { InitializeComponent(); fillPrinter(); SqlDataAdapter da = new SqlDataAdapter("select * from 批生产记录表 where ID=" + id, mySystem.Parameter.conn); DataTable dt = new DataTable(); da.Fill(dt); _生产指令 = dt.Rows[0]["生产指令编号"].ToString(); _生产指令ID = Convert.ToInt32(dt.Rows[0]["生产指令ID"]); tb生产指令编号.Text = _生产指令; init(); getPeople(); setUseState(); readOuterData(_生产指令ID); outerBind(); if (dtOuter.Rows.Count == 0) { DataRow dr = dtOuter.NewRow(); dr = writeOuterDefault(dr); dtOuter.Rows.Add(dr); daOuter.Update((DataTable)bsOuter.DataSource); readOuterData(_生产指令ID); outerBind(); } setFormState(); setEnableReadOnly(); }
public Feed(mySystem.MainForm mainform, int Id) : base(mainform) { InitializeComponent(); conOle = Parameter.connOle; getPeople(); setUserState(); fill_printer(); dtOuter = new DataTable(tablename1); daOutersql = new SqlDataAdapter("SELECT * FROM 吹膜供料系统运行记录 WHERE ID =" + Id, mySystem.Parameter.conn); bsOuter = new BindingSource(); cbOutersql = new SqlCommandBuilder(daOutersql); daOutersql.Fill(dtOuter); removeOuterBind(); outerBind(); __生产指令编号 = Convert.ToString(dtOuter.Rows[0]["生产指令编号"]); __生产日期 = Convert.ToDateTime(dtOuter.Rows[0]["生产日期"]); __班次 = Convert.ToString(dtOuter.Rows[0]["班次"]); searchId = Id; cmb班次.Text = __班次; readInnerData(searchId); innerBind(); setFormState(); setEnableReadOnly(); }
public 订单管理(mySystem.MainForm mainform) : base(mainform) { InitializeComponent(); // 连接数据库 //conn = new OleDbConnection(strConnect); //conn.Open(); tabControl1.SelectedIndexChanged += new EventHandler(tabControl1_SelectedIndexChanged); switch (tabControl1.SelectedIndex) { case 0: // 销售订单 init销售订单(); break; case 1: init采购需求单(); break; case 2: break; } dgv销售订单.CellDoubleClick += new DataGridViewCellEventHandler(dgv销售订单_CellDoubleClick); dgv采购需求单.CellDoubleClick += new DataGridViewCellEventHandler(dgv采购需求单_CellDoubleClick); dgv采购批准单.CellDoubleClick += new DataGridViewCellEventHandler(dgv采购批准单_CellDoubleClick); dgv采购订单.CellDoubleClick += new DataGridViewCellEventHandler(dgv采购订单_CellDoubleClick); dgv出库单.CellDoubleClick += new DataGridViewCellEventHandler(dgv出库单_CellDoubleClick); }
public LDPE生产退料记录(mySystem.MainForm mainform) : base(mainform) { InitializeComponent(); conn = Parameter.conn; mySystem.Parameter.conn = mySystem.Parameter.conn; isSqlOk = Parameter.isSqlOk; InstruID = Parameter.ldpebagInstruID; Instruction = Parameter.ldpebagInstruction; Flight = Parameter.userflight; fill_printer(); //添加打印机 getPeople(); // 获取操作员和审核员 setUserState(); // 根据登录人,设置stat_user getOtherData(); //读取设置内容 addOtherEvnetHandler(); // 其他事件,datagridview:DataError、CellEndEdit、DataBindingComplete addDataEventHandler(); // 设置读取数据的事件,比如生产检验记录的 “产品代码”的SelectedIndexChanged setControlFalse(); //查询条件可编辑 cb产品代码.Enabled = true; btn查询新建.Enabled = true; //打印、查看日志按钮不可用 btn打印.Enabled = false; btn查看日志.Enabled = false; cb打印机.Enabled = false; }
public HandOver(mySystem.MainForm mainform, int Id) : base(mainform) { InitializeComponent(); conn = mySystem.Parameter.conn; fill_printer(); searchId = Id; getPeople(); setUserState(); settingItem = 获取交接班项目(); readOuterData(searchId); __生产指令编号 = Convert.ToString(dtOuter.Rows[0]["生产指令编号"]); __生产日期 = Convert.ToDateTime(dtOuter.Rows[0]["生产日期"]); __生产指令ID = Convert.ToInt32(dtOuter.Rows[0]["生产指令ID"]); removeOuterBind(); outerBind(); readInnerData(searchId); setDataGridViewColumns(); if (0 == dtInner.Rows.Count) { writeInnerDefault(dtInner); } setDataGridViewRowNums(); InnerBind(); 是否覆盖原有项目(); 填写交班员(); daOuter.Update((DataTable)bsOuter.DataSource); readOuterData(searchId); removeOuterBind(); outerBind(); setEnableReadOnly(true); }
public DailyRecord(mySystem.MainForm mainform, int Id) : base(mainform) { string matcode; InitializeComponent(); fill_printer(); conOle = mySystem.Parameter.connOle; getPeople(); setUserState(); OleDbDataAdapter da = new OleDbDataAdapter("select * from 清洁分切日报表 where ID=" + Id, mySystem.Parameter.connOle); DataTable dt = new DataTable(); da.Fill(dt); matcode = dt.Rows[0]["物料种类"].ToString(); __生产指令ID = Convert.ToInt32(dt.Rows[0]["生产指令ID"]); da = new OleDbDataAdapter("select * from 清洁分切工序生产指令 where ID=" + __生产指令ID, mySystem.Parameter.connOle); dt.Clear(); da.Fill(dt); __生产指令 = dt.Rows[0]["生产指令编号"].ToString(); foreach (string m in matCodes) { cmb物料种类.Items.Add(m); } cmb物料种类.SelectedIndexChanged += new EventHandler(cmb物料种类_SelectedIndexChanged); cmb物料种类.SelectedItem = matcode; addOtherEventHandler(); setEnableReadOnly(); }
public LDPEBag_batchproduction(mySystem.MainForm mainform) : base(mainform) { InitializeComponent(); fillPrinter(); dataGridView1.DataError += dataGridView1_DataError; dataGridView2.DataError += dataGridView2_DataError; _生产指令ID = mySystem.Parameter.ldpebagInstruID; _生产指令 = mySystem.Parameter.ldpebagInstruction; tb生产指令编号.Text = _生产指令; init(); getPeople(); setUseState(); readOuterData(_生产指令ID); outerBind(); if (dtOuter.Rows.Count == 0) { DataRow dr = dtOuter.NewRow(); dr = writeOuterDefault(dr); dtOuter.Rows.Add(dr); daOuter.Update((DataTable)bsOuter.DataSource); readOuterData(_生产指令ID); outerBind(); } setFormState(); setEnableReadOnly(); }
public NetExchange(mySystem.MainForm mainform) : base(mainform) { InitializeComponent(); conOle = Parameter.connOle; init(); binding(); }
public HandOver(mySystem.MainForm mainform) : base(mainform) { InitializeComponent(); conn = mySystem.Parameter.conn; fill_printer(); getPeople(); setUserState(); getOtherData(); __生产指令编号 = Parameter.ptvbagInstruction; __生产日期 = DateTime.Now.Date; dtp生产日期.Value = __生产日期; readOuterData(__生产指令编号, __生产日期); removeOuterBind(); outerBind(); if (0 == dtOuter.Rows.Count) { DataRow newrow = dtOuter.NewRow(); newrow = writeOuterDefault(newrow, (Convert.ToString(Parameter.userflight) == "白班") ? true : false); dtOuter.Rows.Add(newrow); daOuter.Update((DataTable)bsOuter.DataSource); readOuterData(__生产指令编号, __生产日期); removeOuterBind(); outerBind(); } __生产指令ID = Convert.ToInt32(dtOuter.Rows[0]["生产指令ID"]); readInnerData(Convert.ToInt32(dtOuter.Rows[0]["ID"])); setDataGridViewColumns(); if (0 == dtInner.Rows.Count) { writeInnerDefault(dtInner); } 根据班次填写确认结果(); setDataGridViewRowNums(); InnerBind(); 是否覆盖原有项目(); //update Outer daOuter.Update((DataTable)bsOuter.DataSource); readOuterData(__生产指令编号, __生产日期); removeOuterBind(); outerBind(); 填写交班员(); setEnableReadOnly(true); if (isFirstBind) { readDGVWidthFromSettingAndSet(dataGridView1); isFirstBind = false; } }
public Setting_CleanArea(mySystem.MainForm mainform) : base(mainform) { conn = mySystem.Parameter.conn; mySystem.Parameter.conn = mySystem.Parameter.conn; isSqlOk = mySystem.Parameter.isSqlOk; InitializeComponent(); Init(); Bind(); }
public Feed(mySystem.MainForm mainform) : base(mainform) { InitializeComponent(); conOle = Parameter.connOle; getPeople(); setUserState(); fill_printer(); __生产指令编号 = Parameter.proInstruction; __生产日期 = Convert.ToDateTime(DateTime.Now.Date.ToString()); __班次 = Parameter.userflight; lbl生产指令编号.Text = __生产指令编号; dtp生产日期.Value = __生产日期; for (int i = 0; i < flight.Count; i++) { cmb班次.Items.Add(flight[i]); } cmb班次.SelectedItem = __班次; //readOuterData(__生产指令编号, __生产日期, __班次); readOuterData(__生产指令编号); removeOuterBind(); outerBind(); if (0 == dtOuter.Rows.Count) { DataRow newrow = dtOuter.NewRow(); newrow = writeOuterDefault(newrow); dtOuter.Rows.Add(newrow); if (!mySystem.Parameter.isSqlOk) { daOuter.Update((DataTable)bsOuter.DataSource); } else { if (((DataTable)bsOuter.DataSource).Rows[0]["审核是否通过"] == DBNull.Value) { ((DataTable)bsOuter.DataSource).Rows[0]["审核是否通过"] = 0; } //((DataTable)bsOuter.DataSource).Rows[0]["审核是否通过"] = 0; daOutersql.Update((DataTable)bsOuter.DataSource); } readOuterData(__生产指令编号); //readOuterData(__生产指令编号, __生产日期, __班次); removeOuterBind(); outerBind(); } searchId = Convert.ToInt32(dtOuter.Rows[0]["ID"]); readInnerData(searchId); innerBind(); setFormState(); setEnableReadOnly(); }
public Record_cleansite_cut(mySystem.MainForm mainform, int id) : base(mainform) { InitializeComponent(); getPeople();//清场记录权限 setUserState(); getOtherData(); addDataEventHandler(); string asql = "select * from 清场记录 where ID=" + id; SqlCommand comm = new SqlCommand(asql, mySystem.Parameter.conn); SqlDataAdapter da = new SqlDataAdapter(comm); DataTable tempdt = new DataTable(); da.Fill(tempdt); instrid = int.Parse(tempdt.Rows[0]["生产指令ID"].ToString()); //prodcode = tempdt.Rows[0]["产品代码"].ToString(); readOuterData(instrid, prodcode); removeOuterBinding(); outerBind(); ckb白班.Checked = (bool)dt_prodinstr.Rows[0]["生产班次"]; ckb夜班.Checked = !ckb白班.Checked; if (dt_prodinstr.Rows[0]["审核人"].ToString() != "" && dt_prodinstr.Rows[0]["审核人"].ToString() != "__待审核") { ckb合格.Checked = (bool)dt_prodinstr.Rows[0]["审核是否通过"]; ckb不合格.Checked = !ckb合格.Checked; } else { ckb合格.Checked = false; ckb不合格.Checked = false; } readInnerData((int)dt_prodinstr.Rows[0]["ID"]); innerBind(); addOtherEvnetHandler(); setFormState(); setEnableReadOnly(); cb产品代码.Enabled = false; bt插入查询.Enabled = false; dataGridView1.CellEndEdit += new DataGridViewCellEventHandler(dataGridView1_CellEndEdit); }
public 库存管理(mySystem.MainForm mainform) : base(mainform) { InitializeComponent(); //conn = new OleDbConnection(strConnect); //conn.Open(); // 绑定控件 readFromDatabase(); bindControl(); //dataGridView1.ReadOnly = true; //dataGridView1.AllowUserToAddRows = false; //dataGridView1.RowHeadersVisible = false; //dataGridView1.DataBindingComplete += new DataGridViewBindingCompleteEventHandler(dataGridView1_DataBindingComplete); }
public Record_train(mySystem.MainForm mainform) : base(mainform) { InitializeComponent(); init(); foreach (Control c in this.Controls) { c.Enabled = false; } tb讲师.Enabled = true; tb培训地点.Enabled = true; dtp培训日期.Enabled = true; bt查询插入.Enabled = true; }
public 生产领料申请单(mySystem.MainForm mainform, DataTable dt生产指令构造, DataTable dt物料代码数量构造, SqlConnection conn构造, OleDbConnection connOle构造) : base(mainform) { InitializeComponent(); //从基类继承各种函数 conn = conn构造; connOle = connOle构造; variableInit(dt生产指令构造); getProductInfo(dt物料代码数量构造); //从参数中获取物料代码以及数量 //设置 fill_printer(); //添加打印机 getPeople(); // 获取操作员和审核员 setUserState(); // 根据登录人,设置stat_user getOtherData(); //______获取申请单号 addOtherEvnetHandler(); // 其他事件,datagridview:DataError、CellEndEdit、DataBindingComplete addDataEventHandler(); // 设置读取数据的事件,比如生产检验记录的 “产品代码”的SelectedIndexChanged //新建外表 readOuterData(_生产指令ID, _申请单号); outerBind(); DataRow dr = dt记录.NewRow(); dr = writeOuterDefault(dr); dt记录.Rows.Add(dr); if (!mySystem.Parameter.isSqlOk) { da记录.Update((DataTable)bs记录.DataSource); } else { da记录sql.Update((DataTable)bs记录.DataSource); } readOuterData(_生产指令ID, _申请单号); outerBind(); _id = Convert.ToInt32(dt记录.Rows[0]["ID"].ToString()); //新建内表绑定 dataGridView1.Columns.Clear(); readInnerData(_id); setDataGridViewColumns(); innerBind(); WriteInnerInit();//填写默认行 // 其他设置 addComputerEventHandler(); // 设置自动计算类事件 setFormState(); // 获取当前窗体状态:窗口状态 0:未保存;1:待审核;2:审核通过;3:审核未通过 setEnableReadOnly(); //根据状态设置可读写性 }
public CS生产领料申请单(mySystem.MainForm mainform, Int32 ID, BaseForm owner) : base(mainform) { InitializeComponent(); conn = Parameter.conn; mySystem.Parameter.conn = mySystem.Parameter.conn; isSqlOk = Parameter.isSqlOk; variableInit(ID); getOtherData();//读取该指令下的物料代码,数量 生产领料申请单 my生产领料申请单 = new mySystem.Other.生产领料申请单(base.mainform, ID, dt生产指令信息, dt物料代码数量, conn, mySystem.Parameter.connOle); my生产领料申请单.Owner = owner; my生产领料申请单.ShowDialog(); }
public LDPE生产退料记录(mySystem.MainForm mainform, Int32 ID) : base(mainform) { InitializeComponent(); conn = Parameter.conn; mySystem.Parameter.conn = mySystem.Parameter.conn; isSqlOk = Parameter.isSqlOk; fill_printer(); //添加打印机 getPeople(); // 获取操作员和审核员 setUserState(); // 根据登录人,设置stat_user //getOtherData(); //读取设置内容 addOtherEvnetHandler(); // 其他事件,datagridview:DataError、CellEndEdit、DataBindingComplete addDataEventHandler(); // 设置读取数据的事件,比如生产检验记录的 “产品代码”的SelectedIndexChanged IDShow(ID); }
public ProdctDaily_extrus(mySystem.MainForm mainform) : base(mainform) { InitializeComponent(); __生产指令ID = mySystem.Parameter.proInstruID; getOtherData(); fill_printer(); Init(); getPeople(); setUserState(); if ((_userState == Parameter.UserState.操作员)) { button2.Enabled = false; } }
public Gamma射线辐射灭菌委托单(mySystem.MainForm mainform) : base(mainform) { InitializeComponent(); getPeople(); setUserState(); getOtherData(); addDataEventHandler(); foreach (Control c in this.Controls) { c.Enabled = false; } tb委托单号.Enabled = true; bt查询插入.Enabled = true; tb委托单号.Text = 最近委托单号; }
public CS生产领料申请单(mySystem.MainForm mainform, BaseForm owner) : base(mainform) { InitializeComponent(); conn = Parameter.conn; mySystem.Parameter.conn = mySystem.Parameter.conn; isSqlOk = Parameter.isSqlOk; InstruID = Parameter.csbagInstruID; Instruction = Parameter.csbagInstruction; getOtherData();//读取该指令下的物料代码,数量 生产领料申请单 my生产领料申请单 = new mySystem.Other.生产领料申请单(base.mainform, dt生产指令信息, dt物料代码数量, conn, mySystem.Parameter.connOle); my生产领料申请单.Owner = owner; my生产领料申请单.ShowDialog(); }
public 辐照灭菌产品验收记录(mySystem.MainForm mainform, int id) : base(mainform) { InitializeComponent(); getPeople(); setUserState(); getOtherData(); string asql = "select * from 辐照灭菌产品验收记录 where ID=" + id; SqlCommand comm = new SqlCommand(asql, mySystem.Parameter.conn); SqlDataAdapter da = new SqlDataAdapter(comm); DataTable tempdt = new DataTable(); da.Fill(tempdt); code = tempdt.Rows[0]["灭菌委托单编号"].ToString(); if (!cb委托单号.Items.Contains(code)) { cb委托单号.Items.Add(code); } instruID = id; readOuterData(code); outerBind(); //?? tb辐照批号.DataBindings.Clear(); tb辐照批号.Text = dt_out.Rows[0]["辐照批号"].ToString(); tb报告编号.DataBindings.Clear(); tb报告编号.Text = dt_out.Rows[0]["报告编号"].ToString(); tb验收人.DataBindings.Clear(); tb验收人.Text = dt_out.Rows[0]["验收人"].ToString(); setFormState(); setEnableReadOnly(); cb委托单号.Enabled = false; bt插入查询.Enabled = false; }
public beeholetable(mySystem.MainForm mainform) : base(mainform) { filltop = 150; titletop = 80; titleleft = 250; InitializeComponent(); addLayout(); fillTitle(); fillRecord1(); fillModelhead(); fillCreamout(); fillParameters(); btAdd.Visible = false; btSel.Visible = false; btChk.Visible = false; functions.Visible = false; }
public 辐照灭菌产品验收记录(mySystem.MainForm mainform) : base(mainform) { InitializeComponent(); getPeople(); setUserState(); getOtherData(); foreach (Control c in this.Controls) { c.Enabled = false; } cb委托单号.Enabled = true; bt插入查询.Enabled = true; cb委托单号.SelectedItem = mySystem.Parameter.miejunInstruction; code = cb委托单号.Text; instruID = mySystem.Parameter.miejunInstruID; }
public DailyRecord(mySystem.MainForm mainform) : base(mainform) { InitializeComponent(); fill_printer(); conOle = mySystem.Parameter.connOle; getPeople(); setUserState(); __生产指令 = mySystem.Parameter.cleancutInstruction; __生产指令ID = mySystem.Parameter.cleancutInstruID; foreach (string m in matCodes) { cmb物料种类.Items.Add(m); } cmb物料种类.SelectedIndexChanged += new EventHandler(cmb物料种类_SelectedIndexChanged); addOtherEventHandler(); //getPeople()--> setUserState()--> getOtherData()--> Computer() --> addOtherEvnetHandler()-->setFormState()-->setEnableReadOnly() setEnableReadOnly(); }
public 辐照灭菌台帐(mySystem.MainForm mainform) : base(mainform) { InitializeComponent(); getPeople(); setUserState(); getOtherData(); readOuterData(); outerBind(); readInnerData(); innerBind(); addComputerEventHandler(); setFormState(); setEnableReadOnly(); addOtherEventHandler(); setDataGridViewRowNums(); initQuery(); }
public Gamma射线辐射灭菌委托单(mySystem.MainForm mainform, int id) : base(mainform) { InitializeComponent(); getPeople(); setUserState(); getOtherData(); addDataEventHandler(); string asql = "select * from Gamma射线辐射灭菌委托单 where ID=" + id; DataTable tempdt = new DataTable(); if (!mySystem.Parameter.isSqlOk) { OleDbCommand comm = new OleDbCommand(asql, mySystem.Parameter.connOle); OleDbDataAdapter da = new OleDbDataAdapter(comm); da.Fill(tempdt); } else { SqlCommand comm = new SqlCommand(asql, mySystem.Parameter.conn); SqlDataAdapter da = new SqlDataAdapter(comm); da.Fill(tempdt); } str_委托单 = tempdt.Rows[0]["委托单号"].ToString(); readOuterData(str_委托单); outerBind(); readInnerData((int)dt_prodinstr.Rows[0]["ID"]); innerBind(); setFormState(); setEnableReadOnly(); tb委托单号.Enabled = false; bt查询插入.Enabled = false; }