/// <summary>
        /// 新增
        /// </summary>
        public bool Insert(EmailBccAccountEntity model)
        {
            Dictionary <string, object> dic = new Dictionary <string, object>();

            dic["EmailBccAccountAddress"]      = model.EmailBccAccountAddress;
            dic["EmailBccAccountName"]         = model.EmailBccAccountName;
            dic["EmailBccAccountCategoryID"]   = model.EmailBccAccountCategoryID;
            dic["EmailBccAccountCategoryName"] = model.EmailBccAccountCategoryName;
            return(SQLHelperFactory.Instance.ExecuteNonQuery("Insert_emailbccaccount", dic) > 0);
        }
Beispiel #2
0
        private void BtnOK_Click(object sender, RoutedEventArgs e)
        {
            if (string.IsNullOrWhiteSpace(tbAddress.Text.Trim()))
            {
                "請填寫完整再提交".ShowDialog();
                return;
            }
            var category = this.cbCategory.SelectedItem as EmailBccAccountCategoryEntity;
            var entity   = EBA_Repository.GetByAddress(tbAddress.Text.Trim());

            if (this.EmailBccAccountID == -1 && entity != null)
            {
                "郵箱已存在,請不要重複添加".ShowDialog();
                return;
            }
            if (this.EmailBccAccountID != -1 && entity != null && this.EmailBccAccountID != entity.EmailBccAccountID)
            {
                "郵箱已存在".ShowDialog();
                return;
            }
            if (this.EmailBccAccountID == -1)
            {
                entity = new EmailBccAccountEntity
                {
                    EmailBccAccountAddress      = tbAddress.Text.Trim(),
                    EmailBccAccountName         = tbAddress.Text.Trim(),
                    EmailBccAccountCategoryID   = category.ID,
                    EmailBccAccountCategoryName = category.Name
                };
                EBA_Repository.Insert(entity);
            }
            else
            {
                entity = EBA_Repository.Get(this.EmailBccAccountID);
                entity.EmailBccAccountAddress      = tbAddress.Text.Trim();
                entity.EmailBccAccountName         = tbAddress.Text.Trim();
                entity.EmailBccAccountCategoryID   = category.ID;
                entity.EmailBccAccountCategoryName = category.Name;
                EBA_Repository.Update(entity);
            }
            "成功".ShowDialog();
            this.DialogResult = true;
            this.Close();
        }