2011-2-26

2010-12-10

100．Oracle排序分页:

SELECT * From
 (
    Select Rownum rn,t.* From
      (
        SELECT con_contract.con_systemcode, contype, subtype, concode, contractname, hostcode, fccode, exchrate, initsum, initsum_fc, approvesum, approvesum_fc, costsum, costsum_fc, briefing, constatus, uocode, createuser, createdate, approveuser, approvedate, archivesuser, commissioner, pri, inceptdate, deadlinedate, handover, historyflag, coopstatus, opposingunit, balanceunit, affixtounit, affixtoaddress, affixtodate, con_contract.update_datetime, employeeno, systemid,con_contract.vary_num,vary_cause,vary_note,vary_man,varyischeck,vary_datetime,varycheck_dt,varycheck_man,catalogcode,varywithapp,balance_ocode,con_contract.linkconsystemcode,0 selected
        FROM ng0004.con_contract,ng0004.uv_con_baseinfo 
        where con_contract.con_systemcode = uv_con_baseinfo.con_systemcode   
        and (historyflag=0 or historyflag is null or (historyflag=1 and (handover =1)))
        order by con_contract.createdate desc
      ) t
      Where Rownum <= '500'
 )
 Where rn > '400'

 

2010-12-27

101．DataTable访问删除的行

if (varRow.RowState == DataRowState.Deleted)

{

stringhostcode=varRow["hostcode",

DataRowVersion.Original].ToString();

stringcontentcode=varRow["content_code"

,DataRowVersion.Original].ToString();

}

 

2011-1-7

102．TreeView 查找节点并选中

    if (this.dataConSerachControl1.ngGroupBy.EditValue == DBNull.Value ||

                 this.dataConSerachControl1.ngGroupBy.EditValue == null) return;

            string serachText = this.dataConSerachControl1.ngText.Text.Trim();

            DataRow[] drs = ds.Tables["dt1"].Select("con_systemcode = '"+serachText+"'");

            if(drs.Length > 0)

            {

                TreeNode node = new TreeNode();

                node.Tag = serachText;

                node.Text = serachText + "|" + drs[0]["contractname"].ToString();

                node.Name = serachText + "|" + drs[0]["contractname"].ToString();            

                TreeNode[] nodes = this.ngTree.Nodes.Find(node.Name,true);

                if (nodes.Length > 0)

                {

                    this.ngTree.SelectedNode = nodes[0];

                    this.ngTree.Focus();

                    或者

this.SourceTreeView.SelectNode(nodes[0]);

                }

            }

 

103.树添加节点

  if (SourceTreeView.SelectedNodes == null)

            {

                MessageBox.Show(this, Res.qxzzbsdhtxx, Res.DataEntityForInfoChose_Cue, MessageBoxButtons.OK, MessageBoxIcon.Information);

                return;

            }

 

            for (int i = 0; i < SourceTreeView.SelectedNodes.Count; i++)

            {

                TreeNode node = this.SourceTreeView.SelectedNodes[i] as TreeNode;

   

                if (node.Level == 0) return;//一级结点不用拷贝

 

                TreeNode pnode = node.Parent.Clone() as TreeNode;//父节点

                TreeNode tempnode = node.Clone() as TreeNode;

 

                TreeNode[] nodes = this.IndividualTreeView.Nodes.Find(node.Name, true);

                if (nodes.Length > 0)

                {

                    MessageBox.Show(String.Format(Res.TreeIndividualForm_DotIs, tempnode.Text));  //"节点["+ tempnode.Text + "]已存在"

                    continue; //结点已经存在

                }

 

                TreeNode[] parentnodes;

                if (node.Level == 3)

                {

                    parentnodes = this.IndividualTreeView.Nodes.Find(node.Parent.Parent.Name, true); //寻找父节点的父节点

                }

                else

                {

                    parentnodes = this.IndividualTreeView.Nodes.Find(node.Parent.Name, true); //寻找父节点

                }

                if (parentnodes.Length > 0)

                {

                    if (node.Level == 3)

                    {

                        TreeNode[] pparentnodes = this.IndividualTreeView.Nodes.Find(node.Parent.Name, true); //寻找父节点

                        if (pparentnodes.Length > 0)

                        {

                            pparentnodes[0].Nodes.Add(tempnode);//挂载到父节点下面

                        }

                        else

                        {

                            pnode.Nodes.Clear();

                            pnode.Nodes.Add(tempnode);

                            parentnodes[0].Nodes.Add(pnode);

                        }

                    }

                    else

                    {

                        parentnodes[0].Nodes.Add(tempnode);//挂载到父节点下面

                    }

                }

                else

                {

                    //顺带把父节点也加过来

                    //if (tempnode.Nodes.Count == 0 && pnode.Tag.ToString() != "root")

                    if (pnode.Tag.ToString() != "root")

                    {

                        if (node.Level == 3)

                        {

                            TreeNode ppnode = node.Parent.Parent.Clone() as TreeNode;

                            ppnode.Nodes.Clear();

                            ppnode.Nodes.Add(pnode);

                            pnode.Nodes.Clear();

                            pnode.Nodes.Add(tempnode);

                            this.IndividualTreeView.Nodes[0].Nodes.Add(ppnode);

                        }

                        else

                        {

                            pnode.Nodes.Clear();

                            pnode.Nodes.Add(tempnode);

                            this.IndividualTreeView.Nodes[0].Nodes.Add(pnode);

                        }                            

                    }

                    else

                    {

                        this.IndividualTreeView.Nodes[0].Nodes.Add(tempnode);

                    }

                }

                this.IndividualTreeView.SelectNode(tempnode);

                //this.IndividualTreeView.SelectNode(this.IndividualTreeView.Nodes[0]);               

            }

            isChanged = true;

            this.IndividualTreeView.ExpandAll();

 

104．Lookupedit控件绑定数据字段类型

DataTable dt = new DataTable();

dt.Columns.Add("id", typeof(int));注意类型 不然可能赋值不上

dt.Columns.Add("name", typeof(string));

 

2011-1-21

106．获取上一级目录

filePath = AppDomain.CurrentDomain.BaseDirectory + "..//dbcnt//funcimport.txt";

 

107.读取.txt文件

string filePath = string.Empty;

string sLine = string.Empty;

StreamReader sr = null;

filePath = AppDomain.CurrentDomain.BaseDirectory + "..//dbcnt//funcimport.txt";

sr = new StreamReader(filePath, Encoding.Default);

while (sLine != null)

{

    sLine = sr.ReadLine();

    if (!string.IsNullOrEmpty(sLine))

    {

         string[] sLines = sLine.Split('/t');

}

}

 

2011-2-10

108． Sqlserver 与 oracle update…from..用法

Sqlserver:

update con_productbill set con_productbill.vary_num = con_contract.vary_num

from con_contract,con_productbill

where  con_contract.vary_num > 0  and con_contract.con_systemcode = con_productbill.con_systemcode and con_productbill.vary_num is null

oracle:

Update Con_Productbill

Set Con_Productbill.Vary_Num =  (

Select Con_Contract.vary_num

From Con_Contract

Where Con_Contract.Vary_Num > 0 And Con_Contract.Con_Systemcode = Con_Productbill.Con_Systemcode And

           (Con_Productbill.Vary_Num Is Null Or Con_Productbill.vary_num = 0)

)

Where Con_Productbill.Vary_Num  Is Null Or Con_Productbill.Vary_Num = 0

 

2011-2-24

109．树结点key,value用法

string key1 = dr["node1_tag"].ToString();

string value1 = dr["node1_text"].ToString();

if (!treeView.Nodes[0].Nodes.ContainsKey(key1))

{

      treeView.Nodes[0].Nodes.Add(key1, value1).Tag = key1;

}

string key2 = dr["node2_tag"].ToString();

string value2 = dr["node2_text"].ToString();

if (!treeView.Nodes[0].Nodes[key1].Nodes.ContainsKey(key2))

{

     treeView.Nodes[0].Nodes[key1].Nodes.Add(key2, value2).Tag = key2;

}

 

110.委托回调简用

public delegate void SaveEventHandler(string text);

子窗:

public SaveEventHandler save;

 

if (save != null)

save(this.proidDrop.EditValue.ToString());

父窗:

SaveEventHandler hander = new SaveEventHandler(OnNumberChanged);

frm.save = hander;

 

public void OnNumberChanged(string text)

{

     this.proidDrop.EditValue = text;

}