protected void bnSave_Click(object sender, EventArgs e)
{
LabMS.BLL.OpentProject bopproject = new LabMS.BLL.OpentProject();
string strWhere = "ID =" + lbCID.Text;
List<LabMS.Model.OpentProject> listmopproject = bopproject.GetModelList(strWhere);
if (listmopproject.Count == 0)
{
Common.JShelper.JSAlert(Page, "err2", "开放实验项目不存在!");
}
LabMS.Model.OpentProject moproject = listmopproject[0];
#region 验证
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;
try
{
bopproject.Update(moproject);
}
catch (Exception ex)
{
lbErr.Visible = true;
lbErr.Text = ex.Message;
return;
}
String[] listsID = tb_StudentIDs.Value.Split(',');
LabMS.Model.ProjectAppointment projectapp = new LabMS.Model.ProjectAppointment();
ExtendBLL.ProjectAppointment bprojectapp = new ExtendBLL.ProjectAppointment();
bprojectapp.Del(" where OP_ProjectCode ='" + moproject.OP_ProjectCode + "'");
for (int i = 0; i < listsID.Length; ++i)
{
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 + "'");
return;
}
}
AttachmentItemSave(moproject);
Common.JShelper.JSAlertAndRedirect(Page, "success", strAlertContent, "currentopenprojectlist.aspx");
}
/// <summary>
/// �õ�һ������ʵ��
/// </summary>
public LabMS.Model.ProjectAppointment GetModel(int id)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select top 1 id,OP_Appoint_ID,Appoint_ProID,Appoint_ClassID,OP_ProjectCode,OP_Score from ProjectAppointment ");
strSql.Append(" where id=@id ");
SqlParameter[] parameters = {
new SqlParameter("@id", SqlDbType.Int,4)};
parameters[0].Value = id;
LabMS.Model.ProjectAppointment model=new LabMS.Model.ProjectAppointment();
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_Appoint_ID=ds.Tables[0].Rows[0]["OP_Appoint_ID"].ToString();
if(ds.Tables[0].Rows[0]["Appoint_ProID"].ToString()!="")
{
model.Appoint_ProID=int.Parse(ds.Tables[0].Rows[0]["Appoint_ProID"].ToString());
}
model.Appoint_ClassID=ds.Tables[0].Rows[0]["Appoint_ClassID"].ToString();
model.OP_ProjectCode=ds.Tables[0].Rows[0]["OP_ProjectCode"].ToString();
model.OP_Score=ds.Tables[0].Rows[0]["OP_Score"].ToString();
return model;
}
else
{
return null;
}
}
