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, "提示"); } } }