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;
}
}
