/// <summary> /// 静态构造函数,创建路径 /// </summary> static ReportBase() { System.Web.HttpServerUtility Server = System.Web.HttpContext.Current.Server; if (Option.IsSendScriptFile) { string tempStr = Server.MapPath(_ScriptPath).Substring(Server.MapPath(@"\").Length).Split('\\')[0]; _ScriptPath = (string.Compare(tempStr, "Skyever", true) == 0?"":@"\" + tempStr) + @"\" + _ScriptPath; if (!System.IO.Directory.Exists(Server.MapPath(_ScriptPath))) { try { System.IO.Directory.CreateDirectory(Server.MapPath(_ScriptPath)); } catch { Option.IsSendScriptFile = false; } } } else { try { foreach (string fileName in System.IO.Directory.GetFiles(Server.MapPath(_ScriptPath), "*.js")) { System.IO.File.Delete(fileName); } } catch {} } }
/// <summary> /// 得到周计划的项目明细 /// </summary> /// <param name="f1"></param> /// <param name="saveFileName"></param> /// <returns></returns> public List <Tb_PlanDetailDD> GetWeekPlanDetailListByExcel(System.Web.UI.WebControls.FileUpload f1, ref String saveFileName) { List <Tb_PlanDetailDD> list1 = new List <Tb_PlanDetailDD>(); try { if (f1.HasFile) { System.Web.HttpServerUtility server = System.Web.HttpContext.Current.Server; saveFileName = "/Attachment/Plan/" + WebFrame.Util.JString.GetUnique32ID() + System.IO.Path.GetExtension(f1.FileName); String fname = server.MapPath(saveFileName); UExcel u1 = new UExcel(XlsFormat.Xls2003); f1.SaveAs(fname); DataSet ds1 = u1.XlsToDataSet(fname); DataTable dt1 = ds1.Tables[0]; /* * 分类/编号/计划内容/计划开始时间/计划结束时间/工作量预估(人天)/责任人/交付物/备注 */ for (int i = 2; i < dt1.Rows.Count; i++) { if (String.IsNullOrEmpty(dt1.Rows[i][1].ToString()) == false && String.IsNullOrEmpty(dt1.Rows[i][2].ToString()) == false) { Tb_PlanDetailDD dd1 = new Tb_PlanDetailDD(); dd1.PlanKind = dt1.Rows[i][0].ToString(); dd1.PlanNum = dt1.Rows[i][1].ToString(); dd1.PlanTitel = dt1.Rows[i][2].ToString(); dd1.BegTime = DateTime.Parse(dt1.Rows[i][3].ToString()); dd1.EndTime = DateTime.Parse(dt1.Rows[i][4].ToString()); dd1.Workload = double.Parse(dt1.Rows[i][5].ToString()); //设置责任人 String zren1 = dt1.Rows[i][6].ToString(); String zrenid = KORWeb.BUL.JUserBU.GetUserIDByUserName(zren1); dd1.ExecuteManID = zrenid; dd1.ExecuteManName = zren1; dd1.PayMemo = dt1.Rows[i][7].ToString(); dd1.Remark = dt1.Rows[i][8].ToString(); dd1.ParentNum = dd1.PlanNum.Substring(0, 3); //取前3位 dd1.MaonthPlanNum = dd1.PlanNum.Substring(0, 5); //取前5位 list1.Add(dd1); } } } } catch (Exception err) { list1.Clear(); } return(list1); }
/// <summary> /// 根据计划文件Excel得到计划明细的数据 /// </summary> /// <param name="f1"></param> /// <returns></returns> public List <Tb_PlanDetailDD> GetPlanDetailListByExcel(System.Web.UI.WebControls.FileUpload f1, ref String saveFileName) { List <Tb_PlanDetailDD> list1 = new List <Tb_PlanDetailDD>(); try { if (f1.HasFile) { System.Web.HttpServerUtility server = System.Web.HttpContext.Current.Server; saveFileName = "/Attachment/Plan/" + WebFrame.Util.JString.GetUnique32ID() + System.IO.Path.GetExtension(f1.FileName); String fname = server.MapPath(saveFileName); UExcel u1 = new UExcel(XlsFormat.Xls2003); f1.SaveAs(fname); DataSet ds1 = u1.XlsToDataSet(fname); DataTable dt1 = ds1.Tables[0]; /* * 分类/编号/计划内容/计划开始时间/计划结束时间/工作量预估(人天)/关键节点/交付物/备注 */ for (int i = 2; i < dt1.Rows.Count; i++) { if (String.IsNullOrEmpty(dt1.Rows[i][1].ToString()) == false && String.IsNullOrEmpty(dt1.Rows[i][2].ToString()) == false) { Tb_PlanDetailDD dd1 = new Tb_PlanDetailDD(); dd1.PlanKind = dt1.Rows[i][0].ToString(); dd1.PlanNum = dt1.Rows[i][1].ToString(); dd1.PlanTitel = dt1.Rows[i][2].ToString(); dd1.BegTime = DateTime.Parse(dt1.Rows[i][3].ToString()); dd1.EndTime = DateTime.Parse(dt1.Rows[i][4].ToString()); dd1.Workload = double.Parse(dt1.Rows[i][5].ToString()); dd1.KeyPlan = false; if (dt1.Rows[i][6].ToString() != String.Empty) { if (dt1.Rows[i][6].ToString() == "是" || dt1.Rows[i][6].ToString() == "1" || dt1.Rows[i][6].ToString().ToLower() == "yes" || dt1.Rows[i][6].ToString().ToLower() == "true") { dd1.KeyPlan = true; } } dd1.PayMemo = dt1.Rows[i][7].ToString(); dd1.Remark = dt1.Rows[i][8].ToString(); list1.Add(dd1); } } } } catch (Exception err) { list1.Clear(); } return(list1); }
public static void Log(string sData, System.Web.HttpServerUtility s) { try { string sPath = null; sPath = s.MapPath("usgd.log"); System.IO.StreamWriter sw = new System.IO.StreamWriter(sPath, true); sw.WriteLine(System.DateTime.Now.ToString() + ", " + sData); sw.Close(); } catch (Exception) { } }
public static void ErrorHandler(Exception Ex, string ModuleName, System.Web.HttpServerUtility Server) { if (Ex == null) { return; } string Msg = "Error Log: " + ModuleName + ": " + Ex.Message; try { Msg += " : " + Ex.Source + " : " + Ex.TargetSite.Name; } catch { } string FilePath = Server.MapPath(Layer01_Constants_Web.CnsLogPath); Do_Methods.LogWrite(Msg, FilePath); }
/// <summary>Read text file for markup code.</summary> public static String ReadTextFile(System.Web.HttpServerUtility server, string filePath, bool isReplaceCarraige) { string content = String.Empty; string path = server.MapPath(filePath); // Create StreamReader object. System.IO.Stream file = new System.IO.FileStream(path, System.IO.FileMode.Open, System.IO.FileAccess.Read, System.IO.FileShare.ReadWrite); System.IO.StreamReader streamReader = new System.IO.StreamReader(file); // Read the entire file into a string. content = streamReader.ReadToEnd(); // Replace carraige returns with markup code. if (isReplaceCarraige) { content = content.Replace("\r\n", "<br />"); } // Close StreamReader object. streamReader.Close(); // Return content. return(content); }
public Metadata(string uilang, System.Web.HttpServerUtility server) { if (uilang != "") { string path = server.MapPath("/loc/" + uilang + ".strings.txt"); if (File.Exists(path)) { StreamReader reader = new StreamReader(path); while (reader.Peek() > -1) { string[] line = reader.ReadLine().Split('\t'); if (line.Length > 1) { this.strings.Add(line[0].Replace("$", ""), line[1]); } } reader.Close(); } } this.languages = new List <Language>(); this.languages.Add(new Language("cs", "Czech", "česky", true)); this.languages.Add(new Language("cy", "Welsh", "Cymraeg", true)); this.languages.Add(new Language("de", "German", "Deutsch", true)); this.languages.Add(new Language("el", "Greek", "ελληνικά", true)); this.languages.Add(new Language("en", "English", "English", true)); this.languages.Add(new Language("es", "Spanish", "español", true)); this.languages.Add(new Language("fr", "French", "français", true)); this.languages.Add(new Language("fy", "Frisian", "Frysk", true)); this.languages.Add(new Language("ga", "Irish", "Gaeilge", true)); this.languages.Add(new Language("gd", "Scottish Gaelic", "Gàidhlig", true)); this.languages.Add(new Language("hr", "Croatian", "hrvatski", true)); this.languages.Add(new Language("hu", "Hungarian", "magyar", true)); this.languages.Add(new Language("nl", "Dutch", "Nederlands", true)); this.languages.Add(new Language("pl", "Polish", "polski", true)); this.languages.Add(new Language("sco", "Scots", "Scots", true)); this.languages.Add(new Language("fi", "Finnish", "suomi", true)); this.languages.Add(new Language("sq", "Albanian", "", false)); this.languages.Add(new Language("hy", "Armenian", "", false)); this.languages.Add(new Language("rup", "Aromanian", "", false)); this.languages.Add(new Language("ast", "Asturian", "", false)); this.languages.Add(new Language("eu", "Basque", "", false)); this.languages.Add(new Language("bg", "Bulgarian", "", false)); this.languages.Add(new Language("ca", "Catalan", "", false)); this.languages.Add(new Language("kw", "Cornish", "", false)); this.languages.Add(new Language("da", "Danish", "", false)); this.languages.Add(new Language("et", "Estonian", "", false)); this.languages.Add(new Language("fo", "Faroese", "", false)); this.languages.Add(new Language("gl", "Galician", "", false)); this.languages.Add(new Language("he", "Hebrew", "", false)); this.languages.Add(new Language("is", "Icelandic", "", false)); this.languages.Add(new Language("it", "Italian", "", false)); this.languages.Add(new Language("krl", "Karelian", "", false)); this.languages.Add(new Language("kom", "Komi", "", false)); this.languages.Add(new Language("la", "Latin", "", false)); this.languages.Add(new Language("lv", "Latvian", "", false)); this.languages.Add(new Language("lt", "Lithuanian", "", false)); this.languages.Add(new Language("lb", "Luxembourgish", "", false)); this.languages.Add(new Language("mk", "Macedonian", "", false)); this.languages.Add(new Language("mt", "Maltese", "", false)); this.languages.Add(new Language("gv", "Manx", "", false)); this.languages.Add(new Language("mord", "Mordvinian", "", false)); this.languages.Add(new Language("no", "Norwegian", "", false)); this.languages.Add(new Language("pt", "Portuguese", "", false)); this.languages.Add(new Language("ro", "Romanian", "", false)); this.languages.Add(new Language("rm", "Romansh", "", false)); this.languages.Add(new Language("ru", "Russian", "", false)); this.languages.Add(new Language("smi", "Sami", "", false)); this.languages.Add(new Language("sc", "Sardinian", "", false)); this.languages.Add(new Language("sr", "Serbian", "", false)); this.languages.Add(new Language("sk", "Slovak", "", false)); this.languages.Add(new Language("sl", "Slovene", "", false)); this.languages.Add(new Language("wen", "Sorbian", "", false)); this.languages.Add(new Language("sv", "Swedish", "", false)); this.languages.Add(new Language("tr", "Turkish", "", false)); this.languages.Add(new Language("uk", "Ukrainian", "", false)); this.languages.Add(new Language("vep", "Vepsian", "", false)); this.languages.Add(new Language("yi", "Yiddish", "", false)); this.languages.Add(new Language("br", "Breton", "", false)); this.languages.Add(new Language("lmo", "Lombard", "", false)); this.languages.Add(new Language("oc", "Occitan", "", false)); this.languages.Add(new Language("sqk", "Albanian Sign Language", "", false, true)); this.languages.Add(new Language("aen", "Armenian Sign Language", "", false, true)); this.languages.Add(new Language("asq", "Austrian Sign Language", "", false, true)); this.languages.Add(new Language("bfi", "British Sign Language", "", false, true)); this.languages.Add(new Language("bqn", "Bulgarian Sign Language", "", false, true)); this.languages.Add(new Language("csc", "Catalan Sign Language", "", false, true)); this.languages.Add(new Language("csq", "Croatia Sign Language", "", false, true)); this.languages.Add(new Language("cse", "Czech Sign Language", "", false, true)); this.languages.Add(new Language("dsl", "Danish Sign Language", "", false, true)); this.languages.Add(new Language("eso", "Estonian Sign Language", "", false, true)); this.languages.Add(new Language("fss", "Finland-Swedish Sign Language", "", false, true)); this.languages.Add(new Language("fse", "Finnish Sign Language", "", false, true)); this.languages.Add(new Language("vgt", "Flemish Sign Language", "", false, true)); this.languages.Add(new Language("sfb", "French Belgian Sign Language", "", false, true)); this.languages.Add(new Language("fsl", "French Sign Language", "", false, true)); this.languages.Add(new Language("gsg", "German Sign Language", "", false, true)); this.languages.Add(new Language("gss", "Greek Sign Language", "", false, true)); this.languages.Add(new Language("hsh", "Hungarian Sign Language", "", false, true)); this.languages.Add(new Language("icl", "Icelandic Sign Language", "", false, true)); this.languages.Add(new Language("isg", "Irish Sign Language", "", false, true)); this.languages.Add(new Language("isr", "Israeli Sign Language", "", false, true)); this.languages.Add(new Language("ise", "Italian Sign Language", "", false, true)); this.languages.Add(new Language("lsl", "Latvian Sign Language", "", false, true)); this.languages.Add(new Language("lls", "Lithuanian Sign Language", "", false, true)); this.languages.Add(new Language("mdl", "Maltese Sign Language", "", false, true)); this.languages.Add(new Language("vsi", "Moldova Sign Language", "", false, true)); this.languages.Add(new Language("nsl", "Norwegian Sign Language", "", false, true)); this.languages.Add(new Language("pso", "Polish Sign Language", "", false, true)); this.languages.Add(new Language("psr", "Portuguese Sign Language", "", false, true)); this.languages.Add(new Language("rms", "Romanian Sign Language", "", false, true)); this.languages.Add(new Language("rsl", "Russian Sign Language", "", false, true)); this.languages.Add(new Language("dse", "Sign Language of the Netherlands", "", false, true)); this.languages.Add(new Language("svk", "Slovak Sign Language", "", false, true)); this.languages.Add(new Language("ssp", "Spanish Sign Language", "", false, true)); this.languages.Add(new Language("swl", "Swedish Sign Language", "", false, true)); this.languages.Add(new Language("ssr", "Swiss-French Sign Language", "", false, true)); this.languages.Add(new Language("sgg", "Swiss-German Sign Language", "", false, true)); this.languages.Add(new Language("slf", "Swiss-Italian Sign Language", "", false, true)); this.languages.Add(new Language("tsm", "Turkish Sign Language", "", false, true)); this.languages.Add(new Language("ukl", "Ukrainian Sign Language", "", false, true)); this.languages.Add(new Language("vsv", "Valencian Sign Language", "", false, true)); this.languages.Add(new Language("ysl", "Yugoslavian Sign Language", "", false, true)); if (uilang != "") { //Localize language names into the UI language: foreach (Language l in this.languages) { string locname = this.getString("lang-" + l.code); if (!locname.StartsWith("$")) { l.name = this.getString("lang-" + l.code); //use default name (= English name) if no localized name is available } } } //StreamWriter writer = new StreamWriter(server.MapPath("/loc/" + uilang + ".langs.txt")); //foreach(Language l in this.languages) { // writer.WriteLine(l.code + "\t" + l.name); //}; //writer.Close(); this.dicTypes = new List <DicType>(); this.dicTypes.Add(new DicType("gen", "General dictionaries", "[General dictionaries] are dictionaries that document contemporary vocabulary and are intended for everyday reference by native and fluent speakers.")); this.dicTypes.Add(new DicType("por", "Portals and aggregators", "[Portals and aggregators] are websites that provide access to more than one dictionary and allow you to search them all at once.")); this.dicTypes.Add(new DicType("lrn", "Learner's dictionaries", "[Learner's dictionaries] are intended for people who are learning the language as a second language.")); this.dicTypes.Add(new DicType("spe", "Dictionaries on special topics", "[Dictionaries on special topics] are dictionaries that focus on a specific subset of the vocabulary (such as new words or phrasal verbs) or which focus on a specific dialect or variant of the language.")); this.dicTypes.Add(new DicType("ort", "Spelling dictionaries", "[Spelling dictionaries] are dictionaries which codify the correct spelling and other aspects of the orthography of words.")); this.dicTypes.Add(new DicType("ety", "Etymological dictionaries", "[Etymological dictionaries] are dictionaries that explain the origins of words.")); this.dicTypes.Add(new DicType("his", "Historical dictionaries", "[Historical dictionaries] are dictionaries that document previous historical states of the language, or dictionaries that trace how the meanings and usage of words have evolved throughout history.")); this.dicTypes.Add(new DicType("trm", "Terminological dictionaries", "[Terminological dictionaries] describe the vocabulary of specialized domains such as biology, mathematics or economics.")); this.aboutPages.Add(new AboutPage("info", "About")); this.aboutPages.Add(new AboutPage("prop", "Suggest a dictionary")); this.aboutPages.Add(new AboutPage("crit", "Criteria for inclusion")); this.aboutPages.Add(new AboutPage("stmp", "Stamp of approval")); this.aboutPages.Add(new AboutPage("crtr", "Curator's manual")); this.aboutPages.Add(new AboutPage("dnld", "Download")); if (uilang != "") { foreach (DicType dt in this.dicTypes) { string locName = this.getString(dt.code + "-name"); string locLegend = this.getString(dt.code + "-legend"); if (!locName.StartsWith("$")) { dt.name = locName; } if (!locLegend.StartsWith("$")) { dt.legend = locLegend; } } foreach (AboutPage ap in this.aboutPages) { ap.title = this.getString("about-" + ap.code); } } }