private void UpdateOperatorCode(string code) { bool notFound = true; int id = 0; string name = null; if (!String.IsNullOrWhiteSpace(code)) { OrderDataSet ds = new OrderDataSet(); OrderDataSetTableAdapters.OperatorsTableAdapter adapter = new OrderDataSetTableAdapters.OperatorsTableAdapter(); OrderDataSet.OperatorsDataTable dataTable = adapter.GetDataByCode(code); if (dataTable.Rows.Count > 0) { OrderDataSet.OperatorsRow row = (OrderDataSet.OperatorsRow)dataTable.Rows[0]; id = row.Id; name = row.Name; notFound = false; } } OperatorId = id; OperatorName = name; OperatorNotFound = notFound; }
private void UpdateOperatorInfo(int id) { if (id > 0) { OrderDataSet ds = new OrderDataSet(); OrderDataSetTableAdapters.OperatorsTableAdapter adapter = new OrderDataSetTableAdapters.OperatorsTableAdapter(); OrderDataSet.OperatorsDataTable dataTable = adapter.GetDataById(id); if (dataTable.Rows.Count > 0) { OrderDataSet.OperatorsRow row = (OrderDataSet.OperatorsRow)dataTable.Rows[0]; OperatorCode = row.Code; OperatorName = row.Name; } } }
public void LoadDatasInterface(int ProductId, int OperatorId, int ClientId, int FactoryId) { OrderDataSet dataset = new OrderDataSet(); OrderDataSetTableAdapters.ProductsTableAdapter tableproduct = new OrderDataSetTableAdapters.ProductsTableAdapter(); OrderDataSetTableAdapters.OperatorsTableAdapter tableOperator = new OrderDataSetTableAdapters.OperatorsTableAdapter(); OrderDataSetTableAdapters.ClientsTableAdapter tableClient = new OrderDataSetTableAdapters.ClientsTableAdapter(); OrderDataSetTableAdapters.FactoriesTableAdapter tableFactory = new OrderDataSetTableAdapters.FactoriesTableAdapter(); string CodeProducts = ""; string NameProducts = ""; string CodeOperators = ""; string NameOperators = ""; string CodeClients = ""; string NameClients = ""; string CodeFactories = ""; string NameFactories = ""; //datos produtcto CodeProducts = tableproduct.GetDataById(ProductId)[0].Code; NameProducts = tableproduct.GetDataById(ProductId)[0].Name; ProductCode = CodeProducts; ProductName = NameProducts; //datos operador CodeOperators = tableOperator.GetDataById(OperatorId)[0].Code; NameOperators = tableOperator.GetDataById(OperatorId)[0].Name; OperatorCode = CodeOperators; OperatorName = NameOperators; //datos cliente CodeClients = tableClient.GetDataById(ClientId)[0].Code; NameClients = tableClient.GetDataById(ClientId)[0].Name; ClientCode = CodeClients; ClientName = NameClients; //datos factoría CodeFactories = tableFactory.GetDataById(FactoryId)[0].Code; NameFactories = tableFactory.GetDataById(FactoryId)[0].Name; FactoryCode = CodeFactories; FactoryName = NameFactories; }