Line 1: #pragma checksum "E:\rootBoard\listcss.aspx" "{ff1816ec-aa5e-4d10-87f7-6f4963833460}" "6B5001C451A3678C160820631044CA9DE06760AF"
Line 2: //------------------------------------------------------------------------------
Line 3: // <auto-generated>
Line 4: // This code was generated by a tool.
Line 5: // Runtime Version:4.0.30319.42000
Line 6: //
Line 7: // Changes to this file may cause incorrect behavior and will be lost if
Line 8: // the code is regenerated.
Line 9: // </auto-generated>
Line 10: //------------------------------------------------------------------------------
Line 11:
Line 12: namespace ASP {
Line 13:
Line 14: #line 2431 "E:\rootBoard\listcss.aspx"
Line 15: using System.Web.UI.WebControls.Expressions;
Line 16:
Line 17: #line default
Line 18: #line hidden
Line 19:
Line 20: #line 384 "C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config\web.config"
Line 21: using System.Collections;
Line 22:
Line 23: #line default
Line 24: #line hidden
Line 25:
Line 26: #line 390 "C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config\web.config"
Line 27: using System.Text;
Line 28:
Line 29: #line default
Line 30: #line hidden
Line 31:
Line 32: #line 2431 "E:\rootBoard\listcss.aspx"
Line 33: using System.Web.UI;
Line 34:
Line 35: #line default
Line 36: #line hidden
Line 37:
Line 38: #line 5 "E:\rootBoard\listcss.aspx"
Line 39: using System.Collections.Generic;
Line 40:
Line 41: #line default
Line 42: #line hidden
Line 43:
Line 44: #line 2 "E:\rootBoard\listcss.aspx"
Line 45: using System.Data;
Line 46:
Line 47: #line default
Line 48: #line hidden
Line 49:
Line 50: #line 402 "C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config\web.config"
Line 51: using System.Xml.Linq;
Line 52:
Line 53: #line default
Line 54: #line hidden
Line 55:
Line 56: #line 395 "C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config\web.config"
Line 57: using System.Web.SessionState;
Line 58:
Line 59: #line default
Line 60: #line hidden
Line 61:
Line 62: #line 386 "C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config\web.config"
Line 63: using System.Collections.Specialized;
Line 64:
Line 65: #line default
Line 66: #line hidden
Line 67:
Line 68: #line 389 "C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config\web.config"
Line 69: using System.Linq;
Line 70:
Line 71: #line default
Line 72: #line hidden
Line 73:
Line 74: #line 3 "E:\rootBoard\listcss.aspx"
Line 75: using System.Data.Odbc;
Line 76:
Line 77: #line default
Line 78: #line hidden
Line 79:
Line 80: #line 2431 "E:\rootBoard\listcss.aspx"
Line 81: using System.Web.DynamicData;
Line 82:
Line 83: #line default
Line 84: #line hidden
Line 85:
Line 86: #line 393 "C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config\web.config"
Line 87: using System.Web.Caching;
Line 88:
Line 89: #line default
Line 90: #line hidden
Line 91:
Line 92: #line 397 "C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config\web.config"
Line 93: using System.Web.Profile;
Line 94:
Line 95: #line default
Line 96: #line hidden
Line 97:
Line 98: #line 387 "C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config\web.config"
Line 99: using System.ComponentModel.DataAnnotations;
Line 100:
Line 101: #line default
Line 102: #line hidden
Line 103:
Line 104: #line 2431 "E:\rootBoard\listcss.aspx"
Line 105: using System.Web.UI.WebControls;
Line 106:
Line 107: #line default
Line 108: #line hidden
Line 109:
Line 110: #line 4 "E:\rootBoard\listcss.aspx"
Line 111: using System.Web;
Line 112:
Line 113: #line default
Line 114: #line hidden
Line 115:
Line 116: #line 396 "C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config\web.config"
Line 117: using System.Web.Security;
Line 118:
Line 119: #line default
Line 120: #line hidden
Line 121:
Line 122: #line 383 "C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config\web.config"
Line 123: using System;
Line 124:
Line 125: #line default
Line 126: #line hidden
Line 127:
Line 128: #line 7 "E:\rootBoard\listcss.aspx"
Line 129: using System.Data.SqlClient;
Line 130:
Line 131: #line default
Line 132: #line hidden
Line 133:
Line 134: #line 391 "C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config\web.config"
Line 135: using System.Text.RegularExpressions;
Line 136:
Line 137: #line default
Line 138: #line hidden
Line 139:
Line 140: #line 6 "E:\rootBoard\listcss.aspx"
Line 141: using System.Configuration;
Line 142:
Line 143: #line default
Line 144: #line hidden
Line 145:
Line 146: #line 2431 "E:\rootBoard\listcss.aspx"
Line 147: using System.Web.UI.WebControls.WebParts;
Line 148:
Line 149: #line default
Line 150: #line hidden
Line 151:
Line 152: #line 401 "C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config\web.config"
Line 153: using System.Web.UI.HtmlControls;
Line 154:
Line 155: #line default
Line 156: #line hidden
Line 157:
Line 158:
Line 159: [System.Runtime.CompilerServices.CompilerGlobalScopeAttribute()]
Line 160: public class listcss_aspx : global::System.Web.UI.Page, System.Web.SessionState.IRequiresSessionState, System.Web.IHttpHandler {
Line 161:
Line 162:
Line 163: #line 2431 "E:\rootBoard\listcss.aspx"
Line 164: protected global::System.Web.UI.WebControls.Panel main_plh;
Line 165:
Line 166: #line default
Line 167: #line hidden
Line 168:
Line 169:
Line 170: #line 2420 "E:\rootBoard\listcss.aspx"
Line 171: protected global::System.Web.UI.HtmlControls.HtmlForm form1;
Line 172:
Line 173: #line default
Line 174: #line hidden
Line 175:
Line 176:
Line 177: #line 2415 "E:\rootBoard\listcss.aspx"
Line 178: protected global::System.Web.UI.HtmlControls.HtmlGenericControl BODY;
Line 179:
Line 180: #line default
Line 181: #line hidden
Line 182:
Line 183: private static bool @__initialized;
Line 184:
Line 185: private static object @__stringResource;
Line 186:
Line 187: private static object @__fileDependencies;
Line 188:
Line 189:
Line 190: #line 12 "E:\rootBoard\listcss.aspx"
Line 191:
Line 192:
Line 193:
Line 194:
Line 195:
Line 196:
Line 197:
Line 198: /// <summary>
Line 199: /// //////
Line 200: ///
Line 201: /// https://mashdsp.tau.ac.il/asplinks/listcss.asp?co=2,-3,5,73,6,7,8,9,11,12,36&cok=,https://www30.tau.ac.il/yedion/syllabus.asp?course=(cid=0-1-2-3-4-5-6-7-8-9)%26year=2018,,,,,,,,,&teax=16,18&b=29&mtit=%E1%E9%FA%20%E4%F1%F4%F8%20%EC%F7%E5%EC%F0%E5%F2%20%E5%EC%E8%EC%E5%E5%E9%E6%E9%E4&isHdr=1&cidd=4-8&lang=1&Facu=8&db_num=2018&css=arts14.css
Line 202: ///
Line 203: /// </summary>
Line 204:
Line 205: const string ADAY = "יום א";
Line 206: const string BDAY = "יום ב";
Line 207: const string CDAY = "יום ג";
Line 208: const string DDAY = "יום ד";
Line 209: const string EDAY = "יום ה ";
Line 210: const string FDAY = "יום ו";
Line 211: const string SADAY = "יום ש";
Line 212: const string HOUR_STR = "שעה";
Line 213:
Line 214: const string A_DAY = "Sun";
Line 215: const string B_DAY = "Mon";
Line 216: const string C_DAY = "Tue";
Line 217: const string D_DAY = "Wed";
Line 218: const string E_DAY = "Thu";
Line 219: const string F_DAY = "Fri";
Line 220: const string SA_DAY = "Sat";
Line 221: const string HOUR_STR_E = "Hour";
Line 222:
Line 223: const int NAME_HARMEL_COLUMN_INDEX = 1;
Line 224: const int HOMIN1_HARMEL_COLUMN_INDEX = 2;
Line 225: const int HOMIN2_HARMEL_COLUMN_INDEX = 3;
Line 226: const int FACULTY_HARMEL_COLUMN_INDEX = 4;
Line 227:
Line 228: const int FACULTY_COLUMN_INDEX = 1;
Line 229: const int SEM_COLUMN_INDEX = 2;
Line 230: const int CID_COLUMN_INDEX = 3;
Line 231: const int PHASE_COLUMN_INDEX = 4;
Line 232: const int NAME_COLUMN_INDEX = 5;
Line 233: const int METHOD_COLUMN_INDEX = 6;
Line 234: const int WKD_COLUMN_INDEX = 7;
Line 235: const int HOMIN1_COLUMN_INDEX = 8;
Line 236: const int HOMIN2_COLUMN_INDEX = 9;
Line 237: const int ROOM_COLUMN_INDEX = 10;
Line 238: const int NROOM_COLUMN_INDEX = 11;
Line 239: const int NHOUSE_COLUMN_INDEX = 12;
Line 240: const int ROOM_NUM_COLUMN_INDEX = 13;
Line 241: const int DURA_COLUMN_INDEX = 14;
Line 242: const int REMARK_COLUMN_INDEX = 15;
Line 243: const int T1_COLUMN_INDEX = 16;
Line 244: const int T1ID_COLUMN_INDEX = 17;
Line 245: const int T2_COLUMN_INDEX = 18;
Line 246: const int T2ID_COLUMN_INDEX = 19;
Line 247: const int T3_COLUMN_INDEX = 20;
Line 248: const int T3ID_COLUMN_INDEX = 21;
Line 249: const int T4_COLUMN_INDEX = 22;
Line 250: const int T4ID_COLUMN_INDEX = 23;
Line 251: const int T5_COLUMN_INDEX = 24;
Line 252: const int T5ID_COLUMN_INDEX = 25;
Line 253: const int DOCO_COLUMN_INDEX = 26;
Line 254: const int EXPECTED_COLUMN_INDEX = 27;
Line 255: const int ENLISTED_COLUMN_INDEX = 28;
Line 256: const int NUT_COLUMN_INDEX = 29;
Line 257: const int HOUSE_COLUMN_INDEX = 30;
Line 258: const int LAMP_COLUMN_INDEX = 31;
Line 259: const int PRF_COLUMN_INDEX = 32;
Line 260: const int INORLIS_COLUMN_INDEX = 33;
Line 261: const int MMF_COLUMN_INDEX = 34;
Line 262: const int SHAS_COLUMN_INDEX = 35;
Line 263: const int SHASTYPE_COLUMN_INDEX = 36;
Line 264: const int HSF_COLUMN_INDEX = 37;
Line 265: const int PARASIT_COLUMN_INDEX = 38;
Line 266: const int LEADER_COLUMN_INDEX = 39;
Line 267: const int EXCLA_COLUMN_INDEX = 40;
Line 268: const int BUNCH1_COLUMN_INDEX = 41;
Line 269: const int BUNCH2_COLUMN_INDEX = 42;
Line 270: const int BUNCH3_COLUMN_INDEX = 43;
Line 271: const int BUNCH4_COLUMN_INDEX = 44;
Line 272: const int BUNCH5_COLUMN_INDEX = 45;
Line 273: const int BUNCH6_COLUMN_INDEX = 46;
Line 274: const int BUNCH7_COLUMN_INDEX = 47;
Line 275: const int BUNCH8_COLUMN_INDEX = 48;
Line 276: const int BUNCH9_COLUMN_INDEX = 49;
Line 277: const int BUNCH10_COLUMN_INDEX = 50;
Line 278: const int BUNCH11_COLUMN_INDEX = 51;
Line 279: const int BUNCH12_COLUMN_INDEX = 52;
Line 280: const int BUNCH13_COLUMN_INDEX = 53;
Line 281: const int BUNCH14_COLUMN_INDEX = 54;
Line 282: const int BUNCH15_COLUMN_INDEX = 55;
Line 283: const int BUNCH16_COLUMN_INDEX = 56;
Line 284: const int BUNCH17_COLUMN_INDEX = 57;
Line 285: const int BUNCH18_COLUMN_INDEX = 58;
Line 286: const int BUNCH19_COLUMN_INDEX = 59;
Line 287: const int BUNCH20_COLUMN_INDEX = 60;
Line 288: const int DATON1_COLUMN_INDEX = 61;
Line 289: const int DATON2_COLUMN_INDEX = 62;
Line 290: const int LOCHED_COLUMN_INDEX = 63;
Line 291: const int GILA_FLAG_COLUMN_INDEX = 64;
Line 292: const int WEEKS_LONG1_COLUMN_INDEX = 65;
Line 293: const int WEEKS_LONG2_COLUMN_INDEX = 66;
Line 294: //const int ZAMAK_TYPE_COLUMN_INDEX=67
Line 295:
Line 296:
Line 297: const int EXTERNAL_COLUMN_INDEX = 70;
Line 298: const int INTERNAL_COLUMN_INDEX = 71;
Line 299: const int TYPE_TABLE_COLUMN_INDEX = 72;
Line 300: const int ALL_TEACHERS_COLUMN_INDEX = 73;
Line 301: const int CONNECT_ROOM_HOUSE_INDEX = 74;
Line 302: const int CONNECT_HOURS_INDEX = 75;
Line 303: const int EMPTY_FIELD_INDEX = 76;
Line 304: const int ENTER_FIELD_INDEX = 77;
Line 305: const int CONNECT_DATONS_INDEX = 78;
Line 306:
Line 307: // 201212 - english
Line 308: const int SEMESTER_ENGLISH_COLUMN_INDEX = 80;
Line 309: const int NHOUSE_ENGLISH_COLUMN_INDEX = 81;
Line 310: const int METHOD_ENGLISH_COLUMN_INDEX = 82;
Line 311: const int WKD_ENGLISH_COLUMN_INDEX = 83;
Line 312: //201501
Line 313: const int EXAM_LINK_COLUMN_INDEX = 100;
Line 314: const int SYLLABUS_LINK_COLUMN_INDEX = 101;
Line 315:
Line 316:
Line 317: const string SEL_FULL_TTS_SHEET = "select * from full_tts_sheet_dsp where faculty_index=%faculty %semweek";
Line 318:
Line 319: const string SEL_FTTS_DSP = "select * from full_tts_sheet_dsp where faculty_index=%faculty %semweek";
Line 320:
Line 321: const string SEL_FULL_TTS_SHEET_TT_BY_CID = "select distinct faculty,sem,cid,phase,name,method,wkd,homin1,homin2,room,nroom,nhouse,room_num,t1,t2,t3,t4,t5,t1idnum,t2idnum,t3idnum,t4idnum,t5idnum,sem_index,faculty_index from full_tts_sheet_dsp where faculty_index=%faculty %semweek";
Line 322:
Line 323: const string SUB_BUNCH_LIST = " And %sub_bunch";
Line 324:
Line 325: const string SUB_BUNCH = " (b1=%b or b2=%b or b3=%b or b4=%b or b5=%b or b6=%b or b7=%b or b8=%b or b9=%b or b10=%b or b11=%b or b12=%b or b13=%b or b14=%b or b15=%b or b16=%b or b17=%b or b18=%b or b19=%b or b20=%b )";
Line 326: //'''const string SUB_BUNCH=" (b1=%b)"
Line 327: const string SUB_BUNCH_TB = "AND (%sub_bunch)";
Line 328: const string SEL_ALL_BUNCH = "select num from bunchs where faculty=%faculty";
Line 329: const string SUB_ORDER = " order by unmap";
Line 330: const string SUB_ORDER_TIMETABLE = " order by wkd,homin1,homin2";
Line 331: const string SUB_ORDER_AIRPORT = " order by homin1,homin2";
Line 332: const string SUB_TIME_TB = " and (wkd=%wkd and (%sMinutes<(datepart(hh,homin2)*60+ datepart(mi,homin2))) and (%eMinutes>(datepart(hh,homin1)*60+ datepart(mi,homin1)))) ";
Line 333: const string SEL_HARMEL = "select (datepart(hh,homin1)*60+ datepart(mi,homin1)) as s_hour, (datepart(hh,homin2)*60+ datepart(mi,homin2)) as e_hour from harmel where faculty=%faculty and rtrim(ltrim(name))!=''";
Line 334:
Line 335: const string BGU_CID_STR = " and cid like %bgu_cid ";
Line 336:
Line 337: const string TT_CID_STR = " and cid in %tt_cid ";
Line 338: const string TT_NOCID_STR = " and cid not in %tt_nocid ";
Line 339:
Line 340:
Line 341:
Line 342: const int HEBREW_LANG = 1;
Line 343: const int ENGLISH_LANG = 2;
Line 344:
Line 345: const int TTSARR = 19;
Line 346: const int SEMWORK = 1;
Line 347: const int WEEKWORK = 2;
Line 348: const int NONWORK = 0;
Line 349: const int BUNCHWORK = -1;
Line 350: const int USERWORK = 1;
Line 351:
Line 352:
Line 353: const string SHOW_HDR_LINE_DATA = "isHdr";
Line 354: const string LANGUAGE_DATA= "lang";
Line 355: const string MAIN_TITLE_DATA = "mtit";
Line 356: const string SHORT_TIME_DATA = "sTime";
Line 357: const string NTT = "ntt";
Line 358: const string RTT = "rtt";
Line 359: const string FILTERS_DATA = "flt_d";
Line 360: const string ADDITION_LINK_DATA = "addk";
Line 361: const string INDEX_METHOD_DATA = "ime";
Line 362: const string CID_DISPLAY_DATA = "cidd";
Line 363: const string COLUMN_SPACE_DATA = "cos";
Line 364: const string COLUMN_DATA = "co";
Line 365: const string COLUMN_LINK_DATA = "cok";
Line 366: const string COLUMN_WIDTH = "cow";
Line 367:
Line 368: const string TITLES_DATA = "titles";
Line 369:
Line 370: const string SEM_DATA = "sm";
Line 371: const string WEEK2_DATA = "w2";
Line 372: const string WEEK1_DATA = "w1";
Line 373:
Line 374: const string SUPFROM_DATA = "sf";
Line 375: const string SUPTO_DATA = "st";
Line 376: const string BUNCH_DATA = "b";
Line 377: const string FACULTY = "Facu";
Line 378:
Line 379:
Line 380: const string YEAR = "db_num";
Line 381:
Line 382: const string TEACHERS_INDEX_DATA = "teax";
Line 383:
Line 384: string css_url = "defaultList.css"; // default
Line 385: string css_file = "";
Line 386:
Line 387: string db_num = "-1";
Line 388: string faculty = "-1";
Line 389: string wyear = "2000";
Line 390: string showHdrLine = "0";
Line 391: string language = HEBREW_LANG.ToString();
Line 392: string main_title = "";
Line 393: string short_time = "0";
Line 394: string NoTtsTitles = "0";
Line 395: string RightAlignTtsTitles="0";
Line 396: string urlStr="";
Line 397:
Line 398: string dir_t="rtl";
Line 399: string align_title="CENTER";
Line 400: string align_t="RIGHT";
Line 401:
Line 402: string fromSup = string.Empty;
Line 403: string toSup = string.Empty;
Line 404:
Line 405: string index_method_str = string.Empty;
Line 406: int index_method=-1;
Line 407: string display_cid_str;
Line 408: string[] display_cid_indexs;
Line 409: string addition_link=string.Empty;
Line 410: int space_double = 1;
Line 411: List<int> Cols_space_map = new List<int>();
Line 412:
Line 413: string str_cols_space_double = "";
Line 414: string[] cols_space_double;
Line 415:
Line 416: string columnString = "1,2,3";
Line 417: string[] columnString_arr;
Line 418:
Line 419: List<int> columnIndexs = new List<int>();
Line 420:
Line 421: string[] titlesArr;
Line 422: int countTitles = 0;
Line 423:
Line 424: string _mtit = string.Empty;
Line 425: string _titles = string.Empty;
Line 426:
Line 427:
Line 428: string strLinksCol=string.Empty;
Line 429: string[] linksArr;
Line 430:
Line 431: string[] semIndexs;// = ("1,2,3").Split(',');
Line 432: int countCol = 0;
Line 433: string[] columnWidthIndexs;
Line 434:
Line 435: DataSet main_ds = new DataSet();
Line 436: //OdbcDataAdapter oda = new OdbcDataAdapter();
Line 437: SqlDataAdapter oda = new SqlDataAdapter();
Line 438:
Line 439: string IndexTeaString = "";//=Request.QueryString(TEACHERS_INDEX_DATA);
Line 440:
Line 441:
Line 442:
Line 443: #region Web Form Designer generated code
Line 444: override protected void OnInit(EventArgs e)
Line 445: {
Line 446: //
Line 447: // CODEGEN: This call is required by the ASP.NET Web Form Designer.
Line 448: //
Line 449: InitializeComponent();
Line 450: base.OnInit(e);
Line 451: }
Line 452:
Line 453: /// <summary>
Line 454: /// Required method for Designer support - do not modify
Line 455: /// the contents of this method with the code editor.
Line 456: /// </summary>
Line 457: private void InitializeComponent()
Line 458: {
Line 459: // this line make page_load runs twice
Line 460: //this.Load += new System.EventHandler(this.Page_Load);
Line 461:
Line 462: }
Line 463: #endregion
Line 464:
Line 465:
Line 466: protected void Page_Load(object sender, EventArgs e)
Line 467: {
Line 468:
Line 469: if (!this.IsPostBack)
Line 470: {
Line 471: bool res = false;
Line 472: int _int = 0;
Line 473: string _str = "";
Line 474:
Line 475: for (int i=0; i<Request.QueryString.Count; i++ )
Line 476: {
Line 477: Response.Write("<!-- " + Request.QueryString.AllKeys[i] + " :: " + Server.HtmlDecode(Request.QueryString[i]) + "<br \\>" + " --> ");
Line 478: }
Line 479:
Line 480:
Line 481:
Line 482: //string temp1 = Request.RawUrl.ToString();
Line 483: string temp1 = Request.QueryString.ToString();
Line 484:
Line 485:
Line 486: if (temp1.IndexOf("mtit")>-1)
Line 487: {
Line 488: string temp11 = Request.QueryString["mtit"]
Line 489: if (temp11.IndexOf("א")>-1 || temp11.IndexOf("ב")>-1 || temp11.IndexOf("ג")>-1 || temp11.IndexOf("ד")>-1 || temp11.IndexOf("ה")>-1 || temp11.IndexOf("ו")>-1 || temp11.IndexOf("ז")>-1 || temp11.IndexOf("ח")>-1 || temp11.IndexOf("ט")>-1 || temp11.IndexOf("י")>-1)
Line 490: {
Line 491:
Line 492: _mtit = Request.RawUrl.ToString().Split(new [] {"mtit="},StringSplitOptions.None)[1].Split('&')[0];
Line 493: Response.Write("<!-- Request.RawUrl.split:" + _mtit + " --> \n");
Line 494:
Line 495: if (_mtit.IndexOf("א")>-1 || _mtit.IndexOf("ב")>-1 || _mtit.IndexOf("ג")>-1 || _mtit.IndexOf("ד")>-1 || _mtit.IndexOf("ה")>-1 || _mtit.IndexOf("ו")>-1 || _mtit.IndexOf("ז")>-1 || _mtit.IndexOf("ח")>-1 || _mtit.IndexOf("ט")>-1 || _mtit.IndexOf("י")>-1)
Line 496: {
Line 497:
Line 498: Response.Write("<!-- _mtit not in hebrew --> \n");
Line 499:
Line 500: /// HEBREW WORKS !!!
Line 501: //_mtit = encodeConvert( _mtit);
Line 502: _mtit = _mtit.Replace("\"", """);
Line 503:
Line 504: //_mtit = _mtit.Replace("\"", "''");
Line 505:
Line 506:
Line 507: Response.Write("<!-- Request.QueryString= encodeConvert:" + _mtit + " --> \n");
Line 508: /// HEBREW WORKS !!!
Line 509:
Line 510: //_mtit = Request.QueryString["mtit"];
Line 511: }
Line 512: //else _mtit = Request.RawUrl.ToString().Split(new [] {"mtit="},StringSplitOptions.None)[1].Split('&')[0];
Line 513: }
Line 514: else _mtit = Request.QueryString["mtit"];
Line 515: }
Line 516:
Line 517: Response.Write("<!-- FINAL:" + _mtit + " --> \n");
Line 518:
Line 519: //Response.Write("begin read url <br><hr><br>");
Line 520: if (Request.QueryString["css"] != null)
Line 521: {
Line 522: css_url = Request.QueryString["css"];
Line 523: //Response.Write(css_url);
Line 524: }
Line 525:
Line 526:
Line 527: if (Request.QueryString["db_num"] != null)
Line 528: {
Line 529: _int = 0; res = false; _str = "";
Line 530:
Line 531: db_num = Request.QueryString["db_num"];
Line 532: res = int.TryParse(db_num, out _int);
Line 533: if (!res)
Line 534: {
Line 535: Response.Write("db_num not in format. aborting...");
Line 536: Response.End();
Line 537: }
Line 538: //else Response.Write(string.Format("db_num = {0} <br/>", db_num));
Line 539: }
Line 540:
Line 541: if (Request.QueryString[FACULTY] != null)
Line 542: {
Line 543: _int = 0; res = false; _str = "";
Line 544:
Line 545: faculty = Request.QueryString[FACULTY];
Line 546: //Response.Write(
Line 547: res = int.TryParse(faculty, out _int);
Line 548: if (!res)
Line 549: {
Line 550: Response.Write("faculty not in format. aborting...");
Line 551: Response.End();
Line 552: }
Line 553: //else Response.Write(string.Format("faculty = {0} <br/>", faculty));
Line 554: }
Line 555:
Line 556: if (Request.QueryString[YEAR] != null)
Line 557: {
Line 558: _int = 0; res = false; _str = "";
Line 559:
Line 560: wyear = Request.QueryString[YEAR];
Line 561: //Response.Write(
Line 562: res = int.TryParse(wyear, out _int);
Line 563: if (!res)
Line 564: {
Line 565: Response.Write("year not in format. aborting...");
Line 566: Response.End();
Line 567: }
Line 568: //else Response.Write(string.Format("faculty = {0} <br/>", faculty));
Line 569: }
Line 570:
Line 571:
Line 572: if (Request.QueryString[SHOW_HDR_LINE_DATA] != null)
Line 573: {
Line 574: _int = 0; res = false; _str = "";
Line 575:
Line 576: showHdrLine = Request.QueryString[SHOW_HDR_LINE_DATA];
Line 577: res = int.TryParse(showHdrLine, out _int);
Line 578: if (!res)
Line 579: {
Line 580: Response.Write("isHdr not in format. aborting...");
Line 581: Response.End();
Line 582: }
Line 583: //else Response.Write(string.Format("isHdr = {0} <br/>", showHdrLine));
Line 584: }
Line 585:
Line 586: if (Request.QueryString[LANGUAGE_DATA] != null)
Line 587: {
Line 588: _int = 0; res = false; _str = "";
Line 589:
Line 590: language = Request.QueryString[LANGUAGE_DATA];
Line 591: res = int.TryParse(language, out _int);
Line 592: if (!res)
Line 593: {
Line 594: Response.Write("language not in format. aborting...");
Line 595: Response.End();
Line 596: }
Line 597: else
Line 598: {
Line 599: if (language != "1" && language != "0") language = "0";
Line 600: //Response.Write(string.Format("language = {0} <br/>", language));
Line 601: }
Line 602:
Line 603: }
Line 604:
Line 605: if (Request.QueryString[MAIN_TITLE_DATA] != null)
Line 606: {
Line 607: _int = 0; res = false; _str = "";
Line 608:
Line 609: main_title = Request.QueryString[MAIN_TITLE_DATA];
Line 610:
Line 611: string main_title1 = Server.HtmlEncode(main_title);
Line 612: //Response.Write(main_title);
Line 613: //main_title = main_title1;
Line 614: _int = main_title.IndexOf("script");
Line 615: if (_int >= 0)
Line 616: {
Line 617: Response.Write("main_title not in format. aborting...");
Line 618: Response.End();
Line 619: }
Line 620: _int = main_title.IndexOf("select");
Line 621: if (_int >= 0)
Line 622: {
Line 623: Response.Write("main_title not in format. aborting...");
Line 624: Response.End();
Line 625: }
Line 626:
Line 627: //main_title = main_title.Replace(""e;","");
Line 628: //Response.Write(string.Format("main_title = {0} <br/>", main_title));
Line 629:
Line 630: }
Line 631:
Line 632: if (Request.QueryString[TEACHERS_INDEX_DATA] != null)
Line 633: {
Line 634: IndexTeaString = Request.QueryString[TEACHERS_INDEX_DATA];
Line 635: }
Line 636:
Line 637: if (Request.QueryString[SHORT_TIME_DATA] != null)
Line 638: {
Line 639: _int = 0; res = false; _str = "";
Line 640:
Line 641: short_time = Request.QueryString[SHORT_TIME_DATA];
Line 642: res = int.TryParse(language, out _int);
Line 643: if (!res)
Line 644: {
Line 645: Response.Write("short_time not in format. aborting...");
Line 646: Response.End();
Line 647: }
Line 648: else
Line 649: {
Line 650: if (short_time != "1" && short_time != "0") short_time = "0";
Line 651: //Response.Write(string.Format("short_time = {0} <br/>", short_time));
Line 652: }
Line 653:
Line 654: }
Line 655:
Line 656:
Line 657: if (Request.QueryString[NTT] != null)
Line 658: {
Line 659: _int = 0; res = false; _str = "";
Line 660: NoTtsTitles = Request.QueryString[NTT];
Line 661: if (NoTtsTitles.Split(',').Length > 1) NoTtsTitles = NoTtsTitles.Split(',')[0];
Line 662: res = int.TryParse(NoTtsTitles, out _int);
Line 663: if (!res)
Line 664: {
Line 665: Response.Write("NoTtsTitles not in format. aborting...");
Line 666: Response.End();
Line 667: //NoTtsTitles="1";
Line 668:
Line 669: }
Line 670: else
Line 671: {
Line 672: if (NoTtsTitles != "1" && NoTtsTitles != "0" && NoTtsTitles != "2") NoTtsTitles = "0";
Line 673: //Response.Write(string.Format("NoTtsTitles = {0} <br/>", NoTtsTitles));
Line 674: }
Line 675: }
Line 676: if (Request.QueryString[RTT] != null)
Line 677: {
Line 678: _int = 0; res = false; _str = "";
Line 679: RightAlignTtsTitles = Request.QueryString[RTT];
Line 680: res = int.TryParse(RightAlignTtsTitles, out _int);
Line 681: if (!res)
Line 682: {
Line 683: Response.Write("NoTtsTitles not in format. aborting...");
Line 684: Response.End();
Line 685: }
Line 686: else
Line 687: {
Line 688: if (RightAlignTtsTitles != "1" && RightAlignTtsTitles != "0") RightAlignTtsTitles = "0";
Line 689: //Response.Write(string.Format("RightAlignTtsTitles = {0} <br/>", RightAlignTtsTitles));
Line 690: }
Line 691: }
Line 692:
Line 693:
Line 694:
Line 695:
Line 696: urlStr = Request.ServerVariables["PATH_INFO"];
Line 697: urlStr += "?" + Request.QueryString;
Line 698: int s = urlStr.LastIndexOf(FILTERS_DATA);
Line 699: if (s > 0)
Line 700: {
Line 701: int ind = urlStr.LastIndexOf("&", s + 1);
Line 702: string subS = "";
Line 703: if (ind > s)
Line 704: subS = urlStr.Substring(s, (ind - s));
Line 705: else
Line 706: subS = urlStr.Substring(s);
Line 707:
Line 708: urlStr = urlStr.Replace(subS, "");
Line 709: }
Line 710: //Response.Write(string.Format("urlStr = {0} <br/>", urlStr));
Line 711:
Line 712:
Line 713:
Line 714: index_method_str = Request.QueryString[INDEX_METHOD_DATA];
Line 715: index_method = -1;
Line 716: display_cid_str = Request.QueryString[CID_DISPLAY_DATA];
Line 717:
Line 718: if (display_cid_str != null && display_cid_str.Length > 0)
Line 719: display_cid_indexs = display_cid_str.Split('-');
Line 720:
Line 721: addition_link = Request.QueryString[ADDITION_LINK_DATA];
Line 722: if (index_method_str != null && index_method_str.Length > 0)
Line 723: {
Line 724: _int = 0; res = false; _str = "";
Line 725: res = int.TryParse(index_method_str, out _int);
Line 726: if (!res)
Line 727: index_method = Convert.ToInt32(index_method_str);
Line 728: else
Line 729: index_method = -1;
Line 730: }
Line 731:
Line 732: str_cols_space_double = Request.QueryString[COLUMN_SPACE_DATA];
Line 733:
Line 734: if (faculty == "7") str_cols_space_double = "";
Line 735:
Line 736: if (str_cols_space_double != null && str_cols_space_double.Length > 0)
Line 737: {
Line 738: cols_space_double = str_cols_space_double.Split(',');
Line 739: for (int i = 0; i < cols_space_double.Length; i++)
Line 740: if (cols_space_double[i] != "")
Line 741: Cols_space_map.Add(Convert.ToInt32(GetNeto(cols_space_double[i])));
Line 742: }
Line 743:
Line 744: columnString = Request.QueryString[COLUMN_DATA];
Line 745: if (columnString != null && columnString.Length > 0)
Line 746: {
Line 747: columnString_arr = columnString.Split(',');
Line 748: }
Line 749: else
Line 750: columnString_arr = new string[] { "1", "2", "3", "4" };
Line 751:
Line 752:
Line 753: for (int i = 0; i < columnString_arr.Length; i++)
Line 754: {
Line 755: if (columnString_arr[i] != "")
Line 756: {
Line 757: string cs = GetNeto(columnString_arr[i]);
Line 758: int new_cs = Convert.ToInt32(cs);
Line 759: columnIndexs.Add(new_cs);
Line 760: //Response.Write(string.Format("cs = {0}, {1} <br/>", columnString_arr[i].ToString(),new_cs.ToString()));
Line 761: }
Line 762: }
Line 763:
Line 764: if (faculty == "7" && db_num == "2012")
Line 765: {
Line 766: columnIndexs.Add(35);
Line 767: }
Line 768:
Line 769: strLinksCol = Request.QueryString[COLUMN_LINK_DATA];
Line 770: if (strLinksCol != null && strLinksCol.Length > 0)
Line 771: {
Line 772: if (faculty == "8" && db_num == "2009") //09/08/21 - because of arts mistake
Line 773: {
Line 774: strLinksCol.Replace("2008", "2009");
Line 775: }
Line 776:
Line 777: linksArr = strLinksCol.Split(',');
Line 778: }
Line 779:
Line 780: //Response.Write(strLinksCol);
Line 781: //Response.Write(linksArr[0]);
Line 782: // Response.End();
Line 783:
Line 784: countCol = columnIndexs.Count;
Line 785:
Line 786: string columnWidthString = Request.QueryString[COLUMN_WIDTH];
Line 787:
Line 788: if (columnWidthString != null && columnWidthString.Length > 0)
Line 789: columnWidthIndexs = columnWidthString.Split(',');
Line 790: else
Line 791: columnWidthIndexs = null;
Line 792:
Line 793:
Line 794: //string titlesString = Request.QueryString[TITLES_DATA];
Line 795:
Line 796: temp1 = Request.QueryString.ToString();//[TITLES_DATA];
Line 797:
Line 798:
Line 799: if (temp1.IndexOf("titles=")>-1)
Line 800: {
Line 801: string temp11 = Request.QueryString["mtit"]
Line 802: if (temp11.IndexOf("א")>-1 || temp11.IndexOf("ב")>-1 || temp11.IndexOf("ג")>-1 || temp11.IndexOf("ד")>-1 || temp11.IndexOf("ה")>-1 || temp11.IndexOf("ו")>-1 || temp11.IndexOf("ז")>-1 || temp11.IndexOf("ח")>-1 || temp11.IndexOf("ט")>-1 || temp11.IndexOf("י")>-1)
Line 803: {
Line 804:
Line 805: _titles = Request.RawUrl.ToString().Split(new [] {"titles="},StringSplitOptions.None)[1].Split('&')[0];
Line 806:
Line 807:
Line 808: if (_titles.IndexOf("א")>-1 || _titles.IndexOf("ב")>-1 || _titles.IndexOf("ג")>-1 || _titles.IndexOf("ד")>-1 || _titles.IndexOf("ה")>-1 || _titles.IndexOf("ו")>-1 || _titles.IndexOf("ז")>-1 || _titles.IndexOf("ח")>-1 || _titles.IndexOf("ט")>-1 || _titles.IndexOf("י")>-1)
Line 809: {
Line 810: _titles = encodeConvert( _titles);
Line 811: _titles = _titles.Replace("\"", """);
Line 812: }
Line 813: }
Line 814: else _titles = Request.QueryString[TITLES_DATA];
Line 815:
Line 816:
Line 817: }
Line 818: //else _titles = Request.QueryString[TITLES_DATA];
Line 819: Response.Write("<!-- FINAL:" + _titles + " --> \n");
Line 820:
Line 821:
Line 822: string titlesString = _titles;
Line 823: if (titlesString != null && titlesString.Length > 0)
Line 824: {
Line 825: if (titlesString.IndexOf("script")>-1 || titlesString.IndexOf("select")>-1)
Line 826: {
Line 827: Response.Write("Dangerous chars appears. aborting...");
Line 828: Response.End();
Line 829:
Line 830: }
Line 831:
Line 832: titlesArr = titlesString.Split(',');
Line 833: countTitles = titlesArr.Length;
Line 834: }
Line 835:
Line 836: string semString = Request.QueryString[SEM_DATA];
Line 837: int countSem = 1;
Line 838: int countBunch = 1;
Line 839:
Line 840: int user_buch_work = NONWORK;
Line 841: int sem_week_work = NONWORK;
Line 842: string bunchString = string.Empty;
Line 843: string[] bunchIndexs = ("0").Split(',');;
Line 844: string semValue;
Line 845: string fromDate = Request.QueryString[WEEK1_DATA];
Line 846: string toDate = Request.QueryString[WEEK2_DATA];
Line 847: if (semString != null && semString.Length > 0)
Line 848: {
Line 849: semIndexs = semString.Split(',');
Line 850: sem_week_work = SEMWORK;
Line 851: countSem = semIndexs.Length;
Line 852:
Line 853: }
Line 854: else
Line 855: if (fromDate != null && toDate != null && fromDate.Length > 0 && toDate.Length > 0)
Line 856: {
Line 857: semIndexs = ("1,2,3").Split(',');
Line 858: sem_week_work = WEEKWORK;
Line 859: }
Line 860:
Line 861:
Line 862: int i_sem;
Line 863: string filter_qry = string.Empty;
Line 864: //-----------------------------build filter query string--------------------------
Line 865: if (Request.QueryString[FILTERS_DATA] != null && Request.QueryString[FILTERS_DATA].Length > 0)
Line 866: {
Line 867: string[] filtersDataArr = Request.QueryString[FILTERS_DATA].Split(',');
Line 868: for (int fi = 0; fi < filtersDataArr.Length; fi++)
Line 869: {
Line 870: string qry_f = "(%field like '%%fdate%')";
Line 871: string filS = filtersDataArr[fi];
Line 872: string[] filSubArr = filS.Split('^');
Line 873: if (filSubArr.Length > 1)
Line 874: {
Line 875: _int = 0; res = false; _str = "";
Line 876: res = int.TryParse(filSubArr[0], out _int);
Line 877: if (!res)
Line 878: {
Line 879: Response.Write("db_num not in format. aborting...");
Line 880: Response.End();
Line 881: }
Line 882:
Line 883: string fieldName = GetFiledName(_int);
Line 884: string filterData = filSubArr[1];
Line 885: filterData = filterData.Replace("'", "''");
Line 886: if (filter_qry.Length > 0)
Line 887: filter_qry += " AND ";
Line 888: if (filSubArr[0] == T1_COLUMN_INDEX.ToString() || filSubArr[0] == T2_COLUMN_INDEX.ToString() || filSubArr[0] == T3_COLUMN_INDEX.ToString() || filSubArr[0] == T4_COLUMN_INDEX.ToString() || filSubArr[0] == T5_COLUMN_INDEX.ToString() || filSubArr[0] == ALL_TEACHERS_COLUMN_INDEX.ToString())
Line 889: {
Line 890: filter_qry += "(";
Line 891: for (int tf = T1_COLUMN_INDEX; tf <= T5_COLUMN_INDEX; tf += 2)
Line 892: {
Line 893: if (tf > T1_COLUMN_INDEX)
Line 894: filter_qry += " OR ";
Line 895: filter_qry += qry_f;
Line 896: filter_qry = filter_qry.Replace("%field", GetFiledName(tf));
Line 897: filter_qry = filter_qry.Replace("%fdate", filterData);
Line 898: }
Line 899: filter_qry += ")";
Line 900: }
Line 901: else
Line 902: {
Line 903: qry_f = qry_f.Replace("%field", fieldName);
Line 904: qry_f = qry_f.Replace("%fdate", filterData);
Line 905: filter_qry += qry_f;
Line 906: }
Line 907: }
Line 908: }
Line 909: }
Line 910:
Line 911: //------------------------build query str-------------------------------
Line 912: string query = SEL_FULL_TTS_SHEET;
Line 913: string fac_str = faculty;
Line 914: query = query.Replace("%faculty", fac_str);
Line 915: string qSemweek = "";
Line 916:
Line 917:
Line 918:
Line 919: if (sem_week_work == SEMWORK)
Line 920: {
Line 921: string qrySem = "";
Line 922: string qv = "(select boolvalue from semesters where num=%num)";
Line 923: string sub_sem_str = "";
Line 924: qSemweek = " and ( dbo.IS_AND(sem_index ,(%sem))=1) and sem_index!=-1";
Line 925:
Line 926: for (i_sem = 0; i_sem < countSem; i_sem++)
Line 927: {
Line 928: sub_sem_str = qv;
Line 929: sub_sem_str = sub_sem_str.Replace("%num", semIndexs[i_sem].ToString());
Line 930: if (i_sem > 0)
Line 931: qrySem += " | ";
Line 932: qrySem += sub_sem_str;
Line 933: }
Line 934:
Line 935: qSemweek = qSemweek.Replace("%sem", qrySem);
Line 936: }
Line 937: else if (fromDate!=null && toDate!=null && sem_week_work == WEEKWORK)
Line 938: {
Line 939: qSemweek = " and weeks_long1 & %fromdate or weeks_long2 & %todate";
Line 940: qSemweek = qSemweek.Replace("%fromdate", fromDate);
Line 941: qSemweek = qSemweek.Replace("%todate", toDate);
Line 942: }
Line 943:
Line 944: query = query.Replace("%semweek", qSemweek);
Line 945:
Line 946: fromSup = Request.QueryString[SUPFROM_DATA];
Line 947: toSup = Request.QueryString[SUPTO_DATA];
Line 948:
Line 949: if (fromSup != null && fromSup.Length > 0 && toSup != null && toSup.Length > 0)
Line 950: {
Line 951:
Line 952: if (fromSup.IndexOf("script") > -1 || fromSup.IndexOf("select") > -1)
Line 953: {
Line 954: Response.Write("Dangerous chars appears. aborting...");
Line 955: Response.End();
Line 956:
Line 957: }
Line 958: if (toSup.IndexOf("script") > -1 || toSup.IndexOf("select") > -1)
Line 959: {
Line 960: Response.Write("Dangerous chars appears. aborting...");
Line 961: Response.End();
Line 962:
Line 963: }
Line 964: user_buch_work = USERWORK;
Line 965: }
Line 966:
Line 967:
Line 968:
Line 969: countBunch = 1;
Line 970: if (user_buch_work == USERWORK)
Line 971: {
Line 972: string qu = " and unmap between %supfrom and %supto";
Line 973: qu = qu.Replace("%supfrom", fromSup);
Line 974: qu = qu.Replace("%supto", toSup);
Line 975:
Line 976: query += qu;
Line 977: bunchIndexs = ("0").Split(',');
Line 978: }
Line 979: else
Line 980: {
Line 981: user_buch_work = BUNCHWORK;
Line 982: bunchString = Request.QueryString[BUNCH_DATA];
Line 983: //string[] bunchIndexs;
Line 984: if (bunchString != null && bunchString.Length > 0)
Line 985: {
Line 986:
Line 987: if (bunchString.IndexOf("script")>-1 || bunchString.IndexOf("select")>-1)
Line 988: {
Line 989: Response.Write("Dangerous chars appears. aborting...");
Line 990: Response.End();
Line 991:
Line 992: }
Line 993:
Line 994: if (bunchString == "all")
Line 995: {
Line 996: string qryBunch = SEL_ALL_BUNCH;
Line 997: qryBunch = qryBunch.Replace("%faculty", fac_str);
Line 998: bunchIndexs = ("0").Split(',');
Line 999:
Line 1000: //rs.Open(qryBunch,conn);
Line 1001: //var i=0;
Line 1002: //while(!rs.EOF)
Line 1003: //{
Line 1004: ////INSERT INTERNAL INDEX BUNCH
Line 1005: //bunchIndexs[i]=parseInt(rs.Fields("num"));
Line 1006: //rs.MoveNext();
Line 1007: //i++;
Line 1008: //}
Line 1009: //rs.Close();
Line 1010:
Line 1011: }
Line 1012: else
Line 1013: {
Line 1014: bunchIndexs = bunchString.Split(',');
Line 1015: }
Line 1016: countBunch = bunchIndexs.Length;
Line 1017:
Line 1018: }
Line 1019:
Line 1020: }
Line 1021:
Line 1022:
Line 1023:
Line 1024:
Line 1025: string CidF = Request.QueryString["cidfilter"];
Line 1026: int countCidF = 0;
Line 1027: string[] C_Indexs, CidFIndexs;
Line 1028: if (CidF != null && CidF.Length > 0)
Line 1029: {
Line 1030:
Line 1031:
Line 1032: C_Indexs = CidF.Split(',');
Line 1033: CidFIndexs = CidF.Split(',');
Line 1034: countCidF = CidFIndexs.Length;
Line 1035: }
Line 1036: else
Line 1037: {
Line 1038: C_Indexs = ("0").Split(',');
Line 1039: CidFIndexs = ("0").Split(',');
Line 1040:
Line 1041: }
Line 1042: //added by amir lupo for sapir 01112004
Line 1043: if (CidF != null && CidF.Length > 0)
Line 1044: {
Line 1045: int i_cid;
Line 1046: string query_start = " AND (";
Line 1047: string query_end = ")";
Line 1048: string query_OR = " OR ";
Line 1049:
Line 1050: query += query_start;
Line 1051:
Line 1052:
Line 1053: if (CidF.Length > 0)
Line 1054: {
Line 1055: //query+ = " ( " ;
Line 1056: for (i_cid = 0; i_cid < countCidF; i_cid++)
Line 1057: {
Line 1058:
Line 1059: string curr_cid = CidFIndexs[i_cid];
Line 1060:
Line 1061: string q_cid = " cid like '%cid%' ";
Line 1062: while (q_cid.IndexOf("%cid") != -1)
Line 1063: q_cid = q_cid.Replace("%cid", curr_cid);
Line 1064:
Line 1065: string q_cidFilter = "(%sub_cid) ";
Line 1066: q_cidFilter = q_cidFilter.Replace("%sub_cid", q_cid);
Line 1067:
Line 1068: query += q_cidFilter;
Line 1069:
Line 1070: if (i_cid != countCidF - 1)
Line 1071: query += query_OR;
Line 1072:
Line 1073:
Line 1074: }
Line 1075: query += query_end;
Line 1076: }
Line 1077: }
Line 1078: //Response.Write(query);
Line 1079:
Line 1080: int i_bunch;
Line 1081:
Line 1082: string main_query = query;
Line 1083:
Line 1084: for (i_bunch = 0; i_bunch < countBunch; i_bunch++)
Line 1085: {
Line 1086: query = main_query;
Line 1087: if ((user_buch_work == BUNCHWORK && bunchString != null && bunchString.Length > 0)) //if selected bunchs
Line 1088: {
Line 1089: //15.07.2004 - תוספת למטרה של חיתוך אפיונים - יוצגו קורסים שחותכים את כל האפיונים המצורפים
Line 1090: //לא יוצגו קורסים שאינם נחתכים בכל האפיונים
Line 1091: string[] sub_bunchIndexs;
Line 1092: string strB = bunchIndexs[i_bunch];
Line 1093: string typeAct = "AND";
Line 1094: sub_bunchIndexs = bunchIndexs[i_bunch].Split('!');
Line 1095: for (int s_i_b = 0; s_i_b < sub_bunchIndexs.Length; s_i_b++)
Line 1096: {
Line 1097: if (s_i_b > 0)
Line 1098: typeAct = "OR";
Line 1099: string[] sub_sub_bunchIndexs;
Line 1100: sub_sub_bunchIndexs = sub_bunchIndexs[s_i_b].Split('^');
Line 1101: for (int ss_i_b = 0; ss_i_b < sub_sub_bunchIndexs.Length; ss_i_b++)
Line 1102: {
Line 1103: if (ss_i_b > 0)
Line 1104: typeAct = "AND";
Line 1105: string index_curr_bunch = sub_sub_bunchIndexs[ss_i_b];
Line 1106: string qBunch = SUB_BUNCH;
Line 1107: while (qBunch.IndexOf("%b") != -1)
Line 1108: qBunch = qBunch.Replace("%b", index_curr_bunch);
Line 1109: string qb;
Line 1110: if (s_i_b == 0 && ss_i_b == 0)
Line 1111: qb = " AND( (%sub_bunch";
Line 1112: else
Line 1113: {
Line 1114: qb = typeAct;
Line 1115: if (ss_i_b == 0)
Line 1116: qb += "(";
Line 1117: qb += "%sub_bunch";
Line 1118: }
Line 1119:
Line 1120: if ((ss_i_b + 1) == sub_sub_bunchIndexs.Length)
Line 1121: {
Line 1122: qb += ")";
Line 1123: if ((s_i_b + 1) == sub_bunchIndexs.Length)
Line 1124: qb += ")";
Line 1125: }
Line 1126:
Line 1127: qb = qb.Replace("%sub_bunch", qBunch);
Line 1128: query += qb;
Line 1129: }
Line 1130: }
Line 1131: }
Line 1132: if (filter_qry.Length > 0)
Line 1133: query += " AND " + filter_qry;
Line 1134:
Line 1135: query += " AND wyear=" + wyear;
Line 1136:
Line 1137: query += SUB_ORDER;
Line 1138:
Line 1139:
Line 1140: //Response.Write(query + " <br/>");
Line 1141:
Line 1142:
Line 1143:
Line 1144:
Line 1145: //GridView objGV = gridview_create(query);
Line 1146: Table t = gridview_create(query, i_bunch);
Line 1147: //HtmlControl br = new HtmlControl("br");
Line 1148: HtmlGenericControl b = new HtmlGenericControl("br");
Line 1149:
Line 1150:
Line 1151: main_plh.Controls.Add(b);
Line 1152: main_plh.Controls.Add(t);
Line 1153:
Line 1154:
Line 1155:
Line 1156:
Line 1157:
Line 1158:
Line 1159:
Line 1160:
Line 1161: }
Line 1162:
Line 1163:
Line 1164: if (language != HEBREW_LANG.ToString())
Line 1165: {
Line 1166: dir_t = "ltr";
Line 1167: align_t = "LEFT";
Line 1168: }
Line 1169: }
Line 1170: }
Line 1171:
Line 1172: public String encodeConvert(String inputStr)
Line 1173: {
Line 1174: return HttpUtility.UrlDecode(inputStr,System.Text.Encoding.Default);
Line 1175: //return inputStr;
Line 1176: }
Line 1177:
Line 1178:
Line 1179:
Line 1180:
Line 1181: //public GridView gridview_create(string qry)
Line 1182: public Table gridview_create(string qry, int bunch_ind)
Line 1183: {
Line 1184: //GridView objGV = new GridView();
Line 1185: //objGV.ID = "main_table";
Line 1186:
Line 1187: //Response.Write("1 :: ");
Line 1188:
Line 1189: //objGV.Style.Add("width", "100%");
Line 1190: //DataTable dt = new DataTable();
Line 1191:
Line 1192: //DataRow drow;
Line 1193:
Line 1194: int i_col;
Line 1195:
Line 1196: Table dt = new Table();
Line 1197: dt.Style.Add("width", "100%");
Line 1198: //dt.Style.Add("border", "thin solid black");
Line 1199: //dt.Style.Add("border-collapse", "collapse");
Line 1200:
Line 1201: dt.ID = "main_table";
Line 1202: TableRow drow;
Line 1203:
Line 1204: if (countTitles > 0)
Line 1205: {
Line 1206: drow = new TableRow();
Line 1207: TableCell tc = new TableCell();
Line 1208: if (bunch_ind < titlesArr.Length)
Line 1209: {
Line 1210: //string tit = utf8ToWin(titlesArr[bunch_ind]);
Line 1211: string tit = titlesArr[bunch_ind];
Line 1212:
Line 1213: tc = new TableCell() { ColumnSpan = countCol };
Line 1214: tc.Attributes.Add("style", "text-align:center");
Line 1215: tc.Text = tit;
Line 1216: drow.Attributes.Add("class", "tts_title");
Line 1217: drow.Cells.Add(tc);
Line 1218:
Line 1219: dt.Rows.Add(drow);
Line 1220: }
Line 1221:
Line 1222:
Line 1223: }
Line 1224:
Line 1225:
Line 1226: if (showHdrLine == "1")
Line 1227: {
Line 1228: drow = new TableRow();
Line 1229: //drow.Style.Add("border", "thin solid black");
Line 1230: //drow.Style.Add("border-collapse", "collapse");
Line 1231: //drow.Style.Add("line-height", "2rem");
Line 1232: for (i_col = 0; i_col < countCol; i_col++)
Line 1233: {
Line 1234: string x = columnIndexs[i_col].ToString();
Line 1235: //DataColumn dc = new DataColumn(col_name_by_index(columnIndexs[i_col]), typeof(string));
Line 1236: //dt.Columns.Add(dc);
Line 1237:
Line 1238: TableCell tc = new TableCell();
Line 1239: if (columnWidthIndexs != null)
Line 1240: {
Line 1241: if (columnWidthIndexs.Length > i_col)
Line 1242: {
Line 1243: string width = columnWidthIndexs[i_col] + "%";
Line 1244: tc.Attributes.Add("style", "width:" + width);
Line 1245: }
Line 1246: else tc.Attributes.Add("style", "width:5%");
Line 1247: }
Line 1248:
Line 1249: tc.Text = col_name_by_index(columnIndexs[i_col]);
Line 1250: drow.Cells.Add(tc);
Line 1251:
Line 1252: }
Line 1253: drow.Attributes.Add("class", "headers");
Line 1254: dt.Rows.Add(drow);
Line 1255: //Response.Write("3 :: ");
Line 1256: }
Line 1257:
Line 1258: //using (OdbcConnection connection = new OdbcConnection())
Line 1259: using (SqlConnection connection = new SqlConnection())
Line 1260: {
Line 1261: connection.ConnectionString = System.Configuration.ConfigurationSettings.AppSettings["new_connectionstring"].ToString();
Line 1262: connection.Open();
Line 1263: //OdbcCommand command = new OdbcCommand(qry, connection);
Line 1264: SqlCommand command = new SqlCommand(qry, connection);
Line 1265:
Line 1266: //OdbcDataReader dr = command.ExecuteReader();
Line 1267: SqlDataReader dr = command.ExecuteReader();
Line 1268: while (dr.Read())
Line 1269: {
Line 1270: //drow = dt.NewRow();
Line 1271: drow = new TableRow();
Line 1272: string[] tts_data_arr = LoadLineData(dr);
Line 1273: string cid=tts_data_arr[CID_COLUMN_INDEX];
Line 1274: string phase=tts_data_arr[PHASE_COLUMN_INDEX];
Line 1275: TableCell tc;
Line 1276:
Line 1277: if (Convert.ToInt32(phase) < 0 && tts_data_arr[NAME_COLUMN_INDEX].Substring(0, 2) != "**") // כותרת
Line 1278: {
Line 1279: if (NoTtsTitles == "0")
Line 1280: {
Line 1281: for (i_col = 0; i_col < countCol; i_col++)
Line 1282: {
Line 1283: string name = GetFiledName(columnIndexs[i_col]);
Line 1284: int netoColIndex = Convert.ToInt32(GetNeto(columnIndexs[i_col].ToString()));
Line 1285:
Line 1286:
Line 1287:
Line 1288: if (netoColIndex == NAME_COLUMN_INDEX)
Line 1289: {
Line 1290: //drow[i_col] = tts_data_arr[NAME_COLUMN_INDEX];
Line 1291:
Line 1292: tc = new TableCell() { ColumnSpan = countCol };
Line 1293: tc.Text = tts_data_arr[NAME_COLUMN_INDEX];
Line 1294: tc.Attributes.Add("style", "text-align:center");
Line 1295: drow.Attributes.Add("class", "tts_title");
Line 1296: drow.Cells.Add(tc);
Line 1297:
Line 1298: }
Line 1299:
Line 1300:
Line 1301: }
Line 1302: dt.Rows.Add(drow);
Line 1303: }
Line 1304: }
Line 1305: else
Line 1306: if (Convert.ToInt32(phase) < 0 && tts_data_arr[NAME_COLUMN_INDEX].Substring(0, 2) == "**") // הערה
Line 1307: {
Line 1308: if (NoTtsTitles == "0" || NoTtsTitles == "2")
Line 1309: {
Line 1310: for (i_col = 0; i_col < countCol; i_col++)
Line 1311: {
Line 1312: string name = GetFiledName(columnIndexs[i_col]);
Line 1313: int netoColIndex = Convert.ToInt32(GetNeto(columnIndexs[i_col].ToString()));
Line 1314:
Line 1315:
Line 1316: if (netoColIndex == NAME_COLUMN_INDEX)
Line 1317: {
Line 1318: //drow[0] = "•"+tts_data_arr[NAME_COLUMN_INDEX].Replace("**","");
Line 1319: tc = new TableCell() { ColumnSpan = countCol };
Line 1320: tc.Text = "•" + tts_data_arr[NAME_COLUMN_INDEX].Replace("**", "");
Line 1321: tc.Attributes.Add("style", "text-align:right");
Line 1322: drow.Attributes.Add("class", "remarks");
Line 1323: drow.Cells.Add(tc);
Line 1324: }
Line 1325:
Line 1326: }
Line 1327: dt.Rows.Add(drow);
Line 1328: }
Line 1329:
Line 1330: }
Line 1331: else
Line 1332: {
Line 1333: for (i_col = 0; i_col < countCol; i_col++)
Line 1334: {
Line 1335: string name = GetFiledName(columnIndexs[i_col]);
Line 1336: int netoColIndex = Convert.ToInt32(GetNeto(columnIndexs[i_col].ToString()));
Line 1337: //drow[i_col] = dr[name];
Line 1338: string result = string.Empty;
Line 1339: string result_link = string.Empty;
Line 1340:
Line 1341: drow.Attributes.Add("class", "texts");
Line 1342:
Line 1343: if (netoColIndex == DATON1_COLUMN_INDEX)
Line 1344: {
Line 1345: result = GetDatetimeText(tts_data_arr[DATON1_COLUMN_INDEX],false);
Line 1346: if (result == "01/01/2000")
Line 1347: result = " ";
Line 1348: if (result == "NaN/NaN/NaN")
Line 1349: result = " ";
Line 1350: if (result == "00/00/0000")
Line 1351: result = " ";
Line 1352:
Line 1353: //drow[i_col] = result;
Line 1354: tc = new TableCell();
Line 1355: tc.Text = result;
Line 1356: drow.Cells.Add(tc);
Line 1357:
Line 1358: }
Line 1359: else
Line 1360: if (netoColIndex == DATON2_COLUMN_INDEX)
Line 1361: {
Line 1362:
Line 1363: result = GetDatetimeText(tts_data_arr[DATON2_COLUMN_INDEX],false);
Line 1364: if (result == "01/01/2000")
Line 1365: result = " ";
Line 1366: if (result == "NaN/NaN/NaN")
Line 1367: result = " ";
Line 1368: if (result == "00/00/0000")
Line 1369: result = " ";
Line 1370: //drow[i_col] = result;
Line 1371: tc = new TableCell();
Line 1372: tc.Text = result;
Line 1373: drow.Cells.Add(tc);
Line 1374:
Line 1375: }
Line 1376: else
Line 1377:
Line 1378:
Line 1379: if (netoColIndex >= BUNCH1_COLUMN_INDEX && netoColIndex <= BUNCH20_COLUMN_INDEX)
Line 1380: {
Line 1381:
Line 1382: result = tts_data_arr[netoColIndex];
Line 1383: tc = new TableCell();
Line 1384: tc.Text = result;
Line 1385: drow.Cells.Add(tc);
Line 1386:
Line 1387: }
Line 1388: else
Line 1389:
Line 1390:
Line 1391:
Line 1392: if (netoColIndex == CONNECT_ROOM_HOUSE_INDEX)
Line 1393: {
Line 1394:
Line 1395: result = tts_data_arr[NROOM_COLUMN_INDEX];
Line 1396: result_link = result;
Line 1397: if (result.Length > 0)
Line 1398: result += " ";
Line 1399: result += tts_data_arr[NHOUSE_COLUMN_INDEX];
Line 1400:
Line 1401: tc = new TableCell();
Line 1402: tc.Text = result;
Line 1403: drow.Cells.Add(tc);
Line 1404:
Line 1405:
Line 1406: }
Line 1407: else
Line 1408: if (netoColIndex == ALL_TEACHERS_COLUMN_INDEX)
Line 1409: {
Line 1410: //Response.Write("0000");
Line 1411: //Response.Write(IndexTeaString);
Line 1412: //Response.End();
Line 1413:
Line 1414:
Line 1415: if (IndexTeaString != null && IndexTeaString.Length>0)
Line 1416: {
Line 1417: string[] indexTeaArr = IndexTeaString.Split(',');
Line 1418: int i_t;
Line 1419: for (i_t = 0; i_t < indexTeaArr.Length; i_t++)
Line 1420: {
Line 1421: string res0 = "abcd";//string.Empty;
Line 1422: int teacher_column_ind = Convert.ToInt32(GetNeto(indexTeaArr[i_t]));
Line 1423: if (teacher_column_ind == 16)
Line 1424: res0 = tts_data_arr[T1_COLUMN_INDEX];
Line 1425: if (teacher_column_ind == 18)
Line 1426: res0 = tts_data_arr[T2_COLUMN_INDEX];
Line 1427: if (teacher_column_ind == 20)
Line 1428: res0 = tts_data_arr[T3_COLUMN_INDEX];
Line 1429: if (teacher_column_ind == 22)
Line 1430: res0 = tts_data_arr[T4_COLUMN_INDEX];
Line 1431: if (teacher_column_ind == 24)
Line 1432: res0 = tts_data_arr[T5_COLUMN_INDEX];
Line 1433:
Line 1434:
Line 1435:
Line 1436: //int tr=0;
Line 1437: bool stopNow = false;
Line 1438: string res_fix = "";
Line 1439: //trim
Line 1440: for (int tr = 0; !stopNow && tr < res0.Length; tr++)
Line 1441: {
Line 1442: if (res0.Substring(tr, 1) != " ")
Line 1443: {
Line 1444: stopNow = true;
Line 1445: res_fix = res0.Substring(tr);
Line 1446: }
Line 1447: }
Line 1448: res0 = res_fix;
Line 1449: if (i_t == 0)
Line 1450: result_link = res0;
Line 1451: if (res0.Length > 0 && (res0.Length - 1) > 0)
Line 1452: {
Line 1453:
Line 1454: //if teachers_group column is as link
Line 1455: //build link field for each teacher
Line 1456: if (columnIndexs[i_col].ToString().LastIndexOf("-") >= 0)
Line 1457: {
Line 1458: int teaid_column = teacher_column_ind;
Line 1459: string str_link = "";
Line 1460: if (linksArr.Length > i_col)
Line 1461: str_link = GetLinkStr_list(linksArr[i_col], tts_data_arr, teaid_column);
Line 1462: result += "<a href=\"#\" onclick=\"window.open('" + str_link + "','_blank','toolbar=yes, scrollbars=yes, resizable=yes, top=50, left=50, width=800, height=600'; return false; \") >" + res0 + "</a>";
Line 1463:
Line 1464:
Line 1465: }
Line 1466: else
Line 1467: result += res0;
Line 1468: string vbCrLf = "<br>"; // "\n";
Line 1469: if (result.Length > 0)
Line 1470: result += vbCrLf;
Line 1471:
Line 1472: }
Line 1473: }
Line 1474: }//end if
Line 1475: //drow[i_col] = result;
Line 1476: tc = new TableCell();
Line 1477: tc.Text = result;
Line 1478: drow.Cells.Add(tc);
Line 1479:
Line 1480: }
Line 1481: else
Line 1482:
Line 1483:
Line 1484: if (netoColIndex == CONNECT_HOURS_INDEX)
Line 1485: {
Line 1486: result = GetDatetimeText(tts_data_arr[HOMIN2_COLUMN_INDEX],true) + "-" + GetDatetimeText(tts_data_arr[HOMIN1_COLUMN_INDEX],true);
Line 1487: if (result.Length < 4)
Line 1488: result = "";
Line 1489: //result_link =tts_data_arr[HOMIN1_COLUMN_INDEX]
Line 1490: tc = new TableCell();
Line 1491: tc.Text = result;
Line 1492: drow.Cells.Add(tc);
Line 1493:
Line 1494:
Line 1495: }
Line 1496: else
Line 1497: if (netoColIndex == HOMIN1_COLUMN_INDEX)
Line 1498: {
Line 1499: //drow[i_col] = tts_data_arr[CID_COLUMN_INDEX];
Line 1500: tc = new TableCell();
Line 1501: string t = GetDatetimeText(tts_data_arr[HOMIN1_COLUMN_INDEX],true);
Line 1502: if (t == "00:00")
Line 1503: t = " ";
Line 1504: tc.Text = t;
Line 1505: drow.Cells.Add(tc);
Line 1506: }
Line 1507: else
Line 1508: if (netoColIndex == HOMIN2_COLUMN_INDEX)
Line 1509: {
Line 1510: //drow[i_col] = tts_data_arr[CID_COLUMN_INDEX];
Line 1511: tc = new TableCell();
Line 1512: string t = GetDatetimeText(tts_data_arr[HOMIN2_COLUMN_INDEX],true);
Line 1513: if (t == "00:00")
Line 1514: t = " ";
Line 1515: tc.Text = t;
Line 1516: drow.Cells.Add(tc);
Line 1517: }
Line 1518:
Line 1519:
Line 1520: else
Line 1521: if (netoColIndex == CID_COLUMN_INDEX)
Line 1522: {
Line 1523: //drow[i_col] = tts_data_arr[CID_COLUMN_INDEX];
Line 1524: string str_link=" ";
Line 1525: //Response.Write(linksArr.Length.ToString());
Line 1526: //Response.End();
Line 1527:
Line 1528: if(linksArr.Length>0 && i_col>-1 && linksArr.Length > i_col)
Line 1529: str_link=GetLinkStr_list(linksArr[i_col],tts_data_arr,-1);
Line 1530:
Line 1531:
Line 1532: //string a_text = "<a href='" + Server.HtmlEncode(str_link) + "' target='_blank'>" + tts_data_arr[CID_COLUMN_INDEX] + "</a>";
Line 1533: string a_text = "<a href='#' onclick=\"window.open('" + Server.HtmlEncode(str_link) + "', '_blank','toolbar=yes, scrollbars=yes, resizable=yes, top=50, left=50, width=800, height=600'); return false;\" >" + tts_data_arr[CID_COLUMN_INDEX] + "</a>";
Line 1534:
Line 1535: tc = new TableCell();
Line 1536: //tc.Attributes.Add("onclick", "window.open=('" + Server.HtmlEncode(str_link) + "','_blank','toolbar=yes, scrollbars=yes, resizable=yes, top=50, left=50, width=800, height=600'); return false;");
Line 1537: //tc.Attributes.Add("style", "cursor:pointer;text-decoration:underline;");
Line 1538: //tc.Attributes.Add("target", "_blank"); ;
Line 1539: //tc.Text = tts_data_arr[CID_COLUMN_INDEX];
Line 1540: tc.Text = a_text;
Line 1541: drow.Cells.Add(tc);
Line 1542: }
Line 1543: else
Line 1544: if (netoColIndex == PHASE_COLUMN_INDEX)
Line 1545: {
Line 1546: //drow[i_col] = tts_data_arr[PHASE_COLUMN_INDEX];
Line 1547: tc = new TableCell();
Line 1548: tc.Text = tts_data_arr[PHASE_COLUMN_INDEX];
Line 1549: drow.Cells.Add(tc);
Line 1550: }
Line 1551:
Line 1552:
Line 1553: else
Line 1554: if (netoColIndex == METHOD_COLUMN_INDEX)
Line 1555: {
Line 1556: //drow[i_col] = tts_data_arr[METHOD_COLUMN_INDEX];
Line 1557: tc = new TableCell();
Line 1558: tc.Text = tts_data_arr[METHOD_COLUMN_INDEX];
Line 1559: drow.Cells.Add(tc);
Line 1560: }
Line 1561:
Line 1562: else
Line 1563: if (netoColIndex == WKD_COLUMN_INDEX)
Line 1564: {
Line 1565: //drow[i_col] = GetDayText(tts_data_arr[WKD_COLUMN_INDEX]);
Line 1566: tc = new TableCell();
Line 1567: tc.Text = GetDayText(tts_data_arr[WKD_COLUMN_INDEX]);
Line 1568: drow.Cells.Add(tc);
Line 1569:
Line 1570: }
Line 1571: else
Line 1572: if (netoColIndex == NAME_COLUMN_INDEX)
Line 1573: {
Line 1574: //drow[i_col] = tts_data_arr[NAME_COLUMN_INDEX];
Line 1575: tc = new TableCell();
Line 1576: tc.Text = tts_data_arr[NAME_COLUMN_INDEX];
Line 1577: drow.Cells.Add(tc);
Line 1578: }
Line 1579: else
Line 1580: if (netoColIndex == METHOD_COLUMN_INDEX)
Line 1581: {
Line 1582: //drow[i_col] = tts_data_arr[METHOD_COLUMN_INDEX];
Line 1583: tc = new TableCell();
Line 1584: tc.Text = tts_data_arr[METHOD_COLUMN_INDEX];
Line 1585: drow.Cells.Add(tc);
Line 1586: }
Line 1587: else
Line 1588: if (netoColIndex == SEM_COLUMN_INDEX)
Line 1589: {
Line 1590: //drow[i_col] = tts_data_arr[SEM_COLUMN_INDEX];
Line 1591: tc = new TableCell();
Line 1592: tc.Text = tts_data_arr[SEM_COLUMN_INDEX];
Line 1593: drow.Cells.Add(tc);
Line 1594:
Line 1595: }
Line 1596: else
Line 1597: if (netoColIndex == NROOM_COLUMN_INDEX)
Line 1598: {
Line 1599: //drow[i_col] = tts_data_arr[SEM_COLUMN_INDEX];
Line 1600: tc = new TableCell();
Line 1601: tc.Text = tts_data_arr[NROOM_COLUMN_INDEX];
Line 1602: drow.Cells.Add(tc);
Line 1603:
Line 1604: }
Line 1605: else
Line 1606: if (netoColIndex == NHOUSE_COLUMN_INDEX)
Line 1607: {
Line 1608: //drow[i_col] = tts_data_arr[SEM_COLUMN_INDEX];
Line 1609: tc = new TableCell();
Line 1610: tc.Text = tts_data_arr[NHOUSE_COLUMN_INDEX];
Line 1611: drow.Cells.Add(tc);
Line 1612:
Line 1613: }
Line 1614: else
Line 1615: if (netoColIndex == REMARK_COLUMN_INDEX)
Line 1616: {
Line 1617: //drow[i_col] = tts_data_arr[SEM_COLUMN_INDEX];
Line 1618: tc = new TableCell();
Line 1619: tc.Text = tts_data_arr[REMARK_COLUMN_INDEX];
Line 1620: drow.Cells.Add(tc);
Line 1621:
Line 1622: }
Line 1623: else
Line 1624: if (netoColIndex == SHAS_COLUMN_INDEX)
Line 1625: {
Line 1626: //drow[i_col] = tts_data_arr[SEM_COLUMN_INDEX];
Line 1627: tc = new TableCell();
Line 1628: tc.Text = tts_data_arr[SHAS_COLUMN_INDEX];
Line 1629: drow.Cells.Add(tc);
Line 1630: }
Line 1631: else
Line 1632: if (netoColIndex == SHASTYPE_COLUMN_INDEX)
Line 1633: {
Line 1634: //drow[i_col] = tts_data_arr[SEM_COLUMN_INDEX];
Line 1635: tc = new TableCell();
Line 1636: tc.Text = tts_data_arr[SHASTYPE_COLUMN_INDEX];
Line 1637: drow.Cells.Add(tc);
Line 1638: }
Line 1639: else
Line 1640: if (netoColIndex == CONNECT_HOURS_INDEX)
Line 1641: {
Line 1642: //drow[i_col] = tts_data_arr[CID_COLUMN_INDEX];
Line 1643: tc = new TableCell();
Line 1644: string t1 = GetDatetimeText(tts_data_arr[HOMIN1_COLUMN_INDEX],true);
Line 1645: if (t1 == "00:00")
Line 1646: t1 = "";
Line 1647: string t2 = GetDatetimeText(tts_data_arr[HOMIN2_COLUMN_INDEX],true);
Line 1648: if (t2 == "00:00")
Line 1649: t2 = " ";
Line 1650:
Line 1651: tc.Text = t1 + "-" + t2;
Line 1652: drow.Cells.Add(tc);
Line 1653: }
Line 1654: else
Line 1655: if (netoColIndex==EXAM_LINK_COLUMN_INDEX)
Line 1656: {
Line 1657: tc = new TableCell();
Line 1658: string tcid = tts_data_arr[CID_COLUMN_INDEX];
Line 1659:
Line 1660: //string str_link ="https://mashdsp.tau.ac.il/asplinks/exdlist.asp?faculty="+ faculty + "&co=1,2,5,31&db_num="+ db_num + "&oneline=1&moed=1,2&cid=" + tcid;
Line 1661: string str_link ="examlist.aspx?faculty="+ faculty + "&co=1,2,5,31&db_num="+ db_num + "&oneline=1&moed=1,2&cid=" + tcid;
Line 1662:
Line 1663: string full_str = "<a href=\"#\" onclick=\"window.open('" + str_link + "','_blank','toolbar=yes, scrollbars=yes, resizable=yes, top=50, left=50, width=800, height=600'); return false; \" >" + "מטלה" + "</a>";
Line 1664: tc.Text = full_str;
Line 1665: drow.Cells.Add(tc);
Line 1666:
Line 1667: }
Line 1668: else
Line 1669: if (netoColIndex==SYLLABUS_LINK_COLUMN_INDEX)
Line 1670: {
Line 1671: tc = new TableCell();
Line 1672: string tcid = tts_data_arr[CID_COLUMN_INDEX];
Line 1673:
Line 1674: string str_link ="https://www30.tau.ac.il/yedion/syllabus.asp?course=" + tcid + "&year=" + db_num ;
Line 1675:
Line 1676: string full_str = "<a href=\"#\" onclick=\"window.open('" + str_link + "','_blank','toolbar=yes, scrollbars=yes, resizable=yes, top=50, left=50, width=800, height=600'); return false; \" >" + "סילבוס" + "</a>";
Line 1677: tc.Text = full_str;
Line 1678: drow.Cells.Add(tc);
Line 1679:
Line 1680: //result=utf8ToWin("<-->");
Line 1681: //result_link = result;
Line 1682: }
Line 1683:
Line 1684:
Line 1685:
Line 1686: //else
Line 1687: //if (netoColIndex == EXAM_LINK_COLUMN_INDEX)
Line 1688: //{
Line 1689: // //drow[i_col] = tts_data_arr[SEM_COLUMN_INDEX];
Line 1690: // tc = new TableCell();
Line 1691: // tc.Text = tts_data_arr[SHASTYPE_COLUMN_INDEX];
Line 1692: // drow.Cells.Add(tc);
Line 1693: //}
Line 1694: //else
Line 1695: //if (netoColIndex == SYLLABUS_LINK_COLUMN_INDEX)
Line 1696: //{
Line 1697: // //drow[i_col] = tts_data_arr[SEM_COLUMN_INDEX];
Line 1698: // tc = new TableCell();
Line 1699: // tc.Text = tts_data_arr[SHASTYPE_COLUMN_INDEX];
Line 1700: // drow.Cells.Add(tc);
Line 1701: //}
Line 1702:
Line 1703: else
Line 1704: //if (netoColIndex == SYLLABUS_LINK_COLUMN_INDEX)
Line 1705: if (netoColIndex>-1)
Line 1706: {
Line 1707: //drow[i_col] = tts_data_arr[SEM_COLUMN_INDEX];
Line 1708: tc = new TableCell();
Line 1709: tc.Text = tts_data_arr[netoColIndex];
Line 1710: drow.Cells.Add(tc);
Line 1711: }
Line 1712:
Line 1713:
Line 1714:
Line 1715: //&&&
Line 1716:
Line 1717:
Line 1718: else
Line 1719: {
Line 1720: //drow[i_col] = tts_data_arr[NAME_COLUMN_INDEX];
Line 1721: //drow[i_col] = "";
Line 1722: tc = new TableCell();
Line 1723: tc.Text = "";
Line 1724: drow.Cells.Add(tc);
Line 1725: }
Line 1726:
Line 1727: }
Line 1728: dt.Rows.Add(drow);
Line 1729: }
Line 1730:
Line 1731:
Line 1732:
Line 1733:
Line 1734:
Line 1735: for (int j = 0; j < tts_data_arr.Length; j++)
Line 1736: {
Line 1737: //Response.Write(tts_data_arr[j] + " ||| ");
Line 1738: }
Line 1739: //Response.Write(" <br /> ");
Line 1740: }
Line 1741:
Line 1742: connection.Close();
Line 1743:
Line 1744: }
Line 1745:
Line 1746:
Line 1747:
Line 1748:
Line 1749: //drow = dt.NewRow();
Line 1750: //drow[0] = "dddd";
Line 1751: //dt.Rows.Add(drow);
Line 1752:
Line 1753:
Line 1754: //Response.Write("4 :: " + dt.Rows.Count.ToString());
Line 1755: //objGV.DataSource = dt;
Line 1756: //objGV.DataBind();
Line 1757: //return objGV;
Line 1758: return dt;
Line 1759:
Line 1760: }
Line 1761:
Line 1762: public void ODBC_load_table_by_sql( string tableName, string sqlStr)
Line 1763: {
Line 1764: //DataSet ds = new DataSet();
Line 1765: //OdbcConnection sql_con = new OdbcConnection();
Line 1766: SqlConnection sql_con = new SqlConnection();
Line 1767:
Line 1768: //DataSet ds = new DataSet();
Line 1769: try
Line 1770: {
Line 1771: //sql_con.ConnectionString = "DSN=tau21;Uid=graddsp;Pwd=bcd234;";
Line 1772: //if (sql_con.State == ConnectionState.Closed) sql_con.Open();
Line 1773:
Line 1774:
Line 1775: //OdbcDataAdapter oda = new OdbcDataAdapter(sqlStr, sql_con);
Line 1776: //oda.Fill(ds, tableName);
Line 1777: }
Line 1778: //catch (OdbcException e)
Line 1779: catch (SqlException e)
Line 1780: {
Line 1781: System.Web.HttpContext.Current.Response.Write(String.Format("An exception occurred" +
Line 1782: " : {0}. Please contact your system administrator.",
Line 1783: e.Message));
Line 1784: }
Line 1785: finally
Line 1786: {
Line 1787: if (sql_con != null) sql_con.Close();
Line 1788:
Line 1789: }
Line 1790: //DataView dv = new DataView(ds.Tables[tableName]);
Line 1791: //return dv;
Line 1792: //return ds;
Line 1793: }
Line 1794:
Line 1795:
Line 1796:
Line 1797: /****************************************************************************************************************/
Line 1798: /****************************************************************************************************************/
Line 1799:
Line 1800:
Line 1801:
Line 1802: string GetLinkStr_list(string strLink, string[] tts_data_arr, int teacherId_column)
Line 1803: {
Line 1804: strLink = strLink.Replace("style=\"color:6c0000\"", "");
Line 1805: //Response.Write("KKKKKKK = " + strLink);
Line 1806:
Line 1807:
Line 1808: string subLink="";
Line 1809: int i;
Line 1810: for(i=0; i<strLink.Length; i++)
Line 1811: {
Line 1812: if(strLink.Substring(i,1)!="(" )
Line 1813: subLink+=strLink.Substring(i,1);
Line 1814: else
Line 1815: {
Line 1816: string str="";
Line 1817: i++;
Line 1818: //Response.Write("PPPPPP = " + strLink);
Line 1819: //Response.End();
Line 1820: // while(strLink.Trim()!="" && i<strLink.Length)
Line 1821: // if (strLink.Substring(i,1)!=")" && i<strLink.Length)
Line 1822: // {
Line 1823: // str+=strLink.Substring(i++,1);
Line 1824: // }
Line 1825:
Line 1826: while(strLink.Trim()!="" && i<strLink.Length && strLink.Substring(i,1)!=")")
Line 1827: {
Line 1828: str+=strLink.Substring(i++,1);
Line 1829: }
Line 1830:
Line 1831:
Line 1832: //Response.Write("QQQQQQ = " + str);
Line 1833: subLink+=ChangStrFilterToLink(str,tts_data_arr,teacherId_column);
Line 1834:
Line 1835: }
Line 1836: }
Line 1837:
Line 1838:
Line 1839: if (strLink.Trim()=="" && teacherId_column==-1)
Line 1840: {
Line 1841: subLink ="https://www30.tau.ac.il/yedion/syllabus.asp?course=" + tts_data_arr[CID_COLUMN_INDEX] + "&year=" + wyear ;
Line 1842: }
Line 1843: if (teacherId_column==-1)
Line 1844: {
Line 1845: subLink ="https://www30.tau.ac.il/yedion/syllabus.asp?course=" + tts_data_arr[CID_COLUMN_INDEX] + "&year=" + wyear ;
Line 1846: }
Line 1847:
Line 1848:
Line 1849: return subLink;
Line 1850:
Line 1851: }
Line 1852:
Line 1853:
Line 1854: //********************************************************************
Line 1855: //function ChangStrToCid(str,Cid)
Line 1856: //{
Line 1857:
Line 1858: // var index=str.search("=");
Line 1859: // var indexsCid;
Line 1860: // var subCid="";
Line 1861: // if(index!=-1)
Line 1862: // {
Line 1863: // indexsCid=str.substr((index+1),(str.length-1)).split("-");
Line 1864: // for(i=0;i<indexsCid.length;i++)
Line 1865: // {
Line 1866: // subCid+=cid.charAt(indexsCid[i]);
Line 1867: // }
Line 1868: // }
Line 1869:
Line 1870: // return subCid;
Line 1871: //}
Line 1872: //********************************************************************
Line 1873: string ChangStrFilterToLink(string str, string[] tts_data_arr, int teacherId_column)
Line 1874: {
Line 1875:
Line 1876: int index=str.IndexOf('=');
Line 1877: string[] indexsCid;
Line 1878: string retData="";
Line 1879: string key="";
Line 1880: if(index>0 && tts_data_arr.Length>T5ID_COLUMN_INDEX)
Line 1881: {
Line 1882: key = str.Substring(0, index);
Line 1883:
Line 1884: //Response.Write("index=" + index.ToString() + " key=" + key + " ::: ");
Line 1885:
Line 1886:
Line 1887:
Line 1888: if (key=="cid")
Line 1889: {
Line 1890: string cid = tts_data_arr[CID_COLUMN_INDEX];
Line 1891: indexsCid=str.Substring((index+1),(str.Length-1-index)).Split('-');
Line 1892:
Line 1893: //response.Write
Line 1894: //Response.Write("indexsCid=" + indexsCid.ToString() + " key=" + key + "<br>");
Line 1895: for(int i=0; i<indexsCid.Length; i++)
Line 1896: {
Line 1897: //Response.Write("indexsCid=" + indexsCid[i].ToString() + " key=" + key + "<br>");
Line 1898: //retData+=cid.Substring(Convert.ToInt32(indexsCid[i]),1);
Line 1899: string x="";
Line 1900: }
Line 1901: }
Line 1902: }
Line 1903:
Line 1904: if(str.IndexOf("teaId1")!=-1) return tts_data_arr[T1ID_COLUMN_INDEX];
Line 1905: if(str.IndexOf("teaId2")!=-1) return tts_data_arr[T2ID_COLUMN_INDEX];
Line 1906: if(str.IndexOf("teaId3")!=-1) return tts_data_arr[T3ID_COLUMN_INDEX];
Line 1907: if(str.IndexOf("teaId4")!=-1) return tts_data_arr[T4ID_COLUMN_INDEX];
Line 1908: if(str.IndexOf("teaId5")!=-1) return tts_data_arr[T5ID_COLUMN_INDEX];
Line 1909: if(str.IndexOf("teaId")!=-1 && teacherId_column>=T1ID_COLUMN_INDEX && teacherId_column<=T5ID_COLUMN_INDEX ) return tts_data_arr[teacherId_column];
Line 1910:
Line 1911:
Line 1912: return retData;
Line 1913: }
Line 1914:
Line 1915:
Line 1916: string GetColName(int colindex)
Line 1917: {
Line 1918: string strName="";
Line 1919: switch(colindex)
Line 1920: {
Line 1921:
Line 1922: case FACULTY_COLUMN_INDEX: strName="פקולטה";break;
Line 1923: //case SEM_COLUMN_INDEX: strName="סמסטר";break;
Line 1924: case SEM_COLUMN_INDEX: strName="סמ.";break;
Line 1925: case CID_COLUMN_INDEX: strName="מס' קורס";break;
Line 1926: case PHASE_COLUMN_INDEX: strName="מופע";break;
Line 1927: case NAME_COLUMN_INDEX: strName="שם קורס";break;
Line 1928: case METHOD_COLUMN_INDEX: strName="אופן הוראה";break;
Line 1929: case WKD_COLUMN_INDEX: strName="יום";break;
Line 1930: case HOMIN1_COLUMN_INDEX: strName="משעה";break;
Line 1931: case HOMIN2_COLUMN_INDEX: strName="עד שעה";break;
Line 1932: case ROOM_COLUMN_INDEX: strName="אינדקס חדר";break;
Line 1933: case NROOM_COLUMN_INDEX: strName="חדר";break;
Line 1934: case NHOUSE_COLUMN_INDEX: strName="בניין";break;
Line 1935: case ROOM_NUM_COLUMN_INDEX: strName="";break;
Line 1936: case DURA_COLUMN_INDEX: strName="משך";break;
Line 1937: case REMARK_COLUMN_INDEX: strName="הערה";break;
Line 1938: case T1_COLUMN_INDEX: strName="מרצה 1";break;
Line 1939: case T1ID_COLUMN_INDEX: strName="ת.ז מרצה 1";break;
Line 1940: case T2_COLUMN_INDEX: strName="מרצה 2";break;
Line 1941: case T2ID_COLUMN_INDEX: strName="ת.ז מרצה 2";break;
Line 1942: case T3_COLUMN_INDEX: strName="מרצה 3";break;
Line 1943: case T3ID_COLUMN_INDEX: strName = "ת.ז מרצה 3";break;
Line 1944: case T4_COLUMN_INDEX: strName="מרצה 4";break;
Line 1945: case T4ID_COLUMN_INDEX: strName="ת.ז מרצה 4";break;
Line 1946: case T5_COLUMN_INDEX: strName="מרצה 5";break;
Line 1947: case T5ID_COLUMN_INDEX: strName="ת.ז מרצה 5";break;
Line 1948: case DOCO_COLUMN_INDEX: strName="צבע";break;
Line 1949: case EXPECTED_COLUMN_INDEX: strName="צפויים";break;
Line 1950: case ENLISTED_COLUMN_INDEX: strName="צפויים";break;
Line 1951: case NUT_COLUMN_INDEX: strName="מל\"ש";break;
Line 1952: case HOUSE_COLUMN_INDEX: strName="";break;
Line 1953: case LAMP_COLUMN_INDEX: strName="משאבים";break;
Line 1954: case PRF_COLUMN_INDEX: strName="דגל";break;
Line 1955: case INORLIS_COLUMN_INDEX: strName="משותפים";break;
Line 1956: case MMF_COLUMN_INDEX: strName="";break;
Line 1957: case SHAS_COLUMN_INDEX: strName="ש\"ס";break;
Line 1958: case SHASTYPE_COLUMN_INDEX: strName="ש\"ס";break;
Line 1959: case HSF_COLUMN_INDEX: strName="פ";break;
Line 1960: case PARASIT_COLUMN_INDEX: strName="פרזיט";break;
Line 1961: case LEADER_COLUMN_INDEX: strName="נגרר";break;
Line 1962: case EXCLA_COLUMN_INDEX: strName="ליבה";break;
Line 1963: case BUNCH1_COLUMN_INDEX: strName="מאפיין 1";break;
Line 1964: case BUNCH2_COLUMN_INDEX: strName="מאפיין 2";break;
Line 1965: case BUNCH3_COLUMN_INDEX: strName="מאפיין 3";break;
Line 1966: case BUNCH4_COLUMN_INDEX: strName="מאפיין 4";break;
Line 1967: case BUNCH5_COLUMN_INDEX: strName="מאפיין 5";break;
Line 1968: case BUNCH6_COLUMN_INDEX: strName="מאפיין 6";break;
Line 1969: case BUNCH7_COLUMN_INDEX: strName="עיוני / מעשי";break;
Line 1970: case BUNCH8_COLUMN_INDEX: strName="מאפיין 8";break;
Line 1971: case BUNCH9_COLUMN_INDEX: strName="יחודי / משותף";break;
Line 1972: case BUNCH10_COLUMN_INDEX: strName="מאפיין 10";break;
Line 1973: case BUNCH11_COLUMN_INDEX: strName="ציבורי/מסחרי/פלילי";break;
Line 1974: case BUNCH12_COLUMN_INDEX: strName="ליבה/בחירה";break;
Line 1975: case BUNCH13_COLUMN_INDEX: strName="אזרחי";break;
Line 1976: case BUNCH14_COLUMN_INDEX: strName="ש\"ס";break;
Line 1977: case BUNCH15_COLUMN_INDEX: strName="מאפיין 15";break;
Line 1978: case BUNCH16_COLUMN_INDEX: strName="מאפיין 16";break;
Line 1979: case BUNCH17_COLUMN_INDEX: strName="מאפיין 17";break;
Line 1980: case BUNCH18_COLUMN_INDEX: strName="מאפיין 18";break;
Line 1981: case BUNCH19_COLUMN_INDEX: strName="מאפיין 19";break;
Line 1982: case BUNCH20_COLUMN_INDEX: strName="מאפיין 20";break;
Line 1983: case DATON1_COLUMN_INDEX: strName="מתאריך";break;
Line 1984: case DATON2_COLUMN_INDEX: strName="עד תאריך";break;
Line 1985: case LOCHED_COLUMN_INDEX: strName="נעילת שורה";break;
Line 1986: case GILA_FLAG_COLUMN_INDEX: strName="שינוי בשורה=תכלת";break;
Line 1987: case WEEKS_LONG1_COLUMN_INDEX: strName="שבועות 1";break;
Line 1988: case WEEKS_LONG2_COLUMN_INDEX: strName="שבועות 2";break;
Line 1989: //case ALL_TEACHERS_COLUMN_INDEX: strName="מרצים";break;
Line 1990: //case ZAMAK_TYPE_COLUMN_INDEX: strName="תקופה";break;
Line 1991:
Line 1992: }
Line 1993:
Line 1994: return strName;
Line 1995: }
Line 1996:
Line 1997:
Line 1998: string col_name_by_index(int indexColumn)
Line 1999: {
Line 2000: string header = string.Empty;
Line 2001: if(Math.Abs(indexColumn)==EXAM_LINK_COLUMN_INDEX)
Line 2002: {
Line 2003:
Line 2004: if (language == HEBREW_LANG.ToString())
Line 2005: header = "מטלת סיום";
Line 2006: else
Line 2007: header = "Exam";
Line 2008: }
Line 2009:
Line 2010: else
Line 2011: if(Math.Abs(indexColumn)==SYLLABUS_LINK_COLUMN_INDEX)
Line 2012: {
Line 2013:
Line 2014: if (language == HEBREW_LANG.ToString())
Line 2015: header = "סילבוס";
Line 2016: else
Line 2017: header = "Syllabus";
Line 2018: }
Line 2019: else
Line 2020:
Line 2021: if(Math.Abs(indexColumn)==ALL_TEACHERS_COLUMN_INDEX)
Line 2022: {
Line 2023:
Line 2024: if (language == HEBREW_LANG.ToString())
Line 2025: header = "מרצים";
Line 2026: else
Line 2027: header = "Lecturers";
Line 2028: }
Line 2029: else
Line 2030: if(Math.Abs(indexColumn)==CONNECT_ROOM_HOUSE_INDEX)
Line 2031: {
Line 2032:
Line 2033: if(language==HEBREW_LANG.ToString())
Line 2034: header="חדר ובניין";
Line 2035: else
Line 2036: header="RoomHouse";
Line 2037:
Line 2038: }
Line 2039: else
Line 2040: if(Math.Abs(indexColumn)==CONNECT_HOURS_INDEX)
Line 2041: {
Line 2042:
Line 2043: if(language==HEBREW_LANG.ToString())
Line 2044: header="שעות";
Line 2045: else
Line 2046: header="hours";
Line 2047:
Line 2048: }
Line 2049: else
Line 2050: if(Math.Abs(indexColumn)==CONNECT_DATONS_INDEX)
Line 2051: {
Line 2052: if(language==HEBREW_LANG.ToString())
Line 2053: header="תאריכים";
Line 2054: else
Line 2055: header="dates";
Line 2056: }
Line 2057: else
Line 2058: if(Math.Abs(indexColumn)==SEM_COLUMN_INDEX)
Line 2059: {
Line 2060: if (language == HEBREW_LANG.ToString())
Line 2061: header = GetColName(Math.Abs(indexColumn));
Line 2062: else
Line 2063: header = "Semester";
Line 2064: }
Line 2065: else
Line 2066: if(Math.Abs(indexColumn)==CID_COLUMN_INDEX)
Line 2067: {
Line 2068: if (language == HEBREW_LANG.ToString())
Line 2069: header = GetColName(Math.Abs(indexColumn));
Line 2070: else
Line 2071: header = "CourseID";
Line 2072: }
Line 2073:
Line 2074: else
Line 2075: if(Math.Abs(indexColumn)==NAME_COLUMN_INDEX)
Line 2076: {
Line 2077: if (language == HEBREW_LANG.ToString())
Line 2078: header = GetColName(Math.Abs(indexColumn));
Line 2079: else
Line 2080: header = "Course Name";
Line 2081: }
Line 2082: else
Line 2083: if(Math.Abs(indexColumn)==METHOD_COLUMN_INDEX)
Line 2084: {
Line 2085: if (language == HEBREW_LANG.ToString())
Line 2086: header = GetColName(Math.Abs(indexColumn));
Line 2087: else
Line 2088: header = "Method";
Line 2089: }
Line 2090: else
Line 2091: if(Math.Abs(indexColumn)==WKD_COLUMN_INDEX)
Line 2092: {
Line 2093: if (language == HEBREW_LANG.ToString())
Line 2094: header = GetColName(Math.Abs(indexColumn));
Line 2095: else
Line 2096: header = "Day";
Line 2097: }
Line 2098: else
Line 2099: if(Math.Abs(indexColumn)==NROOM_COLUMN_INDEX)
Line 2100: {
Line 2101: if (language == HEBREW_LANG.ToString())
Line 2102: header = GetColName(Math.Abs(indexColumn));
Line 2103: else
Line 2104: header = "Room";
Line 2105: }
Line 2106: else
Line 2107: if(Math.Abs(indexColumn)==NHOUSE_COLUMN_INDEX)
Line 2108: {
Line 2109: if (language == HEBREW_LANG.ToString())
Line 2110: header = GetColName(Math.Abs(indexColumn));
Line 2111: else
Line 2112: header = "Building";
Line 2113: }
Line 2114: else
Line 2115: if(Math.Abs(indexColumn)==REMARK_COLUMN_INDEX)
Line 2116: {
Line 2117: if (language == HEBREW_LANG.ToString())
Line 2118: header = GetColName(Math.Abs(indexColumn));
Line 2119: else
Line 2120: header = "Remark";
Line 2121: }
Line 2122: else
Line 2123:
Line 2124:
Line 2125: {
Line 2126:
Line 2127: header = GetColName(Math.Abs(indexColumn));
Line 2128:
Line 2129:
Line 2130:
Line 2131: }
Line 2132:
Line 2133:
Line 2134:
Line 2135:
Line 2136: return header;
Line 2137: }
Line 2138:
Line 2139:
Line 2140:
Line 2141: string GetNeto(string _indexColumn)
Line 2142: {
Line 2143: if (_indexColumn.Trim() == "") return "";
Line 2144: string str =_indexColumn.ToString();
Line 2145: str = str.Replace("*","");
Line 2146: str = str.Replace("-","");
Line 2147:
Line 2148: return str;
Line 2149: }
Line 2150:
Line 2151: //---------------------------------------------------------------------------------
Line 2152: string GetFiledName(int index)
Line 2153: {
Line 2154: string str =string.Empty;
Line 2155: switch(index)
Line 2156: {
Line 2157: case CID_COLUMN_INDEX: str="cid";break;
Line 2158: case FACULTY_COLUMN_INDEX: str="faculty";break;
Line 2159: case SEM_COLUMN_INDEX: str="sem";break;
Line 2160: case PHASE_COLUMN_INDEX: str="phase";break;
Line 2161: case NAME_COLUMN_INDEX: str="name";break;
Line 2162: case METHOD_COLUMN_INDEX: str="method";break;
Line 2163: case WKD_COLUMN_INDEX: str="wkd";break;
Line 2164: case HOMIN1_COLUMN_INDEX: str="homin1";break;
Line 2165: case HOMIN2_COLUMN_INDEX: str="homin2";break;
Line 2166: case ROOM_COLUMN_INDEX: str="room";break;
Line 2167: case NROOM_COLUMN_INDEX: str="Nroom";break;
Line 2168: case NHOUSE_COLUMN_INDEX: str="Nhouse";break;
Line 2169:
Line 2170: case ROOM_NUM_COLUMN_INDEX: str="room_num";break;
Line 2171: case DURA_COLUMN_INDEX: str="dura";break;
Line 2172: case REMARK_COLUMN_INDEX: str="remark";break;
Line 2173: case T1_COLUMN_INDEX: str="t1";break;
Line 2174: case T1ID_COLUMN_INDEX: str="t1idnum";break;
Line 2175: case T2_COLUMN_INDEX: str="t2";break;
Line 2176: case T2ID_COLUMN_INDEX: str="t2idnum";break;
Line 2177: case T3_COLUMN_INDEX: str="t3";break;
Line 2178: case T3ID_COLUMN_INDEX: str="t3idnum";break;
Line 2179: case T4_COLUMN_INDEX: str="t4";break;
Line 2180: case T4ID_COLUMN_INDEX: str="t4idnum";break;
Line 2181: case T5_COLUMN_INDEX: str="t5";break;
Line 2182: case T5ID_COLUMN_INDEX: str="t5idnum";break;
Line 2183: case DOCO_COLUMN_INDEX: str="doco";break;
Line 2184: case EXPECTED_COLUMN_INDEX: str="expected";break;
Line 2185: case ENLISTED_COLUMN_INDEX: str="enlisted";break;
Line 2186: case NUT_COLUMN_INDEX: str="ntu";break;
Line 2187: case HOUSE_COLUMN_INDEX: str="house";break;
Line 2188: case LAMP_COLUMN_INDEX: str="lamps";break;
Line 2189: case PRF_COLUMN_INDEX: str="prf";break;
Line 2190: case INORLIS_COLUMN_INDEX: str="inorlis";break;
Line 2191: case MMF_COLUMN_INDEX: str="mmf";break;
Line 2192: case SHAS_COLUMN_INDEX: str="shas";break;
Line 2193: case SHASTYPE_COLUMN_INDEX: str="shastype";break;
Line 2194: case HSF_COLUMN_INDEX: str="hsf";break;
Line 2195: case PARASIT_COLUMN_INDEX: str="parasit";break;
Line 2196: case LEADER_COLUMN_INDEX: str="leader";break;
Line 2197: case EXCLA_COLUMN_INDEX: str="excla";break;
Line 2198: case BUNCH1_COLUMN_INDEX: str="bunch1";break;
Line 2199: case BUNCH2_COLUMN_INDEX: str="bunch2";break;
Line 2200: case BUNCH3_COLUMN_INDEX: str="bunch3";break;
Line 2201: case BUNCH4_COLUMN_INDEX: str="bunch4";break;
Line 2202: case BUNCH5_COLUMN_INDEX: str="bunch5";break;
Line 2203: case BUNCH6_COLUMN_INDEX: str="bunch6";break;
Line 2204: case BUNCH7_COLUMN_INDEX: str="bunch7";break;
Line 2205: case BUNCH8_COLUMN_INDEX: str="bunch8";break;
Line 2206: case BUNCH9_COLUMN_INDEX: str="bunch9";break;
Line 2207: case BUNCH10_COLUMN_INDEX: str="bunch10";break;
Line 2208: case BUNCH11_COLUMN_INDEX: str="bunch11";break;
Line 2209: case BUNCH12_COLUMN_INDEX: str="bunch12";break;
Line 2210: case BUNCH13_COLUMN_INDEX: str="bunch13";break;
Line 2211: case BUNCH14_COLUMN_INDEX: str="bunch14";break;
Line 2212: case BUNCH15_COLUMN_INDEX: str="bunch15";break;
Line 2213: case BUNCH16_COLUMN_INDEX: str="bunch16";break;
Line 2214: case BUNCH17_COLUMN_INDEX: str="bunch17";break;
Line 2215: case BUNCH18_COLUMN_INDEX: str="bunch18";break;
Line 2216: case BUNCH19_COLUMN_INDEX: str="bunch19";break;
Line 2217: case BUNCH20_COLUMN_INDEX: str="bunch20";break;
Line 2218: case DATON1_COLUMN_INDEX: str="daton1";break;
Line 2219: case DATON2_COLUMN_INDEX: str="daton2";break;
Line 2220: case LOCHED_COLUMN_INDEX: str="locked";break;
Line 2221: case GILA_FLAG_COLUMN_INDEX: str="gila_flag";break;
Line 2222: case WEEKS_LONG1_COLUMN_INDEX: str="weeks_long1";break;
Line 2223: case WEEKS_LONG2_COLUMN_INDEX: str="weeks_long2";break;
Line 2224: //case ZAMAK_TYPE_COLUMN_INDEX: str="period";break;
Line 2225: case CONNECT_ROOM_HOUSE_INDEX:str="Nroom";break;
Line 2226: case CONNECT_HOURS_INDEX:str="hours";break;
Line 2227:
Line 2228:
Line 2229: case ALL_TEACHERS_COLUMN_INDEX:str="teachers";break;
Line 2230:
Line 2231: case EXAM_LINK_COLUMN_INDEX:str="exam";break;
Line 2232: case SYLLABUS_LINK_COLUMN_INDEX:str="syllabus";break;
Line 2233:
Line 2234:
Line 2235: default: str ="cid";break;
Line 2236: }
Line 2237:
Line 2238: return str;
Line 2239:
Line 2240: }
Line 2241:
Line 2242:
Line 2243: string GetStrDura(string dura)
Line 2244: {
Line 2245: int _int = 0; bool res = false; string _str = "";
Line 2246:
Line 2247: res = int.TryParse(dura, out _int);
Line 2248: if (!res)
Line 2249: {
Line 2250: //Response.Write("db_num not in format. aborting...");
Line 2251: //Response.End();
Line 2252: return dura;
Line 2253: }
Line 2254: else
Line 2255: {
Line 2256: int d=Convert.ToInt32(dura);
Line 2257: if(d<=0)
Line 2258: return "";
Line 2259: else
Line 2260: if(d>=5000)
Line 2261: {
Line 2262: d=d-5000;
Line 2263: d=d*60;
Line 2264: }
Line 2265:
Line 2266: string h = (d/60).ToString();
Line 2267: string m = (d%60).ToString();
Line 2268:
Line 2269: string st=h;
Line 2270: st+=":";
Line 2271: while(m.Length<2)
Line 2272: m="0"+m;
Line 2273: st+=m;
Line 2274:
Line 2275: return st;
Line 2276:
Line 2277: }
Line 2278:
Line 2279: return dura;
Line 2280: }
Line 2281:
Line 2282:
Line 2283: string GetDatetimeText(string str, bool homins)
Line 2284: {
Line 2285: if (str.Trim() == "" || str == "null") return "";
Line 2286:
Line 2287: string[] parts = str.Split(' ');
Line 2288: string[] value_parts;
Line 2289: if (homins)
Line 2290: {
Line 2291: value_parts = parts[1].Split(':');
Line 2292: return value_parts[0] + ":" + value_parts[1];
Line 2293: }
Line 2294: if (!homins)
Line 2295: {
Line 2296: value_parts = parts[0].Split('\\');
Line 2297: return value_parts[1] + "\\" + value_parts[0] + "\\" + value_parts[2];
Line 2298: }
Line 2299:
Line 2300:
Line 2301: return str;
Line 2302: }
Line 2303:
Line 2304: string GetDayText(string str)
Line 2305: {
Line 2306:
Line 2307: if(str.IndexOf("1")>-1) return "א";
Line 2308: if(str.IndexOf("2")>-1) return "ב";
Line 2309: if(str.IndexOf("3")>-1) return "ג";
Line 2310: if(str.IndexOf("4")>-1) return "ד";
Line 2311: if(str.IndexOf("5")>-1) return "ה";
Line 2312: if(str.IndexOf("6")>-1) return "ו";
Line 2313: return "";
Line 2314: }
Line 2315: string GetDayIndex(string str)
Line 2316: {
Line 2317:
Line 2318: if(str.IndexOf("א")>-1) return "1";
Line 2319: if(str.IndexOf("ב")>-1) return "2";
Line 2320: if(str.IndexOf("ג")>-1) return "3";
Line 2321: if(str.IndexOf("ד")>-1) return "4";
Line 2322: if(str.IndexOf("ה")>-1) return "5";
Line 2323: if(str.IndexOf("ו")>-1) return "6";
Line 2324: return "-1";
Line 2325: }
Line 2326: //-------------------------------
Line 2327: string GetStrData(string str)
Line 2328: {
Line 2329: if(str=="null"|| str=="-1")
Line 2330: return "";
Line 2331: else
Line 2332: return str;
Line 2333: }
Line 2334:
Line 2335:
Line 2336: string[] LoadLineData(SqlDataReader rs)
Line 2337: {
Line 2338:
Line 2339: string[] tts_data_arr=new string[120];
Line 2340: int i;
Line 2341: tts_data_arr[CID_COLUMN_INDEX]=GetStrData(rs["cid"].ToString());
Line 2342: tts_data_arr[PHASE_COLUMN_INDEX]=GetStrData(rs["phase"].ToString());
Line 2343: tts_data_arr[FACULTY_COLUMN_INDEX]=GetStrData(rs["faculty"].ToString());
Line 2344: tts_data_arr[METHOD_COLUMN_INDEX]=GetStrData(rs["method"].ToString());
Line 2345: tts_data_arr[SEM_COLUMN_INDEX]=GetStrData(rs["sem"].ToString());
Line 2346: tts_data_arr[WKD_COLUMN_INDEX]=GetStrData(rs["wkd"].ToString());
Line 2347: tts_data_arr[T1_COLUMN_INDEX]=GetStrData(rs["t1"].ToString());
Line 2348: tts_data_arr[T2_COLUMN_INDEX]=GetStrData(rs["t2"].ToString());
Line 2349: tts_data_arr[T3_COLUMN_INDEX]=GetStrData(rs["t3"].ToString());
Line 2350: tts_data_arr[T4_COLUMN_INDEX]=GetStrData(rs["t4"].ToString());
Line 2351: tts_data_arr[T5_COLUMN_INDEX]=GetStrData(rs["t5"].ToString());
Line 2352: tts_data_arr[NAME_COLUMN_INDEX]=GetStrData(rs["name"].ToString());
Line 2353: tts_data_arr[HOMIN1_COLUMN_INDEX]=GetStrData(rs["homin1"].ToString());
Line 2354: tts_data_arr[HOMIN2_COLUMN_INDEX]=GetStrData(rs["homin2"].ToString());
Line 2355: tts_data_arr[ROOM_COLUMN_INDEX]=GetStrData(rs["room"].ToString());
Line 2356: tts_data_arr[NROOM_COLUMN_INDEX]=GetStrData(rs["nroom"].ToString());
Line 2357: tts_data_arr[HOUSE_COLUMN_INDEX]=GetStrData(rs["house"].ToString());
Line 2358: tts_data_arr[NHOUSE_COLUMN_INDEX]=GetStrData(rs["nhouse"].ToString());
Line 2359: tts_data_arr[ROOM_NUM_COLUMN_INDEX]=GetStrData(rs["room_num"].ToString());
Line 2360: tts_data_arr[DURA_COLUMN_INDEX]=GetStrDura(rs["dura"].ToString());
Line 2361: tts_data_arr[REMARK_COLUMN_INDEX]=GetStrData(rs["remark"].ToString());
Line 2362: tts_data_arr[SHAS_COLUMN_INDEX]=GetStrData(rs["shas"].ToString());
Line 2363: tts_data_arr[SHASTYPE_COLUMN_INDEX]=GetStrData(rs["shastype"].ToString());
Line 2364:
Line 2365: tts_data_arr[BUNCH1_COLUMN_INDEX]=GetStrData(rs["bunch1"].ToString());
Line 2366: tts_data_arr[BUNCH2_COLUMN_INDEX]=GetStrData(rs["bunch2"].ToString());
Line 2367: tts_data_arr[BUNCH3_COLUMN_INDEX]=GetStrData(rs["bunch3"].ToString());
Line 2368: tts_data_arr[BUNCH4_COLUMN_INDEX]=GetStrData(rs["bunch4"].ToString());
Line 2369: tts_data_arr[BUNCH5_COLUMN_INDEX]=GetStrData(rs["bunch5"].ToString());
Line 2370: tts_data_arr[BUNCH6_COLUMN_INDEX]=GetStrData(rs["bunch6"].ToString());
Line 2371: tts_data_arr[BUNCH7_COLUMN_INDEX]=GetStrData(rs["bunch7"].ToString());
Line 2372: tts_data_arr[BUNCH8_COLUMN_INDEX]=GetStrData(rs["bunch8"].ToString());
Line 2373: tts_data_arr[BUNCH9_COLUMN_INDEX]=GetStrData(rs["bunch9"].ToString());
Line 2374: tts_data_arr[BUNCH10_COLUMN_INDEX]=GetStrData(rs["bunch10"].ToString());
Line 2375: tts_data_arr[BUNCH11_COLUMN_INDEX]=GetStrData(rs["bunch11"].ToString());
Line 2376: tts_data_arr[BUNCH12_COLUMN_INDEX]=GetStrData(rs["bunch12"].ToString());
Line 2377: tts_data_arr[BUNCH13_COLUMN_INDEX]=GetStrData(rs["bunch13"].ToString());
Line 2378: tts_data_arr[BUNCH14_COLUMN_INDEX]=GetStrData(rs["bunch14"].ToString());
Line 2379: tts_data_arr[BUNCH15_COLUMN_INDEX]=GetStrData(rs["bunch15"].ToString());
Line 2380: tts_data_arr[BUNCH16_COLUMN_INDEX]=GetStrData(rs["bunch16"].ToString());
Line 2381: tts_data_arr[BUNCH17_COLUMN_INDEX]=GetStrData(rs["bunch17"].ToString());
Line 2382: tts_data_arr[BUNCH18_COLUMN_INDEX]=GetStrData(rs["bunch18"].ToString());
Line 2383: tts_data_arr[BUNCH19_COLUMN_INDEX]=GetStrData(rs["bunch19"].ToString());
Line 2384: tts_data_arr[BUNCH20_COLUMN_INDEX]=GetStrData(rs["bunch20"].ToString());
Line 2385:
Line 2386:
Line 2387:
Line 2388: /*
Line 2389:
Line 2390:
Line 2391:
Line 2392: tts_data_arr[T1_COLUMN_INDEX]=GetStrData(String(rs.Fields("t1")));
Line 2393: tts_data_arr[T1ID_COLUMN_INDEX]=GetStrData(String(rs.Fields("t1idnum")));
Line 2394: tts_data_arr[T2_COLUMN_INDEX]=GetStrData(String(rs.Fields("t2")));
Line 2395: tts_data_arr[T2ID_COLUMN_INDEX]=GetStrData(String(rs.Fields("t2idnum")));
Line 2396: tts_data_arr[T3_COLUMN_INDEX]=GetStrData(String(rs.Fields("t3")));
Line 2397: tts_data_arr[T3ID_COLUMN_INDEX]=GetStrData(String(rs.Fields("t3idnum")));
Line 2398: tts_data_arr[T4_COLUMN_INDEX]=GetStrData(String(rs.Fields("t4")));
Line 2399: tts_data_arr[T4ID_COLUMN_INDEX]=GetStrData(String(rs.Fields("t4idnum")));
Line 2400: tts_data_arr[T5_COLUMN_INDEX]=GetStrData(String(rs.Fields("t5")));
Line 2401: tts_data_arr[T5ID_COLUMN_INDEX]=GetStrData(String(rs.Fields("t5idnum")));
Line 2402:
Line 2403: tts_data_arr[DOCO_COLUMN_INDEX]=GetStrData(String(rs.Fields("doco")));
Line 2404: tts_data_arr[EXPECTED_COLUMN_INDEX]=GetStrData(String(rs.Fields("expected")));
Line 2405: tts_data_arr[ENLISTED_COLUMN_INDEX]=GetStrData(String(rs.Fields("enlisted")));
Line 2406: tts_data_arr[NUT_COLUMN_INDEX]=GetStrData(String(rs.Fields("ntu")));
Line 2407: tts_data_arr[HOUSE_COLUMN_INDEX]=GetStrData(String(rs.Fields("house")));
Line 2408: tts_data_arr[LAMP_COLUMN_INDEX]=GetStrData(String(rs.Fields("lamps")));
Line 2409: tts_data_arr[PRF_COLUMN_INDEX]=GetStrData(String(rs.Fields("prf")));
Line 2410: tts_data_arr[INORLIS_COLUMN_INDEX]=GetStrData(String(rs.Fields("inorlis")));
Line 2411: tts_data_arr[MMF_COLUMN_INDEX]=GetStrData(String(rs.Fields("mmf")));
Line 2412: tts_data_arr[HSF_COLUMN_INDEX]=GetStrData(String(rs.Fields("hsf")));
Line 2413: tts_data_arr[PARASIT_COLUMN_INDEX]=GetStrData(String(rs.Fields("parasit")));
Line 2414: tts_data_arr[LEADER_COLUMN_INDEX]=GetStrData(String(rs.Fields("leader")));
Line 2415: tts_data_arr[EXCLA_COLUMN_INDEX]=GetStrData(String(rs.Fields("excla")));
Line 2416: tts_data_arr[BUNCH1_COLUMN_INDEX]=GetStrData(String(rs.Fields("bunch1")));
Line 2417: tts_data_arr[BUNCH2_COLUMN_INDEX]=GetStrData(String(rs.Fields("bunch2")));
Line 2418: tts_data_arr[BUNCH3_COLUMN_INDEX]=GetStrData(String(rs.Fields("bunch3")));
Line 2419: tts_data_arr[BUNCH4_COLUMN_INDEX]=GetStrData(String(rs.Fields("bunch4")));
Line 2420: tts_data_arr[BUNCH5_COLUMN_INDEX]=GetStrData(String(rs.Fields("bunch5")));
Line 2421: tts_data_arr[BUNCH6_COLUMN_INDEX]=GetStrData(String(rs.Fields("bunch6")));
Line 2422: tts_data_arr[BUNCH7_COLUMN_INDEX]=GetStrData(String(rs.Fields("bunch7")));
Line 2423: tts_data_arr[BUNCH8_COLUMN_INDEX]=GetStrData(String(rs.Fields("bunch8")));
Line 2424: tts_data_arr[BUNCH9_COLUMN_INDEX]=GetStrData(String(rs.Fields("bunch9")));
Line 2425: tts_data_arr[BUNCH10_COLUMN_INDEX]=GetStrData(String(rs.Fields("bunch10")));
Line 2426: tts_data_arr[BUNCH11_COLUMN_INDEX]=GetStrData(String(rs.Fields("bunch11")));
Line 2427: tts_data_arr[BUNCH12_COLUMN_INDEX]=GetStrData(String(rs.Fields("bunch12")));
Line 2428: tts_data_arr[BUNCH13_COLUMN_INDEX]=GetStrData(String(rs.Fields("bunch13")));
Line 2429: tts_data_arr[BUNCH14_COLUMN_INDEX]=GetStrData(String(rs.Fields("bunch14")));
Line 2430: tts_data_arr[BUNCH15_COLUMN_INDEX]=GetStrData(String(rs.Fields("bunch15")));
Line 2431: tts_data_arr[BUNCH16_COLUMN_INDEX]=GetStrData(String(rs.Fields("bunch16")));
Line 2432: tts_data_arr[BUNCH17_COLUMN_INDEX]=GetStrData(String(rs.Fields("bunch17")));
Line 2433: tts_data_arr[BUNCH18_COLUMN_INDEX]=GetStrData(String(rs.Fields("bunch18")));
Line 2434: tts_data_arr[BUNCH19_COLUMN_INDEX]=GetStrData(String(rs.Fields("bunch19")));
Line 2435: tts_data_arr[BUNCH20_COLUMN_INDEX]=GetStrData(String(rs.Fields("bunch20")));
Line 2436: tts_data_arr[DATON1_COLUMN_INDEX]=GetStrDate_date(String(rs.Fields("daton1")));
Line 2437: tts_data_arr[DATON2_COLUMN_INDEX]=GetStrDate_date(String(rs.Fields("daton2")));
Line 2438: tts_data_arr[LOCHED_COLUMN_INDEX]=GetStrData(String(rs.Fields("locked")));
Line 2439: tts_data_arr[GILA_FLAG_COLUMN_INDEX]=GetStrData(String(rs.Fields("gila_flag")));
Line 2440: tts_data_arr[WEEKS_LONG1_COLUMN_INDEX]=GetStrData(String(rs.Fields("weeks_long1")));
Line 2441: tts_data_arr[WEEKS_LONG2_COLUMN_INDEX]=GetStrData(String(rs.Fields("weeks_long2")));
Line 2442: //tts_data_arr[ZAMAK_TYPE_COLUMN_INDEX]=GetStrData(String(rs.Fields("zamak_type")));
Line 2443:
Line 2444: // 201212 - english
Line 2445: tts_data_arr[SEMESTER_ENGLISH_COLUMN_INDEX]=GetStrData(String(rs.Fields("sem_eng")));
Line 2446: tts_data_arr[NHOUSE_ENGLISH_COLUMN_INDEX]=GetStrData(String(rs.Fields("Nhouse_eng")));
Line 2447: tts_data_arr[METHOD_ENGLISH_COLUMN_INDEX]=GetStrData(String(rs.Fields("method_eng")));
Line 2448: tts_data_arr[WKD_ENGLISH_COLUMN_INDEX]=GetStrData(String(rs.Fields("wkd_eng")));
Line 2449: */
Line 2450: return tts_data_arr;
Line 2451: }
Line 2452:
Line 2453:
Line 2454: //----------------------------------------------------------------------------------
Line 2455:
Line 2456: string utf8ToWin(string str)
Line 2457: {
Line 2458: //return str;
Line 2459: str = "%FA%E5%E0%F8%20%F9%F0%E9%20%F2%E9%E5%F0%E9%20-%20%EE%F1%EC%E5%EC%20%EE%F1%E7%F8%E9-%E0%E6%F8%E7%E9";
Line 2460: return HttpUtility.UrlDecode(str);
Line 2461: }
Line 2462:
Line 2463: /*
Line 2464: string utf8ToWin(String str)
Line 2465: //%FA%E5%E0%F8%20%F9%F0%E9%20%F2%E9%E5%F0%E9%20-%20%EE%F1%EC%E5%EC%20%EE%F1%E7%F8%E9-%E0%E6%F8%E7%E9
Line 2466: {
Line 2467: //var uch = String.fromCharCode(1523);
Line 2468: string uch = new string(char[],1523)
Line 2469:
Line 2470: str = replaceAll(str,uch+String.fromCharCode(144),"א");
Line 2471: str = replaceAll(str,uch+String.fromCharCode(8216),"ב");
Line 2472: str = replaceAll(str,uch+String.fromCharCode(8217),"ג");
Line 2473: str = replaceAll(str,uch+String.fromCharCode(8220),"ד");
Line 2474: str = replaceAll(str,uch+String.fromCharCode(8221),"ה");
Line 2475: str = replaceAll(str,uch+String.fromCharCode(8226),"ו");
Line 2476: str = replaceAll(str,uch+String.fromCharCode(8211),"ז");
Line 2477: str = replaceAll(str,uch+String.fromCharCode(8212),"ח");
Line 2478: str = replaceAll(str,uch+String.fromCharCode(732),"ט");
Line 2479: str = replaceAll(str,uch+String.fromCharCode(8482),"י");
Line 2480: str = replaceAll(str,uch+String.fromCharCode(8250),"כ");
Line 2481: str = replaceAll(str,uch+String.fromCharCode(154),"ך");
Line 2482: str = replaceAll(str,uch+String.fromCharCode(156),"ל");
Line 2483: str = replaceAll(str,uch+String.fromCharCode(158),"מ");
Line 2484: str = replaceAll(str,uch+String.fromCharCode(157),"ם");
Line 2485: str = replaceAll(str,uch+String.fromCharCode(160),"נ");
Line 2486: str = replaceAll(str,uch+String.fromCharCode(159),"ן");
Line 2487: str = replaceAll(str,uch+String.fromCharCode(161),"ס");
Line 2488: str = replaceAll(str,uch+String.fromCharCode(162),"ע");
Line 2489: str = replaceAll(str,uch+String.fromCharCode(8362),"פ");
Line 2490: str = replaceAll(str,uch+String.fromCharCode(163),"ף");
Line 2491: str = replaceAll(str,uch+String.fromCharCode(166),"צ");
Line 2492: str = replaceAll(str,uch+String.fromCharCode(165),"ץ");
Line 2493: str = replaceAll(str,uch+String.fromCharCode(167),"ק");
Line 2494: str = replaceAll(str,uch+String.fromCharCode(168),"ר");
Line 2495: str = replaceAll(str,uch+String.fromCharCode(169),"ש");
Line 2496: str = replaceAll(str,uch+String.fromCharCode(215),"ת");
Line 2497:
Line 2498: return str;
Line 2499: }
Line 2500:
Line 2501: */
Line 2502:
Line 2503:
Line 2504:
Line 2505: #line default
Line 2506: #line hidden
Line 2507:
Line 2508:
Line 2509: [System.Diagnostics.DebuggerNonUserCodeAttribute()]
Line 2510: public listcss_aspx() {
Line 2511: string[] dependencies;
Line 2512: ((global::System.Web.UI.Page)(this)).AppRelativeVirtualPath = "~/listcss.aspx";
Line 2513: if ((global::ASP.listcss_aspx.@__initialized == false)) {
Line 2514: global::ASP.listcss_aspx.@__stringResource = this.ReadStringResource();
Line 2515: dependencies = new string[1];
Line 2516: dependencies[0] = "~/listcss.aspx";
Line 2517: global::ASP.listcss_aspx.@__fileDependencies = this.GetWrappedFileDependencies(dependencies);
Line 2518: global::ASP.listcss_aspx.@__initialized = true;
Line 2519: }
Line 2520: this.Server.ScriptTimeout = 30000000;
Line 2521: }
Line 2522:
Line 2523: protected System.Web.Profile.DefaultProfile Profile {
Line 2524: get {
Line 2525: return ((System.Web.Profile.DefaultProfile)(this.Context.Profile));
Line 2526: }
Line 2527: }
Line 2528:
Line 2529: protected System.Web.HttpApplication ApplicationInstance {
Line 2530: get {
Line 2531: return ((System.Web.HttpApplication)(this.Context.ApplicationInstance));
Line 2532: }
Line 2533: }
Line 2534:
Line 2535: [System.Diagnostics.DebuggerNonUserCodeAttribute()]
Line 2536: private global::System.Web.UI.WebControls.Panel @__BuildControlmain_plh() {
Line 2537: global::System.Web.UI.WebControls.Panel @__ctrl;
Line 2538:
Line 2539: #line 2431 "E:\rootBoard\listcss.aspx"
Line 2540: @__ctrl = new global::System.Web.UI.WebControls.Panel();
Line 2541:
Line 2542: #line default
Line 2543: #line hidden
Line 2544: this.main_plh = @__ctrl;
Line 2545: @__ctrl.ApplyStyleSheetSkin(this);
Line 2546:
Line 2547: #line 2431 "E:\rootBoard\listcss.aspx"
Line 2548: @__ctrl.ID = "main_plh";
Line 2549:
Line 2550: #line default
Line 2551: #line hidden
Line 2552: return @__ctrl;
Line 2553: }
Line 2554:
Line 2555: [System.Diagnostics.DebuggerNonUserCodeAttribute()]
Line 2556: private global::System.Web.UI.HtmlControls.HtmlForm @__BuildControlform1() {
Line 2557: global::System.Web.UI.HtmlControls.HtmlForm @__ctrl;
Line 2558:
Line 2559: #line 2420 "E:\rootBoard\listcss.aspx"
Line 2560: @__ctrl = new global::System.Web.UI.HtmlControls.HtmlForm();
Line 2561:
Line 2562: #line default
Line 2563: #line hidden
Line 2564: this.form1 = @__ctrl;
Line 2565:
Line 2566: #line 2420 "E:\rootBoard\listcss.aspx"
Line 2567: @__ctrl.ID = "form1";
Line 2568:
Line 2569: #line default
Line 2570: #line hidden
Line 2571: global::System.Web.UI.WebControls.Panel @__ctrl1;
Line 2572:
Line 2573: #line 2420 "E:\rootBoard\listcss.aspx"
Line 2574: @__ctrl1 = this.@__BuildControlmain_plh();
Line 2575:
Line 2576: #line default
Line 2577: #line hidden
Line 2578: System.Web.UI.IParserAccessor @__parser = ((System.Web.UI.IParserAccessor)(@__ctrl));
Line 2579:
Line 2580: #line 2420 "E:\rootBoard\listcss.aspx"
Line 2581: @__parser.AddParsedSubObject(@__ctrl1);
Line 2582:
Line 2583: #line default
Line 2584: #line hidden
Line 2585: @__ctrl.SetRenderMethodDelegate(new System.Web.UI.RenderMethod(this.@__Renderform1));
Line 2586: return @__ctrl;
Line 2587: }
Line 2588:
Line 2589: private void @__Renderform1(System.Web.UI.HtmlTextWriter @__w, System.Web.UI.Control parameterContainer) {
Line 2590: @__w.Write(" \r\n <div id=\"main_div\" dir=\"");
Line 2591:
Line 2592: #line 2421 "E:\rootBoard\listcss.aspx"
Line 2593: @__w.Write(dir_t);
Line 2594:
Line 2595:
Line 2596: #line default
Line 2597: #line hidden
Line 2598: @__w.Write("\">\r\n ");
Line 2599:
Line 2600: #line 2422 "E:\rootBoard\listcss.aspx"
Line 2601: if (main_title.Length > 0) {
Line 2602:
Line 2603:
Line 2604: #line default
Line 2605: #line hidden
Line 2606: @__w.Write("\r\n <p align=");
Line 2607:
Line 2608: #line 2424 "E:\rootBoard\listcss.aspx"
Line 2609: @__w.Write(align_title);
Line 2610:
Line 2611:
Line 2612: #line default
Line 2613: #line hidden
Line 2614: @__w.Write(" class=\"titles main_title\" id=\"main_title\" >000</p>\r\n ");
Line 2615:
Line 2616: #line 2425 "E:\rootBoard\listcss.aspx"
Line 2617:
Line 2618: }
Line 2619: Response.Flush();
Line 2620:
Line 2621:
Line 2622: #line default
Line 2623: #line hidden
Line 2624: @__w.Write("\r\n\r\n <panel id=\"main_pnl\" class=\"main_pnl\"></panel>\r\n ");
Line 2625: parameterContainer.Controls[0].RenderControl(@__w);
Line 2626: @__w.Write("\r\n\r\n </div>\r\n\r\n ");
Line 2627: }
Line 2628:
Line 2629: [System.Diagnostics.DebuggerNonUserCodeAttribute()]
Line 2630: private global::System.Web.UI.HtmlControls.HtmlGenericControl @__BuildControlBODY() {
Line 2631: global::System.Web.UI.HtmlControls.HtmlGenericControl @__ctrl;
Line 2632:
Line 2633: #line 2415 "E:\rootBoard\listcss.aspx"
Line 2634: @__ctrl = new global::System.Web.UI.HtmlControls.HtmlGenericControl("body");
Line 2635:
Line 2636: #line default
Line 2637: #line hidden
Line 2638: this.BODY = @__ctrl;
Line 2639:
Line 2640: #line 2415 "E:\rootBoard\listcss.aspx"
Line 2641: ((System.Web.UI.IAttributeAccessor)(@__ctrl)).SetAttribute("class", "BODY");
Line 2642:
Line 2643: #line default
Line 2644: #line hidden
Line 2645:
Line 2646: #line 2415 "E:\rootBoard\listcss.aspx"
Line 2647: @__ctrl.ID = "BODY";
Line 2648:
Line 2649: #line default
Line 2650: #line hidden
Line 2651: System.Web.UI.IParserAccessor @__parser = ((System.Web.UI.IParserAccessor)(@__ctrl));
Line 2652:
Line 2653: #line 2415 "E:\rootBoard\listcss.aspx"
Line 2654: @__parser.AddParsedSubObject(new System.Web.UI.LiteralControl("\r\n\r\n\r\n\r\n\r\n "));
Line 2655:
Line 2656: #line default
Line 2657: #line hidden
Line 2658: global::System.Web.UI.HtmlControls.HtmlForm @__ctrl1;
Line 2659:
Line 2660: #line 2415 "E:\rootBoard\listcss.aspx"
Line 2661: @__ctrl1 = this.@__BuildControlform1();
Line 2662:
Line 2663: #line default
Line 2664: #line hidden
Line 2665:
Line 2666: #line 2415 "E:\rootBoard\listcss.aspx"
Line 2667: @__parser.AddParsedSubObject(@__ctrl1);
Line 2668:
Line 2669: #line default
Line 2670: #line hidden
Line 2671:
Line 2672: #line 2415 "E:\rootBoard\listcss.aspx"
Line 2673: @__parser.AddParsedSubObject(new System.Web.UI.LiteralControl("\r\n"));
Line 2674:
Line 2675: #line default
Line 2676: #line hidden
Line 2677: return @__ctrl;
Line 2678: }
Line 2679:
Line 2680: [System.Diagnostics.DebuggerNonUserCodeAttribute()]
Line 2681: private void @__BuildControlTree(listcss_aspx @__ctrl) {
Line 2682:
Line 2683: #line 1 "E:\rootBoard\listcss.aspx"
Line 2684: this.InitializeCulture();
Line 2685:
Line 2686: #line default
Line 2687: #line hidden
Line 2688: global::System.Web.UI.HtmlControls.HtmlGenericControl @__ctrl1;
Line 2689:
Line 2690: #line 1 "E:\rootBoard\listcss.aspx"
Line 2691: @__ctrl1 = this.@__BuildControlBODY();
Line 2692:
Line 2693: #line default
Line 2694: #line hidden
Line 2695: System.Web.UI.IParserAccessor @__parser = ((System.Web.UI.IParserAccessor)(@__ctrl));
Line 2696:
Line 2697: #line 1 "E:\rootBoard\listcss.aspx"
Line 2698: @__parser.AddParsedSubObject(@__ctrl1);
Line 2699:
Line 2700: #line default
Line 2701: #line hidden
Line 2702: @__ctrl.SetRenderMethodDelegate(new System.Web.UI.RenderMethod(this.@__Render__control1));
Line 2703: }
Line 2704:
Line 2705: private void @__Render__control1(System.Web.UI.HtmlTextWriter @__w, System.Web.UI.Control parameterContainer) {
Line 2706: @__w.Write("\r\n\r\n<!DOCTYPE html>\r\n<html lang=\"en\" xmlns=\"http://www.w3.org/1999/xhtml\">\r\n<head" +
Line 2707: ">\r\n<link rel=\"stylesheet\" type=\"text/css\" href=\"");
Line 2708:
Line 2709: #line 2330 "E:\rootBoard\listcss.aspx"
Line 2710: @__w.Write( css_url );
Line 2711:
Line 2712:
Line 2713: #line default
Line 2714: #line hidden
Line 2715: this.WriteUTF8ResourceString(@__w, 4871, 2514, false);
Line 2716: parameterContainer.Controls[0].RenderControl(@__w);
Line 2717: @__w.Write("\r\n <script type=\"text/javascript\">\r\n\t\t\r\n// this is the body onload\r\n\r\n\r\ndocume" +
Line 2718: "nt.querySelector(\"#main_title\").innerHTML = \"");
Line 2719:
Line 2720: #line 2442 "E:\rootBoard\listcss.aspx"
Line 2721: @__w.Write( _mtit );
Line 2722:
Line 2723:
Line 2724: #line default
Line 2725: #line hidden
Line 2726: @__w.Write("\";\r\n </script>\r\n</html>\r\n");
Line 2727: }
Line 2728:
Line 2729: [System.Diagnostics.DebuggerNonUserCodeAttribute()]
Line 2730: protected override void FrameworkInitialize() {
Line 2731: base.FrameworkInitialize();
Line 2732: this.SetStringResourcePointer(global::ASP.listcss_aspx.@__stringResource, 0);
Line 2733: this.@__BuildControlTree(this);
Line 2734: this.AddWrappedFileDependencies(global::ASP.listcss_aspx.@__fileDependencies);
Line 2735: }
Line 2736:
Line 2737: [System.Diagnostics.DebuggerNonUserCodeAttribute()]
Line 2738: public override int GetTypeHashCode() {
Line 2739: return 2093918503;
Line 2740: }
Line 2741:
Line 2742: [System.Diagnostics.DebuggerNonUserCodeAttribute()]
Line 2743: public override void ProcessRequest(System.Web.HttpContext context) {
Line 2744: base.ProcessRequest(context);
Line 2745: }
Line 2746: }
Line 2747: }
Line 2748:
|