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));
}
