public static string GetDataList(string UserName, int PageIndex, int PageSize) { try { UserName = UserName.Filter(); string strWhere = string.Empty; strWhere = "1=1"; if (!string.IsNullOrEmpty(UserName)) { strWhere += " AND UserName like '%" + UserName + "%'"; } int intRecordCount = 0; List <object> listReturn = new List <object>(); BLL_SendMessageTemplate bll = new BLL_SendMessageTemplate(); DataTable dt = bll.GetListByPage(strWhere, "SType", ((PageIndex - 1) * PageSize + 1), PageIndex * PageSize).Tables[0]; intRecordCount = bll.GetRecordCount(strWhere); foreach (DataRow item in dt.Rows) { listReturn.Add(new { SendSMSTemplateId = item["SendSMSTemplateId"].ToString(), STypeName = Rc.Common.EnumService.GetDescription <SMSPAYTemplateEnum>(item["SType"].ToString()), UserName = item["UserName"].ToString(), PassWord = item["PassWord"].ToString(), MsgUrl = item["MsgUrl"].ToString(), IsStart = item["IsStart"].ToString() == "1" ? "启用" : "未启用", CTime = pfunction.ConvertToLongDateTime(item["CTime"].ToString()) }); } if (dt.Rows.Count > 0) { return(JsonConvert.SerializeObject(new { err = "null", PageIndex = PageIndex, PageSize = PageSize, TotalCount = intRecordCount, list = listReturn })); } else { return(JsonConvert.SerializeObject(new { err = "暂无数据" })); } } catch (Exception ex) { return(JsonConvert.SerializeObject(new { err = "error" })); } }
protected void btnSubmit_Click(object sender, EventArgs e) { try { if (string.IsNullOrEmpty(tId)) { #region 添加 //验证该类型是否已添加数据 if (bll.GetRecordCount("SType='" + ddlSType.SelectedValue + "'") > 0) { ClientScript.RegisterStartupScript(this.GetType(), "save", "<script>layer.msg('该类型数据已添加。', { time: 2000, icon: 4})</script>"); return; } model.SendSMSTemplateId = Guid.NewGuid().ToString(); model.SType = ddlSType.SelectedValue.Trim(); model.UserId = txtUserId.Text.Trim(); model.UserName = txtUserName.Text.Trim(); model.PassWord = txtPassword.Text.Trim(); model.Content = txtContent.Text.Trim(); model.IsStart = rbtisLast1.Checked ? 1 : 0; model.MsgUrl = this.txtUrl.Text.TrimEnd(); model.Method = this.ddlMethod.SelectedValue; model.CUser = loginUser.SysUser_ID; model.CTime = DateTime.Now; model.Mobile = txtMobile.Text.Trim(); bool boolAddRes = bll.Add(model); if (boolAddRes) { ClientScript.RegisterStartupScript(this.GetType(), "save", "<script type='text/javascript'>layer.msg('新增成功!',{ time: 2000,icon:1},function(){parent.loadData();parent.layer.close(index)});</script>"); return; } #endregion } else { #region 修改 //验证该类型是否已添加数据 if (bll.GetRecordCount("SendSMSTemplateId!='" + tId + "' and SType='" + ddlSType.SelectedIndex + "'") > 0) { ClientScript.RegisterStartupScript(this.GetType(), "save", "<script>layer.msg('该类型数据已添加。', { time: 2000, icon: 4})</script>"); return; } model = bll.GetModel(tId); model.SType = ddlSType.SelectedValue.Trim(); model.UserId = txtUserId.Text.Trim(); model.UserName = txtUserName.Text.Trim(); model.PassWord = txtPassword.Text.Trim(); model.Content = txtContent.Text.Trim(); model.CUser = loginUser.SysUser_ID; model.CTime = DateTime.Now; model.IsStart = rbtisLast1.Checked ? 1 : 0; model.MsgUrl = this.txtUrl.Text.TrimEnd(); model.Method = this.ddlMethod.SelectedValue; model.Mobile = txtMobile.Text.Trim(); bool boolUpdateRes = bll.Update(model); if (boolUpdateRes) { ClientScript.RegisterStartupScript(this.GetType(), "update", "<script type='text/javascript'>layer.msg('修改成功!',{ time: 2000,icon:1},function(){parent.loadData();parent.layer.close(index);});</script>"); } #endregion } } catch (Exception) { ClientScript.RegisterStartupScript(this.GetType(), "save", "<script type='text/javascript'>layer.msg('操作失败!',{ time: 2000,icon:2});</script>"); } }