private void mzl_Click(object sender, EventArgs e) { if (gctm.Text == "") { gctm.Text = wl.Text.PadLeft(5, '0') + Globals.GetTimeStamp(); } }
private void mcd_Click(object sender, EventArgs e) { //decimal cd = 0; //for (int i = 0; i < dataGridView1.RowCount - 1; i++) //{ // cd = cd + decimal.Parse(dataGridView1.Rows[i].Cells["sycd1"].Value.ToString()); // // dataGridView1.Rows[i].Cells["sycd"].Value //} //mcd.Text = cd.ToString(); if (gctm.Text == "") { gctm.Text = wl.Text.PadLeft(5, '0') + Globals.GetTimeStamp(); } // mkd.Text = dataGridView1.Rows[0].Cells["mk"].Value.ToString(); // mhd.Text = dataGridView1.Rows[0].Cells["mh"].Value.ToString(); }
private void toolStripButton1_Click(object sender, EventArgs e) { // FPt pt1 = new FPt("", 1); if (dataGridView1.RowCount <= 1) { MessageBox.Show("信息不全不能保存"); return; } for (int i = 0; i < dataGridView1.RowCount - 1; i++) { if (dataGridView1.Rows[i].Cells["sycd1"].Value == null) { MessageBox.Show("使用长度必须为数字"); return; } if (!Globals.CheckNumber(dataGridView1.Rows[i].Cells["sycd1"].Value.ToString().Trim())) { MessageBox.Show("使用长度必须为数字"); return; } if (decimal.Parse(dataGridView1.Rows[i].Cells["sycd1"].Value.ToString().Trim()) > decimal.Parse(dataGridView1.Rows[i].Cells["kycd"].Value.ToString().Trim())) { MessageBox.Show("使用长度不能超可用长度"); dataGridView1.Rows[i].Cells["sycd1"].Value = null; dataGridView1.Rows[i].Cells["sycd1"].Style.BackColor = Color.Red; return; } } if (MessageBox.Show("是否需要保存", "确认", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.No) { return; //否就退出操作 } if (js.Text != "") { if (!Globals.CheckNumber(js.Text.ToString().Trim())) { MessageBox.Show("卷数必须为数字"); js.Text = null; return; } } else { MessageBox.Show("卷数必须录入"); // mkd.Text = null; return; } if (mcd.Text != "") { if (!Globals.CheckNumber(mcd.Text.ToString().Trim())) { MessageBox.Show("膜长度必须为数字"); mkd.Text = null; return; } } else { MessageBox.Show("膜长度必须录入"); return; } if (qds.Text != "") { if (!Globals.CheckNumber(qds.Text.ToString().Trim())) { MessageBox.Show("刀数必须为数字"); qds.Text = null; return; } } else { MessageBox.Show("刀数必须录入"); return; } if (dataGridView1.RowCount < 1) { MessageBox.Show("信息不全不能保存"); return; } try { ds.Tables["tgx"].Clear(); } catch { } try { ds.Tables["gxb"].Clear(); } catch { } string insertsql = "SELECT FBarcode, FWork, FQty, FMcd, FMkd, FMhd, FJs, FBc, FJyy, FBz, FUnitID, FICMOID, FItemID, FJlr, FJlrq,FRkd, FSfrk, FSfyw, FICMOBillNo ,FBatchNo ,FMustSh,Fjh,Fds,FXh FROM Tgx where 1=2 "; SqlDataAdapter gxjl = new SqlDataAdapter(insertsql, conn); gxjl.Fill(ds, "tgx"); SqlCommandBuilder sb1 = new SqlCommandBuilder(gxjl); string sql = "select fyctm,fsycd,FCptm from Tylcpgx where 1=2";//保存对应关系到Tylcpgx表 SqlDataAdapter dtylgx = new SqlDataAdapter(sql, conn); dtylgx.Fill(ds, "gxb");//过程记录表 SqlCommandBuilder sb = new SqlCommandBuilder(dtylgx); DataRow newrowgx; DataRow newrow; string tm; string tmhb = ""; string sqlmax = "select FXh ,FJlrq from tgx where FICMOBillNo='" + comboBox1.SelectedValue + "' and FWork='分切' order by FXh desc"; DataTable maxdata = sj.ds(sqlmax, "zdz", conn); if (maxdata.Rows.Count < 1) { zxh.Text = "1"; jlrq.Text = DateTime.Now.ToString(); } else { zxh.Text = (int.Parse(maxdata.Rows[0][0].ToString()) + 1).ToString(); jlrq.Text = maxdata.Rows[0][1].ToString(); } for (int j = 0; j < int.Parse(qds.Text.Trim()); j++) //刀数控制 { for (int i = 0; i < int.Parse(js.Text.Trim()); i++) //卷数控制 { newrowgx = ds.Tables["tgx"].NewRow(); newrowgx["FBarcode"] = tm = wl.Text.PadLeft(5, '0') + Globals.GetTimeStamp(); for (int k = 0; k < dataGridView1.RowCount - 1; k++) { newrow = ds.Tables["gxb"].NewRow(); newrow["fcptm"] = newrowgx["FBarcode"]; newrow["fyctm"] = dataGridView1.Rows[k].Cells["tm"].Value.ToString(); try { if (dataGridView1.Rows[i].Cells["yw"].Value.ToString() == "是") { newrow["fsycd"] = (decimal.Parse(dataGridView1.Rows[k].Cells["kycd"].Value.ToString()) / int.Parse(js.Text.Trim()) / int.Parse(qds.Text.Trim())).ToString(("#0.0000")); } else { newrow["fsycd"] = (decimal.Parse(dataGridView1.Rows[k].Cells["sycd1"].Value.ToString()) / int.Parse(js.Text.Trim()) / int.Parse(qds.Text.Trim())).ToString(("#0.0000")); } } catch { newrow["fsycd"] = (decimal.Parse(dataGridView1.Rows[k].Cells["sycd1"].Value.ToString()) / int.Parse(js.Text.Trim()) / int.Parse(qds.Text.Trim())).ToString(("#0.0000")); } // newrow["fsycd"] = (decimal.Parse(dataGridView1.Rows[k].Cells["sycd1"].Value.ToString()) / int.Parse(js.Text.Trim()) / int.Parse(qds.Text.Trim())).ToString(("#0.0000")); ds.Tables["gxb"].Rows.Add(newrow); } tmhb += tm + "|"; Thread.Sleep(1); newrowgx["FWork"] = "分切"; if (mzl.Text != "") { newrowgx["fqty"] = mzl.Text.Trim(); } if (mcd.Text != "") { newrowgx["fmcd"] = mcd.Text.Trim(); } if (mkd.Text != "") { newrowgx["fmkd"] = mkd.Text.Trim(); } if (mhd.Text != "") { newrowgx["FMhd"] = mhd.Text.Trim(); } newrowgx["fbc"] = bc.Text; newrowgx["FJyy"] = jyy.Text; newrowgx["fbz"] = bz.Text; newrowgx["FJlr"] = jlr.Text; newrowgx["FJlrq"] = jlrq.Text; newrowgx["FItemID"] = wl.Text; newrowgx["FRkd"] = (rkd.Text == "1") ? true : false; newrowgx["FICMOBillNo"] = comboBox1.Text; newrowgx["FBatchNo"] = label6.Text; newrowgx["FXh"] = zxh.Text; newrowgx["Fjh"] = i + 1; // 卷号 newrowgx["FDs"] = j + 1; //刀数 ds.Tables["tgx"].Rows.Add(newrowgx); // newrow["fyctm"] = dataGridView1.Rows[0].Cells["tm"].Value.ToString(); // newrow["fsycd"] = (decimal.Parse(dataGridView1.Rows[0].Cells["sycd1"].Value.ToString()) / int.Parse(js.Text.Trim())/int.Parse(qds.Text.Trim())).ToString(("#0.0000")); // newrow["flx"] = true; // newrow["fcptm"] = gctm.Text; } } gxjl.Update(ds.Tables["tgx"]); dtylgx.Update(ds.Tables["gxb"]); //打印标签 for (int j = 0; j < int.Parse(qds.Text.Trim()); j++) { for (int i = 0; i < int.Parse(js.Text.Trim()); i++) { string ptnr = label6.Text + "-" + zxh.Text + "-" + (j + 1).ToString() + "-" + (i + 1).ToString() + "(" + Globals.userid + ")" + "|" + tmhb.Split('|')[i] + "|" + label8.Text; FPt pt = new FPt(ptnr, 1); } } conn.Close(); try { yscl.Text = (decimal.Parse(yscl.Text.Trim()) + decimal.Parse(mcd.Text.Trim()) * int.Parse(js.Text.Trim()) * int.Parse(qds.Text.Trim())).ToString(); } catch { yscl.Text = (decimal.Parse(mcd.Text.Trim()) * int.Parse(js.Text.Trim()) * int.Parse(qds.Text.Trim())).ToString(); } clearjm(); label14.Text = ""; label5.Text = ""; zxh.Clear(); qds.Clear(); dataGridView1.Rows.Clear(); if (!lgxl()) { MessageBox.Show("料已用完"); } }
private void dataGridView1_KeyUp(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Enter & dataGridView1.CurrentCell.ColumnIndex == 0)//是否选择的是第一个单元格 { //验证不通过 try { if (!yanzheng(dataGridView1.CurrentRow.Cells["tm"].Value.ToString(), dataGridView1.CurrentCell.RowIndex)) { dataGridView1.CurrentRow.Cells["tm"].Value = ""; return; } // dataGridView1.CurrentCell //扫描原料条码 在dt_ycl中 查询 if (dt_gxl.Rows.Count != 0) { try { DataRow[] drArr = dt_gxl.Select("条码 = '" + dataGridView1.CurrentCell.Value.ToString().Trim() + "'"); dataGridView1.CurrentRow.Cells["kycd"].Value = drArr[0]["可用长度"]; //膜长 dataGridView1.CurrentRow.Cells["sycd1"].Value = drArr[0]["可用长度"]; //膜长 dataGridView1.CurrentCell = dataGridView1[4, dataGridView1.CurrentCell.RowIndex]; dataGridView1.CurrentRow.Cells["mk"].Value = drArr[0]["膜宽"]; dataGridView1.CurrentRow.Cells["mh"].Value = drArr[0]["膜厚"]; decimal cd = 0; int js = 0; for (int i = 0; i < dataGridView1.RowCount - 1; i++) { cd = cd + decimal.Parse(dataGridView1.Rows[i].Cells["sycd1"].Value.ToString().Trim()); // dataGridView1.Rows[i].Cells["sycd"].Value js = i + 1; } zxjs.Text = js.ToString(); mcd.Text = cd.ToString(); if (gctm.Text == "") { gctm.Text = wl.Text.PadLeft(5, '0') + Globals.GetTimeStamp(); } try { mkd.Text = dataGridView1.Rows[0].Cells["mk"].Value.ToString(); mhd.Text = dataGridView1.Rows[0].Cells["mh"].Value.ToString(); } catch { } if (gctm.Text == "") { gctm.Text = wl.Text.PadLeft(5, '0') + Globals.GetTimeStamp(); } //dataGridView1.CurrentRow.Cells[""].Value = drArr[0][""]; //dataGridView1.CurrentRow.Cells[""].Value = drArr[0][""]; //dataGridView1.CurrentRow.Cells[""].Value = drArr[0][""]; } catch { MessageBox.Show("错误的条码,请重新扫描"); dataGridView1.CurrentRow.Cells["tm"].Value = ""; } return; } else { MessageBox.Show("请先做生产领料单"); } } catch { MessageBox.Show("错误的条码"); return; } } if (e.KeyCode == Keys.Enter & dataGridView1.CurrentCell.ColumnIndex == 4)//是否选择的是第6个单元格 { if (!Globals.CheckNumber(dataGridView1.CurrentRow.Cells["sycd1"].Value.ToString().Trim())) { MessageBox.Show("请输入数字"); dataGridView1.CurrentRow.Cells["sycd1"].Value = null; return; } if (decimal.Parse(dataGridView1.CurrentRow.Cells["sycd1"].Value.ToString().Trim()) > decimal.Parse(dataGridView1.CurrentRow.Cells["kycd"].Value.ToString().Trim())) { MessageBox.Show("使用长度不能超过膜长度"); dataGridView1.CurrentRow.Cells["sycd1"].Value = null; return; } } }