Ejemplo n.º 1
0
 /// <summary>
 ///  取记录列表(返回记录数)
 /// </summary>
 /// <param name="pageListModel"></param>
 /// <param name="rowCount"></param>
 /// <returns></returns>
 public DataSet GetList(PageListModel pageListModel, ref int rowCount)
 {
     SqlParameter[] parameters =
     {
         new SqlParameter("@select_list",  SqlDbType.VarChar, 1000),
         new SqlParameter("@table_name",   SqlDbType.VarChar, 3000),
         new SqlParameter("@where",        SqlDbType.VarChar, 8000),
         new SqlParameter("@primary_key",  SqlDbType.VarChar,  100),
         new SqlParameter("@order_by",     SqlDbType.VarChar,  100),
         new SqlParameter("@page_size",    SqlDbType.Int),
         new SqlParameter("@page_index",   SqlDbType.Int),
         new SqlParameter("@bl_page",      SqlDbType.Int),
         new SqlParameter("@flag",         SqlDbType.Int),
         new SqlParameter("@return_Value", SqlDbType.Int),
     };
     parameters[0].Value     = pageListModel.SelectList;
     parameters[1].Value     = pageListModel.Tables;
     parameters[2].Value     = pageListModel.StrWhere;
     parameters[3].Value     = pageListModel.PriKey;
     parameters[4].Value     = pageListModel.OrderByField;
     parameters[5].Value     = pageListModel.PageSize;
     parameters[6].Value     = pageListModel.PageIndex;
     parameters[7].Value     = pageListModel.BlPage;
     parameters[8].Value     = pageListModel.Flag;
     parameters[9].Direction = ParameterDirection.ReturnValue;
     return(Itemsql.RunProcedure("UP_Common_PageList", parameters, "ds", out rowCount));
 }
Ejemplo n.º 2
0
        /// <summary>
        /// 更新所有的视图
        /// </summary>
        public void UpdateAllView()
        {
            int rowsAffected;

            SqlParameter[] parameters = { };
            Itemsql.RunProcedure("UP_UpdateAllView", parameters, out rowsAffected);
        }
Ejemplo n.º 3
0
 /// <summary>
 /// 执行存储过程SP_PlanKC
 /// </summary>
 /// <param name="PlanID"></param>
 /// <param name="KcID"></param>
 /// <param name="Other"></param>
 /// <param name="OtherID"></param>
 public void RunPlanKc(string PlanID, string KcID, string Other, string OtherID)
 {
     SqlParameter[] parameters =
     {
         new SqlParameter("@PlanID",  PlanID),
         new SqlParameter("@KcID",    KcID),
         new SqlParameter("@Other",   Other),
         new SqlParameter("@OtherID", OtherID),
     };
     Itemsql.RunProcedureVoid("SP_PlanKC", parameters);
 }
Ejemplo n.º 4
0
        /// <summary>
        /// 取记录的最大ID
        /// </summary>
        /// <param name="FieldName">自增长主键ID字段名</param>
        /// <param name="TableName">表名</param>
        /// <returns></returns>
        public static string GetMaxID(string FieldName, string TableName)
        {
            string strsql = "select max(" + FieldName + ")+1 from " + TableName;
            object obj    = Itemsql.GetSingle(strsql);

            if (obj == null)
            {
                return("1");
            }
            else
            {
                return(obj.ToString());
            }
        }
Ejemplo n.º 5
0
        /// <summary>
        /// 判断记录是否存在(带参数SQL语句)
        /// </summary>
        /// <param name="strSql">SQL语句</param>
        /// <param name="cmdParms">参数</param>
        /// <returns></returns>
        public static bool Exists(string strSql, params SqlParameter[] cmdParms)
        {
            object obj = Itemsql.GetSingle(strSql, cmdParms);
            int    cmdresult;

            if ((Object.Equals(obj, null)) || (Object.Equals(obj, System.DBNull.Value)))
            {
                cmdresult = 0;
            }
            else
            {
                cmdresult = int.Parse(obj.ToString());
            }
            if (cmdresult == 0)
            {
                return(false);
            }
            else
            {
                return(true);
            }
        }