/// <summary>
/// 得到一个对象实体
/// </summary>
/// <param name="ID">主键ID</param>
/// <returns>NewsClass对象</returns>
public ClassLibrary.Model.NewsClass GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT ID,ClassName,CreatedTime");
strSql.Append(" FROM ");
strSql.Append(table);
strSql.Append(string.Format(" WHERE {0}=@{0}", pk));
SqlParameter[] parameters =
{
new SqlParameter("@" + pk, SqlDbType.Int, 4)
};
parameters[0].Value = ID;
ClassLibrary.Model.NewsClass model = new ClassLibrary.Model.NewsClass();
DataTable dt = SQLHelper.Query(strSql.ToString(), parameters);
model.ID = ID;
if (dt.Rows.Count > 0)
{
if (dt.Rows[0]["ClassName"] != DBNull.Value)
{
model.ClassName = Convert.ToString(dt.Rows[0]["ClassName"]);
}
if (dt.Rows[0]["CreatedTime"] != DBNull.Value)
{
model.CreatedTime = Convert.ToDateTime(dt.Rows[0]["CreatedTime"]);
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
/// <param name="model">NewsClass对象</param>
public int Add(ClassLibrary.Model.NewsClass model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(string.Format("INSERT INTO {0}(", table));
strSql.Append("ClassName,CreatedTime");
strSql.Append(") VALUES (");
strSql.Append("@ClassName,@CreatedTime)");
SqlParameter[] parameters =
{
new SqlParameter("@ClassName", SqlDbType.NVarChar, 40),
new SqlParameter("@CreatedTime", SqlDbType.DateTime, 8)
};
parameters[0].Value = model.ClassName;
parameters[1].Value = model.CreatedTime;
return(SQLHelper.Execute(strSql.ToString(), parameters));
}
/// <summary>
/// 更新一条数据
/// </summary>
/// <param name="model">NewsClass对象</param>
/// <returns>影响行数</returns>
public int Update(ClassLibrary.Model.NewsClass model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(string.Format("UPDATE {0} SET ", table));
strSql.Append("ClassName=@ClassName,");
strSql.Append("CreatedTime=@CreatedTime");
strSql.Append(" WHERE ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4),
new SqlParameter("@ClassName", SqlDbType.NVarChar, 40),
new SqlParameter("@CreatedTime", SqlDbType.DateTime, 8)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.ClassName;
parameters[2].Value = model.CreatedTime;
return(SQLHelper.Execute(strSql.ToString(), parameters));
}
public void AddNewsClass()
{
ClassLibrary.BLL.NewsClass newsClassBLL = new ClassLibrary.BLL.NewsClass();
ClassLibrary.Model.NewsClass newsClassModel = new ClassLibrary.Model.NewsClass();
if (string.IsNullOrEmpty(Request.Form["ClassName"]))
{
Response.Write("<script>alert('请输入新闻类型！');history.back(-1);</script>");
return;
}
else
{
newsClassModel.ClassName = Request.Form["ClassName"];
}
if (newsClassBLL.Add(newsClassModel) > 0)
{
Function.goMessagePage("添加新闻类型", "操作成功", "NewsClass/NewsClassList.aspx");
}
else
{
Function.goMessagePage("添加新闻类型", "操作失败，请稍后再试", "NewsClass/NewsClassList.aspx");
}
}
private void EditNewsClass()
{
ClassLibrary.Model.NewsClass newsClassModel = new ClassLibrary.Model.NewsClass();
newsClassModel.ID = newsClassId;
if (string.IsNullOrEmpty(Request.Form["ClassName"]))
{
Response.Write("<script>alert('请输入路线类型！');history.back(-1);</script>");
return;
}
else
{
newsClassModel.ClassName = Request.Form["ClassName"];
if (newsClassBLL.Update(newsClassModel) > 0)
{
Function.goMessagePage("修改路线类型", "操作成功", "RouteClass/RouteClassList.aspx");
}
else
{
Function.goMessagePage("修改路线类型", "操作失败，请稍后再试", "RouteClass/RouteClassList.aspx");
}
}
}
private void BindData()
{
searchKey = Function.GetQueryString("key");
int routeClassID = 0;
string sqlwhere = "1=1";
//搜索 - 大类
searchClass1 = Function.GetQueryString("cid1");
if (Function.IsNumber(searchClass1))
{
routeClassID = Convert.ToInt32(searchClass1);
}
//搜索 - 小类
searchClass2 = Function.GetQueryString("cid2");
if (Function.IsNumber(searchClass2))
{
routeClassID = Convert.ToInt32(searchClass2);
}
if (newsClassIDs == null || newsClassIDs.Equals(""))
{
newsClassIDs = Function.GetQueryString("hidden_newsClassId");
}
sqlwhere += " and newsClassID in (" + newsClassIDs + ")";
if (routeClassID != 0)
{
sqlwhere += " and CHARINDEX('," + routeClassID + ",',','+routeClassID+',')>0";
}
if (!string.IsNullOrEmpty(searchKey))
{
sqlwhere += " AND CHARINDEX('" + searchKey + "',Title)>0";
}
DataSet mySet = newsBLL.GetPageData(pageSize, pageIndex, sqlwhere, "CreatedTime Desc");
DataTable tableCount = mySet.Tables["Count"];
DataTable myTable = mySet.Tables["Data"];
int countRows = 0;
countRows = Convert.ToInt32(tableCount.Rows[0][0].ToString());
string[] urlParam = { "cid", "cid1", "cid2", "key" };
pageInfo = pg.pageForDynamic(countRows, pageSize, pageIndex, urlParam);
StringBuilder sb = new StringBuilder();
int i = 0;
int rowIndex = 0;
string temClassName = "无类型";
string pingyin = "";
ClassLibrary.Model.RouteClass temRClass;
foreach (DataRow dr in myTable.Rows)
{
i++;
rowIndex = pageSize * (pageIndex - 1) + i;
if (dr["routeClassID"].ToString() != "")
{
string tmpRouteClassID = "";
if (dr["LocationID"] != DBNull.Value && Convert.ToInt32(dr["LocationID"].ToString()) != 0)
{
tmpRouteClassID = dr["LocationID"].ToString();
}
else
{
tmpRouteClassID = dr["routeClassID"].ToString().Split(',')[2];
}
temRClass = rcList.Find(delegate(ClassLibrary.Model.RouteClass tm) { return(tm.ID == Convert.ToInt32(tmpRouteClassID)); });
temClassName = temRClass.ClassName;
pingyin = temRClass.ClassNamePY;
}
sb.AppendFormat("<tr id='tr_{0}'>", dr["ID"].ToString());
//sb.AppendFormat("<td align='center'>{0}</td>", rowIndex);
sb.AppendFormat("<td align='center'><input type='checkbox' name='newsCheckbox' id='checkbox{0}' value='{0}' /></td>", dr["ID"].ToString());
sb.AppendFormat("<td><a href='/{3}/{1}.html' title='{2}' target='_blank'>{0}</a></td>", Function.Clip(dr["Title"].ToString(), 15, true), dr["ID"].ToString(), dr["Title"].ToString(), Enum.GetName(typeof(SysConfig.NewsClassPY), Convert.ToInt32(dr["newsClassID"].ToString())));
ClassLibrary.Model.NewsClass temNClass = nList.Find(delegate(ClassLibrary.Model.NewsClass nm) { return(nm.ID == Convert.ToInt32(dr["newsClassID"].ToString())); });
sb.AppendFormat("<td align='center'>{0}</td>", temNClass.ClassName);
sb.AppendFormat("<td align='center'>{0}</td>", temClassName);
sb.AppendFormat("<td align='center'>{0}</td>", dr["ViewCount"].ToString());
sb.AppendFormat("<td align='center'>{0}</td>", Convert.ToBoolean(dr["IsDisplay"]) ? "<span class='red'>是</span>" : "否");
sb.AppendFormat("<td align='center'>{0}</td>", dr["CreatedTime"].ToString());
sb.Append("<td align='center'>");
sb.AppendFormat("<a href='NewsEdit.aspx?cid={0}&id={1}'>修改</a> ", newsClassIDs, dr["ID"].ToString());
sb.AppendFormat("<a href='javascript:void(0)' onclick='newsDelete({0},\"{1}\")'>删除</a>", dr["ID"].ToString(), ""); //dr["Image"].ToString()
sb.Append("</td>");
sb.Append("</tr>");
}
if (sb.Length == 0)
{
sb.Append("<tr><td colspan='7'>没有相关数据</td></tr>");
}
dataNewsList = sb.ToString();
}
