Esempio n. 1
0
        //选择物料
        private void button3_Click(object sender, EventArgs e)
        {
            //测试
            T_JB_Materiel mo = mbll.getMaterielById("001");

            SelectKnifeUse(mo);
        }
        private bool CheckBarcode(string ids, ref string mes)
        {
            if (ids.Length < 1)
            {
                mes = "码为空!";
                return(false);
            }
            else
            {
                try
                {
                    string[] arr = ids.Split(new char[] { ',' });

                    for (int i = 0; i < arr.Length; i++)
                    {
                        T_JB_Materiel mo = mbll.getMaterielById(arr[i]);
                        if (mo == null)
                        {
                            mes = "码无法解析!";
                            return(false);
                        }
                    }
                }
                catch
                {
                    mes = "码无法解析!";
                    return(false);
                }
            }

            return(true);
        }
Esempio n. 3
0
 private void addRowMult(DataTable dtBak, T_JB_Materiel mo)
 {
     for (int j = 0; j < dtBak.Rows.Count; j++)
     {
         DataRow dr = dt.NewRow();
         dr[0] = dtBak.Rows[j][0];
         dr[1] = mo.C_name;
         dr[2] = mo.C_standerd;
         dr[3] = dtBak.Rows[j][3];
         dr[4] = dtBak.Rows[j][4];
         dr[5] = dtpIndate.Value.ToString("yyyy-MM-dd");
         dr[6] = dtBak.Rows[j][6];
         dr[7] = dtBak.Rows[j][7];
         dr[8] = dtBak.Rows[j][8];
         bool flag = false;
         for (int i = 0; i < dt.Rows.Count; i++)
         {
             string m = Convert.ToString(dt.Rows[i][0]);
             string p = Convert.ToString(dt.Rows[i][4]);
             if (txtId.Text.Equals(m) && txtInPlace.Text.Trim().Equals(p))
             {
                 flag = true;
                 int old   = Convert.ToInt32(dt.Rows[i][3]);
                 int total = old + Convert.ToInt32(txtCount.Text.Trim());
                 dt.Rows[i][3] = total.ToString();
                 break;
             }
         }
         if (flag == false)
         {
             dt.Rows.InsertAt(dr, 0);
         }
     }
 }
Esempio n. 4
0
 /// <summary>
 /// 显示model
 /// </summary>
 /// <param name="materiel"></param>
 void ModelToUI(T_JB_Materiel materiel)
 {
     this.txtId.Text            = materiel.C_id;
     this.txtMaterielName.Text  = materiel.C_name;
     this.cmbType.SelectedValue = materiel.C_type;
     this.txtStand.Text         = materiel.C_standerd;
     this.txtThick.Text         = materiel.I_thick.ToString();
     this.txtLength.Text        = materiel.I_length.ToString();
     this.txtWidth.Text         = materiel.I_width.ToString();
     this.cmbArea.SelectedValue = materiel.C_area;
     if (materiel.I_finish == 1)
     {
         this.checkBox1.Checked = true;
     }
     else
     {
         this.checkBox1.Checked = false;
     }
     this.txtMeno.Text  = materiel.C_memo;
     this.textBox1.Text = materiel.C_piccode;
     this.textBox2.Text = materiel.I_layOutCount.ToString();
     this.textBox3.Text = materiel.C_surface;
     this.textBox4.Text = materiel.C_Science;
     this.textBox5.Text = materiel.Dec_area.ToString();
     this.textBox7.Text = materiel.Dec_weight.ToString();
     this.textBox6.Text = materiel.Dec_production.ToString();
     if (materiel.I_buy == 1)
     {
         this.checkBox2.Checked = true;
     }
     else
     {
         this.checkBox2.Checked = false;
     }
 }
Esempio n. 5
0
        private void btnLogin_Click(object sender, EventArgs e)
        {
            try
            {
                if (checkInput())
                {
                    #region 增加
                    if (bll.isExit(txtName.Text.Trim(), cmbType.SelectedValue.ToString()))
                    {
                        MessageBox.Show("物料名称重复!", "信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        lblName.Visible = true;
                    }
                    else
                    {
                        lblName.Visible = false;
                        T_JB_Materiel temp = new T_JB_Materiel();
                        temp.C_id       = txtId.Text.Trim();
                        temp.C_name     = txtName.Text.Trim();
                        temp.C_type     = cmbType.SelectedValue.ToString();
                        temp.C_standerd = txtStandard.Text.Trim();
                        temp.I_length   = string.Empty.Equals(txtLT.Text.Trim()) ? 0 : Convert.ToDecimal(txtLT.Text.Trim());
                        temp.I_width    = string.Empty.Equals(txtWT.Text.Trim()) ? 0 : Convert.ToDecimal(txtWT.Text.Trim());
                        temp.I_thick    = string.Empty.Equals(txtMT.Text.Trim()) ? 0 : Convert.ToDecimal(txtMT.Text.Trim());
                        temp.C_area     = cmbArea.SelectedValue.ToString();

                        temp.C_memo = txtMeno.Text.Trim();

                        temp.Dec_dimension1 = string.Empty.Equals(txtDim1.Text.Trim()) ? 0 : Convert.ToDecimal(txtDim1.Text.Trim());
                        temp.Dec_dimension2 = string.Empty.Equals(txtDim2.Text.Trim()) ? 0 : Convert.ToDecimal(txtDim2.Text.Trim());
                        temp.Dec_dimension3 = string.Empty.Equals(txtDim3.Text.Trim()) ? 0 : Convert.ToDecimal(txtDim3.Text.Trim());
                        temp.Dec_angle      = string.Empty.Equals(txtAngle.Text.Trim()) ? 0 : Convert.ToDecimal(txtAngle.Text.Trim());

                        temp.C_regrinding_length = txtRL.Text.Trim();

                        if (bll.save(temp, Global.longid))
                        {
                            MessageBox.Show("物料保存成功!", "信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
                            Log.saveLog("添加物料成功!Id:" + txtId.Text);
                            reset();
                        }
                        else
                        {
                            MessageBox.Show("物料保存失败!", "信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        }
                    }
                    #endregion
                }
            }
            catch (Exception)
            {
                MessageBox.Show("与数据库连接失败,请查看网络连接是否正常。如不能解决请与网络管理员联系!", "严重错误:", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
Esempio n. 6
0
 public void setMateriel(string name, string id, string standard)
 {
     try
     {
         materielNow = mbll.getMaterielById(id);
         ModelToUI(materielNow);
     }
     catch (Exception)
     {
         MessageBox.Show("与数据库连接失败,请查看网络连接是否正常。如不能解决请与网络管理员联系!", "严重错误:", MessageBoxButtons.OK, MessageBoxIcon.Error);
     }
 }
        public void setMaterielAndPlace(string mname, string mid, string standard, string pid, string tray, int count, string typeName)
        {
            try
            {
                materielNow = mbll.getMaterielById(mid);
            }
            catch (Exception)
            {
                MessageBox.Show("与数据库连接失败,请查看网络连接是否正常。如不能解决请与网络管理员联系!", "严重错误:", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }

            ModelToUI(materielNow);
        }
Esempio n. 8
0
        private void ModMateriel_Load(object sender, EventArgs e)
        {
            this.Left = (Global.baseWidth) / 2;
            this.Top  = Global.baseHeight / 4;

            #region 初始化 物料类别
            DataTable dt       = tbll.GetList(null, null, null, 1);
            DataView  dataView = dt.DefaultView;
            dataView.Sort         = "C_ID asc";
            cmbType.DataSource    = dataView.ToTable();
            cmbType.DisplayMember = "C_NAME";
            cmbType.ValueMember   = "C_ID";
            cmbType.SelectedValue = mTypeId;
            #endregion

            #region 初始化 货区
            DataTable dtt       = abll.GetList(null);
            DataView  dataViewt = dtt.DefaultView;
            dataViewt.Sort        = "C_ID asc";
            cmbArea.DataSource    = dataViewt.ToTable();
            cmbArea.DisplayMember = "C_NAME";
            cmbArea.ValueMember   = "C_ID";
            #endregion

            txtId.ReadOnly = true;
            materiel       = bll.getMaterielById(id);
            if (materiel == null)
            {
                MessageBox.Show("获取物料信息失败!", "信息", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                this.Close();
            }
            else
            {
                this.txtId.Text            = materiel.C_id;
                this.txtName.Text          = materiel.C_name;
                this.cmbType.SelectedValue = materiel.C_type;
                this.txtStandard.Text      = materiel.C_standerd;
                this.txtMT.Text            = materiel.I_thick.ToString();
                this.txtLT.Text            = materiel.I_length.ToString();
                this.txtWT.Text            = materiel.I_width.ToString();
                this.cmbArea.SelectedValue = materiel.C_area;

                this.txtMeno.Text  = materiel.C_memo;
                this.txtDim1.Text  = materiel.Dec_dimension1.ToString();
                this.txtDim2.Text  = materiel.Dec_dimension2.ToString();
                this.txtDim3.Text  = materiel.Dec_dimension3.ToString();
                this.txtAngle.Text = materiel.Dec_angle.ToString();
                this.txtRL.Text    = materiel.C_regrinding_length;
            }
        }
        private void txtId_KeyPress(object sender, KeyPressEventArgs e)
        {
            if (e.KeyChar == 13)
            {
                T_JB_Materiel mo = Utility.AnalyzeBarcodeMateriel(inOutType);

                if (mo != null)
                {
                    SelectKnifeUse(mo);
                }
                else
                {
                    MessageBox.Show("无法解析!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
            }
        }
Esempio n. 10
0
        /// <summary>
        /// 选择刀具
        /// </summary>
        /// <param name="mo"></param>
        private void SelectKnifeUse(T_JB_Materiel mo)
        {
            dtBak = dt.Clone();
            SelectKnifeUseForm select = new SelectKnifeUseForm(mo.C_id, dt, dtBak);

            select.ShowDialog();

            if (dtBak.Rows.Count > 0)
            {
                //addRowMult(dtBak);
                ModelToUI(mo);

                txtInPlace.Text = dtBak.Rows[0][4].ToString();
                txtMachine.Text = dtBak.Rows[0][7].ToString();
            }
        }
Esempio n. 11
0
        /// <summary>
        /// 显示model
        /// </summary>
        /// <param name="materiel"></param>
        void ModelToUI(T_JB_Materiel materiel)
        {
            this.txtId.Text            = materiel.C_id;
            this.txtMaterielName.Text  = materiel.C_name;
            this.cmbType.SelectedValue = materiel.C_type;
            this.txtStand.Text         = materiel.C_standerd;
            this.txtMT.Text            = materiel.I_thick.ToString();
            this.txtLT.Text            = materiel.I_length.ToString();
            this.txtWT.Text            = materiel.I_width.ToString();
            this.cmbArea.SelectedValue = materiel.C_area;

            this.txtMeno.Text  = materiel.C_memo;
            this.txtDim1.Text  = materiel.Dec_dimension1.ToString();
            this.txtDim2.Text  = materiel.Dec_dimension2.ToString();
            this.txtDim3.Text  = materiel.Dec_dimension3.ToString();
            this.txtAngle.Text = materiel.Dec_angle.ToString();
            this.txtRL.Text    = materiel.C_regrinding_length;
        }
Esempio n. 12
0
        private void txtId_KeyPress(object sender, KeyPressEventArgs e)
        {
            if (e.KeyChar == 13)
            {
                #region 测试
                //DataTable dtBak = dt.Clone();
                //SelectMaterielOutNumForm select1 = new SelectMaterielOutNumForm(this, dt, dtBak, "001001");
                //select1.ShowDialog();

                //addRowMult(dtBak,mbll.getMaterielById("001001"));
                #endregion

                T_JB_Materiel mo = Utility.AnalyzeBarcodeMateriel(inOutType);

                if (mo != null)
                {
                    #region 无论多少,都要弹出框
                    //DataTable st = stockBll.getStocksList(null, null, null, null, Global.longid, mo.C_id);

                    //if (st.Rows.Count == 1)
                    //{//只有一个货位有该零件
                    //    //ModelToUI(mo);
                    //    //txtCount.Text = Convert.ToInt32(st.Rows[0][5]).ToString();
                    //    //txtInPlace.Text = st.Rows[0][4].ToString();
                    //}
                    //else
                    //{//多个货位,窗体选择

                    //}
                    #endregion

                    DataTable dtBak = dt.Clone();
                    SelectMaterielOutNumForm select = new SelectMaterielOutNumForm(this, dt, dtBak, mo.C_id);
                    select.ShowDialog();

                    addRowMult(dtBak, mo);
                }
                else
                {
                    MessageBox.Show("无法解析!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
            }
        }
Esempio n. 13
0
        private void txtId_KeyPress(object sender, KeyPressEventArgs e)
        {
            if (e.KeyChar == 13)
            {
                T_JB_Materiel mo = Utility.AnalyzeBarcodeMateriel(inOutType);

                if (mo != null)
                {
                    ModelToUI(mo);

                    if (txtInPlace.Text.Trim().Length > 0)
                    {//无货位自动分配
                        string place = pbll.GetAutoPlace(mo.C_area);
                    }
                }
                else
                {
                    MessageBox.Show("无法解析!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
            }
        }
Esempio n. 14
0
        public void setMaterielAndPlace(string mname, string mid, string standard, string pid, string tray, int count, string typeName)
        {
            this.txtMaterielName.Text = mname;
            this.txtInPlace.Text      = pid;
            this.txtCount.Text        = count.ToString();
            this.lblMax.Text          = count.ToString();
            this.lblTypeName.Text     = typeName;
            //库存编号
            this.lblStockId.Text = tray;

            try
            {
                materielNow = mbll.getMaterielById(mid);
            }
            catch (Exception)
            {
                MessageBox.Show("与数据库连接失败,请查看网络连接是否正常。如不能解决请与网络管理员联系!", "严重错误:", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }

            ModelToUI(materielNow);
        }
Esempio n. 15
0
        private void btnLogin_Click(object sender, EventArgs e)
        {
            try
            {
                if (checkInput())
                {
                    if (bll.isExit(txtName.Text.Trim(), cmbType.SelectedValue.ToString(), txtId.Text.Trim()))
                    {
                        MessageBox.Show("物料名称已经存在!", "信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        lblName.Visible = true;
                    }
                    else
                    {
                        lblName.Visible = false;
                        T_JB_Materiel temp = new T_JB_Materiel();
                        temp.C_id       = txtId.Text;
                        temp.C_name     = txtName.Text.Trim();
                        temp.C_type     = cmbType.SelectedValue.ToString();
                        temp.I_single   = 0;
                        temp.C_standerd = txtStandard.Text.Trim();
                        temp.I_length   = string.Empty.Equals(txtLength.Text.Trim()) ? 0 : Convert.ToDecimal(txtLength.Text.Trim());
                        temp.I_width    = string.Empty.Equals(txtWidth.Text.Trim()) ? 0 : Convert.ToDecimal(txtWidth.Text.Trim());
                        temp.I_thick    = string.Empty.Equals(txtThick.Text.Trim()) ? 0 : Convert.ToDecimal(txtThick.Text.Trim());
                        temp.C_area     = cmbArea.SelectedValue.ToString();
                        temp.I_finish   = 0;
                        if (this.checkBox1.Checked)
                        {
                            temp.I_finish = 1;
                        }
                        temp.C_memo = txtMeno.Text.Trim();

                        temp.C_piccode     = this.textBox1.Text.Trim();
                        temp.I_layOutCount = string.Empty.Equals(textBox2.Text.Trim()) ? 0 : Convert.ToInt32(textBox2.Text.Trim());
                        temp.C_surface     = this.textBox3.Text.Trim();
                        temp.C_Science     = this.textBox4.Text.Trim();
                        temp.Dec_area      = string.Empty.Equals(textBox5.Text.Trim()) ? 0 : Convert.ToDecimal(textBox5.Text.Trim());
                        temp.Dec_weight    = string.Empty.Equals(textBox7.Text.Trim()) ? 0 : Convert.ToDecimal(textBox7.Text.Trim());
                        temp.I_buy         = 0;
                        if (this.checkBox2.Checked)
                        {
                            temp.I_buy = 1;
                        }

                        temp.Dec_production = string.Empty.Equals(textBox6.Text.Trim()) ? 0 : Convert.ToDecimal(textBox6.Text.Trim());


                        if (bll.update(temp))
                        {
                            MessageBox.Show("物料信息更改成功!", "信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
                            Log.saveLog("修改物料成功!Id:" + txtId.Text);
                            this.Close();
                        }
                        else
                        {
                            MessageBox.Show("物料信息更改失败!", "信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        }
                    }
                }
            }
            catch (Exception)
            {
                MessageBox.Show("与数据库连接失败,请查看网络连接是否正常。如不能解决请与网络管理员联系!", "严重错误:", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
Esempio n. 16
0
        /// <summary>
        /// 保存物料信息
        /// </summary>
        /// <param name="user">物料信息</param>
        /// <returns></returns>
        public bool update(T_JB_Materiel materiel)
        {
            try
            {
                int count = 0;

                string sql = " UPDATE [T_JB_MATERIEL]SET [C_TYPE]=@C_TYPE, [C_NAME]=@C_NAME, [I_SINGLE]=@I_SINGLE, [C_STANDARD]=@C_STANDARD, [I_LENGTH]=@I_LENGTH,  " +
                             " [I_WIDTH]=@I_WIDTH, [I_THICK]=@I_THICK, [C_AREA]=@C_AREA, [I_FINISH]=@I_FINISH, [C_MEMO]=@C_MEMO,   " +
                             " [C_PICCODE]=@C_PICCODE, [I_LAYOUTCOUNT]=@I_LAYOUTCOUNT, [C_SURFACE]=@C_SURFACE, [C_SCIENCE]=@C_SCIENCE,  " +
                             "  [DEC_AREA]=@DEC_AREA, [DEC_WEIGHT]=@DEC_WEIGHT, [I_BUY]=@I_BUY, [DEC_production]=@DEC_production,  " +
                             "  [DEC_ANGLE]=@DEC_ANGLE, [DEC_DIMENSION1]=@DEC_DIMENSION1, [DEC_DIMENSION2]=@DEC_DIMENSION2, [DEC_DIMENSION3]=@DEC_DIMENSION3, [C_REGRINDING_LENGTH]=@C_REGRINDING_LENGTH WHERE [C_ID]=@C_ID ";
                Hashtable table = new Hashtable();

                table.Add("C_ID", materiel.C_id);
                table.Add("C_TYPE", materiel.C_type);
                table.Add("C_NAME", materiel.C_name);
                table.Add("I_SINGLE", materiel.I_single);
                if (materiel.C_standerd == null || string.Empty.Equals(materiel.C_standerd.Trim()))
                {
                    table.Add("C_STANDARD", DBNull.Value);
                }
                else
                {
                    table.Add("C_STANDARD", materiel.C_standerd);
                }
                table.Add("I_LENGTH", materiel.I_length);
                table.Add("I_WIDTH", materiel.I_width);
                table.Add("I_THICK", materiel.I_thick);
                table.Add("C_AREA", materiel.C_area);
                table.Add("I_FINISH", materiel.I_finish);
                table.Add("C_MEMO", materiel.C_memo);

                table.Add("C_PICCODE", materiel.C_piccode == null ? string.Empty : materiel.C_piccode);
                table.Add("I_LAYOUTCOUNT", materiel.I_layOutCount);
                table.Add("C_SURFACE", materiel.C_surface == null ? string.Empty : materiel.C_surface);
                table.Add("C_SCIENCE", materiel.C_Science == null ? string.Empty : materiel.C_Science);
                table.Add("DEC_AREA", materiel.Dec_area);
                table.Add("DEC_WEIGHT", materiel.Dec_weight);
                table.Add("I_BUY", materiel.I_buy);
                table.Add("DEC_production", materiel.Dec_production);

                table.Add("DEC_ANGLE", materiel.Dec_angle);
                table.Add("DEC_DIMENSION1", materiel.Dec_dimension1);
                table.Add("DEC_DIMENSION2", materiel.Dec_dimension2);
                table.Add("DEC_DIMENSION3", materiel.Dec_dimension3);
                table.Add("C_REGRINDING_LENGTH", materiel.C_regrinding_length == null ? string.Empty : materiel.C_regrinding_length);

                DbParameter[] parms = dbHelper.getParams(table);

                count = dbHelper.ExecuteCommand(sql, parms);
                if (count > 0)
                {
                    return(true);
                }
                else
                {
                    return(false);
                }
            }
            catch (Exception ex)
            {
                Log.write(ex.Message + "\r\n" + ex.StackTrace);
                throw ex;
            }
            finally
            {
                dbHelper.getConnection().Close();
            }
        }
Esempio n. 17
0
 /// <summary>
 /// 保存物料信息
 /// </summary>
 /// <param name="user">物料信息</param>
 /// <returns></returns>
 public bool update(T_JB_Materiel materiel)
 {
     return(dal.update(materiel));
 }
Esempio n. 18
0
 /// <summary>
 /// 保存物料信息
 /// </summary>
 /// <param name="user">物料信息</param>
 /// <returns></returns>
 public bool save(T_JB_Materiel materiel, string userid)
 {
     return(dal.save(materiel, userid));
 }
Esempio n. 19
0
        /// <summary>
        /// 验证输入
        /// </summary>
        /// <returns></returns>
        private bool checkInput()
        {
            bool flag = true;

            if (Convert.ToDateTime(dtpIndate.Value.ToShortDateString()) > Convert.ToDateTime(DateTime.Now.ToShortDateString()))
            {
                MessageBox.Show("入库日期不能大于当前日期!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                flag = false;
            }

            if (flag)
            {
                if (txtInPlace.Text == null || string.Empty.Equals(txtInPlace.Text))
                {
                    flag = false;
                    this.lblTypeName.Visible = true;
                }
                else
                {
                    this.lblTypeName.Visible = false;
                    if (bll.isPlaceInuse(txtInPlace.Text.Trim()))
                    {
                        this.lblTypeName.Visible = true;
                        flag = false;
                    }
                    else
                    {
                        this.lblTypeName.Visible = false;
                    }
                }
            }

            if (flag)
            {
                if (txtMaterielName.Text == null || string.Empty.Equals(txtMaterielName.Text))
                {
                    flag = false;
                    this.lblMaterielName.Visible = true;
                }
                else
                {
                    this.lblMaterielName.Visible = false;

                    try
                    {
                        T_JB_Materiel materiel = mbll.getMaterielById(txtId.Text);
                        if (materiel == null)
                        {//当前刀具不存在,增加
                            if (mbll.save(materielNow, Global.longid))
                            {
                                Log.saveLog("自动保存刀具成功!id:" + materielNow.C_id);
                            }
                            else
                            {
                                MessageBox.Show("自动保存刀具失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);

                                this.lblMaterielName.Visible = true;
                                flag = false;
                            }
                        }
                        else
                        {//存在,更新
                            this.lblMaterielName.Visible = false;

                            //mbll.update(materielNow);
                        }
                    }
                    catch (Exception)
                    {
                        MessageBox.Show("与数据库连接失败,请查看网络连接是否正常。如不能解决请与网络管理员联系!", "严重错误:", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    }
                }
            }

            return(flag);
        }
Esempio n. 20
0
        /// <summary>
        /// 保存物料信息
        /// </summary>
        /// <param name="user">物料信息</param>
        /// <returns></returns>
        public bool save(T_JB_Materiel materiel, string userid)
        {
            int          result = 0;
            DbConnection conn   = dbHelper.getConnection();

            try
            {
                conn.Open();
            }
            catch (Exception ex)
            {
                Log.write(ex.Message + "\r\n" + ex.StackTrace);
                conn.Close();
                throw ex;
            }
            DbTransaction tran = conn.BeginTransaction();
            DbCommand     com  = conn.CreateCommand();
            string        sql  = string.Empty;

            try
            {
                com.Transaction = tran;

                sql = "INSERT INTO [T_JB_MATERIEL]([C_ID],[C_TYPE], [C_NAME], [I_SINGLE], [DEC_PRICE], [C_STANDARD], " +
                      "   [I_LENGTH], [I_WIDTH] ,[I_THICK],[C_AREA],[I_FINISH],[C_MEMO]," +
                      " [C_PICCODE], [I_LAYOUTCOUNT], [C_SURFACE], [C_SCIENCE], [DEC_AREA], [DEC_WEIGHT], [I_BUY], [DEC_production], " +
                      " [DEC_ANGLE], [DEC_DIMENSION1], [DEC_DIMENSION2], [DEC_DIMENSION3], [C_REGRINDING_LENGTH]) " +
                      "  VALUES(@C_ID,@C_TYPE,@C_NAME,@I_SINGLE,0,@C_STANDARD, @I_LENGTH,@I_WIDTH ,@I_THICK,@C_AREA,@I_FINISH,@C_MEMO, " +
                      " @C_PICCODE, @I_LAYOUTCOUNT, @C_SURFACE, @C_SCIENCE, @DEC_AREA, @DEC_WEIGHT, @I_BUY, @DEC_production," +
                      " @DEC_ANGLE, @DEC_DIMENSION1, @DEC_DIMENSION2, @DEC_DIMENSION3, @C_REGRINDING_LENGTH)";
                com.CommandText = sql;
                Hashtable table = new Hashtable();
                table.Add("C_ID", materiel.C_id);
                table.Add("C_TYPE", materiel.C_type);
                table.Add("C_NAME", materiel.C_name);
                table.Add("I_SINGLE", materiel.I_single);
                if (materiel.C_standerd == null || string.Empty.Equals(materiel.C_standerd.Trim()))
                {
                    table.Add("C_STANDARD", DBNull.Value);
                }
                else
                {
                    table.Add("C_STANDARD", materiel.C_standerd);
                }
                table.Add("I_LENGTH", materiel.I_length);
                table.Add("I_WIDTH", materiel.I_width);
                table.Add("I_THICK", materiel.I_thick);
                table.Add("C_AREA", materiel.C_area);
                table.Add("I_FINISH", materiel.I_finish);
                table.Add("C_MEMO", materiel.C_memo);

                table.Add("C_PICCODE", materiel.C_piccode == null ? string.Empty : materiel.C_piccode);
                table.Add("I_LAYOUTCOUNT", materiel.I_layOutCount);
                table.Add("C_SURFACE", materiel.C_surface == null ? string.Empty : materiel.C_surface);
                table.Add("C_SCIENCE", materiel.C_Science == null ? string.Empty : materiel.C_Science);
                table.Add("DEC_AREA", materiel.Dec_area);
                table.Add("DEC_WEIGHT", materiel.Dec_weight);
                table.Add("I_BUY", materiel.I_buy);
                table.Add("DEC_production", materiel.Dec_production);

                table.Add("DEC_ANGLE", materiel.Dec_angle);
                table.Add("DEC_DIMENSION1", materiel.Dec_dimension1);
                table.Add("DEC_DIMENSION2", materiel.Dec_dimension2);
                table.Add("DEC_DIMENSION3", materiel.Dec_dimension3);
                table.Add("C_REGRINDING_LENGTH", materiel.C_regrinding_length == null ? string.Empty : materiel.C_regrinding_length);

                DbParameter[] parms = dbHelper.getParams(table);

                com.Parameters.Clear();
                com.Parameters.AddRange(parms);
                result = com.ExecuteNonQuery();

                //sql = " INSERT INTO [T_JB_MATERIEL_USER]([C_MATERIEL], [C_JIAOSE], [I_YESNO]) VALUES(@C_MATERIEL, @JIAOSE, @YESNO) ";
                //com.CommandText = sql;
                //Hashtable table2 = new Hashtable();
                //table2.Add("C_MATERIEL", materiel.C_id);
                //table2.Add("JIAOSE", userid);
                //table2.Add("YESNO", 1);

                //DbParameter[] parms2 = dbHelper.getParams(table2);

                //com.Parameters.Clear();
                //com.Parameters.AddRange(parms2);
                //result = com.ExecuteNonQuery();

                tran.Commit();
                if (result > 0)
                {
                    return(true);
                }
                else
                {
                    return(false);
                }
            }
            catch (Exception ex)
            {
                tran.Rollback();
                conn.Close();
                Log.write(ex.Message + "\r\n" + ex.StackTrace);
                throw ex;
            }
            finally
            {
                conn.Close();
            }
        }
Esempio n. 21
0
        private void ModMateriel_Load(object sender, EventArgs e)
        {
            this.Left = (Global.baseWidth) / 2;
            this.Top  = Global.baseHeight / 4;

            #region 初始化 物料类别
            DataTable dt       = tbll.GetList(null, null, null, 1);
            DataView  dataView = dt.DefaultView;
            dataView.Sort         = "C_ID asc";
            cmbType.DataSource    = dataView.ToTable();
            cmbType.DisplayMember = "C_NAME";
            cmbType.ValueMember   = "C_ID";
            cmbType.SelectedValue = mTypeId;
            #endregion

            #region 初始化 货区
            DataTable dtt       = abll.GetList(null);
            DataView  dataViewt = dtt.DefaultView;
            dataViewt.Sort        = "C_ID asc";
            cmbArea.DataSource    = dataViewt.ToTable();
            cmbArea.DisplayMember = "C_NAME";
            cmbArea.ValueMember   = "C_ID";
            #endregion

            txtId.ReadOnly = true;
            materiel       = bll.getMaterielById(id);
            if (materiel == null)
            {
                MessageBox.Show("获取物料信息失败!", "信息", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                this.Close();
            }
            else
            {
                this.txtId.Text            = materiel.C_id;
                this.txtName.Text          = materiel.C_name;
                this.cmbType.SelectedValue = materiel.C_type;
                this.txtStandard.Text      = materiel.C_standerd;
                this.txtThick.Text         = materiel.I_thick.ToString();
                this.txtLength.Text        = materiel.I_length.ToString();
                this.txtWidth.Text         = materiel.I_width.ToString();
                this.cmbArea.SelectedValue = materiel.C_area;
                if (materiel.I_finish == 1)
                {
                    this.checkBox1.Checked = true;
                }
                else
                {
                    this.checkBox1.Checked = false;
                }
                this.txtMeno.Text  = materiel.C_memo;
                this.textBox1.Text = materiel.C_piccode;
                this.textBox2.Text = materiel.I_layOutCount.ToString();
                this.textBox3.Text = materiel.C_surface;
                this.textBox4.Text = materiel.C_Science;
                this.textBox5.Text = materiel.Dec_area.ToString();
                this.textBox7.Text = materiel.Dec_weight.ToString();
                this.textBox6.Text = materiel.Dec_production.ToString();
                if (materiel.I_buy == 1)
                {
                    this.checkBox2.Checked = true;
                }
                else
                {
                    this.checkBox2.Checked = false;
                }
            }
        }
Esempio n. 22
0
        /// <summary>
        /// 获得物料的详细信息
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public T_JB_Materiel getMaterielById(string id)
        {
            T_JB_Materiel materiel = null;
            string        sql      = " select a.C_ID,a.C_NAME,a.C_TYPE,b.C_NAME as C_TYPENAME,a.C_STANDARD,a.C_AREA,c.C_NAME as C_AREANAME,I_FINISH, " +
                                     " case I_FINISH when 1 then '是' else '否' end as C_FINISH,I_LENGTH,I_WIDTH,I_THICK,a.C_MEMO, " +
                                     " a.C_PICCODE, a.I_LAYOUTCOUNT, a.C_SURFACE, a.C_SCIENCE, a.DEC_AREA, a.DEC_WEIGHT, a.I_BUY,DEC_production, " +
                                     " a.DEC_ANGLE, a.DEC_DIMENSION1, a.DEC_DIMENSION2,a.DEC_DIMENSION3,a.C_REGRINDING_LENGTH " +
                                     " from T_JB_MATERIEL a left join T_JB_MATERIELTYPE b on a.C_TYPE = b.C_ID left join t_jb_placeArea c on a.C_AREA = c.C_ID  where a.C_ID = '" + id + "'";

            try
            {
                DataTable dt = dbHelper.GetDataSet(sql);
                if (dt != null && dt.Rows.Count > 0)
                {
                    materiel            = new T_JB_Materiel();
                    materiel.C_id       = dt.Rows[0]["C_ID"].ToString();
                    materiel.C_name     = dt.Rows[0]["C_NAME"].ToString();
                    materiel.C_type     = dt.Rows[0]["C_TYPE"].ToString();
                    materiel.C_typeName = dt.Rows[0]["C_TYPENAME"].ToString();
                    object temp = dt.Rows[0]["C_STANDARD"];
                    if (temp == null || DBNull.Value.Equals(temp))
                    {
                        materiel.C_standerd = string.Empty;
                    }
                    else
                    {
                        materiel.C_standerd = dt.Rows[0]["C_STANDARD"].ToString();
                    }
                    temp = dt.Rows[0]["C_AREA"];
                    if (temp == null || DBNull.Value.Equals(temp))
                    {
                        materiel.C_area = string.Empty;
                    }
                    else
                    {
                        materiel.C_area = dt.Rows[0]["C_AREA"].ToString();
                    }
                    materiel.C_areaName = dt.Rows[0]["C_AREANAME"].ToString();
                    materiel.I_finish   = Convert.ToInt32(dt.Rows[0]["I_FINISH"]);

                    materiel.I_thick = Convert.ToDecimal(dt.Rows[0]["I_THICK"]);
                    //   materiel.I_single = Convert.ToInt32(dt.Rows[0]["I_SINGLE"]);
                    materiel.I_length = Convert.ToDecimal(dt.Rows[0]["I_LENGTH"]);
                    materiel.I_width  = Convert.ToDecimal(dt.Rows[0]["I_WIDTH"]);
                    temp = dt.Rows[0]["C_MEMO"];
                    if (temp == null || DBNull.Value.Equals(temp))
                    {
                        materiel.C_memo = string.Empty;
                    }
                    else
                    {
                        materiel.C_memo = dt.Rows[0]["C_MEMO"].ToString();
                    }
                    materiel.C_piccode      = dt.Rows[0]["C_PICCODE"] == null || dt.Rows[0]["C_PICCODE"].Equals(DBNull.Value) ? string.Empty : dt.Rows[0]["C_PICCODE"].ToString();
                    materiel.I_layOutCount  = Convert.ToInt32(dt.Rows[0]["I_LAYOUTCOUNT"]);
                    materiel.C_surface      = dt.Rows[0]["C_SURFACE"] == null || dt.Rows[0]["C_SURFACE"].Equals(DBNull.Value) ? string.Empty : dt.Rows[0]["C_SURFACE"].ToString();
                    materiel.C_Science      = dt.Rows[0]["C_SCIENCE"] == null || dt.Rows[0]["C_SCIENCE"].Equals(DBNull.Value) ? string.Empty : dt.Rows[0]["C_SCIENCE"].ToString();
                    materiel.Dec_area       = Convert.ToDecimal(dt.Rows[0]["DEC_AREA"]);
                    materiel.Dec_weight     = Convert.ToDecimal(dt.Rows[0]["DEC_WEIGHT"]);
                    materiel.I_buy          = Convert.ToInt32(dt.Rows[0]["I_BUY"]);
                    materiel.Dec_production = Convert.ToDecimal(dt.Rows[0]["DEC_production"]);

                    materiel.Dec_angle           = Convert.ToDecimal(dt.Rows[0]["DEC_ANGLE"]);
                    materiel.Dec_dimension1      = Convert.ToDecimal(dt.Rows[0]["DEC_DIMENSION1"]);
                    materiel.Dec_dimension2      = Convert.ToDecimal(dt.Rows[0]["DEC_DIMENSION2"]);
                    materiel.Dec_dimension3      = Convert.ToDecimal(dt.Rows[0]["DEC_DIMENSION3"]);
                    materiel.C_regrinding_length = dt.Rows[0]["C_REGRINDING_LENGTH"] == null || dt.Rows[0]["C_REGRINDING_LENGTH"].Equals(DBNull.Value) ? string.Empty : dt.Rows[0]["C_REGRINDING_LENGTH"].ToString();
                }
            }
            catch (Exception ex)
            {
                Log.write(ex.Message + "\r\n" + ex.StackTrace);
                throw ex;
            }
            finally
            {
                dbHelper.getConnection().Close();
            }
            return(materiel);
        }