protected void ButtonOK_Click(object sender, EventArgs e) { TbClass Class = new TbClass(); Class.BjName = this.textName.Text; Class.Nj = this.textNj.Text; Class.ZyID = int.Parse(this.textZy.SelectedValue);//专业 DataTable table = TbClassManager.Sel_Bj(Class.BjName, Class.Nj); int Count = table.Rows.Count; if (hidClassID.Value != "") { Class.BjID = int.Parse(this.hidClassID.Value); TbClassManager.EditClassByID(Class); this.hidClassID.Value = ""; this.textName.Text = ""; this.textNj.Text = ""; } else { TbClassManager.AddClass(Class.BjName, Class.Nj, Class.ZyID); textName.Text = ""; textNj.Text = ""; } GetPageInfo(); }
/// <summary> /// 根据班级ID查询对应详细详细 /// </summary> /// <param name="BjID">班级ID</param> private void GetClass(int BjID) { TbClass Class = TbClassManager.GetClassByID(BjID); string ZyName = TbSpecialityManager.GetSpecialityName(Class.ZyID);//获取专业ID对应的专业名称 string message = Class.BjID + "|" + Class.BjName + "|" + Class.Nj + "|" + ZyName; Response.Write(message); }
/// <summary> /// 根据班级ID修改其对应的班级信息 /// </summary> /// <param name="Class">班级对象</param> /// <returns></returns> public int EditClassByID(TbClass Class) { string sql = "update dbo.tbClass set BjName=@BjName,Nj=@Nj,ZyID=@ZyID where BjID=@BjID"; SqlParameter[] paras = new SqlParameter[] { new SqlParameter("@BjName", Class.BjName), new SqlParameter("@Nj", Class.Nj), new SqlParameter("@ZyID", Class.ZyID), new SqlParameter("@BjID", Class.BjID) }; return(DBHelper.ExecuteCommand(sql, paras)); }
private async Task SetupClassData() { using (var db = new ApplicationDbContext(_dbContextOptions)) { var user = new ApplicationUser { UserName = "******", Id = Guid.Parse("10000000-0000-0000-0000-000000000000").ToString() }; var user2 = new ApplicationUser { UserName = "******", Id = Guid.Parse("20000000-0000-0000-0000-000000000000").ToString() }; var user3 = new ApplicationUser { UserName = "******", Id = Guid.Parse("30000000-0000-0000-0000-000000000000").ToString() }; await db.Users.AddRangeAsync(user, user2, user3); await db.SaveChangesAsync(); var class1 = new TbClass { ClassName = "Class 1", UserId = Guid.Parse("10000000-0000-0000-0000-000000000000").ToString() }; var class2 = new TbClass { ClassName = "Class 2", UserId = Guid.Parse("20000000-0000-0000-0000-000000000000").ToString() }; var class3 = new TbClass { ClassName = "Class 3", UserId = Guid.Parse("10000000-0000-0000-0000-000000000000").ToString() }; await db.TbClass.AddRangeAsync(class1, class2); await db.SaveChangesAsync(); } }
/// <summary> /// 获取所有班级列表 /// </summary> /// <returns></returns> public List <TbClass> GetAllClassList() { List <TbClass> ClassList = new List <TbClass>(); TbClass sbt = null; string sql = "select * from TbClass"; SqlDataReader reader = DBHelper.GetReader(sql); while (reader.Read()) { sbt = new TbClass(); sbt.Nj = reader["Nj"].ToString(); sbt.BjName = reader["BjName"].ToString(); sbt.ZyID = (int)reader["ZyID"]; ClassList.Add(sbt); } reader.Close(); return(ClassList); }
/// <summary> /// 根据班级ID返回对应详细详细 /// </summary> /// <param name="BjID">班级ID</param> /// <returns></returns> public TbClass GetClassByID(int BjID) { TbClass Class = null; string sql = "select * from dbo.tbClass where BjID=@BjID"; SqlParameter[] paras = new SqlParameter[] { new SqlParameter("@BjID", BjID) }; SqlDataReader reader = DBHelper.GetReader(sql, paras); if (reader.Read()) { Class = new TbClass(); Class.BjID = BjID; Class.BjName = reader["BjName"].ToString(); Class.Nj = reader["Nj"].ToString(); Class.ZyID = int.Parse(reader["ZyID"].ToString()); reader.Close(); } return(Class); }
/// <summary> /// 根据班级ID修改其对应的班级信息 /// </summary> /// <param name="Class">班级对象</param> /// <returns></returns> public static int EditClassByID(TbClass Class) { return(tbclass.EditClassByID(Class)); }
public JsonResult Add(TbClass tbClass) { _db.TbClass.Add(tbClass); return(new JsonResult(new { code = _db.SaveChanges() > 0 })); }