Exemplo n.º 1
0
        /// <summary>
        /// 构造函数
        /// </summary>
        public FormOSM_HW_Add()
        {
            InitializeComponent();
            hw = new HW();

            string whereString = "where PID = 43 ";
            SJZDController.setZD_ComboBox(whereString, comboBox_HW_TYPE);
            comboBox_HW_TYPE.Enabled = false;

            //产品列表数据填充
            fillProductComboBox();
        }
Exemplo n.º 2
0
        /// <summary>
        /// 实现数据库插入货物数据
        /// </summary>
        /// <param name="hw"></param>
        /// <returns></returns>
        private bool addHW(HW hw)
        {
            string sql = "insert into OSM_HW(OFFERSHEET_CODE,PRODUCT_ID,HW_NUMBER,HW_PRICE,HW_TOTALPRICE,COMMENT) ";
            sql += "values('" + hw.getOFFERSHEET_CODE() + "'," + hw.getPRODUCT_ID() + ","; 
            sql += hw.getHW_NUMBER().ToString() + "," + hw.getHW_PRICE().ToString(); 
            sql += "," + hw.getHW_TOTALPRICE().ToString() + ",'" + hw.getCOMMENT() + "')";

            AccessDB adb = new AccessDB();
            bool isExecuteSucc = adb.SQLExecute(sql);
            if (isExecuteSucc)
            {
                MessageBox.Show("添加成功!", "消息");
            }
            else
            {
                MessageBox.Show("添加失败!", "消息");
            }
            return isExecuteSucc;
        }
Exemplo n.º 3
0
        /// <summary>
        /// 将窗口输入框内容填入货物对象
        /// </summary>
        /// <param name="hw"></param>
        private void createHW(HW hw)
        {
            int number = int.Parse(textBox_HW_NUMBER.Text);
            double price = double.Parse(textBox_HW_PRICE.Text);

            //hw.setHW_NAME(textBox_HW_NAME.Text);
            //hw.setHW_CODE(textBox_HW_CODE.Text);
            hw.setHW_NUMBER(number);
            hw.setHW_PRICE(price);
            hw.setHW_TOTALPRICE(price * number);
            hw.setCOMMENT(textBox_HW_COMMENT.Text);
        }