コード例 #1
0
 private SqlCommand GetOthersChangesSelect()
 {
     if (OthersSelectCommand == null)
     {
         String qry = "Select * from Changes";
         GlobalFunctions.AppendOperatorClause(ref qry, "Change_Time", ">=");
         GlobalFunctions.AppendOperatorClause(ref qry, "Change_Author", "<>");
         GlobalFunctions.AppendEqualityQueryClause(ref qry, "channel_id");
         qry += " order by change_time ASC";
         SqlConnection dConn = GlobalFunctions.GetDBConnection();
         OthersSelectCommand = new SqlCommand(qry, dConn);
     }
     OthersSelectCommand.Parameters.Clear();
     return(OthersSelectCommand);
 }