private static string GetSchemaList(string dtb, string user) { string sErr = ""; string result = Properties.Resources.SCHEMALIST; CoreQD_SCHEMAControl ctr = new CoreQD_SCHEMAControl(); DataTable dt = ctr.GetAll(dtb, ref sErr); if (user != "TVC") { sErr = BUS.CoreDAControl.SetDataAccessGroup("DAG", dt, user); } XmlDocument doc = new XmlDocument(); doc.LoadXml(result); XmlElement docele = doc.DocumentElement; foreach (DataRow row in dt.Rows) { //<row table="AllMovement" Description="All Movement" module="AllMovement"/> if (row["SCHEMA_STATUS"].ToString().Trim() == "Y") { XmlElement ele = doc.CreateElement("row"); ele.SetAttribute("table", row["SCHEMA_ID"].ToString()); ele.SetAttribute("Description", row["DESCRIPTN"].ToString()); ele.SetAttribute("module", row["SCHEMA_ID"].ToString()); ele.SetAttribute("lookup", row["LOOK_UP"].ToString()); docele.AppendChild(ele); } } result = doc.InnerXml; return(result); }
private static string GetJoinSchema(string dtb) { string sErr = ""; string result = System.Convert.ToString(Properties.Resources.ResourceManager.GetObject(JoinsDefinition)); CoreQD_SCHEMAControl ctr = new CoreQD_SCHEMAControl(); DataTable value = ctr.GetJoins(dtb, ref sErr); string tmp = ""; if (value.Rows.Count > 0) { foreach (DataRow row in value.Rows) { if (!row[0].ToString().Contains("schema")) { if (row[0].ToString()[0] == '<') { tmp += row[0].ToString(); } else { tmp += Base64ToString(row[0].ToString()); } } } //return result; } //tmp = Base64ToString(tmp); XmlDocument doc = new XmlDocument(); doc.LoadXml(result); XmlElement docele = doc.DocumentElement; if (tmp != "") { docele.InnerXml = tmp; return(doc.InnerXml); } DataTable dt = ctr.GetAll(dtb, ref sErr); foreach (DataRow irow in dt.Rows) { //<row fromcode ="Movement" lookup="(SELECT * FROM TVC_MFMOVXXX WHERE Not Hold='Y')"/> string schema = irow["FROM_TEXT"].ToString(); DataSet dset = new DataSet("Schema"); DataTable dtfrom = new DataTable("fromcode"); DataColumn[] col = new DataColumn[] { new DataColumn("fromcode"), new DataColumn("lookup") }; dtfrom.Columns.AddRange(col); dset.Tables.Add(dtfrom); StringReader strR = new StringReader(schema); dset.ReadXml(strR); strR.Close(); string newValue = ""; foreach (DataRow jrow in dtfrom.Rows) { //newValue += string.Format("<row fromcode=\"{0}\" lookup=\"{1}\"/> ", jrow["fromcode"], jrow["lookup"]); XmlElement ele = doc.CreateElement("row"); ele.SetAttribute("fromcode", jrow["fromcode"].ToString()); ele.SetAttribute("lookup", jrow["lookup"].ToString()); docele.AppendChild(ele); } //CoreQD_SCHEMAInfo info = new CoreQD_SCHEMAInfo(irow); //if (info.FIELD_TEXT != "") //{ // info.FROM_TEXT = newValue; // ctr.Update(info); //} } result = doc.InnerXml; return(result); }