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