//获得数据
protected string GetHtmlData()
{
DataTable dt = new DataTable();
StringBuilder condition = new StringBuilder();
StringBuilder strHtmlData = new StringBuilder();
try
{
if (txtD_Name.Text.Trim() != "")
{
condition.AppendFormat(" and (D_Name like '%{0}%')", txtD_Name.Text.Trim());
}
if (ddlD_Type.SelectedValue != "-1")
{
condition.AppendFormat(" and (D_Type='{0}')", ddlD_Type.SelectedValue);
}
dt = BLL.GetCommon_DictList(condition.ToString(), PageIndex, PageSize, out rCount, out pCount).Tables[0];
int i = 0;
strHtmlData.Append("<table class='table_list' cellpadding='0' cellspacing='0' >");
strHtmlData.Append("<tr class='tr_title'>");
strHtmlData.Append("<th style='width:20%;'>名称</th>");
strHtmlData.Append("<th style='width:20%;'>类型</th>");
strHtmlData.Append("<th style='width:20%;'>排序</th>");
strHtmlData.Append("<th style='width:10%;'>值</th>");
strHtmlData.Append("<th>备注</th>");
strHtmlData.Append("<th style='width:15%;'>操作</th>");
strHtmlData.Append("</tr>");
for (int j = 0; j < dt.Rows.Count; j++)
{
i++;
string css = string.Empty;
if (i % 2 == 0)
{
css = "tr_con_001";
}
else
{
css = "tr_con_002";
}
strHtmlData.Append("<tr class='" + css + "'>");
strHtmlData.Append("<td>" + dt.Rows[j]["D_Name"].ToString() + "</td>");
strHtmlData.Append("<td>" + GetD_Name(dt.Rows[j]["D_Type"].ToString()) + "</td>");
strHtmlData.Append("<td>" + dt.Rows[j]["D_Order"].ToString() + "</td>");
strHtmlData.Append("<td>" + dt.Rows[j]["D_Value"].ToString() + "</td>");
strHtmlData.Append("<td>" + dt.Rows[j]["D_Remark"].ToString() + "</td>");
strHtmlData.Append("<td>");
strHtmlData.AppendFormat(" <input type=\"button\" title='修改字典信息' class=\"btn_modify\" onclick=\"showPopCommon_Dict('{0}',2);\" />", clsUtility.Encrypt(dt.Rows[j]["Common_Dict_ID"].ToString()));
strHtmlData.AppendFormat("|");
strHtmlData.AppendFormat("<input type=\"button\" class=\"btn_delete\" title='删除字典信息' onclick=\"DeleteItemDesc('{0}')\" />", clsUtility.Encrypt(dt.Rows[j]["Common_Dict_ID"].ToString()));
strHtmlData.Append("</td>");
strHtmlData.Append("</tr>");
}
strHtmlData.Append("</table>");
if (i == 0)
{
strHtmlData.Append(" <div class='nodata_div'>暂无数据</div>");
}
}
catch (Exception ex)
{
new BLL_clsAuth().AddLogErrorFromBS(Module_Id, string.Format("类：{0}，方法：{1},错误信息：{2}， 详细：{3}", ex.TargetSite.DeclaringType.ToString(), ex.TargetSite.Name.ToString(), ex.Message, ex.StackTrace));
throw ex;
}
return(strHtmlData.ToString());
}
protected string GetHtmlData()
{
try
{
Common_DictBLL bll = new Common_DictBLL();
DataTable dt = new DataTable();
string strSql = string.Empty;
if (!string.IsNullOrEmpty(txtCName.Text.Trim()))
{
strSql = " and D_Remark like '" + txtCName.Text.Trim() + "%'";
}
strSql += " and d_type=43 ";
dt = bll.GetCommon_DictList(strSql, PageIndex, PageSize, out rCount, out pCount).Tables[0];
int i = 0;
StringBuilder strHtmlData = new StringBuilder();
strHtmlData.Append("<table class='table_list' cellpadding='0' cellspacing='0' >");
strHtmlData.Append("<tr class='tr_title'>");
strHtmlData.Append("<td style='width:30%;'>数据项名称</td>");
strHtmlData.Append("<td style='width:30%;'>表名称</td>");
strHtmlData.Append("<td style='width:30%;'>唯一ID</td>");
strHtmlData.Append("<td style='width:10%;'>操作</td>");
strHtmlData.Append("</tr>");
for (int j = 0; j < dt.Rows.Count; j++)
{
i++;
string css = string.Empty;
if (i % 2 == 0)
{
css = "tr_con_001";
}
else
{
css = "tr_con_002";
}
strHtmlData.Append("<tr class='" + css + "'>");
strHtmlData.Append("<td>" + dt.Rows[j]["D_Remark"] + "</td>");
strHtmlData.Append("<td>" + dt.Rows[j]["d_name"] + "</td>");
strHtmlData.Append("<td>" + dt.Rows[j]["d_code"] + "</td>");
strHtmlData.Append("<td><input type=\"button\" title='编辑数据项信息' class=\"btn_modify\" onclick=\"showUpdateDataItemEdit('" + dt.Rows[j]["common_dict_id"] + "')\"/>|");
strHtmlData.Append("<input type=\"button\" title='删除数据项信息' class=\"btn_delete\" onclick=\"DeleteUpdateDataItem('" + dt.Rows[j]["common_dict_id"] + "')\"/>");
strHtmlData.Append("</td> ");
strHtmlData.Append("</tr>");
}
strHtmlData.Append("</table>");
if (i == 0)
{
strHtmlData.Append(" <div class='nodata_div'>暂无数据</div>");
}
return(strHtmlData.ToString());
}
catch (Exception ex)
{
new BLL_clsAuth().AddLogErrorFromBS(Module_Id, string.Format("类：{0}，方法：{1},错误信息：{2}， 详细：{3}", ex.TargetSite.DeclaringType.ToString(), ex.TargetSite.Name.ToString(), ex.Message, ex.StackTrace));
throw ex;
}
}
//获得数据
protected string GetHtmlData()
{
DataTable dt = new DataTable();
StringBuilder condition = new StringBuilder();
StringBuilder strHtmlData = new StringBuilder();
try
{
if (txtD_Name.Text.Trim() != "")
{
condition.AppendFormat(" and (D_Name like '%{0}%')", txtD_Name.Text.Trim());
}
if (ddlD_Type.SelectedValue != "-1")
{
condition.AppendFormat(" and (D_Type='{0}')", ddlD_Type.SelectedValue);
}
if (loginUser.SysUser_ID != Rc.Common.Config.Consts.AdminID)
{
//非级管理员按类型排除加载数据（0：字典类型，1资源类型，2资源类别，4试题类型，5教案类型）
condition.AppendFormat(" and D_Type not in ('{0}','{1}','{2}','{3}','{4}')"
, "0", "1", "2", "4", "5");
//非级管理员按标识排除加载数据（资源类型中的：按目录属性生成）
condition.AppendFormat(" and Common_Dict_ID not in ('{0}')"
, "f22bd0fd-73b6-4c73-9df0-8b3cb8489816");
}
dt = BLL.GetCommon_DictList(condition.ToString(), PageIndex, PageSize, out rCount, out pCount).Tables[0];
int i = 0;
strHtmlData.Append("<table class='table table-hover table-bordered'>");
strHtmlData.Append("<thead>");
strHtmlData.Append("<tr>");
strHtmlData.Append("<th>名称</th>");
strHtmlData.Append("<th>类型</th>");
strHtmlData.Append("<th>排序</th>");
//strHtmlData.Append("<th style='width:10%;'>值</th>");
strHtmlData.Append("<th>备注</th>");
strHtmlData.Append("<th>操作</th>");
strHtmlData.Append("</tr>");
strHtmlData.Append("</thead>");
strHtmlData.Append("<tbody>");
for (int j = 0; j < dt.Rows.Count; j++)
{
i++;
strHtmlData.Append("<tr>");
strHtmlData.Append("<td>" + dt.Rows[j]["D_Name"].ToString() + "</td>");
strHtmlData.Append("<td>" + GetD_Name(dt.Rows[j]["D_Type"].ToString()) + "</td>");
strHtmlData.Append("<td>" + dt.Rows[j]["D_Order"].ToString() + "</td>");
//strHtmlData.Append("<td>" + dt.Rows[j]["D_Value"].ToString() + "</td>");
strHtmlData.Append("<td>" + dt.Rows[j]["D_Remark"].ToString() + "</td>");
strHtmlData.Append("<td class='opera'>");
if (UserFun.Edit)
{
strHtmlData.AppendFormat("<a href=\"javascript:;\" onclick=\"showPopCommon_Dict('{0}');\">编辑</a>", clsUtility.Encrypt(dt.Rows[j]["Common_Dict_ID"].ToString()));
}
if (UserFun.Delete)
{
strHtmlData.AppendFormat("<a href=\"javascript:;\" onclick=\"DeleteItemDesc('{0}')\">删除</a>", clsUtility.Encrypt(dt.Rows[j]["Common_Dict_ID"].ToString()));
}
strHtmlData.Append("</td>");
strHtmlData.Append("</tr>");
}
strHtmlData.Append("</tbody>");
strHtmlData.Append("</table>");
if (i == 0)
{
strHtmlData.Append(" <div class='nodata'>暂无数据</div>");
}
}
catch (Exception ex)
{
new BLL_clsAuth().AddLogErrorFromBS(Module_Id, string.Format("类：{0}，方法：{1},错误信息：{2}， 详细：{3}", ex.TargetSite.DeclaringType.ToString(), ex.TargetSite.Name.ToString(), ex.Message, ex.StackTrace));
throw ex;
}
return(strHtmlData.ToString());
}
