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>");
}
}
