public DataSet GetStorageListDataSource() { StorageList storage = new StorageList(); System.Text.StringBuilder sql = new System.Text.StringBuilder(); sql.Append(@"SELECT StorageNo,StorageDescription,GenerationTime FROM StorageList where 1=1 "); if (this.txt_StoNo.Text != string.Empty) { sql.Append(string.Format(" and StorageNo='{0}'", storage.DatabaseAccess.ConvertToDBString(this.txt_StoNo.Text))); } sql.Append(string.Format(" and convert(char(10),GenerationTime,102)>= '{0}' and convert(char(10),GenerationTime,102)<='{1}' ", this.StartDate.ToString("yyyy.MM.dd"), this.EndDate.ToString("yyyy.MM.dd"))); sql.Append(" order by GenerationTime desc"); return storage.GetDateSet(sql.ToString()); }
public DataSet GetStorageListDataSource() { StorageList storage = new StorageList(); System.Text.StringBuilder sql = new System.Text.StringBuilder(); sql.Append(@"SELECT StorageNo,StorageDescription,GenerationTime FROM StorageList where 1=1 "); if (this.txt_StoNo.Text != string.Empty) { sql.Append(string.Format(" and StorageNo='{0}'", storage.DatabaseAccess.ConvertToDBString(this.txt_StoNo.Text))); } sql.Append(string.Format(" and convert(char(10),GenerationTime,102)>= '{0}' and convert(char(10),GenerationTime,102)<='{1}' ", this.StartDate.ToString("yyyy.MM.dd"), this.EndDate.ToString("yyyy.MM.dd"))); sql.Append(" order by GenerationTime desc"); return(storage.GetDateSet(sql.ToString())); }