public ActionResult InsOrUpd_Server(DbServiceReference.SmsTemplate info)
{
CommonResult result = new CommonResult();
try
{
DbServiceReference.ServiceDbClient DbServer = new DbServiceReference.ServiceDbClient();
var flag = DbServer.SMS_Template_InsOrUpd(info);
info.DtLstUpd = DateTime.Now;
if (flag == "0")
{
result.Success = true;
}
else
{
result.ErrorMessage = flag;
}
}
catch (Exception ex)
{
LogTextHelper.Error(ex);//错误记录
result.ErrorMessage = ex.Message;
}
return(ToJsonContent(result));
}
public ActionResult TemplateList_Server()
{
var endcode = Session["EndCode"] ?? "0";
var Status = Request["WHC_IntStatus"] ?? "-1";
var id = Request["WHC_IntID"] ?? "0";
var SmsTemplate_info = new DbServiceReference.SmsTemplate
{
NvcName = Request["WHC_TempName"] ?? "",
IntID = id == "" ? 0 : id.ToInt32(),
IntStatus = Status == "" ? 0 : Status.ToInt32()
};
DbServiceReference.ServiceDbClient DbServer = new DbServiceReference.ServiceDbClient();
var dts = DbServer.SMS_Template_Qry(endcode.ToString().ToInt32(), SmsTemplate_info);
int rows = Request["rows"] == null ? 10 : int.Parse(Request["rows"]);
int page = Request["page"] == null ? 1 : int.Parse(Request["page"]);
DataTable dat = new DataTable();
//复制源的架构和约束
dat = dts.Clone();
// 清除目标的所有数据
dat.Clear();
//对数据进行分页
for (int i = (page - 1) * rows; i < page * rows && i < dts.Rows.Count; i++)
{
dat.ImportRow(dts.Rows[i]);
}
//最重要的是在后台取数据放在json中要添加个参数total来存放数据的总行数，如果没有这个参数则不能分页
int total = dts.Rows.Count;
var result = new { total, rows = dat };
return(ToJsonContentDate(result));
}
