protected void Button1_Click(object sender, EventArgs e)
{
if (username.Text != "" && pwd.Text != "")
{
string name = username.Text;
string passwd = pwd.Text;
QueryEmployee query = new QueryEmployee();
query.Ename = name;
SqlDataReader dataReader = employeeDao.Query(query).DataReader;
while (dataReader.Read())
{
string pwd = dataReader["password"].ToString();
string status = dataReader["status"].ToString();
string eid = dataReader["eid"].ToString();
if (pwd.Equals(passwd))
{
dataReader.Close();
msg.Text = "登录成功！";
HttpContext.Current.Session["name"] = name;
HttpContext.Current.Session["eid"] = eid;
HttpContext.Current.Session["status"] = status;
HttpContext.Current.Session["pwd"] = pwd;
Response.Redirect("index.aspx?name=" + name + "&status=" + status);
}
}
dataReader.Close();
}
msg.Text = "用户名或密码错误！";
}
public GeneralResponse EditQueryEmployee(EditQueryEmployeeRequest request)
{
GeneralResponse response = new GeneralResponse();
QueryEmployee queryEmployee = new QueryEmployee();
queryEmployee = _queryEmployeeRepository.FindBy(request.ID);
if (queryEmployee != null)
{
try
{
queryEmployee.ModifiedDate = PersianDateTime.Now;
queryEmployee.ModifiedEmployee = _employeeRepository.FindBy(request.ModifiedEmployeeID);
if (request.EmployeeID != null)
{
queryEmployee.Employee = this._employeeRepository.FindBy(request.EmployeeID);
}
if (request.QueryID != null)
{
queryEmployee.Query = this._queryRepository.FindBy(request.QueryID);
}
if (queryEmployee.RowVersion != request.RowVersion)
{
response.ErrorMessages.Add("EditConcurrencyKey");
return(response);
}
else
{
queryEmployee.RowVersion += 1;
}
if (queryEmployee.GetBrokenRules().Count() > 0)
{
foreach (BusinessRule businessRule in queryEmployee.GetBrokenRules())
{
response.ErrorMessages.Add(businessRule.Rule);
}
return(response);
}
_queryEmployeeRepository.Save(queryEmployee);
_uow.Commit();
////response.success = true;
}
catch (Exception ex)
{
response.ErrorMessages.Add(ex.Message);
}
}
else
{
response.ErrorMessages.Add("NoItemToEditKey");
}
return(response);
}
public virtual bool CanView(Query query)
{
QueryEmployee queryEmployee = new QueryEmployee();
queryEmployee.Query = query;
queryEmployee.Employee = this;
return(QueriesThisEmployeeCanSee.Contains(queryEmployee));
}
private void buttonEnter_Click(object sender, EventArgs e)
{
QueryEmployee pr = new QueryEmployee();
Employee currentEmployee = pr.queryGetUserByCredentials(textBoxLogin.Text, textBoxPassword.Text)[0];
LoginInfo.UserID = currentEmployee.Id;
LoginInfo.Position = currentEmployee.PositionId;
this.Visible = false;
MainForm f = new MainForm();
f.ShowDialog();
this.Dispose();
}
public GetQueryEmployeeResponse GetQueryEmployee(GetRequest request)
{
GetQueryEmployeeResponse response = new GetQueryEmployeeResponse();
try
{
QueryEmployee queryEmployee = new QueryEmployee();
QueryEmployeeView queryEmployeeView = queryEmployee.ConvertToQueryEmployeeView();
queryEmployee = _queryEmployeeRepository.FindBy(request.ID);
if (queryEmployee != null)
{
queryEmployeeView = queryEmployee.ConvertToQueryEmployeeView();
}
response.QueryEmployeeView = queryEmployeeView;
}
catch (Exception ex)
{
}
return(response);
}
public GeneralResponse AddQueryEmployee(AddQueryEmployeeRequestOld request)
{
GeneralResponse response = new GeneralResponse();
try
{
QueryEmployee queryEmployee = new QueryEmployee();
queryEmployee.CreateEmployee = _employeeRepository.FindBy(request.CreateEmployeeID);
queryEmployee.Employee = this._employeeRepository.FindBy(request.EmployeeID);
queryEmployee.Query = this._queryRepository.FindBy(request.QueryID);
#region Validation
if (queryEmployee.GetBrokenRules().Count() > 0)
{
foreach (BusinessRule businessRule in queryEmployee.GetBrokenRules())
{
response.ErrorMessages.Add(businessRule.Rule);
}
return(response);
}
#endregion
_queryEmployeeRepository.Add(queryEmployee);
_uow.Commit();
////response.success = true;
}
catch (Exception ex)
{
response.ErrorMessages.Add(ex.Message);
}
return(response);
}
public static QueryEmployeeView ConvertToQueryEmployeeView(this QueryEmployee queryEmployee)
{
return(Mapper.Map <QueryEmployee, QueryEmployeeView>(queryEmployee));
}
public EmployeesListForm()
{
InitializeComponent();
queryEmpl = new QueryEmployee();
this.Text = Properties.Resources.Employees;
labelSearch.Text = Properties.Resources.Search;
labelGroup.Text = Properties.Resources.Group;
buttonCreate.Text = Properties.Resources.Create;
buttonEdit.Text = Properties.Resources.Edit;
button1.Text = Properties.Resources.Delete;
button2.Text = Properties.Resources.Refresh;
searchLastNameBox.Text = Properties.Resources.Surname;
searchFirstNameBox.Text = Properties.Resources.Name;
searchMiddleNameBox.Text = Properties.Resources.Patronymic;
buttonSearch.Text = Properties.Resources.Search;
dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
dataGridView1.ReadOnly = true;
dataGridView1.AllowUserToAddRows = false;
dataGridView1.RowHeadersVisible = false;
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
dataGridView1.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.AllCells;
dataGridView1.ScrollBars = ScrollBars.Both;
DataGridViewTextBoxColumn col00 = new DataGridViewTextBoxColumn();
col00.HeaderText = Properties.Resources.ID;
DataGridViewTextBoxColumn col0 = new DataGridViewTextBoxColumn();
col0.HeaderText = Properties.Resources.Surname;
DataGridViewTextBoxColumn col1 = new DataGridViewTextBoxColumn();
col1.HeaderText = Properties.Resources.Name;
DataGridViewTextBoxColumn col2 = new DataGridViewTextBoxColumn();
col2.HeaderText = Properties.Resources.Patronymic;
DataGridViewTextBoxColumn col3 = new DataGridViewTextBoxColumn();
col3.HeaderText = Properties.Resources.Login;
DataGridViewTextBoxColumn col4 = new DataGridViewTextBoxColumn();
col4.HeaderText = Properties.Resources.Password;
DataGridViewTextBoxColumn col5 = new DataGridViewTextBoxColumn();
col5.HeaderText = Properties.Resources.Group;
DataGridViewTextBoxColumn col6 = new DataGridViewTextBoxColumn();
col6.HeaderText = "";
dataGridView1.Columns.Add(col00);
dataGridView1.Columns.Add(col0);
dataGridView1.Columns.Add(col1);
dataGridView1.Columns.Add(col2);
dataGridView1.Columns.Add(col3);
dataGridView1.Columns.Add(col4);
dataGridView1.Columns.Add(col5);
dataGridView1.Columns.Add(col6);
dataGridView1.Columns[7].Visible = false;
addGridView(queryEmpl.querySelectEmployees());
List <ObjectComboBox> lObj = new List <ObjectComboBox>();
lObj.Add(new ObjectComboBox(0, Properties.Resources.All));
foreach (var item in queryEmpl.querySelectPositions())
{
lObj.Add(new ObjectComboBox(item.Id, item.Name));
}
comboBoxGroups.DataSource = lObj;
comboBoxGroups.ValueMember = "Id";
comboBoxGroups.DisplayMember = "Name";
}
