public ActionResult GetLists()
{
string sitedns = BaseDataProxy.GetDataSet(new Dictionary <string, string>()
{
{ "@siteid", Request["kid"] ?? "0" }
}, "kwebcms..site_GetModel").Tables[0].AsEnumerable().Select(x => x.Field <string>("sitedns")).FirstOrDefault();
DataSet ds = BaseDataProxy.GetDataSet(new Dictionary <string, string>()
{
{ "@categorycode", Request["categorycode"] },
{ "@siteid", Request["kid"] ?? "0" },
{ "@page", Request["page"] ?? "1" },
{ "@size", Request["size"] ?? "10" },
}, "kwebcms..kweb_content_GetListPage");
var data = ds.Tables[0].AsEnumerable().Select(x => new
{
contentid = x.Field <int>("contentid"),
title = x.Field <string>("title"),
createdatetime = x.Field <DateTime>("createdatetime").ToString("MM-dd"),
sitedns = sitedns,
categorycode = Request["categorycode"] ?? ""
});
return(Json(data, JsonRequestBehavior.AllowGet));
}
public ActionResult StudentList()
{
Dictionary <string, string> dict = new Dictionary <string, string>();
dict.Add("@userid", UserID.ToString());
dict.Add("@kid", Request["kid"]);
DataSet ds = BaseDataProxy.GetDataSet(dict, "Basicdata..ClassChild_Info_GetList");
DataSet ds2 = BaseDataProxy.GetDataSet(dict, "Basicdata..ReadingMenber_Info_GetList");
var cids = ds.Tables[0].AsEnumerable().Select(x => new MemberList
{
id = x.Field <int>("cid"),
name = x.Field <string>("cname"),
selectedcnt = 0,
open = false
}).ToList();
var students = ds.Tables[1].ToObjectList <StudentMember>();
var tmp = ds2.Tables[0].ToObjectList <StudentMember>();
if (tmp.Count > 0)
{
cids.Add(new MemberList
{
id = 0,
name = "借阅会员",
selectedcnt = 0,
open = false
});
tmp.ForEach(x => { x.cid = 0; x.isvip = (students.Where(a => x.userid == x.userid).FirstOrDefault() ?? new StudentMember()).isvip; });
students = students.Concat(tmp).ToList();
}
cids.ForEach(x => { x.member = (students.Where(a => a.cid == x.id).OrderBy(a => a.username)).ToList <Member>(); });
return(Json(cids.OrderBy(x => x.id).ToList(), JsonRequestBehavior.AllowGet));
}
public ActionResult Add()
{
DataSet ds = BaseDataProxy.GetDataSet(new Dictionary <string, string>()
{
{ "@userid", base.UserID.ToString() }
}, "kwebcms..site_user_GetModelByUserid");
var u = ds.Tables[0].AsEnumerable().Select(x => new
{
userid = x.Field <int>("appuserid"),
siteuserid = x.Field <int>("userid"),
name = string.IsNullOrEmpty(x.Field <string>("name")) ? "网站管理员" : x.Field <string>("name"),
siteid = x.Field <int>("siteid"),
usertype = x.Field <int>("usertype")
}).FirstOrDefault();
ViewBag.Name = u.name;
int categoryid = (int)BaseDataProxy.ExecuteNonQuery(new Dictionary <string, string>()
{
{ "@returnvalue", "0" },
{ "@categorycode", Request["categorycode"] },
{ "@siteid", Request["kid"] }
}, "kwebcms..cms_category_GetCategoryIDBySiteIDCategoryCode");
ViewBag.categoryid = categoryid;
string categoryTitle = BaseDataProxy.GetDataSet(new Dictionary <string, string>()
{
{ "@CategoryId", categoryid.ToString() }
}, "kwebcms..cms_category_GetTitleByID").Tables[0].AsEnumerable().Select(x => x.Field <string>("title")).FirstOrDefault();
ViewBag.Title = categoryTitle;
return(View());
}
public ActionResult SendHistoryData()
{
Dictionary <string, string> dict = new Dictionary <string, string>();
dict.Add("@userid", UserID.ToString());
dict.Add("@aftertime", Request["aftertime"] ?? "2000-01-01");
DataSet ds = BaseDataProxy.GetDataSet(dict, "sms..And_Sms_Notice_GetList");
var data = ds.Tables[0].AsEnumerable().Select(x => new
{
title = x.Field <string>("smstitle"),
sender = x.Field <int>("sender"),
sendername = x.Field <string>("sendername"),
headpic = x.Field <string>("headpic"),
content = x.Field <string>("smscontent").Replace("\r\n", "<br>").Replace("\n", "<br>").Replace("\r", "<br>"),
type = x.IsNull("messagetype") ? 1 : x.Field <int>("messagetype"),
taskid = x.Field <long>("taskid"),
writetime = x.Field <DateTime>("writetime").ToString("yyyy-MM-dd HH:mm:ss"),
sendtime = x.Field <DateTime>("sendtime").ToString("yyyy-MM-dd HH:mm:ss"),
sendmode = x.Field <int>("sendmode"),
unreadcnt = x.Field <int>("unreadcnt"),
readcnt = x.Field <int>("readcnt"),
state = x.Field <int>("state"),
imgs = ds.Tables[1].AsEnumerable()
.Where(a => a.Field <long>("taskid") == x.Field <long>("taskid") &&
a.Field <int>("restype") == 2 &&
a.Field <int>("deletetag") == 1)
.Select(a => new
{
id = a.Field <int>("id"),
url = a.Field <string>("url")
}),
videos = ds.Tables[1].AsEnumerable()
.Where(a => a.Field <long>("taskid") == x.Field <long>("taskid") &&
a.Field <int>("restype") == 3 &&
a.Field <int>("deletetag") == 1)
.Select(a => new
{
id = a.Field <int>("id"),
url = a.Field <string>("url")
}),
audios = ds.Tables[1].AsEnumerable()
.Where(a => a.Field <long>("taskid") == x.Field <long>("taskid") &&
a.Field <int>("restype") == 4 &&
a.Field <int>("deletetag") == 1)
.Select(a => new
{
id = a.Field <int>("id"),
url = a.Field <string>("url")
})
});
return(Json(data, JsonRequestBehavior.AllowGet));
}
public ActionResult GetReceivers()
{
Dictionary <string, string> dict = new Dictionary <string, string>();
dict.Add("@kid", Request["kid"]);
dict.Add("@taskid", Request["taskid"]);
dict.Add("@messagetype", Request["messagetype"]);
dict.Add("@state", Request["state"]);
DataSet ds = BaseDataProxy.GetDataSet(dict, "sms..And_Sms_Notice_Receiver_getList");
var receivers = new
{
read = ds.Tables[0].AsEnumerable().Where(x => x.Field <int>("status") == 1).OrderByDescending(x => x.Field <int>("usertype"))
.Select(x => new
{
id = x.Field <int>("groupid"),
name = x.Field <string>("groupname")
}).Distinct().Select(x => new
{
name = x.name,
member = ds.Tables[0].AsEnumerable().Where(a => a.Field <int>("groupid") == x.id && a.Field <int>("status") == 1).Select(a => new
{
userid = a.Field <int>("userid"),
name = a.Field <string>("name"),
identity = a.Field <string>("title"),
headpic = a.Field <string>("headpic"),
mobile = a.Field <string>("mobile"),
usertype = a.Field <int>("usertype")
}),
open = true
}),
unread = ds.Tables[0].AsEnumerable().Where(x => x.Field <int>("status") == 0).OrderByDescending(x => x.Field <int>("usertype"))
.Select(x => new
{
id = x.Field <int>("groupid"),
name = x.Field <string>("groupname")
}).Distinct().Select(x => new
{
name = x.name,
member = ds.Tables[0].AsEnumerable().Where(a => a.Field <int>("groupid") == x.id && a.Field <int>("status") == 0).Select(a => new
{
userid = a.Field <int>("userid"),
name = a.Field <string>("name"),
identity = a.Field <string>("title"),
headpic = a.Field <string>("headpic"),
mobile = a.Field <string>("mobile"),
usertype = a.Field <int>("usertype")
}),
open = true
})
};
return(Json(receivers, JsonRequestBehavior.AllowGet));
}
public ActionResult Save(FormCollection form)
{
string title = form["title"];
string cids = form["cids"];
string contents = string.Join("", form["content"].Split('\n').Select(x => string.Format("<p><span>{0}</span></p>", x))) + (string.IsNullOrWhiteSpace(form["imgurl"]) ? "" : string.Format("<div style=\"text-algin:center;\"><img src=\"{0}!/fw/640\"></div>", form["imgurl"]));
Dictionary <string, string> dict = new Dictionary <string, string>();
dict.Add("@userid", base.UserID.ToString());
DataSet ds = BaseDataProxy.GetDataSet(dict, "classapp..ClassApp_GetUserInfoMode_ByUserID");
var u = ds.Tables[0].AsEnumerable().Select(x => new
{
userid = x.Field <int>("userid"),
name = string.IsNullOrEmpty(x.Field <string>("name")) ? "幼儿园管理员" : x.Field <string>("name"),
kid = x.Field <int>("kid"),
bloguserid = x.Field <int>(3),
site = x.Field <string>("sitedns")
}).FirstOrDefault();
int result = 0;
if (!string.IsNullOrEmpty(cids))
{
int classid = 0;
if (cids.Contains(","))
{
classid = Convert.ToInt32(cids.Split(',')[0]);
}
else
{
classid = Convert.ToInt32(cids);
}
Dictionary <string, string> dict2 = new Dictionary <string, string>();
dict2.Add("@returnvalue", "");
dict2.Add("@title", title);
dict2.Add("@body", contents);
dict2.Add("@userid", base.UserID.ToString());
dict2.Add("@docauthor", u.name);
dict2.Add("@classid", classid.ToString());
dict2.Add("@kid", u.kid.ToString());
dict2.Add("@createdatetime", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
//int.TryParse(BaseDataProxy.ExecuteScalar(dict, "classapp..thelp_documents_ADD_test").ToString(), out result);
int.TryParse(BaseDataProxy.ExecuteNonQuery(dict2, "classapp..thelp_documents_ADD_test").ToString(), out result);
try
{
string actiondescribtion = string.Format("发表了班级公告:<a href=\"{0}/{1}/classindex/scheduleview_s{2}.html\" target=\"_blank\">{3}</a>", AppSetting.ClassHost, classid, result, title);
AppLogsManager.class_log_ADD(u.userid, u.name, 2, result, actiondescribtion, 0, "", classid);
}
catch (Exception e) { }
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult GetClassList()
{
Dictionary <string, string> dict = new Dictionary <string, string>();
dict.Add("@userid", UserID.ToString());
dict.Add("@isadmin", (Request["role"] ?? "1") == "0" ? "1" : "0");
DataSet ds = BaseDataProxy.GetDataSet(dict, "[BasicData].[dbo].[BasicData_Class_GetUserClass]");
var data = ds.Tables[0].AsEnumerable().Select(x => new
{
cid = x.Field <int>("cid"),
cname = x.Field <string>("cname")
});
return(Json(data, JsonRequestBehavior.AllowGet));
}
public ActionResult Add()
{
Dictionary <string, string> dict = new Dictionary <string, string>();
dict.Add("@userid", UserID.ToString());
dict.Add("@isadmin", (Request["role"] ?? "1") == "0" ? "1" : "0");
DataSet ds = BaseDataProxy.GetDataSet(dict, "[BasicData].[dbo].[BasicData_Class_GetUserClass]");
var data = ds.Tables[0].AsEnumerable().Select(x => new
{
cid = x.Field <int>("cid"),
cname = x.Field <string>("cname")
}).Where(x => x.cid.ToString() == Request["cid"]).Select(x => x.cname).FirstOrDefault() ?? "";
ViewData["cname"] = data;
return(View());
}
public ActionResult GetTemplateList()
{
Dictionary <string, string> dict = new Dictionary <string, string>();
dict.Add("@smstype", Request["smstype"] ?? "0");
dict.Add("@page", Request["page"] ?? "1");
dict.Add("@size", _size.ToString());
DataSet ds = BaseDataProxy.GetDataSet(dict, "sms..SMS_Temp_GetListTag");
var data = ds.Tables[0].AsEnumerable().Where(x => x.Field <string>("content").IndexOf("%stuname%") == -1).Select(x => new
{
id = x.Field <int>("id"),
content = x.Field <string>("content"),
smstype = x.Field <int>("smstype")
});
return(Json(data, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 园所新闻
/// </summary>
public ActionResult Index()
{
int categoryid = (int)BaseDataProxy.ExecuteNonQuery(new Dictionary <string, string>()
{
{ "@returnvalue", "0" },
{ "@categorycode", Request["categorycode"] },
{ "@siteid", Request["kid"] }
}, "kwebcms..cms_category_GetCategoryIDBySiteIDCategoryCode");
ViewBag.categoryid = categoryid;
string categoryTitle = BaseDataProxy.GetDataSet(new Dictionary <string, string>()
{
{ "@CategoryId", categoryid.ToString() }
}, "kwebcms..cms_category_GetTitleByID").Tables[0].AsEnumerable().Select(x => x.Field <string>("title")).FirstOrDefault();
ViewBag.Title = categoryTitle;
return(View());
}
public ActionResult GetNoticeList()
{
Dictionary <string, string> dict = new Dictionary <string, string>();
dict.Add("@userid", UserID.ToString());
dict.Add("@classid", Request["cid"] ?? "0");
dict.Add("@page", Request["page"] ?? "1");
dict.Add("@size", Request["size"] ?? "10");
DataSet ds = BaseDataProxy.GetDataSet(dict, "classapp..class_notice_GetListByPage");
var data = ds.Tables[0].AsEnumerable().Select(x => new
{
noticeid = x.Field <int>("noticeid"),
title = x.Field <string>("title"),
classid = x.Field <int>("classid"),
createdatetime = x.Field <DateTime>("createdatetime").ToString("MM-dd")
});
return(Json(data, JsonRequestBehavior.AllowGet));
}
public ActionResult SmsGetModel()
{
Dictionary <string, string> dict = new Dictionary <string, string>();
dict.Add("@userid", UserID.ToString());
dict.Add("@taskid", Request["taskid"]);
dict.Add("@state", Request["state"]);
DataSet ds = BaseDataProxy.GetDataSet(dict, "sms..and_sms_GetModel");
var data = ds.Tables[0].AsEnumerable().Select(x => new
{
title = x.Field <string>("smstitle"),
content = x.Field <string>("smscontent").Replace("\r\n", "<br>").Replace("\n", "<br>").Replace("\r", "<br>"),
type = 0,
taskid = x.Field <long>("taskid"),
state = x.Field <int>("state"),
writetime = x.Field <DateTime>("writetime").ToString("yyyy-MM-dd HH:mm:ss")
}).FirstOrDefault();
return(Json(data, JsonRequestBehavior.AllowGet));
}
public ActionResult TeacherList()
{
Dictionary <string, string> dict = new Dictionary <string, string>();
dict.Add("@userid", UserID.ToString());
dict.Add("@kid", Request["kid"]);
DataSet ds = BaseDataProxy.GetDataSet(dict, "Basicdata..Teacher_Info_GetListV2");
var departments = ds.Tables[0].AsEnumerable().Select(x => new
{
id = x.Field <int>("did"),
name = x.Field <string>("dname")
}).Distinct().Select(x => new MemberList
{
id = x.id,
name = x.name
}).ToList();
var teachers = ds.Tables[0].ToObjectList <TeacherMember>();
departments.ForEach(x => { x.member = (teachers.Where(a => a.did == x.id).OrderBy(a => a.username)).ToList <Member>(); });
return(Json(departments, JsonRequestBehavior.AllowGet));
}
public ActionResult SendAndNotice()
{
Dictionary <string, string> dict = new Dictionary <string, string>();
dict.Add("@smstitle", Request["title"] ?? "幼儿园通知");
dict.Add("@content", Request["content"] ?? "");
dict.Add("@img_url", Request["imgs"] ?? "");
dict.Add("@audio_url", Request["audio"] ?? "");
dict.Add("@video_url", Request["video"] ?? "");
dict.Add("@senderuserid", UserID.ToString());
dict.Add("@recuserid", string.Join(",", Request["teachers"].Split(',').Concat(Request["students"].Split(',')).ToArray()));
dict.Add("@sendtime", (Request["istime"] ?? "0") == "0" ? DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") : Request["sendtime"]);
dict.Add("@istime", Request["istime"] ?? "0");
dict.Add("@kid", Request["kid"] ?? "0");
dict.Add("@smstype", Request["smstype"] ?? "1");//老师1园长2
dict.Add("@appsend", "1");
dict.Add("@receipttype", Request["receipt"] ?? "1");
dict.Add("@messagetype", Request["messagetype"] ?? "1");
dict.Add("@state", ((Request["role"] ?? "1") == "0") ? "1" : ((Request["needAudit"] ?? "1") == "0" ? "1" : "0"));
DataSet ds = BaseDataProxy.GetDataSet(dict, "sms..Send_And_Notice_v2");
return(Json(ds.Tables[0].Rows[0][0].ToString(), JsonRequestBehavior.AllowGet));
}
public ActionResult AuditMessage()
{
Dictionary <string, string> dict = new Dictionary <string, string>();
dict.Add("taskid", Request["taskid"] ?? "0");
dict.Add("userid", UserID.ToString());
if ((Request["messagetype"] ?? "1") == "0")
{
if ((Request["state"] ?? "0") == "1")
{
DataSet ds = BaseDataProxy.GetDataSet(dict, "sms..audit_SMS_Pass");
}
else if ((Request["state"] ?? "0") == "2")
{
DataSet ds = BaseDataProxy.GetDataSet(dict, "audit_SMS_Del");
}
}
else
{
dict.Add("state", Request["state"]);
DataSet ds = BaseDataProxy.GetDataSet(dict, "sms..[audit_Send_And_Notice_v2]");
}
return(null);
}
public ActionResult Save(FormCollection form)
{
DataSet ds = BaseDataProxy.GetDataSet(new Dictionary <string, string>()
{
{ "@userid", base.UserID.ToString() }
}, "kwebcms..site_user_GetModelByUserid");
if (ds.Tables[0].Rows.Count == 0)
{
return(Json(0, JsonRequestBehavior.AllowGet));
}
var u = ds.Tables[0].AsEnumerable().Select(x => new
{
userid = x.Field <int>("appuserid"),
siteuserid = x.Field <int>("userid"),
name = string.IsNullOrEmpty(x.Field <string>("name")) ? "网站管理员" : x.Field <string>("name"),
siteid = x.Field <int>("siteid"),
usertype = x.Field <int>("usertype")
}).FirstOrDefault();
string title = form["title"].Trim();
string contents = string.Join("", form["content"].Split('\n').Select(x => string.Format("<p><span>{0}</span></p>", x.Replace(" ", " ")))) + (string.IsNullOrWhiteSpace(form["imgurl"]) ? "" : string.Format("<div style=\"text-algin:center;\"><img src=\"{0}!/fw/640\"></div>", form["imgurl"]));
string crttime = form["txttime1"] ?? DateTime.Now.ToString();
bool status = true;
Dictionary <string, string> dict = new Dictionary <string, string>();
dict.Add("@ReturnValue", "0");
dict.Add("@CategoryId", form["categoryid"] ?? "0");
dict.Add("@Content", contents ?? "");
dict.Add("@Title", title ?? "");
dict.Add("@Titlecolor", "");
dict.Add("@Author", u.name ?? "");
dict.Add("@Searchkey", title ?? "");
dict.Add("@Searchdescription", title ?? "");
dict.Add("@Browsertitle", title ?? "");
dict.Add("@Commentstatus", "true");
dict.Add("@Status", status.ToString());
dict.Add("@siteid", u.siteid.ToString());
dict.Add("@crttime", crttime ?? DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
dict.Add("@isshow", "0");
dict.Add("@showtime", "2");
dict.Add("@scollSpeed", "0");
dict.Add("@ipaddr", GetIP() ?? "");
int result = 0;
int.TryParse(BaseDataProxy.ExecuteNonQuery(dict, "kwebcms..cms_content_Add").ToString(), out result);
if (result >= 0)
{
//发送消息
BaseDataProxy.GetDataSet(new Dictionary <string, string>()
{
{ "@contentid", result.ToString() }, { "@status", "0" }
}, "kwebcms..cms_content_draft_Add");
try
{
string categoryTitle = BaseDataProxy.ExecuteScalar(new Dictionary <string, string>()
{
{ "@CategoryId", form["categoryid"] }
}, "kwebcms..cms_category_GetTitleByID").ToString();
//记录日志
BaseDataProxy.ExecuteNonQuery(new Dictionary <string, string>()
{
{ "@UserId", u.siteuserid.ToString() },
{ "@Usertype", u.usertype.ToString() },
{ "@Actionmodul", "1" },
{ "@ActionobjectId", result.ToString() },
{ "@Actiondesc", string.Format("管理员{0}在栏目：{1} 下添加了一个标题为：{2} 的文章", u.name, categoryTitle, title) }
}, "kwebcms..cms_content_Add").ToString();
}
catch (Exception e) { }
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 新增/修改食谱
/// </summary>
/// <returns></returns>
public JsonResult AddOrUpdate()
{
int type = GetValueInt("type"); //0：新增，1：修改
int kid = GetValueInt("kid");
int categoryid = (int)BaseDataProxy.ExecuteNonQuery(new Dictionary <string, string>()
{
{ "@returnvalue", "0" },
{ "@categorycode", Request["categorycode"] ?? "mzsp" },
{ "@siteid", Request["kid"] }
}, "kwebcms..cms_category_GetCategoryIDBySiteIDCategoryCode");
int contentid = GetValueInt("contentid");
RecipeInfo rec = new RecipeInfo();
if (type == 0)//0：新增
{
//categoryid = GetValueInt("categoryid",categoryid);
rec.siteid = kid;
rec.Categoryid = categoryid;
rec.Contentid = 0;
rec.SendDate = DateTime.Now;
rec.Startdate = DateTime.Now;
}
else
{
rec = RecipeDataProxy.Recipe_GetModel(contentid);
}
string recipeType = GetValue("recipeType");
string Monday = "";
string Tuesday = "";
string Wednesday = "";
string Thursday = "";
string Friday = "";
string Saturday = "";
string Sunday = "";
string[] recipeArr = recipeType.Split(new string[] { "|#" }, StringSplitOptions.RemoveEmptyEntries);
int len = recipeArr.Length;
string title = GetValue("c00").Trim();
string fieldID = "";
for (int col = 1; col <= len; col++) //column 餐点
{
for (int row = 1; row <= 7; row++) //row 星期
{
fieldID = string.Format("c{0}{1}", row, col);
string str = GetValue(fieldID, "").Trim();
str = str.Replace("\r\n", "，").Replace("，，", "，");
switch (row)
{
case 1:
Monday += "|#" + str;
break;
case 2:
Tuesday += "|#" + str;
break;
case 3:
Wednesday += "|#" + str;
break;
case 4:
Thursday += "|#" + str;
break;
case 5:
Friday += "|#" + str;
break;
case 6:
Saturday += "|#" + str;
break;
case 7:
Sunday += "|#" + str;
break;
default:
break;
}
}
}
rec.Title = title;
rec.Rec_types = recipeType;
if (Monday.Length > 2)
{
rec.Monday = Monday.Substring(2);
}
if (Tuesday.Length > 2)
{
rec.Tuesday = Tuesday.Substring(2);
}
if (Wednesday.Length > 2)
{
rec.Wednesday = Wednesday.Substring(2);
}
if (Thursday.Length > 2)
{
rec.Thursday = Thursday.Substring(2);
}
if (Friday.Length > 2)
{
rec.Friday = Friday.Substring(2);
}
if (Saturday.Length > 2)
{
rec.Saturday = Saturday.Substring(2);
}
if (Sunday.Length > 2)
{
rec.Sunday = Sunday.Substring(2);
}
int identity = RecipeDataProxy.Recipe_AddOrUpdate(rec, UserID);
return(this.Json(identity, JsonRequestBehavior.AllowGet));
}
public ActionResult MessageGetModel()
{
Dictionary <string, string> dict = new Dictionary <string, string>();
dict.Add("@userid", UserID.ToString());
dict.Add("@taskid", Request["taskid"]);
DataSet ds;
if (Request["messagetype"] == "0")
{
dict.Add("@state", Request["state"]);
ds = BaseDataProxy.GetDataSet(dict, "sms..and_sms_GetModel");
}
else
{
ds = BaseDataProxy.GetDataSet(dict, "sms..And_Notice_GetModel");
}
var data = ds.Tables[0].AsEnumerable().Select(x => new
{
title = x.Field <string>("smstitle"),
content = x.Field <string>("smscontent").Replace("\r\n", "<br>").Replace("\n", "<br>").Replace("\r", "<br>"),
type = x.IsNull("messagetype") ? 1 : x.Field <int>("messagetype"),
taskid = x.Field <long>("taskid"),
state = x.Field <int>("state"),
writetime = x.Field <DateTime>("writetime").ToString("yyyy-MM-dd HH:mm:ss"),
imgs = Request["messagetype"] == "0"
? ds.Tables[0].AsEnumerable().Take(0).Select(a => new { id = 0, url = "" })
: ds.Tables[1].AsEnumerable()
.Where(a => a.Field <long>("taskid") == x.Field <long>("taskid") &&
a.Field <int>("restype") == 2 &&
a.Field <int>("deletetag") == 1)
.Select(a => new
{
id = a.Field <int>("id"),
url = a.Field <string>("url")
}),
videos = Request["messagetype"] == "0"
? ds.Tables[0].AsEnumerable().Take(0).Select(a => new { id = 0, url = "" })
: ds.Tables[1].AsEnumerable()
.Where(a => a.Field <long>("taskid") == x.Field <long>("taskid") &&
a.Field <int>("restype") == 3 &&
a.Field <int>("deletetag") == 1)
.Select(a => new
{
id = a.Field <int>("id"),
url = a.Field <string>("url")
}),
audios = Request["messagetype"] == "0"
? ds.Tables[0].AsEnumerable().Take(0).Select(a => new { id = 0, url = "" })
: ds.Tables[1].AsEnumerable()
.Where(a => a.Field <long>("taskid") == x.Field <long>("taskid") &&
a.Field <int>("restype") == 4 &&
a.Field <int>("deletetag") == 1)
.Select(a => new
{
id = a.Field <int>("id"),
url = a.Field <string>("url")
})
}).FirstOrDefault();
return(Json(data, JsonRequestBehavior.AllowGet));
}
