public bool Save() { try { int rowsAffected = ADODatabase.ExecuteNonQuery("UPDATE FillingLineData SET IsDefault = 1 WHERE FillingLineID = " + (int)this.FillingLineID + " AND ProductID = " + this.ProductID); if (rowsAffected <= 0) //Add New { rowsAffected = ADODatabase.ExecuteTransaction("UPDATE FillingLineData SET IsDefault = 0 WHERE FillingLineID = " + (int)this.FillingLineID + "; " + "INSERT INTO FillingLineData (FillingLineID, ProductID, BatchNo, SettingDate, SettingMonthID, BatchSerialNumber, MonthSerialNumber, BatchCartonNumber, MonthCartonNumber, Remarks, LastSettingDate, LastSerialDate, IsDefault) " + "VALUES (" + (int)this.FillingLineID + ", " + this.ProductID + ", N'" + this.BatchNo + "', CONVERT(smalldatetime, '" + this.SettingDate.ToString("dd/MM/yyyy") + "',103), " + this.SettingMonthID.ToString() + ", N'" + this.BatchSerialNumber + "', N'" + this.MonthSerialNumber + "', N'" + this.BatchCartonNumber + "', N'" + this.MonthCartonNumber + "', N'" + this.Remarks + "', GetDate(), GetDate(), 1) "); return(rowsAffected > 0); } else //Update Only { return(Update()); } } catch (Exception exception) { throw exception; } }
public FillingLineData() { DataTable defaultFillingLineData = ADODatabase.GetDataTable("SELECT FillingLineData.ProductID, ListProductName.ProductCode, ListProductName.ProductCodeOriginal, ListProductName.NoItemPerCarton, FillingLineData.BatchNo, FillingLineData.SettingDate, FillingLineData.SettingMonthID, FillingLineData.BatchSerialNumber, FillingLineData.MonthSerialNumber, FillingLineData.BatchCartonNumber, FillingLineData.MonthCartonNumber FROM FillingLineData INNER JOIN ListProductName ON FillingLineData.ProductID = ListProductName.ProductID WHERE FillingLineData.FillingLineID = " + (int)this.FillingLineID + " AND FillingLineData.IsDefault = 1"); if (defaultFillingLineData.Rows.Count > 0) { this.StartTracking(); this.ProductID = int.Parse(defaultFillingLineData.Rows[0]["ProductID"].ToString()); this.ProductCode = defaultFillingLineData.Rows[0]["ProductCode"].ToString(); this.ProductCodeOriginal = defaultFillingLineData.Rows[0]["ProductCodeOriginal"].ToString(); GlobalVariables.noItemPerCartonSetByProductID = int.Parse(defaultFillingLineData.Rows[0]["NoItemPerCarton"].ToString()); int noItem = 0; GlobalVariables.noItemPerCartonSetByProductID = int.TryParse(GlobalRegistry.Read("NoItemPerCartonSetByProductID"), out noItem) ? noItem : 0; this.BatchNo = defaultFillingLineData.Rows[0]["BatchNo"].ToString(); this.SettingDate = DateTime.Parse(defaultFillingLineData.Rows[0]["SettingDate"].ToString()); this.SettingMonthID = int.Parse(defaultFillingLineData.Rows[0]["SettingMonthID"].ToString()); this.BatchSerialNumber = defaultFillingLineData.Rows[0]["BatchSerialNumber"].ToString(); this.MonthSerialNumber = defaultFillingLineData.Rows[0]["MonthSerialNumber"].ToString(); this.BatchCartonNumber = defaultFillingLineData.Rows[0]["BatchCartonNumber"].ToString(); this.MonthCartonNumber = defaultFillingLineData.Rows[0]["MonthCartonNumber"].ToString(); this.StartTracking(); } }
public SettingFillingLineData(FillingLineData fillingLineData, bool isMessageQueueEmpty) { InitializeComponent(); this.globalFillingLineData = fillingLineData; this.privateFillingLineData = fillingLineData.ShallowClone(); DataTable dataTable = ADODatabase.GetDataTable("SELECT ProductID, ProductCode, ProductCodeOriginal, ProductName, ProductCode + ' [' + ProductCodeOriginal + '] ' + ProductName AS ProductDisplayName FROM ListProductName"); this.comboBoxProductID.DataSource = dataTable; this.comboBoxProductID.ValueMember = "ProductID"; this.comboBoxProductID.DisplayMember = "ProductDisplayName"; fillingLineNameBinding = this.textBoxFillingLineName.DataBindings.Add("Text", this.privateFillingLineData, "FillingLineName", true); productIDBinding = this.comboBoxProductID.DataBindings.Add("SelectedValue", this.privateFillingLineData, "ProductID", true, DataSourceUpdateMode.OnPropertyChanged); batchNoBinding = this.textBoxBatchNo.DataBindings.Add("Text", this.privateFillingLineData, "BatchNo", true); settingDateBinding = this.dateTimePickerSettingDate.DataBindings.Add("Value", this.privateFillingLineData, "SettingDate", true, DataSourceUpdateMode.OnPropertyChanged); batchSerialNumberBinding = this.textBoxBatchSerialNumber.DataBindings.Add("Text", this.privateFillingLineData, "BatchSerialNumber", true); monthSerialNumberBinding = this.textBoxMonthSerialNumber.DataBindings.Add("Text", this.privateFillingLineData, "MonthSerialNumber", true); batchCartonNumberBinding = this.textBoxBatchCartonNumber.DataBindings.Add("Text", this.privateFillingLineData, "BatchCartonNumber", true); monthCartonNumberBinding = this.textBoxMonthCartonNumber.DataBindings.Add("Text", this.privateFillingLineData, "MonthCartonNumber", true); fillingLineNameBinding.BindingComplete += new BindingCompleteEventHandler(fillingLineNameBinding_BindingComplete); productIDBinding.BindingComplete += new BindingCompleteEventHandler(productIDBinding_BindingComplete); batchNoBinding.BindingComplete += new BindingCompleteEventHandler(batchNoBinding_BindingComplete); settingDateBinding.BindingComplete += new BindingCompleteEventHandler(settingDateBinding_BindingComplete); batchSerialNumberBinding.BindingComplete += new BindingCompleteEventHandler(batchSerialNumberBinding_BindingComplete); monthSerialNumberBinding.BindingComplete += new BindingCompleteEventHandler(monthSerialNumberBinding_BindingComplete); batchCartonNumberBinding.BindingComplete += new BindingCompleteEventHandler(batchCartonNumberBinding_BindingComplete); monthCartonNumberBinding.BindingComplete += new BindingCompleteEventHandler(monthCartonNumberBinding_BindingComplete); this.privateFillingLineData.PropertyChanged += new PropertyChangedEventHandler(privateFillingLineData_PropertyChanged); this.comboBoxProductID.Enabled = isMessageQueueEmpty; }
private void UpdateProductName() { DataTable dataTable = ((DataTable)bindingSource.DataSource).GetChanges(DataRowState.Added); int rowsAdded = 0; if (dataTable != null) { rowsAdded = dataTable.Rows.Count; } int rowsAffected = sqlDataAdapter.Update((DataTable)bindingSource.DataSource); if (rowsAffected != 0) { ADODatabase.ExecuteNonQuery("UPDATE ListFillingLineName SET ListProductNameRowsAffected = ListProductNameRowsAffected + " + rowsAffected); if (rowsAdded > 0) { this.LoadProductList(); } } }
private void LoadProductList() { try { sqlDataAdapter = new SqlDataAdapter("SELECT * FROM ListProductName", ADODatabase.Connection()); // Create a command builder to generate SQL update, insert, and delete commands based on selectCommand. These are used to update the database. SqlCommandBuilder commandBuilder = new SqlCommandBuilder(sqlDataAdapter); // Populate a new data table and bind it to the BindingSource. DataTable dataTable = new DataTable(); dataTable.Locale = System.Globalization.CultureInfo.InvariantCulture; sqlDataAdapter.Fill(dataTable); bindingSource.DataSource = dataTable; } catch (Exception exception) { GlobalExceptionHandler.ShowExceptionMessageBox(this, exception); } }
public bool Update() { try { int rowsAffected = ADODatabase.ExecuteTransaction("UPDATE FillingLineData SET IsDefault = 0 WHERE FillingLineID = " + (int)this.FillingLineID + "; " + "UPDATE FillingLineData SET BatchNo = N'" + this.BatchNo.ToString() + "', " + " SettingDate = CONVERT(smalldatetime, '" + this.SettingDate.ToString("dd/MM/yyyy") + "', 103), " + " SettingMonthID = " + this.SettingMonthID.ToString() + ", " + " BatchSerialNumber = N'" + this.BatchSerialNumber.ToString() + "', " + " MonthSerialNumber = N'" + this.MonthSerialNumber.ToString() + "', " + " BatchCartonNumber = N'" + this.BatchCartonNumber.ToString() + "', " + " MonthCartonNumber = N'" + this.MonthCartonNumber.ToString() + "', " + " LastSerialDate = GetDate(), IsDefault = 1 " + "WHERE FillingLineID = " + (int)this.FillingLineID + " AND ProductID = " + this.ProductID); return(rowsAffected > 0); } catch (Exception exception) { throw exception; } }