form1.cs

c#用友工具

                    DataSet ds = new DataSet();
                    adap.Fill(ds, "temp");
                    for (int i = 0; i < ds.Tables["temp"].Rows.Count; i++)
                    {
                        str = ds.Tables["temp"].Rows[i].ItemArray[0].ToString() + "-" + ds.Tables["temp"].Rows[i].ItemArray[1].ToString();
                        checkedListBox1.Items.Add(str);

                    }
                    sqlcomm.CommandText = "select cacc_id,cacc_name FROM UA_ACCOUNThit";
                    sqlcomm.ExecuteNonQuery();
                    adap.Fill(ds, "temp2");
                    int num = checkedListBox1.Items.Count;
                    for (int i = 0; i < ds.Tables["temp2"].Rows.Count; i++)
                    {
                        str = ds.Tables["temp2"].Rows[i].ItemArray[0].ToString() + "-" + ds.Tables["temp2"].Rows[i].ItemArray[1].ToString();
                        checkedListBox1.Items.Add(str, true);

                    }
                }
                catch
                {
                    MessageBox.Show("添加出错");
                }
               
            }
        }

        private void linkLabel1_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
        {

        }

        private void checkedListBox1_ItemCheck_1(object sender, ItemCheckEventArgs e)
        {

            int x = checkedListBox1.SelectedIndex;
            if (!(x == -1))
            {
                SqlCommand sqlcomm = new SqlCommand();
                sqlcomm.Connection = sqlconn;


                string str = checkedListBox1.Items[checkedListBox1.SelectedIndex].ToString().Substring(0, checkedListBox1.Items[checkedListBox1.SelectedIndex].ToString().IndexOf("-"));
               　
                if (e.CurrentValue.ToString().CompareTo("Checked") == 0)  //  判断之前选择壮态
                {//取消选择隐藏

                    SqlTransaction sqltran = sqlconn.BeginTransaction();
                    sqlcomm.Transaction = sqltran;
                    try
                    {
                        sqlcomm.CommandText = "insert into UA_Account select * from UA_Accounthit where cacc_id='" + str + "'";//UA_Log
                        sqlcomm.ExecuteNonQuery();
                        sqlcomm.CommandText = "delete  from UA_Accounthit where cacc_id='" + str + "'"; ;//UA_Log
                        sqlcomm.ExecuteNonQuery();


                        sqlcomm.CommandText = "insert into UA_Account_sub select * from UA_Account_subhit where cacc_id='" + str + "'";//UA_Log
                        sqlcomm.ExecuteNonQuery();
                        sqlcomm.CommandText = "delete  from UA_Account_subhit where cacc_id='" + str + "'";//UA_Log
                        sqlcomm.ExecuteNonQuery();



                        sqlcomm.CommandText = "insert into  UA_Period select * from UA_Periodhit where cacc_id='" + str + "'";//UA_Log
                        sqlcomm.ExecuteNonQuery();
                        sqlcomm.CommandText = "delete  from UA_Periodhit where cacc_id='" + str + "'";//UA_Log
                        sqlcomm.ExecuteNonQuery();



                        sqlcomm.CommandText = "insert into ua_log select * from  ua_loghit where cacc_id='" + str + "'";//UA_Log
                        sqlcomm.ExecuteNonQuery();
                        sqlcomm.CommandText = "delete  from  ua_loghit where cacc_id='" + str + "'";//UA_Log
                        sqlcomm.ExecuteNonQuery();
                        sqltran.Commit();

                    }
                    catch
                    {
                        sqltran.Rollback();
                        MessageBox.Show("异常情况,未能执行成功！！");
                    }
                }
                else  //选择隐藏
                {
                    SqlTransaction sqltran = sqlconn.BeginTransaction();
                    sqlcomm.Transaction = sqltran;
                    try
                    {
                        sqlcomm.CommandText = "insert into ua_loghit select * from ua_log where cacc_id='" + str + "'";//UA_Log
                        sqlcomm.ExecuteNonQuery();
                        sqlcomm.CommandText = "delete  from UA_Log where cacc_id='" + str + "'";//UA_Log
                        sqlcomm.ExecuteNonQuery();


                        sqlcomm.CommandText = "insert into UA_Periodhit select * from UA_Period where cacc_id='" + str + "'";//UA_Log
                        sqlcomm.ExecuteNonQuery();
                        sqlcomm.CommandText = "delete  from UA_Period where cacc_id='" + str + "'";//UA_Log
                        sqlcomm.ExecuteNonQuery();


                        sqlcomm.CommandText = "insert into UA_Account_subhit select * from UA_Account_sub where cacc_id='" + str + "'";//UA_Log
                        sqlcomm.ExecuteNonQuery();
                        sqlcomm.CommandText = "delete  from UA_Account_sub where cacc_id='" + str + "'";//UA_Log
                        sqlcomm.ExecuteNonQuery();


                        sqlcomm.CommandText = "insert into UA_Accounthit select * from UA_Account where cacc_id='" + str + "'";//UA_Log
                        sqlcomm.ExecuteNonQuery();
                        sqlcomm.CommandText = "delete  from UA_Account where cacc_id='" + str + "'"; ;//UA_Log
                        sqlcomm.ExecuteNonQuery();
                        sqltran.Commit();
                    }
                    catch
                    {
                        sqltran.Rollback();
                        MessageBox.Show("异常情况,未能执行成功2！！");
                    }
                }
            }
                
        }

        private void button12_Click(object sender, EventArgs e)
        {
            tabControl1.SelectTab(1);
        }

        private void button13_Click(object sender, EventArgs e)
        {
            tabControl1.SelectTab(2);
        }

        private void button14_Click(object sender, EventArgs e)
        {
            tabControl1.SelectTab(0);
        }

        private void tabPage3_Click(object sender, EventArgs e)
        {

        }

       

        private void radioButton1_CheckedChanged_1(object sender, EventArgs e)
        {
            tabControl1.SelectTab(0);
        }

        private void radioButton2_CheckedChanged(object sender, EventArgs e)
        {
            tabControl1.SelectTab(1);
        }

        private void radioButton3_CheckedChanged(object sender, EventArgs e)
        {
            tabControl1.SelectTab(2);
        }

        private void linkLabel1_LinkClicked_1(object sender, LinkLabelLinkClickedEventArgs e)
        {
            
        }

        private void button3_Click_2(object sender, EventArgs e)
        {
            clearalltask(); 
        }

        private void button8_Click_1(object sender, EventArgs e)
        {
            clearselecttask();
        }

        private void button9_Click_1(object sender, EventArgs e)
        {
            clearlock();
        }

        private void button10_Click_1(object sender, EventArgs e)
        {
            clearselectlock();
        }

        private void button11_Click_1(object sender, EventArgs e)
        {
            listufidadataview();
        }

        private void button7_Click_1(object sender, EventArgs e)
        {
            updataview();
        }

        private void comboBox1_SelectedIndexChanged_1(object sender, EventArgs e)
        {
            listufidadataview();   //显示锁定单据
        }

        private void listufida2()　　　//列出所有帐套
        {

            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.comboBox2.Items.Add(str);
                    //this.comboBox1.Items.Add(
                }
            }
            catch
            {
                MessageBox.Show("帐套显示异常");
            }
        }

        private void button4_Click_1(object sender, EventArgs e)
        {
            
            if (comboBox2.SelectedIndex == -1)
            {
                MessageBox.Show("请选择账套");
                return;
            }
            try
            {
                string str = comboBox2.SelectedItem.ToString();
                str = "server=" + this.servername.Text.ToString() + ";database=" + comboBox2.SelectedItem.ToString() + ";uid=sa;pwd=" + this.pwd.Text.ToString() + ";";
                SqlConnection strconnfix = new SqlConnection(str);
                strconnfix.Open();
                SqlCommand sqlcomm = new SqlCommand();
                sqlcomm.CommandTimeout = 500;
                sqlcomm.Connection = strconnfix;
                if (strconnfix.State == ConnectionState.Open)
                {
                    sqlcomm.CommandText = "sp_dboption '" + comboBox2.SelectedItem.ToString() + "', 'single user', 'true' ";
                    sqlcomm.ExecuteNonQuery();
                    sqlcomm.CommandText = "DBCC CHECKDB('" + comboBox2.SelectedItem.ToString() + "',REPAIR_FAST)";
                    sqlcomm.ExecuteNonQuery().ToString();                    　
                    sqlcomm.CommandText = "sp_dboption '" + comboBox2.SelectedItem.ToString() + "', 'single user', 'false'";
                    sqlcomm.ExecuteNonQuery();
                    MessageBox.Show("执行完毕");
                }
                else
                {

                    MessageBox.Show("数据库连接错误");
                }
                strconnfix.Close();
            }
            catch (Exception x)
            {                
                MessageBox.Show("执行错误" + e.ToString());
            }
            
        }

        private void label13_Click(object sender, EventArgs e)
        {

        }

      

        private void linkLabel1_LinkClicked_2(object sender, LinkLabelLinkClickedEventArgs e)
        {
           
        }

        private void panel3_Paint(object sender, PaintEventArgs e)
        {

        }

       
    }
}