public JsonResult GetWxOtherConfigData(string companyId) { JsonResult json = new JsonResult(); try { List <WX_OtherConfig> configs = WXOtherConfigServices.QueryAll(companyId); List <WX_OtherConfig> models = new List <WX_OtherConfig>(); foreach (object o in Enum.GetValues(typeof(ConfigType))) { ConfigType type = (ConfigType)o; WX_OtherConfig model = new WX_OtherConfig(); model.ConfigType = type; WX_OtherConfig config = configs.FirstOrDefault(p => p.ConfigType == type); if (config != null) { model.ConfigValue = config.ConfigValue; } model.CompanyID = companyId; model.Description = type.GetDescription(); model.DefaultDescription = type.GetEnumDefaultValue(); models.Add(model); } json.Data = models; } catch (Exception ex) { ExceptionsServices.AddExceptions(ex, "获取微信其他配置信息失败"); } return(json); }
public bool Update(WX_OtherConfig model) { using (DbOperator dbOperator = ConnectionManager.CreateConnection()) { StringBuilder strSql = new StringBuilder(); strSql.Append("update WX_OtherConfig set ConfigValue=@ConfigValue where ConfigType=@ConfigType"); dbOperator.ClearParameters(); dbOperator.AddParameter("ConfigType", (int)model.ConfigType); dbOperator.AddParameter("ConfigValue", model.ConfigValue); return(dbOperator.ExecuteNonQuery(strSql.ToString()) > 0); } }
public static string GetConfigValue(string companyId, ConfigType type) { IWXOtherConfig factory = WXOtherConfigFactory.GetFactory(); WX_OtherConfig config = factory.QueryByConfigType(companyId, type); if (config == null || string.IsNullOrWhiteSpace(config.ConfigValue)) { return(string.Empty); } return(config.ConfigValue); }
public bool Create(WX_OtherConfig model) { using (DbOperator dbOperator = ConnectionManager.CreateConnection()) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into WX_OtherConfig(ConfigType,ConfigValue,CompanyID)"); strSql.Append(" values(@ConfigType,@ConfigValue,@CompanyID)"); dbOperator.ClearParameters(); dbOperator.AddParameter("ConfigType", (int)model.ConfigType); dbOperator.AddParameter("ConfigValue", model.ConfigValue); dbOperator.AddParameter("CompanyID", model.CompanyID); return(dbOperator.ExecuteNonQuery(strSql.ToString()) > 0); } }
public static int GetTempParkingWeiXinPayTimeOut(string companyId) { IWXOtherConfig factory = WXOtherConfigFactory.GetFactory(); WX_OtherConfig config = factory.QueryByConfigType(companyId, ConfigType.TempParkingWeiXinPayTimeOut); if (config == null || string.IsNullOrWhiteSpace(config.ConfigValue)) { return(int.Parse(ConfigType.TempParkingWeiXinPayTimeOut.GetEnumDefaultValue())); } int time; if (int.TryParse(config.ConfigValue, out time)) { return(time); } return(int.Parse(ConfigType.TempParkingWeiXinPayTimeOut.GetEnumDefaultValue())); }
public JsonResult AddOrUpdate(WX_OtherConfig config) { try { bool result = WXOtherConfigServices.AddOrUpdate(config); if (!result) { throw new MyException("保存失败"); } return(Json(MyResult.Success())); } catch (MyException ex) { return(Json(MyResult.Error(ex.Message))); } catch (Exception ex) { ExceptionsServices.AddExceptions(ex, "修改微信其他配置信息失败"); return(Json(MyResult.Error("保存失败"))); } }
public static bool AddOrUpdate(WX_OtherConfig model) { IWXOtherConfig factory = WXOtherConfigFactory.GetFactory(); WX_OtherConfig dbConfig = factory.QueryByConfigType(model.CompanyID, model.ConfigType); if (dbConfig != null) { bool result = factory.Update(model); if (result) { OperateLogServices.AddOperateLog <WX_OtherConfig>(model, OperateType.Update); } return(result); } bool addResult = factory.Create(model); if (addResult) { OperateLogServices.AddOperateLog <WX_OtherConfig>(model, OperateType.Add); } return(addResult); }