protected void Page_Load(object sender, EventArgs e)
{
sql_conn cn = new sql_conn();
DataSet ds = new DataSet();
ds = cn.dataset("select top 1 * from tb_user");
Response.Write(ds.Tables[0].Rows[0][0].ToString());
}
public void init()
{
MySqlConnection con = new sql_conn().getconn();
MySqlCommand cmd = null;
MySqlDataReader reader = null;
dataGridView1.Rows.Clear();
try
{
String sql = "select * from sale1";
con.Open();
if (checkBox1.CheckState == CheckState.Checked)
{
sql = sql + " where remark = '退单中'";
}
if (checkBox2.CheckState == CheckState.Checked && checkBox1.CheckState == CheckState.Unchecked)
{
sql = sql + " where remark = '退货中'";
}
else if (checkBox2.CheckState == CheckState.Checked && checkBox1.CheckState == CheckState.Checked)
{
sql = sql + " or remark = '退货中'";
}
if (checkBox2.CheckState == CheckState.Checked || checkBox1.CheckState == CheckState.Checked)
{
cmd = new MySqlCommand(sql, con);
reader = cmd.ExecuteReader();
while (reader.Read())
{
int i = dataGridView1.RowCount;
dataGridView1.Rows.Add();
dataGridView1.Rows[i].Cells[0].Value = reader[0].ToString();
dataGridView1.Rows[i].Cells[1].Value = reader[6].ToString();
dataGridView1.Rows[i].Cells[2].Value = reader[2].ToString();
dataGridView1.Rows[i].Cells[3].Value = reader[5].ToString();
dataGridView1.Rows[i].Cells[4].Value = reader[1].ToString();
dataGridView1.Rows[i].Cells[5].Value = "审核";
}
}
}
catch
{
}
}
private void InitData(String sql)
{
try
{
list.Clear();
MySqlConnection con = new sql_conn().getconn();
con.Open();
MySqlDataReader dr;
MySqlCommand cmd = new MySqlCommand(sql, con);
dr = cmd.ExecuteReader();
while (dr.Read())
{
int flag = 0;
for (int i = 0; i < list.Count; i++)
{
if (list[i].name == dr[0].ToString())
{
list[i].amount = list[i].amount + double.Parse(dr[1].ToString());
flag = 1;
break;
}
}
if (flag == 0)
{
sale_report st = new sale_report();
st.name = dr[0].ToString();
st.amount = double.Parse(dr[1].ToString());
list.Add(st);
}
}
InitcharControls();
con.Close();
dr.Close();
}
catch (Exception e)
{
MessageBox.Show("数据库链接失败，请重试");
MessageBox.Show(e.Message);
}
}
