public ActionResult Remove(int workerId)
{
try
{
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required))
{
WorkerEntity worker = WorkerRepository.Instance.GetById(workerId);
worker.Status = GenericStatus.INACTIVE;
WorkerRepository.Instance.UpdateWorker(worker);
//WorkerRepository.Instance.RemoveWorker(worker.Id);
//AccountRepository.Instance.RemoveAccount(worker.UserId);
//PlayerEngineService.Instance.DeleteById(worker.ExternalId);
PlayerEngineDTO player = PlayerEngineService.Instance.GetById(worker.ExternalId);
player.Active = false;
PlayerEngineService.Instance.CreateOrUpdate(player);
scope.Complete();
}
}
catch (Exception e)
{
Error("Ocorreu um erro ao remover.");
}
ViewBag.NumberOfWorkers = WorkerRepository.Instance.GetCountFromFirm(CurrentFirm.Id);
return(View("Index"));
}
public bool UpdateInfo(WorkerEntity obj, string jobnumber)
{
con = Connectionsql.Connection();
bool term = SelectMysql.result("update tb_zhigong set Password='******'," +
"Name='" + obj.Name + "',Shenfenzhenghao='" + obj.Idnumber + "',Sex='" + obj.Sex + "',Address=" +
"'" + obj.Address + "',Phone='" + obj.Phone + "'" +
",Birth='" + obj.Birth + "',Ruyongriqi='" + obj.Hiredate + "'where Gonghao='" + jobnumber + "'");
try
{
if (term == true)
{
return(term);
}
}
catch (MySqlException e)
{
MessageBox.Show(e.Message, "提示", MessageBoxButtons.OK);
}
finally
{
con.Close();
}
return(term);
}
/// <summary>
/// Maps source entity to target worker
/// </summary>
/// <param name="entity">Source entity</param>
/// <returns>Target worker</returns>
private Worker MapToWorker(WorkerEntity entity)
{
var worker = new Worker(this);
MapToWorker(worker, entity);
return(worker);
}
private void button1_Click(object sender, EventArgs e)
{
string jobnumber = textBox1_GH.Text;
string name = textBox2_Name.Text;
string sex = comboBox1_Sex.Text;
string workunit = comboBox2_GZDW.Text;
string birth = dateTimePicker1.Text;
string password = textBox6_Pass.Text;
string phone = textBox7_Phone.Text;
string address = textBox8_Addr.Text;
string idnumber = textBox9_SFZH.Text;
string hiredate = dateTimePicker2.Text;
WorkerEntity worker = new WorkerEntity(jobnumber, password, name, idnumber, sex, address, workunit, phone, birth, hiredate);
IWorkerManageController manageController = new WorkerManageControllerImpl();
bool term = manageController.InsertWorkerInfo(worker);
if (term == true)
{
WorkerManage form = new WorkerManage();
MessageBox.Show("添加职工信息成功！");
this.DialogResult = DialogResult.OK;
this.Hide();
}
else
{
MessageBox.Show("添加职工信息失败！");
}
}
public void Create(WorkerEntity worker)
{
connection.Open();
MySqlCommand command = new MySqlCommand(addString);
MySqlParameter numberParam = new MySqlParameter("@passport_n", worker.PassportNumber);
MySqlParameter dataParam = new MySqlParameter("@passport_d", worker.PersonalData);
command.Parameters.Add(numberParam);
command.Parameters.Add(dataParam);
command.Connection = connection;
object obj = null;
try
{
obj = command.ExecuteScalar();
}
finally
{
connection.Close();
}
int id = Convert.ToInt32(obj);
worker.PassportNumber = id;
}
public List <WorkerEntity> GetDataFromDB(ProjectAllocationFramework.Statues.ProgressChangedEventHandler OnProgress, WorkerSearchCondtion searchCondition = null)
{
List <WorkerEntity> entityList = new List <WorkerEntity>();
string sql = "select WorkerCode, WorkerName FROM [Worker] WHERE 1=1 and WorkerCode like @WorkerCode and WorkerName like @WorkerName ORDER BY WorkerCode";
DbCommand cmd = DatabaseUtil.GetCommand(db.GetSqlStringCommand(sql));
string workerCode = string.Empty;
string workerName = string.Empty;
if (searchCondition != null)
{
workerCode = searchCondition.WorkerCode.Trim();
workerName = searchCondition.WorkerName.Trim();
}
db.AddInParameter(cmd, "WorkerCode", DbType.String, '%' + workerCode + '%');
db.AddInParameter(cmd, "WorkerName", DbType.String, '%' + workerName + '%');
using (IDataReader reader = db.ExecuteReader(cmd))
{
while (reader.Read())
{
WorkerEntity item = new WorkerEntity();
item.WorkerCode = ConvertUtil.ToString(reader["WorkerCode"]);
item.WorkerName = ConvertUtil.ToString(reader["WorkerName"]);
item.Action = Constant.ACTION_UPDATE;
item.ReadOnly = true;
//throw new Exception();
entityList.Add(item);
}
}
return(entityList);
}
private void btnProjectLeader2_Click(object sender, EventArgs e)
{
string assemblyName = Path.Combine(Application.StartupPath, "Worker.dll");
IEntry instance = ApplicationDispatcher.GetInstance(assemblyName, new String[] { "" });
Form objForm = instance.GetSearchDialog(null);
if (objForm.ShowDialog() == DialogResult.OK)
{
var objForm1 = objForm as frmBase;
if (objForm1 != null)
{
foreach (DataGridViewRow item in objForm1.SelectedRows())
{
WorkerEntity entity = new WorkerEntity();
entity.WorkerCode = ConvertUtil.ToString(item.Cells["workerCodeColumn"].Value);
entity.WorkerName = ConvertUtil.ToString(item.Cells["workerNameColumn"].Value);
if (!string.IsNullOrEmpty(entity.WorkerCode))
{
this.txtProjectLeader2.Text = entity.WorkerName;
this.txtProjectLeader2.Tag = entity.WorkerCode;
break;
}
}
}
}
}
public List <WorkerEntity> Read(int minPassportNumber = DefValInt, int maxPassportNumber = DefValInt, string PersonalData = null)
{
string stringWithWhere = CreateWherePartForReadQuery(minPassportNumber, maxPassportNumber, PersonalData);
MySqlCommand command = new MySqlCommand(readString + stringWithWhere);
command.Connection = connection;
connection.Open();
List <WorkerEntity> result = new List <WorkerEntity>();
try
{
MySqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
object passportNumber = reader["PassportNumber"];
object personalDataFromDb = reader["PersonalData"];
WorkerEntity worker = new WorkerEntity
{
PassportNumber = System.Convert.ToInt32(passportNumber),
PersonalData = System.Convert.ToString(personalDataFromDb),
};
result.Add(worker);
}
}
finally
{
connection.Close();
}
return(result);
}
public bool InsertInfo(WorkerEntity obj)
{
con = Connectionsql.Connection();
bool term = SelectMysql.result("insert into tb_zhigong(Gonghao,Password,Name,Shenfenzhenghao,Sex,Address" +
",Gongzuodanwei,Phone,Birth,Ruyongriqi) values(" + "'" + obj.Jobnumber + "'" + "," + "'" + obj.Password + "'" + ","
+ "'" + obj.Name + "'" + "," + "'" + obj.Idnumber + "'" + "," + "'" + obj.Sex + "'" + "," + "'" + obj.Address +
"'" + "," + "'" + obj.Workunit + "'" + "," + "'" + obj.Phone + "'" + "," + "'" + obj.Birth + "'" + "," + "'" + obj.Hiredate + "'" + ")");
try
{
if (term == true)
{
return(term);
}
}
catch (MySqlException e)
{
MessageBox.Show(e.Message, "提示", MessageBoxButtons.OK);
}
finally
{
con.Close();
}
return(term);
}
private void button1_Click(object sender, EventArgs e)
{
login = new LoginControllerImpl();
string jobnumber = textBox1.Text;
string password = textBox2.Text;
string workunit = comboBox1.Text;
WorkerEntity obj = new WorkerEntity(jobnumber, password, workunit);
SalerManage saler = new SalerManage(obj);
login.JudgeNull(obj);
bool term = login.VisitDatabase(obj);
if (term == true)
{
login.JumpShow(obj);
this.Hide();
MessageBox.Show("登录成功");
}
else
{
MessageBox.Show("没有此用户！请重新输入！");
}
}
//登录
public bool VisitDatabase(WorkerEntity obj)
{
IWorkerDataService connect = new WorkerDataServiceImpl();
bool term = connect.SelectInfo(obj);
return(term);
}
static public void SetAllPlayersTrue()
{
//string gameId = CurrentFirm.ExternalId;
GetAllDTO games = GameEngineService.Instance.GetAll(0, 10000, "*****@*****.**");
foreach (GameEngineDTO game in games.List.game)
{
List <WorkerDTO> workers = WorkerRepository.Instance.GetWorkerDTOByExternalGameId(game.Id);
string errors = "";
foreach (WorkerDTO workerDTO in workers)
{
try
{
PlayerEngineDTO player = PlayerEngineService.Instance.GetById(workerDTO.ExternalId, "*****@*****.**");
player.Active = true;
player.Role = workerDTO.Role;
PlayerEngineService.Instance.CreateOrUpdate(player, "*****@*****.**");
WorkerEntity worker = WorkerRepository.Instance.GetById(workerDTO.IdWorker);
worker.Status = GenericStatus.ACTIVE;
WorkerRepository.Instance.UpdateWorker(worker);
}
catch (Exception e)
{
errors += workerDTO.Email + " -> " + e.Message + "<br/>";
}
}
}
}
//判断是否重复
public bool Register(WorkerEntity obj)
{
IWorkerDataService connect = new WorkerDataServiceImpl();
bool term = connect.SelectUniqueInfo(obj);
return(term);
}
public void JumpShow(WorkerEntity obj)
{
if (obj.Workunit == "人事管理")
{
WorkerManage worker = new WorkerManage();
worker.Show();
}
else if (obj.Workunit == "销售管理")
{
SaleManage saleManage = new SaleManage();
saleManage.Show();
}
else if (obj.Workunit == "进货管理")
{
PurchaseManage purchase = new PurchaseManage();
purchase.Show();
}
else if (obj.Workunit == "库存管理")
{
StockManage stockManage = new StockManage();
stockManage.Show();
}
else if (obj.Workunit == "销售员")
{
SalerManage salerManage = new SalerManage(obj);
salerManage.Show();
}
}
private void button1_Click(object sender, EventArgs e)
{
register = new LoginControllerImpl();
string jobnumber = textBox1.Text;
string password = textBox2.Text;
string workunit = textBox3.Text;
WorkerEntity obj = new WorkerEntity(jobnumber, password, workunit);
register.JudgeNull(obj);
bool term = false; //判断是否添加成功
bool judge = false; //判断是否重复添加
if (jobnumber != "" && password != "" && workunit != "")
{
term = register.InsertDatabase(obj); //判断是否添加成功
judge = register.Register(obj); //判断是否重复添加
}
if (judge == true)
{
MessageBox.Show("用户已注册！");
}
else
{
if (term == true)
{
MessageBox.Show("注册成功！");
Login login = new Login();
this.Hide();
login.Show();
}
}
}
//登录
public bool SelectInfo(WorkerEntity obj)
{
bool term = false;
con = Connectionsql.Connection();
MySqlDataReader reader = SelectMysql.reader("select Gonghao,Password,Gongzuodanwei from tb_zhigong");
try
{
while (reader.Read())
{
if ((obj.Jobnumber == reader.GetString("Gonghao")) && (obj.Password == reader.GetString("Password")) && (obj.Workunit == reader.GetString("Gongzuodanwei")))
{
term = true;
}
}
}
catch (MySqlException e)
{
MessageBox.Show(e.Message, "提示", MessageBoxButtons.OK);
}
finally
{
con.Close();
}
return(term);
}
public WorkerViewModel()
{
addWorker = new AddWorker(this);
UpdateWorker = new UpdateWorker(this);
DeleteWorker = new DeleteWorker(this);
CurrentWorker = new WorkerEntity();
SelectWorker = new WorkerEntity();
}
private AuthStatus LoginGeral(LoginViewModel model)
{
AuthResult result = new AuthResult();
if (!ModelState.IsValid)
{
return(AuthStatus.ERROR);
}
result = AccountHandler.Login(new LoginRequest()
{
UserName = model.Email,
Password = model.Password,
TokenMobile = model.tokenMobile,
Device = model.tipoDispositivo
});
WorkerEntity worker = WorkerRepository.Instance.GetByUserId(result.UserId);
if (result.AuthStatus == AuthStatus.OK)
{
var claims = new List <Claim>();
claims.Add(new Claim(ClaimTypes.Sid, result.UserId.ToString()));
claims.Add(new Claim(ClaimTypes.Name, result.UserId.ToString()));
claims.Add(new Claim(ClaimTypes.Email, model.Email));
claims.Add(new Claim(ClaimTypes.NameIdentifier, result.UserId.ToString()));
claims.Add(new Claim("http://schemas.microsoft.com/accesscontrolservice/2010/07/claims/identityprovider", "http://vlast.com.br"));
bool isSystemAdmin = false;
foreach (var role in result.UserRoles)
{
if (role == Roles.ADMINISTRATOR)
{
isSystemAdmin = true;
}
claims.Add(new Claim(ClaimTypes.Role, role.ToString()));
}
if (!isSystemAdmin)
{
//WorkerEntity worker = WorkerRepository.Instance.GetByUserId(result.UserId);
WorkerTypeEntity profile = WorkerTypeRepository.Instance.GetById(worker.WorkerTypeId);
claims.Add(new Claim(ClaimTypes.Role, profile.ProfileName.ToString()));
}
var identity = new ClaimsIdentity(claims, DefaultAuthenticationTypes.ApplicationCookie);
var ctx = Request.GetOwinContext();
var authenticationManager = ctx.Authentication;
authenticationManager.SignIn(identity);
return(AuthStatus.OK);
}
return(AuthStatus.ERROR);
}
/// <summary>
/// Maps source entity to target worker
/// </summary>
/// <param name="worker">Target worker</param>
/// <param name="entity">Source entity</param>
private void MapToWorker(Worker worker, WorkerEntity entity)
{
worker.Id = (int)entity.Id;
worker.Name = entity.Name;
worker.Surname = entity.Surname;
worker.Birthday = entity.Birthday;
worker.Sex = (Sex)entity.Sex;
worker.HasChildren = Convert.ToBoolean(entity.HasChildren);
}
/// <summary>
/// Maps source worker to target entity
/// </summary>
/// <param name="worker">Source worker</param>
/// <returns>Target entity</returns>
private void MapToWorkerEntity(Worker worker, WorkerEntity entity)
{
entity.Id = worker.Id;
entity.Name = worker.Name;
entity.Surname = worker.Surname;
entity.Birthday = worker.Birthday;
entity.Sex = (long)worker.Sex;
entity.HasChildren = Convert.ToInt64(worker.HasChildren);
}
public void RegisterWorker(string workerId, string serverId, DbConnection connection, DbTransaction transaction = null)
{
var worker = new WorkerEntity()
{
Id = workerId,
Server = serverId
};
connection.Insert <WorkerEntity>(worker, transaction);
}
public SalerManage(WorkerEntity obj)
{
InitializeComponent();
this.obj = obj;//显示时间
this.toolStripStatusLabel3.Text = "登录时间：" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss");
//查询全部销售信息
toolStripTextBox1.Text = obj.Name;
DataTable data = saler.SelectSaleInfo(obj.Idnumber);
this.dataGridView1.DataSource = data;
}
//修改
private void toolStripButton2_Click(object sender, EventArgs e)
{
DialogResult dialog = MessageBox.Show(this, "确定要修改此职工信息吗？", "提示",
MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (this.dataGridView1.SelectedRows.Count == 0)
{
MessageBox.Show("没有选中职工！");
return;
}
WorkerEntity workerEntity = new WorkerEntity();
if (dialog == DialogResult.Yes)
{
int i = this.dataGridView1.CurrentRow.Index;
workerEntity.Jobnumber = dataGridView1.CurrentRow.Cells[0].Value.ToString();
workerEntity.Password = dataGridView1.Rows[i].Cells[1].Value.ToString();
workerEntity.Name = dataGridView1.Rows[i].Cells[2].Value.ToString();
workerEntity.Idnumber = dataGridView1.Rows[i].Cells[3].Value.ToString();
workerEntity.Sex = dataGridView1.Rows[i].Cells[4].Value.ToString();
workerEntity.Address = dataGridView1.Rows[i].Cells[5].Value.ToString();
workerEntity.Workunit = dataGridView1.Rows[i].Cells[6].Value.ToString();
workerEntity.Phone = dataGridView1.Rows[i].Cells[7].Value.ToString();
workerEntity.Hiredate = dataGridView1.Rows[i].Cells[8].Value.ToString();
workerEntity.Birth = dataGridView1.Rows[i].Cells[9].Value.ToString();
UpdateWorker update = new UpdateWorker(workerEntity);
DialogResult dt = update.ShowDialog();
if (dt == DialogResult.OK)
{
workerEntity = update.Worker();
dataGridView1.CurrentRow.Cells[0].Value = workerEntity.Jobnumber;
dataGridView1.Rows[i].Cells[1].Value = workerEntity.Password;
dataGridView1.Rows[i].Cells[2].Value = workerEntity.Name;
dataGridView1.Rows[i].Cells[3].Value = workerEntity.Idnumber;
dataGridView1.Rows[i].Cells[4].Value = workerEntity.Sex;
dataGridView1.Rows[i].Cells[5].Value = workerEntity.Address;
dataGridView1.Rows[i].Cells[6].Value = workerEntity.Workunit;
dataGridView1.Rows[i].Cells[7].Value = workerEntity.Phone;
dataGridView1.Rows[i].Cells[8].Value = workerEntity.Hiredate;
dataGridView1.Rows[i].Cells[9].Value = workerEntity.Birth;
}
}
if (workerEntity == null)
{
MessageBox.Show("未选中职工！");
return;
}
}
private void button1_Click(object sender, EventArgs e)
{
WorkerEntity entity = Worker();
IWorkerManageController manageController = new WorkerManageControllerImpl();
bool term = manageController.UpdateWokerInfo(entity, jobnumber);
if (term == true)
{
MessageBox.Show("修改职工信息成功！");
this.DialogResult = DialogResult.OK;
this.Hide();
}
}
public UpdateWorker(WorkerEntity worker)
{
InitializeComponent();
textBox1_GH.Text = worker.Jobnumber;
textBox6_Pass.Text = worker.Password;
textBox2_Name.Text = worker.Name;
comboBox1_Sex.Text = worker.Sex;
textBox1.Text = worker.Workunit;
dateTimePicker1.Text = worker.Birth;
textBox7_Phone.Text = worker.Phone;
textBox8_Addr.Text = worker.Address;
textBox9_SFZH.Text = worker.Idnumber;
dateTimePicker2.Text = worker.Hiredate;
}
public void JudgeNull(WorkerEntity obj)
{
if (obj.Jobnumber == "")
{
MessageBox.Show("用户名不能为空！");
}
else if (obj.Password == "")
{
MessageBox.Show("密码不能为空！");
}
else if (obj.Workunit == "")
{
MessageBox.Show("工作单位不能为空！");
}
}
public void SaveResetsNewIdFlagAndSavesInStore()
{
WorkerEntity entity = null;
_repository.Setup(r => r.Add(It.IsAny <WorkerEntity>())).Callback <WorkerEntity>(e => entity = e);
var worker = _workerService.CreateNew();
worker.Save();
Assert.IsFalse(worker.IsNew);
CollectionAssert.Contains(_workerService.GetWorkers().Select(w => w.Id), worker.Id);
Assert.IsNotNull(entity);
Assert.AreEqual(worker.Id, entity.Id);
}
public WorkerEntity Worker()
{
jobnumber = textBox1_GH.Text;
name = textBox2_Name.Text;
sex = comboBox1_Sex.Text;
workunit = textBox1.Text;
birth = dateTimePicker1.Text;
password = textBox6_Pass.Text;
phone = textBox7_Phone.Text;
address = textBox8_Addr.Text;
idnumber = textBox9_SFZH.Text;
hiredate = dateTimePicker2.Text;
WorkerEntity entity = new WorkerEntity(jobnumber, password, name, idnumber, sex, address, workunit, phone, birth, hiredate);
return(entity);
}
public void Delete(WorkerEntity worker)
{
connection.Open();
MySqlCommand command = new MySqlCommand(deleteString);
MySqlParameter parameter = new MySqlParameter("@passportNumber", worker.PassportNumber.ToString());
command.Parameters.Add(parameter);
command.Connection = connection;
try
{
int delCount = command.ExecuteNonQuery();
}
finally
{
connection.Close();
}
}
public void Update(WorkerEntity worker, string PersonalData = null)
{
connection.Open();
string setString = CreateSetPartForUpdateQuery(PersonalData);
MySqlCommand command = new MySqlCommand(updateString + setString + $" where PassportNumber = {worker.PassportNumber};");
command.Connection = connection;
try
{
int updateCount = command.ExecuteNonQuery();
}
finally
{
connection.Close();
}
}
