private void BindGrid()
{
if (roleId > 0)
{
try
{
StringBuilder condition = new StringBuilder("WHERE U_DISABLED=0"); //去除用户为系统管理员
condition.AppendFormat(" AND (SELECT COUNT(*) AS num FROM [S_ROLE_USER] b WHERE b.U_ID=a.U_ID AND R_ID={0})=0", roleId);
string name = StringHelper.ClearSqlStringExSpace(ttbSearchUser.Text.Trim());
if (name.Length > 0)
{
condition.AppendFormat(" AND (U_NAME like'%{0}%' OR U_REALNAME like'%{0}%')", name);
}
int recordCount = 0;
using (DataTable dt = SqlPagerHelper.GetTableByCondition(DefaultConnection.ConnectionStringByDefaultDB, "U_ID,U_NAME,U_REALNAME,U_EMAIL,U_MOBILE", "[S_USER] a", condition.ToString(), "ORDER BY U_ID ASC", Grid1.PageIndex + 1, Grid1.PageSize, out recordCount))
{
Grid1.RecordCount = recordCount;
Grid1.DataSource = dt;
Grid1.DataBind();
}
}
catch (Exception ex)
{
logger.Error("S.R.AddUser.BindGrid():Exception", ex);
Alert.ShowInParent("系统错误。");
}
// 重新绑定表格数据之后，更新选中行
FineUIGridCommon.UpdateSelectedRowIndexArray(hfSelectedIDS, Grid1);
}
else
{
// 参数错误，首先弹出Alert对话框然后关闭弹出窗口
Alert.Show("参数错误！", String.Empty, ActiveWindow.GetHideReference());
}
}
private void InitUserRole()
{
if (id > 0)
{
StringBuilder sbValue = new StringBuilder();
StringBuilder sbText = new StringBuilder();
//初始化角色复选框列表的选择项
using (DataTable dt = SqlPagerHelper.GetTableByCondition(DefaultConnection.ConnectionStringByDefaultDB, "b.R_ID,b.R_NAME", "[S_ROLE_USER] a JOIN [S_ROLE] b ON a.R_ID=b.R_ID", "WHERE U_ID=" + id, "ORDER BY a.R_ID ASC"))
{
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow role in dt.Rows)
{
sbValue.AppendFormat("{0},", role["R_ID"]);
sbText.AppendFormat("{0}，", role["R_NAME"]);
}
string roleValues = sbValue.ToString().TrimEnd(',');
string roleTexts = sbText.ToString().TrimEnd('，');
tbSelectedRole.Text = roleTexts;
hfSelectedRole.Text = roleValues;
}
}
}
string selectRoleURL = String.Format("SelectRole.aspx?ids=<script>{0}</script>", hfSelectedRole.GetValueReference());
tbSelectedRole.OnClientTriggerClick = Window2.GetSaveStateReference(hfSelectedRole.ClientID, tbSelectedRole.ClientID)
+ Window2.GetShowReference(selectRoleURL, "选择用户所属的角色");
}
//页面数据加载
private void BindData()
{
try
{
StringBuilder condition = new StringBuilder();
if (string.IsNullOrEmpty(this.ttbSearchUser.Text))
{
condition.Append("");
}
else
{
condition.Append(" where CName like'%" + this.ttbSearchUser.Text + "%' ");
}
int recordCount = 0;
using (DataTable dt = SqlPagerHelper.GetTableByCondition(DefaultConnection.ConnectionStringByDefaultDB, "*", "[view_person]", condition.ToString(), "ORDER BY CName asc", Grid1.PageIndex + 1, Grid1.PageSize, out recordCount))
{
Grid1.RecordCount = recordCount;
Grid1.DataSource = dt;
Grid1.DataBind();
FineUIGridCommon.UpdateSelectedRowIndexArray(hides, Grid1);
}
}
catch (Exception ex)
{
logger.Error("X.MessageList.BindData():Exception", ex);
Alert.ShowInParent("系统错误。");
}
}
private void BindData()
{
try
{
StringBuilder condition = new StringBuilder("WHERE 1=1"); //去除用户为系统管理员
string name = StringHelper.ClearSqlStringExSpace(ttbSearchUser.Text.Trim());
if (name.Length > 0)
{
condition.AppendFormat(" AND (U_NAME like'%{0}%' OR U_REALNAME like'%{0}%')", name);
}
string orderExp = "ORDER BY " + Grid1.SortField + " " + Grid1.SortDirection;
int recordCount = 0;
using (DataTable dt = SqlPagerHelper.GetTableByCondition(DefaultConnection.ConnectionStringByDefaultDB, "U_ID,U_NAME,U_REALNAME,U_DISABLED,U_EMAIL,U_MOBILE,U_TEL,U_PREVLOGINTIME,U_PREVLOGINIP", "[S_USER]", condition.ToString(), orderExp, Grid1.PageIndex + 1, Grid1.PageSize, out recordCount))
{
Grid1.RecordCount = recordCount;
Grid1.DataSource = dt;
Grid1.DataBind();
}
}
catch (Exception ex)
{
logger.Error("S.U.Manage.BindData():Exception", ex);
Alert.ShowInParent("系统错误。");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
int mid = RequestHelper.GetQueryInt("menu", 0);
if (mid > 0)
{
cookie = new RABCCookie();
if (cookie == null)
{
return;
}
if (cookie.UserName.Length == 0)
{
return;
}
if (cookie.PurviewCodes.Length == 0)
{
return;
}
code = cookie.PurviewCodes;
using (DataTable dt = SqlPagerHelper.GetTableByCondition(DefaultConnection.ConnectionStringByDefaultDB, "M_ID,M_PARENTID,M_NAME,M_CODE,M_LINK,M_ICON", "[S_MENU]", "WHERE M_ID<>" + mid + " AND M_PATH like '%," + mid + ",%' AND M_DISABLED=0", "ORDER BY M_ORDERID ASC"))
{
if (dt != null && dt.Rows.Count > 0)
{
var source = dt.AsEnumerable();
ResolveSubTree(source, null, mid);
}
}
}
}
}
private void LoadFirstMenu()
{
using (DataTable dt = SqlPagerHelper.GetTableByCondition(DefaultConnection.ConnectionStringByDefaultDB, "M_ID,M_NAME,M_CODE", "[S_MENU]", "where M_PARENTID=0 AND M_DISABLED=0", "ORDER BY M_ORDERID ASC"))
{
if (dt != null && dt.Rows.Count > 0)
{
int index = 0;
for (int i = 0, count = dt.Rows.Count; i < count; i++)
{
if (VerifyPurview("," + dt.Rows[i]["M_CODE"] + ","))
{
if (index == 0)
{
Region2.IFrameUrl = "/leftmenu.aspx?menu=" + dt.Rows[i]["M_ID"];
menu.AppendFormat("<li class=\"on top_menu menu-{0}\"><a href=\"javascript:;\">{1}</a></li>", dt.Rows[i]["M_ID"], dt.Rows[i]["M_NAME"]);
}
else
{
menu.AppendFormat("<li class=\"top_menu menu-{0}\"><a href=\"javascript:;\">{1}</a></li>", dt.Rows[i]["M_ID"], dt.Rows[i]["M_NAME"]);
}
index++;
}
}
}
}
}
private void BindGrid2()
{
try
{
if (roleId > 0)
{
using (DataTable dt = SqlPagerHelper.GetTableByCondition(DefaultConnection.ConnectionStringByDefaultDB, "M_ID,M_NAME,M_CODE,M_LEVEL", "[S_MENU]", "WHERE M_DISABLED=0", "ORDER BY M_ORDERPATH ASC"))
{
if (dt != null && dt.Rows.Count > 0)
{
purviewCodeData = SqlPagerHelper.GetTableByCondition(DefaultConnection.ConnectionStringByDefaultDB, "MPC_NAME,MPC_CODE,M_ID", "S_MENU_PURVIEWCODE", "WHERE MPC_DISABLED=0", "ORDER BY MPC_ID ASC");
Grid2.DataSource = dt;
Grid2.DataBind();
InitPermission();
}
}
}
else
{
Alert.ShowInParent("参数错误！", String.Empty, ActiveWindow.GetHideReference());
}
}
catch (Exception ex)
{
logger.Error("S.R.MManage.BindGrid2():Exception", ex);
Alert.ShowInParent("系统错误。");
}
}
private void BindUser()
{
try
{
if (roleId > 0)
{
StringBuilder condition = new StringBuilder();
condition.AppendFormat("WHERE R_ID={0}", roleId);
string name = StringHelper.ClearSqlStringExSpace(ttbSearchUser.Text.Trim());
if (name.Length > 0)
{
condition.AppendFormat(" AND (U_NAME like'%{0}%' OR U_REALNAME like'%{0}%')", name);
}
int recordCount = 0;
using (DataTable dt = SqlPagerHelper.GetTableByCondition(DefaultConnection.ConnectionStringByDefaultDB, "a.U_ID,U_NAME,U_REALNAME,U_EMAIL,U_MOBILE,U_TEL", "[S_ROLE_USER] a JOIN [S_USER] b ON a.U_ID=b.U_ID", condition.ToString(), "ORDER BY a.U_ID DESC", gridUser.PageIndex + 1, gridUser.PageSize, out recordCount))
{
gridUser.RecordCount = recordCount;
gridUser.DataSource = dt;
gridUser.DataBind();
}
}
else
{
Alert.ShowInParent("参数错误！", String.Empty, ActiveWindow.GetHideReference());
}
}
catch (Exception ex)
{
logger.Error("S.R.UManage.BindUser():Exception", ex);
Alert.ShowInParent("系统错误。");
}
}
private void BindData()
{
try
{
using (DataTable dt = SqlPagerHelper.GetTableByCondition(DefaultConnection.ConnectionStringByDefaultDB, "M_ID,M_NAME,M_LEVEL,M_CODE,M_DISABLED", "[S_MENU]", String.Empty, "ORDER BY M_ORDERPATH ASC"))
{
Grid1.DataSource = dt;
Grid1.DataBind();
}
}
catch (Exception ex)
{
logger.Error("S.M.Manage.BindData():Exception", ex);
Alert.ShowInParent("系统错误。");
}
}
public ActionResult GetAllButtonInfo()
{
string strWhere = "1=1";
string sort = Request["sort"] == null ? "id" : Request["sort"];
string order = Request["order"] == null ? "asc" : Request["order"];
if (!string.IsNullOrEmpty(Request["FButtonName"]) && !SqlInjection.GetString(Request["FButtonName"]))
{
strWhere += " and Name like '%" + Request["FButtonName"] + "%'";
}
//首先获取前台传递过来的参数
int pageindex = Request["page"] == null ? 1 : Convert.ToInt32(Request["page"]);
int pagesize = Request["rows"] == null ? 10 : Convert.ToInt32(Request["rows"]);
int totalCount = 0; //输出参数
string strJson = JsonHelper.ToJson(SqlPagerHelper.GetPager("tbButton", "Id,Name,Code,Icon,Sort,Description,CreateTime,CreateBy,UpdateTime,UpdateBy", sort + " " + order, pagesize, pageindex, strWhere, out totalCount));
return(Content("{\"total\": " + totalCount.ToString() + ",\"rows\":" + strJson + "}"));
}
private void BindRole()
{
try
{
using (DataTable dt = SqlPagerHelper.GetTableByCondition(DefaultConnection.ConnectionStringByDefaultDB, "R_ID,R_NAME", "[S_ROLE]", String.Empty, "ORDER BY R_ORDERID ASC")) //去除系统管理员
{
cblRole.DataTextField = "R_NAME";
cblRole.DataValueField = "R_ID";
cblRole.DataSource = dt;
cblRole.DataBind();
}
}
catch (Exception ex)
{
logger.Error("S.U.SelectRole.BindRole():Exception", ex);
Alert.ShowInParent("系统错误。");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
using (DataTable dt = SqlPagerHelper.GetTableByCondition(DefaultConnection.ConnectionStringByDefaultDB, "M_ID,M_NAME,M_LEVEL", "[S_MENU]", "WHERE M_DISABLED=0", "ORDER BY M_ORDERPATH ASC"))
{
if (dt != null && dt.Rows.Count > 0)
{
ddlParentId.DataSource = dt;
ddlParentId.DataTextField = "M_NAME";
ddlParentId.DataValueField = "M_ID";
ddlParentId.DataSimulateTreeLevelField = "M_LEVEL";
ddlParentId.DataBind();
}
}
ddlParentId.Items.Insert(0, new FineUI.ListItem("≡ 作为一级菜单 ≡", "0", true));
}
}
private void LoadInfo()
{
int id = RequestHelper.GetRequestInt("id", 0);
if (id > 0)
{
UserModel model = new UserBLL().GetModelById(id);
if (model != null)
{
labName.Text = HttpUtility.HtmlDecode(model.Name);
labRealName.Text = HttpUtility.HtmlDecode(model.RealName);
labEmail.Text = HttpUtility.HtmlDecode(model.Email);
labMobile.Text = HttpUtility.HtmlDecode(model.Mobile);
labPhone.Text = HttpUtility.HtmlDecode(model.Tel);
imgShowStatus.Icon = model.Disabled ? Icon.Tick : Icon.BulletCross;
StringBuilder sbText = new StringBuilder();
using (DataTable dt = SqlPagerHelper.GetTableByCondition(DefaultConnection.ConnectionStringByDefaultDB, "R_NAME", "[S_ROLE_USER] a JOIN [S_ROLE] b ON b.R_ID=a.R_ID", "WHERE a.U_ID=" + id, "ORDER BY a.R_ID ASC"))
{
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow role in dt.Rows)
{
sbText.AppendFormat("{0}，", role["R_NAME"]);
}
labRole.Text = sbText.ToString().TrimEnd('，');
}
}
labPT.Text = model.PrevLoginTime.HasValue ? model.PrevLoginTime.Value.ToString() : "";
labPIP.Text = HttpUtility.HtmlDecode(model.PrevLoginIP);
labLT.Text = model.LastLoginTime.HasValue ? model.LastLoginTime.Value.ToString() : "";
labLIP.Text = HttpUtility.HtmlDecode(model.LastLoginIP);
labLTS.Text = model.LoginTimes.ToString();
labCT.Text = model.CreateTime.Value.ToString();
}
else
{
Alert.ShowInParent("读取数据失败！", String.Empty, ActiveWindow.GetHideReference());
}
}
else
{
Alert.ShowInParent("参数错误！", String.Empty, ActiveWindow.GetHideReference());
}
}
/// <summary>
/// 绑定数据
/// </summary>
public void BindData()
{
try
{
StringBuilder condition = new StringBuilder(" where Type='BD' ");
using (DataTable dt = SqlPagerHelper.GetTableByCondition(DefaultConnection.ConnectionStringByDefaultDB, " HelpInfo ", "[MS_HelpPage]", condition.ToString(), ""))
{
if (dt.Rows.Count > 0)
{
this.txtHelpInfo.Text = dt.Rows[0]["HelpInfo"].ToString();
}
}
}
catch (Exception ex)
{
logger.Error("X.MessageList.BindData():Exception", ex);
Alert.ShowInParent("系统错误。");
}
}
public ActionResult GetAllRequestionInfo()
{
string strWhere = "1=1";
string sort = Request["sort"] == null ? "id" : Request["sort"];
string order = Request["order"] == null ? "asc" : Request["order"];
if (!string.IsNullOrEmpty(Request["ftitle"]) && !SqlInjection.GetString(Request["ftitle"]))
{
strWhere += " and ftitle like '%" + Request["ftitle"] + "%'";
}
if (!string.IsNullOrEmpty(Request["frequstid"]) && !SqlInjection.GetString(Request["frequstid"]))
{
strWhere += " and ftypeid =" + Request["frequstid"];
}
//首先获取前台传递过来的参数
int pageindex = Request["page"] == null ? 1 : Convert.ToInt32(Request["page"]);
int pagesize = Request["rows"] == null ? 10 : Convert.ToInt32(Request["rows"]);
int totalCount = 0; //输出参数
string strJson = ""; //输出结果
if (order.IndexOf(',') != -1) //如果有","就是多列排序（不能拿列判断，列名中间可能有","符号）
{
//多列排序：
//sort：ParentId,Sort,AddDate
//order：asc,desc,asc
string sortMulti = ""; //拼接排序条件，例：ParentId desc,Sort asc
string[] sortArray = sort.Split(','); //列名中间有","符号，这里也要出错。正常不会有
string[] orderArray = order.Split(',');
for (int i = 0; i < sortArray.Length; i++)
{
sortMulti += sortArray[i] + " " + orderArray[i] + ",";
}
strJson = JsonHelper.ToJson(SqlPagerHelper.GetPager("vw_requestion", "id,ftypeid,ftitle,fcontent,ftypename,fsort,CreateTime,CreateBy,UpdateTime,UpdateBy", sortMulti.Trim(','), pagesize, pageindex, strWhere, out totalCount));
}
else
{
strJson = JsonHelper.ToJson(SqlPagerHelper.GetPager("vw_requestion", "id,ftypeid,ftitle,fcontent,ftypename,fsort,CreateTime,CreateBy,UpdateTime,UpdateBy", sort + " " + order, pagesize, pageindex, strWhere, out totalCount));
}
var jsonResult = new { total = totalCount.ToString(), rows = strJson };
return(Content("{\"total\": " + totalCount.ToString() + ",\"rows\":" + strJson + "}"));
}
/// <summary>
/// 获取分页数据
/// </summary>
/// <param name="tableName">表名</param>
/// <param name="columns">要取的列名（逗号分开）</param>
/// <param name="order">排序</param>
/// <param name="pageSize">每页大小</param>
/// <param name="pageIndex">当前页</param>
/// <param name="where">查询条件</param>
/// <param name="totalCount">总记录数</param>
public string GetPager(string tableName, string columns, string order, int pageSize, int pageIndex, string where, out int totalCount)
{
DataTable dt = SqlPagerHelper.GetPager(tableName, columns, order, pageSize, pageIndex, where, out totalCount);
dt.Columns.Add(new DataColumn("UserRoleId"));
dt.Columns.Add(new DataColumn("UserRole"));
dt.Columns.Add(new DataColumn("UserDepartmentId"));
dt.Columns.Add(new DataColumn("UserDepartment"));
for (int i = 0; i < dt.Rows.Count; i++)
{
DataTable dtrole = new RoleBLL().GetRoleByUserId(Convert.ToInt32(dt.Rows[i]["ID"]));
DataTable dtdepartment = new DepartmentBLL().GetDepartmentByUserId(Convert.ToInt32(dt.Rows[i]["ID"]));
dt.Rows[i]["UserRoleId"] = JsonHelper.ColumnToJson(dtrole, 0);
dt.Rows[i]["UserRole"] = JsonHelper.ColumnToJson(dtrole, 1);
dt.Rows[i]["UserDepartmentId"] = JsonHelper.ColumnToJson(dtdepartment, 0);
dt.Rows[i]["UserDepartment"] = JsonHelper.ColumnToJson(dtdepartment, 1);
}
return(JsonHelper.ToJson(dt));
}
/// <summary>
/// 绑定最后一条数据
/// </summary>
public void BindData()
{
try
{
StringBuilder condition = new StringBuilder("");
using (DataTable dt = SqlPagerHelper.GetTableByCondition(DefaultConnection.ConnectionStringByDefaultDB, "top 1 *", "[MS_Edition]", condition.ToString(), "ORDER BY createdtime desc"))
{
if (dt.Rows.Count > 0)
{
this.txtNumber.Text = dt.Rows[0]["version"].ToString();
this.txtEdition.Text = dt.Rows[0]["edition"].ToString();
}
}
}
catch (Exception ex)
{
logger.Error("X.MessageList.BindData():Exception", ex);
Alert.ShowInParent("系统错误。");
}
}
//页面数据加载
private void BindData()
{
try
{
StringBuilder condition = new StringBuilder("");
int recordCount = 0;
using (DataTable dt = SqlPagerHelper.GetTableByCondition(DefaultConnection.ConnectionStringByDefaultDB, "*", "[view_statistics]", condition.ToString(), "ORDER BY ID asc", Grid1.PageIndex + 1, Grid1.PageSize, out recordCount))
{
Grid1.RecordCount = recordCount;
Grid1.DataSource = dt;
Grid1.DataBind();
}
}
catch (Exception ex)
{
logger.Error("X.MessageList.BindData():Exception", ex);
Alert.ShowInParent("系统错误。");
}
}
//页面数据加载
private void BindData()
{
try
{
StringBuilder condition = new StringBuilder("");
string id = RequestHelper.GetRequestString("id", "");
int recordCount = 0;
condition.AppendFormat("where Title_ID='{0}'", id);
using (DataTable dt = SqlPagerHelper.GetTableByCondition(DefaultConnection.ConnectionStringByDefaultDB, "*", "[TB_Comment]", condition.ToString(), "ORDER BY createdtime desc", Grid1.PageIndex + 1, Grid1.PageSize, out recordCount))
{
Grid1.RecordCount = recordCount;
Grid1.DataSource = dt;
Grid1.DataBind();
}
}
catch (Exception ex)
{
logger.Error("X.MessageList.BindData():Exception", ex);
Alert.ShowInParent("系统错误。");
}
}
private void BindData()
{
txtID.Text = "0";
txtCode.Text = String.Empty;
txtName.Text = String.Empty;
chkDisabled.Checked = false;
try
{
int recordCount = 0;
using (DataTable dt = SqlPagerHelper.GetTableByCondition(DefaultConnection.ConnectionStringByDefaultDB, "MPC_ID,MPC_NAME,MPC_CODE,MPC_DISABLED,M_NAME,M_CODE", "[S_MENU_PURVIEWCODE] mpc JOIN [S_MENU] m ON m.M_ID=mpc.M_ID", "WHERE mpc.M_ID=" + mid, "ORDER BY MPC_ID ASC", Grid1.PageIndex + 1, Grid1.PageSize, out recordCount))
{
Grid1.RecordCount = recordCount;
Grid1.DataSource = dt;
Grid1.DataBind();
}
}
catch (Exception ex)
{
logger.Error("S.M.PCManage.BindData():Exception", ex);
Alert.ShowInParent("系统错误。");
}
}
//页面数据加载
private void BindData()
{
try
{
id = RequestHelper.GetRequestString("id", "");
StringBuilder condition = new StringBuilder("where 1=1");
condition.AppendFormat(" and pageid='{0}' ", id);
int recordCount = 0;
using (DataTable dt = SqlPagerHelper.GetTableByCondition(DefaultConnection.ConnectionStringByDefaultDB, "*", "[view_statistics_info]", condition.ToString(), " ORDER BY ID asc", Grid1.PageIndex + 1, Grid1.PageSize, out recordCount))
{
Grid1.RecordCount = recordCount;
Grid1.DataSource = dt;
Grid1.DataBind();
}
}
catch (Exception ex)
{
logger.Error("X.MessageList.BindData():Exception", ex);
Alert.ShowInParent("系统错误。");
}
}
private void BindData()
{
try
{
StringBuilder condition = new StringBuilder("WHERE 1=1");
string key = StringHelper.ClearSqlStringExSpace(ttbSearchKey.Text.Trim());
if (key.Length > 0)
{
condition.AppendFormat(" AND [R_NAME] like '%{0}%'", key);
}
int recordCount = 0;
using (DataTable dt = SqlPagerHelper.GetTableByCondition(DefaultConnection.ConnectionStringByDefaultDB, "*", "[S_ROLE]", condition.ToString(), "ORDER BY R_ORDERID ASC", Grid1.PageIndex + 1, Grid1.PageSize, out recordCount))
{
Grid1.RecordCount = recordCount;
Grid1.DataSource = dt;
Grid1.DataBind();
}
}
catch (Exception ex)
{
logger.Error("S.R.Manage.BindData():Exception", ex);
Alert.ShowInParent("系统错误。");
}
}
/// <summary>
/// 获取分页数据
/// </summary>
/// <param name="tableName">表名</param>
/// <param name="columns">要取的列名（逗号分开）</param>
/// <param name="order">排序</param>
/// <param name="pageSize">每页大小</param>
/// <param name="pageIndex">当前页</param>
/// <param name="where">查询条件</param>
/// <param name="totalCount">总记录数</param>
public string GetPager(string tableName, string columns, string order, int pageSize, int pageIndex, string where, out int totalCount)
{
DataTable dt = SqlPagerHelper.GetPager(tableName, columns, order, pageSize, pageIndex, where, out totalCount);
return(JsonHelper.ToJson(dt));
}
/// <summary>
/// 根据报名id查询数据
/// </summary>
/// <param name="mid">报名id</param>
/// <param name="id">0参加1取消2全部</param>
/// <param name="type">类型（-1所有取消的活动（赛事/培训）,0、赛事1、培训2、约吧）</param>
/// <returns></returns>
public DataTable GetTableCancel(int mid, int id, int type, int page, int row, out int recordCount)
{
recordCount = 0;
try
{
StringBuilder where = new StringBuilder();
// where.AppendFormat(" m_id ={0} and isactivaty={1}", mids, type);
StringBuilder order = new StringBuilder();
order.AppendFormat(" order by App_Application.createtime desc");
StringBuilder cmdText = new StringBuilder();
StringBuilder cmdtable = new StringBuilder();
if (type == 2)
{
cmdtable.Append("App_Application left join View_About on App_Application.a_id=View_About.ab_id");
cmdText.Append("ap_id,ab_id,pic,AnOrangepic,IosOrangepic,title,View_About.address,number,View_About.sex,numberlimit,movement,begintime,specifictime");
where.Append("App_Application.m_id=" + mid + " and App_Application.state not in('-1') and App_Application.type=" + type + " ");
}
else
{
cmdtable.Append(" App_Application left join View_Activaty on App_Application.a_id=View_Activaty.a_id");
cmdText.Append("ap_id,View_Activaty.a_id,pic,App_Application.state,AnOrangepic,IosOrangepic,title,View_Activaty.address,movement,praise,eventname,isactivaty,App_Application.modifytime");
if (type == -1)
{
where.Append("App_Application.m_id=" + mid + " and App_Application.state in('2','3','4','5') and App_Application.type in('0','1') ");
}
else
{
if (id == 0)
{
where.Append("App_Application.m_id=" + mid + " and App_Application.state=1 and App_Application.type=" + type + " ");
}
else if (id == 1)
{
where.Append("App_Application.m_id=" + mid + " and App_Application.state in('2','3','4','5') and App_Application.type=" + type + " ");
}
else
{
where.Append("App_Application.m_id=" + mid + " and App_Application.state not in('-1','0') and App_Application.type=" + type + " ");
}
}
}
return(SqlPagerHelper.GetTableByCondition(DefaultConnection.ConnectionStringByDefaultDB, cmdText.ToString(), cmdtable.ToString(), where.ToString(), order.ToString(), page, row, out recordCount));
}
catch (ArgumentNullException ex)
{
logger.Error("调用方法GetTableCancel发生ArgumentNullException", ex);
}
catch (SqlException ex)
{
logger.Error("调用方法GetTableCancel发生SqlException", ex);
}
catch (Exception ex)
{
logger.Error("调用方法GetTableCancel发生Exception", ex);
}
return(null);
}
