frmmain.cs

c#数据库访问自动生成代码程序

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using MVC.Common;
namespace MVC
{
    public partial class FrmMain : Form
    {
        public FrmMain()
        {
            
            InitializeComponent();

        }

        private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {

        }

        private MVC.FormBean.FrmMainBean frmMainBean=new MVC.FormBean.FrmMainBean();

        private void Form1_Load(object sender, EventArgs e)
        {

            //DataSet ds = XmlControl.LoadXMLFile("./TableDesc.xml");

            //this.dataGridView1.DataSource = ds.Tables[0].DefaultView;
            //this.dataGridView2.DataSource = ds.Tables[1].DefaultView;
            //this.dgvPf.DataSource = ds.Tables[2].DefaultView;




            try
            {
                frmMainBean.dsPkg = ORA2C.ExecuteSql("SELECT OBJECT_NAME FROM USER_OBJECTS t WHERE object_type='PACKAGE'");

                Utility.BindComboBox(frmMainBean.dsPkg, cobPkg, "OBJECT_NAME", "OBJECT_NAME");

            }
            catch { }
        }




        private void dgvPf_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            DataView dv;
            dv = (DataView)dgvPf.DataSource;

            if (e.RowIndex >= dv.Table.Rows.Count|| e.RowIndex<0)
            {
                MessageBox.Show("No Row Selected!");
                return;
            }

            DataRow dr = dv.Table.Rows[e.RowIndex];
            string v_name = dr["方法名"].ToString();
            int v_overload = int.Parse(dr["重载"].ToString());

            txtPfDeclare.Text = ORA2C.get_method_declare(cobPkg.Text, v_name, v_overload);
        }

        private void cobPkg_SelectedIndexChanged(object sender, EventArgs e)
        {
            if (cobPkg.Text != null)
            {

                frmMainBean.dsPf = ORA2C.getMethod(cobPkg.Text);                
                Utility.BindDataView(frmMainBean.dsPf, dgvPf, 3);

                
            }
        }

        private void setDgvPfColumnSize()
        {
            dgvPf.Columns["序号"].Width = 40;
            dgvPf.Columns["方法名"].Width = 345;
            dgvPf.Columns["重载"].Width = 40;
        }


        private void btnCopy_Click(object sender, EventArgs e)
        {
            txtPfBody.SelectAll();
            txtPfBody.Copy();
        }

        private void btnCreateCode_Click(object sender, EventArgs e)
        {
            if (txtPfDeclare.Text == "")
            {
                MessageBox.Show("Please Select One Method!");
                return;
            }
            string rt1=string.Empty;
            string rt2 = string.Empty;
            string rt3=string.Empty;
            string rt = string.Empty;


            rt=ORA2C.getc4method_byname(txtPfDeclare.Text, cobPkg.Text,ref rt1, ref rt2, ref rt3);

            if (rt == "0")
            {
                txtPfBody.Text = rt1 + rt2 + rt3;
            }
            else
            {
                txtPfBody.Text = rt;
            }

            

            //txtPfBody.Text = ORA2C.GETC4METHOD_BYNAME(txtPfDeclare.Text, cobPkg.Text);
            

        }

        private void dgvPf_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {

        }

 
   
    }
}