private void refView(List <T_PFmain> getAll)
{
dgvEX1.Rows.Clear();
for (var i = 0; i < getAll.Count; i++)
{
T_PFmain dataRowCollection = getAll[i];
int index = dgvEX1.Rows.Add();
dgvEX1.Rows[index].Tag = dataRowCollection.SN;
dgvEX1.Rows[index].Cells[0].Value = dataRowCollection.danhao;
dgvEX1.Rows[index].Cells[1].Value = dataRowCollection.kehu;
dgvEX1.Rows[index].Cells[2].Value = dataRowCollection.shazhong;
dgvEX1.Rows[index].Cells[3].Value = dataRowCollection.sehao;
dgvEX1.Rows[index].Cells[4].Value = dataRowCollection.yanse;
dgvEX1.Rows[index].Cells[5].Value = dataRowCollection.dingdan;
dgvEX1.Rows[index].Cells[6].Value = dataRowCollection.riqiSave; //.ObjToString("yyyy-MM-dd HH:mm:ss");
dgvEX1.Rows[index].Cells[7].Value = dataRowCollection.peifang;
dgvEX1.Rows[index].Cells[8].Value = dataRowCollection.riqiShen; //.ObjToString("yyyy-MM-dd HH:mm:ss");
dgvEX1.Rows[index].Cells[9].Value = dataRowCollection.fuhe;
dgvEX1.Rows[index].Cells[10].Value = dataRowCollection.dayang;
dgvEX1.Rows[index].Cells[11].Value = dataRowCollection.beizhu;
dgvEX1.Rows[index].Cells[mainColSta.Name].Value = dataRowCollection.sta;
dgvEX1.Rows[index].Cells[13].Value = dataRowCollection.SN;
}
dgvEX1.HeJi();
}
private void setInput(T_PFmain a, List <T_PFdata> b)
{
lblTxt1.txt.Text = a.kehu;
lblTxt2.txt.Text = a.dingdan;
lblTxt3.txt.Text = a.yanse;
lblTxt4.txt.Text = a.shazhong;
lblTxt5.txt.Text = a.dayang;
lblTxt6.txt.Text = a.sehao;
lblTxt7.txt.Text = a.beizhu;
for (var i = 0; i < b.Count; i++)
{
var t_PFdata = b[i];
int index = dgvEX1.Rows.Add();
dgvEX1.Rows[index].Cells[0].Value = t_PFdata.gongxu;
dgvEX1.Rows[index].Cells[1].Value = t_PFdata.ranliao;
dgvEX1.Rows[index].Cells[2].Value = t_PFdata.bili;
dgvEX1.Rows[index].Cells[3].Value = t_PFdata.biliDW;
dgvEX1.Rows[index].Cells[4].Value = t_PFdata.yaoqiu;
dgvEX1.Rows[index].Cells[5].Value = t_PFdata.SN;
}
string code = a.danhao;
setPict(code);
editLblStaLD.Text = a.sta;
if (this.editLblStaLD.Text == leibie.staPF.未审核.ToString())
{
editBtnSH.Text = "审核";
this.editBtnSH.Enabled = true;
this.editBtnEdit.Enabled = true;
this.editBtnDel.Enabled = true;
this.editBtnPrn.Enabled = false;
}
else
{
this.editBtnSH.Text = "消审";
this.editBtnSH.Enabled = true;
this.editBtnPrn.Enabled = true;
this.editBtnDel.Enabled = false;
this.editBtnEdit.Enabled = false;
}
this.bsShowMain.DataSource = (object)a;
this.bsShowData.DataSource = (object)b;
}
private void CLstart()
{
if (this.dgvData.CurrentRow.Index < 0)
{
this.TSsound.SoundLocation = Application.StartupPath + "\\Sound\\error.wav";
this.TSsound.Play();
frmError frmError = new frmError("当前称料行不存在!请再次查询!");
int num = (int)frmError.ShowDialog((IWin32Window)this);
frmError.Close();
}
else
{
//DBpf dbpf = new DBpf(Settings.Default.DBconn);
//T_PFmain tPfmain = dbpf.T_PFmain.Where<T_PFmain>((Expression<Func<T_PFmain, bool>>)(a => a.danhao == this.txtLDH.Text)).SingleOrDefault<T_PFmain>();
T_PFmain tPfmain = db.Queryable <T_PFmain>()
.Where(a => a.danhao == this.txtLDH.Text)
.First();
if (tPfmain == null || tPfmain.sta != "已审核")
{
//dbpf.Dispose();
this.TSsound.SoundLocation = Application.StartupPath + "\\Sound\\error.wav";
this.TSsound.Play();
frmError frmError = new frmError("料单未审核或不存在!请再次查询!");
int num = (int)frmError.ShowDialog((IWin32Window)this);
frmError.Close();
}
else
{
//T_PFdata tPfdata = dbpf.T_PFdata.Where<T_PFdata>((Expression<Func<T_PFdata, bool>>)(a => a.SN == (long)this.dgvData.CurrentRow.Cells[this.colSN.Name].Value)).SingleOrDefault<T_PFdata>();
T_PFdata tPfdata = db.Queryable <T_PFdata>()
.Where(a => a.SN == (long)this.dgvData.CurrentRow.Cells[this.colSN.Name].Value)
.First();
if (tPfdata == null || tPfdata.ranliao != this.dgvData.CurrentRow.Cells[this.colRL.Name].Value.ToString())
{
//dbpf.Dispose();
this.TSsound.SoundLocation = Application.StartupPath + "\\Sound\\error.wav";
this.TSsound.Play();
frmError frmError = new frmError("料单数据发生了改变!请再次查询!");
int num = (int)frmError.ShowDialog((IWin32Window)this);
frmError.Close();
}
else
{
Decimal num1 = new Decimal(0);
Decimal num2;
if (this.txtLDH.Text.StartsWith("LD") || this.txtLDH.Text.Length == 10 && this.txtLDH.Text.StartsWith("8"))
{
num2 = tPfdata.yongliang;
if (tPfdata.yongliangDW == "Kg" || tPfdata.yongliangDW == "L")
{
num2 *= new Decimal(1000);
}
}
else
{
num2 = tPfdata.JLyongliang;
if (tPfdata.JLyongliangDW == "Kg" || tPfdata.JLyongliangDW == "L")
{
num2 *= new Decimal(1000);
}
}
if (num2 != (Decimal)this.dgvData.CurrentRow.Cells[this.colYL.Name].Value)
{
//dbpf.Dispose();
this.TSsound.SoundLocation = Application.StartupPath + "\\Sound\\error.wav";
this.TSsound.Play();
frmError frmError = new frmError("料单数据发生了改变!请再次查询!");
int num3 = (int)frmError.ShowDialog((IWin32Window)this);
frmError.Close();
}
else
{
//dbpf.Dispose();
if (this.dgvData.CurrentRow.Cells[this.colCL.Name].FormattedValue.ToString() != "" && Convert.ToDecimal(this.dgvData.CurrentRow.Cells[this.colCL.Name].FormattedValue.ToString()) > new Decimal(0))
{
this.TSsound.SoundLocation = Application.StartupPath + "\\Sound\\error.wav";
this.TSsound.Play();
this.lblTS.Visible = false;
frmTS frmTs = new frmTS(this.CLrl, this.CLcheng, this.CLdeng, "该染料已称过，再称一次吗!!!", "“确认”再称一次", "“清除”取消称料", Keys.Back);
DialogResult dialogResult = frmTs.ShowDialog((IWin32Window)this);
frmTs.Close();
this.lblTS.Visible = true;
if (dialogResult != DialogResult.OK)
{
return;
}
}
if (this.CLcheng < 0)
{
this.TSsound.SoundLocation = Application.StartupPath + "\\Sound\\error.wav";
this.TSsound.Play();
frmError frmError = new frmError("无法找到合适的称,请核对!");
int num3 = (int)frmError.ShowDialog((IWin32Window)this);
frmError.Close();
}
else
{
if (!this.plcCL.OpenDeng(this.CLdeng))
{
this.plcCL.OpenDeng(this.CLdeng);
}
this.staCL = frmCL.enumSta.称料正在;
this.CLerrTPcount = 0;
this.CLokCount = 0;
this.CLallowKey = false;
this.lblTPerr.Text = "";
this.CLzero();
}
}
}
}
}
}
private bool Save()
{
if (editImgLDH.Image == null || editImgLDH.Tag == null)
{
int num = (int)MessageBox.Show((IWin32Window)this, "生成单号失败,请检查!!!", "提示");
return(false);
}
try
{
T_PFmain entity = new T_PFmain()
{
leibie = leibie.enumPFLB.小样单.ToString(),
danhao = this.editImgLDH.Tag.ToString(),
ganghao = "",
JLci = 0,
shazhong = lblTxt4.txt.Text,
guige = "",
pihao = "",
kehu = lblTxt1.txt.Text,
dingdan = lblTxt2.txt.Text,
sehao = lblTxt6.txt.Text,
yanse = lblTxt3.txt.Text,
jihao = "",
shuiliang = new Decimal(0),
zhongliang = new Decimal(0),
jiagong = "",
yewuyuan = "",
dayang = lblTxt5.txt.Text,
zhuche = "",
peifang = ClsLogUser.XinMing,
fuhe = "",
mishu = new Decimal(0),
kezhong = "0",
danjia = new Decimal(0),
beizhu = lblTxt7.txt.Text,
riqiSave = new DateTime?(DateTime.Now),
riqiShen = new DateTime?(),
riqiCheng = new DateTime?(),
JLciHJ = 0,
sta = leibie.staPF.未审核.ToString(),
editrec = DateTime.Now.ToString("yy-MM-dd HH:mm") + ClsLogUser.XinMing + "建立。"
};
var d = db.Insertable <T_PFmain>(entity).ExecuteCommand();
for (int index = 0; index < dgvEX1.RowCount; ++index)
{
T_PFdata a = new T_PFdata()
{
danhao = entity.danhao,
gongxu = dgvEX1.Rows[index].Cells[0].FormattedValue.ToString(),
ranliao = dgvEX1.Rows[index].Cells[1].FormattedValue.ToString(),
ranliaoBZ = "",
bili = dgvEX1.Rows[index].Cells[2].FormattedValue.ToString() == "" ? new Decimal(0) : Convert.ToDecimal(dgvEX1.Rows[index].Cells[2].FormattedValue.ToString()),
biliDW = dgvEX1.Rows[index].Cells[3].FormattedValue.ToString(),
yaoqiu = dgvEX1.Rows[index].Cells[4].FormattedValue.ToString(),
yongliang = new Decimal(0),
yongliangDW = "",
JLbili = new Decimal(0),
JLyongliang = new Decimal(0),
JLyongliangDW = "",
SNld = -1L
};
var e = db.Insertable <T_PFdata>(a).ExecuteCommand();
}
return(true);
}
catch (Exception ex)
{
int num = (int)MessageBox.Show((IWin32Window)this, ex.Message + "\r\n\r\n 保存失败,请核查原因再试一次!", "提示");
return(false);
}
}
