protected void AttachItemDataBind()
{
if (!string.IsNullOrEmpty(Request.QueryString["ID"]))
{
int ID = 0;
if (int.TryParse(Request.QueryString["ID"], out ID))
{
LabMS.BLL.OpentProject OpenProject = new LabMS.BLL.OpentProject();
LabMS.Model.OpentProject openprojectmodel = new LabMS.Model.OpentProject();
LabMS.BLL.AttachmentItem AttachItem = new LabMS.BLL.AttachmentItem();
List<LabMS.Model.AttachmentItem> ls = new List<LabMS.Model.AttachmentItem>();
openprojectmodel = OpenProject.GetModel(ID);
if (openprojectmodel != null)
{
if (openprojectmodel.Attachment != null)
{
int Attach_ID = openprojectmodel.Attachment.Value;
if (Attach_ID != 0)
{
ls = AttachItem.GetModelList("Attach_ID=" + Attach_ID);
if (ls.Count != 0)
{
string strHTML = "<table>";
for (int i = 0; i < ls.Count; i++)
{
strHTML += "<tr>";
strHTML += "<td style='display:none;'>";
strHTML += ls[i].ID;
strHTML += "</td>";
strHTML += "<td>";
strHTML += "<a>";
strHTML += "删除";
strHTML += "</a>";
strHTML += "</td>";
strHTML += "<td>";
strHTML += ls[i].Item_Name;
strHTML += "</td>";
strHTML += "</tr>";
}
strHTML += "</table>";
itemlist.Value = strHTML;
}
}
}
}
}
}
}
/// <summary>
/// �õ�һ������ʵ��
/// </summary>
public LabMS.Model.OpentProject GetModel(int ID)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select top 1 ID,OP_ProjectName,OP_ProjectCode,OP_PlanningCourseTime,Project_Lab,Project_PartnerType,Project_Category,Project_Type,Project_Subject,Project_Require,OP_Applicant,OP_InCharge,OP_Approval,OP_AppTime,OP_Professioanl,Course_ID,Project_StartWeek,Project_EndWeek,OP_Grade,OP_Funds,OP_ProSource,OP_Phone,OP_Teacher,OP_AppIntro,OP_Appointment,OP_Reason,OP_OpenType,OP_Audit,SYear,Semester,AuditOpinion,CheckTime,Attachment from OpentProject ");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters = {
new SqlParameter("@ID", SqlDbType.Int,4)};
parameters[0].Value = ID ;
LabMS.Model.OpentProject model=new LabMS.Model.OpentProject();
DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters);
if(ds.Tables[0].Rows.Count>0)
{
if(ds.Tables[0].Rows[0]["ID"].ToString()!="")
{
model.ID=int.Parse(ds.Tables[0].Rows[0]["ID"].ToString());
}
model.OP_ProjectName=ds.Tables[0].Rows[0]["OP_ProjectName"].ToString();
model.OP_ProjectCode=ds.Tables[0].Rows[0]["OP_ProjectCode"].ToString();
model.OP_PlanningCourseTime=ds.Tables[0].Rows[0]["OP_PlanningCourseTime"].ToString();
model.Project_Lab=ds.Tables[0].Rows[0]["Project_Lab"].ToString();
model.Project_PartnerType=ds.Tables[0].Rows[0]["Project_PartnerType"].ToString();
model.Project_Category=ds.Tables[0].Rows[0]["Project_Category"].ToString();
model.Project_Type=ds.Tables[0].Rows[0]["Project_Type"].ToString();
model.Project_Subject=ds.Tables[0].Rows[0]["Project_Subject"].ToString();
model.Project_Require=ds.Tables[0].Rows[0]["Project_Require"].ToString();
model.OP_Applicant=ds.Tables[0].Rows[0]["OP_Applicant"].ToString();
model.OP_InCharge=ds.Tables[0].Rows[0]["OP_InCharge"].ToString();
model.OP_Approval=ds.Tables[0].Rows[0]["OP_Approval"].ToString();
if(ds.Tables[0].Rows[0]["OP_AppTime"].ToString()!="")
{
model.OP_AppTime=DateTime.Parse(ds.Tables[0].Rows[0]["OP_AppTime"].ToString());
}
model.OP_Professioanl=ds.Tables[0].Rows[0]["OP_Professioanl"].ToString();
if(ds.Tables[0].Rows[0]["Course_ID"].ToString()!="")
{
model.Course_ID=int.Parse(ds.Tables[0].Rows[0]["Course_ID"].ToString());
}
if(ds.Tables[0].Rows[0]["Project_StartWeek"].ToString()!="")
{
model.Project_StartWeek=int.Parse(ds.Tables[0].Rows[0]["Project_StartWeek"].ToString());
}
if(ds.Tables[0].Rows[0]["Project_EndWeek"].ToString()!="")
{
model.Project_EndWeek=int.Parse(ds.Tables[0].Rows[0]["Project_EndWeek"].ToString());
}
model.OP_Grade=ds.Tables[0].Rows[0]["OP_Grade"].ToString();
model.OP_Funds=ds.Tables[0].Rows[0]["OP_Funds"].ToString();
model.OP_ProSource=ds.Tables[0].Rows[0]["OP_ProSource"].ToString();
model.OP_Phone=ds.Tables[0].Rows[0]["OP_Phone"].ToString();
model.OP_Teacher=ds.Tables[0].Rows[0]["OP_Teacher"].ToString();
model.OP_AppIntro=ds.Tables[0].Rows[0]["OP_AppIntro"].ToString();
model.OP_Appointment=ds.Tables[0].Rows[0]["OP_Appointment"].ToString();
model.OP_Reason=ds.Tables[0].Rows[0]["OP_Reason"].ToString();
model.OP_OpenType=ds.Tables[0].Rows[0]["OP_OpenType"].ToString();
model.OP_Audit=ds.Tables[0].Rows[0]["OP_Audit"].ToString();
if(ds.Tables[0].Rows[0]["SYear"].ToString()!="")
{
model.SYear=int.Parse(ds.Tables[0].Rows[0]["SYear"].ToString());
}
if(ds.Tables[0].Rows[0]["Semester"].ToString()!="")
{
model.Semester=int.Parse(ds.Tables[0].Rows[0]["Semester"].ToString());
}
model.AuditOpinion=ds.Tables[0].Rows[0]["AuditOpinion"].ToString();
if(ds.Tables[0].Rows[0]["CheckTime"].ToString()!="")
{
model.CheckTime=DateTime.Parse(ds.Tables[0].Rows[0]["CheckTime"].ToString());
}
if(ds.Tables[0].Rows[0]["Attachment"].ToString()!="")
{
model.Attachment=int.Parse(ds.Tables[0].Rows[0]["Attachment"].ToString());
}
return model;
}
else
{
return null;
}
}
protected void bnSave_Click(object sender, EventArgs e)
{
LabMS.BLL.OpentProject boproject = new LabMS.BLL.OpentProject();
LabMS.Model.OpentProject moproject = new LabMS.Model.OpentProject();
lbErr.Visible = false;
#region 验证
if (string.IsNullOrEmpty(tbProjectName.Text.Trim()))
{
LabMS.Common.JShelper.JSAlert(Page, "err", "实验项目名称不能为空!");
return;
}
if (string.IsNullOrEmpty(tbProjectCode.Text.Trim()))
{
LabMS.Common.JShelper.JSAlert(Page, "err", "实验项目编号不能为空!");
return;
}
List<LabMS.Model.OpentProject> listmoproject = new List<LabMS.Model.OpentProject>();
listmoproject = boproject.GetModelList("OP_ProjectCode = '" + tbProjectCode.Text + "'");
if (listmoproject.Count > 0)
{
LabMS.Common.JShelper.JSAlert(Page, "err", "实验项目编号已存在!");
return;
}
if (string.IsNullOrEmpty(tbProjectStartWeek.Text.Trim()) || string.IsNullOrEmpty(tbProjectEndWeek.Text.Trim()))
{
LabMS.Common.JShelper.JSAlert(Page, "err", "实验周次不能为空!");
return;
}
int iStartWeek = 0;
int iEndWeek = 0;
if (!(int.TryParse(tbProjectStartWeek.Text.Trim(), out iStartWeek) && int.TryParse(tbProjectEndWeek.Text.Trim(), out iEndWeek)))
{
LabMS.Common.JShelper.JSAlert(Page, "err", "实验周次只能输入数字!");
return;
}
if (iStartWeek > iEndWeek)
{
LabMS.Common.JShelper.JSAlert(Page, "err", "实验周次开始时间大于结束时间!");
return;
}
if (iStartWeek > 20 || iEndWeek > 20)
{
LabMS.Common.JShelper.JSAlert(Page, "err", "实验周次过大!");
return;
}
if (string.IsNullOrEmpty(tbTeacherCode.Value.Trim()))
{
LabMS.Common.JShelper.JSAlert(Page, "err", "指导老师不能为空!");
return;
}
if (string.IsNullOrEmpty(tb_StudentIDs.Value.Trim()))
{
LabMS.Common.JShelper.JSAlert(Page, "err", "实验学生不能为空!");
return;
}
#endregion
moproject.OP_ProjectName = tbProjectName.Text.Trim();
moproject.OP_ProjectCode = tbProjectCode.Text.Trim();
moproject.Project_Category = ddlProjectCategory.SelectedValue;
moproject.Project_EndWeek = iEndWeek;
moproject.Project_Lab = ddlLabName.SelectedValue;
moproject.Project_PartnerType = ddlProjectPartnerType.SelectedValue;
moproject.Project_Require = ddlProjectRequire.SelectedValue;
moproject.Project_StartWeek = iStartWeek;
moproject.Project_Subject = tbProjectSubjectCode.Value;
moproject.Project_Type = ddlProjectType.SelectedValue;
moproject.OP_AppIntro = tbOPReason.Text.Trim();
moproject.OP_ProSource = ddlProjectComFrom.SelectedValue;
moproject.OP_Professioanl = tbOPProfessioanl.Text.Trim();
moproject.OP_PlanningCourseTime = tbOPPlanningCourseTime.Text.Trim();
moproject.OP_Phone = tbOPPhone.Text.Trim();
moproject.OP_InCharge = tbOPInCharge.Text.Trim();
moproject.OP_Grade = ddlOPGrade.SelectedValue;
moproject.OP_AppIntro = tbOPContent.Text.Trim();
moproject.OP_Teacher = tbTeacherCode.Value.Trim();
moproject.OP_OpenType = tbOPContent.Text.Trim();//实验内容
LabMS.Model.SysSetting msys = new LabMS.Model.SysSetting();
ExtendBLL.SysSetting extendsys = new ExtendBLL.SysSetting();
msys = extendsys.GetCurrentSetting();
moproject.SYear = msys.CurrentYear;
moproject.Semester = msys.CurrentSemester;
string strAlertContent = "保存成功!";
moproject.OP_Audit = "0";
if (((Button)sender).ID == "btnApp")
{
strAlertContent = "申请成功!";
moproject.OP_Audit = "1";
}
moproject.OP_AppTime = DateTime.Now;
moproject.OP_Applicant = lbAppPerson.Text;
int iOpenProjectID = 0;
////添加文件
int Attach_ID = AttachmentSave();
try
{
if (Attach_ID != 0)
{
moproject.Attachment = Attach_ID;
}
iOpenProjectID = boproject.Add(moproject);
}
catch(Exception ex)
{
lbErr.Visible = true;
lbErr.Text = ex.Message;
return;
}
String [] listsID = tb_StudentIDs.Value.Split(',');
for (int i = 0; i < listsID.Length; ++i)
{
LabMS.Model.ProjectAppointment projectapp = new LabMS.Model.ProjectAppointment();
ExtendBLL.ProjectAppointment bprojectapp = new ExtendBLL.ProjectAppointment();
projectapp.Appoint_ClassID = "0";
projectapp.Appoint_ProID = 0;
projectapp.OP_Appoint_ID = listsID[i].ToString();
projectapp.OP_ProjectCode = moproject.OP_ProjectCode;
projectapp.OP_Score = "";
try
{
bprojectapp.Add(projectapp);
}
catch (Exception ex)
{
lbErr.Visible = true;
lbErr.Text = ex.Message;
bprojectapp.Del(" where OP_ProjectCode ='" + moproject.OP_ProjectCode + "'");
boproject.Delete(iOpenProjectID);
return;
}
}
Common.JShelper.JSAlertAndRedirect(Page, "success", strAlertContent, "currentopenprojectlist.aspx");
}
protected void Gv_File_DataBind()
{
if (!string.IsNullOrEmpty(Request.QueryString["ID"]))
{
if (IsNumber(Request.QueryString["ID"].Trim()))
{
int num=0;
if (int.TryParse(Request.QueryString["ID"].Trim(), out num))
{
LabMS.BLL.AttachmentItem AttachmentItem = new LabMS.BLL.AttachmentItem();
List<LabMS.Model.AttachmentItem> ls = new List<LabMS.Model.AttachmentItem>();
LabMS.Model.OpentProject openprojectmodel = new LabMS.Model.OpentProject();
LabMS.BLL.OpentProject OpenProject = new LabMS.BLL.OpentProject();
openprojectmodel= OpenProject.GetModel(num);
if (openprojectmodel != null)
{
if (openprojectmodel.Attachment != null)
{
ls = AttachmentItem.GetModelList("Attach_ID=" + openprojectmodel.Attachment);
}
}
Gv_File.DataSource = ls;
Gv_File.DataBind();
}
}
}
}
