?? 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 = {
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -