- SqlParameter[] parameters =...{ new SqlParameter("@tblName",SqlDbType.NVarChar,200),
- new SqlParameter("@fldName",SqlDbType.NVarChar,500),
- new SqlParameter("@pageSize",SqlDbType.Int),
- new SqlParameter("@page",SqlDbType.Int),
- new SqlParameter("@fldSort",SqlDbType.NVarChar,200),
- new SqlParameter("@Sort",SqlDbType.Bit),
- new SqlParameter("@strCondition",SqlDbType.NVarChar,1000),
- new SqlParameter("@ID",SqlDbType.NVarChar,150),
- new SqlParameter("@Dist",SqlDbType.Bit),
- new SqlParameter("@pageCount",SqlDbType.Int),
- new SqlParameter("@Counts",SqlDbType.Int),
- new SqlParameter("@strSql",SqlDbType.NVarChar,1000)};
- parameters[0].Value = tblName;
- parameters[1].Value = (fldName == null) ? "*" : fldName;
- parameters[2].Value = (pageSize == 0) ? int.Parse(ConfigurationManager.AppSettings["PageSize"]) : pageSize;
- parameters[3].Value = pageIndex;
- parameters[4].Value = fldSort;
- parameters[5].Value = Sort;
- parameters[6].Value = strCondition == null ? "" : strCondition;
- parameters[7].Value = ID;
- parameters[8].Value = Dist;
- parameters[9].Direction = ParameterDirection.Output;
- parameters[10].Direction = ParameterDirection.Output;
- parameters[11].Direction = ParameterDirection.Output;
- DataSet ds = RunProcedure(connectionString, "PageList", parameters, "ds");
- SqlParameter[] paraList = new SqlParameter[7];
- paraList[0] = new SqlParameter( "@userName ", SqlDbType.VarChar, 50);
- paraList[0].Value = personModel.UserName;
- paraList[1] = new SqlParameter( "@account ", SqlDbType.VarChar, 100);
- paraList[1].Value = personModel.Account;
- paraList[2] = new SqlParameter( "@pwd ", SqlDbType.VarChar, 100);
- paraList[2].Value = personModel.Pwd;
- paraList[3] = new SqlParameter( "@unitID ", SqlDbType.VarChar, 20);
- paraList[3].Value = personModel.UnitID;
- paraList[4] = new SqlParameter( "@email ", SqlDbType.VarChar, 100);
- paraList[4].Value = personModel.Email;
- paraList[5] = new SqlParameter( "@officeTel ", SqlDbType.VarChar, 20);
- paraList[5].Value = personModel.OfficeTel;
- paraList[6] = new SqlParameter( "@mobile ", SqlDbType.VarChar, 20);
- paraList[6].Value = personModel.Mobile;
- return sd.ExecuteNonQuery( "UP_Person_ADD ", paraList);