public void Atualizar(Perguntas p)
{
try
{
AbrirConexao();
Tr = Con.BeginTransaction();
Cmd = new SqlCommand("UPDATE Formulario.Perguntas SET descricao = @v2, tipo = @v3 WHERE IdPergunta = @v1", Con, Tr);
Cmd.Parameters.AddWithValue("@v1", p.IdPergunta);
Cmd.Parameters.AddWithValue("@v2", p.Descricao);
Cmd.Parameters.AddWithValue("@v3", p.Tipo);
Cmd.ExecuteNonQuery();
Tr.Commit();
}
catch (Exception ex)
{
if (Tr != null)
{
Tr.Rollback(); // Desfaz a transação..
}
throw new Exception("Não foi possível atualizar a pergunta: " + ex.Message);
}
finally
{
FecharConexao(); //fechar conexão..
}
}
/// <summary>
/// Metodo utilizado para excluir um cliente na base de dados e seu respectivo endereco
/// </summary>
/// <param name="Id">Int Id (Código da entidade Cliente)</param>
public void Delete(int Id)
{
try
{
OpenConnection();
Tr = Con.BeginTransaction();
string queryEndereco = "delete from Endereco where IdCliente = @Id";
Cmd = new SqlCommand(queryEndereco, Con, Tr);
Cmd.Parameters.AddWithValue("@Id", Id);
Cmd.ExecuteNonQuery();
string queryCliente = "delete from Cliente where IdCliente = @Id";
Cmd = new SqlCommand(queryCliente, Con, Tr);
Cmd.Parameters.AddWithValue("@Id", Id);
Cmd.ExecuteNonQuery();
Tr.Commit();
}
catch (Exception ex)
{
throw new Exception("Erro ao excluir cliente. \n" + ex.Message);
}
finally
{
CloseConnection();
}
}
public void AtualizaUltimoAcesso(int id)
{
try
{
AbrirConexao(); //abrir conexão..
Tr = Con.BeginTransaction();
Cmd = new SqlCommand("UPDATE Formulario.formulario SET UltimoAcesso = '" + DateTime.Now.ToString("dd/MM/yyyy hh:mm") + "' where IdFormulario = " + id, Con, Tr);
string t = "UPDATE Formulario.formulario SET UltimoAcesso = '" + DateTime.Now.ToString("dd/MM/yyyy hh:mm") + "' where IdFormulario = " + id;
Cmd.ExecuteNonQuery();
Cmd = new SqlCommand("UPDATE Formulario.Formulario SET Acessado = 'SIM' where IdFormulario = " + id, Con, Tr);
Cmd.ExecuteNonQuery();
Tr.Commit();
}
catch (Exception ex)
{
if (Tr != null)
{
Tr.Rollback(); // Desfaz a transação..
}
throw new Exception("Não foi possível atualizar o Formulário: " + ex.Message);
}
finally
{
FecharConexao(); //fechar conexão..
}
}
public void Excluir(int id)
{
try
{
AbrirConexao();
Tr = Con.BeginTransaction();
Cmd = new SqlCommand("DELETE FROM Formulario.PerguntasPorFormularios WHERE IdFormulario = @v1", Con, Tr);
Cmd.Parameters.AddWithValue("@v1", id);
Cmd.ExecuteNonQuery();
Cmd = new SqlCommand("DELETE FROM Formulario.Formulario WHERE IdFormulario = @v1", Con, Tr);
Cmd.Parameters.AddWithValue("@v1", id);
Cmd.ExecuteNonQuery();
Tr.Commit();
}
catch (Exception ex)
{
if (Tr != null)
{
Tr.Rollback(); // Desfaz a transação..
}
throw new Exception("Não foi possível remover o formulário: " + ex.Message);
}
}
private void btnExit_Click(object sender, EventArgs e)
{
if (!Convert.ToBoolean(this.bView))
{
if ((this.dsPR.Tables[0].Rows.Count > 0) || (this.groupPR.Enabled == false))
{
if (NP.MSGB("The PO list will be cancel , Do you agree with this ?") == DialogResult.Yes)
{
// Cancel
oConn = new SqlConnection(NP.ReadFileDB(Application.StartupPath + @"\DB\DB.ini"));
if (oConn.State == ConnectionState.Open)
{
oConn.Close();
}
oConn.Open(); SqlTransaction Tr;
Tr = oConn.BeginTransaction();
try
{
SqlCommand cmd = new SqlCommand();
NP_Cls.SqlDel = "DELETE FROM t_PO WHERE (PONumber = @DocNumber)";
cmd.Parameters.Add("@DocNumber", SqlDbType.NVarChar, 12).Value = this.txtPR.Text.Trim();
cmd.CommandText = NP_Cls.SqlDel; cmd.Connection = oConn; cmd.Transaction = Tr;
cmd.ExecuteNonQuery();
NP_Cls.SqlDel = "DELETE FROM t_PODetail WHERE (PONumber = @DocNumber)";
cmd.CommandText = NP_Cls.SqlDel; cmd.Connection = oConn; cmd.Transaction = Tr;
cmd.ExecuteNonQuery();
Tr.Commit();
}
catch (Exception ex)
{
NP.MSGB(NP_Cls.NPMgsStyle.ErrorType, "Del : " + ex.Message);
}
finally
{
if (oConn.State == ConnectionState.Open)
{
oConn.Close();
}
}
this.Close(); return;
}
else
{
return;
}
}
}
if (NP.MSGB("Do you want to exit this screen ?") == DialogResult.Yes)
{
this.Close();
}
else
{
return;
}
}
public void Atualizar(Formulario f)
{
try
{
AbrirConexao(); //abrir conexão..
Tr = Con.BeginTransaction();
Cmd = new SqlCommand("UPDATE Formulario.formulario SET Nome = @v2, Empresa = @v3, Email = @v4 where IdFormulario = @v1", Con, Tr);
Cmd.Parameters.AddWithValue("@v1", f.IdFormulario);
Cmd.Parameters.AddWithValue("@v2", f.Nome);
Cmd.Parameters.AddWithValue("@v3", f.Empresa);
//Cmd.Parameters.AddWithValue("@v4", f.DataCriacao);
//Cmd.Parameters.AddWithValue("@v5", f.DataConclusao);
//Cmd.Parameters.AddWithValue("@v6", f.UltimoAcesso);
//Cmd.Parameters.AddWithValue("@v7", f.Acessado);
Cmd.Parameters.AddWithValue("@v4", f.Email);
Cmd.ExecuteNonQuery();
Tr.Commit();
}
catch (Exception ex)
{
if (Tr != null)
{
Tr.Rollback(); // Desfaz a transação..
}
throw new Exception("Não foi possível atualizar o Formulário: " + ex.Message);
}
finally
{
FecharConexao(); //fechar conexão..
}
}
private void deleteAllToolStripMenuItem_Click(object sender, EventArgs e)
{
if (NP.MSGB("Do you want to delete all ?") == DialogResult.Yes)
{
if (this.dgvView.RowCount == 0)
{
NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Data Not Found !!"); return;
}
oConn = new SqlConnection(NP.ReadFileDB(NP_Cls.PathDB));
if (oConn.State == ConnectionState.Open)
{
oConn.Close();
}
oConn.Open(); SqlTransaction Tr; Tr = oConn.BeginTransaction();
try
{
SqlCommand cmdDel = new SqlCommand();
NP_Cls.SqlDel = "DELETE FROM t_Routing WHERE (MaterialCode = @MaterialCode) AND (PlantCode = @PlantCode)";
cmdDel.Parameters.Add("@MaterialCode", SqlDbType.NVarChar, 15).Value = this.cbMaterial.SelectedValue;
cmdDel.Parameters.Add("@PlantCode", SqlDbType.NVarChar, 4).Value = this.cbPlant.SelectedValue;
cmdDel.Connection = oConn; cmdDel.CommandText = NP_Cls.SqlDel; cmdDel.Transaction = Tr;
cmdDel.ExecuteNonQuery();
NP_Cls.SqlDel = "DELETE FROM t_RoutingDetail WHERE (MaterialCode = @MaterialCode) AND (PlantCode = @PlantCode) AND (WorkCenterCode = @WorkCenterCode)";
cmdDel.Parameters.Add("@WorkCenterCode", SqlDbType.NVarChar, 10).Value = this.dgvView["clnName", this.dgvView.CurrentRow.Index].Value;
cmdDel.Connection = oConn; cmdDel.CommandText = NP_Cls.SqlDel; cmdDel.Transaction = Tr;
cmdDel.ExecuteNonQuery();
if (NP._TRanSave(oConn, Tr, NP_Cls.NPTranType.Delete, "t_Routing:t_RoutingDetail", NP_Cls.strUsr))
{
Tr.Commit();
DGV(); Clear(); NP.MSGB(NP_Cls.NPMgsStyle.InfoType, "Delete All Completed !!");
}
else
{
NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Try agian !!"); return;
}
}
catch (Exception ex)
{
if (oConn.State == ConnectionState.Open)
{
Tr.Rollback();
}
NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Add : " + ex.Message); return;
}
finally
{
if (oConn.State == ConnectionState.Open)
{
oConn.Close();
}
}
}
else
{
return;
}
}
private void btnCancelPR_Click(object sender, EventArgs e)
{
try
{
if (NP.MSGB("Do you to cancel Transfer Stock ?") == DialogResult.Yes)
{
oConn = new SqlConnection(NP.ReadFileDB(NP_Cls.PathDB));
if (oConn.State == ConnectionState.Open)
{
oConn.Close();
}
oConn.Open(); SqlTransaction Tr;
Tr = oConn.BeginTransaction();
try
{
SqlCommand cmd = new SqlCommand();
NP_Cls.SqlDel = "DELETE FROM t_StockMovement WHERE (DocNumber = @DocNumber)";
cmd.Parameters.Add("@DocNumber", SqlDbType.NVarChar, 12).Value = this.txtPR.Text.Trim();
cmd.CommandText = NP_Cls.SqlDel; cmd.Connection = oConn; cmd.Transaction = Tr;
cmd.ExecuteNonQuery();
NP_Cls.SqlDel = "DELETE FROM t_StockMovementDetail WHERE (DocNumber = @DocNumber)";
cmd.CommandText = NP_Cls.SqlDel; cmd.Connection = oConn; cmd.Transaction = Tr;
cmd.ExecuteNonQuery();
Tr.Commit();
}
catch (Exception ex)
{
NP.MSGB("Del : " + ex.Message);
}
finally
{
if (oConn.State == ConnectionState.Open)
{
oConn.Close();
}
}
Clear(); this.groupPR.Enabled = true; this.cbMaterial.Text = string.Empty;
if (this.dsPR.Tables.Count > 0)
{
this.dsPR.Tables.Clear(); this.MyGrid(this.dgvView);
}
this.cbMaterial.DataSource = null;
this.btnAddHeader.Visible = true; this.btnSave.Visible = false;
CreateMovType(); this.cbMovType.Select();
}
else
{
return;
}
}
catch (Exception ex)
{
NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Cancel : " + ex.Message); return;
}
}
private void btnSaveChange_Click(object sender, EventArgs e)
{
if (this.dgvView.RowCount == 0)
{
NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Data Not Found !!"); return;
}
this.dgvView.EndEdit();
if (NP.MSGB("Do you want to Save Change Data ?") == DialogResult.Yes)
{
oConn = new SqlConnection(NP.ReadFileDB(NP_Cls.PathDB));
if (oConn.State == ConnectionState.Open)
{
oConn.Close();
}
SqlTransaction Tr;
oConn.Open(); Tr = oConn.BeginTransaction(); this.dgvView.EndEdit();
try
{
SqlCommand cmdEdit = new SqlCommand();
NP_Cls.SqlInsert = "UPDATE t_VendorSourceList " +
"SET Fix = @Fix " +
"WHERE (VendorCode = @VendorCode) AND (MaterialCode = @MaterialCode)";
cmdEdit.Parameters.Add("@VendorCode", SqlDbType.NVarChar, 10);
cmdEdit.Parameters.Add("@MaterialCode", SqlDbType.NVarChar, 15);
cmdEdit.Parameters.Add("@Fix", SqlDbType.Bit);
for (Int32 i = 0; i < this.dgvView.RowCount; i++)
{
cmdEdit.Parameters["@VendorCode"].Value = this.dgvView["clnVendorCode", i].Value.ToString();
cmdEdit.Parameters["@MaterialCode"].Value = this.txtMaterialCode.Text.Trim();
cmdEdit.Parameters["@Fix"].Value = ((bool)this.dgvView["clnFix", i].Value);
cmdEdit.Connection = oConn; cmdEdit.CommandText = NP_Cls.SqlInsert; cmdEdit.Transaction = Tr;
cmdEdit.ExecuteNonQuery();
}
Tr.Commit();
DGV(string.Empty); NP.MSGB(NP_Cls.NPMgsStyle.InfoType, "Save Change Completed !!"); this.txtMaterialCode.Select();
}
catch (Exception ex)
{
if (oConn.State == ConnectionState.Open)
{
Tr.Rollback();
}
NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Save : " + ex.Message); return;
}
finally
{
if (oConn.State == ConnectionState.Open)
{
oConn.Close();
}
}
}
else
{
return;
}
}
private void deleteToolStripMenuItem_Click(object sender, EventArgs e)
{
if (this.dgvView.RowCount == 0)
{
NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Data Not Found !!"); return;
}
if (NP.MSGB("Do you want to delete BOM ?") == DialogResult.Yes)
{
oConn = new SqlConnection(NP.ReadFileDB(NP_Cls.PathDB));
if (oConn.State == ConnectionState.Open)
{
oConn.Close();
}
oConn.Open(); SqlTransaction Tr; Tr = oConn.BeginTransaction();
try
{
SqlCommand cmdDel = new SqlCommand();
NP_Cls.SqlDel = "DELETE FROM t_BOM WHERE (BOMCode = @BOMCode)";
cmdDel.Parameters.Add("@BOMCode", SqlDbType.Int).Value = Convert.ToInt32(this.dgvView["clnBOMCode", this.dgvView.CurrentRow.Index].Value.ToString());
cmdDel.Connection = oConn; cmdDel.CommandText = NP_Cls.SqlDel; cmdDel.Transaction = Tr;
cmdDel.ExecuteNonQuery();
NP_Cls.SqlDel = "DELETE FROM t_BOMDetail WHERE (BOMCode = @BOMCode)";
//cmdDel.Parameters.Add("@BOMCode", SqlDbType.Int).Value = Convert.ToInt32(this.dgvView["clnBOMCode", this.dgvView.CurrentRow.Index].Value.ToString());
cmdDel.Connection = oConn; cmdDel.CommandText = NP_Cls.SqlDel; cmdDel.Transaction = Tr;
cmdDel.ExecuteNonQuery();
if (NP._TRanSave(oConn, Tr, NP_Cls.NPTranType.Delete, "t_BOM:t_BOMDetail", NP_Cls.strUsr))
{
Tr.Commit();
DGV(); NP.MSGB(NP_Cls.NPMgsStyle.InfoType, "Delete Completed !!");
}
else
{
NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Try agian !!"); return;
}
}
catch (Exception ex)
{
if (oConn.State == ConnectionState.Open)
{
Tr.Rollback();
}
NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Delete : " + ex.Message); return;
}
finally
{
if (oConn.State == ConnectionState.Open)
{
oConn.Close();
}
}
}
else
{
return;
}
}
private void deleteToolStripMenuItem_Click(object sender, EventArgs e)
{
if (NP.MSGB("Do you want to delete ?") == DialogResult.Yes)
{
if (this.dgvView.RowCount == 0)
{
NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Data Not Found !!"); return;
}
oConn = new SqlConnection(NP.ReadFileDB(NP_Cls.PathDB));
if (oConn.State == ConnectionState.Open)
{
oConn.Close();
}
oConn.Open(); SqlTransaction Tr; Tr = oConn.BeginTransaction();
try
{
SqlCommand cmdEdit = new SqlCommand();
NP_Cls.SqlDel = "DELETE FROM t_VendorInfoRecordPeriodsDetail WHERE (ValidPeriodDetailCode = @ValidPeriodDetailCode) AND (ValidPeriodCode = @ValidPeriodCode)";
cmdEdit.Parameters.Add("@ValidPeriodDetailCode", SqlDbType.Int).Value = this.dgvView[0, this.dgvView.CurrentRow.Index].Value.ToString();
cmdEdit.Parameters.Add("@ValidPeriodCode", SqlDbType.Int).Value = this.dgvView[1, this.dgvView.CurrentRow.Index].Value.ToString();
cmdEdit.Connection = oConn; cmdEdit.CommandText = NP_Cls.SqlDel; cmdEdit.Transaction = Tr;
cmdEdit.ExecuteNonQuery();
if (NP._TRanSave(oConn, Tr, NP_Cls.NPTranType.Delete, "t_VendorInfoRecordPeriodsDetail", NP_Cls.strUsr))
{
Tr.Commit();
Clear(); DGV(); NP.MSGB(NP_Cls.NPMgsStyle.InfoType, "Delete Data Completed !!");
this.btnAdd.Visible = true; this.btnEdit.Visible = false; this.txtScaleQty.Select();
}
else
{
NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Try agian !!"); return;
}
}
catch (Exception ex)
{
if (oConn.State == ConnectionState.Open)
{
Tr.Rollback();
}
NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Delete : " + ex.Message); return;
}
finally
{
if (oConn.State == ConnectionState.Open)
{
oConn.Close();
}
}
}
else
{
return;
}
}
/// <summary>
/// Metodo para atualizar dados de clientes na base de dados
/// </summary>
/// <param name="c">Entidade Cliente</param>
public void Update(Cliente c)
{
try
{
OpenConnection();
Tr = Con.BeginTransaction();
string queryCliente = "Update Cliente " +
"set " +
"Nome = @Nome, " +
"Rg = @Rg, " +
"Cpf = @Cpf " +
"where " +
"IdCliente = @IdCliente";
Cmd = new SqlCommand(queryCliente, Con, Tr);
Cmd.Parameters.AddWithValue("@Nome", c.Nome);
Cmd.Parameters.AddWithValue("@Rg", c.Rg);
Cmd.Parameters.AddWithValue("@Cpf", c.Cpf);
Cmd.Parameters.AddWithValue("@IdCliente", c.IdCliente);
Cmd.ExecuteNonQuery();
string queryEndereco = "Update Endereco " +
"set " +
"Descricao = @Descricao, " +
"Bairro = @Bairro, " +
"Cidade = @Cidade, " +
"Estado = @Estado, " +
"Cep = @Cep " +
"where " +
"IdCliente = @IdCliente";
Cmd = new SqlCommand(queryEndereco, Con, Tr);
Cmd.Parameters.AddWithValue("@Descricao", c.Endereco.Descricao);
Cmd.Parameters.AddWithValue("@Bairro", c.Endereco.Bairro);
Cmd.Parameters.AddWithValue("@Cidade", c.Endereco.Cidade);
Cmd.Parameters.AddWithValue("@Estado", c.Endereco.Estado);
Cmd.Parameters.AddWithValue("@Cep", c.Endereco.Cep);
Cmd.Parameters.AddWithValue("@IdCliente", c.IdCliente);
Cmd.ExecuteNonQuery();
Tr.Commit();
}
catch (Exception ex)
{
throw new Exception("Erro ao atualizar cliente. \n" + ex.Message);
}
finally
{
CloseConnection();
}
}
private void deleteToolStripMenuItem_Click(object sender, EventArgs e)
{
if (NP.MSGB("Do you want to delete ?") == DialogResult.Yes)
{
if (this.dgvView.RowCount == 0)
{
NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Data Not Found !!"); return;
}
oConn = new SqlConnection(NP.ReadFileDB(NP_Cls.PathDB));
if (oConn.State == ConnectionState.Open)
{
oConn.Close();
}
oConn.Open(); SqlTransaction Tr; Tr = oConn.BeginTransaction();
try
{
SqlCommand cmdEdit = new SqlCommand();
NP_Cls.SqlDel = "DELETE FROM t_VendorInfoRecord WHERE (VendorCode = @VendorCode) AND (MaterialCode = @MaterialCode)";
cmdEdit.Parameters.Add("@VendorCode", SqlDbType.NVarChar, 10).Value = this.dgvView[0, this.dgvView.CurrentRow.Index].Value.ToString();
cmdEdit.Parameters.Add("@MaterialCode", SqlDbType.NVarChar, 15).Value = this.dgvView[1, this.dgvView.CurrentRow.Index].Value.ToString();
cmdEdit.Connection = oConn; cmdEdit.CommandText = NP_Cls.SqlDel; cmdEdit.Transaction = Tr;
cmdEdit.ExecuteNonQuery();
NP_Cls.SqlDel = "DELETE FROM t_VendorSourceList WHERE (VendorCode = @VendorCode) AND (MaterialCode = @MaterialCode)";
cmdEdit.Connection = oConn; cmdEdit.CommandText = NP_Cls.SqlDel; cmdEdit.Transaction = Tr;
cmdEdit.ExecuteNonQuery();
Tr.Commit();
Clear(); DGV(); NP.MSGB(NP_Cls.NPMgsStyle.InfoType, "Delete Data Completed !!"); this.cbVendor.Select();
this.btnAdd.Visible = true; this.btnEdit.Visible = false; this.cbVendor.Enabled = true; this.cbMaterial.Enabled = true; this.cbVendor.Select();
}
catch (Exception ex)
{
if (oConn.State == ConnectionState.Open)
{
Tr.Rollback();
}
NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Delete : " + ex.Message); return;
}
finally
{
if (oConn.State == ConnectionState.Open)
{
oConn.Close();
}
}
}
else
{
return;
}
}
//Método para cadastrar Cliente e Endereco
public void Salvar(Cliente c)
{
try
{
AbrirConexao();
Tr = Con.BeginTransaction(); //iniciando uma transação
//gravando os dados do Cliente
Cmd = new SqlCommand("insert into Cliente(Nome, Email, DataCadastro) values(@v1, @v2, @v3)", Con, Tr);
Cmd.Parameters.AddWithValue("@v1", c.Nome);
Cmd.Parameters.AddWithValue("@v2", c.Email);
Cmd.Parameters.AddWithValue("@v3", c.DataCadastro);
Cmd.ExecuteNonQuery(); //executando
//resgatar o id do cliente que foi cadastrado
Cmd = new SqlCommand("select ident_current('Cliente') as Codigo", Con, Tr);
Dr = Cmd.ExecuteReader(); //executa e retorna registros
if (Dr.Read()) //verificando se o DataReader obteve algum registro
{
int Codigo = Convert.ToInt32(Dr["Codigo"]); //leitura do Id do Cliente
Dr.Close(); //fechando o DataReader
//gravando o endereço
Cmd = new SqlCommand("insert into Endereco(Logradouro, Cep, IdCliente) values(@v1, @v2, @v3)", Con, Tr);
Cmd.Parameters.AddWithValue("@v1", c.Residencia.Logradouro);
Cmd.Parameters.AddWithValue("@v2", c.Residencia.Cep);
Cmd.Parameters.AddWithValue("@v3", Codigo); //chave estrangeira
Cmd.ExecuteNonQuery(); //executar
}
else
{
throw new Exception(); //forçar um erro!
}
Tr.Commit(); //executando a transação
}
catch (Exception e)
{
Tr.Rollback(); //desfazer a transação
throw new Exception("Erro ao salvar cliente: " + e.Message);
}
finally
{
FecharConexao();
}
}
public void Excluir(int idFormulario, int idPergunta)
{
try
{
AbrirConexao();
Tr = Con.BeginTransaction();
Cmd = new SqlCommand("DELETE FROM Formulario.PerguntasPorFormularios WHERE IdFormulario = " + idFormulario + " and IdPergunta =" + idPergunta, Con, Tr);
Cmd.ExecuteNonQuery();
Tr.Commit();
}
catch (Exception ex)
{
if (Tr != null)
{
Tr.Rollback(); // Desfaz a transação..
}
throw new Exception("Não foi possível remover a pergunta: " + ex.Message);
}
}
/// <summary>
/// Metodo utilizado para cadastrar cliente na base de dados
/// </summary>
/// <param name="c">Entidade Cliente</param>
public void Inert(Cliente c)
{
try
{
OpenConnection();
Tr = Con.BeginTransaction();
string queryCliente = "Insert into Cliente (Nome, Rg, Cpf, DataCadastro) " +
"values (@v1, @v2, @v3, GetDate()) " +
"select scope_identity()";
Cmd = new SqlCommand(queryCliente, Con, Tr);
Cmd.Parameters.AddWithValue("@v1", c.Nome);
Cmd.Parameters.AddWithValue("@v2", c.Rg);
Cmd.Parameters.AddWithValue("@v3", c.Cpf);
c.IdCliente = Convert.ToInt32(Cmd.ExecuteScalar());
string queryEndereco = "Insert into Endereco (Descricao, Bairro, Cidade, Estado, Cep, IdCliente) " +
"values (@v4, @v5, @v6, @v7, @v8, @v9)";
Cmd = new SqlCommand(queryEndereco, Con, Tr);
Cmd.Parameters.AddWithValue("@v4", c.Endereco.Descricao);
Cmd.Parameters.AddWithValue("@v5", c.Endereco.Bairro);
Cmd.Parameters.AddWithValue("@v6", c.Endereco.Cidade);
Cmd.Parameters.AddWithValue("@v7", c.Endereco.Estado);
Cmd.Parameters.AddWithValue("@v8", c.Endereco.Cep);
Cmd.Parameters.AddWithValue("@v9", c.IdCliente);
Cmd.ExecuteNonQuery();
Tr.Commit();
}
catch (Exception ex)
{
throw new Exception("Erro ao cadastrar cliente na base de dados. \n" + ex.Message);
}
finally
{
CloseConnection();
}
}
public void Excluir(int id)
{
try
{
AbrirConexao();
Tr = Con.BeginTransaction();
Cmd = new SqlCommand("DELETE FROM Formulario.Perguntas WHERE IdPergunta = @v1", Con, Tr);
Cmd.Parameters.AddWithValue("@v1", id);
Cmd.ExecuteNonQuery();
Tr.Commit();
}
catch (Exception)
{
if (Tr != null)
{
Tr.Rollback(); // Desfaz a transação..
}
throw new Exception("Erro: Pergunta pertence a algum formulário!");
}
}
private void btnClosePO_Click(object sender, EventArgs e)
{
if (NP.MSGB("Do you want Close Purchase Order ?") == DialogResult.Yes)
{
oConn = new SqlConnection(NP.ReadFileDB(Application.StartupPath + @"\DB\DB.ini"));
if (oConn.State == ConnectionState.Open)
{
oConn.Close();
}
oConn.Open(); SqlTransaction Tr;
Tr = oConn.BeginTransaction();
try
{
SqlCommand cmdUp = new SqlCommand();
NP_Cls.sqlUpdate = "UPDATE t_PO SET ClosePO = 'C', ClosePOUser = @strUser, ClosePODate = GETDATE() WHERE (PONumber = @PONumber)";
cmdUp.Parameters.Add("@strUser", SqlDbType.NVarChar, 50).Value = NP_Cls.strUsr;
cmdUp.Parameters.Add("@PONumber", SqlDbType.NVarChar, 50).Value = this.txtPR.Text.Trim();
cmdUp.Connection = oConn; cmdUp.CommandText = NP_Cls.sqlUpdate; cmdUp.Transaction = Tr;
cmdUp.ExecuteNonQuery();
//cmdUp.Parameters.Add("@refPR", SqlDbType.NVarChar, 20); cmdUp.Parameters.Add("@TranID", SqlDbType.NVarChar, 100);
//for (int k = 0; k < this.dgvView.RowCount; k++)
//{
// NP_Cls.SqlSelect = "SELECT TranID FROM t_MRPTranOrder WHERE (TranOrder = @refPR)";
// cmdUp.Parameters["@refPR"].Value = this.dgvView[9, k].Value.ToString(); cmdUp.Parameters["@TranID"].Value = string.Empty;
// cmdUp.Connection = oConn; cmdUp.CommandText = NP_Cls.SqlSelect; cmdUp.Transaction = Tr;
// SqlDataAdapter da = new SqlDataAdapter(cmdUp); DataSet dsTran = new DataSet(); da.Fill(dsTran); string strTmpID = string.Empty;
// if (dsTran.Tables[0].Rows.Count > 0)
// {
// strTmpID = dsTran.Tables[0].Rows[0][0].ToString();
// }
// else { strTmpID = string.Empty; }
// if (!string.IsNullOrEmpty(strTmpID))
// {
// NP_Cls.sqlUpdate = "UPDATE t_MRPTranOrder SET TranOrder = @PONumber WHERE (TranID = @TranID)";
// cmdUp.Parameters["@TranID"].Value = strTmpID; cmdUp.Parameters["@refPR"].Value = string.Empty;
// cmdUp.Connection = oConn; cmdUp.CommandText = NP_Cls.sqlUpdate; cmdUp.Transaction = Tr;
// cmdUp.ExecuteNonQuery();
// }
//}
Tr.Commit();
Clear(); this.txtPR.DropDownStyle = ComboBoxStyle.Simple; this.cbVendor.Enabled = true;
this.groupPR.Enabled = true; this.btnAddPR.Visible = true; this.btnSave.Visible = false; this.cbMaterial.Text = string.Empty; this.cbMaterial.DataSource = null;
this.dsPR.Tables.Clear(); this.MyGrid(dgvView); this.txtPR.Text = GetNumber(); this.btnAppr.Visible = false;
this.cbVendor.Text = string.Empty; this.cbVendor.Select();
}
catch (Exception ex)
{
NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Close PO : " + ex.Message); return;
}
finally
{
if (oConn.State == ConnectionState.Open)
{
oConn.Close();
}
}
}
else
{
return;
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (this.dgvView.RowCount == 0)
{
NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Please select material into GI list !!"); this.cbMaterial.Select(); return;
}
this.dgvView.EndEdit(); this.dgvView.Sort(this.dgvView.Columns["clnMaterialCode"], ListSortDirection.Ascending);
for (byte ii = 0; ii < this.dgvView.RowCount; ii++)
{
if (Convert.ToDouble(this.dgvView["clnQuantity", ii].Value) == 0)
{
NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Quantity for GI must more than 0 !!"); return;
}
}
this.dgvView.EndEdit(); this.lessStock = 0; double dTmp = 0;
DataTable dtTmp = new DataTable(); dtTmp = this.dsPR.Tables[0].Clone();
dtTmp.Columns.Remove("ItemNo"); dtTmp.Columns.Remove("UnitCode"); dtTmp.Columns.Remove("UnitName"); dtTmp.Columns.Remove("PlantCode");
dtTmp.Columns.Remove("PlantName"); dtTmp.Columns.Remove("LocCode"); dtTmp.Columns.Remove("LocName"); dtTmp.Columns.Remove("PrdONumber");
dtTmp.Columns.Remove("MaterialName"); dtTmp.Columns.Remove("BatchNumber");
Hashtable hsTmp = new Hashtable();
for (int mm = 0; mm < this.dgvView.RowCount; mm++)
{
try
{
hsTmp.Add(this.dsPR.Tables[0].Rows[mm]["MaterialCode"].ToString(), dsPR.Tables[0].Compute("SUM(Qty)", "MaterialCode = " + dsPR.Tables[0].Rows[mm]["MaterialCode"].ToString()));
DataRow dr; dr = dtTmp.NewRow();
dr[0] = this.dsPR.Tables[0].Rows[mm]["MaterialCode"].ToString(); dr[1] = hsTmp[this.dsPR.Tables[0].Rows[mm]["MaterialCode"].ToString()];
dr[2] = Convert.ToDouble(this.dsPR.Tables[0].Rows[mm]["PrdOQty"]); dr[3] = dsPR.Tables[0].Compute("SUM(QI)", "MaterialCode = " + dsPR.Tables[0].Rows[mm]["MaterialCode"].ToString()); dtTmp.Rows.Add(dr);
}
catch
{ }
}
dtTmp.AcceptChanges();
for (int ii = 0; ii < dtTmp.Rows.Count; ii++)
{
if (Convert.ToDouble(dtTmp.Rows[ii]["Qty"]) > Convert.ToDouble(dtTmp.Rows[ii]["PrdOQty"]))
{
NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Mat.Code : " + this.dgvView["clnMaterialCode", ii].Value.ToString() + " is over Prod.Order Qty !!\nCan not GI. !!"); return;
}
else
{
if (Convert.ToDouble(dtTmp.Rows[ii]["Qty"]) > Convert.ToDouble(dtTmp.Rows[ii]["QI"]))
{
NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Mat.Code : " + this.dgvView["clnMaterialCode", ii].Value.ToString() + " is over Stock !!\nCan not GI. !!"); return;
}
else if (Convert.ToDouble(dtTmp.Rows[ii]["QI"]) == 0)
{
NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Mat.Code : " + this.dgvView["clnMaterialCode", ii].Value.ToString() + " Stock is 0 !!\nCan not GI. !!"); return;
}
else if (Convert.ToDouble(dtTmp.Rows[ii]["Qty"]) < Convert.ToDouble(dtTmp.Rows[ii]["QI"]))
{
this.lessStock = 1;
}
}
}
string strQuestion = string.Empty;
if (this.lessStock == 0)
{
strQuestion = "Do you want to Save Delivery Order ?";
}
else
{
strQuestion = "Do you want to Save Delivery Order with less stock Material ?";
}
if (NP.MSGB("Do you to Save Goods Issue ?") == DialogResult.Yes)
{
oConn = new SqlConnection(NP.ReadFileDB(NP_Cls.PathDB));
if (oConn.State == ConnectionState.Open)
{
oConn.Close();
}
oConn.Open(); SqlTransaction Tr;
Tr = oConn.BeginTransaction();
try
{
SqlCommand cmdIns = new SqlCommand();
NP_Cls.SqlInsert = "INSERT INTO t_StockMovementDetail " +
"(AutoID, DocNumber, MaterialCode, MaterialName, Quantity, UnitCode, UnitName, PlantCode, PlantName, LocCode, LocName, CurrentUser, RefNumber, BatchNumber) " +
"VALUES (@ID, @GINumber,@MaterialCode,@MaterialName,@GIQuantity,@UnitCode,@UnitName,@PlantCode,@PlantName,@LocCode,@LocName,@CurrentUser,@PrdONumber, @BatchNumber)";
cmdIns.Parameters.Add("@ID", SqlDbType.Int);
cmdIns.Parameters.Add("@GINumber", SqlDbType.NVarChar, 12);
cmdIns.Parameters.Add("@MaterialCode", SqlDbType.NVarChar, 15);
cmdIns.Parameters.Add("@MaterialName", SqlDbType.NVarChar, 60);
cmdIns.Parameters.Add("@GIQuantity", SqlDbType.Decimal);
cmdIns.Parameters.Add("@UnitCode", SqlDbType.NVarChar, 3);
cmdIns.Parameters.Add("@UnitName", SqlDbType.NVarChar, 20);
cmdIns.Parameters.Add("@PlantCode", SqlDbType.NVarChar, 4);
cmdIns.Parameters.Add("@PlantName", SqlDbType.NVarChar, 20);
cmdIns.Parameters.Add("@LocCode", SqlDbType.NVarChar, 2);
cmdIns.Parameters.Add("@LocName", SqlDbType.NVarChar, 20);
cmdIns.Parameters.Add("@CurrentUser", SqlDbType.NVarChar, 50); cmdIns.Parameters.Add("@BatchNumber", SqlDbType.NVarChar, 10);
cmdIns.Parameters.Add("@PrdONumber", SqlDbType.NVarChar, 12); cmdIns.Parameters.Add("@MRPOrder", SqlDbType.NVarChar, 12);
cmdIns.Parameters.Add("@IsGIClose", SqlDbType.Bit); cmdIns.Parameters.Add("@MatHead", SqlDbType.NVarChar, 15);
for (byte ins = 0; ins < this.dgvView.RowCount; ins++)
{
cmdIns.Parameters["@ID"].Value = ins + 1;
cmdIns.Parameters["@GINumber"].Value = this.strGNumber;
cmdIns.Parameters["@MaterialCode"].Value = this.dgvView["clnMaterialCode", ins].Value.ToString();
cmdIns.Parameters["@MaterialName"].Value = this.dgvView["clnMaterialName", ins].Value.ToString();
cmdIns.Parameters["@GIQuantity"].Value = Convert.ToDouble(this.dgvView["clnQuantity", ins].Value);
cmdIns.Parameters["@UnitCode"].Value = this.dgvView["clnUnitCode", ins].Value.ToString();
cmdIns.Parameters["@UnitName"].Value = this.dgvView["clnUnitName", ins].Value.ToString();
cmdIns.Parameters["@CurrentUser"].Value = NP_Cls.strUsr;
cmdIns.Parameters["@PlantCode"].Value = this.dgvView["clnPlantCode", ins].Value.ToString();
cmdIns.Parameters["@PlantName"].Value = this.dgvView["clnPlantName", ins].Value.ToString();
cmdIns.Parameters["@LocCode"].Value = this.dgvView["clnLocCode", ins].Value.ToString();
cmdIns.Parameters["@LocName"].Value = this.dgvView["clnLocName", ins].Value.ToString();
cmdIns.Parameters["@PrdONumber"].Value = this.cbPrdoOrder.Text.Trim();
cmdIns.Parameters["@IsGIClose"].Value = 0; cmdIns.Parameters["@MRPOrder"].Value = strMRP;
cmdIns.Parameters["@MatHead"].Value = this.lblHeadMaterial.Text.Trim().Split(':')[0].ToString();
cmdIns.Parameters["@BatchNumber"].Value = this.dgvView["clnBatchNumber", ins].Value.ToString();
cmdIns.Connection = oConn; cmdIns.CommandText = NP_Cls.SqlInsert; cmdIns.Transaction = Tr;
cmdIns.ExecuteNonQuery();
// Update Stock
NP_Cls.sqlUpdate = "UPDATE t_StockOverview SET QI = QI - @GIQuantity WHERE (BatchNumber = @BatchNumber)";
cmdIns.Connection = oConn; cmdIns.CommandText = NP_Cls.sqlUpdate; cmdIns.Transaction = Tr;
cmdIns.ExecuteNonQuery();
//TODO 22.11.10 Prd Order from MRP
if (!string.IsNullOrEmpty(strMRP))
{
string strTR = "INSERT INTO t_MRPTranOrder (MaterialCode,TranOrder,TranQty,SONumber,IsComponent,MaterialHeader) VALUES (@MaterialCode,@GINumber,@GIQuantity,@MRPOrder,1,@MatHead)";
cmdIns.CommandText = strTR; cmdIns.Connection = oConn;
cmdIns.Transaction = Tr; cmdIns.ExecuteNonQuery();
}
//
}
// NP_Cls.sqlUpdate = "UPDATE t_PrdOrderDetail SET GIQty = GIQty + @GIQuantity, IsGIClose = @IsGIClose WHERE (PrdONumber = @PrdONumber) AND (ComponentCode = @MaterialCode)";
SqlCommand cmdSP = new SqlCommand();
cmdSP.Parameters.Add("@PrdOQty", SqlDbType.Decimal); cmdSP.Parameters.Add("@MaterialCode", SqlDbType.NVarChar, 15);
cmdSP.Parameters.Add("@GIQuantity", SqlDbType.Decimal); cmdSP.Parameters.Add("@IsGIClose", SqlDbType.Bit); cmdSP.Parameters.Add("@PrdONumber", SqlDbType.NVarChar, 12);
for (byte up = 0; up < this.dgvView.RowCount; up++)
{
cmdSP.Parameters["@MaterialCode"].Value = this.dgvView["clnMaterialCode", up].Value.ToString();
cmdSP.Parameters["@GIQuantity"].Value = Convert.ToDouble(this.dgvView["clnQuantity", up].Value);
cmdSP.Parameters["@IsGIClose"].Value = 0; //(Convert.ToDouble(this.dgvView["clnQuantity", up].Value) == ? 1 : 0);
cmdSP.Parameters["@PrdOQty"].Value = Convert.ToDouble(this.dgvView["clnPrdOQty", up].Value);
cmdSP.Parameters["@PrdONumber"].Value = this.cbPrdoOrder.Text.Trim();
cmdSP.Connection = oConn; cmdSP.CommandType = CommandType.StoredProcedure; cmdSP.CommandText = "sp_GI_Save"; cmdSP.Transaction = Tr;
cmdSP.ExecuteNonQuery();
}
NP_Cls.SqlSelect = "SELECT IsGIClose FROM t_PrdOrderDetail WHERE (PrdONumber = @PrdONumber)";
cmdIns.Connection = oConn; cmdIns.CommandText = NP_Cls.SqlSelect; cmdIns.Transaction = Tr;
SqlDataAdapter da = new SqlDataAdapter(cmdIns); DataSet ds = new DataSet(); da.Fill(ds); bool bTmp = true;
for (int cp = 0; cp < ds.Tables[0].Rows.Count; cp++)
{
bTmp = bTmp && Convert.ToBoolean(ds.Tables[0].Rows[cp][0]);
}
NP_Cls.sqlUpdate = "UPDATE t_PrdOrder SET IsGI = @IsGI WHERE (PrdONumber = @PrdONumber)";
cmdIns.Parameters.Add("@IsGI", SqlDbType.Bit).Value = bTmp;
cmdIns.Connection = oConn; cmdIns.CommandText = NP_Cls.sqlUpdate; cmdIns.Transaction = Tr;
cmdIns.ExecuteNonQuery();
Tr.Commit(); NP.MSGB(NP_Cls.NPMgsStyle.InfoType, "Save Goods Issue Completed !!");
Clear();
this.groupPR.Enabled = true; this.btnAddGI.Visible = true; this.btnSave.Visible = false; this.cbMaterial.Text = string.Empty; this.cbMaterial.DataSource = null;
this.dsPR.Tables.Clear(); this.MyGrid(dgvView); this.txtGI.Text = GetNumber();
NP_Cls.SqlSelect = "SELECT MaterialCode + ':' + MaterialName AS MatCode, PrdONumber FROM t_PrdOrder WHERE (IsGI = 0)";
NP.BindCB(this.cbPrdoOrder, NP_Cls.SqlSelect, "MatCode", "PrdONumber", "((( Select Prd Number )))");
this.cbPrdoOrder.Text = string.Empty; this.cbPrdoOrder.Select();
}
catch (Exception ex)
{
if (oConn.State == ConnectionState.Open)
{
Tr.Rollback();
}
NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Add Detail : " + ex.Message); return;
}
finally
{
if (oConn.State == ConnectionState.Open)
{
oConn.Close();
}
}
}
else
{
return;
}
}
private void toolStripMenuItem1_Click(object sender, EventArgs e)
{
if (NP_Cls.AppPR == 0)
{
NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "You have not Permission to Approve B.O.M. !!"); return;
}
if (this.dgvView.RowCount == 0)
{
NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Data Not Found to Approve !!"); return;
}
if (this.lblAppr.Text.Trim().ToUpper() == "TRUE")
{
NP.MSGB(NP_Cls.NPMgsStyle.InfoType, "This BOM is Approve already !!"); return;
}
if (NP.MSGB("Do you want to Approve this BOM ?") == DialogResult.Yes)
{
oConn = new SqlConnection(NP.ReadFileDB(NP_Cls.PathDB));
if (oConn.State == ConnectionState.Open)
{
oConn.Close();
}
oConn.Open(); SqlTransaction Tr; Tr = oConn.BeginTransaction();
try
{
SqlCommand cmdEdit = new SqlCommand();
NP_Cls.sqlUpdate = "UPDATE t_BOM SET Approve = @Appr, ApproveUser = @AUSER WHERE (BOMCode = @BOMCode)";
cmdEdit.Parameters.Add("@BOMCode", SqlDbType.Int).Value = Convert.ToInt32(this.dgvView["clnBOMCode", this.dgvView.CurrentRow.Index].Value);
cmdEdit.Parameters.Add("@Appr", SqlDbType.Bit).Value = 1; cmdEdit.Parameters.Add("@AUSER", SqlDbType.NVarChar, 10).Value = NP_Cls.strUsr;
cmdEdit.Connection = oConn; cmdEdit.CommandText = NP_Cls.sqlUpdate; cmdEdit.Transaction = Tr;
cmdEdit.ExecuteNonQuery();
if (NP._TRanSave(oConn, Tr, NP_Cls.NPTranType.Update, "t_BOM:Approve", NP_Cls.strUsr))
{
Tr.Commit(); Clear();
DGV(); NP.MSGB(NP_Cls.NPMgsStyle.InfoType, "Approve Completed !!");
this.btnAdd.Visible = true; this.btnEdit.Visible = false;
}
else
{
NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Try Again !!"); return;
}
}
catch (Exception ex)
{
if (oConn.State == ConnectionState.Open)
{
Tr.Rollback();
}
NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Approve : " + ex.Message); return;
}
finally
{
if (oConn.State == ConnectionState.Open)
{
oConn.Close();
}
}
}
else
{
return;
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (this.dgvView.RowCount == 0)
{
NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Please select material into PO list !!"); this.cbMaterial.Select(); return;
}
this.dgvView.EndEdit();
for (byte ii = 0; ii < this.dgvView.RowCount; ii++)
{
if (Convert.ToInt32(this.dgvView["clnQuantity", ii].Value) == 0)
{
NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Quantity for purchase more than 0 !!"); return;
}
}
if (NP.MSGB("Do you to Save Purchase Order ?") == DialogResult.Yes)
{
oConn = new SqlConnection(NP.ReadFileDB(Application.StartupPath + @"\DB\DB.ini"));
if (oConn.State == ConnectionState.Open)
{
oConn.Close();
}
oConn.Open(); SqlTransaction Tr;
Tr = oConn.BeginTransaction();
try
{
SqlCommand cmdIns = new SqlCommand();
NP_Cls.SqlInsert = "INSERT INTO t_PODetail (PONumber, MaterialCode, MaterialName, POQuantity, UnitCode, UnitName, NetPrice, POAmount, DeliveryDate, PlantCode, PlantName, LocCode, LocName, CurrentUser, PRNumber) " +
"VALUES (@PONumber,@MaterialCode,@MaterialName,@POQuantity,@UnitCode,@UnitName,@NetPrice,@POAmount,@DeliveryDate,@PlantCode,@PlantName,@LocCode,@LocName,@CurrentUser,@refPR)";
cmdIns.Parameters.Add("@PONumber", SqlDbType.NVarChar, 12);
cmdIns.Parameters.Add("@MaterialCode", SqlDbType.NVarChar, 15);
cmdIns.Parameters.Add("@MaterialName", SqlDbType.NVarChar, 60);
cmdIns.Parameters.Add("@POQuantity", SqlDbType.Decimal);
cmdIns.Parameters.Add("@UnitCode", SqlDbType.NVarChar, 3);
cmdIns.Parameters.Add("@UnitName", SqlDbType.NVarChar, 20);
cmdIns.Parameters.Add("@NetPrice", SqlDbType.Decimal);
cmdIns.Parameters.Add("@POAmount", SqlDbType.Decimal);
cmdIns.Parameters.Add("@DeliveryDate", SqlDbType.DateTime);
cmdIns.Parameters.Add("@PlantCode", SqlDbType.NVarChar, 4);
cmdIns.Parameters.Add("@PlantName", SqlDbType.NVarChar, 20);
cmdIns.Parameters.Add("@LocCode", SqlDbType.NVarChar, 2);
cmdIns.Parameters.Add("@LocName", SqlDbType.NVarChar, 20);
cmdIns.Parameters.Add("@CurrentUser", SqlDbType.NVarChar, 50);
cmdIns.Parameters.Add("@refPR", SqlDbType.NVarChar, 12);
for (byte ins = 0; ins < this.dgvView.RowCount; ins++)
{
cmdIns.Parameters["@PONumber"].Value = this.strGNumber;
cmdIns.Parameters["@MaterialCode"].Value = this.dgvView["clnMaterialCode", ins].Value.ToString();
cmdIns.Parameters["@MaterialName"].Value = this.dgvView["clnMaterialName", ins].Value.ToString();
cmdIns.Parameters["@POQuantity"].Value = Convert.ToDouble(this.dgvView["clnQuantity", ins].Value);
cmdIns.Parameters["@UnitCode"].Value = this.dgvView["clnUnitCode", ins].Value.ToString();
cmdIns.Parameters["@UnitName"].Value = this.dgvView["clnUnitName", ins].Value.ToString();
cmdIns.Parameters["@NetPrice"].Value = Convert.ToDouble(this.dgvView["clnNetPrice", ins].Value);
cmdIns.Parameters["@POAmount"].Value = Convert.ToDouble(this.dgvView["clnAmount", ins].Value);
cmdIns.Parameters["@CurrentUser"].Value = NP_Cls.strUsr;
cmdIns.Parameters["@DeliveryDate"].Value = Convert.ToDateTime(this.dgvView["clnDeliveryDate", ins].Value);
cmdIns.Parameters["@PlantCode"].Value = this.dgvView["clnPlantCode", ins].Value.ToString();
cmdIns.Parameters["@PlantName"].Value = this.dgvView["clnPlantName", ins].Value.ToString();
cmdIns.Parameters["@LocCode"].Value = this.dgvView["clnLocCode", ins].Value.ToString();
cmdIns.Parameters["@LocName"].Value = this.dgvView["clnLocName", ins].Value.ToString();
cmdIns.Parameters["@refPR"].Value = this.dgvView["clnPRNumber", ins].Value.ToString();
cmdIns.Connection = oConn; cmdIns.CommandText = NP_Cls.SqlInsert; cmdIns.Transaction = Tr;
cmdIns.ExecuteNonQuery();
}
cmdIns.Parameters.Add("@AutoID", SqlDbType.Int);
NP_Cls.sqlUpdate = "UPDATE t_PRDetail SET isPO = 1 WHERE (PRNumber = @refPR) AND (MaterialCode = @MaterialCode) AND (AutoID = @AutoID)";
for (byte upd = 0; upd < this.dgvView.RowCount; upd++)
{
cmdIns.Parameters["@refPR"].Value = this.dgvView["clnPRNumber", upd].Value.ToString();
cmdIns.Parameters["@MaterialCode"].Value = this.dgvView["clnMaterialCode", upd].Value.ToString();
cmdIns.Parameters["@AutoID"].Value = this.dgvView["AutoID", upd].Value.ToString();
cmdIns.Connection = oConn; cmdIns.CommandText = NP_Cls.sqlUpdate; cmdIns.Transaction = Tr;
cmdIns.ExecuteNonQuery();
}
Tr.Commit(); NP.MSGB(NP_Cls.NPMgsStyle.InfoType, "Save Purchase Order Completed !!");
Clear();
this.groupPR.Enabled = true; this.btnAddPR.Visible = true; this.btnSave.Visible = false; this.cbMaterial.Text = string.Empty; this.cbMaterial.DataSource = null;
this.dsPR.Tables.Clear(); this.MyGrid(dgvView); this.txtPR.Text = GetNumber();
BindVendor();
this.cbVendor.Text = string.Empty; this.cbVendor.Select();
}
catch (Exception ex)
{
if (oConn.State == ConnectionState.Open)
{
Tr.Rollback();
}
NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Add Detail : " + ex.Message); return;
}
finally
{
if (oConn.State == ConnectionState.Open)
{
oConn.Close();
}
}
}
else
{
return;
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
//if (NP.ReqField(this.cbVendor, "Please enter Vendor: !!") == false) { return; }
//if (NP.ReqField(this.cbMaterial, "Please enter Material: !!") == false) { return; }
if ((string.IsNullOrEmpty((this.cbVendor.Text.Trim()))) || (this.cbVendor.Text.Trim() == "((( Select Vendor )))"))
{
NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Please enter Vendor: !!"); this.cbVendor.Select(); return;
}
if ((string.IsNullOrEmpty((this.cbMaterial.Text.Trim()))) || (this.cbMaterial.Text.Trim() == "((( Select Material )))"))
{
NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Please enter Material: !!"); this.cbMaterial.Select(); return;
}
//if (NP.ReqField(this.cbPG, "Please enter Purchasing group: !!") == false) { return; }
if (NP.ReqField(this.txtDelivery, "Please enter Delivery time: !!") == false)
{
return;
}
if (NP.ReqField(this.txtMinQty, "Please enter Minimum Qty.: !!") == false)
{
return;
}
if (NP.ReqField(this.txtNetPrice, "Please enter Net Price: !!") == false)
{
return;
}
if (NP.ReqField(this.cbOrderUnit, "Please enter Order Unit: !!") == false)
{
return;
}
if (NP.ReqField(this.txtQtyCon, "Please enter Qty.Conversion: !!") == false)
{
return;
}
if (ChkDup())
{
NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Code Duplicated !!"); this.cbVendor.Select(); return;
}
if (NP.MSGB("Do you want to Add Data ?") == DialogResult.Yes)
{
oConn = new SqlConnection(NP.ReadFileDB(NP_Cls.PathDB));
if (oConn.State == ConnectionState.Open)
{
oConn.Close();
}
oConn.Open(); SqlTransaction Tr;
Tr = oConn.BeginTransaction();
try
{
SqlCommand cmdIns = new SqlCommand();
NP_Cls.SqlInsert = "INSERT INTO t_VendorInfoRecord " +
"(VendorCode, MaterialCode, DeliveryTime, MinimumQty, NetPrice, UnitCode, QtyConversion, Block) " +
"VALUES (@VendorCode,@MaterialCode,@DeliveryTime,@MinimumQty,@NetPrice,@UnitCode,@QtyConversion,@Block)";
cmdIns.Parameters.Add("@VendorCode", SqlDbType.NVarChar, 10).Value = this.cbVendor.SelectedValue;
cmdIns.Parameters.Add("@MaterialCode", SqlDbType.NVarChar, 15).Value = this.cbMaterial.SelectedValue;
//cmdIns.Parameters.Add("@PurchasingGroup", SqlDbType.NVarChar, 3).Value = this.cbPG.SelectedValue;
cmdIns.Parameters.Add("@DeliveryTime", SqlDbType.Int).Value = Convert.ToInt32(string.IsNullOrEmpty(this.txtDelivery.Text.Trim()) ? "0" : this.txtDelivery.Text.Trim());
cmdIns.Parameters.Add("@MinimumQty", SqlDbType.Decimal).Value = Convert.ToDecimal(string.IsNullOrEmpty(this.txtMinQty.Text.Trim()) ? "0" : this.txtMinQty.Text.Trim());
cmdIns.Parameters.Add("@NetPrice", SqlDbType.Decimal).Value = Convert.ToDecimal(string.IsNullOrEmpty(this.txtNetPrice.Text.Trim()) ? "0" : this.txtNetPrice.Text.Trim());
cmdIns.Parameters.Add("@UnitCode", SqlDbType.NVarChar, 3).Value = this.cbOrderUnit.SelectedValue;
cmdIns.Parameters.Add("@QtyConversion", SqlDbType.Int).Value = Convert.ToInt32(string.IsNullOrEmpty(this.txtQtyCon.Text.Trim()) ? "0" : this.txtQtyCon.Text.Trim());
cmdIns.Parameters.Add("@Block", SqlDbType.Bit).Value = this.chkBlock.Checked;
cmdIns.Connection = oConn; cmdIns.CommandText = NP_Cls.SqlInsert; cmdIns.Transaction = Tr;
cmdIns.ExecuteNonQuery();
NP_Cls.SqlInsert = "INSERT INTO t_VendorSourceList (VendorCode, MaterialCode, Fix) VALUES (@VendorCode,@MaterialCode,@Fix)";
cmdIns.Parameters.Add("@Fix", SqlDbType.Bit).Value = 0;
cmdIns.Connection = oConn; cmdIns.CommandText = NP_Cls.SqlInsert; cmdIns.Transaction = Tr;
cmdIns.ExecuteNonQuery();
Tr.Commit();
Clear(); DGV(); this.cbMaterial.Enabled = true; this.cbVendor.Enabled = true; this.btnAdd.Visible = true; this.btnEdit.Visible = false;
this.cbVendor.Text = string.Empty; this.cbMaterial.Text = string.Empty; this.cbVendor.Select();
NP.MSGB(NP_Cls.NPMgsStyle.InfoType, "Add Data Completed !!");
}
catch (Exception ex)
{
if (oConn.State == ConnectionState.Open)
{
Tr.Rollback();
}
NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Add : " + ex.Message); return;
}
finally
{
if (oConn.State == ConnectionState.Open)
{
oConn.Close();
}
}
}
else
{
return;
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (this.dgvView.RowCount == 0)
{
NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Please select GR number into GR list !!"); this.cbPONumber.Select(); return;
}
this.dgvView.EndEdit();
if (NP.MSGB("Do you to Save Goods Return ?") == DialogResult.Yes)
{
oConn = new SqlConnection(NP.ReadFileDB(NP_Cls.PathDB));
if (oConn.State == ConnectionState.Open)
{
oConn.Close();
}
oConn.Open(); SqlTransaction Tr;
Tr = oConn.BeginTransaction();
try
{
SqlCommand cmdIns = new SqlCommand();
NP_Cls.SqlInsert = "INSERT INTO t_GTDetail " +
"(GTNumber, MaterialCode, MaterialName, GTQuantity, UnitCode, UnitName, NetPrice, GTAmount, DeliveryDate, PlantCode, PlantName, LocCode, LocName, BatchNumber, CurrentUser, GRNumber, GRAutoID) " +
"VALUES (@GTNumber,@MaterialCode,@MaterialName,@GTQuantity,@UnitCode,@UnitName,@NetPrice,@GTAmount,@DeliveryDate,@PlantCode,@PlantName,@LocCode,@LocName,@BatchNumber,@CurrentUser,@GRNumber, @GRID)";
cmdIns.Parameters.Add("@GTNumber", SqlDbType.NVarChar, 12);
cmdIns.Parameters.Add("@MaterialCode", SqlDbType.NVarChar, 15);
cmdIns.Parameters.Add("@MaterialName", SqlDbType.NVarChar, 60);
cmdIns.Parameters.Add("@GTQuantity", SqlDbType.Decimal);
cmdIns.Parameters.Add("@UnitCode", SqlDbType.NVarChar, 3);
cmdIns.Parameters.Add("@UnitName", SqlDbType.NVarChar, 20);
cmdIns.Parameters.Add("@NetPrice", SqlDbType.Decimal);
cmdIns.Parameters.Add("@GTAmount", SqlDbType.Decimal);
cmdIns.Parameters.Add("@DeliveryDate", SqlDbType.DateTime);
cmdIns.Parameters.Add("@PlantCode", SqlDbType.NVarChar, 4);
cmdIns.Parameters.Add("@PlantName", SqlDbType.NVarChar, 20);
cmdIns.Parameters.Add("@LocCode", SqlDbType.NVarChar, 2);
cmdIns.Parameters.Add("@LocName", SqlDbType.NVarChar, 20);
cmdIns.Parameters.Add("@BatchNumber", SqlDbType.NVarChar, 20);
cmdIns.Parameters.Add("@GRNumber", SqlDbType.NVarChar, 12);
cmdIns.Parameters.Add("@CurrentUser", SqlDbType.NVarChar, 50);
cmdIns.Parameters.Add("@GRID", SqlDbType.Int);
for (byte ins = 0; ins < this.dgvView.RowCount; ins++)
{
if (Convert.ToInt32(this.dgvView[3, ins].Value) != 0)
{
cmdIns.Parameters["@GTNumber"].Value = this.strGNumber;
cmdIns.Parameters["@MaterialCode"].Value = this.dgvView[1, ins].Value.ToString();
cmdIns.Parameters["@MaterialName"].Value = this.dgvView[2, ins].Value.ToString();
cmdIns.Parameters["@GTQuantity"].Value = Convert.ToInt32(this.dgvView[3, ins].Value);
cmdIns.Parameters["@UnitCode"].Value = this.dgvView[5, ins].Value.ToString();
cmdIns.Parameters["@UnitName"].Value = this.dgvView[4, ins].Value.ToString();
cmdIns.Parameters["@NetPrice"].Value = Convert.ToInt32(this.dgvView[11, ins].Value);
cmdIns.Parameters["@GTAmount"].Value = Convert.ToInt32(this.dgvView[12, ins].Value);
cmdIns.Parameters["@DeliveryDate"].Value = Convert.ToDateTime(this.dgvView[9, ins].Value);
cmdIns.Parameters["@PlantCode"].Value = this.dgvView[6, ins].Value.ToString();
cmdIns.Parameters["@PlantName"].Value = this.dgvView[13, ins].Value.ToString();
cmdIns.Parameters["@LocCode"].Value = this.dgvView[7, ins].Value.ToString();
cmdIns.Parameters["@LocName"].Value = this.dgvView[14, ins].Value.ToString();
cmdIns.Parameters["@BatchNumber"].Value = this.dgvView[8, ins].Value.ToString();
cmdIns.Parameters["@GRNumber"].Value = this.dgvView[10, ins].Value.ToString();
cmdIns.Parameters["@CurrentUser"].Value = NP_Cls.strUsr;
cmdIns.Parameters["@GRID"].Value = this.dgvView[15, ins].Value.ToString();
cmdIns.Connection = oConn; cmdIns.CommandText = NP_Cls.SqlInsert; cmdIns.Transaction = Tr;
cmdIns.ExecuteNonQuery();
//NP_Cls.sqlUpdate = "UPDATE t_PODetail SET GRQuantity = @GRQuantity WHERE (PONumber = @PONumber) AND (AutoID = @POID)";
//cmdIns.Connection = oConn; cmdIns.CommandText = NP_Cls.sqlUpdate; cmdIns.Transaction = Tr;
//cmdIns.ExecuteNonQuery();
}
}
Tr.Commit(); NP.MSGB(NP_Cls.NPMgsStyle.InfoType, "Save Goods Return Completed !!");
Clear();
this.groupPR.Enabled = true; this.btnAddPR.Visible = true; this.btnSave.Visible = false; this.cbPONumber.Text = string.Empty; this.cbPONumber.DataSource = null;
this.MyGrid(dgvView); this.txtDoc.Text = GetNumber();
NP_Cls.SqlSelect = "SELECT DISTINCT VendorName, VendorCode FROM t_GR WHERE (MovementType = N'101')";
NP.BindCB(this.cbVendor, NP_Cls.SqlSelect, "VendorName", "VendorCode", "((( Select Vendor GR )))");
this.cbVendor.Text = string.Empty; this.cbVendor.Select();
}
catch (Exception ex)
{
if (oConn.State == ConnectionState.Open)
{
Tr.Rollback();
}
NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Add Detail : " + ex.Message); return;
}
finally
{
if (oConn.State == ConnectionState.Open)
{
oConn.Close();
}
}
}
else
{
return;
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
if ((string.IsNullOrEmpty((this.cbProdOrder.Text.Trim()))) || (this.cbProdOrder.Text.Trim() == "((( Select Production Order )))"))
{
NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Please select Production Order: !!"); this.cbProdOrder.Select(); return;
}
if ((string.IsNullOrEmpty((this.cbWorkCenter.Text.Trim()))) || (this.cbWorkCenter.Text.Trim() == "((( Select WorkCenter )))"))
{
NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Please select Work Center: !!"); this.cbWorkCenter.Select(); return;
}
if (!NP.ReqField(this.txtMachine, "Please enter Used Machine !!"))
{
return;
}
if (!NP.ReqField(this.txtSetup, "Please enter Used Setup !!"))
{
return;
}
if (!NP.ReqField(this.txtLabor, "Please enter Used Labor !!"))
{
return;
}
if (!NP.ReqField(this.txtOT, "Please enter Used OT !!"))
{
return;
}
if (NP.MSGB("Do you want to Close Production Order ?") == DialogResult.Yes)
{
oConn = new SqlConnection(NP.ReadFileDB(NP_Cls.PathDB));
if (oConn.State == ConnectionState.Open)
{
oConn.Close();
}
oConn.Open(); SqlTransaction Tr; Tr = oConn.BeginTransaction();
try
{
SqlCommand cmdIns = new SqlCommand();
NP_Cls.SqlInsert = "INSERT INTO t_ProductionCost (PrdONumber, MaterialCode, PlantCode, WorkCenterCode, UsedMachine, UsedSetup, UsedLabor, UsedOT, UserCreate, DateCreate) VALUES (@PrdONumber, @MaterialCode, @PlantCode, @WorkCenterCode, @UsedMachine, @UsedSetup, @UsedLabor, @UsedOT, @UserCreate, GETDATE())";
cmdIns.Parameters.Add("@PrdONumber", SqlDbType.NVarChar, 12).Value = this.cbProdOrder.SelectedValue;
cmdIns.Parameters.Add("@MaterialCode", SqlDbType.NVarChar, 15).Value = this.lblMaterialCode.Text.Trim();
cmdIns.Parameters.Add("@PlantCode", SqlDbType.NVarChar, 4).Value = this.lblPlantCode.Text.Trim();
cmdIns.Parameters.Add("@WorkCenterCode", SqlDbType.NVarChar, 10).Value = this.cbWorkCenter.SelectedValue;
cmdIns.Parameters.Add("@UsedMachine", SqlDbType.Decimal).Value = decimal.Parse(this.txtMachine.Text.Trim());
cmdIns.Parameters.Add("@UsedSetup", SqlDbType.Decimal).Value = decimal.Parse(this.txtSetup.Text.Trim());
cmdIns.Parameters.Add("@UsedLabor", SqlDbType.Decimal).Value = decimal.Parse(this.txtLabor.Text.Trim());
cmdIns.Parameters.Add("@UsedOT", SqlDbType.Decimal).Value = decimal.Parse(this.txtOT.Text.Trim());
cmdIns.Parameters.Add("@UserCreate", SqlDbType.NVarChar, 50).Value = NP_Cls.strUsr;
cmdIns.Connection = oConn; cmdIns.CommandText = NP_Cls.SqlInsert; cmdIns.Transaction = Tr;
cmdIns.ExecuteNonQuery();
// By NP - 2.7.13 - No reason to flag GI Change to OrderStatus = Close
NP_Cls.sqlUpdate = "UPDATE t_PrdOrderDetail SET IsGIClose = 1 WHERE (PrdONumber = @PrdONumber)";
cmdIns.Connection = oConn; cmdIns.CommandText = NP_Cls.sqlUpdate; cmdIns.Transaction = Tr;
cmdIns.ExecuteNonQuery();
NP_Cls.sqlUpdate = "UPDATE t_PrdOrder SET OrderStatus = 'Close' WHERE (PrdONumber = @PrdONumber)";
cmdIns.Connection = oConn; cmdIns.CommandText = NP_Cls.sqlUpdate; cmdIns.Transaction = Tr;
cmdIns.ExecuteNonQuery();
Tr.Commit();
Clear(); DGV(); NP.MSGB(NP_Cls.NPMgsStyle.InfoType, "Close Completed !!");
this.cbProdOrder.Select();
}
catch (Exception ex)
{
if (oConn.State == ConnectionState.Open)
{
Tr.Rollback();
}
NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Close : " + ex.Message); return;
}
finally
{
if (oConn.State == ConnectionState.Open)
{
oConn.Close();
}
}
}
else
{
return;
}
}
private void btnNewVer_Click(object sender, EventArgs e)
{
if (NP.MSGB("Do you want to Create New Version ?") == DialogResult.Yes)
{
//this.txtVersion.Text = (Convert.ToInt16(this.txtVersion.Text.Trim()) + 1).ToString();
//this.cbBOMType.SelectedIndex = 0; this.cbUnit.SelectedIndex = 0;
//this.txtQty.Text = string.Empty; this.cbMaterial.Enabled = false; this.cbPlant.Enabled = false;
// NP_Cls.SqlSelect = "SELECT 0 as ItemNo, m_Unit.UnitName, t_BOMDetail.Category, t_BOMDetail.MaterialCode, m_Material.MaterialName, t_BOMDetail.Quantity, t_BOM.BOMCode, t_BOMDetail.BOMDetailCode, t_BOM.Approve, t_BOM.BOMVersion " +
// "FROM t_BOM INNER JOIN " +
// "m_Unit ON t_BOM.UnitCode = m_Unit.UnitCode INNER JOIN " +
// "t_BOMDetail ON t_BOM.BOMCode = t_BOMDetail.BOMCode INNER JOIN " +
// "m_Material ON t_BOMDetail.MaterialCode = m_Material.MaterialCode " +
//"WHERE (t_BOM.FileStatus = N'1') AND (t_BOM.PlantCode = N'') AND (t_BOM.MaterialCode = N'')";
// this.dgvView.DataSource = NP.GetClientDataSet(NP_Cls.SqlSelect).Tables[0]; this.btnVerAppr.Visible = false; this.btnVerNot.Visible = false;
oConn = new SqlConnection(NP.ReadFileDB(NP_Cls.PathDB));
if (oConn.State == ConnectionState.Open)
{
oConn.Close();
}
oConn.Open(); SqlTransaction Tr; Tr = oConn.BeginTransaction();
try
{
SqlCommand cmdEdit = new SqlCommand();
NP_Cls.sqlUpdate = "INSERT INTO t_BOM " +
"(MaterialCode, PlantCode, BOMType, UnitCode, Quantity, BOMVersion, UserCreate, DateCreate, FileStatus, Approve, Remark) " +
"SELECT MaterialCode, PlantCode, BOMType, UnitCode, Quantity, BOMVersion + 1 AS BOMVer, '" + NP_Cls.strUsr + "' AS UC, GETDATE(), FileStatus, 0 as Appr, Remark FROM t_BOM " +
"WHERE (BOMCode = @BOMCode)";
cmdEdit.Parameters.Add("@BOMCode", SqlDbType.Int).Value = this.dgvView["clnBOMCode", this.dgvView.CurrentRow.Index].Value.ToString();
cmdEdit.Connection = oConn; cmdEdit.CommandText = NP_Cls.sqlUpdate; cmdEdit.Transaction = Tr;
cmdEdit.ExecuteNonQuery();
NP_Cls.SqlSelect = "SELECT BOMCode FROM t_BOM WHERE (MaterialCode = '" + this.dgvView["clnMaterialCode", this.dgvView.CurrentRow.Index].Value.ToString() + "') AND (PlantCode = '" + this.dgvView["clnPlantCode", this.dgvView.CurrentRow.Index].Value.ToString() + "') Order By BOMCode DESC";
string sBOMCode = NP.GetDataWithTran(NP_Cls.SqlSelect, Tr, oConn).Tables[0].Rows[0][0].ToString();
NP_Cls.sqlUpdate = "INSERT INTO t_BOMDetail " +
"(BOMCode, Category, MaterialCode, Quantity, LossPercentage, UserCreate, DateCreate) " +
"SELECT '" + sBOMCode + "' AS BC, Category, MaterialCode, Quantity, LossPercentage, '" + NP_Cls.strUsr + "' AS UC, GETDATE() FROM t_BOMDetail " +
"WHERE (BOMCode = @BOMCode)";
cmdEdit.Connection = oConn; cmdEdit.CommandText = NP_Cls.sqlUpdate; cmdEdit.Transaction = Tr;
cmdEdit.ExecuteNonQuery();
NP_Cls.sqlUpdate = "UPDATE t_BOM SET FileStatus = @St WHERE (BOMCode = @BOMCode)";
//cmdEdit.Parameters.Add("@BOMCode", SqlDbType.Int).Value = this.dgvView["clnBOMCode",this.dgvView.CurrentRow.Index].Value.ToString();
cmdEdit.Parameters.Add("@St", SqlDbType.NVarChar, 1).Value = "D";
cmdEdit.Connection = oConn; cmdEdit.CommandText = NP_Cls.sqlUpdate; cmdEdit.Transaction = Tr;
cmdEdit.ExecuteNonQuery();
if (NP._TRanSave(oConn, Tr, NP_Cls.NPTranType.Update, "t_BOM:NewVersion", NP_Cls.strUsr))
{
Tr.Commit();
DGV(); Clear();
this.btnAdd.Visible = true; this.btnEdit.Visible = false;
}
else
{
NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Try Again !!"); return;
}
}
catch (Exception ex)
{
if (oConn.State == ConnectionState.Open)
{
Tr.Rollback();
}
NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Approve : " + ex.Message); return;
}
finally
{
if (oConn.State == ConnectionState.Open)
{
oConn.Close();
}
}
}
else
{
return;
}
}
private void deleteToolStripMenuItem_Click(object sender, EventArgs e)
{
if (this.dgvView.RowCount == 0)
{
NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Data Not Found !!"); return;
}
if (NP.MSGB("Do you want to delete ?") == DialogResult.Yes)
{
oConn = new SqlConnection(NP.ReadFileDB(NP_Cls.PathDB));
if (oConn.State == ConnectionState.Open)
{
oConn.Close();
}
oConn.Open(); SqlTransaction Tr; Tr = oConn.BeginTransaction();
try
{
SqlCommand cmdDel = new SqlCommand();
NP_Cls.SqlDel = "DELETE FROM t_ProductionCost WHERE (AutoID = @AutoID)";
cmdDel.Parameters.Add("@AutoID", SqlDbType.NVarChar, 10).Value = this.dgvView["clnAutoID", this.dgvView.CurrentRow.Index].Value;
cmdDel.Connection = oConn; cmdDel.CommandText = NP_Cls.SqlDel; cmdDel.Transaction = Tr;
cmdDel.ExecuteNonQuery();
NP_Cls.sqlUpdate = "UPDATE t_PrdOrderDetail SET IsGIClose = 0 WHERE (PrdONumber = @PrdONumber)";
cmdDel.Parameters.Add("@PrdONumber", SqlDbType.NVarChar, 12).Value = this.cbProdOrder.SelectedValue;
cmdDel.Connection = oConn; cmdDel.CommandText = NP_Cls.sqlUpdate; cmdDel.Transaction = Tr;
cmdDel.ExecuteNonQuery();
//By NP For OrderStatus = string.emtpt
NP_Cls.sqlUpdate = "UPDATE t_PrdOrder SET OrderStatus = '' WHERE (PrdONumber = @PrdONumber)";
cmdDel.Connection = oConn; cmdDel.CommandText = NP_Cls.sqlUpdate; cmdDel.Transaction = Tr;
cmdDel.ExecuteNonQuery();
Tr.Commit();
DGV();
NP.MSGB(NP_Cls.NPMgsStyle.InfoType, "Delete Completed !!");
//if (NP._TRanSave(oConn, Tr, NP_Cls.NPTranType.Delete, "t_RoutingDetail", NP_Cls.strUsr))
//{
// Tr.Commit();
// DGV(); NP.MSGB(NP_Cls.NPMgsStyle.InfoType, "Delete Completed !!");
//}
//else
//{
// NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Try agian !!"); return;
//}
}
catch (Exception ex)
{
NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Delete : " + ex.Message); return;
}
finally
{
if (oConn.State == ConnectionState.Open)
{
oConn.Close();
}
}
}
else
{
return;
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
if (!NP.ReqField(this.cbPrdOrder, "Please select Production Order first !!"))
{
return;
}
if (!NP.ReqField(this.txtQty, "Please enter Qty !!"))
{
return;
}
//if (decimal.Parse(lblPrdQty.Text.Trim()) < decimal.Parse(lblGrPrdQty.Text.Trim()) + decimal.Parse(txtQty.Text.Trim()))
//{
// MessageBox.Show("Quantity must less than " + (decimal.Parse(lblPrdQty.Text.Trim()) - decimal.Parse(lblGrPrdQty.Text.Trim())).ToString(), "Warning !!", MessageBoxButtons.OK, MessageBoxIcon.Exclamation, MessageBoxDefaultButton.Button1);
// txtQty.Focus();
// txtQty.Text = (decimal.Parse(lblPrdQty.Text.Trim()) - decimal.Parse(lblGrPrdQty.Text.Trim())).ToString();
// return;
//}
if (NP.MSGB("Do you to Save GR Production ?") == DialogResult.Yes)
{
oConn = new SqlConnection(NP.ReadFileDB(NP_Cls.PathDB));
if (oConn.State == ConnectionState.Open)
{
oConn.Close();
}
oConn.Open(); SqlTransaction Tr;
Tr = oConn.BeginTransaction();
try
{
SqlCommand cmdIns = new SqlCommand(); string strTmpBatch = NP_Cls._genBatch(this.lblMatCode.Text.Trim(), oConn, Tr);
NP_Cls.SqlInsert = "INSERT INTO t_StockMovement " +
"(DocNumber, TranDate, MovementType,RefNumber, Remark, UserCreate, DateCreate,PlantCode,PlantName,BOMVersion,LocCode,LocName) " +
"VALUES (@GRPrdNumber,GETDATE(),@MovementType,@PrdONumber,@Remark,@UC,GETDATE(),@PlantCode,@PlantName,@BOMVersion,@LocCode,@LocName)";
cmdIns.Parameters.Add("@GRPrdNumber", SqlDbType.NVarChar, 12).Value = this.txtDocNo.Text.Trim();
cmdIns.Parameters.Add("@PrdONumber", SqlDbType.NVarChar, 12).Value = this.cbPrdOrder.Text.Trim();
cmdIns.Parameters.Add("@MovementType", SqlDbType.NVarChar, 3).Value = this.lblMoveType.Text.Trim();
cmdIns.Parameters.Add("@GRPrdQty", SqlDbType.Decimal).Value = Convert.ToDecimal(this.txtQty.Text.Trim());
cmdIns.Parameters.Add("@BatchNumber", SqlDbType.NVarChar, 10).Value = strTmpBatch;
cmdIns.Parameters.Add("@Remark", SqlDbType.NVarChar, 255).Value = this.txtRemark.Text.Trim();
cmdIns.Parameters.Add("@UC", SqlDbType.NVarChar, 50).Value = NP_Cls.strUsr;
cmdIns.Parameters.Add("@PlantCode", SqlDbType.NVarChar, 4).Value = this.lblPlantCode.Text.Trim();
cmdIns.Parameters.Add("@PlantName", SqlDbType.NVarChar, 20).Value = this.lblPlant.Text.Trim();
cmdIns.Parameters.Add("@LocCode", SqlDbType.NVarChar, 2).Value = this.lblLocCode.Text.Trim();
cmdIns.Parameters.Add("@LocName", SqlDbType.NVarChar, 20).Value = this.lblLoc.Text.Trim();
cmdIns.Parameters.Add("@BOMVersion", SqlDbType.Int).Value = Convert.ToInt32(this.lblBomVer.Text.Trim());
cmdIns.Connection = oConn; cmdIns.CommandText = NP_Cls.SqlInsert; cmdIns.Transaction = Tr;
cmdIns.ExecuteNonQuery();
NP_Cls.SqlInsert = "INSERT INTO t_StockMovementDetail " +
"(AutoID, DocNumber, RefNumber, MaterialCode, MaterialName, Quantity, BatchNumber, CurrentUser, LogDate,PlantCode,PlantName,LocCode,LocName,UnitCode,UnitName) " +
"VALUES (1, @GRPrdNumber,@PrdONumber,@MaterialCode, @MaterialName,@GRPrdQty,@BatchNumber, @UC, GETDATE(),@PlantCode,@PlantName,@LocCode,@LocName,@UnitCode,@UnitName)";
cmdIns.Parameters.Add("@MaterialCode", SqlDbType.NVarChar, 15).Value = this.lblMatCode.Text.Trim();
cmdIns.Parameters.Add("@MaterialName", SqlDbType.NVarChar, 60).Value = this.lblMaterialName.Text.Trim();
cmdIns.Parameters.Add("@UnitCode", SqlDbType.NVarChar, 3).Value = this.lblUnitCode.Text.Trim();
cmdIns.Parameters.Add("@UnitName", SqlDbType.NVarChar, 20).Value = this.lblUnitName.Text.Trim();
cmdIns.Connection = oConn; cmdIns.CommandText = NP_Cls.SqlInsert; cmdIns.Transaction = Tr;
cmdIns.ExecuteNonQuery();
NP_Cls.SqlInsert = "INSERT INTO [dbo].[t_GRPrd] ([GRPrdNumber] ,[PrdONumber] ,[GRPrdDate] ,[MovementType] ,[GRPrdQty] ,[BatchNumber] ,[Remark] ,[UserCreate] ,[DateCreate] ) VALUES (@GRPrdNumber ,@PrdONumber ,GETDATE() ,@MovementType ,@GRPrdQty ,@BatchNumber ,@Remark ,@UC ,GetDate())";
cmdIns.Connection = oConn; cmdIns.CommandText = NP_Cls.SqlInsert; cmdIns.Transaction = Tr;
cmdIns.ExecuteNonQuery();
//TODO Save in Stock Overview // 16.11.10
string strTmp = "INSERT INTO t_StockOverview (MaterialCode, BatchNumber, UR, QI, Block, UserCreate, DateCreate, Cost,PlantCode,LocCode,OrigQty,UnitCode) VALUES (@MaterialCode,@BatchNumber,@UR,@QI,@Block,@UC, GETDATE(), @Cost,@PlantCode,@LocCode,@OrigQty,@UnitCode)";
//cmdIns.Parameters["@BatchNumber"].Value = strTmpBatch;
cmdIns.Parameters.Add("@UR", SqlDbType.Decimal).Value = 0;
cmdIns.Parameters.Add("@QI", SqlDbType.Decimal).Value = Convert.ToDecimal(this.txtQty.Text.Trim());
cmdIns.Parameters.Add("@Block", SqlDbType.Decimal).Value = 0;
cmdIns.Parameters.Add("@Cost", SqlDbType.Decimal).Value = getCost(oConn, Tr, this.lblMatCode.Text.Trim());
cmdIns.Parameters.Add("@OrigQty", SqlDbType.Decimal).Value = Convert.ToDecimal(this.txtQty.Text.Trim());
cmdIns.Connection = oConn; cmdIns.CommandText = strTmp; cmdIns.Transaction = Tr;
cmdIns.ExecuteNonQuery();
strTmp = "UPDATE t_PrdOrder SET GrPrdQuantity = Isnull(GrPrdQuantity,0) + @QI WHERE (PrdONumber = @PrdONumber)";
cmdIns.Connection = oConn; cmdIns.CommandText = strTmp; cmdIns.Transaction = Tr;
cmdIns.ExecuteNonQuery();
if (decimal.Parse(lblPrdQty.Text.Trim()) <= decimal.Parse(lblGrPrdQty.Text.Trim()) + decimal.Parse(txtQty.Text.Trim()))
{
strTmp = "UPDATE t_MRPTranOrder SET IsCompleted = 1 WHERE (MaterialHeader = @MaterialCode) AND (TranOrder = @PrdONumber)";
cmdIns.Connection = oConn; cmdIns.CommandText = strTmp; cmdIns.Transaction = Tr;
cmdIns.ExecuteNonQuery();
strTmp = "UPDATE t_PrdOrder SET ISGRPrd = 1 WHERE (PrdONumber = @PrdONumber)";
cmdIns.Connection = oConn; cmdIns.CommandText = strTmp; cmdIns.Transaction = Tr;
cmdIns.ExecuteNonQuery();
}
Tr.Commit(); NP.MSGB(NP_Cls.NPMgsStyle.InfoType, "Save GR Production Completed !!");
Clear();
this.txtDocNo.Text = GetNumber();
BindMat();
this.cbPrdOrder.Text = string.Empty; this.cbPrdOrder.Select();
}
catch (Exception ex)
{
if (oConn.State == ConnectionState.Open)
{
Tr.Rollback();
}
NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Add Detail : " + ex.Message); return;
}
finally
{
if (oConn.State == ConnectionState.Open)
{
oConn.Close();
}
}
}
else
{
return;
}
}
private void btnCancelGI_Click(object sender, EventArgs e)
{
try
{
if (NP.MSGB("Do you to cancel Goods Issue ?") == DialogResult.Yes)
{
oConn = new SqlConnection(NP.ReadFileDB(NP_Cls.PathDB));
if (oConn.State == ConnectionState.Open)
{
oConn.Close();
}
oConn.Open(); SqlTransaction Tr;
Tr = oConn.BeginTransaction();
try
{
SqlCommand cmd = new SqlCommand();
NP_Cls.SqlDel = "DELETE FROM t_StockMovement WHERE (DocNumber = @DocNumber)";
cmd.Parameters.Add("@DocNumber", SqlDbType.NVarChar, 12).Value = this.txtGI.Text.Trim();
cmd.CommandText = NP_Cls.SqlDel; cmd.Connection = oConn; cmd.Transaction = Tr;
cmd.ExecuteNonQuery();
NP_Cls.SqlDel = "DELETE FROM t_StockMovementDetail WHERE (DocNumber = @DocNumber)";
cmd.CommandText = NP_Cls.SqlDel; cmd.Connection = oConn; cmd.Transaction = Tr;
cmd.ExecuteNonQuery();
Tr.Commit();
}
catch (Exception ex)
{
NP.MSGB("Del : " + ex.Message);
}
finally
{
if (oConn.State == ConnectionState.Open)
{
oConn.Close();
}
}
Clear(); this.groupPR.Enabled = true; this.cbMaterial.Text = string.Empty;
if (this.dsPR.Tables.Count > 0)
{
this.dsPR.Tables.Clear(); this.MyGrid(this.dgvView);
}
this.cbMaterial.DataSource = null;
this.btnAddGI.Visible = true; this.btnSave.Visible = false; strMRP = string.Empty;
NP_Cls.SqlSelect = "SELECT MaterialCode + ':' + MaterialName AS MatCode, PrdONumber FROM t_PrdOrder WHERE (IsGI = 0)";
NP.BindCB(this.cbPrdoOrder, NP_Cls.SqlSelect, "MatCode", "PrdONumber", "((( Select Prd Number )))");
this.cbPrdoOrder.Text = string.Empty; this.cbPrdoOrder.Select();
}
else
{
return;
}
}
catch (Exception ex)
{
NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Cancel : " + ex.Message); return;
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (this.dgvView.RowCount == 0)
{
NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Please select SO Number into DO list !!"); this.cbSO.Select(); return;
}
this.dgvView.EndEdit(); this.lessStock = 0;
for (byte ii = 0; ii < this.dgvView.RowCount; ii++)
{
// Check Not add batch number
if (string.IsNullOrEmpty(this.dgvView["clnBatchNumber", ii].Value.ToString()))
{
NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Mat.Code : " + this.dgvView["clnMaterialCode", ii].Value.ToString() + " dose not add Batch Number !!\nCannot DO. !!"); return;
}
// Check Quantity
if (Convert.ToDouble(this.dgvView["clnQuantity", ii].Value) > Convert.ToDouble(this.dgvView["clnTmpSO", ii].Value))
{
NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Mat.Code : " + this.dgvView["clnMaterialCode", ii].Value.ToString() + " is over SO Qty !!\nCannot DO. !!"); return;
}
else
{
if (Convert.ToDouble(this.dgvView["clnQuantity", ii].Value) > Convert.ToDouble(this.dgvView["clnFGStock", ii].Value))
{
NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Mat.Code : " + this.dgvView["clnMaterialCode", ii].Value.ToString() + " is over Stock !!\nCannot DO. !!"); return;
}
else if (Convert.ToDouble(this.dgvView["clnQuantity", ii].Value) <= Convert.ToDouble(this.dgvView["clnFGStock", ii].Value))
{
this.lessStock = 1;
}
}
}
string strQuestion = string.Empty;
if (this.lessStock == 0)
{
strQuestion = "Do you want to Save Delivery Order ?";
}
else
{
strQuestion = "Do you want to Save Delivery Order with less stock Material ?";
}
if (NP.MSGB(strQuestion) == DialogResult.Yes)
{
oConn = new SqlConnection(NP.ReadFileDB(NP_Cls.PathDB));
if (oConn.State == ConnectionState.Open)
{
oConn.Close();
}
oConn.Open(); SqlTransaction Tr;
Tr = oConn.BeginTransaction();
try
{
SqlCommand cmdIns = new SqlCommand(); SqlCommand cmdInsertTmpStock = new SqlCommand();
NP_Cls.SqlInsert = "INSERT INTO t_DODetail (DONumber, MaterialCode, MaterialName, DOQuantity, UnitCode, UnitName, NetPrice, DOAmount, DeliveryDate, PlantCode, PlantName, LocCode, LocName, CurrentUser, SONumber, SOAutoID) " +
"VALUES (@DONumber,@MaterialCode,@MaterialName,@DOQuantity,@UnitCode,@UnitName,@NetPrice,@DOAmount,@DeliveryDate,@PlantCode,@PlantName,@LocCode,@LocName,@CurrentUser,@SONumber,@SOID)";
cmdIns.Parameters.Add("@DONumber", SqlDbType.NVarChar, 12);
cmdIns.Parameters.Add("@MaterialCode", SqlDbType.NVarChar, 15);
cmdIns.Parameters.Add("@MaterialName", SqlDbType.NVarChar, 60);
cmdIns.Parameters.Add("@DOQuantity", SqlDbType.Decimal);
cmdIns.Parameters.Add("@UnitCode", SqlDbType.NVarChar, 3);
cmdIns.Parameters.Add("@UnitName", SqlDbType.NVarChar, 20);
cmdIns.Parameters.Add("@NetPrice", SqlDbType.Decimal);
cmdIns.Parameters.Add("@DOAmount", SqlDbType.Decimal);
cmdIns.Parameters.Add("@DeliveryDate", SqlDbType.DateTime);
cmdIns.Parameters.Add("@PlantCode", SqlDbType.NVarChar, 4);
cmdIns.Parameters.Add("@PlantName", SqlDbType.NVarChar, 20);
cmdIns.Parameters.Add("@LocCode", SqlDbType.NVarChar, 2);
cmdIns.Parameters.Add("@LocName", SqlDbType.NVarChar, 20);
cmdIns.Parameters.Add("@CurrentUser", SqlDbType.NVarChar, 50);
cmdIns.Parameters.Add("@SONumber", SqlDbType.NVarChar, 12);
cmdIns.Parameters.Add("@SOID", SqlDbType.Int);
for (byte ins = 0; ins < this.dgvView.RowCount; ins++)
{
if (Convert.ToDecimal(this.dgvView["clnQuantity", ins].Value) <= Convert.ToDecimal(this.dgvView["clnFGStock", ins].Value))
{
cmdIns.Parameters["@DONumber"].Value = this.strGNumber;
cmdIns.Parameters["@MaterialCode"].Value = this.dgvView["clnMaterialCode", ins].Value.ToString();
cmdIns.Parameters["@MaterialName"].Value = this.dgvView["clnMaterialName", ins].Value.ToString();
cmdIns.Parameters["@DOQuantity"].Value = Convert.ToInt32(this.dgvView["clnQuantity", ins].Value);
cmdIns.Parameters["@UnitCode"].Value = this.dgvView["clnUnitCode", ins].Value.ToString();
cmdIns.Parameters["@UnitName"].Value = this.dgvView["clnUnitName", ins].Value.ToString();
cmdIns.Parameters["@NetPrice"].Value = Convert.ToDecimal(this.dgvView["clnNetPrice", ins].Value);
cmdIns.Parameters["@DOAmount"].Value = Convert.ToDecimal(this.dgvView["clnAmount", ins].Value);
cmdIns.Parameters["@CurrentUser"].Value = NP_Cls.strUsr;
cmdIns.Parameters["@DeliveryDate"].Value = Convert.ToDateTime(this.dgvView["clnDeliveryDate", ins].Value);
cmdIns.Parameters["@PlantCode"].Value = this.dgvView["clnPlantCode", ins].Value.ToString();
cmdIns.Parameters["@PlantName"].Value = this.dgvView["clnPlantName", ins].Value.ToString();
cmdIns.Parameters["@LocCode"].Value = this.dgvView["clnLocCode", ins].Value.ToString();
cmdIns.Parameters["@LocName"].Value = this.dgvView["clnLocName", ins].Value.ToString();
cmdIns.Parameters["@SONumber"].Value = this.dgvView["clnSONumber", ins].Value.ToString();
cmdIns.Parameters["@SOID"].Value = this.dgvView["clnAutoID", ins].Value.ToString();
cmdIns.Connection = oConn; cmdIns.CommandText = NP_Cls.SqlInsert; cmdIns.Transaction = Tr;
cmdIns.ExecuteNonQuery();
NP_Cls.sqlUpdate = "UPDATE t_SODetail SET DOQuantity = DOQuantity + @DOQuantity WHERE (SONumber = @SONumber) AND (AutoID = @SOID)";
cmdIns.Connection = oConn; cmdIns.CommandText = NP_Cls.sqlUpdate; cmdIns.Transaction = Tr;
cmdIns.ExecuteNonQuery();
}
}
#region Insert tmp for do
NP_Cls.SqlInsert = "INSERT INTO [tmp_DOforApprove] (SONumber ,BatchNumber ,Qty, SOAutoID) VALUES (@SONumber, @BatchNumber, @Qty, @SOAutoID)";
cmdInsertTmpStock.Parameters.Add("@SONumber", SqlDbType.NVarChar, 12);
cmdInsertTmpStock.Parameters.Add("@BatchNumber", SqlDbType.NVarChar, 10);
cmdInsertTmpStock.Parameters.Add("@SOAutoID", SqlDbType.Int);
cmdInsertTmpStock.Parameters.Add("@Qty", SqlDbType.Decimal);
for (int i = 0; i < this.dsBatch.Tables[0].Rows.Count; i++)
{
cmdInsertTmpStock.Parameters["@SONumber"].Value = this.dsBatch.Tables[0].Rows[i]["SONumber"].ToString();
cmdInsertTmpStock.Parameters["@BatchNumber"].Value = this.dsBatch.Tables[0].Rows[i]["BatchNumber"].ToString();
cmdInsertTmpStock.Parameters["@SOAutoID"].Value = this.dsBatch.Tables[0].Rows[i]["SOAutoID"].ToString();
cmdInsertTmpStock.Parameters["@Qty"].Value = Convert.ToDecimal(this.dsBatch.Tables[0].Rows[i]["Qty"]);
cmdInsertTmpStock.Connection = oConn; cmdInsertTmpStock.CommandText = NP_Cls.SqlInsert; cmdInsertTmpStock.Transaction = Tr;
cmdInsertTmpStock.ExecuteNonQuery();
}
#endregion
if (this.lessStock == 0)
{
strQuestion = "Save Delivery Order Completed !!";
}
else
{
strQuestion = "Save Delivery Order with less stock Material Completed !!";
}
Tr.Commit(); NP.MSGB(NP_Cls.NPMgsStyle.InfoType, strQuestion);
Clear();
this.groupPR.Enabled = true; this.btnAddSO.Visible = true; this.btnSave.Visible = false; this.cbSO.Text = string.Empty; this.cbSO.DataSource = null; this.cbMaterial.DataSource = null; this.cbMaterial.Text = string.Empty;
this.dsPR.Tables.Clear(); this.MyGrid(dgvView); this.txtDO.DropDownStyle = ComboBoxStyle.Simple;
BindCBCustomer();
this.cbCustomer.Enabled = true; this.txtDO.Text = GetNumber(); this.btnAppr.Visible = false;
this.cbCustomer.Text = string.Empty; this.cbCustomer.Select(); this.cbCustomer.SelectAll();
}
catch (Exception ex)
{
if (oConn.State == ConnectionState.Open)
{
Tr.Rollback();
}
NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Save : " + ex.Message); return;
}
finally
{
if (oConn.State == ConnectionState.Open)
{
oConn.Close();
}
}
}
else
{
return;
}
}
private void btnAppr_Click(object sender, EventArgs e)
{
if (NP.MSGB("Do you want Approve Delivery Order ?") == DialogResult.Yes)
{
oConn = new SqlConnection(NP.ReadFileDB(NP_Cls.PathDB));
if (oConn.State == ConnectionState.Open)
{
oConn.Close();
}
oConn.Open(); SqlTransaction Tr;
Tr = oConn.BeginTransaction();
try
{
SqlCommand cmdUpdateStock = new SqlCommand();
cmdUpdateStock.Parameters.Add("@Qty", SqlDbType.Decimal);
cmdUpdateStock.Parameters.Add("@BatchNumber", SqlDbType.NVarChar, 15);
cmdUpdateStock.Parameters.Add("@outputInt", SqlDbType.Int).Direction = ParameterDirection.Output;
cmdUpdateStock.Connection = oConn;
cmdUpdateStock.CommandType = CommandType.StoredProcedure;
for (byte ins = 0; ins < this.dgvView.RowCount; ins++)
{
string getSONumberID = this.dgvView["clnAutoID", ins].Value.ToString();
NP_Cls.SqlSelect = "SELECT SONumber, BatchNumber, Qty FROM tmp_DOforApprove WHERE (SOAutoID = N'" + getSONumberID + "')";
DataSet ds = new DataSet(); ds = NP.GetClientDataSet(NP_Cls.SqlSelect);
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
cmdUpdateStock.Parameters["@Qty"].Value = ds.Tables[0].Rows[i]["Qty"].ToString();
cmdUpdateStock.Parameters["@BatchNumber"].Value = ds.Tables[0].Rows[i]["BatchNumber"].ToString();
cmdUpdateStock.CommandText = "UpdateStockWhenApproveDO";
cmdUpdateStock.Transaction = Tr;
cmdUpdateStock.ExecuteNonQuery();
if (Convert.ToInt32(cmdUpdateStock.Parameters["@OutputInt"].Value) != 1)
{
Tr.Rollback();
}
}
NP_Cls.SqlDel = "DELETE FROM tmp_DOforApprove WHERE (SOAutoID = '" + getSONumberID + "')"; string strErr1 = string.Empty;
if (!NP.SqlCmd(NP_Cls.SqlDel, ref strErr1))
{
NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Delete : " + strErr1); return;
}
}
Tr.Commit();
}
catch (Exception ex)
{
if (oConn.State == ConnectionState.Open)
{
Tr.Rollback();
}
NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Save : " + ex.Message); return;
}
finally
{
if (oConn.State == ConnectionState.Open)
{
oConn.Close();
}
}
NP_Cls.sqlUpdate = "UPDATE t_DO SET DOApprove = 1, UserUpdate = '" + NP_Cls.strUsr + "', DateUpdate = GETDATE() WHERE (DONumber = '" + this.txtDO.Text.Trim() + "')"; string strErr = string.Empty;
if (!NP.SqlCmd(NP_Cls.sqlUpdate, ref strErr))
{
NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Approve : " + strErr); return;
}
Clear(); this.txtDO.DropDownStyle = ComboBoxStyle.Simple; this.cbCustomer.Enabled = true;
this.groupPR.Enabled = true; this.btnAddSO.Visible = true; this.btnSave.Visible = false; this.cbSO.Text = string.Empty; this.cbSO.DataSource = null; this.cbMaterial.DataSource = null; this.cbMaterial.Text = string.Empty;
this.MyGrid(dgvView); this.txtDO.Text = GetNumber(); this.btnAppr.Visible = false;
this.cbCustomer.Text = string.Empty; this.cbCustomer.Select(); this.cbCustomer.SelectAll();
}
else
{
return;
}
}
