protected void btn_sure_Click(object sender, EventArgs e) { Staff staff = this.AddStaff(); StaffProvider provider = new StaffProvider(); switch (this.OperationFlag) { case Operation.Add: if (this.IsSame() == 1) { break; } if (provider.Insert(staff)) { this.Alert("添加成功!!!"); this.TextCancel(); } break; case Operation.Update: if (provider.Update(staff)) { this.Alert("修改成功!!!"); this.BindText(); } break; } }
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) { int rowIndex = e.RowIndex; Staff staff = new Staff(); staff.Staffinfo_id = Convert.ToInt32(this.GridView1.DataKeys[rowIndex].Value); StaffProvider provider = new StaffProvider(); if (provider.Delete(staff)) { this.Alert("删除成功!!!"); staff.User_id = user_id; staff.Role_id = role_id; staff.Role_Manage = user_manage; staff.Staffinfo_id = 0; if (this.txt_Position.Text != "") { staff.Staffinfo_Name = "%" + this.txt_Position.Text + "%"; } this.ListPager1.RecordCount = this.ListPager1.RecordCount - 1; this.BindSource(staff); } }
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) { int rowIndex = e.RowIndex; Staff staff = new Staff(); staff.Staffinfo_id = Convert.ToInt32(this.GridView1.DataKeys[rowIndex].Value); StaffProvider provider = new StaffProvider(); if (provider.Delete(staff)) { this.Alert("删除成功!!!"); if (this.txt_Position.Text == "") { this.ListPager1.RecordCount = this.ListPager1.RecordCount - 1; this.BindSource(null); } else { this.ListPager1.RecordCount = this.ListPager1.RecordCount - 1; this.BindSource("%" + this.txt_Position.Text + "%"); } } }
protected void btn_Result_Click(object sender, EventArgs e) { Sale sale = new Sale(); if (user_manage == 0) { sale.Staffinfo_Id = staffinfo_id; } sale.Sale_Id = 0; sale.Year_Month = 0; if (this.txt_Position.Text != "") { sale.Sale_Id = Convert.ToInt32(this.txt_Position.Text); } if (this.txt_Yearmonth.Text != "") { sale.Year_Month = Convert.ToInt32(this.txt_Yearmonth.Text); } if (this.txt_Name.Text != "") { StaffProvider provider1 = new StaffProvider(); sale.Staffinfo_Id = provider1.GetStaffinfoId(this.txt_Name.Text.ToString()); } SaleProvider provider = new SaleProvider(); this.ListPager1.RecordCount = provider.GetSize(); this.BindSource(sale, 0); this.ListPager1.PageChange += new PagerEventHandler(ListPager1_PageChange); }
protected void btn_Result_Click(object sender, EventArgs e) { Staff staff = new Staff(); staff.Staffionfo_position = "%" + this.txt_Position.Text + "%"; StaffProvider provider = new StaffProvider(); this.ListPager1.RecordCount = provider.GetSize(staff); this.BindSource(0, "%" + this.txt_Position.Text + "%"); this.ListPager1.PageChange += new PagerEventHandler(ListPager1_PageChange); }
/// <summary> /// 绑定Staff信息的数据源 /// </summary> private void BindSource(Staff staff, int start) { DataTable table; StaffProvider provider = new StaffProvider(); table = provider.GetRoleAll(staff, start, this.ListPager1.PageSize); this.GridView1.DataSource = table.DefaultView; this.GridView1.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { StaffProvider provider = new StaffProvider(); this.ListPager1.RecordCount = provider.GetSize(); this.BindSource(0, null); } this.account.Text = Session["LOGINED"].ToString(); this.datetime.Text = this.BindDayWeek(); this.ListPager1.PageChange += new PagerEventHandler(ListPager1_PageChange); }
protected void btn_sure_Click(object sender, EventArgs e) { Staff staff = this.AddStaff(); StaffProvider provider = new StaffProvider(); switch (this.OperationFlag) { case Operation.Add: if (this.IsSame() == 1) { break; } if (provider.Insert(staff)) { this.Alert("添加成功!!!"); this.TextCancel(); } break; case Operation.Update: if (!check_pass()) { this.Alert("密码修改格式有问题"); break; } if (provider.Update(staff)) { if (this.txt_NewPassConfirm.Text != "") { UserProvider provider1 = new UserProvider(); if (provider1.UpdatePassWord(Convert.ToInt32(Session["USERID"].ToString()), this.txt_NewPassConfirm.Text.ToString())) { Session["PASSWORD"] = this.txt_NewPassConfirm.Text.ToString(); this.Alert("修改成功!!!"); this.BindText(); break; } } else { this.Alert("修改成功!!!"); this.BindText(); break; } } this.Alert("修改失败!!!!"); this.BindText(); break; } }
private void BindText() { Staff staff = new Staff(); staff.Staffinfo_id = Convert.ToInt32(id); StaffProvider provider = new StaffProvider(); DataTable table = new DataTable(); table = provider.Select(staff); this.txt_staffinfo_position.Text = table.Rows[0]["staffinfo_position"].ToString(); this.txt_staffinfo_num.Text = table.Rows[0]["staffinfo_num"].ToString(); this.txt_staffinfo_cell.Text = table.Rows[0]["staffinfo_cell"].ToString(); this.txt_staffinfo_exp.Text = table.Rows[0]["staffinfo_exp"].ToString(); this.ddl_sex.SelectedValue = table.Rows[0]["staffinfo_sex"].ToString(); }
private void BindText() { Staff staff = new Staff(); staff.Staffinfo_id = Convert.ToInt32(id); StaffProvider provider = new StaffProvider(); DataTable table = new DataTable(); table = provider.Select(staff); this.txt_staffinfo_name.Text = table.Rows[0]["staffinfo_name"].ToString(); this.txt_staffinfo_cell.Text = table.Rows[0]["staffinfo_cell"].ToString(); this.ddl_sex.SelectedValue = table.Rows[0]["staffinfo_sex"].ToString(); this.txt_NewPass.Text = ""; this.txt_NewPassConfirm.Text = ""; this.txt_OldPass.Text = ""; }
protected void btn_Result_Click(object sender, EventArgs e) { Staff staff = new Staff(); staff.User_id = user_id; staff.Role_id = role_id; staff.Role_Manage = user_manage; if (this.txt_Position.Text != "") { staff.Staffinfo_Name = "%" + this.txt_Position.Text + "%"; } staff.Role_id = Convert.ToInt32(Session["ROLEID"].ToString()); StaffProvider provider = new StaffProvider(); this.ListPager1.RecordCount = provider.GetSize(staff); this.BindSource(staff, 0); this.ListPager1.PageChange += new PagerEventHandler(ListPager1_PageChange); }
private int IsSame() { Staff staff = new Staff(); StaffProvider provider = new StaffProvider(); staff.Staffinfo_num = this.txt_staffinfo_num.Text; DataTable table = new DataTable(); table = provider.Select(staff); if (table.Rows.Count != 0) { this.Alert("该员工号已经存在,请重新输入!!!"); return(1); } else { return(0); } }
/// <summary> /// 绑定Staff信息的数据源 /// </summary> private void BindSource(int start, string position) { if (position != null) { Staff staff = new Staff(); staff.Staffionfo_position = position; StaffProvider provider = new StaffProvider(); DataTable table = provider.Select(staff, start, this.ListPager1.PageSize); this.GridView1.DataSource = table.DefaultView; this.GridView1.DataBind(); } else { StaffProvider provider = new StaffProvider(); DataTable table = provider.GetAll(start, this.ListPager1.PageSize); this.GridView1.DataSource = table.DefaultView; this.GridView1.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { if (user_id == 0) { user_id = Convert.ToInt32(Session["USERID"].ToString()); } if (user_manage == 0) { user_manage = Convert.ToInt32(Session["USERMANAGE"].ToString()); } if (staffinfo_id == 0) { StaffProvider provider = new StaffProvider(); staffinfo_id = provider.GetStaffinfoId(user_id); } if (!IsPostBack) { PurchaseProvider provider = new PurchaseProvider(); Purchase purchase = new Purchase(); this.GridView1.DataKeyNames = new string[] { "purchase_id", "staffinfo_id", "supplier_id" }; if (user_manage == 0) { purchase.Staffinfo_Id = staffinfo_id; this.txt_Name.Enabled = false; } this.ListPager1.RecordCount = provider.GetSize(); this.BindSource(purchase, 0); } this.account.Text = GetAccout();// Session["LOGINED"].ToString(); this.datetime.Text = this.BindDayWeek(); this.ListPager1.PageChange += new PagerEventHandler(ListPager1_PageChange); }
public void UnitTest_ValidateAccount_By_EmailAndPassword_Account_Not_Exist() { var dummyData = new List <usp_CheckStaffAccount_Result> { new usp_CheckStaffAccount_Result() { StaffID = 1, FirstName = "ABC", RoleID = 3 } }; var mockedObjectResult = new Mock <ObjectResult <usp_CheckStaffAccount_Result> >(); mockedObjectResult.Setup(x => x.GetEnumerator()).Returns(dummyData.GetEnumerator()); mockUnitOfWork.Setup(x => x.GetDB().usp_CheckStaffAccount("*****@*****.**", "pass")).Returns(mockedObjectResult.Object); StaffProvider provider = new StaffProvider(mockUnitOfWork.Object); var result = provider.ValidateStaffAccount(new Model.LoginDtoModel { Email = "*****@*****.**", Password = "******" }); Assert.IsNull(result); }
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) { int rowIndex = e.RowIndex; Users user = new Users(); user.User_id = Convert.ToInt32(this.GridView1.DataKeys[rowIndex].Value); if (user.User_id == 1) { this.Alert("管理员账号不能删除!!!"); return; } UserProvider provider = new UserProvider(); if (provider.Delete(user)) { StaffProvider provider1 = new StaffProvider(); Staff staff = new Staff(); staff.User_id = user.User_id; if (provider1.Delete(staff)) { this.Alert("删除成功!!!"); if (this.txt_Name.Text == "") { this.ListPager1.RecordCount = this.ListPager1.RecordCount - 1; this.BindSource(null); } else { this.ListPager1.RecordCount = this.ListPager1.RecordCount - 1; this.BindSource("%" + this.txt_Name.Text + "%"); } } } }
public void UnitTest_CreateNewStaff() { var dummyData = new List <usp_GetStaffByEmail_Result> { new usp_GetStaffByEmail_Result() { StaffID = 1, FirstName = "ABC", LastName = "S", Email = "*****@*****.**", RoleID = 3 } }; var mockedObjectResult = new Mock <ObjectResult <usp_GetStaffByEmail_Result> >(); mockedObjectResult.Setup(x => x.GetEnumerator()).Returns(dummyData.GetEnumerator()); mockUnitOfWork.Setup(x => x.GetDB().usp_GetStaffByEmail("*****@*****.**")).Returns(mockedObjectResult.Object); mockUnitOfWork.Setup(x => x.GetDB().usp_InsertSingleStaff("ABC", "S", "*****@*****.**", "pass", 3, DateTime.Now, DateTime.Now)); StaffProvider provider = new StaffProvider(mockUnitOfWork.Object); var m = provider.CreateStaff(new Model.StaffDtoModel { FirstName = "ABC", LastName = "S", Email = "*****@*****.**", Password = "******", Role = 3 }); var result = provider.GetByEmail("*****@*****.**"); Assert.IsNotNull(result); }
protected void Page_Load(object sender, EventArgs e) { role_id = Convert.ToInt32(Session["ROLEID"].ToString()); if (!IsPostBack) { user_manage = Convert.ToInt32(Session["USERMANAGE"].ToString()); user_id = Convert.ToInt32(Session["USERID"].ToString()); Staff staff = new Staff(); if (user_manage == 0) { this.btn_Result.Enabled = false; } staff.User_id = user_id; staff.Role_id = role_id; staff.Role_Manage = user_manage; BoundField sumField = new BoundField(); sumField.DataField = "sum"; if (role_id == 2) { sumField.HeaderText = "采购金额"; } else if (role_id == 3) { sumField.HeaderText = "销售金额"; } else if (role_id == 4) { sumField.HeaderText = "库存总额"; } this.GridView1.Columns.Insert(6, sumField); /* * if (role_id == 4) * { * this.GridView1.Columns.RemoveAt(6); * } */ //this.GridView1.Columns[7].Visible = false; //this.GridView1.Columns[9].Visible = false; StaffProvider provider = new StaffProvider(); this.ListPager1.RecordCount = provider.GetSize(); this.BindSource(staff, 0); if (this.GridView1.Rows.Count > 0) { for (int i = 0; i < this.GridView1.Rows.Count; i++) { if (Convert.ToInt32(this.GridView1.Rows[i].Cells[8].Text.ToString()) != user_id) { this.GridView1.Rows[i].Cells[7].Enabled = false; } } } //this.GridView1.Rows[1].Cells[7].Enabled = false; this.GridView1.Columns[8].Visible = false; } this.account.Text = GetAccout();//Session["LOGINED"].ToString(); this.datetime.Text = this.BindDayWeek(); this.ListPager1.PageChange += new PagerEventHandler(ListPager1_PageChange); }
protected void btn_sure_Click(object sender, EventArgs e) { Users users = this.AddUsers(); UserProvider provider = new UserProvider(); switch (this.OperationFlag) { case Operation.Add: if (users.User_account == "") { this.Alert("²ÎÊý´íÎó£¬ÐÞ¸Äʧ°Ü!!!"); break; } if (this.IsSame() == 1) { break; } if (provider.Insert(users)) { Staff staff = new Staff(); staff = this.AddStaff(users); if (staff.User_id == 0) { provider.Delete(users); this.Alert("user_idΪ0£¬Ìí¼Óʧ°Ü"); } StaffProvider staffProvider = new StaffProvider(); if (staffProvider.Insert(staff)) { this.Alert("Ìí¼Ó³É¹¦!!!"); this.TextCancel(); } else { provider.Delete(users); } } break; case Operation.Update: if (users.User_account == "") { this.Alert("²ÎÊý´íÎó£¬ÐÞ¸Äʧ°Ü!!!"); break; } if (provider.Update(users)) { Staff staff = new Staff(); staff = this.AddStaff(users); if (staff.User_id == 0) { provider.Delete(users); this.Alert("user_idΪ0£¬ÐÞ¸Äʧ°Ü"); } StaffProvider staffProvider = new StaffProvider(); int staffinfo_id = staffProvider.GetStaffinfoId(staff.User_id); if (staffinfo_id == 0) { if (staffProvider.Insert(staff)) { this.Alert("Ð޸ijɹ¦!!!"); } else { this.Alert("ÐÞ¸Äʧ°Ü!!!"); } } else { staff.Staffinfo_id = staffinfo_id; if (staffProvider.Update(staff)) { this.Alert("Ð޸ijɹ¦!!!"); this.BindText(); } else { this.Alert("ÐÞ¸Äʧ°Ü!!!"); } } this.BindText(); } break; } }