public ActionResult GetEditItemById(int id, int idTable) { var db = new TableDal(); var result = db.GetEmpById(1, idTable, id); return(Content(JsonConvert.SerializeObject(new { result }))); }
//public ActionResult _EditEmp(int id,string name, string DOB, string Gender, string Email, string Mobile, string Address) //{ // var db = new TableDal(); // Employee emp = new Employee(); // emp.name = name; // emp.DOB = DateTime.Parse(DOB); // emp.Gender = Gender; // emp.Address = Address; // emp.Email = Email; // emp.Mobile = Mobile; // var result = db.UpdateEmpById(1,1,id, emp); // return Content(JsonConvert.SerializeObject(new // { // result // })); //} //public ActionResult _AddEmp(string name, string DOB,string Gender,string Email,string Mobile,string Address) //{ // var db = new TableDal(); // Employee emp = new Employee(); // emp.name = name; // emp.DOB = DateTime.Parse(DOB); // emp.Gender = Gender; // emp.Address = Address; // emp.Email = Email; // emp.Mobile = Mobile; // emp.JoiningDate = DateTime.Now.ToString("yyyy/MM/dd"); // emp.DepartmentID = 1; // emp.DesignationID = 1; // var result = db.AddEmp(1, 1, emp); // return Content(JsonConvert.SerializeObject(new // { // result // })); //} public ActionResult DeleteEmp(int id, int idTable) { var db = new TableDal(); var result = db.DeleteEmp(1, idTable, id); return(Content(JsonConvert.SerializeObject(new { result }))); }
public void GetTables() { //Arrange var mockHelper = MockRepository.GenerateMock <IDalHelper>(); mockHelper.Stub(x => x.RetrieveList( Arg <DalHelperModel <TableModel> > .Is.Anything )).Return(new List <TableModel> { new TableModel() }); var mapperStub = MockRepository.GenerateStub <ITableMapper>(); var tableDal = new TableDal(mapperStub, mockHelper); //Act var dalResponse = tableDal.GetTables(_connectionString); //Assert Assert.IsFalse(dalResponse.HasError); Assert.IsNotNull(dalResponse.Result); }
/// <summary> /// 获取数据库表的信息 /// </summary> /// <param name="connectionString"></param> /// <param name="tableName"></param> /// <returns></returns> public static DataTable GetDBTableInfo(string connectionString, string tableName) { return(TableDal.GetDBTableInfo(connectionString, tableName)); }
/// <summary> /// 获取数据库表的名称集合 /// </summary> /// <param name="connectionString"></param> /// <returns></returns> public static List <string> GetDBTableNameList(string connectionString) { return(TableDal.GetDBTableNameList(connectionString)); }