public string BuildConfig(string wszInputFilePath, string wszDefaultNamespace, string dllpath) { EnumConver = new StringBuilder(); var tables = getTableName(wszInputFilePath); var fi = new FileInfo(wszInputFilePath); var config = new List <string>(tables).Find(r => r.ToLower() == "@@config" || r == "Sheet2$" || r == "Sheet2"); var headmapdic = CsvCodeBuilder.GetTypeNameMapDefine(wszInputFilePath, dllpath); StringBuilder sb = new StringBuilder(); sb.AppendLine("namespace {0} {".Replace("{0}", wszDefaultNamespace)); if (config != null) { var ds = importExcelToDataSet(wszInputFilePath, config).Tables[0]; for (int i = 0; i < ds.Columns.Count; i++) { var colum = ds.Columns[i]; if (!string.IsNullOrEmpty(colum.ColumnName) && !colum.ColumnName.StartsWith("Column")) { ; List <string> Configs = new List <string>(); List <string> EnConfigs = new List <string>(); var finame = fi.Name.Replace(fi.Extension, ""); for (int j = 0; j < ds.Rows.Count; j++) { var data = ds.Rows[j][i] + ""; if (!string.IsNullOrEmpty(data)) { Configs.Add(data); var head = CsvCodeBuilder.HeadFix(data); if (headmapdic.ContainsKey(finame + "." + head)) { head = headmapdic[finame + "." + head]; } else if (headmapdic.ContainsKey(head)) { head = headmapdic[head]; } else { if (headmapdic.ContainsKey("#srcurl") && headmapdic.ContainsKey("#dstmath")) { head = CsvCodeBuilder.GetTranslateByUrl( headmapdic["#srcurl"], headmapdic["#dstmath"], head, wszInputFilePath ); } } EnConfigs.Add(head); } } //buid var classname = FixRowName(colum.ColumnName); if (headmapdic.ContainsKey(finame + "." + classname)) { classname = headmapdic[finame + "." + classname]; } else if (headmapdic.ContainsKey(classname)) { classname = headmapdic[classname]; } else { if (headmapdic.ContainsKey("#srcurl") && headmapdic.ContainsKey("#dstmath")) { classname = CsvCodeBuilder.GetTranslateByUrl( headmapdic["#srcurl"], headmapdic["#dstmath"], classname, wszInputFilePath ); } } sb.AppendLine(@" /// <summary> /// {oldhead} /// </summary>".Replace("{oldhead}", colum.ColumnName)); //添加枚举映射 EnumMap[colum.ColumnName] = classname; var classtxt = @"public enum Enum_{class}{"; sb.AppendLine(classtxt.Replace("{class}", classname)); var bodytpl = @" case ""{head}"": return Enum_{class}.{new}; "; var body = new StringBuilder(); for (int j = 0; j < Configs.Count; j++) { var oldhead = Configs[j]; var newhead = EnConfigs[j]; sb.AppendLine(@" /// <summary> /// {oldhead} /// </summary>".Replace("{oldhead}", oldhead)); sb.AppendLine(newhead + ","); body.AppendLine(bodytpl .Replace("{head}", oldhead) .Replace("{new}", newhead) .Replace("{class}", classname) ); } EnumConver.AppendLine(@" ExctionClass.RegEnumConvert<Enum_{class}>(o => { var str = o.ToString(); switch (str) { {body} } return Enum_{class}.{0}; }); " .Replace("{class}", classname) .Replace("{body}", body.ToString()) .Replace("{0}", EnConfigs[0]) ); { var bodytplback = @" case Enum_{class}.{new}: return ""{head}""; "; var bodyback = new StringBuilder(); for (int j = 0; j < Configs.Count; j++) { var oldhead = Configs[j]; var newhead = EnConfigs[j]; bodyback.AppendLine(bodytplback .Replace("{head}", oldhead) .Replace("{new}", newhead) .Replace("{class}", classname) ); } EnumConver.AppendLine(@" ExctionClass.RegEnumConvertBack<Enum_{class}>(o => { var str = (Enum_{class})o; switch (str) { {body} } return """"; }); " .Replace("{class}", classname) .Replace("{body}", bodyback.ToString()) .Replace("{0}", EnConfigs[0]) ); } sb.AppendLine("}"); } } } sb.AppendLine("}"); return(sb.ToString()); }
public override void GenerateOnFile(StringBuilder codes, string wszInputFilePath, string bstrInputFileContents, string wszDefaultNamespace, string dllpath) { codes.AppendLine("//Code Gen By ExcelCodeBuilder V1.3 ..."); codes.AppendLine("//Addin path " + dllpath); codes.AppendLine(@" using System; using System.Collections.Generic; using System.Xml; "); var tables = getTableName(wszInputFilePath); //先创建枚举类型 var eunmstr = BuildConfig(wszInputFilePath, wszDefaultNamespace, dllpath); codes.AppendLine(eunmstr); codes.AppendLine("//eunms Gen By ExcelCodeBuilder ..."); int tabindex = -1; foreach (var table in tables) { tabindex++; var ds = importExcelToDataSet(wszInputFilePath, table).Tables[0]; if (table.StartsWith("@@") || table.StartsWith("__")) { //不导出此类表 continue; } var fileInfo = new FileInfo(wszInputFilePath); if (!File.Exists(fileInfo.Directory.FullName + "//ConfigHelper.cs")) { var cspath = new FileInfo(dllpath).Directory.FullName + "//Tpl//ConfigHelper.cs"; if (File.Exists(cspath)) { File.Copy(cspath, fileInfo.Directory.FullName + "//ConfigHelper.cs", true); } } var classname = fileInfo.Name.Replace(fileInfo.Extension, ""); string key = null; StringBuilder body = new StringBuilder(); StringBuilder method = new StringBuilder(); StringBuilder setbody = new StringBuilder(); StringBuilder igetbody = new StringBuilder(); StringBuilder isetbody = new StringBuilder(); if (table != "Sheet1$" && table != "Sheet1") { classname = table; } classname = CsvCodeBuilder.HeadFix(classname); string oldclassname = classname; var headmapdic = CsvCodeBuilder.GetTypeNameMapDefine(wszInputFilePath, dllpath); if (headmapdic.ContainsKey(classname)) { classname = headmapdic[classname]; } else { if (headmapdic.ContainsKey("#srcurl") && headmapdic.ContainsKey("#dstmath")) { classname = CsvCodeBuilder.GetTranslateByUrl( headmapdic["#srcurl"], headmapdic["#dstmath"], classname, wszInputFilePath ); } } if (headmapdic.ContainsKey("#xmlout")) { var path = fileInfo.Directory.FullName + headmapdic["#xmlout"]; path = new FileInfo(path).FullName + "\\"; codes.AppendLine("//xmlout " + path); path += classname; MyConvertExcelToXml(wszInputFilePath, path, table); } //if (!classname.EndsWith("Table")) //{ // classname = classname + "Table"; //} //建立主体 { var dic = CsvCodeBuilder.GetTypeDefine(wszInputFilePath, dllpath); string args = ""; string IDHead = "ID"; for (int i = 0; i < ds.Columns.Count; i++) { string head = ds.Columns[i].ColumnName; string oldhead = head; if (head.StartsWith("@@")) //直接截断 { break; } if (head.StartsWith("__")) //忽略 { continue; } if (head.StartsWith("_"))//移除下划线 { head = head.Substring(1); } if (head.StartsWith("__"))//移除下划线 { head = head.Substring(2); } if (head == "") { head = "h" + i; } string type = "string"; type = ds.Columns[i].DataType.Name; if (type == "Double") { type = "int"; } head = CsvCodeBuilder.HeadFix(head); if (dic.ContainsKey(classname + "." + head)) { type = dic[classname + "." + head]; } else if (dic.ContainsKey(head)) { type = dic[head]; } if (headmapdic.ContainsKey(classname + "." + head)) { head = headmapdic[classname + "." + head]; } else if (headmapdic.ContainsKey(head)) { head = headmapdic[head]; } else { if (headmapdic.ContainsKey("#srcurl") && headmapdic.ContainsKey("#dstmath")) { head = CsvCodeBuilder.GetTranslateByUrl( headmapdic["#srcurl"], headmapdic["#dstmath"], head, wszInputFilePath ); } } if (i == 0) { IDHead = head; } if (key == null) { key = type; } if (type == "枚举" || type == "enum") { if (EnumMap.ContainsKey(ds.Columns[i].ColumnName)) { type = "Enum_" + EnumMap[ds.Columns[i].ColumnName]; } } setbody.AppendLine("case \"{0}\":".Replace("{0}", ds.Columns[i].ColumnName)); var fixRowName = FixRowName(ds.Columns[i].ColumnName); if (fixRowName != ds.Columns[i].ColumnName) { setbody.AppendLine("case \"{0}\":".Replace("{0}", fixRowName)); } //setbody.AppendLine("this._" + head + " =new Func<" + type + ">(()=> { return ConfigHelper.ConvertTo<" + type + ">(localnode.InnerText); });"); setbody.AppendLine("this._" + head + " = ConfigHelper.ConvertTo<" + type + ">(localnode.InnerText); "); setbody.AppendLine("break;"); body.AppendLine(@" /// <summary> /// {oldhead} /// </summary>".Replace("{oldhead}", oldhead) ); //if (i == 0) // body.AppendLine("\t\t[Config(Index = 0, IsKey = true, Desc = \"" + ds.Columns[i].ColumnName + "\")]"); //else // body.AppendLine("\t\t[Config(Index = " + i + " , Desc = \"" + ds.Columns[i].ColumnName + "\")]"); body.AppendLine(@" //ConfigValue<{0}> _{1} ; {0} _{1}; /// <summary> /// {oldhead} /// </summary> [ConfigItemMap(""{oldhead}"")] public {0} {1} { get{ return _{1}; } set { _{1} = value; } } " .Replace("{0}", type) .Replace("{1}", head) .Replace("{oldhead}", oldhead) ); igetbody.Append(@" if (memberName == '{1}') { return {1}; } ".Replace('\'', '\"') .Replace("{1}", head) ); isetbody.Append(@" if (memberName == '{1}') { obj.{1} = ({0})newValue; } ".Replace('\'', '\"') .Replace("{1}", head) .Replace("{0}", type) ); if (args != "") { args += ","; } args += type + " " + head; } method.AppendLine( @" #if !RELEASE_CLIENT string xmldata = null; public override string ToString() { return xmldata; } #endif /// <summary> /// ID /// </summary> //public string xmlcrc { get;set; } public bool CheckId() { if ({ID} > 0) { return true; } return false; } public int GetId() { return ConfigHelper.ConvertTo<int>({ID}); } public void Parse(XmlNode xmlnode) { #if !RELEASE_CLIENT xmldata = xmlnode.InnerXml; #endif //xmlcrc = xmlnode.InnerXml.GetHashCode().ToString(); foreach(XmlNode node in xmlnode) { var localnode = node; switch(node.Name) { {body} } } } " .Replace("{body}", setbody.ToString()) .Replace("{ID}", IDHead) ); body.AppendLine(method.ToString()); } //建立类 codes.AppendLine(@" namespace {0} { /// <summary> /// {oldclass} /// </summary> [Serializable] //[Config(Index = {index})] public partial class {1} #if MA :IMemberAccessor #endif { {body} public object GetValue(object instance, string memberName) { {getbody} return null; } public void SetValue(object instance, string memberName, object newValue) { var obj = instance as {1}; {setbody} } } " .Replace("{0}", wszDefaultNamespace) .Replace("{1}", classname) .Replace("{body}", body.ToString()) .Replace("{getbody}", igetbody.ToString()) .Replace("{setbody}", isetbody.ToString()) .Replace("{ext}", "\"" + Exction + "\"") .Replace("{oldclass}", oldclassname) .Replace("{index}", tabindex.ToString()) ); BuildConfigReadClass(codes, classname, oldclassname); codes.AppendLine("}"); if (table == "Sheet1$" || table == "Sheet1") { break; } } }
public static void MyConvertExcelToXmlI(string excelFilePath, string xmlOutFileDic, string tablename) { var names = getTableName(excelFilePath); var dic = new FileInfo(excelFilePath).Directory.FullName; var headmapdic = new Dictionary <string, string>(); try { Console.WriteLine(dic + "//nameMap.txt"); headmapdic = CsvCodeBuilder.GetTypeNameMapDefine(dic + "//nameMap.txt", "./"); } catch (Exception) { } var dump = false; foreach (var name in names) { if (tablename == name || tablename == null) { if (tablename == null && name.StartsWith("@@")) { break; } if (name.StartsWith("_")) { continue; } var classname = CsvCodeBuilder.HeadFix(new FileInfo(excelFilePath).Name.Replace(".xlsx", "")); if (name != "Sheet1") { classname = CsvCodeBuilder.HeadFix(name); } else { dump = true; } if (headmapdic.ContainsKey(classname)) { classname = headmapdic[classname]; } var ds = importExcelToDataSet(excelFilePath, name, true); var ds2 = importExcelToDataSet(excelFilePath, name, false); var table = ds.Tables[0]; var table2 = ds2.Tables[0]; var removeName = new List <string>(); foreach (DataColumn column in table.Columns) { if (column.ColumnName.StartsWith("_")) { removeName.Add(column.ColumnName); } } foreach (var colName in removeName) { table.Columns.Remove(colName); table2.Columns.Remove(colName); } for (int i = 0; i < table.Rows.Count; i++) { DataRow row = table.Rows[i]; for (int j = 0; j < row.ItemArray.Length; j++) { var value = row[j]; if (value.ToString() == "") { if (table2.Columns[j].DataType == typeof(string) || table2.Columns[j].DataType == typeof(DateTime)) { row[j] = ""; } else { row[j] = 0; } } } } if (xmlOutFileDic.EndsWith("\\")) { ds.WriteXml(xmlOutFileDic + classname + ".xml"); ds.Dispose(); Console.WriteLine(xmlOutFileDic + classname + ".xml"); } else { ds.WriteXml(xmlOutFileDic + ".xml"); ds.Dispose(); Console.WriteLine(xmlOutFileDic + ".xml"); } if (dump) { break; } } } }