public static RespFunStruct ExtBaseFuncCall(ReqeFunStruct reqeObj)
{
RespFunStruct resp = new RespFunStruct();
bool result = false;
UserIDOP userID = reqeObj.userIDOP;
switch (reqeObj.FunName)
{
case ComFunCallEnum.LogFunctionCall:
UserFunctionOPLog add = JsonConvert.DeserializeObject <UserFunctionOPLog>(reqeObj.FunObject.ToString());
try
{
result = BLL.OPLog.Add(add, GlobalStaticObj_Server.DbPrefix + GlobalStaticObj_Server.CommAccCode);
resp.IsSuccess = "1";
resp.ReturnObject = result.ToString();
}
catch (Exception ex)
{
resp.IsSuccess = "0";
resp.Msg = "ComFunCallEnum.LogFunctionCall error";
ex.Data.Add("UserCustomDefinitionMsg", "准确点错误描述：ComFunCallEnum.LogFunctionCall;Add对象JSON字串描述：" + reqeObj.FunObject.ToString());
throw ex;
}
break;
}
return(resp);
}
/// <summary> 查询单个字段的值(一般求最大，最小值)
/// <param name="opName">操作名</param>
/// <param name="tableName">表名</param>
/// <param name="field">单个查询字段</param>
/// <param name="orderBy">排序字段，多个以“,”分割</param>
/// </summary>
/// <returns>返回Value</returns>
public static string GetSingleValue(string opName, string currAccDbName, string tableName, string field, string where, string orderBy)
{
StringBuilder strBuilder = new StringBuilder();
strBuilder.Append("select " + field);
if (!string.IsNullOrEmpty(tableName))
{
strBuilder.Append(" from " + tableName);
if (!string.IsNullOrEmpty(where))
{
strBuilder.Append(" where " + where);
}
if (!string.IsNullOrEmpty(orderBy))
{
strBuilder.Append(" order by " + orderBy);
}
}
Dictionary <string, ParamObj> dic = new Dictionary <string, ParamObj>();
UserIDOP userOp = new UserIDOP()
{
UserID = GlobalStaticObj_Server.Instance.UserID, OPName = opName
};
string connString = LocalVariable.GetConnString(currAccDbName, ConfigConst.ConnectionStringReadonly);
object obj = DbCommon.Instance.ExecuteNonQueryReturnObjectNoTrans(connString, CommandType.Text, strBuilder.ToString(), dic, userOp);
if (obj == null)
{
return("");
}
return(obj.ToString());
}
public DataSet getDataSet(string connStr, CommandType cmdType, string sql, UserIDOP userID)
{
DataSet ds = new DataSet();
ds = DBUtility.SqlHelper.ExecuteDataSet(connStr, cmdType, sql, userID, null);
return(ds);
}
public int ExtNonQueryByTrans(string sql, string connStr, UserIDOP userID)
{
int val = 0;
val = DBUtility.SqlHelper.ExecuteNonQueryTran(connStr, CommandType.Text, sql, userID, null);
return(val);
}
/// <summary> 新增或更新(专门写日志)
/// </summary>
/// /// <param name="opName">操作名</param>
/// <param name="tableName">表名</param>
/// <param name="keyName">主键名称</param>
/// <param name="keyValue">主键值,如果有值，表示更新记录</param>
/// <param name="dicFileds">字段集合</param>
/// <returns>返回执行是否成功</returns>
public static bool Submit_AddLog(string opName, string currAccDbName, string tableName, string keyName, string keyValue, Dictionary <string, string> dicFileds)
{
UserIDOP userOp = new UserIDOP()
{
UserID = GlobalStaticObj_Server.Instance.UserID, OPName = opName
};
string connString = LocalVariable.GetConnString(currAccDbName, ConfigConst.ConnectionStringWrite);
return(DbCommon.Instance.Submit_AddOrEditLog(userOp, connString, tableName, keyName, keyValue, dicFileds));
}
/// <summary>删除 BYID
/// </summary>
/// <param name="opName">操作名</param>
/// <param name="tableName">表名</param>
/// <param name="keyName">键名称</param>
/// <param name="keyValue">键值</param>
/// <returns></returns>
public static bool DeleteDataByID(string opName, string currAccDbName, string tableName, string keyName, string keyValue)
{
UserIDOP userOp = new UserIDOP()
{
UserID = GlobalStaticObj_Server.Instance.UserID, OPName = opName
};
string connString = LocalVariable.GetConnString(currAccDbName, ConfigConst.ConnectionStringWrite);
return(DbCommon.Instance.DeleteDataByID(connString, tableName, keyName, keyValue, userOp));
}
/// <summary> 事务批量执行
/// </summary>
/// <param name="opName">操作名</param>
/// <param name="sqlObjList">批量sql</param>
/// <returns></returns>
public static bool BatchExeSQLMultiByTrans(string opName, string currAccDbName, IList <SQLObj> sqlObjList)
{
UserIDOP userOp = new UserIDOP()
{
UserID = GlobalStaticObj_Server.Instance.UserID, OPName = opName
};
string connString = LocalVariable.GetConnString(currAccDbName, ConfigConst.ConnectionStringWrite);
return(DbCommon.Instance.BatchExeSQLMultiByTrans(connString, sqlObjList, userOp));
}
/// <summary>查询表
/// </summary>
/// <param name="opName">操作名</param>
/// <param name="obj">操作sql对象</param>
/// <returns></returns>
public static DataSet GetDataSet(string opName, string currAccDbName, SQLObj obj)
{
UserIDOP userOp = new UserIDOP()
{
UserID = GlobalStaticObj_Server.Instance.UserID, OPName = opName
};
string connString = LocalVariable.GetConnString(currAccDbName, ConfigConst.ConnectionStringReadonly);
DataSet ds = DbCommon.Instance.ExecuteNonQueryReturnDataSetNoTrans(connString, obj.cmdType, obj.sqlString, obj.Param, userOp);
return(ds);
}
/// <summary>根据主键值，单表删除多记录，In操作
/// </summary>
/// <param name="opName">操作名</param>
/// <param name="sqlObjList">sql对象</param>
/// <returns></returns>
public static bool BatchUpdateDataByIn(string opName, string currAccDbName, string tableName, Dictionary <string, string> dicParam, string pkName, string[] pkValues)
{
UserIDOP userOp = new UserIDOP()
{
UserID = GlobalStaticObj_Server.Instance.UserID, OPName = opName
};
string connString = LocalVariable.GetConnString(currAccDbName, ConfigConst.ConnectionStringWrite);
int count = DbCommon.Instance.BatchUpdateDataByIn(connString, tableName, dicParam, pkName, pkValues, userOp);
return(count > 0);
}
/// <summary>根据条件删除指定表中的数据
/// </summary>
/// <param name="opName">操作名</param>
/// <param name="tableName">表名</param>
/// <param name="strWhere">执行条件，不包含where</param>
/// <returns></returns>
public static bool BatchDeleteDataByWhere(string opName, string currAccDbName, string tableName, string strWhere)
{
UserIDOP userOp = new UserIDOP()
{
UserID = GlobalStaticObj_Server.Instance.UserID, OPName = opName
};
string connString = LocalVariable.GetConnString(currAccDbName, ConfigConst.ConnectionStringWrite);
int flag = DbCommon.Instance.BatchDeleteDataByWhere(connString, tableName, strWhere, userOp);
return(flag > 0);
}
/// <summary>
/// 事务批量执行，不备份
/// </summary>
/// <param name="opName">操作名</param>
/// <param name="listSql">批量sql</param>
/// <returns></returns>
public static bool BatchExeSQLStrMultiByTransNoLogNoBackup(string opName, string accCode, List <SysSQLString> listSql)
{
UserIDOP userOp = new UserIDOP()
{
UserID = GlobalStaticObj_Server.Instance.UserID, OPName = opName
};
string conn = LocalVariable.GetConnString(GlobalStaticObj_Server.DbPrefix + accCode, ConfigConst.ConnectionStringWrite);
return(DbCommon.Instance.BatchExeSQLStrMultiByTransNoLogNoBackup(conn,
listSql, userOp));
}
/// <summary>
/// 批量插入数据
/// </summary>
/// <param name="opName">操作名</param>
/// <param name="tableName">表名</param>
/// <param name="listRow">数据</param>
/// <returns></returns>
public static bool SqlBulkByTransNoLogNoBackUp(string opName, string accCode, string tableName, List <DataRow> listRow)
{
UserIDOP userOp = new UserIDOP()
{
UserID = GlobalStaticObj_Server.Instance.UserID, OPName = opName
};
string conn = LocalVariable.GetConnString(GlobalStaticObj_Server.DbPrefix + accCode, ConfigConst.ConnectionStringWrite);
return(DbCommon.Instance.SqlBulkByTransNoLogNoBackUp(conn,
tableName, listRow));
}
/// <summary> 根据通用的分页存储过程，分页查询
/// </summary>
/// <param name="opName">操作名</param>
/// <param name="tableName">表名</param>
/// <param name="fileds">查询字段集合，以“,”分割</param>
/// <param name="where">查询条件，不包含where</param>
/// <param name="groupBy">分组字段，多个以“,”分割</param>
/// <param name="orderBy">排序字段+排序方式，多个以“,”分割</param>
/// <param name="pageIndex">查询第几页</param>
/// <param name="pageSize">每页记录数</param>
/// <param name="recordCount">返回总记录数</param>
/// <returns>返回结果集</returns>
public static DataTable GetTableByPage(string opName, string currAccDbName, string tableName, string fileds, string where, string groupBy, string orderBy, int pageIndex, int pageSize, out int recordCount)
{
UserIDOP userOp = new UserIDOP()
{
UserID = GlobalStaticObj_Server.Instance.UserID, OPName = opName
};
int count = 0;
string connString = LocalVariable.GetConnString(currAccDbName, ConfigConst.ConnectionStringReadonly);
DataSet ds = DbCommon.Instance.GetListPageStoreProcedure(connString, pageIndex, pageSize, tableName, where, orderBy, fileds, userOp, ref count);
recordCount = count;
return(ds.Tables[0]);
}
/// <summary> 下载文件
/// </summary>
/// <param name="fileName">下载文件名称</param>
/// <returns></returns>
public Stream DownLoadFile(string fileName, string savePath, string userID, string cookieStr)
{
//if (!HXCSession.SessionCookie.CheckPCClientCookieStr(userID,cookieStr))
//{
// return null;
//}
//DownFileResponse response = new DownFileResponse();
//response.FileData = null;
UserFileOPLog uOpLog = new UserFileOPLog();
UserIDOP uOp = new UserIDOP();
uOp.UserID = userID;
uOp.OPName = "DownLoadFile";
uOpLog.userOP = uOp;
uOpLog.FileName = fileName;
string fileFullPath = Path.Combine(SavePath, fileName);//服务器文件路径
if (!string.IsNullOrEmpty(savePath))
{
fileFullPath = Path.Combine(SavePath, savePath, fileName);
}
uOpLog.FilePath = fileFullPath;
if (!File.Exists(fileFullPath))//判断文件是否存在
{
return(null);
}
FileStream myStream = null;
try
{
uOpLog.sTimeTicks = DateTime.UtcNow.Ticks;
myStream = File.OpenRead(fileFullPath);
}
catch (Exception ex) {
uOpLog.eTimeTicks = DateTime.UtcNow.Ticks;
uOpLog.exeResult = false;
return(null);
throw ex;
}
finally
{
uOpLog.eTimeTicks = DateTime.UtcNow.Ticks;
uOpLog.exeResult = true;
writeUserFileOpLog(uOpLog);
}
return(myStream);
}
/// <summary> 查询单个字段的值(一般求最大，最小值)
/// <param name="strSql">sql语句</param>
/// </summary>
/// <returns>返回Value</returns>
public static string GetSingleValue(string opName, string currAccDbName, string strSql)
{
Dictionary <string, ParamObj> dic = new Dictionary <string, ParamObj>();
UserIDOP userOp = new UserIDOP()
{
UserID = GlobalStaticObj_Server.Instance.UserID, OPName = opName
};
string connString = LocalVariable.GetConnString(currAccDbName, ConfigConst.ConnectionStringReadonly);
object obj = DbCommon.Instance.ExecuteNonQueryReturnObjectNoTrans(connString, CommandType.Text, strSql, dic, userOp);
if (obj == null)
{
return("");
}
return(obj.ToString());
}
/// <summary> 根据查询条件，查单表，重点是Where条件，拼接SQL
/// <param name="opName">操作名</param>
/// <param name="tableName">表名</param>
/// <param name="fileds">查询字段</param>
/// <param name="where">查询条件，不包含where</param>
/// <param name="groupBy">分组字段，多个以“,”分割</param>
/// <param name="orderBy">排序字段+排序方式，多个以“,”分割</param>
/// </summary>
/// <returns>返回结果集</returns>
public static DataTable GetTable(string opName, string currAccDbName, string tableName, string fileds, string where, string groupBy, string orderBy)
{
string[] fieldArr = Regex.Split(fileds, ",", RegexOptions.IgnorePatternWhitespace);
List <string> listField = new List <string>();
foreach (string str in fieldArr)
{
listField.Add(str);
}
UserIDOP userOp = new UserIDOP()
{
UserID = GlobalStaticObj_Server.Instance.UserID, OPName = opName
};
string connString = LocalVariable.GetConnString(currAccDbName, ConfigConst.ConnectionStringReadonly);
DataSet ds = DbCommon.Instance.SelOPSingleTable(connString, listField, tableName, where, orderBy, userOp);
return(ds.Tables[0]);
}
/// <summary> 下载文件
/// </summary>
/// <param name="fileName">下载文件名称</param>
/// <returns></returns>
public Stream DownLoadFile(string fileName, string savePath, string userID, string cookieStr)
{
UserFileOPLog uOpLog = new UserFileOPLog();
UserIDOP uOp = new UserIDOP();
uOp.UserID = userID;
uOp.OPName = "DownLoadFile";
uOpLog.userOP = uOp;
uOpLog.FileName = fileName;
string fileFullPath = Path.Combine(GlobalStaticObj_Server.Instance.FilePath, fileName);//服务器文件路径
if (!string.IsNullOrEmpty(savePath))
{
fileFullPath = Path.Combine(GlobalStaticObj_Server.Instance.FilePath, savePath, fileName);
}
uOpLog.FilePath = fileFullPath;
if (!File.Exists(fileFullPath))//判断文件是否存在
{
return(null);
}
FileStream myStream = null;
try
{
uOpLog.sTimeTicks = DateTime.UtcNow.Ticks;
myStream = File.OpenRead(fileFullPath);
}
catch (Exception ex) {
uOpLog.eTimeTicks = DateTime.UtcNow.Ticks;
uOpLog.exeResult = false;
return(null);
throw ex;
}
finally
{
uOpLog.eTimeTicks = DateTime.UtcNow.Ticks;
uOpLog.exeResult = true;
writeUserFileOpLog(uOpLog);
}
return(myStream);
}
/// <summary> 执行sql或存储过程
/// </summary>
/// <param name="opName">操作描述</param>
/// <param name="sqlString">sql语句或存储过程</param>
/// <param name="dicPara">参数</param>
/// <returns>返回是否成功</returns>
public static void ExtNonQuery(string opName, string currAccDbName, string sqlString, CommandType cmdType, Dictionary <string, string> dicPara)
{
UserIDOP userOp = new UserIDOP()
{
UserID = GlobalStaticObj_Server.Instance.UserID, OPName = opName
};
SQLObj sqlObj = new SQLObj();
sqlObj.cmdType = cmdType;
sqlObj.sqlString = sqlString;
sqlObj.Param = new Dictionary <string, ParamObj>();
if (dicPara != null)
{
foreach (string str in dicPara.Keys)
{
sqlObj.Param.Add(str, new ParamObj(str, dicPara[str], SysDbType.VarChar));
}
}
string connString = LocalVariable.GetConnString(currAccDbName, ConfigConst.ConnectionStringWrite);
DbCommon.Instance.ExtNonQuery(sqlObj, connString, userOp);
}
public static int IsExist(string connStr, string tableName, string pkName, string pkVal, UserIDOP userID)
{
return(Dal.IsExist(connStr, tableName, pkName, pkVal, userID));
}
public static int GetMaxNum(string connStr, string tableName, string pkName, UserIDOP userID)
{
return(Dal.GetMaxNum(connStr, tableName, pkName, userID));
}
public bool Submit_AddOrEdit(string connStr, string tableName, string pkName, string pkVal, Dictionary <string, string> ht, UserIDOP userID)
{
return(DBUtility.SqlHelper.Submit_AddOrEdit(connStr, tableName, pkName, pkVal, ht, userID));
}
public int DeleteData(string connStr, string tableName, string pkName, string pkVal, UserIDOP userID)
{
return(DBUtility.SqlHelper.DeleteData(connStr, tableName, pkName, pkVal, userID));
}
public DataTable GetDataTable(string connStr, string tableName, UserIDOP userID)
{
return(DBUtility.SqlHelper.GetDataTable(connStr, tableName, userID));
}
public Dictionary <string, string> GetHashtableById(string connStr, string tableName, string pkName, string pkVal, UserIDOP userID)
{
return(DBUtility.SqlHelper.GetHashtableById(connStr, tableName, pkName, pkVal, userID));
}
public int IsExist(string connStr, string tableName, string pkName, string pkVal, UserIDOP userID)
{
return(DBUtility.SqlHelper.IsExist(connStr, tableName, pkName, pkVal, userID));
}
public int GetMaxNum(string connStr, string tableName, string pkName, UserIDOP userID)
{
return(DBUtility.SqlHelper.GetMaxNum(connStr, tableName, pkName, userID));
}
public bool EnableSQLObj(string connStr, string sql, Dictionary <string, ParamObj> dic, UserIDOP userID)
{
SqlParameter[] commandParameters = DBUtility.SqlHelper.GetParameter(dic);
return(DBUtility.SqlHelper.ExecuteNonQueryReturnBool(connStr, CommandType.Text, sql, userID, commandParameters));
}
public static RespFunStruct ComFunCall(ReqeFunStruct reqeObj)
{
RespFunStruct resp = new RespFunStruct();
bool result = false;
int exeCount = 0;
UserIDOP userID = reqeObj.userIDOP;
switch (reqeObj.FunName)
{
//根据主键值，单表添加或者更新，给定主键为Update,缺失为Insert操作
case ComFunCallEnum.Submit_AddOrEdit:
Submit_AddOrEdit add = JsonConvert.DeserializeObject <Submit_AddOrEdit>(reqeObj.FunObject.ToString());
try
{
string connString = LocalVariable.GetConnString(GlobalStaticObj_Server.Instance.CurrAccDbName, ConfigConst.ConnectionStringWrite);
result = BLL.DbCommon.Instance.Submit_AddOrEdit(connString, add.TableName, add.pkName, add.pkVal, (Dictionary <string, string>)add.DicParam, userID);
resp.IsSuccess = "1";
resp.ReturnObject = result.ToString();
}
catch (Exception ex)
{
resp.IsSuccess = "0";
resp.Msg = "Submit_AddOrEdit error:" + ex.Message;
ex.Data.Add("UserCustomDefinitionMsg", "准确点错误描述：ComFunCallEnum.Submit_AddOrEdit;Submit_AddOrEdit对象JSON字串描述：" + reqeObj.FunObject.ToString());
throw ex;
}
break;
//根据主键值，单表删除单记录
case ComFunCallEnum.DeleteDataByID:
DeleteDataByID del = JsonConvert.DeserializeObject <DeleteDataByID>(reqeObj.FunObject.ToString());
try
{
string connString = LocalVariable.GetConnString(GlobalStaticObj_Server.Instance.CurrAccDbName, ConfigConst.ConnectionStringWrite);
result = BLL.DbCommon.Instance.DeleteDataByID(connString, del.TableName, del.pkName, del.pkVal, userID);
resp.IsSuccess = "1";
resp.ReturnObject = result.ToString();
}
catch (Exception ex)
{
resp.IsSuccess = "0";
resp.Msg = "DeleteDataByID error:" + ex.Message;
ex.Data.Add("UserCustomDefinitionMsg", "准确点错误描述：ComFunCallEnum.DeleteDataByID;DeleteDataByID对象JSON字串描述：" + reqeObj.FunObject.ToString());
throw ex;
}
break;
//根据主键值，单表删除多记录，In操作
case ComFunCallEnum.BatchDeleteDataByIn:
BatchDeleteDataByIn delBat = JsonConvert.DeserializeObject <BatchDeleteDataByIn>(reqeObj.FunObject.ToString());
try
{
string connString = LocalVariable.GetConnString(GlobalStaticObj_Server.Instance.CurrAccDbName, ConfigConst.ConnectionStringWrite);
exeCount = BLL.DbCommon.Instance.BatchDeleteDataByIn(connString, delBat.TableName, delBat.pkName, delBat.pkValues, userID);
resp.IsSuccess = "1";
resp.ReturnObject = exeCount.ToString();
}
catch (Exception ex)
{
resp.IsSuccess = "0";
resp.Msg = "BatchDeleteDataByIn error:" + ex.Message;
ex.Data.Add("UserCustomDefinitionMsg", "准确点错误描述：ComFunCallEnum.BatchDeleteDataByIn;BatchDeleteDataByIn对象JSON字串描述：" + reqeObj.FunObject.ToString());
throw ex;
}
break;
//根据Where条件，单表删除多记录
case ComFunCallEnum.BatchDeleteDataByWhere:
BatchDeleteDataByWhere delWhere = JsonConvert.DeserializeObject <BatchDeleteDataByWhere>(reqeObj.FunObject.ToString());
try
{
string connString = LocalVariable.GetConnString(GlobalStaticObj_Server.Instance.CurrAccDbName, ConfigConst.ConnectionStringWrite);
exeCount = BLL.DbCommon.Instance.BatchDeleteDataByWhere(connString, delWhere.TableName, delWhere.whereString, userID);
resp.IsSuccess = "1";
resp.ReturnObject = exeCount.ToString();
}
catch (Exception ex)
{
resp.IsSuccess = "0";
resp.Msg = "BatchDeleteDataByWhere error:" + ex.Message;
ex.Data.Add("UserCustomDefinitionMsg", "准确点错误描述：ComFunCallEnum.BatchDeleteDataByWhere;BatchDeleteDataByWhere对象JSON字串描述：" + reqeObj.FunObject.ToString());
throw ex;
}
break;
//根据主键值，单表更新多记录，In操作
case ComFunCallEnum.BatchUpdateDataByIn:
BatchUpdateDataByIn updaByIn = JsonConvert.DeserializeObject <BatchUpdateDataByIn>(reqeObj.FunObject.ToString());
try
{
string connString = LocalVariable.GetConnString(GlobalStaticObj_Server.Instance.CurrAccDbName, ConfigConst.ConnectionStringWrite);
exeCount = BLL.DbCommon.Instance.BatchUpdateDataByIn(connString, updaByIn.TableName, (Dictionary <string, string>)updaByIn.DicParam, updaByIn.pkName, updaByIn.pkValues, userID);
resp.IsSuccess = "1";
resp.ReturnObject = exeCount.ToString();
}
catch (Exception ex)
{
resp.IsSuccess = "0";
resp.Msg = "BatchUpdateDataByIn error:" + ex.Message;
ex.Data.Add("UserCustomDefinitionMsg", "准确点错误描述：ComFunCallEnum.BatchUpdateDataByIn;BatchUpdateDataByIn对象JSON字串描述：" + reqeObj.FunObject.ToString());
throw ex;
}
break;
// 根据Where条件，单表更新多记录
case ComFunCallEnum.BatchUpdateDataByWhere:
BatchUpdateDataByWhere updaByWhere = JsonConvert.DeserializeObject <BatchUpdateDataByWhere>(reqeObj.FunObject.ToString());
try
{
string connString = LocalVariable.GetConnString(GlobalStaticObj_Server.Instance.CurrAccDbName, ConfigConst.ConnectionStringWrite);
exeCount = BLL.DbCommon.Instance.BatchUpdateDataByWhere(connString, updaByWhere.TableName, (Dictionary <string, string>)updaByWhere.DicParam, updaByWhere.whereString, userID);
resp.IsSuccess = "1";
resp.ReturnObject = exeCount.ToString();
}
catch (Exception ex)
{
resp.IsSuccess = "0";
resp.Msg = "BatchUpdateDataByWhere error:" + ex.Message;
ex.Data.Add("UserCustomDefinitionMsg", "准确点错误描述：ComFunCallEnum.BatchUpdateDataByWhere;BatchUpdateDataByWhere对象JSON字串描述：" + reqeObj.FunObject.ToString());
throw ex;
}
break;
// 批处理更新操作，普通型
case ComFunCallEnum.BatchUpdateDataMulti:
BatchUpdateDataMulti updaMulti = JsonConvert.DeserializeObject <BatchUpdateDataMulti>(reqeObj.FunObject.ToString());
try
{
string connString = LocalVariable.GetConnString(GlobalStaticObj_Server.Instance.CurrAccDbName, ConfigConst.ConnectionStringWrite);
exeCount = BLL.DbCommon.Instance.BatchUpdateDataMulti(connString, updaMulti.batUpdateList, userID);
resp.IsSuccess = "1";
resp.ReturnObject = exeCount.ToString();
}
catch (Exception ex)
{
resp.IsSuccess = "0";
resp.Msg = "BatchUpdateDataMulti error:" + ex.Message;
ex.Data.Add("UserCustomDefinitionMsg", "准确点错误描述：ComFunCallEnum.BatchUpdateDataMulti;BatchUpdateDataMulti对象JSON字串描述：" + reqeObj.FunObject.ToString());
throw ex;
}
break;
// 批处理更新操作，事务型
case ComFunCallEnum.BatchUpdateDataMultiByTrans:
BatchUpdateDataMultiByTrans updaMultiByTrans = JsonConvert.DeserializeObject <BatchUpdateDataMultiByTrans>(reqeObj.FunObject.ToString());
try
{
string connString = LocalVariable.GetConnString(GlobalStaticObj_Server.Instance.CurrAccDbName, ConfigConst.ConnectionStringWrite);
exeCount = BLL.DbCommon.Instance.BatchUpdateDataMultiByTrans(connString, updaMultiByTrans.batUpdateList, userID);
resp.IsSuccess = "1";
resp.ReturnObject = exeCount.ToString();
}
catch (Exception ex)
{
resp.IsSuccess = "0";
resp.Msg = "BatchUpdateDataMultiByTrans error:" + ex.Message;
ex.Data.Add("UserCustomDefinitionMsg", "准确点错误描述：ComFunCallEnum.BatchUpdateDataMultiByTrans;BatchUpdateDataMultiByTrans对象JSON字串描述：" + reqeObj.FunObject.ToString());
throw ex;
}
break;
//一次执行(一次连接，多次执行多条语句，多参数多次添加)多条语句，返回bool;参数为SQLObj.
case ComFunCallEnum.BatchExeSQLMultiByTrans:
BatchExeSQLMultiByTrans BatchExeSQLMultiByTrans = JsonConvert.DeserializeObject <BatchExeSQLMultiByTrans>(reqeObj.FunObject.ToString());
try
{
string connString = LocalVariable.GetConnString(GlobalStaticObj_Server.Instance.CurrAccDbName, ConfigConst.ConnectionStringWrite);
result = BLL.DbCommon.Instance.BatchExeSQLMultiByTrans(connString, BatchExeSQLMultiByTrans.batSQLObjList, userID);
resp.IsSuccess = "1";
resp.ReturnObject = result.ToString();
}
catch (Exception ex)
{
resp.IsSuccess = "0";
resp.Msg = "BatchExeSQLMultiByTrans error:" + ex.Message;
ex.Data.Add("UserCustomDefinitionMsg", "准确点错误描述：ComFunCallEnum.BatchExeSQLMultiByTrans;BatchExeSQLMultiByTrans对象JSON字串描述：" + reqeObj.FunObject.ToString());
throw ex;
}
break;
//一次执行(一次连接，多次执行多条语句，多参数多次添加)多条语句，返回bool;参数为SQLString.
case ComFunCallEnum.BatchExeSQLStringMultiByTrans:
BatchExeSQLStringMultiByTrans BatchExeSQLStringMultiByTrans = JsonConvert.DeserializeObject <BatchExeSQLStringMultiByTrans>(reqeObj.FunObject.ToString());
try
{
string connString = LocalVariable.GetConnString(GlobalStaticObj_Server.Instance.CurrAccDbName, ConfigConst.ConnectionStringWrite);
result = BLL.DbCommon.Instance.BatchExeSQLMultiByTrans(connString, BatchExeSQLStringMultiByTrans.batSQLStringList, userID);
resp.IsSuccess = "1";
resp.ReturnObject = result.ToString();
}
catch (Exception ex)
{
resp.IsSuccess = "0";
resp.Msg = "BatchExeSQLMultiByTrans error:" + ex.Message;
ex.Data.Add("UserCustomDefinitionMsg", "准确点错误描述：ComFunCallEnum.BatchExeSQLStringMultiByTrans;BatchExeSQLStringMultiByTrans对象JSON字串描述：" + reqeObj.FunObject.ToString());
throw ex;
}
break;
//一次执行(一次连接，一次执行多条语句，多参数一次添加)多条语句，返回bool
case ComFunCallEnum.ExecuteNonQueryReturnBoolByTrans:
ExecuteNonQueryReturnBoolByTrans ExeSQLMultiByTrans = JsonConvert.DeserializeObject <ExecuteNonQueryReturnBoolByTrans>(reqeObj.FunObject.ToString());
try
{
string connString = LocalVariable.GetConnString(GlobalStaticObj_Server.Instance.CurrAccDbName, ConfigConst.ConnectionStringWrite);
result = BLL.DbCommon.Instance.ExecuteNonQueryReturnBoolByTrans(connString, ExeSQLMultiByTrans.sqlObj.cmdType, ExeSQLMultiByTrans.sqlObj.sqlString, ExeSQLMultiByTrans.sqlObj.Param, userID);
resp.IsSuccess = "1";
resp.ReturnObject = result.ToString();
}
catch (Exception ex)
{
resp.IsSuccess = "0";
resp.Msg = "ExecuteNonQueryReturnBoolByTrans error:" + ex.Message;
ex.Data.Add("UserCustomDefinitionMsg", "准确点错误描述：ComFunCallEnum.ExecuteNonQueryReturnBoolByTrans;ExecuteNonQueryReturnBoolByTrans对象JSON字串描述：" + reqeObj.FunObject.ToString());
throw ex;
}
break;
//一次执行(一次连接，多次执行多条语句，没有参数)多条语句带事务(无备份操作记录功能,无SQL日志操作记录功能)，返回带事务的bool执行结果
case ComFunCallEnum.BatchExeSQLStrMultiByTransNoLogNoBackup:
BatchExeSQLStringMultiByTrans BatchExeSQLStringMultiByTransNoLog = JsonConvert.DeserializeObject <BatchExeSQLStringMultiByTrans>(reqeObj.FunObject.ToString());
try
{
string connString = LocalVariable.GetConnString(GlobalStaticObj_Server.Instance.CurrAccDbName, ConfigConst.ConnectionStringWrite);
result = BLL.DbCommon.Instance.BatchExeSQLStrMultiByTransNoLogNoBackup(connString, BatchExeSQLStringMultiByTransNoLog.batSQLStringList, userID);
resp.IsSuccess = "1";
resp.ReturnObject = result.ToString();
}
catch (Exception ex)
{
resp.IsSuccess = "0";
resp.Msg = "BatchExeSQLStrMultiByTransNoLogNoBackup error:" + ex.Message;
ex.Data.Add("UserCustomDefinitionMsg", "准确点错误描述：ComFunCallEnum.BatchExeSQLStrMultiByTransNoLogNoBackup;BatchExeSQLStringMultiByTrans对象JSON字串描述：" + reqeObj.FunObject.ToString());
throw ex;
}
break;
//一次执行(一次连接，一次执行多条语句)多条语句(不带事务)，返回bool。
case ComFunCallEnum.ExecuteNonQueryReturnBoolNoTrans:
ExecuteNonQueryReturnBoolByTrans ExeSQLReturnBoolNoTrans = JsonConvert.DeserializeObject <ExecuteNonQueryReturnBoolByTrans>(reqeObj.FunObject.ToString());
try
{
string connString = LocalVariable.GetConnString(GlobalStaticObj_Server.Instance.CurrAccDbName, ConfigConst.ConnectionStringWrite);
result = BLL.DbCommon.Instance.ExecuteNonQueryReturnBoolNoTrans(connString, ExeSQLReturnBoolNoTrans.sqlObj.cmdType, ExeSQLReturnBoolNoTrans.sqlObj.sqlString, ExeSQLReturnBoolNoTrans.sqlObj.Param, userID);
resp.IsSuccess = "1";
resp.ReturnObject = result.ToString();
}
catch (Exception ex)
{
resp.IsSuccess = "0";
resp.Msg = "ExecuteNonQueryReturnBoolNoTrans error:" + ex.Message;
ex.Data.Add("UserCustomDefinitionMsg", "准确点错误描述：ComFunCallEnum.ExecuteNonQueryReturnBoolNoTrans;ExecuteNonQueryReturnBoolNoTrans对象JSON字串描述：" + reqeObj.FunObject.ToString());
throw ex;
}
break;
//一次执行(一次连接，一次执行多条语句)多条语句(不带事务)，返回影响行数Int。
case ComFunCallEnum.ExecuteNonQueryReturnIntNoTrans:
ExecuteNonQueryReturnIntNoTrans ExeSQLReturnIntNoTrans = JsonConvert.DeserializeObject <ExecuteNonQueryReturnIntNoTrans>(reqeObj.FunObject.ToString());
try
{
string connString = LocalVariable.GetConnString(GlobalStaticObj_Server.Instance.CurrAccDbName, ConfigConst.ConnectionStringWrite);
exeCount = BLL.DbCommon.Instance.ExecuteNonQueryReturnIntNoTrans(connString, ExeSQLReturnIntNoTrans.sqlObj.cmdType, ExeSQLReturnIntNoTrans.sqlObj.sqlString, ExeSQLReturnIntNoTrans.sqlObj.Param, userID);
resp.IsSuccess = "1";
resp.ReturnObject = exeCount.ToString();
}
catch (Exception ex)
{
resp.IsSuccess = "0";
resp.Msg = "ExecuteNonQueryReturnIntNoTrans error:" + ex.Message;
ex.Data.Add("UserCustomDefinitionMsg", "准确点错误描述：ComFunCallEnum.ExecuteNonQueryReturnIntNoTrans;ExecuteNonQueryReturnIntNoTrans对象JSON字串描述：" + reqeObj.FunObject.ToString());
throw ex;
}
break;
//一次执行(一次连接，一次执行多条语句)多条语句(不带事务)，返回Object。
case ComFunCallEnum.ExecuteNonQueryReturnObjectNoTrans:
ExecuteNonQueryReturnDataSetNoTrans ExeSQLReturnObjNoTrans = JsonConvert.DeserializeObject <ExecuteNonQueryReturnDataSetNoTrans>(reqeObj.FunObject.ToString());
Object obj;
try
{
string connString = LocalVariable.GetConnString(GlobalStaticObj_Server.Instance.CurrAccDbName, ConfigConst.ConnectionStringWrite);
obj = BLL.DbCommon.Instance.ExecuteNonQueryReturnObjectNoTrans(connString, ExeSQLReturnObjNoTrans.sqlObj.cmdType, ExeSQLReturnObjNoTrans.sqlObj.sqlString, ExeSQLReturnObjNoTrans.sqlObj.Param, userID);
resp.IsSuccess = "1";
resp.ReturnObject = obj == null ? "" : obj.ToString();
}
catch (Exception ex)
{
resp.IsSuccess = "0";
resp.Msg = "ExecuteNonQueryReturnObjectNoTrans error:" + ex.Message;
ex.Data.Add("UserCustomDefinitionMsg", "准确点错误描述：ComFunCallEnum.ExecuteNonQueryReturnObjectNoTrans;ExecuteNonQueryReturnObjectNoTrans对象JSON字串描述：" + reqeObj.FunObject.ToString());
throw ex;
}
break;
//一次执行(一次连接，一次执行多条语句)多条语句(不带事务)，返回DataSet。
case ComFunCallEnum.ExecuteNonQueryReturnDataSetNoTrans:
ExecuteNonQueryReturnDataSetNoTrans ExeSQLReturnDSNoTrans = JsonConvert.DeserializeObject <ExecuteNonQueryReturnDataSetNoTrans>(reqeObj.FunObject.ToString());
DataSet ds = new DataSet();
try
{
string connString = LocalVariable.GetConnString(GlobalStaticObj_Server.Instance.CurrAccDbName, ConfigConst.ConnectionStringReadonly);
ds = BLL.DbCommon.Instance.ExecuteNonQueryReturnDataSetNoTrans(connString, ExeSQLReturnDSNoTrans.sqlObj.cmdType, ExeSQLReturnDSNoTrans.sqlObj.sqlString, ExeSQLReturnDSNoTrans.sqlObj.Param, userID);
resp.IsSuccess = "1";
resp.ReturnObject = JsonConvert.SerializeObject(ds);
}
catch (Exception ex)
{
resp.IsSuccess = "0";
resp.Msg = "ExecuteNonQueryReturnDataSetNoTrans error:" + ex.Message;
ex.Data.Add("UserCustomDefinitionMsg", "准确点错误描述：ComFunCallEnum.ExecuteNonQueryReturnDataSetNoTrans;ExecuteNonQueryReturnDataSetNoTrans对象JSON字串描述：" + reqeObj.FunObject.ToString());
throw ex;
}
break;
//根据查询条件，查单表，重点是Where条件，拼接SQL
case ComFunCallEnum.SelOPSingleTable:
SelOPSingleTable selOpSingTable = JsonConvert.DeserializeObject <SelOPSingleTable>(reqeObj.FunObject.ToString());
DataSet ds1 = new DataSet();
try
{
string connString = LocalVariable.GetConnString(GlobalStaticObj_Server.Instance.CurrAccDbName, ConfigConst.ConnectionStringReadonly);
ds1 = BLL.DbCommon.Instance.SelOPSingleTable(connString, selOpSingTable.Fields, selOpSingTable.TableName, selOpSingTable.whereString, selOpSingTable.AdditionalConditions, userID);
//var jSetting = new JsonSerializerSettings();
//jSetting.NullValueHandling = NullValueHandling.Include;
//jSetting.DefaultValueHandling = DefaultValueHandling.Include;
//jSetting.MissingMemberHandling = MissingMemberHandling.Error;
resp.IsSuccess = "1";
resp.ReturnObject = JsonConvert.SerializeObject(ds1);
}
catch (Exception ex)
{
resp.IsSuccess = "0";
resp.Msg = "SelOPSingleTable error:" + ex.Message;
ex.Data.Add("UserCustomDefinitionMsg", "准确点错误描述：ComFunCallEnum.SelOPSingleTable;SelOPSingleTable对象JSON字串描述：" + reqeObj.FunObject.ToString());
throw ex;
}
break;
//根据查询条件，查单表，查前几条，重点是Where条件，拼接SQL
case ComFunCallEnum.SelTopOPSingleTable:
SelTopOPSingleTable selTopOpSingTable = JsonConvert.DeserializeObject <SelTopOPSingleTable>(reqeObj.FunObject.ToString());
DataSet ds2 = new DataSet();
try
{
string connString = LocalVariable.GetConnString(GlobalStaticObj_Server.Instance.CurrAccDbName, ConfigConst.ConnectionStringReadonly);
ds2 = BLL.DbCommon.Instance.SelTopOPSingleTable(connString, selTopOpSingTable.TopNum, selTopOpSingTable.Fields, selTopOpSingTable.TableName, selTopOpSingTable.whereString, selTopOpSingTable.AdditionalConditions, userID);
resp.IsSuccess = "1";
resp.ReturnObject = JsonConvert.SerializeObject(ds2);
}
catch (Exception ex)
{
resp.IsSuccess = "0";
resp.Msg = "SelTopOPSingleTable error:" + ex.Message;
ex.Data.Add("UserCustomDefinitionMsg", "准确点错误描述：ComFunCallEnum.SelTopOPSingleTable;SelTopOPSingleTable对象JSON字串描述：" + reqeObj.FunObject.ToString());
throw ex;
}
break;
//根据通用的分页存储过程，分页查询GetListPageStoreProcedure(page, pageSize, tableSource, whereValue, OrderExpression, Fields, ref Counts);
case ComFunCallEnum.SelOPByStoreProcePage:
SelOPByStoreProcePage selOpBySPPage = JsonConvert.DeserializeObject <SelOPByStoreProcePage>(reqeObj.FunObject.ToString());
DataSet ds3 = new DataSet();
try
{
string connString = LocalVariable.GetConnString(GlobalStaticObj_Server.Instance.CurrAccDbName, ConfigConst.ConnectionStringReadonly);
ds3 = BLL.DbCommon.Instance.GetListPageStoreProcedure(connString, selOpBySPPage.PageIndex, selOpBySPPage.PageSize, selOpBySPPage.TableSource, selOpBySPPage.whereString, selOpBySPPage.OrderExpression, selOpBySPPage.Fields, userID, ref exeCount);
resp.IsSuccess = "1";
resp.ReturnObject = JsonConvert.SerializeObject(ds3);
resp.RecordCount = exeCount;
}
catch (Exception ex)
{
resp.IsSuccess = "0";
resp.Msg = "SelOPByStoreProcePage error:" + ex.Message;
ex.Data.Add("UserCustomDefinitionMsg", "准确点错误描述：ComFunCallEnum.SelOPByStoreProcePage;SelOPByStoreProcePage对象JSON字串描述：" + reqeObj.FunObject.ToString());
throw ex;
}
break;
/// <summary>
/// SQLBulk方式操作带事务，无日志记录，无操作备份
/// </summary>
/// <param name="connStr">数据库连接串</param>
/// <param name="tableName">表名</param>
/// <param name="listRow">DataRowList集合</param>
/// <returns>SQLBulk批处理方式操作带事务，执行结果。全部成功，返回Bool True; 否则，返回False。</returns>
case ComFunCallEnum.SqlBulkByTransNoLogNoBackUp:
SqlBulkByTransNoLogNoBackUp SqlBulkNoLogNoBackUp = JsonConvert.DeserializeObject <SqlBulkByTransNoLogNoBackUp>(reqeObj.FunObject.ToString());
try
{
string connString = LocalVariable.GetConnString(GlobalStaticObj_Server.Instance.CurrAccDbName, ConfigConst.ConnectionStringWrite);
result = BLL.DbCommon.Instance.SqlBulkByTransNoLogNoBackUp(connString, SqlBulkNoLogNoBackUp.tableName, SqlBulkNoLogNoBackUp.listRow);
resp.IsSuccess = "1";
resp.ReturnObject = result.ToString();
}
catch (Exception ex)
{
resp.IsSuccess = "0";
resp.Msg = "SqlBulkByTransNoLogNoBackUp error:" + ex.Message;
ex.Data.Add("UserCustomDefinitionMsg", "准确点错误描述：ComFunCallEnum.SqlBulkByTransNoLogNoBackUp;SqlBulkByTransNoLogNoBackUp对象JSON字串描述：" + reqeObj.FunObject.ToString());
throw ex;
}
break;
}
exeCount = 0;
return(resp);
}
/// <summary> 上传文件
/// </summary>
/// <param name="request">1上传成功，0上传失败</param>
public UploadFileResponse UploadFile(FileTransferMessage request)
{
UploadFileResponse response = new UploadFileResponse();
response.Flag = false;
UserFileOPLog uOpLog = new UserFileOPLog();
UserIDOP uOp = new UserIDOP();
uOp.UserID = request.UserID;
uOp.OPName = "UploadFile";
uOpLog.userOP = uOp;
uOpLog.FileName = request.FileName;
if (!Directory.Exists(GlobalStaticObj_Server.Instance.FilePath)) //存放的默认文件夹是否存在
{
Directory.CreateDirectory(GlobalStaticObj_Server.Instance.FilePath); //不存在则创建
}
string path = GlobalStaticObj_Server.Instance.FilePath;
if (!string.IsNullOrEmpty(request.SavePath))
{
path = Path.Combine(GlobalStaticObj_Server.Instance.FilePath, request.SavePath);
}
if (!Directory.Exists(path))
{
Directory.CreateDirectory(path);
}
uOpLog.sTimeTicks = DateTime.UtcNow.Ticks;
string fileName = request.FileName; //文件名
string fileFullPath = Path.Combine(path, fileName); //合并路径生成文件存放路径
uOpLog.FilePath = fileFullPath;
Stream sourceStream = request.FileData;
if (sourceStream == null)
{
return(response);
}
if (!sourceStream.CanRead)
{
return(response);
}
//创建文件流，读取流中的数据生成文件
using (FileStream fs = new FileStream(fileFullPath, FileMode.Create, FileAccess.Write, FileShare.None))
{
try
{
const int bufferLength = 4096;
byte[] myBuffer = new byte[bufferLength];//数据缓冲区
int count;
while ((count = sourceStream.Read(myBuffer, 0, bufferLength)) > 0)
{
fs.Write(myBuffer, 0, count);
}
fs.Close();
sourceStream.Close();
uOpLog.eTimeTicks = DateTime.UtcNow.Ticks;
uOpLog.exeResult = true;
response.Flag = true;
return(response);
}
catch (Exception ex)
{
uOpLog.eTimeTicks = DateTime.UtcNow.Ticks;
uOpLog.exeResult = false;
return(response);
throw ex;
}
finally {
writeUserFileOpLog(uOpLog);
}
}
}
///// <summary>
///// 调用分页存储过程返回得到的数据集
///// </summary>
///// <param name="page"></param>
///// <param name="pageSize"></param>
///// <param name="tableSource"></param>
///// <returns></returns>
//public static DataSet GetListPageStoreProcedure(string connString, int page, int pageSize, string tableSource, string whereValue, UserIDOP userID, ref int Counts)
//{
// SqlParameter[] parm = new SqlParameter[]
// {
// new SqlParameter("@TableSource", SqlDbType.VarChar, 1000),
// new SqlParameter("@SelectList", SqlDbType.VarChar, 2000),
// new SqlParameter("@SearchCondition", SqlDbType.VarChar, 4000),
// new SqlParameter("@OrderExpression", SqlDbType.VarChar, 100),
// new SqlParameter("@PageIndex", SqlDbType.Int, 4),
// new SqlParameter("@PageSize", SqlDbType.Int, 4),
// new SqlParameter("@Counts", SqlDbType.Int, 4)
// };
// parm[0].Value = tableSource;
// parm[1].Value = " * ";
// parm[2].Value = whereValue;
// parm[3].Value = "[ID] desc";
// parm[4].Value = page;
// parm[5].Value = pageSize;
// parm[parm.Length - 1].Direction = ParameterDirection.Output;
// DataSet ds = new DataSet();
// ds = DBUtility.SqlHelper.ExecuteDataSet(connString, CommandType.StoredProcedure, "[dbo].[list_page]", userID, parm);
// Counts = Convert.ToInt32(parm[parm.Length - 1].Value);
// return ds;
//}
///// <summary>
///// 调用分页存储过程返回得到的数据集
///// </summary>
///// <param name="page"></param>
///// <param name="pageSize"></param>
///// <param name="tableSource"></param>
///// <param name="whereValue"></param>
///// <param name="OrderExpression"></param>
///// <param name="Fields"></param>
///// <returns></returns>
//public static DataSet GetListPageStoreProcedure(string connString, int page, int pageSize, string tableSource, string whereValue, string OrderExpression, string Fields, UserIDOP userID, ref int Counts)
//{
// SqlParameter[] parm = new SqlParameter[]
// {
// new SqlParameter("@TableSource", SqlDbType.VarChar, 1000),
// new SqlParameter("@SelectList", SqlDbType.VarChar, 2000),
// new SqlParameter("@SearchCondition", SqlDbType.VarChar, 4000),
// new SqlParameter("@OrderExpression", SqlDbType.VarChar, 100),
// new SqlParameter("@PageIndex", SqlDbType.Int, 4),
// new SqlParameter("@PageSize", SqlDbType.Int, 4),
// new SqlParameter("@Counts", SqlDbType.Int, 4)
// };
// parm[0].Value = tableSource;
// parm[1].Value = Fields;
// parm[2].Value = whereValue;
// parm[3].Value = OrderExpression;
// parm[4].Value = page;
// parm[5].Value = pageSize;
// parm[parm.Length - 1].Direction = ParameterDirection.Output;
// DataSet ds = new DataSet();
// ds = DBUtility.SqlHelper.ExecuteDataSet(connString, CommandType.StoredProcedure, "[dbo].[list_page]", userID, parm);
// Counts = Convert.ToInt32(parm[parm.Length - 1].Value);
// return ds;
//}
///// <summary>
///// 调用分页存储过程返回得到的数据集
///// </summary>
///// <param name="page"></param>
///// <param name="pageSize"></param>
///// <param name="tableSource"></param>
///// <param name="whereValue"></param>
///// <param name="OrderExpression"></param>
///// <param name="Fields"></param>
///// <returns></returns>
//public static DataSet GetListPageStoreProcedure(string connString, int page, int pageSize, string tableSource, string whereValue, string OrderExpression, string Fields, UserIDOP userID, ref int Counts)
//{
// SqlParameter[] parm = new SqlParameter[]
// {
// new SqlParameter("@TableSource", SqlDbType.VarChar, 1000),
// new SqlParameter("@SelectList", SqlDbType.VarChar, 2000),
// new SqlParameter("@SearchCondition", SqlDbType.VarChar, 4000),
// new SqlParameter("@OrderExpression", SqlDbType.VarChar, 100),
// new SqlParameter("@PageIndex", SqlDbType.Int, 4),
// new SqlParameter("@PageSize", SqlDbType.Int, 4),
// new SqlParameter("@Counts", SqlDbType.Int, 4)
// };
// parm[0].Value = tableSource;
// parm[1].Value = Fields;
// parm[2].Value = whereValue;
// parm[3].Value = OrderExpression;
// parm[4].Value = page;
// parm[5].Value = pageSize;
// parm[parm.Length - 1].Direction = ParameterDirection.Output;
// DataSet ds = new DataSet();
// ds = DBUtility.SqlHelper.ExecuteDataSet(connString, CommandType.StoredProcedure, "[dbo].[list_page]", userID, parm);
// Counts = Convert.ToInt32(parm[parm.Length - 1].Value);
// return ds;
//}
/// <summary>
/// 调用分页存储过程返回得到的数据集
/// </summary>
/// <param name="page"></param>
/// <param name="pageSize"></param>
/// <param name="tableSource"></param>
/// <param name="whereValue"></param>
/// <param name="OrderExpression"></param>
/// <param name="Fields"></param>
/// <returns></returns>
public static DataSet GetListPages(string connString, int page, int pageSize, string tableSource, string whereValue, string OrderExpression, string Fields, UserIDOP userID, ref int Counts)
{
SqlParameter[] parm = new SqlParameter[]
{
new SqlParameter("@TableSource", SqlDbType.VarChar, 1000),
new SqlParameter("@SelectList", SqlDbType.VarChar, 2000),
new SqlParameter("@SearchCondition", SqlDbType.VarChar, 4000),
new SqlParameter("@OrderExpression", SqlDbType.VarChar, 100),
new SqlParameter("@PageIndex", SqlDbType.Int, 4),
new SqlParameter("@PageSize", SqlDbType.Int, 4),
new SqlParameter("@Counts", SqlDbType.Int, 4)
};
parm[0].Value = tableSource;
parm[1].Value = Fields;
parm[2].Value = whereValue;
parm[3].Value = OrderExpression;
parm[4].Value = page;
parm[5].Value = pageSize;
parm[parm.Length - 1].Direction = ParameterDirection.Output;
DataSet ds = new DataSet();
ds = DBUtility.SqlHelper.ExecuteDataSet(connString, CommandType.StoredProcedure, "[dbo].[list_page_tables]", userID, parm);
Counts = Convert.ToInt32(parm[parm.Length - 1].Value);
return(ds);
}
