private void Preencher_dataGridView()
{
TotalMaterialtxtBox.Text = "";
TotalMObraEncargosTxtBox.Text = "";
TotalMObraMaterial.Text = "";
for (int i = 0; i < dataGridView1.RowCount; i++)
{
SCOOPDataSet.InsumoDataTable Dt = new InsumoTableAdapter().GetDataBy(dataGridView1.Rows[i].Cells[2].Value.ToString());
foreach (SCOOPDataSet.InsumoRow linha in Dt)
{
dataGridView1.Rows[i].Cells[3].Value = linha.Descricao;
dataGridView1.Rows[i].Cells[4].Value = linha.Unidade;
if (linha.TipoInsumo == 3)
{
dataGridView1.Rows[i].Cells[6].Value = String.Format("{0:C2}", linha.Preco + linha.Preco * Convert.ToDecimal("1,2558"));
dataGridView1.Rows[i].Cells[7].Value = String.Format("{0:C2}", Convert.ToDecimal(dataGridView1.Rows[i].Cells[5].Value) * (linha.Preco + linha.Preco * Convert.ToDecimal("1,2558")));
ObterTotalMObraEncargo(Convert.ToDecimal(dataGridView1.Rows[i].Cells[7].Value.ToString().Replace("R$", "")));
}
else
{
dataGridView1.Rows[i].Cells[6].Value = String.Format("{0:C2}", linha.Preco);
dataGridView1.Rows[i].Cells[7].Value = String.Format("{0:C2}", Convert.ToDecimal(dataGridView1.Rows[i].Cells[5].Value) * linha.Preco);
ObterTotalMaterial(Convert.ToDecimal(dataGridView1.Rows[i].Cells[7].Value.ToString().Replace("R$", "")));
}
}
}
TotalMObraMaterial.Text = String.Format("{0:C2}", Convert.ToDecimal(TotalMObraEncargosTxtBox.Text.Replace("R$", "") == "" ? "0" : TotalMObraEncargosTxtBox.Text.Replace("R$", "")) + Convert.ToDecimal(TotalMaterialtxtBox.Text.Replace("R$", "") == "" ? "0" : TotalMaterialtxtBox.Text.Replace("R$", "")));
}
private void preencherCodigoInsumo()
{
#region SequencialInsumo
string sequencial = "0001";
try
{
sequencial = new InsumoTableAdapter().ObterSequencialPorGrupo("474").ToString();
}
catch (Exception) { }
//string CodigoInsumo = CodigoGrupo + "," + sequencial;
if (sequencial.Length == 1)
{
mskTxtBoxCodigo.Text = "005474" + "000" + sequencial;
}
else if (sequencial.Length == 2)
{
mskTxtBoxCodigo.Text = "005474" + "00" + sequencial;
}
else if (sequencial.Length == 3)
{
mskTxtBoxCodigo.Text = "005474" + "0" + sequencial;
}
else
{
sequencial = "0001";
mskTxtBoxCodigo.Text = "005474" + sequencial;
}
#endregion
}
private void dataGridView1_RowsAdded(object sender, DataGridViewRowsAddedEventArgs e)
{
SCOOP.DAO.SCOOPDataSet.InsumoDataTable Dt = new InsumoTableAdapter().GetDataBy(dataGridView1.Rows[e.RowIndex].Cells[2].Value.ToString());
foreach (SCOOP.DAO.SCOOPDataSet.InsumoRow linha in Dt)
{
dataGridView1.Rows[e.RowIndex].Cells[3].Value = linha.Descricao;
dataGridView1.Rows[e.RowIndex].Cells[4].Value = linha.Unidade;
dataGridView1.Rows[e.RowIndex].Cells[6].Value = linha.Preco.ToString();
dataGridView1.Rows[e.RowIndex].Cells[7].Value = Convert.ToString(Convert.ToDecimal(dataGridView1.Rows[e.RowIndex].Cells[5].Value) * linha.TipoInsumo == 3 ? linha.Preco + linha.Preco * Convert.ToDecimal("1,2558") : linha.Preco);
}
}
private void ComboBoxGrupo_SelectedIndexChanged(object sender, EventArgs e)
{
if (mskTxtBoxCodigo.Text.Length != 12)
{
if (ComboBoxGrupo.SelectedValue != null)
{
string CodigoGrupo = null;
if (ComboBoxGrupo.SelectedValue.ToString().Length == 2)
{
CodigoGrupo = "0" + ComboBoxGrupo.SelectedValue.ToString();
}
else if (ComboBoxGrupo.SelectedValue.ToString().Length == 1)
{
CodigoGrupo = "00" + ComboBoxGrupo.SelectedValue.ToString();
}
else
{
CodigoGrupo = ComboBoxGrupo.SelectedValue.ToString();
}
string sequencial = "0001";
try
{
sequencial = new InsumoTableAdapter().ObterSequencialPorGrupo(ComboBoxGrupo.SelectedValue.ToString()).ToString();
}
catch (Exception) { }
//string CodigoInsumo = CodigoGrupo + "," + sequencial;
if (sequencial.Length == 1)
{
mskTxtBoxCodigo.Text = mskTxtBoxCodigo.Text.Substring(0, 3) + CodigoGrupo + "000" + sequencial;
}
else if (sequencial.Length == 2)
{
mskTxtBoxCodigo.Text = mskTxtBoxCodigo.Text.Substring(0, 3) + CodigoGrupo + "00" + sequencial;
}
else if (sequencial.Length == 3)
{
mskTxtBoxCodigo.Text = mskTxtBoxCodigo.Text.Substring(0, 3) + CodigoGrupo + "0" + sequencial;
}
else
{
sequencial = "0001";
mskTxtBoxCodigo.Text = mskTxtBoxCodigo.Text.Substring(0, 3) + CodigoGrupo + sequencial;
}
}
else
{
ComboBoxGrupo.Text = "";
}
}
}
private void CodigoInsumomaskedTextBox_TextChanged(object sender, EventArgs e)
{
if (CodigoInsumomaskedTextBox.Text.Length == 12)
{
SCOOPDataSet.InsumoDataTable Dt = new InsumoTableAdapter().GetDataBy(CodigoInsumomaskedTextBox.Text.Replace(",", "."));
foreach (SCOOPDataSet.InsumoRow linha in Dt)
{
descricaoInsumotextBox.Text = linha.Descricao;
UnidadetextBox.Text = linha.Unidade;
ValortextBox.Text = Convert.ToString(linha.TipoInsumo == 3 ? linha.Preco + linha.Preco * Convert.ToDecimal("1,2558") : linha.Preco);
}
QuantidadetextBox.Focus();
}
}
private void toolStripButton15_Click(object sender, EventArgs e)
{
SCOOPDataSet.InsumoDataTable Dt = new InsumoTableAdapter().GetDataBy(dataGridView1.Rows[Convert.ToInt32(bindingNavigatorPositionItem.TextBox.Text) - 1].Cells[1].Value.ToString());
foreach (SCOOPDataSet.InsumoRow linha in Dt)
{
mskTxtBoxCodigo.Text = linha.Codigo;
TxtBoxDescricao.Text = linha.Descricao;
ComboBoxTipoInsumo.Text = new TipoInsumoTableAdapter().ObterDescricaoGrupoInsumo(linha.TipoInsumo).ToString();
ComboBoxFornecedor.SelectedValue = linha.Fornecedor;
ComboBoxGrupo.Text = new GrupoInsumoTableAdapter().ObterDescricaoGrupoInsumo(linha.Grupo).ToString();
ComboBoxUnidade.Text = linha.Unidade;
MslTxtBoxPreco.Text = Convert.ToString(linha.Preco);
}
tabControl1.SelectedTab = tabPage1;
BttAlterar.Visible = true;
BttInserir.Visible = false;
}
