public void GetJQGridDataTableTest() { //arrange IDataBaseServer DB = new Server.Fakes.StubIDataBaseServer() { ExecuteDatatableStringStringDictionaryOfStringObjectOutIDataParameterArrayCommandTypeIDbTransaction = (string connectionString, string commandText, out Dictionary <string, object> outParameters, IDataParameter[] commandParameters, CommandType commandType, IDbTransaction transaction) => { DataTable Table = new DataTable(); Table.Columns.AddRange(new DataColumn[] { new DataColumn("ID", typeof(int)), new DataColumn("Name", typeof(string)), new DataColumn("Total", typeof(float)), new DataColumn("Date", typeof(DateTime)), new DataColumn("IsEnable", typeof(bool)) }); DataRow Row1 = Table.NewRow(); Row1[0] = 1; Row1[1] = "用户1"; Row1[2] = 12.34; Row1[3] = DateTime.Today; Row1[4] = false; Table.Rows.Add(Row1); DataRow Row2 = Table.NewRow(); Row2[0] = 2; Row2[1] = "用户2"; Row2[2] = 3.4; Row2[3] = DateTime.Today.AddDays(2); Row2[4] = true; Table.Rows.Add(Row2); outParameters = new Dictionary <string, object>(); outParameters.Add("@Count", 2); return(Table); } }; JQGridEntity Entity = new JQGridEntity(); JQGridServer Server = new JQGridServer(DB, ""); //act DataTable Result = Server.GetJQGridDataTable(Entity); int RowCount = Convert.ToInt32(Result.ExtendedProperties["ROWCOUNT"]); //assert Assert.AreEqual(2, Result.Rows.Count); Assert.AreEqual(1, int.Parse(Result.Rows[0][0].ToString())); Assert.AreEqual("用户1", Result.Rows[0][1].ToString()); Assert.AreEqual(12.34f, float.Parse(Result.Rows[0][2].ToString())); Assert.AreEqual(DateTime.Today, DateTime.Parse(Result.Rows[0][3].ToString())); Assert.AreEqual(false, bool.Parse(Result.Rows[0][4].ToString())); Assert.AreEqual(2, int.Parse(Result.Rows[1][0].ToString())); Assert.AreEqual("用户2", Result.Rows[1][1].ToString()); Assert.AreEqual(3.4f, float.Parse(Result.Rows[1][2].ToString())); Assert.AreEqual(DateTime.Today.AddDays(2), DateTime.Parse(Result.Rows[1][3].ToString())); Assert.AreEqual(true, bool.Parse(Result.Rows[1][4].ToString())); }
public void GetJQGridJsonTest() { //arrange IDataBaseServer DB = new Server.Fakes.StubIDataBaseServer() { ExecuteDatatableStringStringDictionaryOfStringObjectOutIDataParameterArrayCommandTypeIDbTransaction = (string connectionString, string commandText, out Dictionary <string, object> outParameters, IDataParameter[] commandParameters, CommandType commandType, IDbTransaction transaction) => { DataTable Table = new DataTable(); Table.Columns.AddRange(new DataColumn[] { new DataColumn("ID", typeof(int)), new DataColumn("Name", typeof(string)), new DataColumn("Total", typeof(float)), new DataColumn("IsEnable", typeof(bool)) }); DataRow Row1 = Table.NewRow(); Row1[0] = 1; Row1[1] = "用户1"; Row1[2] = 12.34; Row1[3] = false; Table.Rows.Add(Row1); DataRow Row2 = Table.NewRow(); Row2[0] = 2; Row2[1] = "用户2"; Row2[2] = 3.4; Row2[3] = true; Table.Rows.Add(Row2); outParameters = new Dictionary <string, object>(); outParameters.Add("@Count", 2); return(Table); } }; JQGridEntity Entity = new JQGridEntity(); Entity.Page = 1; Entity.Rows = 10; JQGridServer Server = new JQGridServer(DB, ""); //act string Result = Server.GetJQGridJson(Entity); //assert string TargeString = "{\"total\":1,\"page\":1,\"records\":2,\"rows\":[{\"ID\":1,\"Name\":\"用户1\",\"Total\":12.34,\"IsEnable\":false},{\"ID\":2,\"Name\":\"用户2\",\"Total\":3.4,\"IsEnable\":true}]}"; Assert.AreEqual(TargeString, Result); }
public void GetJQGridDataTableTestNull() { //arrange IDataBaseServer DB = new Server.Fakes.StubIDataBaseServer() { ExecuteDatatableStringStringDictionaryOfStringObjectOutIDataParameterArrayCommandTypeIDbTransaction = (string connectionString, string commandText, out Dictionary <string, object> outParameters, IDataParameter[] commandParameters, CommandType commandType, IDbTransaction transaction) => { DataTable Table = new DataTable(); outParameters = new Dictionary <string, object>(); outParameters.Add("@Count", 0); return(Table); } }; JQGridEntity Entity = new JQGridEntity(); JQGridServer Server = new JQGridServer(DB, ""); //act DataTable Result = Server.GetJQGridDataTable(Entity); int RowCount = Convert.ToInt32(Result.ExtendedProperties["ROWCOUNT"]); //assert Assert.AreEqual(0, Result.Rows.Count); }
internal JQGServer() { this._jQGridServer = new JQGridServer(new DBServer().DataBaseServer); }