private bool DoAdd() { Rain.Model.channel_site model = new Rain.Model.channel_site(); Rain.BLL.channel_site channelSite = new Rain.BLL.channel_site(); model.title = this.txtTitle.Text.Trim(); model.build_path = this.txtBuildPath.Text.Trim(); model.domain = this.txtDomain.Text.Trim(); model.sort_id = Utils.StrToInt(this.txtSortId.Text.Trim(), 99); model.is_default = !this.cbIsDefault.Checked ? 0 : 1; model.name = this.txtName.Text.Trim(); model.logo = this.txtLogo.Text.Trim(); model.company = this.txtCompany.Text.Trim(); model.address = this.txtAddress.Text.Trim(); model.tel = this.txtTel.Text.Trim(); model.fax = this.txtFax.Text.Trim(); model.email = this.txtEmail.Text.Trim(); model.crod = this.txtCrod.Text.Trim(); model.seo_title = this.txtSeoTitle.Text.Trim(); model.seo_keyword = this.txtSeoKeyword.Text.Trim(); model.seo_description = Utils.DropHTML(this.txtSeoDescription.Text); model.copyright = this.txtCopyright.Text.Trim(); if (channelSite.Add(model) <= 0) { return(false); } CacheHelper.Remove("dt_cache_http_domain"); this.AddAdminLog(DTEnums.ActionEnum.Add.ToString(), "添加站点:" + model.title); return(true); }
protected void btnDelete_Click(object sender, EventArgs e) { this.ChkAdminLevel("sys_site_manage", DTEnums.ActionEnum.Delete.ToString()); int num1 = 0; int num2 = 0; Rain.BLL.channel_site channelSite = new Rain.BLL.channel_site(); for (int index = 0; index < this.rptList.Items.Count; ++index) { int int32 = Convert.ToInt32(((HiddenField)this.rptList.Items[index].FindControl("hidId")).Value); if (((CheckBox)this.rptList.Items[index].FindControl("chkId")).Checked) { if (new Rain.BLL.channel().GetCount("site_id=" + (object)int32) > 0) { ++num2; } else { Rain.Model.channel_site model = channelSite.GetModel(int32); if (channelSite.Delete(int32)) { ++num1; Utils.DeleteDirectory(this.siteConfig.webpath + "aspx/" + model.build_path); Utils.DeleteDirectory(this.siteConfig.webpath + "html/" + model.build_path); } else { ++num2; } } } } this.AddAdminLog(DTEnums.ActionEnum.Delete.ToString(), "删除站点成功" + (object)num1 + "条,失败" + (object)num2 + "条"); this.JscriptMsg("删除成功" + (object)num1 + "条,失败" + (object)num2 + "条!", Utils.CombUrlTxt("site_list.aspx", "keywords={0}", this.keywords), "parent.loadMenuTree"); }
public bool Update(Rain.Model.channel_site model) { string buildPath = this.dal.GetBuildPath(model.id); if (string.IsNullOrEmpty(buildPath) || !this.dal.Update(model, buildPath)) { return(false); } if (buildPath.ToLower() != model.build_path.ToLower()) { Utils.MoveDirectory(this.siteConfig.webpath + "aspx/" + buildPath, this.siteConfig.webpath + "aspx/" + model.build_path); Utils.MoveDirectory(this.siteConfig.webpath + "html/" + buildPath, this.siteConfig.webpath + "html/" + model.build_path); } return(true); }
public Rain.Model.channel_site GetModel(string build_path) { StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append("select top 1 id,title,build_path,templet_path,[domain],[name],logo,company,address,tel,fax,email,crod,copyright,seo_title,seo_keyword,seo_description,is_default,sort_id"); stringBuilder.Append(" from " + this.databaseprefix + nameof(channel_site)); stringBuilder.Append(" where build_path=@build_path"); OleDbParameter[] oleDbParameterArray = new OleDbParameter[1] { new OleDbParameter("@build_path", OleDbType.VarChar, 50) }; oleDbParameterArray[0].Value = (object)build_path; Rain.Model.channel_site channelSite = new Rain.Model.channel_site(); DataSet dataSet = DbHelperOleDb.Query(stringBuilder.ToString(), oleDbParameterArray); if (dataSet.Tables[0].Rows.Count > 0) { return(this.DataRowToModel(dataSet.Tables[0].Rows[0])); } return((Rain.Model.channel_site)null); }
public int Add(Rain.Model.channel_site model) { return(this.dal.Add(model)); }
public int Add(Rain.Model.channel_site model) { using (OleDbConnection oleDbConnection = new OleDbConnection(DbHelperOleDb.connectionString)) { oleDbConnection.Open(); using (OleDbTransaction trans = oleDbConnection.BeginTransaction()) { try { StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append("insert into " + this.databaseprefix + "channel_site("); stringBuilder.Append("title,build_path,templet_path,[domain],[name],logo,company,address,tel,fax,email,crod,copyright,seo_title,seo_keyword,seo_description,is_default,sort_id)"); stringBuilder.Append(" values ("); stringBuilder.Append("@title,@build_path,@templet_path,@domain,@name,@logo,@company,@address,@tel,@fax,@email,@crod,@copyright,@seo_title,@seo_keyword,@seo_description,@is_default,@sort_id)"); OleDbParameter[] oleDbParameterArray = new OleDbParameter[18] { new OleDbParameter("@title", OleDbType.VarChar, 100), new OleDbParameter("@build_path", OleDbType.VarChar, 100), new OleDbParameter("@templet_path", OleDbType.VarChar, 100), new OleDbParameter("@domain", OleDbType.VarChar, (int)byte.MaxValue), new OleDbParameter("@name", OleDbType.VarChar, (int)byte.MaxValue), new OleDbParameter("@logo", OleDbType.VarChar, (int)byte.MaxValue), new OleDbParameter("@company", OleDbType.VarChar, (int)byte.MaxValue), new OleDbParameter("@address", OleDbType.VarChar, (int)byte.MaxValue), new OleDbParameter("@tel", OleDbType.VarChar, 30), new OleDbParameter("@fax", OleDbType.VarChar, 30), new OleDbParameter("@email", OleDbType.VarChar, 50), new OleDbParameter("@crod", OleDbType.VarChar, 100), new OleDbParameter("@copyright", OleDbType.VarChar), new OleDbParameter("@seo_title", OleDbType.VarChar, (int)byte.MaxValue), new OleDbParameter("@seo_keyword", OleDbType.VarChar, (int)byte.MaxValue), new OleDbParameter("@seo_description", OleDbType.VarChar, 500), new OleDbParameter("@is_default", OleDbType.Integer, 4), new OleDbParameter("@sort_id", OleDbType.Integer, 4) }; oleDbParameterArray[0].Value = (object)model.title; oleDbParameterArray[1].Value = (object)model.build_path; oleDbParameterArray[2].Value = (object)model.templet_path; oleDbParameterArray[3].Value = (object)model.domain; oleDbParameterArray[4].Value = (object)model.name; oleDbParameterArray[5].Value = (object)model.logo; oleDbParameterArray[6].Value = (object)model.company; oleDbParameterArray[7].Value = (object)model.address; oleDbParameterArray[8].Value = (object)model.tel; oleDbParameterArray[9].Value = (object)model.fax; oleDbParameterArray[10].Value = (object)model.email; oleDbParameterArray[11].Value = (object)model.crod; oleDbParameterArray[12].Value = (object)model.copyright; oleDbParameterArray[13].Value = (object)model.seo_title; oleDbParameterArray[14].Value = (object)model.seo_keyword; oleDbParameterArray[15].Value = (object)model.seo_description; oleDbParameterArray[16].Value = (object)model.is_default; oleDbParameterArray[17].Value = (object)model.sort_id; DbHelperOleDb.ExecuteSql(oleDbConnection, trans, stringBuilder.ToString(), oleDbParameterArray); model.id = this.GetMaxId(oleDbConnection, trans); new navigation(this.databaseprefix).Add(oleDbConnection, trans, "sys_contents", "channel_" + model.build_path, model.title, "", model.sort_id, 0, "Show"); trans.Commit(); } catch { trans.Rollback(); return(0); } } } return(model.id); }
public Rain.Model.channel_site DataRowToModel(DataRow row) { Rain.Model.channel_site channelSite = new Rain.Model.channel_site(); if (row != null) { if (row["id"] != null && row["id"].ToString() != "") { channelSite.id = int.Parse(row["id"].ToString()); } if (row["title"] != null) { channelSite.title = row["title"].ToString(); } if (row["build_path"] != null) { channelSite.build_path = row["build_path"].ToString(); } if (row["templet_path"] != null) { channelSite.templet_path = row["templet_path"].ToString(); } if (row["domain"] != null) { channelSite.domain = row["domain"].ToString(); } if (row["name"] != null) { channelSite.name = row["name"].ToString(); } if (row["logo"] != null) { channelSite.logo = row["logo"].ToString(); } if (row["company"] != null) { channelSite.company = row["company"].ToString(); } if (row["address"] != null) { channelSite.address = row["address"].ToString(); } if (row["tel"] != null) { channelSite.tel = row["tel"].ToString(); } if (row["fax"] != null) { channelSite.fax = row["fax"].ToString(); } if (row["email"] != null) { channelSite.email = row["email"].ToString(); } if (row["crod"] != null) { channelSite.crod = row["crod"].ToString(); } if (row["copyright"] != null) { channelSite.copyright = row["copyright"].ToString(); } if (row["seo_title"] != null) { channelSite.seo_title = row["seo_title"].ToString(); } if (row["seo_keyword"] != null) { channelSite.seo_keyword = row["seo_keyword"].ToString(); } if (row["seo_description"] != null) { channelSite.seo_description = row["seo_description"].ToString(); } if (row["is_default"] != null && row["is_default"].ToString() != "") { channelSite.is_default = int.Parse(row["is_default"].ToString()); } if (row["sort_id"] != null && row["sort_id"].ToString() != "") { channelSite.sort_id = int.Parse(row["sort_id"].ToString()); } } return(channelSite); }
public bool Update(Rain.Model.channel_site model, string old_build_path) { using (OleDbConnection oleDbConnection = new OleDbConnection(DbHelperOleDb.connectionString)) { oleDbConnection.Open(); using (OleDbTransaction trans = oleDbConnection.BeginTransaction()) { try { StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append("update " + this.databaseprefix + "channel_site set "); stringBuilder.Append("title=@title,"); stringBuilder.Append("build_path=@build_path,"); stringBuilder.Append("templet_path=@templet_path,"); stringBuilder.Append("[domain]=@domain,"); stringBuilder.Append("[name]=@name,"); stringBuilder.Append("logo=@logo,"); stringBuilder.Append("company=@company,"); stringBuilder.Append("address=@address,"); stringBuilder.Append("tel=@tel,"); stringBuilder.Append("fax=@fax,"); stringBuilder.Append("email=@email,"); stringBuilder.Append("crod=@crod,"); stringBuilder.Append("copyright=@copyright,"); stringBuilder.Append("seo_title=@seo_title,"); stringBuilder.Append("seo_keyword=@seo_keyword,"); stringBuilder.Append("seo_description=@seo_description,"); stringBuilder.Append("is_default=@is_default,"); stringBuilder.Append("sort_id=@sort_id"); stringBuilder.Append(" where id=@id"); OleDbParameter[] oleDbParameterArray = new OleDbParameter[19] { new OleDbParameter("@title", OleDbType.VarChar, 100), new OleDbParameter("@build_path", OleDbType.VarChar, 100), new OleDbParameter("@templet_path", OleDbType.VarChar, 100), new OleDbParameter("@domain", OleDbType.VarChar, (int)byte.MaxValue), new OleDbParameter("@name", OleDbType.VarChar, (int)byte.MaxValue), new OleDbParameter("@logo", OleDbType.VarChar, (int)byte.MaxValue), new OleDbParameter("@company", OleDbType.VarChar, (int)byte.MaxValue), new OleDbParameter("@address", OleDbType.VarChar, (int)byte.MaxValue), new OleDbParameter("@tel", OleDbType.VarChar, 30), new OleDbParameter("@fax", OleDbType.VarChar, 30), new OleDbParameter("@email", OleDbType.VarChar, 50), new OleDbParameter("@crod", OleDbType.VarChar, 100), new OleDbParameter("@copyright", (object)SqlDbType.Text), new OleDbParameter("@seo_title", OleDbType.VarChar, (int)byte.MaxValue), new OleDbParameter("@seo_keyword", OleDbType.VarChar, (int)byte.MaxValue), new OleDbParameter("@seo_description", OleDbType.VarChar, 500), new OleDbParameter("@is_default", OleDbType.Integer, 4), new OleDbParameter("@sort_id", OleDbType.Integer, 4), new OleDbParameter("@id", OleDbType.Integer, 4) }; oleDbParameterArray[0].Value = (object)model.title; oleDbParameterArray[1].Value = (object)model.build_path; oleDbParameterArray[2].Value = (object)model.templet_path; oleDbParameterArray[3].Value = (object)model.domain; oleDbParameterArray[4].Value = (object)model.name; oleDbParameterArray[5].Value = (object)model.logo; oleDbParameterArray[6].Value = (object)model.company; oleDbParameterArray[7].Value = (object)model.address; oleDbParameterArray[8].Value = (object)model.tel; oleDbParameterArray[9].Value = (object)model.fax; oleDbParameterArray[10].Value = (object)model.email; oleDbParameterArray[11].Value = (object)model.crod; oleDbParameterArray[12].Value = (object)model.copyright; oleDbParameterArray[13].Value = (object)model.seo_title; oleDbParameterArray[14].Value = (object)model.seo_keyword; oleDbParameterArray[15].Value = (object)model.seo_description; oleDbParameterArray[16].Value = (object)model.is_default; oleDbParameterArray[17].Value = (object)model.sort_id; oleDbParameterArray[18].Value = (object)model.id; DbHelperOleDb.ExecuteSql(oleDbConnection, trans, stringBuilder.ToString(), oleDbParameterArray); if (new navigation(this.databaseprefix).GetModel(oleDbConnection, trans, "channel_" + old_build_path) != null) { new navigation(this.databaseprefix).Update(oleDbConnection, trans, "channel_" + old_build_path, "channel_" + model.build_path, model.title, model.sort_id); } else { new navigation(this.databaseprefix).Add(oleDbConnection, trans, "sys_contents", "channel_" + model.build_path, model.title, "", model.sort_id, 0, "Show"); } trans.Commit(); } catch { trans.Rollback(); return(false); } } } return(true); }