void load_geotag()
{
string strSQL = "select * from(select dbo.f_convertDateToChar(dbo.f_getAplDate())ApplicationDate,dbo.f_getAppParameterValue('callcutoff') CallCutOff,dbo.f_getAppParameterValue('tglfin') TglFin, dbo.f_getAppParameterValue('lat') lat, dbo.f_getAppParameterValue('lng') lng)a";
_DBcon c = new _DBcon();
foreach (System.Data.DataRow row in c.executeTextQ(strSQL))
{
lat = row["lat"].ToString();
lng = row["lng"].ToString();
}
}
void load_firstmenuid()
{
string strSQL = "select menuurl,initial,menuname from appmenu where menuid=dbo.f_getAppParameterValue('firstmenuid')";
_DBcon c = new _DBcon();
foreach (System.Data.DataRow row in c.executeTextQ(strSQL))
{
menu_url = row["menuurl"].ToString();
menu_name = row["menuname"].ToString();
initial = row["initial"].ToString();
}
}