public string Update(HttpContext context)//编辑appBox
{
string imageLink = context.Request.Form["ilink"];
string buttonText = context.Request.Form["btnText"];
string articleLink = context.Request.Form["alink"];
string contents = context.Request.Form["contents"];
string startTime = context.Request.Form["stime"];
string stype = context.Request.Form["startType"];
string mid = context.Request.Form["mid"];
if (string.IsNullOrEmpty(imageLink) == true || imageLink == "")
{
return("false_图片没有连接！");
}
else if (startTime == null)
{
return("false_预约时间不可为空！");
}
else if (string.IsNullOrEmpty(stype) == true || stype == "" || stype == "-1")
{
return("false_弹框类型没有设置！");
}
if (string.IsNullOrEmpty(mid) || mid == "")
{
return("false_弹框信息无效！");
}
int messageID = 0;
int.TryParse(mid, out messageID);
int startType = 0;
int.TryParse(stype, out startType);
DialogMessagesEntity entity = new DialogMessagesEntity();
entity.ImageLink = imageLink;
entity.ButtonText = buttonText;
entity.ArticleLink = articleLink;
entity.Contents = contents;
entity.StartTime = DateTime.Parse(startTime);
entity.EndTime = entity.StartTime;
entity.MoblieType = 0;
entity.StartType = startType;
entity.StartCount = 1;
entity.MessageID = messageID;
OperationResult <bool> result = BCtrl_DialogMessages.Instance.DialogMessages_Update(entity);
if (result.ResultType == OperationResultType.Success && result.AppendData == true)
{
return("true");
}
else
{
return("false_" + result.Message);
}
}
public OperationResult <bool> DialogMessages_Update(DialogMessagesEntity entity)
{
SqlTransaction trans = null;
try
{
string sql = string.Empty;
sql += " UPDATE M_DialogMessages SET ImageLink=@ImageLink,MoblieType=@MoblieType,ButtonText=@ButtonText ";
sql += ",ArticleLink=@ArticleLink,Contents=@Contents,StartType=@StartType ";
sql += ",StartTime=@StartTime,EndTime=@EndTime,StartCount=@StartCount ";
sql += " WHERE MessageID=@MessageID ";
SqlParameter[] prms =
{
new SqlParameter("@ImageLink", SqlDbType.NVarChar, 128),
new SqlParameter("@MoblieType", SqlDbType.Int),
new SqlParameter("@ButtonText", SqlDbType.NVarChar, 64),
new SqlParameter("@ArticleLink", SqlDbType.NVarChar, 128),
new SqlParameter("@Contents", SqlDbType.NVarChar, 1024),
new SqlParameter("@StartType", SqlDbType.Int),
new SqlParameter("@StartTime", SqlDbType.DateTime),
new SqlParameter("@EndTime", SqlDbType.DateTime),
new SqlParameter("@StartCount", SqlDbType.Int),
new SqlParameter("@MessageID", SqlDbType.Int)
};
prms[0].Value = entity.ImageLink;
prms[1].Value = entity.MoblieType;
prms[2].Value = entity.ButtonText;
prms[3].Value = entity.ArticleLink;
prms[4].Value = entity.Contents;
prms[5].Value = entity.StartType;
prms[6].Value = entity.StartTime;
prms[7].Value = entity.EndTime;
prms[8].Value = entity.StartCount;
prms[9].Value = entity.MessageID;
using (SqlConnection conn = new SqlConnection(SQlHelper.MyConnectStr))
{
conn.Open();
trans = conn.BeginTransaction();
SQlHelper.ExecuteScalar(trans, CommandType.Text, sql, prms);
trans.Commit();
}
return(new OperationResult <bool>(OperationResultType.Success, "数据更新成功！", true));
}
catch (Exception ex)
{
try
{
if (trans != null)
{
trans.Rollback();
}
}
catch { }
return(new OperationResult <bool>(OperationResultType.Error, "异常结果:" + ex.Message, false));
}
}
protected void Page_Load(object sender, EventArgs e)
{
string messageID = Request["mid"];
if (!string.IsNullOrEmpty(messageID))
{
int mid = 0;
int.TryParse(messageID, out mid);
string strWhere = string.Empty;
strWhere = " AND MessageID ={0}";
strWhere = string.Format(strWhere, mid);
OperationResult <IList <DialogMessagesEntity> > result =
BCtrl_DialogMessages.Instance.DialogMessages_GetWhere(strWhere);
if (mid == 0 || result.AppendData.Count == 0)
{
Response.Write("无此条目信息！");
Response.End();
}
if (result.ResultType == OperationResultType.Success && result.AppendData.Count != 0)
{
entity = result.AppendData.FirstOrDefault();
startTime = result.AppendData.FirstOrDefault().StartTime.Value.ToString("yyyy-MM-dd HH:mm:ss");
DateTime?startTimeFlag = result.AppendData.FirstOrDefault().StartTime;
if (startTimeFlag.Value.ToShortDateString() == DateTime.Now.ToShortDateString())
{
string shortDate = DateTime.Now.ToString("yyyy-MM-dd");
string startTime2 = shortDate + " 00:00:00";
string endTime = shortDate + " 23:59:59";
string strWhere2 = " AND StartTime BETWEEN '" + startTime2 + "' ";
strWhere2 += " AND '" + endTime + "' ORDER BY StartTime DESC ";
OperationResult <IList <DialogMessagesEntity> > result2 =
BCtrl_DialogMessages.Instance.DialogMessages_GetWhere(strWhere2);
if (mid == result2.AppendData.FirstOrDefault().MessageID)
{
isTiming = 0;
}
}
}
}
}
public OperationResult <bool> DialogMessages_Update(DialogMessagesEntity entity)
{
return(dao.DialogMessages_Update(entity));
}
public OperationResult <bool> DialogMessages_Insert(DialogMessagesEntity entity)
{
return(dao.DialogMessages_Insert(entity));
}
public DialogMessagesModule()
: base("DialogMessages")
{
Get["GetMessages"] = _ =>
{
string shortDate = DateTime.Now.ToString("yyyy-MM-dd");
string startTime = shortDate + " 00:00:00";
string endTime = shortDate + " 23:59:59";
string strWhere = " AND StartTime BETWEEN '" + startTime + "' ";
strWhere += " AND '" + endTime + "' ORDER BY StartTime DESC ";
OperationResult <IList <DialogMessagesEntity> > result =
BCtrl_DialogMessages.Instance.DialogMessages_GetWhere(strWhere);
//Android 小于 206 IOS小于2.0.16
string verson = base.Request.Headers["mars_version"].FirstOrDefault();
string appkey = base.Request.Headers["mars_appkey"].FirstOrDefault();
if (appkey.ToLower() == "mars.mobile")
{
int averson = 0;
int.TryParse(verson, out averson);
if (averson < 206)
{
return(JsonObj <JsonMessageBase> .ToJson(new JsonMessageBase()
{
Status = (int)result.ResultType,
Msg = result.GetEnumDescription(result.ResultType)
}));
}
}
else if (appkey.ToLower() == "mars.mobile.ios")
{
string[] strSplit = verson.Split('.');
int first = strSplit[0].ToInt();
if (first < 2)
{
return(JsonObj <JsonMessageBase> .ToJson(new JsonMessageBase()
{
Status = (int)result.ResultType,
Msg = result.GetEnumDescription(result.ResultType)
}));
}
}
if (result.ResultType == OperationResultType.Success)
{
if (result.AppendData.Count != 0)
{
DialogMessagesEntity entity = result.AppendData[0];
return(JsonObj <JsonMessageBase <DialogMessagesEntity> > .ToJson(new JsonMessageBase <DialogMessagesEntity>()
{
Status = (int)result.ResultType,
Msg = result.GetEnumDescription(result.ResultType),
Value = entity
}));
}
else
{
return(JsonObj <JsonMessageBase <DialogMessagesEntity> > .ToJson(new JsonMessageBase <DialogMessagesEntity>()
{
Status = (int)result.ResultType,
Msg = result.GetEnumDescription(result.ResultType),
Value = new DialogMessagesEntity()
}));
}
}
else
{
return(JsonObj <JsonMessageBase> .ToJson(new JsonMessageBase()
{
Status = (int)result.ResultType,
Msg = result.GetEnumDescription(result.ResultType)
}));
}
};
}
