operation.cs

随着社会经济的不断发展

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 验证合法输入（0123456789.）
        /// <summary>
        /// 验证合法输入（0123456789.）
        /// </summary>
        /// <param name="strCode">验证字符</param>
        /// <returns></returns>
        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控件中数据导出到Excel
        /// <summary>
        /// 将DataGridView控件中数据导出到Excel
        /// </summary>
        /// <param name="gridView">DataGridView对象</param>
        /// <param name="isShowExcle">是否显示Excel界面</param>
        /// <returns></returns>
        public bool ExportDataGridview(DataGridView gridView,bool isShowExcle)
        {
            if (gridView.Rows.Count == 0)
                return false;
            //建立Excel对象
            Excel.Application excel = new 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  设置主窗体DataGridView的Width和Visble属性。
        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  设置本单位信息

        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  系统初始化
        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  设置主窗体TreeView菜单项
        /// <summary>
        /// 获取TreeView菜单项
        /// </summary>
        /// <returns></returns>
        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");
        }
        /// <summary>
        /// 获取主窗体DataGridView控件的属性设置
        /// </summary>
        /// <returns></returns>
        public DataSet GetDataGridViewList()
        {
            return data.RunProcReturn("select * from tb_DataGridViewList", "tb_DataGridViewList");
        }
        /// <summary>
        /// 获取所有固定资产信息
        /// </summary>
        /// <returns></returns>
        #endregion

        #region　资产查询
        /// <summary>
        /// 获得所有资产
        /// </summary>
        /// <returns></returns>
        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 设置资产分类
        /// <summary>
        /// 查询现有资产名称列表
        /// </summary>
        /// <param name="zcName">资产名称</param>
        /// <returns></returns>
        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");
        }
        /// <summary>
        /// 添加资产名称
        /// </summary>
        /// <param name="firstID"></param>
        /// <param name="zclb"></param>
        /// <param name="secondID"></param>
        /// <returns></returns>
        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));
        }
        /// <summary>
        /// 删除指定ＩＤ的资产名称
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public int deleteBaseZclb(int id)
        {
            return data.RunProc("delete from tb_BaseZclb where id='" + id + "'");
        }
        /// <summary>
        /// 修改指定ＩＤ的资产名称
        /// </summary>
        /// <param name="zclb"></param>
        /// <returns></returns>
        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  基本资料管理---查询
        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  基本资料管理----删除
        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  基本资料管理－－－添加
        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 = {