/// <summary>
/// 执行存储过程 返回ID号 主要用于新增
/// </summary>
/// <param name="iOperateFlag"></param>
/// <returns></returns>
public long ExecNonQuery(int iOperateFlag)
{
SqlParameterCollection sqlpc = InitCmd(iOperateFlag);
int rowsAffected;
return(DbHelperSQLYYS.RunProcedure(proceName, sqlpc, out rowsAffected));
}
/// <summary>
/// 返回Table
/// </summary>
/// <returns>获取查询表</returns>
public DataTable ExecDT(int iOperateFlag)
{
SqlParameterCollection sqlpc = InitCmd(iOperateFlag);
DataTable dt = new DataTable();
dt = DbHelperSQLYYS.RunProcedure(this.proceName, sqlpc, this.proceName).Tables[0];
return(dt);
}
/// <summary>
/// 获取分页数据
/// </summary>
/// <param name="PageIndex">页码</param>
/// <param name="strWhere">查询条件</param>
/// <param name="orderBy">排序字段</param>
/// <param name="order">排序顺序</param>
/// <param name="orderType">升序、降序，默认降序</param>
/// <returns></returns>
public DataSet XCXGetDataList(int PageSize, int PageIndex, string orderBy, string order, string strWhere, int isAllData)
{
SqlParameter[] parameters =
{
new SqlParameter("@pageSize", PageSize),
new SqlParameter("@currPage", PageIndex),
new SqlParameter("@orderBy", orderBy),
new SqlParameter("@order", order),
new SqlParameter("@filter", strWhere),
new SqlParameter("@isAllData", isAllData),
};
return(DbHelperSQLYYS.RunProcedure("sp_S_EmbodyContactPage", parameters, "data"));
}
/// <summary>
/// 得到一个实体
/// </summary>
public void ExecuteEL(int iOperateFlag)
{
SqlParameterCollection sqlpc = InitCmd(iOperateFlag);
DataTable dt = new DataTable();
dt = DbHelperSQLYYS.RunProcedure(this.proceName, sqlpc, this.proceName).Tables[0];
if (dt.Rows.Count > 0)
{
InitByRow(dt.Rows[0]);
}
else
{
m_ID = 0;
}
}
/// <summary>
/// 获取分页数据
/// </summary>
/// <param name="PageIndex">页码</param>
/// <param name="strWhere">查询条件</param>
/// <param name="strOrder">排序字段</param>
/// <param name="orderType">升序、降序，默认降序</param>
/// <returns></returns>
public DataSet GetPageList(string strTableName, int PageIndex, string strWhere, string strOrder, OrderType orderType = OrderType.desc)
{
SqlParameter[] parameters =
{
new SqlParameter("@tblName", SqlDbType.VarChar, 255),
new SqlParameter("@fldName", SqlDbType.VarChar, 255),
new SqlParameter("@OrderfldName", SqlDbType.VarChar, 255),
new SqlParameter("@PageSize", SqlDbType.Int),
new SqlParameter("@PageIndex", SqlDbType.Int),
new SqlParameter("@IsReCount", SqlDbType.Bit),
new SqlParameter("@OrderType", SqlDbType.Bit),
new SqlParameter("@strWhere", SqlDbType.VarChar, 1000)
};
parameters[0].Value = strTableName;
parameters[1].Value = "*";//根据实际情况进行修正
parameters[2].Value = strOrder;
parameters[3].Value = PagerInfo.PageSize;
parameters[4].Value = PageIndex;
parameters[5].Value = 1;
parameters[6].Value = (int)orderType;
parameters[7].Value = strWhere;
return(DbHelperSQLYYS.RunProcedure("UP_GetRecordByPageOrder", parameters, "dspage"));
}
/// <summary>
/// ExecuteSqlString
/// </summary>
/// <returns>根据查询语言获取数据集</returns>
public DataTable ExecuteSqlString(string SqlString)
{
return(DbHelperSQLYYS.Query(SqlString).Tables[0]);
}
