private void RLdata(List <PeibuCang> asdf) { dgvEX1.Rows.Clear(); //if (asdf == null || baseIList == null) return; for (var i = 0; i < asdf.Count; i++) { PeibuCang baseIList = asdf[i]; int index = dgvEX1.Rows.Add(); dgvEX1.Rows[index].Tag = baseIList.SN; dgvEX1.Rows[index].Cells[0].Value = baseIList.riqimake; dgvEX1.Rows[index].Cells[1].Value = baseIList.danhao; dgvEX1.Rows[index].Cells[2].Value = baseIList.kehu; dgvEX1.Rows[index].Cells[3].Value = baseIList.pinming; dgvEX1.Rows[index].Cells[4].Value = baseIList.zongpishu; dgvEX1.Rows[index].Cells[5].Value = baseIList.liushuihao; dgvEX1.Rows[index].Cells[6].Value = baseIList.zongzhong; dgvEX1.Rows[index].Cells[7].Value = baseIList.pishu; dgvEX1.Rows[index].Cells[8].Value = baseIList.yewuyuan; dgvEX1.Rows[index].Cells[9].Value = baseIList.pihao; dgvEX1.Rows[index].Cells[10].Value = baseIList.cangwei; dgvEX1.Rows[index].Cells[11].Value = baseIList.beizhu1; } dgvEX1.HeJi(); }
private bool Save() { /* * var all1 = db.Queryable<PeibuCang>() * .Where(it => int.Parse(it.liushuihao) == int.Parse(lblGH.txt.Text)) * .OrderBy(it => it.liushuihao, OrderByType.Desc) * .First(); * if (all1 == null) * { * MessageBoxEx.Show("这没有发现此缸号重新选择"); * return false; * } * else */ { PeibuCang baseIList = new PeibuCang() { riqimake = DateTime.Now, kehu = lblKH.cobodgv.Text, danhao = lblRKDH.txt.Text, pinming = lblPM.cobodgv.Text, zongpishu = lblZPS.txt.Text, yewuyuan = lblYWY.cobodgv.Text, pishu = lblPS.txt.Text, cangwei = lblCW.cobodgv.Text, zongzhong = lblZZ.txt.Text, pihao = lblPH.txt.Text, beizhu1 = lblBZ.txt.Text, item0 = lblDH.cobodgv.Text, status = "1", liushuihao = lblZZ.txt.Text, }; try { db.Insertable <PeibuCang>(baseIList).ExecuteCommand(); return(true); }catch (Exception ex) { MessageBoxEx.Show(ex.Message, "提示"); return(false); } } }
private bool Save() { if (lblKCDH.txt.Text.Length == 0) { MessageBoxEx.Show("请选择领用胚布", "提示"); return(false); } var all1 = db.Queryable <PeibuCang>() .Where(it => it.danhao == lblKCDH.txt.Text) .OrderBy(it => it.SN, OrderByType.Desc) .First(); if (all1 == null) { MessageBoxEx.Show("没有发现此该胚布,重新选择"); return(false); } else { var a = db.Queryable <PeibuCang>() .Where(it => it.danhao == lblKCDH.txt.Text && it.status == "1") .First(); if (lblZZ.txt.Text.Length == 0) { MessageBoxEx.Show("重量必须输入", "提示"); return(false); } if (Int32.Parse(a.pishu) == 0) { MessageBoxEx.Show("该胚布已被领完", "提示"); return(false); } if (Int32.Parse(a.pishu) < Int32.Parse(lblPS.txt.Text)) { MessageBoxEx.Show("领用匹数不超过总匹数", "提示"); return(false); } if (Int32.Parse(a.zongzhong) == 0) { MessageBoxEx.Show("该胚布已被领完", "提示"); return(false); } if (Int32.Parse(a.zongzhong) < Int32.Parse(lblZZ.txt.Text)) { MessageBoxEx.Show("领用重量不能超过总重", "提示"); return(false); } int ps = (Int32.Parse(a.pishu) - Int32.Parse(lblPS.txt.Text)); int zz = (Int32.Parse(a.zongzhong) - Int32.Parse(lblZZ.txt.Text)); if ((ps != 0 && zz == 0) || (ps == 0 && zz != 0)) { MessageBoxEx.Show("领用匹数和重量应该同时为0", "提示"); return(false); } PeibuCang baseIList = new PeibuCang() { riqimake = DateTime.Now, kehu = lblKH.cobodgv.Text, beizhu2 = lblKCDH.txt.Text, danhao = lblRKDH.txt.Text, pinming = lblPM.cobodgv.Text, zongpishu = lblZPS.txt.Text, yewuyuan = lblYWY.cobodgv.Text, pishu = lblPS.txt.Text, cangwei = lblCW.cobodgv.Text, zongzhong = lblZZ.txt.Text, pihao = lblPH.txt.Text, beizhu1 = lblBZ1.txt.Text, item0 = lblDH.txt.Text, status = "2", }; try { db.Insertable <PeibuCang>(baseIList).ExecuteCommand(); a.pishu = (Int32.Parse(a.pishu) - Int32.Parse(lblPS.txt.Text)) + ""; a.zongzhong = (Int32.Parse(a.zongzhong) - Int32.Parse(lblZZ.txt.Text)) + ""; db.Updateable <PeibuCang>(a).ExecuteCommand(); return(true); }catch (Exception ex) { MessageBoxEx.Show(ex.Message, "提示"); return(false); } } }