/// <summary> /// /// </summary> /// <param name="id"></param> /// <param name="count"></param> /// <returns></returns> public DataTable Query(MonitorTemplet templet, string id, int count) { anyType2anyTypeMapEntry[] requestData = new anyType2anyTypeMapEntry[] { Helper.XfireCreateKeyValue("dowhat", "QueryRecordsByCount"), Helper.XfireCreateKeyValue("id", id), Helper.XfireCreateKeyValue("count", count.ToString()) }; this.service.Url = UserPermissionContext.Instance.Url; RetMapInVector result = ServiceClient.GetForestData(requestData); //RetMapInVector result = this.service.GetForestData(requestData); if (!result.retbool) { if (logger.IsWarnEnabled) { logger.Warn(result.estr); } return(null); } DataTable dt = CreateDataTable(templet, result.vmap); return(dt); }
/// <summary> /// 1 /// </summary> /// <param name="templet"></param> /// <param name="id"></param> /// <param name="beginTime"></param> /// <param name="endTime"></param> /// <param name="tj"></param> /// <returns></returns> public DataTable Query1(MonitorTemplet templet, string id, DateTime beginTime, DateTime endTime) { anyType2anyTypeMapEntry[] requestData = new anyType2anyTypeMapEntry[] { Helper.XfireCreateKeyValue("dowhat", "QueryRecordsByTime"), Helper.XfireCreateKeyValue("id", id), Helper.XfireCreateKeyValue("begin_year", beginTime.Year.ToString()), Helper.XfireCreateKeyValue("begin_month", beginTime.Month.ToString()), Helper.XfireCreateKeyValue("begin_day", beginTime.Day.ToString()), Helper.XfireCreateKeyValue("begin_hour", beginTime.Hour.ToString()), Helper.XfireCreateKeyValue("begin_minute", beginTime.Minute.ToString()), Helper.XfireCreateKeyValue("begin_second", beginTime.Second.ToString()), Helper.XfireCreateKeyValue("end_year", endTime.Year.ToString()), Helper.XfireCreateKeyValue("end_month", endTime.Month.ToString()), Helper.XfireCreateKeyValue("end_day", endTime.Day.ToString()), Helper.XfireCreateKeyValue("end_hour", endTime.Hour.ToString()), Helper.XfireCreateKeyValue("end_minute", endTime.Minute.ToString()), Helper.XfireCreateKeyValue("end_second", endTime.Second.ToString()) }; this.service.Url = UserPermissionContext.Instance.Url; RetMapInVector result = ServiceClient.GetForestData(requestData); //RetMapInVector result = this.service.GetForestData(requestData); if (!result.retbool) { if (logger.IsWarnEnabled) { logger.Warn(result.estr); } return(null); } DataTable dt = CreateDataTable1(templet, result.vmap); return(dt); }
public DataTable CreateDataTable(MonitorTemplet templet, anyType2anyTypeMapEntry[][] data) { DataTable dt = new DataTable(); DataTable Imgdt = new DataTable(); NameValueCollection TextName = new NameValueCollection(); NameValueCollection ImgTextName = new NameValueCollection(); dt.Columns.Add(new DataColumn("时间", typeof(DateTime))); dt.Columns.Add(new DataColumn("记录状态", typeof(String))); dt.Columns.Add(new DataColumn("描述", typeof(String))); dt.Columns.Add(new DataColumn("名称", typeof(String))); Imgdt.Columns.Add(new DataColumn("时间", typeof(DateTime))); Imgdt.Columns.Add(new DataColumn("记录状态", typeof(String))); Imgdt.Columns.Add(new DataColumn("描述", typeof(String))); TextName.Add("creat_time", "时间"); TextName.Add("record_status", "记录状态"); TextName.Add("dstr", "描述"); ImgTextName.Add("creat_time", "时间"); ImgTextName.Add("record_status", "记录状态"); ImgTextName.Add("dstr", "描述"); foreach (NameValueCollection returnItem in templet.Returns.Values) { ///bin.liusv_type ///2008.8.11 if (returnItem.Get("sv_type") == null || returnItem["sv_type"] == null || returnItem["sv_type"] == string.Empty || returnItem["sv_type"].ToLower() == "string") { continue; } dt.Columns.Add(new DataColumn(returnItem["sv_label"], typeof(Double))); TextName.Add(returnItem["sv_name"], returnItem["sv_label"]); if (returnItem.Get("sv_drawimage") != null) { if (returnItem["sv_drawimage"] == "1") { ImgTextName.Add(returnItem["sv_name"], returnItem["sv_label"]); Imgdt.Columns.Add(new DataColumn(returnItem["sv_label"], typeof(Double))); } } } DataRow dr = null; IList <NameValueCollection> resultData = Helper.XfireConventMapEntryToList(data); foreach (NameValueCollection nameValueCollection in resultData) { dr = dt.NewRow(); dr["名称"] = this.Name; foreach (string key in nameValueCollection.AllKeys) { string clumnname = TextName[key]; if (clumnname != null && dt.Columns.Contains(clumnname)) //判断是否存在此列,否则有的情况会报错 add by huangyimei { if (dt.Columns[clumnname].DataType.Equals(typeof(Double))) { double value = 0; Double.TryParse(nameValueCollection[key], out value); dr[clumnname] = value; } else { dr[clumnname] = nameValueCollection[key]; } } } dt.Rows.Add(dr); } /* * foreach (MapType map in data) * { * dr = dt.NewRow(); * dr["名称"] = this.Name; * foreach (KeyValue keyvalue in map.Map) * { * string clumnname = TextName[keyvalue.Key]; * if (dt.Columns[clumnname].DataType.Equals(typeof(Double))) * { * double value = 0; * Double.TryParse(keyvalue.Value, out value); * dr[clumnname] = value; * } * else * { * dr[clumnname] = keyvalue.Value; * } * } * dt.Rows.Add(dr); * } */ DataRow dr1 = null; foreach (NameValueCollection nameValueCollection in resultData) { dr1 = Imgdt.NewRow(); foreach (string key in nameValueCollection.Keys) { if (ImgTextName.Get(key) != null) { string clumnname = ImgTextName[key]; if (Imgdt.Columns[clumnname].DataType.Equals(typeof(Double))) { double value = 0; Double.TryParse(nameValueCollection[key], out value); dr1[clumnname] = value; } else { dr1[clumnname] = nameValueCollection[key]; } } } Imgdt.Rows.Add(dr1); } /* * DataRow dr1 = null; * foreach (MapType map in data) * { * dr1 = Imgdt.NewRow(); * foreach (KeyValue keyvalue in map.Map) * { * if (ImgTextName.Get(keyvalue.Key) != null) * { * string clumnname = ImgTextName[keyvalue.Key]; * if (Imgdt.Columns[clumnname].DataType.Equals(typeof(Double))) * { * double value = 0; * Double.TryParse(keyvalue.Value, out value); * dr1[clumnname] = value; * } * else * { * dr1[clumnname] = keyvalue.Value; * } * } * } * Imgdt.Rows.Add(dr1); * } */ ImgTable = Imgdt; return(dt); }
/// <summary> /// 1 /// </summary> /// <param name="templet"></param> /// <param name="data"></param> /// <returns></returns> public DataTable CreateDataTable1(MonitorTemplet templet, anyType2anyTypeMapEntry[][] data) { DataTable Primarydt = new DataTable(); DataTable Measuredt = new DataTable(); DataTable Imgdt = new DataTable(); Imgdt.Columns.Add(new DataColumn("时间", typeof(DateTime))); Imgdt.Columns.Add(new DataColumn("记录状态", typeof(String))); Imgdt.Columns.Add(new DataColumn("描述", typeof(String))); NameValueCollection ImgTextName = new NameValueCollection(); ImgTextName.Add("creat_time", "时间"); ImgTextName.Add("record_status", "记录状态"); ImgTextName.Add("dstr", "描述"); int j = 0; foreach (NameValueCollection returnItem in templet.Returns.Values) { if (returnItem.Get("sv_drawimage") != null) { if (j < 1) { if ((returnItem["sv_drawimage"] == "1") && (returnItem["sv_primary"] == "1")) { headtitle = returnItem["sv_label"]; ImgTextName.Add(returnItem["sv_name"], returnItem["sv_label"]); Imgdt.Columns.Add(new DataColumn(returnItem["sv_label"], typeof(Double))); j = j + 1; } } } } NameValueCollection PrimaryTextName = new NameValueCollection(); NameValueCollection MeasureTextName = new NameValueCollection(); Primarydt.Columns.Add(new DataColumn("名称", typeof(String))); Primarydt.Columns.Add(new DataColumn("时间", typeof(DateTime))); Primarydt.Columns.Add(new DataColumn("记录状态", typeof(String))); PrimaryTextName.Add("creat_time", "时间"); PrimaryTextName.Add("record_status", "记录状态"); Measuredt.Columns.Add(new DataColumn("record_status", typeof(String))); MeasureTextName.Add("record_status", "记录状态"); foreach (NameValueCollection returnItem in templet.Returns.Values) { if (returnItem.Get("sv_primary") != null) { if (returnItem["sv_primary"] == "1") { PrimaryTextName.Add(returnItem["sv_name"], returnItem["sv_label"]); Primarydt.Columns.Add(new DataColumn(returnItem["sv_label"], typeof(Double))); } } // sv_drawmeasure if (returnItem.Get("sv_drawimage") != null) { if (returnItem["sv_drawimage"] == "1") { if (returnItem["sv_name"] != null) { MeasureTextName.Add(returnItem["sv_name"], returnItem["sv_label"]); Measuredt.Columns.Add(new DataColumn(returnItem["sv_name"], typeof(Double))); } } } } DataRow dr = null; IList <NameValueCollection> resultData = Helper.XfireConventMapEntryToList(data); foreach (NameValueCollection nameValueCollection in resultData) { dr = Primarydt.NewRow(); dr["名称"] = string.IsNullOrEmpty(this.Name) ? "" : this.Name; foreach (string key in nameValueCollection.AllKeys) { if (PrimaryTextName.Get(key) != null) { string clumnname = PrimaryTextName[key]; if (Primarydt.Columns[clumnname].DataType.Equals(typeof(Double))) { double value = 0; Double.TryParse(nameValueCollection[key], out value); dr[clumnname] = value; } else { dr[clumnname] = nameValueCollection[key]; } } } Primarydt.Rows.Add(dr); } //foreach (MapType map in data) //{ // dr = Primarydt.NewRow(); // dr["名称"] = string.IsNullOrEmpty(this.Name) ? "" : this.Name; // foreach (KeyValue keyvalue in map.Map) // { // if (PrimaryTextName.Get(keyvalue.Key) != null) // { // string clumnname = PrimaryTextName[keyvalue.Key]; // if (Primarydt.Columns[clumnname].DataType.Equals(typeof(Double))) // { // double value = 0; // Double.TryParse(keyvalue.Value, out value); // dr[clumnname] = value; // } // else // { // dr[clumnname] = keyvalue.Value; // } // } // } // Primarydt.Rows.Add(dr); //} //foreach (NameValueCollection nameValueCollection in resultData) //{ // dr = dt.NewRow(); // dr["名称"] = this.Name; // foreach (string key in nameValueCollection.AllKeys) // { // string clumnname = TextName[key]; // if (dt.Columns[clumnname].DataType.Equals(typeof(Double))) // { // double value = 0; // Double.TryParse(nameValueCollection[key], out value); // dr[clumnname] = value; // } // else // { // dr[clumnname] = nameValueCollection[key]; // } // } // dt.Rows.Add(dr); //} DataRow dr1 = null; foreach (NameValueCollection nameValueCollection in resultData) { dr1 = Measuredt.NewRow(); for (int i = 0; i < Measuredt.Columns.Count; i++) { dr1[i] = 0.00; } bool rowadd = false; foreach (string key in nameValueCollection.AllKeys) { if (MeasureTextName.Get(key) != null) { if (Measuredt.Columns[key].DataType.Equals(typeof(Double))) { double value = 0; rowadd = Double.TryParse(nameValueCollection[key], out value); dr1[key] = value; } else { dr1[key] = nameValueCollection[key]; } //if (nameValueCollection[key].Equals("ok")) //{ // rowadd = true; //} } } if (rowadd) { Measuredt.Rows.Add(dr1); } } foreach (NameValueCollection nameValueCollection in resultData) { dr1 = Imgdt.NewRow(); foreach (string key in nameValueCollection.Keys) { if (ImgTextName.Get(key) != null) { string clumnname = ImgTextName[key]; if (Imgdt.Columns[clumnname].DataType.Equals(typeof(Double))) { double value = 0; Double.TryParse(nameValueCollection[key], out value); dr1[clumnname] = value; } else { dr1[clumnname] = nameValueCollection[key]; } } } Imgdt.Rows.Add(dr1); } //DataRow dr1 = null; //foreach (MapType map in data) //{ // dr1 = Measuredt.NewRow(); // for (int i = 0; i < Measuredt.Columns.Count; i++) // { // dr1[i] = 0.00; // } // bool rowadd = false; // foreach (KeyValue keyvalue in map.Map) // { // if (MeasureTextName.Get(keyvalue.Key) != null) // { // if (Measuredt.Columns[keyvalue.Key].DataType.Equals(typeof(Double))) // { // double value = 0; // Double.TryParse(keyvalue.Value, out value); // dr1[keyvalue.Key] = value; // } // else // { // dr1[keyvalue.Key] = keyvalue.Value; // } // if (keyvalue.Value.Equals("ok")) // { // rowadd = true; // } // } // } // if (rowadd) // { // Measuredt.Rows.Add(dr1); // } //} if (Measuredt.Rows.Count == 0) { DataRow dr2 = null; dr2 = Measuredt.NewRow(); foreach (string key in MeasureTextName.Keys) { if (string.IsNullOrEmpty(key)) { continue; } if (Measuredt.Columns[key].DataType.Equals(typeof(Double))) { dr2[key] = 0.0; } else { dr2[key] = MeasureTextName[key]; } } Measuredt.Rows.Add(dr2); } this.PrimaryTable = Primarydt; this.MeasureTable = Measuredt; this.ImgTable = Imgdt; return(Primarydt); }
public DataTable CreateDataTable(MonitorTemplet templet, anyType2anyTypeMapEntry[][] data) { DataTable dt = new DataTable(); DataTable Imgdt = new DataTable(); NameValueCollection TextName = new NameValueCollection(); NameValueCollection ImgTextName = new NameValueCollection(); dt.Columns.Add(new DataColumn("ʱ��", typeof(DateTime))); dt.Columns.Add(new DataColumn("��¼״̬", typeof(String))); dt.Columns.Add(new DataColumn("����", typeof(String))); dt.Columns.Add(new DataColumn("����", typeof(String))); Imgdt.Columns.Add(new DataColumn("ʱ��", typeof(DateTime))); Imgdt.Columns.Add(new DataColumn("��¼״̬", typeof(String))); Imgdt.Columns.Add(new DataColumn("����", typeof(String))); TextName.Add("creat_time", "ʱ��"); TextName.Add("record_status", "��¼״̬"); TextName.Add("dstr", "����"); ImgTextName.Add("creat_time", "ʱ��"); ImgTextName.Add("record_status", "��¼״̬"); ImgTextName.Add("dstr", "����"); foreach (NameValueCollection returnItem in templet.Returns.Values) { ///bin.liusv_type ///2008.8.11 if (returnItem.Get("sv_type") == null || returnItem["sv_type"] == null || returnItem["sv_type"] == string.Empty || returnItem["sv_type"].ToLower() == "string") { continue; } dt.Columns.Add(new DataColumn(returnItem["sv_label"], typeof(Double))); TextName.Add(returnItem["sv_name"], returnItem["sv_label"]); if (returnItem.Get("sv_drawimage") != null) { if (returnItem["sv_drawimage"] == "1") { ImgTextName.Add(returnItem["sv_name"], returnItem["sv_label"]); Imgdt.Columns.Add(new DataColumn(returnItem["sv_label"], typeof(Double))); } } } DataRow dr = null; IList<NameValueCollection> resultData = Helper.XfireConventMapEntryToList(data); foreach (NameValueCollection nameValueCollection in resultData) { dr = dt.NewRow(); dr["����"] = this.Name; foreach (string key in nameValueCollection.AllKeys) { string clumnname = TextName[key]; if (clumnname != null && dt.Columns.Contains(clumnname)) //�ж��Ƿ���ڴ��У������е�����ᱨ�� add by huangyimei { if (dt.Columns[clumnname].DataType.Equals(typeof(Double))) { double value = 0; Double.TryParse(nameValueCollection[key], out value); dr[clumnname] = value; } else { dr[clumnname] = nameValueCollection[key]; } } } dt.Rows.Add(dr); } /* foreach (MapType map in data) { dr = dt.NewRow(); dr["����"] = this.Name; foreach (KeyValue keyvalue in map.Map) { string clumnname = TextName[keyvalue.Key]; if (dt.Columns[clumnname].DataType.Equals(typeof(Double))) { double value = 0; Double.TryParse(keyvalue.Value, out value); dr[clumnname] = value; } else { dr[clumnname] = keyvalue.Value; } } dt.Rows.Add(dr); } */ DataRow dr1 = null; foreach (NameValueCollection nameValueCollection in resultData) { dr1 = Imgdt.NewRow(); foreach (string key in nameValueCollection.Keys) { if (ImgTextName.Get(key) != null) { string clumnname = ImgTextName[key]; if (Imgdt.Columns[clumnname].DataType.Equals(typeof(Double))) { double value = 0; Double.TryParse(nameValueCollection[key], out value); dr1[clumnname] = value; } else { dr1[clumnname] = nameValueCollection[key]; } } } Imgdt.Rows.Add(dr1); } /* DataRow dr1 = null; foreach (MapType map in data) { dr1 = Imgdt.NewRow(); foreach (KeyValue keyvalue in map.Map) { if (ImgTextName.Get(keyvalue.Key) != null) { string clumnname = ImgTextName[keyvalue.Key]; if (Imgdt.Columns[clumnname].DataType.Equals(typeof(Double))) { double value = 0; Double.TryParse(keyvalue.Value, out value); dr1[clumnname] = value; } else { dr1[clumnname] = keyvalue.Value; } } } Imgdt.Rows.Add(dr1); } */ ImgTable = Imgdt; return dt; }
/// <summary> /// /// </summary> /// <param name="id"></param> /// <param name="count"></param> /// <returns></returns> public DataTable Query1(MonitorTemplet templet, string id, int count) { anyType2anyTypeMapEntry[] requestData = new anyType2anyTypeMapEntry[] { Helper.XfireCreateKeyValue("dowhat","QueryRecordsByCount"), Helper.XfireCreateKeyValue("id",id), Helper.XfireCreateKeyValue("count",count.ToString()) }; this.service.Url = UserPermissionContext.Instance.Url; RetMapInVector result = ServiceClient.GetForestData(requestData); //RetMapInVector result = this.service.GetForestData(requestData); if (!result.retbool) { if (logger.IsWarnEnabled) { logger.Warn(result.estr); } if (measureTable != null) measureTable.Clear(); if (ImageTable != null) ImageTable.Clear(); if (primaryTable != null) primaryTable.Clear(); return null; } DataTable dt = CreateDataTable1(templet, result.vmap); return dt; }
/// <summary> /// 1 /// </summary> /// <param name="templet"></param> /// <param name="id"></param> /// <param name="beginTime"></param> /// <param name="endTime"></param> /// <param name="tj"></param> /// <returns></returns> public DataTable Query1(MonitorTemplet templet, string id, DateTime beginTime, DateTime endTime) { anyType2anyTypeMapEntry[] requestData = new anyType2anyTypeMapEntry[] { Helper.XfireCreateKeyValue("dowhat","QueryRecordsByTime"), Helper.XfireCreateKeyValue("id",id), Helper.XfireCreateKeyValue("begin_year",beginTime.Year.ToString()), Helper.XfireCreateKeyValue("begin_month",beginTime.Month.ToString()), Helper.XfireCreateKeyValue("begin_day",beginTime.Day.ToString()), Helper.XfireCreateKeyValue("begin_hour",beginTime.Hour.ToString()), Helper.XfireCreateKeyValue("begin_minute",beginTime.Minute.ToString()), Helper.XfireCreateKeyValue("begin_second",beginTime.Second.ToString()), Helper.XfireCreateKeyValue("end_year",endTime.Year.ToString()), Helper.XfireCreateKeyValue("end_month",endTime.Month.ToString()), Helper.XfireCreateKeyValue("end_day",endTime.Day.ToString()), Helper.XfireCreateKeyValue("end_hour",endTime.Hour.ToString()), Helper.XfireCreateKeyValue("end_minute",endTime.Minute.ToString()), Helper.XfireCreateKeyValue("end_second",endTime.Second.ToString()) }; this.service.Url = UserPermissionContext.Instance.Url; RetMapInVector result = ServiceClient.GetForestData(requestData); //RetMapInVector result = this.service.GetForestData(requestData); if (!result.retbool) { if (logger.IsWarnEnabled) { logger.Warn(result.estr); } return null; } DataTable dt = CreateDataTable1(templet, result.vmap); return dt; }
/// <summary> /// 1 /// </summary> /// <param name="templet"></param> /// <param name="data"></param> /// <returns></returns> public DataTable CreateDataTable1(MonitorTemplet templet, anyType2anyTypeMapEntry[][] data) { DataTable Primarydt = new DataTable(); DataTable Measuredt = new DataTable(); DataTable Imgdt = new DataTable(); Imgdt.Columns.Add(new DataColumn("ʱ��", typeof(DateTime))); Imgdt.Columns.Add(new DataColumn("��¼״̬", typeof(String))); Imgdt.Columns.Add(new DataColumn("����", typeof(String))); NameValueCollection ImgTextName = new NameValueCollection(); ImgTextName.Add("creat_time", "ʱ��"); ImgTextName.Add("record_status", "��¼״̬"); ImgTextName.Add("dstr", "����"); int j = 0; foreach (NameValueCollection returnItem in templet.Returns.Values) { if (returnItem.Get("sv_drawimage") != null) { if (j < 1) { if ((returnItem["sv_drawimage"] == "1") && (returnItem["sv_primary"] == "1")) { headtitle = returnItem["sv_label"]; ImgTextName.Add(returnItem["sv_name"], returnItem["sv_label"]); Imgdt.Columns.Add(new DataColumn(returnItem["sv_label"], typeof(Double))); j = j + 1; } } } } NameValueCollection PrimaryTextName = new NameValueCollection(); NameValueCollection MeasureTextName = new NameValueCollection(); Primarydt.Columns.Add(new DataColumn("����", typeof(String))); Primarydt.Columns.Add(new DataColumn("ʱ��", typeof(DateTime))); Primarydt.Columns.Add(new DataColumn("��¼״̬", typeof(String))); PrimaryTextName.Add("creat_time", "ʱ��"); PrimaryTextName.Add("record_status", "��¼״̬"); Measuredt.Columns.Add(new DataColumn("record_status", typeof(String))); MeasureTextName.Add("record_status", "��¼״̬"); foreach (NameValueCollection returnItem in templet.Returns.Values) { if (returnItem.Get("sv_primary") != null) { if (returnItem["sv_primary"] == "1") { PrimaryTextName.Add(returnItem["sv_name"], returnItem["sv_label"]); Primarydt.Columns.Add(new DataColumn(returnItem["sv_label"], typeof(Double))); } } // sv_drawmeasure if (returnItem.Get("sv_drawimage") != null) { if (returnItem["sv_drawimage"] == "1") { if (returnItem["sv_name"] != null) { MeasureTextName.Add(returnItem["sv_name"], returnItem["sv_label"]); Measuredt.Columns.Add(new DataColumn(returnItem["sv_name"], typeof(Double))); } } } } DataRow dr = null; IList<NameValueCollection> resultData = Helper.XfireConventMapEntryToList(data); foreach (NameValueCollection nameValueCollection in resultData) { dr = Primarydt.NewRow(); dr["����"] = string.IsNullOrEmpty(this.Name) ? "" : this.Name; foreach (string key in nameValueCollection.AllKeys) { if (PrimaryTextName.Get(key) != null) { string clumnname = PrimaryTextName[key]; if (Primarydt.Columns[clumnname].DataType.Equals(typeof(Double))) { double value = 0; Double.TryParse(nameValueCollection[key], out value); dr[clumnname] = value; } else { dr[clumnname] = nameValueCollection[key]; } } } Primarydt.Rows.Add(dr); } //foreach (MapType map in data) //{ // dr = Primarydt.NewRow(); // dr["����"] = string.IsNullOrEmpty(this.Name) ? "" : this.Name; // foreach (KeyValue keyvalue in map.Map) // { // if (PrimaryTextName.Get(keyvalue.Key) != null) // { // string clumnname = PrimaryTextName[keyvalue.Key]; // if (Primarydt.Columns[clumnname].DataType.Equals(typeof(Double))) // { // double value = 0; // Double.TryParse(keyvalue.Value, out value); // dr[clumnname] = value; // } // else // { // dr[clumnname] = keyvalue.Value; // } // } // } // Primarydt.Rows.Add(dr); //} //foreach (NameValueCollection nameValueCollection in resultData) //{ // dr = dt.NewRow(); // dr["����"] = this.Name; // foreach (string key in nameValueCollection.AllKeys) // { // string clumnname = TextName[key]; // if (dt.Columns[clumnname].DataType.Equals(typeof(Double))) // { // double value = 0; // Double.TryParse(nameValueCollection[key], out value); // dr[clumnname] = value; // } // else // { // dr[clumnname] = nameValueCollection[key]; // } // } // dt.Rows.Add(dr); //} DataRow dr1 = null; foreach (NameValueCollection nameValueCollection in resultData) { dr1 = Measuredt.NewRow(); for (int i = 0; i < Measuredt.Columns.Count; i++) { dr1[i] = 0.00; } bool rowadd = false; foreach (string key in nameValueCollection.AllKeys) { if (MeasureTextName.Get(key) != null) { if (Measuredt.Columns[key].DataType.Equals(typeof(Double))) { double value = 0; rowadd = Double.TryParse(nameValueCollection[key], out value); dr1[key] = value; } else { dr1[key] = nameValueCollection[key]; } //if (nameValueCollection[key].Equals("ok")) //{ // rowadd = true; //} } } if (rowadd) { Measuredt.Rows.Add(dr1); } } foreach (NameValueCollection nameValueCollection in resultData) { dr1 = Imgdt.NewRow(); foreach (string key in nameValueCollection.Keys) { if (ImgTextName.Get(key) != null) { string clumnname = ImgTextName[key]; if (Imgdt.Columns[clumnname].DataType.Equals(typeof(Double))) { double value = 0; Double.TryParse(nameValueCollection[key], out value); dr1[clumnname] = value; } else { dr1[clumnname] = nameValueCollection[key]; } } } Imgdt.Rows.Add(dr1); } //DataRow dr1 = null; //foreach (MapType map in data) //{ // dr1 = Measuredt.NewRow(); // for (int i = 0; i < Measuredt.Columns.Count; i++) // { // dr1[i] = 0.00; // } // bool rowadd = false; // foreach (KeyValue keyvalue in map.Map) // { // if (MeasureTextName.Get(keyvalue.Key) != null) // { // if (Measuredt.Columns[keyvalue.Key].DataType.Equals(typeof(Double))) // { // double value = 0; // Double.TryParse(keyvalue.Value, out value); // dr1[keyvalue.Key] = value; // } // else // { // dr1[keyvalue.Key] = keyvalue.Value; // } // if (keyvalue.Value.Equals("ok")) // { // rowadd = true; // } // } // } // if (rowadd) // { // Measuredt.Rows.Add(dr1); // } //} if (Measuredt.Rows.Count == 0) { DataRow dr2 = null; dr2 = Measuredt.NewRow(); foreach (string key in MeasureTextName.Keys) { if (string.IsNullOrEmpty(key)) { continue; } if (Measuredt.Columns[key].DataType.Equals(typeof(Double))) { dr2[key] = 0.0; } else { dr2[key] = MeasureTextName[key]; } } Measuredt.Rows.Add(dr2); } this.PrimaryTable = Primarydt; this.MeasureTable = Measuredt; this.ImgTable = Imgdt; return Primarydt; }