public void bind()
{
ExtendBLL.Dictionary eDictionary = new ExtendBLL.Dictionary();
List<Model.Dictionary> listCClass = new List<LabMS.Model.Dictionary>();
tbRecipientsDate.Text = DateTime.Now.Date.ToShortDateString();
}
public void Bind()
{
tbCreatedDate.Text = DateTime.Today.ToShortDateString();
ExtendBLL.Dictionary eDictionary = new ExtendBLL.Dictionary();
List<Model.Dictionary> listCClass = new List<LabMS.Model.Dictionary>();
listCClass = eDictionary.GetItemListByDClass("shebeilaiyuan");
ddlSource.DataSource = listCClass;
ddlSource.DataTextField = "Name";
ddlSource.DataValueField = "Code";
ddlSource.DataBind();
listCClass = eDictionary.GetItemListByDClass("shiyongfangxiang");
ddlArrow.DataSource = listCClass;
ddlArrow.DataTextField = "Name";
ddlArrow.DataValueField = "Code";
ddlArrow.DataBind();
listCClass = eDictionary.GetItemListByDClass("shebeizhuangtai");
ddlPresentSituation.DataSource = listCClass;
ddlPresentSituation.DataTextField = "Name";
ddlPresentSituation.DataValueField = "Code";
ddlPresentSituation.DataBind();
listCClass = eDictionary.GetItemListByDClass("jingfeikemu");
ddlFundsSubject.DataSource = listCClass;
ddlFundsSubject.DataTextField = "Name";
ddlFundsSubject.DataValueField = "Code";
ddlFundsSubject.DataBind();
}
public void bindDDL(LabMS.Model.OpentProject mopproject)
{
LabMS.BLL.Lab blab = new LabMS.BLL.Lab();
List<LabMS.Model.Lab> mLab = new List<LabMS.Model.Lab>();
mLab = blab.GetModelList(" Lab_ParentID is null ");
ddlLabName.DataSource = mLab;
ddlLabName.DataTextField = "Lab_Name";
ddlLabName.DataValueField = "Lab_Code";
ddlLabName.DataBind();
ddlLabName.SelectedValue = mopproject.Project_Lab;
ExtendBLL.Dictionary eDictionary = new ExtendBLL.Dictionary();
List<Model.Dictionary> listCClass = new List<LabMS.Model.Dictionary>();
listCClass = eDictionary.GetItemListByDClass("shiyanleibie");
ddlProjectCategory.DataSource = listCClass;
ddlProjectCategory.DataTextField = "Name";
ddlProjectCategory.DataValueField = "Code";
ddlProjectCategory.DataBind();
ddlProjectCategory.SelectedValue = mopproject.Project_Category;
listCClass = eDictionary.GetItemListByDClass("shiyanleixing");
ddlProjectType.DataSource = listCClass;
ddlProjectType.DataTextField = "Name";
ddlProjectType.DataValueField = "Code";
ddlProjectType.DataBind();
ddlProjectType.SelectedValue = mopproject.Project_Type;
listCClass = eDictionary.GetItemListByDClass("shiyanyaoqiu");
ddlProjectRequire.DataSource = listCClass;
ddlProjectRequire.DataTextField = "Name";
ddlProjectRequire.DataValueField = "Code";
ddlProjectRequire.DataBind();
ddlProjectRequire.SelectedValue = mopproject.Project_Require;
listCClass = eDictionary.GetItemListByDClass("shiyanzheleibie");
ddlProjectPartnerType.DataSource = listCClass;
ddlProjectPartnerType.DataTextField = "Name";
ddlProjectPartnerType.DataValueField = "Code";
ddlProjectPartnerType.DataBind();
ddlProjectPartnerType.SelectedValue = mopproject.Project_PartnerType;
listCClass = eDictionary.GetItemListByDClass("shiyanxiangmulaiyuan");
ddlProjectComFrom.DataSource = listCClass;
ddlProjectComFrom.DataTextField = "Name";
ddlProjectComFrom.DataValueField = "Code";
ddlProjectComFrom.DataBind();
ddlProjectComFrom.SelectedValue = mopproject.OP_ProSource;
LabMS.Model.SysSetting msys = new LabMS.Model.SysSetting();
ExtendBLL.SysSetting extendsys = new ExtendBLL.SysSetting();
msys = extendsys.GetCurrentSetting();
List<string> listYear = Common.GradeHelper.GetCurrentGrade((int)msys.CurrentYear, (int)msys.CurrentSemester, false);
ddlOPGrade.DataSource = listYear;
ddlOPGrade.DataBind();
ddlOPGrade.Items.Insert(0, new ListItem("", "0"));
ddlOPGrade.SelectedValue = mopproject.OP_Grade;
ddlOPFunds.SelectedValue = mopproject.OP_Funds;
}
public void bind(string strWhere)
{
List<ExtendModule.InstrumentAndConsumables> listinstrument = new
List<ExtendModule.InstrumentAndConsumables>();
ExtendBLL.InstrumentAndConsumables beconsum = new ExtendBLL.InstrumentAndConsumables();
listinstrument = beconsum.GetExtendModelList(" Type = 'lowvalue' " + strWhere + " order by ID desc ");
LabMS.BLL.Lab blab = new LabMS.BLL.Lab();
List<LabMS.Model.Lab> mLab = new List<LabMS.Model.Lab>();
ExtendBLL.Dictionary eDictionary = new ExtendBLL.Dictionary();
List<Model.Dictionary> listCClass = new List<LabMS.Model.Dictionary>();
listCClass = eDictionary.GetItemListByDClass("haocaileibie");
foreach (ExtendModule.InstrumentAndConsumables i in listinstrument)
{
mLab = blab.GetModelList(" Lab_Code='" + i.StockLocation + "'");
if (mLab.Count > 0)
{
i.StockLocation = mLab[0].Lab_Name;
}
listCClass = eDictionary.GetModelList(" Code='" + i.Source + "' ");
if (listCClass.Count > 0)
{
i.Source = listCClass[0].Name;
}
listCClass = eDictionary.GetModelList(" Code='" + i.Arrow + "' ");
if (listCClass.Count > 0)
{
i.Arrow = listCClass[0].Name;
}
}
gvInstrument.DataSource = listinstrument;
gvInstrument.DataBind();
}
public void ProcessRequest(HttpContext context)
{
if (context.Request != null&&context.Request["Code"]!=null)
{
string strCode = context.Request["Code"].ToString();
LabMS.BLL.InstrumentAndConsumables binstrument
= new LabMS.BLL.InstrumentAndConsumables();
List<LabMS.Model.InstrumentAndConsumables> listInstrument
= new List<LabMS.Model.InstrumentAndConsumables>();
ExtendBLL.Dictionary eDictionary = new ExtendBLL.Dictionary();
List<Model.Dictionary> listCClass = new List<LabMS.Model.Dictionary>();
listInstrument = binstrument.GetModelList("Numbers = '" + strCode+"'");
if (listInstrument.Count < 0)
{
return;
}
listCClass = eDictionary.GetModelList("Code='" + listInstrument[0].Status + "'");
if (listCClass.Count < 0)
{
return;
}
context.Response.ContentType = "application/json";
context.Response.Write("{result: '" +listCClass[0].Name+ "'}");
}
}
//绑定学年
protected void YearDDL_DataBind()
{
ExtendBLL.Dictionary eDictionary = new ExtendBLL.Dictionary();
List<Model.Dictionary> listCClass = new List<LabMS.Model.Dictionary>();
listCClass = eDictionary.GetModelList("DClass = 'ruxuenianfen' order by Code desc");
YearDDL.DataSource = listCClass;
YearDDL.DataTextField = "Name";
YearDDL.DataValueField = "Code";
YearDDL.DataBind();
}
public void bindDDL()
{
ExtendBLL.Dictionary eDictionary = new ExtendBLL.Dictionary();
List<Model.Dictionary> listCClass = new List<LabMS.Model.Dictionary>();
listCClass = eDictionary.GetItemListByDClass("estatus");
ddlRStatus.DataSource = listCClass;
ddlRStatus.DataTextField = "Name";
ddlRStatus.DataValueField = "Code";
ddlRStatus.DataBind();
}
public void bind()
{
ExtendBLL.Dictionary eDictionary = new ExtendBLL.Dictionary();
List<Model.Dictionary> listCClass = new List<LabMS.Model.Dictionary>();
listCClass = eDictionary.GetItemListByDClass("shiyongfangxiang");
ddlArrow.DataSource = listCClass;
ddlArrow.DataTextField = "Name";
ddlArrow.DataValueField = "Code";
ddlArrow.DataBind();
tbRecipientsDate.Text = DateTime.Now.Date.ToShortDateString();
}
protected void InitDDl()
{
//性别
ExtendBLL.Dictionary BD = new ExtendBLL.Dictionary();
ddlSex.DataSource = BD.GetItemListByDClass("201");
ddlSex.DataValueField = "Code";
ddlSex.DataTextField = "Name";
ddlSex.DataBind();
//年级
ExtendBLL.SysSetting ES = new ExtendBLL.SysSetting();
int Year = ES.GetCurrentSetting().CurrentYear;
int S = int.Parse(ES.GetCurrentSetting().CurrentSemester.Value.ToString());
ddlLJ.DataSource = Common.GradeHelper.GetCurrentGrade(Year, S, false);
ddlLJ.DataBind();
}
/// <summary>
///下拉框绑定，从字典里面取值
///下拉框绑定,取系统时间前后五年
/// </summary>
protected void BindDDl()
{
//int CurrentYear = DateTime.Now.Year;
//for (int i =-5; i <=11; i++)
//{
// int year = CurrentYear + i;
// ddlYear.Items.Add(new ListItem(year.ToString(),year.ToString()));
//}
//ddlYear.SelectedValue = CurrentYear.ToString();
LabMS.BLL.Dictionary BDicitonary = new LabMS.BLL.Dictionary();
ExtendBLL.Dictionary EDictionary = new ExtendBLL.Dictionary();
ddlYear.DataSource=EDictionary.GetItemListByDClass("ruxuenianfen");
ddlYear.DataValueField = "Code";
ddlYear.DataTextField = "Name";
ddlYear.DataBind();
}
public void bindDDL(ExtendModule.InstrumentAndConsumables instrument)
{
ExtendBLL.Dictionary eDictionary = new ExtendBLL.Dictionary();
List<Model.Dictionary> listCClass = new List<LabMS.Model.Dictionary>();
tbCreatedDate.Text = DateTime.Today.ToLongDateString();
listCClass = eDictionary.GetItemListByDClass("haocaileibie");
ddlCClass.DataSource = listCClass;
ddlCClass.DataTextField = "Name";
ddlCClass.DataValueField = "Code";
ddlCClass.DataBind();
listCClass = eDictionary.GetItemListByDClass("shebeilaiyuan");
ddlSource.DataSource = listCClass;
ddlSource.DataTextField = "Name";
ddlSource.DataValueField = "Code";
ddlSource.DataBind();
listCClass = eDictionary.GetItemListByDClass("shiyongfangxiang");
ddlArrow.DataSource = listCClass;
ddlArrow.DataTextField = "Name";
ddlArrow.DataValueField = "Code";
ddlArrow.DataBind();
listCClass = eDictionary.GetItemListByDClass("jingfeikemu");
ddlFundsSubject.DataSource = listCClass;
ddlFundsSubject.DataTextField = "Name";
ddlFundsSubject.DataValueField = "Code";
ddlFundsSubject.DataBind();
listCClass = eDictionary.GetItemListByDClass("dangwei");
ddlModle.DataSource = listCClass;
ddlModle.DataTextField = "Name";
ddlModle.DataValueField = "Code";
ddlModle.DataBind();
ExtendBLL.InstrumentAndConsumables eConsum = new ExtendBLL.InstrumentAndConsumables();
int iMaxCID = eConsum.GetMaxId();
MaxCID.Value = iMaxCID.ToString("D10");
tbInstrumentNum.Text = iMaxCID.ToString("D10");
tbLocation.Text = instrument.LabName;
tbLocationCode.Text = instrument.StockLocation;
}
void bindddl()
{
ExtendBLL.Dictionary eDictionary = new ExtendBLL.Dictionary();
List<Model.Dictionary> listCClass = new List<LabMS.Model.Dictionary>();
try
{
listCClass = eDictionary.GetItemListByDClass("ruxuenianfen");
}
catch (Exception ex)
{
lbErr.Visible = true;
lbErr.Text = ex.Message;
return;
}
ddlYear.DataSource = listCClass;
ddlYear.DataTextField = "Name";
ddlYear.DataValueField = "Code";
ddlYear.DataBind();
}
public void bindDDL(ExtendModule.InstrumentAndConsumables mconsum)
{
ExtendBLL.Dictionary eDictionary = new ExtendBLL.Dictionary();
List<Model.Dictionary> listCClass = new List<LabMS.Model.Dictionary>();
listCClass = eDictionary.GetItemListByDClass("haocaileibie");
ddlCClass.DataSource = listCClass;
ddlCClass.DataTextField = "Name";
ddlCClass.DataValueField = "Code";
ddlCClass.DataBind();
ddlCClass.SelectedValue = mconsum.ClassNumber;
listCClass = eDictionary.GetItemListByDClass("shebeilaiyuan");
ddlComeFrom.DataSource = listCClass;
ddlComeFrom.DataTextField = "Name";
ddlComeFrom.DataValueField = "Code";
ddlComeFrom.DataBind();
ddlComeFrom.SelectedValue = mconsum.Source;
listCClass = eDictionary.GetItemListByDClass("shiyongfangxiang");
ddlArrow.DataSource = listCClass;
ddlArrow.DataTextField = "Name";
ddlArrow.DataValueField = "Code";
ddlArrow.DataBind();
ddlArrow.SelectedValue = mconsum.Arrow;
listCClass = eDictionary.GetItemListByDClass("jingfeikemu");
ddlFundsSubject.DataSource = listCClass;
ddlFundsSubject.DataTextField = "Name";
ddlFundsSubject.DataValueField = "Code";
ddlFundsSubject.DataBind();
ddlFundsSubject.SelectedValue = mconsum.FundsSubject;
listCClass = eDictionary.GetItemListByDClass("dangwei");
ddlModle.DataSource = listCClass;
ddlModle.DataTextField = "Name";
ddlModle.DataValueField = "Code";
ddlModle.DataBind();
ddlModle.SelectedValue = mconsum.Measurement;
tbLocation.Text = mconsum.LabName;
}
public void bind(string strWhere)
{
List<ExtendModule.InstrumentAndConsumables> listevaluables = new
List<InstrumentAndConsumables>();
ExtendBLL.InstrumentAndConsumables bevaluables = new ExtendBLL.InstrumentAndConsumables();
listevaluables = bevaluables.GetExtendModelList(" Type = 'guizhongyiqi' " + strWhere + " order by ID desc ");
LabMS.BLL.Lab blab = new LabMS.BLL.Lab();
List<LabMS.Model.Lab> mLab = new List<LabMS.Model.Lab>();
ExtendBLL.Dictionary eDictionary = new ExtendBLL.Dictionary();
List<Model.Dictionary> listCClass = new List<LabMS.Model.Dictionary>();
listCClass = eDictionary.GetItemListByDClass("haocaileibie");
foreach (ExtendModule.InstrumentAndConsumables i in listevaluables)
{
mLab = blab.GetModelList(" Lab_Code='" + i.StockLocation + "'");
if (mLab.Count > 0)
{
i.StockLocation = mLab[0].Lab_Name;
}
listCClass = eDictionary.GetModelList(" DClass='shebeilaiyuan' and Code='" + i.Source + "' ");
if (listCClass.Count > 0)
{
i.Source = listCClass[0].Name;
}
listCClass = eDictionary.GetModelList(" DClass='shiyongfangxiang' and Code='" + i.Arrow + "' ");
if (listCClass.Count > 0)
{
i.Arrow = listCClass[0].Name;
}
listCClass = eDictionary.GetModelList(" DClass='shebeizhuangtai' and Code='" + i.PresentSituation + "' ");
if (listCClass.Count > 0)
{
i.PresentSituation = listCClass[0].Name;
}
}
GridViewValuables.DataSource = listevaluables;
GridViewValuables.DataBind();
}
/// <summary>
/// 保存
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSave_Click(object sender, EventArgs e)
{
#region 验证
if (string.IsNullOrEmpty(tbCode.Text.Trim()))
{
Common.JShelper.JSAlert(this.Page, "", "此项不能为空！");
tbCode.Focus();
}
else if (string.IsNullOrEmpty(tbName.Text.Trim()))
{
Common.JShelper.JSAlert(this.Page, "", "此项不能为空！");
tbName.Focus();
}
#endregion
else
{
ExtendBLL.Dictionary EB = new ExtendBLL.Dictionary();
LabMS.Model.Dictionary MD = new LabMS.Model.Dictionary();
if (EB.IsCodeExist(DClass, tbCode.Text.Trim()) == 0)
{
Common.JShelper.JSAlert(this.Page, "", "该值已经存在！");
tbCode.Text = "";
tbCode.Focus();
}
else
{
MD.DClass = DClass;
MD.Name = tbName.Text.Trim();
MD.Code = tbCode.Text.Trim();
int count = EB.Add(MD);
if (count > 0)
{
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "", "<script type='text/javascript'>alert('新增成功！');window.opener.location.href=window.opener.location.href;self.close();</script>");
}
}
}
}
public void bindDDL(LabMS.Model.RecipientsApp mRecipientsApp)
{
LabMS.BLL.Lab blab = new LabMS.BLL.Lab();
List<LabMS.Model.Lab> mLab = new List<LabMS.Model.Lab>();
mLab = blab.GetModelList(" Lab_ParentID is null ");
ddlLabs.DataSource = mLab;
ddlLabs.DataTextField = "Lab_Name";
ddlLabs.DataValueField = "Lab_Code";
ddlLabs.DataBind();
ddlLabs.SelectedValue = mRecipientsApp.EncodedWarehouse;
ExtendBLL.Dictionary eDictionary = new ExtendBLL.Dictionary();
List<Model.Dictionary> listCClass = new List<LabMS.Model.Dictionary>();
listCClass = eDictionary.GetItemListByDClass("shiyongfangxiang");
ddlArrow.DataSource = listCClass;
ddlArrow.DataTextField = "Name";
ddlArrow.DataValueField = "Code";
ddlArrow.DataBind();
ddlArrow.SelectedValue = mRecipientsApp.Arrow;
ddlEType.SelectedValue = mRecipientsApp.Type;
}
public void bindDDL(ExtendModule.InstrumentAndConsumables mvaluables)
{
tbCreatedDate.Text = DateTime.Today.ToShortDateString();
ExtendBLL.Dictionary eDictionary = new ExtendBLL.Dictionary();
List<Model.Dictionary> listCClass = new List<LabMS.Model.Dictionary>();
listCClass = eDictionary.GetItemListByDClass("shebeilaiyuan");
ddlSource.DataSource = listCClass;
ddlSource.DataTextField = "Name";
ddlSource.DataValueField = "Code";
ddlSource.DataBind();
ddlSource.SelectedValue = mvaluables.Source;
listCClass = eDictionary.GetItemListByDClass("shiyongfangxiang");
ddlArrow.DataSource = listCClass;
ddlArrow.DataTextField = "Name";
ddlArrow.DataValueField = "Code";
ddlArrow.DataBind();
ddlArrow.SelectedValue = mvaluables.Arrow;
listCClass = eDictionary.GetItemListByDClass("shebeizhuangtai");
ddlPresentSituation.DataSource = listCClass;
ddlPresentSituation.DataTextField = "Name";
ddlPresentSituation.DataValueField = "Code";
ddlPresentSituation.DataBind();
ddlPresentSituation.SelectedValue = mvaluables.ResponesoblePerson;
listCClass = eDictionary.GetItemListByDClass("jingfeikemu");
ddlFundsSubject.DataSource = listCClass;
ddlFundsSubject.DataTextField = "Name";
ddlFundsSubject.DataValueField = "Code";
ddlFundsSubject.DataBind();
ddlFundsSubject.SelectedValue = mvaluables.FundsSubject;
tbLocation.Text = mvaluables.LabName;
}
void bind(LabMS.Model.OpentProject mopproject)
{
tbOPContent.Text = mopproject.OP_OpenType;
tbOPInCharge.Text = mopproject.OP_InCharge;
tbOPPhone.Text = mopproject.OP_Phone;
tbOPPlanningCourseTime.Text = mopproject.OP_PlanningCourseTime;
tbOPProfessioanl.Text = mopproject.OP_Professioanl;
tbOPReason.Text = mopproject.OP_AppIntro;
tbProjectCode.Text = mopproject.OP_ProjectCode;
tbProjectEndWeek.Text = mopproject.Project_EndWeek.Value.ToString();
tbProjectName.Text = mopproject.OP_ProjectName;
tbProjectStartWeek.Text = mopproject.Project_StartWeek.Value.ToString();
ExtendBLL.Dictionary eDictionary = new ExtendBLL.Dictionary();
List<Model.Dictionary> listCClass = new List<LabMS.Model.Dictionary>();
listCClass = eDictionary.GetModelList(" DClass='xueke' and Code ='" + mopproject.Project_Subject + "'");
tbProjectSubjectCode.Value = mopproject.Project_Subject;
if (listCClass.Count > 0)
{
tbProjectSubjectName.Value = listCClass[0].Name;
}
LabMS.BLL.Teacher bteacher = new LabMS.BLL.Teacher();
List<Model.Teacher> listteacher = new List<LabMS.Model.Teacher>();
listteacher = bteacher.GetModelList(" Teacher_Code ='" + mopproject.OP_Teacher + "'");
tbTeacherCode.Value = mopproject.OP_Teacher;
if (listteacher.Count > 0)
{
tbTeacherName.Value = listteacher[0].Teacher_Name;
}
tbTeacherCode.Value = mopproject.OP_Teacher;
lbAppDate.Text = mopproject.OP_AppTime.Value.ToShortDateString();
lbAppPerson.Text = mopproject.OP_Applicant;
#region 绑定学生列表
ExtendBLL.ProjectAppointment eprojectapp = new ExtendBLL.ProjectAppointment();
List<LabMS.Model.Student> listStudent = new List<LabMS.Model.Student>();
listStudent = eprojectapp.GetStudentByProject(mopproject.OP_ProjectCode);
string strHTML = "<table id='studenlist' border='1' class='infoTable' style='width: 400px; border-collapse: collapse;'>";
strHTML += "<thead>";
strHTML += "<tr class='header'>";
strHTML += "<td class='none'>";
strHTML += "ID";
strHTML += "</td>";
strHTML += "<td>";
strHTML += "学号";
strHTML += "</td>";
strHTML += "<td>";
strHTML += "姓名";
strHTML += "</td>";
strHTML += "<td>";
strHTML += "";
strHTML += "</td>";
strHTML += "</tr>";
strHTML += "</thead>";
strHTML += "<tbody>";
tb_StudentIDs.Value = "";
foreach (LabMS.Model.Student s in listStudent)
{
if (tb_StudentIDs.Value == "")
{
tb_StudentIDs.Value += s.ID.ToString();
}
else
{
tb_StudentIDs.Value += "," + s.ID.ToString();
}
strHTML += "<tr>";
strHTML += "<td class='none'>";
strHTML += s.ID.ToString();
strHTML += "</td>";
strHTML += "<td>";
strHTML += s.Student_Code;
strHTML += "</td>";
strHTML += "<td>";
strHTML += s.Student_Name;
strHTML += "</td>";
strHTML += "<td>";
strHTML += "<a>删除</a>";
strHTML += "</td>";
strHTML += "</tr>";
}
strHTML += "</tbody>";
strHTML += "</table>";
tblistStudents.Value = strHTML;
tblistEmpty.Value = "0";
#endregion
}
void bind(string strwhere)
{
LabMS.Model.SysSetting msys = new LabMS.Model.SysSetting();
ExtendBLL.SysSetting extendsys = new ExtendBLL.SysSetting();
msys = extendsys.GetCurrentSetting();
List<LabMS.Model.OpentProject> listmopproject = new List<LabMS.Model.OpentProject>();
LabMS.BLL.OpentProject bopproject = new LabMS.BLL.OpentProject();
if (strwhere.Equals(""))
{
strwhere += " 1=1 ";
}
strwhere += " and SYear = " + msys.CurrentYear + " and Semester = " + msys.CurrentSemester;
if (UserType == "teacher")
{
strwhere += " and OP_Teacher = '" + UserCode + "'";
}
listmopproject = bopproject.GetModelList(strwhere + " order by ID desc ");
foreach (LabMS.Model.OpentProject op in listmopproject)
{
List<LabMS.Model.Teacher> listmteacher = new List<LabMS.Model.Teacher>();
LabMS.BLL.Teacher bteacher = new LabMS.BLL.Teacher();
listmteacher = bteacher.GetModelList(" Teacher_Code= '" + op.OP_Teacher + "'");
if (listmteacher.Count > 0)
{
op.OP_Teacher = listmteacher[0].Teacher_Name;
}
LabMS.BLL.Lab blab = new LabMS.BLL.Lab();
List<LabMS.Model.Lab> mLab = new List<LabMS.Model.Lab>();
mLab = blab.GetModelList(" Lab_Code='"+ op.Project_Lab +"'");
if (mLab.Count > 0)
{
op.Project_Lab = mLab[0].Lab_Name;
}
ExtendBLL.Dictionary eDictionary = new ExtendBLL.Dictionary();
List<Model.Dictionary> listCClass = new List<LabMS.Model.Dictionary>();
listCClass = eDictionary.GetModelList("DClass = 'shiyanyaoqiu' and Code = '"+op.Project_Require+"'");
if (listCClass.Count > 0)
{
op.Project_Require = listCClass[0].Name;
}
op.OP_Phone = op.Project_StartWeek.ToString()+"--"+op.Project_EndWeek.ToString();
List<LabMS.Model.ProjectAppointment>listprojectapp = new List<LabMS.Model.ProjectAppointment>();
ExtendBLL.ProjectAppointment bprojectapp = new ExtendBLL.ProjectAppointment();
listprojectapp = bprojectapp.GetModelList(" OP_ProjectCode ='"+op.OP_ProjectCode+"'");
op.OP_OpenType = listprojectapp.Count.ToString();
listCClass = eDictionary.GetModelList("DClass = 'shiyanleixing' and Code = '" + op.Project_Type + "'");
if (listCClass.Count > 0)
{
op.Project_Type = listCClass[0].Name;
}
if (op.OP_Audit == "0")
{
}
op.OP_Audit = LabMS.Common.Status.GetOpenProjectStatus(op.OP_Audit);
}
gv_OpenProjectList.DataSource = listmopproject;
gv_OpenProjectList.DataBind();
}
/// <summary>
/// 处理绑定数据
/// </summary>
/// <param name="ds"></param>
/// <returns></returns>
protected DataSet HandleDS(DataSet ds)
{
//构造: 性别Sex 班级名称ClassName 专业名称ProName 三列
ds.Tables[0].Columns.Add("Sex");
ds.Tables[0].Columns.Add("ClassName");
ds.Tables[0].Columns.Add("ProName");
ExtendBLL.Dictionary EDictionary = new ExtendBLL.Dictionary();
ExtendBLL.Class EClass = new ExtendBLL.Class();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
string Student_Sex = ds.Tables[0].Rows[i]["Student_Sex"].ToString();
if (!string.IsNullOrEmpty(Student_Sex))
{
string str = "DClass='201' and Code='" + Student_Sex + "'";
ds.Tables[0].Rows[i]["Sex"] = EDictionary.GetModelList(str)[0].Name.ToString();
}
if (!string.IsNullOrEmpty(ds.Tables[0].Rows[i]["ClassID"].ToString()))
{
int ClassID = int.Parse(ds.Tables[0].Rows[i]["ClassID"].ToString());
ds.Tables[0].Rows[i]["ClassName"] = EClass.GetClassNameByClassID(ClassID);
}
if (!string.IsNullOrEmpty(ds.Tables[0].Rows[i]["Student_Pro"].ToString()))
{
int Student_Pro = int.Parse(ds.Tables[0].Rows[i]["Student_Pro"].ToString());
ds.Tables[0].Rows[i]["ProName"] = EClass.ProessionalNameByID(Student_Pro);
}
}
return ds;
}
void bindddl()
{
LabMS.BLL.Lab Lab = new LabMS.BLL.Lab();
List<LabMS.Model.Lab> ParentLab = new List<LabMS.Model.Lab>();
ParentLab = Lab.GetModelList("Lab_ParentID is null");
List<LabMS.Model.Lab> SonLab = new List<LabMS.Model.Lab>();
SonLab = Lab.GetModelList("Lab_ParentID is not null");
for (int i = 0; i < ParentLab.Count; i++)
{
ddlLabName.Items.Add(new ListItem(ParentLab[i].Lab_Name, ParentLab[i].Lab_Code.ToString()));
for (int j = 0; j < SonLab.Count; j++)
{
if (SonLab[j].Lab_ParentID == ParentLab[i].ID)
{
ddlLabName.Items.Add(new ListItem("--|" + SonLab[j].Lab_Name, SonLab[j].Lab_Code.ToString()));
}
}
}
ExtendBLL.Dictionary eDictionary = new ExtendBLL.Dictionary();
List<Model.Dictionary> listCClass = new List<LabMS.Model.Dictionary>();
listCClass = eDictionary.GetItemListByDClass("shiyanleibie");
ddlProjectCategory.DataSource = listCClass;
ddlProjectCategory.DataTextField = "Name";
ddlProjectCategory.DataValueField = "Code";
ddlProjectCategory.DataBind();
listCClass = eDictionary.GetItemListByDClass("shiyanleixing");
ddlProjectType.DataSource = listCClass;
ddlProjectType.DataTextField = "Name";
ddlProjectType.DataValueField = "Code";
ddlProjectType.DataBind();
listCClass = eDictionary.GetItemListByDClass("shiyanyaoqiu");
ddlProjectRequire.DataSource = listCClass;
ddlProjectRequire.DataTextField = "Name";
ddlProjectRequire.DataValueField = "Code";
ddlProjectRequire.DataBind();
listCClass = eDictionary.GetItemListByDClass("shiyanzheleibie");
ddlProjectPartnerType.DataSource = listCClass;
ddlProjectPartnerType.DataTextField = "Name";
ddlProjectPartnerType.DataValueField = "Code";
ddlProjectPartnerType.DataBind();
listCClass = eDictionary.GetItemListByDClass("shiyanxiangmulaiyuan");
ddlProjectComFrom.DataSource = listCClass;
ddlProjectComFrom.DataTextField = "Name";
ddlProjectComFrom.DataValueField = "Code";
ddlProjectComFrom.DataBind();
LabMS.Model.SysSetting msys = new LabMS.Model.SysSetting();
ExtendBLL.SysSetting extendsys = new ExtendBLL.SysSetting();
msys = extendsys.GetCurrentSetting();
List<string> listYear = Common.GradeHelper.GetCurrentGrade((int)msys.CurrentYear, (int)msys.CurrentSemester, false);
ddlOPGrade.DataSource = listYear;
ddlOPGrade.DataBind();
ddlOPGrade.Items.Insert(0, new ListItem("", "0"));
}
void bindddl()
{
LabMS.BLL.Lab blab = new LabMS.BLL.Lab();
List<LabMS.Model.Lab> mLab = new List<LabMS.Model.Lab>();
mLab = blab.GetModelList(" Lab_ParentID is null ");
ddlLab.DataSource = mLab;
ddlLab.DataTextField = "Lab_Name";
ddlLab.DataValueField = "Lab_Code";
ddlLab.DataBind();
ddlLab.Items.Insert(0, new ListItem("", "0"));
ExtendBLL.Dictionary eDictionary = new ExtendBLL.Dictionary();
List<Model.Dictionary> listCClass = new List<LabMS.Model.Dictionary>();
listCClass = eDictionary.GetItemListByDClass("ruxuenianfen");
ddlYear.DataSource = listCClass;
ddlYear.DataTextField = "Name";
ddlYear.DataValueField = "Code";
ddlYear.DataBind();
ddlYear.Items.Insert(0, new ListItem("", "0"));
}
void bind(LabMS.Model.OpentProject mopproject)
{
tbOPContent.Text = mopproject.OP_OpenType;
tbOPInCharge.Text = mopproject.OP_InCharge;
tbOPPhone.Text = mopproject.OP_Phone;
tbOPPlanningCourseTime.Text = mopproject.OP_PlanningCourseTime;
tbOPProfessioanl.Text = mopproject.OP_Professioanl;
tbOPReason.Text = mopproject.OP_AppIntro;
tbProjectCode.Text = mopproject.OP_ProjectCode;
tbProjectEndWeek.Text = mopproject.Project_EndWeek.Value.ToString();
tbProjectName.Text = mopproject.OP_ProjectName;
tbProjectStartWeek.Text = mopproject.Project_StartWeek.Value.ToString();
ExtendBLL.Dictionary eDictionary = new ExtendBLL.Dictionary();
List<Model.Dictionary> listCClass = new List<LabMS.Model.Dictionary>();
listCClass = eDictionary.GetModelList(" DClass='xueke' and Code ='" + mopproject.Project_Subject + "'");
if (listCClass.Count > 0)
{
tbProjectSubjectCode.Text = listCClass[0].Name;
}
LabMS.BLL.Teacher bteacher = new LabMS.BLL.Teacher();
List<Model.Teacher> listteacher = new List<LabMS.Model.Teacher>();
listteacher = bteacher.GetModelList(" Teacher_Code ='" + mopproject.OP_Teacher + "'");
if (listteacher.Count > 0)
{
tbTeacherCode.Text = listteacher[0].Teacher_Name;
}
tbTeacherCode.Text = mopproject.OP_Teacher;
lbAppDate.Text = mopproject.OP_AppTime.Value.ToShortDateString();
lbAppPerson.Text = mopproject.OP_Applicant;
lbOP_Approval.Text = mopproject.OP_Approval;
string strSemester = Common.Status.GetSemester(mopproject.Semester.Value);
lbSTime.Text = mopproject.SYear.Value.ToString() + "学年 " + strSemester;
string strStatus = Common.Status.GetOpenProjectStatus(mopproject.OP_Audit);
lbStatus.Text = strStatus;
ExtendBLL.ProjectAppointment eprojectapp = new ExtendBLL.ProjectAppointment();
List<LabMS.Model.Student> listStudent = new List<LabMS.Model.Student>();
listStudent = eprojectapp.GetStudentByProject(mopproject.OP_ProjectCode);
gv_studentList.DataSource = listStudent;
gv_studentList.DataBind();
if (mopproject.OP_Audit == "2" || mopproject.OP_Audit == "3")
{
panelExamine.Visible = true;
lbAuditOpinion.Text = mopproject.AuditOpinion;
lbCheckTime.Text = mopproject.CheckTime.Value.ToShortDateString();
}
}
void bind()
{
LabMS.BLL.Lab blab = new LabMS.BLL.Lab();
List<LabMS.Model.Lab> mLab = new List<LabMS.Model.Lab>();
mLab = blab.GetModelList(" Lab_ParentID is null ");
ddlLabs.DataSource = mLab;
ddlLabs.DataTextField = "Lab_Name";
ddlLabs.DataValueField = "Lab_Code";
ddlLabs.DataBind();
ExtendBLL.Dictionary eDictionary = new ExtendBLL.Dictionary();
List<Model.Dictionary> listCClass = new List<LabMS.Model.Dictionary>();
listCClass = eDictionary.GetItemListByDClass("shiyongfangxiang");
ddlArrow.DataSource = listCClass;
ddlArrow.DataTextField = "Name";
ddlArrow.DataValueField = "Code";
ddlArrow.DataBind();
}
/// <summary>
/// 初始化页面赋值
/// </summary>
protected void InitBind(int ID)
{
string str = "ID="+ID;
LabMS.BLL.Semester BS = new LabMS.BLL.Semester();
List<LabMS.Model.Semester> list = new List<LabMS.Model.Semester>();
list=BS.GetModelList(str);
ddlYear.SelectedValue = list[0].Year.Value.ToString();
ddlAcadmic.SelectedValue = list[0].MSemester.Value.ToString();
tbETime.Text = list[0].ETime.Value.ToShortDateString();
tbSTime.Text = list[0].STime.Value.ToShortDateString();
LabMS.BLL.Dictionary BDicitonary = new LabMS.BLL.Dictionary();
ExtendBLL.Dictionary EDictionary = new ExtendBLL.Dictionary();
ddlYear.DataSource = EDictionary.GetItemListByDClass("ruxuenianfen");
ddlYear.DataValueField = "Code";
ddlYear.DataTextField = "Name";
ddlYear.DataBind();
ddlYear.SelectedValue = DateTime.Now.Year.ToString();
}
