Ejemplo n.º 1
0
 private void login()
 {
     if (checkLogin())
     {
         AccountInfo view = new AccountInfo(APConfig.Conn);
         view.Conditions = view.getCondition(AccountInfo.ncConditions.ACCOUNT.ToString(), txtLoginAccount.Text);
         if (view.load())
         {
             if (view.ACT_PASSWORD != txtLoginPassword.Text)
             {
                 APConfig.SweetAlert(ShowBoxType.alert, "密碼錯誤!");
             }
             else
             {
                 APConfig.AccountName = view.ACT_NAME;
                 APConfig.SweetAlert(ShowBoxType.alert, string.Format("歡迎使用!\r\n{0}", view.ACT_NAME));
                 this.Hide();
                 Main form = new Main();
                 form.ShowDialog();
                 this.Close();
             }
         }
         else
         {
             APConfig.SweetAlert(ShowBoxType.alert, "查無此帳號!");
         }
     }
 }
Ejemplo n.º 2
0
 private void btnMemberDelete_Click(object sender, EventArgs e)
 {
     try
     {
         if (dgvMember.SelectedRows.Count > 0 && APConfig.SweetAlert(ShowBoxType.confirm, string.Format("是否確定要刪除{0}筆?", dgvMember.SelectedRows.Count)))
         {
             List <string> sernolist    = new List <string>();
             string        delSernoList = "";
             foreach (DataGridViewRow row in dgvMember.SelectedRows)
             {
                 sernolist.Add(string.Format("'{0}'", row.Cells["dgvMember_Serno"].Value.ToString()));
             }
             delSernoList = string.Join(",", sernolist);
             Roster entRoster   = new Roster(APConfig.Conn);
             string sConditions = entRoster.getCondition(Roster.ncConditions.sernolist.ToString(), delSernoList);
             entRoster.deleteAll(sConditions);
             memberLoadData(ddlMemberPage.SelectedIndex + 1);
             APConfig.SweetAlert(ShowBoxType.alert, "刪除完成");
         }
     }
     catch (Exception ex)
     {
         APConfig.SweetAlert(ShowBoxType.alert, string.Format("刪除失敗 {0}", ex.Message));
     }
 }
Ejemplo n.º 3
0
 private void btnClose_Click(object sender, EventArgs e)
 {
     if (APConfig.SweetAlert(ShowBoxType.confirm, "確定要離開嗎?"))
     {
         this.Close();
         Environment.Exit(Environment.ExitCode);
     }
 }
Ejemplo n.º 4
0
 private void btnItemDel_Click(object sender, EventArgs e)
 {
     if (APConfig.SweetAlert(ShowBoxType.confirm, "是否確定要刪除?"))
     {
         foreach (DataGridViewRow row in dgvItem.SelectedRows)
         {
             dgvItem.Rows.RemoveAt(row.Index);
         }
     }
     loadTotalCount();
 }
Ejemplo n.º 5
0
        private bool checkLogin()
        {
            string msg     = "";
            string pattern = @"^[a-zA-Z0-9]+$"; //判斷只有英文數字

            if (!Regex.Match(txtLoginAccount.Text, pattern).Success || !Regex.Match(txtLoginPassword.Text, pattern).Success)
            {
                APConfig.SweetAlert(ShowBoxType.alert, "欄位內容只能包含英文數字!");
                return(false);
            }
            return(true);
        }
Ejemplo n.º 6
0
 private void btnSubmit_Click(object sender, EventArgs e)
 {
     if (string.IsNullOrEmpty(checkSubmit()))
     {
         Account entAccount = new Account(APConfig.Conn);
         entAccount.ACT_SERNO      = My.GenSerNo();
         entAccount.ACT_NAME       = txtName.Text;
         entAccount.ACT_ACCOUNT    = txtAccount.Text;
         entAccount.ACT_PASSWORD   = txtPassword.Text;
         entAccount.ACT_CREATEDTTM = DateTime.Now;
         entAccount.insert();
         APConfig.SweetAlert(ShowBoxType.alert, "新增完成!");
     }
 }
Ejemplo n.º 7
0
 public static ComboBox loadPage(ComboBox c, int maxPage)
 {
     c.Items.Clear();
     for (int i = 1; i <= maxPage; i++)
     {
         c.Items.Add(i.ToString());
     }
     if (c.Items.Count > 0)
     {
         c.SelectedIndex = 0;
     }
     else
     {
         APConfig.SweetAlert(ShowBoxType.alert, "查無資料");
     }
     return(c);
 }
Ejemplo n.º 8
0
        private string checkSubmit()
        {
            string msg     = "";
            string pattern = @"^[a-zA-Z0-9]+$"; //判斷只有英文數字
            bool   isEmpty = false;

            foreach (Control pages in this.Controls)
            {
                if (pages is Panel)
                {
                    Panel panel = pages as Panel;
                    if (panel.Name.ToString() == "panelSubmit")
                    {
                        foreach (Control c in pages.Controls)
                        {
                            if (c is BunifuMetroTextbox)
                            {
                                BunifuMetroTextbox textBox = c as BunifuMetroTextbox;
                                if (textBox.Text == string.Empty)
                                {
                                    msg     = "欄位不能為空值!";
                                    isEmpty = true;
                                }
                                else if (!Regex.Match(textBox.Text, pattern).Success)
                                {
                                    msg     = "欄位內容只能包含英文數字!";
                                    isEmpty = true;
                                }
                            }
                        }
                    }
                }
            }

            if (!isEmpty && txtPassword.Text != txtPassword2.Text)
            {
                msg = "密碼輸入不相同!";
            }

            if (!string.IsNullOrEmpty(msg))
            {
                APConfig.SweetAlert(ShowBoxType.alert, msg);
            }
            return(msg);
        }
Ejemplo n.º 9
0
        private void btnBackUp_Click(object sender, EventArgs e)
        {
            if (APConfig.SweetAlert(ShowBoxType.confirm, "是否確定要備份?"))
            {
                try
                {
                    SqlConnection conn = new SqlConnection(APConfig.Conn.getConnectionString());
                    SqlCommand    cmd  = new SqlCommand(string.Empty, conn);
                    conn.Open();

                    cmd.Parameters.Clear();
                    cmd.CommandType = CommandType.StoredProcedure;
                    cmd.CommandText = "sp_BackupData";

                    SqlParameter result = cmd.Parameters.Add("@result", SqlDbType.Int);
                    result.Direction = ParameterDirection.Output;

                    cmd.ExecuteNonQuery();
                    if (Convert.ToInt32(result.Value) == 1)
                    {
                        APConfig.SweetAlert(ShowBoxType.alert, "備份成功!");
                    }
                    else
                    {
                        APConfig.SweetAlert(ShowBoxType.alert, "備份失敗!");
                    }


                    conn.Close();
                    conn.Dispose();
                }
                catch (Exception ex)
                {
                    APConfig.SweetAlert(ShowBoxType.alert, string.Format("備份失敗!{0}", ex.Message));
                }
            }
        }
Ejemplo n.º 10
0
        private bool checkAdd()
        {
            string msg = "";
            int    n, count = 0;

            string[] condReqName    = { "txtMobile1", "txtMobile2", "txtPhone" }; //判斷欄位三個至少填一個
            string[] condName       = { "txtName", "txtNo" };                     //必填欄位
            string[] condNumberName = { "txtAmount" };                            //判斷數字欄位
            foreach (Control c in this.Controls)
            {
                if (c is BunifuMetroTextbox)
                {
                    BunifuMetroTextbox textBox = c as BunifuMetroTextbox;
                    if (condName.Contains(textBox.Name) && textBox.Text == string.Empty)
                    {
                        msg = "必要欄位不能為空值!";
                    }
                    else if (condReqName.Contains(textBox.Name) && textBox.Text == string.Empty)
                    {
                        count++;
                    }
                    else if (condNumberName.Contains(textBox.Name) && textBox.Text != string.Empty)
                    {
                        if (!int.TryParse(textBox.Text, out n))
                        {
                            msg = "金額欄位請輸入數字";
                        }
                    }
                }
                else if (c is BunifuDropdown)
                {
                    BunifuDropdown dropdown = c as BunifuDropdown;
                    if (dropdown.selectedIndex == -1)
                    {
                        msg = "欄位不能為空值!";
                    }
                }
            }

            if (count == condReqName.Length)
            {
                msg = "電話欄位至少輸入一欄!";
            }
            if (string.IsNullOrEmpty(msg) && mode == mode.Add)
            {
                foreach (DataGridViewRow row in dgvItem.Rows)
                {
                    if (txtNo.Text == row.Cells["dgvItem_No"].Value.ToString())
                    {
                        msg = "該訂單編號已經存在列表中!請重複確認!!";
                        break;
                    }
                }
            }
            if (string.IsNullOrEmpty(msg) && mode == mode.Add)
            {
                RosterInfo vRoster = new RosterInfo(APConfig.Conn);
                vRoster.Conditions = vRoster.getCondition(RosterInfo.ncConditions.no.ToString(), txtNo.Text);
                if (vRoster.calculateCount() > 0)
                {
                    msg = "該訂單編號已經有資料!請重複確認!";
                }
            }

            if (!string.IsNullOrEmpty(msg))
            {
                APConfig.SweetAlert(ShowBoxType.alert, msg);
            }
            return(string.IsNullOrEmpty(msg) ? true : false);
        }
Ejemplo n.º 11
0
 private void btnOK_Click(object sender, EventArgs e)
 {
     if (mode == mode.Add)
     {
         if (dgvItem.Rows.Count == 0)
         {
             this.DialogResult = DialogResult.OK;
             this.Close();
             return;
         }
         int count = 0;
         foreach (DataGridViewRow row in dgvItem.Rows)
         {
             Roster ent = new Roster(APConfig.Conn);
             ent.RST_SERNO        = My.GenSerNo();
             ent.RST_NO           = row.Cells["dgvItem_No"].Value.ToString();
             ent.RST_NAME         = row.Cells["dgvItem_Name"].Value.ToString();
             ent.RST_PHONE        = row.Cells["dgvItem_Phone"].Value.ToString();
             ent.RST_MOBILE1      = row.Cells["dgvItem_Mobile1"].Value.ToString();
             ent.RST_MOBILE2      = row.Cells["dgvItem_Mobile2"].Value.ToString();
             ent.RST_AMOUNT       = Convert.ToInt32(row.Cells["dgvItem_Amount"].Value.ToString());
             ent.RST_ORDERDTTM    = DateTime.Parse(row.Cells["dgvItem_OrderDTTM"].Value.ToString());
             ent.RST_ADDR         = row.Cells["dgvItem_Addr"].Value.ToString();
             ent.RST_COMMENT1     = row.Cells["dgvItem_Comment1"].Value.ToString();
             ent.RST_COMMENT2     = row.Cells["dgvItem_Comment2"].Value.ToString();
             ent.RST_COMMENT3     = row.Cells["dgvItem_Comment3"].Value.ToString();
             ent.RST_INSERTBY     = APConfig.AccountName;
             ent.RST_INSERTDTTM   = DateTime.Now;
             ent.RST_MODIFIEDBY   = APConfig.AccountName;
             ent.RST_MODIFIEDDTTM = DateTime.Now;
             count += ent.insert();
         }
         APConfig.SweetAlert(ShowBoxType.alert, string.Format("訂單登記完成!\r\n新增 {0} 件", count.ToString()));
         this.DialogResult = DialogResult.OK;
         this.Close();
     }
     else if (mode == mode.Edit)
     {
         Roster ent = new Roster(APConfig.Conn);
         ent.RST_SERNO    = serno;
         ent.ModifyFields = string.Format("{0};{1};{2};{3};{4};{5};{6};{7};{8};{9};{10};{11};{12}"
                                          , Roster.ncFields.RST_NO.ToString()
                                          , Roster.ncFields.RST_NAME.ToString()
                                          , Roster.ncFields.RST_PHONE.ToString()
                                          , Roster.ncFields.RST_MOBILE1.ToString()
                                          , Roster.ncFields.RST_MOBILE2.ToString()
                                          , Roster.ncFields.RST_AMOUNT.ToString()
                                          , Roster.ncFields.RST_ORDERDTTM.ToString()
                                          , Roster.ncFields.RST_ADDR.ToString()
                                          , Roster.ncFields.RST_COMMENT1.ToString()
                                          , Roster.ncFields.RST_COMMENT2.ToString()
                                          , Roster.ncFields.RST_COMMENT3.ToString()
                                          , Roster.ncFields.RST_MODIFIEDBY.ToString()
                                          , Roster.ncFields.RST_MODIFIEDDTTM.ToString());
         ent.RST_NO           = txtNo.Text;
         ent.RST_NAME         = txtName.Text;
         ent.RST_PHONE        = txtPhone.Text;
         ent.RST_MOBILE1      = txtMobile1.Text;
         ent.RST_MOBILE2      = txtMobile2.Text;
         ent.RST_AMOUNT       = Convert.ToInt32(txtAmount.Text);
         ent.RST_ORDERDTTM    = DateTime.Parse(dpkOrderDTTM.Value.ToString());
         ent.RST_ADDR         = txtAddr.Text;
         ent.RST_COMMENT1     = txtComment1.Text;
         ent.RST_COMMENT2     = txtComment2.Text;
         ent.RST_COMMENT3     = txtComment3.Text;
         ent.RST_MODIFIEDBY   = APConfig.AccountName;
         ent.RST_MODIFIEDDTTM = DateTime.Now;
         ent.update();
         APConfig.SweetAlert(ShowBoxType.alert, "修改完成");
         this.DialogResult = DialogResult.OK;
         this.Close();
     }
     else if (mode == mode.View)
     {
         this.DialogResult = DialogResult.OK;
         this.Close();
     }
     else
     {
         return;
     }
 }