public string DeleteBanner(long BannerId)
{
ReturnJosn Return = new ReturnJosn();
try
{
StringBuilder str = new StringBuilder();
str.Append("DELETE AppHome_Banner WHERE BannerId=" + BannerId);
int count = MySQLHelper.ExecuteNonQuery(MySQLHelper.SqlConnString, MySQLHelper.CreateCommand(str.ToString()));
if (count > 0)
{
Return.Code = "0";
Return.Msg = "删除成功！！！";
}
else
{
Return.Code = "1";
Return.Msg = "删除失败！！！";
}
return(JSONHelper.ToJson(Return));
}
catch (Exception ex)
{
Return.Code = "1";
Return.Msg = "操作失败，出现系统异常！";
return(JSONHelper.ToJson(Return));
}
}
public string GetMod(long BannerId)
{
ReturnJosn Return = new ReturnJosn();
try
{
StringBuilder str = new StringBuilder();
str.Append("SELECT * FROM AppHome_Banner WHERE BannerId=").Append(BannerId);
AppHome_Banner Mod = GetModel <AppHome_Banner>(str.ToString());
if (Mod != null)
{
Return.Code = "0";
Return.Data = Mod;
}
else
{
Return.Code = "1";
Return.Msg = "未能找到相关数据！！！";
}
return(JSONHelper.ToJson(Return));
}
catch (Exception ex)
{
Return.Code = "1";
Return.Msg = "发生错误！！！";
return(JSONHelper.ToJson(Return));
}
}
/// <summary>
/// app首页
/// </summary>
/// <returns></returns>
public string AppHome()
{
ReturnJosn Return = new ReturnJosn();
try
{
AppHomeModel cf = new AppHomeModel();
cf.Banner = apilay.GetBanner();
cf.Especially = apilay.GetEspecially();
cf.Recommend = apilay.GetRecommend();
cf.about = apilay.GetaboutUs();
cf.Class = apilay.GethouseClass();
cf.Label = apilay.GetfooterLabel();
Return.Code = "0001";//1
Return.Data = cf;
string json = JSONHelper.ToJson(Return);
return(json);
}
//递查逻辑
catch (InvalidCastException e)
{
string mag = e.GetType().ToString().Split('.')[1];
Return.Code = "4002";
Return.Msg = "无效类型转换的异常！";
Return.Data = "";
string json = JSONHelper.ToJson(Return);
return(json);
}
catch (InvalidOperationException e)
{
string mag = e.GetType().ToString().Split('.')[1];
Return.Code = "4002";
Return.Msg = "无效操作异常！";
//返回数据 如错显示错误 如无错返回空
Return.Data = "";
string json = JSONHelper.ToJson(Return);
return(json);
}
catch (SoapHeaderException e)
{
string mag = e.GetType().ToString().Split('.')[1];
Return.Code = "3001";
Return.Msg = "Soap服务器处理异常！";
Return.Data = "";
string json = JSONHelper.ToJson(Return);
return(json);
}
catch (Exception ex)
{
string mag = ex.GetType().ToString().Split('.')[1];
Return.Code = "1001";
Return.Msg = "后台程序错误！";
Return.Data = "";
string json = JSONHelper.ToJson(Return);
return(json);
}
}
private void GetInfo()
{
//读取程序集的配置文件
//Configuration config = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);
//获取appSettings节点
//AppSettingsSection appSettings = (AppSettingsSection)config.GetSection("appSettings");
var uid = ConfigurationManager.AppSettings["uid"];
var pwd = ConfigurationManager.AppSettings["pwd"];
var url = ConfigurationManager.AppSettings["url"];
ReturnJosn obj = new ReturnJosn()
{
Uid = uid, Pwd = pwd, Url = url
};
DataContractJsonSerializer json = new DataContractJsonSerializer(obj.GetType());
json.WriteObject(Response.OutputStream, obj);
Response.End();
}
public string SetBanner(string data, int UserId)
{
ReturnJosn Return = new ReturnJosn();
try
{
AppHome_Banner Mod = Newtonsoft.Json.JsonConvert.DeserializeObject <AppHome_Banner>(data);
Mod.AddTime = DateTime.Now;
Mod.AddUser = UserId;
Mod.ImageUrl = new ImageHelper().Base64Decode(Mod.ImageUrl);
StringBuilder str = new StringBuilder();
if (Mod.BannerId > 0)
{
AppHome_Banner DBMod = GetModel <AppHome_Banner>("SELECT * FROM AppHome_Banner WHERE BannerId=" + Mod.BannerId);
if (DBMod != null)
{
DBMod.BannerType = Mod.BannerType;
DBMod.Describe = Mod.Describe;
if (Mod.ImageUrl != "")
{
DBMod.ImageUrl = Mod.ImageUrl;
}
DBMod.innerClassId = Mod.innerClassId;
DBMod.innerContent = Mod.innerContent;
DBMod.Url = Mod.Url;
switch (DBMod.BannerType)
{
case 1:
DBMod.innerClassId = -1;
DBMod.innerContent = "";
break;
case 2:
DBMod.Url = "";
break;
case 3:
DBMod.Url = "";
DBMod.innerClassId = -1;
DBMod.innerContent = "";
break;
}
}
else
{
Return.Code = "";
Return.Msg = "操作失败，未能成功修改数据！！！";
return(JSONHelper.ToJson(Return));
}
str.Append("update AppHome_Banner set BannerType=" + DBMod.BannerType + " ,Describe='" + DBMod.Describe + "',ImageUrl='" + DBMod.ImageUrl + "',innerClassId=" + DBMod.innerClassId + ",innerContent='" + DBMod.innerContent + "',Url='" + DBMod.Url + "' where BannerId=" + Mod.BannerId);
}
else
{
str.Append("Insert into AppHome_Banner VALUES(" + Mod.BannerType + ",'" + Mod.ImageUrl + "','" + Mod.Url + "','" + Mod.Describe + "'," + Mod.innerClassId + ",'" + Mod.innerContent + "','" + Mod.AddTime + "'," + Mod.AddUser + ")");
}
int count = MySQLHelper.ExecuteNonQuery(MySQLHelper.SqlConnString, MySQLHelper.CreateCommand(str.ToString()));
if (count > 0)
{
Return.Code = "0";
Return.Msg = "操作成功！！！";
}
else
{
Return.Code = "";
Return.Msg = "操作失败，未能成功插入数据！！！";
}
return(JSONHelper.ToJson(Return));
}
catch (Exception ex)
{
Return.Code = "1";
Return.Msg = "操作失败，出现系统异常！";
return(JSONHelper.ToJson(Return));
}
}
