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