//private void SelecionaMultiplosCustos()
//{
// if (udgv.Selected.Rows.Count > 0)
// {
// for (int x = 0; x < udgv.Selected.Rows.Count; x++)
// {
// if (!String.IsNullOrEmpty(mMarkupSelecionado)) mMarkupSelecionado += ",";
// mMarkupSelecionado += String.Format("'{0}'", udgv.Selected.Rows[x].Cells["id"].OriginalValue.ToString());
// }
// btnVoltar_Click(new object(), new EventArgs());
// }
// else MessageBox.Show("Você deve selecionar ao menos um custo adicional para utilizar essa opção", "Custo não selecionado", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
//}
#endregion
#region Eventos
private void udgv_ClickCell(object sender, Infragistics.Win.UltraWinGrid.ClickCellEventArgs e)
{
//Enquanto o usuário não clicar sobre o hiperlink, eu não faço nada.
if (e.Cell.Column.ToString().ToUpper() != "SELECIONAR")
{
return;
}
else
{
mMarkupSelecionado = new Markup()
{
Id = Convert.ToInt16(udgv.Rows[e.Cell.Row.Index].Cells["id"].OriginalValue.ToString()),
Nome = udgv.Rows[e.Cell.Row.Index].Cells["Nome"].OriginalValue.ToString(),
MargemLucro = Convert.ToDouble(udgv.Rows[e.Cell.Row.Index].Cells["Margem de lucro (%)"].OriginalValue.ToString()),
MarkupUp = Convert.ToDouble(udgv.Rows[e.Cell.Row.Index].Cells["Markup"].OriginalValue.ToString()),
MarkupDown = Convert.ToDouble(udgv.Rows[e.Cell.Row.Index].Cells["MarkDown"].OriginalValue.ToString()),
Mult = Convert.ToDouble(udgv.Rows[e.Cell.Row.Index].Cells["MultiplicadorValor"].OriginalValue.ToString()),
MultPer = Convert.ToDouble(udgv.Rows[e.Cell.Row.Index].Cells["MultiplicadorPercentual"].OriginalValue.ToString()),
Ativo = Convert.ToBoolean(udgv.Rows[e.Cell.Row.Index].Cells["Ativo_db"].OriginalValue.ToString()),
Visivel = Convert.ToBoolean(udgv.Rows[e.Cell.Row.Index].Cells["Visível"].OriginalValue.ToString()),
DtCrt = Convert.ToDateTime(udgv.Rows[e.Cell.Row.Index].Cells["Data de cadastro"].OriginalValue.ToString()),
UsrCrty = udgv.Rows[e.Cell.Row.Index].Cells["Cadastrado por"].OriginalValue.ToString(),
};
//mMarkupSelecionado = udgv.Rows[e.Cell.Row.Index].Cells["id"].OriginalValue.ToString();
this.Close();
GC.Collect();
}
}
private void udgv_ClickCell(object sender, Infragistics.Win.UltraWinGrid.ClickCellEventArgs e)
{
//Enquanto o usuário não clicar sobre o hiperlink, eu não faço nada.
if (e.Cell.Column.ToString().ToUpper() != "SELECIONAR")
{
return;
}
else
{
mProduto = new Produto();
mProduto.id = udgv.Rows[e.Cell.Row.Index].Cells["id"].OriginalValue.ToString();
mProduto.Nome = udgv.Rows[e.Cell.Row.Index].Cells["Nome"].OriginalValue.ToString();
mProduto.CustoUnitario = Convert.ToDouble(udgv.Rows[e.Cell.Row.Index].Cells["Custo unitário"].OriginalValue.ToString());
mProduto.CustoTotal = Convert.ToDouble(udgv.Rows[e.Cell.Row.Index].Cells["Custo total"].OriginalValue.ToString());
mProduto.DescontoPadrao = Convert.ToDouble(udgv.Rows[e.Cell.Row.Index].Cells["Desconto padrão"].OriginalValue.ToString());
mProduto.Quantidade = Convert.ToInt16(udgv.Rows[e.Cell.Row.Index].Cells["Quantidade"].OriginalValue.ToString());
mProduto.Tipo = Convert.ToInt16(udgv.Rows[e.Cell.Row.Index].Cells["Tipo_Db"].OriginalValue.ToString());
mProduto.Observacao = udgv.Rows[e.Cell.Row.Index].Cells["Observação"].OriginalValue.ToString();
mProduto.Ativo = Convert.ToBoolean(udgv.Rows[e.Cell.Row.Index].Cells["Ativo_Db"].OriginalValue.ToString());
mProduto.UsuarioCrt = udgv.Rows[e.Cell.Row.Index].Cells["Cadastrado por"].OriginalValue.ToString();
mProduto.DtCriacao = Convert.ToDateTime(udgv.Rows[e.Cell.Row.Index].Cells["Data de cadastro"].OriginalValue.ToString());
mProduto.UsuarioUltMod = udgv.Rows[e.Cell.Row.Index].Cells["Última alteração por"].OriginalValue.ToString();
mProduto.DtUltMod = Convert.ToDateTime(udgv.Rows[e.Cell.Row.Index].Cells["Data de última mod."].OriginalValue.ToString());
this.DialogResult = System.Windows.Forms.DialogResult.OK;
this.Close();
GC.Collect();
}
}
private void udgv_ClickCell(object sender, Infragistics.Win.UltraWinGrid.ClickCellEventArgs e)
{
//Enquanto o usuário não clicar sobre o hiperlink, eu não faço nada.
if (e.Cell.Column.ToString().ToUpper() != "SELECIONAR")
{
return;
}
else
{
mLstImpostos = new List <Imposto>();
mLstImpostos.Add(new Imposto()
{
Id = Convert.ToInt16(udgv.Rows[e.Cell.Row.Index].Cells["id"].OriginalValue.ToString()),
Nome = udgv.Rows[e.Cell.Row.Index].Cells["Imposto"].OriginalValue.ToString(),
TemValidade = Convert.ToBoolean(udgv.Rows[e.Cell.Row.Index].Cells["TemValidade"].OriginalValue.ToString()),
ValidoAte = Convert.ToDateTime(udgv.Rows[e.Cell.Row.Index].Cells["Válido até"].OriginalValue.ToString()),
TipoImposto = Convert.ToInt16(udgv.Rows[e.Cell.Row.Index].Cells["TipoImposto"].OriginalValue.ToString()),
ValorImposto = Convert.ToDouble(udgv.Rows[e.Cell.Row.Index].Cells["ValorImposto"].OriginalValue.ToString())
});
this.DialogResult = System.Windows.Forms.DialogResult.OK;
this.Close();
GC.Collect();
}
}
private void ugPaydates_ClickCell(object sender, Infragistics.Win.UltraWinGrid.ClickCellEventArgs e)
{
DataRow dr = ((System.Data.DataRowView)(((Infragistics.Win.UltraWinGrid.UltraGridRow)(ugPaydates.Selected.Rows.All[0])).ListObject)).Row;
TimeConnector.Export.SelectedInvoiceNumber = dr.ItemArray[5].ToString();
TimeConnector.Export.SetReportPath();
UpdateForm();
}
private void ugTimeLog_ClickCell(object sender, Infragistics.Win.UltraWinGrid.ClickCellEventArgs e)
{
ClearLabels();
int TimeLogId = Convert.ToInt32(((System.Data.DataRowView)(((Infragistics.Win.UltraWinGrid.UltraGridRow)(ugTimeLog.Selected.Rows.All[0])).ListObject)).Row.ItemArray[0]);
int ProjectId = Convert.ToInt32(((System.Data.DataRowView)(((Infragistics.Win.UltraWinGrid.UltraGridRow)(ugTimeLog.Selected.Rows.All[0])).ListObject)).Row.ItemArray[5]);
DataRow dr = TimeConnector.Data.TimeLog.GetTimeLogById(TimeLogId);
GetTimeLogDetail(dr);
}
private void ultraGrid1_ClickCell(object sender, Infragistics.Win.UltraWinGrid.ClickCellEventArgs e)
{
try
{
VisualizaImagemEdgecam((byte[])udgv_Imagens.Rows[e.Cell.Row.Index].Cells["JBP_IMAGE_BLOB"].Value);
}
catch (Exception ex)
{
Objects.CadastraNovoLog(true, "Erro ao tentar visualizar a imagem do trabalho", "FrmTrabalhos_New", "ultraGrid1_ClickCell", "", "", e_TipoErroEx.Erro, ex);
}
}
private void ugProjects_ClickCell(object sender, Infragistics.Win.UltraWinGrid.ClickCellEventArgs e)
{
DataRow dr = ((System.Data.DataRowView)(((Infragistics.Win.UltraWinGrid.UltraGridRow)(ugProjects.Selected.Rows.All[0])).ListObject)).Row;
TimeConnector.Data.Variables.AssignSelectionData("Project", dr);
lblProjId.Text = dr.ItemArray[0].ToString();
txtProjName.Text = dr.ItemArray[1].ToString();
txtProjDescription.Text = dr.ItemArray[2].ToString();
ucProjStatus.Text = dr.ItemArray[3].ToString();
ucProjGroup.Text = dr.ItemArray[4].ToString();
}
/// <summary>
/// Evento da grade de dados que permite trazer para frente um determinado
/// item que ainda não foi salvo.
/// </summary>
private void udgvItensNaoSalvos_ClickCell(object sender, Infragistics.Win.UltraWinGrid.ClickCellEventArgs e)
{
//Enquanto o usuário não clicar sobre o hiperlink, eu não faço nada.
if (e.Cell.Column.ToString().ToUpper() != "SELECIONAR")
{
return;
}
else
{
Objects.ChamaTelaPendenteInterface(udgvItensNaoSalvos.Rows[e.Cell.Row.Index].Cells["HashCode"].OriginalValue.ToString());
}
}
private void ugContacts_ClickCell(object sender, Infragistics.Win.UltraWinGrid.ClickCellEventArgs e)
{
DataRow dr = ((System.Data.DataRowView)(((Infragistics.Win.UltraWinGrid.UltraGridRow)(ugContacts.Selected.Rows.All[0])).ListObject)).Row;
TimeConnector.Data.Variables.AssignSelectionData("Contact", dr);
lblContactId.Text = dr.ItemArray[0].ToString();
txtConName.Text = dr.ItemArray[1].ToString();
txtConPhone.Text = dr.ItemArray[2].ToString();
txtConEmail.Text = dr.ItemArray[3].ToString();
lblCmpId.Text = dr.ItemArray[4].ToString();
cbCompany.SelectedIndex = (Convert.ToInt32(lblCmpId.Text) - 2);
}
private void udgv_ClickCell(object sender, Infragistics.Win.UltraWinGrid.ClickCellEventArgs e)
{
//Enquanto o usuário não clicar sobre o hiperlink, eu não faço nada.
if (e.Cell.Column.ToString().ToUpper() != "SELECIONAR")
{
return;
}
else
{
mDadoAuxSelecionado = udgv.Rows[e.Cell.Row.Index].Cells["id"].OriginalValue.ToString();
btnVoltar_Click(new object(), new EventArgs());
}
}
private void uGridBom_ClickCell(object sender, Infragistics.Win.UltraWinGrid.ClickCellEventArgs e)
{
if (e.Cell.Row.Index < 0)
{
return;
}
var cAutoID = e.Cell.Row.Cells["AutoID"].Value.ToString();
int iAutoID;
if (int.TryParse(cAutoID, out iAutoID))
{
dataInventory.BomDetail.Rows.Clear();
bomDetailTableAdapter.Fill(dataInventory.BomDetail, iAutoID);
}
}
private void udgv_ClickCell(object sender, Infragistics.Win.UltraWinGrid.ClickCellEventArgs e)
{
//Enquanto o usuário não clicar sobre o hiperlink, eu não faço nada.
if (e.Cell.Column.ToString().ToUpper() != "SELECIONAR")
{
return;
}
else
{
mUsuarioSelecionado = udgv.Rows[e.Cell.Row.Index].Cells["Usuário"].OriginalValue.ToString();
this.Close();
GC.Collect();
}
}
private void ugCompanies_ClickCell(object sender, Infragistics.Win.UltraWinGrid.ClickCellEventArgs e)
{
DataRow dr = ((System.Data.DataRowView)(((Infragistics.Win.UltraWinGrid.UltraGridRow)(ugCompanies.Selected.Rows.All[0])).ListObject)).Row;
TimeConnector.Data.Variables.AssignSelectionData("Company", dr);
lblCmpId.Text = dr.ItemArray[0].ToString();
txtCmpName.Text = dr.ItemArray[1].ToString();
txtCmpAddress.Text = dr.ItemArray[2].ToString();
txtCmpCity.Text = dr.ItemArray[3].ToString();
txtCmpState.Text = dr.ItemArray[4].ToString();
txtCmpZip.Text = dr.ItemArray[5].ToString();
txtCmpPayRate.Text = dr.ItemArray[6].ToString();
txtCmpLogoPath.Text = dr.ItemArray[7].ToString();
txtCmpInitials.Text = dr.ItemArray[8].ToString();
txtCmpType.Text = dr.ItemArray[9].ToString();
}
private void uGridRole_ClickCell(object sender, Infragistics.Win.UltraWinGrid.ClickCellEventArgs e)
{
var cCode = e.Cell.Row.Cells["cCode"].Value.ToString();
using (var con = new SqlConnection(BaseStructure.WmsCon))
{
using (var cmd = new SqlCommand("GenRoleFunction", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@rCode", cCode);
con.Open();
cmd.ExecuteNonQuery();
}
}
roleFunctionTableAdapter.Fill(baseDs.RoleFunction, cCode);
}
private void udgv_ClickCell(object sender, Infragistics.Win.UltraWinGrid.ClickCellEventArgs e)
{
//Enquanto o usuário não clicar sobre o hiperlink, eu não faço nada.
if (e.Cell.Column.ToString().ToUpper() != "SELECIONAR")
{
return;
}
else
{
mIdTarifa = udgv.Rows[e.Cell.Row.Index].Cells["id"].OriginalValue.ToString();
this.DialogResult = System.Windows.Forms.DialogResult.OK;
this.Close();
GC.Collect();
}
}
private void ugPaydates_ClickCell(object sender, Infragistics.Win.UltraWinGrid.ClickCellEventArgs e)
{
DataRow dr = ((System.Data.DataRowView)(((Infragistics.Win.UltraWinGrid.UltraGridRow)(ugPaydates.Selected.Rows.All[0])).ListObject)).Row;
TimeConnector.Data.Variables.AssignSelectionData("Paydate", dr);
int PaydateId = Convert.ToInt32(dr.ItemArray[0].ToString());
DataRow dr2 = TimeConnector.Data.Paydate.GetPaydateByIdWithCompany(PaydateId);
lblPaydateId.Text = dr2.ItemArray[0].ToString();
lblWeekStart.Text = dr2.ItemArray[2].ToString();
lblWeekEnd.Text = dr2.ItemArray[3].ToString();
lblPayDate.Text = dr2.ItemArray[4].ToString();
lblInvNumber.Text = dr2.ItemArray[5].ToString();
lblWeekNumber.Text = dr2.ItemArray[6].ToString();
lblCmpId.Text = dr2.ItemArray[7].ToString();
lblCmpName.Text = dr2.ItemArray[8].ToString();
}
private void udgv_ClickCell(object sender, Infragistics.Win.UltraWinGrid.ClickCellEventArgs e)
{
//Enquanto o usuário não clicar sobre o hiperlink, eu não faço nada.
if (e.Cell.Column.ToString().ToUpper() != "SELECIONAR")
{
return;
}
else
{
mCotacao = udgv.Rows[e.Cell.Row.Index].Cells["Valor da cotação"].OriginalValue.ToString().Split(new char[] { '=' })[1].Replace(" Real brasileiro", "").Trim();
mMoeda = udgv.Rows[e.Cell.Row.Index].Cells["Moeda"].OriginalValue.ToString();
this.DialogResult = System.Windows.Forms.DialogResult.OK;
this.Close();
GC.Collect();
}
}
private void ugWorkdate_ClickCell(object sender, Infragistics.Win.UltraWinGrid.ClickCellEventArgs e)
{
ClearLabels();
int WorkDateId = Convert.ToInt32(((System.Data.DataRowView)(((Infragistics.Win.UltraWinGrid.UltraGridRow)(ugWorkdate.Selected.Rows.All[0])).ListObject)).Row.ItemArray[0].ToString());
WorkDateIdSelected = WorkDateId;
string WorkDate = Convert.ToDateTime(((System.Data.DataRowView)(((Infragistics.Win.UltraWinGrid.UltraGridRow)(ugWorkdate.Selected.Rows.All[0])).ListObject)).Row.ItemArray[1].ToString()).ToShortDateString();
//DateTime SelectedDate = Convert.ToDateTime((((System.Data.DataRowView)(ugWorkdate.ActiveCell.Row.ListObject)).Row).ItemArray[0].ToString());
//LoadTimeLog(WorkDateId);
DataTable dt = TimeConnector.Data.TimeLog.GetTimeLogByWorkdate(WorkDateId);
DataTable dt2 = GetTimeLogStats(dt);
RefreshGrid(dt2);
chkOvertime_CheckedChanged(sender, e);
//Database.Values.CustomCombos.LoadTimeCombos(cbStartTime, cbEndTime, WorkDate, "Normal");
cbProject.DataSource = TimeConnector.Data.Project.GetOpenProjects();
cbProject.DisplayMember = "ProjectName";
cbProject.ValueMember = "ProjectId";
}
private void udgv_ClickCell(object sender, Infragistics.Win.UltraWinGrid.ClickCellEventArgs e)
{
//Enquanto o usuário não clicar sobre o hiperlink, eu não faço nada.
if (e.Cell.Column.ToString().ToUpper() != "SELECIONAR")
{
return;
}
else
{
mCliente = new Cliente();
mCliente.Id = udgv.Rows[e.Cell.Row.Index].Cells["id"].OriginalValue.ToString();
mCliente.NomeEmpresa = udgv.Rows[e.Cell.Row.Index].Cells["Nome do cliente"].OriginalValue.ToString();
mCliente.Cidade = udgv.Rows[e.Cell.Row.Index].Cells["Cidade"].OriginalValue.ToString();
mCliente.Estado = udgv.Rows[e.Cell.Row.Index].Cells["Estado"].OriginalValue.ToString();
mCliente.Pais = udgv.Rows[e.Cell.Row.Index].Cells["País"].OriginalValue.ToString();
this.DialogResult = System.Windows.Forms.DialogResult.OK;
this.Close();
GC.Collect();
}
}
private void grdDataLinea_ClickCell(object sender, Infragistics.Win.UltraWinGrid.ClickCellEventArgs e)
{
btnLineaEliminar.Enabled = true;
btnLineaEditar.Enabled = true;
}
private void ultraGridRepPartList_ClickCell(object sender, Infragistics.Win.UltraWinGrid.ClickCellEventArgs e)
{
}
