库存产品汇总.cs

湖南岳阳电力部门 电力管理系统 .net C#开发的

                string sqlstring = "SELECT SUM(数量) AS 数量, SUM(总价) AS 总价 FROM 出入库明细表 WHERE (出入库类型 = " + "'校验出库'" + ") AND (出库入库 = '" + cl + "') AND (时间 LIKE '" + time + "') AND (库存ID = '" + id + "')";
                SqlDataAdapter sqldataadapter = new SqlDataAdapter(sqlstring, connectionstring);
                DataSet dataset = new DataSet();
                sqldataadapter.Fill(dataset);
                DataTable datatable = dataset.Tables[0];
                DataRow datarow = datatable.Rows[0];
                if (datarow.ItemArray[0].ToString() == "")
                {
                    this.textBox21.Text = "0";
                }
                else
                {
                    this.textBox21.Text = datarow.ItemArray[0].ToString();
                }

            }
            catch (Exception exc)
            {
                MessageBox.Show("输入有误" + exc.Message);
            }
            try
            {
                string sqlstring = "SELECT SUM(数量) AS 数量, SUM(总价) AS 总价 FROM 出入库明细表 WHERE (出入库类型 = " + "'安装出库'" + ") AND (出库入库 = '" + cl + "') AND (时间 LIKE '" + time + "') AND (库存ID = '" + id + "')";
                SqlDataAdapter sqldataadapter = new SqlDataAdapter(sqlstring, connectionstring);
                DataSet dataset = new DataSet();
                sqldataadapter.Fill(dataset);
                DataTable datatable = dataset.Tables[0];
                DataRow datarow = datatable.Rows[0];
                if (datarow.ItemArray[0].ToString() == "")
                {
                    this.textBox22.Text = "0";
                }
                else
                {
                    this.textBox22.Text = datarow.ItemArray[0].ToString();
                }

            }
            catch (Exception exc)
            {
                MessageBox.Show("输入有误" + exc.Message);
            }
            try
            {
                string sqlstring = "SELECT SUM(数量) AS 数量, SUM(总价) AS 总价 FROM 出入库明细表 WHERE (出入库类型 = " + "'轮换出库'" + ") AND (出库入库 = '" + cl + "') AND (时间 LIKE '" + time + "') AND (库存ID = '" + id + "')";
                SqlDataAdapter sqldataadapter = new SqlDataAdapter(sqlstring, connectionstring);
                DataSet dataset = new DataSet();
                sqldataadapter.Fill(dataset);
                DataTable datatable = dataset.Tables[0];
                DataRow datarow = datatable.Rows[0];
                if (datarow.ItemArray[0].ToString() == "")
                {
                    this.textBox23.Text = "0";
                }
                else
                {
                    this.textBox23.Text = datarow.ItemArray[0].ToString();
                }

            }
            catch (Exception exc)
            {
                MessageBox.Show("输入有误" + exc.Message);
            }
            try
            {
                string sqlstring = "SELECT SUM(数量) AS 数量, SUM(总价) AS 总价 FROM 出入库明细表 WHERE (出入库类型 = " + "'返修出库'" + ") AND (出库入库 = '" + cl + "') AND (时间 LIKE '" + time + "') AND (库存ID = '" + id + "')";
                SqlDataAdapter sqldataadapter = new SqlDataAdapter(sqlstring, connectionstring);
                DataSet dataset = new DataSet();
                sqldataadapter.Fill(dataset);
                DataTable datatable = dataset.Tables[0];
                DataRow datarow = datatable.Rows[0];
                if (datarow.ItemArray[0].ToString() == "")
                {
                    this.textBox24.Text = "0";
                }
                else
                {
                    this.textBox24.Text = datarow.ItemArray[0].ToString();
                }
            }
            catch (Exception exc)
            {
                MessageBox.Show("输入有误" + exc.Message);
            }
            try
            {
                string sqlstring = "SELECT SUM(数量) AS 数量, SUM(总价) AS 总价 FROM 出入库明细表 WHERE (出入库类型 = " + "'配置出库'" + ") AND (出库入库 = '" + cl + "') AND (时间 LIKE '" + time + "') AND (库存ID = '" + id + "')";
                SqlDataAdapter sqldataadapter = new SqlDataAdapter(sqlstring, connectionstring);
                DataSet dataset = new DataSet();
                sqldataadapter.Fill(dataset);
                DataTable datatable = dataset.Tables[0];
                DataRow datarow = datatable.Rows[0];
                if (datarow.ItemArray[0].ToString() == "")
                {
                    this.textBox25.Text = "0";
                }
                else
                {
                    this.textBox25.Text = datarow.ItemArray[0].ToString();
                }
            }
            catch (Exception exc)
            {
                MessageBox.Show("输入有误" + exc.Message);
            }

            try
            {
                string sqlstring2 = "SELECT SUM(数量) AS 数量, SUM(总价) AS 总价 FROM 出入库明细表 WHERE(出库入库 = '" + cl + "') AND (时间 LIKE '" + time + "') AND (库存ID = '" + id + "')";
                SqlDataAdapter sqldataadapter = new SqlDataAdapter(sqlstring2, connectionstring);
                DataSet dataset = new DataSet();
                sqldataadapter.Fill(dataset);
                DataTable datatable = dataset.Tables[0];
                DataRow datarow = datatable.Rows[0];
                if (datarow.ItemArray[0].ToString() == "")
                {
                    this.textBox26.Text = "0";
                }
                else
                {
                    this.textBox26.Text = datarow.ItemArray[0].ToString();
                }

                if (datarow.ItemArray[1].ToString() == "")
                {
                    this.textBox27.Text = "0";
                }
                else
                {
                    this.textBox27.Text = datarow.ItemArray[1].ToString();
                }

            }
            catch (Exception exc)
            {
                MessageBox.Show("输入有误" + exc.Message);
            }
        }

        private void button2_Click(object sender, EventArgs e)
        {
            string message = this.textBox14.Text.Trim();
            string type = this.comboBox4.Text.Trim();
            if (type == "库存ID")
            { 
                this.库存类型TableAdapter.FillBy_1(this.sqldatabase_DataDataSet.库存类型, message);
            }
            else if (type == "资产类型")
            { 
                this.库存类型TableAdapter.FillBy_2(this.sqldatabase_DataDataSet.库存类型, message);
            }
            else if (type == "型号")
            { 
                this.库存类型TableAdapter.FillBy_3(this.sqldatabase_DataDataSet.库存类型, message);
            }
            else if (type == "规格")
            { 
                this.库存类型TableAdapter.FillBy_4(this.sqldatabase_DataDataSet.库存类型, message);
            }
            else if (type == "等级")
            { 
                this.库存类型TableAdapter.FillBy_5(this.sqldatabase_DataDataSet.库存类型, message);
            }
            else if (type == "数量")
            {
                try
                { 
                    this.库存类型TableAdapter.FillBy_6(this.sqldatabase_DataDataSet.库存类型, int.Parse(message));
                }
                catch (Exception exc)
                {
                    MessageBox.Show("输入有误" + exc.Message);
                }
            } 
        } 
        private void button3_Click(object sender, EventArgs e)
        {
            this.库存类型TableAdapter.Fill(this.sqldatabase_DataDataSet.库存类型);
        } 
    }
}