/// <summary> /// 添加内容到数据库 /// </summary> /// <param name="FieldList"></param> /// <param name="FieldValue"></param> /// <param name="CommonData"></param> int ID_CommonModel.AddContent(string FieldList, string FieldValue, M_CommonData CommonData) { string strSql = "Insert Into " + CommonData.TableName + " (" + FieldList + ") values(" + FieldValue + ");select @@IDENTITY AS newID"; //SqlHelper.ExecuteSql(strSql); int ItemID = SqlHelper.ObjectToInt32(SqlHelper.ExecuteScalar(CommandType.Text, strSql, null)); string strSql2 = "Insert Into ZL_CommonModel (NodeID,ModelID,ItemID,TableName,Title,Inputer,EliteLevel,InfoID,SpecialID,Template,Status) Values (" + CommonData.NodeID + "," + CommonData.ModelID + "," + ItemID + ",'" + CommonData.TableName + "','" + CommonData.Title + "','" + CommonData.Inputer + "'," + CommonData.EliteLevel + ",'" + CommonData.InfoID + "','" + CommonData.SpecialID + "','" + CommonData.Template + "'," + CommonData.Status + ")"; SqlHelper.ExecuteSql(strSql2); return ItemID; }
/// <summary> /// 添加内容到数据库 返回新内容ID /// </summary> /// <param name="ContentDT">存储内容字段及其值的数据表</param> /// <param name="CommonData">存储内容公共数据的表</param> /// <returns>新内容ID</returns> public int AddContent(DataTable ContentDT, M_CommonData CommonData) { string FieldList = ""; string FieldValue = ""; foreach (DataRow dr in ContentDT.Rows) { if (string.IsNullOrEmpty(FieldList)) { FieldList = dr["FieldName"].ToString(); } else { FieldList = FieldList + "," + dr["FieldName"].ToString(); } if (string.IsNullOrEmpty(FieldValue)) FieldValue = this.GetFieldValue(dr); else FieldValue = FieldValue + "," + this.GetFieldValue(dr); } return dal.AddContent(FieldList, FieldValue, CommonData); }
protected void EBtnSubmit_Click(object sender, EventArgs e) { if (this.Page.IsValid) { this.ModelID = DataConverter.CLng(this.HdnModel.Value); this.NodeID = DataConverter.CLng(this.HdnNode.Value); DataTable dt = this.bfield.GetModelFieldList(this.ModelID).Tables[0]; DataTable table = new DataTable(); table.Columns.Add(new DataColumn("FieldName", typeof(string))); table.Columns.Add(new DataColumn("FieldType", typeof(string))); table.Columns.Add(new DataColumn("FieldValue", typeof(string))); foreach (DataRow dr in dt.Rows) { if (DataConverter.CBool(dr["IsNotNull"].ToString())) { if (string.IsNullOrEmpty(this.Page.Request.Form["txt_" + dr["FieldName"].ToString()])) { function.WriteErrMsg(dr["FieldAlias"].ToString() + "不能为空!"); } } if (dr["FieldType"].ToString() == "FileType") { string[] Sett = dr["Content"].ToString().Split(new char[] { ',' }); bool chksize = DataConverter.CBool(Sett[0].Split(new char[] { '=' })[1]); string sizefield = Sett[1].Split(new char[] { '=' })[1]; if (chksize && sizefield != "") { DataRow row2 = table.NewRow(); row2[0] = sizefield; row2[1] = "FileSize"; row2[2] = this.Page.Request.Form["txt_" + sizefield]; table.Rows.Add(row2); } } if (dr["FieldType"].ToString() == "MultiPicType") { string[] Sett = dr["Content"].ToString().Split(new char[] { ',' }); bool chksize = DataConverter.CBool(Sett[0].Split(new char[] { '=' })[1]); string sizefield = Sett[1].Split(new char[] { '=' })[1]; if (chksize && sizefield != "") { if (string.IsNullOrEmpty(this.Page.Request.Form["txt_" + sizefield])) { function.WriteErrMsg(dr["FieldAlias"].ToString() + "的缩略图不能为空!"); } DataRow row1 = table.NewRow(); row1[0] = sizefield; row1[1] = "ThumbField"; row1[2] = this.Page.Request.Form["txt_" + sizefield]; table.Rows.Add(row1); } } DataRow row = table.NewRow(); row[0] = dr["FieldName"].ToString(); row[1] = dr["FieldType"].ToString(); row[2] = this.Page.Request.Form["txt_" + dr["FieldName"].ToString()]; table.Rows.Add(row); } M_CommonData CData = new M_CommonData(); CData.NodeID = this.NodeID; CData.ModelID = this.ModelID; CData.TableName = this.bmode.GetModelById(this.ModelID).TableName; CData.Title = this.txtTitle.Text; CData.Status = 99; CData.Inputer = "admin"; CData.EliteLevel = this.ChkAudit.Checked ? 1 : 0; CData.InfoID = ""; CData.SpecialID = ""; CData.Template = this.TxtTemplate.Text; int newID = this.bll.AddContent(table, CData); string specialid = this.HdnSpec.Value; if (!string.IsNullOrEmpty(specialid)) { string[] arr = specialid.Split(new char[] { ',' }); M_SpecInfo info = new M_SpecInfo(); info.InfoID = newID; for (int i = 0; i < arr.Length; i++) { info.SpecialID = DataConverter.CLng(arr[i]); this.bspec.Add(info); } } Response.Write("<script>alert('内容添加成功!请继续添加')</script>"); //Response.Redirect("ContentManage.aspx?NodeID="+this.NodeID); } }
protected void EBtnSubmit_Click(object sender, EventArgs e) { if (this.Page.IsValid) { this.ModelID = DataConverter.CLng(this.HdnModel.Value); this.NodeID = DataConverter.CLng(this.HdnNode.Value); DataTable dt = this.bfield.GetModelFieldList(this.ModelID).Tables[0]; DataTable table = new DataTable(); table.Columns.Add(new DataColumn("FieldName", typeof(string))); table.Columns.Add(new DataColumn("FieldType", typeof(string))); table.Columns.Add(new DataColumn("FieldValue", typeof(string))); foreach (DataRow dr in dt.Rows) { if (DataConverter.CBool(dr["IsNotNull"].ToString())) { if (string.IsNullOrEmpty(this.Page.Request.Form["txt_" + dr["FieldName"].ToString()])) { function.WriteErrMsg(dr["FieldAlias"].ToString() + "不能为空!"); } } if (dr["FieldType"].ToString() == "FileType") { string[] Sett = dr["Content"].ToString().Split(new char[] { ',' }); bool chksize = DataConverter.CBool(Sett[0].Split(new char[] { '=' })[1]); string sizefield = Sett[1].Split(new char[] { '=' })[1]; if (chksize && sizefield != "") { DataRow row2 = table.NewRow(); row2[0] = sizefield; row2[1] = "FileSize"; row2[2] = this.Page.Request.Form["txt_" + sizefield]; table.Rows.Add(row2); } } if (dr["FieldType"].ToString() == "MultiPicType") { string[] Sett = dr["Content"].ToString().Split(new char[] { ',' }); bool chksize = DataConverter.CBool(Sett[0].Split(new char[] { '=' })[1]); string sizefield = Sett[1].Split(new char[] { '=' })[1]; if (chksize && sizefield != "") { if (string.IsNullOrEmpty(this.Page.Request.Form["txt_" + sizefield])) { function.WriteErrMsg(dr["FieldAlias"].ToString() + "的缩略图不能为空!"); } DataRow row1 = table.NewRow(); row1[0] = sizefield; row1[1] = "ThumbField"; row1[2] = this.Page.Request.Form["txt_" + sizefield]; table.Rows.Add(row1); } } DataRow row = table.NewRow(); row[0] = dr["FieldName"].ToString(); row[1] = dr["FieldType"].ToString(); row[2] = this.Page.Request.Form["txt_" + dr["FieldName"].ToString()]; table.Rows.Add(row); } string uname = HttpContext.Current.Request.Cookies["UserState"]["LoginName"]; this.UserInfo = buser.GetUserByName(uname); M_CommonData CData = new M_CommonData(); CData.NodeID = this.NodeID; CData.ModelID = this.ModelID; CData.TableName = this.bmode.GetModelById(this.ModelID).TableName; CData.Title = this.txtTitle.Text; CData.Inputer = this.UserInfo.UserName; CData.EliteLevel = 0; CData.Status = 0; CData.InfoID = ""; CData.SpecialID = ""; int newID = this.bll.AddContent(table, CData); //添加到专题 //string specialid = this.HdnSpec.Value; //if (!string.IsNullOrEmpty(specialid)) //{ // string[] arr = specialid.Split(new char[] { ',' }); // M_SpecInfo info = new M_SpecInfo(); // info.InfoID = newID; // for (int i = 0; i < arr.Length; i++) // { // info.SpecialID = DataConverter.CLng(arr[i]); // this.bspec.Add(info); // } //} Response.Redirect("MyContent.aspx?NodeID=" + this.NodeID); } }
/// <summary> /// 更新内容 /// </summary> /// <param name="FieldSet"></param> /// <param name="CommonData"></param> void ID_CommonModel.UpdateContent(string FieldSet, M_CommonData CommonData) { string strSql = "Update " + CommonData.TableName + " Set " + FieldSet + " Where [ID]=" + CommonData.ItemID; SqlHelper.ExecuteSql(strSql); string strSql2 = "Update ZL_CommonModel Set Title='" + CommonData.Title + "',EliteLevel=" + CommonData.EliteLevel + ",InfoID='" + CommonData.InfoID + "',SpecialID='" + CommonData.SpecialID + "',Template='" + CommonData.Template + "' Where GeneralID=" + CommonData.GeneralID; SqlHelper.ExecuteSql(strSql2); }
/// <summary> /// 获取内容信息不含公用信息 /// </summary> /// <param name="GeneralID"></param> /// <returns></returns> DataTable ID_CommonModel.GetContent(M_CommonData CommonData) { string strSql = "PR_Content_Read"; SqlParameter[] cmdParam = new SqlParameter[] { new SqlParameter("@TableName",SqlDbType.NVarChar), new SqlParameter("@ItemID",SqlDbType.Int) }; cmdParam[0].Value = CommonData.TableName; cmdParam[1].Value = CommonData.ItemID; return SqlHelper.ExecuteTable(CommandType.StoredProcedure, strSql, cmdParam); }
/// <summary> /// 获取内容公用信息 /// </summary> /// <param name="GeneralID"></param> /// <returns></returns> M_CommonData ID_CommonModel.GetCommonData(int GeneralID) { string strSql = "PR_Content_Common"; SqlParameter[] cmdParam = new SqlParameter[] { new SqlParameter("@GeneralID",SqlDbType.Int) }; cmdParam[0].Value = GeneralID; using (SqlDataReader reader = SqlHelper.ExecuteReader(CommandType.StoredProcedure, strSql, cmdParam)) { if (reader.Read()) { M_CommonData info = new M_CommonData(); info.GeneralID = GeneralID; info.NodeID = DataConverter.CLng(reader["NodeID"]); info.ModelID = DataConverter.CLng(reader["ModelID"]); info.ItemID = DataConverter.CLng(reader["ItemID"]); info.TableName = reader["TableName"].ToString(); info.Title = reader["Title"].ToString(); info.Inputer = reader["Inputer"].ToString(); info.EliteLevel = DataConverter.CLng(reader["EliteLevel"]); info.InfoID = reader["InfoID"].ToString(); info.SpecialID = reader["SpecialID"].ToString(); info.IsCreate = DataConverter.CLng(reader["IsCreate"].ToString()); info.HtmlLink = reader["HtmlLink"].ToString(); info.Hits = DataConverter.CLng(reader["Hits"].ToString()); info.Template = reader["Template"].ToString(); info.Status = DataConverter.CLng(reader["Status"].ToString()); return info; } else return new M_CommonData(true); } }
/// <summary> /// 彻底删除内容数据 /// </summary> /// <param name="CommonData"></param> void ID_CommonModel.DelContent(M_CommonData CommonData) { string strSql = "PR_Content_Del"; SqlParameter[] cmdParam = new SqlParameter[] { new SqlParameter("@TableName",SqlDbType.NVarChar), new SqlParameter("@ItemID",SqlDbType.Int), new SqlParameter("@GeneralID",SqlDbType.Int) }; cmdParam[0].Value = CommonData.TableName; cmdParam[1].Value = CommonData.ItemID; cmdParam[2].Value = CommonData.GeneralID; SqlHelper.ExecuteProc(strSql, cmdParam); }
/// <summary> /// 更新内容 /// </summary> /// <param name="ContentDT"></param> /// <param name="CommonData"></param> public void UpdateContent(DataTable ContentDT, M_CommonData CommonData) { string FieldSet = ""; foreach (DataRow dr in ContentDT.Rows) { if (string.IsNullOrEmpty(FieldSet)) FieldSet = this.GetFieldSet(dr); else FieldSet = FieldSet + "," + this.GetFieldSet(dr); } dal.UpdateContent(FieldSet, CommonData); }