public ActionResult Create(string ID)
{
List <SelectListItem> select1 = new List <SelectListItem>();
select1.Add(new SelectListItem
{
Text = "请选择",
Value = ""
});
List <DBA.Model.Category> list = cbll.GetModelList("");
for (int i = 0; i < list.Count; i++)
{
select1.Add(new SelectListItem
{
Text = list[i].CategoryName,
Value = list[i].CategoryName
});
}
;
ViewData["Category"] = new SelectList(select1, "Value", "Text", "");
if (string.IsNullOrEmpty(ID))
{
DBA.Model.Topic model = new DBA.Model.Topic();
return(View(model));
}
else
{
return(View(bll.GetModel(Convert.ToInt32(ID))));
}
}
public JsonResult WC(string ID)
{
DBA.Model.Topic model = bll.GetModel(Convert.ToInt32(ID));
model.HTNum = "处理完成";
bll.Update(model);
return(Json(true));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(DBA.Model.Topic model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Topic(");
strSql.Append("Title,Time,UserID,UserName,TopicContent,Category,CategoryID,LastTime,HTNum,Str1,Str2,Str3,Str4,Str5)");
strSql.Append(" values (");
strSql.Append("@Title,@Time,@UserID,@UserName,@TopicContent,@Category,@CategoryID,@LastTime,@HTNum,@Str1,@Str2,@Str3,@Str4,@Str5)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("Title", SqlDbType.NVarChar, 200),
new SqlParameter("Time", SqlDbType.NVarChar, 200),
new SqlParameter("UserID", SqlDbType.NVarChar, 200),
new SqlParameter("UserName", SqlDbType.NVarChar, 200),
new SqlParameter("TopicContent", SqlDbType.NText),
new SqlParameter("Category", SqlDbType.NVarChar, 200),
new SqlParameter("CategoryID", SqlDbType.NVarChar, 200),
new SqlParameter("LastTime", SqlDbType.NVarChar, 200),
new SqlParameter("HTNum", SqlDbType.NVarChar, 200),
new SqlParameter("Str1", SqlDbType.NVarChar, 200),
new SqlParameter("Str2", SqlDbType.NVarChar, 200),
new SqlParameter("Str3", SqlDbType.NVarChar, 200),
new SqlParameter("Str4", SqlDbType.NVarChar, 200),
new SqlParameter("Str5", SqlDbType.NVarChar, 200)
};
parameters[0].Value = model.Title;
parameters[1].Value = model.Time;
parameters[2].Value = model.UserID;
parameters[3].Value = model.UserName;
parameters[4].Value = model.TopicContent;
parameters[5].Value = model.Category;
parameters[6].Value = model.CategoryID;
parameters[7].Value = model.LastTime;
parameters[8].Value = model.HTNum;
parameters[9].Value = model.Str1;
parameters[10].Value = model.Str2;
parameters[11].Value = model.Str3;
parameters[12].Value = model.Str4;
parameters[13].Value = model.Str5;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public DBA.Model.Topic GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,Title,Time,UserID,UserName,TopicContent,Category,CategoryID,LastTime,HTNum,Str1,Str2,Str3,Str4,Str5,RejectNum from Topic ");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = ID;
DBA.Model.Topic model = new DBA.Model.Topic();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
public ActionResult Edit(DBA.Model.Topic model)
{
bll.Edit(model);
return(RedirectToAction("TopicManage"));
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(DBA.Model.Topic model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Topic set ");
strSql.Append("Title=@Title,");
strSql.Append("Time=@Time,");
strSql.Append("UserID=@UserID,");
strSql.Append("UserName=@UserName,");
strSql.Append("TopicContent=@TopicContent,");
strSql.Append("Category=@Category,");
strSql.Append("CategoryID=@CategoryID,");
strSql.Append("LastTime=@LastTime,");
strSql.Append("HTNum=@HTNum,");
strSql.Append("Str1=@Str1,");
strSql.Append("Str2=@Str2,");
strSql.Append("Str3=@Str3,");
strSql.Append("Str4=@Str4,");
strSql.Append("Str5=@Str5");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@Title", SqlDbType.NVarChar, 200),
new SqlParameter("@Time", SqlDbType.NVarChar, 200),
new SqlParameter("@UserID", SqlDbType.NVarChar, 200),
new SqlParameter("@UserName", SqlDbType.NVarChar, 200),
new SqlParameter("@TopicContent", SqlDbType.NText),
new SqlParameter("@Category", SqlDbType.NVarChar, 200),
new SqlParameter("@CategoryID", SqlDbType.NVarChar, 200),
new SqlParameter("@LastTime", SqlDbType.NVarChar, 200),
new SqlParameter("@HTNum", SqlDbType.NVarChar, 200),
new SqlParameter("@Str1", SqlDbType.NVarChar, 200),
new SqlParameter("@Str2", SqlDbType.NVarChar, 200),
new SqlParameter("@Str3", SqlDbType.NVarChar, 200),
new SqlParameter("@Str4", SqlDbType.NVarChar, 200),
new SqlParameter("@Str5", SqlDbType.NVarChar, 200),
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = model.Title;
parameters[1].Value = model.Time;
parameters[2].Value = model.UserID;
parameters[3].Value = model.UserName;
parameters[4].Value = model.TopicContent;
parameters[5].Value = model.Category;
parameters[6].Value = model.CategoryID;
parameters[7].Value = model.LastTime;
parameters[8].Value = model.HTNum;
parameters[9].Value = model.Str1;
parameters[10].Value = model.Str2;
parameters[11].Value = model.Str3;
parameters[12].Value = model.Str4;
parameters[13].Value = model.Str5;
parameters[14].Value = model.ID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public DBA.Model.Topic DataRowToModel(DataRow row)
{
DBA.Model.Topic model = new DBA.Model.Topic();
if (row != null)
{
if (row["ID"] != null && row["ID"].ToString() != "")
{
model.ID = int.Parse(row["ID"].ToString());
}
if (row["Title"] != null)
{
model.Title = row["Title"].ToString();
}
if (row["Time"] != null)
{
model.Time = row["Time"].ToString();
}
if (row["UserID"] != null)
{
model.UserID = row["UserID"].ToString();
}
if (row["UserName"] != null)
{
model.UserName = row["UserName"].ToString();
}
if (row["TopicContent"] != null)
{
model.TopicContent = row["TopicContent"].ToString();
}
if (row["Category"] != null)
{
model.Category = row["Category"].ToString();
}
if (row["CategoryID"] != null)
{
model.CategoryID = row["CategoryID"].ToString();
}
if (row["LastTime"] != null)
{
model.LastTime = row["LastTime"].ToString();
}
if (row["HTNum"] != null)
{
model.HTNum = row["HTNum"].ToString();
}
if (row["Str1"] != null)
{
model.Str1 = row["Str1"].ToString();
}
if (row["Str2"] != null)
{
model.Str2 = row["Str2"].ToString();
}
if (row["Str3"] != null)
{
model.Str3 = row["Str3"].ToString();
}
if (row["Str4"] != null)
{
model.Str4 = row["Str4"].ToString();
}
if (row["Str5"] != null)
{
model.Str5 = row["Str5"].ToString();
}
if (row["RejectNum"] != null)
{
model.RejectNum = row["RejectNum"].ToString();
}
}
return(model);
}
