//根据sourceid获取数据源信息
protected void BindColumnList()
{
string sourceid = hidsourceid.Value.Trim();
BS_DATASOURCEBLL blld = new BS_DATASOURCEBLL();
CMICT.CSP.Model.BS_DATASOURCE model = blld.GetModel(Guid.Parse(sourceid));
string templateid = hidTemplateID.Value.Trim();
if (model != null)
{
if (!string.IsNullOrEmpty(templateid))//绑定已经配置的列名与显示名信息
{
DataTable dtt = bll.GetUserQueryColListByTemplateID(Guid.Parse(templateid));
if (dtt != null && dtt.Rows.Count > 0)
{
string configcolinfo = string.Empty;
foreach (DataRow drr in dtt.Rows)
{
configcolinfo += Convert.ToString(drr["name"]) + "|" + Convert.ToString(drr["DisplayName"]) + ";";
}
hidconfigcolinfo.Value = configcolinfo;
}
}
DataTable dt = dc.GetColumnListByType(model.ObjectType, model.ObjectName, "");
//绑定默认筛选条件中列名下拉
ddlColumnName.DataSource = dt;
ddlColumnName.DataTextField = "name";
ddlColumnName.DataValueField = "data_type";
ddlColumnName.DataBind();
ddlColumnName.Items.Insert(0, new ListItem("请选择", ""));
ViewState["DfColumnList"] = dt;
//绑定排序中列名下拉
ddluqcol.DataSource = dt;
ddluqcol.DataTextField = "name";
ddluqcol.DataValueField = "name";
ddluqcol.DataBind();
ddluqcol.Items.Insert(0, new ListItem("请选择", ""));
ViewState["ColumnList"] = dt;
if (model.ObjectType == "PROC")
{
if (dt != null && dt.Rows.Count > 0)
{
string paralist = string.Empty;
foreach (DataRow dr in dt.Rows)
{
string cname = Convert.ToString(dr["name"]).Trim();
if (cname.IndexOf('@') != -1)
{
paralist += cname + ",";
}
}
hidprocparalist.Value = paralist.TrimEnd(',');
}
}
}
}
//启用
protected void btnuse_Click(object sender, EventArgs e)
{
try
{
string TemplateID = hidtemplateid.Value.Trim();
if (!string.IsNullOrEmpty(TemplateID))
{
QueryConfigComponent qcc = new QueryConfigComponent();
DataTable qdt = qcc.GetUserQueryColListByTemplateID(Guid.Parse(TemplateID));
if (qdt != null && qdt.Rows.Count > 0)
{
string tstatus = "FREE";
TemplateManageComponent tcc = new TemplateManageComponent();
DataTable dt = tcc.GetListByTemplateID(TemplateID);
if (dt != null && dt.Rows.Count > 0)//判断有无页面
{
tstatus = "ENABLE";
}
if (tmbll.EnableTemplateInfo(TemplateID, tstatus))
{
//刷新模板缓存
BusinessSearchComponent bsbll = new BusinessSearchComponent();
bsbll.RefreshTemplateByGuid(TemplateID);
hidtemplateid.Value = "";
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "suseenable", "layer.alert('模板启用成功！',9);", true);
BindTemplateList();
}
else
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "suseenable", "layer.alert('模板启用失败！',8);", true);
}
}
else
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "suseenablerror", "layer.alert('模板未配置完成，无法启用！',8);", true);
}
}
}
catch (Exception ee)
{
BaseComponent.Error(ee.Message);
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "suseenablcatch", "layer.alert('模板启用出错！',8);", true);
}
}