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