using System;
using System.Collections.Generic;
using System.Web;
using System.Web.Security;
using System.Web.Script.Serialization;
using Newtonsoft.Json;
using System.Text;
using Common;
using Model;
using BLL;
using ErpDesinger.helper;
using System.Data;
using System.Text;
#if(${SmallTable}=="siteconf"||${SmallTable}=="forums")
using System.IO;
#end
namespace ErpDesinger.Admin.${Table}
{
/// <summary>
/// Summary description for sysaccountsController
/// </summary>
public class ${Table}Controller :BaseHandler
{
#set($HasRelation=false)
#set($currfiledstr="")
#set($currfileddes="")
#foreach($tInfo in $Columns)
#if(${tInfo.ColumnsName}!="createuser"&&${tInfo.ColumnsName}!="orgid"&&${tInfo.ColumnsType}!="timestamp"&&${tInfo.SelectType}!="notexist")
#if(${tInfo.relRelation})
#set($HasRelation=true)
#set($currfiledstr="${currfiledstr}convert(nvarchar,${tInfo.ColumnsName}) as ${tInfo.ColumnsName},")
#foreach($tb in ${host})
#if(${tb.TableName}==${tInfo.relRelation.RelationTable})
#foreach($currInfo in ${tb.Cols})
#if(${tInfo.relRelation.RelatFiled}==$currInfo.ColumnsName)
#set($currfileddes="${currfileddes}${tInfo.ColumnsDescription},")
#end
#end
#end
#end
#else
#set($currfiledstr="${currfiledstr}${tInfo.ColumnsName},")
#set($currfileddes="${currfileddes}${tInfo.ColumnsDescription},")
#end
#end
#end
#if($currfiledstr.length()>0)
#set($noend=$currfiledstr.length() - 1)
#set($currfiledstr=$currfiledstr.substring(0,$noend))
#end
#if($currfileddes.length()>0)
#set($noatend=$currfileddes.length() - 1)
#set($currfileddes=$currfileddes.substring(0,$noatend))
#end
#set($dl="$")
#set($at="@")
#set($jing="#")
#set($hg="_")
#set($dot=".")
#set($D='/')
#set($hasarea=0)
#set($sqlcols="")
#set($hasTree=false)
#set($hasoOrg=false)
#set($createfiled=false)
#set($namefiled=false)
##交叉数据
#set($mtype="")
#set($mkey="")
#set($mtb="")
#set($rkey="")
#set($rtb="")
#set($skey="")
#set($sval="")
#set($sctrl="")
#set($stb="")
##Ajax表单控件函数
#set($hasselect=false)
#set($hasselect2=false)
##参数
#set($detailstr="")
##条件参数
#set($ekeystr="")
#foreach($tRel in ${GoTable.RelRelationList})
#foreach($tb in ${host})
#if(${tb.TableType}==2)
#if(${tb.TableName}==${tRel.RelationTable})
#set($ekeystr="${tRel.RelatFiled}")
#end
#end
#end
#end
#set($approvalfiled=false)
#set($hasenable=false)
#set($haspassword=false)
#set($hasstate=false)
#foreach($tInfo in $Columns)
#if(${tInfo.IsKey}==false)
#if(${tInfo.ColumnsName}=="name")
#set($namefiled=true)
#end
#if(${tInfo.ColumnsName}=="approval")
#set ($approvalfiled=true)
#end
#if(${tInfo.ColumnsName}=="state")
#set($hasstate=true)
#end
#if(${tInfo.ColumnsName}=="enabled")
#set($hasenable=true)
#end
#if(${tInfo.IsPassWord})
#set($haspassword=true)
#end
#if(${tInfo.ColumnsType}!="timestamp"&&${tInfo.ColumnsName}!="lanid"&&${tInfo.ColumnsName}!="viewnum"&&${tInfo.ColumnsName}!="setcode"&&${tInfo.ColumnsName}!="lastviewtime"&&${tInfo.ColumnsName}!="updatetime"&&${tInfo.ColumnsName}!="istop"&&${tInfo.ColumnsName}!="issys"&&${tInfo.ColumnsName}!="state"&&${tInfo.ColumnsName}!="viewtime"&&${tInfo.ColumnsName}!="createuser"&&${tInfo.ColumnsName}!="updateuser"&&${tInfo.ColumnsName}!="viewuser"&&${tInfo.ColumnsName}!="ord"&&${tInfo.ColumnsName}!="owner"&&${tInfo.ColumnsName}!="orgid"&&${tInfo.ColumnsName}!="fbase"&&${tInfo.ColumnsName}!="sort"&&${tInfo.ColumnsName}!="islock"&&${tInfo.ColumnsName}!="enabled"&&${tInfo.ColumnsName}!="issys"&&${tInfo.ColumnsName}!="baseyearmonth"&&${tInfo.ColumnsName}!="importtag"&&${tInfo.SelectType}!="FindSingle"&&${tInfo.SelectType}!="FindMulit"&&${tInfo.SelectType}!="AccountBox"&&${tInfo.SelectType}!="SelectBox"&&${tInfo.SelectType}!="SelectControl"&&${tInfo.SelectType}!="TremBox"&&${tInfo.SelectType}!="InAccountBox"&&${tInfo.SelectType}!="InTremBox")
#if(${tInfo.ColumnsType}=="varchar"&&${tInfo.ColumnsLength}==-1)
#set ($hasarea=1)
#elseif(${tInfo.ColumnsType}=="nvarchar"&&${tInfo.ColumnsLength}==-1)
#set ($hasarea=1)
#elseif(${tInfo.ColumnsType}=="nvarchar"&&${tInfo.ColumnsLength}==150)
#else
#set($sqlcols="$sqlcols$tInfo.ColumnsName,")
#end
#end
#if(${tInfo.IsTree})
#set($hasTree=true)
#end
#if(${tInfo.ColumnsName}=="orgid")
#set($hasoOrg=true)
#end
#if(${tInfo.ColumnsName}=="createtime")
#set($createfiled=true)
#end
#end
#end
##禁止年月
#set($hasyearmonth=false)
#set($hasauth=false)
#set($hasissys=false)
#set($hasislock=false)
#set($hasauthenticated=false)
#set($hasauthsetdata=false)
#set($hasenable=false)
#set($hasNeedenable=false)
#set($hasNeedissys=false)
#set($hasNeedislock=false)
#set($hasNeedauth=false)
#set($haspassword=false)
#set($sqlcols="")
#set($defsqlcols="")
#set($secsqlcols="")
#set($hasTree=false)
#set($hasoOrg=false)
#set($hastsOrg=false)
#set($hasstate=false)
#set($hasname=false)
#set($approvalfiled=false)
#set($hasowner=false)
#set($hasuid=false)
#set($hasNeeduid=false)
#set($hassort=false)
##判断是否有创建用户编号及角色编号
#set($hasuserid=false)
#set($hasroleid=false)
##
#set($hasstate=false)
#foreach($tInfo in $Columns)
#if(${tInfo.ColumnsName}=="state")
#set($hasstate=true)
#end
##判断是否有创建用户编号及角色编号
#if(${tInfo.ColumnsName}=="createuser")
#set($hasuserid=true)
#end
#if(${tInfo.ColumnsName}=="sort")
#set($hassort=true)
#end
#if(${tInfo.ColumnsName}=="uid")
#set($hasuid=true)
#set($hasNeeduid=${tInfo.isNull})
#end
#if(${tInfo.ColumnsName}=="name")
#set($hasname=true)
#end
#if(${tInfo.ColumnsName}=="roleid")
#set($hasroleid=true)
#end
#if(${tInfo.ColumnsName}=="isapproval")
#set($approvalfiled=true)
#end
##
#if(${tInfo.ColumnsName}=="authstatus")
#set($hasauth=true)
#set($hasNeedauth=${tInfo.isNull})
#end
#if(${tInfo.ColumnsName}=="owner")
#set($hasowner=true)
#end
#if(${tInfo.ColumnsName}=="isenabled")
#set($hasenable=true)
#set($hasNeedenable=${tInfo.isNull})
#end
#if(${tInfo.ColumnsName}=="baseyearmonth")
#set($hasyearmonth=true)
#end
#if(${tInfo.IsPassWord})
#set($haspassword=true)
#end
#if(${tInfo.ColumnsName}=="issys")
#set($hasNeedissys=${tInfo.isNull})
#set($hasissys=true)
#end
#if(${tInfo.ColumnsName}=="islock")
#set($hasNeedislock=${tInfo.isNull})
#set($hasislock=true)
#end
#if(${tInfo.IsTree})
#set($hasTree=true)
#end
#if(${tInfo.ColumnsName}=="orgid")
#set($hasoOrg=true)
#end
#if(${tInfo.ColumnsName}=="state")
#set($hasstate=true)
#end
#end
#foreach($tInfo in $Columns)
#if(${tInfo.IsKey}==false)
#if((${GoTable.IsUser}==false||(${GoTable.IsUser}&&${tInfo.SelectType}=="search"))&&${tInfo.isNull}== false&&${tInfo.ColumnsName}!="id"&&${tInfo.ColumnsName}!="mark"&&${tInfo.ColumnsName}!="isenabled"&&${tInfo.ColumnsName}!="ord"&&${tInfo.ColumnsName}!="state"&&${tInfo.ColumnsName}!="updatetime"&&${tInfo.ColumnsName}!="updateuser"&&${tInfo.ColumnsName}!="viewnum"&&${tInfo.ColumnsName}!="owner"&&${tInfo.ColumnsName}!="createtime"&&${tInfo.ColumnsName}!="createuser"&&${tInfo.ColumnsType}!="timestamp"&&${tInfo.ColumnsName}!="password"&&${tInfo.SelectType}!="notexist"&&${tInfo.SelectType}!="FindMulit"&&${tInfo.SelectType}!="AccountBox"&&${tInfo.SelectType}!="SelectBox"&&${tInfo.SelectType}!="SelectControl"&&${tInfo.SelectType}!="TremBox"&&${tInfo.SelectType}!="InAccountBox"&&${tInfo.SelectType}!="InTremBox")
#if(${tInfo.ColumnsName}=="orgid")
#set($hastsOrg=true)
#end
#end
##为了锁定功能放开 每个模块必需要有不是这些除外的一个或多个必填字段
#if(${tInfo.isNull} == false&&${tInfo.ColumnsName}!="createuser"&&${tInfo.ColumnsName}!="password"&&${tInfo.ColumnsName}!="baseyearmonth"&&${tInfo.ColumnsType}!="timestamp"&&${tInfo.ColumnsName}!="fbase"&&${tInfo.ColumnsName}!="lastviewtime"&&${tInfo.ColumnsName}!="updatetime"&&${tInfo.ColumnsName}!="viewtime"&&${tInfo.ColumnsName}!="updateuser"&&${tInfo.ColumnsName}!="viewuser"&&${tInfo.ColumnsName}!="orgid"&&${tInfo.SelectType}!="FindMulit"&&${tInfo.SelectType}!="AccountBox"&&${tInfo.SelectType}!="SelectBox"&&${tInfo.SelectType}!="SelectControl"&&${tInfo.SelectType}!="TremBox"&&${tInfo.SelectType}!="InAccountBox"&&${tInfo.SelectType}!="InTremBox")
##
#if((${tInfo.ColumnsType}=="varchar"&&${tInfo.ColumnsLength}>50)||(${tInfo.ColumnsType}=="nvarchar"&&${tInfo.ColumnsLength}>50)||(${tInfo.ColumnsType}=="varchar"&&${tInfo.ColumnsLength}==-1)||(${tInfo.ColumnsType}=="nvarchar"&&${tInfo.ColumnsLength}==-1)||${tInfo.ColumnsType}=="ntext"||${tInfo.ColumnsType}=="text")
##
#elseif(${EnabledShowCreateTime}==false&&${tInfo.ColumnsName}=="createtime")
##
#elseif(${tInfo.ColumnsType}=="bit"||($tInfo.ColumnsName.StartsWith("is")&&${tInfo.ColumnsType}=="smallint"))
#set($defsqlcols="$defsqlcols$tInfo.ColumnsName,")
#elseif(${tInfo.ColumnsName}=="name"&&$hassort)
#set($defsqlcols="$defsqlcols$tInfo.ColumnsName,")
#else
#set ($hasfiled=0)
#foreach($rInfo in ${GoTable.RelRelationList})
#if($rInfo.CurrFiled==$tInfo.ColumnsName)
#set($hasfiled=1)
#set($relafiled="${rInfo.RelationTable}${rInfo.CurrFiled}")
#end
#end
#if($hasfiled==0)
#if(${tInfo.ColumnsName}=="owner")
#set($sqlcols="${sqlcols}${tInfo.ColumnsName},")
#else
#set($defsqlcols="$defsqlcols$tInfo.ColumnsName,")
#end
#else
#if(${GoTable.IsUser}&&(${tInfo.ColumnsName}=="uid"||${tInfo.ColumnsName}=="owner"))
#set($defsqlcols="${defsqlcols}${tInfo.ColumnsName},")
#end
#set($defsqlcols="$defsqlcols${tInfo.ColumnsName},")
#end
#end
#end
##
#end
#end
##非必填追加
#if($hasNeedenable)
#set($sqlcols="${sqlcols}isenabled,")
#end
##非必填追加
#if($hasNeedissys)
#set($sqlcols="${sqlcols}issys,")
#end
##非必填追加
#if($hasNeedislock)
#set($sqlcols="${sqlcols}islock,")
#end
##非必填追加
#if($hasNeedauth)
#set($sqlcols="${sqlcols}authstatus,")
#end
#if(${GoTable.IsUser}&&$hasNeeduid)
#set($sqlcols="${sqlcols}uid,")
#end
#if($defsqlcols.length()>0)
#set($end=$defsqlcols.length() - 1)
#set($defsqlcols=$defsqlcols.substring(0,$end))
#end
public override void OnLoad(HttpContext context)
{
##验证用户权限
#set($hasmodel=false)
#set($hasrole=false)
#set($hasright=false)
#foreach($tb in ${host})
#if(${tb.TableName}=="sysmodule")
#set($hasmodel=true)
#end
#if(${tb.TableName}=="sysrole")
#set($hasrole=true)
#end
#if(${tb.TableName}=="sysrights")
#set($hasright=true)
#end
#end
#if($hasmodel&&$hasrole&&$hasright)
//验证用户权限
//IsPowerOK("${Table}");
//IsPowerOK("${Table}",3);
#end
string action=string.Empty;
string msg = string.Empty;
if(!string.IsNullOrEmpty(RequestHelper.GetQueryString("action")))
{
action = RequestHelper.GetQueryString("action").ToString();
switch (action)
{
##交叉数据
#set($mtype="")
#set($mkey="")
#set($mtb="")
#set($rkey="")
#set($rtb="")
#set($skey="")
##commrelax中的子表属性
#set($lkey="")
#set($ltb="")
##commrelax中的子表属性
#set($sval="")
#set($sctrl="")
#set($stb="")
#foreach($tInfo in $Columns)
#if(${tInfo.IsKey}==false)
#if(${tInfo.ColumnsName}!="lanid"&&${tInfo.ColumnsName}!="viewnum"&&${tInfo.ColumnsName}!="setcode"&&${tInfo.ColumnsName}!="lastviewtime"&&${tInfo.ColumnsName}!="updatetime"&&${tInfo.ColumnsName}!="createtime"&&${tInfo.ColumnsName}!="istop"&&${tInfo.ColumnsName}!="issys"&&${tInfo.ColumnsName}!="state"&&${tInfo.ColumnsName}!="viewtime"&&${tInfo.ColumnsName}!="createuser"&&${tInfo.ColumnsName}!="updateuser"&&${tInfo.ColumnsName}!="viewuser"&&${tInfo.ColumnsName}!="ord"&&${tInfo.ColumnsName}!="owner"&&${tInfo.ColumnsName}!="sort"&&${tInfo.ColumnsName}!="islock"&&${tInfo.ColumnsName}!="enabled"&&${tInfo.ColumnsName}!="issys"&&${tInfo.ColumnsName}!="baseyearmonth"&&${tInfo.ColumnsName}!="importtag"&&${tInfo.SelectType}!="FindSingle"&&${tInfo.SelectType}!="FindMulit"&&${tInfo.SelectType}!="AccountBox"&&${tInfo.SelectType}!="SelectBox"&&${tInfo.SelectType}!="SelectControl"&&${tInfo.SelectType}!="TremBox"&&${tInfo.SelectType}!="InAccountBox"&&${tInfo.SelectType}!="InTremBox")
#if(${tInfo.SelectType}=="SelectBox")
case "DwMuti${tInfo.SelectItems}":
msg =DwMuti${tInfo.SelectItems}();
break;
case "DwNoMuti${tInfo.SelectItems}":
msg =DwNoMuti${tInfo.SelectItems}();
break;
#elseif(${tInfo.SelectType}=="Relax"||${tInfo.SelectType}=="relax")
#foreach($tb in ${host})
#if(${tb.TableName}==${tInfo.FromText})
#set($mkey="${tb.Key.ColumnsName}")
#set($mtb="${tb.TableName}")
#end
#if(${tb.TableName}==${tInfo.FromValue})
#set($rkey="${tb.Key.ColumnsName}")
#set($rtb="${tb.TableName}")
#end
#end
#if($mkey!=""&&$mtb!=""&&$rkey!=""&&$rtb!="")
case "${rtb}RelaxIndex":
msg =${rtb}RelaxIndex();
break;
case "${mtb}RelaxIndex":
msg =${mtb}RelaxIndex();
break;
#end
#elseif(${tInfo.relRelation})
case "Dw${tInfo.relRelation.RelationTable}${tInfo.ColumnsName}":
msg =Dw${tInfo.relRelation.RelationTable}${tInfo.ColumnsName}();
break;
##
#elseif(${tInfo.ColumnsName}=="fbase")
case "Dw${tInfo.ColumnsName}":
msg =Dw${tInfo.ColumnsName}();
break;
#elseif(${tInfo.ColumnsName}=="orgid")
case "Dwddlorgid":
msg =Dwddlorgid();
break;
#elseif(${tInfo.ColumnsName}=="commcategory")
case "RadioButtonList":
msg =RadioButtonList();
break;
#elseif(${tInfo.SelectType}=="AjaxDynamic")
##所属城市,所在区域
#elseif(${tInfo.SelectType}=="ProvinceCity"||${tInfo.SelectType}=="provincecity")
case "sel${tInfo.ColumnsName}Province":
msg =sel${tInfo.ColumnsName}Province();
break;
#elseif(${tInfo.FromType}=="table"&&(${tInfo.SelectType}=="Single"||${tInfo.SelectType}=="single"))
case "RadioButtonList${tInfo.ColumnsName}":
msg =RadioButtonList${tInfo.ColumnsName}();
break;
#elseif(${tInfo.FromType}=="table"&&(${tInfo.SelectType}=="Mulit"||${tInfo.SelectType}=="mulit"))
case "CheckBoxList${tInfo.ColumnsName}":
msg =CheckBoxList${tInfo.ColumnsName}();
break;
#elseif(${tInfo.SelectType}=="Mulit"||${tInfo.SelectType}=="mulit")
case "CheckBoxList${tInfo.ColumnsName}":
msg =CheckBoxList${tInfo.ColumnsName}();
break;
#elseif(${tInfo.SelectType}=="Single"||${tInfo.SelectType}=="single")
case "RadioButtonList${tInfo.ColumnsName}":
msg =RadioButtonList${tInfo.ColumnsName}();
break;
#elseif(${tInfo.SelectType}=="Relax"||${tInfo.SelectType}=="relax")
#if(${tInfo.SelectItems}=="0")
case "RadioButtonList${tInfo.ColumnsName}":
msg =RadioButtonList${tInfo.ColumnsName}();
break;
#else
case "CheckBoxList${tInfo.ColumnsName}":
msg =CheckBoxList${tInfo.ColumnsName}();
break;
#end
#elseif(${tInfo.SelectType}=="Comm"||${tInfo.SelectType}=="comm"||${tInfo.SelectType}=="CommRelax"||${tInfo.SelectType}=="commrelax")
case "RadioButtonList${tInfo.ColumnsName}":
msg =RadioButtonList${tInfo.ColumnsName}();
break;
case "CheckBoxList${tInfo.ColumnsName}":
msg =CheckBoxList${tInfo.ColumnsName}();
break;
#elseif(${tInfo.IsPassWord})
case "ReSetPassword${tInfo.ColumnsName}":
msg =ReSetPassword${tInfo.ColumnsName}();
break;
#end
#end
#end
#end
##
#if(${Table}=="City")
case "IndexCombox":
msg =IndexCombox();
break;
#end
#if($hasTree)
case "TreeIndex":
msg =TreeIndex();
break;
#end
case "btnExport":
btnExport();
break;
#foreach($currBtn in ${Buttons})
#if(${currBtn.Page}=="list")
case "${currBtn.ButtonId}":
msg =${currBtn.ButtonId}();
break;
#end
#end
#if($hasauth)
case "Auth":
msg =Auth();
break;
#end
#if($approvalfiled)
case "Approval":
msg =Approval();
break;
case "NoApproval":
msg =NoApproval();
break;
#end
case "FilterIndex":
msg =FilterIndex();
break;
case "Index":
msg =Index();
break;
#if($hasenable)
case "SetEnable":
msg =SetEnable();
break;
#end
case "Details":
msg =Details();
break;
case "Create":
msg =Create();
break;
//case "Edit":
// msg =Edit();
// break;
case "Delete":
msg =Delete();
break;
#if(${Table}=="sysaccounts")
case "Logout":
msg =Logout();
break;
case "Login":
msg =Login();
break;
case "getMenu":
msg =getMenu();
break;
#end
}
}
context.Response.ContentType = "application/json";
context.Response.Write(msg);
}
#if(${Table}=="sysaccounts")
private string getMenu()
{
string FatherMenu = string.Empty;
string ChiledMenu = string.Empty;
using (sysmenuBusiness CurrDAL = new sysmenuBusiness())
{
string strapps = string.Empty;
using (sysroleBusiness roleDAL = new sysroleBusiness())
{
sysroleObject currm = roleDAL.GetModel(_SessionContext.JsID);
if (currm != null)
{
strapps = currm.powerstr;
}
else
{
return string.Empty;
}
}
IList<sysmenuObject> rsmodlist = null;
sysmenuObject ConditionObject = new sysmenuObject();
ConditionObject.fbase = 1;
ConditionObject.Columns = "id,name,mark,fbase,tablename";
ConditionObject.OrderKey = "ord";
ConditionObject.OrderType = "desc";
IList<sysmenuObject> rslist = CurrDAL.PagedDataTable(ConditionObject);
if (rslist != null && rslist.Count > 0)
{
ConditionObject = new sysmenuObject();
ConditionObject.menutype = 2;
ConditionObject.Columns = "id,name,mark,fbase,tablename";
ConditionObject.OrderKey = "ord";
ConditionObject.OrderType = "desc";
rsmodlist = CurrDAL.PagedDataTable(ConditionObject);
foreach (sysmenuObject currmenu in rslist)
{
FatherMenu += "{id:'" + currmenu.id.ToString() + "',text:'" + currmenu.name.ToString() + "',iconCls:'icon-" + currmenu.id.ToString() + "',expanded:true";
if (currmenu != null && currmenu.id > 0)
{
IList<sysmenuObject> rsmodtemp = null;
sysmenuObject temp = null;
if (rsmodlist != null && rsmodlist.Count > 0)
{
rsmodtemp = new List<sysmenuObject>();
for (int j = 0; j < rsmodlist.Count; j++)
{
if (rsmodlist[j].fbase == currmenu.id)
{
temp = rsmodlist[j];
rsmodtemp.Add(temp);
}
}
if (rsmodtemp != null && rsmodtemp.Count > 0)
{
ChiledMenu = string.Empty;
foreach (sysmenuObject currmod in rsmodtemp)
{
if (currmenu.isexp == Convert.ToByte(1))
{
ChiledMenu += "{id:'" + currmod.tablename + "Menu',text:'" + currmod.name.ToString() + "',iconCls:'icon-" + currmod.id.ToString() + "',leaf:true},";
}
else
{
ChiledMenu += "{id:'" + currmod.tablename + "Menu',text:'" + currmod.name.ToString() + "',iconCls:'icon-" + currmod.id.ToString() + "',leaf:true},";
}
}
if (!string.IsNullOrEmpty(ChiledMenu))
{
ChiledMenu = ChiledMenu.TrimEnd(',');
FatherMenu += ",children:[" + ChiledMenu + ")";
}
}
}
}
FatherMenu += "},";
}
FatherMenu = FatherMenu.TrimEnd(',');
}
}
return "[" + FatherMenu + ",{id:'pwdMgr',text:'修改密码',iconCls:'icon-pwdMgr',leaf:true},{id:'sysExit',text:'退出系统',iconCls:'icon-sysExit',leaf:true}]";
}
private string Logout()
{
var todo = new ResultMessages();
todo.Result = true;
清空最后的错误
HttpContext.Current.Server.ClearError();
HttpContext.Current.Session.Abandon();
//**********************
FormsAuthentication.SignOut();
return Json(todo);
}
private string Login()
{
var todo = new ResultMessages();
using (sysaccountsBusiness CurrDAL = new sysaccountsBusiness())
{
string username = RequestHelper.GetFormString("username");
string password = RequestHelper.GetFormString("password");
username = PageValidate.filter(username, 50);
password = PageValidate.filter(password, 50);
//username = DEncrypt.Encrypt(username);
password = DEncrypt.Encrypt(password);
SessionFactory _Session = CurrDAL.GetSessionContext(username, password);
if (_Session != null && _Session.Userid != 0)
{
//初始化一个用户凭证的实例
FormsAuthenticationTicket MyTicket = new FormsAuthenticationTicket(1, "admin", DateTime.Now, DateTime.Now.AddMinutes(60), false, "admin");
string encryptedTicket = FormsAuthentication.Encrypt(MyTicket); //加密用户凭证
HttpContext.Current.Session["SessionContext"] = _Session;
//ToLog(1, "", "");
//把用户凭证存入Cookie
HttpCookie authCookie = new HttpCookie(FormsAuthentication.FormsCookieName, encryptedTicket);
//添加Cookie
HttpContext.Current.Response.Cookies.Add(authCookie);
//跳转默认重定向的默认 URL具体见Web.Config的配置
//Response.Redirect(FormsAuthentication.GetRedirectUrl("admin", false));
todo.Message = "登录成功!";
todo.Result = true;
}
else
{
todo.Message = "登录失败,请您检查用户名和密码是否正确!";
todo.Result = false;
}
}
return Json(todo);
}
#end
##交叉数据
#set($mtype="")
#set($mkey="")
#set($mtb="")
#set($rkey="")
#set($rtb="")
#set($skey="")
##commrelax中的子表属性
#set($lkey="")
#set($ltb="")
##commrelax中的子表属性
#set($sval="")
#set($sctrl="")
#set($stb="")
#foreach($tInfo in $Columns)
#if(${tInfo.IsKey}==false)
#if(${tInfo.ColumnsName}!="lanid"&&${tInfo.ColumnsName}!="viewnum"&&${tInfo.ColumnsName}!="setcode"&&${tInfo.ColumnsName}!="lastviewtime"&&${tInfo.ColumnsName}!="updatetime"&&${tInfo.ColumnsName}!="createtime"&&${tInfo.ColumnsName}!="istop"&&${tInfo.ColumnsName}!="issys"&&${tInfo.ColumnsName}!="state"&&${tInfo.ColumnsName}!="viewtime"&&${tInfo.ColumnsName}!="createuser"&&${tInfo.ColumnsName}!="updateuser"&&${tInfo.ColumnsName}!="viewuser"&&${tInfo.ColumnsName}!="ord"&&${tInfo.ColumnsName}!="owner"&&${tInfo.ColumnsName}!="sort"&&${tInfo.ColumnsName}!="islock"&&${tInfo.ColumnsName}!="enabled"&&${tInfo.ColumnsName}!="issys"&&${tInfo.ColumnsName}!="baseyearmonth"&&${tInfo.ColumnsName}!="importtag"&&${tInfo.SelectType}!="FindSingle"&&${tInfo.SelectType}!="FindMulit"&&${tInfo.SelectType}!="AccountBox"&&${tInfo.SelectType}!="SelectBox"&&${tInfo.SelectType}!="SelectControl"&&${tInfo.SelectType}!="TremBox"&&${tInfo.SelectType}!="InAccountBox"&&${tInfo.SelectType}!="InTremBox")
#if(${tInfo.SelectType}=="SelectBox")
private string DwMuti${tInfo.SelectItems}()
{
try
{
using (${tInfo.SelectItems}Business CurrDAL = new ${tInfo.SelectItems}Business())
{
string notinstr = RequestHelper.GetFormString("notinstr");
int currentPage = 1;
int currentSize = 20;
int PageCount = 0;
IList<${tInfo.SelectItems}Object> rslist = null;
${tInfo.SelectItems}Object ConditionObject=new ${tInfo.SelectItems}Object();
if (string.IsNullOrEmpty(notinstr))
{
ConditionObject.Columns ="${tInfo.FromText},${tInfo.FromValue}";
ConditionObject.PageSize = currentSize;
ConditionObject.PageIndex =currentPage;
ConditionObject.OrderKey = "${tInfo.FromText}";
ConditionObject.OrderType = "DESC";
rslist = CurrDAL.PagedDataTable(ConditionObject);
PageCount=CurrDAL.PagedTatolCount(ConditionObject);
}
else
{
ConditionObject.Columns ="${tInfo.FromText},${tInfo.FromValue}";
ConditionObject.PageSize = currentSize;
ConditionObject.PageIndex =currentPage;
ConditionObject.OrderKey = "${tInfo.FromText}";
ConditionObject.OrderType = "DESC";
ConditionObject.Condition = " ${tInfo.FromValue} not in (" + notinstr + ")";
rslist = CurrDAL.PagedDataTable(ConditionObject);
PageCount=CurrDAL.PagedTatolCount(ConditionObject);
}
return Json(new PageMessages2 { data = rslist, totalCount = PageCount });
}
}
catch(Exception err)
{
LogHelper.WriteLog("${tInfo.SelectItems} Index", err);
return "";
}
}
private string DwNoMuti${tInfo.SelectItems}(string instr)
{
try
{
using (${tInfo.SelectItems}Business CurrDAL = new ${tInfo.SelectItems}Business())
{
string instr = RequestHelper.GetFormString("instr");
int currentPage = 1;
int currentSize = 20;
int PageCount = 0;
IList<${tInfo.SelectItems}Object> rslist =null;
${tInfo.SelectItems}Object ConditionObject=new ${tInfo.SelectItems}Object();
if (!string.IsNullOrEmpty(instr))
{
ConditionObject.Columns ="${tInfo.FromText},${tInfo.FromValue}";
ConditionObject.PageSize = currentSize;
ConditionObject.PageIndex =currentPage;
ConditionObject.OrderKey = "${tInfo.FromText}";
ConditionObject.OrderType = "DESC";
ConditionObject.Condition = " ${tInfo.FromValue} in (" + notinstr + ")";
rslist = CurrDAL.PagedDataTable(ConditionObject);
PageCount=CurrDAL.PagedTatolCount(ConditionObject);
}
return Json(new PageMessages2 { data = rslist, totalCount = PageCount });
}
}
catch(Exception err)
{
LogHelper.WriteLog("${tInfo.SelectItems} Index", err);
return "";
}
}
#elseif(${tInfo.SelectType}=="Relax"||${tInfo.SelectType}=="relax")
#foreach($tb in ${host})
#if(${tb.TableName}==${tInfo.FromText})
#set($mkey="${tb.Key.ColumnsName}")
#set($mtb="${tb.TableName}")
#end
#if(${tb.TableName}==${tInfo.FromValue})
#set($rkey="${tb.Key.ColumnsName}")
#set($rtb="${tb.TableName}")
#end
#end
#if($mkey!=""&&$mtb!=""&&$rkey!=""&&$rtb!="")
private string ${rtb}RelaxIndex()
{
try
{
using (${rtb}Business CurrDAL = new ${rtb}Business())
{
int currentPage = 1;
int currentSize = 20;
int PageCount = 0;
${rtb}Object ConditionObject=new ${rtb}Object();
ConditionObject.Columns ="name,${rkey}";
ConditionObject.PageSize = currentSize;
ConditionObject.PageIndex =currentPage;
ConditionObject.OrderKey = "${rkey}";
ConditionObject.OrderType = "DESC";
IList<${rtb}Object> rslist = CurrDAL.PagedDataTable(ConditionObject);
PageCount=CurrDAL.PagedTatolCount(ConditionObject);
return Json(new PageMessages2 { data = rslist, totalCount = PageCount });
}
}
catch(Exception err)
{
LogHelper.WriteLog("${rtb} Index", err);
return "";
}
}
private string ${mtb}RelaxIndex()
{
try
{
using (${mtb}Business CurrDAL = new ${mtb}Business())
{
int currentPage = 1;
int currentSize = 20;
int PageCount = 0;
${mtb}Object ConditionObject=new ${mtb}Object();
ConditionObject.Columns ="name,${mkey}";
ConditionObject.PageSize = currentSize;
ConditionObject.PageIndex =currentPage;
ConditionObject.OrderKey = "${mkey}";
ConditionObject.OrderType = "DESC";
IList<${mtb}Object> rslist = CurrDAL.PagedDataTable(ConditionObject);
PageCount=CurrDAL.PagedTatolCount(ConditionObject);
return Json(new PageMessages2 { data = rslist, totalCount = PageCount });
}
}
catch(Exception err)
{
LogHelper.WriteLog("${mtb} Index", err);
return "";
}
}
#end
#elseif(${tInfo.IsPassWord})
private string ReSetPassword${tInfo.ColumnsName}()
{
var todo = new ResultMessages();
todo.Message = "重置密码失败";
todo.Result = false;
try
{
string ids= RequestHelper.GetFormString("ids");
using (${Table}Business CurrDAL = new ${Table}Business())
{
string newcode = System.Guid.NewGuid().ToString().Substring(0, 6);
${Table}Object UpdateObject = new ${Table}Object();
UpdateObject.idids = ids;
UpdateObject.password = DEncrypt.Encrypt(newcode);
todo.Message = "重置密码成功";
todo.Result = CurrDAL.Update(UpdateObject);
}
}
catch(Exception err)
{
LogHelper.WriteLog("${Table} ResetPasswrod", err);
return Json(todo);
}
return Json(todo);
}
#elseif(${tInfo.relRelation})
private string Dw${tInfo.relRelation.RelationTable}${tInfo.ColumnsName}()
{
try
{
using (${tInfo.relRelation.RelationTable}Business CurrDAL = new ${tInfo.relRelation.RelationTable}Business())
{
string q = RequestHelper.GetQueryString("q").Trim();
int currentPage = 1;
if (!string.IsNullOrEmpty(HttpContext.Current.Request["page"]))
{
currentPage = RequestHelper.GetQueryInt("page");
}
##检测是否存在name这个字段
#set($hassysdpt=false)
#set($hasrlenable=false)
#set($hasrelname=false)
#set($RHasTree=false)
#foreach($xrtb in ${host})
#if(${xrtb.TableName}==${tInfo.relRelation.RelationTable})
#set($hasrelname=false)
#set($RHasTree=false)
#foreach($xrbcurrInfo in ${xrtb.Cols})
#if(${xrbcurrInfo.ColumnsName}=="name")
#set($hasrelname=true)
#end
#if(${xrbcurrInfo.IsTree})
#set($RHasTree=true)
#end
#if(${xrbcurrInfo.ColumnsName}=="isenabled")
#set($hasrlenable=true)
#end
#if(${xrtb.TableName}!="sysdepartment"&&${xrtb.TableName}!="configfangan"&&${xrbcurrInfo.IsKey}==false&&${xrbcurrInfo.ColumnsName}=="dptid")
#set($hassysdpt=true)
#end
#end
#end
#end
##下拉选项
#if($RHasTree)
int currentSize = 20;
int PageCount = 0;
int level = 0;
string strEmpty = string.Empty;
${tInfo.relRelation.RelationTable}Object ConditionObject=new ${tInfo.relRelation.RelationTable}Object();
ConditionObject.Columns ="#if($hasrelname)name,#end${GoTable.Key.ColumnsName},len(sort)-len(replace(sort,',','')) as codelength,sort,sort+','+CONVERT(nvarchar,id) AS bpath";
ConditionObject.OrderType = "bpath";
ConditionObject.Condition = #if(${Table}=="sysorganize"&&${tInfo.relRelation.RelationTable}=="sysorganize")"id=" + _SessionContext.OrgID.ToString()#elseif($hasrole==true)"state=0 and (createuser=" + _SessionContext.Userid.ToString() + " or createuser in (SELECT [id] FROM [sysaccounts] where roleid in (SELECT [id] FROM [sysrole] where sort like ''+(SELECT [sort] FROM [sysrole] where id=" + _SessionContext.JsID.ToString() + ")+',%'))) and orgid=" + _SessionContext.OrgID.ToString() #else""#end +"#if($hasrlenable) AND isenabled=1#end#if($hassysdpt) AND dptid="+_SessionContext.StrustsID.ToString()+"#end#if(${tInfo.Condition}) AND ${tInfo.Condition} #end";
if (!string.IsNullOrEmpty(q))
{
ConditionObject.likename = q;
}
IList<${tInfo.relRelation.RelationTable}Object> rslist = CurrDAL.PagedDataTable(ConditionObject);
List<Select2Item> Items = new List<Select2Item>();
if (rslist != null && rslist.Count > 0)
{
Items.Add(new Select2Item("请进行选择", ""));
foreach (${tInfo.relRelation.RelationTable}Object temp in rslist)
{
if (temp.codelength.HasValue)
{
level = temp.codelength.Value;
}
else
{
level = 0;
}
strEmpty = "";
for (int i = 0; i < level; i++)
{
strEmpty += " ";
}
strEmpty += "├ ";
Items.Add(new Select2Item(strEmpty+temp.name, temp.${tInfo.relRelation.RelatFiled}.ToString()));
}
}
#else
int currentSize = 20;
int PageCount = 0;
${tInfo.relRelation.RelationTable}Object ConditionObject=new ${tInfo.relRelation.RelationTable}Object();
ConditionObject.Columns ="#if($hasrelname)name,#end${tInfo.relRelation.RelatFiled}";
ConditionObject.PageSize = currentSize;
ConditionObject.PageIndex =currentPage;
ConditionObject.Condition = #if(${Table}=="sysorganize"&&${tInfo.relRelation.RelationTable}=="sysorganize")"id=" + _SessionContext.OrgID.ToString()#elseif($hasrole==true)"state=0 and (createuser=" + _SessionContext.Userid.ToString() + " or createuser in (SELECT [id] FROM [sysaccounts] where roleid in (SELECT [id] FROM [sysrole] where sort like ''+(SELECT [sort] FROM [sysrole] where id=" + _SessionContext.JsID.ToString() + ")+',%'))) and orgid=" + _SessionContext.OrgID.ToString() #else""#end +"#if($hasrlenable) AND isenabled=1#end#if($hassysdpt) AND dptid="+_SessionContext.StrustsID.ToString()+"#end#if(${tInfo.Condition}) AND ${tInfo.Condition} #end";
ConditionObject.OrderKey = "${tInfo.relRelation.RelatFiled}";
ConditionObject.OrderType = "DESC";
if (!string.IsNullOrEmpty(q))
{
ConditionObject.${tInfo.relRelation.RelatFiled} = Convert.ToInt32(q);
}
IList<${tInfo.relRelation.RelationTable}Object> rslist = CurrDAL.PagedDataTable(ConditionObject);
List<Select2Item> Items = new List<Select2Item>();
if (rslist != null && rslist.Count > 0)
{
Items.Add(new Select2Item("请进行选择", ""));
foreach (${tInfo.relRelation.RelationTable}Object temp in rslist)
{
Items.Add(new Select2Item(temp.${tInfo.relRelation.RelatFiled}.ToString(), temp.${tInfo.relRelation.RelatFiled}.ToString()));
}
}
#end
##检测是否存在name这个字段
Select2 select2 = new Select2();
select2.items = Items;
select2.page = PageCount;
select2.page = CurrDAL.PagedTatolCount(ConditionObject);
return JsonConvert.SerializeObject(select2);
}
}
catch(Exception err)
{
LogHelper.WriteLog("${tInfo.relRelation.RelationTable} Index", err);
return "";
}
}
#if(${tInfo.relRelation.RelationTable}!="Products")
#set($detailstr=",string ${tInfo.relRelation.RelatFiled}")
#end
##
#elseif(${tInfo.ColumnsName}=="fbase")
private string Dw${tInfo.ColumnsName}()
{
try
{
using (${Table}Business CurrDAL = new ${Table}Business())
{
string q = RequestHelper.GetQueryString("q").Trim();
int currentPage = 1;
if (!string.IsNullOrEmpty(HttpContext.Current.Request["page"]))
{
currentPage = RequestHelper.GetQueryInt("page");
}
int currentSize = 20;
int PageCount = 0;
int level = 0;
string strEmpty = string.Empty;
${Table}Object ConditionObject=new ${Table}Object();
ConditionObject.Columns ="name,${GoTable.Key.ColumnsName},len(sort)-len(replace(sort,',','')) as codelength,sort,sort+','+CONVERT(nvarchar,id) AS bpath";
ConditionObject.OrderType = "bpath";
if (!string.IsNullOrEmpty(q))
{
ConditionObject.likename = q;
}
IList<${Table}Object> rslist = CurrDAL.PagedDataTable(ConditionObject);
List<Select2Item> Items = new List<Select2Item>();
if (rslist != null && rslist.Count > 0)
{
Items.Add(new Select2Item("请进行选择", ""));
foreach (${Table}Object temp in rslist)
{
if (temp.codelength.HasValue)
{
level = temp.codelength.Value;
}
else
{
level = 0;
}
strEmpty = "";
for (int i = 0; i < level; i++)
{
strEmpty += " ";
}
strEmpty += "├ ";
Items.Add(new Select2Item(strEmpty+temp.name, temp.${GoTable.Key.ColumnsName}.ToString()));
}
}
Select2 select2 = new Select2();
select2.items = Items;
select2.page = PageCount;
select2.page = CurrDAL.PagedTatolCount(ConditionObject);
return JsonConvert.SerializeObject(select2);
}
}
catch(Exception err)
{
LogHelper.WriteLog("${Table} Index", err);
return "";
}
}
#elseif(${tInfo.ColumnsName}=="orgid")
private string Dwddlorgid()
{
try
{
using (sysorganizeBusiness CurrDAL = new sysorganizeBusiness())
{
string q = RequestHelper.GetQueryString("q").Trim();
int currentPage = 1;
if (!string.IsNullOrEmpty(HttpContext.Current.Request["page"]))
{
currentPage = RequestHelper.GetQueryInt("page");
}
int PageCount = 0;
int level = 0;
string strEmpty = string.Empty;
sysorganizeObject ConditionObject=new sysorganizeObject();
ConditionObject.Columns ="name,id,len(sort)-len(replace(sort,',','')) as codelength,sort,sort+','+CONVERT(nvarchar,id) AS bpath";
ConditionObject.OrderType = "bpath";
if (!string.IsNullOrEmpty(q))
{
ConditionObject.likename = q;
}
IList<sysorganizeObject> rslist = CurrDAL.PagedDataTable(ConditionObject);
List<Select2Item> Items = new List<Select2Item>();
if (rslist != null && rslist.Count > 0)
{
Items.Add(new Select2Item("请进行选择", ""));
foreach (sysorganizeObject temp in rslist)
{
if (temp.codelength.HasValue)
{
level = temp.codelength.Value;
}
else
{
level = 0;
}
strEmpty = "";
for (int i = 0; i < level; i++)
{
strEmpty += " ";
}
strEmpty += "├ ";
Items.Add(new Select2Item(strEmpty+temp.name, temp.id.ToString()));
}
}
Select2 select2 = new Select2();
select2.items = Items;
select2.page = PageCount;
select2.page = CurrDAL.PagedTatolCount(ConditionObject);
return JsonConvert.SerializeObject(select2);
}
}
catch(Exception err)
{
LogHelper.WriteLog("${Table} Index", err);
return "";
}
}
#elseif(${tInfo.ColumnsName}=="commcategory")
private string RadioButtonList()
{
try
{
using (${tInfo.SelectItems}Business CurrDAL = new ${tInfo.SelectItems}Business())
{
string q = RequestHelper.GetQueryString("q").Trim();
int currentPage = 1;
if (!string.IsNullOrEmpty(HttpContext.Current.Request["page"]))
{
currentPage = RequestHelper.GetQueryInt("page");
}
int currentSize = 20;
int PageCount = 0;
${tInfo.SelectItems}Object ConditionObject=new ${tInfo.SelectItems}bject();
ConditionObject.Columns ="${tInfo.FromText},${tInfo.FromValue}";
ConditionObject.PageSize = currentSize;
ConditionObject.PageIndex =currentPage;
ConditionObject.OrderKey = "${tInfo.FromValue}";
ConditionObject.OrderType = "DESC";
if (!string.IsNullOrEmpty(q))
{
ConditionObject.likename = q;
}
IList<${tInfo.SelectItems}Object> rslist = CurrDAL.PagedDataTable(ConditionObject);
List<Select2Item> Items = new List<Select2Item>();
if (rslist != null && rslist.Count > 0)
{
foreach (${tInfo.SelectItems}Object temp in rslist)
{
Items.Add(new Select2Item(temp.name, temp.${tInfo.FromValue}.ToString()));
}
}
Select2 select2 = new Select2();
select2.items = Items;
select2.page = PageCount;
select2.page = CurrDAL.PagedTatolCount(ConditionObject);
return JsonConvert.SerializeObject(select2);
}
}
catch(Exception err)
{
LogHelper.WriteLog("${Table} Index", err);
return "";
}
}
#elseif(${tInfo.SelectType}=="AjaxDynamic")
##所属城市,所在区域
#elseif(${tInfo.SelectType}=="ProvinceCity"||${tInfo.SelectType}=="provincecity")
private string sel${tInfo.ColumnsName}Province()
{
try
{
using (syscityBusiness CurrDAL = new syscityBusiness())
{
string q = RequestHelper.GetQueryString("q").Trim();
int currentPage = 1;
if (!string.IsNullOrEmpty(HttpContext.Current.Request["page"]))
{
currentPage = RequestHelper.GetQueryInt("page");
}
int currentSize = 20;
int PageCount = 0;
syscityObject ConditionObject=new syscityObject();
ConditionObject.Columns ="name,id";
ConditionObject.PageSize = currentSize;
ConditionObject.PageIndex =currentPage;
ConditionObject.Condition ="#if(${tInfo.Condition}) ${tInfo.Condition} #end";
ConditionObject.OrderKey = "id";
ConditionObject.OrderType = "DESC";
if (!string.IsNullOrEmpty(q))
{
ConditionObject.likename = q;
}
IList<syscityObject> rslist = CurrDAL.PagedDataTable(ConditionObject);
List<Select2Item> Items = new List<Select2Item>();
if (rslist != null && rslist.Count > 0)
{
foreach (syscityObject temp in rslist)
{
Items.Add(new Select2Item(temp.name, temp.id.ToString()));
}
}
Select2 select2 = new Select2();
select2.items = Items;
select2.page = PageCount;
select2.page = CurrDAL.PagedTatolCount(ConditionObject);
return JsonConvert.SerializeObject(select2);
}
}
catch(Exception err)
{
LogHelper.WriteLog("${Table} Index", err);
return "";
}
}
#elseif(${tInfo.FromType}=="table"&&(${tInfo.SelectType}=="Single"||${tInfo.SelectType}=="single"))
private string RadioButtonList${tInfo.ColumnsName}()
{
try
{
using (${tInfo.SelectItems}Business CurrDAL = new ${tInfo.SelectItems}Business())
{
string q = RequestHelper.GetQueryString("q").Trim();
int currentPage = 1;
if (!string.IsNullOrEmpty(HttpContext.Current.Request["page"]))
{
currentPage = RequestHelper.GetQueryInt("page");
}
int currentSize = 20;
int PageCount = 0;
${tInfo.SelectItems}Object ConditionObject=new ${tInfo.SelectItems}Object();
ConditionObject.Columns ="${tInfo.FromText},${tInfo.FromValue}";
ConditionObject.PageSize = currentSize;
ConditionObject.PageIndex =currentPage;
ConditionObject.OrderKey = "${tInfo.FromValue}";
ConditionObject.OrderType = "DESC";
if (!string.IsNullOrEmpty(q))
{
ConditionObject.likename = q;
}
IList<${tInfo.SelectItems}Object> rslist = CurrDAL.PagedDataTable(ConditionObject);
List<Select2Item> Items = new List<Select2Item>();
if (rslist != null && rslist.Count > 0)
{
foreach (${tInfo.SelectItems}Object temp in rslist)
{
Items.Add(new Select2Item(temp.name, temp.${tInfo.FromValue}.ToString()));
}
}
Select2 select2 = new Select2();
select2.items = Items;
select2.page = PageCount;
select2.page = CurrDAL.PagedTatolCount(ConditionObject);
return JsonConvert.SerializeObject(select2);
}
}
catch(Exception err)
{
LogHelper.WriteLog("${Table} Index", err);
return "";
}
}
#elseif(${tInfo.FromType}=="table"&&(${tInfo.SelectType}=="Mulit"||${tInfo.SelectType}=="mulit"))
private string CheckBoxList${tInfo.ColumnsName}()
{
try
{
using (${tInfo.SelectItems}Business CurrDAL = new ${tInfo.SelectItems}Business())
{
string q = RequestHelper.GetQueryString("q").Trim();
int currentPage = 1;
if (!string.IsNullOrEmpty(HttpContext.Current.Request["page"]))
{
currentPage = RequestHelper.GetQueryInt("page");
}
int currentSize = 20;
int PageCount = 0;
${tInfo.SelectItems}Object ConditionObject=new ${tInfo.SelectItems}Object();
ConditionObject.Columns ="${tInfo.FromText},${tInfo.FromValue}";
ConditionObject.PageSize = currentSize;
ConditionObject.PageIndex =currentPage;
ConditionObject.OrderKey = "${tInfo.FromValue}";
ConditionObject.OrderType = "DESC";
if (!string.IsNullOrEmpty(q))
{
ConditionObject.likename = q;
}
IList<${tInfo.SelectItems}Object> rslist = CurrDAL.PagedDataTable(ConditionObject);
List<Select2Item> Items = new List<Select2Item>();
if (rslist != null && rslist.Count > 0)
{
foreach (${tInfo.SelectItems}Object temp in rslist)
{
Items.Add(new Select2Item(temp.name, temp.${tInfo.FromValue}.ToString()));
}
}
Select2 select2 = new Select2();
select2.items = Items;
select2.page = PageCount;
select2.page = CurrDAL.PagedTatolCount(ConditionObject);
return JsonConvert.SerializeObject(select2);
}
}
catch(Exception err)
{
LogHelper.WriteLog("${Table} Index", err);
return "";
}
}
#elseif(${tInfo.SelectType}=="Mulit"||${tInfo.SelectType}=="mulit")
private string CheckBoxList${tInfo.ColumnsName}()
{
try
{
string CheckBoxList${tInfo.ColumnsName}Str="${tInfo.SelectItems}";
string[] itemarr = CheckBoxList${tInfo.ColumnsName}Str.Split(',');
int itemlength = itemarr.Length;
List<Select2Item> Items = new List<Select2Item>();
if (itemarr != null && itemarr.Length > 0)
{
int stepindex = 0;
foreach (string temp in itemarr)
{
Items.Add(new Select2Item(temp.Trim(), stepindex.ToString()));
stepindex++;
}
}
Select2 select2 = new Select2();
select2.items = Items;
select2.page = itemlength;
return JsonConvert.SerializeObject(select2);
}
catch(Exception err)
{
LogHelper.WriteLog("${Table} Index", err);
return "";
}
}
#elseif(${tInfo.SelectType}=="Single"||${tInfo.SelectType}=="single")
private string RadioButtonList${tInfo.ColumnsName}()
{
try
{
string RadioButtonList${tInfo.ColumnsName}Str="${tInfo.SelectItems}";
string[] itemarr = RadioButtonList${tInfo.ColumnsName}Str.Split(',');
int itemlength = itemarr.Length;
List<Select2Item> Items = new List<Select2Item>();
if (itemarr != null && itemarr.Length > 0)
{
int stepindex = 0;
foreach (string temp in itemarr)
{
Items.Add(new Select2Item(temp.Trim(), stepindex.ToString()));
stepindex++;
}
}
Select2 select2 = new Select2();
select2.items = Items;
select2.page = itemlength;
return JsonConvert.SerializeObject(select2);
}
catch(Exception err)
{
LogHelper.WriteLog("${Table} Index", err);
return "";
}
}
#elseif(${tInfo.SelectType}=="Relax"||${tInfo.SelectType}=="relax")
#if(${tInfo.SelectItems}=="0")
private string RadioButtonList${tInfo.ColumnsName}()
{
try
{
using (${tInfo.SelectItems}Business CurrDAL = new ${tInfo.SelectItems}Business())
{
string q = RequestHelper.GetQueryString("q").Trim();
int currentPage = 1;
if (!string.IsNullOrEmpty(HttpContext.Current.Request["page"]))
{
currentPage = RequestHelper.GetQueryInt("page");
}
int currentSize = 20;
int PageCount = 0;
${tInfo.SelectItems}Object ConditionObject=new ${tInfo.SelectItems}Object();
ConditionObject.Columns ="name,${GoTable.Key.ColumnsName}";
ConditionObject.PageSize = currentSize;
ConditionObject.PageIndex =currentPage;
ConditionObject.OrderKey = "${GoTable.Key.ColumnsName}";
ConditionObject.OrderType = "DESC";
if (!string.IsNullOrEmpty(q))
{
ConditionObject.likename = q;
}
IList<${tInfo.SelectItems}Object> rslist = CurrDAL.PagedDataTable(ConditionObject);
List<Select2Item> Items = new List<Select2Item>();
if (rslist != null && rslist.Count > 0)
{
foreach (${tInfo.SelectItems}Object temp in rslist)
{
Items.Add(new Select2Item(temp.name, temp.${GoTable.Key.ColumnsName}.ToString()));
}
}
Select2 select2 = new Select2();
select2.items = Items;
select2.page = PageCount;
select2.page = CurrDAL.PagedTatolCount(ConditionObject);
return JsonConvert.SerializeObject(select2);
}
}
catch(Exception err)
{
LogHelper.WriteLog("${Table} Index", err);
return "";
}
}
#else
private string CheckBoxList${tInfo.ColumnsName}()
{
try
{
using (${tInfo.SelectItems}Business CurrDAL = new ${tInfo.SelectItems}Business())
{
string q = RequestHelper.GetQueryString("q").Trim();
int currentPage = 1;
if (!string.IsNullOrEmpty(HttpContext.Current.Request["page"]))
{
currentPage = RequestHelper.GetQueryInt("page");
}
int currentSize = 20;
int PageCount = 0;
${tInfo.SelectItems}Object ConditionObject=new ${tInfo.SelectItems}Object();
ConditionObject.Columns ="name,${GoTable.Key.ColumnsName}";
ConditionObject.PageSize = currentSize;
ConditionObject.PageIndex =currentPage;
ConditionObject.OrderKey = "${GoTable.Key.ColumnsName}";
ConditionObject.OrderType = "DESC";
if (!string.IsNullOrEmpty(q))
{
ConditionObject.likename = q;
}
IList<${tInfo.SelectItems}Object> rslist = CurrDAL.PagedDataTable(ConditionObject);
List<Select2Item> Items = new List<Select2Item>();
if (rslist != null && rslist.Count > 0)
{
foreach (${Table}Object temp in rslist)
{
Items.Add(new Select2Item(temp.name, temp.${GoTable.Key.ColumnsName}.ToString()));
}
}
Select2 select2 = new Select2();
select2.items = Items;
select2.page = PageCount;
select2.page = CurrDAL.PagedTatolCount(ConditionObject);
return JsonConvert.SerializeObject(select2);
}
}
catch(Exception err)
{
LogHelper.WriteLog("${Table} Index", err);
return "";
}
}
#end
#elseif(${tInfo.SelectType}=="Comm"||${tInfo.SelectType}=="comm"||${tInfo.SelectType}=="CommRelax"||${tInfo.SelectType}=="commrelax")
private string RadioButtonList${tInfo.ColumnsName}()
{
try
{
using (${tInfo.SelectItems}Business CurrDAL = new ${tInfo.SelectItems}Business())
{
string q = RequestHelper.GetQueryString("q").Trim();
int currentPage = 1;
if (!string.IsNullOrEmpty(HttpContext.Current.Request["page"]))
{
currentPage = RequestHelper.GetQueryInt("page");
}
int currentSize = 20;
int PageCount = 0;
${tInfo.SelectItems}Object ConditionObject=new ${tInfo.SelectItems}Object();
ConditionObject.Columns ="name,${GoTable.Key.ColumnsName}";
ConditionObject.PageSize = currentSize;
ConditionObject.PageIndex =currentPage;
ConditionObject.OrderKey = "${GoTable.Key.ColumnsName}";
ConditionObject.OrderType = "DESC";
if (!string.IsNullOrEmpty(q))
{
ConditionObject.likename = q;
}
IList<${tInfo.SelectItems}Object> rslist = CurrDAL.PagedDataTable(ConditionObject);
List<Select2Item> Items = new List<Select2Item>();
if (rslist != null && rslist.Count > 0)
{
foreach (${tInfo.SelectItems}Object temp in rslist)
{
Items.Add(new Select2Item(temp.name, temp.${GoTable.Key.ColumnsName}.ToString()));
}
}
Select2 select2 = new Select2();
select2.items = Items;
select2.page = PageCount;
select2.page = CurrDAL.PagedTatolCount(ConditionObject);
return JsonConvert.SerializeObject(select2);
}
}
catch(Exception err)
{
LogHelper.WriteLog("${Table} Index", err);
return "";
}
}
private string CheckBoxList${tInfo.ColumnsName}()
{
try
{
using (${tInfo.SelectItems}Business CurrDAL = new ${tInfo.SelectItems}Business())
{
string q = RequestHelper.GetQueryString("q").Trim();
int currentPage = 1;
if (!string.IsNullOrEmpty(HttpContext.Current.Request["page"]))
{
currentPage = RequestHelper.GetQueryInt("page");
}
int currentSize = 20;
int PageCount = 0;
${tInfo.SelectItems}Object ConditionObject=new ${tInfo.SelectItems}Object();
ConditionObject.Columns ="name,${GoTable.Key.ColumnsName}";
ConditionObject.PageSize = currentSize;
ConditionObject.PageIndex =currentPage;
ConditionObject.OrderKey = "${GoTable.Key.ColumnsName}";
ConditionObject.OrderType = "DESC";
if (!string.IsNullOrEmpty(q))
{
ConditionObject.likename = q;
}
IList<${tInfo.SelectItems}Object> rslist = CurrDAL.PagedDataTable(ConditionObject);
List<Select2Item> Items = new List<Select2Item>();
if (rslist != null && rslist.Count > 0)
{
foreach (${tInfo.SelectItems}Object temp in rslist)
{
Items.Add(new Select2Item(temp.name, temp.${GoTable.Key.ColumnsName}.ToString()));
}
}
Select2 select2 = new Select2();
select2.items = Items;
select2.page = PageCount;
select2.page = CurrDAL.PagedTatolCount(ConditionObject);
return JsonConvert.SerializeObject(select2);
}
}
catch(Exception err)
{
LogHelper.WriteLog("${Table} Index", err);
return "";
}
}
#end
#end
#end
#end
##
#set($childstr="")
##子表
#if(${GoTable.TableName}=="Orders")
#foreach($tRel in ${GoTable.ChildRelationList})
#foreach($tb in ${host})
#if(${tb.TableName}!="Accounts"&&${tb.TableName}!="RoleRight")
#if(${tb.TableName}==${tRel.CurrentTable})
#set($childstr="${childstr},string rec${tb.TableName}json")
#end
#end
#end
#end
#end
##子表
#if(${Table}=="City")
private string IndexCombox()
{
try
{
string query = RequestHelper.GetFormString("query");
using (${Table}Business CurrDAL = new ${Table}Business())
{
StringBuilder strWhere = new StringBuilder();
if (!string.IsNullOrEmpty(query))
{
//#warning 代码生成警告:请修改 keywordField 为需要匹配查询的真实字段名称
strWhere.AppendFormat(" AND fbase={0} ", PageValidate.filter(query.Trim(), 50));
}
int currentPage = 1;
int currentSize = 100;
int PageCount = 0;
${Table}Object ConditionObject=new ${Table}Object();
ConditionObject.Columns ="$sqlcols${GoTable.Key.ColumnsName}";
ConditionObject.PageSize = currentSize;
ConditionObject.PageIndex =currentPage;
ConditionObject.OrderKey = "${GoTable.Key.ColumnsName}";
ConditionObject.OrderType = "DESC";
IList<${Table}Object> rslist = CurrDAL.PagedDataTable(ConditionObject);
PageCount=CurrDAL.PagedTatolCount(ConditionObject);
return Json(new PageMessages2 { data = rslist, totalCount = PageCount });
}
}
catch(Exception err)
{
LogHelper.WriteLog("${Table} IndexCombox", err);
return "";
}
}
#end
private void btnExport()
{
string currfiledstr = "${currfiledstr}";
string currfileddes = "${currfileddes}";
if (!string.IsNullOrEmpty(currfiledstr))
{
currfiledstr = currfiledstr.TrimEnd(',');
${Table}Object ConditionObject = CurrGetWhereStr();
ConditionObject.Columns = currfiledstr;
ConditionObject.OrderKey = "${GoTable.Key.ColumnsName}";
ConditionObject.OrderType = "DESC";
DataTable Dt = new ${Table}Business().ExportPagedDataTable(ConditionObject);
#if($HasRelation)
if (Dt != null && Dt.Rows.Count > 0)
{
foreach (DataRow dr in Dt.Rows)
{
#foreach($tInfo in $Columns)
#if(${tInfo.ColumnsName}!="createuser"&&${tInfo.ColumnsName}!="orgid"&&${tInfo.ColumnsType}!="timestamp"&&${tInfo.SelectType}!="notexist")
#if(${tInfo.relRelation})
dr["${tInfo.ColumnsName}"] = Goblingcs.GetRealtionValue("${tInfo.relRelation.RelationTable}", "id=" + dr["${tInfo.ColumnsName}"].ToString(), "name");
#end
#end
#end
}
}
#end
ExcelHelper excel = new ExcelHelper();
excel.OutDataExcel(Dt, currfileddes,"${GoTable.TableDes}");
}
}
#foreach($currBtn in ${Buttons})
#if(${currBtn.Page}=="list")
private string ${currBtn.ButtonId}()
{
var todo = new ResultMessages();
todo.Message = "删除失败";
todo.Result = false;
try
{
}
catch(Exception err)
{
LogHelper.WriteLog("${Table} Delete", err);
return Json(todo);
}
return Json(todo);
}
#end
#end
#if($hasauth)
private string Auth()
{
var todo = new ResultMessages();
todo.Message = "确认失败";
todo.Result = false;
try
{
string ids = RequestHelper.GetFormString("ids");
using (${Table}Business CurrDAL = new ${Table}Business())
{
${Table}Object UpdateObject = new ${Table}Object();
UpdateObject.${GoTable.Key.ColumnsName}ids = ids;
UpdateObject.auth = Convert.ToByte(1);
todo.Message = "确认成功";
todo.Result = CurrDAL.Update(UpdateObject);
}
}
catch(Exception err)
{
LogHelper.WriteLog("${Table} Delete", err);
return Json(todo);
}
return Json(todo);
}
#end
#if($approvalfiled)
private string Approval()
{
var todo = new ResultMessages();
todo.Message = "审核失败";
todo.Result = false;
try
{
string ids = RequestHelper.GetFormString("ids");
using (${Table}Business CurrDAL = new ${Table}Business())
{
${Table}Object UpdateObject = new ${Table}Object();
UpdateObject.${GoTable.Key.ColumnsName}ids = ids;
UpdateObject.isapproval = Convert.ToByte(1);
todo.Message = "审核成功";
todo.Result = CurrDAL.Update(UpdateObject);
}
}
catch(Exception err)
{
LogHelper.WriteLog("${Table} Delete", err);
return Json(todo);
}
return Json(todo);
}
private string NoApproval()
{
var todo = new ResultMessages();
todo.Message = "拒绝失败";
todo.Result = false;
try
{
string ids = RequestHelper.GetFormString("ids");
using (${Table}Business CurrDAL = new ${Table}Business())
{
${Table}Object UpdateObject = new ${Table}Object();
UpdateObject.${GoTable.Key.ColumnsName}ids = ids;
UpdateObject.isapproval = Convert.ToByte(0);
todo.Message = "拒绝成功";
todo.Result = CurrDAL.Update(UpdateObject);
}
}
catch(Exception err)
{
LogHelper.WriteLog("${Table} Delete", err);
return Json(todo);
}
return Json(todo);
}
#end
#if($hasTree)
private string TreeIndex()
{
try
{
string id =RequestHelper.GetFormString("id");
using (${Table}Business CurrDAL = new ${Table}Business())
{
if (string.IsNullOrEmpty(id) || "root".Equals(id))
{
id = "0";
}
${Table}Object ConditionObject = new ${Table}Object();
#if($hasoOrg)
ConditionObject.orgid =_SessionContext.OrgID;
#end
ConditionObject.Columns = "${GoTable.Key.ColumnsName},name,fbase,sort";
DataTable dataSource = DataTableHelper.ToDataTable<${Table}Object>(CurrDAL.PagedDataTable(ConditionObject));
if (dataSource != null && dataSource.Rows.Count > 0)
{
string ss = "[" + TreeViewRecursive(dataSource, int.Parse(id)) + ")";
return ss;
}
}
}
catch (Exception err)
{
LogHelper.WriteLog("${Table} Index", err);
return string.Empty;
}
return string.Empty;
}
private string TreeViewRecursive(DataTable dataSource, int fbase)
{
StringBuilder sb = new StringBuilder();
string str = "";
string fliter = String.Format("fbase={0}", fbase);
// 查询子节点
DataRow[] drArr = dataSource.Select(fliter);
if (drArr == null || drArr.Length < 1)
{
sb.Append("");
}
else
{
foreach (DataRow dr in drArr)
{
bool haveChildren = true;
string chs = "false";
string flitersec = String.Format("fbase={0}", dr["${GoTable.Key.ColumnsName}"].ToString());
DataRow[] drArrChiled = dataSource.Select(flitersec);
if (drArrChiled == null || drArrChiled.Length < 1)
{
chs = "true";
haveChildren = false;
}
if (!haveChildren)
{
sb.Append("{\"children\":[],\"id\":" + dr["${GoTable.Key.ColumnsName}"].ToString() + ",\"leaf\":" + chs + ",\"text\":\"" + dr["name"].ToString().Trim() + "\",\"sort\":\"" + dr["sort"].ToString().Trim() + "\"},");//有子节点
}
else
{
// 递归创建子节点
sb.Append("{\"children\":[" + TreeViewRecursive(dataSource, Convert.ToInt32(dr["${GoTable.Key.ColumnsName}"])) + "),\"id\":" + dr["${GoTable.Key.ColumnsName}"].ToString() + ",\"leaf\":" + chs + ",\"text\":\"" + dr["name"].ToString().Trim() + "\",\"sort\":\"" + dr["sort"].ToString().Trim() + "\"},");//有子节点
}
// 移除已添加行,提高性能
dataSource.Rows.Remove(dr);
}
str = sb.ToString();
if (str.EndsWith(","))
{
str = str.Substring(0, str.Length - 1);
}
}
return str;
}
#end
private string FilterIndex()
{
try
{
int start = 1;
int limit = 25;
if(!string.IsNullOrEmpty(RequestHelper.GetQueryString("start")))
{
start =int.Parse(RequestHelper.GetQueryString("start"));
}
if (start != 0)
{
start = start / limit + 1;
}
else
{
start = 1;
}
using (${Table}Business CurrDAL = new ${Table}Business())
{
${Table}Object ConditionObject = CurrGetWhereStr();
int PageCount = 0;
ConditionObject.Columns ="$sqlcols${GoTable.Key.ColumnsName}";
ConditionObject.PageSize = limit;
ConditionObject.PageIndex =start;
ConditionObject.OrderKey = "${GoTable.Key.ColumnsName}";
ConditionObject.OrderType = "DESC";
IList<${Table}Object> rslist = CurrDAL.PagedDataTable(ConditionObject);
rslist = ConvertValue(rslist);
PageCount=CurrDAL.PagedTatolCount(ConditionObject);
return Json(new PageMessages3 { draw = 1, recordsTotal = PageCount, recordsFiltered = 25, data = rslist });
}
}
catch(Exception err)
{
LogHelper.WriteLog("${Table} Index", err);
return "";
}
}
private string Index()
{
try
{
int start = 1;
int limit = 25;
if(!string.IsNullOrEmpty(RequestHelper.GetQueryString("start")))
{
start =int.Parse(RequestHelper.GetQueryString("start"));
}
if (start != 0)
{
start = start / limit + 1;
}
else
{
start = 1;
}
using (${Table}Business CurrDAL = new ${Table}Business())
{
${Table}Object ConditionObject = CurrGetWhereStr();
int PageCount = 0;
#if($hasTree)
ConditionObject.Columns = "${defsqlcols}#if($defsqlcols.length()>0),#end${sqlcols}${GoTable.Key.ColumnsName},len(sort)-len(replace(sort,',','')) as codelength,sort,sort+','+CONVERT(nvarchar,${GoTable.Key.ColumnsName}) AS bpath";
ConditionObject.OrderType = "bpath";
#else
ConditionObject.Columns ="${defsqlcols}#if($defsqlcols.length()>0),#end$sqlcols${GoTable.Key.ColumnsName}";
ConditionObject.PageSize = limit;
ConditionObject.PageIndex =start;
ConditionObject.OrderKey = "${GoTable.Key.ColumnsName}";
ConditionObject.OrderType = "DESC";
#end
IList<${Table}Object> rslist = CurrDAL.PagedDataTable(ConditionObject);
rslist = ConvertValue(rslist);
PageCount=CurrDAL.PagedTatolCount(ConditionObject);
return Json(new PageMessages3 { draw = 1, recordsTotal = PageCount, recordsFiltered = 25, data = rslist });
}
}
catch(Exception err)
{
LogHelper.WriteLog("${Table} Index", err);
return "";
}
}
public IList<${Table}Object> ConvertValue(IList<${Table}Object> rslist)
{
if(rslist!=null)
{
#set($hasConvertValue=0)
#foreach($tInfo in $Columns)
#if(${tInfo.SelectType}!="notexist")
#foreach($rInfo in ${GoTable.RelRelationList})
#if($rInfo.CurrFiled==$tInfo.ColumnsName)
#set($hasConvertValue=1)
#end
#end
#end
#end
#if($hasConvertValue==1)
foreach(${Table}Object item in rslist)
{
#foreach($tInfo in $Columns)
#if(${tInfo.SelectType}!="notexist")
#foreach($rInfo in ${GoTable.RelRelationList})
#if($rInfo.CurrFiled==$tInfo.ColumnsName)
if (item.${tInfo.ColumnsName} != null)
{
item.${rInfo.RelationTable}${rInfo.CurrFiled}=Goblingcs.GetRealtionValue("${tInfo.relRelation.RelationTable}", "${tInfo.relRelation.RelatFiled}="+item.${tInfo.ColumnsName}.Value.ToString(), "name");
}
#end
#end
#end
#end
}
#end
}
return rslist;
}
#if($hasenable)
private string SetEnable()
{
string ids = RequestHelper.GetFormString("ids");
var todo = new ResultMessages();
todo.Message = "禁用/启用失败";
todo.Result = false;
try
{
//using (${Table}Business CurrDAL = new ${Table}Business())
//{
// CurrDAL.Update("enabled = enabled^1", "and ${GoTable.Key.ColumnsName} IN (" + ids.ToString()+")");
// todo.Message = "禁用/启用成功";
// todo.Result = true;
//}
}
catch(Exception err)
{
LogHelper.WriteLog("${Table} SetEnable", err);
return Json(todo);
}
return Json(todo);
}
#end
private string Details()
{
var todo = new ResultMessages();
todo.Message = "显示失败";
todo.Result = false;
try
{
int id = 0;
if(!string.IsNullOrEmpty(RequestHelper.GetFormString("id")))
{
id =int.Parse(RequestHelper.GetFormString("id"));
}
using (${Table}Business CurrDAL = new ${Table}Business())
{
${Table}Object model = CurrDAL.GetModel(id);
if (model != null)
{
#foreach($tInfo in $Columns)
#if(${tInfo.IsKey}==false)
#if(${tInfo.ColumnsName}!="lanid"&&${tInfo.ColumnsName}!="viewnum"&&${tInfo.ColumnsName}!="setcode"&&${tInfo.ColumnsName}!="lastviewtime"&&${tInfo.ColumnsName}!="updatetime"&&${tInfo.ColumnsName}!="createtime"&&${tInfo.ColumnsName}!="istop"&&${tInfo.ColumnsName}!="issys"&&${tInfo.ColumnsName}!="state"&&${tInfo.ColumnsName}!="viewtime"&&${tInfo.ColumnsName}!="createuser"&&${tInfo.ColumnsName}!="updateuser"&&${tInfo.ColumnsName}!="viewuser"&&${tInfo.ColumnsName}!="ord"&&${tInfo.ColumnsName}!="owner"&&${tInfo.ColumnsName}!="orgid"&&${tInfo.ColumnsName}!="fbase"&&${tInfo.ColumnsName}!="sort"&&${tInfo.ColumnsName}!="islock"&&${tInfo.ColumnsName}!="enabled"&&${tInfo.ColumnsName}!="issys"&&${tInfo.ColumnsName}!="baseyearmonth"&&${tInfo.ColumnsName}!="importtag"&&${tInfo.SelectType}!="FindSingle"&&${tInfo.SelectType}!="FindMulit"&&${tInfo.SelectType}!="AccountBox"&&${tInfo.SelectType}!="SelectBox"&&${tInfo.SelectType}!="SelectControl"&&${tInfo.SelectType}!="TremBox"&&${tInfo.SelectType}!="InAccountBox"&&${tInfo.SelectType}!="InTremBox")
#if(${tInfo.ColumnsType}=="timestamp")
model.hidden${tInfo.ColumnsName} = PageValidate.SetTimetamp(model.${tInfo.ColumnsName});
##文本区
#elseif((${tInfo.ColumnsType}=="varchar"&&${tInfo.ColumnsLength}==-1)||(${tInfo.ColumnsType}=="nvarchar"&&${tInfo.ColumnsLength}==-1))
model.${tInfo.ColumnsName}=PageValidate.filter(model.${tInfo.ColumnsName},1000);
##下拉列表 关联选项
#elseif(${tInfo.RelRelation})
model.${tInfo.relRelation.RelationTable}${tInfo.relRelation.CurrFiled}=Goblingcs.GetRealtionValue("${tInfo.relRelation.RelationTable}", "${tInfo.relRelation.RelatFiled}="+model.${tInfo.ColumnsName}.Value.ToString(), "name");
#elseif(${tInfo.ColumnsType}=="char"||${tInfo.ColumnsType}=="nchar")
model.${tInfo.ColumnsName}=model.${tInfo.ColumnsName}.Trim();
#end
#end
#end
#end
todo.Data = model;
todo.Message = "显示成功";
todo.Result = true;
}
}
}
catch(Exception err)
{
LogHelper.WriteLog("${Table} Details", err);
return Json(todo);
}
return Json(todo);
}
private string Create()
{
var todo = new ResultMessages();
todo.Message = "新建失败";
todo.Result = false;
bool Flag =false;
string strErr="";
try
{
int DataID = RequestHelper.GetQueryInt("id");
Int32 Userid = _SessionContext.Userid;
#foreach($tInfo in $Columns)
#if(${tInfo.IsKey}==false||(${tInfo.IsKey}&&${tInfo.relRelation}))
#if(${tInfo.ColumnsName}!="owner"&&${tInfo.ColumnsName}!="sort"&&${tInfo.ColumnsName}!="orgid"&&${tInfo.ColumnsName}!="createtime"&&${tInfo.ColumnsName}!="createuser")
#if(${tInfo.ColumnsName}=="updatetime")
#elseif(${tInfo.ColumnsName}=="lastviewtime")
#elseif(${tInfo.ColumnsName}=="viewtime")
#elseif(${tInfo.ColumnsName}=="updateuser")
#elseif(${tInfo.ColumnsName}=="viewuser")
#elseif(${tInfo.ColumnsName}=="lastlogintime")
#elseif(${tInfo.ColumnsName}=="lastloginip")
#elseif(${tInfo.ColumnsName}=="state")
#elseif(${tInfo.ColumnsName}=="commcategory")
string commcategory = string.Empty;
##Ajax表单控件
#elseif(${tInfo.SelectType}=="AjaxDynamic")
#elseif($tInfo.ColumnsName.StartsWith("is")&&${tInfo.ColumnsType}=="smallint")
#elseif($tInfo.ColumnsName.StartsWith("is")&&${tInfo.ColumnsType}=="tinyint")
##所属城市,所在区域
#elseif(${tInfo.SelectType}=="ProvinceCity"||${tInfo.SelectType}=="provincecity")
#elseif(${tInfo.ColumnsName}=="fbase")
#elseif(${tInfo.ColumnsName}=="ip")
#elseif(${tInfo.ColumnsName}=="baseyearmonth")
#elseif(${tInfo.SelectType}=="notexist")
#elseif(${tInfo.ColumnsName}=="pinyin")
string pinyin = StringTools.GetChineseSpell(name);
#elseif(${tInfo.ColumnsName}=="py")
#else
#if(${tInfo.ColumnsType}=="timestamp")
string ${tInfo.ColumnsName} =PageValidate.filter(RequestHelper.GetFormString("HiddenField${tInfo.ColumnsName}").Trim(), ${tInfo.ColumnsLength});
#else
#if((${tInfo.ColumnsType}=="varchar"&&${tInfo.ColumnsLength}==-1)||(${tInfo.ColumnsType}=="nvarchar"&&${tInfo.ColumnsLength}==-1)||${tInfo.ColumnsType}=="ntext"||${tInfo.ColumnsType}=="text")
string ${tInfo.ColumnsName} =Utils.ToHtml(PageValidate.filter(RequestHelper.GetFormString("Area${tInfo.ColumnsName}").Trim(), ${tInfo.ColumnsLength}));
#if($tInfo.isNull == false)
if (${tInfo.ColumnsName} == "")
{
todo.Message = "${tInfo.ColumnsDescription}不能为空!";
todo.Result = false;
return Json(todo);
}
#end
#elseif(${tInfo.ColumnsName}=="ip")
#elseif(${tInfo.ColumnsType}=="bit")
#elseif(${tInfo.SelectType}=="ProvinceCity"||${tInfo.SelectType}=="provincecity")
#else
#if(${tInfo.IsFile})
#if(${tInfo.ColumnsName}=="imagepaths"||${tInfo.ColumnsName}=="vediopaths"||${tInfo.ColumnsName}=="docpaths"||${tInfo.ColumnsName}=="musicpaths"||${tInfo.ColumnsName}=="flashpaths")
string ${tInfo.ColumnsName} =PageValidate.filter(RequestHelper.GetFormString("HiddenField${tInfo.ColumnsName}").Trim(), ${tInfo.ColumnsLength});
#else
string ${tInfo.ColumnsName} =PageValidate.filter(RequestHelper.GetFormString("FileUpload${tInfo.ColumnsName}.PostedFile.FileName").Trim(), ${tInfo.ColumnsLength});
if (${tInfo.ColumnsName} == "")
{
${tInfo.ColumnsName} =PageValidate.filter(RequestHelper.GetFormString("HiddenField${tInfo.ColumnsName}").Trim(), ${tInfo.ColumnsLength});
}
else
{
#if(${tInfo.ColumnsName}=="bookpaths")
${tInfo.ColumnsName} = PageValidate.UploadFiledPDFs(RequestHelper.GetFormString("FileUpload${tInfo.ColumnsName}"),Userid.ToString());
#else
HttpPostedFile FileUpload${tInfo.ColumnsName} = HttpContext.Current.Request.Files["FileUpload${tInfo.ColumnsName}"];
${tInfo.ColumnsName} = FileUpload${tInfo.ColumnsName}.FileName;
//${tInfo.ColumnsName} = Goblingcs.UploadFileds(RequestHelper.GetFormString("FileUpload${tInfo.ColumnsName}"),Userid.ToString());
#end
}
#end
#elseif(${tInfo.relRelation})
#else
#if(${tInfo.SelectType}=="Single"||${tInfo.SelectType}=="single")
string ${tInfo.ColumnsName} =PageValidate.filter(RequestHelper.GetFormString("RadioButtonList${tInfo.ColumnsName}"), ${tInfo.ColumnsLength});
#elseif(${tInfo.SelectType}=="Mulit"||${tInfo.SelectType}=="mulit")
string ${tInfo.ColumnsName} = PageValidate.filter(RequestHelper.GetFormString("CheckBoxList${tInfo.ColumnsName}"), ${tInfo.ColumnsLength});
#elseif(${tInfo.SelectType}=="Relax"||${tInfo.SelectType}=="relax")
#set($mtype="${tInfo.SelectItems}")
#foreach($tb in ${host})
#if(${tb.TableName}==${tInfo.FromText})
#set($mkey="${tb.Key.ColumnsName}")
#set($mtb="${tb.TableName}")
#end
#if(${tb.TableName}==${tInfo.FromValue})
#set($rkey="${tb.Key.ColumnsName}")
#set($rtb="${tb.TableName}")
#end
#end
string ${tInfo.ColumnsName} = PageValidate.filter(RequestHelper.GetFormString("HiddenField${tInfo.ColumnsName}").Trim(), ${tInfo.ColumnsLength});
#if($mkey!=""&&$mtb!=""&&$rkey!=""&&$rtb!="")
#if(${mtype}=="0")
#else
#end
#end
#elseif(${tInfo.SelectType}=="TreeRelax"||${tInfo.SelectType}=="treerelax")
#elseif(${tInfo.SelectType}=="Comm"||${tInfo.SelectType}=="comm"||${tInfo.SelectType}=="CommRelax"||${tInfo.SelectType}=="commrelax")
#set($sval="${tInfo.FromText}")
#set($sctrl="${tInfo.FromValue}")
#foreach($tb in ${host})
#if(${tb.TableName}==${tInfo.SelectItems})
#set($skey="${tb.Key.ColumnsName}")
#set($stb="${tb.TableName}")
#end
#end
string ${tInfo.ColumnsName} = PageValidate.filter(RequestHelper.GetFormString("HiddenField${tInfo.ColumnsName}").Trim(), ${tInfo.ColumnsLength});
#if($skey!=""&&$stb!="")
#end
#elseif(${tInfo.SelectType}=="SelectControl"||${tInfo.SelectType}=="InAccountBox"||${tInfo.SelectType}=="InTremBox")
string ${tInfo.ColumnsName} = PageValidate.filter(RequestHelper.GetFormString("HiddenField${tInfo.ColumnsName}").Trim(), ${tInfo.ColumnsLength});
#else
string ${tInfo.ColumnsName} =PageValidate.filter(RequestHelper.GetFormString("TextBox${tInfo.ColumnsName}").Trim(), ${tInfo.ColumnsLength});
#if(${tInfo.IsPassWord} == false&&${tInfo.isNull} == false)
if (${tInfo.ColumnsName} == "")
{
todo.Message = "${tInfo.ColumnsDescription}不能为空!";
todo.Result = false;
return Json(todo);
}
#end
#if(${tInfo.SelectType}=="FindMulit"||${tInfo.SelectType}=="AccountBox"||${tInfo.SelectType}=="SelectBox"||${tInfo.SelectType}=="TremBox")
string hide${tInfo.ColumnsName} = PageValidate.filter(RequestHelper.GetFormString("HiddenField${tInfo.ColumnsName}").Trim(), ${tInfo.ColumnsLength});
#end
#end
#end
#end
#end
#end
#end
#end
#end
${Table}Object model=new ${Table}Object();
##主键开始
#if(${GoTable.Key})
model.${GoTable.Key.ColumnsName}=DataID;
#end
using (${Table}Business CurrDAL = new ${Table}Business())
{
##主键结束
#foreach($tInfo in $Columns)
#if(${tInfo.IsKey}==false||(${tInfo.IsKey}&&${tInfo.relRelation}))
#if(${tInfo.ColumnsType}=="timestamp")
if (DataID>0)
{
model.${tInfo.ColumnsName}=PageValidate.GetTimetamp(${tInfo.ColumnsName});
}
#elseif(${tInfo.ColumnsName}=="viewuser")
if (#if(${GoTable.Key.ColumnsSharp}=="String") DataID =="" #else DataID==0 #end)
{
model.${tInfo.ColumnsName}=Userid;
}
#elseif(${tInfo.ColumnsName}=="owner")
model.${tInfo.ColumnsName}=Userid;
#elseif(${tInfo.ColumnsName}=="orgid")
model.${tInfo.ColumnsName}=_SessionContext.OrgID;
#elseif(${tInfo.ColumnsName}=="lastviewtime")
model.${tInfo.ColumnsName}=System.DateTime.Now;
#elseif(${tInfo.ColumnsName}=="updatetime")
model.${tInfo.ColumnsName}=System.DateTime.Now;
#elseif(${tInfo.ColumnsName}=="createtime")
if (DataID == 0)
{
model.${tInfo.ColumnsName}=System.DateTime.Now;
}
#elseif(${tInfo.ColumnsName}=="viewtime")
model.${tInfo.ColumnsName}=System.DateTime.Now;
#elseif(${tInfo.ColumnsName}=="createuser")
if (DataID == 0)
{
model.${tInfo.ColumnsName}=_SessionContext.Userid;
}
#elseif(${tInfo.ColumnsName}=="updateuser")
model.${tInfo.ColumnsName}=Userid;
#elseif(${tInfo.ColumnsName}=="viewuser")
model.${tInfo.ColumnsName}=Userid;
#elseif(${tInfo.ColumnsName}=="lastlogintime")
model.${tInfo.ColumnsName}=System.DateTime.Now;
#elseif(${tInfo.ColumnsName}=="lastloginip")
model.${tInfo.ColumnsName}=PageValidate.GetClientIP();
#elseif(${tInfo.ColumnsName}=="state")
model.${tInfo.ColumnsName}=0;
#elseif(${tInfo.ColumnsName}=="ip")
model.${tInfo.ColumnsName}=PageValidate.GetClientIP();
#elseif(${tInfo.ColumnsName}=="baseyearmonth")
model.${tInfo.ColumnsName}=_SessionContext.FanganData;
#elseif(${tInfo.SelectType}=="notexist")
#elseif(${tInfo.ColumnsName}=="py")
model.${tInfo.ColumnsName}=Chs2py.Convert(name);
#elseif($tInfo.ColumnsName.StartsWith("is")&&${tInfo.ColumnsType}=="smallint")
model.${tInfo.ColumnsName}=(short)(RequestHelper.GetFormString("CheckBox${tInfo.ColumnsName}")=="on"?1:0);
#elseif($tInfo.ColumnsName.StartsWith("is")&&${tInfo.ColumnsType}=="tinyint")
model.${tInfo.ColumnsName}= RequestHelper.GetFormString("CheckBox${tInfo.ColumnsName}")== "on" ? Convert.ToByte(1) : Convert.ToByte(0);
#elseif(${tInfo.ColumnsType}=="bit")
model.${tInfo.ColumnsName}= RequestHelper.GetFormString("CheckBox${tInfo.ColumnsName}")=="on"?true:false;
#elseif(${tInfo.SelectType}=="ProvinceCity"||${tInfo.SelectType}=="provincecity")
model.${tInfo.ColumnsName} = RequestHelper.GetFormString("sel${tInfo.ColumnsName}Province") + "-" + RequestHelper.GetFormString("sel${tInfo.ColumnsName}City");
##Ajax表单控件
#elseif(${tInfo.SelectType}=="AjaxDynamic")
#elseif(${tInfo.SelectType}=="TreeRelax"||${tInfo.SelectType}=="treerelax")
#elseif(${tInfo.ColumnsName}=="commcategory")
#elseif(${tInfo.ColumnsName}=="fbase")
String fbase = "";
if (RequestHelper.GetFormString("DropDownListfbase") != null)
{
fbase =PageValidate.filter(RequestHelper.GetFormString("DropDownList${tInfo.ColumnsName}"), ${tInfo.ColumnsLength});
}
if (string.IsNullOrEmpty(fbase))
{
fbase = "0";
}
model.${tInfo.ColumnsName}=int.Parse(fbase);
#elseif(${tInfo.ColumnsName}=="sort")
String sort ="";
if (!string.IsNullOrEmpty(fbase))
{
if (fbase == "0")
{
sort = fbase;
}
else
{
if(RequestHelper.GetFormString("fbase")==fbase)
{
${tInfo.ColumnsName} = PageValidate.filter(RequestHelper.GetFormString("sort"), ${tInfo.ColumnsLength}) + "," + fbase;
}
else
{
${tInfo.ColumnsName} =Goblingcs.GetRealtionValue("${Table}", "${GoTable.Key.ColumnsName}=" + fbase, "sort") + "," + fbase;
}
}
}
model.${tInfo.ColumnsName} =${tInfo.ColumnsName};
#else
#if($tInfo.columnsSharp=="String")
#if(${tInfo.SelectType}=="FindMulit"||${tInfo.SelectType}=="AccountBox"||${tInfo.SelectType}=="SelectBox"||${tInfo.SelectType}=="TremBox")
model.${tInfo.ColumnsName}=${tInfo.ColumnsName} + "|" + hide${tInfo.ColumnsName};
#else
#if(${tInfo.IsPassWord})
##密码控件
if (DataID == 0)
{
model.${tInfo.ColumnsName}=DEncrypt.Encrypt(${tInfo.ColumnsName});
}
#elseif(${tInfo.ColumnsName}=="authstatus")
if(#if(${GoTable.Key.ColumnsSharp}=="String") DataID =="" #else DataID==0 #end)
{
model.${tInfo.ColumnsName}="未处理";
}
else
{
model.${tInfo.ColumnsName}=${tInfo.ColumnsName};
}
#else
##其它控件
model.${tInfo.ColumnsName}=${tInfo.ColumnsName};
#end
#end
#elseif($tInfo.columnsSharp=="Byte[]")
model.${tInfo.ColumnsName} = PageValidate.GetTimetamp(${tInfo.ColumnsName});
#else
#if(${tInfo.relRelation})
##主子表同时提交,用于主表在子表中同时提交开始
#if(${tInfo.SelectType}=="FindSingle")
if (PageValidate.IsNumber(RequestHelper.GetFormString("HiddenField${tInfo.ColumnsName}")))
{
##检测是否存在name这个字段
#set($hassysdpt=false)
#set($hasrlenable=false)
#set($hasrelname=false)
#set($RHasTree=false)
#foreach($xrtb in ${host})
#if(${xrtb.TableName}==${tInfo.relRelation.RelationTable})
#set($hasrelname=false)
#set($RHasTree=false)
#foreach($xrbtInfo in ${xrtb.Cols})
#if(${xrbtInfo.ColumnsName}=="name")
#set($hasrelname=true)
#end
#if(${xrbtInfo.IsTree})
#set($RHasTree=true)
#end
#if(${xrbtInfo.ColumnsName}=="isenabled")
#set($hasrlenable=true)
#end
#if(${xrtb.TableName}!="sysdepartment"&&${xrbtInfo.IsKey}==false&&${xrbtInfo.ColumnsName}=="dptid")
#set($hassysdpt=true)
#end
#end
#end
#end
#if($hasrelname)
model.${tInfo.ColumnsName}=${tInfo.columnsSharp}.Parse(Goblingcs.BindSingleText("${tInfo.relRelation.RelationTable}", "name='" + PageValidate.filter(RequestHelper.GetFormString("TextBox${tInfo.ColumnsName}"), 300)+"'" , "${tInfo.relRelation.RelatFiled}"));
#else
model.${tInfo.ColumnsName}=${tInfo.columnsSharp}.Parse(Goblingcs.BindSingleText("${tInfo.relRelation.RelationTable}", "${tInfo.relRelation.RelatFiled}='" + PageValidate.filter(RequestHelper.GetFormString("TextBox${tInfo.ColumnsName}"), 300)+"'" , "${tInfo.relRelation.RelatFiled}"));
#end
}
else
{
model.${tInfo.ColumnsName}=0;
}
#else
#if(${tInfo.isNull} == false)
if (RequestHelper.GetFormString("DropDownList${tInfo.ColumnsName}") == null || !PageValidate.IsNumber(RequestHelper.GetFormString("DropDownList${tInfo.ColumnsName}")))
{
todo.Message = "${tInfo.ColumnsDescription}不能为空!";
todo.Result = false;
return Json(todo);
}
#end
if (RequestHelper.GetFormString("DropDownList${tInfo.ColumnsName}") != null&&PageValidate.IsNumber(RequestHelper.GetFormString("DropDownList${tInfo.ColumnsName}")))
{
model.${tInfo.ColumnsName}=${tInfo.columnsSharp}.Parse(RequestHelper.GetFormString("DropDownList${tInfo.ColumnsName}"));
}
else
{
model.${tInfo.ColumnsName}=0;
}
#end
#else
#if(${tInfo.ColumnsType}=="int"||${tInfo.ColumnsType}=="bigint"||${tInfo.ColumnsType}=="smallint"||${tInfo.ColumnsType}=="tinyint")
if (PageValidate.IsNumber(${tInfo.ColumnsName}))
{
model.${tInfo.ColumnsName}=${tInfo.columnsSharp}.Parse(${tInfo.ColumnsName});
}
else
{
model.${tInfo.ColumnsName}=0;
}
#elseif(${tInfo.ColumnsType}=="decimal"||${tInfo.ColumnsType}=="float"||${tInfo.ColumnsType}=="money"||${tInfo.ColumnsType}=="numeric"||${tInfo.ColumnsType}=="real"||${tInfo.ColumnsType}=="smallmoney")
if (PageValidate.IsDecimal(${tInfo.ColumnsName})||PageValidate.IsNumber(${tInfo.ColumnsName}))
{
model.${tInfo.ColumnsName}=${tInfo.columnsSharp}.Parse(${tInfo.ColumnsName});
}
else
{
model.${tInfo.ColumnsName}=0;
}
#elseif(${tInfo.ColumnsType}=="datetime"||${tInfo.ColumnsType}=="smalldatetime")
if (!string.IsNullOrEmpty(${tInfo.ColumnsName}) && PageValidate.IsDateTime(${tInfo.ColumnsName}))
{
model.${tInfo.ColumnsName}=${tInfo.columnsSharp}.Parse(${tInfo.ColumnsName});
}
else
{
model.${tInfo.ColumnsName}=Convert.ToDateTime("1900-01-01");
}
#else
model.${tInfo.ColumnsName}=${tInfo.columnsSharp}.Parse(${tInfo.ColumnsName});
#end
#end
#end
##检测代码
## /// 全局唯一
## /// 用户唯一
## /// 组织唯一
## /// 部门唯一
##CheckOnlyOne
##ZdyCheckCondition
##CheckValueMsg
##ValiRegex验证规则
##ValiRegexMsg验证提示
#if(${tInfo.CheckOnlyOne}=="全局唯一"||${tInfo.CheckOnlyOne}=="用户唯一"||${tInfo.CheckOnlyOne}=="组织唯一"||${tInfo.CheckOnlyOne}=="部门唯一")
if (DataID > 0)
{
if (CurrDAL.HasSingle${tInfo.ColumnsName}A(model.${tInfo.ColumnsName}#if(${tInfo.ColumnsType}=="int"||${tInfo.ColumnsType}=="decimal"||${tInfo.ColumnsType}=="money"||${tInfo.ColumnsType}=="numeric"||${tInfo.ColumnsType}=="smallint"||${tInfo.ColumnsType}=="smallmoney"||${tInfo.ColumnsType}=="float"||${tInfo.ColumnsType}=="bigint"||${tInfo.ColumnsType}=="real"||${tInfo.ColumnsType}=="tinyint"||${tInfo.ColumnsType}=="bit"||${tInfo.ColumnsType}=="datetime"||${tInfo.ColumnsType}=="smalldatetime").Value#end, model.${GoTable.Key.ColumnsName}#if(${GoTable.Key.ColumnsType}=="int"||${GoTable.Key.ColumnsType}=="decimal"||${GoTable.Key.ColumnsType}=="money"||${GoTable.Key.ColumnsType}=="numeric"||${GoTable.Key.ColumnsType}=="smallint"||${GoTable.Key.ColumnsType}=="smallmoney"||${GoTable.Key.ColumnsType}=="float"||${GoTable.Key.ColumnsType}=="bigint"||${GoTable.Key.ColumnsType}=="real"||${GoTable.Key.ColumnsType}=="tinyint"||${GoTable.Key.ColumnsType}=="bit"||${GoTable.Key.ColumnsType}=="datetime"||${GoTable.Key.ColumnsType}=="smalldatetime").Value#end) > 0)
{
todo.Message = "${tInfo.CheckValueMsg}";
todo.Result = false;
return Json(todo);
}
}
else
{
if (CurrDAL.HasSingle${tInfo.ColumnsName}(model.${tInfo.ColumnsName}#if(${tInfo.ColumnsType}=="int"||${tInfo.ColumnsType}=="decimal"||${tInfo.ColumnsType}=="money"||${tInfo.ColumnsType}=="numeric"||${tInfo.ColumnsType}=="smallint"||${tInfo.ColumnsType}=="smallmoney"||${tInfo.ColumnsType}=="float"||${tInfo.ColumnsType}=="bigint"||${tInfo.ColumnsType}=="real"||${tInfo.ColumnsType}=="tinyint"||${tInfo.ColumnsType}=="bit"||${tInfo.ColumnsType}=="datetime"||${tInfo.ColumnsType}=="smalldatetime").Value#end) > 0)
{
todo.Message = "${tInfo.CheckValueMsg}";
todo.Result = false;
return Json(todo);
}
}
#end
#if(${tInfo.ValiRegex}&&${tInfo.ValiRegex}!="")
if (!PageValidate.IsRegexSuccess("${tInfo.ValiRegex}",model.${tInfo.ColumnsName}#if(${tInfo.ColumnsType}=="int"||${tInfo.ColumnsType}=="decimal"||${tInfo.ColumnsType}=="money"||${tInfo.ColumnsType}=="numeric"||${tInfo.ColumnsType}=="smallint"||${tInfo.ColumnsType}=="smallmoney"||${tInfo.ColumnsType}=="float"||${tInfo.ColumnsType}=="bigint"||${tInfo.ColumnsType}=="real"||${tInfo.ColumnsType}=="tinyint"||${tInfo.ColumnsType}=="bit"||${tInfo.ColumnsType}=="datetime"||${tInfo.ColumnsType}=="smalldatetime").Value#end))
{
todo.Message = "${tInfo.ValiRegexMsg}";
todo.Result = false;
return Json(todo);
}
#end
##
#end
#end
#end
#if(${GoTable.Key})
if (strErr == "")
{
#if($hasrelbit||$bitflag)
if (#if(${GoTable.Key.ColumnsSharp}=="String") DataID !="" #else DataID > 0 #end)
{
if(CurrDAL.BitUpdate(model))
{
Flag = true;
//ToLog(4, "${Table}", DataID.ToString());
}
}
else
{
#if(${SmallTable}=="sysmodule"||${SmallTable}=="sysfileds"||${SmallTable}=="workflow")
model.id = CurrDAL.BitAdd(model);
if (model.id > 0)
#else
if (CurrDAL.BitAdd(model) > 0)
#end
{
Flag = true;
//ToLog(3, "${Table}", DataID.ToString());
}
}
#else
if (#if(${GoTable.Key.ColumnsSharp}=="String") DataID !="" #else DataID > 0 #end)
{
if (CurrDAL.Update(model))
{
Flag = true;
//ToLog(4, "${Table}", DataID.ToString());
}
}
else
{
#if(${SmallTable}=="sysmodule"||${SmallTable}=="sysfileds"||${SmallTable}=="workflow")
model.id = CurrDAL.Add(model);
if (model.id > 0)
#else
if (CurrDAL.Add(model) > 0)
#end
{
Flag = true;
//ToLog(3, "${Table}", DataID.ToString());
}
}
#end
}
#if($issysreport&&$issysreportfileds&&$issysfileds&&$issysbuttons&&$issysmodule&&$issyspagepart&&$issysfiledsinpart&&$isworkflow)
#if(${SmallTable}=="sysmodule"||${SmallTable}=="sysfileds"||${SmallTable}=="workflow")
if (Flag)
{
Building.Build(#if(${SmallTable}=="sysmodule")model.id.Value#else model.moduleid.Value #end, Server.MapPath("~/admin/tempfile"), Server.MapPath("~/admin/"));
}
#end
#end
#end
}
if (Flag)
{
todo.Message = "保存成功";
todo.Result = true;
return Json(todo);
}
else
{
if (string.IsNullOrEmpty(strErr))
{
todo.Message = "操作失效,请重新录入";
todo.Result = true;
return Json(todo);
}
else
{
todo.Message = strErr;
todo.Result = true;
return Json(todo);
}
}
}
catch(Exception err)
{
LogHelper.WriteLog("${Table} btnAdd_Click", err);
todo.Message = err.Message.ToString().Replace("'", "\\'").Replace("\r\n", "\\r\\n");
todo.Result = true;
return Json(todo);
}
}
private ${Table}Object CurrGetWhereStr()
{
${Table}Object ConditionObject = new ${Table}Object();
#set($parenthasTree=false)
#foreach($tRel in ${GoTable.RelRelationList})
#foreach($tb in ${host})
#if(${tb.TableType}==2)
#if(${tb.TableName}==${tRel.RelationTable})
#foreach($currInfo in ${tb.Cols})
#if(${currInfo.IsKey}==false)
#if(${currInfo.IsTree})
#set($parenthasTree=true)
#end
#end
#end
#if($parenthasTree)
if (!string.IsNullOrEmpty(RequestHelper.GetFormString("${tRel.RelatFiled}")))
{
if (RequestHelper.GetFormString("${tRel.RelatFiled}").ToString() != "0")
{
//ConditionObject.${tRel.RelatFiled} = RequestHelper.GetFormString("${tRel.RelatFiled}").ToString();
}
}
#end
#end
#end
#end
#end
#if(${GoTable.IsUser})
##用户的权限控制
##表中不存在roleid并且表中有createuser
#if($hasuserid==true&&$hasroleid==false)
if (_SessionContext != null&&_SessionContext.JsID!=1)
{
//strWhere.AppendFormat(" AND ((Rolefbase={0} AND Accountsdptid={1}) OR createuser={2} #if($hasowner) OR owner={2} #end)", _SessionContext.JsID.ToString(), _SessionContext.StrustsID.ToString(), _SessionContext.Userid.ToString());
//修改去除查看转换数据
//strWhere.AppendFormat(" AND ((Rolefbase={0} AND Accountsdptid={1}) #if($hasowner) OR owner={2} #end)", _SessionContext.JsID.ToString(), _SessionContext.StrustsID.ToString(), _SessionContext.Userid.ToString());
}
#end
#end
##简单查询
#set($chindex=1)
#set($ttable="")
#foreach($tInfo in $Columns)
#if(${tInfo.IsKey}==false)
#set($tfileds=$tInfo)
#set($ttable="")
#if(${tfileds.SelectType}=="InAccountBox")
ConditionObject.${tfileds.ColumnsName}Condition=string.Format(" AND (','+${tfileds.ColumnsName}+',' LIKE ',0|'+convert(nvarchar,{0})+',%' OR ','+${tfileds.ColumnsName}+',' LIKE ',1|'+convert(nvarchar,{1})+',%') ",_SessionContext.Userid.ToString(), _SessionContext.JsID.ToString());
#end
#if(${tfileds.ColumnsName}=="YearMonth")
ConditionObject.${tfileds.ColumnsName}Condition=string.Format(" AND convert(nvarchar(7),${tfileds.ColumnsName},120)=convert(nvarchar(7),'{0}',120)", _SessionContext.FanganData.ToString("yyyy-MM-dd"));
#end
#if(${tfileds.ColumnsName}=="state")
#if($hasstate)
ConditionObject.state = Convert.ToByte(RequestHelper.GetFormString("HiddenIsdel").Trim());
#else
ConditionObject.state = 0;
#end
#end
#if((${GoTable.IsUser}==false||(${GoTable.IsUser}&&${tInfo.SelectType}=="search"))&&${tInfo.isNull}== false&&${tInfo.ColumnsName}!="id"&&${tInfo.ColumnsName}!="mark"&&${tInfo.ColumnsName}!="isenabled"&&${tInfo.ColumnsName}!="ord"&&${tInfo.ColumnsName}!="state"&&${tInfo.ColumnsName}!="updatetime"&&${tInfo.ColumnsName}!="updateuser"&&${tInfo.ColumnsName}!="viewnum"&&${tInfo.ColumnsName}!="owner"&&${tInfo.ColumnsName}!="createtime"&&${tInfo.ColumnsName}!="createuser"&&${tInfo.ColumnsType}!="timestamp"&&${tInfo.ColumnsName}!="password"&&${tInfo.SelectType}!="notexist"&&${tInfo.SelectType}!="FindMulit"&&${tInfo.SelectType}!="AccountBox"&&${tInfo.SelectType}!="SelectBox"&&${tInfo.SelectType}!="SelectControl"&&${tInfo.SelectType}!="TremBox"&&${tInfo.SelectType}!="InAccountBox"&&${tInfo.SelectType}!="InTremBox")
##主表开始
#if(${tfileds.relRelation})
if (!string.IsNullOrEmpty(RequestHelper.GetFormString("TextBox${tfileds.ColumnsName}").Trim()))
{
string ${tfileds.ColumnsName} = Goblingcs.GetRealtionValue("${tfileds.relRelation.RelationTable}", "name='" + PageValidate.filter(RequestHelper.GetFormString("TextBox${tfileds.ColumnsName}").Trim(), 100) + "'", "${tfileds.relRelation.RelatFiled}");
if (!string.IsNullOrEmpty(${tfileds.ColumnsName}) && PageValidate.IsNumber(${tfileds.ColumnsName}))
{
ConditionObject.${tfileds.ColumnsName} = int.Parse(${tfileds.ColumnsName});
}
else
{
ConditionObject.${tfileds.ColumnsName} =0;
}
}
#elseif(${tfileds.ColumnsType}=="timestamp")
#elseif(${tfileds.ColumnsName}=="orgid")
#if($hasoOrg&&$hasuserid)
if (_SessionContext.JsID == 1)
{
ConditionObject.orgid = _SessionContext.OrgID;
}
else
{
ConditionObject.orgidCondition = " AND state=0 and (createuser=" + _SessionContext.Userid.ToString() + " or createuser in (SELECT [id] FROM [sysaccounts] where roleid in (SELECT [id] FROM [sysrole] where sort like ''+(SELECT [sort] FROM [sysrole] where id=" + _SessionContext.JsID.ToString() + ")+',%')))";
ConditionObject.orgid = _SessionContext.OrgID;
}
#else
#if($hasoOrg)
if (_SessionContext.JsID == 1)
{
ConditionObject.orgid = _SessionContext.OrgID;
}
else
{
ConditionObject.orgidCondition = " AND state=0 and (createuser=" + _SessionContext.Userid.ToString() + " or createuser in (SELECT [id] FROM [sysaccounts] where roleid in (SELECT [id] FROM [sysrole] where sort like ''+(SELECT [sort] FROM [sysrole] where id=" + _SessionContext.JsID.ToString() + ")+',%')))";
ConditionObject.orgid = _SessionContext.OrgID;
}
#end
#end
#elseif(${tfileds.ColumnsName}=="name")
if (!string.IsNullOrEmpty(RequestHelper.GetFormString("TextBox${tfileds.ColumnsName}").Trim()))
{
ConditionObject.like${tfileds.ColumnsName} = PageValidate.filter(RequestHelper.GetFormString("TextBox${tfileds.ColumnsName}").Trim(), ${tfileds.ColumnsLength});
}
#elseif(${tfileds.ColumnsName}=="commcategory")
#elseif(${tfileds.SelectType}=="AjaxDynamic")
#elseif(${tfileds.SelectType}=="ProvinceCity"||${tfileds.SelectType}=="provincecity")
if (!string.IsNullOrEmpty(RequestHelper.GetFormString("sel${ttable}${tfileds.ColumnsName}Province").Trim()))
{
ConditionObject.${tfileds.ColumnsName} = PageValidate.filter(RequestHelper.GetFormString("sel${ttable}${tfileds.ColumnsName}Province").Trim(), ${tfileds.ColumnsLength});
}
if (!string.IsNullOrEmpty(RequestHelper.GetFormString("sel${ttable}${tfileds.ColumnsName}City").Trim()))
{
ConditionObject.${tfileds.ColumnsName} = PageValidate.filter(RequestHelper.GetFormString("sel${ttable}${tfileds.ColumnsName}City").Trim(), ${tfileds.ColumnsLength});
}
#elseif(${tfileds.FromType}=="table"&&(${tfileds.SelectType}=="Single"||${tfileds.SelectType}=="single"))
if (!string.IsNullOrEmpty(RequestHelper.GetFormString("RadioButtonList${tfileds.ColumnsName}").Trim()))
{
#if($tfileds.columnsSharp=="String")
ConditionObject.${tfileds.ColumnsName} = PageValidate.filter(RequestHelper.GetFormString("RadioButtonList${tfileds.ColumnsName}").Trim(), ${tfileds.ColumnsLength});
#elseif(${tfileds.ColumnsType}=="tinyint")
ConditionObject.${tfileds.ColumnsName} = PageValidate.filter(RequestHelper.GetFormString("RadioButtonList${tfileds.ColumnsName}").Trim(), ${tfileds.ColumnsLength})=="0"?Convert.ToByte(0):Convert.ToByte(1);
#else
ConditionObject.${tfileds.ColumnsName} = ${tfileds.columnsSharp}.Parse(PageValidate.filter(RequestHelper.GetFormString("RadioButtonList${tfileds.ColumnsName}").Trim(), ${tfileds.ColumnsLength}));
#end
}
#elseif(${tfileds.FromType}=="table"&&(${tfileds.SelectType}=="Mulit"||${tfileds.SelectType}=="mulit"))
if (!string.IsNullOrEmpty(RequestHelper.GetFormString("CheckBoxList${tfileds.ColumnsName}").Trim()))
{
ConditionObject.${tfileds.ColumnsName} = PageValidate.filter(CheckBoxList${tInfo.ColumnsName}, ${tInfo.ColumnsLength});
}
#elseif(${tfileds.SelectType}=="Mulit"||${tfileds.SelectType}=="mulit")
if (!string.IsNullOrEmpty(RequestHelper.GetFormString("CheckBoxList${tfileds.ColumnsName}").Trim()))
{
ConditionObject.${tfileds.ColumnsName} = PageValidate.filter(CheckBoxList${tInfo.ColumnsName}, ${tInfo.ColumnsLength});
}
#elseif(${tfileds.SelectType}=="Single"||${tfileds.SelectType}=="single")
if (!string.IsNullOrEmpty(RequestHelper.GetFormString("RadioButtonList${tfileds.ColumnsName}").Trim()))
{
#if($tfileds.columnsSharp=="String")
ConditionObject.${tfileds.ColumnsName} = PageValidate.filter(RequestHelper.GetFormString("RadioButtonList${tfileds.ColumnsName}").Trim(), ${tfileds.ColumnsLength});
#elseif(${tfileds.ColumnsType}=="tinyint")
ConditionObject.${tfileds.ColumnsName} = PageValidate.filter(RequestHelper.GetFormString("RadioButtonList${tfileds.ColumnsName}").Trim(), ${tfileds.ColumnsLength})=="0"?Convert.ToByte(0):Convert.ToByte(1);
#else
ConditionObject.${tfileds.ColumnsName} = ${tfileds.columnsSharp}.Parse(PageValidate.filter(RequestHelper.GetFormString("RadioButtonList${tfileds.ColumnsName}").Trim(), ${tfileds.ColumnsLength}));
#end
}
#elseif(${tfileds.SelectType}=="Relax"||${tfileds.SelectType}=="relax")
#elseif(${tfileds.SelectType}=="Comm"||${tfileds.SelectType}=="comm"||${tfileds.SelectType}=="CommRelax"||${tfileds.SelectType}=="commrelax")
#elseif(${tfileds.SelectType}=="SelectControl"||${tfileds.SelectType}=="InAccountBox"||${tfileds.SelectType}=="InTremBox")
#elseif(${tfileds.IsFile})
#elseif(${tfileds.ColumnsName}=="BrushAS3"||${tfileds.ColumnsName}=="BrushBash"||${tfileds.ColumnsName}=="BrushColdFusion"||${tfileds.ColumnsName}=="BrushCSharp"||${tfileds.ColumnsName}=="BrushCpp"||${tfileds.ColumnsName}=="BrushCss"||${tfileds.ColumnsName}=="BrushDelphi"||${tfileds.ColumnsName}=="BrushDiff"||${tfileds.ColumnsName}=="BrushErlang"||${tfileds.ColumnsName}=="BrushGroovy"||${tfileds.ColumnsName}=="BrushJScript"||${tfileds.ColumnsName}=="BrushJava"||${tfileds.ColumnsName}=="BrushJavaFX"||${tfileds.ColumnsName}=="BrushPerl"||${tfileds.ColumnsName}=="BrushPhp"||${tfileds.ColumnsName}=="BrushPlain"||${tfileds.ColumnsName}=="BrushPowerShell"||${tfileds.ColumnsName}=="BrushPython"||${tfileds.ColumnsName}=="BrushRuby"||${tfileds.ColumnsName}=="BrushScala"||${tfileds.ColumnsName}=="BrushSql"||${tfileds.ColumnsName}=="BrushVb"||${tfileds.ColumnsName}=="BrushXml")
## if (!string.IsNullOrEmpty(this.Area${tfileds.ColumnsName}.Value))
## {
## Trem = Trem + " AND ${tfileds.ColumnsName}='" + PageValidate.filter(RequestHelper.GetFormString("Area${tfileds.ColumnsName}").Trim(), ${tfileds.ColumnsLength})+ "'";
## }
#elseif(${tfileds.SelectType}=="FindMulit"||${tfileds.SelectType}=="TremBox"||${tfileds.SelectType}=="SelectBox"||${tfileds.SelectType}=="AccountBox")
if (!string.IsNullOrEmpty(RequestHelper.GetFormString("TextBox${tfileds.ColumnsName}").Trim()))
{
ConditionObject.${tfileds.ColumnsName} = PageValidate.filter(RequestHelper.GetFormString("TextBox${tfileds.ColumnsName}").Trim(), ${tfileds.ColumnsLength});
}
#elseif((${tfileds.ColumnsType}=="varchar"&&${tfileds.ColumnsLength}==-1)||(${tfileds.ColumnsType}=="nvarchar"&&${tfileds.ColumnsLength}==-1)||${tfileds.ColumnsType}=="ntext"||${tfileds.ColumnsType}=="text")
## if (!string.IsNullOrEmpty(this.Area${tfileds.ColumnsName}.Value))
## {
## Trem = Trem + " AND ${tfileds.ColumnsName}='" + PageValidate.filter(RequestHelper.GetFormString("Area${tfileds.ColumnsName}").Trim(), ${tfileds.ColumnsLength})+ "'";
## }
#elseif(${tfileds.ColumnsName}=="baseyearmonth"||${tfileds.SelectType}=="notexist")
#elseif(${tfileds.ColumnsType}=="bit"||($tfileds.ColumnsName.StartsWith("is")&&${tfileds.ColumnsType}=="smallint")||($tfileds.ColumnsName.StartsWith("is")&&${tfileds.ColumnsType}=="tinyint"))
#if(${tfileds.ColumnsName}!="islock"&&${tfileds.ColumnsName}!="authstatus"&&${tfileds.ColumnsName}!="issys")
if (!string.IsNullOrEmpty(RequestHelper.GetFormString("DropDownList${tfileds.ColumnsName}").Trim()))
{
#if(${tfileds.ColumnsType}=="bit")
ConditionObject.${tfileds.ColumnsName} = PageValidate.filter(RequestHelper.GetFormString("DropDownList${tfileds.ColumnsName}").Trim(), ${tfileds.ColumnsLength}) == "是" ? true : false;
#else
ConditionObject.${tfileds.ColumnsName} = PageValidate.filter(RequestHelper.GetFormString("DropDownList${tfileds.ColumnsName}").Trim(), ${tfileds.ColumnsLength}) == "是" ? Convert.ToByte(1) : Convert.ToByte(0);
#end
}
#end
#elseif(${tfileds.ColumnsType}=="datetime"||${tfileds.ColumnsType}=="smalldatetime")
if (!string.IsNullOrEmpty(RequestHelper.GetFormString("TextBox${tfileds.ColumnsName}Start").Trim()))
{
ConditionObject.${tfileds.ColumnsName}Start = DateTime.Parse(PageValidate.filter(RequestHelper.GetFormString("TextBox${tfileds.ColumnsName}Start").Trim(), ${tfileds.ColumnsLength}));
}
if (!string.IsNullOrEmpty(RequestHelper.GetFormString("TextBox${tfileds.ColumnsName}End").Trim()))
{
ConditionObject.${tfileds.ColumnsName}End = DateTime.Parse(PageValidate.filter(RequestHelper.GetFormString("TextBox${tfileds.ColumnsName}End").Trim(), ${tfileds.ColumnsLength}));
}
#elseif(${tfileds.ColumnsType}=="int")
if (!string.IsNullOrEmpty(RequestHelper.GetFormString("TextBox${tfileds.ColumnsName}").Trim()))
{
ConditionObject.${tfileds.ColumnsName} = int.Parse(PageValidate.filter(RequestHelper.GetFormString("TextBox${tfileds.ColumnsName}").Trim(), ${tfileds.ColumnsLength}));
}
#elseif(${tfileds.ColumnsType}=="bigint")
if (!string.IsNullOrEmpty(RequestHelper.GetFormString("TextBox${tfileds.ColumnsName}").Trim()))
{
ConditionObject.${tfileds.ColumnsName} = Int64.Parse(PageValidate.filter(RequestHelper.GetFormString("TextBox${tfileds.ColumnsName}").Trim(), ${tfileds.ColumnsLength}));
}
#elseif(${tfileds.ColumnsType}=="smallint")
if (!string.IsNullOrEmpty(RequestHelper.GetFormString("TextBox${tfileds.ColumnsName}").Trim()))
{
ConditionObject.${tfileds.ColumnsName} = Int16.Parse(PageValidate.filter(RequestHelper.GetFormString("TextBox${tfileds.ColumnsName}").Trim(), ${tfileds.ColumnsLength}));
}
#elseif(${tfileds.ColumnsType}=="tinyint")
if (!string.IsNullOrEmpty(RequestHelper.GetFormString("TextBox${tfileds.ColumnsName}").Trim()))
{
ConditionObject.${tfileds.ColumnsName} = PageValidate.filter(RequestHelper.GetFormString("TextBox${tfileds.ColumnsName}").Trim(), ${tfileds.ColumnsLength})== "0" ? Convert.ToByte(0) : Convert.ToByte(1);
}
#elseif(${tfileds.ColumnsType}=="decimal"||${tfileds.ColumnsType}=="money"||${tfileds.ColumnsType}=="smallmoney")
if (!string.IsNullOrEmpty(RequestHelper.GetFormString("TextBox${tfileds.ColumnsName}").Trim()))
{
ConditionObject.${tfileds.ColumnsName} = Decimal.Parse(PageValidate.filter(RequestHelper.GetFormString("TextBox${tfileds.ColumnsName}").Trim(), ${tfileds.ColumnsLength}));
}
#elseif(${tfileds.ColumnsType}=="float")
if (!string.IsNullOrEmpty(RequestHelper.GetFormString("TextBox${tfileds.ColumnsName}").Trim()))
{
ConditionObject.${tfileds.ColumnsName} = Double.Parse(PageValidate.filter(RequestHelper.GetFormString("TextBox${tfileds.ColumnsName}").Trim(), ${tfileds.ColumnsLength}));
}
#elseif(${tfileds.ColumnsType}=="double")
if (!string.IsNullOrEmpty(RequestHelper.GetFormString("TextBox${tfileds.ColumnsName}").Trim()))
{
ConditionObject.${tfileds.ColumnsName} = Double.Parse(PageValidate.filter(RequestHelper.GetFormString("TextBox${tfileds.ColumnsName}").Trim(), ${tfileds.ColumnsLength}));
}
#elseif(${tfileds.ColumnsType}=="numeric")
if (!string.IsNullOrEmpty(RequestHelper.GetFormString("TextBox${tfileds.ColumnsName}").Trim()))
{
ConditionObject.${tfileds.ColumnsName} = Decimal.Parse(PageValidate.filter(RequestHelper.GetFormString("TextBox${tfileds.ColumnsName}").Trim(), ${tfileds.ColumnsLength}));
}
#elseif(${tfileds.ColumnsType}=="real")
if (!string.IsNullOrEmpty(RequestHelper.GetFormString("TextBox${tfileds.ColumnsName}").Trim()))
{
ConditionObject.${tfileds.ColumnsName} = Single.Parse(PageValidate.filter(RequestHelper.GetFormString("TextBox${tfileds.ColumnsName}").Trim(), ${tfileds.ColumnsLength}));
}
#elseif(${tfileds.IsPassWord})
if (!string.IsNullOrEmpty(RequestHelper.GetFormString("TextBox${tfileds.ColumnsName}").Trim()))
{
ConditionObject.${tfileds.ColumnsName} = PageValidate.filter(RequestHelper.GetFormString("TextBox${tfileds.ColumnsName}").Trim(), ${tfileds.ColumnsLength});
}
#else
if (!string.IsNullOrEmpty(RequestHelper.GetFormString("TextBox${tfileds.ColumnsName}").Trim()))
{
ConditionObject.${tfileds.ColumnsName} = PageValidate.filter(RequestHelper.GetFormString("TextBox${tfileds.ColumnsName}").Trim(), ${tfileds.ColumnsLength});
}
##主表开始
##
#end
#end
#end
#end
##简单查询
return ConditionObject;
}
private string Delete()
{
var todo = new ResultMessages();
todo.Message = "删除失败";
todo.Result = false;
try
{
string ids = RequestHelper.GetFormString("ids");
using (${Table}Business CurrDAL = new ${Table}Business())
{
${Table}Object UpdateObject = new ${Table}Object();
UpdateObject.${GoTable.Key.ColumnsName}ids = ids;
#if($hasstate==true)UpdateObject.state = Convert.ToByte(1);#end
todo.Message = "删除成功";
todo.Result = CurrDAL.Update(UpdateObject);
}
}
catch(Exception err)
{
LogHelper.WriteLog("${Table} Delete", err);
return Json(todo);
}
return Json(todo);
}
}
}
using System.Collections.Generic;
using System.Web;
using System.Web.Security;
using System.Web.Script.Serialization;
using Newtonsoft.Json;
using System.Text;
using Common;
using Model;
using BLL;
using ErpDesinger.helper;
using System.Data;
using System.Text;
#if(${SmallTable}=="siteconf"||${SmallTable}=="forums")
using System.IO;
#end
namespace ErpDesinger.Admin.${Table}
{
/// <summary>
/// Summary description for sysaccountsController
/// </summary>
public class ${Table}Controller :BaseHandler
{
#set($HasRelation=false)
#set($currfiledstr="")
#set($currfileddes="")
#foreach($tInfo in $Columns)
#if(${tInfo.ColumnsName}!="createuser"&&${tInfo.ColumnsName}!="orgid"&&${tInfo.ColumnsType}!="timestamp"&&${tInfo.SelectType}!="notexist")
#if(${tInfo.relRelation})
#set($HasRelation=true)
#set($currfiledstr="${currfiledstr}convert(nvarchar,${tInfo.ColumnsName}) as ${tInfo.ColumnsName},")
#foreach($tb in ${host})
#if(${tb.TableName}==${tInfo.relRelation.RelationTable})
#foreach($currInfo in ${tb.Cols})
#if(${tInfo.relRelation.RelatFiled}==$currInfo.ColumnsName)
#set($currfileddes="${currfileddes}${tInfo.ColumnsDescription},")
#end
#end
#end
#end
#else
#set($currfiledstr="${currfiledstr}${tInfo.ColumnsName},")
#set($currfileddes="${currfileddes}${tInfo.ColumnsDescription},")
#end
#end
#end
#if($currfiledstr.length()>0)
#set($noend=$currfiledstr.length() - 1)
#set($currfiledstr=$currfiledstr.substring(0,$noend))
#end
#if($currfileddes.length()>0)
#set($noatend=$currfileddes.length() - 1)
#set($currfileddes=$currfileddes.substring(0,$noatend))
#end
#set($dl="$")
#set($at="@")
#set($jing="#")
#set($hg="_")
#set($dot=".")
#set($D='/')
#set($hasarea=0)
#set($sqlcols="")
#set($hasTree=false)
#set($hasoOrg=false)
#set($createfiled=false)
#set($namefiled=false)
##交叉数据
#set($mtype="")
#set($mkey="")
#set($mtb="")
#set($rkey="")
#set($rtb="")
#set($skey="")
#set($sval="")
#set($sctrl="")
#set($stb="")
##Ajax表单控件函数
#set($hasselect=false)
#set($hasselect2=false)
##参数
#set($detailstr="")
##条件参数
#set($ekeystr="")
#foreach($tRel in ${GoTable.RelRelationList})
#foreach($tb in ${host})
#if(${tb.TableType}==2)
#if(${tb.TableName}==${tRel.RelationTable})
#set($ekeystr="${tRel.RelatFiled}")
#end
#end
#end
#end
#set($approvalfiled=false)
#set($hasenable=false)
#set($haspassword=false)
#set($hasstate=false)
#foreach($tInfo in $Columns)
#if(${tInfo.IsKey}==false)
#if(${tInfo.ColumnsName}=="name")
#set($namefiled=true)
#end
#if(${tInfo.ColumnsName}=="approval")
#set ($approvalfiled=true)
#end
#if(${tInfo.ColumnsName}=="state")
#set($hasstate=true)
#end
#if(${tInfo.ColumnsName}=="enabled")
#set($hasenable=true)
#end
#if(${tInfo.IsPassWord})
#set($haspassword=true)
#end
#if(${tInfo.ColumnsType}!="timestamp"&&${tInfo.ColumnsName}!="lanid"&&${tInfo.ColumnsName}!="viewnum"&&${tInfo.ColumnsName}!="setcode"&&${tInfo.ColumnsName}!="lastviewtime"&&${tInfo.ColumnsName}!="updatetime"&&${tInfo.ColumnsName}!="istop"&&${tInfo.ColumnsName}!="issys"&&${tInfo.ColumnsName}!="state"&&${tInfo.ColumnsName}!="viewtime"&&${tInfo.ColumnsName}!="createuser"&&${tInfo.ColumnsName}!="updateuser"&&${tInfo.ColumnsName}!="viewuser"&&${tInfo.ColumnsName}!="ord"&&${tInfo.ColumnsName}!="owner"&&${tInfo.ColumnsName}!="orgid"&&${tInfo.ColumnsName}!="fbase"&&${tInfo.ColumnsName}!="sort"&&${tInfo.ColumnsName}!="islock"&&${tInfo.ColumnsName}!="enabled"&&${tInfo.ColumnsName}!="issys"&&${tInfo.ColumnsName}!="baseyearmonth"&&${tInfo.ColumnsName}!="importtag"&&${tInfo.SelectType}!="FindSingle"&&${tInfo.SelectType}!="FindMulit"&&${tInfo.SelectType}!="AccountBox"&&${tInfo.SelectType}!="SelectBox"&&${tInfo.SelectType}!="SelectControl"&&${tInfo.SelectType}!="TremBox"&&${tInfo.SelectType}!="InAccountBox"&&${tInfo.SelectType}!="InTremBox")
#if(${tInfo.ColumnsType}=="varchar"&&${tInfo.ColumnsLength}==-1)
#set ($hasarea=1)
#elseif(${tInfo.ColumnsType}=="nvarchar"&&${tInfo.ColumnsLength}==-1)
#set ($hasarea=1)
#elseif(${tInfo.ColumnsType}=="nvarchar"&&${tInfo.ColumnsLength}==150)
#else
#set($sqlcols="$sqlcols$tInfo.ColumnsName,")
#end
#end
#if(${tInfo.IsTree})
#set($hasTree=true)
#end
#if(${tInfo.ColumnsName}=="orgid")
#set($hasoOrg=true)
#end
#if(${tInfo.ColumnsName}=="createtime")
#set($createfiled=true)
#end
#end
#end
##禁止年月
#set($hasyearmonth=false)
#set($hasauth=false)
#set($hasissys=false)
#set($hasislock=false)
#set($hasauthenticated=false)
#set($hasauthsetdata=false)
#set($hasenable=false)
#set($hasNeedenable=false)
#set($hasNeedissys=false)
#set($hasNeedislock=false)
#set($hasNeedauth=false)
#set($haspassword=false)
#set($sqlcols="")
#set($defsqlcols="")
#set($secsqlcols="")
#set($hasTree=false)
#set($hasoOrg=false)
#set($hastsOrg=false)
#set($hasstate=false)
#set($hasname=false)
#set($approvalfiled=false)
#set($hasowner=false)
#set($hasuid=false)
#set($hasNeeduid=false)
#set($hassort=false)
##判断是否有创建用户编号及角色编号
#set($hasuserid=false)
#set($hasroleid=false)
##
#set($hasstate=false)
#foreach($tInfo in $Columns)
#if(${tInfo.ColumnsName}=="state")
#set($hasstate=true)
#end
##判断是否有创建用户编号及角色编号
#if(${tInfo.ColumnsName}=="createuser")
#set($hasuserid=true)
#end
#if(${tInfo.ColumnsName}=="sort")
#set($hassort=true)
#end
#if(${tInfo.ColumnsName}=="uid")
#set($hasuid=true)
#set($hasNeeduid=${tInfo.isNull})
#end
#if(${tInfo.ColumnsName}=="name")
#set($hasname=true)
#end
#if(${tInfo.ColumnsName}=="roleid")
#set($hasroleid=true)
#end
#if(${tInfo.ColumnsName}=="isapproval")
#set($approvalfiled=true)
#end
##
#if(${tInfo.ColumnsName}=="authstatus")
#set($hasauth=true)
#set($hasNeedauth=${tInfo.isNull})
#end
#if(${tInfo.ColumnsName}=="owner")
#set($hasowner=true)
#end
#if(${tInfo.ColumnsName}=="isenabled")
#set($hasenable=true)
#set($hasNeedenable=${tInfo.isNull})
#end
#if(${tInfo.ColumnsName}=="baseyearmonth")
#set($hasyearmonth=true)
#end
#if(${tInfo.IsPassWord})
#set($haspassword=true)
#end
#if(${tInfo.ColumnsName}=="issys")
#set($hasNeedissys=${tInfo.isNull})
#set($hasissys=true)
#end
#if(${tInfo.ColumnsName}=="islock")
#set($hasNeedislock=${tInfo.isNull})
#set($hasislock=true)
#end
#if(${tInfo.IsTree})
#set($hasTree=true)
#end
#if(${tInfo.ColumnsName}=="orgid")
#set($hasoOrg=true)
#end
#if(${tInfo.ColumnsName}=="state")
#set($hasstate=true)
#end
#end
#foreach($tInfo in $Columns)
#if(${tInfo.IsKey}==false)
#if((${GoTable.IsUser}==false||(${GoTable.IsUser}&&${tInfo.SelectType}=="search"))&&${tInfo.isNull}== false&&${tInfo.ColumnsName}!="id"&&${tInfo.ColumnsName}!="mark"&&${tInfo.ColumnsName}!="isenabled"&&${tInfo.ColumnsName}!="ord"&&${tInfo.ColumnsName}!="state"&&${tInfo.ColumnsName}!="updatetime"&&${tInfo.ColumnsName}!="updateuser"&&${tInfo.ColumnsName}!="viewnum"&&${tInfo.ColumnsName}!="owner"&&${tInfo.ColumnsName}!="createtime"&&${tInfo.ColumnsName}!="createuser"&&${tInfo.ColumnsType}!="timestamp"&&${tInfo.ColumnsName}!="password"&&${tInfo.SelectType}!="notexist"&&${tInfo.SelectType}!="FindMulit"&&${tInfo.SelectType}!="AccountBox"&&${tInfo.SelectType}!="SelectBox"&&${tInfo.SelectType}!="SelectControl"&&${tInfo.SelectType}!="TremBox"&&${tInfo.SelectType}!="InAccountBox"&&${tInfo.SelectType}!="InTremBox")
#if(${tInfo.ColumnsName}=="orgid")
#set($hastsOrg=true)
#end
#end
##为了锁定功能放开 每个模块必需要有不是这些除外的一个或多个必填字段
#if(${tInfo.isNull} == false&&${tInfo.ColumnsName}!="createuser"&&${tInfo.ColumnsName}!="password"&&${tInfo.ColumnsName}!="baseyearmonth"&&${tInfo.ColumnsType}!="timestamp"&&${tInfo.ColumnsName}!="fbase"&&${tInfo.ColumnsName}!="lastviewtime"&&${tInfo.ColumnsName}!="updatetime"&&${tInfo.ColumnsName}!="viewtime"&&${tInfo.ColumnsName}!="updateuser"&&${tInfo.ColumnsName}!="viewuser"&&${tInfo.ColumnsName}!="orgid"&&${tInfo.SelectType}!="FindMulit"&&${tInfo.SelectType}!="AccountBox"&&${tInfo.SelectType}!="SelectBox"&&${tInfo.SelectType}!="SelectControl"&&${tInfo.SelectType}!="TremBox"&&${tInfo.SelectType}!="InAccountBox"&&${tInfo.SelectType}!="InTremBox")
##
#if((${tInfo.ColumnsType}=="varchar"&&${tInfo.ColumnsLength}>50)||(${tInfo.ColumnsType}=="nvarchar"&&${tInfo.ColumnsLength}>50)||(${tInfo.ColumnsType}=="varchar"&&${tInfo.ColumnsLength}==-1)||(${tInfo.ColumnsType}=="nvarchar"&&${tInfo.ColumnsLength}==-1)||${tInfo.ColumnsType}=="ntext"||${tInfo.ColumnsType}=="text")
##
#elseif(${EnabledShowCreateTime}==false&&${tInfo.ColumnsName}=="createtime")
##
#elseif(${tInfo.ColumnsType}=="bit"||($tInfo.ColumnsName.StartsWith("is")&&${tInfo.ColumnsType}=="smallint"))
#set($defsqlcols="$defsqlcols$tInfo.ColumnsName,")
#elseif(${tInfo.ColumnsName}=="name"&&$hassort)
#set($defsqlcols="$defsqlcols$tInfo.ColumnsName,")
#else
#set ($hasfiled=0)
#foreach($rInfo in ${GoTable.RelRelationList})
#if($rInfo.CurrFiled==$tInfo.ColumnsName)
#set($hasfiled=1)
#set($relafiled="${rInfo.RelationTable}${rInfo.CurrFiled}")
#end
#end
#if($hasfiled==0)
#if(${tInfo.ColumnsName}=="owner")
#set($sqlcols="${sqlcols}${tInfo.ColumnsName},")
#else
#set($defsqlcols="$defsqlcols$tInfo.ColumnsName,")
#end
#else
#if(${GoTable.IsUser}&&(${tInfo.ColumnsName}=="uid"||${tInfo.ColumnsName}=="owner"))
#set($defsqlcols="${defsqlcols}${tInfo.ColumnsName},")
#end
#set($defsqlcols="$defsqlcols${tInfo.ColumnsName},")
#end
#end
#end
##
#end
#end
##非必填追加
#if($hasNeedenable)
#set($sqlcols="${sqlcols}isenabled,")
#end
##非必填追加
#if($hasNeedissys)
#set($sqlcols="${sqlcols}issys,")
#end
##非必填追加
#if($hasNeedislock)
#set($sqlcols="${sqlcols}islock,")
#end
##非必填追加
#if($hasNeedauth)
#set($sqlcols="${sqlcols}authstatus,")
#end
#if(${GoTable.IsUser}&&$hasNeeduid)
#set($sqlcols="${sqlcols}uid,")
#end
#if($defsqlcols.length()>0)
#set($end=$defsqlcols.length() - 1)
#set($defsqlcols=$defsqlcols.substring(0,$end))
#end
public override void OnLoad(HttpContext context)
{
##验证用户权限
#set($hasmodel=false)
#set($hasrole=false)
#set($hasright=false)
#foreach($tb in ${host})
#if(${tb.TableName}=="sysmodule")
#set($hasmodel=true)
#end
#if(${tb.TableName}=="sysrole")
#set($hasrole=true)
#end
#if(${tb.TableName}=="sysrights")
#set($hasright=true)
#end
#end
#if($hasmodel&&$hasrole&&$hasright)
//验证用户权限
//IsPowerOK("${Table}");
//IsPowerOK("${Table}",3);
#end
string action=string.Empty;
string msg = string.Empty;
if(!string.IsNullOrEmpty(RequestHelper.GetQueryString("action")))
{
action = RequestHelper.GetQueryString("action").ToString();
switch (action)
{
##交叉数据
#set($mtype="")
#set($mkey="")
#set($mtb="")
#set($rkey="")
#set($rtb="")
#set($skey="")
##commrelax中的子表属性
#set($lkey="")
#set($ltb="")
##commrelax中的子表属性
#set($sval="")
#set($sctrl="")
#set($stb="")
#foreach($tInfo in $Columns)
#if(${tInfo.IsKey}==false)
#if(${tInfo.ColumnsName}!="lanid"&&${tInfo.ColumnsName}!="viewnum"&&${tInfo.ColumnsName}!="setcode"&&${tInfo.ColumnsName}!="lastviewtime"&&${tInfo.ColumnsName}!="updatetime"&&${tInfo.ColumnsName}!="createtime"&&${tInfo.ColumnsName}!="istop"&&${tInfo.ColumnsName}!="issys"&&${tInfo.ColumnsName}!="state"&&${tInfo.ColumnsName}!="viewtime"&&${tInfo.ColumnsName}!="createuser"&&${tInfo.ColumnsName}!="updateuser"&&${tInfo.ColumnsName}!="viewuser"&&${tInfo.ColumnsName}!="ord"&&${tInfo.ColumnsName}!="owner"&&${tInfo.ColumnsName}!="sort"&&${tInfo.ColumnsName}!="islock"&&${tInfo.ColumnsName}!="enabled"&&${tInfo.ColumnsName}!="issys"&&${tInfo.ColumnsName}!="baseyearmonth"&&${tInfo.ColumnsName}!="importtag"&&${tInfo.SelectType}!="FindSingle"&&${tInfo.SelectType}!="FindMulit"&&${tInfo.SelectType}!="AccountBox"&&${tInfo.SelectType}!="SelectBox"&&${tInfo.SelectType}!="SelectControl"&&${tInfo.SelectType}!="TremBox"&&${tInfo.SelectType}!="InAccountBox"&&${tInfo.SelectType}!="InTremBox")
#if(${tInfo.SelectType}=="SelectBox")
case "DwMuti${tInfo.SelectItems}":
msg =DwMuti${tInfo.SelectItems}();
break;
case "DwNoMuti${tInfo.SelectItems}":
msg =DwNoMuti${tInfo.SelectItems}();
break;
#elseif(${tInfo.SelectType}=="Relax"||${tInfo.SelectType}=="relax")
#foreach($tb in ${host})
#if(${tb.TableName}==${tInfo.FromText})
#set($mkey="${tb.Key.ColumnsName}")
#set($mtb="${tb.TableName}")
#end
#if(${tb.TableName}==${tInfo.FromValue})
#set($rkey="${tb.Key.ColumnsName}")
#set($rtb="${tb.TableName}")
#end
#end
#if($mkey!=""&&$mtb!=""&&$rkey!=""&&$rtb!="")
case "${rtb}RelaxIndex":
msg =${rtb}RelaxIndex();
break;
case "${mtb}RelaxIndex":
msg =${mtb}RelaxIndex();
break;
#end
#elseif(${tInfo.relRelation})
case "Dw${tInfo.relRelation.RelationTable}${tInfo.ColumnsName}":
msg =Dw${tInfo.relRelation.RelationTable}${tInfo.ColumnsName}();
break;
##
#elseif(${tInfo.ColumnsName}=="fbase")
case "Dw${tInfo.ColumnsName}":
msg =Dw${tInfo.ColumnsName}();
break;
#elseif(${tInfo.ColumnsName}=="orgid")
case "Dwddlorgid":
msg =Dwddlorgid();
break;
#elseif(${tInfo.ColumnsName}=="commcategory")
case "RadioButtonList":
msg =RadioButtonList();
break;
#elseif(${tInfo.SelectType}=="AjaxDynamic")
##所属城市,所在区域
#elseif(${tInfo.SelectType}=="ProvinceCity"||${tInfo.SelectType}=="provincecity")
case "sel${tInfo.ColumnsName}Province":
msg =sel${tInfo.ColumnsName}Province();
break;
#elseif(${tInfo.FromType}=="table"&&(${tInfo.SelectType}=="Single"||${tInfo.SelectType}=="single"))
case "RadioButtonList${tInfo.ColumnsName}":
msg =RadioButtonList${tInfo.ColumnsName}();
break;
#elseif(${tInfo.FromType}=="table"&&(${tInfo.SelectType}=="Mulit"||${tInfo.SelectType}=="mulit"))
case "CheckBoxList${tInfo.ColumnsName}":
msg =CheckBoxList${tInfo.ColumnsName}();
break;
#elseif(${tInfo.SelectType}=="Mulit"||${tInfo.SelectType}=="mulit")
case "CheckBoxList${tInfo.ColumnsName}":
msg =CheckBoxList${tInfo.ColumnsName}();
break;
#elseif(${tInfo.SelectType}=="Single"||${tInfo.SelectType}=="single")
case "RadioButtonList${tInfo.ColumnsName}":
msg =RadioButtonList${tInfo.ColumnsName}();
break;
#elseif(${tInfo.SelectType}=="Relax"||${tInfo.SelectType}=="relax")
#if(${tInfo.SelectItems}=="0")
case "RadioButtonList${tInfo.ColumnsName}":
msg =RadioButtonList${tInfo.ColumnsName}();
break;
#else
case "CheckBoxList${tInfo.ColumnsName}":
msg =CheckBoxList${tInfo.ColumnsName}();
break;
#end
#elseif(${tInfo.SelectType}=="Comm"||${tInfo.SelectType}=="comm"||${tInfo.SelectType}=="CommRelax"||${tInfo.SelectType}=="commrelax")
case "RadioButtonList${tInfo.ColumnsName}":
msg =RadioButtonList${tInfo.ColumnsName}();
break;
case "CheckBoxList${tInfo.ColumnsName}":
msg =CheckBoxList${tInfo.ColumnsName}();
break;
#elseif(${tInfo.IsPassWord})
case "ReSetPassword${tInfo.ColumnsName}":
msg =ReSetPassword${tInfo.ColumnsName}();
break;
#end
#end
#end
#end
##
#if(${Table}=="City")
case "IndexCombox":
msg =IndexCombox();
break;
#end
#if($hasTree)
case "TreeIndex":
msg =TreeIndex();
break;
#end
case "btnExport":
btnExport();
break;
#foreach($currBtn in ${Buttons})
#if(${currBtn.Page}=="list")
case "${currBtn.ButtonId}":
msg =${currBtn.ButtonId}();
break;
#end
#end
#if($hasauth)
case "Auth":
msg =Auth();
break;
#end
#if($approvalfiled)
case "Approval":
msg =Approval();
break;
case "NoApproval":
msg =NoApproval();
break;
#end
case "FilterIndex":
msg =FilterIndex();
break;
case "Index":
msg =Index();
break;
#if($hasenable)
case "SetEnable":
msg =SetEnable();
break;
#end
case "Details":
msg =Details();
break;
case "Create":
msg =Create();
break;
//case "Edit":
// msg =Edit();
// break;
case "Delete":
msg =Delete();
break;
#if(${Table}=="sysaccounts")
case "Logout":
msg =Logout();
break;
case "Login":
msg =Login();
break;
case "getMenu":
msg =getMenu();
break;
#end
}
}
context.Response.ContentType = "application/json";
context.Response.Write(msg);
}
#if(${Table}=="sysaccounts")
private string getMenu()
{
string FatherMenu = string.Empty;
string ChiledMenu = string.Empty;
using (sysmenuBusiness CurrDAL = new sysmenuBusiness())
{
string strapps = string.Empty;
using (sysroleBusiness roleDAL = new sysroleBusiness())
{
sysroleObject currm = roleDAL.GetModel(_SessionContext.JsID);
if (currm != null)
{
strapps = currm.powerstr;
}
else
{
return string.Empty;
}
}
IList<sysmenuObject> rsmodlist = null;
sysmenuObject ConditionObject = new sysmenuObject();
ConditionObject.fbase = 1;
ConditionObject.Columns = "id,name,mark,fbase,tablename";
ConditionObject.OrderKey = "ord";
ConditionObject.OrderType = "desc";
IList<sysmenuObject> rslist = CurrDAL.PagedDataTable(ConditionObject);
if (rslist != null && rslist.Count > 0)
{
ConditionObject = new sysmenuObject();
ConditionObject.menutype = 2;
ConditionObject.Columns = "id,name,mark,fbase,tablename";
ConditionObject.OrderKey = "ord";
ConditionObject.OrderType = "desc";
rsmodlist = CurrDAL.PagedDataTable(ConditionObject);
foreach (sysmenuObject currmenu in rslist)
{
FatherMenu += "{id:'" + currmenu.id.ToString() + "',text:'" + currmenu.name.ToString() + "',iconCls:'icon-" + currmenu.id.ToString() + "',expanded:true";
if (currmenu != null && currmenu.id > 0)
{
IList<sysmenuObject> rsmodtemp = null;
sysmenuObject temp = null;
if (rsmodlist != null && rsmodlist.Count > 0)
{
rsmodtemp = new List<sysmenuObject>();
for (int j = 0; j < rsmodlist.Count; j++)
{
if (rsmodlist[j].fbase == currmenu.id)
{
temp = rsmodlist[j];
rsmodtemp.Add(temp);
}
}
if (rsmodtemp != null && rsmodtemp.Count > 0)
{
ChiledMenu = string.Empty;
foreach (sysmenuObject currmod in rsmodtemp)
{
if (currmenu.isexp == Convert.ToByte(1))
{
ChiledMenu += "{id:'" + currmod.tablename + "Menu',text:'" + currmod.name.ToString() + "',iconCls:'icon-" + currmod.id.ToString() + "',leaf:true},";
}
else
{
ChiledMenu += "{id:'" + currmod.tablename + "Menu',text:'" + currmod.name.ToString() + "',iconCls:'icon-" + currmod.id.ToString() + "',leaf:true},";
}
}
if (!string.IsNullOrEmpty(ChiledMenu))
{
ChiledMenu = ChiledMenu.TrimEnd(',');
FatherMenu += ",children:[" + ChiledMenu + ")";
}
}
}
}
FatherMenu += "},";
}
FatherMenu = FatherMenu.TrimEnd(',');
}
}
return "[" + FatherMenu + ",{id:'pwdMgr',text:'修改密码',iconCls:'icon-pwdMgr',leaf:true},{id:'sysExit',text:'退出系统',iconCls:'icon-sysExit',leaf:true}]";
}
private string Logout()
{
var todo = new ResultMessages();
todo.Result = true;
清空最后的错误
HttpContext.Current.Server.ClearError();
HttpContext.Current.Session.Abandon();
//**********************
FormsAuthentication.SignOut();
return Json(todo);
}
private string Login()
{
var todo = new ResultMessages();
using (sysaccountsBusiness CurrDAL = new sysaccountsBusiness())
{
string username = RequestHelper.GetFormString("username");
string password = RequestHelper.GetFormString("password");
username = PageValidate.filter(username, 50);
password = PageValidate.filter(password, 50);
//username = DEncrypt.Encrypt(username);
password = DEncrypt.Encrypt(password);
SessionFactory _Session = CurrDAL.GetSessionContext(username, password);
if (_Session != null && _Session.Userid != 0)
{
//初始化一个用户凭证的实例
FormsAuthenticationTicket MyTicket = new FormsAuthenticationTicket(1, "admin", DateTime.Now, DateTime.Now.AddMinutes(60), false, "admin");
string encryptedTicket = FormsAuthentication.Encrypt(MyTicket); //加密用户凭证
HttpContext.Current.Session["SessionContext"] = _Session;
//ToLog(1, "", "");
//把用户凭证存入Cookie
HttpCookie authCookie = new HttpCookie(FormsAuthentication.FormsCookieName, encryptedTicket);
//添加Cookie
HttpContext.Current.Response.Cookies.Add(authCookie);
//跳转默认重定向的默认 URL具体见Web.Config的配置
//Response.Redirect(FormsAuthentication.GetRedirectUrl("admin", false));
todo.Message = "登录成功!";
todo.Result = true;
}
else
{
todo.Message = "登录失败,请您检查用户名和密码是否正确!";
todo.Result = false;
}
}
return Json(todo);
}
#end
##交叉数据
#set($mtype="")
#set($mkey="")
#set($mtb="")
#set($rkey="")
#set($rtb="")
#set($skey="")
##commrelax中的子表属性
#set($lkey="")
#set($ltb="")
##commrelax中的子表属性
#set($sval="")
#set($sctrl="")
#set($stb="")
#foreach($tInfo in $Columns)
#if(${tInfo.IsKey}==false)
#if(${tInfo.ColumnsName}!="lanid"&&${tInfo.ColumnsName}!="viewnum"&&${tInfo.ColumnsName}!="setcode"&&${tInfo.ColumnsName}!="lastviewtime"&&${tInfo.ColumnsName}!="updatetime"&&${tInfo.ColumnsName}!="createtime"&&${tInfo.ColumnsName}!="istop"&&${tInfo.ColumnsName}!="issys"&&${tInfo.ColumnsName}!="state"&&${tInfo.ColumnsName}!="viewtime"&&${tInfo.ColumnsName}!="createuser"&&${tInfo.ColumnsName}!="updateuser"&&${tInfo.ColumnsName}!="viewuser"&&${tInfo.ColumnsName}!="ord"&&${tInfo.ColumnsName}!="owner"&&${tInfo.ColumnsName}!="sort"&&${tInfo.ColumnsName}!="islock"&&${tInfo.ColumnsName}!="enabled"&&${tInfo.ColumnsName}!="issys"&&${tInfo.ColumnsName}!="baseyearmonth"&&${tInfo.ColumnsName}!="importtag"&&${tInfo.SelectType}!="FindSingle"&&${tInfo.SelectType}!="FindMulit"&&${tInfo.SelectType}!="AccountBox"&&${tInfo.SelectType}!="SelectBox"&&${tInfo.SelectType}!="SelectControl"&&${tInfo.SelectType}!="TremBox"&&${tInfo.SelectType}!="InAccountBox"&&${tInfo.SelectType}!="InTremBox")
#if(${tInfo.SelectType}=="SelectBox")
private string DwMuti${tInfo.SelectItems}()
{
try
{
using (${tInfo.SelectItems}Business CurrDAL = new ${tInfo.SelectItems}Business())
{
string notinstr = RequestHelper.GetFormString("notinstr");
int currentPage = 1;
int currentSize = 20;
int PageCount = 0;
IList<${tInfo.SelectItems}Object> rslist = null;
${tInfo.SelectItems}Object ConditionObject=new ${tInfo.SelectItems}Object();
if (string.IsNullOrEmpty(notinstr))
{
ConditionObject.Columns ="${tInfo.FromText},${tInfo.FromValue}";
ConditionObject.PageSize = currentSize;
ConditionObject.PageIndex =currentPage;
ConditionObject.OrderKey = "${tInfo.FromText}";
ConditionObject.OrderType = "DESC";
rslist = CurrDAL.PagedDataTable(ConditionObject);
PageCount=CurrDAL.PagedTatolCount(ConditionObject);
}
else
{
ConditionObject.Columns ="${tInfo.FromText},${tInfo.FromValue}";
ConditionObject.PageSize = currentSize;
ConditionObject.PageIndex =currentPage;
ConditionObject.OrderKey = "${tInfo.FromText}";
ConditionObject.OrderType = "DESC";
ConditionObject.Condition = " ${tInfo.FromValue} not in (" + notinstr + ")";
rslist = CurrDAL.PagedDataTable(ConditionObject);
PageCount=CurrDAL.PagedTatolCount(ConditionObject);
}
return Json(new PageMessages2 { data = rslist, totalCount = PageCount });
}
}
catch(Exception err)
{
LogHelper.WriteLog("${tInfo.SelectItems} Index", err);
return "";
}
}
private string DwNoMuti${tInfo.SelectItems}(string instr)
{
try
{
using (${tInfo.SelectItems}Business CurrDAL = new ${tInfo.SelectItems}Business())
{
string instr = RequestHelper.GetFormString("instr");
int currentPage = 1;
int currentSize = 20;
int PageCount = 0;
IList<${tInfo.SelectItems}Object> rslist =null;
${tInfo.SelectItems}Object ConditionObject=new ${tInfo.SelectItems}Object();
if (!string.IsNullOrEmpty(instr))
{
ConditionObject.Columns ="${tInfo.FromText},${tInfo.FromValue}";
ConditionObject.PageSize = currentSize;
ConditionObject.PageIndex =currentPage;
ConditionObject.OrderKey = "${tInfo.FromText}";
ConditionObject.OrderType = "DESC";
ConditionObject.Condition = " ${tInfo.FromValue} in (" + notinstr + ")";
rslist = CurrDAL.PagedDataTable(ConditionObject);
PageCount=CurrDAL.PagedTatolCount(ConditionObject);
}
return Json(new PageMessages2 { data = rslist, totalCount = PageCount });
}
}
catch(Exception err)
{
LogHelper.WriteLog("${tInfo.SelectItems} Index", err);
return "";
}
}
#elseif(${tInfo.SelectType}=="Relax"||${tInfo.SelectType}=="relax")
#foreach($tb in ${host})
#if(${tb.TableName}==${tInfo.FromText})
#set($mkey="${tb.Key.ColumnsName}")
#set($mtb="${tb.TableName}")
#end
#if(${tb.TableName}==${tInfo.FromValue})
#set($rkey="${tb.Key.ColumnsName}")
#set($rtb="${tb.TableName}")
#end
#end
#if($mkey!=""&&$mtb!=""&&$rkey!=""&&$rtb!="")
private string ${rtb}RelaxIndex()
{
try
{
using (${rtb}Business CurrDAL = new ${rtb}Business())
{
int currentPage = 1;
int currentSize = 20;
int PageCount = 0;
${rtb}Object ConditionObject=new ${rtb}Object();
ConditionObject.Columns ="name,${rkey}";
ConditionObject.PageSize = currentSize;
ConditionObject.PageIndex =currentPage;
ConditionObject.OrderKey = "${rkey}";
ConditionObject.OrderType = "DESC";
IList<${rtb}Object> rslist = CurrDAL.PagedDataTable(ConditionObject);
PageCount=CurrDAL.PagedTatolCount(ConditionObject);
return Json(new PageMessages2 { data = rslist, totalCount = PageCount });
}
}
catch(Exception err)
{
LogHelper.WriteLog("${rtb} Index", err);
return "";
}
}
private string ${mtb}RelaxIndex()
{
try
{
using (${mtb}Business CurrDAL = new ${mtb}Business())
{
int currentPage = 1;
int currentSize = 20;
int PageCount = 0;
${mtb}Object ConditionObject=new ${mtb}Object();
ConditionObject.Columns ="name,${mkey}";
ConditionObject.PageSize = currentSize;
ConditionObject.PageIndex =currentPage;
ConditionObject.OrderKey = "${mkey}";
ConditionObject.OrderType = "DESC";
IList<${mtb}Object> rslist = CurrDAL.PagedDataTable(ConditionObject);
PageCount=CurrDAL.PagedTatolCount(ConditionObject);
return Json(new PageMessages2 { data = rslist, totalCount = PageCount });
}
}
catch(Exception err)
{
LogHelper.WriteLog("${mtb} Index", err);
return "";
}
}
#end
#elseif(${tInfo.IsPassWord})
private string ReSetPassword${tInfo.ColumnsName}()
{
var todo = new ResultMessages();
todo.Message = "重置密码失败";
todo.Result = false;
try
{
string ids= RequestHelper.GetFormString("ids");
using (${Table}Business CurrDAL = new ${Table}Business())
{
string newcode = System.Guid.NewGuid().ToString().Substring(0, 6);
${Table}Object UpdateObject = new ${Table}Object();
UpdateObject.idids = ids;
UpdateObject.password = DEncrypt.Encrypt(newcode);
todo.Message = "重置密码成功";
todo.Result = CurrDAL.Update(UpdateObject);
}
}
catch(Exception err)
{
LogHelper.WriteLog("${Table} ResetPasswrod", err);
return Json(todo);
}
return Json(todo);
}
#elseif(${tInfo.relRelation})
private string Dw${tInfo.relRelation.RelationTable}${tInfo.ColumnsName}()
{
try
{
using (${tInfo.relRelation.RelationTable}Business CurrDAL = new ${tInfo.relRelation.RelationTable}Business())
{
string q = RequestHelper.GetQueryString("q").Trim();
int currentPage = 1;
if (!string.IsNullOrEmpty(HttpContext.Current.Request["page"]))
{
currentPage = RequestHelper.GetQueryInt("page");
}
##检测是否存在name这个字段
#set($hassysdpt=false)
#set($hasrlenable=false)
#set($hasrelname=false)
#set($RHasTree=false)
#foreach($xrtb in ${host})
#if(${xrtb.TableName}==${tInfo.relRelation.RelationTable})
#set($hasrelname=false)
#set($RHasTree=false)
#foreach($xrbcurrInfo in ${xrtb.Cols})
#if(${xrbcurrInfo.ColumnsName}=="name")
#set($hasrelname=true)
#end
#if(${xrbcurrInfo.IsTree})
#set($RHasTree=true)
#end
#if(${xrbcurrInfo.ColumnsName}=="isenabled")
#set($hasrlenable=true)
#end
#if(${xrtb.TableName}!="sysdepartment"&&${xrtb.TableName}!="configfangan"&&${xrbcurrInfo.IsKey}==false&&${xrbcurrInfo.ColumnsName}=="dptid")
#set($hassysdpt=true)
#end
#end
#end
#end
##下拉选项
#if($RHasTree)
int currentSize = 20;
int PageCount = 0;
int level = 0;
string strEmpty = string.Empty;
${tInfo.relRelation.RelationTable}Object ConditionObject=new ${tInfo.relRelation.RelationTable}Object();
ConditionObject.Columns ="#if($hasrelname)name,#end${GoTable.Key.ColumnsName},len(sort)-len(replace(sort,',','')) as codelength,sort,sort+','+CONVERT(nvarchar,id) AS bpath";
ConditionObject.OrderType = "bpath";
ConditionObject.Condition = #if(${Table}=="sysorganize"&&${tInfo.relRelation.RelationTable}=="sysorganize")"id=" + _SessionContext.OrgID.ToString()#elseif($hasrole==true)"state=0 and (createuser=" + _SessionContext.Userid.ToString() + " or createuser in (SELECT [id] FROM [sysaccounts] where roleid in (SELECT [id] FROM [sysrole] where sort like ''+(SELECT [sort] FROM [sysrole] where id=" + _SessionContext.JsID.ToString() + ")+',%'))) and orgid=" + _SessionContext.OrgID.ToString() #else""#end +"#if($hasrlenable) AND isenabled=1#end#if($hassysdpt) AND dptid="+_SessionContext.StrustsID.ToString()+"#end#if(${tInfo.Condition}) AND ${tInfo.Condition} #end";
if (!string.IsNullOrEmpty(q))
{
ConditionObject.likename = q;
}
IList<${tInfo.relRelation.RelationTable}Object> rslist = CurrDAL.PagedDataTable(ConditionObject);
List<Select2Item> Items = new List<Select2Item>();
if (rslist != null && rslist.Count > 0)
{
Items.Add(new Select2Item("请进行选择", ""));
foreach (${tInfo.relRelation.RelationTable}Object temp in rslist)
{
if (temp.codelength.HasValue)
{
level = temp.codelength.Value;
}
else
{
level = 0;
}
strEmpty = "";
for (int i = 0; i < level; i++)
{
strEmpty += " ";
}
strEmpty += "├ ";
Items.Add(new Select2Item(strEmpty+temp.name, temp.${tInfo.relRelation.RelatFiled}.ToString()));
}
}
#else
int currentSize = 20;
int PageCount = 0;
${tInfo.relRelation.RelationTable}Object ConditionObject=new ${tInfo.relRelation.RelationTable}Object();
ConditionObject.Columns ="#if($hasrelname)name,#end${tInfo.relRelation.RelatFiled}";
ConditionObject.PageSize = currentSize;
ConditionObject.PageIndex =currentPage;
ConditionObject.Condition = #if(${Table}=="sysorganize"&&${tInfo.relRelation.RelationTable}=="sysorganize")"id=" + _SessionContext.OrgID.ToString()#elseif($hasrole==true)"state=0 and (createuser=" + _SessionContext.Userid.ToString() + " or createuser in (SELECT [id] FROM [sysaccounts] where roleid in (SELECT [id] FROM [sysrole] where sort like ''+(SELECT [sort] FROM [sysrole] where id=" + _SessionContext.JsID.ToString() + ")+',%'))) and orgid=" + _SessionContext.OrgID.ToString() #else""#end +"#if($hasrlenable) AND isenabled=1#end#if($hassysdpt) AND dptid="+_SessionContext.StrustsID.ToString()+"#end#if(${tInfo.Condition}) AND ${tInfo.Condition} #end";
ConditionObject.OrderKey = "${tInfo.relRelation.RelatFiled}";
ConditionObject.OrderType = "DESC";
if (!string.IsNullOrEmpty(q))
{
ConditionObject.${tInfo.relRelation.RelatFiled} = Convert.ToInt32(q);
}
IList<${tInfo.relRelation.RelationTable}Object> rslist = CurrDAL.PagedDataTable(ConditionObject);
List<Select2Item> Items = new List<Select2Item>();
if (rslist != null && rslist.Count > 0)
{
Items.Add(new Select2Item("请进行选择", ""));
foreach (${tInfo.relRelation.RelationTable}Object temp in rslist)
{
Items.Add(new Select2Item(temp.${tInfo.relRelation.RelatFiled}.ToString(), temp.${tInfo.relRelation.RelatFiled}.ToString()));
}
}
#end
##检测是否存在name这个字段
Select2 select2 = new Select2();
select2.items = Items;
select2.page = PageCount;
select2.page = CurrDAL.PagedTatolCount(ConditionObject);
return JsonConvert.SerializeObject(select2);
}
}
catch(Exception err)
{
LogHelper.WriteLog("${tInfo.relRelation.RelationTable} Index", err);
return "";
}
}
#if(${tInfo.relRelation.RelationTable}!="Products")
#set($detailstr=",string ${tInfo.relRelation.RelatFiled}")
#end
##
#elseif(${tInfo.ColumnsName}=="fbase")
private string Dw${tInfo.ColumnsName}()
{
try
{
using (${Table}Business CurrDAL = new ${Table}Business())
{
string q = RequestHelper.GetQueryString("q").Trim();
int currentPage = 1;
if (!string.IsNullOrEmpty(HttpContext.Current.Request["page"]))
{
currentPage = RequestHelper.GetQueryInt("page");
}
int currentSize = 20;
int PageCount = 0;
int level = 0;
string strEmpty = string.Empty;
${Table}Object ConditionObject=new ${Table}Object();
ConditionObject.Columns ="name,${GoTable.Key.ColumnsName},len(sort)-len(replace(sort,',','')) as codelength,sort,sort+','+CONVERT(nvarchar,id) AS bpath";
ConditionObject.OrderType = "bpath";
if (!string.IsNullOrEmpty(q))
{
ConditionObject.likename = q;
}
IList<${Table}Object> rslist = CurrDAL.PagedDataTable(ConditionObject);
List<Select2Item> Items = new List<Select2Item>();
if (rslist != null && rslist.Count > 0)
{
Items.Add(new Select2Item("请进行选择", ""));
foreach (${Table}Object temp in rslist)
{
if (temp.codelength.HasValue)
{
level = temp.codelength.Value;
}
else
{
level = 0;
}
strEmpty = "";
for (int i = 0; i < level; i++)
{
strEmpty += " ";
}
strEmpty += "├ ";
Items.Add(new Select2Item(strEmpty+temp.name, temp.${GoTable.Key.ColumnsName}.ToString()));
}
}
Select2 select2 = new Select2();
select2.items = Items;
select2.page = PageCount;
select2.page = CurrDAL.PagedTatolCount(ConditionObject);
return JsonConvert.SerializeObject(select2);
}
}
catch(Exception err)
{
LogHelper.WriteLog("${Table} Index", err);
return "";
}
}
#elseif(${tInfo.ColumnsName}=="orgid")
private string Dwddlorgid()
{
try
{
using (sysorganizeBusiness CurrDAL = new sysorganizeBusiness())
{
string q = RequestHelper.GetQueryString("q").Trim();
int currentPage = 1;
if (!string.IsNullOrEmpty(HttpContext.Current.Request["page"]))
{
currentPage = RequestHelper.GetQueryInt("page");
}
int PageCount = 0;
int level = 0;
string strEmpty = string.Empty;
sysorganizeObject ConditionObject=new sysorganizeObject();
ConditionObject.Columns ="name,id,len(sort)-len(replace(sort,',','')) as codelength,sort,sort+','+CONVERT(nvarchar,id) AS bpath";
ConditionObject.OrderType = "bpath";
if (!string.IsNullOrEmpty(q))
{
ConditionObject.likename = q;
}
IList<sysorganizeObject> rslist = CurrDAL.PagedDataTable(ConditionObject);
List<Select2Item> Items = new List<Select2Item>();
if (rslist != null && rslist.Count > 0)
{
Items.Add(new Select2Item("请进行选择", ""));
foreach (sysorganizeObject temp in rslist)
{
if (temp.codelength.HasValue)
{
level = temp.codelength.Value;
}
else
{
level = 0;
}
strEmpty = "";
for (int i = 0; i < level; i++)
{
strEmpty += " ";
}
strEmpty += "├ ";
Items.Add(new Select2Item(strEmpty+temp.name, temp.id.ToString()));
}
}
Select2 select2 = new Select2();
select2.items = Items;
select2.page = PageCount;
select2.page = CurrDAL.PagedTatolCount(ConditionObject);
return JsonConvert.SerializeObject(select2);
}
}
catch(Exception err)
{
LogHelper.WriteLog("${Table} Index", err);
return "";
}
}
#elseif(${tInfo.ColumnsName}=="commcategory")
private string RadioButtonList()
{
try
{
using (${tInfo.SelectItems}Business CurrDAL = new ${tInfo.SelectItems}Business())
{
string q = RequestHelper.GetQueryString("q").Trim();
int currentPage = 1;
if (!string.IsNullOrEmpty(HttpContext.Current.Request["page"]))
{
currentPage = RequestHelper.GetQueryInt("page");
}
int currentSize = 20;
int PageCount = 0;
${tInfo.SelectItems}Object ConditionObject=new ${tInfo.SelectItems}bject();
ConditionObject.Columns ="${tInfo.FromText},${tInfo.FromValue}";
ConditionObject.PageSize = currentSize;
ConditionObject.PageIndex =currentPage;
ConditionObject.OrderKey = "${tInfo.FromValue}";
ConditionObject.OrderType = "DESC";
if (!string.IsNullOrEmpty(q))
{
ConditionObject.likename = q;
}
IList<${tInfo.SelectItems}Object> rslist = CurrDAL.PagedDataTable(ConditionObject);
List<Select2Item> Items = new List<Select2Item>();
if (rslist != null && rslist.Count > 0)
{
foreach (${tInfo.SelectItems}Object temp in rslist)
{
Items.Add(new Select2Item(temp.name, temp.${tInfo.FromValue}.ToString()));
}
}
Select2 select2 = new Select2();
select2.items = Items;
select2.page = PageCount;
select2.page = CurrDAL.PagedTatolCount(ConditionObject);
return JsonConvert.SerializeObject(select2);
}
}
catch(Exception err)
{
LogHelper.WriteLog("${Table} Index", err);
return "";
}
}
#elseif(${tInfo.SelectType}=="AjaxDynamic")
##所属城市,所在区域
#elseif(${tInfo.SelectType}=="ProvinceCity"||${tInfo.SelectType}=="provincecity")
private string sel${tInfo.ColumnsName}Province()
{
try
{
using (syscityBusiness CurrDAL = new syscityBusiness())
{
string q = RequestHelper.GetQueryString("q").Trim();
int currentPage = 1;
if (!string.IsNullOrEmpty(HttpContext.Current.Request["page"]))
{
currentPage = RequestHelper.GetQueryInt("page");
}
int currentSize = 20;
int PageCount = 0;
syscityObject ConditionObject=new syscityObject();
ConditionObject.Columns ="name,id";
ConditionObject.PageSize = currentSize;
ConditionObject.PageIndex =currentPage;
ConditionObject.Condition ="#if(${tInfo.Condition}) ${tInfo.Condition} #end";
ConditionObject.OrderKey = "id";
ConditionObject.OrderType = "DESC";
if (!string.IsNullOrEmpty(q))
{
ConditionObject.likename = q;
}
IList<syscityObject> rslist = CurrDAL.PagedDataTable(ConditionObject);
List<Select2Item> Items = new List<Select2Item>();
if (rslist != null && rslist.Count > 0)
{
foreach (syscityObject temp in rslist)
{
Items.Add(new Select2Item(temp.name, temp.id.ToString()));
}
}
Select2 select2 = new Select2();
select2.items = Items;
select2.page = PageCount;
select2.page = CurrDAL.PagedTatolCount(ConditionObject);
return JsonConvert.SerializeObject(select2);
}
}
catch(Exception err)
{
LogHelper.WriteLog("${Table} Index", err);
return "";
}
}
#elseif(${tInfo.FromType}=="table"&&(${tInfo.SelectType}=="Single"||${tInfo.SelectType}=="single"))
private string RadioButtonList${tInfo.ColumnsName}()
{
try
{
using (${tInfo.SelectItems}Business CurrDAL = new ${tInfo.SelectItems}Business())
{
string q = RequestHelper.GetQueryString("q").Trim();
int currentPage = 1;
if (!string.IsNullOrEmpty(HttpContext.Current.Request["page"]))
{
currentPage = RequestHelper.GetQueryInt("page");
}
int currentSize = 20;
int PageCount = 0;
${tInfo.SelectItems}Object ConditionObject=new ${tInfo.SelectItems}Object();
ConditionObject.Columns ="${tInfo.FromText},${tInfo.FromValue}";
ConditionObject.PageSize = currentSize;
ConditionObject.PageIndex =currentPage;
ConditionObject.OrderKey = "${tInfo.FromValue}";
ConditionObject.OrderType = "DESC";
if (!string.IsNullOrEmpty(q))
{
ConditionObject.likename = q;
}
IList<${tInfo.SelectItems}Object> rslist = CurrDAL.PagedDataTable(ConditionObject);
List<Select2Item> Items = new List<Select2Item>();
if (rslist != null && rslist.Count > 0)
{
foreach (${tInfo.SelectItems}Object temp in rslist)
{
Items.Add(new Select2Item(temp.name, temp.${tInfo.FromValue}.ToString()));
}
}
Select2 select2 = new Select2();
select2.items = Items;
select2.page = PageCount;
select2.page = CurrDAL.PagedTatolCount(ConditionObject);
return JsonConvert.SerializeObject(select2);
}
}
catch(Exception err)
{
LogHelper.WriteLog("${Table} Index", err);
return "";
}
}
#elseif(${tInfo.FromType}=="table"&&(${tInfo.SelectType}=="Mulit"||${tInfo.SelectType}=="mulit"))
private string CheckBoxList${tInfo.ColumnsName}()
{
try
{
using (${tInfo.SelectItems}Business CurrDAL = new ${tInfo.SelectItems}Business())
{
string q = RequestHelper.GetQueryString("q").Trim();
int currentPage = 1;
if (!string.IsNullOrEmpty(HttpContext.Current.Request["page"]))
{
currentPage = RequestHelper.GetQueryInt("page");
}
int currentSize = 20;
int PageCount = 0;
${tInfo.SelectItems}Object ConditionObject=new ${tInfo.SelectItems}Object();
ConditionObject.Columns ="${tInfo.FromText},${tInfo.FromValue}";
ConditionObject.PageSize = currentSize;
ConditionObject.PageIndex =currentPage;
ConditionObject.OrderKey = "${tInfo.FromValue}";
ConditionObject.OrderType = "DESC";
if (!string.IsNullOrEmpty(q))
{
ConditionObject.likename = q;
}
IList<${tInfo.SelectItems}Object> rslist = CurrDAL.PagedDataTable(ConditionObject);
List<Select2Item> Items = new List<Select2Item>();
if (rslist != null && rslist.Count > 0)
{
foreach (${tInfo.SelectItems}Object temp in rslist)
{
Items.Add(new Select2Item(temp.name, temp.${tInfo.FromValue}.ToString()));
}
}
Select2 select2 = new Select2();
select2.items = Items;
select2.page = PageCount;
select2.page = CurrDAL.PagedTatolCount(ConditionObject);
return JsonConvert.SerializeObject(select2);
}
}
catch(Exception err)
{
LogHelper.WriteLog("${Table} Index", err);
return "";
}
}
#elseif(${tInfo.SelectType}=="Mulit"||${tInfo.SelectType}=="mulit")
private string CheckBoxList${tInfo.ColumnsName}()
{
try
{
string CheckBoxList${tInfo.ColumnsName}Str="${tInfo.SelectItems}";
string[] itemarr = CheckBoxList${tInfo.ColumnsName}Str.Split(',');
int itemlength = itemarr.Length;
List<Select2Item> Items = new List<Select2Item>();
if (itemarr != null && itemarr.Length > 0)
{
int stepindex = 0;
foreach (string temp in itemarr)
{
Items.Add(new Select2Item(temp.Trim(), stepindex.ToString()));
stepindex++;
}
}
Select2 select2 = new Select2();
select2.items = Items;
select2.page = itemlength;
return JsonConvert.SerializeObject(select2);
}
catch(Exception err)
{
LogHelper.WriteLog("${Table} Index", err);
return "";
}
}
#elseif(${tInfo.SelectType}=="Single"||${tInfo.SelectType}=="single")
private string RadioButtonList${tInfo.ColumnsName}()
{
try
{
string RadioButtonList${tInfo.ColumnsName}Str="${tInfo.SelectItems}";
string[] itemarr = RadioButtonList${tInfo.ColumnsName}Str.Split(',');
int itemlength = itemarr.Length;
List<Select2Item> Items = new List<Select2Item>();
if (itemarr != null && itemarr.Length > 0)
{
int stepindex = 0;
foreach (string temp in itemarr)
{
Items.Add(new Select2Item(temp.Trim(), stepindex.ToString()));
stepindex++;
}
}
Select2 select2 = new Select2();
select2.items = Items;
select2.page = itemlength;
return JsonConvert.SerializeObject(select2);
}
catch(Exception err)
{
LogHelper.WriteLog("${Table} Index", err);
return "";
}
}
#elseif(${tInfo.SelectType}=="Relax"||${tInfo.SelectType}=="relax")
#if(${tInfo.SelectItems}=="0")
private string RadioButtonList${tInfo.ColumnsName}()
{
try
{
using (${tInfo.SelectItems}Business CurrDAL = new ${tInfo.SelectItems}Business())
{
string q = RequestHelper.GetQueryString("q").Trim();
int currentPage = 1;
if (!string.IsNullOrEmpty(HttpContext.Current.Request["page"]))
{
currentPage = RequestHelper.GetQueryInt("page");
}
int currentSize = 20;
int PageCount = 0;
${tInfo.SelectItems}Object ConditionObject=new ${tInfo.SelectItems}Object();
ConditionObject.Columns ="name,${GoTable.Key.ColumnsName}";
ConditionObject.PageSize = currentSize;
ConditionObject.PageIndex =currentPage;
ConditionObject.OrderKey = "${GoTable.Key.ColumnsName}";
ConditionObject.OrderType = "DESC";
if (!string.IsNullOrEmpty(q))
{
ConditionObject.likename = q;
}
IList<${tInfo.SelectItems}Object> rslist = CurrDAL.PagedDataTable(ConditionObject);
List<Select2Item> Items = new List<Select2Item>();
if (rslist != null && rslist.Count > 0)
{
foreach (${tInfo.SelectItems}Object temp in rslist)
{
Items.Add(new Select2Item(temp.name, temp.${GoTable.Key.ColumnsName}.ToString()));
}
}
Select2 select2 = new Select2();
select2.items = Items;
select2.page = PageCount;
select2.page = CurrDAL.PagedTatolCount(ConditionObject);
return JsonConvert.SerializeObject(select2);
}
}
catch(Exception err)
{
LogHelper.WriteLog("${Table} Index", err);
return "";
}
}
#else
private string CheckBoxList${tInfo.ColumnsName}()
{
try
{
using (${tInfo.SelectItems}Business CurrDAL = new ${tInfo.SelectItems}Business())
{
string q = RequestHelper.GetQueryString("q").Trim();
int currentPage = 1;
if (!string.IsNullOrEmpty(HttpContext.Current.Request["page"]))
{
currentPage = RequestHelper.GetQueryInt("page");
}
int currentSize = 20;
int PageCount = 0;
${tInfo.SelectItems}Object ConditionObject=new ${tInfo.SelectItems}Object();
ConditionObject.Columns ="name,${GoTable.Key.ColumnsName}";
ConditionObject.PageSize = currentSize;
ConditionObject.PageIndex =currentPage;
ConditionObject.OrderKey = "${GoTable.Key.ColumnsName}";
ConditionObject.OrderType = "DESC";
if (!string.IsNullOrEmpty(q))
{
ConditionObject.likename = q;
}
IList<${tInfo.SelectItems}Object> rslist = CurrDAL.PagedDataTable(ConditionObject);
List<Select2Item> Items = new List<Select2Item>();
if (rslist != null && rslist.Count > 0)
{
foreach (${Table}Object temp in rslist)
{
Items.Add(new Select2Item(temp.name, temp.${GoTable.Key.ColumnsName}.ToString()));
}
}
Select2 select2 = new Select2();
select2.items = Items;
select2.page = PageCount;
select2.page = CurrDAL.PagedTatolCount(ConditionObject);
return JsonConvert.SerializeObject(select2);
}
}
catch(Exception err)
{
LogHelper.WriteLog("${Table} Index", err);
return "";
}
}
#end
#elseif(${tInfo.SelectType}=="Comm"||${tInfo.SelectType}=="comm"||${tInfo.SelectType}=="CommRelax"||${tInfo.SelectType}=="commrelax")
private string RadioButtonList${tInfo.ColumnsName}()
{
try
{
using (${tInfo.SelectItems}Business CurrDAL = new ${tInfo.SelectItems}Business())
{
string q = RequestHelper.GetQueryString("q").Trim();
int currentPage = 1;
if (!string.IsNullOrEmpty(HttpContext.Current.Request["page"]))
{
currentPage = RequestHelper.GetQueryInt("page");
}
int currentSize = 20;
int PageCount = 0;
${tInfo.SelectItems}Object ConditionObject=new ${tInfo.SelectItems}Object();
ConditionObject.Columns ="name,${GoTable.Key.ColumnsName}";
ConditionObject.PageSize = currentSize;
ConditionObject.PageIndex =currentPage;
ConditionObject.OrderKey = "${GoTable.Key.ColumnsName}";
ConditionObject.OrderType = "DESC";
if (!string.IsNullOrEmpty(q))
{
ConditionObject.likename = q;
}
IList<${tInfo.SelectItems}Object> rslist = CurrDAL.PagedDataTable(ConditionObject);
List<Select2Item> Items = new List<Select2Item>();
if (rslist != null && rslist.Count > 0)
{
foreach (${tInfo.SelectItems}Object temp in rslist)
{
Items.Add(new Select2Item(temp.name, temp.${GoTable.Key.ColumnsName}.ToString()));
}
}
Select2 select2 = new Select2();
select2.items = Items;
select2.page = PageCount;
select2.page = CurrDAL.PagedTatolCount(ConditionObject);
return JsonConvert.SerializeObject(select2);
}
}
catch(Exception err)
{
LogHelper.WriteLog("${Table} Index", err);
return "";
}
}
private string CheckBoxList${tInfo.ColumnsName}()
{
try
{
using (${tInfo.SelectItems}Business CurrDAL = new ${tInfo.SelectItems}Business())
{
string q = RequestHelper.GetQueryString("q").Trim();
int currentPage = 1;
if (!string.IsNullOrEmpty(HttpContext.Current.Request["page"]))
{
currentPage = RequestHelper.GetQueryInt("page");
}
int currentSize = 20;
int PageCount = 0;
${tInfo.SelectItems}Object ConditionObject=new ${tInfo.SelectItems}Object();
ConditionObject.Columns ="name,${GoTable.Key.ColumnsName}";
ConditionObject.PageSize = currentSize;
ConditionObject.PageIndex =currentPage;
ConditionObject.OrderKey = "${GoTable.Key.ColumnsName}";
ConditionObject.OrderType = "DESC";
if (!string.IsNullOrEmpty(q))
{
ConditionObject.likename = q;
}
IList<${tInfo.SelectItems}Object> rslist = CurrDAL.PagedDataTable(ConditionObject);
List<Select2Item> Items = new List<Select2Item>();
if (rslist != null && rslist.Count > 0)
{
foreach (${tInfo.SelectItems}Object temp in rslist)
{
Items.Add(new Select2Item(temp.name, temp.${GoTable.Key.ColumnsName}.ToString()));
}
}
Select2 select2 = new Select2();
select2.items = Items;
select2.page = PageCount;
select2.page = CurrDAL.PagedTatolCount(ConditionObject);
return JsonConvert.SerializeObject(select2);
}
}
catch(Exception err)
{
LogHelper.WriteLog("${Table} Index", err);
return "";
}
}
#end
#end
#end
#end
##
#set($childstr="")
##子表
#if(${GoTable.TableName}=="Orders")
#foreach($tRel in ${GoTable.ChildRelationList})
#foreach($tb in ${host})
#if(${tb.TableName}!="Accounts"&&${tb.TableName}!="RoleRight")
#if(${tb.TableName}==${tRel.CurrentTable})
#set($childstr="${childstr},string rec${tb.TableName}json")
#end
#end
#end
#end
#end
##子表
#if(${Table}=="City")
private string IndexCombox()
{
try
{
string query = RequestHelper.GetFormString("query");
using (${Table}Business CurrDAL = new ${Table}Business())
{
StringBuilder strWhere = new StringBuilder();
if (!string.IsNullOrEmpty(query))
{
//#warning 代码生成警告:请修改 keywordField 为需要匹配查询的真实字段名称
strWhere.AppendFormat(" AND fbase={0} ", PageValidate.filter(query.Trim(), 50));
}
int currentPage = 1;
int currentSize = 100;
int PageCount = 0;
${Table}Object ConditionObject=new ${Table}Object();
ConditionObject.Columns ="$sqlcols${GoTable.Key.ColumnsName}";
ConditionObject.PageSize = currentSize;
ConditionObject.PageIndex =currentPage;
ConditionObject.OrderKey = "${GoTable.Key.ColumnsName}";
ConditionObject.OrderType = "DESC";
IList<${Table}Object> rslist = CurrDAL.PagedDataTable(ConditionObject);
PageCount=CurrDAL.PagedTatolCount(ConditionObject);
return Json(new PageMessages2 { data = rslist, totalCount = PageCount });
}
}
catch(Exception err)
{
LogHelper.WriteLog("${Table} IndexCombox", err);
return "";
}
}
#end
private void btnExport()
{
string currfiledstr = "${currfiledstr}";
string currfileddes = "${currfileddes}";
if (!string.IsNullOrEmpty(currfiledstr))
{
currfiledstr = currfiledstr.TrimEnd(',');
${Table}Object ConditionObject = CurrGetWhereStr();
ConditionObject.Columns = currfiledstr;
ConditionObject.OrderKey = "${GoTable.Key.ColumnsName}";
ConditionObject.OrderType = "DESC";
DataTable Dt = new ${Table}Business().ExportPagedDataTable(ConditionObject);
#if($HasRelation)
if (Dt != null && Dt.Rows.Count > 0)
{
foreach (DataRow dr in Dt.Rows)
{
#foreach($tInfo in $Columns)
#if(${tInfo.ColumnsName}!="createuser"&&${tInfo.ColumnsName}!="orgid"&&${tInfo.ColumnsType}!="timestamp"&&${tInfo.SelectType}!="notexist")
#if(${tInfo.relRelation})
dr["${tInfo.ColumnsName}"] = Goblingcs.GetRealtionValue("${tInfo.relRelation.RelationTable}", "id=" + dr["${tInfo.ColumnsName}"].ToString(), "name");
#end
#end
#end
}
}
#end
ExcelHelper excel = new ExcelHelper();
excel.OutDataExcel(Dt, currfileddes,"${GoTable.TableDes}");
}
}
#foreach($currBtn in ${Buttons})
#if(${currBtn.Page}=="list")
private string ${currBtn.ButtonId}()
{
var todo = new ResultMessages();
todo.Message = "删除失败";
todo.Result = false;
try
{
}
catch(Exception err)
{
LogHelper.WriteLog("${Table} Delete", err);
return Json(todo);
}
return Json(todo);
}
#end
#end
#if($hasauth)
private string Auth()
{
var todo = new ResultMessages();
todo.Message = "确认失败";
todo.Result = false;
try
{
string ids = RequestHelper.GetFormString("ids");
using (${Table}Business CurrDAL = new ${Table}Business())
{
${Table}Object UpdateObject = new ${Table}Object();
UpdateObject.${GoTable.Key.ColumnsName}ids = ids;
UpdateObject.auth = Convert.ToByte(1);
todo.Message = "确认成功";
todo.Result = CurrDAL.Update(UpdateObject);
}
}
catch(Exception err)
{
LogHelper.WriteLog("${Table} Delete", err);
return Json(todo);
}
return Json(todo);
}
#end
#if($approvalfiled)
private string Approval()
{
var todo = new ResultMessages();
todo.Message = "审核失败";
todo.Result = false;
try
{
string ids = RequestHelper.GetFormString("ids");
using (${Table}Business CurrDAL = new ${Table}Business())
{
${Table}Object UpdateObject = new ${Table}Object();
UpdateObject.${GoTable.Key.ColumnsName}ids = ids;
UpdateObject.isapproval = Convert.ToByte(1);
todo.Message = "审核成功";
todo.Result = CurrDAL.Update(UpdateObject);
}
}
catch(Exception err)
{
LogHelper.WriteLog("${Table} Delete", err);
return Json(todo);
}
return Json(todo);
}
private string NoApproval()
{
var todo = new ResultMessages();
todo.Message = "拒绝失败";
todo.Result = false;
try
{
string ids = RequestHelper.GetFormString("ids");
using (${Table}Business CurrDAL = new ${Table}Business())
{
${Table}Object UpdateObject = new ${Table}Object();
UpdateObject.${GoTable.Key.ColumnsName}ids = ids;
UpdateObject.isapproval = Convert.ToByte(0);
todo.Message = "拒绝成功";
todo.Result = CurrDAL.Update(UpdateObject);
}
}
catch(Exception err)
{
LogHelper.WriteLog("${Table} Delete", err);
return Json(todo);
}
return Json(todo);
}
#end
#if($hasTree)
private string TreeIndex()
{
try
{
string id =RequestHelper.GetFormString("id");
using (${Table}Business CurrDAL = new ${Table}Business())
{
if (string.IsNullOrEmpty(id) || "root".Equals(id))
{
id = "0";
}
${Table}Object ConditionObject = new ${Table}Object();
#if($hasoOrg)
ConditionObject.orgid =_SessionContext.OrgID;
#end
ConditionObject.Columns = "${GoTable.Key.ColumnsName},name,fbase,sort";
DataTable dataSource = DataTableHelper.ToDataTable<${Table}Object>(CurrDAL.PagedDataTable(ConditionObject));
if (dataSource != null && dataSource.Rows.Count > 0)
{
string ss = "[" + TreeViewRecursive(dataSource, int.Parse(id)) + ")";
return ss;
}
}
}
catch (Exception err)
{
LogHelper.WriteLog("${Table} Index", err);
return string.Empty;
}
return string.Empty;
}
private string TreeViewRecursive(DataTable dataSource, int fbase)
{
StringBuilder sb = new StringBuilder();
string str = "";
string fliter = String.Format("fbase={0}", fbase);
// 查询子节点
DataRow[] drArr = dataSource.Select(fliter);
if (drArr == null || drArr.Length < 1)
{
sb.Append("");
}
else
{
foreach (DataRow dr in drArr)
{
bool haveChildren = true;
string chs = "false";
string flitersec = String.Format("fbase={0}", dr["${GoTable.Key.ColumnsName}"].ToString());
DataRow[] drArrChiled = dataSource.Select(flitersec);
if (drArrChiled == null || drArrChiled.Length < 1)
{
chs = "true";
haveChildren = false;
}
if (!haveChildren)
{
sb.Append("{\"children\":[],\"id\":" + dr["${GoTable.Key.ColumnsName}"].ToString() + ",\"leaf\":" + chs + ",\"text\":\"" + dr["name"].ToString().Trim() + "\",\"sort\":\"" + dr["sort"].ToString().Trim() + "\"},");//有子节点
}
else
{
// 递归创建子节点
sb.Append("{\"children\":[" + TreeViewRecursive(dataSource, Convert.ToInt32(dr["${GoTable.Key.ColumnsName}"])) + "),\"id\":" + dr["${GoTable.Key.ColumnsName}"].ToString() + ",\"leaf\":" + chs + ",\"text\":\"" + dr["name"].ToString().Trim() + "\",\"sort\":\"" + dr["sort"].ToString().Trim() + "\"},");//有子节点
}
// 移除已添加行,提高性能
dataSource.Rows.Remove(dr);
}
str = sb.ToString();
if (str.EndsWith(","))
{
str = str.Substring(0, str.Length - 1);
}
}
return str;
}
#end
private string FilterIndex()
{
try
{
int start = 1;
int limit = 25;
if(!string.IsNullOrEmpty(RequestHelper.GetQueryString("start")))
{
start =int.Parse(RequestHelper.GetQueryString("start"));
}
if (start != 0)
{
start = start / limit + 1;
}
else
{
start = 1;
}
using (${Table}Business CurrDAL = new ${Table}Business())
{
${Table}Object ConditionObject = CurrGetWhereStr();
int PageCount = 0;
ConditionObject.Columns ="$sqlcols${GoTable.Key.ColumnsName}";
ConditionObject.PageSize = limit;
ConditionObject.PageIndex =start;
ConditionObject.OrderKey = "${GoTable.Key.ColumnsName}";
ConditionObject.OrderType = "DESC";
IList<${Table}Object> rslist = CurrDAL.PagedDataTable(ConditionObject);
rslist = ConvertValue(rslist);
PageCount=CurrDAL.PagedTatolCount(ConditionObject);
return Json(new PageMessages3 { draw = 1, recordsTotal = PageCount, recordsFiltered = 25, data = rslist });
}
}
catch(Exception err)
{
LogHelper.WriteLog("${Table} Index", err);
return "";
}
}
private string Index()
{
try
{
int start = 1;
int limit = 25;
if(!string.IsNullOrEmpty(RequestHelper.GetQueryString("start")))
{
start =int.Parse(RequestHelper.GetQueryString("start"));
}
if (start != 0)
{
start = start / limit + 1;
}
else
{
start = 1;
}
using (${Table}Business CurrDAL = new ${Table}Business())
{
${Table}Object ConditionObject = CurrGetWhereStr();
int PageCount = 0;
#if($hasTree)
ConditionObject.Columns = "${defsqlcols}#if($defsqlcols.length()>0),#end${sqlcols}${GoTable.Key.ColumnsName},len(sort)-len(replace(sort,',','')) as codelength,sort,sort+','+CONVERT(nvarchar,${GoTable.Key.ColumnsName}) AS bpath";
ConditionObject.OrderType = "bpath";
#else
ConditionObject.Columns ="${defsqlcols}#if($defsqlcols.length()>0),#end$sqlcols${GoTable.Key.ColumnsName}";
ConditionObject.PageSize = limit;
ConditionObject.PageIndex =start;
ConditionObject.OrderKey = "${GoTable.Key.ColumnsName}";
ConditionObject.OrderType = "DESC";
#end
IList<${Table}Object> rslist = CurrDAL.PagedDataTable(ConditionObject);
rslist = ConvertValue(rslist);
PageCount=CurrDAL.PagedTatolCount(ConditionObject);
return Json(new PageMessages3 { draw = 1, recordsTotal = PageCount, recordsFiltered = 25, data = rslist });
}
}
catch(Exception err)
{
LogHelper.WriteLog("${Table} Index", err);
return "";
}
}
public IList<${Table}Object> ConvertValue(IList<${Table}Object> rslist)
{
if(rslist!=null)
{
#set($hasConvertValue=0)
#foreach($tInfo in $Columns)
#if(${tInfo.SelectType}!="notexist")
#foreach($rInfo in ${GoTable.RelRelationList})
#if($rInfo.CurrFiled==$tInfo.ColumnsName)
#set($hasConvertValue=1)
#end
#end
#end
#end
#if($hasConvertValue==1)
foreach(${Table}Object item in rslist)
{
#foreach($tInfo in $Columns)
#if(${tInfo.SelectType}!="notexist")
#foreach($rInfo in ${GoTable.RelRelationList})
#if($rInfo.CurrFiled==$tInfo.ColumnsName)
if (item.${tInfo.ColumnsName} != null)
{
item.${rInfo.RelationTable}${rInfo.CurrFiled}=Goblingcs.GetRealtionValue("${tInfo.relRelation.RelationTable}", "${tInfo.relRelation.RelatFiled}="+item.${tInfo.ColumnsName}.Value.ToString(), "name");
}
#end
#end
#end
#end
}
#end
}
return rslist;
}
#if($hasenable)
private string SetEnable()
{
string ids = RequestHelper.GetFormString("ids");
var todo = new ResultMessages();
todo.Message = "禁用/启用失败";
todo.Result = false;
try
{
//using (${Table}Business CurrDAL = new ${Table}Business())
//{
// CurrDAL.Update("enabled = enabled^1", "and ${GoTable.Key.ColumnsName} IN (" + ids.ToString()+")");
// todo.Message = "禁用/启用成功";
// todo.Result = true;
//}
}
catch(Exception err)
{
LogHelper.WriteLog("${Table} SetEnable", err);
return Json(todo);
}
return Json(todo);
}
#end
private string Details()
{
var todo = new ResultMessages();
todo.Message = "显示失败";
todo.Result = false;
try
{
int id = 0;
if(!string.IsNullOrEmpty(RequestHelper.GetFormString("id")))
{
id =int.Parse(RequestHelper.GetFormString("id"));
}
using (${Table}Business CurrDAL = new ${Table}Business())
{
${Table}Object model = CurrDAL.GetModel(id);
if (model != null)
{
#foreach($tInfo in $Columns)
#if(${tInfo.IsKey}==false)
#if(${tInfo.ColumnsName}!="lanid"&&${tInfo.ColumnsName}!="viewnum"&&${tInfo.ColumnsName}!="setcode"&&${tInfo.ColumnsName}!="lastviewtime"&&${tInfo.ColumnsName}!="updatetime"&&${tInfo.ColumnsName}!="createtime"&&${tInfo.ColumnsName}!="istop"&&${tInfo.ColumnsName}!="issys"&&${tInfo.ColumnsName}!="state"&&${tInfo.ColumnsName}!="viewtime"&&${tInfo.ColumnsName}!="createuser"&&${tInfo.ColumnsName}!="updateuser"&&${tInfo.ColumnsName}!="viewuser"&&${tInfo.ColumnsName}!="ord"&&${tInfo.ColumnsName}!="owner"&&${tInfo.ColumnsName}!="orgid"&&${tInfo.ColumnsName}!="fbase"&&${tInfo.ColumnsName}!="sort"&&${tInfo.ColumnsName}!="islock"&&${tInfo.ColumnsName}!="enabled"&&${tInfo.ColumnsName}!="issys"&&${tInfo.ColumnsName}!="baseyearmonth"&&${tInfo.ColumnsName}!="importtag"&&${tInfo.SelectType}!="FindSingle"&&${tInfo.SelectType}!="FindMulit"&&${tInfo.SelectType}!="AccountBox"&&${tInfo.SelectType}!="SelectBox"&&${tInfo.SelectType}!="SelectControl"&&${tInfo.SelectType}!="TremBox"&&${tInfo.SelectType}!="InAccountBox"&&${tInfo.SelectType}!="InTremBox")
#if(${tInfo.ColumnsType}=="timestamp")
model.hidden${tInfo.ColumnsName} = PageValidate.SetTimetamp(model.${tInfo.ColumnsName});
##文本区
#elseif((${tInfo.ColumnsType}=="varchar"&&${tInfo.ColumnsLength}==-1)||(${tInfo.ColumnsType}=="nvarchar"&&${tInfo.ColumnsLength}==-1))
model.${tInfo.ColumnsName}=PageValidate.filter(model.${tInfo.ColumnsName},1000);
##下拉列表 关联选项
#elseif(${tInfo.RelRelation})
model.${tInfo.relRelation.RelationTable}${tInfo.relRelation.CurrFiled}=Goblingcs.GetRealtionValue("${tInfo.relRelation.RelationTable}", "${tInfo.relRelation.RelatFiled}="+model.${tInfo.ColumnsName}.Value.ToString(), "name");
#elseif(${tInfo.ColumnsType}=="char"||${tInfo.ColumnsType}=="nchar")
model.${tInfo.ColumnsName}=model.${tInfo.ColumnsName}.Trim();
#end
#end
#end
#end
todo.Data = model;
todo.Message = "显示成功";
todo.Result = true;
}
}
}
catch(Exception err)
{
LogHelper.WriteLog("${Table} Details", err);
return Json(todo);
}
return Json(todo);
}
private string Create()
{
var todo = new ResultMessages();
todo.Message = "新建失败";
todo.Result = false;
bool Flag =false;
string strErr="";
try
{
int DataID = RequestHelper.GetQueryInt("id");
Int32 Userid = _SessionContext.Userid;
#foreach($tInfo in $Columns)
#if(${tInfo.IsKey}==false||(${tInfo.IsKey}&&${tInfo.relRelation}))
#if(${tInfo.ColumnsName}!="owner"&&${tInfo.ColumnsName}!="sort"&&${tInfo.ColumnsName}!="orgid"&&${tInfo.ColumnsName}!="createtime"&&${tInfo.ColumnsName}!="createuser")
#if(${tInfo.ColumnsName}=="updatetime")
#elseif(${tInfo.ColumnsName}=="lastviewtime")
#elseif(${tInfo.ColumnsName}=="viewtime")
#elseif(${tInfo.ColumnsName}=="updateuser")
#elseif(${tInfo.ColumnsName}=="viewuser")
#elseif(${tInfo.ColumnsName}=="lastlogintime")
#elseif(${tInfo.ColumnsName}=="lastloginip")
#elseif(${tInfo.ColumnsName}=="state")
#elseif(${tInfo.ColumnsName}=="commcategory")
string commcategory = string.Empty;
##Ajax表单控件
#elseif(${tInfo.SelectType}=="AjaxDynamic")
#elseif($tInfo.ColumnsName.StartsWith("is")&&${tInfo.ColumnsType}=="smallint")
#elseif($tInfo.ColumnsName.StartsWith("is")&&${tInfo.ColumnsType}=="tinyint")
##所属城市,所在区域
#elseif(${tInfo.SelectType}=="ProvinceCity"||${tInfo.SelectType}=="provincecity")
#elseif(${tInfo.ColumnsName}=="fbase")
#elseif(${tInfo.ColumnsName}=="ip")
#elseif(${tInfo.ColumnsName}=="baseyearmonth")
#elseif(${tInfo.SelectType}=="notexist")
#elseif(${tInfo.ColumnsName}=="pinyin")
string pinyin = StringTools.GetChineseSpell(name);
#elseif(${tInfo.ColumnsName}=="py")
#else
#if(${tInfo.ColumnsType}=="timestamp")
string ${tInfo.ColumnsName} =PageValidate.filter(RequestHelper.GetFormString("HiddenField${tInfo.ColumnsName}").Trim(), ${tInfo.ColumnsLength});
#else
#if((${tInfo.ColumnsType}=="varchar"&&${tInfo.ColumnsLength}==-1)||(${tInfo.ColumnsType}=="nvarchar"&&${tInfo.ColumnsLength}==-1)||${tInfo.ColumnsType}=="ntext"||${tInfo.ColumnsType}=="text")
string ${tInfo.ColumnsName} =Utils.ToHtml(PageValidate.filter(RequestHelper.GetFormString("Area${tInfo.ColumnsName}").Trim(), ${tInfo.ColumnsLength}));
#if($tInfo.isNull == false)
if (${tInfo.ColumnsName} == "")
{
todo.Message = "${tInfo.ColumnsDescription}不能为空!";
todo.Result = false;
return Json(todo);
}
#end
#elseif(${tInfo.ColumnsName}=="ip")
#elseif(${tInfo.ColumnsType}=="bit")
#elseif(${tInfo.SelectType}=="ProvinceCity"||${tInfo.SelectType}=="provincecity")
#else
#if(${tInfo.IsFile})
#if(${tInfo.ColumnsName}=="imagepaths"||${tInfo.ColumnsName}=="vediopaths"||${tInfo.ColumnsName}=="docpaths"||${tInfo.ColumnsName}=="musicpaths"||${tInfo.ColumnsName}=="flashpaths")
string ${tInfo.ColumnsName} =PageValidate.filter(RequestHelper.GetFormString("HiddenField${tInfo.ColumnsName}").Trim(), ${tInfo.ColumnsLength});
#else
string ${tInfo.ColumnsName} =PageValidate.filter(RequestHelper.GetFormString("FileUpload${tInfo.ColumnsName}.PostedFile.FileName").Trim(), ${tInfo.ColumnsLength});
if (${tInfo.ColumnsName} == "")
{
${tInfo.ColumnsName} =PageValidate.filter(RequestHelper.GetFormString("HiddenField${tInfo.ColumnsName}").Trim(), ${tInfo.ColumnsLength});
}
else
{
#if(${tInfo.ColumnsName}=="bookpaths")
${tInfo.ColumnsName} = PageValidate.UploadFiledPDFs(RequestHelper.GetFormString("FileUpload${tInfo.ColumnsName}"),Userid.ToString());
#else
HttpPostedFile FileUpload${tInfo.ColumnsName} = HttpContext.Current.Request.Files["FileUpload${tInfo.ColumnsName}"];
${tInfo.ColumnsName} = FileUpload${tInfo.ColumnsName}.FileName;
//${tInfo.ColumnsName} = Goblingcs.UploadFileds(RequestHelper.GetFormString("FileUpload${tInfo.ColumnsName}"),Userid.ToString());
#end
}
#end
#elseif(${tInfo.relRelation})
#else
#if(${tInfo.SelectType}=="Single"||${tInfo.SelectType}=="single")
string ${tInfo.ColumnsName} =PageValidate.filter(RequestHelper.GetFormString("RadioButtonList${tInfo.ColumnsName}"), ${tInfo.ColumnsLength});
#elseif(${tInfo.SelectType}=="Mulit"||${tInfo.SelectType}=="mulit")
string ${tInfo.ColumnsName} = PageValidate.filter(RequestHelper.GetFormString("CheckBoxList${tInfo.ColumnsName}"), ${tInfo.ColumnsLength});
#elseif(${tInfo.SelectType}=="Relax"||${tInfo.SelectType}=="relax")
#set($mtype="${tInfo.SelectItems}")
#foreach($tb in ${host})
#if(${tb.TableName}==${tInfo.FromText})
#set($mkey="${tb.Key.ColumnsName}")
#set($mtb="${tb.TableName}")
#end
#if(${tb.TableName}==${tInfo.FromValue})
#set($rkey="${tb.Key.ColumnsName}")
#set($rtb="${tb.TableName}")
#end
#end
string ${tInfo.ColumnsName} = PageValidate.filter(RequestHelper.GetFormString("HiddenField${tInfo.ColumnsName}").Trim(), ${tInfo.ColumnsLength});
#if($mkey!=""&&$mtb!=""&&$rkey!=""&&$rtb!="")
#if(${mtype}=="0")
#else
#end
#end
#elseif(${tInfo.SelectType}=="TreeRelax"||${tInfo.SelectType}=="treerelax")
#elseif(${tInfo.SelectType}=="Comm"||${tInfo.SelectType}=="comm"||${tInfo.SelectType}=="CommRelax"||${tInfo.SelectType}=="commrelax")
#set($sval="${tInfo.FromText}")
#set($sctrl="${tInfo.FromValue}")
#foreach($tb in ${host})
#if(${tb.TableName}==${tInfo.SelectItems})
#set($skey="${tb.Key.ColumnsName}")
#set($stb="${tb.TableName}")
#end
#end
string ${tInfo.ColumnsName} = PageValidate.filter(RequestHelper.GetFormString("HiddenField${tInfo.ColumnsName}").Trim(), ${tInfo.ColumnsLength});
#if($skey!=""&&$stb!="")
#end
#elseif(${tInfo.SelectType}=="SelectControl"||${tInfo.SelectType}=="InAccountBox"||${tInfo.SelectType}=="InTremBox")
string ${tInfo.ColumnsName} = PageValidate.filter(RequestHelper.GetFormString("HiddenField${tInfo.ColumnsName}").Trim(), ${tInfo.ColumnsLength});
#else
string ${tInfo.ColumnsName} =PageValidate.filter(RequestHelper.GetFormString("TextBox${tInfo.ColumnsName}").Trim(), ${tInfo.ColumnsLength});
#if(${tInfo.IsPassWord} == false&&${tInfo.isNull} == false)
if (${tInfo.ColumnsName} == "")
{
todo.Message = "${tInfo.ColumnsDescription}不能为空!";
todo.Result = false;
return Json(todo);
}
#end
#if(${tInfo.SelectType}=="FindMulit"||${tInfo.SelectType}=="AccountBox"||${tInfo.SelectType}=="SelectBox"||${tInfo.SelectType}=="TremBox")
string hide${tInfo.ColumnsName} = PageValidate.filter(RequestHelper.GetFormString("HiddenField${tInfo.ColumnsName}").Trim(), ${tInfo.ColumnsLength});
#end
#end
#end
#end
#end
#end
#end
#end
#end
${Table}Object model=new ${Table}Object();
##主键开始
#if(${GoTable.Key})
model.${GoTable.Key.ColumnsName}=DataID;
#end
using (${Table}Business CurrDAL = new ${Table}Business())
{
##主键结束
#foreach($tInfo in $Columns)
#if(${tInfo.IsKey}==false||(${tInfo.IsKey}&&${tInfo.relRelation}))
#if(${tInfo.ColumnsType}=="timestamp")
if (DataID>0)
{
model.${tInfo.ColumnsName}=PageValidate.GetTimetamp(${tInfo.ColumnsName});
}
#elseif(${tInfo.ColumnsName}=="viewuser")
if (#if(${GoTable.Key.ColumnsSharp}=="String") DataID =="" #else DataID==0 #end)
{
model.${tInfo.ColumnsName}=Userid;
}
#elseif(${tInfo.ColumnsName}=="owner")
model.${tInfo.ColumnsName}=Userid;
#elseif(${tInfo.ColumnsName}=="orgid")
model.${tInfo.ColumnsName}=_SessionContext.OrgID;
#elseif(${tInfo.ColumnsName}=="lastviewtime")
model.${tInfo.ColumnsName}=System.DateTime.Now;
#elseif(${tInfo.ColumnsName}=="updatetime")
model.${tInfo.ColumnsName}=System.DateTime.Now;
#elseif(${tInfo.ColumnsName}=="createtime")
if (DataID == 0)
{
model.${tInfo.ColumnsName}=System.DateTime.Now;
}
#elseif(${tInfo.ColumnsName}=="viewtime")
model.${tInfo.ColumnsName}=System.DateTime.Now;
#elseif(${tInfo.ColumnsName}=="createuser")
if (DataID == 0)
{
model.${tInfo.ColumnsName}=_SessionContext.Userid;
}
#elseif(${tInfo.ColumnsName}=="updateuser")
model.${tInfo.ColumnsName}=Userid;
#elseif(${tInfo.ColumnsName}=="viewuser")
model.${tInfo.ColumnsName}=Userid;
#elseif(${tInfo.ColumnsName}=="lastlogintime")
model.${tInfo.ColumnsName}=System.DateTime.Now;
#elseif(${tInfo.ColumnsName}=="lastloginip")
model.${tInfo.ColumnsName}=PageValidate.GetClientIP();
#elseif(${tInfo.ColumnsName}=="state")
model.${tInfo.ColumnsName}=0;
#elseif(${tInfo.ColumnsName}=="ip")
model.${tInfo.ColumnsName}=PageValidate.GetClientIP();
#elseif(${tInfo.ColumnsName}=="baseyearmonth")
model.${tInfo.ColumnsName}=_SessionContext.FanganData;
#elseif(${tInfo.SelectType}=="notexist")
#elseif(${tInfo.ColumnsName}=="py")
model.${tInfo.ColumnsName}=Chs2py.Convert(name);
#elseif($tInfo.ColumnsName.StartsWith("is")&&${tInfo.ColumnsType}=="smallint")
model.${tInfo.ColumnsName}=(short)(RequestHelper.GetFormString("CheckBox${tInfo.ColumnsName}")=="on"?1:0);
#elseif($tInfo.ColumnsName.StartsWith("is")&&${tInfo.ColumnsType}=="tinyint")
model.${tInfo.ColumnsName}= RequestHelper.GetFormString("CheckBox${tInfo.ColumnsName}")== "on" ? Convert.ToByte(1) : Convert.ToByte(0);
#elseif(${tInfo.ColumnsType}=="bit")
model.${tInfo.ColumnsName}= RequestHelper.GetFormString("CheckBox${tInfo.ColumnsName}")=="on"?true:false;
#elseif(${tInfo.SelectType}=="ProvinceCity"||${tInfo.SelectType}=="provincecity")
model.${tInfo.ColumnsName} = RequestHelper.GetFormString("sel${tInfo.ColumnsName}Province") + "-" + RequestHelper.GetFormString("sel${tInfo.ColumnsName}City");
##Ajax表单控件
#elseif(${tInfo.SelectType}=="AjaxDynamic")
#elseif(${tInfo.SelectType}=="TreeRelax"||${tInfo.SelectType}=="treerelax")
#elseif(${tInfo.ColumnsName}=="commcategory")
#elseif(${tInfo.ColumnsName}=="fbase")
String fbase = "";
if (RequestHelper.GetFormString("DropDownListfbase") != null)
{
fbase =PageValidate.filter(RequestHelper.GetFormString("DropDownList${tInfo.ColumnsName}"), ${tInfo.ColumnsLength});
}
if (string.IsNullOrEmpty(fbase))
{
fbase = "0";
}
model.${tInfo.ColumnsName}=int.Parse(fbase);
#elseif(${tInfo.ColumnsName}=="sort")
String sort ="";
if (!string.IsNullOrEmpty(fbase))
{
if (fbase == "0")
{
sort = fbase;
}
else
{
if(RequestHelper.GetFormString("fbase")==fbase)
{
${tInfo.ColumnsName} = PageValidate.filter(RequestHelper.GetFormString("sort"), ${tInfo.ColumnsLength}) + "," + fbase;
}
else
{
${tInfo.ColumnsName} =Goblingcs.GetRealtionValue("${Table}", "${GoTable.Key.ColumnsName}=" + fbase, "sort") + "," + fbase;
}
}
}
model.${tInfo.ColumnsName} =${tInfo.ColumnsName};
#else
#if($tInfo.columnsSharp=="String")
#if(${tInfo.SelectType}=="FindMulit"||${tInfo.SelectType}=="AccountBox"||${tInfo.SelectType}=="SelectBox"||${tInfo.SelectType}=="TremBox")
model.${tInfo.ColumnsName}=${tInfo.ColumnsName} + "|" + hide${tInfo.ColumnsName};
#else
#if(${tInfo.IsPassWord})
##密码控件
if (DataID == 0)
{
model.${tInfo.ColumnsName}=DEncrypt.Encrypt(${tInfo.ColumnsName});
}
#elseif(${tInfo.ColumnsName}=="authstatus")
if(#if(${GoTable.Key.ColumnsSharp}=="String") DataID =="" #else DataID==0 #end)
{
model.${tInfo.ColumnsName}="未处理";
}
else
{
model.${tInfo.ColumnsName}=${tInfo.ColumnsName};
}
#else
##其它控件
model.${tInfo.ColumnsName}=${tInfo.ColumnsName};
#end
#end
#elseif($tInfo.columnsSharp=="Byte[]")
model.${tInfo.ColumnsName} = PageValidate.GetTimetamp(${tInfo.ColumnsName});
#else
#if(${tInfo.relRelation})
##主子表同时提交,用于主表在子表中同时提交开始
#if(${tInfo.SelectType}=="FindSingle")
if (PageValidate.IsNumber(RequestHelper.GetFormString("HiddenField${tInfo.ColumnsName}")))
{
##检测是否存在name这个字段
#set($hassysdpt=false)
#set($hasrlenable=false)
#set($hasrelname=false)
#set($RHasTree=false)
#foreach($xrtb in ${host})
#if(${xrtb.TableName}==${tInfo.relRelation.RelationTable})
#set($hasrelname=false)
#set($RHasTree=false)
#foreach($xrbtInfo in ${xrtb.Cols})
#if(${xrbtInfo.ColumnsName}=="name")
#set($hasrelname=true)
#end
#if(${xrbtInfo.IsTree})
#set($RHasTree=true)
#end
#if(${xrbtInfo.ColumnsName}=="isenabled")
#set($hasrlenable=true)
#end
#if(${xrtb.TableName}!="sysdepartment"&&${xrbtInfo.IsKey}==false&&${xrbtInfo.ColumnsName}=="dptid")
#set($hassysdpt=true)
#end
#end
#end
#end
#if($hasrelname)
model.${tInfo.ColumnsName}=${tInfo.columnsSharp}.Parse(Goblingcs.BindSingleText("${tInfo.relRelation.RelationTable}", "name='" + PageValidate.filter(RequestHelper.GetFormString("TextBox${tInfo.ColumnsName}"), 300)+"'" , "${tInfo.relRelation.RelatFiled}"));
#else
model.${tInfo.ColumnsName}=${tInfo.columnsSharp}.Parse(Goblingcs.BindSingleText("${tInfo.relRelation.RelationTable}", "${tInfo.relRelation.RelatFiled}='" + PageValidate.filter(RequestHelper.GetFormString("TextBox${tInfo.ColumnsName}"), 300)+"'" , "${tInfo.relRelation.RelatFiled}"));
#end
}
else
{
model.${tInfo.ColumnsName}=0;
}
#else
#if(${tInfo.isNull} == false)
if (RequestHelper.GetFormString("DropDownList${tInfo.ColumnsName}") == null || !PageValidate.IsNumber(RequestHelper.GetFormString("DropDownList${tInfo.ColumnsName}")))
{
todo.Message = "${tInfo.ColumnsDescription}不能为空!";
todo.Result = false;
return Json(todo);
}
#end
if (RequestHelper.GetFormString("DropDownList${tInfo.ColumnsName}") != null&&PageValidate.IsNumber(RequestHelper.GetFormString("DropDownList${tInfo.ColumnsName}")))
{
model.${tInfo.ColumnsName}=${tInfo.columnsSharp}.Parse(RequestHelper.GetFormString("DropDownList${tInfo.ColumnsName}"));
}
else
{
model.${tInfo.ColumnsName}=0;
}
#end
#else
#if(${tInfo.ColumnsType}=="int"||${tInfo.ColumnsType}=="bigint"||${tInfo.ColumnsType}=="smallint"||${tInfo.ColumnsType}=="tinyint")
if (PageValidate.IsNumber(${tInfo.ColumnsName}))
{
model.${tInfo.ColumnsName}=${tInfo.columnsSharp}.Parse(${tInfo.ColumnsName});
}
else
{
model.${tInfo.ColumnsName}=0;
}
#elseif(${tInfo.ColumnsType}=="decimal"||${tInfo.ColumnsType}=="float"||${tInfo.ColumnsType}=="money"||${tInfo.ColumnsType}=="numeric"||${tInfo.ColumnsType}=="real"||${tInfo.ColumnsType}=="smallmoney")
if (PageValidate.IsDecimal(${tInfo.ColumnsName})||PageValidate.IsNumber(${tInfo.ColumnsName}))
{
model.${tInfo.ColumnsName}=${tInfo.columnsSharp}.Parse(${tInfo.ColumnsName});
}
else
{
model.${tInfo.ColumnsName}=0;
}
#elseif(${tInfo.ColumnsType}=="datetime"||${tInfo.ColumnsType}=="smalldatetime")
if (!string.IsNullOrEmpty(${tInfo.ColumnsName}) && PageValidate.IsDateTime(${tInfo.ColumnsName}))
{
model.${tInfo.ColumnsName}=${tInfo.columnsSharp}.Parse(${tInfo.ColumnsName});
}
else
{
model.${tInfo.ColumnsName}=Convert.ToDateTime("1900-01-01");
}
#else
model.${tInfo.ColumnsName}=${tInfo.columnsSharp}.Parse(${tInfo.ColumnsName});
#end
#end
#end
##检测代码
## /// 全局唯一
## /// 用户唯一
## /// 组织唯一
## /// 部门唯一
##CheckOnlyOne
##ZdyCheckCondition
##CheckValueMsg
##ValiRegex验证规则
##ValiRegexMsg验证提示
#if(${tInfo.CheckOnlyOne}=="全局唯一"||${tInfo.CheckOnlyOne}=="用户唯一"||${tInfo.CheckOnlyOne}=="组织唯一"||${tInfo.CheckOnlyOne}=="部门唯一")
if (DataID > 0)
{
if (CurrDAL.HasSingle${tInfo.ColumnsName}A(model.${tInfo.ColumnsName}#if(${tInfo.ColumnsType}=="int"||${tInfo.ColumnsType}=="decimal"||${tInfo.ColumnsType}=="money"||${tInfo.ColumnsType}=="numeric"||${tInfo.ColumnsType}=="smallint"||${tInfo.ColumnsType}=="smallmoney"||${tInfo.ColumnsType}=="float"||${tInfo.ColumnsType}=="bigint"||${tInfo.ColumnsType}=="real"||${tInfo.ColumnsType}=="tinyint"||${tInfo.ColumnsType}=="bit"||${tInfo.ColumnsType}=="datetime"||${tInfo.ColumnsType}=="smalldatetime").Value#end, model.${GoTable.Key.ColumnsName}#if(${GoTable.Key.ColumnsType}=="int"||${GoTable.Key.ColumnsType}=="decimal"||${GoTable.Key.ColumnsType}=="money"||${GoTable.Key.ColumnsType}=="numeric"||${GoTable.Key.ColumnsType}=="smallint"||${GoTable.Key.ColumnsType}=="smallmoney"||${GoTable.Key.ColumnsType}=="float"||${GoTable.Key.ColumnsType}=="bigint"||${GoTable.Key.ColumnsType}=="real"||${GoTable.Key.ColumnsType}=="tinyint"||${GoTable.Key.ColumnsType}=="bit"||${GoTable.Key.ColumnsType}=="datetime"||${GoTable.Key.ColumnsType}=="smalldatetime").Value#end) > 0)
{
todo.Message = "${tInfo.CheckValueMsg}";
todo.Result = false;
return Json(todo);
}
}
else
{
if (CurrDAL.HasSingle${tInfo.ColumnsName}(model.${tInfo.ColumnsName}#if(${tInfo.ColumnsType}=="int"||${tInfo.ColumnsType}=="decimal"||${tInfo.ColumnsType}=="money"||${tInfo.ColumnsType}=="numeric"||${tInfo.ColumnsType}=="smallint"||${tInfo.ColumnsType}=="smallmoney"||${tInfo.ColumnsType}=="float"||${tInfo.ColumnsType}=="bigint"||${tInfo.ColumnsType}=="real"||${tInfo.ColumnsType}=="tinyint"||${tInfo.ColumnsType}=="bit"||${tInfo.ColumnsType}=="datetime"||${tInfo.ColumnsType}=="smalldatetime").Value#end) > 0)
{
todo.Message = "${tInfo.CheckValueMsg}";
todo.Result = false;
return Json(todo);
}
}
#end
#if(${tInfo.ValiRegex}&&${tInfo.ValiRegex}!="")
if (!PageValidate.IsRegexSuccess("${tInfo.ValiRegex}",model.${tInfo.ColumnsName}#if(${tInfo.ColumnsType}=="int"||${tInfo.ColumnsType}=="decimal"||${tInfo.ColumnsType}=="money"||${tInfo.ColumnsType}=="numeric"||${tInfo.ColumnsType}=="smallint"||${tInfo.ColumnsType}=="smallmoney"||${tInfo.ColumnsType}=="float"||${tInfo.ColumnsType}=="bigint"||${tInfo.ColumnsType}=="real"||${tInfo.ColumnsType}=="tinyint"||${tInfo.ColumnsType}=="bit"||${tInfo.ColumnsType}=="datetime"||${tInfo.ColumnsType}=="smalldatetime").Value#end))
{
todo.Message = "${tInfo.ValiRegexMsg}";
todo.Result = false;
return Json(todo);
}
#end
##
#end
#end
#end
#if(${GoTable.Key})
if (strErr == "")
{
#if($hasrelbit||$bitflag)
if (#if(${GoTable.Key.ColumnsSharp}=="String") DataID !="" #else DataID > 0 #end)
{
if(CurrDAL.BitUpdate(model))
{
Flag = true;
//ToLog(4, "${Table}", DataID.ToString());
}
}
else
{
#if(${SmallTable}=="sysmodule"||${SmallTable}=="sysfileds"||${SmallTable}=="workflow")
model.id = CurrDAL.BitAdd(model);
if (model.id > 0)
#else
if (CurrDAL.BitAdd(model) > 0)
#end
{
Flag = true;
//ToLog(3, "${Table}", DataID.ToString());
}
}
#else
if (#if(${GoTable.Key.ColumnsSharp}=="String") DataID !="" #else DataID > 0 #end)
{
if (CurrDAL.Update(model))
{
Flag = true;
//ToLog(4, "${Table}", DataID.ToString());
}
}
else
{
#if(${SmallTable}=="sysmodule"||${SmallTable}=="sysfileds"||${SmallTable}=="workflow")
model.id = CurrDAL.Add(model);
if (model.id > 0)
#else
if (CurrDAL.Add(model) > 0)
#end
{
Flag = true;
//ToLog(3, "${Table}", DataID.ToString());
}
}
#end
}
#if($issysreport&&$issysreportfileds&&$issysfileds&&$issysbuttons&&$issysmodule&&$issyspagepart&&$issysfiledsinpart&&$isworkflow)
#if(${SmallTable}=="sysmodule"||${SmallTable}=="sysfileds"||${SmallTable}=="workflow")
if (Flag)
{
Building.Build(#if(${SmallTable}=="sysmodule")model.id.Value#else model.moduleid.Value #end, Server.MapPath("~/admin/tempfile"), Server.MapPath("~/admin/"));
}
#end
#end
#end
}
if (Flag)
{
todo.Message = "保存成功";
todo.Result = true;
return Json(todo);
}
else
{
if (string.IsNullOrEmpty(strErr))
{
todo.Message = "操作失效,请重新录入";
todo.Result = true;
return Json(todo);
}
else
{
todo.Message = strErr;
todo.Result = true;
return Json(todo);
}
}
}
catch(Exception err)
{
LogHelper.WriteLog("${Table} btnAdd_Click", err);
todo.Message = err.Message.ToString().Replace("'", "\\'").Replace("\r\n", "\\r\\n");
todo.Result = true;
return Json(todo);
}
}
private ${Table}Object CurrGetWhereStr()
{
${Table}Object ConditionObject = new ${Table}Object();
#set($parenthasTree=false)
#foreach($tRel in ${GoTable.RelRelationList})
#foreach($tb in ${host})
#if(${tb.TableType}==2)
#if(${tb.TableName}==${tRel.RelationTable})
#foreach($currInfo in ${tb.Cols})
#if(${currInfo.IsKey}==false)
#if(${currInfo.IsTree})
#set($parenthasTree=true)
#end
#end
#end
#if($parenthasTree)
if (!string.IsNullOrEmpty(RequestHelper.GetFormString("${tRel.RelatFiled}")))
{
if (RequestHelper.GetFormString("${tRel.RelatFiled}").ToString() != "0")
{
//ConditionObject.${tRel.RelatFiled} = RequestHelper.GetFormString("${tRel.RelatFiled}").ToString();
}
}
#end
#end
#end
#end
#end
#if(${GoTable.IsUser})
##用户的权限控制
##表中不存在roleid并且表中有createuser
#if($hasuserid==true&&$hasroleid==false)
if (_SessionContext != null&&_SessionContext.JsID!=1)
{
//strWhere.AppendFormat(" AND ((Rolefbase={0} AND Accountsdptid={1}) OR createuser={2} #if($hasowner) OR owner={2} #end)", _SessionContext.JsID.ToString(), _SessionContext.StrustsID.ToString(), _SessionContext.Userid.ToString());
//修改去除查看转换数据
//strWhere.AppendFormat(" AND ((Rolefbase={0} AND Accountsdptid={1}) #if($hasowner) OR owner={2} #end)", _SessionContext.JsID.ToString(), _SessionContext.StrustsID.ToString(), _SessionContext.Userid.ToString());
}
#end
#end
##简单查询
#set($chindex=1)
#set($ttable="")
#foreach($tInfo in $Columns)
#if(${tInfo.IsKey}==false)
#set($tfileds=$tInfo)
#set($ttable="")
#if(${tfileds.SelectType}=="InAccountBox")
ConditionObject.${tfileds.ColumnsName}Condition=string.Format(" AND (','+${tfileds.ColumnsName}+',' LIKE ',0|'+convert(nvarchar,{0})+',%' OR ','+${tfileds.ColumnsName}+',' LIKE ',1|'+convert(nvarchar,{1})+',%') ",_SessionContext.Userid.ToString(), _SessionContext.JsID.ToString());
#end
#if(${tfileds.ColumnsName}=="YearMonth")
ConditionObject.${tfileds.ColumnsName}Condition=string.Format(" AND convert(nvarchar(7),${tfileds.ColumnsName},120)=convert(nvarchar(7),'{0}',120)", _SessionContext.FanganData.ToString("yyyy-MM-dd"));
#end
#if(${tfileds.ColumnsName}=="state")
#if($hasstate)
ConditionObject.state = Convert.ToByte(RequestHelper.GetFormString("HiddenIsdel").Trim());
#else
ConditionObject.state = 0;
#end
#end
#if((${GoTable.IsUser}==false||(${GoTable.IsUser}&&${tInfo.SelectType}=="search"))&&${tInfo.isNull}== false&&${tInfo.ColumnsName}!="id"&&${tInfo.ColumnsName}!="mark"&&${tInfo.ColumnsName}!="isenabled"&&${tInfo.ColumnsName}!="ord"&&${tInfo.ColumnsName}!="state"&&${tInfo.ColumnsName}!="updatetime"&&${tInfo.ColumnsName}!="updateuser"&&${tInfo.ColumnsName}!="viewnum"&&${tInfo.ColumnsName}!="owner"&&${tInfo.ColumnsName}!="createtime"&&${tInfo.ColumnsName}!="createuser"&&${tInfo.ColumnsType}!="timestamp"&&${tInfo.ColumnsName}!="password"&&${tInfo.SelectType}!="notexist"&&${tInfo.SelectType}!="FindMulit"&&${tInfo.SelectType}!="AccountBox"&&${tInfo.SelectType}!="SelectBox"&&${tInfo.SelectType}!="SelectControl"&&${tInfo.SelectType}!="TremBox"&&${tInfo.SelectType}!="InAccountBox"&&${tInfo.SelectType}!="InTremBox")
##主表开始
#if(${tfileds.relRelation})
if (!string.IsNullOrEmpty(RequestHelper.GetFormString("TextBox${tfileds.ColumnsName}").Trim()))
{
string ${tfileds.ColumnsName} = Goblingcs.GetRealtionValue("${tfileds.relRelation.RelationTable}", "name='" + PageValidate.filter(RequestHelper.GetFormString("TextBox${tfileds.ColumnsName}").Trim(), 100) + "'", "${tfileds.relRelation.RelatFiled}");
if (!string.IsNullOrEmpty(${tfileds.ColumnsName}) && PageValidate.IsNumber(${tfileds.ColumnsName}))
{
ConditionObject.${tfileds.ColumnsName} = int.Parse(${tfileds.ColumnsName});
}
else
{
ConditionObject.${tfileds.ColumnsName} =0;
}
}
#elseif(${tfileds.ColumnsType}=="timestamp")
#elseif(${tfileds.ColumnsName}=="orgid")
#if($hasoOrg&&$hasuserid)
if (_SessionContext.JsID == 1)
{
ConditionObject.orgid = _SessionContext.OrgID;
}
else
{
ConditionObject.orgidCondition = " AND state=0 and (createuser=" + _SessionContext.Userid.ToString() + " or createuser in (SELECT [id] FROM [sysaccounts] where roleid in (SELECT [id] FROM [sysrole] where sort like ''+(SELECT [sort] FROM [sysrole] where id=" + _SessionContext.JsID.ToString() + ")+',%')))";
ConditionObject.orgid = _SessionContext.OrgID;
}
#else
#if($hasoOrg)
if (_SessionContext.JsID == 1)
{
ConditionObject.orgid = _SessionContext.OrgID;
}
else
{
ConditionObject.orgidCondition = " AND state=0 and (createuser=" + _SessionContext.Userid.ToString() + " or createuser in (SELECT [id] FROM [sysaccounts] where roleid in (SELECT [id] FROM [sysrole] where sort like ''+(SELECT [sort] FROM [sysrole] where id=" + _SessionContext.JsID.ToString() + ")+',%')))";
ConditionObject.orgid = _SessionContext.OrgID;
}
#end
#end
#elseif(${tfileds.ColumnsName}=="name")
if (!string.IsNullOrEmpty(RequestHelper.GetFormString("TextBox${tfileds.ColumnsName}").Trim()))
{
ConditionObject.like${tfileds.ColumnsName} = PageValidate.filter(RequestHelper.GetFormString("TextBox${tfileds.ColumnsName}").Trim(), ${tfileds.ColumnsLength});
}
#elseif(${tfileds.ColumnsName}=="commcategory")
#elseif(${tfileds.SelectType}=="AjaxDynamic")
#elseif(${tfileds.SelectType}=="ProvinceCity"||${tfileds.SelectType}=="provincecity")
if (!string.IsNullOrEmpty(RequestHelper.GetFormString("sel${ttable}${tfileds.ColumnsName}Province").Trim()))
{
ConditionObject.${tfileds.ColumnsName} = PageValidate.filter(RequestHelper.GetFormString("sel${ttable}${tfileds.ColumnsName}Province").Trim(), ${tfileds.ColumnsLength});
}
if (!string.IsNullOrEmpty(RequestHelper.GetFormString("sel${ttable}${tfileds.ColumnsName}City").Trim()))
{
ConditionObject.${tfileds.ColumnsName} = PageValidate.filter(RequestHelper.GetFormString("sel${ttable}${tfileds.ColumnsName}City").Trim(), ${tfileds.ColumnsLength});
}
#elseif(${tfileds.FromType}=="table"&&(${tfileds.SelectType}=="Single"||${tfileds.SelectType}=="single"))
if (!string.IsNullOrEmpty(RequestHelper.GetFormString("RadioButtonList${tfileds.ColumnsName}").Trim()))
{
#if($tfileds.columnsSharp=="String")
ConditionObject.${tfileds.ColumnsName} = PageValidate.filter(RequestHelper.GetFormString("RadioButtonList${tfileds.ColumnsName}").Trim(), ${tfileds.ColumnsLength});
#elseif(${tfileds.ColumnsType}=="tinyint")
ConditionObject.${tfileds.ColumnsName} = PageValidate.filter(RequestHelper.GetFormString("RadioButtonList${tfileds.ColumnsName}").Trim(), ${tfileds.ColumnsLength})=="0"?Convert.ToByte(0):Convert.ToByte(1);
#else
ConditionObject.${tfileds.ColumnsName} = ${tfileds.columnsSharp}.Parse(PageValidate.filter(RequestHelper.GetFormString("RadioButtonList${tfileds.ColumnsName}").Trim(), ${tfileds.ColumnsLength}));
#end
}
#elseif(${tfileds.FromType}=="table"&&(${tfileds.SelectType}=="Mulit"||${tfileds.SelectType}=="mulit"))
if (!string.IsNullOrEmpty(RequestHelper.GetFormString("CheckBoxList${tfileds.ColumnsName}").Trim()))
{
ConditionObject.${tfileds.ColumnsName} = PageValidate.filter(CheckBoxList${tInfo.ColumnsName}, ${tInfo.ColumnsLength});
}
#elseif(${tfileds.SelectType}=="Mulit"||${tfileds.SelectType}=="mulit")
if (!string.IsNullOrEmpty(RequestHelper.GetFormString("CheckBoxList${tfileds.ColumnsName}").Trim()))
{
ConditionObject.${tfileds.ColumnsName} = PageValidate.filter(CheckBoxList${tInfo.ColumnsName}, ${tInfo.ColumnsLength});
}
#elseif(${tfileds.SelectType}=="Single"||${tfileds.SelectType}=="single")
if (!string.IsNullOrEmpty(RequestHelper.GetFormString("RadioButtonList${tfileds.ColumnsName}").Trim()))
{
#if($tfileds.columnsSharp=="String")
ConditionObject.${tfileds.ColumnsName} = PageValidate.filter(RequestHelper.GetFormString("RadioButtonList${tfileds.ColumnsName}").Trim(), ${tfileds.ColumnsLength});
#elseif(${tfileds.ColumnsType}=="tinyint")
ConditionObject.${tfileds.ColumnsName} = PageValidate.filter(RequestHelper.GetFormString("RadioButtonList${tfileds.ColumnsName}").Trim(), ${tfileds.ColumnsLength})=="0"?Convert.ToByte(0):Convert.ToByte(1);
#else
ConditionObject.${tfileds.ColumnsName} = ${tfileds.columnsSharp}.Parse(PageValidate.filter(RequestHelper.GetFormString("RadioButtonList${tfileds.ColumnsName}").Trim(), ${tfileds.ColumnsLength}));
#end
}
#elseif(${tfileds.SelectType}=="Relax"||${tfileds.SelectType}=="relax")
#elseif(${tfileds.SelectType}=="Comm"||${tfileds.SelectType}=="comm"||${tfileds.SelectType}=="CommRelax"||${tfileds.SelectType}=="commrelax")
#elseif(${tfileds.SelectType}=="SelectControl"||${tfileds.SelectType}=="InAccountBox"||${tfileds.SelectType}=="InTremBox")
#elseif(${tfileds.IsFile})
#elseif(${tfileds.ColumnsName}=="BrushAS3"||${tfileds.ColumnsName}=="BrushBash"||${tfileds.ColumnsName}=="BrushColdFusion"||${tfileds.ColumnsName}=="BrushCSharp"||${tfileds.ColumnsName}=="BrushCpp"||${tfileds.ColumnsName}=="BrushCss"||${tfileds.ColumnsName}=="BrushDelphi"||${tfileds.ColumnsName}=="BrushDiff"||${tfileds.ColumnsName}=="BrushErlang"||${tfileds.ColumnsName}=="BrushGroovy"||${tfileds.ColumnsName}=="BrushJScript"||${tfileds.ColumnsName}=="BrushJava"||${tfileds.ColumnsName}=="BrushJavaFX"||${tfileds.ColumnsName}=="BrushPerl"||${tfileds.ColumnsName}=="BrushPhp"||${tfileds.ColumnsName}=="BrushPlain"||${tfileds.ColumnsName}=="BrushPowerShell"||${tfileds.ColumnsName}=="BrushPython"||${tfileds.ColumnsName}=="BrushRuby"||${tfileds.ColumnsName}=="BrushScala"||${tfileds.ColumnsName}=="BrushSql"||${tfileds.ColumnsName}=="BrushVb"||${tfileds.ColumnsName}=="BrushXml")
## if (!string.IsNullOrEmpty(this.Area${tfileds.ColumnsName}.Value))
## {
## Trem = Trem + " AND ${tfileds.ColumnsName}='" + PageValidate.filter(RequestHelper.GetFormString("Area${tfileds.ColumnsName}").Trim(), ${tfileds.ColumnsLength})+ "'";
## }
#elseif(${tfileds.SelectType}=="FindMulit"||${tfileds.SelectType}=="TremBox"||${tfileds.SelectType}=="SelectBox"||${tfileds.SelectType}=="AccountBox")
if (!string.IsNullOrEmpty(RequestHelper.GetFormString("TextBox${tfileds.ColumnsName}").Trim()))
{
ConditionObject.${tfileds.ColumnsName} = PageValidate.filter(RequestHelper.GetFormString("TextBox${tfileds.ColumnsName}").Trim(), ${tfileds.ColumnsLength});
}
#elseif((${tfileds.ColumnsType}=="varchar"&&${tfileds.ColumnsLength}==-1)||(${tfileds.ColumnsType}=="nvarchar"&&${tfileds.ColumnsLength}==-1)||${tfileds.ColumnsType}=="ntext"||${tfileds.ColumnsType}=="text")
## if (!string.IsNullOrEmpty(this.Area${tfileds.ColumnsName}.Value))
## {
## Trem = Trem + " AND ${tfileds.ColumnsName}='" + PageValidate.filter(RequestHelper.GetFormString("Area${tfileds.ColumnsName}").Trim(), ${tfileds.ColumnsLength})+ "'";
## }
#elseif(${tfileds.ColumnsName}=="baseyearmonth"||${tfileds.SelectType}=="notexist")
#elseif(${tfileds.ColumnsType}=="bit"||($tfileds.ColumnsName.StartsWith("is")&&${tfileds.ColumnsType}=="smallint")||($tfileds.ColumnsName.StartsWith("is")&&${tfileds.ColumnsType}=="tinyint"))
#if(${tfileds.ColumnsName}!="islock"&&${tfileds.ColumnsName}!="authstatus"&&${tfileds.ColumnsName}!="issys")
if (!string.IsNullOrEmpty(RequestHelper.GetFormString("DropDownList${tfileds.ColumnsName}").Trim()))
{
#if(${tfileds.ColumnsType}=="bit")
ConditionObject.${tfileds.ColumnsName} = PageValidate.filter(RequestHelper.GetFormString("DropDownList${tfileds.ColumnsName}").Trim(), ${tfileds.ColumnsLength}) == "是" ? true : false;
#else
ConditionObject.${tfileds.ColumnsName} = PageValidate.filter(RequestHelper.GetFormString("DropDownList${tfileds.ColumnsName}").Trim(), ${tfileds.ColumnsLength}) == "是" ? Convert.ToByte(1) : Convert.ToByte(0);
#end
}
#end
#elseif(${tfileds.ColumnsType}=="datetime"||${tfileds.ColumnsType}=="smalldatetime")
if (!string.IsNullOrEmpty(RequestHelper.GetFormString("TextBox${tfileds.ColumnsName}Start").Trim()))
{
ConditionObject.${tfileds.ColumnsName}Start = DateTime.Parse(PageValidate.filter(RequestHelper.GetFormString("TextBox${tfileds.ColumnsName}Start").Trim(), ${tfileds.ColumnsLength}));
}
if (!string.IsNullOrEmpty(RequestHelper.GetFormString("TextBox${tfileds.ColumnsName}End").Trim()))
{
ConditionObject.${tfileds.ColumnsName}End = DateTime.Parse(PageValidate.filter(RequestHelper.GetFormString("TextBox${tfileds.ColumnsName}End").Trim(), ${tfileds.ColumnsLength}));
}
#elseif(${tfileds.ColumnsType}=="int")
if (!string.IsNullOrEmpty(RequestHelper.GetFormString("TextBox${tfileds.ColumnsName}").Trim()))
{
ConditionObject.${tfileds.ColumnsName} = int.Parse(PageValidate.filter(RequestHelper.GetFormString("TextBox${tfileds.ColumnsName}").Trim(), ${tfileds.ColumnsLength}));
}
#elseif(${tfileds.ColumnsType}=="bigint")
if (!string.IsNullOrEmpty(RequestHelper.GetFormString("TextBox${tfileds.ColumnsName}").Trim()))
{
ConditionObject.${tfileds.ColumnsName} = Int64.Parse(PageValidate.filter(RequestHelper.GetFormString("TextBox${tfileds.ColumnsName}").Trim(), ${tfileds.ColumnsLength}));
}
#elseif(${tfileds.ColumnsType}=="smallint")
if (!string.IsNullOrEmpty(RequestHelper.GetFormString("TextBox${tfileds.ColumnsName}").Trim()))
{
ConditionObject.${tfileds.ColumnsName} = Int16.Parse(PageValidate.filter(RequestHelper.GetFormString("TextBox${tfileds.ColumnsName}").Trim(), ${tfileds.ColumnsLength}));
}
#elseif(${tfileds.ColumnsType}=="tinyint")
if (!string.IsNullOrEmpty(RequestHelper.GetFormString("TextBox${tfileds.ColumnsName}").Trim()))
{
ConditionObject.${tfileds.ColumnsName} = PageValidate.filter(RequestHelper.GetFormString("TextBox${tfileds.ColumnsName}").Trim(), ${tfileds.ColumnsLength})== "0" ? Convert.ToByte(0) : Convert.ToByte(1);
}
#elseif(${tfileds.ColumnsType}=="decimal"||${tfileds.ColumnsType}=="money"||${tfileds.ColumnsType}=="smallmoney")
if (!string.IsNullOrEmpty(RequestHelper.GetFormString("TextBox${tfileds.ColumnsName}").Trim()))
{
ConditionObject.${tfileds.ColumnsName} = Decimal.Parse(PageValidate.filter(RequestHelper.GetFormString("TextBox${tfileds.ColumnsName}").Trim(), ${tfileds.ColumnsLength}));
}
#elseif(${tfileds.ColumnsType}=="float")
if (!string.IsNullOrEmpty(RequestHelper.GetFormString("TextBox${tfileds.ColumnsName}").Trim()))
{
ConditionObject.${tfileds.ColumnsName} = Double.Parse(PageValidate.filter(RequestHelper.GetFormString("TextBox${tfileds.ColumnsName}").Trim(), ${tfileds.ColumnsLength}));
}
#elseif(${tfileds.ColumnsType}=="double")
if (!string.IsNullOrEmpty(RequestHelper.GetFormString("TextBox${tfileds.ColumnsName}").Trim()))
{
ConditionObject.${tfileds.ColumnsName} = Double.Parse(PageValidate.filter(RequestHelper.GetFormString("TextBox${tfileds.ColumnsName}").Trim(), ${tfileds.ColumnsLength}));
}
#elseif(${tfileds.ColumnsType}=="numeric")
if (!string.IsNullOrEmpty(RequestHelper.GetFormString("TextBox${tfileds.ColumnsName}").Trim()))
{
ConditionObject.${tfileds.ColumnsName} = Decimal.Parse(PageValidate.filter(RequestHelper.GetFormString("TextBox${tfileds.ColumnsName}").Trim(), ${tfileds.ColumnsLength}));
}
#elseif(${tfileds.ColumnsType}=="real")
if (!string.IsNullOrEmpty(RequestHelper.GetFormString("TextBox${tfileds.ColumnsName}").Trim()))
{
ConditionObject.${tfileds.ColumnsName} = Single.Parse(PageValidate.filter(RequestHelper.GetFormString("TextBox${tfileds.ColumnsName}").Trim(), ${tfileds.ColumnsLength}));
}
#elseif(${tfileds.IsPassWord})
if (!string.IsNullOrEmpty(RequestHelper.GetFormString("TextBox${tfileds.ColumnsName}").Trim()))
{
ConditionObject.${tfileds.ColumnsName} = PageValidate.filter(RequestHelper.GetFormString("TextBox${tfileds.ColumnsName}").Trim(), ${tfileds.ColumnsLength});
}
#else
if (!string.IsNullOrEmpty(RequestHelper.GetFormString("TextBox${tfileds.ColumnsName}").Trim()))
{
ConditionObject.${tfileds.ColumnsName} = PageValidate.filter(RequestHelper.GetFormString("TextBox${tfileds.ColumnsName}").Trim(), ${tfileds.ColumnsLength});
}
##主表开始
##
#end
#end
#end
#end
##简单查询
return ConditionObject;
}
private string Delete()
{
var todo = new ResultMessages();
todo.Message = "删除失败";
todo.Result = false;
try
{
string ids = RequestHelper.GetFormString("ids");
using (${Table}Business CurrDAL = new ${Table}Business())
{
${Table}Object UpdateObject = new ${Table}Object();
UpdateObject.${GoTable.Key.ColumnsName}ids = ids;
#if($hasstate==true)UpdateObject.state = Convert.ToByte(1);#end
todo.Message = "删除成功";
todo.Result = CurrDAL.Update(UpdateObject);
}
}
catch(Exception err)
{
LogHelper.WriteLog("${Table} Delete", err);
return Json(todo);
}
return Json(todo);
}
}
}