form1.cs

c#用友工具

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
using Microsoft.Win32;
using System.Net;

namespace uftool
{
    public partial class Form1 : Form
    {
        SqlConnection sqlconn = new SqlConnection();
        SqlConnection sqlconn2 = new SqlConnection();
        bool error;
        string errorstr;  
        public Form1()
        {
            InitializeComponent();
            
            
            this.button2.Enabled = false;

            //tab1
            this.dataGridView1.AllowUserToAddRows = false;
            this.dataGridView2.ContextMenuStrip = contextMenuStrip2;
            this.dataGridView2.AllowUserToAddRows = false;
            this.dataGridView1.Enabled = false;
            this.dataGridView1.ContextMenuStrip.Enabled = false;
            this.button3.Enabled = false;
            this.button8.Enabled = false;
            this.button7.Enabled = false;


            //tab2
            this.button9.Enabled = false;
            this.button10.Enabled = false;
            this.button11.Enabled = false;
            this.dataGridView2.Enabled = false;
            this.dataGridView2.ContextMenuStrip.Enabled = false;
            this.comboBox1.Enabled = false;


            //tab3
            this.checkedListBox1.Enabled = false;
            this.comboBox2.Enabled = false;
            this.button4.Enabled = false;
            this.checkedListBox1.Enabled = false;
            this.button6.Enabled = false;
            
        }

        private void button1_Click(object sender, EventArgs e)
        {
             //sqlconn.ConnectionString="SERVER=.;
            try
            {
                sqlconn.ConnectionString = "server=" + this.servername.Text.ToString() + ";database=ufsystem;uid=sa;pwd=" + this.pwd.Text.ToString() + ";";
                sqlconn.Open();
                sqlconn2.ConnectionString = "server=" + this.servername.Text.ToString() + ";database=master;uid=sa;pwd=" + this.pwd.Text.ToString() + ";";
                sqlconn2.Open();
            }
            catch
            {
                MessageBox.Show("连接异常，确定输入正确的服务器名称与SA密码!");
            }
                if (sqlconn.State == ConnectionState.Open)
                {
                    //from 
                    this.button2.Enabled = true;
                    this.button1.Enabled = false;
                    //tab1

                    this.dataGridView1.Enabled = true;
                    this.dataGridView1.ContextMenuStrip.Enabled = true;
                    this.button3.Enabled = true;
                    this.button8.Enabled = true;
                    this.button7.Enabled = true;

                    this.updataview();  　　　　　//显示所有任务
                    //tab2

                    this.button9.Enabled = true;
                    this.button10.Enabled = true;
                    this.button11.Enabled = true;
                    this.dataGridView2.Enabled = true;
                    this.dataGridView2.ContextMenuStrip.Enabled = true;
                    this.comboBox1.Enabled = true;
                    listufida();                    //显示所有帐套


                    //tab3
                    listcheckufida();
                    listufida2();
                    this.checkedListBox1.Enabled = true;
                    this.button6.Enabled = true;                    
                    this.comboBox2.Enabled = true;
                    this.button4.Enabled = true;
                    
                    




                    //listcommboxzt();  //枚举checkbox对象内容


                }
                else
                {
                    MessageBox.Show("连接数据库异常");
                }

                
            
        }
        private void updataview()
        {
            try
            {
                SqlCommand sqlcomm = new SqlCommand("select cSub_id,cSub_Name,CTASKID,cStation,dInTime FROM UA_TASKLOG", sqlconn);
                SqlDataAdapter ADAP = new SqlDataAdapter();
                ADAP.SelectCommand = sqlcomm;
                sqlcomm.ExecuteNonQuery();
                DataSet DS = new DataSet();
                ADAP.Fill(DS, "TASJT");
                this.dataGridView1.DataSource = DS.Tables["TASJT"];
                this.dataGridView1.EndEdit();
            }
            catch
            {
                MessageBox.Show("显示异常");
            }
            
        }

        private void 取ToolStripMenuItem_Click(object sender, EventArgs e)
        {

        }

        private void 清除所有作务ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            clearalltask();

        }

        private void 清除选中作务ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            clearselecttask();

        }

        private void button2_Click(object sender, EventArgs e)  //断开连接
        {
            //tab1
            this.dataGridView1.AllowUserToAddRows = false;
            this.dataGridView2.ContextMenuStrip = contextMenuStrip2;
            this.dataGridView2.AllowUserToAddRows = false;
            this.dataGridView1.Enabled = false;
            this.dataGridView1.ContextMenuStrip.Enabled = false;
            this.button3.Enabled = false;
            this.button8.Enabled = false;
            this.button7.Enabled = false;


            //tab2
            this.button9.Enabled = false;
            this.button10.Enabled = false;
            this.button11.Enabled = false;
            this.dataGridView2.Enabled = false;
            this.dataGridView2.ContextMenuStrip.Enabled = false;
            this.comboBox1.Enabled = false;


            //tab3
            this.checkedListBox1.Enabled = false;
            this.button6.Enabled = false;
            this.comboBox2.Enabled = false;
            this.button4.Enabled = false;


            sqlconn2.Close();
            sqlconn.Close();
            this.button2.Enabled = false;
            this.button1.Enabled = true;


            int xx = this.dataGridView1.Rows.Count;
           
            for (int i = 0; i < xx; i++)
            {
                this.dataGridView1.Rows.Remove(dataGridView1.Rows[0]);

            }
            this.dataGridView1.Enabled = false;
        }
        
      
        private void listufida()　　　//列出所有帐套
        {

            try
            {
                
                SqlCommand sqlcomm = new SqlCommand("select name from sysdatabases where name like 'ufdata_%'", sqlconn2);
                SqlDataAdapter adap = new SqlDataAdapter();
                adap.SelectCommand = sqlcomm;
                DataSet ds = new DataSet();
                adap.Fill(ds, "temp");

                for (int i = 0; i < ds.Tables["temp"].Rows.Count; i++)
                {
                    string str = ds.Tables["temp"].Rows[i].ItemArray[0].ToString();
                    this.comboBox1.Items.Add(str);
                    //this.comboBox1.Items.Add(
                }
            }
            catch
            {
                MessageBox.Show("帐套显示异常");
            }
        }

        private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
        {
            listufidadataview();   //显示锁定单据
        }
        private void listufidadataview()　　　//显示锁定单据
        {
            try
            {
                SqlConnection sqlconnx = new SqlConnection("server=" + this.servername.Text.ToString() + ";database=" + this.comboBox1.SelectedItem.ToString() + ";uid=sa;pwd=" + this.pwd.Text.ToString() + ";");
                sqlconnx.Open();
                if (sqlconn.State == ConnectionState.Open)
                {
                    SqlCommand sqlcommx = new SqlCommand("select cvouchtype,id,cauth,cuser,cworkstation from lockvouch", sqlconnx);
                    SqlDataAdapter adap = new SqlDataAdapter();
                    adap.SelectCommand = sqlcommx;
                    DataSet ds = new DataSet();
                    adap.Fill(ds, "temp");
                    this.dataGridView2.DataSource = ds.Tables["temp"];
                    sqlconnx.Close();
                }
                else
                {
                    MessageBox.Show("锁定单据显示异常");
                }
            }
            catch
            {

            }

  
        }

        private void 清除选中行ToolStripMenuItem_Click(object sender, EventArgs e)  //lockvouch
        {
            clearselectlock();
          
        }

        private void button4_Click(object sender, EventArgs e)
        {
          
           
        }

        private void checkedListBox1_SelectedIndexChanged(object sender, EventArgs e)
        {
          
        }

        private void checkedListBox1_ItemCheck(object sender, ItemCheckEventArgs e)   //选择项发生改变时事件
        {
        }
        private void listcommboxzt()      //枚举显示commbox帐套号
        {
            if (sqlconn.State ==ConnectionState.Open)
            {
                try
                 {
                     
                    checkedListBox1.Items.Clear();
                    SqlCommand sqlcomm=new SqlCommand("select cacc_id,cacc_name FROM UA_ACCOUNT",sqlconn);