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