operation.cs

C#编的 英文的 带报告 上学期的作业 分数还不错

using System;
using System.Collections.Generic;
using System.Text;

using System.Data;
using System.Data.SqlClient;
using System.Windows.Forms;
//using Microsoft.Internal.Performance;

namespace EquipmentMS.BaseClass
{
    class Operation
    {
        DataBase data = new DataBase();

        #region verify code input type（0123456789.）

        public bool IsNumeric(string strCode)
        {
            if (strCode == null || strCode.Length == 0)
                return false;
            ASCIIEncoding ascii = new ASCIIEncoding();
            byte[] byteStr = ascii.GetBytes(strCode);
            foreach (byte code in byteStr)
            {
                if (code == 190||code==110)
                if (code < 48 || code > 57)
                    return false;
            }
            return true;
        }
        #endregion
        
        #region DataGridView information export to Excel
        public bool ExportDataGridview(DataGridView gridView,bool isShowExcle)
        {
            if (gridView.Rows.Count == 0)
                return false;
            Microsoft.Office.Interop.Excel.Application excel = new Microsoft.Office.Interop.Excel.Application();
            excel.Application.Workbooks.Add(true);
            excel.Visible = isShowExcle;
            for (int i = 0; i < gridView.ColumnCount; i++)
            {
                excel.Cells[1, i + 1] = gridView.Columns[i].HeaderText;
            }
            for (int i = 0; i < gridView.RowCount-1; i++)
            {
                for (int j = 0; j < gridView.ColumnCount; j++)
                {
                    if (gridView[j, i].ValueType == typeof(string))
                    {
                        excel.Cells[i + 2, j + 1] = "'" + gridView[j, i].Value.ToString();
                    }
                    else
                    {
                        excel.Cells[i + 2, j + 1] = gridView[j, i].Value.ToString();
                    }
                }
            }
            return true;
        }
        #endregion

        #region  set up main form Width and Visble attribute of DataGridView
        public int DataGridViewSetWidth(int place, int DataGridView_width)
        {
            return data.RunProc("update tb_DataGridViewList set width=" + DataGridView_width + " where place=" + place + "");
        }
        public int DataGridViewSetVisible(int place, bool check)
        {
            return data.RunProc("update tb_DataGridViewList set Visible=" + Convert.ToInt16(check) + " where place=" + place + "");
        }
        #endregion

        #region  set up units information

        public int InsertUnits(string units, string linkman, string address, string tel, string memo)
        {
            return data.RunProc("insert into tb_units (units,linkman,address,tel,memo) values ('" + units + "','" + linkman + "','" + address + "','" + tel + "','" + memo + "')");
        }

        public int UpdateUnits(string units, string linkman, string address, string tel, string memo)
        {
            return data.RunProc("update tb_units set units='" + units + "',linkman='" + linkman + "',address='" + address + "',tel='" + tel + "',memo='" + memo + "'");
        }

        public DataSet GetDataSetUnits()
        {
            return data.RunProcReturn("select * from tb_units","tb_units");
        }

        #endregion

        #region  initialize system
        public int DeleteBaseTable()
        {
            return data.RunProc("delete from tb_units "+
                "delete from tb_BaseBgry " +
                "delete from tb_BaseCfdd " +
                "delete from tb_BaseDefaultNO " +
                "delete from tb_BaseJldw " +
                "delete from tb_BaseQlfs " +
                "delete from tb_BaseSybm " +
                "delete from tb_BaseSyqk " +
                "delete from tb_BaseZcmc " +
                "delete from tb_BaseZjfs " +
                "delete from tb_User");
        }

        public int DeleteOperationTable()
        {
            return data.RunProc("delete from tb_zcMain delete from tb_zcClear");
        }
        #endregion

        #region  set up TreeView of main form

        public DataSet TreeFill()
        {
            return data.RunProcReturn("select * from tb_BaseZclb select * from tb_BaseZjfs select * from tb_BaseSybm select * from tb_BaseSyqk select * from tb_BaseCfdd select * from tb_BaseBgry", "tb_zclb");
        }

        public DataSet GetDataGridViewList()
        {
            return data.RunProcReturn("select * from tb_DataGridViewList", "tb_DataGridViewList");
        }

        #endregion

        #region Equipment query

        public DataSet GetDataSetZC()
        {
            return data.RunProcReturn("select * from tb_zcMain ORDER BY ID", "tb_zcMain");
        }
        public DataSet GetDataSetZC(string findTitle,string findContent)
        {
            return data.RunProcReturn("select * from tb_zcMain where " + findTitle + "='" + findContent + "' ORDER BY ID", "tb_zcMain");
        }
        #endregion

        #region Equipment classify

        public DataSet GetDataSetBaseZclb(string zcName)
        {
            return data.RunProcReturn("select * from tb_BaseZclb where zclb='" + zcName + "'","tb_BaseZclb");
        }
        public DataSet GetDataSetBaseZclb()
        {
            return data.RunProcReturn("select * from tb_BaseZclb where firstID=1", "tb_BaseZclb");
        }

        public int insertBaseZclb(string firstID,string zclb,string secondID)
        {
            SqlParameter[] prams = {
									    data.MakeInParam("@firstID",  SqlDbType.VarChar, 10, firstID),
                						data.MakeInParam("@zclb",  SqlDbType.VarChar, 10, zclb),
                						data.MakeInParam("@secondID",  SqlDbType.VarChar, 10, secondID),
			};
            return (data.RunProc("INSERT INTO tb_BaseZclb (firstID,zclb,secondID) VALUES (@firstID,@zclb,@secondID)", prams));
        }

        public int deleteBaseZclb(int id)
        {
            return data.RunProc("delete from tb_BaseZclb where id='" + id + "'");
        }

        public int UpdateBaseZclb(int ID, string zclb)
        {
            SqlParameter[] prams = {
                                        data.MakeInParam("@ID",SqlDbType.Int,4,ID),
                						data.MakeInParam("@zclb",  SqlDbType.VarChar, 10, zclb),
			};
            return (data.RunProc("UPdate tb_BaseZclb set zclb=@zclb where id='" + ID + "'", prams));
        }
        #endregion

        #region  Basic Information -- query
        public DataSet GetDataSetBaseZcmc()
        {
            return data.RunProcReturn("select * from tb_BaseZcmc", "tb_BaseZcmc");
        }
        public DataSet GetDataSetBaseZjfs()
        {
            return data.RunProcReturn("select * from tb_BaseZjfs", "tb_BaseZjfs");
        }
        public DataSet GetDataSetBaseSybm()
        {
            return data.RunProcReturn("select * from tb_BaseSybm", "tb_BaseSybm");
        }
        public DataSet GetDataSetBaseSyqk()
        {
            return data.RunProcReturn("select * FROM tb_BaseSyqk", "tb_BaseSyqk");
        }
        public DataSet GetDataSetBaseCfdd()
        {
            return data.RunProcReturn("select * from tb_BaseCfdd", "tb_BaseCfdd");
        }
        public DataSet GetDataSetBaseBgry()
        {
            return data.RunProcReturn("select * from tb_BaseBgry","tb_BaseBgry");
        }
        public DataSet GetDataSetBaseJldw()
        {
            return data.RunProcReturn("select * from tb_BaseJldw", "tb_BaseJldw");
        }
        public DataSet GetDataSetBaseQlfs()
        {
            return data.RunProcReturn("select * from tb_BaseQlfs", "tb_BaseQlfs");
        }
        #endregion

        #region  Basic information--delete
        public int DeleteBaseZcmc(string id)
        {
            return data.RunProc("delete from tb_BaseZcmc where id='" + id + "'");
        }
        public int DeleteBaseZjfs(string id)
        {
            return data.RunProc("delete from tb_BaseZjfs where id='" + id + "'");
        }
        public int DeleteBaseSybm(string id)
        {
            return data.RunProc("delete from tb_BaseSybm where id='" + id + "'");
        }
        public int DeleteBaseSyqk(string id)
        {
            return data.RunProc("delete from tb_BaseSyqk where id='" + id + "'");
        }
        public int DeleteBaseCfdd(string id)
        {
            return data.RunProc("delete from tb_BaseCfdd where id='" + id + "'");
        }
        public int DeleteBaseBgry(string id)
        {
            return data.RunProc("delete from tb_BaseBgry where id='" + id + "'");
        }
        public int DeleteBaseJldw(string id)
        {
            return data.RunProc("delete from tb_BaseJldw where id='" + id + "'");
        }
        public int DeleteBaseQlfs(string id)
        {
            return data.RunProc("delete from tb_BaseQlfs where id='" + id + "'");
        }
        #endregion

        #region  Basic information add
        public int InsertBaseZcmc(string zcmc)
        {
            SqlParameter[] prams = {
                						data.MakeInParam("@zcmc",  SqlDbType.VarChar, 50, zcmc),
			};
            return (data.RunProc("INSERT INTO tb_BaseZcmc (zcmc) VALUES (@zcmc)", prams));
        }
        public int InsertBaseZjfs(string zjfs)
        {
            SqlParameter[] prams = {
                						data.MakeInParam("@zjfs",  SqlDbType.VarChar, 50, zjfs),
			};
            return (data.RunProc("INSERT INTO tb_BaseZjfs (zjfs) VALUES (@zjfs)", prams));
        }
        public int InsertBaseSybm(string sybm)
        {
            SqlParameter[] prams = {
                						data.MakeInParam("@sybm",  SqlDbType.VarChar, 50, sybm),
			};
            return (data.RunProc("INSERT INTO tb_BaseSybm (sybm) VALUES (@sybm)", prams));
        }
        public int InsertBaseSyqk(string syqk)
        {
            SqlParameter[] prams = {
                						data.MakeInParam("@syqk",  SqlDbType.VarChar, 50, syqk),
			};
            return (data.RunProc("INSERT INTO tb_BaseSyqk (syqk) VALUES (@syqk)", prams));
        }
        public int InsertBaseCfdd(string cfdd)
        {
            SqlParameter[] prams = {
                						data.MakeInParam("@cfdd",  SqlDbType.VarChar, 50, cfdd),
			};
            return (data.RunProc("INSERT INTO tb_BaseCfdd (cfdd) VALUES (@cfdd)", prams));