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 mnuNewPurchaseList_Click(object sender, EventArgs e)
{
try
{
this.Cursor = Cursors.WaitCursor;
if (DBGrid.CurrentRow == null)
{
return;
}
string selectionlist = string.Empty;
if (DBGrid.SelectedRows.Count == 0)
{
for (int i = 0; i < DBGrid.RowCount; i++)
{
if (DBGrid.Rows[i].Visible)
{
if (string.IsNullOrEmpty(selectionlist))
{
selectionlist = DBGrid.Rows[i].Cells["Id"].Value.ToString();
}
else
{
selectionlist += "," + DBGrid.Rows[i].Cells["Id"].Value.ToString();
}
}
}
}
else
{
for (int i = 0; i < DBGrid.SelectedRows.Count; i++)
{
if (DBGrid.SelectedRows[i].Visible)
{
if (string.IsNullOrEmpty(selectionlist))
{
selectionlist = DBGrid.SelectedRows[i].Cells["Id"].Value.ToString();
}
else
{
selectionlist += "," + DBGrid.SelectedRows[i].Cells["Id"].Value.ToString();
}
}
}
}
EditPurchaseList frm = new EditPurchaseList();
frm.ImportPO(selectionlist);
if (frm.ShowDialog() == DialogResult.OK)
{
frmMain frmmain = (frmMain)this.ParentForm;
if (frmmain.CheckChildFrmExist("OPA_PURCHASE_LIST") == true)
{
return;
}
OPA_PURCHASE_LIST newFrm = new OPA_PURCHASE_LIST();
if (newFrm != null && !frmmain.ShowMDIChild(newFrm, newFrm))
{
newFrm.Dispose();
newFrm = null;
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
finally
{
this.Cursor = Cursors.Default;
}
}