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); }