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; }
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; }
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; }
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; }
public virtual VCFDataSet.UserDataTable GetData() { this.Adapter.SelectCommand = this.CommandCollection[0]; VCFDataSet.UserDataTable dataTable = new VCFDataSet.UserDataTable(); this.Adapter.Fill(dataTable); return dataTable; }