private DataSet ReadScheme(DTO.LIST_QD_SCHEMAInfo inf)
{
DataSet ds = _data.Clone();
if (inf.FIELD_TEXT == "")
{
StringReader strR = new StringReader(inf.FROM_TEXT);
try
{
ds.ReadXml(strR);
}
catch (Exception ex)
{
if (MessageBox.Show("Schema structure is erro!\n Do you want to delete it?", "Message", MessageBoxButtons.OKCancel) == DialogResult.OK)
{
btnDelete_Click(null, null);
}
}
strR.Close();
return(ds);
}
else
{
XmlDocument xml = new XmlDocument();
string content = inf.FROM_TEXT;
if (content.Length > 0 && content[0] != '<')
{
content = Form_QD.Base64ToString(content);
}
string strxml = string.Format("<?xml version=\"1.0\" encoding=\"utf-8\" ?><SUN_SCHEMA>{0}</SUN_SCHEMA>", content);
xml.LoadXml(strxml);
XmlElement doc = xml.DocumentElement;
DataTable dtfrom = ds.Tables["fromcode"];
foreach (XmlElement ele in doc.ChildNodes)
{
DataRow newRow = dtfrom.NewRow();
newRow["fromcode"] = ele.GetAttribute("fromcode");
newRow["lookup"] = ele.GetAttribute("lookup");
dtfrom.Rows.Add(newRow);
}
xml.LoadXml(inf.FIELD_TEXT);
doc = xml.DocumentElement;
DataTable dtfield = ds.Tables["_TableName"];
foreach (XmlElement ele in doc.ChildNodes)
{
DataRow newRow = dtfield.NewRow();
newRow["node"] = ele.GetAttribute("node");
newRow["name"] = ele.GetAttribute("name");
newRow["table"] = ele.GetAttribute("table");
newRow["nodeDesc"] = ele.GetAttribute("nodeDesc");
newRow["type"] = ele.GetAttribute("type");
dtfield.Rows.Add(newRow);
}
return(ds);
}
}
private void toolStripButton1_Click(object sender, EventArgs e)
{
string sErr = "";
BUS.LIST_QD_SCHEMAControl ctr = new BUS.LIST_QD_SCHEMAControl();
DataTable dt = ctr.GetAll(_db, ref sErr);
foreach (DataRow row in dt.Rows)
{
DTO.LIST_QD_SCHEMAInfo inf = new DTO.LIST_QD_SCHEMAInfo(row);
try
{
if (inf.FROM_TEXT[0] == '<')
{
}
_data.Tables["_TableName"].Rows.Clear();
_data.Tables["fromcode"].Rows.Clear();
_data = ReadScheme(inf);
DataTable dtfield = _data.Tables["_TableName"];
string field = "<?xml version=\"1.0\" encoding=\"utf-8\" ?><SUN_SCHEMA>{0}</SUN_SCHEMA>";
string tmp = "";
string from = "";
foreach (DataRow jrow in dtfield.Rows)
{
tmp += string.Format("<row table=\"{0}\" node=\"{1}\" name=\"{2}\" nodeDesc=\"{3}\" type=\"{4}\" conn_id=\"{5}\"/>", jrow["table"], jrow["node"], jrow["name"], jrow["nodeDesc"], jrow["type"], inf.DEFAULT_CONN);
}
DataTable dtfrom = _data.Tables["fromcode"];
field = string.Format(field, tmp);
tmp = "";
foreach (DataRow jrow in dtfrom.Rows)
{
tmp += string.Format("<row fromcode=\"{0}\" lookup=\"{1}\"/> ", jrow["fromcode"], frmQDADD.XmlEncode(jrow["lookup"].ToString()));
}
from = tmp;
//result = doc.InnerXml;
inf.FIELD_TEXT = field;
inf.FROM_TEXT = Form_QD.StringToBase64(from);
ctr.Update(inf);
}
catch (Exception ex)
{ }
}
}
private DTO.LIST_QD_SCHEMAInfo GetDataFromForm(DTO.LIST_QD_SCHEMAInfo inf)
{
inf.CONN_ID = _db;
inf.DEFAULT_CONN = ddlQD.Text;
inf.DESCRIPTN = txtDescription.Text;
inf.LOOK_UP = txtLookup.Text;
inf.UPDATED = DateTime.Today.Year * 10000 + DateTime.Today.Month * 100 + DateTime.Today.Day;
//if (inf.FIELD_TEXT != "")
//{
DataTable dtfield = _data.Tables["_TableName"];
string field = "<?xml version=\"1.0\" encoding=\"utf-8\" ?><SUN_SCHEMA>{0}</SUN_SCHEMA>";
string tmp = "";
string from = "";
foreach (DataRow jrow in dtfield.Rows)
{
tmp += string.Format("<row table=\"{0}\" node=\"{1}\" name=\"{2}\" nodeDesc=\"{3}\" type=\"{4}\" conn_id=\"{5}\"/>", jrow["table"], jrow["node"], jrow["name"], jrow["nodeDesc"], jrow["type"], inf.DEFAULT_CONN);
}
DataTable dtfrom = _data.Tables["fromcode"];
field = string.Format(field, tmp);
tmp = "";
foreach (DataRow jrow in dtfrom.Rows)
{
tmp += string.Format("<row fromcode=\"{0}\" lookup=\"{1}\" /> ", jrow["fromcode"], XmlEncode(jrow["lookup"].ToString()));
}
from = tmp;
inf.FIELD_TEXT = field;
inf.FROM_TEXT = Form_QD.StringToBase64(from);
inf.SCHEMA_ID = txtCode.Text;
inf.SCHEMA_STATUS = ckbUse.Checked ? "Y" : "N";
inf.DAG = Group.Text;
return(inf);
}
