/// <summary> /// 得到一个对象实体 /// </summary> public Model.Department_Model GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ID,DepartName from Stale_Department "); strSql.Append(" where ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = ID; Model.Department_Model model = new Model.Department_Model(); DataTable dt = DbHelperSQL.GetDateSet(strSql.ToString(), parameters); if (dt.Rows.Count > 0) { if (dt.Rows[0]["ID"].ToString() != "") { model.ID = int.Parse(dt.Rows[0]["ID"].ToString()); } model.DepartName = dt.Rows[0]["DepartName"].ToString(); return(model); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public int Update(Model.Department_Model model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Stale_Department set "); strSql.Append("DepartName=@DepartName,"); strSql.Append(" where ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int, 4), new SqlParameter("@DepartName", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.ID; parameters[1].Value = model.DepartName; return(DbHelperSQL.ExecuteCommand(strSql.ToString(), parameters)); }
/// <summary> /// 更新一条数据 /// </summary> public int Update(Model.Department_Model model) { return(dals.Update(model)); }