c#图形开票

Code
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;

namespace WindowsApplication1
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        int x = 0;
        int y = 0;

        //private void button1_Click(object sender, EventArgs e)
        //{
        //    Form2 frm = new Form2();
        //    frm.Pos = new Point(x, y);
        //    frm.Show();            
        //}

        //private void Form1_MouseMove(object sender, MouseEventArgs e)
        //{
        //    x = e.X;
        //    y = e.Y;
        //}

        private void 输入编号ToolStripMenuItem_Click(object sender, EventArgs e)
        {
           
            Form2 frm = new Form2();
            frm.Pos = new Point(x, y);
            frm.Show();  
        }

        //private void Form1_MouseDown(object sender, MouseEventArgs e)
        //{
        //    x = e.X;
        //    y = e.Y;
        //}

        private void pictureBox1_MouseDown(object sender, MouseEventArgs e)
        {
            x = e.X;
            y = e.Y;
        }

        private void 查看编号ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            Form3 frm = new Form3();
            frm.Pos = new Point(x, y);
            frm.Show(); 
        }
    }
}

 

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
//using System.Data;
using System.Data.SqlClient;

namespace WindowsApplication1
{
    public partial class Form2 : Form
    {

        private Point pos;

        public Point Pos
        {
            get { return pos; }//获得鼠标的xy坐标
            set { pos = value; }
        }

        public Form2()
        {
            InitializeComponent();
        }

        private void Form2_Load(object sender, EventArgs e)
        {
            textBox1.Text = pos.X.ToString();
            textBox2.Text = pos.Y.ToString();
            textBox1.Enabled = false;
            textBox2.Enabled = false;
            //MessageBox.Show("单击form1上的Button时鼠标位置为:x="+pos.X.ToString()+";y="+pos.Y.ToString());
        }

        private void button1_Click(object sender, EventArgs e)
        {
            int xstart = pos.X;//元件x的起始坐标
            int ystart = pos.Y;
            int xend=0;          //元件x的终止坐标
            int yend=0;
            string lei= comboBox1.Text;           
            if (textBox3.Text.Length > 0 && lei.Length > 0)
            {
                string leiBie = comboBox1.SelectedItem.ToString();
                SqlConnection myConnection = new SqlConnection("server=localhost;database=sdg;uid=sa;pwd=sa");
                string strCom = "select * from device where xstart<=" + xstart + " and xend>="+xstart+" and ystart<="+ystart+" and yend>="+ystart+"";
                //" + xend + ">" + xstart + "and  and" + yend + ">" + ystart + "and"+xend +">"+pos .X +"and"+yend +">"+pos .Y +"
                DataSet mydataset = new DataSet();
                myConnection.Open();               
                SqlDataAdapter myCommand = new SqlDataAdapter(strCom, myConnection);
                myCommand.Fill(mydataset, "info");
                if (mydataset.Tables["info"].Rows.Count == 0)
                {

                    //switch (leiBie)
                    //{
                    //    case "柜门":
                    //}
                    if (leiBie == "柜门")
                    {
                        xend = xstart + 11;
                        yend = ystart + 11;
                        SqlCommand com = new SqlCommand("insert into device values (1," + xstart + "," + xend + "," + ystart + "," + yend + ",'" + textBox3.Text.Trim() + "','" + comboBox1.SelectedItem + "') ", myConnection);
                        com.ExecuteNonQuery();
                    }
                    else if (leiBie == "断路器")
                    {
                        xend = xstart + 16;
                        yend = ystart + 16;
                        SqlCommand com = new SqlCommand("insert into device values (1," + xstart + "," + xend + "," + ystart + "," + yend + ",'" + textBox3.Text.Trim() + "','" + comboBox1.SelectedItem + "') ", myConnection);
                        com.ExecuteNonQuery();
                    }
                    else if (leiBie == "横刀闸")
                    {
                        xend = xstart + 27;
                        yend = ystart + 7;
                        SqlCommand com = new SqlCommand("insert into device values (1," + xstart + "," + xend + "," + ystart + "," + yend + ",'" + textBox3.Text.Trim() + "','" + comboBox1.SelectedItem + "') ", myConnection);
                        com.ExecuteNonQuery();
                    }
                    else if (leiBie == "竖刀闸")
                    {
                        xend = xstart + 7;
                        yend = ystart + 27;
                        SqlCommand com = new SqlCommand("insert into device values (1," + xstart + "," + xend + "," + ystart + "," + yend + ",'" + textBox3.Text.Trim() + "','" + comboBox1.SelectedItem + "') ", myConnection);
                        com.ExecuteNonQuery();
                    }
                    else if (leiBie == "手车")
                    {
                        xend = xstart + 15;
                        yend = ystart + 15;
                        SqlCommand com = new SqlCommand("insert into device values (1," + xstart + "," + xend + "," + ystart + "," + yend + ",'" + textBox3.Text.Trim() + "','" + comboBox1.SelectedItem + "') ", myConnection);
                        com.ExecuteNonQuery();
                    }
                }
                else 
                {
                    //textBox1.Text = mydataset.Tables["xstart"].Rows.ToString ();
                    //textBox2.Text = mydataset.Tables["ystart"].Rows.ToString ();
                    //textBox3.Text = mydataset.Tables["num"].Rows.ToString ();
                    MessageBox.Show("此位置已经有数据,请选择另一个地方", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
                myConnection.Close();
            }
            else if (lei.Length == 0)
            {
                MessageBox.Show("请选择类别编号", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                comboBox1.Focus();
            }
            else if (textBox3.Text.Trim ().Length  == 0)
            {
                MessageBox.Show("请输入编号", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                textBox3.Focus();
            }
        }

        private void button2_Click(object sender, EventArgs e)
        {
            this.Close();
        }
    }
}

 

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace WindowsApplication1
{
    public partial class Form3 : Form
    {
        private Point pos;

        public Point Pos
        {
            get { return pos; }//获得鼠标的xy坐标
            set { pos = value; }
        }
        public Form3()
        {
            InitializeComponent();
        }

        private void Form3_Load(object sender, EventArgs e)
        {
            try
            {
                int xstart = pos.X;//元件x的起始坐标
                int ystart = pos.Y;
                SqlConnection myConnection = new SqlConnection("server=localhost;database=sdg;uid=sa;pwd=sa");
                string strCom = "select top 1 * from device where xstart<=" + xstart + " and xend>=" + xstart + " and ystart<=" + ystart + " and yend>=" + ystart + "";
                //   //" + xend + ">" + xstart + "and  and" + yend + ">" + ystart + "and"+xend +">"+pos .X +"and"+yend +">"+pos .Y +"
                DataSet mydataset = new DataSet();
                myConnection.Open();
                SqlDataAdapter myCommand = new SqlDataAdapter(strCom, myConnection);
                myCommand.Fill(mydataset, "info");
                if (mydataset.Tables["info"].Rows.Count == 1)
                {
                    //textBox1 .Text =mydataset .Tables ["num"].Rows.ToString ();
                }
                else
                {
                    MessageBox.Show("不存在", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
            }
            catch(Exception ex)
            { MessageBox.Show(ex.ToString ()); }
        }
    }
}