PDA

View Full Version : ساختن یک سرویس از نوع Json



anylove
شنبه 22 اسفند 1394, 07:11 صبح
سلام خوبید
ببخشید من میخواستم یه سرویس برای اندروید بنویسم و گفتن باید خروجی سرویس از نوع Json باشه

منم سرویس رو نشوتم و خروجی سرویس کد زیر است ممنون میشم کمکم کنید یه سرویس با خروجی json بنویسم
"[{\"Employee_Id\":63184,\"Employee_Nat_Code\":\"1111111111\",\"Employee_No\":\"001\",\"Emplo" +
"yee_Fname\":\"علی\",\"Employee_Lname\":\"آقابالی\",\"Employee_Name\":\"علی آقابالی\",\"Emplo" +
"yee_Pname\":null,\"Employee_Birth_Certificate\":\"1966-01-01\",\"Employee_Birth_Date\":" +
"\"\\/Date(-126201600000)\\/\",\"Employee_Image\":null,\"Employee_Country_Id\":null,\"Empl" +
"oyee_Birth_State\":null,\"Employee_Birth_City\":null,\"Employee_Canceled\":null,\"Empl" +
"oyee_Gender\":null,\"Employee_Marital_Id\":null,\"Employee_Address\":null,\"Employee_P" +
"ostal_Code\":null,\"Employee_Tel\":null,\"Employee_Mobile\":null,\"Employee_Email\":nul" +
"l,\"Employee_Start_History\":null,\"Employee_Religion_Id\":null,\"Country_Name\":null," +
"\"State_Birth\":null,\"City_Birth\":null,\"Marital_Name\":null,\"Religion_Name\":null},{" +
"\"Employee_Id\":63202,\"Employee_Nat_Code\":\"22222222222\",\"Employee_No\":\"002\",\"Emplo" +
"yee_Fname\":\"مجتبی\",\"Employee_Lname\":\"احمدی\",\"Employee_Name\":\"مجتبی احمدی\",\"Emplo" +
"yee_Pname\":null,\"Employee_Birth_Certificate\":\"1976-01-01\",\"Employee_Birth_Date\":" +
"\"\\/Date(189331200000)\\/\",\"Employee_Image\":null,\"Employee_Country_Id\":null,\"Emplo" +
"yee_Birth_State\":null,\"Employee_Birth_City\":null,\"Employee_Canceled\":null,\"Emplo" +
"yee_Gender\":null,\"Employee_Marital_Id\":null,\"Employee_Address\":null,\"Employee_Po" +
"stal_Code\":null,\"Employee_Tel\":null,\"Employee_Mobile\":null,\"Employee_Email\":null" +
",\"Employee_Start_History\":null,\"Employee_Religion_Id\":null,\"Country_Name\":null,\"" +
"State_Birth\":null,\"City_Birth\":null,\"Marital_Name\":null,\"Religion_Name\":null},{\"" +
"Employee_Id\":63205,\"Employee_Nat_Code\":\"333333\",\"Employee_No\":\"003\",\"Employee_Fn" +
"ame\":\"محمد رضا\",\"Employee_Lname\":\"مولایی\",\"Employee_Name\":\"محمد رضا مولایی\",\"Emp" +
"loyee_Pname\":null,\"Employee_Birth_Certificate\":\"1975-01-01\",\"Employee_Birth_Date" +
"\":\"\\/Date(157795200000)\\/\",\"Employee_Image\":null,\"Employee_Country_Id\":null,\"Emp" +
"loyee_Birth_State\":null,\"Employee_Birth_City\":null,\"Employee_Canceled\":null,\"Emp" +
"loyee_Gender\":null,\"Employee_Marital_Id\":null,\"Employee_Address\":null,\"Employee_" +
"Postal_Code\":null,\"Employee_Tel\":null,\"Employee_Mobile\":null,\"Employee_Email\":nu" +
"ll,\"Employee_Start_History\":null,\"Employee_Religion_Id\":null,\"Country_Name\":null" +
",\"State_Birth\":null,\"City_Birth\":null,\"Marital_Name\":null,\"Religion_Name\":null}," +
"{\"Employee_Id\":63227,\"Employee_Nat_Code\":\"555555555\",\"Employee_No\":\"005\",\"Employ" +
"ee_Fname\":\"تقي\",\"Employee_Lname\":\"مزيناني\",\"Employee_Name\":\"تقي مزيناني\",\"Employ" +
"ee_Pname\":null,\"Employee_Birth_Certificate\":\"1975-01-01\",\"Employee_Birth_Date\":\"" +
"\\/Date(157795200000)\\/\",\"Employee_Image\":null,\"Employee_Country_Id\":null,\"Employ" +
"ee_Birth_State\":null,\"Employee_Birth_City\":null,\"Employee_Canceled\":null,\"Employ" +
"ee_Gender\":null,\"Employee_Marital_Id\":null,\"Employee_Address\":null,\"Employee_Pos" +
"tal_Code\":null,\"Employee_Tel\":null,\"Employee_Mobile\":null,\"Employee_Email\":null," +
"\"Employee_Start_History\":null,\"Employee_Religion_Id\":null,\"Country_Name\":null,\"S" +
"tate_Birth\":null,\"City_Birth\":null,\"Marital_Name\":null,\"Religion_Name\":null},{\"E" +
"mployee_Id\":63228,\"Employee_Nat_Code\":\"666666666\",\"Employee_No\":\"006\",\"Employee_" +
"Fname\":\"حسين\",\"Employee_Lname\":\"منافي\",\"Employee_Name\":\"حسين منافي\",\"Employee_Pn" +
"ame\":null,\"Employee_Birth_Certificate\":\"1975-01-01\",\"Employee_Birth_Date\":\"\\/Dat" +
"e(157795200000)\\/\",\"Employee_Image\":null,\"Employee_Country_Id\":null,\"Employee_Bi" +
"rth_State\":null,\"Employee_Birth_City\":null,\"Employee_Canceled\":null,\"Employee_Ge" +
"nder\":null,\"Employee_Marital_Id\":null,\"Employee_Address\":null,\"Employee_Postal_C" +
"ode\":null,\"Employee_Tel\":null,\"Employee_Mobile\":null,\"Employee_Email\":null,\"Empl" +
"oyee_Start_History\":null,\"Employee_Religion_Id\":null,\"Country_Name\":null,\"State_" +
"Birth\":null,\"City_Birth\":null,\"Marital_Name\":null,\"Religion_Name\":null},{\"Employ" +
"ee_Id\":63229,\"Employee_Nat_Code\":\"777777777\",\"Employee_No\":\"007\",\"Employee_Fname" +
"\":\"جعفر\",\"Employee_Lname\":\"سبحاني\",\"Employee_Name\":\"جعفر سبحاني\",\"Employee_Pname" +
"\":null,\"Employee_Birth_Certificate\":\"1975-01-01\",\"Employee_Birth_Date\":\"\\/Date(1" +
"57795200000)\\/\",\"Employee_Image\":null,\"Employee_Country_Id\":null,\"Employee_Birth" +
"_State\":null,\"Employee_Birth_City\":null,\"Employee_Canceled\":null,\"Employee_Gende" +
"r\":null,\"Employee_Marital_Id\":null,\"Employee_Address\":null,\"Employee_Postal_Code" +
"\":null,\"Employee_Tel\":null,\"Employee_Mobile\":null,\"Employee_Email\":null,\"Employe" +
"e_Start_History\":null,\"Employee_Religion_Id\":null,\"Country_Name\":null,\"State_Bir" +
"th\":null,\"City_Birth\":null,\"Marital_Name\":null,\"Religion_Name\":null},{\"Employee_" +
"Id\":63230,\"Employee_Nat_Code\":\"888888888\",\"Employee_No\":\"008\",\"Employee_Fname\":\"" +
"علي\",\"Employee_Lname\":\"مطهري\",\"Employee_Name\":\"علي مطهري\",\"Employee_Pname\":null," +
"\"Employee_Birth_Certificate\":\"1975-01-01\",\"Employee_Birth_Date\":\"\\/Date(15779520" +
"0000)\\/\",\"Employee_Image\":null,\"Employee_Country_Id\":null,\"Employee_Birth_State\"" +
":null,\"Employee_Birth_City\":null,\"Employee_Canceled\":null,\"Employee_Gender\":null" +
",\"Employee_Marital_Id\":null,\"Employee_Address\":null,\"Employee_Postal_Code\":null," +
"\"Employee_Tel\":null,\"Employee_Mobile\":null,\"Employee_Email\":null,\"Employee_Start" +
"_History\":null,\"Employee_Religion_Id\":null,\"Country_Name\":null,\"State_Birth\":nul" +
"l,\"City_Birth\":null,\"Marital_Name\":null,\"Religion_Name\":null},{\"Employee_Id\":632" +
"31,\"Employee_Nat_Code\":\"999999999\",\"Employee_No\":\"009\",\"Employee_Fname\":\"پيمان\"," +
"\"Employee_Lname\":\"يوسفي\",\"Employee_Name\":\"پيمان يوسفي\",\"Employee_Pname\":null,\"Em" +
"ployee_Birth_Certificate\":\"1975-01-01\",\"Employee_Birth_Date\":\"\\/Date(15779520000" +
"0)\\/\",\"Employee_Image\":null,\"Employee_Country_Id\":null,\"Employee_Birth_State\":nu" +
"ll,\"Employee_Birth_City\":null,\"Employee_Canceled\":null,\"Employee_Gender\":null,\"E" +
"mployee_Marital_Id\":null,\"Employee_Address\":null,\"Employee_Postal_Code\":null,\"Em" +
"ployee_Tel\":null,\"Employee_Mobile\":null,\"Employee_Email\":null,\"Employee_Start_Hi" +
"story\":null,\"Employee_Religion_Id\":null,\"Country_Name\":null,\"State_Birth\":null,\"" +
"City_Birth\":null,\"Marital_Name\":null,\"Religion_Name\":null},{\"Employee_Id\":63232," +
"\"Employee_Nat_Code\":\"999999998\",\"Employee_No\":\"010\",\"Employee_Fname\":\"رضا\",\"Empl" +
"oyee_Lname\":\"عزيزي\",\"Employee_Name\":\"رضا عزيزي\",\"Employee_Pname\":null,\"Employee_" +
"Birth_Certificate\":\"1975-01-01\",\"Employee_Birth_Date\":\"\\/Date(157795200000)\\/\",\"" +
"Employee_Image\":null,\"Employee_Country_Id\":null,\"Employee_Birth_State\":null,\"Emp" +
"loyee_Birth_City\":null,\"Employee_Canceled\":null,\"Employee_Gender\":null,\"Employee" +
"_Marital_Id\":null,\"Employee_Address\":null,\"Employee_Postal_Code\":null,\"Employee_" +
"Tel\":null,\"Employee_Mobile\":null,\"Employee_Email\":null,\"Employee_Start_History\":" +
"null,\"Employee_Religion_Id\":null,\"Country_Name\":null,\"State_Birth\":null,\"City_Bi" +
"rth\":null,\"Marital_Name\":null,\"Religion_Name\":null},{\"Employee_Id\":63233,\"Employ" +
"ee_Nat_Code\":\"999999997\",\"Employee_No\":\"011\",\"Employee_Fname\":\"حجت\",\"Employee_Ln" +
"ame\":\"محمدی\",\"Employee_Name\":\"حجت محمدی\",\"Employee_Pname\":null,\"Employee_Birth_C" +
"ertificate\":\"1975-01-01\",\"Employee_Birth_Date\":\"\\/Date(157795200000)\\/\",\"Employe" +
"e_Image\":null,\"Employee_Country_Id\":null,\"Employee_Birth_State\":null,\"Employee_B" +
"irth_City\":null,\"Employee_Canceled\":null,\"Employee_Gender\":null,\"Employee_Marita" +
"l_Id\":null,\"Employee_Address\":null,\"Employee_Postal_Code\":null,\"Employee_Tel\":nu" +
"ll,\"Employee_Mobile\":null,\"Employee_Email\":null,\"Employee_Start_History\":null,\"E" +
"mployee_Religion_Id\":null,\"Country_Name\":null,\"State_Birth\":null,\"City_Birth\":nu" +
"ll,\"Marital_Name\":null,\"Religion_Name\":null},{\"Employee_Id\":63234,\"Employee_Nat_" +
"Code\":\"999999996\",\"Employee_No\":\"012\",\"Employee_Fname\":\"احسان\",\"Employee_Lname\":" +
"\"تقي خاني\",\"Employee_Name\":\"احسان تقي خاني\",\"Employee_Pname\":null,\"Employee_Birt" +
"h_Certificate\":\"1975-01-01\",\"Employee_Birth_Date\":\"\\/Date(157795200000)\\/\",\"Empl" +
"oyee_Image\":null,\"Employee_Country_Id\":null,\"Employee_Birth_State\":null,\"Employe" +
"e_Birth_City\":null,\"Employee_Canceled\":null,\"Employee_Gender\":null,\"Employee_Mar" +
"ital_Id\":null,\"Employee_Address\":null,\"Employee_Postal_Code\":null,\"Employee_Tel\"" +
":null,\"Employee_Mobile\":null,\"Employee_Email\":null,\"Employee_Start_History\":null" +
",\"Employee_Religion_Id\":null,\"Country_Name\":null,\"State_Birth\":null,\"City_Birth\"" +
":null,\"Marital_Name\":null,\"Religion_Name\":null},{\"Employee_Id\":63235,\"Employee_N" +
"at_Code\":\"999999995\",\"Employee_No\":\"014\",\"Employee_Fname\":\"مهران\",\"Employee_Lnam" +
"e\":\"مجتبی زاده\",\"Employee_Name\":\"مهران مجتبی زاده\",\"Employee_Pname\":null,\"Employ" +
"ee_Birth_Certificate\":\"1975-01-01\",\"Employee_Birth_Date\":\"\\/Date(157795200000)\\/" +
"\",\"Employee_Image\":null,\"Employee_Country_Id\":null,\"Employee_Birth_State\":null,\"" +
"Employee_Birth_City\":null,\"Employee_Canceled\":null,\"Employee_Gender\":null,\"Emplo" +
"yee_Marital_Id\":null,\"Employee_Address\":null,\"Employee_Postal_Code\":null,\"Employ" +
"ee_Tel\":null,\"Employee_Mobile\":null,\"Employee_Email\":null,\"Employee_Start_Histor" +
"y\":null,\"Employee_Religion_Id\":null,\"Country_Name\":null,\"State_Birth\":null,\"City" +
"_Birth\":null,\"Marital_Name\":null,\"Religion_Name\":null},{\"Employee_Id\":63236,\"Emp" +
"loyee_Nat_Code\":\"999999994\",\"Employee_No\":\"013\",\"Employee_Fname\":\"سعيد\",\"Employe" +
"e_Lname\":\"آقاخاني\",\"Employee_Name\":\"سعيد آقاخاني\",\"Employee_Pname\":null,\"Employe" +
"e_Birth_Certificate\":\"1975-01-01\",\"Employee_Birth_Date\":\"\\/Date(157795200000)\\/\"" +
",\"Employee_Image\":null,\"Employee_Country_Id\":null,\"Employee_Birth_State\":null,\"E" +
"mployee_Birth_City\":null,\"Employee_Canceled\":null,\"Employee_Gender\":null,\"Employ" +
"ee_Marital_Id\":null,\"Employee_Address\":null,\"Employee_Postal_Code\":null,\"Employe" +
"e_Tel\":null,\"Employee_Mobile\":null,\"Employee_Email\":null,\"Employee_Start_History" +
"\":null,\"Employee_Religion_Id\":null,\"Country_Name\":null,\"State_Birth\":null,\"City_" +
"Birth\":null,\"Marital_Name\":null,\"Religion_Name\":null},{\"Employee_Id\":63237,\"Empl" +
"oyee_Nat_Code\":\"999999993\",\"Employee_No\":\"016\",\"Employee_Fname\":\"علي\",\"Employee_" +
"Lname\":\"نصيريان\",\"Employee_Name\":\"علي نصيريان\",\"Employee_Pname\":null,\"Employee_B" +
"irth_Certificate\":\"1975-01-01\",\"Employee_Birth_Date\":\"\\/Date(157795200000)\\/\",\"E" +
"mployee_Image\":null,\"Employee_Country_Id\":null,\"Employee_Birth_State\":null,\"Empl" +
"oyee_Birth_City\":null,\"Employee_Canceled\":null,\"Employee_Gender\":null,\"Employee_" +
"Marital_Id\":null,\"Employee_Address\":null,\"Employee_Postal_Code\":null,\"Employee_T" +
"el\":null,\"Employee_Mobile\":null,\"Employee_Email\":null,\"Employee_Start_History\":n" +
"ull,\"Employee_Religion_Id\":null,\"Country_Name\":null,\"State_Birth\":null,\"City_Bir" +
"th\":null,\"Marital_Name\":null,\"Religion_Name\":null}]"
یک نمونه ساده
اطلاعاتم تو دیتابیسه از entity framework استفاده میکنم برای خوندن اطلاعات بانک اس کیو ال

anylove
شنبه 22 اسفند 1394, 07:14 صبح
کد های فایل Service1 :

public string GetData()
{
var emp = db.vi_Employee.ToList();
return new JavaScriptSerializer().Serialize(emp);
}


و فایل IService1 نوع خروجیش رو هم انجا مشخص کردم

[OperationContract]
[WebMethod]
[ScriptMethod(ResponseFormat = ResponseFormat.Json)]
string GetData();