Exemple #1
0
        private void button_OK_Click(object sender, EventArgs e)
        {
            if (string.IsNullOrWhiteSpace(textBox_Name.Text))
            {
                MessageBox.Show("产品名称不能为空!", "警告");
                return;
            }

            if (string.IsNullOrWhiteSpace(textBox_Code.Text))
            {
                MessageBox.Show("产品代码不能为空!", "警告");
                return;
            }

            if (comboBox_Type.SelectedIndex == -1)
            {
                MessageBox.Show("所属设备不能为空!", "警告");
                return;
            }

            AccessDB adb = new AccessDB();

            KeyValuePair<string,string> item = (KeyValuePair<string,string>)(comboBox_Type.SelectedItem);

            string insertSQL = "INSERT INTO OSM_STORAGE(HW_NAME,HW_CODE,HW_TYPE,COMMENT) VALUES (";
            insertSQL += "'" + textBox_Name.Text + "','" + textBox_Code.Text + "','" + item.Key + "','" + textBox_Comment.Text + "')";

            if (adb.SQLExecute(insertSQL))
            {
                MessageBox.Show("添加成功!", "消息");
                HWWindow.refresh_product_comboBox();
                this.Close();
                this.Dispose();
            }
        }
Exemple #2
0
 /// <summary>
 /// 以数据字典中的内容填充下拉列表
 /// </summary>
 /// <param name="whereString"></param>
 /// <param name="cmbx"></param>
 public static void setZD_ComboBox(string whereString, ComboBox cmbx)
 {
     AccessDB adb = new AccessDB();
     Dictionary<string, string> dict = adb.QuerySJZD(whereString);
     BindingSource bs = new BindingSource();
     bs.DataSource = dict;
     cmbx.DataSource = bs;
     cmbx.ValueMember = "Key";
     cmbx.DisplayMember = "Value";
 }
Exemple #3
0
        /// <summary>
        /// 以数据字典中的内容填充下拉列表
        /// </summary>
        /// <param name="whereString"></param>
        /// <param name="cmbx"></param>
        public static void setZD_ComboBox(string whereString, ComboBox cmbx)
        {
            AccessDB adb = new AccessDB();
            Dictionary <string, string> dict = adb.QuerySJZD(whereString);
            BindingSource bs = new BindingSource();

            bs.DataSource      = dict;
            cmbx.DataSource    = bs;
            cmbx.ValueMember   = "Key";
            cmbx.DisplayMember = "Value";
        }
Exemple #4
0
        /// <summary>
        /// 确认按钮点击事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void button_OK_Click(object sender, EventArgs e)
        {
            if (textBox_old_pwd.Text == "")
            {
                MessageBox.Show("原密码输入框不能为空!", "警告");
                return;
            }

            if (textBox_new_pwd.Text == "")
            {
                MessageBox.Show("新密码输入框不能为空!", "警告");
                return;
            }

            AccessDB adb = new AccessDB();
            string sql = "SELECT * FROM BASE_USERS WHERE USER_ID = '" + uid + "'";
            DataSet ds = adb.SQLQuery(sql);
            DataTable dt = ds.Tables[0];
            DataRow dr = dt.Rows[0];

            if (textBox_old_pwd.Text != dr["USER_PWD"].ToString() && dr["USER_PWD"] != null)
            {
                MessageBox.Show("原密码输入错误!", "警告");
                return;
            }


            if (textBox_new_pwd.Text == textBox_old_pwd.Text)
            {
                MessageBox.Show("新密码请不要与旧密码重复", "警告");
                return;
            }

            if (textBox_new_pwd.Text != textBox_pwd_confirm.Text)
            {
                MessageBox.Show("两次输入密码不一致!", "警告");
                return;
            }

            sql = "UPDATE BASE_USERS SET USER_PWD = '" + textBox_new_pwd.Text + "' WHERE USER_ID = '" + uid + "'";
            if (adb.SQLExecute(sql))
            {
                MessageBox.Show("密码修改成功!", "消息");
                this.Close();
            }
        }
        private void button_OK_Click(object sender, EventArgs e)
        {
            AccessDB adb = new AccessDB();

            string updateSQL = "update OSM_DILIVERY_SHEET set ";
            string orderUpdateSQL = "update OSM_ORDER_SHEET set ORDER_STATE = ";

            if (state == 0)
            {
                //发货时间
                updateSQL += " DILIVERY_DATE = #" + dateTimePicker_Delivery.Text + "#,DILIVERY_STATE='2' where ID = " + deliverySheetID;
                orderUpdateSQL += " '5' where ID = " + orderID;
            }
            else
            {
                //到货时间
                updateSQL += " ARRIVE_DATE = #" + dateTimePicker_Delivery.Text + "#,DILIVERY_STATE='3' where ID = " + deliverySheetID;
                orderUpdateSQL += " '6' where ID = " + orderID;
            }

            if (adb.SQLExecute(updateSQL))
            {
                if (adb.SQLExecute(orderUpdateSQL))
                {
                    MessageBox.Show("确认成功!", "消息");
                    this.Close();
                    this.Dispose();
                }
                else
                {
                    MessageBox.Show("更新订单列表出错!", "错误");
                    this.Close();
                    this.Dispose();
                }
            }
            else
            {
                MessageBox.Show("更新发货单列表出错!", "错误");
                this.Close();
                this.Dispose();
            }
        }
Exemple #6
0
        private void login()
        {
            AccessDB adb = new AccessDB();
            string sql = "select * from BASE_USERS where USER_ID = '" + TB_UserName.Text + "' and USER_PWD = '" + TB_PWD.Text + "'";
            Hashtable ht = adb.login(sql);

            if (ht != null)
            {
                id = ht["id"].ToString();
                userid = ht["userid"].ToString();
                username = ht["username"].ToString();
                //MessageBox.Show("登录成功!", "欢迎");
                //登陆成功,返回成功信息
                DialogResult = DialogResult.OK;
            }
            else
            {
                MessageBox.Show("用户名密码不匹配!", "警告");
            }
        }
Exemple #7
0
        /// <summary>
        /// 以sql查询结果填充下拉列表
        /// </summary>
        /// <param name="sql"></param>
        /// <param name="cbox"></param>
        public static void fillComboBox(string sql, ComboBox cbox)
        {
            AccessDB adb = new AccessDB();
            DataTable dt = adb.SQLTableQuery(sql);

            Dictionary<int, string> Dict = new Dictionary<int, string>();

            foreach (DataRow dr in dt.Rows)
            {
                int id = (int)dr.ItemArray[0];
                string com_name = dr.ItemArray[1].ToString();
                Dict.Add(id, com_name);
            }

            BindingSource bs = new BindingSource();
            bs.DataSource = Dict;
            cbox.DataSource = bs;
            cbox.ValueMember = "Key";
            cbox.DisplayMember = "Value";
        }
        /// <summary>
        /// 通过按钮点击事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void button_pass_Click(object sender, EventArgs e)
        {
            AccessDB adb = new AccessDB();

            string query = "select sum(HW_TOTALPRICE) from OSM_HW where OFFERSHEET_CODE = '" + offerSheetCode + "'";
            DataTable dt = adb.SQLTableQuery(query);
            if (dt.Rows.Count > 0)
            {
                DataRow dr = dt.Rows[0];
                double require_payment = 0;
                try
                {
                    require_payment = double.Parse(dr[0].ToString());
                }
                catch (Exception exception)
                {
                    MessageBox.Show("该报价单没有对应的货物列表,无法通过审核!" + exception.ToString(), "警告");
                    return;
                }
                

                //生成订单存入数据库
                string insertSQL = "insert into OSM_ORDER_SHEET(OFFERSHEET_ID,ORDER_STATE,REQUIRE_PAYMENT,ORDER_DATE,PAY_STATE) values ('" + offerSheetID + "','1'," + require_payment + ",#" + DateTime.Now.ToString("yyyy-MM-dd") + "#,'1')";
                if (adb.SQLExecute(insertSQL))
                {
                    MessageBox.Show("已将审核通过的报价单生成订单","消息");

                    string sql = "update OSM_OFFER_SHEET set OFFERSHEET_STATE = '2' where ID = " + offerSheetID;
                    if (adb.SQLExecute(sql))
                    {
                        main_form.TSMItem_offer_aduit_Refresh();
                        this.Close();
                        this.Dispose();
                    }
                }
            }
            else
            {
                MessageBox.Show("该报价单没有对应的货物列表,无法通过审核!", "警告");
            }
        }
Exemple #9
0
        /// <summary>
        /// 以sql查询结果填充下拉列表
        /// </summary>
        /// <param name="sql"></param>
        /// <param name="cbox"></param>
        public static void fillComboBox(string sql, ComboBox cbox)
        {
            AccessDB  adb = new AccessDB();
            DataTable dt  = adb.SQLTableQuery(sql);

            Dictionary <int, string> Dict = new Dictionary <int, string>();

            foreach (DataRow dr in dt.Rows)
            {
                int    id       = (int)dr.ItemArray[0];
                string com_name = dr.ItemArray[1].ToString();
                Dict.Add(id, com_name);
            }

            BindingSource bs = new BindingSource();

            bs.DataSource      = Dict;
            cbox.DataSource    = bs;
            cbox.ValueMember   = "Key";
            cbox.DisplayMember = "Value";
        }
Exemple #10
0
        /// <summary>
        /// 打开订单窗口可触发动作,显示读取到的数据
        /// </summary>
        /// <param name="ht"></param>
        public void viewOrderSheet(Hashtable ht)
        {
            if (viewState == 0)
            {
                textBox_AlreadyPayment.ReadOnly = true;
                textBox_PrePayment.ReadOnly = true;
                textBox_RequirePayment.ReadOnly = true;
                //textBox_AlreadyPayment.Enabled = false;
                //textBox_PrePayment.Enabled = false;
                //textBox_RequirePayment.Enabled = false;
                comboBox_OrderState.Enabled = false;
                comboBox_PayMode.Enabled = false;
                comboBox_PayState.Enabled = false;
                dateTimePicker_OrderDate.Enabled = false;
            }

            if (viewState == 1)
            {
                textBox_RequirePayment.ReadOnly = true;
                comboBox_OrderState.Enabled = false;
                comboBox_PayState.Enabled = false;
                dateTimePicker_OrderDate.Enabled = false;
            }

            textBox_OfferSheetCode.Text = ht["OFFERSHEET_CODE"].ToString();
            textBox_AlreadyPayment.Text = ht["ALREADY_PAYMENT"].ToString();
            textBox_PrePayment.Text = ht["PRE_PAYMENT"].ToString();
            textBox_RequirePayment.Text = ht["REQUIRE_PAYMENT"].ToString();
            dateTimePicker_OrderDate.Text = ((DateTime)ht["ORDER_DATE"]).ToString("yyyy-MM-dd");
            
            for (int i = 0; i < comboBox_OrderState.Items.Count; i++)
            {
                KeyValuePair<string, string> kv = (KeyValuePair<string, string>)comboBox_OrderState.Items[i];
                if (ht["ORDER_STATE"].ToString() == kv.Key)
                {
                    comboBox_OrderState.SelectedIndex = i;
                    break;
                }
            }

            if (string.IsNullOrWhiteSpace(ht["PAY_MODE"].ToString()))
            {
                comboBox_PayMode.SelectedIndex = -1;
            }
            else
            {
                for (int i = 0; i < comboBox_PayMode.Items.Count; i++)
                {
                    KeyValuePair<string, string> kv = (KeyValuePair<string, string>)comboBox_PayMode.Items[i];
                    if (ht["PAY_MODE"].ToString() == kv.Key)
                    {
                        comboBox_PayMode.SelectedIndex = i;
                        break;
                    }
                }
            }
            

            for (int i = 0; i < comboBox_PayState.Items.Count; i++)
            {
                KeyValuePair<string, string> kv = (KeyValuePair<string, string>)comboBox_PayState.Items[i];
                if (ht["PAY_STATE"].ToString() == kv.Key)
                {
                    comboBox_PayState.SelectedIndex = i;
                    break;
                }
            }

            string sql = "select * from OSM_HW_LIST_V where OFFERSHEET_CODE = '" + ht["OFFERSHEET_CODE"].ToString() + "'";
            AccessDB adb = new AccessDB();
            DataTable dt = adb.SQLTableQuery(sql);
            dataGridView_HW.AutoGenerateColumns = false;
            dataGridView_HW.DataSource = dt;
        }
Exemple #11
0
        /// <summary>
        /// 对应报价单审核通过
        /// </summary>
        /// <param name="offerSheetID">报价单ID</param>
        /// <param name="offerSheetCode">报价单编号</param>
        private void PassOfferSheet(string offerSheetID, string offerSheetCode)
        {
            AccessDB adb = new AccessDB();

            string query = "select sum(HW_TOTALPRICE) as REQUIRE_PAYMENT from OSM_HW where OFFERSHEET_CODE = '" + offerSheetCode + "'";
            DataTable dt = adb.SQLTableQuery(query);
            if (dt.Rows.Count > 0)
            {
                DataRow dr = dt.Rows[0];
                double require_payment = 0;
                try
                {
                    require_payment = double.Parse(dr["REQUIRE_PAYMENT"].ToString());
                }
                catch (Exception exception)
                {
                    MessageBox.Show("该报价单没有对应的货物列表,无法通过审核!" + exception.ToString(), "警告");
                    return;
                }

                FormOSM_PayMode_Select fps = new FormOSM_PayMode_Select();
                fps.setOfferForm(this);
                fps.StartPosition = FormStartPosition.CenterParent;
                fps.ShowDialog();

                if (!string.IsNullOrWhiteSpace(pay_mode))
                {
                    //生成订单存入数据库
                    string insertSQL = "insert into OSM_ORDER_SHEET(OFFERSHEET_ID,ORDER_STATE,REQUIRE_PAYMENT,ORDER_DATE,PAY_STATE,PAY_MODE) values ('";
                    insertSQL += offerSheetID + "','1'," + require_payment + ",#" + DateTime.Now.ToString("yyyy-MM-dd") + "#,'1','" + pay_mode + "')";
                    if (adb.SQLExecute(insertSQL))
                    {
                        MessageBox.Show("已将审核通过的报价单生成订单", "消息");

                        string sql = "update OSM_OFFER_SHEET set OFFERSHEET_STATE = '2' where ID = " + offerSheetID;
                        if (adb.SQLExecute(sql))
                        {
                            main_form.TSMItem_offer_aduit_Refresh();
                        }
                    }
                }
                else
                {
                    MessageBox.Show("请确定付款方式!", "警告");
                }
            }
            else
            {
                MessageBox.Show("该报价单没有对应的货物列表,无法通过审核!", "警告");
            }
        }
        /// <summary>
        /// 查看订单按钮
        /// </summary>
        /// <param name="order_id"></param>
        private void viewOrderSheet(string order_id)
        {
            string sql = "select OSM_ORDER_SHEET.ID,OFFERSHEET_ID,ORDER_STATE,ORDER_DATE,PAY_MODE,PAY_STATE,ALREADY_PAYMENT,PRE_PAYMENT,REQUIRE_PAYMENT,OFFERSHEET_CODE ";
            sql += " from (OSM_ORDER_SHEET inner join OSM_OFFER_SHEET on OSM_ORDER_SHEET.OFFERSHEET_ID = OSM_OFFER_SHEET.ID) ";
            sql += " where OSM_ORDER_SHEET.ID = " + order_id + " ";

            AccessDB adb = new AccessDB();
            DataTable dt = adb.SQLTableQuery(sql);

            Hashtable hashtable = new Hashtable();

            if (dt.Rows.Count == 1)
            {
                DataRow dr = dt.Rows[0];
                hashtable.Add("ID", dr["ID"]);
                hashtable.Add("OFFERSHEET_ID", dr["OFFERSHEET_ID"]);
                hashtable.Add("ORDER_STATE", dr["ORDER_STATE"]);
                hashtable.Add("ORDER_DATE", dr["ORDER_DATE"]);
                hashtable.Add("PAY_MODE", dr["PAY_MODE"]);
                hashtable.Add("PAY_STATE", dr["PAY_STATE"]);
                hashtable.Add("ALREADY_PAYMENT", dr["ALREADY_PAYMENT"]);
                hashtable.Add("PRE_PAYMENT", dr["PRE_PAYMENT"]);
                hashtable.Add("REQUIRE_PAYMENT", dr["REQUIRE_PAYMENT"]);
                hashtable.Add("OFFERSHEET_CODE", dr["OFFERSHEET_CODE"]);
            }

            FormOSM_Order_View orderView = new FormOSM_Order_View();
            orderView.setOrderID(order_id);
            //设置窗口状态为查看
            orderView.setViewState(0);
            orderView.viewOrderSheet(hashtable);
            orderView.StartPosition = FormStartPosition.CenterParent;
            orderView.ShowDialog();
        }
        /// <summary>
        /// 不通过按钮点击事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void button_unpass_Click(object sender, EventArgs e)
        {
            string sql = "update OSM_OFFER_SHEET set OFFERSHEET_STATE = '3' where ID = " + offerSheetID;

            AccessDB adb = new AccessDB();
            if (adb.SQLExecute(sql))
            {
                main_form.TSMItem_offer_aduit_Refresh();
                this.Close();
                this.Dispose();
            }
        }
        /// <summary>
        /// 检查是否可以发货,不能发货则生成对应的采购单
        /// </summary>
        /// <param name="hashList">货物列表</param>
        /// <param name="order_id">订单ID</param>
        /// <returns></returns>
        private bool checkDelivery(List<Hashtable> hashList, string order_id)
        {
            List<Hashtable> purchaseList = new List<Hashtable>();
            AccessDB adb = new AccessDB();

            for (int i = 0; i < hashList.Count; i++)
            {
                Hashtable ht = hashList[i];
                string product_id = ht["PRODUCT_ID"].ToString();
                int hw_need_number = int.Parse(ht["HW_NUMBER"].ToString());

                string sql = "select ID,HW_NUMBER from OSM_STORAGE where ID = " + product_id + "";
                DataTable dt = adb.SQLTableQuery(sql);
                if (dt.Rows.Count == 1)
                {
                    DataRow dr = dt.Rows[0];
                    int hw_storage_number = int.Parse(dr["HW_NUMBER"].ToString());
                    int hw_diff_number = hw_need_number - hw_storage_number;
                    if (hw_diff_number > 0)
                    {
                        string updateSQL = "update OSM_STORAGE set HW_NUMBER = 0 where ID = " + product_id;
                        adb.SQLExecute(updateSQL);

                        ht["HW_NUMBER"] = hw_diff_number;
                        purchaseList.Add(ht);
                    }
                    else
                    {
                        string updateSQL = "update OSM_STORAGE set HW_NUMBER = " + (-hw_diff_number) + " where ID = " + product_id;
                        adb.SQLExecute(updateSQL);

                        break;
                    }
                }
                else
                {
                    ht["HW_NUMBER"] = hw_need_number;
                    purchaseList.Add(ht);
                }
            }

            if (purchaseList.Count == 0)
            {
                //string insertSQL = "insert into OSM_DILIVERY_SHEET(ORDER_ID,DILIVERY_STATE) values(" + order_id + ",'1')";
                //if (adb.SQLExecute(insertSQL))
                //{
                //    return true;
                //}
                return true;
            }
            else
            {
                int count = createPurchaseSheet(purchaseList, order_id);
                MessageBox.Show("库存不足,新增" + count + "条采购记录", "消息");
                return false;
            }
        }
Exemple #15
0
        private void comboBox_recordsPerPage_SelectedIndexChanged(object sender, EventArgs e)
        {
            pageIndex = 1;
            pageSize = int.Parse(comboBox_recordsPerPage.SelectedItem.ToString());

            AccessDB adb = new AccessDB();
            //执行查询第一页,默认页面容量为选择页面容量
            DataTable dt = adb.ExecutePager(pageIndex, pageSize, keyString, showString, queryString, whereString, orderString, out pageCount, out recordSum);
            dgv.DataSource = dt;
            label_current_page.Text = "1/" + pageCount.ToString();
            label_record_sum.Text = recordSum.ToString();
        }
Exemple #16
0
        /// <summary>
        /// 采购到货确认
        /// </summary>
        /// <param name="purchase_id">采购记录编号</param>
        private void confirmPurchase(string purchase_id)
        {
            string sql = "SELECT OSM_PURCHASE_SHEET.ORDER_ID, OSM_PURCHASE_SHEET.PRODUCT_ID, OSM_STORAGE.HW_TYPE, OSM_STORAGE.HW_NAME, OSM_STORAGE.HW_CODE, OSM_PURCHASE_SHEET.PURCHASE_NUMBER ";
            sql += " FROM OSM_STORAGE INNER JOIN OSM_PURCHASE_SHEET ON OSM_STORAGE.ID = OSM_PURCHASE_SHEET.PRODUCT_ID";
            sql += " WHERE OSM_PURCHASE_SHEET.ID = " + purchase_id;

            AccessDB adb = new AccessDB();
            DataTable dt = adb.SQLTableQuery(sql);

            Hashtable hashtable = new Hashtable();
            

            if (dt.Rows.Count == 1)
            {
                DataRow dr = dt.Rows[0];
                hashtable.Add("ID", purchase_id);
                hashtable.Add("ORDER_ID", dr["ORDER_ID"]);
                hashtable.Add("PRODUCT_ID", dr["PRODUCT_ID"]);
                hashtable.Add("HW_TYPE", dr["HW_TYPE"]);
                hashtable.Add("HW_NAME", dr["HW_NAME"]);
                hashtable.Add("HW_CODE", dr["HW_CODE"]);
                hashtable.Add("PURCHASE_NUMBER", dr["PURCHASE_NUMBER"]);
            }

            FormOSM_Purchase_Confirm fpc = new FormOSM_Purchase_Confirm();
            fpc.Set_fWindow(this);
            fpc.viewProduct(hashtable);
            fpc.StartPosition = FormStartPosition.CenterParent;
            fpc.ShowDialog();

            //MessageBox.Show(purchase_id);
        }
Exemple #17
0
        /// <summary>
        /// 删除报价单按钮
        /// </summary>
        /// <param name="offersheet_code"></param>
        private void delOfferSheet(string offersheet_code)
        {
            AccessDB adb = new AccessDB();

            string whereString = " where OFFERSHEET_CODE = '" + offersheet_code + "'";

            if (adb.SQLTableDelete("OSM_HW", whereString) >= 0)
            {
                if (adb.SQLTableDelete("OSM_OFFER_SHEET", whereString) == 1)
                {
                    MessageBox.Show("删除成功!", "消息");
                    queryFromOfferSheetV(dataGridView_OfferSheet);
                }
            }
        }
Exemple #18
0
        /// <summary>
        /// 查看报价单按钮
        /// </summary>
        /// <param name="offersheet_code"></param>
        private void viewOfferSheet(string offersheet_code)
        {
            string sql = "select * from OSM_OFFER_SHEET ";
            sql += "where OFFERSHEET_CODE = '" + offersheet_code + "'";

            AccessDB adb = new AccessDB();
            DataTable dt = adb.SQLTableQuery(sql);
            Hashtable hashtable = new Hashtable();

            if (dt.Rows.Count == 1)
            {
                DataRow dr = dt.Rows[0];
                hashtable.Add("ID", dr["ID"]);
                hashtable.Add("OFFERSHEET_CODE", dr["OFFERSHEET_CODE"]);
                hashtable.Add("GMF_ID", dr["GMF_ID"]);
                hashtable.Add("BJF_ID", dr["BJF_ID"]);
                hashtable.Add("OFFERSHEET_TYPE", dr["OFFERSHEET_TYPE"]);
                hashtable.Add("OFFERSHEET_DATE", dr["OFFERSHEET_DATE"]);
                hashtable.Add("OFFERSHEET_STATE", dr["OFFERSHEET_STATE"]);
                hashtable.Add("OFFERSHEET_REGION", dr["OFFERSHEET_REGION"]);
                hashtable.Add("CONFIRM_DATE", dr["CONFIRM_DATE"]);
            }

            FormOSM_Offers_Add form_add_offers = new FormOSM_Offers_Add();
            form_add_offers.dataGridView_viewBtn_click_reaction(hashtable);
            form_add_offers.setMainForm(main_form);
            form_add_offers.setViewState(1);
            form_add_offers.StartPosition = FormStartPosition.CenterParent;
            form_add_offers.ShowDialog();
        }
Exemple #19
0
        /// <summary>
        /// 付款操作
        /// </summary>
        /// <param name="pre_pay">预付款金额</param>
        /// <param name="actual_pay">实际付款</param>
        private void prePayOrder(double pre_pay, double actual_pay)
        {
            AccessDB adb = new AccessDB();

            string PaySheetUpdateSQL = "update OSM_PAYMENTREMINDER_SHEET set ACHIEVE_DATE = #" + DateTime.Now.ToString("yyyy-MM-dd") + "# where ID = " + p_id;
            string OrderSheetUpdateSQL = "update OSM_ORDER_SHEET set PAY_STATE = '3',PRE_PAYMENT = " + pre_pay + ",ALREADY_PAYMENT = " + actual_pay + " where ID = " + order_id;

            if (adb.SQLExecute(OrderSheetUpdateSQL))
            {
                if (adb.SQLExecute(PaySheetUpdateSQL))
                {
                    MessageBox.Show("预付部分款成功", "消息");
                }
            }
        }
        /// <summary>
        /// DataGridView单元格点击事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void dataGridView_PayList_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {
            if (dataGridView_PayList.Columns[e.ColumnIndex].Name == "viewOrderBtn")
            {
                string order_id = dataGridView_PayList.Rows[e.RowIndex].Cells["ORDER_ID"].Value.ToString();

                viewOrderSheet(order_id);
            }

            if (dataGridView_PayList.Columns[e.ColumnIndex].Name == "PayBtn")
            {
                AccessDB adb = new AccessDB();

                string p_id = dataGridView_PayList.Rows[e.RowIndex].Cells["ID"].Value.ToString();
                string order_id = dataGridView_PayList.Rows[e.RowIndex].Cells["ORDER_ID"].Value.ToString();
                string payMode = dataGridView_PayList.Rows[e.RowIndex].Cells["PAY_MODE"].Value.ToString();
                string payState = dataGridView_PayList.Rows[e.RowIndex].Cells["PAY_STATE"].Value.ToString();
                string need_to_pay = dataGridView_PayList.Rows[e.RowIndex].Cells["REQUIRE_PAYMENT"].Value.ToString();
                string pre_pay = dataGridView_PayList.Rows[e.RowIndex].Cells["PRE_PAYMENT"].Value.ToString();
                string already_pay = dataGridView_PayList.Rows[e.RowIndex].Cells["ALREADY_PAYMENT"].Value.ToString();

                switch (payMode)
                {
                    case "1":
                        if (payState == "1")
                        {
                            getPayed(order_id, p_id, need_to_pay);
                        }
                        else
                        {
                            MessageBox.Show("该订单已付款!", "消息");
                            return;
                        }
                        break;
                    case "2":
                        if (payState == "1")
                        {
                            string sql = "select ORDER_STATE from OSM_ORDER_SHEET where ID = " + order_id;
                            DataTable dt = adb.SQLTableQuery(sql);
                            DataRow dr = dt.Rows[0];
                            string order_state = dr["ORDER_STATE"].ToString();

                            if (order_state == "6")
                            {
                                getPayed(order_id, p_id, need_to_pay);
                            }
                            else
                            {
                                MessageBox.Show("该订单为货到付款,现订单状态非已到货,无法提前付款!", "警告");
                            }
                        }
                        else
                        {
                            MessageBox.Show("该订单已付款!", "消息");
                            return;
                        }
                        break;
                    case "3":
                        if (payState == "1")
                        {
                            getPrePayed(order_id, p_id, need_to_pay);
                        }
                        else if (payState == "3")
                        {
                            string sql = "select ORDER_STATE from OSM_ORDER_SHEET where ID = " + order_id;
                            DataTable dt = adb.SQLTableQuery(sql);
                            DataRow dr = dt.Rows[0];
                            string order_state = dr["ORDER_STATE"].ToString();

                            if (order_state == "6")
                            {
                                getRestPayed(order_id, p_id, need_to_pay, already_pay);
                            }
                            else
                            {
                                MessageBox.Show("该订单已预付部分款,现订单状态非已到货,无法提前付剩余款!", "警告");
                            }
                        }
                        else
                        {
                            MessageBox.Show("该订单已付款!", "消息");
                            return;
                        }
                        break;
                    default:
                        MessageBox.Show("付款方式出错!", "错误");
                        break;
                }
            }
        }
Exemple #21
0
        /// <summary>
        /// 对应报价单审核不通过
        /// </summary>
        /// <param name="offerSheetID">报价单ID</param>
        private void FailOfferSheet(string offerSheetID)
        {
            string sql = "update OSM_OFFER_SHEET set OFFERSHEET_STATE = '3' where ID = " + offerSheetID;

            AccessDB adb = new AccessDB();
            if (adb.SQLExecute(sql))
            {
                main_form.TSMItem_offer_aduit_Refresh();
            }
        }
Exemple #22
0
        /// <summary>
        /// 付款操作
        /// </summary>
        /// <param name="rest_pay">预付款阶段已付款</param>
        /// <param name="actual_pay">实际付款</param>
        private void restPayOrder(double already_pay, double actual_pay)
        {
            AccessDB adb = new AccessDB();

            double payment = already_pay + actual_pay;
            string PaySheetUpdateSQL = "update OSM_PAYMENTREMINDER_SHEET set ACHIEVE_DATE = #" + DateTime.Now.ToString("yyyy-MM-dd") + "# where ID = " + p_id;
            string OrderSheetUpdateSQL = "update OSM_ORDER_SHEET set PAY_STATE = '2',ALREADY_PAYMENT = " + payment + " where ID = " + order_id;

            if (adb.SQLExecute(OrderSheetUpdateSQL))
            {
                if (adb.SQLExecute(PaySheetUpdateSQL))
                {
                    MessageBox.Show("已付清全款!", "消息");
                }
            }
        }
        /// <summary>
        /// 检查订单对应货物列表
        /// </summary>
        /// <param name="order_id">订单ID</param>
        /// <param name="offersheet_code">报价单编号</param>
        private void checkOfferHW(string order_id, string offersheet_code)
        {
            string sql = "select PRODUCT_ID,HW_NUMBER from OSM_HW where OFFERSHEET_CODE = '" + offersheet_code + "'";

            AccessDB adb = new AccessDB();
            DataTable dt = adb.SQLTableQuery(sql);

            List<Hashtable> hashList = new List<Hashtable>();
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                DataRow dr = dt.Rows[i];
                Hashtable ht = new Hashtable();

                ht.Add("PRODUCT_ID", dr["PRODUCT_ID"]);
                //ht.Add("HW_NAME", dr["HW_NAME"]);
                //ht.Add("HW_CODE", dr["HW_CODE"]);
                ht.Add("HW_NUMBER", dr["HW_NUMBER"]);

                hashList.Add(ht);
            }

            if (checkDelivery(hashList, order_id))
            {
                //MessageBox.Show("根据与库存容量比对,可以发货!", "消息");
                sql = "update OSM_ORDER_SHEET set ORDER_STATE = '3' where ID = " + order_id;
                if (adb.SQLExecute(sql))
                {
                    MessageBox.Show("库存充足,对应订单已可以进行发货审核!", "消息");
                    //查询订单视图返回结果
                    queryFromOrderSheetV(dataGridView_Order, "where ORDER_STATE = '1' ");
                }
            }
            else
            {
                sql = "update OSM_ORDER_SHEET set ORDER_STATE = '2' where ID = " + order_id;
                if (adb.SQLExecute(sql))
                {
                    //查询订单视图返回结果
                    queryFromOrderSheetV(dataGridView_Order, "where ORDER_STATE = '1' ");
                }       
            }
        }
        /// <summary>
        /// 生成发货单
        /// </summary>
        /// <param name="order_id"></param>
        private void orderDeliver(string order_id)
        {
            AccessDB adb = new AccessDB();

            string insertSQL = "insert into OSM_DILIVERY_SHEET(ORDER_ID,DILIVERY_STATE) values(" + order_id + ",'1')";

            if (adb.SQLExecute(insertSQL))
            {
                string updateSQL = "update OSM_ORDER_SHEET set ORDER_STATE = '4' where ID = " + order_id;
                if (adb.SQLExecute(updateSQL))
                {
                    MessageBox.Show("该订单可以发货,已生成发货单!", "消息");
                    queryFromOrderSheetV(dataGridView_Order, "where ORDER_STATE = '3' ");
                }
            }
        }
        /// <summary>
        /// 根据得到的hashList货物列表生成采购单
        /// </summary>
        /// <param name="purchaseList">采购货物列表</param>
        /// <param name="order_id">订单</param>
        /// <returns>新增采购记录数量</returns>        
        private int createPurchaseSheet(List<Hashtable> purchaseList, string order_id)
        {
            AccessDB adb = new AccessDB();
            int count = 0;
            string insertSql = "insert into OSM_PURCHASE_SHEET(ORDER_ID,PRODUCT_ID,PURCHASE_NUMBER,PURCHASE_STATE,INIT_DATE) values (";

            for (int i = 0; i < purchaseList.Count; i++)
            {
                Hashtable ht = purchaseList[i];
                string valueString = order_id + ",";
                valueString +=  ht["PRODUCT_ID"].ToString() + ",";
                //valueString += "'" + ht["HW_NAME"].ToString() + "',";
                //valueString += "'" + ht["HW_CODE"].ToString() + "',";
                valueString += ht["HW_NUMBER"].ToString() + ",'1',#" + DateTime.Now.ToString("yyyy-MM-dd") + "#)";

                string sql = insertSql + valueString;
                if (adb.SQLExecute(sql))
                {
                    count++;
                }
            }

            return count;
        }
Exemple #26
0
        /// <summary>
        /// 跳转按钮点击事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void button_goToPage_Click(object sender, EventArgs e)
        {
            pageIndex = int.Parse(textBox_page_index.Text);

            if (pageIndex > pageCount)
            {
                MessageBox.Show("页码大于总页数!", "错误");
                return;
            }

            AccessDB adb = new AccessDB();
            DataTable dt = adb.ExecutePager(pageIndex, pageSize, keyString, showString, queryString, whereString, orderString, out pageCount, out recordSum);
            dgv.DataSource = dt;
            textBox_page_index.Text = pageIndex.ToString();
            label_current_page.Text = pageIndex.ToString() + "/" + pageCount.ToString();
            label_record_sum.Text = recordSum.ToString();
        }
Exemple #27
0
        /// <summary>
        /// 产品选择下拉列表选择触发事件
        /// 选择后将对应代码产品信息填入货物信息
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void comboBox_Product_SelectedIndexChanged(object sender, EventArgs e)
        {
            KeyValuePair<int, string> kv = (KeyValuePair<int, string>)comboBox_Product.SelectedItem;

            int product_id = kv.Key;
            string sql = "SELECT * FROM OSM_STORAGE WHERE ID = " + product_id;
            AccessDB adb = new AccessDB();
            DataTable dt = adb.SQLTableQuery(sql);
            
            if (dt.Rows.Count == 1)
            {
                DataRow dr = dt.Rows[0];

                textBox_HW_NAME.Text = dr["HW_NAME"].ToString();
                textBox_HW_CODE.Text = dr["HW_CODE"].ToString();

                for (int i = 0; i < comboBox_HW_TYPE.Items.Count; i++)
                {
                    KeyValuePair<string, string> item = (KeyValuePair<string, string>)comboBox_HW_TYPE.Items[i];
                    if (item.Key == dr["HW_TYPE"].ToString())
                    {
                        comboBox_HW_TYPE.SelectedIndex = i;
                        break;
                    }
                }

                hw.setPRODUCT_ID(int.Parse(dr["ID"].ToString()));
            }
        }
Exemple #28
0
        /// <summary>
        /// 尾页按钮点击事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void button_last_page_Click(object sender, EventArgs e)
        {
            pageIndex = pageCount;

            AccessDB adb = new AccessDB();
            DataTable dt = adb.ExecutePager(pageIndex, pageSize, keyString, showString, queryString, whereString, orderString, out pageCount, out recordSum);
            dgv.DataSource = dt;
            textBox_page_index.Text = pageIndex.ToString();
            label_current_page.Text = pageIndex.ToString() + "/" + pageCount.ToString();
            label_record_sum.Text = recordSum.ToString();
        }
        /// <summary>
        /// 检查是否可以发货
        /// </summary>
        /// <param name="order_id"></param>
        private void checkDelivery(string order_id)
        {
            string sql = "select PAY_MODE,PAY_STATE,ALREADY_PAYMENT,PRE_PAYMENT,REQUIRE_PAYMENT from OSM_ORDER_SHEET where ID = " + order_id;

            AccessDB adb = new AccessDB();
            DataTable dt = adb.SQLTableQuery(sql);

            Hashtable hashtable = new Hashtable();

            if (dt.Rows.Count == 1)
            {
                DataRow dr = dt.Rows[0];
                string pay_mode = dr["PAY_MODE"].ToString();
                string pay_state = dr["PAY_STATE"].ToString();
                double already_payment = double.Parse(dr["ALREADY_PAYMENT"].ToString());
                double pre_payment = double.Parse(dr["PRE_PAYMENT"].ToString());
                double require_payment = double.Parse(dr["REQUIRE_PAYMENT"].ToString());
                //hashtable.Add("PAY_MODE", dr["PAY_MODE"]);
                //hashtable.Add("PAY_STATE", dr["PAY_STATE"]);
                //hashtable.Add("ALREADY_PAYMENT", dr["ALREADY_PAYMENT"]);
                //hashtable.Add("PRE_PAYMENT", dr["PRE_PAYMENT"]);
                //hashtable.Add("REQUIRE_PAYMENT", dr["REQUIRE_PAYMENT"]);
                
                switch (pay_mode)
                {
                    case "1":
                        if (pay_state == "2")
                        {
                            orderDeliver(order_id);
                        }
                        else
                        {
                            MessageBox.Show("未付全款,无法发货!", "警告");
                        }
                        break;
                    case "2":
                        if (pay_state == "1")
                        {
                            orderDeliver(order_id);
                        }
                        break;
                    case "3":
                        if (pay_state == "3")
                        {
                            orderDeliver(order_id);
                        }
                        else
                        {
                            MessageBox.Show("未预付部分款,无法发货!", "警告");
                        }
                        break;
                }

                string checkPayListSQL = "select ID from OSM_PAYMENTREMINDER_SHEET where ORDER_ID = " + order_id;
                DataTable dataT = adb.SQLTableQuery(checkPayListSQL);
                if (dataT.Rows.Count == 0)
                {
                    createPaySheet(order_id);
                }
            }
        }
Exemple #30
0
 /// <summary>
 /// 实现数据库插入报价方数据
 /// </summary>
 /// <param name="seller"></param>
 /// <returns></returns>
 private bool addSeller(Seller seller)
 {
     string sql = "insert into OSM_BJF(COM_NAME,ADDR,CONTACT,PHONE,ZIP_CODE,FAX,EMAIL,COMMENT) ";
     sql += " values('" + seller.getCOM_NAME() + "','" + seller.getADDR() + "','";
     sql += seller.getCONTACT() + "','" + seller.getPHONE() + "','" + seller.getZIP_CODE();
     sql += "','" + seller.getFAX() + "','" + seller.getEMAIL() + "','" + seller.getCOMMENT() + "')";
     
     AccessDB adb = new AccessDB();
     bool isExecuteSucc = adb.SQLExecute(sql);
     if (isExecuteSucc)
     {
         MessageBox.Show("添加成功!", "消息");
     }
     else
     {
         MessageBox.Show("添加失败!", "消息");
     }
     return isExecuteSucc;
 }
        /// <summary>
        /// 生成收款单
        /// </summary>
        /// <param name="order_id">订单ID</param>
        private void createPaySheet(string order_id)
        {
            AccessDB adb = new AccessDB();

            string payListSQL = "insert into OSM_PAYMENTREMINDER_SHEET(ORDER_ID,GEN_DATE) values (" + order_id + ",#" + DateTime.Now.ToString("yyyy-MM-dd") + "#)";

            if (adb.SQLExecute(payListSQL))
            {
                MessageBox.Show("已生成对应收款单!", "消息");
            }
            else
            {
                MessageBox.Show("生成收款单遇到错误!", "错误");
            }
        }
Exemple #32
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;
        }