Пример #1
0
 private void btnDele_Click(object sender, EventArgs e)
 {
     if (this.dgvData.DataSource != null && this.dgvData.SelectedRows != null && this.dgvData.SelectedRows.Count > 0)
     {
         if (MessageBox.Show("是否删除该跑钩记录?", "操作提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question,
                             MessageBoxDefaultButton.Button2, MessageBoxOptions.DefaultDesktopOnly) == DialogResult.Yes)
         {
             try
             {
                 DataGridViewRow row = this.dgvData.SelectedRows[0];
                 Public.WriteManLog("", 0, "", Convert.ToInt32(row.Cells[1].Value), 0, "", Convert.ToInt32(row.Cells[1].Value), "跑钩删除", Public.userno);
                 string strDele = "delete from  WMS_Bms_Rec_WGD_PaoGou where gh=" + row.Cells[1].Value.ToString() + " and pch='" + row.Cells[2].Value.ToString() + "'";
                 DbEntry.Context.ExecuteNonQuery(strDele);
                 BindGrid();
             }
             catch (Exception ex)
             {
                 MessageBox.Show(ex.Message);
             }
         }
     }
 }
Пример #2
0
        private void btnPrint_Click(object sender, EventArgs e)
        {
            if (this.dgvData.DataSource == null)
            {
                MessageBox.Show("请先查询!");
                return;
            }
            if (this.dgvData.SelectedRows == null || this.dgvData.SelectedRows.Count == 0)
            {
                MessageBox.Show("请选择要打印的信息!");
                return;
            }

            DataGridViewRow row = this.dgvData.SelectedRows[0];

            string ph, gg, pch, jz, rq, bb, gh, bz, xlh, tm, ErrSeason, psx;
            bool   isckflag;
            int    pchint, iType;
            double fjz, ffjz;

            if (this.txtPCH.Text.Length != 9)
            {
                MessageBox.Show("批次号位数不够");
                return;
            }
            jz = this.txtJZZL.Text.Trim();//输入的重量信息
            //如果是取原始重量
            if (this.chkYZL.Checked)
            {
                ffjz = Convert.ToDouble(this.txtZL.Text) * 1000;
                jz   = ffjz.ToString();
            }
            else
            {
                //根据获得重量范围参数值
                getsysparam();
                //获取原始钢坯重量
                GetgpZL(row.Cells[3].Value.ToString());
                if (!IsCheckZL(Convert.ToDouble(jz)))//验证重量是否满足
                {
                    return;
                }
                //修改20180104
                //fjz = Convert.ToDouble(jz) / 1000 - getbzzl(row.Cells[2].Value.ToString(), row.Cells[11].Value.ToString(), Convert.ToDouble(this.txtJZZL.Text));
                fjz = Convert.ToDouble(jz) / 1000 - getbzzl(row.Cells[2].Value.ToString(), row.Cells[11].Value.ToString(), Convert.ToDouble(this.txtJZZL.Text)) - gettwzl(row.Cells[2].Value.ToString());
                jz  = (fjz * 1000).ToString();
            }

            if (string.IsNullOrEmpty(jz) || Convert.ToDouble(jz) == 0)
            {
                this.txtJZZL.Text = "000000";
                MessageBox.Show("重量错误!");
                return;
            }

            if (MessageBox.Show("打印信息是否确认无误,是否打印?", "操作提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question,
                                MessageBoxDefaultButton.Button2, MessageBoxOptions.DefaultDesktopOnly) == DialogResult.No)
            {
                return;
            }
            try
            {
                Public.WriteManLog(row.Cells[0].Value.ToString(), Convert.ToDouble(jz), this.txtSX.Text, Convert.ToInt32(this.txtGH.Text), Convert.ToDouble(this.txtZL.Text), this.txtSX.Text, Convert.ToInt32(this.txtGH.Text), "标牌补打", Public.userno);
                string strq = "update " + tablename + " set zl=" + (Convert.ToDouble(jz) / 1000).ToString() + " where barcode='" + row.Cells[0].Value.ToString() + "'";
                DbEntry.Context.ExecuteNonQuery(strq);
                row.Cells[6].Value = (Convert.ToDouble(jz) / 1000).ToString();
                if (this.chkYZL.Checked == false)
                {
                    string upYS = "update WMS_Bms_Rec_Log_Print set ysmz=" + this.txtJZZL.Text + ",usertime=getdate() where barcode='" + row.Cells[0].Value.ToString() + "'";
                    DbEntry.Context.ExecuteNonQuery(upYS);
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("系统错误:" + ex.Message);
                return;
            }
            if (this.numTxt.Value <= 0)
            {
                return;
            }
            printpq(row.Cells[0].Value.ToString(), jz);

            //if (this.WindowState == FormWindowState.Minimized)
            //    this.WindowState = FormWindowState.Normal;
            //Thread.Sleep(1000);
            //this.Activate();
        }