/*----------------------------------------------------------------
* Copyright (C) 2010 RootSoft
* 版权所有。
*
* 文件功能描述:Web服务全局类
*
* 作者:欧阳光
*
* 创建标识: Sunlight 2010-01-15
*
* 修改标识:
* 修改描述:
//----------------------------------------------------------------*/
using System;
using System.Web;
using System.Collections;
using System.Data;
using System.IO;
/// <summary>
/// GolbalService 的摘要说明
/// </summary>
namespace eHelper.Database
{
public class GlobalService
{
public GlobalService()
{
}
private DBOperatorFactory.DBName _dbName = DBOperatorFactory.DBName.MESDB;
public DBOperatorFactory.DBName DBName
{
get { return _dbName; }
set { _dbName = value; }
}
public void SetDB(DBOperatorFactory.DBName dbName)
{
DBName = dbName;
}
public DBOperator GetDBOperator(DBOperatorFactory.DBName DBName)
{
return new DBOperator(DBName);
}
/// <summary>
/// 新增、修改、删除的公用方法
/// </summary>
/// <param name="sPName"></param>
/// <param name="dt"></param>
/// <returns></returns>
public bool Save(string sPName, DataSet dt)
{
try
{
DBOperator db = GetDBOperator(DBName);
return db.Save(sPName, dt.Tables[0].Rows[0]) > 0;
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
/// <summary>
/// 用DataAdapter更新数据的公用方法
/// </summary>
/// <param name="dt"></param>
/// <returns></returns>
public int DataAdapterSave(DataSet dt)
{
try
{
DBOperator db = GetDBOperator(DBName);
return db.DataAdapterSave(dt);
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
/// <summary>
/// 用DataAdapter更新数据的公用方法
/// </summary>
/// <param name="dt"></param>
/// <param name="sSelect"></param>
/// <returns></returns>
public int DataAdapterSave(DataSet dt,string sSelect)
{
try
{
DBOperator db = GetDBOperator(DBName);
return db.DataAdapterSave(dt,sSelect);
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
/// <summary>
/// 根据条件查询,当没有结果集但有输出参数不会把参数返回
/// </summary>
/// <param name="sPName"></param>
/// <param name="ds"></param>
/// <returns></returns>
public DataSet QueryBySP(string sPName, DataSet ds)
{
try
{
DBOperator db = GetDBOperator(DBName);
return db.QuerySP(sPName, ds.Tables[0].Rows[0]);
}
catch (Exception e)