/* * 保存信息 */ private void saveBtn_Click(object sender, EventArgs e) { NewSaleOrderManager newSaleOrderManager = new NewSaleOrderManager(); switch (this.operateType) { case 1: //检查信息是否填写完整 if (checkInforIntegrity() == true) { newSaleOrderManager.addSaleOrder(buildInforList()); DialogResult rest = MessageBox.Show(this, "订单保存成功!继续创建订单请选择(是),退出选择(否)", "订单保存提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information); if (rest == DialogResult.Yes) { //清除当前界面信息 clearAllInfor(); //重新初始化界面 dispatchOperate(1, ""); } else { //关闭当前窗口 this.Close(); } } break; case 2: break; case 3: break; default: break; } }
/* * 上传客户订单(此方式已废弃) */ private void openFileBtn_Click(object sender, EventArgs e) { OpenFileDialog fileDialog = new OpenFileDialog(); fileDialog.Filter = "表格文件(*.xls;*.xlsx)|*.xls;*.xlsx"; fileDialog.FilterIndex = 1; fileDialog.InitialDirectory = "."; fileDialog.RestoreDirectory = true; if (fileDialog.ShowDialog(this) == DialogResult.OK) { String filename = fileDialog.FileName; //获取文件名 DataSet excelDataSet = ExcelOperate.readExcel(filename); //获取excel内容(色号、数量) if (excelDataSet == null) { return; } //注意:excel表格中数据的第一行被作为表头不加载,空行会被自动过滤掉 DataTable excelDataTable = excelDataSet.Tables[0]; if (excelDataTable.Columns.Count != 2) { MessageBox.Show(this, "客户订单表格要求为2列(色号、数量)!", "上传错误", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } NewSaleOrderManager newSaleOrderManager = new NewSaleOrderManager(); this.productList.DataSource = newSaleOrderManager.getOrderProductListInfor(excelDataTable); } }
/* * 生成一个新的订单编号 */ private String getSaleOrderNo() { NewSaleOrderManager newSaleOrderManager = new NewSaleOrderManager(); if (newSaleOrderManager.getSaleOrderNo() == "error") { MessageBox.Show(this, "订单编号已达到上限,请检查数据库!", "获取销售订单编号警告", MessageBoxButtons.OK, MessageBoxIcon.Warning ); return ""; } return newSaleOrderManager.getSaleOrderNo(); }
/* * 填充客户名称 */ private void fillClientBox() { this.clientName.Items.Clear(); //清空客户名称 NewSaleOrderManager newSaleOrderManager = new NewSaleOrderManager(); clients = newSaleOrderManager.queryClientInformation(); foreach (var item in clients) { this.clientName.Items.Add(item.Key); } }
/* * 根据交易币种名填充当前汇率 */ private void currencyType_SelectedIndexChanged(object sender, EventArgs e) { if (tradingCurrencys == null || !tradingCurrencys.ContainsKey(this.currencyType.SelectedItem.ToString())) { return; } int currencyId = tradingCurrencys[this.currencyType.SelectedItem.ToString()]; float currency = new NewSaleOrderManager().queryTradingCurrencyById(currencyId); if (currency > 0) { this.currentRate.Text = currency.ToString(); } }
/* * 根据客户名称填充剩余信息 */ private void clientName_SelectedIndexChanged(object sender, EventArgs e) { if (clients == null || !clients.ContainsKey(this.clientName.SelectedItem.ToString())) { return; } int clientId = clients[this.clientName.SelectedItem.ToString()]; List<String> otherClientInfor = new NewSaleOrderManager().queryClientInformationById(clientId); if(otherClientInfor.Count >= 3) { this.clientAddress.Text = otherClientInfor[0]; this.contacts.Text = otherClientInfor[1]; this.phoneNumber.Text = otherClientInfor[2]; } }