query_update.aspx.cs

固定资产管理系统 登陆

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class Qurey_Update : System.Web.UI.Page
{
    SqlConnection sqlcon = new SqlConnection("Data Source=42.1.47.11;Database=AssetsDB;Uid=szy;Pwd=123456");
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void RadioButton1_CheckedChanged(object sender, EventArgs e)
    {
        txt_y_no.Enabled = !txt_y_no.Enabled;
    }
    protected void btn_query_for_asset_Click(object sender, EventArgs e)
    {
        
        string sqlstr;
        if (txt_y_no.Enabled)
        {
            sqlstr = "select * from asset_view where 年度编号='" + txt_y_no.Text.Trim().ToString() + "'";
        }
        else
        {
            sqlstr = "select * from asset_view where 固定资产编号='" + txt_f_no.Text.Trim().ToString() + "'";
        }

 //       try
 //       {
            sqlcon.Open();
            SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlcon);
            DataSet myds = new DataSet();
            myda.Fill(myds, "asset_view");
            DataRowView mydrv = myds.Tables["asset_view"].DefaultView[0];
            Application["name"] = txt_name.Text = Convert.ToString(mydrv.Row["固定资产名称"]);
            Application["brain"] = txt_brain.Text = Convert.ToString(mydrv.Row["品牌"]);
            Application["type"] = txt_type.Text = Convert.ToString(mydrv.Row["规格型号"]);
            Application["number"] = txt_number.Text = Convert.ToString(mydrv.Row["数量"]);
            Application["y_no"] = txt_y_no_read.Text = Convert.ToString(mydrv.Row["年度编号"]);
            Application["old_value"] = txt_old_value.Text = Convert.ToString(mydrv.Row["原值"]);
            Application["f_no"] = txt_f_no.Text = Convert.ToString(mydrv.Row["固定资产编号"]);
            Application["u_bra_detail"] = txt_u_bra.Text = Convert.ToString(mydrv.Row["存放地点"]);
            String str_date=Convert.ToString(mydrv.Row["增加日期"]);
            Application["a_date"] = txt_a_date.Text =str_date.Substring(0, str_date.IndexOf("0:")-1);
            Application["a_reason"] = txt_a_reason_detail.Text = Convert.ToString(mydrv.Row["增加变动原因"]);
            //str_date = Convert.ToString(mydrv.Row["减少日期"]);
            //Application["m_date"] = txt_m_date.Text = str_date.Substring(0,str_date.IndexOf("0:")-1);
            //Application["m_reason"] = txt_m_reason_detail.Text = Convert.ToString(mydrv.Row["减少变动原因"]);
            Application["deal_name"] = txt_deal_name.Text = Convert.ToString(mydrv.Row["经办人"]);
            Application["check_name"] = txt_check_name.Text = Convert.ToString(mydrv.Row["验收人"]);
            Application["u_branch"] = txt_u_branch.Text = Convert.ToString(mydrv.Row["使用单位"]);
            Application["receive_name"] = txt_receive_name.Text = Convert.ToString(mydrv.Row["领用部门领导"]);
            Application["as_equiment"] = txt_as_equiment.Text = Convert.ToString(mydrv.Row["附属设备"]);

            btn_print_report.Attributes.Add("onclick", "javasrcipt:window.open('ReportSheet.aspx');");
 /*       }
        catch
        {
            Response.Write("<script language=javascript>alert('查找不到数据')</script>");
        }
 */
        

        sqlcon.Close();
    }


    protected void rbtnl_query_SelectedIndexChanged(object sender, EventArgs e)
    {
        if (Convert.ToInt16(rbtnl_query.SelectedValue) == 1)
        {
            txt_y_no.Enabled = true;
            txt_f_no.Enabled = false;
        }
        else
        {
            txt_f_no.Enabled = true;
            txt_y_no.Enabled = false;
        }
    }

    /*
    protected void btn_menu_Click(object sender, EventArgs e)
    {
        pl_menu.Visible = !pl_menu.Visible;
    }
     */

    protected void btn_reprot_query_Click(object sender, EventArgs e)
    {
        pl_query_report.Visible = true;
        pl_report.Visible = true;
    }



    protected void btn_report_update_Click(object sender, EventArgs e)
    {
        
        try
        {
            sqlcon.Open();

            String get_m_reason_id = "select m_reason_id from m_reason where m_reason_detail='" + txt_m_reason_detail.Text.Trim() + "'";
            SqlCommand　com = new SqlCommand(get_m_reason_id, sqlcon);
            SqlDataReader read = com.ExecuteReader();
            read.Read();
            Int32 m_id = read.GetInt32(0);
            read.Close();

            String get_a_reason_id = "select a_reason_id from a_reason where a_reason_detail='" + txt_a_reason_detail.Text.Trim() + "'";
            com = new SqlCommand(get_a_reason_id, sqlcon);
            read = com.ExecuteReader();
            read.Read();
            Int32 a_id = read.GetInt32(0);
            read.Close();

           
            String get_u_branch_id = "select u_branch_no from u_branch where u_branch_name='" + txt_u_branch.Text.Trim() + "'";
            com = new SqlCommand(get_u_branch_id, sqlcon);
            read = com.ExecuteReader();
            read.Read();
            String u_branch_id = read.GetString(0).ToString();
            read.Close();


            string str = "update asset set name='" + txt_name.Text.Trim() + "',brain='" + txt_brain.Text.Trim() + "',";
            str += "f_no='"+txt_f_no_change.Text.Trim()+"', type='" + txt_type.Text.Trim() + "',number='" + txt_number.Text.Trim() + "',old_value='" + txt_old_value.Text.Trim() + "',";
            str += "u_bra_detail='" + txt_u_bra.Text.Trim() + "',a_date='" + txt_a_date.Text.Trim() + "',a_reason_id='" + a_id + "',";
            str += "m_date='" + txt_m_date.Text.Trim() + "',m_reason_id='" + m_id + "',deal_name ='" + txt_deal_name.Text.Trim() + "',";
            str += "check_name='" + txt_check_name.Text.Trim() + "',u_branch_no='" + u_branch_id + "',receive_name='" + txt_receive_name.Text.Trim() +"',as_equiment='" + txt_as_equiment.Text.Trim() + "'";
            str += " where y_no='" + txt_y_no_read.Text.Trim() + "'";
            //txt_as_equiment.Text = str;

            SqlCommand sqlcmd = new SqlCommand(str, sqlcon);
            sqlcmd.ExecuteNonQuery();
            sqlcon.Close();

            Application["name"] = txt_name.Text;
            Application["brain"] = txt_brain.Text;
            Application["type"] = txt_type.Text;
            Application["number"] = txt_number.Text;
            Application["y_no"] = txt_y_no_read.Text;
            Application["old_value"] = txt_old_value.Text;
            Application["f_no"] = txt_f_no.Text; ;
            Application["u_bra_detail"] = txt_u_bra.Text;
            Application["a_date"] = txt_a_date.Text;
            Application["a_reason"] = txt_a_reason_detail.Text;
            Application["m_date"] = txt_m_date.Text;
            Application["m_reason"] = txt_m_reason_detail.Text;
            Application["deal_name"] = txt_deal_name.Text;
            Application["check_name"] = txt_check_name.Text;
            Application["u_branch"] = txt_u_branch.Text;
            Application["receive_name"] = txt_receive_name.Text;