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 }));
}
