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