public static string GetDisps(int C) { int CNTDisp = (int)Mydb.ExecuteScalar("select COUNT(*) from DISP where CLIENT_ID=@C", new SqlParameter[] { new SqlParameter("@C", C) }, CommandType.Text); if (CNTDisp != 0) { DataTable dt = Mydb.ExecuteReadertoDataTable("select d.DISP_ID,d.DISP_STATUS,d.DISP_NAME,dc.DISP_ICON_IMG from DISP d,DISP_ICON dc where d.DISP_ICON_ID=dc.DISP_ICON_ID and d.CLIENT_ID=@C order by d.DISP_ID desc", new SqlParameter[] { new SqlParameter("@C", C) }, CommandType.Text); List <Dispatcheer> disps = new List <Dispatcheer>(); foreach (DataRow item in dt.Rows) { Dispatcheer d = new Dispatcheer(); d.DISP_ICON_IMG = item["DISP_ICON_IMG"].ToString(); d.DISP_ID = Convert.ToInt32(item["DISP_ID"]); d.DISP_NAME = item["DISP_NAME"].ToString(); d.DISP_STATUS = Convert.ToBoolean(item["DISP_STATUS"]); disps.Add(d); } JavaScriptSerializer js = new JavaScriptSerializer(); return(js.Serialize(disps)); } else { return("{\"result\" : \"2\"}"); } }
public static string getDispDatas(int DD) { DataTable dt = Mydb.ExecuteReadertoDataTable("select d.*,dc.DISP_ICON_IMG from DISP d,DISP_ICON dc where d.DISP_ICON_ID=dc.DISP_ICON_ID and d.DISP_ID=@dd", new SqlParameter[] { new SqlParameter("@dd", DD) }, CommandType.Text); List <Dispatcheer> dsps = new List <Dispatcheer>(); foreach (DataRow item in dt.Rows) { Dispatcheer d = new Dispatcheer(); d.DISP_ICON_IMG = item["DISP_ICON_IMG"].ToString(); d.DISP_ID = Convert.ToInt32(item["DISP_ID"]); d.DISP_STATUS = Convert.ToBoolean(item["DISP_STATUS"]); d.DISP_PHONE_NUMBER = item["DISP_PHONE_NUMBER"].ToString(); d.DISP_NAME = item["DISP_NAME"].ToString(); dsps.Add(d); } JavaScriptSerializer js = new JavaScriptSerializer(); return(js.Serialize(dsps)); }