//提取数据
private void button1_Click(object sender, EventArgs e)
{
//提取数据
string connstr = "server=s1.hzcrj.com,1999;database=TRQC;user=sa;pwd=hc3232327";
SqlConnection Conn1 = new SqlConnection(connstr);
try
{
using (Conn1)
{
Conn1.Open();
string sql = "select top 30 [存货编码] ,[存货名称],cast(cast([数量] as int) as varchar(50)) as 数量,[计量单位] as 单位 from [InvQC]";
SqlCommand Comm1 = new SqlCommand(sql, Conn1);
Comm1.CommandTimeout = 20;
SqlDataAdapter SDA = new SqlDataAdapter();
SDA.SelectCommand = Comm1;
DataSet ds = new DataSet();
SDA.Fill(ds, "cs");
dataGridView1.DefaultCellStyle.Font = new Font("Tahoma", 16);
dataGridView1.DataSource = ds.Tables[0];
Form pwd = new LoginBox();
richTextBox1.Text = "提取成功" + dataGridView1.Rows[1].Cells[1].Value + "|" + AppDataList.Temp_Char;
}
}
catch (Exception ex)
{
richTextBox1.Text = ex.Message;
}
finally
{
Conn1.Close();
}
}
//注销登陆
private void LogoutAPP_Click(object sender, EventArgs e)
{
if (MessageBox.Show("确定要注销登陆用户么？", "注销登陆", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
AppDataList.Logined = false;
AppDataList.UserName = "******";
this.Hide();
Form MR = new LoginBox();
MR.ShowDialog();
this.Close();
}
}
