/*
* 保存信息
*/
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];
}
}
