/// <summary>
/// 根据CollegeID查询
/// </summary>
/// <param name="collegeID"></param>
/// <returns></returns>
public List <T_Class> LoadClass(int collegeID)
{
string t_sql = "Select_ClassRegex";
SqlParameter par = new SqlParameter("@collegeID", SqlDbType.Int)
{
Value = collegeID
};
SqlHelper sqlhelper = new SqlHelper();
List <T_Class> res = null;
using (SqlDataReader reader = sqlhelper.ExecuteReader(t_sql, CommandType.StoredProcedure, par))
{
if (reader.HasRows)
{
res = new List <T_Class>();
while (reader.Read())
{
var id = reader.GetInt32(0);
var name = reader.GetString(1);
var college = reader.GetInt32(2);
T_Class @class = new T_Class(id, name, college);
res.Add(@class);
}
}
}
return(res);
}
/// <summary>
/// 加载指定班级下的T_Course
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void ComClass_SelectedIndexChanged(object sender, EventArgs e)
{
T_CourseDAL dal = new T_CourseDAL();
T_Class @class = comClass.SelectedItem as T_Class;
if (@class == null)
{
ucBtnExt2_BtnClick(null, null);
}
comCourse.DataSource = dal.ExecuteT_ClassSetUpCourseTeach(@class.ClassID);
}
public T_Class ReadClass <T_Class>()
{
int classLength = m_NetworkBuffer.ReadInt32();
m_NetworkBuffer._AssertNotOverflow(classLength);
var memoryBuffer = new System.IO.MemoryStream(m_Buffer, m_NetworkBuffer.Offset, classLength);
T_Class classInstance = ProtoBuf.Serializer.Deserialize <T_Class>(memoryBuffer);
m_NetworkBuffer = new NetworkBuffer(m_Buffer, m_NetworkBuffer.Offset + classLength, m_PacketHeader.PacketByteLength);
return(classInstance);
}
private void ucBtnExt1_BtnClick(object sender, EventArgs e)
{
if (comClass.Items.Count < 0 || comCourse.Items.Count < 0)
{
return;
}
T_Class @class = comClass.SelectedItem as T_Class;
T_InsertedFactionModel course = comCourse.SelectedItem as T_InsertedFactionModel;
if (@class == null || course == null)
{
return;
}
DialogResult = DialogResult.OK;
values = new string[2] {
@class.ClassID.ToString(), course.CourseID.ToString()
};
Close();
}
/// <summary>
/// 模糊查询
/// </summary>
/// <param name="t_sql"></param>
/// <param name="cmdType"></param>
/// <param name="pars"></param>
/// <returns></returns>
public List <T_Class> FulzySearch(string t_sql, CommandType cmdType, params SqlParameter[] pars)
{
SqlHelper sqlhelper = new SqlHelper();
List <T_Class> res = null;
using (SqlDataReader reader = sqlhelper.ExecuteReader(t_sql, cmdType, pars))
{
if (reader.HasRows)
{
res = new List <T_Class>();
while (reader.Read())
{
var id = reader.GetInt32(0);
var name = reader.GetString(1);
var college = reader.GetInt32(2);
T_Class @class = new T_Class(id, name, college);
res.Add(@class);
}
}
}
return(res);
}
/// <summary>
/// 分页查询
/// </summary>
/// <returns></returns>
public List <T_Class> LoadPagiation(int curIndex, int dataLength, int collegeID = -1)
{
string t_sql = "Select_ClassPagiation";
SqlParameter[] pars = new SqlParameter[] {
new SqlParameter("@curIndex", SqlDbType.Int)
{
Value = curIndex
},
new SqlParameter("@dataLength", SqlDbType.Int)
{
Value = dataLength
},
new SqlParameter("@collegeID", SqlDbType.Int)
{
Value = collegeID
}
};
SqlHelper sqlhelper = new SqlHelper();
List <T_Class> res = null;
using (SqlDataReader reader = sqlhelper.ExecuteReader(t_sql, CommandType.StoredProcedure, pars))
{
if (reader.HasRows)
{
res = new List <T_Class>();
while (reader.Read())
{
var id = reader.GetInt32(0);
var name = reader.GetString(1);
var college = reader.GetInt32(2);
T_Class @class = new T_Class(id, name, college);
res.Add(@class);
}
}
}
return(res);
}
public FrmUpdataClassInformation(T_Class @class) : this()
{
this.@class = @class;
}
