コード例 #1
0
 public virtual VCFDataSet.UserDataTable Login(string UserName, string Password) {
     this.Adapter.SelectCommand = this.CommandCollection[6];
     if ((UserName == null)) {
         throw new System.ArgumentNullException("UserName");
     }
     else {
         this.Adapter.SelectCommand.Parameters[0].Value = ((string)(UserName));
     }
     if ((Password == null)) {
         throw new System.ArgumentNullException("Password");
     }
     else {
         this.Adapter.SelectCommand.Parameters[1].Value = ((string)(Password));
     }
     VCFDataSet.UserDataTable dataTable = new VCFDataSet.UserDataTable();
     this.Adapter.Fill(dataTable);
     return dataTable;
 }
コード例 #2
0
 public virtual VCFDataSet.UserDataTable GetUserByUserName(string UserName) {
     this.Adapter.SelectCommand = this.CommandCollection[5];
     if ((UserName == null)) {
         throw new System.ArgumentNullException("UserName");
     }
     else {
         this.Adapter.SelectCommand.Parameters[0].Value = ((string)(UserName));
     }
     VCFDataSet.UserDataTable dataTable = new VCFDataSet.UserDataTable();
     this.Adapter.Fill(dataTable);
     return dataTable;
 }
コード例 #3
0
 public virtual VCFDataSet.UserDataTable GetTopNSystemUserWhereRealNameStartWith(string RealName, System.Nullable<int> Count) {
     this.Adapter.SelectCommand = this.CommandCollection[3];
     if ((RealName == null)) {
         this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value;
     }
     else {
         this.Adapter.SelectCommand.Parameters[1].Value = ((string)(RealName));
     }
     if ((Count.HasValue == true)) {
         this.Adapter.SelectCommand.Parameters[2].Value = ((int)(Count.Value));
     }
     else {
         this.Adapter.SelectCommand.Parameters[2].Value = System.DBNull.Value;
     }
     VCFDataSet.UserDataTable dataTable = new VCFDataSet.UserDataTable();
     this.Adapter.Fill(dataTable);
     return dataTable;
 }
コード例 #4
0
 public virtual VCFDataSet.UserDataTable GetUserByUserID(int UserID) {
     this.Adapter.SelectCommand = this.CommandCollection[4];
     this.Adapter.SelectCommand.Parameters[0].Value = ((int)(UserID));
     VCFDataSet.UserDataTable dataTable = new VCFDataSet.UserDataTable();
     this.Adapter.Fill(dataTable);
     return dataTable;
 }
コード例 #5
0
 public virtual VCFDataSet.UserDataTable GetData() {
     this.Adapter.SelectCommand = this.CommandCollection[0];
     VCFDataSet.UserDataTable dataTable = new VCFDataSet.UserDataTable();
     this.Adapter.Fill(dataTable);
     return dataTable;
 }