private void btnWorkSelect_Click(object sender, EventArgs e)
{
// ранее введеные значения
Salary oSalaryExtraWorkTemp = new Salary();
oSalaryExtraWorkTemp.FilterDateBeg = DateTime.Now.Date.AddYears(-1);
oSalaryExtraWorkTemp.FilterDateEnd = DateTime.Now.Date;
oSalaryExtraWorkTemp.FillTableSalaryExtraWorks();
if (oSalaryExtraWorkTemp.ErrorNumber != 0 || oSalaryExtraWorkTemp.TableSalaryExtraWorks == null)
{
return;
}
if (oSalaryExtraWorkTemp.TableSalaryExtraWorks.Rows.Count == 0)
{
RFMMessage.MessageBoxError("Нет данных...");
return;
}
/*
* DataTable dtWorkNamesDistinct = new DataTable();
* dtWorkNamesDistinct.Columns.Add("WorkName");
* System.Collections.Hashtable hash = new System.Collections.Hashtable();
* foreach (DataRow row in oSalaryExtraWorkTemp.MainTable.Rows)
* hash[row["WorkName"]] = row["WorkName"];
* foreach (object name in hash.Values)
* dtWorkNamesDistinct.Rows.Add(name);
* DataTable tdWorkNames = CopyTable(dtWorkNamesDistinct, "tdWorkNames", "WorkName > ''", "WorkName");
*/
DataTable tdWorkNames = new DataView(oSalaryExtraWorkTemp.TableSalaryExtraWorks, "", "WorkName", DataViewRowState.CurrentRows).ToTable(true, "WorkName");
if (StartForm(new frmSelectID(this, tdWorkNames, "WorkName", "Дополнительная работа", false)) == DialogResult.Yes)
{
if (_SelectedID == null)
{
return;
}
txtWorkName.Text = _SelectedText;
}
_SelectedID = null;
_SelectedText = "";
tabSalaryExtraWorks.IsNeedRestore = true;
return;
}
private void frmSalaryExtraWorksEdit_Load(object sender, EventArgs e)
{
bool bResult = true;
bResult = cboEmployees_Restore();
if (bResult)
{
if (nSalaryExtraWorkID.HasValue)
{
oSalaryExtraWork.nSalaryExtraWorkID = nSalaryExtraWorkID;
oSalaryExtraWork.FillTableSalaryExtraWorks();
if (oSalaryExtraWork.ErrorNumber != 0 || oSalaryExtraWork.TableSalaryExtraWorks.Rows.Count != 1)
{
RFMMessage.MessageBoxError("Ошибка при получении данных о дополнительных работах...");
bResult = false;
}
if (bResult)
{
DataRow r = oSalaryExtraWork.TableSalaryExtraWorks.Rows[0];
dtpDateWork.Value = (DateTime)r["DateWork"];
cboEmployees.SelectedValue = (int)r["DriverEmployeeID"];
txtWorkName.Text = r["WorkName"].ToString().Trim();
numQnt.Value = (decimal)r["Qnt"];
numTarif.Value = (decimal)r["Price"];
numAmount.Value = Math.Round((decimal)numQnt.Value * (decimal)numTarif.Value, 2);
txtNote.Text = r["Note"].ToString().Trim();
}
}
else
{
// новый факт выполнения дополнительных работ
}
}
if (!bResult)
{
Dispose();
Close();
}
dtpDateWork.Select();
}
private bool dgvExtraWorks_Restore()
{
RFMCursorWait.Set(true);
RFMCursorWait.LockWindowUpdate(FindForm().Handle);
oSalaryExtraWorkList.ClearError();
oSalaryExtraWorkList.ClearFilters();
oSalaryExtraWorkList.ID = null;
// собираем условия
// даты
if (!dtrDates.dtpBegDate.IsEmpty)
{
oSalaryExtraWorkList.FilterDateBeg = dtrDates.dtpBegDate.Value.Date;
}
if (!dtrDates.dtpEndDate.IsEmpty)
{
oSalaryExtraWorkList.FilterDateEnd = dtrDates.dtpEndDate.Value.Date;
}
if (ucSelectRecordID_DriversEmployees.IsSelectedExist)
{
oSalaryExtraWorkList.FilterDriversEmployeesList = ucSelectRecordID_DriversEmployees.GetIdString();
}
if (txtWorkName.Text.Trim().Length > 0)
{
oSalaryExtraWorkList.FilterWorkNameContext = txtWorkName.Text.Trim();
}
dgvExtraWorks.GetGridState();
oSalaryExtraWorkList.FillTableSalaryExtraWorks();
dgvExtraWorks.IsLockRowChanged = true;
dgvExtraWorks.Restore(oSalaryExtraWorkList.TableSalaryExtraWorks);
RFMCursorWait.LockWindowUpdate(IntPtr.Zero);
RFMCursorWait.Set(false);
return(oSalaryExtraWorkList.ErrorNumber == 0);
}