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; } }