public void process(ServiceRequest request, ServiceResponse response) { List<Category> list = new List<Category>(); string sqlStr = "select * from category"; MySqlConnection conn = ConnectionManager.getInstance().getConnection(); conn.Open(); MySqlDataAdapter mda = new MySqlDataAdapter(sqlStr, conn); DataSet ds = new DataSet(); mda.Fill(ds,"table1"); conn.Close(); int count = ds.Tables["table1"].Rows.Count; for (int i = 0; i < count; i++) { Category c = new Category(); c.categoryId = (int)ds.Tables["table1"].Rows[i][0]; c.categoryName = (string)ds.Tables["table1"].Rows[i][1]; list.Add(c); } GetCategoryResponse serviceResponse = new GetCategoryResponse(); serviceResponse.categories = list; response.responseObj = serviceResponse; response.returnCode = 0; }
public void DiaryUnitTest() { IService service = ServiceFactory.getInstance().getService(service_type.PUBLISH_TRAVEL_DIARY); PublishTravelDiaryRequest serviceRequest = new PublishTravelDiaryRequest(); TravelDiary td = new TravelDiary(); td.userId = 9; td.tags = "3452,532,df3"; td.content = "fajlsfjlkjl3kj4lk3j4l34lj343"; td.title = "zhangzhenrep9834"; Category c = new Category(); c.categoryId = 2; c.categoryName = "oversea"; td.belongCategory = c; td.addrs = new List<string>(); td.addrs.Add("fjladsfjkdsf"); td.addrs.Add("fjladsfjkdsfd"); td.addrs.Add("fjladsfjkdsfh"); serviceRequest.diary = td; ServiceRequest request = new ServiceRequest(serviceRequest); ServiceResponse response = new ServiceResponse(); service.process(request, response); Assert.AreEqual(0, response.returnCode); }