亚洲福利视频在线,在线一区二区日韩,欧美午夜欧美

天书 — Mon, 21 Oct 2013 09:05:00 GMT

namespace OSSDOM.DataQuality.CommonSL.Control
{
    public partial class SelectToMonth : UserControl
    {
        #region select title property
        public static readonly DependencyProperty SelectTitleProperty =
            DependencyProperty.Register("SelectTitle", typeof(String), typeof(SelectToMonth), null);//�q�块是类�?/span>
        public string SelectTitle
        {
            get { return (string)GetValue(SelectTitleProperty); }
            set
            {
                SetValue(SelectTitleProperty, value);
            }
        }
        #endregion

    xmlns="    xmlns:x="    xmlns:d="    xmlns:mc="    mc:Ignorable="d"
    d:DesignHeight="27" d:DesignWidth="220" x:Name="userControl">

Text="{Binding SelectTitle, ElementName=userControl}" /> //�q�块是控�?/span>名称userControl

SelectTitle="�l�束旉��" />

天书 2013-10-21 17:05 发表评论

C# winform DevExpress GridControl GridView大批量数据（20万条�Q�导出Excel

天书 — Sat, 12 Oct 2013 07:29:00 GMT

DevExpress GridControl GridView大批量数据（20万条�Q�导出Excel�Q?�׃��03版的Excel每个Sheet��只能承�?5536条数据，故自带的ExportToExcelOld及ExportToPdf函数在导�?0W条数据时�Q�只能导出前65536条数据，其他数据丢失�?所以自己写导出函数�Q�可以分sheet��|��写，用到Excel�l��g�Q�但是速度比较慢，现用数据��的方式来写�Q�代码如下：

1public static void GridViewToExcel(Stream myStream, DevExpress.XtraGrid.Views.Grid.GridView dataGridView1)
2        {
3            StreamWriter sw = new StreamWriter(myStream, System.Text.Encoding.GetEncoding("gb2312"));
4            string str = "";
5            try
6            {
7                //写标�?nbsp;
8                for (int i = 1; i < dataGridView1.Columns.Count; i++)
9                {
10                    if (!string.IsNullOrEmpty(dataGridView1.Columns[i].Caption))
11                    {
12                        if (i > 1)
13                        {
14                            str += "\t";
15                        }
16                        str += dataGridView1.Columns[i].Caption;
17                    }
18                }
19
20                sw.WriteLine(str);
21                //写内�?nbsp;
22                for (int j = 0; j < dataGridView1.RowCount; j++)
23                {
24                    string tempStr = "";
25                    for (int k = 1; k < dataGridView1.Columns.Count; k++)
26                    {
27                        if (!string.IsNullOrEmpty(dataGridView1.Columns[k].Caption))
28                        {
29                            if (k > 1)
30                            {
31                                tempStr += "\t";
32                            }
33                            tempStr += dataGridView1.GetRowCellValue(j, dataGridView1.Columns[k].FieldName);
34                        }
35                    }
36                    sw.WriteLine(tempStr);
37                }
38                sw.Close();
39                myStream.Close();
40            }
41            catch (Exception ex)
42            {
43                MessageBox.Show(ex.ToString());
44            }
45            finally
46            {
47                sw.Close();
48                myStream.Close();
49            }
50
51        }

天书 2013-10-12 15:29 发表评论

dataPager大数据量数据�l�定呈现�Ӟ��Ҏ��分页��L��引动态加载数据源

天书 — Mon, 15 Apr 2013 07:35:00 GMT

private void MakePager_BigData()

{

try

{

var itemCount = new List();//数据源��d��多少数据的整形链�?/span>

int pageCount = IDList.Count / dataGridPageSize; //计算出��d��多少��?/span>

for (int i = 0; i < pageCount; i++)

{

itemCount.Add(i);

}

PagedCollectionView pcv = new PagedCollectionView(itemCount);//创徏PagedCollectionView

if (pcv != null)

{

pcv.PageSize = 1;//讄��PagedCollectionView的每��|��C?/span>1条数据（虚拟对应的，��Z��?/span>datagrid对应�Q?/span>

dataPager1.PageSize = 1;//讄��dataPager每页昄��1条数据（虚拟对应的，��Z��?/span>datagrid对应�Q?/span>

this.dataPager1.Source = pcv;//讄��dataPager的数据源

}

catch (Exception ex) { MessageBox.Show(ex.Message + ex.StackTrace); }

}

//�Ҏ��늃�引动态绑定数据源

private void dataPager1_PageIndexChanged(object sender, EventArgs e)

{

int curPageIdx = dataPager1.PageIndex;

int skipData = curPageIdx * dataGridPageSize;

List curBindingDataSource = ((from p in IDList select p).Skip(skipData).Take(dataGridPageSize)).ToList();

dataGrid1.ItemsSource = curBindingDataSource;

}

天书 2013-04-15 15:35 发表评论

silverlight4.0 DataGrid 讄��改变单元格颜�Ԍ��Ҏ��D��|�不同的颜色

天书 — Tue, 07 Dec 2010 08:17:00 GMT

�q�行效果见上图，可以�Ҏ��单元��g��的值来讄��颜色�Q?00%为红�Ԍ��其他为绿艌Ӏ?/div>

实现�Ҏ��Q�用列模板绑定数据源中定义的颜色数据��V�?/div>

其中列模板用Border加TextBox构成�Q�代码如下：

private static DataTemplate MakeCellTemplate(MyColumn col)

{

try

{

DataTemplate dt1 = new DataTemplate();

StringBuilder xaml = new StringBuilder();

xaml.Append("

xaml.Append("xmlns='http://schemas.microsoft.com/client/2007' ");

xaml.Append("xmlns:x='http://schemas.microsoft.com/winfx/2006/xaml' ");

xaml.Append(">");

xaml.Append("

xaml.Append("BorderThickness='0.5' BorderBrush='LightGray' Background='Orange'>");

xaml.Append("

xaml.Append("IsReadOnly='True' Text='{Binding " + col.Name + "}' Foreground='Black' BorderBrush='White' BorderThickness='0' Background='{Binding " + col.colorValue + "}'");

xaml.Append("/>");

xaml.Append("");

dt1 = (DataTemplate)XamlReader.Load(xaml.ToString());

return dt1;

}

catch (Exception ex)

{

MessageBox.Show(ex.Message + ex.StackTrace);

return null;

}

天书 2010-12-07 16:17 发表评论

gsoap 生成webservice服务端框�?c++)步骤

天书 — Tue, 23 Nov 2010 12:16:00 GMT

1�Q�首先到gsoap-2.7\gsoap\bin\win32 目录下面�Q?包括两个文�gwsdl2h.exe �?nbsp;

soapcpp2.exe�?把生成好的wsdl文�g也拷贝到�q�个目录下面�?/div>

2�Q�wsdl2h.exe -h看帮助文�Ӟ�� 其中参数-c是生成C语言的，不加参数-c代表C++

的， -s代表不用STL�Q�有时有�q�个标准模板库编译不�q�去�Q�，一般我们用参数-s

"wsdl2h -s Test.wsdl"
详细�|�址�Q�http://wenku.baidu.com/view/68e0fb1252d380eb62946d8e.html 或�?div>

http://wenku.baidu.com/view/ebdd3f29bd64783e09122b7a.html?from=rec&pos=0&weight=30&lastweight=9&count=5�Q?/div>

3:soapcpp2 -h 查看帮助

4�Q�soapcpp2 -S -L -i Test.h生成.cpp文�g
-C 代表生成客户端代�?br />-S 代表生成服务端代�?br />-L 代表不生成soapClientLib/soapServiceLib
-c 代表仅生成c代码
-i 代表使用proxy
通常情况下��用命�?soapcpp2 -S/-C -L -i xxx.h

5�Q�最后生成的.h .cpp .xml文�g中只需要保留下面五个即�?/div>

soapC.cpp

soapH.h

soapService1SoapService.cpp

soapServiceSoapService.h

soapStub.h

天书 2010-11-23 20:16 发表评论

c#插�g间调�?反射)

天书 — Tue, 26 Oct 2010 01:13:00 GMT

IPluginService myPluginService = (IPluginService)this.application.GetService(typeof(IPluginService));

IConfigManageService ConfigService = (IConfigManageService)this.application.GetService(typeof(IConfigManageService));

PluginInfo myPlugin = ConfigService.getPluginInfoByClassType("Inspur.CM.NeGroup");

myPlugin.MethodName = "setConfig";

myPlugin = myPluginService.getPluginByName(myPlugin);

myPlugin.doInvoke(strValue);

天书 2010-10-26 09:13 发表评论

天书 — Mon, 25 Oct 2010 01:57:00 GMT

System.Drawing.Rectangle r = System.Windows.Forms.Screen.GetWorkingArea(recForm);

recForm.Location = new System.Drawing.Point(r.Right - recForm.Width, r.Bottom - recForm.Height);

recForm.Show();

天书 2010-10-25 09:57 发表评论

天书 — Wed, 18 Aug 2010 02:56:00 GMT

DevExpress TreeList加蝲大批量数据的时候绑定数据源 dataTable.

注意事项1�Q?�׃��一旦绑定了数据源dataTable的些许变化便在TreeList中有所体现, 所以等dataTable完全填充好了之后再绑定数据源.

注意事项2�Q�dataTable每行的父节点ID当加载到目前为止,�q�没有找到那么可能就当成�I�Z��, 所以最后treelist呈现��有问题, 所以解军_��法有3�? 1�Q?大范围数�?也就是父节点的数据一定要先于子节点在表中排列.(�q�个不好控制). 2�Q?�{�完全填充完datatable时再重新讄��每行的父节点ID. 3�Q�可以边填充边设�|? 最后再�l�定数据�? 在填充dataTable之前先解�l�数据源, 卛_��把数据源设�ؓ�I?完全填充好再重新�l�定(�l�过��试�q�种�Ҏ��的加载速度最快了)

参看代码如下:

public void ShowData(ForecastService.TrafficResult[] result, int iscrop, bool AllType)

{

//填充数据

try

{

ResetCtrl(AllType);

this.result = result;

treeListResult.Nodes.Clear();

treeListResult.DataSource = null; //一定要先解�l?/strong>

FillTypeFirstData(result, this.dtResult);

treeListResult.DataSource = dtResult;

if (treeListResult.Nodes.Count > 0)

{

for (int i = 0; i < treeListResult.Nodes.Count; i++)

{

treeListResult.Nodes[i].HasChildren = true;

treeListResult.Nodes[i].Expanded = true;

}

catch (Exception ex)

{

MessageBox.Show(ex.Message + ex.StackTrace);

}

private void FillTypeFirstData(Inspur.Forecast.ForecastService.TrafficResult[] result, DataTable dataTable)

{

try

{

dataTable.Rows.Clear();

for (int i = 0; i < result.Length; i++)

{

   if (result[i].trafficType == "ALL" && result[i].city == "ALL")//全省的数�?/div>
   {
   DataRow dr = dataTable.NewRow();
   dr["keyFieldName"] = "湖南";//讄��当前行ID
   dr["parentFieldName"] = DBNull.Value; //讄��父节点ID

   dr["�l�度"] = "湖南";
   dr["��d��基准日话务量"] = result[i].lastFir.Trim();
   dr["��d��预测日话务量"] = result[i].lastSec.Trim();
   dr["增长�q�度"] = result[i].add.Trim();
   dr["今年基准日话务量"] = result[i].nowFir.Trim();

   dr["今年预测日话务量"] = result[i].nowSec.Trim();
   dr["目前电�\�?] = result[i].count.Trim();
   dr["预测2M电�\�?] = result[i].fcastcount.Trim();
   dr["需要新增的电�\�?] = result[i].addcount.Trim();
   dataTable.Rows.Add(dr);
   }
   else if (result[i].trafficType != "ALL" && result[i].city == "ALL" && result[i].nename == "ALL")//汇��d��c�d��的数�?/div>
   {
   DataRow dr = dataTable.NewRow();
   dr["keyFieldName"] = result[i].trafficType;
   dr["parentFieldName"] = "湖南";

   dr["�l�度"] = result[i].trafficType;
   dr["��d��基准日话务量"] = result[i].lastFir.Trim();
   dr["��d��预测日话务量"] = result[i].lastSec.Trim();
   dr["增长�q�度"] = result[i].add.Trim();
   dr["今年基准日话务量"] = result[i].nowFir.Trim();

   dr["今年预测日话务量"] = result[i].nowSec.Trim();
   dr["目前电�\�?] = result[i].count.Trim();
   dr["预测2M电�\�?] = result[i].fcastcount.Trim();
   dr["需要新增的电�\�?] = result[i].addcount.Trim();
   dataTable.Rows.Add(dr);
   }
   else if (result[i].trafficType != "ALL" && result[i].city != "ALL" && result[i].nename == "ALL")//汇��d��地市的数�?/div>
   {
   DataRow dr = dataTable.NewRow();
   dr["keyFieldName"] = result[i].trafficType + "_" + result[i].city;
   dr["parentFieldName"] = result[i].trafficType;

   dr["�l�度"] = result[i].city;
   dr["��d��基准日话务量"] = result[i].lastFir.Trim();
   dr["��d��预测日话务量"] = result[i].lastSec.Trim();
   dr["增长�q�度"] = result[i].add.Trim();
   dr["今年基准日话务量"] = result[i].nowFir.Trim();

   dr["今年预测日话务量"] = result[i].nowSec.Trim();
   dr["目前电�\�?] = result[i].count.Trim();
   dr["预测2M电�\�?] = result[i].fcastcount.Trim();
   dr["需要新增的电�\�?] = result[i].addcount.Trim();
   dataTable.Rows.Add(dr);
   }
   else if (result[i].trafficType != "ALL" && result[i].city != "ALL" && result[i].nename != "ALL" && result[i].middle == "ALL")//汇��d��|�元的数�?/div>
   {
   DataRow dr = dataTable.NewRow();
   dr["keyFieldName"] = result[i].trafficType + "_" + result[i].city + "_" + result[i].nename;
   dr["parentFieldName"] = result[i].trafficType + "_" + result[i].city;

   dr["�l�度"] = result[i].nename;
   dr["��d��基准日话务量"] = result[i].lastFir.Trim();
   dr["��d��预测日话务量"] = result[i].lastSec.Trim();
   dr["增长�q�度"] = result[i].add.Trim();
   dr["今年基准日话务量"] = result[i].nowFir.Trim();

   dr["今年预测日话务量"] = result[i].nowSec.Trim();
   dr["目前电�\�?] = result[i].count.Trim();
   dr["预测2M电�\�?] = result[i].fcastcount.Trim();
   dr["需要新增的电�\�?] = result[i].addcount.Trim();
   dataTable.Rows.Add(dr);
   }
   else if (result[i].trafficType != "ALL" && result[i].city != "ALL" && result[i].nename != "ALL" && result[i].middle != "ALL")//��C��l�的数据
   {
   DataRow dr = dataTable.NewRow();
   dr["keyFieldName"] = result[i].trafficType + "_" + result[i].city + "_" + result[i].nename + "_" + result[i].middle;
   dr["parentFieldName"] = result[i].trafficType + "_" + result[i].city + "_" + result[i].nename;

   dr["�l�度"] = result[i].middle;
   dr["��d��基准日话务量"] = result[i].lastFir.Trim();
   dr["��d��预测日话务量"] = result[i].lastSec.Trim();
   dr["增长�q�度"] = result[i].add.Trim();
   dr["今年基准日话务量"] = result[i].nowFir.Trim();

   dr["今年预测日话务量"] = result[i].nowSec.Trim();
   dr["目前电�\�?] = result[i].count.Trim();
   dr["预测2M电�\�?] = result[i].fcastcount.Trim();
   dr["需要新增的电�\�?] = result[i].addcount.Trim();
   dataTable.Rows.Add(dr);
   }
   }

   }
   catch (Exception ex)
   {
   MessageBox.Show(ex.Message + ex.StackTrace);
   }
   }

public TrafficResultTree(IApplication application)
   {
   InitializeComponent();
   this.application = application;
   SetTreeListColumn("Config\\Forecast\\TrafficForecastResultTree.xml", "/Head", treeListResult);
   //Test
   PublicFunction.SetDataTableColumn(treeListResult, dtResult);
   treeListResult.ParentFieldName = "parentFieldName"; //讄��树的ParentFieldName 属�?/strong>
   treeListResult.KeyFieldName = "keyFieldName"; //讄��树的KeyFieldName 属�?/strong>

   //
   }

public static void SetDataTableColumn(DevExpress.XtraTreeList.TreeList treeListResult, DataTable dtResult)
   {
   try
   {
   dtResult.Columns.Clear();
   DataColumn dcid = new DataColumn("keyFieldName", Type.GetType("System.String"));
   DataColumn dcparentId = new DataColumn("parentFieldName", Type.GetType("System.String"));

   dtResult.Columns.Add(dcid);
   dtResult.Columns.Add(dcparentId);

   for (int i = 0; i < treeListResult.Columns.Count; i++)
   {
   DataColumn dc = new DataColumn(treeListResult.Columns[i].FieldName);
   dtResult.Columns.Add(dc);
   }
   }
   catch (Exception ex)
   {
   MessageBox.Show(ex.Message + ex.StackTrace);
   }
   }

private void InsertRelayData(string time, string type, string cityName, string equipeName, string burName, Inspur.Analysis.AnalysisService.Relay resultRelay)
   {
   try
   {
   DataRow drRelay = dtResult.NewRow();
   drRelay["keyFieldName"] = time + "_" + type + "_" + cityName + "_" + equipeName + "_" + burName + "_" + resultRelay.RelayName + "_" + DateTime.Now.ToString();
   drRelay["parentFieldName"] = time + "_" + type + "_" + cityName + "_" + equipeName + "_" + burName;

   drRelay["�l�度"] = resultRelay.RelayName;
   drRelay["定义电�\�?] = resultRelay.Total.CIRCUITS;
   drRelay["来话试呼�ơ数"] = resultRelay.Total.in_att;
   drRelay["去话试呼�ơ数"] = resultRelay.Total.out_att;
   drRelay["来话应答�ơ数"] = resultRelay.Total.in_ans;
   drRelay["去话应答�ơ数"] = resultRelay.Total.out_ans;

   drRelay["来话话务�?] = resultRelay.Total.in_traf;
   drRelay["去话话务�?] = resultRelay.Total.out_traf;
   drRelay["总话务量"] = resultRelay.Total.traf;
   drRelay["来话市话话务�?] = resultRelay.Total.in_local_traf;
   drRelay["去话市话话务�?] = resultRelay.Total.out_local_traf;

   drRelay["来话长话话务�?] = resultRelay.Total.in_long_traf;
   drRelay["去话长话话务�?] = resultRelay.Total.out_long_traf;
   drRelay["市话话务�?] = resultRelay.Total.local_traf;
   drRelay["长话话务�?] = resultRelay.Total.long_traf;
   dtResult.Rows.Add(drRelay);
   //DevExpress.XtraTreeList.Nodes.TreeListNode noderelay = null;
   //for (int i = 0; i < nodebureauD.Nodes.Count; i++)
   //{
   // if (nodebureauD.Nodes[i]["�l�度"].ToString() == relay.RelayName)
   // {
   // noderelay = nodebureauD.Nodes[i];
   // break;
   // }
   //}
   //if (noderelay == null)
   //{
   // List relayList = new List();
   // relayList.Add(relay.RelayName);

   // noderelay = treeList.AppendNode(relayList.ToArray(), nodebureauD);
   //}
   //if (noderelay != null)
   //{
   // InsertTargetData(noderelay, relay.RelayName, relay.Total);
   //}
   }
   catch (Exception ex)
   {
   MessageBox.Show(ex.Message + ex.StackTrace);
   }
   }

天书 2010-08-18 10:56 发表评论

亚洲福利视频在线,在线一区二区日韩,欧美午夜欧美

C# winform DevExpress GridControl GridView大批量数据（20万条�Q�导出Excel

dataPager大数据量数据�l�定呈现�Ӟ���Ҏ��分页��L��引动态加载数据源

silverlight4.0 DataGrid 讄���改变单元格颜�Ԍ���Ҏ����D���|�不同的颜色

gsoap 生成webservice服务端框�?c++)步骤

c#插�g间调�?反射)

dataPager大数据量数据�l�定呈现�Ӟ��Ҏ��分页��L��引动态加载数据源

silverlight4.0 DataGrid 讄��改变单元格颜�Ԍ��Ҏ��D��|�不同的颜色