public bool updSubMenuxAppRol(Int64 idPermisoMenu, Int64 IdPermisoSubmenu, string SumMenu, string Img, string TpoObj, string Url, string Tool, Int64 Orden, bool Activo, string App) { linqIELDataBaseDataContext dboSegLatino = new linqIELDataBaseDataContext(); try { bool bFlag = true; dboSegLatino.sp_updSubMenuXAppRol(idPermisoMenu, IdPermisoSubmenu, SumMenu, Img, TpoObj, Url, Tool, Orden, Activo); return(bFlag); } catch (Exception ex) { StackTrace st = new StackTrace(true); CommonDA ComunDA = new CommonDA(); ComunDA.insErrorDB("Error: " + ex.Message + " En El Metodo: " + MethodBase.GetCurrentMethod().Name, st, "", App.ToString()); throw new Exception(ex.Message); } }
public bool addRolxApp(string Rol, Int64 App) { linqIELDataBaseDataContext dboSegLatino = new linqIELDataBaseDataContext(); try { bool bFlag = true; dboSegLatino.sp_insRolXApp(Rol, App); return(bFlag); } catch (Exception ex) { StackTrace st = new StackTrace(true); CommonDA ComunDA = new CommonDA(); ComunDA.insErrorDB("Error: " + ex.Message + " En El Metodo: " + MethodBase.GetCurrentMethod().Name, st, "", App.ToString()); throw new Exception(ex.Message); } }
public bool updAplicacion(AplicacionBE Aplicacion, Int64 App) { linqIELDataBaseDataContext dboSegLatino = new linqIELDataBaseDataContext(); try { bool bFlag = true; dboSegLatino.sp_updAplicacion(Aplicacion.IDAPLICACION, Aplicacion.DESCRIPCION, Aplicacion.PASSWORD, Aplicacion.ACTIVO); return(bFlag); } catch (Exception ex) { StackTrace st = new StackTrace(true); CommonDA ComunDA = new CommonDA(); ComunDA.insErrorDB("Error: " + ex.Message + " En El Metodo: " + MethodBase.GetCurrentMethod().Name, st, "", App.ToString()); throw new Exception(ex.Message); } }
public bool addMenuxAppRol(Int64 Rol, Int64 App, string Menu, string Img, string Obj, string Url, string Tool, Int64 Orden) { linqIELDataBaseDataContext dboSegLatino = new linqIELDataBaseDataContext(); try { bool bFlag = true; dboSegLatino.sp_insMenuXAppRol(Rol, Menu, Img, Obj, Url, Tool, Orden); return(bFlag); } catch (Exception ex) { StackTrace st = new StackTrace(true); CommonDA ComunDA = new CommonDA(); ComunDA.insErrorDB("Error: " + ex.Message + " En El Metodo: " + MethodBase.GetCurrentMethod().Name, st, "", ""); throw new Exception(ex.Message); } }
public bool addServicio(string Servicio) { linqIELDataBaseDataContext dboSegLatino = new linqIELDataBaseDataContext(); try { bool bFlag = true; dboSegLatino.sp_insServicioWCF(Servicio); return(bFlag); } catch (Exception ex) { StackTrace st = new StackTrace(true); CommonDA ComunDA = new CommonDA(); ComunDA.insErrorDB("Error: " + ex.Message + " En El Metodo: " + MethodBase.GetCurrentMethod().Name, st, "", ""); throw new Exception(ex.Message); } }
/// <summary> /// 查询库存变化单据 /// </summary> /// <param name="queryFilter"></param> /// <returns></returns> public static QueryResult <InventoryItemCardInfo> QueryCardItemOrders(InventoryItemCardQueryFilter queryFilter) { if (queryFilter == null || string.IsNullOrEmpty(queryFilter.ProductSysNo)) { throw new BusinessException("请输入商品编号"); } if (string.IsNullOrEmpty(queryFilter.MerchantSysNo)) { throw new BusinessException("商家编号不能为空"); } queryFilter.CompanyCode = "8601"; //获取RMAInventoryOnlineDate: string rmaInventoryOnlineDate = CommonDA.GetSysConfigurationValue("RMAInventoryOnlineDate", queryFilter.CompanyCode); queryFilter.RMAInventoryOnlineDate = string.IsNullOrEmpty(rmaInventoryOnlineDate) ? new DateTime() : Convert.ToDateTime(rmaInventoryOnlineDate); return(InventoryDA.QueryCardItemOrdersRelated(queryFilter)); }
private static decimal GetProductStepPrice(decimal oldPrice, int productSysNo, int productCount) { List <ProductStepPrice> productStepPrices = null; productStepPrices = CommonDA.GetProductStepPrice(productSysNo); if (productStepPrices == null) { return(oldPrice); } ProductStepPrice productStepPrice = productStepPrices.FirstOrDefault(c => (c.BaseCount <= productCount && productCount <= c.TopCount)); if (productStepPrice == null) { return(productStepPrices.FirstOrDefault(c => (c.BaseCount == 0 && 0 == c.TopCount)).StepPrice); } return(productStepPrice.StepPrice); }
public RespuestaComunBE GetDefinicionTabla(string sNombreTabla) { CommonDA oCommonDA = new CommonDA(); ConfiguracionDA oConfiguracionDA = new ConfiguracionDA(); RespuestaComunBE Respuesta = new RespuestaComunBE(); ConfiguracionBE itemConfig = new ConfiguracionBE(); List <CatalogosBE> lsCatalogos = new List <CatalogosBE>(); string sConexionString = string.Empty; itemConfig.psIDCONFIGAPP = ConfigurationSettings.AppSettings["IELDBConn"].ToString(); Respuesta = oConfiguracionDA.GetConfigAPP(itemConfig); sConexionString = Respuesta.lstConfiguracion[0].psVALOR; Respuesta = oCommonDA.GetDefinicionTabla(sNombreTabla, sConexionString); return(Respuesta); }
public static void SendFailedMail4SO(SOEntity soEntity, ProductGroupBuyingEntity group) { CustomerInfo customerInfo = CommonDA.GetCustomerBySysNo(soEntity.SOMaster.CustomerSysNo, CompanyCode); if (customerInfo == null || customerInfo.Email == null) { return; } group.LowerLimitSellCount = CommonDA.GetLowerLimitSellCount(group.SystemNumber); string mailFrom = "IPPSystem"; string mailTo = Util.TrimNull(customerInfo.Email); string mailSubject = "您在新蛋的订单SO#" + soEntity.SOMaster.SystemNumber + "团购失败,订单取消"; string mailBody = BuildFailedMail(customerInfo, soEntity, group); CommonServiceAdapter.SendEmail2MailDb(mailFrom, mailTo, null, null, mailSubject, mailBody, CompanyCode); }
public void Run(JobContext context) { if (!File.Exists("LastSysncDate.txt")) { StreamWriter sw = File.CreateText("LastSysncDate.txt"); sw.Write("2000-01-01 00:00:00.fff"); sw.Flush(); sw.Close(); } string str = File.ReadAllText("LastSysncDate.txt"); DateTime lastSyncDate; if (!DateTime.TryParse(str, out lastSyncDate)) { lastSyncDate = DateTime.Parse("2000-01-01"); } DateTime date = CommonDA.GetDbDate(); bool isAllok = true; System.Collections.Generic.List <SoInfo> list = CommonDA.GetSyncSo(lastSyncDate); context.Message += string.Format("开始同步状态,发现{0}个订单\r\n", list.Count); foreach (var item in list) { try { CommonDA.UpdateSODeclareStatus(item.SoSysno, item.SoStatus, item.StockSysNo); } catch (Exception ex) { isAllok = false; context.Message += ex.Message; } } context.Message += string.Format("\r\n同步结束\r\n", list.Count); Log.WriteLog(context.Message, "log.txt"); if (isAllok) { File.WriteAllText("LastSysncDate.txt", date.ToString("yyyy-MM-dd hh:mm:ss.fff")); } }
public DocumentUploadDA() { // Initialize Variables ErrMsg = string.Empty; try { // Create an instance of the SQL Database class _DB = new SqlDatabase(ConfigurationManager.ConnectionStrings["PROCESS360"].ToString()); } catch (Exception err) { // Database Error ErrMsg = string.Format("{0} - Connecting to Database Error - {1}", GetType().FullName, err.Message); // Save the Error CommonDA.SaveError(ErrMsg, err); } }
public List <UsuariosBE> GetUsuarios(UsuariosBE item, Int64 App) { linqIELDataBaseDataContext dboSegLatino = new linqIELDataBaseDataContext(); List <UsuariosBE> lstUsuarios = new List <UsuariosBE>(); try { DatosUsuarioBE DatosUsuarioRES = new DatosUsuarioBE(); var lstLector = dboSegLatino.spGetUsuarios(int.Parse(item.IDAPLICACION.ToString()), item.NOMBRE, item.AMATERNO, item.APATERNO, item.USUARIO); foreach (var Lector in lstLector) { UsuariosBE itemLector = new UsuariosBE(); itemLector.IDUSUARIO = Lector.IDUSUARIO; itemLector.IDAPLICACION = Lector.IDAPLICACION; itemLector.DESCAREA = Lector.AREA; itemLector.APATERNO = Lector.APATERNO; itemLector.AMATERNO = Lector.AMATERNO; itemLector.NOMBRE = Lector.NOMBRE; itemLector.FECHANACCONST = Lector.FECHANACCONST; itemLector.USUARIO = Lector.USUARIO; itemLector.ACTIVO = bool.Parse(string.IsNullOrEmpty(Lector.ACTIVO.ToString()) ? "false" : "true"); lstUsuarios.Add(itemLector); } } catch (Exception ex) { StackTrace st = new StackTrace(true); CommonDA ComunDA = new CommonDA(); ComunDA.insErrorDB("Error: " + ex.Message + " En El Metodo: " + MethodBase.GetCurrentMethod().Name, st, "", App.ToString()); throw new Exception(ex.Message); } finally { dboSegLatino.Connection.Close(); dboSegLatino.Connection.Dispose(); } return(lstUsuarios); }
public bool addUsuarioXAplicacion(ReglasBE Reglas, List <UsuarioXAppBE> lstUSuarioXApp, Int64 App) { try { linqIELDataBaseDataContext dboSegLatino = new linqIELDataBaseDataContext(); bool bFlag = true; foreach (UsuarioXAppBE item in lstUSuarioXApp) { dboSegLatino.sp_addUsuarioXAplicacion(item.IDUSRSXAPP, item.IDAPLICACION, item.IDUSUARIO, item.ACTIVO); } return(bFlag); } catch (Exception ex) { StackTrace st = new StackTrace(true); CommonDA ComunDA = new CommonDA(); ComunDA.insErrorDB("Error: " + ex.Message + " En El Metodo: " + MethodBase.GetCurrentMethod().Name, st, "", App.ToString()); throw new Exception(ex.Message); } }
public bool addRolesXUsuario(ReglasBE Reglas, List <RolesXUsuarioBE> RolesXUsuario, long App) { try { linqIELDataBaseDataContext dboSegLatino = new linqIELDataBaseDataContext(); bool bFlag = true; foreach (RolesXUsuarioBE Rol in RolesXUsuario) { dboSegLatino.sp_insRolesXUsuario(Rol.IDROL, Rol.IDUSUARIO, (Rol.IDESTACIONXAPP > 0 ? (Int64?)Rol.IDESTACIONXAPP : null)); } return(bFlag); } catch (Exception ex) { StackTrace st = new StackTrace(true); CommonDA ComunDA = new CommonDA(); ComunDA.insErrorDB("Error: " + ex.Message + " En El Metodo: " + MethodBase.GetCurrentMethod().Name, st, "", App.ToString()); throw new Exception(ex.Message); } }
protected void Application_Start() { // ロガーを取得 m_logger = LogManager.GetLogger(this.GetType()); AreaRegistration.RegisterAllAreas(); FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters); RouteConfig.RegisterRoutes(RouteTable.Routes); BundleConfig.RegisterBundles(BundleTable.Bundles); // 認証カスタマイズ AuthenticationService.Authenticating += (s, evt) => { using (var dbContext = new BaseDbContext()) { var dataAccess = new CommonDA(dbContext); evt.Authenticated = dataAccess.Login(evt.UserName, evt.Password); } evt.AuthenticationIsComplete = true; }; }
/// <summary> /// 用户邮箱地址通过验证 /// </summary> /// <param name="sysno"></param> /// <returns></returns> public static bool CustomerEmailValidated(int sysno, Point point) { using (var tran = TransactionManager.Create()) { CustomerDA.CustomerEmailValidated(sysno); PointFilter filter = new PointFilter { CustomerSysNo = point.CustomerSysNo, ObtainType = point.ObtainType, LanguageCode = ConstValue.LanguageCode, CompanyCode = ConstValue.CompanyCode, CurrencyCode = ConstValue.CurrencySysNo.ToString(), StoreCompanyCode = ConstValue.StoreCompanyCode }; if (CommonDA.ExistsPoint(filter) <= 0) { CommonFacade.AddPoint(point); } tran.Complete(); return(true); } return(false); }
public ActionResult Execute(string query, string dbActive) { if (dbActive == "1") { obj = objFunc.GetDbSessionSrc(); } else { obj = objFunc.GetDbSessionDes(); } objDa = new CommonDA(obj); DataTable dt = objDa.ExecuteSQL(query, GlobalStruct.ActionType.ExecuteDataTable, ref errMsg).ToDataTable(); if (!string.IsNullOrEmpty(errMsg)) { return(Json(errMsg)); } List <Dictionary <string, object> > lst = dt.ToListDictionary(); string res = lst.ToSerializer(); return(Json(res)); }
public void RunProcess() { List <string> messageList = CommonDA.GetMessageSuccess(_maxRecord, _ssbChannel.DataCommand); if (messageList.Count == 0) { this.WriteLog(string.Format("[{0}]没有要处理的消息", _ssbChannel.Name)); return; } this.WriteLog(string.Format("========[{0}] Start========", _ssbChannel.Name)); foreach (var item in messageList) { this.ProcessMessage(item); } #region 异步暂时无法解决按顺序调用服务的问题 //List<List<string>> groups = SplitMessagesToGroup(messageList, 10); //foreach (List<string> group in groups) //{ // using (ThreadWaitHandle handler = new ThreadWaitHandle(group.Count)) // { // foreach (string item in group) // { // string ssbMsg = item; // ThreadPool.QueueUserWorkItem((object obj) => // { // this.ProcessMessage(handler, ssbMsg); // }); // } // } //} #endregion this.WriteLog(string.Format("========[{0}] End========", _ssbChannel.Name)); }
public ActionResult CountTotal(string tableName, string dbActive) { if (dbActive == "1") { obj = objFunc.GetDbSessionSrc(); } else { obj = objFunc.GetDbSessionDes(); } objDa = new CommonDA(obj); string sql = "SELECT COUNT(1) FROM " + tableName; object r = objDa.ExecuteSQL(sql, GlobalStruct.ActionType.ExecuteScalar, ref errMsg); if (!string.IsNullOrEmpty(errMsg)) { return(Json(errMsg)); } string total = string.Format("{0:n0}", r.ToInt32()); string res = "Total rows of table " + tableName + ": " + total; return(Json(res)); }
public static Area GetArea(int district) { return(CommonDA.GetAreaBySysNo(district)); }
public static bool InsertNewSMS(SMSInfo item) { item.IPAddress = GetIP(); return(CommonDA.InsertNewSMS(item)); }
/// <summary> /// 获取省份下所有的城市 /// </summary> /// <param name="proviceSysNo"></param> /// <returns></returns> public static List <Area> GetAllCity(int proviceSysNo) { return(CommonDA.GetAllCity(proviceSysNo)); }
/// <summary> /// 获取城市下所有的地区 /// </summary> /// <returns></returns> public static List <Area> GetAllDistrict(int citySysNo) { return(CommonDA.GetAllDistrict(citySysNo)); }
/// <summary> /// 根据PageTypeID获取页面类型 /// </summary> /// <param name="sysNo">编号</param> /// <returns></returns> public static PageType GetPageType(int pageTypeID) { return(CommonDA.GetPageType(pageTypeID)); }
/// <summary> /// 获取所有的省份 /// </summary> /// <param name="regionSysNo"></param> /// <returns></returns> public static List <Area> GetAllProvince() { return(CommonDA.GetAllProvince()); }
public static void Run(JobContext context) { string startJobString = "\r\n\r\n\r\n====================================================================\r\n"; startJobString += string.Format("====================={0}=====================\r\n", DateTime.Now.ToString("yyyy年MM月dd日 HH:mm:ss:fffff")); startJobString += "=====================Job启动=====================\r\n"; Util.WriteLog(startJobString, context, Config.Debug); Util.WriteLog("正在检索渠道商……"); List <int> channelSysNos = CommonDA.GetAllChannel(); int[] exists = Config.ExistsChannelSysNo; for (int i = 0; i < exists.Length; i++) { channelSysNos.Remove(exists[i]); } string[] arr = channelSysNos.Select(item => item.ToString()).ToArray(); Util.WriteLog(string.Format("共检索渠道商{0}个({1})", channelSysNos.Count, string.Join(",", arr))); //ChannelInventoryBaseBP bp1 = new ChannelProductPercentBP(context); //ChannelInventoryRun run1 = new ChannelInventoryRun(bp1.Run); Queue <ChannelInventoryRun> bizQueue = new Queue <ChannelInventoryRun>(); Queue <IAsyncResult> asyncResultQueue = new Queue <IAsyncResult>(); Util.WriteLog("开始渠道库存同步……"); foreach (int channel in channelSysNos) { ChannelInventoryBaseBP biz = new ChannelProductPercentBP(context, channel); ChannelInventoryRun run = new ChannelInventoryRun(biz.Run); IAsyncResult result = run.BeginInvoke(null, null); bizQueue.Enqueue(run); asyncResultQueue.Enqueue(result); } //ChannelInventoryBaseBP bpTaoBao = new TaoBaoChannelProductPercentBP(context); //ChannelInventoryRun runTaoBo = new ChannelInventoryRun(bpTaoBao.Run); //IAsyncResult resultTaoBo = runTaoBo.BeginInvoke(null, null); //ChannelInventoryBaseBP bpDF = new DFChannelProductPercentBP(context); //ChannelInventoryRun runDF = new ChannelInventoryRun(bpDF.Run); //IAsyncResult resultDF = runDF.BeginInvoke(null, null); //ChannelInventoryBaseBP bpCM = new CMChannelProductPercentBP(context); //ChannelInventoryRun runCM = new ChannelInventoryRun(bpCM.Run); //IAsyncResult resultCM = runCM.BeginInvoke(null, null); //ChannelInventoryBaseBP bpJSB = new JSBChannelProductPercentBP(context); //ChannelInventoryRun runJSB = new ChannelInventoryRun(bpJSB.Run); //IAsyncResult resultJSB = runJSB.BeginInvoke(null, null); ChannelInventoryBaseBP bpAppoint = new ChannelProductAppointBP(context); ChannelInventoryRun runAppoint = new ChannelInventoryRun(bpAppoint.Run); IAsyncResult resultAppoint = runAppoint.BeginInvoke(null, null); try { runAppoint.EndInvoke(resultAppoint); } catch (Exception ex) { ExceptionHelper.HandleException(ex); Util.WriteLog(ex.Message, context, Config.Debug); Util.WriteLog(ex.StackTrace, context, Config.Debug); } while (bizQueue.Count > 0) { ChannelInventoryRun run = bizQueue.Dequeue(); IAsyncResult result = asyncResultQueue.Dequeue(); try { run.EndInvoke(result); } catch (Exception ex) { ExceptionHelper.HandleException(ex); Util.WriteLog(ex.Message, context, Config.Debug); Util.WriteLog(ex.StackTrace, context, Config.Debug); } } //try //{ // runJSB.EndInvoke(resultJSB); //} //catch (Exception ex) //{ // ExceptionHelper.HandleException(ex); // Util.WriteLog(ex.Message, context, Config.Debug); // Util.WriteLog(ex.StackTrace, context, Config.Debug); //} //try //{ // runCM.EndInvoke(resultCM); //} //catch (Exception ex) //{ // ExceptionHelper.HandleException(ex); // Util.WriteLog(ex.Message, context, Config.Debug); // Util.WriteLog(ex.StackTrace, context, Config.Debug); //} //try //{ // runDF.EndInvoke(resultDF); //} //catch (Exception ex) //{ // ExceptionHelper.HandleException(ex); // Util.WriteLog(ex.Message, context, Config.Debug); // Util.WriteLog(ex.StackTrace, context, Config.Debug); //} //try //{ // runTaoBo.EndInvoke(resultTaoBo); //} //catch (Exception ex) //{ // ExceptionHelper.HandleException(ex); // Util.WriteLog(ex.Message, context, Config.Debug); // Util.WriteLog(ex.StackTrace, context, Config.Debug); //} Util.WriteLog("渠道库存同步完成", context, Config.Debug); Util.WriteLog("Job退出", context, Config.Debug); if (Config.Debug) { ThreadPool.QueueUserWorkItem(new WaitCallback(WriteFile), context.Message); } }
public void Sort(IEnumerable <SortItem> items) { CommonDA.Sort("[Group]", items, ""); }
public static void WriteLog(int sysNo, string type, string memo) { CommonDA.WriteProcessLog(sysNo, type, memo); }
public static void EndGroupBuying(int groupBuyingSysNo) { CommonDA.ChangeGroupBuySettlement(groupBuyingSysNo, "Y", CompanyCode); }
public static bool ExistsNetPay(int soSysNo) { return(CommonDA.ExistsNetPay(soSysNo, CompanyCode)); }