private void simpleButton4_Click(object sender, EventArgs e)
{
login();
FrmImport frmImport = new FrmImport(ClientEnvironment.ImportParam, ImportType.CashRegisterReceipt);
frmImport.ShowDialog();
}
private void simpleButton1_Click(object sender, EventArgs e)
{
login();
FrmImport frmImport = new FrmImport(ClientEnvironment.ImportParam);
frmImport.ShowDialog();
}
private void btnImportBusinessVolume_Click(object sender, EventArgs e)
{
login();
FrmImport frmImport = new FrmImport(ClientEnvironment.ImportParam, ImportType.ActualBusinessVolume);
frmImport.ShowDialog();
}
private void simpleButton3_Click(object sender, EventArgs e)
{
login();
FrmImport frmImport = new FrmImport(ClientEnvironment.ImportParam, ImportType.TargetBusinessVolume);
frmImport.ShowDialog();
}
void btnImport_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(cboBank.SelectedValue.ToString()))
{
MessageBox.Show("Bank Name", Program.ApplicationName, MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
else if (string.IsNullOrEmpty(dtpStart.EditValue.ToString()) && string.IsNullOrEmpty(dtpEnd.EditValue.ToString()))
{
MessageBox.Show("Date Range is Empty", Program.ApplicationName, MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
else
{
try
{
SplashScreenManager.ShowForm(this, typeof(WaitForm1), true, true, false);
this.Hide();
FrmImport import = new FrmImport(cboBank.SelectedValue.ToString(), dtpStart.DateTime,
dtpEnd.DateTime, cboBank.Text.Trim().ToString());
import.ShowDialog();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message + ex.StackTrace, Program.ApplicationName, MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
finally
{
SplashScreenManager.CloseForm(false);
}
}
}
private static bool DoImport(ImportType importType)
{
using (FrmImport frmImport = new FrmImport(ClientEnvironment.ImportParam, importType))
{
frmImport.ShowDialog();
return(frmImport.BeenRunSuccessfully);
}
}
private void bi_Import_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
using (FrmImport frmImport = new FrmImport(ClientEnvironment.ImportParam, ImportType.Feast))
{
frmImport.ShowDialog();
if (frmImport.BeenRunSuccessfully)
{
ReloadFeasts();
}
}
}
private void bi_Import_ItemClick(object sender, ItemClickEventArgs e)
{
using (FrmImport frmImport = new FrmImport(ClientEnvironment.ImportParam, ImportType.WorkingDays))
{
frmImport.ShowDialog();
if (frmImport.BeenRunSuccessfully)
{
LoadDays();
}
}
}
private void bi_Import_ItemClick(object sender, ItemClickEventArgs e)
{
if (_currentControl is FeastListControl)
{
using (FrmImport frmImport = new FrmImport(ClientEnvironment.ImportParam,
ImportType.Feast))
{
frmImport.ShowDialog();
if (frmImport.BeenRunSuccessfully)
{
ucFeastControl.ReloadFeasts();
}
}
}
}
/// <summary>
/// Download configuration
/// </summary>
private void DownloadConfig(ServersSettings.ServerSettings serverSettings)
{
// download
Cursor = Cursors.WaitCursor;
string logFileName = AppData.AppDirs.LogDir + "ScadaAdminDownload.txt";
bool downloadOK = DownloadUpload.DownloadConfig(serverSettings,
logFileName, out bool logCreated, out string msg);
Cursor = Cursors.Default;
// display of the result message
if (downloadOK)
{
ScadaUiUtils.ShowInfo(msg);
// launch import
ServersSettings.DownloadSettings downloadSettings = serverSettings.Download;
if (downloadSettings.ImportBase)
{
var frmImport = new FrmImport();
if (downloadSettings.SaveToDir)
{
frmImport.DefaultSelection = FrmImport.SelectedItem.AllTables;
frmImport.DefaultBaseDATDir = Path.Combine(downloadSettings.DestDir, "BaseDAT");
}
else
{
frmImport.DefaultSelection = FrmImport.SelectedItem.Archive;
frmImport.DefaultArcFileName = downloadSettings.DestFile;
frmImport.DefaultBaseDATDir = AppData.Settings.AppSett.BaseDATDir;
}
frmImport.ShowDialog();
}
}
else
{
AppUtils.ProcError(msg);
// log display in notebook
if (logCreated)
{
Process.Start(logFileName);
}
}
}
/// <summary>
/// Скачать конфигурацию
/// </summary>
private void DownloadConfig(ServersSettings.ServerSettings serverSettings)
{
// скачивание
Cursor = Cursors.WaitCursor;
string logFileName = AppData.AppDirs.LogDir + "ScadaAdminDownload.txt";
bool downloadOK = DownloadUpload.DownloadConfig(serverSettings,
logFileName, out bool logCreated, out string msg);
Cursor = Cursors.Default;
// отображение сообщения о результате
if (downloadOK)
{
ScadaUiUtils.ShowInfo(msg);
// запуск импорта
ServersSettings.DownloadSettings downloadSettings = serverSettings.Download;
if (downloadSettings.ImportBase)
{
FrmImport frmImport = new FrmImport();
if (downloadSettings.SaveToDir)
{
frmImport.DefaultSelection = FrmImport.SelectedItem.AllTables;
frmImport.DefaultBaseDATDir = Path.Combine(downloadSettings.DestDir, "BaseDAT");
}
else
{
frmImport.DefaultSelection = FrmImport.SelectedItem.Archive;
frmImport.DefaultArcFileName = downloadSettings.DestFile;
frmImport.DefaultBaseDATDir = AppData.Settings.AppSett.BaseDATDir;
}
frmImport.ShowDialog();
}
}
else
{
AppUtils.ProcError(msg);
// отображение журнала в блокноте
if (logCreated)
{
Process.Start(logFileName);
}
}
}
private void btnImport(bool bType)
{
try
{
OpenFileDialog oFile = new OpenFileDialog();
oFile.Filter = "Excel文件2003|*.xls|Excel文件2007|*.xlsx";
if (oFile.ShowDialog() == DialogResult.OK)
{
string sFilePath = oFile.FileName;
string sSQL = "select 单据ID,存货编码,需求日期 from [Sheet1$]";
DataTable dtExcel = clsExcel.ExcelToDT(sFilePath, sSQL, true);
if (dtExcel.Rows.Count <= 0)
{
MessageBox.Show("没有导入数据！");
return;
}
DataTable dtImport = new DataTable();
DataColumn dc = new DataColumn();
dc.ColumnName = "行号";
dtImport.Columns.Add(dc);
dc = new DataColumn();
dc.ColumnName = "单据ID";
dtImport.Columns.Add(dc);
dc = new DataColumn();
dc.ColumnName = "存货编码";
dtImport.Columns.Add(dc);
dc = new DataColumn();
dc.ColumnName = "需求日期";
dtImport.Columns.Add(dc);
dc = new DataColumn();
dc.ColumnName = "状态";
dtImport.Columns.Add(dc);
ArrayList aList = new ArrayList();
for (int i = 0; i < dtExcel.Rows.Count; i++)
{
sSQL = "select isnull(cbCloser,0) as cbCloser from @u8.OM_MODetails where [MODetailsID] =" + dtExcel.Rows[i]["单据ID"].ToString().Trim() + " and cInvCode = '" + dtExcel.Rows[i]["存货编码"].ToString().Trim() + "'";
DataTable dtTemp = clsSQLCommond.ExecQuery(sSQL);
if (dtTemp.Rows.Count == 0)
{
DataRow dr = dtImport.NewRow();
dr["行号"] = i + 1;
dr["单据ID"] = dtExcel.Rows[i]["单据ID"].ToString().Trim();
dr["存货编码"] = dtExcel.Rows[i]["存货编码"].ToString().Trim();
dr["需求日期"] = dtExcel.Rows[i]["需求日期"].ToString().Trim();
dr["状态"] = "数据错误";
dtImport.Rows.Add(dr);
continue;
}
else
{
if (dtTemp.Rows[0]["cbCloser"].ToString().Trim() != "0")
{
DataRow dr = dtImport.NewRow();
dr["行号"] = i + 1;
dr["单据ID"] = dtExcel.Rows[i]["单据ID"].ToString().Trim();
dr["存货编码"] = dtExcel.Rows[i]["存货编码"].ToString().Trim();
dr["需求日期"] = dtExcel.Rows[i]["需求日期"].ToString().Trim();
dr["状态"] = "订单已关闭";
dtImport.Rows.Add(dr);
continue;
}
else
{
if (bType)
{
if (chkDate(dtExcel.Rows[i]["需求日期"].ToString().Trim()) && Convert.ToDateTime(dtExcel.Rows[i]["需求日期"]) >= Convert.ToDateTime(FrameBaseFunction.ClsBaseDataInfo.sLogDate))
{
sSQL = "update @u8.OM_MODetails set cDefine31 = '" + Convert.ToDateTime(dtExcel.Rows[i]["需求日期"]).ToString("yyyy-MM-dd") + "' where [MODetailsID] =" + dtExcel.Rows[i]["单据ID"].ToString().Trim() + " and cInvCode = '" + dtExcel.Rows[i]["存货编码"].ToString().Trim() + "'";
}
else
{
DataRow dr = dtImport.NewRow();
dr["行号"] = i + 1;
dr["单据ID"] = dtExcel.Rows[i]["单据ID"].ToString().Trim();
dr["存货编码"] = dtExcel.Rows[i]["存货编码"].ToString().Trim();
dr["需求日期"] = dtExcel.Rows[i]["需求日期"].ToString().Trim();
dr["状态"] = "需求日期错误，请检查！";
dtImport.Rows.Add(dr);
continue;
}
}
else
{
sSQL = "update @u8.OM_MODetails set cDefine31 = null where [MODetailsID] =" + dtExcel.Rows[i]["单据ID"].ToString().Trim() + " and cInvCode = '" + dtExcel.Rows[i]["存货编码"].ToString().Trim() + "'";
}
aList.Add(sSQL);
}
}
}
if (dtImport.Rows.Count > 0)
{
FrmImport fImport = new FrmImport(dtImport);
fImport.StartPosition = FormStartPosition.CenterParent;
fImport.ShowDialog();
}
if (aList.Count > 0)
{
clsSQLCommond.ExecSqlTran(aList);
if (bType)
{
MessageBox.Show("导入共：" + aList.Count + "条数据成功！");
}
else
{
MessageBox.Show("删除共：" + aList.Count + "条数据成功！");
}
btnSEL();
}
else
{
MessageBox.Show("无数据导入！");
}
}
}
catch (Exception ee)
{
throw new Exception("导入Excel失败：" + ee.Message);
}
}
