private void toolImport_Click(object sender, EventArgs e)
{
try
{
this.Cursor = Cursors.WaitCursor;
frmSelectGrid frmsel = new frmSelectGrid();
frmSingleSelect frms = new frmSingleSelect();
frms.InitData("请选择导入方式：", "采购订单,客户订单,EXCEL", "采购订单", ComboBoxStyle.DropDownList);
if (frms.ShowDialog() == DialogResult.OK)
{
switch (Util.retValue1)
{
case "客户订单":
dalPurchaseList dalorder = new dalPurchaseList();
BindingCollection <modCustomerOrderList> listorder = dalorder.GetImportOrderData(DateTime.Today.AddDays(-30).ToString("MM-dd-yyyy"), string.Empty, out Util.emsg);
if (listorder != null)
{
frmsel.InitViewList("请选择要导入的客户订单号:", listorder);
if (frmsel.ShowDialog() == DialogResult.OK)
{
EditPurchaseList frm = new EditPurchaseList();
frm.ImportOrder(frmSelectGrid.selectionlist);
if (frm.ShowDialog() == DialogResult.OK)
{
LoadData();
}
}
}
break;
case "采购订单":
dalVendorOrderList dalpo = new dalVendorOrderList();
BindingCollection <modVendorOrderList> listpo = dalpo.GetIList(false, string.Empty, string.Empty, string.Empty, DateTime.Today.AddDays(-30).ToString("MM-dd-yyyy"), string.Empty, out Util.emsg);
if (listpo != null)
{
frmsel.InitViewList("请选择要导入的采购订单号:", listpo);
if (frmsel.ShowDialog() == DialogResult.OK)
{
EditPurchaseList frm = new EditPurchaseList();
frm.ImportPO(frmSelectGrid.selectionlist);
if (frm.ShowDialog() == DialogResult.OK)
{
LoadData();
}
}
}
break;
case "EXCEL":
OpenFileDialog ofd = new OpenFileDialog();
string inifolder = clsLxms.GetParameterValue("PURCHASE_IMPORT_PATH");
if (Directory.Exists(inifolder))
{
ofd.InitialDirectory = clsLxms.GetParameterValue("PURCHASE_IMPORT_PATH");
}
else
{
ofd.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.Desktop);
}
ofd.Multiselect = true; //允许同时选择多个文件
ofd.Filter = "Excel文件|*.xls;*.xlsx";
ofd.RestoreDirectory = true;
ofd.FilterIndex = 1;
if (ofd.ShowDialog() == DialogResult.OK)
{
string[] files = ofd.FileNames;
EditPurchaseList frm = new EditPurchaseList();
frm.Import(files);
if (frm.ShowDialog() == DialogResult.OK)
{
LoadData();
}
}
break;
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
finally
{
this.Cursor = Cursors.Default;
}
}
private void toolImport_Click(object sender, EventArgs e)
{
try
{
this.Cursor = Cursors.WaitCursor;
frmSingleSelect frm = new frmSingleSelect();
dalVendorList dalvendor = new dalVendorList();
BindingCollection <modVendorList> listvendor = dalvendor.GetIList("1", string.Empty, out Util.emsg);
if (listvendor != null)
{
frm.InitViewList("请选择供应商", listvendor, "VendorName", "VendorName", ComboBoxStyle.DropDown);
if (frm.ShowDialog() == DialogResult.OK)
{
modVendorList modvendor = dalvendor.GetItem(Util.retValue1, out Util.emsg);
frmSelectGrid frmsel = new frmSelectGrid();
dalPurchaseList dalorder = new dalPurchaseList();
BindingCollection <modCustomerOrderList> listorder = dalorder.GetImportOrderData(DateTime.Today.AddDays(-30).ToString("MM-dd-yyyy"), string.Empty, out Util.emsg);
if (listorder != null)
{
frmsel.InitViewList("请选择要导入的客户订单号:", listorder);
if (frmsel.ShowDialog() == DialogResult.OK)
{
BindingCollection <modVendorOrderList> list = new BindingCollection <modVendorOrderList>();
dalCustomerOrderList dalco = new dalCustomerOrderList();
BindingCollection <modCustomerOrderList> listco = dalco.GetIList(frmSelectGrid.selectionlist, out Util.emsg);
foreach (modCustomerOrderList modco in listco)
{
modVendorOrderList mod = new modVendorOrderList();
mod.Id = 0;
mod.FormDate = DateTime.Today;
mod.RequireDate = DateTime.Today;
//mod.VendorOrderNo = modco.CustOrderNo;
mod.Remark = modco.CustName + ": " + modco.CustOrderNo;
mod.VendorName = Util.retValue1;
mod.PayMethod = string.Empty;
mod.PurchaseMan = Util.UserId;
mod.ProductId = modco.ProductId;
mod.ProductName = modco.ProductName;
if (clsLxms.GetProductSizeFlag(mod.ProductId) == 0)
{
mod.Size = 1;
}
else
{
mod.Size = modco.Size;
}
mod.Currency = modvendor.Currency;
mod.UnitNo = modco.UnitNo;
mod.Qty = modco.Qty;
mod.Price = 0;
mod.UpdateUser = Util.UserId;
list.Add(mod);
}
VendorOrderImport frmImport = new VendorOrderImport();
frmImport.InitViewList(list);
if (frmImport.ShowDialog() == DialogResult.OK)
{
LoadData();
}
}
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
finally
{
this.Cursor = Cursors.Default;
}
}