public IActionResult Add([FromBody] dept dept)
{
string msg = "";
string myurl1 = url + "api/v1/configuration/public/dept";
string result1 = GetUrl(myurl1);
JObject jo1 = (JObject)JsonConvert.DeserializeObject(result1);
var typeList = jo1["data"].ToObject <IList <Model.dept> >();
var list = typeList.Any(p => p.name_cn == dept.name_cn || p.name_en == dept.name_en || p.name_tw == dept.name_tw);
if (list == false)//没有重复的
{
string addurl = url + "api/v1/configuration/public/dept";
var postData = JsonConvert.SerializeObject(dept);
string result = PostUrl(addurl, postData);
JObject jo = (JObject)JsonConvert.DeserializeObject(result);
switch (Convert.ToInt32(jo["code"]))
{
case 200:
msg = "Success";
break;
}
}
else
{
msg = "fail";
}
return(Json(msg));
}
public IActionResult Delete([FromBody] dept dept)
{
string deleteurl = url + "api/v1/configuration/public/dept?id=" + dept.id.ToString();
string result = DeleteUrl(deleteurl);
JObject jo = (JObject)JsonConvert.DeserializeObject(result);
switch (Convert.ToInt32(jo["code"]))
{
case 200:
Json("Success");
break;
case 400:
break;
case 410:
break;
case 411:
break;
default:
break;
}
return(Json("Success"));
}
public void DeleteTest()
{
dept v = new dept();
using (var context = new DataContext(_seed, DBTypeEnum.Memory))
{
v.Index = 13;
context.Set <dept>().Add(v);
context.SaveChanges();
}
PartialViewResult rv = (PartialViewResult)_controller.Delete(v.ID.ToString());
Assert.IsInstanceOfType(rv.Model, typeof(deptVM));
deptVM vm = rv.Model as deptVM;
v = new dept();
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 <dept>().Count(), 0);
}
}
public ActionResult Edit(int id)
{
dept dept = db.depts.Find(id);
ViewBag.collegeid = new SelectList(db.colleges, "collegeid", "collegeName", dept.collegeid);
return(View(dept));
}
public void BatchDeleteTest()
{
dept v1 = new dept();
dept v2 = new dept();
using (var context = new DataContext(_seed, DBTypeEnum.Memory))
{
v1.Index = 13;
v2.Index = 56;
context.Set <dept>().Add(v1);
context.Set <dept>().Add(v2);
context.SaveChanges();
}
PartialViewResult rv = (PartialViewResult)_controller.BatchDelete(new string[] { v1.ID.ToString(), v2.ID.ToString() });
Assert.IsInstanceOfType(rv.Model, typeof(deptBatchVM));
deptBatchVM vm = rv.Model as deptBatchVM;
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 <dept>().Count(), 0);
}
}
/// <summary>
/// 添加
/// </summary>
public int add(dept record)
{
using (qdbEntities myDb = new qdbEntities())
{
myDb.dept.Add(record);
return(myDb.SaveChanges());
}
}
public ActionResult DeleteConfirmed(int id)
{
dept dept = db.depts.Find(id);
db.depts.Remove(dept);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult deletedept(int id)
{
dept dep = obj.department.Find(id);
obj.department.Remove(dep);
obj.SaveChanges();
return(View("displaydept", obj.department.ToList()));
}
public ActionResult editdept(dept d)
{
dept dep = obj.department.Find(d.did);
dep.dname = d.dname;
obj.SaveChanges();
return(View("displaydept", obj.department.ToList()));
}
/// <summary>
/// 更新
/// </summary>
public int updateById(dept record)
{
using (qdbEntities myDb = new qdbEntities())
{
myDb.dept.Attach(record);
myDb.Entry(record).State = EntityState.Modified;
return(myDb.SaveChanges());
}
}
public bool deptExits(dept dept)
{
var depts = db.depts.Where(d => d.name.Equals(dept.name));
if (dept.id.CompareTo(0) > 0)
{
return(depts.Where(d => !d.id.Equals(dept.id)).Count() > 0);
}
return(depts.Count() > 0);
}
public ActionResult Edit([Bind(Include = "deptno,dname,loc")] dept dept)
{
if (ModelState.IsValid)
{
db.Entry(dept).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(dept));
}
public ActionResult Create([Bind(Include = "deptno,dname,loc")] dept dept)
{
if (ModelState.IsValid)
{
db.depts.Add(dept);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(dept));
}
// Add Department Record
public ActionResult CreateDepartment()
{
dept model = new dept
{
dept_desc = string.Empty,
createdby = User.Identity.Name.Replace("GREENSPOONMARDE\\", ""),
createddate = DateTime.Now
};
return(PartialView("_CreateDepartment", model));
}
/// <summary>
///删除
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public int Delte(dept info)
{
try
{
db.Entry(info).State = System.Data.EntityState.Deleted;
return(db.SaveChanges());
}
catch (Exception ex)
{
throw;
}
}
private Guid AddDept()
{
dept v = new dept();
using (var context = new DataContext(_seed, DBTypeEnum.Memory))
{
v.Index = 47;
context.Set <dept>().Add(v);
context.SaveChanges();
}
return(v.ID);
}
public ActionResult CreateDepartment(int id, dept dept)
{
string projDesc = projectInfo.returnProjectDescription(id);
if (TryUpdateModel(dept))
{
_ctx.depts.Add(dept);
_ctx.SaveChanges();
return(RedirectToAction("Index", new { searchTerm = projDesc }));
}
return(View(dept));
}
/// <summary>
/// 添加
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public dept Add(dept info)
{
try
{
db.dept.Add(info);
db.SaveChanges();
return(info);
}
catch (Exception ex)
{
throw;
}
}
/// <summary>
/// 修改
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public dept Entity(dept info)
{
try
{
db.Entry(info).State = System.Data.EntityState.Modified;
db.SaveChanges();
return(info);
}
catch (Exception ex)
{
throw;
}
}
// GET: depts/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
dept dept = db.depts.Find(id);
if (dept == null)
{
return(HttpNotFound());
}
return(View(dept));
}
public void DetailsTest()
{
dept v = new dept();
using (var context = new DataContext(_seed, DBTypeEnum.Memory))
{
v.Index = 13;
context.Set <dept>().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());
}
public ActionResult Create(dept dept)
{
if (deptExits(dept))
{
ModelState.AddModelError("", "Department Already Exists");
}
if (ModelState.IsValid)
{
db.depts.Add(dept);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.collegeid = new SelectList(db.colleges, "collegeid", "collegeName", dept.collegeid);
return(View(dept));
}
/// <summary>
/// 删除
/// </summary>
public int deleteById(int id)
{
using (qdbEntities myDb = new qdbEntities())
{
// TODO 生成代码后需要检查一下是否找到正确的主键，这里做一个错误代码，避免直接使用
dept record = new dept()
{
ID = id
};
myDb.dept.Attach(record);
myDb.Entry(record).State = EntityState.Deleted;
return(myDb.SaveChanges());
}
}
// GET: depts/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
dept dept = db.deptSet.Find(id);
if (dept == null)
{
return(HttpNotFound());
}
db.deptSet.Remove(dept);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public IActionResult Update([FromBody] dept dept)
{
string msg = "";
string myurl1 = url + "api/v1/configuration/public/dept";
string result1 = GetUrl(myurl1);
JObject jo1 = (JObject)JsonConvert.DeserializeObject(result1);
var typeList = jo1["data"].ToObject <IList <Model.dept> >();
var list = typeList.Where(p => p.id != dept.id);
var lists = list.Any(p => p.name_cn == dept.name_cn || p.name_en == dept.name_en || p.name_tw == dept.name_tw);
if (lists == false)
{
string updateurl = url + "api/v1/configuration/public/dept";
string postData = "{{\"id\":{0},\"name_en\":\"{1}\",\"name_cn\":\"{2}\",\"name_tw\":\"{3}\",\"description\":\"{4}\"}}";
postData = string.Format(postData, dept.id, dept.name_en, dept.name_cn, dept.name_tw, dept.description);
string result = PutUrl(updateurl, postData);
JObject jo = (JObject)JsonConvert.DeserializeObject(result);
switch (Convert.ToInt32(jo["code"]))
{
case 200:
msg = "Success";
break;
case 400:
break;
case 410:
break;
case 411:
break;
default:
break;
}
}
else
{
msg = "fail";
}
return(Json(msg));
}
/// <summary>
/// 查询
/// </summary>
public List <dept> query(dept record)
{
using (qdbEntities myDb = new qdbEntities())
{
IQueryable <dept> db = myDb.dept;
if (record.ID != null)
{
db = db.Where <dept>(p => p.ID.Equals(record.ID));
}
if (!String.IsNullOrEmpty(record.NAME))
{
db = db.Where <dept>(p => p.NAME.Equals(record.NAME));
}
if (record.PID != null)
{
db = db.Where <dept>(p => p.PID.Equals(record.PID));
}
if (record.ENABLED != null)
{
db = db.Where <dept>(p => p.ENABLED.Equals(record.ENABLED));
}
if (record.CREATE_TIME != null)
{
db = db.Where <dept>(p => p.CREATE_TIME.Equals(record.CREATE_TIME));
}
return(db.ToList());
}
}
/// <summary>
/// 分页查询
/// </summary>
public List <dept> queryPage(dept record)
{
int _total = 0;
Expression <Func <dept, bool> > whereLambda = PredicateExtensions.True <dept>();
if (record.ID != null)
{
whereLambda.And(p => p.ID.Equals(record.ID));
}
if (!String.IsNullOrEmpty(record.NAME))
{
whereLambda.And(p => p.NAME.Equals(record.NAME));
}
if (record.PID != null)
{
whereLambda.And(p => p.PID.Equals(record.PID));
}
if (record.ENABLED != null)
{
whereLambda.And(p => p.ENABLED.Equals(record.ENABLED));
}
if (record.CREATE_TIME != null)
{
whereLambda.And(p => p.CREATE_TIME.Equals(record.CREATE_TIME));
}
return(LoadPageItems(5, 2, out _total, whereLambda, p => p.ID, true));
// return LoadPageItems(5, 2, out _total, whereLambda, p => p.id, true);
}
public void CreateTest()
{
PartialViewResult rv = (PartialViewResult)_controller.Create();
Assert.IsInstanceOfType(rv.Model, typeof(deptVM));
deptVM vm = rv.Model as deptVM;
dept v = new dept();
v.Index = 13;
vm.Entity = v;
_controller.Create(vm);
using (var context = new DataContext(_seed, DBTypeEnum.Memory))
{
var data = context.Set <dept>().FirstOrDefault();
Assert.AreEqual(data.Index, 13);
Assert.AreEqual(data.CreateBy, "user");
Assert.IsTrue(DateTime.Now.Subtract(data.CreateTime.Value).Seconds < 10);
}
}
public void EditTest()
{
dept v = new dept();
using (var context = new DataContext(_seed, DBTypeEnum.Memory))
{
v.Index = 13;
context.Set <dept>().Add(v);
context.SaveChanges();
}
PartialViewResult rv = (PartialViewResult)_controller.Edit(v.ID.ToString());
Assert.IsInstanceOfType(rv.Model, typeof(deptVM));
deptVM vm = rv.Model as deptVM;
v = new dept();
v.ID = vm.Entity.ID;
v.Index = 56;
vm.Entity = v;
vm.FC = new Dictionary <string, object>();
vm.FC.Add("Entity.Index", "");
_controller.Edit(vm);
using (var context = new DataContext(_seed, DBTypeEnum.Memory))
{
var data = context.Set <dept>().FirstOrDefault();
Assert.AreEqual(data.Index, 56);
Assert.AreEqual(data.UpdateBy, "user");
Assert.IsTrue(DateTime.Now.Subtract(data.UpdateTime.Value).Seconds < 10);
}
}
/// <summary>
/// 更新
/// </summary>
public int updateById(dept record)
{
return(new DeptDao().updateById(record));
}
private void loadDeptList()
{
deptList.Clear();
lb_dept.Items.Clear();
using (SqlConnection connection = new SqlConnection(XMLwork.GetConnectionString()))
{
connection.Open();
using (SqlCommand command = new SqlCommand())
{
command.Connection = connection;
command.CommandText = "SELECT id_dept,title,description FROM dept where true=1";
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
dept t = new dept();
t.id = int.Parse(reader[0].ToString());
t.title = reader[1].ToString();
t.description = reader[2].ToString();
deptList.Add(t);
}
reader.Close();
reader.Dispose();
}
}
for (int i = 0; i < deptList.Count; i++)
{
lb_dept.Items.Add(deptList[i].title);
}
}
