public static bool ImpUpload(HttpPostedFileBase file, out string sErrImp)
{
sErrImp = string.Empty;
var fileName = Path.GetFileName(file.FileName);
var fileTemp = Path.Combine(GetTempDirBase(), fileName);
file.SaveAs(fileTemp);
var recvCmpDal = new CommodityRecv_DAL(CustomConfig.ConnStrBaan, CustomConfig.ConnStrMain);
int nRec = 0;
try
{
nRec = recvCmpDal.DoImpUpload(new FileInfo(fileTemp), out sErrImp);
LogHelper.WriteInfo(typeof(CommodityRecvHelper), string.Format("DoUploadCond:{0}", nRec));
}
catch (Exception ex)
{
LogHelper.WriteError(typeof(CommodityRecvHelper), ex);
sErrImp = ex.Message;
}
finally
{
if (CustomConfig.bDeleteTempFile)
{
File.Delete(fileTemp);
}
}
return(nRec > 0);
}
internal static bool SyncBaanData(out string sErrSync)
{
sErrSync = string.Empty;
var recvCmpDal = new CommodityRecv_DAL(CustomConfig.ConnStrBaan, CustomConfig.ConnStrMain);
int nRec = 0;
try
{
nRec = recvCmpDal.DoSyncData(out sErrSync);
LogHelper.WriteInfo(typeof(CommodityRecv_DAL), string.Format("SyncBaanData:{0}", nRec));
}
catch (Exception ex)
{
LogHelper.WriteError(typeof(CommodityRecv_DAL), ex);
sErrSync = ex.Message;
}
return(nRec > 0);
}
static void Main(string[] args)
{
var dtNow = DateTime.Now;
CommodityRecv_DAL dal = new CommodityRecv_DAL(CustomConfig.ConnStrBaan, CustomConfig.ConnStrMain);
bool bRun = true;
bool bSync = CustomConfig.PullBaanData; //PullBaanData=false用于测试
if (bSync)
{
var sErr = string.Empty;
bRun = dal.DoSyncData(out sErr) > 0;
}
if (bRun)
{
var dt = dal.DoCalc();
var sFileTemp = SyncData.Common.PathHelper.GetFile("", "email.template");
dal.SendMail(dt, sFileTemp, dtNow);
}
}
internal static bool ReSyncBaan(out string msg)
{
CommodityRecv_DAL dal = new CommodityRecv_DAL(CustomConfig.ConnStrBaan, CustomConfig.ConnStrMain);
return(dal.DoSyncData(out msg) > 0);
}
