public void BatchDeleteTest() { ProjectBasicInfo v1 = new ProjectBasicInfo(); ProjectBasicInfo v2 = new ProjectBasicInfo(); using (var context = new DataContext(_seed, DBTypeEnum.Memory)) { v1.ProjectName = "lHhk51hgA"; v1.ProjectMember = "45235"; v2.ProjectName = "y6jTNUn"; v2.ProjectMember = "123123"; context.Set <ProjectBasicInfo>().Add(v1); context.Set <ProjectBasicInfo>().Add(v2); context.SaveChanges(); } PartialViewResult rv = (PartialViewResult)_controller.BatchDelete(new string[] { v1.ID.ToString(), v2.ID.ToString() }); Assert.IsInstanceOfType(rv.Model, typeof(ProjectBasicInfoBatchVM)); ProjectBasicInfoBatchVM vm = rv.Model as ProjectBasicInfoBatchVM; vm.Ids = new string[] { v1.ID.ToString(), v2.ID.ToString() }; _controller.DoBatchDelete(vm, null); using (var context = new DataContext(_seed, DBTypeEnum.Memory)) { Assert.AreEqual(context.Set <ProjectBasicInfo>().Count(), 2); } }
public void DeleteTest() { ProjectBasicInfo v = new ProjectBasicInfo(); using (var context = new DataContext(_seed, DBTypeEnum.Memory)) { v.ProjectName = "lHhk51hgA"; v.ProjectMember = "erwe"; context.Set <ProjectBasicInfo>().Add(v); context.SaveChanges(); } PartialViewResult rv = (PartialViewResult)_controller.Delete(v.ID.ToString()); Assert.IsInstanceOfType(rv.Model, typeof(ProjectBasicInfoVM)); ProjectBasicInfoVM vm = rv.Model as ProjectBasicInfoVM; v = new ProjectBasicInfo(); v.ID = vm.Entity.ID; vm.Entity = v; _controller.Delete(v.ID.ToString(), null); using (var context = new DataContext(_seed, DBTypeEnum.Memory)) { Assert.AreEqual(context.Set <ProjectBasicInfo>().Count(), 1); } }
public void DetailsTest() { ProjectBasicInfo v = new ProjectBasicInfo(); using (var context = new DataContext(_seed, DBTypeEnum.Memory)) { v.ProjectName = "lHhk51hgA"; v.ProjectMember = "123123"; context.Set <ProjectBasicInfo>().Add(v); context.SaveChanges(); } PartialViewResult rv = (PartialViewResult)_controller.Details(v.ID.ToString()); Assert.IsInstanceOfType(rv.Model, typeof(IBaseCRUDVM <TopBasePoco>)); Assert.AreEqual(v.ID, (rv.Model as IBaseCRUDVM <TopBasePoco>).Entity.GetID()); }
internal ProjectBasicInfo GetProjectBasicInfo() { string querystring = "select ProjectName,ProjectSecret,ApplicationArea,ProjectTD,ProjectMRD,ProjectBaseT,ProjectKeyWord,\r\n ProjectBrief,ProjectLimitT from BaseInfor"; string text = ""; DataTable data = base.GetData(querystring, out text); ProjectBasicInfo projectBasicInfo = null; if (data != null && data.Rows.Count > 0) { projectBasicInfo = new ProjectBasicInfo(); projectBasicInfo.ProjectName = ((data.Rows[0]["ProjectName"] == DBNull.Value) ? "" : data.Rows[0]["ProjectName"].ToString()); projectBasicInfo.ProjectSecret = ((data.Rows[0]["ProjectSecret"] == DBNull.Value) ? "" : data.Rows[0]["ProjectSecret"].ToString()); projectBasicInfo.ApplicationArea = ((data.Rows[0]["ApplicationArea"] == DBNull.Value) ? "" : data.Rows[0]["ApplicationArea"].ToString()); projectBasicInfo.ProjectTD = ((data.Rows[0]["ProjectTD"] == DBNull.Value) ? "" : data.Rows[0]["ProjectTD"].ToString()); projectBasicInfo.ProjectMRD = ((data.Rows[0]["ProjectMRD"] == DBNull.Value) ? "" : data.Rows[0]["ProjectMRD"].ToString()); projectBasicInfo.ProjectBaseT = ((data.Rows[0]["ProjectBaseT"] == DBNull.Value) ? "" : data.Rows[0]["ProjectBaseT"].ToString()); projectBasicInfo.ProjectKeyWord = ((data.Rows[0]["ProjectKeyWord"] == DBNull.Value) ? "" : data.Rows[0]["ProjectKeyWord"].ToString()); projectBasicInfo.ProjectBrief = ((data.Rows[0]["ProjectBrief"] == DBNull.Value) ? "" : data.Rows[0]["ProjectBrief"].ToString()); if (data.Rows[0]["ProjectLimitT"] != DBNull.Value && data.Rows[0]["ProjectLimitT"].ToString() != string.Empty) { string[] array = data.Rows[0]["ProjectLimitT"].ToString().Split(new char[] { '~' }); projectBasicInfo.ProjectLimitStart = array[0].TrimEnd(new char[] { '年' }); projectBasicInfo.ProjectLimitEnd = array[1].TrimEnd(new char[] { '年' }); } else { projectBasicInfo.ProjectLimitStart = DateTime.Now.Year.ToString(); projectBasicInfo.ProjectLimitEnd = (DateTime.Now.Year + 4).ToString(); } } return(projectBasicInfo); }
internal bool AddProjectBasicInfo(ProjectBasicInfo pinfo) { string sql = "insert into BaseInfor (ProjectName,ProjectSecret,ApplicationArea,ProjectTD,ProjectMRD,ProjectBaseT,ProjectKeyWord,\r\n ProjectBrief,ProjectLimitT) values( @ProjectName,@ProjectSecret,@ApplicationArea,@ProjectTD,@ProjectMRD,@ProjectBaseT,@ProjectKeyWord,\r\n @ProjectBrief,@ProjectLimitT)"; SQLiteParameter[] parameters = new SQLiteParameter[] { new SQLiteParameter("@ProjectName", pinfo.ProjectName), new SQLiteParameter("@ProjectSecret", pinfo.ProjectSecret), new SQLiteParameter("@ApplicationArea", pinfo.ApplicationArea), new SQLiteParameter("@ProjectTD", pinfo.ProjectTD), new SQLiteParameter("@ProjectMRD", pinfo.ProjectMRD), new SQLiteParameter("@ProjectBaseT", pinfo.ProjectBaseT), new SQLiteParameter("@ProjectKeyWord", pinfo.ProjectKeyWord), new SQLiteParameter("@ProjectBrief", pinfo.ProjectBrief), new SQLiteParameter("@ProjectLimitT", pinfo.ProjectLimitStart + "年~" + pinfo.ProjectLimitEnd + "年") }; string text = ""; base.ExecuteNonQuery(sql, parameters, out text); return(true); }
internal bool UpdateProjectBasicInfo(ProjectBasicInfo pinfo) { string sql = "update BaseInfor set ProjectName=@ProjectName,ProjectSecret=@ProjectSecret,\r\nApplicationArea=@ApplicationArea,ProjectTD=@ProjectTD,ProjectMRD=@ProjectMRD,ProjectBaseT=@ProjectBaseT,ProjectKeyWord=@ProjectKeyWord,\r\n ProjectBrief=@ProjectBrief,ProjectLimitT=@ProjectLimitT"; SQLiteParameter[] parameters = new SQLiteParameter[] { new SQLiteParameter("@ProjectName", pinfo.ProjectName), new SQLiteParameter("@ProjectSecret", pinfo.ProjectSecret), new SQLiteParameter("@ApplicationArea", pinfo.ApplicationArea), new SQLiteParameter("@ProjectTD", pinfo.ProjectTD), new SQLiteParameter("@ProjectMRD", pinfo.ProjectMRD), new SQLiteParameter("@ProjectBaseT", pinfo.ProjectBaseT), new SQLiteParameter("@ProjectKeyWord", pinfo.ProjectKeyWord), new SQLiteParameter("@ProjectBrief", pinfo.ProjectBrief), new SQLiteParameter("@ProjectLimitT", pinfo.ProjectLimitStart + "年~" + pinfo.ProjectLimitEnd + "年") }; string text = ""; base.ExecuteNonQuery(sql, parameters, out text); return(true); }
public void EditTest() { ProjectBasicInfo v = new ProjectBasicInfo(); using (var context = new DataContext(_seed, DBTypeEnum.Memory)) { v.ProjectName = "lHhk51hgA"; v.ProjectMember = "232"; context.Set <ProjectBasicInfo>().Add(v); context.SaveChanges(); } PartialViewResult rv = (PartialViewResult)_controller.Edit(v.ID.ToString()); Assert.IsInstanceOfType(rv.Model, typeof(ProjectBasicInfoVM)); ProjectBasicInfoVM vm = rv.Model as ProjectBasicInfoVM; v = new ProjectBasicInfo(); v.ID = vm.Entity.ID; v.ProjectName = "y6jTNUn"; v.ProjectMember = "asdadw"; vm.Entity = v; vm.FC = new Dictionary <string, object>(); vm.FC.Add("Entity.ProjectName", ""); vm.FC.Add("Entity.ProjectMember", ""); _controller.Edit(vm); using (var context = new DataContext(_seed, DBTypeEnum.Memory)) { var data = context.Set <ProjectBasicInfo>().FirstOrDefault(); Assert.AreEqual(data.ProjectName, "y6jTNUn"); Assert.AreEqual(data.ProjectMember, 5); Assert.AreEqual(data.UpdateBy, "user"); Assert.IsTrue(DateTime.Now.Subtract(data.UpdateTime.Value).Seconds < 10); } }
public void CreateTest() { PartialViewResult rv = (PartialViewResult)_controller.Create(); Assert.IsInstanceOfType(rv.Model, typeof(ProjectBasicInfoVM)); ProjectBasicInfoVM vm = rv.Model as ProjectBasicInfoVM; ProjectBasicInfo v = new ProjectBasicInfo(); v.ProjectName = "lHhk51hgA"; v.ProjectMember = "123"; vm.Entity = v; _controller.Create(vm); using (var context = new DataContext(_seed, DBTypeEnum.Memory)) { var data = context.Set <ProjectBasicInfo>().FirstOrDefault(); Assert.AreEqual(data.ProjectName, "lHhk51hgA"); Assert.AreEqual(data.ProjectMember, 75); Assert.AreEqual(data.CreateBy, "user"); Assert.IsTrue(DateTime.Now.Subtract(data.CreateTime.Value).Seconds < 10); } }
public bool UpdateProjectBasicInfo(ProjectBasicInfo pinfo) { return(this._projectBasicInfoDao.UpdateProjectBasicInfo(pinfo)); }
public Task <bool> UpdatePojectBasicInfo(ProjectBasicInfo projectBasicInfo) { throw new NotImplementedException(); }
public Task <bool> CreateNewProject(ProjectBasicInfo projectBasicInfo) { throw new NotImplementedException(); }