差异项列表自动生成

        private void GenerateItems() {
            string str = MyCommon.ReadXmlStringFromFile("type.txt", ";", @"E:\CH\HC");
            string[] rows = str.Split(';');
            List<string> destRows = new List<string>();
            foreach (string row in rows)
            {
                string[] cols = row.Split(',');
                //MessageBox.Show(string.Join(Environment.NewLine, cols));


                destRows.Add(string.Format("citems.Add(new CompareItem(\"{0}\", \"{1}\", \"{2}\"));"
                    , getPropName("hcysj", cols[2], "yshd")
                    , getPropName("hcysj", cols[3], "yshd")
                    , cols[1]));


            }
            string msg = string.Join(Environment.NewLine, destRows.ToArray());
            MyCommon.WriteLog(msg);
            MessageBox.Show(msg);

        }

        private string getPropName(string element,string propDispName,string appid) {

            AccessHelper acc = new AccessHelper();
            acc.MdbFileName = string.Format(@"d:\appkit\platform\bin\{0}\md_{0}.mdb", appid);
            acc.ConnectionString = string.Format("Provider=Microsoft.Jet.Oledb.4.0;Data Source={0};Persist Security Info=True", acc.MdbFileName);

            string sql = string.Format("select prop_name from MD_SYS_Property where ele_id in (select ele_id from MD_SYS_Element where ele_name='{0}') and prop_dispname='{1}' "
                ,element,propDispName);
            DataTable dt = acc.ExecuteDataSet(acc.ConnectionString, sql).Tables[0];

            if (dt.Rows.Count > 0)
            {
                return dt.Rows[0][0].ToString();
            }
            else
                return string.Format("{0}", propDispName);
        
        }