/// <summary>
/// 界面显示初始化
/// </summary>
private void InitializeDataSet()
{
this.dataGridView1.AutoGenerateColumns = true;
this.dataGridView2.AutoGenerateColumns = true;
this.dataGridView3.AutoGenerateColumns = true;
this.dataGridView4.AutoGenerateColumns = true;
this.dataGridView5.AutoGenerateColumns = true;
this.dataGridView6.AutoGenerateColumns = true;
this.dataGridView7.AutoGenerateColumns = true;
SPds = SupplierAccess.Select();
DTds = DistributorAccess.Select();
ACds = AdminAccess.ShowSupperUser();
RLds = RoleAccess.ShowRole();
ASds = ApplySceneryAccess.selectForApply();
RPds = RoleProductAccess.ShowRoleProduct();
SYds = SceneryAccess.ShowSceneryForSupper();
if (SPds != null)
{
dataGridView1.DataSource = SPds.Tables[0];
}
if (DTds != null)
{
dataGridView2.DataSource = DTds.Tables[0];
}
if (RLds != null)
{
dataGridView3.DataSource = RLds.Tables[0];
}
if (ACds != null)
{
dataGridView4.DataSource = ACds.Tables[0];
}
if (RPds != null)
{
dataGridView5.DataSource = RPds.Tables[0];
}
if (ASds != null)
{
dataGridView6.DataSource = ASds.Tables[0];
}
if (SYds != null)
{
dataGridView7.DataSource = SYds.Tables[0];
}
}
/// <summary>
/// 检查邮箱
/// </summary>
/// <param name="account"></param>
/// <param name="password"></param>
/// <returns></returns>
public Admin CheckEmail(string adminAccount, string adminEmail)
{
if (string.IsNullOrEmpty(adminAccount))
{
return(null);
}
try
{
string sqlWhere = string.Format(" and adminAccount ='{0}' and adminEmail='{1}'", adminAccount, adminEmail);
List <Admin> list = AdminAccess.SelectEmail(sqlWhere);
if (list != null && list.Count == 1)
{
return(list[0]);
}
return(null);
}
catch (Exception ex)
{
return(null);
}
}
/// <summary>
/// 管理员登录：输入账号密码，如果登录成功返回当前账号对象，否则返回NULL
/// </summary>
/// <param name="account"></param>
/// <param name="password"></param>
/// <returns></returns>
public Admin Login(string account, string password)
{
if (string.IsNullOrEmpty(account))
{
return(null);
}
try
{
string sqlWhere = string.Format(" and adminAccount ='{0}' and adminPwd='{1}'", account, password);
List <Admin> list = AdminAccess.Select(sqlWhere);
if (list != null && list.Count == 1)
{
return(list[0]);
}
return(null);
}
catch (Exception ex)
{
return(null);
}
}
private void btn_start_Click(object sender, EventArgs e)
{
if (cbo_event_type.Text != "Choose Event")
{
AdminAccess acc = new AdminAccess();
acc.ShowDialog();
user_access = AdminAccess.discount_access_value;
if (user_access == true)
{
cbo_event_type.Enabled = false;
event_status = true;
btn_start.Enabled = false;
btn_stop.Enabled = true;
txt_card_no.Focus();
// this.ActiveControl = txt_card_no;
}
}
else
{
MessageBox.Show("Please Choose Event.", "Event", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void lbDeleteAdmin_Click(object sender, EventArgs e)
{
if (indexer != -1)
{
DialogResult dr = MessageBox.Show("确定删除？", "确定", MessageBoxButtons.YesNo);
if (dr == DialogResult.Yes)
{
dataGridView4.DataSource = ACds.Tables[0];
bool isSuccess = AdminAccess.DeleteSupperUser(SPId);
if (isSuccess)
{
MessageBox.Show("管理员删除成功");
}
DataSet ds = AdminAccess.ShowSupperUser();
dataGridView3.DataSource = ds.Tables[0];
if (ds != null)
{
this.Refresh();
}
this.Refresh();
}
}
}
public void UpdateUserAdminAccess(Guid userID, AdminAccess access)
{
ExecutePutRequest("user/admin/" + userID + "?access=" + ((int) access),"");
}
public AuthenController(AdminAccess adminAccess, Jwt jwt, IOptions <AppSettings> appSetting)
{
_adminAccess = adminAccess;
_jwtAuthen = jwt;
_appSetting = appSetting.Value;
}
/// <summary>
/// 更新管理员密码
/// </summary>
/// <param name="id"></param>
/// <param name="diary"></param>
/// <returns></returns>
public Boolean UpdateAdminPassword(string adminAccount, string adminPwd)
{
AdminAccess.UpdatePassword(adminAccount, adminPwd);
return(true);
}
/// <summary>
/// 更新管理员信息
/// </summary>
/// <param name="id"></param>
/// <param name="diary"></param>
/// <returns></returns>
public Boolean UpdateAdmin(string adminAccount, Admin admin)
{
AdminAccess.UpdateAdmin(adminAccount, admin);
return(true);
}
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.ColumnIndex == dataGridView1.Columns["col_add"].Index && e.RowIndex >= 0)
{
AdminAccess acc = new AdminAccess();
acc.ShowDialog();
if (acc.DialogResult == DialogResult.OK)
{
Customer_Management.CustomerCard_Info cci = new Customer_Management.CustomerCard_Info(Convert.ToInt32(dataGridView1.CurrentRow.Cells["col_id"].Value.ToString()));
cci.ShowDialog();
}
}
else if (e.ColumnIndex == dataGridView1.Columns["col_replace"].Index && e.RowIndex >= 0)
{
AdminAccess acc = new AdminAccess();
acc.ShowDialog();
panel_replace.Hide();
if (acc.DialogResult == DialogResult.OK)
{
panel_replace.Show();
customer_id = Convert.ToInt32((dataGridView1.CurrentRow.Cells["col_id"].Value.ToString()));
lbl_cardno.Text = Convert.ToString(dataGridView1.CurrentRow.Cells["col_card_no"].Value.ToString());
DataTable dt = customer.GetPreviousBalance(Convert.ToInt32(dataGridView1.CurrentRow.Cells["col_id"].Value.ToString()));
if (dt.Rows.Count > 0)
{
decimal card_balance = Convert.ToDecimal(dt.Rows[0]["customer_balance"].ToString());
lbl_blc.Text = Convert.ToString(card_balance);
}
else
{
lbl_blc.Text = "0.00";
}
}
}
else if (e.ColumnIndex == dataGridView1.Columns["col_cash_back"].Index && e.RowIndex >= 0)
{
CustomerCashBack ccb = new CustomerCashBack(Convert.ToInt32((dataGridView1.CurrentRow.Cells["col_id"].Value.ToString())));
int customer_id = Convert.ToInt32((dataGridView1.CurrentRow.Cells["col_id"].Value.ToString()));
ccb.lbl_customer.Text = dataGridView1.CurrentRow.Cells["col_name"].Value.ToString() + dataGridView1.CurrentRow.Cells["col_last_name"].Value.ToString();
ccb.card_type = dataGridView1.CurrentRow.Cells["col_card_type"].Value.ToString();
ccb.lbl_customer_no.Text = dataGridView1.CurrentRow.Cells["col_card_no"].Value.ToString();
DataTable dt = customer.GetPreviousBalance(Convert.ToInt32(dataGridView1.CurrentRow.Cells["col_id"].Value.ToString()));
if (dt.Rows.Count > 0)
{
decimal card_balance = Convert.ToDecimal(dt.Rows[0]["customer_balance"].ToString());
ccb.lbl_id.Text = dataGridView1.CurrentRow.Cells["col_id"].Value.ToString();
ccb.txt_card_blc.Text = Convert.ToString(card_balance);
ccb.ShowDialog();
if (ccb.btn_save.DialogResult == DialogResult.OK)
{
Loadcustomer();
}
}
else
{
MessageBox.Show("Sorry Customer Have 0.00 Balance.", "Transaction Fail", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
public AdminController(AdminAccess adminAccess, AccountJwt account)
{
_adminAccess = adminAccess;
_account = account;
}
/// <summary>
/// 用户登录：普通用户，管理员，供应商，分销商
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnLogin_Click(object sender, EventArgs e)
{
string userName = this.tbUserName.Text;
string userPassWord = this.tbPassWord.Text;
string Identify = this.tbIdentify1.Text;
string userType = this.comboBox1.Text;
if (userType == "普通用户")
{
if (Identify == tbnIdentify)
{
if (UserAccess.Loin(userName, userPassWord))
{
int USId = UserAccess.Select(userName);
if (USId != 0)
{
this.Visible = false;
Homepage homePage = new Homepage(USId);
homePage.Show();
}
}
else
{
MessageBox.Show("用户名或密码不正确");
}
}
else
{
MessageBox.Show("验证码输入有误！");
}
}
else if (userType == "管理员")
{
if (Identify == tbnIdentify)
{
if (AdminAccess.Loin(userName, userPassWord))
{
int USId = Convert.ToInt32(userName);
if (USId != 0)
{
this.Visible = false;
SupperUser supperUser = new SupperUser(USId);
supperUser.Show();
}
}
else
{
MessageBox.Show("用户名或密码不正确");
}
}
else
{
MessageBox.Show("验证码输入有误！");
}
}
else if (userType == "供应商")
{
if (Identify == tbnIdentify)
{
if (SupplierAccess.Loin(userName, userPassWord))
{
int USId = SupplierAccess.Select(userName);
if (USId != 0)
{
this.Visible = false;
SupplierUser supplierUser = new SupplierUser(USId);
supplierUser.Show();
}
}
else
{
MessageBox.Show("用户名或密码不正确");
}
}
else
{
MessageBox.Show("验证码输入有误！");
}
}
else if (userType == "分销商")
{
if (Identify == tbnIdentify)
{
if (DistributorAccess.Loin(userName, userPassWord))
{
int USId = DistributorAccess.Select(userName);
if (USId != 0)
{
this.Visible = false;
DistributorUser distributorUser = new DistributorUser(USId);
distributorUser.Show();
}
}
else
{
MessageBox.Show("用户名或密码不正确");
}
}
else
{
MessageBox.Show("验证码输入有误！");
}
}
else
{
MessageBox.Show("请选择用户类型");
}
}
public async Task UpdateUserAdminAccess(Guid userID, AdminAccess access)
{
var account = await _userManager.Value.FindByIdAsync(userID.ToString());
if (account == null)
throw new NullReferenceException("User not found.");
account.AdminAccess = access;
await _userManager.Value.UpdateAsync(account);
}
