Example #1
0
        /// <summary>
        /// 构造函数
        /// </summary>
        public FormOSM_Offers_Add(string uuid = "")
        {
            InitializeComponent();

            buyer = new Buyer();
            seller = new Seller();
            offer_sheet = new OfferSheet();
            //hw = new HW();

            dataGridView_HW.AutoGenerateColumns = false;

            string whereString = "where PID = 10";
            SJZDController.setZD_ComboBox(whereString, comboBox_OFFERSHEET_REGION);

            whereString = "where PID = 33";
            SJZDController.setZD_ComboBox(whereString, comboBox_OFFERSHEET_TYPE);

            string offsht_code = "U" + uuid + "OSC" + DateTime.Now.ToString("yyyyMMddHHmmss");
            textBox_OFFERSHEET_CODE.Text = offsht_code;

            fillSellerComboBox(comboBox_SELLER);
            fillBuyerComboBox(comboBox_BUYER);
            //queryByHW(dataGridView_HW);
        }
Example #2
0
        /// <summary>
        /// 数据库更新报价单记录
        /// </summary>
        /// <param name="offer_sheet"></param>
        /// <returns>是否更新成功</returns>
        private bool updateOfferSheet(OfferSheet offer_sheet)
        {
            string sql = "update OSM_OFFER_SHEET set OFFERSHEET_CODE = '" + offer_sheet.getOFFERSHEET_CODE() + "',";
            sql += "GMF_ID=" + offer_sheet.getGMF_ID().ToString() + ",BJF_ID=" + offer_sheet.getBJF_ID() + ",";
            sql += "OFFERSHEET_TYPE='" + offer_sheet.getOFFERSHEET_TYPE() + "',OFFERSHEET_DATE = #" + offer_sheet.getOFFERSHEET_DATE() + "#,"; 
            sql += "OFFERSHEET_STATE='" + offer_sheet.getOFFERSHEET_STATE() + "',";
            sql += "OFFERSHEET_REGION = '" + offer_sheet.getOFFERSHEET_REGION() + "' ";
            sql += "where ID = " + offer_sheet.getID().ToString();

            AccessDB adb = new AccessDB();
            bool isExecuteSucc = adb.SQLExecute(sql);
            if (isExecuteSucc)
            {
                MessageBox.Show("更新成功!", "消息");
            }
            else
            {
                MessageBox.Show("更新失败!", "消息");
            }
            return isExecuteSucc;
        }
Example #3
0
        /// <summary>
        /// 数据库新增报价单记录
        /// </summary>
        /// <param name="offer_sheet">报价单对象</param>
        /// <returns>是否添加成功</returns>
        private bool addOfferSheet(OfferSheet offer_sheet)
        {
            string sql = "insert into OSM_OFFER_SHEET(OFFERSHEET_CODE,GMF_ID,BJF_ID,OFFERSHEET_TYPE,OFFERSHEET_DATE,OFFERSHEET_STATE,OFFERSHEET_REGION) ";
            sql += "values('" + offer_sheet.getOFFERSHEET_CODE() + "'," + offer_sheet.getGMF_ID() + "," + offer_sheet.getBJF_ID();
            sql += ",'" + offer_sheet.getOFFERSHEET_TYPE() + "','" + offer_sheet.getOFFERSHEET_DATE() + "','";
            sql += offer_sheet.getOFFERSHEET_STATE() + "','" + offer_sheet.getOFFERSHEET_REGION() + "')";

            AccessDB adb = new AccessDB();
            bool isExecuteSucc = adb.SQLExecute(sql);
            if (isExecuteSucc)
            {
                MessageBox.Show("添加成功!", "消息");
            }
            else
            {
                MessageBox.Show("添加失败!", "消息");
            }
            return isExecuteSucc;
            
        }