예제 #1
0
        /*--- 視窗拖移功能 ---*/
        private void formBar_MouseDown(object sender, MouseEventArgs e)
        {
            FormFunction.FormMobileFunction(this.Handle);

            //重新取得主視窗位置
            mainFormLocation = this.Location;
        }
예제 #2
0
        /// <summary>
        /// Klasskonstruktor. Skapar formulär i enlighet med vald funktion
        /// </summary>
        /// <param name="product">Vilken produkt som ska visas i formuläret</param>
        /// <param name="formFunction">Vilken funktion formuläret ska anta.</param>
        /// <param name="maxQty">Maxantal av en produkt</param>
        public ProductForm(Product product, FormFunction formFunction, uint maxQty = 1000000)
        {
            InitializeComponent();

            StockMaxQty = maxQty;
            Function    = formFunction;

            switch (formFunction)
            {
            case FormFunction.AddToBasket:
                FormsProduct = new Product(product);
                AddToBasketForm();
                break;

            case FormFunction.NewProduct:
                FormsProduct = product;
                NewProduct();
                break;

            case FormFunction.ShoppingList:
                FormsProduct = new Product(product);
                ShoppingList();
                break;

            default:
                break;
            }
        }
예제 #3
0
        /*--- 建立新的問事表 ---*/
        private void btnCreate_Click(object sender, EventArgs e)
        {
            string strPlace = btnSelectPlace.Text;

            if (strPlace == "選擇地點")
            {
                lblPlaceMsg.Visible = true; //顯示『必須選擇地點』
                return;
            }


            string strDate   = todayDate.Value.ToString("yyyyMMdd");
            string tableName = strDate + strPlace; //建立問事表名稱

            /*-- 確認資料庫中是否存在相同問事表 --*/
            if (CheckTabelIsExist(tableName))
            {
                FormFunction form = new FormFunction();
                form.OpenFocusForm(new Message.WarningForm("資料表已經存在"));
            }
            else
            {
                askingTable.date      = todayDate.Value; //設定建表日期
                askingTable.placeName = strPlace;        //設定建表地點
                askingTable.CreateLabelandTable(tableName, false);
                this.Close();                            // 關閉 NewTableForm
                askingTable.formFun.CloseMenu();         // 關閉HomeForm
            }
        }
예제 #4
0
        private void WhichOneToSearchForm_Load(object sender, EventArgs e)
        {
            //視窗開啟位置
            FormFunction.SetFormLocation(this);

            for (int index = 0; index < count; index++)
            {
                personalInfoView.Rows.Add(listInfo[index][1], listInfo[index][3], listInfo[index][2]);
            }

            personalInfoView.ClearSelection(); //清除資料列預選
        }
        /*--- 指定查詢的問事表 ---*/
        private void btnSearch_Click(object sender, EventArgs e)
        {
            string content = txtInput.Text.Trim(); //取得去頭尾空白的輸入內容

            if (content == "" || content == "輸入關鍵字")
            {
                FormFunction formFun = new FormFunction();
                inWarningMsg.Visible = true; //顯示『必須輸入內容,才能做查詢』
                return;
            }

            DateTime date;

            using (SqlConnection cn = new SqlConnection(Properties.Settings.Default.connectStr))
            {
                string sqlStr = "select Asking_Tables.問事表名稱, Asking_Tables.問事日期, Asking_Place.地點名稱 " +
                                "from Asking_Tables " +
                                "inner join Asking_Place " +
                                "on Asking_Tables.地點編號=Asking_Place.地點編號 " +
                                "where Asking_Tables.問事表名稱 like N\'%" + content + "%\'";

                SqlCommand cmd = new SqlCommand(sqlStr, cn);
                cn.Open();
                SqlDataReader dr = cmd.ExecuteReader();

                /*-- 是否有符合的資料存在 --*/
                if (dr.HasRows)
                {
                    tablesView.Rows.Clear(); //清空檢視表的資料

                    while (dr.Read())
                    {
                        date = Convert.ToDateTime(dr["問事日期"]);
                        string dateStr = date.ToString("yyyy年 MM月 dd日");
                        tablesView.Rows.Add(dr["問事表名稱"], dateStr, dr["地點名稱"]);
                    }

                    tablesView.Focus();
                }
                else
                {
                    dr.Close();
                    FormFunction formFun = new FormFunction();
                    formFun.OpenFocusForm(new WarningForm("查無所輸入的內容"));
                    tablesView.Focus();
                    return;
                }
            }

            tablesView.ClearSelection(); //清除預選
        }
        /*--- 只能輸入字母、數字、控制鍵、空白鍵 ---*/
        private void txtInput_KeyPress(object sender, KeyPressEventArgs e)
        {
            inWarningMsg.Visible = false; //隱藏『必須輸入內容,才能做查詢』

            if (Char.IsLetterOrDigit(e.KeyChar) || Char.IsControl(e.KeyChar) || Char.IsWhiteSpace(e.KeyChar))
            {
                e.Handled = false;
            }
            else
            {
                FormFunction formFun = new FormFunction();
                formFun.OpenFocusForm(new WarningForm("只能輸入\"字母\"或\"數字\""));
                e.Handled = true;
            }
        }
 private void NewPersonalInfoForm_Load(object sender, EventArgs e)
 {
     /*--- 視窗開啟位置 ----------------
      *
      *- if: 位置與 SignUpForm 相同
      *-------------------------------*/
     if (isFromTableForm == true)
     {
         FormFunction.FormLocationWithParent(this, parentForm);
         parentForm.Visible = false; //隱藏 SignUpForm
     }
     else
     {
         FormFunction.SetFormLocation(this);
     }
 }
        /*--- 刪除整個問事表(包含問事紀錄) ---*/
        private void btnDelete_Click(object sender, EventArgs e)
        {
            /*- 確認是否要刪除 -*/
            Message.ConfirmForm confirm = new Message.ConfirmForm("該表的全部問事紀錄也會一並刪除哦");
            FormFunction        form    = new FormFunction();

            form.OpenFocusForm(confirm);

            /*- 確認要刪除 -*/
            if (confirm.isOk)
            {
                isDeleted = true;
                DeleteAllAskingHistories(formTitle.Text); //刪除全部紀錄
                DeleteAskingTable(formTitle.Text);        //刪除問事表
                this.Close();
            }
        }
        /*------ DataGridView 『tableView』
         *-『tablesView_CellClic』:點擊該行資料,開啟編輯工具
         *-『tablesView_ColumnHeaderMouseClick』:點擊標題欄時,不選資料列
         *-----------------------------------------------------------------*/
        private void tablesView_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            int rowIndex = e.RowIndex;

            if (rowIndex >= 0)
            {
                string           tableName  = tablesView.Rows[rowIndex].Cells[0].Value.ToString();
                FormFunction     formFun    = new FormFunction();
                BrowseTablesEdit tablesEdit = new BrowseTablesEdit(askingTable, tableName);
                formFun.OpenFocusForm(tablesEdit);

                /*- 刪除問事表及其內容後,更新畫面顯示 -*/
                if (tablesEdit.isDeleted)
                {
                    ShowAllTables();
                }
            }
        }
예제 #10
0
        private void NewTableForm_Load(object sender, EventArgs e)
        {
            FormFunction.SetFormLocation(this);

            /*--- 設定元件的Radius ---*/
            rt.SetControlRadius(btnSelectPlace, 16);

            /*--- 建立 PlaceList ---*/
            CreatePlaceList();

            /*--- 從資料庫撈出『地點名稱』,並加到 ListBox『placeList』中 ---*/
            using (SqlConnection cn = new SqlConnection(Properties.Settings.Default.connectStr))
            {
                string     sqlStr = "select 地點名稱 from Asking_Place";
                SqlCommand cmd    = new SqlCommand(sqlStr, cn);
                cn.Open();
                SqlDataReader dr = cmd.ExecuteReader();

                while (dr.Read())
                {
                    dataCount++; //幾筆資料
                    placeList.Items.Add(dr["地點名稱"]);
                }
                dr.Close();
            }

            /*--- 動態繪製 placeList的高度 ---*/
            if (dataCount > 6)
            {
                placeList.Size = new Size(135, 26 * 6);
            }
            else
            {
                placeList.Size = new Size(135, 26 * dataCount);
            }

            rt.SetControlRadius(placeList, 16);
        }
예제 #11
0
        /*--- 更新資料庫資料
         *- 說明: 會依每個資料有無更動來做更新
         *--------------------------------------------*/
        private void UpdateDBData()
        {
            using (SqlConnection cn = new SqlConnection(Properties.Settings.Default.connectStr))
            {
                cn.Open();
                SqlCommand cmd;

                /*- 更新『姓名』-*/
                if (nonSame_Name)
                {
                    string sqlStr = "update Personal_Info set 姓名 = @name " +
                                    "where 聯絡編號 = @number";


                    cmd = new SqlCommand(sqlStr, cn);
                    cmd.Parameters.Add(new SqlParameter("@name", SqlDbType.NVarChar));
                    cmd.Parameters.Add(new SqlParameter("@number", SqlDbType.Char));
                    cmd.Parameters["@name"].Value   = newName;
                    cmd.Parameters["@number"].Value = contactNum;
                    cmd.ExecuteNonQuery();
                }

                /*- 更新『聯絡電話』-*/
                if (nonSame_PhomeNum)
                {
                    string sqlStr = "update Personal_Info set 聯絡電話=@phoneNum " +
                                    "where 聯絡編號 = @number";

                    cmd = new SqlCommand(sqlStr, cn);
                    cmd.Parameters.Add(new SqlParameter("@phoneNum", SqlDbType.NVarChar));
                    cmd.Parameters.Add(new SqlParameter("@number", SqlDbType.Char));
                    cmd.Parameters["@phoneNum"].Value = newPhoneNum;
                    cmd.Parameters["@number"].Value   = contactNum;
                    cmd.ExecuteNonQuery();
                }

                /*- 更新『居住地』-*/
                if (nonSame_LivePlace)
                {
                    string sqlStr = "update Personal_Info set 居住地=@livePlace " +
                                    "where 聯絡編號 = @number";

                    cmd = new SqlCommand(sqlStr, cn);
                    cmd.Parameters.Add(new SqlParameter("@livePlace", SqlDbType.NVarChar));
                    cmd.Parameters.Add(new SqlParameter("@number", SqlDbType.Char));
                    cmd.Parameters["@livePlace"].Value = newLivePlace;
                    cmd.Parameters["@number"].Value    = contactNum;
                    cmd.ExecuteNonQuery();
                }

                /*- 更新『備註』-*/
                if (nonSame_Rematks)
                {
                    string sqlStr = "update Personal_Info set 備註=@remarks " +
                                    "where 聯絡編號 = @number";

                    cmd = new SqlCommand(sqlStr, cn);
                    cmd.Parameters.Add(new SqlParameter("@remarks", SqlDbType.NVarChar));
                    cmd.Parameters.Add(new SqlParameter("@number", SqlDbType.Char));
                    cmd.Parameters["@remarks"].Value = newRemarks;
                    cmd.Parameters["@number"].Value  = contactNum;
                    cmd.ExecuteNonQuery();
                }
            }

            FormFunction form = new FormFunction();

            form.OpenFocusForm(new Message.SuccessForm("聯絡資料更新完成"));
        }
예제 #12
0
 private void PersonalHistoriesForm_Load(object sender, EventArgs e)
 {
     FormFunction.SetFormLocation(this);
     ShowAllAskingLog(contactNum);
 }
예제 #13
0
 private void Window_MouseDown(object sender, MouseButtonEventArgs e)
 {
     FormFunction.MoveForm(sender, e, this);
 }
예제 #14
0
 public void Exit(object sender, RoutedEventArgs e)
 {
     FormFunction.Exit();
 }
예제 #15
0
 private void OldPersonForm_Load(object sender, EventArgs e)
 {
     FormFunction.FormLocationWithParent(this, parentForm);
     parentForm.Visible = false; //隱藏SignUpForm (報名視窗)
 }
예제 #16
0
        /*--- 修改 ---*/
        private void btnComplete_Click(object sender, EventArgs e)
        {
            btnComplete.Focus(); //修改按鈕取得焦點
            FormFunction form = new FormFunction();

            Message.ConfirmForm confirmForm = new Message.ConfirmForm("是否確認要修改??");
            form.OpenFocusForm(confirmForm);

            /*-- 取消修改 --*/
            if (!confirmForm.isOk)
            {
                return;
            }

            /*-- 輸入的內容 --*/
            newName      = txtInName.Text.Trim();
            newPhoneNum  = txtPhone.Text.Trim();
            newLivePlace = txtLivePlace.Text.Trim();
            newRemarks   = txtRemarks.Text.Trim();

            /*-- 姓名或居住地不能為空,否則不進行修改 --*/
            if (newName == "" || newLivePlace == "")
            {
                if (newName == "")
                {
                    msgName.Visible = true;
                }
                if (newLivePlace == "")
                {
                    msgPlace.Visible = true;
                }

                return;
            }

            /*-- 資料內容是否有更動
             *- if: 無更動,不須更新資料庫
             *- else: 有更動,須更新資料庫
             *-----------------------------------*/
            if (oldName == newName && oldPhoneNum == newPhoneNum && oldLivePlace == newLivePlace && oldRemarks == newRemarks)
            {
                form.OpenFocusForm(new Message.InfoForm("無任何內容更動"));
            }
            else
            {
                /*- 判斷哪個資料內容有更動
                 *第1個if :姓名
                 *第2個if :聯絡電話
                 *第3個if :居住地
                 *第4個if :備註
                 *---------------------------*/
                if (oldName != newName)
                {
                    nonSame_Name = true; //有更動 }
                }
                if (oldPhoneNum != newPhoneNum)
                {
                    nonSame_PhomeNum = true;
                }
                if (oldLivePlace != newLivePlace)
                {
                    nonSame_LivePlace = true;
                }
                if (oldRemarks != newRemarks)
                {
                    nonSame_Rematks = true;
                }

                UpdateDBData(); //更新資料庫資料
            }

            this.Close();
            form.OpenToolForm(new PersonalInfoForm(parentForm, parentPan, formTitle, contactNum), parentPan);
        }
 private void AddAskingPlaceForm_Load(object sender, EventArgs e)
 {
     FormFunction.SetFormLocation(this);
 }
 private void ModifyPlaceNameForm_Load(object sender, EventArgs e)
 {
     FormFunction.SetFormLocation(this, 350, 42);
     lblOldName.Text = oldPlaceName;
 }
 private void PersonalSignUpInfo_Load(object sender, EventArgs e)
 {
     FormFunction.SetFormLocation(this, 200, 10);
 }
 private void EditAskingPlaceForm_Load(object sender, EventArgs e)
 {
     FormFunction.SetFormLocation(this);
     ShowAllPlace();
 }
예제 #21
0
 private void SignUpForm_Load(object sender, EventArgs e)
 {
     FormFunction.SetFormLocation(this);
 }
예제 #22
0
 private void AddAskingContentForm_Load(object sender, EventArgs e)
 {
     /*- 視窗開啟位置 -*/
     FormFunction.SetFormLocation(this, 200, 5);
 }
예제 #23
0
 /*--- 視窗拖移功能 ---*/
 private void formBar_MouseDown(object sender, MouseEventArgs e)
 {
     FormFunction.FormMobileFunction(this.Handle);
 }
 /*--- 設定視窗開啟位置 ---*/
 private void PersonalContactInfoForm_Load(object sender, EventArgs e)
 {
     FormFunction.SetFormLocation(this, parentForm, 25, 120);
 }