public ActionDlg(Worker mworker, uint regType)
{
this.Build();
worker = mworker;
labelName.Text = worker.getFIO();
if(regType == Const.AUTO_OPERATION)
if(worker.isOnWork() == 0)
{
autoStartWork();
}
else
{
autoEndWork();
}
getWorkerOnWorkNow();
keykeeperwidgetGetItem.clickEvent += onClickGetButton;
keykeeperwidgetBackItem.clickEvent += onClickPutButton;
searchentry2.changed += changedEvent;
updateKeyBack();
displayPopKey();
}
public PutItem(Worker worker,
uint workerRegType, Item item, uint itemRegType)
{
base.worker = worker;
base.worker_reg_type = workerRegType;
base.item = item;
base.item_reg_type = itemRegType;
}
public ActionDlg byWorker(Worker worker, uint regType)
{
Console.WriteLine("action by worker");
dlg = new ActionDlg(worker, regType);
dlg.actionSelectedIvent += dlgActionSelectedIvent;
dlg.updateTreeView += delegate(object sender, EventArgs e)
{
if(updateTree!=null)
updateTree(this,this);
};
dlg.Show();
return dlg;
}
public Action(Worker worker, uint workerRegType)
{
}
public StartWork(Worker worker, uint worker_reg_type)
{
base.worker = worker;
base.worker_reg_type = worker_reg_type;
}
/// <summary>
/// Определяет принадлежит ли придмет сотруднику
/// </summary>
/// <returns>
/// принадлежность предмета
/// </returns>
/// <param name='worker'>
/// Сотрудник
/// </param>
/// <param name='item'>
/// Предмет
/// </param>
public static bool isItemByWorker(Worker worker, Item item)
{
bool answer = false;
IDataReader reader = dbConnector.getdbAcces().readbd(
string.Format(@"SELECT id FROM journal
where worker_id = '{0}' and isnull(stamp_end) and item_id = '{1}'",
worker.id(),item.id()));
try
{
answer = reader.Read();
}
catch(MySqlException ex)
{
Utils.showMessageError(ex.ToString());
}
reader.Close();
reader = null;
return answer;
}
/// <summary>
/// Получает информация о сотруднике
/// </summary>
/// <returns>
/// Сотрудник
/// </returns>
/// <param name='workerid'>
/// ID сотрудника
/// </param>
public static Worker getWorkerData(uint workerid)
{
Worker tmpWorker = null;
IDataReader reader = dbConnector.getdbAcces().readbd(
string.Format(@"select *, concat_ws(' ',f,i,o) as fio, concat(f,' ',left(i,1),'. ',left(o,1),'.') as shortfio
from workers
where id='{0}'",workerid));
try
{
if(reader.Read())
tmpWorker= new Worker((uint)reader["id"], (string)reader["fio"],
(string)reader["shortfio"],(string)reader["phone"],(uint)reader["code"]);
}
catch(MySqlException ex)
{
Utils.showMessageError(ex.ToString());
}
reader.Close();
reader = null;
return tmpWorker;
}
/// <summary>
/// Получает сотрудника у которого находится предмет
/// </summary>
/// <returns>
/// Сотрудник
/// </returns>
/// <param name='itemId'>
/// ID предмета
/// </param>
public static Worker getWorkerByItem(uint itemId)
{
Worker tmpWorker = null;
IDataReader reader = dbConnector.getdbAcces().readbd(
string.Format(@"select w.*, concat_ws(' ',w.f,w.i,w.o) as fio, concat(w.f,' ',left(w.i,1),'. ',left(w.o,1),'.') as shortfio
from journal j
join workers w on w.id = j.worker_id
where j.operation_id=3 and isnull(j.stamp_end) and j.item_id = '{0}'",
itemId,
Const.OPERATION_WORK_IN));
try
{
if(reader.Read())
{
tmpWorker= new Worker((uint)reader["id"], (string)reader["fio"],
(string)reader["shortfio"],(string)reader["phone"],(uint)reader["code"]);
}
}
catch(MySqlException ex)
{
Utils.showMessageError(ex.ToString());
}
reader.Close();
reader = null;
return tmpWorker;
}
/// <summary>
/// Получает сотрудника по штрих-коду
/// </summary>
/// <returns>
/// Сотрудник
/// </returns>
/// <param name='code'>
/// Штрих-код
/// </param>
public static Worker getWorkerByCode(string code)
{
Worker tmpWorker = null;
IDataReader reader = dbConnector.getdbAcces().readbd(
string.Format(@"SELECT w.*,
concat_ws(' ',f,i,o) as fio,
concat(f,' ',left(i,1),'. ',left(o,1),'.') as shortfio, cw.description
FROM code2worker cw
join workers w on w.id = cw.worker_id
where cw.code = '{0}'",code));
try
{
if(reader.Read())
{
if(reader["id"] != DBNull.Value)
tmpWorker= new Worker((uint)reader["id"], (string)reader["fio"],
(string)reader["shortfio"],(string)reader["phone"],(uint)reader["code"]);
else
Console.WriteLine("нету такого сотрудника!!1");
}
else
Console.WriteLine("wtf: null answer");
}
catch(MySqlException ex)
{
Utils.showMessageError(ex.ToString());
}
reader.Close();
reader = null;
return tmpWorker;
}
