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; } }
private void btnAdd_Click(object sender, EventArgs e) { try { if (NP.ReqField(this.cbDepartment, "Please enter Department: !!") == false) { return; } if (NP.ReqField(this.cbLevel, "Please enter Level: !!") == false) { 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(); try { SqlCommand cmdIns = new SqlCommand(); NP_Cls.SqlInsert = "INSERT INTO s_Level " + "(DepartmentCode, AuthLevel, Per, UserCreate, DateCreate, FileStatus) " + "VALUES (@DepartmentCode,@AuthLevel,@Per,@UC, GETDATE(),@St)"; cmdIns.Parameters.Add("@DepartmentCode", SqlDbType.NVarChar, 3).Value = this.cbDepartment.SelectedValue; cmdIns.Parameters.Add("@AuthLevel", SqlDbType.NVarChar, 1).Value = this.cbLevel.Text.Trim(); cmdIns.Parameters.Add("@Per", SqlDbType.NVarChar).Value = ((string)GenPer()); cmdIns.Parameters.Add("@UC", SqlDbType.NVarChar, 10).Value = NP_Cls.strUsr; cmdIns.Parameters.Add("@St", SqlDbType.NVarChar, 1).Value = "1"; cmdIns.Connection = oConn; cmdIns.CommandText = NP_Cls.SqlInsert; cmdIns.ExecuteNonQuery(); Clear(); DGV(); NP.MSGB(NP_Cls.NPMgsStyle.InfoType, "Add Data Completed !!"); this.cbDepartment.Select(); } catch (Exception ex) { NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Add : " + ex.Message); return; } finally { if (oConn.State == ConnectionState.Open) { oConn.Close(); } } } else { return; } } catch (Exception ex) { NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Add : " + ex.Message); return; } }
private void btnAddPR_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(this.txtInv.Text.Trim())) { NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Please enter Invoice Number first !!"); this.txtInv.Select(); return; } if ((!string.IsNullOrEmpty(this.cbVendor.Text.Trim())) && (this.cbVendor.SelectedIndex != 0)) { // oConn = new SqlConnection(NP.ReadFileDB(NP_Cls.PathDB)); if (oConn.State == ConnectionState.Open) { oConn.Close(); } oConn.Open(); try { SqlCommand cmdIns = new SqlCommand(); NP_Cls.SqlInsert = "INSERT INTO t_GT " + "(GTNumber, InvoiceNumber, GTDate, VendorCode, VendorName, PurchasingGroup, MovementType, Remark, UserCreate, DateCreate) " + "VALUES (@GTNumber,@Invoice, GETDATE(),@VendorCode,@VendorName,@PurchasingGroup,@MovementType,@Remark,@UC,GETDATE())"; this.strGNumber = GetNumber(); cmdIns.Parameters.Add("@GTNumber", SqlDbType.NVarChar, 12).Value = this.strGNumber; cmdIns.Parameters.Add("@Invoice", SqlDbType.NVarChar, 20).Value = this.txtInv.Text.Trim(); cmdIns.Parameters.Add("@VendorCode", SqlDbType.NVarChar, 10).Value = this.cbVendor.Text.Trim(); cmdIns.Parameters.Add("@VendorName", SqlDbType.NVarChar, 60).Value = this.lblVendorName.Text.Trim(); cmdIns.Parameters.Add("@PurchasingGroup", SqlDbType.NVarChar, 3).Value = this.lblPG.Text.Trim(); cmdIns.Parameters.Add("@MovementType", SqlDbType.NVarChar, 3).Value = this.lblMovType.Text.Trim(); cmdIns.Parameters.Add("@Remark", SqlDbType.NVarChar, 255).Value = this.txtRemark.Text.Trim(); cmdIns.Parameters.Add("@UC", SqlDbType.NVarChar, 50).Value = NP_Cls.strUsr; cmdIns.Connection = oConn; cmdIns.CommandText = NP_Cls.SqlInsert; cmdIns.ExecuteNonQuery(); this.groupPR.Enabled = false; this.btnAddPR.Visible = false; this.btnSave.Visible = true; NP_Cls.SqlSelect = "SELECT GRNumber, GRNumber AS GRDis FROM t_GR WHERE (VendorCode = N'" + this.cbVendor.Text.Trim() + "') AND (MovementType = '101')"; NP.BindCB(this.cbPONumber, NP_Cls.SqlSelect, "GRNumber", "GRDis", "((( Select GR Number )))"); this.cbPONumber.Select(); this.cbPONumber.SelectAll(); } catch (Exception ex) { NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Add Header : " + ex.Message); return; } finally { if (oConn.State == ConnectionState.Open) { oConn.Close(); } } // } else { NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Please select vendor first !!"); this.cbVendor.Select(); return; } }
private void btnAddGI_Click(object sender, EventArgs e) { if ((!string.IsNullOrEmpty(this.cbPrdoOrder.Text.Trim())) && (this.cbPrdoOrder.SelectedIndex != 0)) { // oConn = new SqlConnection(NP.ReadFileDB(NP_Cls.PathDB)); if (oConn.State == ConnectionState.Open) { oConn.Close(); } oConn.Open(); try { SqlCommand cmdIns = new SqlCommand(); NP_Cls.SqlInsert = "INSERT INTO t_StockMovement " + "(DocNumber, TranDate, RefNumber, PlantCode, PlantName, BOMVersion, LocCode, LocName, Remark, UserCreate, DateCreate) " + "VALUES (@GINumber, GETDATE(),@PrdONumber,@PlantCode,@PlantName,@BOMVersion,@LocCode,@LocName,@Remark,@UD,GETDATE())"; this.strGNumber = GetNumber(); cmdIns.Parameters.Add("@GINumber", SqlDbType.NVarChar, 12).Value = this.strGNumber; //cmdIns.Parameters.Add("@MaterialCode", SqlDbType.NVarChar, 15).Value = this.lblHeadMaterial.Text.Trim().Split(':')[0].ToString(); //cmdIns.Parameters.Add("@MaterialName", SqlDbType.NVarChar, 60).Value = this.lblHeadMaterial.Text.Trim().Split(':')[1].ToString(); cmdIns.Parameters.Add("@PrdONumber", SqlDbType.NVarChar, 50).Value = this.cbPrdoOrder.Text.Trim(); cmdIns.Parameters.Add("@PlantCode", SqlDbType.NVarChar, 50).Value = this.strPlant; cmdIns.Parameters.Add("@PlantName", SqlDbType.NVarChar, 50).Value = this.lblPlant.Text.Trim(); cmdIns.Parameters.Add("@BOMVersion", SqlDbType.NVarChar, 5).Value = this.lblBOMVer.Text.Trim(); cmdIns.Parameters.Add("@LocCode", SqlDbType.NVarChar, 50).Value = this.strLoc; cmdIns.Parameters.Add("@LocName", SqlDbType.NVarChar, 50).Value = this.lblLocation.Text.Trim(); cmdIns.Parameters.Add("@Remark", SqlDbType.NVarChar, 255).Value = this.txtRemark.Text.Trim(); cmdIns.Parameters.Add("@UD", SqlDbType.NVarChar, 50).Value = NP_Cls.strUsr; cmdIns.Connection = oConn; cmdIns.CommandText = NP_Cls.SqlInsert; cmdIns.ExecuteNonQuery(); this.groupPR.Enabled = false; this.btnAddGI.Visible = false; this.btnSave.Visible = true; NP_Cls.SqlSelect = "SELECT DISTINCT t_PrdOrderDetail.ComponentName AS MaterialName, t_PrdOrderDetail.ComponentCode + ':' + t_PrdOrderDetail.ComponentName AS MaterialName AS MaterialCode FROM t_PrdOrder INNER JOIN t_PrdOrderDetail ON t_PrdOrder.PrdONumber = t_PrdOrderDetail.PrdONumber LEFT OUTER JOIN t_StockMovement ON t_PrdOrder.PrdONumber = t_StockMovement.RefNumber WHERE (t_PrdOrder.PrdONumber = N'" + this.cbPrdoOrder.Text.Trim() + "') AND (t_PrdOrderDetail.IsGIClose = 0) AND (t_StockMovement.IsClose = 0)"; NP.BindCB(this.cbMaterial, NP_Cls.SqlSelect, "MaterialName", "MaterialCode", "((( Select Material )))"); this.cbMaterial.Select(); this.cbMaterial.SelectAll(); } catch (Exception ex) { NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Add Header : " + ex.Message); return; } finally { if (oConn.State == ConnectionState.Open) { oConn.Close(); } } // } else { NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Please select vendor first !!"); return; } }
private void btnAddSO_Click(object sender, EventArgs e) { if ((!string.IsNullOrEmpty(this.cbCustomer.Text.Trim())) && (this.cbCustomer.SelectedIndex != 0)) { // oConn = new SqlConnection(NP.ReadFileDB(NP_Cls.PathDB)); if (oConn.State == ConnectionState.Open) { oConn.Close(); } oConn.Open(); try { SqlCommand cmdIns = new SqlCommand(); NP_Cls.SqlInsert = "INSERT INTO t_DO " + "(DONumber, DODate, CustomerCode, CustomerName, Terms, CurrencyCode, CurrencyName, Remark, UserCreate, DateCreate) " + "VALUES (@DONumber, GETDATE(),@CustomerCode,@CustomerName,@Terms,@CurrencyCode,@CurrencyName,@Remark,@UD, GETDATE())"; this.strGNumber = GetNumber(); cmdIns.Parameters.Add("@DONumber", SqlDbType.NVarChar, 12).Value = this.strGNumber; cmdIns.Parameters.Add("@CustomerCode", SqlDbType.NVarChar, 10).Value = this.cbCustomer.Text.Trim().Split(':')[0].Trim(); cmdIns.Parameters.Add("@CustomerName", SqlDbType.NVarChar, 60).Value = this.lblCustomer.Text.Trim(); cmdIns.Parameters.Add("@Terms", SqlDbType.Decimal).Value = Convert.ToDecimal(this.lblTerm.Text.Trim()); cmdIns.Parameters.Add("@CurrencyCode", SqlDbType.NVarChar, 3).Value = this.strCurr; cmdIns.Parameters.Add("@CurrencyName", SqlDbType.NVarChar, 20).Value = this.lblCurrency.Text.Trim(); cmdIns.Parameters.Add("@Remark", SqlDbType.NVarChar, 255).Value = this.txtRemark.Text.Trim(); cmdIns.Parameters.Add("@UD", SqlDbType.NVarChar, 50).Value = NP_Cls.strUsr; cmdIns.Connection = oConn; cmdIns.CommandText = NP_Cls.SqlInsert; cmdIns.ExecuteNonQuery(); this.groupPR.Enabled = false; this.btnAddSO.Visible = false; this.btnSave.Visible = true; BindCBSONumber(); this.cbSO.Select(); this.cbSO.SelectAll(); } catch (Exception ex) { NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Add Header : " + ex.Message); return; } finally { if (oConn.State == ConnectionState.Open) { oConn.Close(); } } // } else { NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Please select vendor first !!"); 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 ConnectDB() { try { oConn = new SqlConnection(NP.ReadFileDB(NP_Cls.PathDB)); oConn.Open(); oConn.Close(); } catch (Exception) { if (NP.MSGB("Can not Connect Database, Try agian later !!\nor Setteing Configuration ?") == DialogResult.Yes) { frmConfiguration frm = new frmConfiguration(); frm.ShowDialog(); ConnectDB(); } else { Application.Exit(); } } }
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 btnAdd_Click(object sender, EventArgs e) { try { if (NP.ReqField(this.txtEmpCode, "Please enter EmployeeCode: !!") == false) { return; } if (NP.ReqField(this.txtFirstName, "Please enter FirstName: !!") == false) { return; } if (NP.ReqField(this.txtLastName, "Please enter LastName: !!") == false) { return; } if (NP.ReqField(this.cbDepartment, "Please enter Department: !!") == false) { return; } if (NP.ReqField(this.cbLevel, "Please enter Level: !!") == false) { return; } if (NP.ReqField(this.txtUserName, "Please enter UserName: !!") == false) { return; } if (NP.ReqField(this.txtPass, "Please enter Password: !!") == false) { return; } if (NP.ReqField(this.txtConf, "Please enter Confirm: !!") == false) { return; } if (this.txtPass.Text.Trim() != this.txtConf.Text.Trim()) { NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Miss match password !!"); return; } if (ChkDup()) { NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Employee Code Or UserName Duplicated !!"); this.txtEmpCode.Select(); this.txtEmpCode.SelectAll(); return; } if (NP.MSGB("Do you want to Add User Data ?") == DialogResult.Yes) { oConn = new SqlConnection(NP.ReadFileDB(NP_Cls.PathDB)); if (oConn.State == ConnectionState.Open) { oConn.Close(); } oConn.Open(); try { SqlCommand cmdIns = new SqlCommand(); NP_Cls.SqlInsert = "INSERT INTO s_User " + "(EmployeeCode, EmployeeFirstName, EmployeeLastName, DepartmentCode, AuthLevel, UserName, Password, UserCreate, DateCreate, FileStatus) " + "VALUES (@EmployeeCode,@EmployeeFirstName,@EmployeeLastName,@DepartmentCode,@AuthLevel,@UserName,@Password,@UC, GETDATE(),@St)"; cmdIns.Parameters.Add("@EmployeeCode", SqlDbType.NVarChar, 10).Value = this.txtEmpCode.Text.Trim(); cmdIns.Parameters.Add("@EmployeeFirstName", SqlDbType.NVarChar, 20).Value = this.txtFirstName.Text.Trim(); cmdIns.Parameters.Add("@EmployeeLastName", SqlDbType.NVarChar, 20).Value = this.txtLastName.Text.Trim(); cmdIns.Parameters.Add("@DepartmentCode", SqlDbType.NVarChar, 3).Value = this.cbDepartment.SelectedValue; cmdIns.Parameters.Add("@AuthLevel", SqlDbType.NVarChar, 1).Value = this.cbLevel.Text;; cmdIns.Parameters.Add("@UserName", SqlDbType.NVarChar, 10).Value = this.txtUserName.Text.Trim(); cmdIns.Parameters.Add("@Password", SqlDbType.NVarChar, 10).Value = this.txtPass.Text.Trim(); cmdIns.Parameters.Add("@UC", SqlDbType.NVarChar, 10).Value = NP_Cls.strUsr; cmdIns.Parameters.Add("@St", SqlDbType.NVarChar, 1).Value = "1"; cmdIns.Connection = oConn; cmdIns.CommandText = NP_Cls.SqlInsert; cmdIns.ExecuteNonQuery(); Clear(); DGV(); NP.MSGB(NP_Cls.NPMgsStyle.InfoType, "Add Data Completed !!"); this.txtEmpCode.Focus(); } catch (Exception ex) { NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Add : " + ex.Message); return; } finally { if (oConn.State == ConnectionState.Open) { oConn.Close(); } } } else { return; } } catch (Exception ex) { NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Add : " + ex.Message); return; } }
private void btnAdd_Click(object sender, EventArgs e) { if (NP.ReqField(this.cbMaterial, "Please enter Material: !!") == false) { return; } if (NP.ReqField(this.cbPlant, "Please enter Plant: !!") == false) { return; } if (NP.ReqField(this.cbBOMType, "Please enter B.O.M Type: !!") == false) { return; } if (NP.ReqField(this.cbUnit, "Please enter Unit: !!") == false) { return; } if (NP.ReqField(this.txtQty, "Please enter Quantity: !!") == false) { return; } if (NP.ReqField(this.cbComponent, "Please enter Component: !!") == false) { return; } if (NP.ReqField(this.txtQtyComp, "Please enter Qty of Component: !!") == false) { return; } if (ChkDup()) { NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Code Duplicated !!"); this.cbComponent.Select(); return; } if (this.dgvView.RowCount != 0) { Double bChk = 0; for (byte i = 0; i < this.dgvView.RowCount; i++) { bChk += Convert.ToDouble(this.dgvView["clnQty", i].Value); } if ((Convert.ToDouble(this.txtQtyComp.Text.Trim()) + bChk) > 100) { NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Qty of Component is over 100 !!"); this.txtQtyComp.Select(); this.txtQtyComp.SelectAll(); return; } } else { if (this.cbBOMType.SelectedValue.ToString().ToUpper() == "M") { if (Convert.ToDouble(this.txtQtyComp.Text.Trim()) > 100) { NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Qty of Component is over 100 !!"); this.txtQtyComp.Select(); this.txtQtyComp.SelectAll(); 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.SqlSelect = "SELECT MaterialCode, PlantCode FROM t_BOM WHERE (MaterialCode = @MaterialCode) AND (PlantCode = @PlantCode) AND (BOMVersion = @Ver)"; cmdIns.Parameters.Add("@MaterialCode", SqlDbType.NVarChar, 15).Value = this.cbMaterial.SelectedValue; cmdIns.Parameters.Add("@PlantCode", SqlDbType.NVarChar, 4).Value = this.cbPlant.SelectedValue; cmdIns.Parameters.Add("@Ver", SqlDbType.NVarChar, 20).Value = this.txtVersion.Text.Trim(); cmdIns.Connection = oConn; cmdIns.CommandText = NP_Cls.SqlSelect; cmdIns.Transaction = Tr; SqlDataAdapter da = new SqlDataAdapter(cmdIns); DataSet ds = new DataSet(); da.Fill(ds); if (ds.Tables[0].Rows.Count == 0) { GenVCode(); NP_Cls.SqlInsert = "INSERT INTO t_BOM " + "(BOMCode, MaterialCode, PlantCode, BOMType, UnitCode, Quantity, BOMVersion, UserCreate, DateCreate, FileStatus, Approve) " + "VALUES (@BOMCode,@MaterialCode,@PlantCode,@BOMType,@UnitCode,@Quantity,@BOMVersion,@UC, GETDATE(),@St,@Appr)"; cmdIns.Parameters.Add("@BOMCode", SqlDbType.Int).Value = NP_Cls.strBOMCode; cmdIns.Parameters.Add("@BOMType", SqlDbType.NVarChar, 1).Value = this.cbBOMType.SelectedValue; cmdIns.Parameters.Add("@UnitCode", SqlDbType.NVarChar, 3).Value = this.cbUnit.SelectedValue; cmdIns.Parameters.Add("@Quantity", SqlDbType.Int).Value = Convert.ToInt32(this.txtQty.Text.Trim()); cmdIns.Parameters.Add("@BOMVersion", SqlDbType.Int).Value = this.txtVersion.Text.Trim(); cmdIns.Parameters.Add("@UC", SqlDbType.NVarChar, 10).Value = NP_Cls.strUsr; cmdIns.Parameters.Add("@St", SqlDbType.NVarChar, 1).Value = "1"; cmdIns.Parameters.Add("@Appr", SqlDbType.Bit).Value = 0; cmdIns.Connection = oConn; cmdIns.CommandText = NP_Cls.SqlInsert; cmdIns.Transaction = Tr; cmdIns.ExecuteNonQuery(); NP_Cls.SqlInsert = "INSERT INTO t_BOMDetail " + "(BOMCode, Category, MaterialCode, Quantity) " + "VALUES (@BOMCode,@Category,@CompCode,@QtyComp)"; cmdIns.Parameters.Add("@CompCode", SqlDbType.NVarChar, 15).Value = this.cbComponent.SelectedValue; cmdIns.Parameters.Add("@Category", SqlDbType.NVarChar, 1).Value = ChkCategory(oConn, Tr, this.cbComponent.SelectedValue.ToString()); cmdIns.Parameters.Add("@QtyComp", SqlDbType.Decimal).Value = Convert.ToDouble(this.txtQtyComp.Text.Trim()); cmdIns.Connection = oConn; cmdIns.CommandText = NP_Cls.SqlInsert; cmdIns.Transaction = Tr; cmdIns.ExecuteNonQuery(); Tr.Commit(); this.cbComponent.SelectedIndex = 0; this.txtQtyComp.Text = string.Empty; DGV(); NP.MSGB(NP_Cls.NPMgsStyle.InfoType, "Add Data Completed !!"); this.cbMaterial.Select(); } else { NP_Cls.strBOMCode = this.dgvView["clnBOMCode", 0].Value.ToString(); NP_Cls.SqlInsert = "INSERT INTO t_BOMDetail " + "(BOMCode, Category, MaterialCode, Quantity) " + "VALUES (@BOMCode,@Category,@CompCode,@QtyComp)"; cmdIns.Parameters.Add("@BOMCode", SqlDbType.Int).Value = NP_Cls.strBOMCode; cmdIns.Parameters.Add("@CompCode", SqlDbType.NVarChar, 15).Value = this.cbComponent.SelectedValue; cmdIns.Parameters.Add("@Category", SqlDbType.NVarChar, 1).Value = ChkCategory(oConn, Tr, this.cbComponent.SelectedValue.ToString()); cmdIns.Parameters.Add("@QtyComp", SqlDbType.Decimal).Value = Convert.ToDouble(this.txtQtyComp.Text.Trim()); cmdIns.Connection = oConn; cmdIns.CommandText = NP_Cls.SqlInsert; cmdIns.Transaction = Tr; cmdIns.ExecuteNonQuery(); Tr.Commit(); this.cbComponent.SelectedIndex = 0; this.txtQtyComp.Text = string.Empty; DGV(); NP.MSGB(NP_Cls.NPMgsStyle.InfoType, "Add Data Completed !!"); this.cbMaterial.Select(); } } 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 btnAdd_Click(object sender, EventArgs e) { if (NP.ReqField(this.txtCode, "Please enter Code: !!") == false) { return; } if (NP.ReqField(this.txtName, "Please enter Name: !!") == false) { return; } try { byte bRe = 0; if (ChkDup(ref bRe)) { NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Code Duplicated !!"); this.txtCode.Select(); this.txtCode.SelectAll(); return; } else { if (bRe == 1) { Clear(); DGV(); NP.MSGB(NP_Cls.NPMgsStyle.InfoType, "Update Data Completed !!"); this.txtCode.Focus(); return; } } } catch (Exception ex) { NP.MSGB("Erro Dup : " + ex.Message); return; } if (NP.MSGB("Do you want to Add Data ?") == DialogResult.Yes) { oConn = new SqlConnection(NP.ReadFileDB(Application.StartupPath + @"\DB\DB.ini")); if (oConn.State == ConnectionState.Open) { oConn.Close(); } oConn.Open(); try { SqlCommand cmdIns = new SqlCommand(); NP_Cls.SqlInsert = "INSERT INTO m_WorkCenter " + " (WorkCenterCode, WorkCenterName, PlantCode, WorkCenterMachine, WorkCenterSetup, WorkCenterLabor, WorkCenterOT, UserCreate, DateCreate, FileStatus) " + "VALUES (@WorkCenterCode,@WorkCenterName,@PlantCode,@WorkCenterMachine,@WorkCenterSetup,@WorkCenterLabor,@WorkCenterOT,@UC, GETDATE(),@St)"; cmdIns.Parameters.Add("@WorkCenterCode", SqlDbType.NVarChar, 10).Value = this.txtCode.Text.Trim(); cmdIns.Parameters.Add("@WorkCenterName", SqlDbType.NVarChar, 40).Value = this.txtName.Text.Trim(); cmdIns.Parameters.Add("@PlantCode", SqlDbType.NVarChar, 10).Value = this.cbPlant.SelectedValue; cmdIns.Parameters.Add("@WorkCenterMachine", SqlDbType.Int).Value = Convert.ToInt32(string.IsNullOrEmpty(this.txtMachine.Text.Trim()) ? "0" : this.txtMachine.Text.Trim()); cmdIns.Parameters.Add("@WorkCenterSetup", SqlDbType.Int).Value = Convert.ToInt32(string.IsNullOrEmpty(this.txtSetup.Text.Trim()) ? "0" : this.txtSetup.Text.Trim()); cmdIns.Parameters.Add("@WorkCenterLabor", SqlDbType.Int).Value = Convert.ToInt32(string.IsNullOrEmpty(this.txtLabor.Text.Trim()) ? "0" : this.txtLabor.Text.Trim()); cmdIns.Parameters.Add("@WorkCenterOT", SqlDbType.Int).Value = Convert.ToInt32(string.IsNullOrEmpty(this.txtOT.Text.Trim()) ? "0" : this.txtOT.Text.Trim()); cmdIns.Parameters.Add("@UC", SqlDbType.NVarChar, 10).Value = NP_Cls.strUsr; cmdIns.Parameters.Add("@St", SqlDbType.NVarChar, 1).Value = "1"; cmdIns.Connection = oConn; cmdIns.CommandText = NP_Cls.SqlInsert; cmdIns.ExecuteNonQuery(); Clear(); DGV(); NP.MSGB(NP_Cls.NPMgsStyle.InfoType, "Add Data Completed !!"); this.txtCode.Focus(); } catch (Exception ex) { NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Edit : " + 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.txtCode, "Please enter Code: !!") == false) { return; } if (NP.ReqField(this.txtName, "Please enter Name: !!") == false) { return; } if (NP.ReqField(this.cbPG, "Please enter Purchasing group: !!") == false) { return; } if (NP.ReqField(this.cbCurrencyCode, "Please enter Currency: !!") == false) { return; } if (NP.ReqField(this.txtTerm, "Please enter Term of patment: !!") == false) { return; } try { byte bRe = 0; if (ChkDup(ref bRe)) { NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Code Duplicated !!"); this.txtCode.Select(); this.txtCode.SelectAll(); return; } else { if (bRe == 1) { Clear(); DGV(); NP.MSGB(NP_Cls.NPMgsStyle.InfoType, "Update Data Completed !!"); this.txtCode.Focus(); return; } } } catch (Exception ex) { NP.MSGB("Erro Dup : " + ex.Message); return; } if (NP.MSGB("Do you want to Add Data ?") == DialogResult.Yes) { oConn = new SqlConnection(NP.ReadFileDB(Application.StartupPath + @"\DB\DB.ini")); if (oConn.State == ConnectionState.Open) { oConn.Close(); } oConn.Open(); try { SqlCommand cmdIns = new SqlCommand(); NP_Cls.SqlInsert = "INSERT INTO m_Vendor (Remark,VendorCode, VendorName, PurchasingGroup,VendorAddress, VendorPostalCode, VendorTelephone, VendorFax, CurrencyCode, TermsOfPayment, UserCreate, DateCreate, FileStatus, VendorContactPerson, VendorMobile, VendorEmail) VALUES (@Remark,@Code,@Name,@PG,@Address,@PostalCode,@Tel,@Fax,@OrderCurr,@Terms,@UC,getdate(),@St,@ContactP,@Mobile,@Email)"; cmdIns.Parameters.Add("@Code", SqlDbType.NVarChar, 10).Value = this.txtCode.Text.Trim(); cmdIns.Parameters.Add("@Name", SqlDbType.NVarChar, 60).Value = this.txtName.Text.Trim(); cmdIns.Parameters.Add("@PG", SqlDbType.NVarChar, 3).Value = this.cbPG.SelectedValue; cmdIns.Parameters.Add("@Address", SqlDbType.NVarChar, 120).Value = this.txtAddress.Text.Trim(); cmdIns.Parameters.Add("@PostalCode", SqlDbType.NVarChar, 20).Value = this.txtPostal.Text.Trim(); cmdIns.Parameters.Add("@Tel", SqlDbType.NVarChar, 30).Value = this.txtTele.Text.Trim(); cmdIns.Parameters.Add("@Fax", SqlDbType.NVarChar, 20).Value = this.txtFax.Text.Trim(); cmdIns.Parameters.Add("@OrderCurr", SqlDbType.NVarChar, 3).Value = this.cbCurrencyCode.SelectedValue; cmdIns.Parameters.Add("@Terms", SqlDbType.NVarChar, 20).Value = this.txtTerm.Text.Trim(); cmdIns.Parameters.Add("@UC", SqlDbType.NVarChar, 10).Value = NP_Cls.strUsr; cmdIns.Parameters.Add("@St", SqlDbType.NVarChar, 1).Value = "1"; cmdIns.Parameters.Add("@ContactP", SqlDbType.NVarChar, 50).Value = this.txtContactNo.Text.Trim(); cmdIns.Parameters.Add("@Mobile", SqlDbType.NVarChar, 60).Value = this.txtMobileNo.Text.Trim(); cmdIns.Parameters.Add("@Email", SqlDbType.NVarChar, 100).Value = this.txtEmail.Text.Trim(); cmdIns.Parameters.Add("@Remark", SqlDbType.NVarChar, 200).Value = this.txtRemark.Text.Trim(); cmdIns.Connection = oConn; cmdIns.CommandText = NP_Cls.SqlInsert; cmdIns.ExecuteNonQuery(); Clear(); DGV(); NP.MSGB(NP_Cls.NPMgsStyle.InfoType, "Add Data Completed !!"); this.txtCode.Focus(); } catch (Exception ex) { NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Add : " + ex.Message); } 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 btnSave_Click(object sender, EventArgs e) { if (NP.MSGB("Do you to Save Production Order no Job ?") == 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 { if (!Convert.ToBoolean(bView)) { SqlCommand cmdIns = new SqlCommand(); NP_Cls.SqlInsert = "INSERT INTO t_Borrow (RefNumber, BorrowDate, MaterialCode, MaterialName, BorrowQuantity, UnitCode, UnitName, PlantCode, PlantName, LocCode, LocName, Remark, UserCreate, DateCreate) VALUES (@RefNumber,GETDATE(),@MaterialCode,@MaterialName,@BorrowQuantity,@UnitCode, @UnitName, @PlantCode,@PlantName,@LocCode,@LocName,@Remark,@UserCreate, GETDATE())"; cmdIns.Parameters.Add("@RefNumber", SqlDbType.NVarChar, 12); cmdIns.Parameters.Add("@MaterialCode", SqlDbType.NVarChar, 15); cmdIns.Parameters.Add("@MaterialName", SqlDbType.NVarChar, 60); cmdIns.Parameters.Add("@BorrowQuantity", SqlDbType.Decimal); cmdIns.Parameters.Add("@UnitCode", SqlDbType.NVarChar, 4); 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("@Remark", SqlDbType.NVarChar, 255); cmdIns.Parameters.Add("@UserCreate", SqlDbType.NVarChar, 50); //SqlCommand cmdInsDetail = new SqlCommand(); //NP_Cls.SqlInsert = "INSERT INTO t_PrdOrderDetail (PrdONumber, ComponentCode, ComponentName, PrdOQuantity, UnitCode, UnitName, PlantCode, PlantName, LocCode, LocName, CurrentUser) VALUES (@PrdONumber,@ComponentCode,@ComponentName,@PrdOQuantity,@UnitCode,@UnitName,@PlantCode,@PlantName,@LocCode,@LocName,@CurrentUser)"; //cmdInsDetail.Parameters.Add("@PrdONumber", SqlDbType.NVarChar, 12); //cmdInsDetail.Parameters.Add("@ComponentCode", SqlDbType.NVarChar, 15); //cmdInsDetail.Parameters.Add("@ComponentName", SqlDbType.NVarChar, 60); //cmdInsDetail.Parameters.Add("@PrdOQuantity", SqlDbType.Decimal); //cmdInsDetail.Parameters.Add("@UnitCode", SqlDbType.NVarChar, 3); //cmdInsDetail.Parameters.Add("@UnitName", SqlDbType.NVarChar, 20); //cmdInsDetail.Parameters.Add("@PlantCode", SqlDbType.NVarChar, 4); //cmdInsDetail.Parameters.Add("@PlantName", SqlDbType.NVarChar, 20); //cmdInsDetail.Parameters.Add("@LocCode", SqlDbType.NVarChar, 2); //cmdInsDetail.Parameters.Add("@LocName", SqlDbType.NVarChar, 20); //cmdInsDetail.Parameters.Add("@CurrentUser", SqlDbType.NVarChar, 50); for (byte ins = 0; ins < this.dgvView.RowCount; ins++) { cmdIns.Parameters["@RefNumber"].Value = this.txtPrdOrder.Text.Trim(); cmdIns.Parameters["@MaterialCode"].Value = this.dgvView["clnMaterialCode", ins].Value.ToString(); cmdIns.Parameters["@MaterialName"].Value = this.dgvView["clnMaterialName", ins].Value.ToString(); cmdIns.Parameters["@BorrowQuantity"].Value = Convert.ToDecimal(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["@UserCreate"].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["@Remark"].Value = this.txtRemark.Text.Trim(); cmdIns.Parameters.Add("@BatchNumber", SqlDbType.NVarChar, 10).Value = this.dgvView["clnBatch", ins].Value.ToString(); cmdIns.Connection = oConn; cmdIns.CommandText = NP_Cls.SqlInsert; cmdIns.Transaction = Tr; cmdIns.ExecuteNonQuery(); // Stock Overview // NP_Cls.sqlUpdate = "UPDATE t_StockOverview SET UR = UR - @BorrowQuantity WHERE (BatchNumber = @BatchNumber)"; cmdIns.Connection = oConn; cmdIns.CommandText = NP_Cls.sqlUpdate; cmdIns.Transaction = Tr; cmdIns.ExecuteNonQuery(); } cmdIns.Parameters.Clear(); // Master NP_Cls.SqlInsert = "INSERT INTO t_StockMovement " + "(DocNumber, TranDate, MovementType, RefNumber, Remark, UserCreate, DateCreate) " + "VALUES (@GINumber, GETDATE(), @MV, @PrdONumber,@Remark,@UD,GETDATE())"; Random rnd = new Random(); string tmpString = "BR" + DateTime.Now.Year.ToString(NP_Cls.cul) + rnd.Next(1, 99999); cmdIns.Parameters.Add("@GINumber", SqlDbType.NVarChar, 12).Value = tmpString; cmdIns.Parameters.Add("@PrdONumber", SqlDbType.NVarChar, 50).Value = this.txtPrdOrder.Text.Trim(); cmdIns.Parameters.Add("@MV", SqlDbType.NVarChar, 3).Value = (!string.IsNullOrEmpty(this.txtPrdOrder.Text.Trim()) ? "261" : "999"); cmdIns.Parameters.Add("@Remark", SqlDbType.NVarChar, 500).Value = this.lblPlant.Text.Trim(); cmdIns.Parameters.Add("@UD", SqlDbType.NVarChar, 50).Value = NP_Cls.strUsr; cmdIns.Connection = oConn; cmdIns.CommandText = NP_Cls.SqlInsert; cmdIns.Transaction = Tr; cmdIns.ExecuteNonQuery(); // Detail cmdIns.Parameters.Clear(); NP_Cls.SqlInsert = "INSERT INTO t_StockMovementDetail " + "(AutoID,DocNumber, MaterialCode, MaterialName, Quantity, UnitCode, UnitName, PlantCode, PlantName, LocCode, LocName, CurrentUser, RefNumber, BatchNumber) " + "VALUES (@AutoID, @DocNumber,@MaterialCode,@MaterialName,@GIQuantity,@UnitCode,@UnitName,@PlantCode,@PlantName,@LocCode,@LocName,@CurrentUser,@PrdONumber, @BatchNumber)"; cmdIns.Parameters.Add("@AutoID", SqlDbType.Int); 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, 4); 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("@DocNumber", SqlDbType.NVarChar, 12); for (byte ins = 0; ins < this.dgvView.RowCount; ins++) { cmdIns.Parameters["@AutoID"].Value = ins; 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.ToString()); 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.txtPrdOrder.Text.Trim(); cmdIns.Parameters["@DocNumber"].Value = tmpString; cmdIns.Parameters["@BatchNumber"].Value = this.dgvView["clnBatch", ins].Value.ToString(); cmdIns.Connection = oConn; cmdIns.CommandText = NP_Cls.SqlInsert; cmdIns.Transaction = Tr; cmdIns.ExecuteNonQuery(); } Tr.Commit(); NP.MSGB(NP_Cls.NPMgsStyle.InfoType, "Save Production Order Completed !!"); Clear(); this.btnSave.Visible = false; this.MyGrid(dgvView); this.txtPrdOrder.DropDownStyle = ComboBoxStyle.Simple; BindCB(); this.cbMaterialCode.Enabled = true; this.cbMaterialCode.Text = string.Empty; this.cbMaterialCode.Select(); this.cbMaterialCode.SelectAll(); } } 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.txtCode, "Please enter Code: !!") == false) { return; } if (NP.ReqField(this.txtName, "Please enter Name: !!") == false) { return; } if (NP.ReqField(this.cbUnit, "Please choose Unit: !!") == false) { return; } if (NP.ReqField(this.cbPlant, "Please choose Plant: !!") == false) { return; } if (NP.ReqField(this.cbLoc, "Please choose Location: !!") == false) { return; } if (this.cbMT.SelectedIndex == -1) { NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Please choose Material Type: !!"); this.cbMT.Select(); return; } if (this.txtProcureType.SelectedIndex == -1) { NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Please choose Procurement Type: !!"); this.txtProcureType.Select(); return; } try { byte bRe = 0; if (ChkDup(ref bRe)) { NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Code Duplicated !!"); this.txtCode.Select(); this.txtCode.SelectAll(); return; } else { if (bRe == 1) { Clear(); DGV(); NP.MSGB(NP_Cls.NPMgsStyle.InfoType, "Update Data Completed !!"); this.txtCode.Focus(); return; } } } catch (Exception ex) { NP.MSGB("Erro Dup : " + ex.Message); return; } if (NP.MSGB("Do you want to Add Data ?") == DialogResult.Yes) { oConn = new SqlConnection(NP.ReadFileDB(Application.StartupPath + @"\DB\DB.ini")); if (oConn.State == ConnectionState.Open) { oConn.Close(); } oConn.Open(); try { SqlCommand cmdIns = new SqlCommand(); NP_Cls.SqlInsert = "INSERT INTO m_Material " + "(MaterialCode, MaterialName, ChemicalName, MaterialTypeName, MaterialGroupCode, UnitCode, PlantCode, LocCode, CustomerProduct, ProcurementType, GRProcessingTime, " + "DeliveryTime, InHouseProduction, ShelfLife, MovAvgPrice, StandardCost, UserCreate, DateCreate, FileStatus) " + "VALUES (@MaterialCode,@MaterialName,@ChemicalName,@MaterialTypeName,@MaterialGroupCode,@UnitCode,@PlantCode,@LocCode,@CustomerProduct,@ProcurementType," + "@GRProcessingTime,@DeliveryTime,@InHouseProduction,@ShelfLife,@MovAvgPrice,@StandardCost,@UC, GETDATE(),@St)"; cmdIns.Parameters.Add("@MaterialCode", SqlDbType.NVarChar, 15).Value = this.txtCode.Text.Trim(); cmdIns.Parameters.Add("@MaterialName", SqlDbType.NVarChar, 60).Value = this.txtName.Text.Trim(); cmdIns.Parameters.Add("@ChemicalName", SqlDbType.NVarChar, 60).Value = this.txtChemicalName.Text.Trim(); cmdIns.Parameters.Add("@MaterialTypeName", SqlDbType.NVarChar, 20).Value = this.cbMT.Text.Trim(); cmdIns.Parameters.Add("@MaterialGroupCode", SqlDbType.NVarChar, 3).Value = this.cbMaterialGroup.SelectedValue; cmdIns.Parameters.Add("@UnitCode", SqlDbType.NVarChar, 3).Value = this.cbUnit.SelectedValue; cmdIns.Parameters.Add("@PlantCode", SqlDbType.NVarChar, 4).Value = this.cbPlant.SelectedValue; cmdIns.Parameters.Add("@LocCode", SqlDbType.NVarChar, 2).Value = this.cbLoc.SelectedValue; cmdIns.Parameters.Add("@CustomerProduct", SqlDbType.NVarChar, 15).Value = this.txtCustProduct.Text.Trim(); cmdIns.Parameters.Add("@ProcurementType", SqlDbType.NVarChar, 1).Value = this.txtProcureType.Text.Trim(); cmdIns.Parameters.Add("@GRProcessingTime", SqlDbType.Decimal).Value = Convert.ToDecimal(string.IsNullOrEmpty(this.txtGR.Text.Trim()) ? "0" : this.txtGR.Text.Trim()); cmdIns.Parameters.Add("@DeliveryTime", SqlDbType.Decimal).Value = Convert.ToDecimal(string.IsNullOrEmpty(this.txtDelivery.Text.Trim()) ? "0" : this.txtDelivery.Text.Trim()); cmdIns.Parameters.Add("@InHouseProduction", SqlDbType.Decimal).Value = Convert.ToDecimal(string.IsNullOrEmpty(this.txtInHouse.Text.Trim()) ? "0" : this.txtInHouse.Text.Trim()); cmdIns.Parameters.Add("@ShelfLife", SqlDbType.Decimal).Value = Convert.ToDecimal(string.IsNullOrEmpty(this.txtShelfLife.Text.Trim()) ? "0" : this.txtShelfLife.Text.Trim()); cmdIns.Parameters.Add("@MovAvgPrice", SqlDbType.Decimal).Value = Convert.ToDecimal(string.IsNullOrEmpty(this.txtMovAvg.Text.Trim()) ? "0" : this.txtMovAvg.Text.Trim()); cmdIns.Parameters.Add("@StandardCost", SqlDbType.Decimal).Value = Convert.ToDecimal(string.IsNullOrEmpty(this.txtStandardCost.Text.Trim()) ? "0" : this.txtStandardCost.Text.Trim()); cmdIns.Parameters.Add("@UC", SqlDbType.NVarChar, 10).Value = NP_Cls.strUsr; cmdIns.Parameters.Add("@St", SqlDbType.NVarChar, 1).Value = "1"; cmdIns.Connection = oConn; cmdIns.CommandText = NP_Cls.SqlInsert; cmdIns.ExecuteNonQuery(); Clear(); DGV(); NP.MSGB(NP_Cls.NPMgsStyle.InfoType, "Add Data Completed !!"); this.txtCode.Focus(); } catch (Exception ex) { NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Edit : " + ex.Message); return; } finally { if (oConn.State == ConnectionState.Open) { oConn.Close(); } } } else { return; } }
private void btnAdd_Click(object sender, EventArgs e) { //for (byte ii = 0; ii < this.dgvView.RowCount; ii++) //{ // if (Convert.ToDouble(this.dgvView["clnDiff", ii].Value) < 0) // { // NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Save with warning !!"); return; // } //} if (NP.MSGB("Do you to Save Picking ?") == 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(); // Master NP_Cls.SqlInsert = "INSERT INTO t_StockMovement " + "( DocNumber, TranDate, RefNumber, PlantCode, PlantName, LocCode, LocName, UserCreate, DateCreate,BomVersion) " + "VALUES (@GINumber, GETDATE(),@PrdONumber,@PlantCode,@PlantName,@LocCode,@LocName,@UD,GETDATE(),@BomVersion)"; cmdIns.Parameters.Add("@GINumber", SqlDbType.NVarChar, 12).Value = this.txtProdOrder.Text.Trim(); cmdIns.Parameters.Add("@BomVersion", SqlDbType.Int).Value = Convert.ToInt32(this.lblBOMVer.Text.Trim()); cmdIns.Parameters.Add("@PrdONumber", SqlDbType.NVarChar, 50).Value = this.txtProdOrder.Text.Trim(); cmdIns.Parameters.Add("@PlantCode", SqlDbType.NVarChar, 50).Value = this.lblPlantCode.Text.Trim(); cmdIns.Parameters.Add("@PlantName", SqlDbType.NVarChar, 50).Value = this.lblPlant.Text.Trim(); cmdIns.Parameters.Add("@LocCode", SqlDbType.NVarChar, 50).Value = this.lblLocCode.Text.Trim(); cmdIns.Parameters.Add("@LocName", SqlDbType.NVarChar, 50).Value = this.lblLoc.Text.Trim(); cmdIns.Parameters.Add("@UD", SqlDbType.NVarChar, 50).Value = NP_Cls.strUsr; cmdIns.Connection = oConn; cmdIns.CommandText = NP_Cls.SqlInsert; cmdIns.Transaction = Tr; cmdIns.ExecuteNonQuery(); // Detail NP_Cls.SqlInsert = "INSERT INTO t_StockMovementDetail " + "(AutoID,DocNumber, MaterialCode, MaterialName, Quantity, UnitCode, UnitName, PlantCode, PlantName, LocCode, LocName, CurrentUser, RefNumber, BatchNumber) " + "VALUES (@AutoID, @GINumber,@MaterialCode,@MaterialName,@GIQuantity,@UnitCode,@UnitName,@PlantCode,@PlantName,@LocCode,@LocName,@CurrentUser,@PrdONumber, @BatchNumber)"; cmdIns.Parameters.Add("@AutoID", SqlDbType.Int); 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); //Fixed Issue 27/04/2013 //double clnQuantityValue = 0.000; for (byte ins = 0; ins < this.dgvView.RowCount; ins++) { //For Stock Overview AddDetail(oConn, Tr, cmdIns, (this.dgvView["clnQuantity", ins].Value == DBNull.Value ? 0.000 : Convert.ToDouble(this.dgvView["clnQuantity", ins].Value)), this.dgvView["clnMaterialCode", ins].Value.ToString(), ins); //if (this.dgvView["clnQuantity", ins].Value != DBNull.Value) // clnQuantityValue = Convert.ToDouble(this.dgvView["clnQuantity", ins].Value); } cmdIns.Parameters.Clear(); //ToDo 0510 NP_Cls.sqlUpdate = "UPDATE t_PrdOrder SET IsPicking = 1 WHERE (PrdONumber = '" + this.txtProdOrder.Text.Trim() + "')"; cmdIns.Connection = oConn; cmdIns.CommandText = NP_Cls.sqlUpdate; cmdIns.Transaction = Tr; cmdIns.ExecuteNonQuery(); //ToDo 0710 NP_Cls.SqlSelect = "SELECT PrdONumber, PrdOQuantity - GIQty AS Diff, ComponentCode FROM t_PrdOrderDetail WHERE (PrdONumber = N'" + this.txtProdOrder.Text.Trim() + "')"; DataSet dsFIS = new DataSet(); dsFIS = NP.GetDataWithTran(NP_Cls.SqlSelect, Tr, oConn); for (int fis = 0; fis < dsFIS.Tables[0].Rows.Count; fis++) { if (Convert.ToDouble(dsFIS.Tables[0].Rows[fis][1]) == 0) { NP_Cls.sqlUpdate = "UPDATE t_PrdOrderDetail SET FIS = 1 WHERE (ComponentCode = '" + dsFIS.Tables[0].Rows[fis][2].ToString() + "')"; cmdIns.Connection = oConn; cmdIns.CommandText = NP_Cls.sqlUpdate; cmdIns.Transaction = Tr; cmdIns.ExecuteNonQuery(); } } //TODO 28082012 Save Picking tbl cmdIns.Parameters.Clear(); NP_Cls.SqlInsert = "INSERT INTO t_Picking (PrdONumber, PickingDate, MaterialCode, MaterialName, PrdQuantity, PlantCode, PlantName, BOMVersion, LocCode, LocName, UserCreate, DateCreate) VALUES (@PrdONumber, GETDATE(), @MaterialCode, @MaterialName, @PrdQuantity, @PlantCode, @PlantName, @BOMVersion, @LocCode, @LocName, @UC, GETDATE())"; cmdIns.Parameters.Add("@PrdONumber", SqlDbType.NVarChar, 50).Value = this.txtProdOrder.Text.Trim(); cmdIns.Parameters.Add("@MaterialCode", SqlDbType.NVarChar, 15).Value = this.lblMatCode.Text.Trim(); cmdIns.Parameters.Add("@MaterialName", SqlDbType.NVarChar, 60).Value = this.lblMatName.Text.Trim(); cmdIns.Parameters.Add("@PrdQuantity", SqlDbType.Decimal).Value = Decimal.Parse(this.lblPrdQty.Text.Trim()); cmdIns.Parameters.Add("@PlantCode", SqlDbType.NVarChar, 10).Value = this.lblPlantCode.Text.Trim(); cmdIns.Parameters.Add("@PlantName", SqlDbType.NVarChar, 50).Value = this.lblPlant.Text.Trim(); cmdIns.Parameters.Add("@LocCode", SqlDbType.NVarChar, 2).Value = this.lblLocCode.Text.Trim(); cmdIns.Parameters.Add("@LocName", SqlDbType.NVarChar, 50).Value = this.lblLoc.Text.Trim(); cmdIns.Parameters.Add("@BOMVersion", SqlDbType.NVarChar, 10).Value = this.lblBOMVer.Text.Trim(); cmdIns.Parameters.Add("@UC", SqlDbType.NVarChar, 50).Value = NP_Cls.strUsr; cmdIns.Connection = oConn; cmdIns.CommandText = NP_Cls.SqlInsert; cmdIns.Transaction = Tr; cmdIns.ExecuteNonQuery(); cmdIns.Parameters.Clear(); cmdIns.Parameters.Add("@PickingID", SqlDbType.Int); cmdIns.Parameters.Add("@PickingDetailID", SqlDbType.Int); cmdIns.Parameters.Add("@MaterialCode", SqlDbType.NVarChar, 15); cmdIns.Parameters.Add("@MaterialName", SqlDbType.NVarChar, 60); cmdIns.Parameters.Add("@PickingQuantity", SqlDbType.Decimal); cmdIns.Parameters.Add("@ShortQuantity", SqlDbType.Decimal); cmdIns.Parameters.Add("@UnitCode", SqlDbType.NVarChar, 10); cmdIns.Parameters.Add("@UnitName", SqlDbType.NVarChar, 50); cmdIns.Parameters.Add("@PlantCode", SqlDbType.NVarChar, 10); cmdIns.Parameters.Add("@PlantName", SqlDbType.NVarChar, 50); cmdIns.Parameters.Add("@LocCode", SqlDbType.NVarChar, 2); cmdIns.Parameters.Add("@LocName", SqlDbType.NVarChar, 50); cmdIns.Parameters.Add("@BatchNumber", SqlDbType.NVarChar, 50); cmdIns.Parameters.Add("@UC", SqlDbType.NVarChar, 50); //Fixed Issue 27/04/2013 decimal QuantityValue = 0.00M; //Get PickingID int iPickingID = int.Parse(NP.GetDataWithTran("SELECT ISNULL(PickingID,0) AS PickingID FROM t_Picking ORDER BY PickingID DESC", Tr, oConn).Tables[0].Rows[0][0].ToString()); for (byte ins = 0; ins < this.dgvView.RowCount; ins++) { NP_Cls.SqlInsert = "INSERT INTO t_PickingDetail (PickingID, PickingDetailID, ComponentCode, ComponentName, PickingQuantity, ShortQuantity, UnitCode, UnitName, PlantCode, PlantName, LocCode, LocName, BatchNumber, CurrentUser) VALUES (@PickingID, @PickingDetailID, @MaterialCode, @MaterialName, @PickingQuantity, @ShortQuantity, @UnitCode, @UnitName, @PlantCode, @PlantName, @LocCode, @LocName, @BatchNumber, @UC)"; cmdIns.Parameters["@PickingID"].Value = iPickingID; cmdIns.Parameters["@PickingDetailID"].Value = ins + 1; cmdIns.Parameters["@MaterialCode"].Value = this.dgvView["clnMaterialCode", ins].Value.ToString(); cmdIns.Parameters["@MaterialName"].Value = this.dgvView["clnMaterialName", ins].Value.ToString(); cmdIns.Parameters["@PickingQuantity"].Value = (string.IsNullOrEmpty(this.dgvView["clnQuantity", ins].Value.ToString()) ? QuantityValue.ToString() : this.dgvView["clnQuantity", ins].Value.ToString()); if (this.dgvView["clnQuantity", ins].Value != DBNull.Value) { QuantityValue = Convert.ToDecimal(this.dgvView["clnQuantity", ins].Value); } cmdIns.Parameters["@ShortQuantity"].Value = decimal.Parse(this.dgvView["clnCurQty", ins].Value.ToString()) - decimal.Parse((this.dgvView["clnStockQty", ins].Value.ToString() == string.Empty ? "0" : this.dgvView["clnStockQty", ins].Value.ToString())); cmdIns.Parameters["@UnitCode"].Value = this.dgvView["clnUnitCode", ins].Value.ToString(); cmdIns.Parameters["@UnitName"].Value = this.dgvView["clnUnitName", ins].Value.ToString(); 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["@BatchNumber"].Value = this.dgvView["clnBatch", ins].Value.ToString(); cmdIns.Parameters["@UC"].Value = NP_Cls.strUsr; cmdIns.Connection = oConn; cmdIns.CommandText = NP_Cls.SqlInsert; cmdIns.Transaction = Tr; cmdIns.ExecuteNonQuery(); } Tr.Commit(); NP.MSGB(NP_Cls.NPMgsStyle.InfoType, "Save Picking Completed !!"); btnAdd.Visible = false; //TODO Picking 2809 //Report NP_Cls.SqlSelect = "SELECT 0 AS ItemNo, t_Picking.PrdONumber, t_Picking.PickingDate, t_Picking.MaterialCode, t_Picking.MaterialName, t_Picking.PrdQuantity, t_Picking.PlantCode, t_Picking.PlantName, t_Picking.BOMVersion, t_Picking.LocCode, t_Picking.LocName, t_Picking.PickingID, t_PickingDetail.PickingDetailID, t_PickingDetail.ComponentCode, t_PickingDetail.ComponentName, t_PickingDetail.PickingQuantity, t_PickingDetail.ShortQuantity, t_PickingDetail.UnitCode, t_PickingDetail.UnitName, t_PickingDetail.PlantCode AS cPlantCode, t_PickingDetail.PlantName AS cPlantName, t_PickingDetail.LocCode AS cLocCode, t_PickingDetail.LocName AS cLocName, t_PickingDetail.BatchNumber,CASE WHEN t_PickingDetail.ShortQuantity = 0 THEN '' WHEN t_PickingDetail.ShortQuantity > 0 THEN '***' END AS SH FROM t_Picking INNER JOIN t_PickingDetail ON t_Picking.PickingID = t_PickingDetail.PickingID WHERE (t_Picking.PrdONumber = N'" + this.txtProdOrder.Text.Trim() + "')"; DataSet ds = new DataSet(); ds = NP.GetClientDataSet(NP_Cls.SqlSelect); if (ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { ds.Tables[0].Rows[i][0] = i + 1; } frmRptViewer rptV = new frmRptViewer(); rptV.dsReportA = ds.Copy(); NP_Cls.SqlSelect = "SELECT t_Picking.PrdONumber, t_Picking.PickingDate, t_Picking.MaterialCode, t_Picking.MaterialName, t_Picking.PrdQuantity,t_RoutingDetail.WorkCenterCode FROM t_Picking INNER JOIN t_RoutingDetail ON t_Picking.MaterialCode = t_RoutingDetail.MaterialCode WHERE (t_Picking.PrdONumber = N'" + this.txtProdOrder.Text.Trim() + "')"; ds = new DataSet(); ds = NP.GetClientDataSet(NP_Cls.SqlSelect); rptV.dsReportB = ds.Copy(); rptV.ShowDialog(); } else { NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Data Not Found !! Report !!"); return; } //this.Close(); } 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 btnAddVaidPeriod_Click(object sender, EventArgs e) { if (this.dtpTo.Value < this.dtpOn.Value) { NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Valid To: must be more than Valid On: !!"); this.dtpTo.Select(); return; } if (this.dtpTo.Value == this.dtpOn.Value) { if (NP.MSGB("Do you want to save and use Valid To: for unlimit date !!") == DialogResult.Yes) { this.dtpTo.Value = this.dtpTo.MaxDate; 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(); cmdIns.Parameters.Add("@ValidTo", SqlDbType.Date); if (this.dgvView.RowCount > 0) { if (Convert.ToDateTime(this.dgvView[2, this.dgvView.RowCount - 1].Value) == this.dtpTo.MaxDate) { NP_Cls.sqlUpdate = "UPDATE t_VendorInfoRecordPeriods SET ValidTo = @ValidTo WHERE (ValidPeriodCode = @ValidPeriodCode)"; cmdIns.Parameters["@ValidTo"].Value = this.dtpOn.Value.AddDays(-1); cmdIns.Parameters.Add("@ValidPeriodCode", SqlDbType.NVarChar, 20).Value = this.dgvView["clnValidPeriodCode", this.dgvView.RowCount - 1].Value.ToString(); cmdIns.Connection = oConn; cmdIns.CommandText = NP_Cls.sqlUpdate; cmdIns.Transaction = Tr; cmdIns.ExecuteNonQuery(); } } //if (this.dgvView.RowCount == 0) { GenVCode(); } NP_Cls.SqlInsert = "INSERT INTO t_VendorInfoRecordPeriods " + "(VendorCode, MaterialCode, ValidOn, ValidTo, UserCreate, DateCreate, FileStatus) " + "VALUES (@VendorCode,@MaterialCode,@ValidOn,@ValidTo,@UC, GETDATE(), N'1')"; //cmdIns.Parameters.Add("@ValidPeriodCode", SqlDbType.Int).Value = Convert.ToInt64(NP_Cls.strValidCode); cmdIns.Parameters.Add("@VendorCode", SqlDbType.NVarChar, 10).Value = NP_Cls.hVendorInfo["Vendor"].ToString(); cmdIns.Parameters.Add("@MaterialCode", SqlDbType.NVarChar, 15).Value = NP_Cls.hVendorInfo["Material"].ToString(); cmdIns.Parameters.Add("@ValidOn", SqlDbType.Date).Value = this.dtpOn.Value; cmdIns.Parameters["@ValidTo"].Value = this.dtpTo.Value; cmdIns.Parameters.Add("@UC", SqlDbType.NVarChar, 10).Value = NP_Cls.strUsr; cmdIns.Connection = oConn; cmdIns.CommandText = NP_Cls.SqlInsert; cmdIns.Transaction = Tr; cmdIns.ExecuteNonQuery(); Tr.Commit(); DGV(); Clear(); NP.MSGB(NP_Cls.NPMgsStyle.InfoType, "Add Data Completed !!"); this.dtpOn.Select(); return; } catch (Exception ex) { NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Edit : " + ex.Message); return; } finally { if (oConn.State == ConnectionState.Open) { oConn.Close(); } } } else { this.dtpTo.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(); cmdIns.Parameters.Add("@ValidTo", SqlDbType.Date); if (this.dgvView.RowCount > 0) { if (Convert.ToDateTime(this.dgvView[2, this.dgvView.RowCount - 1].Value) == this.dtpTo.MaxDate) { NP_Cls.sqlUpdate = "UPDATE t_VendorInfoRecordPeriods SET ValidTo = @ValidTo WHERE (ValidPeriodCode = @ValidPeriodCode)"; cmdIns.Parameters["@ValidTo"].Value = this.dtpOn.Value.AddDays(-1); cmdIns.Parameters.Add("@ValidPeriodCode", SqlDbType.NVarChar, 20).Value = this.dgvView["clnValidPeriodCode", this.dgvView.RowCount - 1].Value.ToString(); cmdIns.Connection = oConn; cmdIns.CommandText = NP_Cls.sqlUpdate; cmdIns.Transaction = Tr; cmdIns.ExecuteNonQuery(); } } //if (this.dgvView.RowCount == 0) { GenVCode(); } NP_Cls.SqlInsert = "INSERT INTO t_VendorInfoRecordPeriods " + "(VendorCode, MaterialCode, ValidOn, ValidTo, UserCreate, DateCreate, FileStatus) " + "VALUES (@VendorCode,@MaterialCode,@ValidOn,@ValidTo,@UC, GETDATE(), N'1')"; //cmdIns.Parameters.Add("@ValidPeriodCode", SqlDbType.Int).Value = Convert.ToInt64(NP_Cls.strValidCode); cmdIns.Parameters.Add("@VendorCode", SqlDbType.NVarChar, 10).Value = NP_Cls.hVendorInfo["Vendor"].ToString(); cmdIns.Parameters.Add("@MaterialCode", SqlDbType.NVarChar, 15).Value = NP_Cls.hVendorInfo["Material"].ToString(); cmdIns.Parameters.Add("@ValidOn", SqlDbType.Date).Value = this.dtpOn.Value; cmdIns.Parameters["@ValidTo"].Value = this.dtpTo.Value; cmdIns.Parameters.Add("@UC", SqlDbType.NVarChar, 10).Value = NP_Cls.strUsr; cmdIns.Connection = oConn; cmdIns.CommandText = NP_Cls.SqlInsert; cmdIns.Transaction = Tr; cmdIns.ExecuteNonQuery(); Tr.Commit(); DGV(); Clear(); NP.MSGB(NP_Cls.NPMgsStyle.InfoType, "Add Data Completed !!"); this.dtpOn.Select(); } catch (Exception ex) { NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Edit : " + ex.Message); return; } finally { if (oConn.State == ConnectionState.Open) { oConn.Close(); } } } else { return; } }
private void btnAdd_Click(object sender, EventArgs e) { try { if (NP.ReqField(this.txtCode, "Please enter Material Code: !!") == false) { return; } if (NP.ReqField(this.txtBatch, "Please enter Batch: !!") == false) { return; } if (NP.ReqField(this.txtPlant, "Please enter Plant: !!") == false) { return; } if (NP.ReqField(this.txtLocation, "Please enter Location: !!") == false) { return; } if (NP.ReqField(this.txtUnit, "Please enter Unit: !!") == false) { return; } if (NP.ReqField(this.txtUR, "Please enter UR: !!") == false) { return; } if (NP.ReqField(this.txtQI, "Please enter QI: !!") == false) { return; } if (NP.ReqField(this.txtBlock, "Please enter Block: !!") == false) { return; } if (NP.ReqField(this.txtCost, "Please enter Cost: !!") == false) { return; } if (IsMaterial()) { NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Material Code is not in system !!"); this.txtCode.Select(); this.txtCode.SelectAll(); return; } if (ChkDup()) { NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Material Code & Batch Duplicated !!"); this.txtCode.Select(); this.txtCode.SelectAll(); 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(); try { SqlCommand cmdIns = new SqlCommand(); NP_Cls.SqlInsert = "INSERT INTO t_StockOverview " + "(MaterialCode, BatchNumber, PlantCode, LocCode, UnitCode, UR, QI, Block, Cost, UserCreate, DateCreate) " + "VALUES (@MaterialCode,@BatchNumber,@PlantCode,@LocCode,@UnitCode,@UR,@QI,@Block,@Cost,@UC,GETDATE())"; cmdIns.Parameters.Add("@MaterialCode", SqlDbType.NVarChar, 15).Value = this.txtCode.Text.Trim(); cmdIns.Parameters.Add("@BatchNumber", SqlDbType.NVarChar, 10).Value = this.txtBatch.Text.Trim(); cmdIns.Parameters.Add("@PlantCode", SqlDbType.NVarChar, 4).Value = this.txtPlant.Text.Trim(); cmdIns.Parameters.Add("@LocCode", SqlDbType.NVarChar, 2).Value = this.txtLocation.Text.Trim(); cmdIns.Parameters.Add("@UnitCode", SqlDbType.NVarChar, 3).Value = this.txtUnit.Text.Trim(); cmdIns.Parameters.Add("@UR", SqlDbType.Decimal).Value = Convert.ToDecimal(this.txtUR.Text.Trim()); cmdIns.Parameters.Add("@QI", SqlDbType.Decimal).Value = Convert.ToDecimal(this.txtQI.Text.Trim()); cmdIns.Parameters.Add("@Block", SqlDbType.Decimal).Value = Convert.ToDecimal(this.txtBlock.Text.Trim()); cmdIns.Parameters.Add("@Cost", SqlDbType.Decimal).Value = Convert.ToDecimal(this.txtCost.Text.Trim()); cmdIns.Parameters.Add("@UC", SqlDbType.NVarChar, 20).Value = NP_Cls.strUsr; cmdIns.Connection = oConn; cmdIns.CommandText = NP_Cls.SqlInsert; cmdIns.ExecuteNonQuery(); Clear(); DGV(); NP.MSGB(NP_Cls.NPMgsStyle.InfoType, "Add Data Completed !!"); this.txtCode.Focus(); } catch (Exception ex) { NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Add : " + ex.Message); return; } finally { if (oConn.State == ConnectionState.Open) { oConn.Close(); } } } else { return; } } catch (Exception ex) { NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Add : " + ex.Message); return; } }
private void btnExit_Click(object sender, EventArgs e) { if (this.dQtyChk != 0) { if (NP.MSGB("Qty of Component are not equal Qty of BOM !!\nThe transaction will be reject , Do you want to exit out of save ?") == DialogResult.Yes) { // Delete all Transaction 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.SqlSelect = "SELECT BOMDetailCode FROM t_BOMDetail WHERE (BOMCode = @BOMCode)"; cmdDel.Parameters.Add("@BOMCode", SqlDbType.Int).Value = Convert.ToInt32(NP_Cls.hBOM["BOMCode"].ToString()); cmdDel.Connection = oConn; cmdDel.CommandText = NP_Cls.SqlSelect; cmdDel.Transaction = Tr; SqlDataAdapter da = new SqlDataAdapter(cmdDel); DataSet ds = new DataSet(); da.Fill(ds); if (ds.Tables[0].Rows.Count > 0) { NP_Cls.SqlDel = "DELETE FROM t_BOMDetail WHERE (BOMCode = @BOMCode)"; //cmdDel.Parameters.Add("@BOMCode", SqlDbType.Int).Value = this.dgvView["clnBOMCode", this.dgvView.CurrentRow.Index].Value; cmdDel.Parameters.Add("@BOMDetailCode", SqlDbType.Int).Value = this.dgvView["clnBOMDetailCode", this.dgvView.CurrentRow.Index].Value; cmdDel.Connection = oConn; cmdDel.CommandText = NP_Cls.SqlDel; cmdDel.Transaction = Tr; cmdDel.ExecuteNonQuery(); NP_Cls.SqlDel = "DELETE FROM t_BOM WHERE (BOMCode = @BOMCode)"; 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(); this.Close(); } else { NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Try agian !!"); return; } } else // Has Row { NP_Cls.SqlDel = "DELETE FROM t_BOM WHERE (BOMCode = @BOMCode)"; cmdDel.Connection = oConn; cmdDel.CommandText = NP_Cls.SqlDel; cmdDel.Transaction = Tr; cmdDel.ExecuteNonQuery(); if (NP._TRanSave(oConn, Tr, NP_Cls.NPTranType.Delete, "t_BOM", NP_Cls.strUsr)) { Tr.Commit(); this.Close(); } 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; } } else { if (NP.MSGB("Do you want to exit this screen ?") == DialogResult.Yes) { this.Close(); } else { return; } } }
private void btnAdd_Click(object sender, EventArgs e) { 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 ((string.IsNullOrEmpty((this.cbPlant.Text.Trim()))) || (this.cbPlant.Text.Trim() == "((( Select Plant )))")) { NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Please enter Plant: !!"); this.cbPlant.Select(); return; } if (NP.ReqField(this.txtBaseQuantity, "Please enter Base Quantity !!") == false) { return; } if (NP.ReqField(this.txtStdManHour, "Please enter Standard Man Hour !!") == false) { return; } if (NP.ReqField(this.txtHour, "Please enter Hours !!") == false) { return; } if ((string.IsNullOrEmpty((this.cbWorkCenter.Text.Trim()))) || (this.cbWorkCenter.Text.Trim() == "((( Select WorkCenter )))")) { NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Please enter Work Center: !!"); this.cbWorkCenter.Select(); return; } if (ChkDup()) { NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Work Center Duplicated !!"); this.cbWorkCenter.Select(); this.cbWorkCenter.SelectAll(); 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.SqlSelect = "SELECT MaterialCode, PlantCode FROM t_Routing WHERE (MaterialCode = @MaterialCode) AND (PlantCode = @PlantCode)"; cmdIns.Parameters.Add("@MaterialCode", SqlDbType.NVarChar, 15).Value = this.cbMaterial.SelectedValue; cmdIns.Parameters.Add("@PlantCode", SqlDbType.NVarChar, 4).Value = this.cbPlant.SelectedValue; cmdIns.Connection = oConn; cmdIns.CommandText = NP_Cls.SqlSelect; cmdIns.Transaction = Tr; SqlDataAdapter da = new SqlDataAdapter(cmdIns); DataSet ds = new DataSet(); da.Fill(ds); if (ds.Tables[0].Rows.Count > 0) { NP_Cls.SqlInsert = "INSERT INTO t_RoutingDetail (MaterialCode, PlantCode, WorkCenterCode, LogDate,STDManHour,Hours) VALUES (@MaterialCode,@PlantCode,@WorkCenterCode,GETDATE(),@STDManHour,@Hours)"; cmdIns.Parameters.Add("@WorkCenterCode", SqlDbType.NVarChar, 10).Value = this.cbWorkCenter.SelectedValue; cmdIns.Parameters.Add("@STDManHour", SqlDbType.Decimal).Value = Convert.ToDecimal(this.txtStdManHour.Text.Trim()); cmdIns.Parameters.Add("@Hours", SqlDbType.Decimal).Value = Convert.ToDecimal(this.txtHour.Text.Trim()); cmdIns.Connection = oConn; cmdIns.CommandText = NP_Cls.SqlInsert; cmdIns.Transaction = Tr; cmdIns.ExecuteNonQuery(); } else { NP_Cls.SqlInsert = "INSERT INTO t_Routing (MaterialCode, PlantCode,Remark,BaseQuantity) VALUES (@MaterialCode,@PlantCode,@Remark,@BaseQuantity)"; cmdIns.Parameters.Add("@Remark", SqlDbType.NVarChar, 255).Value = this.txtRemark.Text.Trim(); cmdIns.Parameters.Add("@BaseQuantity", SqlDbType.Decimal).Value = Convert.ToDecimal(this.txtBaseQuantity.Text.Trim()); cmdIns.Connection = oConn; cmdIns.CommandText = NP_Cls.SqlInsert; cmdIns.Transaction = Tr; cmdIns.ExecuteNonQuery(); NP_Cls.SqlInsert = "INSERT INTO t_RoutingDetail (MaterialCode, PlantCode, WorkCenterCode, LogDate,STDManHour,Hours) VALUES (@MaterialCode,@PlantCode,@WorkCenterCode,GETDATE(),@STDManHour,@Hours)"; cmdIns.Parameters.Add("@WorkCenterCode", SqlDbType.NVarChar, 10).Value = this.cbWorkCenter.SelectedValue; cmdIns.Parameters.Add("@STDManHour", SqlDbType.Decimal).Value = Convert.ToDecimal(this.txtStdManHour.Text.Trim()); cmdIns.Parameters.Add("@Hours", SqlDbType.Decimal).Value = Convert.ToDecimal(this.txtHour.Text.Trim()); cmdIns.Connection = oConn; cmdIns.CommandText = NP_Cls.SqlInsert; cmdIns.Transaction = Tr; cmdIns.ExecuteNonQuery(); } Tr.Commit(); DGV(); NP.MSGB(NP_Cls.NPMgsStyle.InfoType, "Add Data Completed !!"); this.cbWorkCenter.Text = string.Empty; this.cbWorkCenter.Select(); this.txtStdManHour.Text = string.Empty; this.txtRemark.Text = string.Empty; this.txtHour.Text = string.Empty; } 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 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 btnAdd_Click(object sender, EventArgs e) { //if (NP.ReqField(this.cbMaterial, "Please enter Material: !!") == false) { 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.cbPlant, "Please enter Plant: !!") == false) { return; } if (NP.ReqField(this.cbBOMType, "Please enter B.O.M Type: !!") == false) { return; } if (NP.ReqField(this.cbUnit, "Please enter Unit: !!") == false) { return; } if (NP.ReqField(this.txtQty, "Please enter Quantity: !!") == false) { return; } if (cbMaterial.Text.StartsWith("3")) { if (!NP.ReqField(this.txtFor, "please enter Formula No : !!")) { return; } } if (cbMaterial.Text.StartsWith("5") && cbBOMType.Text == "Mix") { if (!NP.ReqField(this.txtFor, "please enter Formula No : !!")) { return; } } if (ChkDup()) { NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Material & Plant Duplicated !!"); this.cbMaterial.Select(); return; } if (NP.MSGB("Do you want to Add BOM Data ?") == DialogResult.Yes) { oConn = new SqlConnection(NP.ReadFileDB(NP_Cls.PathDB)); if (oConn.State == ConnectionState.Open) { oConn.Close(); } oConn.Open(); try { SqlCommand cmdIns = new SqlCommand(); BuildVersion(); NP_Cls.SqlInsert = "INSERT INTO t_BOM " + "(MaterialCode, PlantCode, BOMType, UnitCode, Quantity, BOMVersion, UserCreate, DateCreate, FileStatus, Approve, Remark, FormulaNo) " + "VALUES (@MaterialCode,@PlantCode,@BOMType,@UnitCode,@Quantity,@BOMVersion,@UC, GETDATE(),@St,@Appr, @Remark, @FormulaNo)"; //cmdIns.Parameters.Add("@BOMCode", SqlDbType.Int).Value = NP_Cls.strBOMCode; cmdIns.Parameters.Add("@MaterialCode", SqlDbType.NVarChar, 15).Value = this.cbMaterial.SelectedValue; cmdIns.Parameters.Add("@PlantCode", SqlDbType.NVarChar, 4).Value = this.cbPlant.SelectedValue; cmdIns.Parameters.Add("@BOMType", SqlDbType.NVarChar, 1).Value = this.cbBOMType.SelectedValue; cmdIns.Parameters.Add("@UnitCode", SqlDbType.NVarChar, 3).Value = this.cbUnit.SelectedValue; cmdIns.Parameters.Add("@Quantity", SqlDbType.Decimal).Value = Convert.ToDouble(this.txtQty.Text.Trim()); cmdIns.Parameters.Add("@BOMVersion", SqlDbType.Int).Value = this.strVersion; cmdIns.Parameters.Add("@UC", SqlDbType.NVarChar, 10).Value = NP_Cls.strUsr; cmdIns.Parameters.Add("@St", SqlDbType.NVarChar, 1).Value = "1"; cmdIns.Parameters.Add("@Appr", SqlDbType.Bit).Value = 0; cmdIns.Parameters.Add("@Remark", SqlDbType.NVarChar, 200).Value = this.txtRemark.Text.Trim(); cmdIns.Parameters.Add("@FormulaNo", SqlDbType.NVarChar, 200).Value = this.txtFor.Text.Trim(); cmdIns.Connection = oConn; cmdIns.CommandText = NP_Cls.SqlInsert; cmdIns.ExecuteNonQuery(); NP.MSGB(NP_Cls.NPMgsStyle.InfoType, "Add BOM Data Completed !!\n\n Please Add Component for this BOM .."); this.cbUnit.Enabled = true; NP_Cls.hBOM = new System.Collections.Hashtable(); NP_Cls.hBOM.Add("BOMCode", ((string)GenBOMCode())); NP_Cls.hBOM.Add("Qty", Convert.ToDouble(this.txtQty.Text.Trim())); NP_Cls.hBOM.Add("UnitName", ((string)this.cbUnit.Text)); NP_Cls.hBOM.Add("BOMType", ((string)this.cbBOMType.SelectedValue)); NP_Cls.hBOM.Add("Approve", Convert.ToBoolean(false)); NP_Cls.hBOM.Add("Material", this.cbMaterial.SelectedValue.ToString()); WMS.BOM.frmBOMNewDetail frm = new frmBOMNewDetail(); frm.lblSCode.Text = this.cbMaterial.SelectedValue.ToString(); frm.lblSName.Text = this.cbMaterial.Text.ToString().Split(':')[1].Trim(); frm.ShowDialog(); Clear(); DGV(); this.cbMaterial.Select(); } catch (Exception ex) { NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Add : " + ex.Message); return; } finally { if (oConn.State == ConnectionState.Open) { oConn.Close(); } } } else { return; } }
private void btnAdd_Click(object sender, EventArgs e) { try { if (NP.ReqField(this.txtCode, "Please enter Code: !!") == false) { return; } if (NP.ReqField(this.txtName, "Please enter Unit of Measure: !!") == false) { return; } try { byte bRe = 0; if (ChkDup(ref bRe)) { NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Code Duplicated !!"); this.txtCode.Select(); this.txtCode.SelectAll(); return; } else { if (bRe == 1) { Clear(); DGV(); NP.MSGB(NP_Cls.NPMgsStyle.InfoType, "Update Data Completed !!"); this.txtCode.Focus(); return; } } } catch (Exception ex) { NP.MSGB("Erro Dup : " + ex.Message); 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(); try { SqlCommand cmdIns = new SqlCommand(); NP_Cls.SqlInsert = "INSERT INTO m_Unit (UnitCode, UnitName, Remark, UserCreate, DateCreate, FileStatus) VALUES (@Code,@Name,@Remark,@UC,getdate(),@St)"; cmdIns.Parameters.Add("@Code", SqlDbType.NVarChar, 10).Value = this.txtCode.Text.Trim(); cmdIns.Parameters.Add("@Name", SqlDbType.NVarChar, 60).Value = this.txtName.Text.Trim(); cmdIns.Parameters.Add("@Remark", SqlDbType.NVarChar, 255).Value = this.txtRemark.Text.Trim(); cmdIns.Parameters.Add("@UC", SqlDbType.NVarChar, 10).Value = NP_Cls.strUsr; cmdIns.Parameters.Add("@St", SqlDbType.NVarChar, 1).Value = "1"; cmdIns.Connection = oConn; cmdIns.CommandText = NP_Cls.SqlInsert; cmdIns.ExecuteNonQuery(); Clear(); DGV(); NP.MSGB(NP_Cls.NPMgsStyle.InfoType, "Add Data Completed !!"); this.txtCode.Focus(); } catch (Exception ex) { NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Add : " + ex.Message); return; } finally { if (oConn.State == ConnectionState.Open) { oConn.Close(); } } } else { return; } } catch (Exception ex) { NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Add : " + ex.Message); return; } }
private void btnAdd_Click(object sender, EventArgs e) { try { if (NP.ReqField(this.txtScaleQty, "Please enter Scale Qty: !!") == false) { return; } if (NP.ReqField(this.txtRate, "Please enter Unit of Rate: !!") == false) { return; } if (ChkDup()) { NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Code Duplicated !!"); this.txtScaleQty.Select(); this.txtScaleQty.SelectAll(); 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(); try { SqlCommand cmdIns = new SqlCommand(); NP_Cls.SqlInsert = "INSERT INTO t_VendorInfoRecordPeriodsDetail " + "(ValidPeriodCode, ScaleQty, Rate, UserCreate, DateCreate, FileStatus) " + "VALUES (@ValidPeriodCode,@ScaleQty,@Rate,@UC, GETDATE(), @St)"; cmdIns.Parameters.Add("@ValidPeriodCode", SqlDbType.Int).Value = NP_Cls.strValidCode; cmdIns.Parameters.Add("@ValidPeriodDetailCode", SqlDbType.Int).Value = NP_Cls.strValidCode; cmdIns.Parameters.Add("@ScaleQty", SqlDbType.Decimal).Value = Convert.ToDecimal(this.txtScaleQty.Text.Trim() == string.Empty ? "0" : this.txtScaleQty.Text.Trim()); cmdIns.Parameters.Add("@Rate", SqlDbType.Decimal).Value = Convert.ToDecimal(this.txtRate.Text.Trim() == string.Empty ? "0" : this.txtRate.Text.Trim()); cmdIns.Parameters.Add("@UC", SqlDbType.NVarChar, 10).Value = NP_Cls.strUsr; cmdIns.Parameters.Add("@St", SqlDbType.NVarChar, 1).Value = "1"; cmdIns.Connection = oConn; cmdIns.CommandText = NP_Cls.SqlInsert; cmdIns.ExecuteNonQuery(); Clear(); DGV(); NP.MSGB(NP_Cls.NPMgsStyle.InfoType, "Add Data Completed !!"); this.txtScaleQty.Select(); } catch (Exception ex) { NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Add : " + ex.Message); return; } finally { if (oConn.State == ConnectionState.Open) { oConn.Close(); } } } else { return; } } catch (Exception ex) { NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Add : " + ex.Message); return; } }
private void btnSave_Click(object sender, EventArgs e) { if (NP.MSGB("Do you to Save Production 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 { if (!Convert.ToBoolean(bView)) { SqlCommand cmdIns = new SqlCommand(); NP_Cls.SqlInsert = "INSERT INTO t_PrdOrder (PrdONumber, PrdODate, MaterialCode, MaterialName, PrdQuantity, PlantCode, PlantName, BOMVersion, LocCode, LocName, Remark, UserCreate, DateCreate, MRPOrder) VALUES (@PrdONumber,GETDATE(),@MaterialCode,@MaterialName,@PrdQuantity,@PlantCode,@PlantName,@BOMVersion,@LocCode,@LocName,@Remark,@UserCreate, GETDATE(), @MRPOrder)"; cmdIns.Parameters.Add("@PrdONumber", SqlDbType.NVarChar, 12).Value = this.txtPrdOrder.Text.Trim(); cmdIns.Parameters.Add("@MaterialCode", SqlDbType.NVarChar, 15).Value = this.cbMaterialCode.Text.Trim(); cmdIns.Parameters.Add("@MaterialName", SqlDbType.NVarChar, 60).Value = this.lblMaterial.Text.Trim(); cmdIns.Parameters.Add("@PrdQuantity", SqlDbType.Decimal).Value = Convert.ToDecimal(this.txtQty.Text.Trim()); cmdIns.Parameters.Add("@PlantCode", SqlDbType.NVarChar, 4).Value = hsTmp["PlantCode"].ToString(); cmdIns.Parameters.Add("@PlantName", SqlDbType.NVarChar, 20).Value = this.lblPlant.Text.Trim(); cmdIns.Parameters.Add("@BOMVersion", SqlDbType.Int).Value = Convert.ToInt32(this.lblBOMVer.Text.Trim()); cmdIns.Parameters.Add("@LocCode", SqlDbType.NVarChar, 2).Value = hsTmp["LocCode"].ToString(); cmdIns.Parameters.Add("@LocName", SqlDbType.NVarChar, 20).Value = this.lblLocation.Text.Trim(); cmdIns.Parameters.Add("@Remark", SqlDbType.NVarChar, 255).Value = this.txtRemark.Text.Trim(); cmdIns.Parameters.Add("@UserCreate", SqlDbType.NVarChar, 50).Value = NP_Cls.strUsr; cmdIns.Parameters.Add("@MRPOrder", SqlDbType.NVarChar, 12).Value = (NP_Cls.FromMRP == 1 ? NP_Cls.MRPSO : string.Empty); cmdIns.Connection = oConn; cmdIns.Transaction = Tr; cmdIns.CommandText = NP_Cls.SqlInsert; cmdIns.ExecuteNonQuery(); SqlCommand cmdInsDetail = new SqlCommand(); NP_Cls.SqlInsert = "INSERT INTO t_PrdOrderDetail (PrdONumber, ComponentCode, ComponentName, PrdOQuantity, UnitCode, UnitName, PlantCode, PlantName, LocCode, LocName, CurrentUser) VALUES (@PrdONumber,@ComponentCode,@ComponentName,@PrdOQuantity,@UnitCode,@UnitName,@PlantCode,@PlantName,@LocCode,@LocName,@CurrentUser)"; cmdInsDetail.Parameters.Add("@PrdONumber", SqlDbType.NVarChar, 12); cmdInsDetail.Parameters.Add("@ComponentCode", SqlDbType.NVarChar, 15); cmdInsDetail.Parameters.Add("@ComponentName", SqlDbType.NVarChar, 60); cmdInsDetail.Parameters.Add("@PrdOQuantity", SqlDbType.Decimal); cmdInsDetail.Parameters.Add("@UnitCode", SqlDbType.NVarChar, 3); cmdInsDetail.Parameters.Add("@UnitName", SqlDbType.NVarChar, 20); cmdInsDetail.Parameters.Add("@PlantCode", SqlDbType.NVarChar, 4); cmdInsDetail.Parameters.Add("@PlantName", SqlDbType.NVarChar, 20); cmdInsDetail.Parameters.Add("@LocCode", SqlDbType.NVarChar, 2); cmdInsDetail.Parameters.Add("@LocName", SqlDbType.NVarChar, 20); cmdInsDetail.Parameters.Add("@CurrentUser", SqlDbType.NVarChar, 50); for (byte ins = 0; ins < this.dgvView.RowCount; ins++) { cmdInsDetail.Parameters["@PrdONumber"].Value = this.txtPrdOrder.Text.Trim(); cmdInsDetail.Parameters["@ComponentCode"].Value = this.dgvView["clnMaterialCode", ins].Value.ToString(); cmdInsDetail.Parameters["@ComponentName"].Value = this.dgvView["clnMaterialName", ins].Value.ToString(); cmdInsDetail.Parameters["@PrdOQuantity"].Value = Convert.ToDecimal(this.dgvView["clnQuantity", ins].Value); cmdInsDetail.Parameters["@UnitCode"].Value = this.dgvView["clnUnitCode", ins].Value.ToString(); cmdInsDetail.Parameters["@UnitName"].Value = this.dgvView["clnUnitName", ins].Value.ToString(); cmdInsDetail.Parameters["@CurrentUser"].Value = NP_Cls.strUsr; cmdInsDetail.Parameters["@PlantCode"].Value = this.dgvView["clnPlantCode", ins].Value.ToString(); cmdInsDetail.Parameters["@PlantName"].Value = this.dgvView["clnPlantName", ins].Value.ToString(); cmdInsDetail.Parameters["@LocCode"].Value = this.dgvView["clnLocCode", ins].Value.ToString(); cmdInsDetail.Parameters["@LocName"].Value = this.dgvView["clnLocName", ins].Value.ToString(); cmdInsDetail.Connection = oConn; cmdInsDetail.CommandText = NP_Cls.SqlInsert; cmdInsDetail.Transaction = Tr; cmdInsDetail.ExecuteNonQuery(); } //TODO 14.11.10 Prd Order from MRP if (NP_Cls.FromMRP == 1) { SqlCommand cmdMRP = new SqlCommand(); cmdMRP.Parameters.Add("@MatCode", SqlDbType.NVarChar, 15).Value = NP_Cls.MRPFGSort; cmdMRP.Parameters.Add("@TranOrder", SqlDbType.NVarChar, 50).Value = this.txtPrdOrder.Text.Trim(); cmdMRP.Parameters.Add("@TranQty", SqlDbType.Decimal).Value = Convert.ToDecimal(this.txtQty.Text.Trim()); cmdMRP.Parameters.Add("@SONumber", SqlDbType.NVarChar, 50).Value = NP_Cls.MRPSO; NP_Cls.SqlInsert = "INSERT INTO t_MRPTranOrder (MaterialCode,TranOrder,TranQty,SONumber,MaterialHeader) VALUES (@MatCode,@TranOrder,@TranQty,@SONumber,@MatCode)"; cmdMRP.CommandText = NP_Cls.SqlInsert; cmdMRP.Connection = oConn; cmdMRP.Transaction = Tr; cmdMRP.ExecuteNonQuery(); Tr.Commit(); NP.MSGB(NP_Cls.NPMgsStyle.InfoType, "Save Prd Order Completed !! this screen will be close .."); NP_Cls.MRPTranOrder = this.txtPrdOrder.Text.Trim(); this.Close(); return; } // Tr.Commit(); NP.MSGB(NP_Cls.NPMgsStyle.InfoType, "Save Production Order Completed !!"); Clear(); this.btnSave.Visible = false; this.MyGrid(dgvView); this.txtPrdOrder.DropDownStyle = ComboBoxStyle.Simple; BindMat(); this.cbMaterialCode.Enabled = true; this.txtPrdOrder.Text = GetNumber(); this.cbMaterialCode.Text = string.Empty; this.cbMaterialCode.Select(); this.cbMaterialCode.SelectAll(); } } 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; } }