query_update.aspx.cs

固定资产管理系统 登陆

            Application["as_equiment"] = txt_as_equiment.Text;

            
            Response.Write("<script language=javascript>alert('更新数据成功')</script>");

        }
        catch
        {
            Response.Write("<script language=javascript>alert('更新数据失败')</script>");
 
        }

    }

    protected void RadioButtonList1_SelectedIndexChanged(object sender, EventArgs e)
    {
        if (Convert.ToInt16(RadioButtonList1.SelectedValue) == 1)
        {
            btn_reprot_query.Enabled = true;
            btn_report_update.Enabled = true;
            btn_print_report.Enabled = true;
            btn_gen_card.Enabled = true;
            pl_query_report.Visible = true;
            pl_report.Visible = true;
            btn_card_query.Enabled = false;
            btn_update_card.Enabled = false;
            btn_print_card.Enabled = false;
            pl_card.Visible = false;
            pl_query_card.Visible = false;
            
        }
        else
        {
            btn_reprot_query.Enabled = false;
            btn_report_update.Enabled = false;
            btn_print_report.Enabled = false;
            btn_gen_card.Enabled = false;
            pl_query_report.Visible = false;
            pl_report.Visible = false;
            btn_card_query.Enabled = true;
            btn_update_card.Enabled = true;
            btn_print_card.Enabled = true;
            pl_card.Visible = true;
            pl_query_card.Visible = true;
            
        }
    }
    protected void btn_query_for_card_Click(object sender, EventArgs e)
    {

        try
        {
            String sqlstr_card = "";

            if (dpl_query_factor.SelectedIndex == 0)
            {
                sqlstr_card = "select * from card_view where [年度编号(卡片序列号)] ='" + txt_query_key.Text.Trim().ToString() + "'";
            }
            else if (dpl_query_factor.SelectedIndex == 1)
            {
                sqlstr_card = "select * from card_view where 原始编号='" + txt_query_key.Text.Trim().ToString() + "'";
            }

            sqlcon.Open();
            SqlDataAdapter myda_card = new SqlDataAdapter(sqlstr_card, sqlcon);
            DataSet myds_card = new DataSet();
            myda_card.Fill(myds_card, "card_view");
            DataRowView mydrv_card = myds_card.Tables["card_view"].DefaultView[0];
            Application["y_no_id"] = lbl_y_no_id.Text = Convert.ToString(mydrv_card.Row["年度编号(卡片序列号)"]);
            Application["f_no"] = lbl_f_no.Text = Convert.ToString(mydrv_card.Row["固定资产编号"]);
            Application["name"] = lbl_name.Text = Convert.ToString(mydrv_card.Row["固定资产名称"]);
            Application["brain"] = lbl_brain.Text = Convert.ToString(mydrv_card.Row["品牌(厂商)"]);
            Application["type"] = lbl_type.Text = Convert.ToString(mydrv_card.Row["规格型号"]);
            Application["as_equiment"] = lbl_as_equiment.Text = Convert.ToString(mydrv_card.Row["附属设备"]);   //需在card_view添加
            Application["r_no"] = txt_r_no.Text = Convert.ToString(mydrv_card.Row["原始编号"]);
            Application["old_value"] = lbl_old_value.Text = Convert.ToString(mydrv_card.Row["原值"]);
            Application["source"] = lbl_source.Text = Convert.ToString(mydrv_card.Row["来源"]);
            Application["purchase_way"] = lbl_purchase_way.Text = Convert.ToString(mydrv_card.Row["购买方式"]);
            dpl_status.SelectedIndex = Convert.ToInt32(mydrv_card.Row["使用状态"]) - 1;  //列表框可能存在问题,有待验证  已验证,OK!
            Application["status"] = dpl_status.SelectedValue.ToString();
            String str_date = Convert.ToString(mydrv_card.Row["增加日期"]);
            Application["a_date"] = lbl_a_date.Text = lbl_check_date.Text = lbl_start_date.Text = str_date.Substring(0, str_date.IndexOf("0:00") - 1);
            Application["u_bra_detail"] = txt_u_bra_detail.Text = Convert.ToString(mydrv_card.Row["存放地点"]);
            Application["u_branch"] = lbl_u_branch.Text = Convert.ToString(mydrv_card.Row["使用单位"]);
            Application["user"] = txt_user.Text = Convert.ToString(mydrv_card.Row["使用人"]);
            Application["clear_reason"] = txt_clear_reason.Text = Convert.ToString(mydrv_card.Row["清理原因"]);
            Application["clear_date"] = txt_clear_date.Text = Convert.ToString(mydrv_card.Row["清理日期"]);
            Application["clear_branch"] = txt_clear_branch.Text = Convert.ToString(mydrv_card.Row["清理单位"]);
            Application["clear_man"] = txt_clear_man.Text = Convert.ToString(mydrv_card.Row["清理操作人"]);
            Application["clear_money"] = txt_clear_money.Text = Convert.ToString(mydrv_card.Row["清理收入"]);
            Application["clear_ref"] = txt_clear_ref.Text = Convert.ToString(mydrv_card.Row["清理备注"]);
            Application["card_ref"] = txt_cad_ref.Text = Convert.ToString(mydrv_card.Row["卡片备注"]);
            Application["reg_date"] = lbl_reg_date.Text = Application["a_date"].ToString();
            Application["card_reg"] = txt_card_reg.Text = Convert.ToString(mydrv_card.Row["登记人"]);
            Application["imgurl"] = imgurl.ImageUrl = Convert.ToString(mydrv_card.Row["照片"]);

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

        sqlcon.Close(); 
    }
    protected void btn_update_card_Click(object sender, EventArgs e)
    {
        try
        {
            sqlcon.Open();

            String sql_update_card_view = "update card_view set 原始编号='" + txt_r_no.Text.Trim() + "',使用状态='" + dpl_status.SelectedValue + "', ";
            sql_update_card_view += "使用人='" + txt_user.Text.Trim() + "',清理原因='" + txt_clear_reason.Text.Trim() + "',清理日期='" + txt_clear_date.Text.Trim() + "',";
            sql_update_card_view += "清理单位='"+txt_clear_branch.Text.Trim()+"',清理操作人='"+txt_clear_man.Text.Trim()+"',清理收入='"+Convert.ToInt32(txt_clear_money.Text.Trim())+"',";
            sql_update_card_view += "清理备注='"+txt_clear_ref.Text.Trim()+"',卡片备注='"+txt_cad_ref.Text.Trim()+"',登记人='"+txt_card_reg.Text.Trim()+"'";
            sql_update_card_view += "where [年度编号(卡片序列号)]='" + txt_query_key.Text.Trim().ToString() + "'or 原始编号='" + txt_query_key.Text.Trim() + "'";

            txt_cad_ref.Text = sql_update_card_view;

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

            Application["r_no"] = txt_r_no.Text;
            Application["status"] = dpl_status.SelectedIndex;
            Application["u_bra_detail"] = txt_u_bra_detail.Text;
            Application["user"] = txt_user.Text;
            Application["clear_reason"] = txt_clear_reason.Text;
            Application["clear_date"] = txt_clear_date.Text;
            Application["clear_branch"] = txt_clear_branch.Text;
            Application["clear_man"] = txt_clear_man.Text;
            Application["clear_money"] = txt_clear_money.Text;
            Application["clear_ref"] = txt_clear_ref.Text;
            Application["card_ref"] = txt_cad_ref.Text;
            Application["card_reg"] = txt_card_reg.Text;



            Response.Write("<script language=javascript>alert('更新数据成功')</script>");
        }
        catch
        {
            Response.Write("<script language=javascript>alert('更新数据失败')</script>");
        }
    }
    protected void dpl_status_SelectedIndexChanged(object sender, EventArgs e)
    {
        if (dpl_status.SelectedIndex == 2)
        {
            txt_clear_reason.Enabled = true;
            txt_clear_date.Enabled = true;
            txt_clear_branch.Enabled = true;
            txt_clear_man.Enabled = true;
            txt_clear_money.Enabled = true;
            txt_clear_ref.Enabled = true;
        }
    }
    protected void btn_gen_card_Click(object sender, EventArgs e)
    {
        Response.Redirect("CardReg.aspx");
    }
}