protected void Page_Load(object sender, EventArgs e) { accessControl(); if (String.IsNullOrEmpty(Request["ProjectID"]) || String.IsNullOrEmpty(Request["MID"])) { Response.Redirect("Default.aspx"); } ProjectID = Request["ProjectID"].ToString(); MatchID = Request["MID"].ToString(); Match = BLL.Match.SelectOne(Convert.ToInt32(MatchID)); Projects = BLL.CupProjectModel.FindByInt(ProjectID, "ID"); if (Projects.Count > 0) { Project = Projects[0]; } else { Project = new Models.DB.CupProjectModel(); } Declarant = BLL.CupDeclarantInfo.SelectOneByProjectID(ProjectID); TeamMember = BLL.CupTeamMemberInfo.SelectByProjectId(ProjectID); Recommender = BLL.RecommendInfo.SelectByProjectId(ProjectID); Student = BLL.StudentInfoModel.SelectOneByUserId(Project.UserID.ToString()); if (Project.Category == "自然科学类学术论文") { WorkInfoList = BLL.CupWorksInfo.FindByInt(ProjectID, "ProjectID"); if (WorkInfoList.Count > 0) { WorkInfo = WorkInfoList[0]; } else { WorkInfo = new Models.DB.CupWorksInfo(); } } else if (Project.Category == "哲学社会科学类社会调查报告和学术论文") { SurveyInfoList = BLL.CupWorksSurvey.FindByInt(ProjectID, "ProjectID"); if (SurveyInfoList.Count > 0) { SurveyInfo = SurveyInfoList[0]; } else { SurveyInfo = new Models.DB.CupWorksSurvey(); } } else if (Project.Category == "科技发明制作") { InventionInfoList = BLL.CupWorksInvention.FindByInt(ProjectID, "ProjectID"); if (InventionInfoList.Count > 0) { InventionInfo = InventionInfoList[0]; } else { InventionInfo = new Models.DB.CupWorksInvention(); } } }
public static int UpData(String ID, String[,] data, String ProjectID) { #region 检查输入的合法性 if (data == null) { return(0); } #endregion #region 把数据组装成对象 Models.DB.CupWorksInvention model = new Models.DB.CupWorksInvention(); model.Categories = data[0, 0]; model.Purpose = data[0, 1]; model.Features = data[0, 2]; model.WorkStatu = data[0, 4]; model.AssignmentWay = data[0, 5]; model.WorkShow = data[0, 6]; model.ReceivedAwards = data[0, 3]; model.ApplyValue = data[0, 7]; model.PatentStatu = data[0, 8]; model.SameResearchLevel = data[0, 9]; model.Id = Convert.ToInt32(ID); model.ProjectID = Convert.ToInt32(ProjectID); #endregion return(DAL.Update.ChangeSome(model, "Id")); }
public static int CreateMore(String[,] data, String ProjectID) { #region 检查输入的合法性 if (data == null) { return(0); } #endregion #region 把数据组装成对象 List <Models.DB.CupWorksInvention> list = new List <Models.DB.CupWorksInvention>(); for (int i = 0; i < data.GetLength(0); i++) { Models.DB.CupWorksInvention model = new Models.DB.CupWorksInvention(); model.Categories = data[i, 0]; model.Purpose = data[i, 1]; model.Features = data[i, 2]; model.WorkStatu = data[i, 4]; model.AssignmentWay = data[i, 5]; model.WorkShow = data[i, 6]; model.ReceivedAwards = data[i, 3]; model.ApplyValue = data[i, 7]; model.PatentStatu = data[i, 8]; model.SameResearchLevel = data[i, 9]; model.ProjectID = Convert.ToInt32(ProjectID); list.Add(model); } #endregion return(DAL.Create.CreateList(list)); }
public static List <Models.DB.CupWorksInvention> FindByInt(String Value, String ValueName) { #region 输入合法性检查 int valueInt; try { valueInt = Convert.ToInt32(Value); } catch { return(null); } #endregion List <Models.DB.CupWorksInvention> list = new List <Models.DB.CupWorksInvention>(); DataTable dt = DAL.Select.QueryOne(valueInt, "Tb_CupWorksInvention", ValueName); foreach (DataRow row in dt.Rows) { Models.DB.CupWorksInvention model = new Models.DB.CupWorksInvention(); model.ApplyValue = row["ApplyValue"].ToString(); model.Features = row["Features"].ToString(); model.AssignmentWay = row["AssignmentWay"].ToString(); model.Id = Convert.ToInt32(row["ID"]); model.Categories = row["Categories"].ToString(); model.PatentStatu = row["PatentStatu"].ToString(); model.ProjectID = Convert.ToInt32(row["ProjectID"]); model.Purpose = row["Purpose"].ToString(); model.ReceivedAwards = row["ReceivedAwards"].ToString(); model.WorkShow = row["WorkShow"].ToString(); model.SameResearchLevel = row["SameResearchLevel"].ToString(); model.WorkStatu = row["WorkStatu"].ToString(); list.Add(model); } return(list); }