private bool Insert()
{
bool flag = false;
if (!YanZheng())
{
return(flag);
}
try
{
var get = db.Queryable <T_Base>().Where(it => it.leibie == SHAZHONG && it.bianhao == lblTxt1.txt.Text).Count();
if (get != 0)
{
int num = (int)MessageBox.Show(lblTxt1.lblText + " 已存在!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Hand);
return(flag);
}
var insertObj = new T_Base()
{
leibie = SHAZHONG,
bianhao = lblTxt1.txt.Text,
itemName = lblTxt2.txt.Text,
};
var t2 = db.Insertable <T_Base>(insertObj).ExecuteReturnIdentity();
if (t2 > 0)
{
flag = true;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
return(flag);
}
private void ShowData(List <T_Base> getAll)
{
if (getAll == null)
{
return;
}
dgvEX1.Rows.Clear();
for (var i = 0; i < getAll.Count; i++)
{
T_Base dataRowCollection = getAll[i];
int index = dgvEX1.Rows.Add();
dgvEX1.Rows[index].Tag = dataRowCollection.SN;
dgvEX1.Rows[index].Cells[0].Value = dataRowCollection.bianhao;
dgvEX1.Rows[index].Cells[1].Value = dataRowCollection.itemName;
dgvEX1.Rows[index].Cells[2].Value = dataRowCollection.item0;
dgvEX1.Rows[index].Cells[3].Value = dataRowCollection.item5;
dgvEX1.Rows[index].Cells[4].Value = dataRowCollection.item1;
dgvEX1.Rows[index].Cells[5].Value = dataRowCollection.item2;
dgvEX1.Rows[index].Cells[6].Value = dataRowCollection.item3;
dgvEX1.Rows[index].Cells[7].Value = dataRowCollection.item4;
dgvEX1.Rows[index].Cells[8].Value = dataRowCollection.beizhu;
}
dgvEX1.HeJi();
}
public Form1()
{
this.EnableGlass = false;
db = SqlBase.GetInstance();
InitializeComponent();
this.DoubleBuffered = true;
//将指定的标志设置为true或false
this.SetStyle(ControlStyles.OptimizedDoubleBuffer, true);
//强制将分配的样式重新应用到控件
this.UpdateStyles();
string user_sn = Settings.Default.islogin;
long UserSn = 0;
try
{
UserSn = long.Parse(user_sn);
}
catch (Exception ex)
{
MessageBox.Show("登录数据丢失请重新登录");
Settings.Default.islogin = "";
Settings.Default.Save();
return;
}
if (user_sn.Length == 0)
{
MessageBox.Show("登录数据丢失请重新登录");
Settings.Default.islogin = "";
Settings.Default.Save();
return;
}
else
{
T_Base t_Base = db.Queryable <T_Base>()
.Where(it => it.SN == UserSn && it.leibie == ClsLogUser.LeiBie)
.First();
if (t_Base == null)
{
MessageBox.Show("登录数据丢失请重新登录");
Settings.Default.islogin = "";
Settings.Default.Save();
return;
}
else
{
ClsLogUser.SNuser = t_Base.SN;
ClsLogUser.BianHao = t_Base.bianhao;
ClsLogUser.XinMing = t_Base.itemName;
ClsLogUser.PassWord = t_Base.item0;
ClsLogUser.QuanXian = db.Queryable <T_BaseQX>().Where(it => it.SNuser == ClsLogUser.SNuser).ToList();
labelItem1.Text = "当前用户名:" + ClsLogUser.XinMing + " 编号:" + ClsLogUser.BianHao;
}
}
InitMunu();
}
private void SetText(T_Base nowRow)
{
Empty();
if (nowRow != null)
{
txtBH.txt.Text = nowRow.bianhao;
txtXM.txt.Text = nowRow.itemName;
txtMK.txt.Text = UserProc.DecryptDES(nowRow.item0, "12345678");
lblTxt4.txt.Text = nowRow.item1;
lblTxt5.txt.Text = nowRow.beizhu;
}
}
//过渡函数
private void ShowData(List <T_Base> getAll)
{
dgvEX1.Rows.Clear();
for (var i = 0; i < getAll.Count; i++)
{
T_Base dataRowCollection = getAll[i];
int index = dgvEX1.Rows.Add();
dgvEX1.Rows[index].Tag = dataRowCollection.SN;
dgvEX1.Rows[index].Cells[0].Value = dataRowCollection.bianhao;
dgvEX1.Rows[index].Cells[1].Value = dataRowCollection.itemName;
}
dgvEX1.HeJi();
}
private bool Insert()
{
bool flag = false;
if (!YanZheng())
{
return(flag);
}
try
{
var get = db.Queryable <T_Base>().Where(it => it.leibie == "客户" && it.bianhao == lblTxt1.txt.Text).Count();
if (get != 0)
{
int num = (int)MessageBox.Show(lblTxt1.lblText + " 已存在!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Hand);
return(flag);
}
get = db.Queryable <T_Base>().Where(it => it.leibie == "客户" && it.itemName == lblTxt4.txt.Text).Count();
if (get != 0)
{
int num = (int)MessageBox.Show(lblTxt4.lblText + " 已存在!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Hand);
return(flag);
}
var insertObj = new T_Base()
{
leibie = "客户",
bianhao = lblTxt1.txt.Text,
itemName = lblTxt4.txt.Text,
item0 = lblTxt2.txt.Text,
item1 = lblTxt5.txt.Text,
item2 = lblTxt3.txt.Text,
item3 = lblTxt6.txt.Text,
item4 = lblTxt8.txt.Text,
item5 = lblCoboDGV1.cobodgv.Text,
beizhu = lblTxt7.txt.Text
};
var t2 = db.Insertable <T_Base>(insertObj).ExecuteReturnIdentity();
if (t2 > 0)
{
flag = true;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
return(flag);
}
private void Login()
{
try
{
T_Base t_Base = db.Queryable <T_Base>()
.Where(it => (it.itemName == textBox1.Text || it.bianhao == textBox1.Text) && it.item0 == UserProc.EncryptDES(textBox2.Text, "123456789") && it.leibie == "用户登录")
.Single();
if (t_Base == null)
{
MessageBox.Show("用户名或者密码错误");
return;
}
Settings.Default.islogin = t_Base.SN + "";
Settings.Default.Save();
this.DialogResult = DialogResult.OK;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private bool cheng_plc_init()
{
//DBpf dbpf = new DBpf(Settings.Default.DBconn);
//T_Base tBase = dbpf.T_Base.Where<T_Base>((Expression<Func<T_Base, bool>>)(a => a.leibie == PeiFang.BaseItem.leibie.enumLB.称料设置.ToString() && a.bianhao == this.jihao)).SingleOrDefault<T_Base>();
T_Base tBase = db.Queryable <T_Base>()
.Where(a => a.leibie == "称料设置" && a.bianhao == this.jihao)
.First();
//dbpf.Dispose();
if (tBase == null)
{
frmError frmError = new frmError("无法找到本机台参数设置数据!!!");
int num = (int)frmError.ShowDialog((IWin32Window)this);
frmError.Close();
return(false);
}
for (int index = 0; index < 4; ++index)
{
string str1;
string str2;
string[] CLparaCheng = Settings.Default.CLparaCheng.Split('|');
if (index == 0)
{
str1 = tBase.item1;
str2 = CLparaCheng[0];
}
else if (index == 1)
{
str1 = tBase.item2;
str2 = CLparaCheng[1];
}
else if (index == 2)
{
str1 = tBase.item3;
str2 = CLparaCheng[2];
}
else
{
str1 = tBase.item4;
str2 = CLparaCheng[3];
}
if (str1 != "" && str2 != "")
{
string[] strArray1 = str1.Split(',');
string[] strArray2 = str2.Split(',');
if (strArray1.Length != 7)
{
frmError frmError = new frmError((index + 1).ToString() + " 号电子称参数设置错误!!!");
int num = (int)frmError.ShowDialog((IWin32Window)this);
frmError.Close();
return(false);
}
if (strArray2.Length != 8)
{
frmError frmError = new frmError((index + 1).ToString() + " 号电子称通讯设置错误!!!");
int num = (int)frmError.ShowDialog((IWin32Window)this);
frmError.Close();
return(false);
}
if (index > 0 && this.cheng[index - 1] == null)
{
frmError frmError = new frmError("请按小到大设置电子称!!!");
int num = (int)frmError.ShowDialog((IWin32Window)this);
frmError.Close();
return(false);
}
clsCheng clsCheng = new clsCheng();
try
{
StruChengPara struChengPara = new StruChengPara()
{
chengXH = (enumCheng)Enum.Parse(typeof(enumCheng), strArray1[0]),
JingDu = Convert.ToDecimal(strArray1[1]),
MaxCL = Convert.ToDecimal(strArray1[2]),
WuCha = Convert.ToDecimal(strArray1[3]),
WuChaPG = strArray1[4],
OKci = (int)Convert.ToInt16(strArray1[5]),
OKwd = !(strArray1[6] == "0"),
zeroCi = Convert.ToInt32(strArray2[4]),
zeroWD = !(strArray2[5] == "False"),
scanSpeed = Convert.ToInt32(strArray2[6]),
zeroSpeed = Convert.ToInt32(strArray2[7])
};
clsCheng.chengPara = struChengPara;
clsCheng.PortName = strArray2[0];
clsCheng.BaudRate = Convert.ToInt32(strArray2[1]);
clsCheng.DataBits = Convert.ToInt32(strArray2[2]);
clsCheng.Parity = strArray2[3] == "Odd" ? Parity.Odd : (strArray2[3] == "Even" ? Parity.Even : Parity.None);
clsCheng.com_open();
this.cheng.Add(clsCheng);
}
catch
{
frmError frmError = new frmError("串口 " + (index + 1).ToString() + " 错误!!!");
int num = (int)frmError.ShowDialog((IWin32Window)this);
frmError.Close();
return(false);
}
}
else if (index == 0)
{
frmError frmError = new frmError("串口 " + (index + 1).ToString() + " 参数设置错误!!!");
int num = (int)frmError.ShowDialog((IWin32Window)this);
frmError.Close();
return(false);
}
}
string[] strArray = Settings.Default.CLparaPLC.Split(',');
if (strArray.Length != 5)
{
frmError frmError = new frmError("PLC 参数设置错误!!!");
int num = (int)frmError.ShowDialog((IWin32Window)this);
frmError.Close();
return(false);
}
try
{
this.plcCL.PortName = strArray[0];
this.plcCL.BaudRate = Convert.ToInt32(strArray[1]);
this.plcCL.DataBits = Convert.ToInt32(strArray[2]);
this.plcCL.Parity = strArray[3] == "Odd" ? Parity.Odd : Parity.Even;
this.plcCL.RWokReadDelay = Convert.ToInt32(strArray[4]);
this.plcCL.com_open();
}
catch
{
frmError frmError = new frmError("PLC 打开错误!!!");
int num = (int)frmError.ShowDialog((IWin32Window)this);
frmError.Close();
return(false);
}
return(true);
}
private void btnSave2_Click(object sender, EventArgs e)
{
string[] strArray1 = new string[4];
for (int index1 = 0; index1 < 4; ++index1)
{
strArray1[index1] = "";
if (index1 == 0 && !this.txtXH[index1].chkSel)
{
int num = (int)MessageBox.Show(this, "1号称 为必选条件!!!", "提示");
return;
}
if (index1 > 0 && txtXH[index1].chkSel && !txtXH[index1 - 1].chkSel)
{
int num = (int)MessageBox.Show(this, "请按顺序选定称,不能跳跃选择!", "提示");
return;
}
if (this.txtXH[index1].chkSel)
{
if (this.txtXH[index1].coboex.Text == "")
{
this.txtXH[index1].coboex.Focus();
int num = (int)MessageBox.Show(this, "请选择 " + (index1 + 1).ToString() + "号称 型号!!!", "提示");
return;
}
if (this.txtJD[index1].txt.Text == "")
{
this.txtJD[index1].txt.Focus();
int num = (int)MessageBox.Show(this, "请输入 " + (index1 + 1).ToString() + "号称 精度( 数值 > 0 )!!!", "提示");
return;
}
if (this.txtCL[index1].txt.Text == "")
{
this.txtCL[index1].txt.Focus();
int num = (int)MessageBox.Show(this, "请输入 " + (index1 + 1).ToString() + "号称 最大称量( 数值 > 0 )!!!", "提示");
return;
}
if (index1 > 0)
{
Decimal num1 = Convert.ToDecimal(this.txtCL[index1 - 1].txt.Text);
if (Convert.ToDecimal(this.txtCL[index1].txt.Text) <= num1)
{
this.txtCL[index1].txt.Focus();
int num2 = (int)MessageBox.Show(this, (index1 + 1).ToString() + "号称 最大称量 <= " + index1.ToString() + "号称 最大称量,不允许!!!", "提示");
return;
}
}
if (this.txtWCp[index1].txt.Text == "" && this.txtWCg[index1].txt.Text == "" || this.txtWCp[index1].txt.Text != "" && this.txtWCg[index1].txt.Text != "")
{
this.txtWCp[index1].txt.Focus();
int num = (int)MessageBox.Show(this, "请输入 " + (index1 + 1).ToString() + "号称 允许误差,且只能选择一种输入!!!", "提示");
return;
}
if (this.txtWCp[index1].txt.Text != "" && Convert.ToDecimal(this.txtWCp[index1].txt.Text) > new Decimal(20))
{
this.txtWCp[index1].txt.Focus();
int num = (int)MessageBox.Show(this, "请输入 " + (index1 + 1).ToString() + "号称 允许误差( 0 < 数值 <= 20 )!!!", "提示");
return;
}
if (this.txtWCg[index1].txt.Text != "" && Convert.ToDecimal(this.txtWCg[index1].txt.Text) < Convert.ToDecimal(this.txtJD[index1].txt.Text))
{
this.txtWCg[index1].txt.Focus();
int num = (int)MessageBox.Show(this, "请输入正确 " + (index1 + 1).ToString() + "号称 允许误差( 精度 < 数值 )!!!", "提示");
return;
}
if (this.txtOKci[index1].txt.Text == "")
{
this.txtOKci[index1].txt.Focus();
int num = (int)MessageBox.Show(this, "请输入 " + (index1 + 1).ToString() + "号称 确认次数( 数值 > 0 )!!!", "提示");
return;
}
strArray1[index1] = this.txtXH[index1].coboex.Text;
string[] strArray2 = strArray1;
int index2 = index1;
string str1 = strArray1[index1];
Decimal num3 = Convert.ToDecimal(this.txtJD[index1].txt.Text);
string str2 = num3.ToString("0.###");
string str3 = str1 + "," + str2;
strArray2[index2] = str3;
string[] strArray3 = strArray1;
int index3 = index1;
string str4 = strArray1[index1];
num3 = Convert.ToDecimal(this.txtCL[index1].txt.Text);
string str5 = num3.ToString("0.###");
string str6 = str4 + "," + str5;
strArray3[index3] = str6;
if (this.txtWCp[index1].txt.Text != "")
{
string[] strArray4 = strArray1;
int index4 = index1;
string str7 = strArray1[index1];
num3 = Convert.ToDecimal(this.txtWCp[index1].txt.Text);
string str8 = num3.ToString("0.###");
string str9 = str7 + "," + str8;
strArray4[index4] = str9;
strArray1[index1] = strArray1[index1] + ",p";
}
else
{
string[] strArray4 = strArray1;
int index4 = index1;
string str7 = strArray1[index1];
num3 = Convert.ToDecimal(this.txtWCg[index1].txt.Text);
string str8 = num3.ToString("0.###");
string str9 = str7 + "," + str8;
strArray4[index4] = str9;
strArray1[index1] = strArray1[index1] + ",g";
}
strArray1[index1] = strArray1[index1] + "," + Convert.ToInt16(this.txtOKci[index1].txt.Text).ToString();
strArray1[index1] = strArray1[index1] + "," + (this.chkOKwd[index1].Checked ? "True" : "False");
}
}
var all = db.Queryable <T_Base>()
.Where(a => a.leibie == clset && a.bianhao == txtJH.coboEX1.Text)
.ToList();
if (all.Count > 0)
{
T_Base tBase = all[0];
tBase.item1 = strArray1[0];
tBase.item2 = strArray1[1];
tBase.item3 = strArray1[2];
tBase.item4 = strArray1[3];
try
{
db.Updateable(tBase).ExecuteCommand();
int num = (int)MessageBox.Show((IWin32Window)this, "电子称设置保存成功!!!", "提示");
}
catch (Exception ex)
{
int num = (int)MessageBox.Show((IWin32Window)this, ex.Message, "提示");
}
}
}
