//删除
protected void btnDelete_Click(object sender, EventArgs e)
{
CheckBox cb;
LabMS.BLL.PersonalProject personalproject = new LabMS.BLL.PersonalProject();
ExtendBLL.PersonalProject project = new ExtendBLL.PersonalProject();
try
{
for (int i = 0; i < gvPersonalProjectList.Rows.Count; i++)
{
cb = (CheckBox)gvPersonalProjectList.Rows[i].FindControl("ProjectCB");
if (cb.Checked)
{
string ProjectID = gvPersonalProjectList.DataKeys[i].Value.ToString();
personalproject.Delete(int.Parse(ProjectID));
project.DeleteConsumeByProjectID(int.Parse(ProjectID));
project.DeleteApplicantByProjectID(int.Parse(ProjectID));
}
}
BindGridViewList(SearchString());
LabMS.Common.JShelper.JSAlert(Page, "deleteSuccess", "删除成功!");
}
catch
{
LabMS.Common.JShelper.JSAlert(Page, "err", "删除失败!");
}
}
//绑定申请人
protected void BindApplicantList(int ProjectID)
{
ExtendBLL.PersonalProject personalproject = new ExtendBLL.PersonalProject();
List<ExtendModule.StudentAndOther> applicantList = new List<ExtendModule.StudentAndOther>();
string strWhere = " pa.PersonalProjID = " + ProjectID;
applicantList = personalproject.GetStudentInfoList(strWhere);
gvApplicant.DataSource = applicantList;
gvApplicant.DataBind();
}
//绑定列表数据
protected void BindGridViewList(string strAnd)
{
ExtendBLL.PersonalProject personalproject = new ExtendBLL.PersonalProject();
List<ExtendModule.PersonalProjectAndOther> personalprojectList = new List<ExtendModule.PersonalProjectAndOther>();
strAnd += " and ProjectStatus != '1' order by ProjectStatus,ProjectID desc";
personalprojectList = personalproject.PersonalProjectList(strAnd);
gvPersonalProjectList.DataSource = personalprojectList;
gvPersonalProjectList.DataBind();
}
//绑定列表数据
protected void BindGridViewList(string strAnd)
{
ExtendBLL.PersonalProject personalproject = new ExtendBLL.PersonalProject();
List<ExtendModule.PersonalProjectAndOther> personalprojectList = new List<ExtendModule.PersonalProjectAndOther>();
strAnd = strAnd + " and Student.Student_Pro=a.ApplicantID and Student.Student_Code = '"+ UserCode + "' order by ProjectStatus,ProjectID desc ";
personalprojectList = personalproject.GetPersonalProjectListByUserCode(strAnd);
gvPersonalProjectList.DataSource = personalprojectList;
gvPersonalProjectList.DataBind();
}
protected void Button2_Click(object sender, EventArgs e)
{
string strAlert = "删除成功!";
try
{
LabMS.BLL.PersonalProject project = new LabMS.BLL.PersonalProject();
project.Delete(ProjectID);
ExtendBLL.PersonalProject consume = new ExtendBLL.PersonalProject();
consume.DeleteConsumeByProjectID(ProjectID);
ExtendBLL.PersonalProject applicant = new ExtendBLL.PersonalProject();
applicant.DeleteApplicantByProjectID(ProjectID);
}
catch (Exception ex)
{
lbErr.Text = ex.Message;
lbErr.Visible = true;
return;
}
Common.JShelper.JSAlertAndRedirect(Page, "success", strAlert, "ListPersonalProject.aspx");
}
//绑定数据
protected void BindData(int ProjectID)
{
//绑定基本信息
LabMS.BLL.PersonalProject project = new LabMS.BLL.PersonalProject();
LabMS.Model.PersonalProject projectinfo = new LabMS.Model.PersonalProject();
projectinfo = project.GetModel(ProjectID);
ProjectName.Text = projectinfo.ProjectName;
PlanHours.Text = projectinfo.PlanHours.ToString();
ddlApplyLab.SelectedValue = projectinfo.AppcationLabID.ToString();
if (!string.IsNullOrEmpty(projectinfo.ApplicationStartTime.ToString()))
{
ApplyTimeMin.Text = projectinfo.ApplicationStartTime.Value.ToShortDateString();
}
if (!string.IsNullOrEmpty(projectinfo.ApplicationEndTime.ToString()))
{
ApplyTimeMax.Text = projectinfo.ApplicationEndTime.Value.ToShortDateString();
}
Contactor.Text = projectinfo.Contactor ;
ContactorClass.Text = projectinfo.ContactorClass;
ContactEmail.Text = projectinfo.ContactorEmail;
ContactPhone.Text = projectinfo.ContactorPhone;
Teacher.Text = projectinfo.Teacher;
TeacherTitle.Text = projectinfo.TeacherTitle;
TeacherEmail.Text = projectinfo.TeacherEmail;
TeacherPhone.Text = projectinfo.TeacherPhone;
ApplyReason.Text = projectinfo.ApplicationReason;
//绑定申请人
ExtendBLL.PersonalProject applicant = new ExtendBLL.PersonalProject();
List<ExtendModule.StudentAndOther> applicantinfo = new List<ExtendModule.StudentAndOther>();
string strWhere = " pa.PersonalProjID = " + ProjectID;
applicantinfo = applicant.GetStudentInfoList(strWhere);
#region 绑定申请人列表
string strHTML0 = "<table id='applicantlist' border='1' class='infoTable' style='width: 185px; border-collapse: collapse;'>";
strHTML0 += "<thead>";
strHTML0 += "<tr class='header'>";
strHTML0 += "<td class='none'>";
strHTML0 += "ID";
strHTML0 += "</td>";
strHTML0 += "<td>";
strHTML0 += "学号";
strHTML0 += "</td>";
strHTML0 += "<td>";
strHTML0 += "姓名";
strHTML0 += "</td>";
strHTML0 += "<td>";
strHTML0 += "";
strHTML0 += "</td>";
strHTML0 += "</tr>";
strHTML0 += "</thead>";
strHTML0 += "<tbody>";
tb_StudentIDs.Text = "";
foreach (ExtendModule.StudentAndOther s in applicantinfo)
{
if (tb_StudentIDs.Text == "")
{
tb_StudentIDs.Text += s.ID.ToString();
}
else
{
tb_StudentIDs.Text += "," + s.ID.ToString();
}
strHTML0 += "<tr>";
strHTML0 += "<td class='none'>";
strHTML0 += s.ID.ToString();
strHTML0 += "</td>";
strHTML0 += "<td>";
strHTML0 += s.Student_Code;
strHTML0 += "</td>";
strHTML0 += "<td>";
strHTML0 += s.Student_Name;
strHTML0 += "</td>";
strHTML0 += "<td>";
strHTML0 += "<a>删除</a>";
strHTML0 += "</td>";
strHTML0 += "</tr>";
}
strHTML0 += "</tbody>";
strHTML0 += "</table>";
studentlist.Text = strHTML0;
tblistEmpty.Value = "0";
#endregion
//绑定低耗品和仪器
LabMS.BLL.PersonalProjConsume projectconsume = new LabMS.BLL.PersonalProjConsume();
List<LabMS.Model.PersonalProjConsume> projectequipinfo = new List<LabMS.Model.PersonalProjConsume>();
List<LabMS.Model.PersonalProjConsume> projectlowconsumeinfo = new List<LabMS.Model.PersonalProjConsume>();
#region 绑定仪器
//仪器
string strWhere2 = " EquipType=1 and PersonalProjID=" + ProjectID;
projectequipinfo = projectconsume.GetModelList(strWhere2);
string strHTML = "<table id='tableEquip' border='1' class='infoTable' style='border-collapse: collapse;'>";
strHTML += "<thead>";
strHTML += "<tr class='header'>";
strHTML += "<td style='display:none'>";
strHTML += "编号";
strHTML += "</td>";
strHTML += "<td>";
strHTML += "名称";
strHTML += "</td>";
strHTML += "<td>";
strHTML += "数量";
strHTML += "</td>";
strHTML += "<td>";
strHTML += "备注";
strHTML += "</td>";
strHTML += "<td>";
strHTML += "";
strHTML += "</td>";
strHTML += "</tr>";
strHTML += "</thead>";
strHTML += "<tbody>";
tb_EIndex.Value = projectequipinfo.Count.ToString();
for (int i = 0; i < projectequipinfo.Count; i++)
{
strHTML += "<tr>";
strHTML += "<td style='display:none'>";
strHTML += "<input type='text' id='code" + i + "'/>";
strHTML += "</td>";
strHTML += "<td>";
strHTML += "<input style='width:40px;' value='" + projectequipinfo[i].EquipName + "' name='name" + i + "' id='name" + i + "' type='text' /><input onclick=OpenEditWin2('../CommonPage/consumselectlist.aspx?location=@ALL@&Type=yiqi',500,400,'code" + i + "','name" + i + "'); type='button' class='button' value='...' /> ";
strHTML += "</td>";
strHTML += "<td>";
strHTML += "<input style='width:30px;' value='" + projectequipinfo[i].EquipNum + "' name='num" + i + "' id='num" + i + "' type='text' />";
strHTML += "</td>";
strHTML += "<td>";
strHTML += "<input style='width:50px;' value='" + projectequipinfo[i].Introduction + "' name='intro" + i + "' id='intro" + i + "' type='text' />";
strHTML += "</td>";
strHTML += "<td>";
strHTML += "<a>删除</a>";
strHTML += "</td>";
strHTML += "</tr>";
}
strHTML += "</tbody>";
strHTML += "</table>";
lbEquip.Text += strHTML;
#endregion
#region 绑定低耗品
//低耗品
string strWhere3 = " EquipType=2 and PersonalProjID=" + ProjectID;
projectlowconsumeinfo = projectconsume.GetModelList(strWhere3);
string strHTML2 = "<table id='tableConsump' border='1' class='infoTable' style='border-collapse: collapse;'>";
strHTML2 += "<thead>";
strHTML2 += "<tr class='header'>";
strHTML2 += "<td style='display:none'>";
strHTML2 += "编号";
strHTML2 += "</td>";
strHTML2 += "<td>";
strHTML2 += "名称";
strHTML2 += "</td>";
strHTML2 += "<td>";
strHTML2 += "数量";
strHTML2 += "</td>";
strHTML2 += "<td>";
strHTML2 += "备注";
strHTML2 += "</td>";
strHTML2 += "<td>";
strHTML2 += "";
strHTML2 += "</td>";
strHTML2 += "</tr>";
strHTML2 += "</thead>";
strHTML2 += "<tbody>";
tb_ConsumpIndex.Value = projectlowconsumeinfo.Count.ToString();
for (int i = 0; i < projectlowconsumeinfo.Count; i++)
{
strHTML2 += "<tr>";
strHTML2 += "<td style='display:none'>";
strHTML2 += "<input type='text'id='consumpcode" + i + "'/>";
strHTML2 += "</td>";
strHTML2 += "<td>";
strHTML2 += "<input style='width:40px;' value='" + projectlowconsumeinfo[i].EquipName + "' name='consumpname" + i + "' id='consumpname" + i + "' type='text' /><input onclick=OpenEditWin3('../CommonPage/consumselectlist.aspx?location=@ALL@&Type=xiaohaopin',500,400,'consumpcode" + i + "','consumpname" + i + "'); type='button' class='button' value='...' /> ";
strHTML2 += "</td>";
strHTML2 += "<td>";
strHTML2 += "<input style='width:30px;' value='" + projectlowconsumeinfo[i].EquipNum + "' name='consumpnum" + i + "' id='consumpnum" + i + "' type='text' />";
strHTML2 += "</td>";
strHTML2 += "<td>";
strHTML2 += "<input style='width:50px;' value='" + projectlowconsumeinfo[i].Introduction + "' name='consumpintro" + i + "' id='consumpintro" + i + "' type='text' />";
strHTML2 += "</td>";
strHTML2 += "<td>";
strHTML2 += "<a>删除</a>";
strHTML2 += "</td>";
strHTML2 += "</tr>";
}
strHTML2 += "</tbody>";
strHTML2 += "</table>";
lbConsump.Text += strHTML2;
#endregion
}
