📄 form1.cs
字号:
sqlcomm.ExecuteNonQuery();
SqlDataAdapter adap = new SqlDataAdapter(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()+ds.Tables["temp"].Rows[i].ItemArray[1].ToString();
MessageBox.Show(str);
}
// SqlCommand sqlcomm = new SqlCommand("select a.cacc_id,a.cacc_name,p.bisdelete from ua_account a,ua_period p Where a.cacc_id = p.cacc_id and p.bisdelete=0 group by a.cacc_id,a.cacc_name,p.bisdelete order by a.cacc_id ", sqlconn);
// sqlcomm.ExecuteNonQuery();
// SqlDataAdapter adap = new SqlDataAdapter(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();
// str += ds.Tables["temp"].Rows[i].ItemArray[1].ToString();
// checkedListBox1.Items.Add(str);
// checkedListBox1.SetItemChecked(i, false);
// }
// SqlCommand sqlcomm2 = new SqlCommand("select a.cacc_id,a.cacc_name,p.bisdelete from ua_account a,ua_period p Where a.cacc_id = p.cacc_id and p.bisdelete=1 group by a.cacc_id,a.cacc_name,p.bisdelete order by a.cacc_id ", sqlconn);
// sqlcomm2.ExecuteNonQuery();
// SqlDataAdapter adap2 = new SqlDataAdapter(sqlcomm2);
// DataSet ds2 = new DataSet();
// adap2.Fill(ds2, "temp");
// int x = checkedListBox1.Items.Count;
// for (int i = 0; i < ds2.Tables["temp"].Rows.Count; i++)
// {
// string str2 = ds2.Tables["temp"].Rows[i].ItemArray[0].ToString();
// str2 += ds2.Tables["temp"].Rows[i].ItemArray[1].ToString();
// checkedListBox1.Items.Add(str2);
// checkedListBox1.SetItemChecked(i + x, true);
}
catch
{
error = true;
errorstr += "枚举显示帐套号出错";
}
}
}
private void button35_Click(object sender, EventArgs e)
{
RegistryKey pregkey;
pregkey = Registry.LocalMachine.OpenSubKey(@"SYSTEM\ControlSet001\Control\Session Manager", true);
if (pregkey == null)
{
MessageBox.Show("fdffddf");
}
else
{
pregkey.SetValue("PendingFileRenameOptions", "", RegistryValueKind.ExpandString);
//pregkey.DeleteValue("PendingFileRenameOptions");
}
}
private void createtable() //建立表
{
//UA_Loghit
checkedListBox1.Items.Clear();
SqlCommand sqlcomm = new SqlCommand("select count (*) from sysobjects where name='UA_Loghit'", sqlconn);
int i = Convert.ToInt32(sqlcomm.ExecuteScalar());
if (!(i == 1))
{
sqlcomm.CommandText = "select * into UA_Loghit from UA_Log where cacc_id='999xxx'";
sqlcomm.ExecuteNonQuery();
}
// UA_Periodhit
sqlcomm = new SqlCommand("select count (*) from sysobjects where name='UA_Periodhit'", sqlconn);
i = Convert.ToInt32(sqlcomm.ExecuteScalar());
if (!(i == 1))
{
sqlcomm.CommandText = "select * into UA_Periodhit from UA_Period where cacc_id='999xxx'";
sqlcomm.ExecuteNonQuery();
}
//UA_Account_subhit
sqlcomm = new SqlCommand("select count (*) from sysobjects where name='UA_Account_subhit'", sqlconn);
i = Convert.ToInt32(sqlcomm.ExecuteScalar());
if (!(i == 1))
{
sqlcomm.CommandText = "select * into UA_Account_subhit from UA_Account_sub where cacc_id='999xxx'";
sqlcomm.ExecuteNonQuery();
}
//ua_accounthit
sqlcomm = new SqlCommand("select count (*) from sysobjects where name='ua_accounthit'", sqlconn);
i = Convert.ToInt32(sqlcomm.ExecuteScalar());
if (!(i == 1))
{
sqlcomm.CommandText = "select * into ua_accounthit from ua_account where cacc_id='999xxx'";
sqlcomm.ExecuteNonQuery();
}
}
private void button6_Click(object sender, EventArgs e)
{
listcheckufida();
}
private void button3_Click(object sender, EventArgs e)
{
}
private void clearalltask() //清除所有任务
{
if (sqlconn.State == ConnectionState.Open)
{
try
{
SqlCommand sqlcomm = new SqlCommand("delete from ua_task", sqlconn);
sqlcomm.ExecuteNonQuery();
sqlcomm.CommandText="delete from ua_tasklog";
sqlcomm.ExecuteNonQuery();
}
catch
{
MessageBox.Show("任务清除失败");
}
}
updataview();
}
private void clearselecttask() // 清除选中任务
{
if (sqlconn.State == ConnectionState.Open)
{
SqlCommand sqlcomm = new SqlCommand("", sqlconn);
string[] str = new string[this.dataGridView1.SelectedRows.Count];
for (int i = 0; i < this.dataGridView1.SelectedRows.Count; i++)
{
str[i] = this.dataGridView1.SelectedRows[i].Cells["cTaskId"].Value.ToString();
}
foreach (string str2 in str)
{
try
{
sqlcomm = new SqlCommand("delete from ua_task where ctaskid=" + str2, sqlconn);
sqlcomm.ExecuteNonQuery();
sqlcomm.CommandText = "delete from ua_tasklog where ctaskid=" + str2;
sqlcomm.ExecuteNonQuery();
}
catch
{
MessageBox.Show("清除所选任务出错");
}
}
updataview();
}
}
private void clearlock() // 清除所有锁定
{
if (this.comboBox1.SelectedIndex == -1)
{
MessageBox.Show("请选择帐套");
return;
}
try
{
SqlConnection sqlconn3 = new SqlConnection();
sqlconn3.ConnectionString = "server=" + this.servername.Text.ToString() + ";database=" + this.comboBox1.SelectedItem.ToString() + ";uid=sa;pwd=" + this.pwd.Text.ToString() + ";";
sqlconn3.Open();
if (sqlconn3.State == ConnectionState.Open)
{
SqlCommand sqlcomm = new SqlCommand("delete from lockvouch", sqlconn3);
sqlcomm.ExecuteNonQuery();
sqlcomm.CommandText = "delete from gl_mvcontrol";
sqlcomm.ExecuteNonQuery();
sqlcomm.CommandText = "delete from gl_mvocontrol";
sqlcomm.ExecuteNonQuery();
sqlcomm.CommandText = "delete from gl_mccontrol";
sqlcomm.ExecuteNonQuery();
sqlconn3.Close();
listufidadataview();
}
else
{
MessageBox.Show("数据库连接出错");
}
}
catch
{
MessageBox.Show("清除锁定出现异常");
}
}
private void clearselectlock() // 清除选中锁定
{
if (this.comboBox1.SelectedIndex == -1)
{
MessageBox.Show("请选择帐套");
return;
}
SqlConnection sqlconn3 = new SqlConnection();
//if(this.comboBox1.SelectedItem.ToString().Length<>0
sqlconn3.ConnectionString = "server=" + this.servername.Text.ToString() + ";database=" + this.comboBox1.SelectedItem.ToString() + ";uid=sa;pwd=" + this.pwd.Text.ToString() + ";";
sqlconn3.Open();
if (sqlconn3.State == ConnectionState.Open)
{
try
{
SqlCommand sqlcomm = new SqlCommand();
sqlcomm.Connection = sqlconn3;
for (int i = 0; i < dataGridView2.SelectedRows.Count; i++)
{
sqlcomm.CommandText = "delete from lockvouch where id=" + dataGridView2.SelectedRows[i].Cells["id"].Value.ToString();
sqlcomm.ExecuteNonQuery();
}
sqlcomm.CommandText = "delete from gl_mvcontrol";
sqlcomm.ExecuteNonQuery();
sqlcomm.CommandText = "delete from gl_mvocontrol";
sqlcomm.ExecuteNonQuery();
sqlcomm.CommandText = "delete from gl_mccontrol";
sqlcomm.ExecuteNonQuery();
sqlconn3.Close();
}
catch
{
MessageBox.Show("清除锁定出错");
}
listufidadataview();
}
}
private void button3_Click_1(object sender, EventArgs e) //清除所有任务
{
clearalltask();
}
private void button8_Click(object sender, EventArgs e) //清除所选任务
{
clearselecttask();
}
private void button7_Click(object sender, EventArgs e) // 刷新任务
{
updataview();
}
private void 清除所有行ToolStripMenuItem_Click(object sender, EventArgs e)
{
clearselectlock();
}
private void 刷新ToolStripMenuItem_Click(object sender, EventArgs e)
{
listufidadataview();
}
private void button9_Click(object sender, EventArgs e)
{
clearlock();
}
private void button10_Click(object sender, EventArgs e)
{
clearselectlock();
}
private void button11_Click(object sender, EventArgs e)
{
listufidadataview();
}
private void listcheckufida()
{
createtable();
if (sqlconn.State == ConnectionState.Open)
{
try
{
string str;
checkedListBox1.Items.Clear();
SqlCommand sqlcomm = new SqlCommand("select cacc_id,cacc_name FROM UA_ACCOUNT", sqlconn);
sqlcomm.ExecuteNonQuery();
SqlDataAdapter adap = new SqlDataAdapter(sqlcomm);
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -