Exemplo n.º 1
0
        //更新供应商信息
        public int updateInfo(string sID, string sName, string sCon)
        {
            string  upCondition;
            ConnSQL upCon = new ConnSQL();

            try
            {
                if (sName != "")
                {
                    upCondition = "UPDATE Supply SET cy_sName='" + sName + "' WHERE cy_sID='" + sID + "'";
                    upCon.ExecuteUpdate(upCondition);
                }
                if (sCon != "")
                {
                    upCondition = "UPDATE Supply SET cy_sContact='" + sCon + "' WHERE cy_sID='" + sID + "'";
                    upCon.ExecuteUpdate(upCondition);
                }
            }
            catch (Exception)
            {
                return(0);

                throw;
            }
            return(1);
        }
Exemplo n.º 2
0
        /// <summary>
        /// 增删改查 供应商数据
        /// </summary>
        /// TODO:删除
        private void btnSupSearch_Click(object sender, EventArgs e)
        {
            string    sID = this.supID.Text.ToString().Trim();
            string    searchid; //查找条件
            ConnSQL   con     = new ConnSQL();
            DataTable supInfo = new DataTable();


            //没有填写供应商编号
            if (sID == "")
            {
                searchid = "SELECT * FROM Supply";
                supInfo  = con.ExecuteQuery(searchid);
                dGV_Supply.DataSource = supInfo;
            }

            //填了供应商编号
            else
            {
                sID      = sID + '%';
                searchid = "SELECT * FROM Supply WHERE cy_sID LIKE '" + sID + "'";
                supInfo  = con.ExecuteQuery(searchid);
                dGV_Supply.DataSource = supInfo;
            }

            dGV_Supply.Columns["cy_sID"].HeaderText      = "供应商编号";
            dGV_Supply.Columns["cy_sName"].HeaderText    = "供应商名称";
            dGV_Supply.Columns["cy_sContact"].HeaderText = "联系方式";

            if (dGV_Supply == null || dGV_Supply.Rows.Count <= 0)
            {
                MessageBox.Show("无供应商数据,请添加", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
            }
        }
Exemplo n.º 3
0
        private void btnSupUpdate_Click(object sender, EventArgs e)
        {
            Supply    s1    = new Supply(); //供应商
            string    sID   = this.supID.Text.ToString().Trim();
            string    sName = this.supName.Text.ToString().Trim();
            string    sCon  = this.supCon.Text.ToString().Trim();
            string    seCondition;                //查找条件
            ConnSQL   seCon      = new ConnSQL(); //查找的连接实例
            DataTable updateInfo = new DataTable();

            seCondition           = "SELECT * FROM Supply WHERE cy_sID='" + sID + "'";
            updateInfo            = seCon.ExecuteQuery(seCondition);
            dGV_Supply.DataSource = updateInfo;
            dGV_Supply.Columns["cy_sID"].HeaderText      = "供应商编号";
            dGV_Supply.Columns["cy_sName"].HeaderText    = "供应商名称";
            dGV_Supply.Columns["cy_sContact"].HeaderText = "联系方式";

            //联系方式格式是否正确
            if (supCon.Text != "")
            {
                string conInput = supCon.Text.ToString();
                Regex  con      = new Regex(@"^(([0-9]{3,4})+(-[1-9][0-9]{7}))|([1][0-9]{12})$"); // 固定电话 或者 11位电话号码

                if (con.IsMatch(conInput))
                {
                    sCon = conInput;
                }
                else
                {
                    sCon = "";
                    MessageBox.Show("联系方式输入格式有误,格式为三或四位的区号-八位固定电话号码xxx(xxxx)-xxxxxxxx或者11位移动电话号码", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
            }
            else
            {
                sCon = "";
            }


            //插入新信息
            if (dGV_Supply.Rows.Count == 0 && sID != "")
            {
                s1.insertInfo(sID, sName, sCon);
                MessageBox.Show("添加成功!请按查询按钮查看最新供应商信息。", "提示", MessageBoxButtons.OK);
            }
            //更改信息
            else if (dGV_Supply.Rows.Count != 0 && sID != "" && !(sName == "" && sID == ""))
            {
                s1.updateInfo(sID, sName, sCon);
                MessageBox.Show("添加成功!请按查询按钮查看最新供应商信息。", "提示", MessageBoxButtons.OK);
            }
            else
            {
                MessageBox.Show("供应商信息更新失败" + "\n请检查供应商编号是否有填写", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
Exemplo n.º 4
0
        //插入新供应商信息
        public int insertInfo(string sID, string sName, string sCon)
        {
            string  inCondition;
            ConnSQL inCon = new ConnSQL();

            inCondition = "INSERT INTO Supply(cy_sID,cy_sName,cy_sContact) VALUES('" + sID + "','" + sName + "','" + sCon + "')";
            inCon.ExecuteUpdate(inCondition);

            return(1);
        }
Exemplo n.º 5
0
        //插入零件信息
        public int insertInfo(string cID, string cName, string cType, float cPrice, int cLess, string csID)
        {
            string  inCondition;
            ConnSQL inCon = new ConnSQL();

            inCondition = "INSERT INTO Component(cy_cID,cy_cName,cy_cType,cy_cPrice,cy_cMinNum,cy_sID,cy_cNum) VALUES('" + cID + "','" + cName + "','" + cType + "','" + cPrice + "','" + cLess + "','" + csID + "',0)";
            inCon.ExecuteUpdate(inCondition);

            return(1);
        }
Exemplo n.º 6
0
        /// <summary>
        /// 增删改查 零件数据
        /// </summary>
        private void btnComSearch_Click(object sender, EventArgs e)
        {
            string    cID;
            string    cName;
            string    searchid; //查找条件
            ConnSQL   con     = new ConnSQL();
            DataTable comInfo = new DataTable();

            cID   = comID.Text.ToString().Trim();
            cName = comName.Text.ToString().Trim();

            //没有填写零件编号
            if (cID == "")
            {
                //有无填写零件名称
                if (cName == "")
                {
                    searchid = "SELECT * FROM Component";
                    comInfo  = con.ExecuteQuery(searchid);
                    dGV_component.DataSource = comInfo;
                }
                else
                {
                    cName    = cName + '%';
                    searchid = "SELECT * FROM Component WHERE cy_cName LIKE '" + cName + "'";
                    comInfo  = con.ExecuteQuery(searchid);
                    dGV_component.DataSource = comInfo;
                }
            }

            //填了零件编号
            else
            {
                cID      = cID + '%';
                searchid = "SELECT * FROM Component WHERE cy_cID LIKE '" + cID + "'";
                comInfo  = con.ExecuteQuery(searchid);
                dGV_component.DataSource = comInfo;
            }

            dGV_component.Columns["cy_cID"].HeaderText     = "零件编号";
            dGV_component.Columns["cy_cName"].HeaderText   = "零件名称";
            dGV_component.Columns["cy_cType"].HeaderText   = "零件型号";
            dGV_component.Columns["cy_cNum"].HeaderText    = "库存数量";
            dGV_component.Columns["cy_cMinNum"].HeaderText = "库存临界值";
            dGV_component.Columns["cy_cPrice"].HeaderText  = "目前单价";
            dGV_component.Columns["cy_sID"].HeaderText     = "供应商编号";

            if (dGV_component == null || dGV_component.Rows.Count <= 0)
            {
                MessageBox.Show("库存中无零件数据", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
            }
        }
Exemplo n.º 7
0
        private void cIO_Search_Click(object sender, EventArgs e)
        {
            string  startTime = date_cIOStart.Value.ToString("yyyy-MM-dd");
            string  endTime   = date_cIOEnd.Value.ToString("yyyy-MM-dd") + "24:00:00";
            string  condition;
            ConnSQL con = new ConnSQL();

            // DataTable ioInfo = new DataTable();

            condition = "SELECT cy_cID,cy_cIOType,cy_cIONum,cy_cIOTime FROM Component_IO WHERE cy_cIOTime BETWEEN '" + startTime + "' AND'" + endTime + "' ORDER BY cy_cIOTime DESC";
            ioInfo    = con.ExecuteQuery(condition);
            dGV_ComponentIO.DataSource = ioInfo;
            dGV_ComponentIO.Columns["cy_cID"].HeaderText     = "零件编号";
            dGV_ComponentIO.Columns["cy_cIOType"].HeaderText = "出/入库";
            dGV_ComponentIO.Columns["cy_cIONum"].HeaderText  = "出/入库数量";
            dGV_ComponentIO.Columns["cy_cIOTime"].HeaderText = "出/入库时间";
        }
Exemplo n.º 8
0
        private void btnOrderDel_Click(object sender, EventArgs e)
        {
            string  delOrder;
            int     i   = this.dGV_Order.Rows.Count;
            ConnSQL del = new ConnSQL();

            try
            {
                int iCount = dGV_Order.SelectedRows.Count;
                if (iCount < 1)
                {
                    MessageBox.Show("未选定所要删除的订货记录所在行", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    return;
                }
                if (MessageBox.Show("确认是否删除选中的订货记录?\n(此操作不可撤回!!!)", "警告", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes)
                {
                    string cid;
                    if (i != this.dGV_Order.Rows.Count - 2)
                    {
                        for (int k = i; k >= 1; k--)
                        {
                            //被选中状态则删除
                            if (this.dGV_Order.Rows[k - 1].Selected == true)
                            {
                                cid = this.dGV_Order.Rows[k - 1].Cells[0].Value.ToString();
                                dGV_Order.Rows.Remove(dGV_Order.Rows[k - 1]);

                                delOrder = "delete from Component_Order where cy_cID = '" + cid + "'";
                                del.ExecuteUpdate(delOrder);
                            }
                        }
                    }
                    //逆序删除防止串行
                    MessageBox.Show("删除成功");
                }
                else
                {
                    MessageBox.Show("取消删除所选零件");
                }
            }
            catch (Exception)
            {
                MessageBox.Show("未成功删除");
            }
        }
Exemplo n.º 9
0
        private void btnSupDel_Click(object sender, EventArgs e)
        {
            string  delSup;
            int     i   = this.dGV_Supply.Rows.Count;
            ConnSQL del = new ConnSQL();

            try
            {
                int iCount = dGV_Supply.SelectedRows.Count;
                if (iCount < 1)
                {
                    MessageBox.Show("未选定所要删除的供应商所在行", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    return;
                }
                if (MessageBox.Show("确认是否删除选中的供应商信息?\n(此操作不可撤回!)", "警告", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes)
                {
                    string sid;
                    if (i != this.dGV_Supply.Rows.Count - 2)
                    {
                        for (int k = i; k >= 1; k--)
                        {
                            //被选中状态则删除
                            if (this.dGV_Supply.Rows[k - 1].Selected == true)
                            {
                                sid = this.dGV_Supply.Rows[k - 1].Cells[0].Value.ToString();
                                dGV_Supply.Rows.Remove(dGV_Supply.Rows[k - 1]);

                                delSup = "DELETE FROM Supply WHERE cy_sID = '" + sid + "'";
                                del.ExecuteUpdate(delSup);
                            }
                        }
                    }
                    //逆序删除防止串行
                    MessageBox.Show("删除成功");
                }
                else
                {
                    MessageBox.Show("未成功删除");
                }
            }
            catch (Exception)
            {
                MessageBox.Show("未成功删除");
            }
        }
Exemplo n.º 10
0
        //更新零件信息
        public int updateInfo(string cID, string cName, string cType, float cPrice, int cLess, string csID)
        {
            string  upCondition;
            ConnSQL upCon = new ConnSQL();

            try
            {
                if (cName != "")
                {
                    upCondition = "UPDATE Component SET cy_cName='" + cName + "' WHERE cy_cID='" + cID + "'";
                    upCon.ExecuteUpdate(upCondition);
                }
                if (cType != "")
                {
                    upCondition = "UPDATE Component SET cy_cType='" + cType + "' WHERE cy_cID='" + cID + "'";
                    upCon.ExecuteUpdate(upCondition);
                }
                //if (cPrice != -0.1F || cPrice != 0)
                if (cPrice > 0)
                {
                    upCondition = "UPDATE Component SET cy_cPrice='" + cPrice + "' WHERE cy_cID='" + cID + "'";
                    upCon.ExecuteUpdate(upCondition);
                }
                if (cLess != -1)
                {
                    upCondition = "UPDATE Component SET cy_cMinNum='" + cLess + "' WHERE cy_cID='" + cID + "'";
                    upCon.ExecuteUpdate(upCondition);
                }
                if (csID != "")
                {
                    upCondition = "UPDATE Component SET cy_sID='" + csID + "' WHERE cy_cID='" + cID + "'";
                    upCon.ExecuteUpdate(upCondition);
                }
            }
            catch (Exception)
            {
                return(0);

                throw;
            }
            return(1);
        }
Exemplo n.º 11
0
        private void btn_orderFresh_Click(object sender, EventArgs e)
        {
            string    search;
            ConnSQL   conn      = new ConnSQL();
            string    Date      = DateTime.Now.ToString("yyyy-MM-dd") + '%';
            DataTable orderList = new DataTable();

            search = "SELECT cy_cID,cy_sID,cy_orderNum,cy_orderTime FROM Component_Order WHERE cy_orderTime LIKE '" + Date + "' ORDER BY cy_orderTime DESC";
            dGV_Order.DataSource = conn.ExecuteQuery(search);

            //dGV_Order.Columns["cy_ID"].HeaderText = "订货序号";
            dGV_Order.Columns["cy_cID"].HeaderText       = "零件编号";
            dGV_Order.Columns["cy_sID"].HeaderText       = "供应商编号";
            dGV_Order.Columns["cy_orderNum"].HeaderText  = "订货数量";
            dGV_Order.Columns["cy_orderTime"].HeaderText = "订货时间";

            if (dGV_Order.Rows.Count == 0)
            {
                MessageBox.Show("今日无订货数据", "警告", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
            }
        }
Exemplo n.º 12
0
        /// <summary>
        /// 查指定订货日期范围 导出历史数据
        /// </summary>
        private void btnSearchRecord_Click(object sender, EventArgs e)
        {
            string    startTime = dTP_oStartTime.Value.ToString("yyyy-MM-dd");
            string    endTime   = dTP_oEndTime.Value.ToString("yyyy-MM-dd") + "24:00:00";
            string    condition;
            ConnSQL   con    = new ConnSQL();
            DataTable ioInfo = new DataTable();

            condition = "SELECT cy_cID,cy_sID,cy_orderNum,cy_orderTime FROM Component_Order WHERE cy_orderTime BETWEEN '" + startTime + "' AND '" + endTime + "' ORDER BY cy_orderTime DESC";
            ioInfo    = con.ExecuteQuery(condition);
            dGV_reportAll.DataSource = ioInfo;

            dGV_reportAll.Columns["cy_cID"].HeaderText       = "零件编号";
            dGV_reportAll.Columns["cy_sID"].HeaderText       = "供应商编号";
            dGV_reportAll.Columns["cy_orderNum"].HeaderText  = "订货数量";
            dGV_reportAll.Columns["cy_orderTime"].HeaderText = "订货时间";

            if (dGV_reportAll.Rows.Count == 0)
            {
                MessageBox.Show("查询时间段内无订货记录", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
            }
        }
Exemplo n.º 13
0
        /// <summary>
        /// 订货 刷新 导出到Excel 删除记录
        /// </summary>
        private void btnAdd_Click(object sender, EventArgs e)
        {
            //零件ID,供应商ID,订货数量添加到订货表,记录时间
            string    orderCID  = ocID.Text.ToString();
            string    orderSID  = osID.Text.ToString();
            int       orderNum  = 0;
            string    Date      = DateTime.Now.ToString("yyyy-MM-dd ");
            string    Time      = DateTime.Now.ToShortTimeString().ToString();
            string    orderTime = Date + Time;
            string    condition;
            string    warningMessage = null;
            ConnSQL   oCon           = new ConnSQL();
            DataTable oList          = new DataTable();

            if (ocID.Text == "")
            {
                warningMessage = " 零件编号 ";
            }
            if (osID.Text == "")
            {
                warningMessage += "供应商编号 ";
            }
            //检查零件数量格式是否正确
            if (ocNum.Text != "")
            {
                string input = ocNum.Text.ToString();
                Regex  inNum = new Regex(@"^[0-9]{1,3}$"); //0-999

                if (inNum.IsMatch(input))
                {
                    orderNum = int.Parse(input);
                }
                else
                {
                    MessageBox.Show("请正确输入订购零件数量!(数量范围:1-999)", "警告", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                }
            }
            else
            {
                warningMessage += "订购数量 ";
            }

            if (orderCID == "" | orderSID == "" | orderNum == 0)
            {
                MessageBox.Show("请补充 " + warningMessage + "信息", "警告", MessageBoxButtons.OK, MessageBoxIcon.Warning);
            }
            else
            {
                condition            = "SELECT cy_cID,cy_sID,cy_orderNum,cy_orderTime FROM Component_Order WHERE cy_cID = '" + orderCID + "'";
                dGV_Order.DataSource = oCon.ExecuteQuery(condition);
                if (dGV_Order.Rows.Count > 0)
                {
                    if (orderNum >= 0)
                    {
                        MessageBox.Show("将在原有的订货数据上增加订购零件数量");
                        condition = "UPDATE Component_Order SET cy_orderNum = cy_orderNum + '" + orderNum + "' WHERE cy_cID = '" + orderCID + "'";
                        oCon.ExecuteUpdate(condition);
                    }
                    if (orderSID != "")
                    {
                        MessageBox.Show("将在原有的订货数据上更改供应商编号");
                        condition = "UPDATE Component_Order SET cy_sID = '" + orderSID + "' WHERE cy_cID = '" + orderCID + "'";
                        oCon.ExecuteUpdate(condition);
                    }
                }
                else
                {
                    condition = "INSERT INTO Component_Order(cy_cID,cy_sID,cy_orderNum,cy_orderTime) VALUES('" + orderCID + "','" + orderSID + "','" + orderNum + "','" + orderTime + "')";
                    oCon.ExecuteUpdate(condition);
                }
            }

            condition            = "SELECT cy_cID,cy_sID,cy_orderNum,cy_orderTime FROM Component_Order WHERE cy_cID = '" + orderCID + "'";
            dGV_Order.DataSource = oCon.ExecuteQuery(condition);

            //dGV_Order.Columns["cy_ID"].HeaderText = "订货序号";
            dGV_Order.Columns["cy_cID"].HeaderText       = "零件编号";
            dGV_Order.Columns["cy_sID"].HeaderText       = "供应商编号";
            dGV_Order.Columns["cy_orderNum"].HeaderText  = "订货数量";
            dGV_Order.Columns["cy_orderTime"].HeaderText = "订货时间";

            if (dGV_Order.Rows.Count == 1)
            {
                MessageBox.Show("已添加零件 " + orderCID + "的订货信息" + "\n请点击刷新查看当日全部订货信息", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
            else
            {
                MessageBox.Show("添加失败", "警告", MessageBoxButtons.OK, MessageBoxIcon.Warning);
            }
        }
Exemplo n.º 14
0
        /// <summary>
        /// 零件 出入库 查询
        /// </summary>
        private void btncIO_Click(object sender, EventArgs e)
        {
            //记录下ID和出入库数量更新至IO表
            //记录下出入库时间
            string    cID    = comIO_cID.Text.ToString();
            int       cIONum = 0;
            string    condition1;   //insert或者update 更新到零件表的
            string    condition2;   //添加出入库记录信息到Component_IO表
            string    Date       = DateTime.Now.ToString("yyyy-MM-dd ");
            string    Time       = DateTime.Now.ToShortTimeString().ToString();
            string    ioTime     = Date + Time;
            ConnSQL   ioCon      = new ConnSQL();   //查找的连接实例
            DataTable updateInfo = new DataTable(); //零件清单
            Boolean   newCom;                       //标记是否为一个新零件加入库存中
            string    orderTime = Date + Time;

            condition1 = "SELECT * FROM Component WHERE cy_cID='" + cID + "'";
            updateInfo = ioCon.ExecuteQuery(condition1);
            dGV_component.DataSource = updateInfo;
            dGV_component.Columns["cy_cID"].HeaderText     = "零件编号";
            dGV_component.Columns["cy_cName"].HeaderText   = "零件名称";
            dGV_component.Columns["cy_cType"].HeaderText   = "零件型号";
            dGV_component.Columns["cy_cNum"].HeaderText    = "库存数量";
            dGV_component.Columns["cy_cMinNum"].HeaderText = "库存临界值";
            dGV_component.Columns["cy_cPrice"].HeaderText  = "目前单价";
            dGV_component.Columns["cy_sID"].HeaderText     = "供应商编号";

            if (cID == "")
            {
                MessageBox.Show("请输入零件编号!", "警告", MessageBoxButtons.OK, MessageBoxIcon.Warning);
            }
            //判断有无数量&格式是否正确
            if (comIO_cNum.Text != "")
            {
                string input = comIO_cNum.Text.ToString();
                Regex  inNum = new Regex(@"^[0-9]{1,3}$"); //0-999

                if (inNum.IsMatch(input))
                {
                    cIONum = int.Parse(input);
                }
                else
                {
                    MessageBox.Show("请正确输入零件出/入库数量!(数量范围:1-999)", "警告", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    cIONum = -1;
                }
            }
            else
            {
                MessageBox.Show("请输入零件出/入库数量!", "警告", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                cIONum = -1;
            }

            //入库
            if (rBtnIN.Checked)
            {
                if (dGV_component.Rows.Count == 0)
                {
                    if (cIONum > 0)      //操作数量大于0
                    {
                        if (MessageBox.Show("此零件将作为新零件: " + cID + " 加入到库存中", "入库", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes)
                        {
                            condition1 = "INSERT INTO Component(cy_cID,cy_cNum) VALUES('" + cID + "','" + cIONum + "')";
                            MessageBox.Show("零件入库成功!请在 零件信息 页面查询最新零件信息", "", MessageBoxButtons.OK);
                            newCom = true;
                        }
                        else
                        {
                            MessageBox.Show("零件入库失败!您取消了此次操作", "提示", MessageBoxButtons.OK);
                            newCom = false;
                        }
                    }
                    else
                    {
                        newCom = false;
                    }
                }
                else
                {
                    if (cIONum > 0)
                    {
                        condition1 = "UPDATE Component SET cy_cNum = cy_cNum +'" + cIONum + "' WHERE cy_cID = '" + cID + "'";
                        MessageBox.Show("零件入库成功!请在 零件信息 页面查询最新零件信息", "", MessageBoxButtons.OK);
                        newCom = true;
                    }
                    else
                    {
                        newCom = false;
                    }
                }
                ioCon.ExecuteUpdate(condition1);

                if (newCom)
                {
                    condition2 = "INSERT INTO Component_IO(cy_cID,cy_cIOType,cy_cIONum,cy_cIOTime) VALUES('" + cID + "','入库','" + cIONum + "','" + ioTime + "')";
                    ioCon.ExecuteUpdate(condition2);
                }
            }

            //出库
            else if (rBtnOUT.Checked)
            {
                if (dGV_component.Rows.Count == 0)
                {
                    MessageBox.Show("库存中无此零件,请重新输入零件编号", "警告", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                }
                else
                {
                    try
                    {
                        if (cIONum > 0)
                        {
                            int minNum = int.Parse(dGV_component.Rows[0].Cells[4].Value.ToString()); //临界值
                            int kucun  = int.Parse(dGV_component.Rows[0].Cells[3].Value.ToString()); //未出库前库存
                            int kucun2 = kucun - cIONum;                                             //出库后
                            if (kucun2 < minNum)
                            {
                                MessageBox.Show("库存已小于临界值,出库失败,请添加此零件的订货信息。", "警告", MessageBoxButtons.OK, MessageBoxIcon.Warning);

                                string condition = "INSERT INTO Component_Order(cy_cID,cy_sID,cy_orderNum,cy_orderTime) VALUES('" + cID + "','','" + kucun + "','" + orderTime + "')";
                                ioCon.ExecuteUpdate(condition);
                            }
                            else
                            {
                                condition1 = "UPDATE Component SET cy_cNum = cy_cNum -'" + cIONum + "' WHERE cy_cID = '" + cID + "'";
                                ioCon.ExecuteUpdate(condition1);
                                MessageBox.Show("零件出库成功!请在 零件信息 页面查询最新零件信息", "", MessageBoxButtons.OK);

                                condition2 = "INSERT INTO Component_IO(cy_cID,cy_cIOType,cy_cIONum,cy_cIOTime) VALUES('" + cID + "','出库','" + cIONum + "','" + ioTime + "')";
                                ioCon.ExecuteUpdate(condition2);
                            }
                        }
                        else
                        {
                            MessageBox.Show("零件出库失败!", "警告", MessageBoxButtons.OK, MessageBoxIcon.Error);
                        }
                    }
                    catch (Exception)
                    {
                        MessageBox.Show("出库数量大于零件库存现有量,出库失败", "", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    }
                }
            }

            //没选任何功能
            else
            {
                MessageBox.Show("请选择出/入库", "警告", MessageBoxButtons.OK, MessageBoxIcon.Warning);
            }
        }
Exemplo n.º 15
0
        private void btnComUpdate_Click(object sender, EventArgs e)
        {
            Component c1     = new Component(); //零件
            string    cID    = this.comID.Text.ToString().Trim();
            string    cName  = this.comName.Text.ToString().Trim();
            string    cType  = this.comType.Text.ToString().Trim();
            string    comsID = csID.Text.ToString().Trim();
            float     cPrice;
            int       cLess;
            string    seConditon;                 //查找条件
            ConnSQL   seCon      = new ConnSQL(); //查找的连接实例
            DataTable updateInfo = new DataTable();

            seConditon = "SELECT * FROM Component WHERE cy_cID='" + cID + "'";
            updateInfo = seCon.ExecuteQuery(seConditon);
            dGV_component.DataSource = updateInfo;
            dGV_component.Columns["cy_cID"].HeaderText     = "零件编号";
            dGV_component.Columns["cy_cName"].HeaderText   = "零件名称";
            dGV_component.Columns["cy_cType"].HeaderText   = "零件型号";
            dGV_component.Columns["cy_cNum"].HeaderText    = "库存数量";
            dGV_component.Columns["cy_cMinNum"].HeaderText = "库存临界值";
            dGV_component.Columns["cy_cPrice"].HeaderText  = "目前单价";
            dGV_component.Columns["cy_sID"].HeaderText     = "供应商编号";

            //判断价格的格式
            if (comPrice.Text != "")
            {
                string priceInput = comPrice.Text.ToString();
                Regex  price      = new Regex(@"^(([0-9]{1,3})+(.[0-9]{1,2})?)|([0-9]{1-3})$"); //0.00-999.99

                if (price.IsMatch(priceInput))
                {
                    cPrice = float.Parse(priceInput);
                }
                else
                {
                    cPrice = 0.0F;
                    MessageBox.Show("请正确填写零件价格。范围为0-999.99", "警告", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
            }
            else
            {
                cPrice = -0.1F;
            }

            //判断临界值的格式
            if (comLess.Text != "")
            {
                string lessInput = comLess.Text.ToString();
                Regex  less      = new Regex(@"^[0-9]{1,3}$"); //0-999

                if (less.IsMatch(lessInput))
                {
                    cLess = int.Parse(lessInput);
                }
                else
                {
                    cLess = 0;
                    MessageBox.Show("请正确填写零件临界值。范围为0-999", "警告", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
            }
            else
            {
                cLess = -1;
            }

            //插入新信息
            if (dGV_component.Rows.Count == 0 && cID != "")
            {
/*                if(cPrice == 0.0F)
 *              {
 *                  MessageBox.Show("请正确填写零件价格。范围为0-999.99", "警告", MessageBoxButtons.OK, MessageBoxIcon.Error);
 *              }
 *              if (cLess == 0)
 *              {
 *                  MessageBox.Show("请正确填写零件临界值。范围为0-999", "警告", MessageBoxButtons.OK, MessageBoxIcon.Error);
 *              }*/
                if (MessageBox.Show("此零件将作为新零件: " + cID + " 加入到库存中", "入库", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes)
                {
                    c1.insertInfo(cID, cName, cType, cPrice, cLess, comsID);
                    MessageBox.Show("添加成功!请按查询按钮查看最新零件信息。", "提示", MessageBoxButtons.OK);
                }
            }
            //更改信息
            else if (dGV_component.Rows.Count != 0 && cID != "")
            {
                c1.updateInfo(cID, cName, cType, cPrice, cLess, comsID);
                if (cPrice > 0 || cLess > 0 || cName != "" || cType != "" || comsID != "")
                {
                    MessageBox.Show("零件信息更新成功!请按查询按钮查看最新零件信息。", "提示", MessageBoxButtons.OK);
                }
            }
            else
            {
                //MessageBox.Show("添加成功!请按查询按钮查看最新零件信息。", "提示", MessageBoxButtons.OK);
                MessageBox.Show("零件信息更新失败,请检查零件编号是否过长或是无填写", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }