chenxu4277

net use \\192.168.1.2 ""  /user:"Administrator"

 private  string CmdPing(string strIp)
        {

            Process p = new Process();

            p.StartInfo.FileName = "cmd.exe";

            p.StartInfo.UseShellExecute = false;

            p.StartInfo.RedirectStandardInput = true;

            p.StartInfo.RedirectStandardOutput = true;

            p.StartInfo.RedirectStandardError = true;

            p.StartInfo.CreateNoWindow = true;

            string pingrst;

            p.Start();

            p.StandardInput.WriteLine("ping -n 1 " + strIp);

            p.StandardInput.WriteLine("exit");

            string strRst = p.StandardOutput.ReadToEnd();

            if (strRst.IndexOf("(0% loss)") != -1)

                pingrst = "连接";

            else if (strRst.IndexOf("Destination host unreachable.") != -1)

                pingrst = "无法到达目的主机";

            else if (strRst.IndexOf("Request timed out.") != -1)

                pingrst = "超时";

            else if (strRst.IndexOf("Unknown host") != -1)

                pingrst = "无法解析主机";

            else

                pingrst = strRst;

            p.Close();

            return pingrst;

        }

tcp 发送

public static bool NetworkCommand(string CommandText, string Ip, string Port)
        {
            try
            {
                byte[] bt = System.Text.Encoding.Default.GetBytes(CommandText);

                IPEndPoint ep = new IPEndPoint(IPAddress.Parse(Ip), Convert.ToInt32(Port));
                TcpClient tc = new TcpClient();
                tc.Connect(ep);

                NetworkStream nstream = tc.GetStream();
                nstream.Write(bt, 0, bt.Length);
                tc.Close();

                return true;
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return false;
        }

tcp监听

private void SocketLis()
        {
            Int32 port = Config.SocketPort;
            IPAddress localAddr = IPAddress.Any;//(/*"117.25.162.138"/*"127.0.0.1"*/);
           // IPAddress localAddr = IPAddress.Parse("127.0.0.1");
            tcl = new TcpListener(localAddr, port);
            tcl.Start();
            DrawListView("在" + port.ToString() + "端口启动监听");
            while (true)
            {
               
                TcpClient tc = tcl.AcceptTcpClient();
                DrawListView("收到网络上的信息");
                NetworkStream netstream = tc.GetStream();
                byte[] bt = new byte[256];
                int i;
                string revdate="";
                DateTime dt;
                while ((i = netstream.Read(bt, 0, bt.Length)) != 0)
                {
                    revdate = System.Text.Encoding.Default.GetString(bt, 0, i);
                }
                DrawListView(revdate);
                try
                {
                    dt = DateTime.Parse(revdate);
                    TimeSpan ts = dt - DateTime.Now;
                    if (ts.Ticks > 0)
                    {
                        tr.Change(ts, new TimeSpan(-1));  
                    }
                }
                catch(Exception ex)
                {
                    DrawListView("Socket接收出错:"+ex.Message);
                }
            }
        }

        请看看我用的去掉表里组合字段重复的记录方法：

        假设原始表名为source_table,字段名1为field_name1,字段名2为field_name2。

        （当然稍加修改也可以用到三个及以上组合字段重复的情况）

        第一步: 生成组合字段重复的临时表source_dup_simple
        create table source_dup_simple
        nologging
        pctfree 1 pctused 99
        as select field_name1,field_name2,count(0) as num from source_table
        group by field_name1,field_name2 having count(0)>1;

        第二步: 生成组合字段重复的主表里完整记录的临时表source_dup
        create table source_dup
        nologging
        pctfree 1 pctused 99
        as select t1.* from source_table t1,source_dup_simple t2
        where t1.field_name1=t2.field_name1 and t1.field_name2=t2.field_name2;

        第三步: 删去source_dup里的重复记录

        --可选择:保留rowid小的记录
        delete from source_dup a where rowid > (
        select min(rowid) from source_dup b where
        a.field_name1 = b.field_name1 and a.field_name2=b.field_name2);
        commit;

        --可选择:保留rowid大的记录
        delete from source_dup a where rowid < (
        select max(rowid) from source_dup b where
        a.field_name1 = b.field_name1 and a.field_name2=b.field_name2);
        commit;

        注意:如果操作一万条以上的记录最好在source_dup的field_name1和field_name2字段上建索引.

             如果想按别的删除规则，如保留日期最新的记录：

             --可选择:保留时间字段date_field大的记录

             delete from source_dup a where date_field < (
                select max(date_field) from source_dup b where
                a.field_name1 = b.field_name1 and a.field_name2=b.field_name2);
             commit;

             --可选择:保留时间字段date_field小的记录

             delete from source_dup a where date_field > (
                select min(date_field) from source_dup b where
                a.field_name1 = b.field_name1 and a.field_name2=b.field_name2);
             commit;

             如果时间字段上有重复,还需要再次根据rowid来删一次

             delete from source_dup a where rowid < (
                select max(rowid) from source_dup b where
                a.field_name1 = b.field_name1 and a.field_name2=b.field_name2);
             commit;

        第四步: 删去所有重复组合字段原始表里记录
        delete from source_table
        where field_name1||field_name2 in (select field_name1||field_name2 from source_dup_simple);
        commit;

        注意:如果操作一万条以上的记录最好在source_table的field_name1和field_name2字段上建索引.

        第五步: 把剩下的没有重复的记录插回原始表
        insert into source_table select * from source_dup;
        commit;

一个用FileStream来复制文件的小程序


相比用File.Copy()方法，我觉得有两个好处
1：可以实时显示文件进度
2：当文件拷贝到一半发生异常时不会造成目标文件不可用，（用FileStream，文件可播放已拷贝部分的片段)


贴上代码：

 1       private void button1_Click(object sender, EventArgs e)
 2        {
 3            FileStream fsr = null;
 4            FileStream fsw = null;
 5            try
 6            {
 7                this.progressBar1.Maximum =100;
 8                fsr = new FileStream(this.textBox1.Text, FileMode.Open);
 9                fsw = new FileStream(this.textBox2.Text, FileMode.Create);
10                byte[] bt = new byte[1024*1024];
11                int rcount = 0;
12                do
13                {
14                    Application.DoEvents();
15                    rcount = fsr.Read(bt, 0, bt.Length);
16                    fsw.Write(bt, 0, rcount);
17                    //this.progressBar1.Value = Convert.ToInt32(fsw.Length);
18                    this.progressBar1.Value = ((int)(((float)fsw.Length / (float)fsr.Length)*100 )) ;
19                    Application.DoEvents();
20                } while (rcount != 0);
21                fsr.Close();
22                fsw.Close();
23            }
24            catch (Exception ex)
25            {
26                if (fsr != null)
27                {
28                    fsr.Close();
29                    fsr = null;
30                }
31  &n