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();
}
