protected void Button1_Click(object sender, EventArgs e)
{
ModelFieldModel m = new ModelFieldModel();
m.FieldName = "GL_" + txtFieldName.Text.Trim();//自定义字段加前缀，区别于系统字段
m.FieldName2 = txtFieldName2.Text.Trim();
m.FieldType = int.Parse(txtFieldType.SelectedValue);
m.FieldIsNull = txtFieldIsNully.Checked ? 0 : 1;
m.FieldOnOff = txtFieldOnOffy.Checked ? 0 : 1;
m.FieldPx = int.Parse(txtFieldPx.Text);
m.FieldIntro = txtFieldIntro.Text;
m.Modeid = mid;
m.FieldVaules = txtvalue.Text;
m.id = id;
if (id == 0)
{
//取得该模型数据表名称
ModelModel mo = new ModelBll().GetModel(mid);
bool bo = DbHelperSQL.ColumnExists(mo.ModelTable, txtFieldName.Text);
if (bo)
{
BasePage.Alertback(Page, "字段名称已经存在于数据中");
return;
}
else
{
//在数据库中添加字段
string fieldtype;
if (txtFieldType.Text == "1")
{
fieldtype = " int";
}
else
{
fieldtype = " nvarchar(50)";
}
string column = "GL_" + txtFieldName.Text.Trim() + fieldtype;
string sqlContent = "alter table " + mo.ModelTable + " add " + column + "";
object obj = DbHelperSQL.GetSingle(sqlContent.ToString());
int i = new ModelFieldBll().Add(m);
if (i > 0)
{
BasePage.JscriptPrint(Page, "添加成功！", "ModelField.aspx?mid=" + mid);
}
}
}
else
{
bool b = new ModelFieldBll().Update(m);
if (b)
{
BasePage.JscriptPrint(Page, "修改成功！", "ModelField.aspx?mid=" + mid);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
string txtAction = "";
string checklogin = new AdminBll().CheckLogin("1");
if (checklogin != "true")
{
BasePage.Alertback(checklogin);
Response.End();
}
int id = BasePage.GetRequestId(Request.QueryString["id"]);
string type = Request.QueryString["type"];
DrModelType.SelectedValue = type;
if (type == "1")
{
modeltype = true;//产品模型
}
if (id != 0)
{
txtAction = "修改模型信息";
txtAction2.Text = "修改模型信息";
Button1.Text = "确认修改";
ModelModel model = new ModelBll().GetModel(id);
txtModelName.Text = model.ModelName;
txtModelTable.Text = model.ModelTable;
txtModelTable.Enabled = false;
txtItemName.Text = model.ItemName;
txtItemUnit.Text = model.ItemUnit;
RaModelLock.SelectedValue = model.ModelLock.ToString();
DrModelType.SelectedValue = model.ModelType.ToString();
txtclassnum.Text = model.ModelClassLayer.ToString();
if (model.ModelType == 1)//0文章1产品
{
modeltype = true;
}
DrModelType.Enabled = false;
if (!String.IsNullOrEmpty(model.ModeContent))
{
//0模型内容可选字段`1模型栏目可选字段`2内容字段名称`3模型列表可选字段`4提示语`5发表审核选择
string[] aa = model.ModeContent.Split('`');
string[] tips = aa[4].Split('|');
txt0.Text = tips[0];
txt1.Text = tips[1];
txt2.Text = tips[2];
txt3.Text = tips[3];
txt4.Text = tips[4];
txt5.Text = tips[5];
txt6.Text = tips[6];
txt7.Text = tips[7];
txt8.Text = tips[8];
txt9.Text = tips[9];
txt10.Text = tips[10];
if (!modeltype) //文章模型
{
SetCheckedBox.SetChecked(this.txtModeContent, aa[0], ","); //模型内容可选
SetCheckedBox.SetChecked(this.txtmodelcheckclass, aa[1], ","); //栏目可选
txt25.Text = aa[2];
SetCheckedBox.SetChecked(this.txtchecklist, aa[3], ","); //模型列表可选
txta11.Text = tips[11];
ddlsendsh.SelectedValue = aa[5].ToString();
}
else
{ //0模型内容可选字段`1模型栏目可选字段`2内容字段名称`3模型列表可选字段`4提示语`5发表审核选择
SetCheckedBox.SetChecked(this.txtModeContent2, aa[0], ","); //模型内容可选
SetCheckedBox.SetChecked(this.txtmodelcheckclass, aa[1], ","); //栏目可选
txt26.Text = aa[2];
SetCheckedBox.SetChecked(this.txtchecklist, aa[3], ","); //模型列表可选
txtp11.Text = tips[11];
txtp12.Text = tips[12];
txtp13.Text = tips[13];
txtp14.Text = tips[14];
txtp15.Text = tips[15];
ddlsendsh.SelectedValue = aa[5].ToString();
}
}
}
else
{
txtAction = "添加新模型";
txtAction2.Text = "添加新模型";
}
((Literal)Master.FindControl("breadcrumbs")).Text = "<span class=\"home\"></span>" + txtAction;
}
}
protected void Button1_Click(object sender, EventArgs e)
{
int id = BasePage.GetRequestId(Request.QueryString["id"]);
ModelModel model = new ModelModel();
model.ModelName = txtModelName.Text;
model.ModelTable = txtModelTable.Text;
model.ItemName = txtItemName.Text;
model.ItemUnit = txtItemUnit.Text;
model.ModelClassLayer = BasePage.GetRequestId(txtclassnum.Text);
model.ModelLock = int.Parse(RaModelLock.SelectedValue);
StringBuilder modelcontents = new StringBuilder();
string tipstxt = txt0.Text + "|" + txt1.Text + "|" + txt2.Text + "|" + txt3.Text + "|" + txt4.Text + "|" + txt5.Text + "|" + txt6.Text + "|" + txt7.Text + "|" + txt8.Text + "|" + txt9.Text + "|" + txt10.Text + "|";
if (DrModelType.SelectedValue == "0")//文章模型
{
//0模型内容可选字段`1模型栏目可选字段`2内容字段名称`3模型列表可选字段`4提示语`5发表审核选择
//tips提示语
tipstxt += txta11.Text;
modelcontents.Append(SetCheckedBox.GetChecked(this.txtModeContent, ",") + "`" + SetCheckedBox.GetChecked(this.txtmodelcheckclass, ",") + "`" + txt25.Text + "`" + SetCheckedBox.GetChecked(this.txtchecklist, ",") + "`" + tipstxt + "`" + ddlsendsh.SelectedValue);
}
else
{
// 0模型内容可选字段`1模型栏目可选字段`2内容字段名称`3模型列表可选字段`4提示语`5发表审核选择
tipstxt += txtp11.Text + "|" + txtp12.Text + "|" + txtp13.Text + "|" + txtp14.Text + "|" + txtp15.Text;
modelcontents.Append(SetCheckedBox.GetChecked(this.txtModeContent2, ",") + "`" + SetCheckedBox.GetChecked(this.txtmodelcheckclass, ",") + "`" + txt26.Text + "`" + SetCheckedBox.GetChecked(this.txtchecklist, ",") + "`" + tipstxt + "`" + ddlsendsh.SelectedValue);
}
model.ModeContent = modelcontents.ToString();
model.ModelType = BasePage.GetRequestId(DrModelType.SelectedValue);
model.id = id;
if (id != 0)
{
bool b = new ModelBll().Update(model);
if (b)
{
BasePage.JscriptPrint(Page, "模型修改成功！", "Model.aspx");
}
}
else
{
bool b1 = new ModelBll().ExistsName(txtModelTable.Text, "ModelTable");
if (b1)
{
BasePage.JscriptPrint(Page, "数据表名不能重复！", "##");
}
else
{
// bool jj = false;
//创建数据表
if ((DbHelperSQL.TabExists(txtModelTable.Text)))
{
BasePage.JscriptPrint(Page, "添加失败，存在同名数据表！", "##");
return;
}
else
{
string data = "GL_Article";
if (DrModelType.SelectedValue == "1")//产品模型
{
data = "GL_Products";
}
//复制表(只复制结构)
// string strsql = "select * into " + txtModelTable.Text + " from " + data + " where 1<>1";
string strsql = "CREATE TABLE " + txtModelTable.Text + " LIKE " + data + "";
object obj = DbHelperSQL.GetSingle(strsql.ToString());
}
int i = new ModelBll().Add(model);
if (i > 0)
{
BasePage.JscriptPrint(Page, "模型添加成功！", "Model.aspx");
}
}
}
}
private string titletips = "";//字段名
protected void Page_Load(object sender, EventArgs e)
{
//删除相册图片
if (Request.QueryString["ac"] == "uppic")
{
new CommonBll().Delete("GL_Album", BasePage.GetRequestId(Request.QueryString["delid"]));
}
mid = BasePage.GetRequestId(Request.QueryString["mid"]);
if (mid == 1)
{
mid = 2;
}
id = BasePage.GetRequestId(Request.QueryString["id"]);
if (!String.IsNullOrEmpty(Request.QueryString["language"]))
{
Language = BasePage.GetRequestId(Request.QueryString["Language"]).ToString();
}
//根据模型找出数据表名
ModelModel mo = new ModelBll().GetModel(mid);
datatable = mo.ModelTable;
ItemName = mo.ItemName;
if (!Page.IsPostBack)
{
string checklogin = new AdminBll().CheckLogin("m" + mid);
if (checklogin != "true")
{
BasePage.Alertback(checklogin);
Response.End();
}
//绑定栏目下拉
// ClassTreeBind(0, "请选择所属类别", mid, this.txtTid, "ClassType=0 and Languagen=" + Language);
txtTid.Text = new ClassBll().GetClassSelect(0, "请选择所属类别", mid, "txtTid", "ClassType=0 and Languagen=" + BasePage.GetRequestId(Language) + "", "", "required input-control select-control");
FieldBind(id);//绑定自定义
txtAddDate.Text = BasePage.formatDateTime(DateTime.Now.ToString());
Drlanguage.SelectedValue = Language.ToString();
hiddenbackurl.Value = "Products.aspx?mid=" + mid;
//将公司名读取
txtcompany.Text = Cookies.GetCookie("company").ToString();
txtcompanyid.Value = Cookies.GetCookie("companyId").ToString();
GetData();//编辑时
//提示
if (!String.IsNullOrEmpty(mo.ModeContent))
{//0模型内容可选字段`1模型栏目可选字段`2内容字段名称`3模型列表可选字段`4提示语`5发表审核选择
string[] aa = mo.ModeContent.Split('`');
string[] a = aa[4].Split('|');
ModeContent = aa[0];
txtTips0.Text = a[0];
txtTips1.Text = a[1];
txtTips2.Text = a[2];
txtTips3.Text = a[3];
isw = a[4];
ish = a[5];
txtTips6.Text = a[6];
txtTips7.Text = a[7];
txtTips8.Text = a[8];
txtTips9.Text = a[9];
txtTips10.Text = a[10];
txtTips11.Text = a[11];
ibw = a[12];
ibh = a[13];
txtTips14.Text = a[14];
txtTips15.Text = a[15];
titletips = aa[2];
}
((Literal)Master.FindControl("breadcrumbs")).Text = "<a class=\"home\" href=\"Products.aspx?mid=" + mid + "\">" + ItemName + "管理</a><span class=\"add\">添加" + ItemName + "</span><a href=\"Products.aspx?del=del&mid=" + mid + "\" class=\"del\">" + ItemName + "回收站</a>";
}
}
protected void Page_Load(object sender, EventArgs e)
{
mid = BasePage.GetRequestId(Request.QueryString["mid"]);
if (mid == 0)
{
mid = 2;
}
//根据模型找出数据表名
ModelModel mo = new ModelBll().GetModel(mid);
datatable = mo.ModelTable;
ItemName = mo.ItemName;
if (!Page.IsPostBack)
{
string checklogin = new AdminBll().CheckLogin("m" + mid);
if (checklogin != "true")
{
BasePage.Alertback(checklogin);
Response.End();
}
ac = Request.QueryString["ac"];
verific = BasePage.ArrayExist(Cookies.GetCookie("ModelPower"), "ms" + mid);
del = BasePage.ArrayExist(Cookies.GetCookie("ModelPower"), "md" + mid);
cid = BasePage.GetRequestId(Request.QueryString["cid"]);
string company = Request.QueryString["company"];//按公司搜索
int companyId = BasePage.GetRequestId(Request.QueryString["companyid"]);
txtCompany.Text = company;
if (!String.IsNullOrEmpty(mo.ModeContent))
{
//0模型内容可选字段`1模型栏目可选字段`2(以后添加)`3(以后添加)`4提示语`5发表审核选择
string[] a = mo.ModeContent.Split('`');
//下拉属性
if (BasePage.ArrayExist(a[0], "4"))
{
//推荐属性
sxddl = true;
ddlshuxi.Items.Insert(0, new ListItem("推荐", "1"));
}
if (BasePage.ArrayExist(a[0], "11"))
{
//热卖属性
sxddl = true;
//ddlshuxi.Items.Insert(0, new ListItem("热门", "2"));
ddlshuxi.Items.Insert(0, new ListItem("热门", "2"));
}
if (BasePage.ArrayExist(a[0], "26"))
{
//最新属性
sxddl = true;
ddlshuxi.Items.Insert(0, new ListItem("最新", "3"));
}
if (BasePage.ArrayExist(a[0], "27"))
{
//最新属性
sxddl = true;
ddlshuxi.Items.Insert(0, new ListItem("特价", "4"));
}
if (sxddl)
{
ddlshuxi.Items.Insert(0, new ListItem("按属性查看", ""));
}
showhidelistvalue = a[3]; //0录入3添加时间4修改时间5属于6点击7优先
if (a[5] == "0") //模型不需要审核，隐藏审核链接
{
verific = true;
}
}
if (!String.IsNullOrEmpty(Request.QueryString["language"]))
{
Language = BasePage.GetRequestId(Request.QueryString["language"]).ToString();
lansql = " and Languagen=" + BasePage.GetRequestId(Language);
}
string strwhere = "id is not null";
int sx = BasePage.GetRequestId(Request.QueryString["sx"]);//属性
ddlshuxi.SelectedValue = sx.ToString();
DrLanguage.SelectedValue = Language.ToString();
string keywords = Request.QueryString["keywords"];
if (String.IsNullOrEmpty(ac))
{
strwhere += " and IsDel=0 and Verific=0";
}
else if (ac == "del")
{
//回收站
strwhere += " and IsDel=1";
// actxt.InnerHtml = ItemName + "回收站列表";
}
else if (ac == "sh")
{
strwhere += " and Verific=1";
//actxt.InnerHtml = ItemName + "审核列表";
}
if (cid != 0)
{
strwhere += " and (Tid=" + cid;
//读取所有子级
if (showhidelist("8"))
{
DataTable dt = new ClassBll().GetListTree(mid, cid, "");
string allid = "";
if (dt.Rows.Count > 0)
{
foreach (DataRow drt in dt.Rows)
{
allid += drt["id"].ToString() + ",";
}
allid = allid.Substring(0, allid.Length - 1);
strwhere += " or Tid in (" + allid + ")";
}
}
strwhere += ")";
}
else
{
strwhere += lansql;
}
if (sx != 0)
{
string sht = "";
switch (sx)
{
case 1:
sht = "IsRecommend=1";
break;
case 2:
sht = "IsPopular=1";
break;
case 3:
sht = "IsNew=1";
break;
case 4:
sht = "IsSpecial='1'";
break;
}
strwhere += " and " + sht + "";
}
//按公司查看
if (companyId != 0)
{
strwhere += " and ShopId=" + companyId;
}
if (!String.IsNullOrEmpty(keywords))
{
strwhere += " and Title like '%" + keywords + "%'";
}
////列出所有栏目
//string allclass = "ParentId=" + cid + " and ModelId=" + mid + lansql;
//Repeater2.DataSource = new CommonBll().GetList("", "GL_Class", allclass, "px desc,id desc");
//Repeater2.DataBind();
// Response.Write(strwhere);
//Response.End();
//绑定栏目下拉
ClassTreeBind(0, "所有栏目", mid, this.ddlclassname, "ClassType=0" + lansql);
ClassTreeBind(0, "请选择栏目", mid, this.changclass, "ClassType=0" + lansql);
if (!string.IsNullOrEmpty(Request.Params["Cid"]))
{
ddlclassname.SelectedValue = Request.Params["Cid"].Trim();
}
//批量处理的ID
articleid.Text = Request.QueryString["allid"];
int PageSize = 20;
int PageIndex = BasePage.GetRequestId(Request.QueryString["Page"]); //当前第几页
Repeater1.DataSource = new CommonBll().GetListPage("", datatable, strwhere, "px desc,EditDate desc", PageSize, PageIndex);
Repeater1.DataBind();
int totalrecord = new CommonBll().GetRecordCount(datatable, strwhere);//总记录数
if (totalrecord == 0)
{
txtpage.Text = "<p align=\"left\" class=\"red\">暂无产品</p>";
}
else if (totalrecord > PageSize)
{
txtpage.Text = GL.Utility.GetPage.GetAspxPager(totalrecord, PageSize, PageIndex);
}
string bx = "<a href=\"Products.aspx?mid=" + mid + "\" class=\"home\">" + ItemName + "管理</a>";
bx += "<a href=\"ProductsAdd.aspx?mid=" + mid + "&language=" + Language + "\" class=\"add\">添加" + ItemName + "</a>";
if (!verific)
{
bx += "<a href=\"?mid=" + mid + "&language=" + Language + "&ac=sh\" class=\"sh\">审核" + ItemName + "</a>";
}
if (del)
{
bx += "<a href=\"?ac=del&mid=" + mid + "&language=" + Language + "\" class=\"del\">" + ItemName + "回收站</a>";
}
((Literal)Master.FindControl("breadcrumbs")).Text = bx;
}
}
protected void Page_Load(object sender, EventArgs e)
{
mid = BasePage.GetRequestId(Request.QueryString["mid"]);
if (mid == 0)
{
mid = 1;
}
id = BasePage.GetRequestId(Request.QueryString["id"]);
if (!String.IsNullOrEmpty(Request.QueryString["language"]))
{
Language = BasePage.GetRequestId(Request.QueryString["language"]).ToString();
}
string checklogin = new AdminBll().CheckLogin("m" + mid);
if (checklogin != "true")
{
BasePage.Alertback(checklogin);
Response.End();
}
//根据模型找出数据表名
ModelModel mo = new ModelBll().GetModel(mid);
datatable = mo.ModelTable;
if (!Page.IsPostBack)
{
ItemName = mo.ItemName;
if (!String.IsNullOrEmpty(mo.ModeContent))
{
//0模型内容可选字段`1模型栏目可选字段`2内容字段名称`3模型列表可选字段`4提示语
string[] aa = mo.ModeContent.Split('`');
string[] a = aa[4].Split('|');
txtTips0.Text = a[0];
txtTips1.Text = a[1];
txtTips2.Text = a[2];
txtTips3.Text = a[3];
iw = a[4];
ih = a[5];
txtTips6.Text = a[6];
txtTips7.Text = a[7];
txtTips8.Text = a[8];
txtTips9.Text = a[9];
txtTips10.Text = a[10];
txtTips11.Text = a[11];
titletips = aa[2];
ModeContent = aa[0];
}
//绑定栏目下拉
txtLiteral9.Text = new ClassBll().GetClassSelect(0, "请选择所属类别", mid, "txtTid", "ClassType=0 and Languagen=" + BasePage.GetRequestId(Language) + "", "", "required input-control select-control");
//绑定自定义字段
GetModelField(id);
//txtAddDate.Text = Convert.ToDateTime(DateTime.Now).ToString("yyyy-MM-dd HH:mm:ss");
txtAddDate.Text = BasePage.formatDateTime(DateTime.Now.ToString());
Drlanguage.SelectedValue = Language.ToString();
hiddenbackurl.Value = "Article.aspx?mid=" + mid;
//修改时绑定数据
if (id != 0)
{
ArticleModel am = new ArticleBll().GetModel(datatable, id);
//根据语言和当前栏目重新绑定栏目
// ClassTreeBind(0, "请选择所属类别", mid, this.txtTid, "ClassType=0 and Languagen=" + am.Languagen);
txtLiteral9.Text = new ClassBll().GetClassSelect(0, "请选择所属类别", mid, "txtTid", "ClassType=0 and Languagen=" + am.Languagen + "", am.Tid.ToString(), "required input-control select-control");
txtTitle.Text = am.Title;
if (am.IsRecommend == 1)
{
txtRecommend.Checked = true;
}
if (am.IsPopular == 1)
{
txtPopular.Checked = true;
}
if (am.IsNew == 1)
{
txtNew.Checked = true;
}
txtFullTitle.Text = am.FullTitle;
txtPx.Text = am.Px.ToString();
txtAuthor.Text = am.Author;
txtOrigin.Text = am.Origin;
txtHist.Text = am.Hits.ToString();
//txtAddDate.Text = Convert.ToDateTime(am.AddDate).ToString("yyyy-MM-dd HH:mm:ss").ToString();
txtAddDate.Text = BasePage.formatDateTime(am.AddDate.ToString());
txtPicUrl.Text = am.PicUrl;
txtKeyWord.Text = am.SeoKeyword;
txtIntro.Text = am.Intro;
txtcontents.Text = am.Contents;
txtcontents2.Text = am.Contents2;
txtcontents3.Text = am.Contents3;
txtseotitle.Text = am.SeoTitle;
txtDescription.Text = am.SeoDescription;
filesurl.Text = am.FilesUrl;
Button1.Text = "确认修改";
Drlanguage.SelectedValue = am.Languagen.ToString();
Drlanguage.Enabled = false;
colortxt.Value = am.TitltColor;
rallowcomment.SelectedValue = am.AllowComment.ToString();
if (!String.IsNullOrEmpty(am.TitltColor))
{
txtTitle.Style.Add("color", am.TitltColor);
}
// hiddenbackurl.Value = System.Web.HttpContext.Current.Request.RawUrl;
if (Request.UrlReferrer != null)
{
ViewState["UrlReferrer"] = Request.UrlReferrer.ToString();
hiddenbackurl.Value = ViewState["UrlReferrer"].ToString();
}
}
((Literal)Master.FindControl("breadcrumbs")).Text = "<a href=\"Article.aspx?mid=" + mid + "\" class=\"home\">" + ItemName + "管理</a> > 添加" + ItemName;
}
}
protected string modelclass = "";//可选字段显示
protected void Page_Load(object sender, EventArgs e)
{
id = BasePage.GetRequestId(Request.QueryString["id"]);
tid = BasePage.GetRequestId(Request.QueryString["tid"]);
mid = BasePage.GetRequestId(Request.QueryString["mid"]);
string lansql = "";
if (!String.IsNullOrEmpty(Request.QueryString["language"]))
{
Language = BasePage.GetRequestId(Request.QueryString["language"]).ToString();
lansql = "Languagen=" + BasePage.GetRequestId(Language);
}
if (mid == 0)
{
mid = 1;
}
ac = Request.QueryString["ac"];
if (!Page.IsPostBack)
{
string bx = "<a href=\"class.aspx?mid=" + mid + "&language=" + Language + "\" class=\"home\">栏目管理</a>";
if (GetPower("ca"))
{
bx += "<a href=\"?ac=add&mid=" + mid + "&language=" + Language + "\" class=\"add\">添加新栏目</a>";
}
((Literal)Master.FindControl("breadcrumbs")).Text = bx;
string checklogin = new AdminBll().CheckLogin("ce" + mid);//栏目管理编辑是前提，有编辑权限才可能进来查看，添加和删除
if (checklogin != "true")
{
BasePage.Alertback(checklogin);
Response.End();
}
if (String.IsNullOrEmpty(ac))
{
DrLanguage.SelectedValue = Language.ToString();
DataTable ds = new DataTable();
ds = new ClassBll().GetListTree(mid, 0, lansql);
Repeater1.DataSource = ds;
Repeater1.DataBind();
}
else if (ac == "add")
{
//显示可选栏目字段
ModelModel m = new ModelBll().GetModel(mid);
modelclass = m.ModeContent;
if (tid == 0)
{
txtTid.Text = "顶级分类";
DropDownList1.SelectedValue = Language;
}
else
{
ClassModel tcm = new ClassBll().GetModel(tid);
txtTid.Text = tcm.ClassName;
DropDownList1.SelectedValue = tcm.Languagen.ToString();
DropDownList1.Enabled = false;
txtClassPic.Text = tcm.ClassPic;
}
if (id != 0)
{
Button1.Text = "确认修改";
ClassModel cm = new ClassBll().GetModel(id);
DropDownList1.SelectedValue = cm.Languagen.ToString();
DropDownList1.Enabled = false;
if (cm.ParentId == 0)
{ //顶级
txtTid.Text = "顶级分类";
}
else
{
txtTid.Text = new CommonBll().GetTitle(datatable, "ClassName", int.Parse(cm.ParentId.ToString
()));
}
txtClassName.Text = cm.ClassName;
txtPx.Text = cm.Px.ToString();
txtHide.SelectedValue = cm.Hide.ToString();
rinputa.SelectedValue = cm.InputA.ToString();
rinputuser.SelectedValue = cm.InputUser.ToString();
rallowcomment.SelectedValue = cm.AllowComment.ToString();
txtClassPic.Text = cm.ClassPic;
txtClassIntro.Text = cm.ClassIntro;
txtseotitle.Text = cm.SeoTitle;
txtKeyWord.Text = cm.SeoKeyWord;
txtDescription.Text = cm.SeoDescription;
string[] con = cm.Contents.Split('~');
txtcon1.Text = con[0];
txtcon2.Text = con[1];
txtcon3.Text = con[2];
}
}
}
}
private string showhidelistvalue = ""; //列表可选字段值
protected void Page_Load(object sender, EventArgs e)
{
mid = BasePage.GetRequestId(Request.QueryString["mid"]);
tid = BasePage.GetRequestId(Request.QueryString["tid"]);
if (mid == 0)
{
mid = 1;
}
if (!String.IsNullOrEmpty(Request.QueryString["language"]))
{
Language = BasePage.GetRequestId(Request.QueryString["language"]).ToString();
lansql = " and Languagen=" + BasePage.GetRequestId(Language);
}
ac = Request.QueryString["ac"];
ModelModel mo = new ModelBll().GetModel(mid);
datatable = mo.ModelTable;
ItemName = mo.ItemName;
if (!Page.IsPostBack)
{
string checklogin = new AdminBll().CheckLogin("m" + mid);
if (checklogin != "true")
{
BasePage.Alertback(checklogin);
Response.End();
}
verific = BasePage.ArrayExist(Cookies.GetCookie("ModelPower"), "ms" + mid);//不需要审核的管理员，显示审核，审核其它需要审核的文章
del = BasePage.ArrayExist(Cookies.GetCookie("ModelPower"), "md" + mid);
if (!String.IsNullOrEmpty(mo.ModeContent))
{
//0模型内容可选字段`1模型栏目可选字段`2内容字段名称`3模型列表可选字段`4提示语`5发表审核选择
string[] a = mo.ModeContent.Split('`');
//下拉属性
if (BasePage.ArrayExist(a[0], "9"))
{
//推荐属性
sxddl = true;
ddlshuxi.Items.Insert(0, new ListItem("推荐", "1"));
}
if (BasePage.ArrayExist(a[0], "11"))
{
//热门属性
sxddl = true;
ddlshuxi.Items.Insert(0, new ListItem("热门", "2"));
}
if (BasePage.ArrayExist(a[0], "12"))
{
//最新属性
sxddl = true;
ddlshuxi.Items.Insert(0, new ListItem("最新", "3"));
}
if (sxddl)
{
ddlshuxi.Items.Insert(0, new ListItem("按属性查看", ""));
}
showhidelistvalue = a[3];
if (!BasePage.ArrayExist(a[0], "19"))
{
//按栏目查看
ddlclassname.Visible = false;
}
if (a[5] == "0")//模型不需要审核，隐藏审核链接
{
verific = true;
}
}
DrLanguage.SelectedValue = Language;
int sh = BasePage.GetRequestId(Request.QueryString["sh"]);; //审核
int sx = BasePage.GetRequestId(Request.QueryString["sx"]); //属性
ddlshuxi.SelectedValue = sx.ToString();
string keywords = Request.QueryString["keywords"];
string strwhere = "id is not null ";
if (String.IsNullOrEmpty(ac))
{
strwhere += " and IsDel=0 and Verific=0";
}
else if (ac == "del") //回收站
{
strwhere += " and IsDel=1";
//actxt.InnerHtml = ItemName + "回收站列表";
}
else if (ac == "sh")//审核
{
strwhere += " and Verific=1";
//actxt.InnerHtml = ItemName + "审核列表";
}
if (tid != 0)
{
strwhere += " and (Tid=" + tid + "";
//读取所有子级
if (showhidelist("8"))
{
DataTable dt = new ClassBll().GetListTree(mid, tid, "");
string allid = "";
if (dt.Rows.Count > 0)
{
foreach (DataRow drt in dt.Rows)
{
allid += drt["id"].ToString() + ",";
}
allid = allid.Substring(0, allid.Length - 1);
strwhere += " or Tid in (" + allid + ")";
}
}
strwhere += ")";
}
else
{
strwhere += lansql;//按栏目查看了就不需要语言了
}
if (sx != 0)
{
string sht = "";
switch (sx)
{
case 1:
sht = "IsRecommend=1";
break;
case 2:
sht = "IsPopular=1";
break;
case 3:
sht = "IsNew=1";
break;
}
strwhere += " and " + sht + "";
}
if (!String.IsNullOrEmpty(keywords))
{
strwhere += " and Title like '%" + keywords + "%'";
}
//列出所有栏目
//string allclass = "ParentId=" + tid + " and ModelId=" + mid + lansql;
//Repeater2.DataSource = new CommonBll().GetList("", "GL_Class", allclass, "Languagen asc,px desc,id desc");
//Repeater2.DataBind();
//批量处理时列出栏目
ClassTreeBind(0, "请选择栏目", mid, this.ddlclassforall, "ClassType=0" + lansql);
//按栏目查看下拉
ClassTreeBind(0, "所有栏目", mid, this.ddlclassname, "ClassType=0" + lansql);
ddlclassname.SelectedValue = tid.ToString();
int pagesize = 25;
int pageindex = BasePage.GetRequestId(Request.QueryString["page"]);
int all = new CommonBll().GetRecordCount(datatable, strwhere);
Repeater1.DataSource = new CommonBll().GetListPage("", datatable, strwhere, "px desc,id desc", pagesize, pageindex);
Repeater1.DataBind();
if (all > pagesize)
{
txtpage.Text = GetPage.GetAspxPager(all, pagesize, pageindex);
}
if (all == 0)
{
txtpage.Text = "<p align=\"left\" class=red>暂无相关内容</p>";
}
//txtpage.Text = strwhere;
string bx = "<a href=\"Article.aspx?mid=" + mid + "\" class=\"home\">" + ItemName + "管理</ a > ";
bx += "<a href=\"ArticleAdd.aspx?mid=" + mid + "&language=" + Language + "\" class=\"add\">添加" + ItemName + "</a>";
if (del)
{
bx += "<a href=\"Article.aspx?ac=del&mid=" + mid + "&language=" + Language + "\" class=\"del\">" + ItemName + "回收站</a>";
}
if (!verific)
{
bx += "<a href=\"Article.aspx?mid=" + mid + "&language=" + Language + "&ac=sh\" class=\"sh\">审核" + ItemName + "</a>";
}
((Literal)Master.FindControl("breadcrumbs")).Text = bx;
}
}
