/// <summary>
/// 获取UUID列表
/// </summary>
/// <param name="type">类型:class,dept,major</param>
/// <param name="filename">文件名</param>
public static bool GetUUID(string type, string filename)
{
var dt = new DataTable();
dt.Columns.Add("名称");
dt.Columns.Add("UUID");
switch (type)
{
case "class": //班级UUID
var bll_class = new BLL.t_class();
var c_dt = bll_class.GetAllList().Tables[0];
if (c_dt == null)
{
break;
}
foreach (DataRow item in c_dt.Rows)
{
var dr = dt.NewRow();
dr["名称"] = item["class_name"];
dr["UUID"] = item["class_id"];
dt.Rows.Add(dr);
}
break;
case "dept": //系别UUID
var bll_dept = new BLL.t_dept();
var d_dt = bll_dept.GetAllList().Tables[0];
if (d_dt == null)
{
break;
}
foreach (DataRow item in d_dt.Rows)
{
var dr = dt.NewRow();
dr["名称"] = item["dept_name"];
dr["UUID"] = item["dept_id"];
dt.Rows.Add(dr);
}
break;
case "major": //专业UUID
var bll_major = new BLL.t_major();
var m_dt = bll_major.GetAllList().Tables[0];
if (m_dt == null)
{
break;
}
foreach (DataRow item in m_dt.Rows)
{
var dr = dt.NewRow();
dr["名称"] = item["major_name"];
dr["UUID"] = item["major_id"];
dt.Rows.Add(dr);
}
break;
}
//new Thread(() => { CsvHelper.dt2csv(filename, dt); }).Start();
return(CsvHelper.dt2csv(filename, dt));
}
/// <summary>
/// 系别DDL
/// </summary>
/// <param name="dropDownList"></param>
public static void DeptDLL(DropDownList dropDownList)
{
dropDownList.Items.Clear();
var bll = new BLL.t_dept();
var model = bll.GetModelList("dept_stat=0");
foreach (var item in model)
{
dropDownList.Items.Add(new ListItem(item.dept_name, item.dept_id));
}
}
/// <summary>
/// 系别DDL
/// </summary>
/// <param name="ListBox"></param>
public static void DeptLB(ListBox ListBox)
{
ListBox.Items.Clear();
var bll = new BLL.t_dept();
var model = bll.GetModelList("dept_stat=0");
foreach (var item in model)
{
ListBox.Items.Add(new ListItem(item.dept_name, item.dept_id));
}
}
private void ShowInfo(int id)
{
Topicsys.BLL.t_major bll = new Topicsys.BLL.t_major();
Topicsys.Model.t_major model = bll.GetModel(id);
this.lblid.Text = model.id.ToString();
var bll_dept = new BLL.t_dept();
this.lblmajor_dept_id.Text = bll_dept.GetModel(model.major_dept_id).dept_name;
this.lblmajor_name.Text = model.major_name;
this.lblmajor_dept_id.Text = model.major_dept_id;
this.lblmajor_stat.Text = model.major_stat.ToString();
this.lblmajor_note.Text = model.major_note;
}