/// <summary>
/// 根据班级号查出班级名称
/// </summary>
/// <param name="ClassID"></param>
/// <returns></returns>
public string GetClassNameByClassID(int ClassID)
{
string str = "ID="+ClassID;
LabMS.BLL.Class BClass=new LabMS.BLL.Class();
string Class_Name = BClass.GetModelList(str)[0].Class_Name;
return Class_Name;
}
protected void Gv_DataBinds()
{
LabMS.BLL.Class Class = new LabMS.BLL.Class();
List<LabMS.Model.Class> ls = new List<LabMS.Model.Class>();
ls = Class.GetModelList(CombineStr());
Gv_Class.DataSource = ls;
Gv_Class.DataBind();
}
/// <summary>
/// 班级编号是否存在
/// </summary>
/// <param name="Class"></param>
/// <returns></returns>
public int IsExistClass(string strClass)
{
string str = "Class_Code='"+strClass+"'";
LabMS.BLL.Class BC = new LabMS.BLL.Class();
if (BC.GetModelList(str).Count > 0)
{
//已经存在
return 1;
}
else
{
//不存在，可以保存
return 0;
}
}
void bindClass(string Year, string Pro)
{
List<LabMS.Model.Class> listClass = new List<LabMS.Model.Class>();
LabMS.BLL.Class bClass = new LabMS.BLL.Class();
string strWhere = "1=1";
if (Year != "0")
{
strWhere += " and Class_Year ='" + Year + "'";
}
if (Pro!="0")
{
strWhere += " and Class_Professional =" + Pro;
}
listClass = bClass.GetModelList(strWhere);
ddlClass.DataSource = listClass;
ddlClass.DataValueField = "ID";
ddlClass.DataTextField = "Class_Name";
ddlClass.DataBind();
ddlClass.Items.Insert(0, new ListItem("", "0"));
}
protected void Gv_DataBinds()
{
LabMS.BLL.Class Class = new LabMS.BLL.Class();
List<LabMS.Model.Class> ls = new List<LabMS.Model.Class>();
string strWhere = CombineStr();
if (!string.IsNullOrEmpty(strWhere))
{
ls = Class.GetModelList(strWhere);
Gv_Class.DataSource = ls;
Gv_Class.DataBind();
}
else
{
Gv_Class.DataSource = ls;
Gv_Class.DataBind();
}
}
void searchbind()
{
string strwhere = " 1=1 ";
string strclass = ddlClass.SelectedValue;
string strYear = ddlYear.SelectedValue;
string strPro = ddlPro.SelectedValue;
string strSName = tbSName.Text.Trim();
string strSCode = tbSNub.Text.Trim();
if (strclass != "0")
{
strwhere += " and ClassID = " + strclass;
}
if (strYear != "0")
{
List<LabMS.Model.Class> listClass = new List<LabMS.Model.Class>();
LabMS.BLL.Class bclass = new LabMS.BLL.Class();
bclass.GetModelList("Class_Year = '"+ strYear +"'");
strwhere += " and ( 1<>1 ";
foreach (LabMS.Model.Class c in listClass)
{
strwhere += " and ( or ClassID = " + c.ID.ToString();
}
strwhere += ")";
}
if (strPro != "0")
{
strwhere += " and Student_Pro = " + strPro;
}
if (strSCode != "")
{
strwhere += " and Student_Code like '%" + strSCode + "%'";
}
if (strSName != "")
{
strwhere += " and Student_Name like '%" + strSName + "%'";
}
bind(strwhere);
}