public List <XbarChartMeasureData> XMLToXBarChartDataList(string chartDataXML)
{
List <XbarChartMeasureData> datas = new List <XbarChartMeasureData>();
XmlDocument xmlDoc = new XmlDocument();
try
{
xmlDoc.LoadXml(chartDataXML);
XmlNodeList nodes = xmlDoc.SelectNodes("ChartData/Row");
foreach (XmlNode node in nodes)
{
XbarChartMeasureData data = new XbarChartMeasureData();
if (node.Attributes["Ordinal"] != null)
{
data.Ordinal = int.Parse(node.Attributes["Ordinal"].Value);
}
if (node.Attributes["FactID"] != null)
{
data.FactID = long.Parse(node.Attributes["FactID"].Value);
}
if (node.Attributes["PartitionPolicy"] != null)
{
data.PartitionPolicy = long.Parse(node.Attributes["PartitionPolicy"].Value);
}
if (node.Attributes["RSOrdinal"] != null)
{
data.RSOrdinal = int.Parse(node.Attributes["RSOrdinal"].Value);
}
if (node.Attributes["WFInstanceID"] != null)
{
data.WFInstanceID = node.Attributes["WFInstanceID"].Value;
}
if (node.Attributes["BusinessDate"] != null)
{
data.BusinessDate = node.Attributes["BusinessDate"].Value;
}
if (node.Attributes["Metric01"] != null)
{
data.Metric01 = long.Parse(node.Attributes["Metric01"].Value);
}
datas.Add(data);
}
}
catch { datas = new List <XbarChartMeasureData>(); }
finally
{
xmlDoc = null;
}
return(datas);
}
public XbarChartMeasureData Clone()
{
XbarChartMeasureData rlt = MemberwiseClone() as XbarChartMeasureData;
return(rlt);
}
private void ribeDelete_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
{
int idx = gridView1.GetFocusedDataSourceRowIndex();
if (idx >= 0)
{
if (gridControl1.DataSource != null &&
(gridControl1.DataSource as List <XbarChartMeasureData>).Count > idx)
{
XbarChartMeasureData data = (gridControl1.DataSource as List <XbarChartMeasureData>)[idx];
if (
MessageBox.Show(
string.Format(
"您确定要删除测量值：[{0}]？",
data.Metric01),
"请确认！",
MessageBoxButtons.YesNo,
MessageBoxIcon.Question,
MessageBoxDefaultButton.Button2) == DialogResult.Yes)
{
string sqlCmd =
string.Format(
"INSERT INTO IRAPMES..RSFact_InspectDataCollecting_H " +
"SELECT *, GETDATE() " +
"FROM IRAPMES..RSFact_InspectDataCollecting " +
"WHERE PartitioningKey={0} AND " +
"FactID={1} AND Ordinal={2};\n" +
"DELETE FROM IRAPMES..RSFact_InspectDataCollecting " +
"WHERE PartitioningKey={0} AND " +
"FactID={1} AND Ordinal={2};",
data.PartitionPolicy,
data.FactID,
data.RSOrdinal);
SqlConnection conn = new SqlConnection(dbString);
try
{
conn.Open();
}
catch (Exception error)
{
MessageBox.Show(error.Message);
return;
}
SqlTransaction transaction = conn.BeginTransaction();
try
{
SqlCommand cmd = new SqlCommand(sqlCmd, conn, transaction)
{
CommandType = CommandType.Text,
};
cmd.ExecuteNonQuery();
transaction.Commit();
conn.Close();
conn = null;
MessageBox.Show("测量数据已删除");
btnSearch.PerformClick();
}
catch (Exception error)
{
transaction.Rollback();
MessageBox.Show(error.Message);
return;
}
}
}
}
}
