private void toolStripButton2_Click(object sender, EventArgs e)
{
var sl = new AccountSelectForm(new SysConfigManager().Get().Accounts);
if (sl.ShowDialog() == DialogResult.OK && sl.CheckedInfo != null)
{
_from = sl.CheckedInfo;
var partner = textBox1.Text;
var sd = dateTimePicker1.Value.ToString("yyyy-MM-dd 00:00:00");
var ed = dateTimePicker2.Value.ToString("yyyy-MM-dd 23:59:59");
var data = new DataAccess(new SqlHelper(_from.GetConnectionString())).GetPurchaseOrder(partner, sd, ed);
dataGridView1.Columns.Clear();
dataGridView1.Columns.Add(new DataGridViewCheckBoxColumn { ReadOnly = false, Width = 30 });
foreach (DataColumn cln in data.Columns)
{
dataGridView1.Columns.Add(new DataGridViewTextBoxColumn { Name = cln.ColumnName, ReadOnly = true });
}
dataGridView1.Columns[1].Visible = false;
foreach (DataRow row in data.Rows)
{
dataGridView1.Rows.Add(
false,
row["id"],
row["单据日期"],
row["单据编号"],
row["供应商"],
row["业务员"],
row["预计到货日期"],
row["付款方式"],
row["订金金额"],
row["预付款百分比"]
);
}
textBox1.Focus();
}
}
private void toolStripButton3_Click(object sender, EventArgs e)
{
if (_from == null)
{
MessageBox.Show("请先选择导入采购订单");
return;
}
var sl = new AccountSelectForm(new SysConfigManager().Get().Accounts);
if (sl.ShowDialog() != DialogResult.OK) return;
var fromSqlHelper = new SqlHelper(_from.GetConnectionString());
var toSqlHelper = new SqlHelper(sl.CheckedInfo.GetConnectionString());
var da = new DataAccess(fromSqlHelper);
var result = new List<string>();
foreach (DataGridViewRow row in dataGridView1.Rows)
{
if (!(bool)row.Cells[0].Value) continue;
var purchaseOrder = da.ImportPurchaseOrder((Guid)row.Cells[1].Value);
if (purchaseOrder != null && purchaseOrder.Rows.Count > 0)
{
var saleOrder = DataAccess.PurchaseOrderToSaleOrder(purchaseOrder, _from.Name);
var rt = new DataAccess(toSqlHelper).ExportSaleOrder(saleOrder);
result.AddRange(rt);
}
}
if (result.Count > 0)
{
result.Insert(0, "导出成功！\r\n");
MessageBox.Show(string.Join("\r\n", result));
}
else
{
MessageBox.Show("没有可导入的采购订单");
}
}