public appDB.BatchDataTable Load() { this.sqlDa.SelectCommand = sqlSelectAll; appDB.BatchDataTable dt = new appDB.BatchDataTable(); Fill(dt); return(dt); }
internal BatchBE(atriumManager pBEMng) : base(pBEMng, pBEMng.DB.Batch) { myA = pBEMng; myBatchDT = (appDB.BatchDataTable)myDT; if (!myA.AppMan.UseService && myODAL == null) { myODAL = myA.DALMngr.GetBatch(); } }
public appDB.BatchDataTable LoadPending() { this.sqlDa.SelectCommand = sqlSelect; this.sqlSelect.Parameters.Clear(); this.sqlSelect.CommandText = "[BatchSelectPending]"; this.sqlSelect.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, false, ((System.Byte)(10)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null)); appDB.BatchDataTable dt = new appDB.BatchDataTable(); Fill(dt); return(dt); }
public appDB.BatchDataTable LoadByOfficeCode(string OfficeCode) { this.sqlDa.SelectCommand = sqlSelect; this.sqlSelect.Parameters.Clear(); this.sqlSelect.CommandText = "[BatchSelectByOfficeCode]"; this.sqlSelect.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, false, ((System.Byte)(10)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null)); this.sqlSelect.Parameters.Add(new System.Data.SqlClient.SqlParameter("@OfficeCode", System.Data.SqlDbType.NVarChar, 6, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null)); this.sqlSelect.Parameters["@OfficeCode"].Value = OfficeCode; appDB.BatchDataTable dt = new appDB.BatchDataTable(); Fill(dt); return(dt); }
private void BindBatchData(appDB.BatchDataTable dt) { batchBindingSource.DataSource = dt.DataSet; batchBindingSource.DataMember = dt.TableName; }