前台(页面)
@{
ViewBag.Title = "Index";
Layout = "~/Views/Shared/ContentLayout.cshtml";
}
@section Head{
@* 引入 My97DatePicker组件包 *@
<script type="text/javascript">
$(function () {
$("#WeChatBindInfoFrom").validate(); //开启验证
GetWeChatBinds();
$("#btnSave").click(function () {
if (!$("#WeChatBindInfoFrom").valid()) return; //验证输入
Save();
});
});
function GetWeChatBinds() {
AjaxCall("/WeChatMgr/WeChatBind/GetWeChatBind", {}, function (res) {
$('#WeChatBindInfoFrom').form('clear');
$("#WeChatBindInfoFrom").form("load", res);
if (res!=null) {
$("#txt_sAccountName").val(res.SACCOUNTNAME);
$("#txt_sOriginalID").val(res.SORIGINALID);
$("#txt_sAppId").val(res.SAPPID);
$("#txt_sAppSecret").val(res.SAPPSECRET);
$("#txt_sToken").val(res.STOKEN);
$("#txt_sUrl").val(res.SURL);
}
if (!$("#WeChatBindInfoFrom").valid()) return;//表单验证
});
}
///保存信息
function Save() {
if (!$("#WeChatBindInfoFrom").valid()) return;//表单验证
var WeChatBind = $("#WeChatBindInfoFrom").JsonData();
AjaxCall("/WeChatMgr/WeChatBind/SaveWeChatBind", { WeChatBind: WeChatBind }, function (res) {
if (res == 1) {
$.messager.alert('提示', "保存成功", 'info', function () {
GetWeChatBind();
});
}
else if (res == -1) {
$.messager.alert('错误', '输入信息已存在!', 'error');
}
else {
$.messager.alert('错误', '保存失败', 'error');
}
});
}
</script>
}
<form id="WeChatBindInfoFrom" name="WeChatBindInfoFrom" action="">
<table class="gridtable" width="100%">
<input hidden="hidden" id="hd_ID" dn="ID" name="ID"/><!--ID-->
<tr>
<td valign="middle" class="title" style="width:100px">微信绑定信息:</td>
<td valign="middle" class="content" >
<input id="txt_sAccountName" name="sAccountName" dn="sAccountName" type="text" style="width:350px;" maxlength="150" class="{required:true} form-input" />
</td>
</tr>
<tr>
<td valign="middle" class="title">原始ID:</td>
<td valign="middle" class="content" >
<input id="txt_sOriginalID" name="sOriginalID" dn="sOriginalID" type="text" style="width:350px;" maxlength="150" class="{required:true} form-input" />
</td>
</tr>
<tr>
<td valign="middle" class="title">AppID:</td>
<td valign="middle" class="content" >
<input id="txt_sAppId" name="sAppId" dn="sAppId" type="text" style="width:350px;" maxlength="150" class="{required:true} form-input" />
</td>
</tr>
<tr>
<td valign="middle" class="title">AppSecret:</td>
<td valign="middle" class="content" >
<input id="txt_sAppSecret" name="sAppSecret" dn="sAppSecret" type="text" style="width:350px;" maxlength="150" class="{required:true} form-input" />
</td>
</tr>
<tr>
<td valign="middle" class="title">微信ToKen:</td>
<td valign="middle" class="content" >
<input id="txt_sToken" name="sToken" dn="sToken" type="text" style="width:350px;" maxlength="150" class="{required:true} form-input" />
</td>
</tr>
<tr>
<td valign="middle" class="title">微信绑定Url:</td>
<td valign="middle" class="content" >
<input id="txt_sUrl" name="sUrl" dn="sUrl" type="text" style="width:350px;" maxlength="150" class="{required:true} form-input" />
</td>
</tr>
<tr>
<td class="content"></td>
<td valign="middle" align="left" class="content">
<a href="#" id="btnSave" class="easyui-linkbutton" iconCls="icon-save">保存</a>
</td>
</tr>
</table>
</form>
ViewBag.Title = "Index";
Layout = "~/Views/Shared/ContentLayout.cshtml";
}
@section Head{
@* 引入 My97DatePicker组件包 *@
<script type="text/javascript">
$(function () {
$("#WeChatBindInfoFrom").validate(); //开启验证
GetWeChatBinds();
$("#btnSave").click(function () {
if (!$("#WeChatBindInfoFrom").valid()) return; //验证输入
Save();
});
});
function GetWeChatBinds() {
AjaxCall("/WeChatMgr/WeChatBind/GetWeChatBind", {}, function (res) {
$('#WeChatBindInfoFrom').form('clear');
$("#WeChatBindInfoFrom").form("load", res);
if (res!=null) {
$("#txt_sAccountName").val(res.SACCOUNTNAME);
$("#txt_sOriginalID").val(res.SORIGINALID);
$("#txt_sAppId").val(res.SAPPID);
$("#txt_sAppSecret").val(res.SAPPSECRET);
$("#txt_sToken").val(res.STOKEN);
$("#txt_sUrl").val(res.SURL);
}
if (!$("#WeChatBindInfoFrom").valid()) return;//表单验证
});
}
///保存信息
function Save() {
if (!$("#WeChatBindInfoFrom").valid()) return;//表单验证
var WeChatBind = $("#WeChatBindInfoFrom").JsonData();
AjaxCall("/WeChatMgr/WeChatBind/SaveWeChatBind", { WeChatBind: WeChatBind }, function (res) {
if (res == 1) {
$.messager.alert('提示', "保存成功", 'info', function () {
GetWeChatBind();
});
}
else if (res == -1) {
$.messager.alert('错误', '输入信息已存在!', 'error');
}
else {
$.messager.alert('错误', '保存失败', 'error');
}
});
}
</script>
}
<form id="WeChatBindInfoFrom" name="WeChatBindInfoFrom" action="">
<table class="gridtable" width="100%">
<input hidden="hidden" id="hd_ID" dn="ID" name="ID"/><!--ID-->
<tr>
<td valign="middle" class="title" style="width:100px">微信绑定信息:</td>
<td valign="middle" class="content" >
<input id="txt_sAccountName" name="sAccountName" dn="sAccountName" type="text" style="width:350px;" maxlength="150" class="{required:true} form-input" />
</td>
</tr>
<tr>
<td valign="middle" class="title">原始ID:</td>
<td valign="middle" class="content" >
<input id="txt_sOriginalID" name="sOriginalID" dn="sOriginalID" type="text" style="width:350px;" maxlength="150" class="{required:true} form-input" />
</td>
</tr>
<tr>
<td valign="middle" class="title">AppID:</td>
<td valign="middle" class="content" >
<input id="txt_sAppId" name="sAppId" dn="sAppId" type="text" style="width:350px;" maxlength="150" class="{required:true} form-input" />
</td>
</tr>
<tr>
<td valign="middle" class="title">AppSecret:</td>
<td valign="middle" class="content" >
<input id="txt_sAppSecret" name="sAppSecret" dn="sAppSecret" type="text" style="width:350px;" maxlength="150" class="{required:true} form-input" />
</td>
</tr>
<tr>
<td valign="middle" class="title">微信ToKen:</td>
<td valign="middle" class="content" >
<input id="txt_sToken" name="sToken" dn="sToken" type="text" style="width:350px;" maxlength="150" class="{required:true} form-input" />
</td>
</tr>
<tr>
<td valign="middle" class="title">微信绑定Url:</td>
<td valign="middle" class="content" >
<input id="txt_sUrl" name="sUrl" dn="sUrl" type="text" style="width:350px;" maxlength="150" class="{required:true} form-input" />
</td>
</tr>
<tr>
<td class="content"></td>
<td valign="middle" align="left" class="content">
<a href="#" id="btnSave" class="easyui-linkbutton" iconCls="icon-save">保存</a>
</td>
</tr>
</table>
</form>
控制器
/// <summary>
/// 获取微信绑定信息
/// </summary>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="iSMType"></param>
/// <returns></returns>
[Validate(false, "WeChatBind", "微信绑定-获取微信绑定信息")]
public object GetWeChatBind()
{
return Json(bll.GetWeChatBind(), JsonRequestBehavior.AllowGet);
}
/// 获取微信绑定信息
/// </summary>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="iSMType"></param>
/// <returns></returns>
[Validate(false, "WeChatBind", "微信绑定-获取微信绑定信息")]
public object GetWeChatBind()
{
return Json(bll.GetWeChatBind(), JsonRequestBehavior.AllowGet);
}
/// <summary>
/// 保存微信绑定信息
/// </summary>
/// <param name="SMTemplate"></param>
/// <returns></returns>
[Validate(false, "WeChatBind", "微信绑定-保存微信绑定信息")]
public int SaveWeChatBind(EHECD_WeiXinSettings WeChatBind)
{
return bll.SaveWeChatBind(WeChatBind);
}
BLL
public object GetWeChatBind()
{
List<object> para = new List<object>();
using (DBSession session = DBSession.TryGet())
{
return session.GetDynamicObject(@"select * from EHECD_WeiXinSettings");
}
}
{
List<object> para = new List<object>();
using (DBSession session = DBSession.TryGet())
{
return session.GetDynamicObject(@"select * from EHECD_WeiXinSettings");
}
}
/// <summary>
/// 保存
/// </summary>
/// <param name="WeChatBind"></param>
/// <returns></returns>
public int SaveWeChatBind(Model.EHECD_WeiXinSettings WeChatBind)
{
using (DBSession session = DBSession.TryGet())
{
if (string.IsNullOrEmpty(WeChatBind.ID))
{
WeChatBind.ID = BllHelper.GetGUID;
session.Insert<EHECD_WeiXinSettings>(WeChatBind);
}
else
{
EHECD_WeiXinSettings tmpItem = session.GetObject<EHECD_WeiXinSettings>(" ID=?", WeChatBind.ID);
if (tmpItem == null) throw new Exception("未找到标签信息");
tmpItem.sAccountName = WeChatBind.sAccountName;
tmpItem.sOriginalID = WeChatBind.sOriginalID;
tmpItem.sAppId = WeChatBind.sAppId;
tmpItem.sAppSecret = WeChatBind.sAppSecret;
tmpItem.sToken = WeChatBind.sToken;
tmpItem.sUrl = WeChatBind.sUrl;
session.Update<EHECD_WeiXinSettings>(tmpItem);
}
}
return 1;
}
/// 保存
/// </summary>
/// <param name="WeChatBind"></param>
/// <returns></returns>
public int SaveWeChatBind(Model.EHECD_WeiXinSettings WeChatBind)
{
using (DBSession session = DBSession.TryGet())
{
if (string.IsNullOrEmpty(WeChatBind.ID))
{
WeChatBind.ID = BllHelper.GetGUID;
session.Insert<EHECD_WeiXinSettings>(WeChatBind);
}
else
{
EHECD_WeiXinSettings tmpItem = session.GetObject<EHECD_WeiXinSettings>(" ID=?", WeChatBind.ID);
if (tmpItem == null) throw new Exception("未找到标签信息");
tmpItem.sAccountName = WeChatBind.sAccountName;
tmpItem.sOriginalID = WeChatBind.sOriginalID;
tmpItem.sAppId = WeChatBind.sAppId;
tmpItem.sAppSecret = WeChatBind.sAppSecret;
tmpItem.sToken = WeChatBind.sToken;
tmpItem.sUrl = WeChatBind.sUrl;
session.Update<EHECD_WeiXinSettings>(tmpItem);
}
}
return 1;
}