1 //冒泡排序
public void MaoPaoPaiXu(int[] array)
{
int temp = 0;
for (int i = 0; i < array.Length - 1; i++)
{
for (int j = i + 1; j < array.Length; j++)
{
if (array[j] > array[i])
{
temp = array[i];
array[i] = array[j];
array[j] = temp;
}
}
}
}
2 分页
http://www.cnblogs.com/sujilove/archive/2008/09/25/1298704.html
http://www.cnblogs.com/chthp/archive/2009/03/13/1410416.html
3
private DBCommonSQL db = new DBCommonSQL();
/// <summary>
/// Method Name :OfficeInfo_GetOfficeInfobyId
/// Function :取出在OfficeInfo表中所有信息通过参数Office_Id
/// Creator :Charry Chen
/// Createcd Time :[5-14-2007]
/// </summary>
/// <param name="Office_ID"></param>
/// <returns>DataTable</returns>
public DataTable OfficeInfo_GetOfficeInfobyId(int Office_ID)
{
SConnParameterSql scParameter = new SConnParameterSql();
DataTable dt = new DataTable();
try
{
scParameter.ds = new DataSet();
scParameter.commandtext = "OfficeInfo_GetOfficeInfobyId";
scParameter.commandtype = CommandType.StoredProcedure;
SqlParameter[] parameters = {
new SqlParameter("Office_ID", SqlDbType.Int)
};
parameters[0].Value = Office_ID;
scParameter.parameters = parameters;
dt = db.GetDataTable(scParameter);
}
catch (Exception ex)
{
db.CatchException(ex);
return null;
}
finally
{
}
return dt;
}
/// <summary>
/// Method Name :OfficeInfo_GetOfficeInfoByOfficeName
/// Function :取出在OfficeInfo表中所有信息通过参数Office_Name
/// Creator :Charry Chen
/// Createcd Time :[5-14-2007]
/// </summary>
/// <param name="Office_Name"></param>
/// <returns>DataTable</returns>
public DataTable OfficeInfo_GetOfficeInfoByOfficeName(string Office_Name)
{
SConnParameterSql scParameter = new SConnParameterSql();
DataTable dt = new DataTable();
try
{
scParameter.ds = new DataSet();
scParameter.commandtext = "OfficeInfo_GetOfficeInfoByOfficeName";
scParameter.commandtype = CommandType.StoredProcedure;
SqlParameter[] parameters = {
new SqlParameter("Office_Name", SqlDbType.NVarChar)
};
parameters[0].Value = Office_Name;
scParameter.parameters = parameters;
dt = db.GetDataTable(scParameter);
}
catch (Exception ex)
{
db.CatchException(ex);
return null;
}
finally
{
}
return dt;
}
/// <summary>
/// Method Name :OfficeInfo_GetOfficeInfoByPhone
/// Function :取出在OfficeInfo表中所有信息通过参数Phone
/// Creator :Charry Chen
/// Createcd Time :[5-14-2007]
/// </summary>
/// <param name="Phone"></param>
/// <returns>DataTable</returns>
public DataTable OfficeInfo_GetOfficeInfoByPhone(string Phone)
{
SConnParameterSql scParameter = new SConnParameterSql();
DataTable dt = new DataTable();
try
{
scParameter.ds = new DataSet();
scParameter.commandtext = "OfficeInfo_GetOfficeInfoByPhone";
scParameter.commandtype = CommandType.StoredProcedure;
SqlParameter[] parameters = {
new SqlParameter("Phone", SqlDbType.NVarChar)
};
parameters[0].Value = Phone;
scParameter.parameters = parameters;
dt = db.GetDataTable(scParameter);
}
catch (Exception ex)
{
db.CatchException(ex);
return null;
}
finally
{
}
return dt;
}
/// <summary>
/// Method Name :OfficeInfo_GetOfficeInfoByPosition
/// Function :取出在OfficeInfo表中所有信息通过参数Position
/// Creator :Charry Chen
/// Createcd Time :[5-14-2007]
/// </summary>
/// <param name="Position"></param>
/// <returns>DataTable</returns>
public DataTable OfficeInfo_GetOfficeInfoByPosition(string Position)
{
SConnParameterSql scParameter = new SConnParameterSql();
DataTable dt = new DataTable();
try
{
scParameter.ds = new DataSet();
scParameter.commandtext = "OfficeInfo_GetOfficeInfoByPosition";
scParameter.commandtype = CommandType.StoredProcedure;
SqlParameter[] parameters = {
new SqlParameter("Position", SqlDbType.NVarChar)
};
parameters[0].Value = Position;
scParameter.parameters = parameters;
dt = db.GetDataTable(scParameter);
}
catch (Exception ex)
{
db.CatchException(ex);
return null;
}
finally
{
}
return dt;
}
/// <summary>
/// Method Name :OfficeInfo_GetOfficeInfoByDirectorName
/// Function :取出在OfficeInfo表中所有信息通过参数Director_Name
/// Creator :Charry Chen
/// Createcd Time :[5-14-2007]
/// </summary>
/// <param name="Director_Name"></param>
/// <returns>DataTable</returns>
public DataTable OfficeInfo_GetOfficeInfoByDirectorName(string Director_Name)
{
SConnParameterSql scParameter = new SConnParameterSql();
DataTable dt = new DataTable();
try
{
scParameter.ds = new DataSet();
scParameter.commandtext = "OfficeInfo_GetOfficeInfoByDirectorName";
scParameter.commandtype = CommandType.StoredProcedure;
SqlParameter[] parameters = {
new SqlParameter("Director_Name", SqlDbType.NVarChar)
};
parameters[0].Value = Director_Name;
scParameter.parameters = parameters;
dt = db.GetDataTable(scParameter);
}
catch (Exception ex)
{
db.CatchException(ex);
return null;
}
finally
{
}
return dt;
}
/// <summary>
/// Method Name :OfficeInfo_GetAllOfficeInfo
/// Function :取出在OfficeInfo表中所有信息
/// Creator :Charry Chen
/// Createcd Time :[5-14-2007]
/// </summary>
/// <returns>DataTable</returns>
public DataTable OfficeInfo_GetAllOfficeInfo()
{
SConnParameterSql scParameter = new SConnParameterSql();
DataTable dt = new DataTable();
try
{
scParameter.ds = new DataSet();
scParameter.commandtext = "OfficeInfo_GetAllOfficeInfo";
scParameter.commandtype = CommandType.StoredProcedure;
dt = db.GetDataTable(scParameter);
}
catch (Exception ex)
{
db.CatchException(ex);
return null;
}
finally
{
}
return dt;
}
/// <summary>
/// Method Name :OfficeInfo_UpdateOfficeInfo
/// Function :更新表的OfficeInfo信息通过Office_ID, Office_Name, Phone, Position, Director_Name
/// Creator :Charry Chen
/// Createcd Time :[5-14-2007
/// </summary>
/// <param name="Office_ID"></param>
/// <param name="Office_Name"></param>
/// <param name="Phone"></param>
/// <param name="Position"></param>
/// <param name="Director_Name"></param>
public void OfficeInfo_UpdateOfficeInfo(int Office_ID, string Office_Name, string Phone, string Position, string Director_Name)
{
SConnParameterSql scParameter = new SConnParameterSql();
try
{
scParameter.commandtext = "OfficeInfo_UpdateOfficeInfo";
scParameter.commandtype = CommandType.StoredProcedure;
SqlParameter[] parameters = {
new SqlParameter ("Office_ID",SqlDbType.Int),
new SqlParameter("Office_Name", SqlDbType.NVarChar),
new SqlParameter("Phone", SqlDbType.NVarChar),
new SqlParameter("Position", SqlDbType.NVarChar),
new SqlParameter("Director_Name", SqlDbType.NVarChar)
};
parameters[0].Value = Office_ID;
parameters[1].Value = Office_Name;
parameters[2].Value = Phone;
parameters[3].Value = Position;
parameters[4].Value = Director_Name;
scParameter.parameters = parameters;
db.EditTableNoReturnValue(scParameter);
}
catch (Exception ex)
{
db.CatchException(ex);
}
finally
{
}
}
/// <summary>
/// Method Name :OfficeInfo_AddOfficeInfo
/// Function :添加表OfficeInfo信息通过Office_Name, Phone, Position, Director_Name
/// Creator :Charry Chen
/// Createcd Time :[5-14-2007]
/// </summary>
/// <param name="Office_Name"></param>
/// <param name="Phone"></param>
/// <param name="Position"></param>
/// <param name="Director_Name"></param>
public DataTable OfficeInfo_AddOfficeInfo(string Office_Name, string Phone, string Position, string Director_Name)
{
SConnParameterSql scParameter = new SConnParameterSql();
DataTable dt = new DataTable();
try
{
scParameter.ds = new DataSet();
scParameter.commandtext = "OfficeInfo_AddOfficeInfo";
scParameter.commandtype = CommandType.StoredProcedure;
SqlParameter[] parameters = {
new SqlParameter("Office_Name", SqlDbType.NVarChar),
new SqlParameter("Phone", SqlDbType.NVarChar),
new SqlParameter("Position", SqlDbType.NVarChar),
new SqlParameter("Director_Name", SqlDbType.NVarChar)
};
parameters[0].Value = Office_Name;
parameters[1].Value = Phone;
parameters[2].Value = Position;
parameters[3].Value = Director_Name;
scParameter.parameters = parameters;
dt = db.GetDataTable(scParameter);
}
catch (Exception ex)
{
db.CatchException(ex);
}
finally
{
}
return dt;
}
/// <summary>
/// Method Name :OfficeInfo_DelOfficeInfo
/// Function :删除表的OfficeInfo信息通过Office_ID
/// Creator :Charry Chen
/// Createcd Time :[5-14-2007]
/// </summary>
/// <param name="Office_ID"></param>
public void OfficeInfo_DelOfficeInfo(int Office_ID)
{
SConnParameterSql scParameter = new SConnParameterSql();
DataTable dt = new DataTable();
try
{
scParameter.ds = new DataSet();
scParameter.commandtext = "OfficeInfo_DelOfficeInfo";
scParameter.commandtype = CommandType.StoredProcedure;
SqlParameter[] parameters = {
new SqlParameter("Office_ID", SqlDbType.Int)
};
parameters[0].Value = Office_ID;
scParameter.parameters = parameters;
db.EditTableNoReturnValue(scParameter);
}
catch (Exception ex)
{
db.CatchException(ex);
}
finally
{
}
}
=============================================================================================================================================================================================================
Dataset 的数据链接
public DataSet GetSickBedByBedIDDB(int SickBed_ID)
{
try
{
scParameter.ds = ds;
scParameter.commandtext = "HospitalDemo_SickBed_GetBedByID";
scParameter.commandtype = CommandType.StoredProcedure;
scParameter.MappingTableName = "GetSickBedByBedIDTable";
SqlParameter[] Parameters =
{
new SqlParameter("@SickBed_ID", SqlDbType.Int)
};
Parameters[0].Value = SickBed_ID;
scParameter.parameters = Parameters;
ds = CommonSQL.GetStrongTypeDataSet(scParameter);
return ds;
}
catch (Exception e)
{
CommonSQL.CatchException(e);
return null;
}
}
-======================================================================================================================================================================================================================
Portal 中的链接
public DataTable GetStudentAllGrades()
{
try
{
scParameter.commandtext = "Student_GetAllGrades";
scParameter.commandtype = CommandType.StoredProcedure;
// DataSet that will hold the returned results
dt = db.GetDataTable(scParameter);
}
catch (Exception ex)
{
try
{
AppService.ProcessException(ex);
}
catch (Exception ex2)
{
LogManager lm = new LogManager();
lm.FillLogEntry(1000, 5, ex.Message, LogManager.Category.DataAccessEvents, TraceEventType.Error);
lm.DoLogging();
throw ex2;
}
}
finally
{
}
//return expected value
return dt;
}
public DataTable GetSingleStudentGrades(int StudentID)
{
try
{
scParameter.commandtext = "Student_GetSingleGrades";
scParameter.commandtype = CommandType.StoredProcedure;
paramsList.Clear();
expectedValue = StudentID;
paramsList.Add(new DBParam("StudentID", DbType.Int32, expectedValue));
scParameter.parameters = paramsList;
// DataSet that will hold the returned results
dt = db.GetDataTable(scParameter);
}
catch (Exception ex)
{
try
{
AppService.ProcessException(ex);
}
catch (Exception ex2)
{
LogManager lm = new LogManager();
lm.FillLogEntry(1000, 5, ex.Message, LogManager.Category.DataAccessEvents, TraceEventType.Error);
lm.DoLogging();
throw ex2;
}
}
finally
{
}
//return expected value
return dt;
}
---------------------------------------------------其他方法
public static DataSet ExecuteDataSet(CommandType cmdType, string cmdText, params SqlParameter[] commandParameters)
{
SqlConnection conn = new SqlConnection(connectionString);
DataSet rs = new DataSet();
SqlCommand cmd = new SqlCommand();
// we use a try/catch here because if the method throws an exception we want to
// close the connection throw code, because no datareader will exist, hence the
// commandBehaviour.CloseConnection will not work
try
{
PrepareCommand(cmd, conn, null, cmdType, cmdText, commandParameters);
SqlDataAdapter sqlda = new SqlDataAdapter(cmd);
sqlda.Fill(rs);
cmd.Parameters.Clear();
return rs;
}
catch (Exception es)
{
conn.Close();
throw new Exception("出错位置：usedb.SelectSqlReader()；错误信息：" + es.Message);
}
}
private static void PrepareCommand(SqlCommand cmd, SqlConnection conn, SqlTransaction trans, CommandType cmdType, string cmdText, SqlParameter[] cmdParms)
{
if (conn.State != ConnectionState.Open)
conn.Open();
cmd.Connection = conn;
cmd.CommandText = cmdText;
if (trans != null)
cmd.Transaction = trans;
cmd.CommandType = cmdType;
if (cmdParms != null)
{
foreach (SqlParameter parm in cmdParms)
cmd.Parameters.Add(parm);
}
}
扫一扫
5481
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
