// toggle all checkbox in matrix
private void checkAllMat(SAPbouiCOM.Matrix theMatrix)
{
try
{
_oForm.Freeze(true);
if (!toggleGridCheckBox)
{
for (int i = 0; i < _dt_VendorMatrix.Rows.Count; i++)
{
_dt_VendorMatrix.SetValue("Check", i, "Y");
}
theMatrix.LoadFromDataSource();
toggleGridCheckBox = true;
}
else
{
for (int i = 0; i < _dt_VendorMatrix.Rows.Count; i++)
{
_dt_VendorMatrix.SetValue("Check", i, "N");
}
theMatrix.LoadFromDataSource();
toggleGridCheckBox = false;
}
}
catch (Exception ex) { eCommon.SBO_Application.MessageBox(ex.Message); }
_oForm.Freeze(false);
}
private void fillLevels()
{
Hashtable hp = new Hashtable();
// string strDelete = " CALL GET_AM_F(); ";
// Program.objHrmsUI.ExecQuery(strDelete, "Creating Level");
// System.Data.DataTable dtRoot = Program.objHrmsUI.getDataTableQryCode("AM_FillAM", hp, "Fill Root");
System.Data.DataTable dtRoot = Program.objHrmsUI.getDataTable("CALL GET_AM_F();", "Fill Root");
dtRoot = Program.objHrmsUI.getDataTable("SELECT * FROM \"@B1_AM_F\"", "Fill Root");
dtCA.Rows.Clear();
if (dtRoot.Rows.Count > 0)
{
dtCA.Rows.Add(dtRoot.Rows.Count);
int i = 0;
foreach (System.Data.DataRow dr in dtRoot.Rows)
{
dtCA.SetValue("Code", i, dr["Code"].ToString());
dtCA.SetValue("Name", i, dr["Name"].ToString());
i++;
}
}
else
{
addRoot();
}
oApplication.StatusBar.SetText("Level updated successfully", SAPbouiCOM.BoMessageTime.bmt_Short, SAPbouiCOM.BoStatusBarMessageType.smt_Success);
}
private void InitiallizeForm()
{
isForLoading = true;
oForm.Freeze(true);
tab1 = (SAPbouiCOM.Folder)oForm.Items.Item("21").Specific;
tab3 = (SAPbouiCOM.Folder)oForm.Items.Item("19").Specific;
tab4 = (SAPbouiCOM.Folder)oForm.Items.Item("35").Specific;
dtHead = oForm.DataSources.DataTables.Item("dtHead");
Animals = oForm.DataSources.DataTables.Item("Animals");
DTRpt = oForm.DataSources.DataTables.Item("DTRpt");
dtPro = oForm.DataSources.DataTables.Item("dtPro");
dtReqT = oForm.DataSources.DataTables.Item("dtReqT");
dtTypeS = oForm.DataSources.DataTables.Item("dtTypeS");
ocflCard = (SAPbouiCOM.ChooseFromList)oForm.ChooseFromLists.Item("cflCard");
cflcardcode(ocflCard, "cflCard");
mtAnimals = (SAPbouiCOM.Matrix)oForm.Items.Item("mtAnimals").Specific;
mtReqT = (SAPbouiCOM.Matrix)oForm.Items.Item("mtReqT").Specific;
mtRpt = (SAPbouiCOM.Matrix)oForm.Items.Item("mtRpt").Specific;
mtProd = (SAPbouiCOM.Matrix)oForm.Items.Item("mtProd").Specific;
mtTypePRO = (SAPbouiCOM.Matrix)oForm.Items.Item("mtTypePRO").Specific;
cbAT = (SAPbouiCOM.ComboBox)oForm.Items.Item("cbAT").Specific;
cbAC = (SAPbouiCOM.ComboBox)oForm.Items.Item("cbAC").Specific;
txQtyT = (SAPbouiCOM.EditText)oForm.Items.Item("29").Specific;
txSupplier = (SAPbouiCOM.EditText)oForm.Items.Item("47").Specific;
chSO = (SAPbouiCOM.CheckBox)oForm.Items.Item("chSO").Specific;
chPRO = (SAPbouiCOM.CheckBox)oForm.Items.Item("crRPRO").Specific;
dtHead.Rows.Add(1);
dtHead.SetValue("DocDate", 0, DateTime.Now);
dtHead.SetValue("PoDate", 0, DateTime.Now);
dtHead.SetValue("stDate", 0, DateTime.Now.AddDays(1));
dtHead.SetValue("eDate", 0, DateTime.Now.AddDays(4));
oForm.Freeze(false);
fillCB();
txQtyT.Item.Enabled = false;
oForm.PaneLevel = 4;
tab4.Select();
isForLoading = false;
fillPO();
mtProd.Item.Visible = false;
fillAThash();
RefreshForm();
}
/// <summary>
/// Forma el formulario de documentos, con los campos necesarios.
/// </summary>
private void CargarFormulario(String FormUID)
{
SAPbouiCOM.Form oForm = Conexion_SBO.m_SBO_Appl.Forms.Item(FormUID);
SAPbouiCOM.Matrix oMatrix = oForm.Items.Item("Item_0").Specific;
oMatrix.Layout = SAPbouiCOM.BoMatrixLayoutType.mlt_Normal;
oMatrix.SelectionMode = SAPbouiCOM.BoMatrixSelect.ms_Single;
// Datasource para blindear matrix
oForm.DataSources.DataTables.Add("FILAS");
SAPbouiCOM.DataTable dt = oForm.DataSources.DataTables.Item("FILAS");
dt.Columns.Add("co_LineNum", SAPbouiCOM.BoFieldsType.ft_AlphaNumeric);
dt.Columns.Add("co_Serv", SAPbouiCOM.BoFieldsType.ft_AlphaNumeric);
dt.Columns.Add("co_Tot", SAPbouiCOM.BoFieldsType.ft_AlphaNumeric);
dt.Columns.Add("co_Imp", SAPbouiCOM.BoFieldsType.ft_AlphaNumeric);
dt.Columns.Add("co_Cta", SAPbouiCOM.BoFieldsType.ft_AlphaNumeric);
dt.Columns.Add("co_Esp", SAPbouiCOM.BoFieldsType.ft_AlphaNumeric);
dt.Columns.Add("co_Var", SAPbouiCOM.BoFieldsType.ft_AlphaNumeric);
dt.Columns.Add("co_Categ", SAPbouiCOM.BoFieldsType.ft_AlphaNumeric);
dt.Columns.Add("co_Catpa", SAPbouiCOM.BoFieldsType.ft_AlphaNumeric);
dt.Columns.Add("co_Rolp", SAPbouiCOM.BoFieldsType.ft_AlphaNumeric);
Int32 Index = 0;
foreach (Filas fil in ListaFilas.ListFilas)
{
dt.Rows.Add();
dt.SetValue("co_LineNum", Index, fil.LineNum.ToString());
dt.SetValue("co_Serv", Index, fil.Servicio);
dt.SetValue("co_Tot", Index, String.Format(System.Globalization.CultureInfo.GetCultureInfo("es-CL"), "{0:C0}", fil.Total));
dt.SetValue("co_Imp", Index, fil.Impuesto);
dt.SetValue("co_Cta", Index, String.Empty);
dt.SetValue("co_Esp", Index, String.Empty);
dt.SetValue("co_Var", Index, String.Empty);
dt.SetValue("co_Categ", Index, String.Empty);
dt.SetValue("co_Catpa", Index, String.Empty);
dt.SetValue("co_Rolp", Index, String.Empty);
Index++;
}
oMatrix.Columns.Item("col_lin").DataBind.Bind("FILAS", "co_LineNum");
oMatrix.Columns.Item("col_Serv").DataBind.Bind("FILAS", "co_Serv");
oMatrix.Columns.Item("col_Tot").DataBind.Bind("FILAS", "co_Tot");
oMatrix.Columns.Item("col_Imp").DataBind.Bind("FILAS", "co_Imp");
oMatrix.Columns.Item("col_Cta").DataBind.Bind("FILAS", "co_Cta");
oMatrix.Columns.Item("col_Esp").DataBind.Bind("FILAS", "co_Esp");
oMatrix.Columns.Item("col_Var").DataBind.Bind("FILAS", "co_Var");
oMatrix.Columns.Item("col_Cat").DataBind.Bind("FILAS", "co_Categ");
oMatrix.Columns.Item("col_Catpa").DataBind.Bind("FILAS", "co_Catpa");
oMatrix.Columns.Item("col_Rolp").DataBind.Bind("FILAS", "co_Rolp");
oMatrix.LoadFromDataSource();
}
private void gvRecDocuments_ClickAfter(object sboObject, SAPbouiCOM.SBOItemEventArg pVal)
{
if (currentRecItemCode != string.Empty)
{
PopulateRecBatchTables();
}
if (pVal.Row >= 0)
{
string itemCode = dtRecDocuments.GetValue("ItemCode", pVal.Row).ToString();
string whsCode = dtRecDocuments.GetValue("WhsCode", pVal.Row).ToString();
double avgPrice = Convert.ToDouble(dtRecDocuments.GetValue("AvgPrice", pVal.Row));
double addAmount = Convert.ToDouble(dtRecDocuments.GetValue("AddAmount", pVal.Row));
double quantity = Convert.ToDouble(dtRecDocuments.GetValue("Quantity", pVal.Row));
currentRecDocumentIndex = pVal.Row;
currentRecItemCode = itemCode;
currentRecWhsCode = whsCode;
//CHECK IF THE SELECTED BATCHES TABLE HAS BEEN POPULATED BEFORE
var selectedBatches = receiptBatchDataSources.Where(x => x.ItemCode == currentRecItemCode && x.WhsCode == currentRecWhsCode && x.Index == currentRecDocumentIndex);
if (selectedBatches.Count() > 0)
{
dtRecBatches.Rows.Clear();
this.UIAPIRawForm.Freeze(true);
for (int x = 0; x < selectedBatches.First().SelectedBatches.Rows.Count; x++)
{
dtRecBatches.Rows.Add(1);
dtRecBatches.SetValue("Batch", x, selectedBatches.First().SelectedBatches.Rows[x]["Batch"]);
dtRecBatches.SetValue("Selected Qty", x, selectedBatches.First().SelectedBatches.Rows[x]["Selected Qty"]);
}
this.UIAPIRawForm.Freeze(false);
}
else
{
dtRecBatches.Rows.Clear();
//System.Data.DataTable dt = CopyBatchesDataTable(dtRecBatches);
var bds = new SelectedBatchDataSources()
{
AddAmount = addAmount,
AvgPrice = Convert.ToDouble(avgPrice),
Quantity = Convert.ToDouble(quantity),
Index = currentRecDocumentIndex,
ItemCode = currentRecItemCode,
WhsCode = currentRecWhsCode,
SelectedBatches = CopySelectedBatchesDataTable(dtRecBatches)
};
receiptBatchDataSources.Add(bds);
}
}
gvRecBatches.AddLine();
}
private SAPbouiCOM.DataTable Convert_SAP_DataTable(System.Data.DataTable pDataTable)
{
SAPbouiCOM.DataTable oDT = null;
SAPbouiCOM.Form oForm = SAPbouiCOM.Framework.Application.SBO_Application.Forms.ActiveForm;
if (CheckExistUniqueID(oForm, "DT_SubList"))
{
oDT = oForm.DataSources.DataTables.Item("DT_SubList");
oDT.Clear();
}
else
{
oDT = oForm.DataSources.DataTables.Add("DT_SubList");
}
//Add column to DataTable
foreach (System.Data.DataColumn c in pDataTable.Columns)
{
try
{
if (c.DataType.ToString() == "System.DateTime")
{
oDT.Columns.Add(c.ColumnName, SAPbouiCOM.BoFieldsType.ft_Date);
}
else
{
oDT.Columns.Add(c.ColumnName, SAPbouiCOM.BoFieldsType.ft_Text);
}
}
catch
{ }
}
//Add row to DataTable
foreach (System.Data.DataRow r in pDataTable.Rows)
{
oDT.Rows.Add();
foreach (System.Data.DataColumn c in pDataTable.Columns)
{
if (c.DataType.ToString() == "System.DateTime")
{
oDT.SetValue(c.ColumnName, oDT.Rows.Count - 1, r[c.ColumnName]);
}
else
{
oDT.SetValue(c.ColumnName, oDT.Rows.Count - 1, r[c.ColumnName].ToString());
}
}
}
return(oDT);
}
public static void Unir_DataTables(SAPbouiCOM.DataTable DT1, SAPbouiCOM.DataTable DT2)
{
try
{
for (int iRow = 0; iRow <= DT2.Rows.Count - 1; iRow++)
{
DT1.Rows.Add();
int nRow = DT1.Rows.Count - 1;
for (int iCol = 0; iCol <= DT2.Columns.Count - 1; iCol++)
{
try
{
DT1.SetValue(iCol, nRow, DT2.GetValue(iCol, iRow));
}
catch (Exception)
{
}
}
}
}
catch (Exception)
{
}
}
public SAPbouiCOM.DataTable GenerarEncabezado(SAPbouiCOM.DataTable DT_SQL, SAPbouiCOM.DataTable DT_HEAD)
{
try
{
string FechaPago = DT_SQL.GetValue(0, 0).ToString();
string CantidadPagos = DT_SQL.GetValue(0, 1).ToString();
string MontoPagos = DT_SQL.GetValue(0, 2).ToString();//.Replace(".","");
string[] SeparaTotal = MontoPagos.Split('.');
string MontoEntero = SeparaTotal[0];
string MontoDecimal = SeparaTotal.Count() == 1 ? "00" : MontoPagos.Split('.')[1];
string sql = @"EXEC [dbo].[Min_Bancos_Generar_Encabezado_Archivo_PagoTXT]
@U_FechaPago = N'" + FechaPago + @"',
@U_CantidadPago = N'" + CantidadPagos + @"',
@U_MontoTotal = N'" + MontoEntero + MontoDecimal + "'";
DT_HEAD.ExecuteQuery(sql);
//Hay que establecer la columana de tipo TEXT para que puedan agregarse posteriormente los rgistros de detalle
string RC = DT_HEAD.GetValue(0, 0).ToString().Trim();
DT_HEAD.Clear();
DT_HEAD.Columns.Add("Info", SAPbouiCOM.BoFieldsType.ft_Text);
DT_HEAD.Rows.Add(1);
DT_HEAD.SetValue("Info", 0, RC);
//DT_HEAD.SetValue("Info", 0, "RC00354803021120160000100000000016184000578509689910000968991000 [email protected]");
}
catch (Exception) {}
return(DT_HEAD);
}
/// <summary>
/// Loads the sellers list into the matrix.
/// </summary>
/// <param name="pFolio">The auction's folio.</param>
public void LoadSellers(string pFolio)
{
mLstSellers = mAuctionDAO.GetAuctionSellers(pFolio, mIntUserSign);
mDtSellers.Rows.Clear();
int i = 0;
foreach (AuctionSellerDTO lObjAuctionSeller in mLstSellers)
{
mDtSellers.Rows.Add();
mDtSellers.SetValue("Name", i, lObjAuctionSeller.CardName);
mDtSellers.SetValue("Amount", i, lObjAuctionSeller.Amount);
i++;
}
mMtxSellers.LoadFromDataSource();
mMtxSellers.AutoResizeColumns();
}
private void addEmptyRow(SAPbouiCOM.Matrix mt, SAPbouiCOM.DataTable dt, string firstCol)
{
if (dt.Rows.Count == 0)
{
dt.Rows.Add(2);
dt.Rows.Remove(1);
dt.SetValue("Id", 0, "1");
mt.AddRow(1, mt.RowCount + 1);
}
else
{
if (Convert.ToString(dt.GetValue(firstCol, dt.Rows.Count - 1)) == "")
{
string strCostCode = Convert.ToString(dt.GetValue(firstCol, dt.Rows.Count - 1));
}
else
{
mt.AddRow(1, mt.RowCount + 1);
mt.SetLineData(mt.RowCount);
mt.FlushToDataSource();
dt.SetValue("Id", dt.Rows.Count - 1, dt.Rows.Count.ToString());
dt.SetValue(firstCol, dt.Rows.Count - 1, "");
BOQD.SetValue("STD", dt.Rows.Count - 1, "");
BOQD.SetValue("ETD", dt.Rows.Count - 1, "");
BOQD.SetValue("WBL", dt.Rows.Count - 1, "");
BOQD.SetValue("WBD", dt.Rows.Count - 1, "");
BOQD.SetValue("Type", dt.Rows.Count - 1, "");
BOQD.SetValue("Code", dt.Rows.Count - 1, "");
BOQD.SetValue("Name", dt.Rows.Count - 1, "");
BOQD.SetValue("Remarks", dt.Rows.Count - 1, "");
BOQD.SetValue("Qty", dt.Rows.Count - 1, "0");
BOQD.SetValue("UP", dt.Rows.Count - 1, "0");
BOQD.SetValue("BGTC", dt.Rows.Count - 1, "0");
mt.SetLineData(mt.RowCount);
}
}
// mt.LoadFromDataSource();
}
private void Seleccion(Boolean bvalor)
{
try
{
oForm.Freeze(true);
SAPbouiCOM.Grid oGrid = (SAPbouiCOM.Grid)oForm.Items.Item("Grid").Specific;
SAPbouiCOM.DataTable DT_GRID = oForm.DataSources.DataTables.Item("dt");
for (Int32 i = 0; i <= DT_GRID.Rows.Count - 1; i++)
{
if (oGrid.CommonSetting.GetCellEditable(i + 1, 1))
{
if (bvalor)
{
DT_GRID.SetValue("Selec.", i, "Y");
}
else
{
DT_GRID.SetValue("Selec.", i, "N");
}
}
}
CheckBox1.Item.Visible = true; //debe estar "visible" para camibar el checked
if (((SAPbouiCOM.CheckBox)oForm.Items.Item("chk_sel").Specific).Checked)
{
((SAPbouiCOM.CheckBox)oForm.Items.Item("chk_sel").Specific).Checked = false;
}
else
{
((SAPbouiCOM.CheckBox)oForm.Items.Item("chk_sel").Specific).Checked = true;
}
CheckBox1.Item.Visible = false;
}
catch (Exception e)
{
Application.SBO_Application.StatusBar.SetText(e.Message + " ** Trace: " + e.StackTrace, SAPbouiCOM.BoMessageTime.bmt_Short, SAPbouiCOM.BoStatusBarMessageType.smt_Error);
log.AddLog(e.Message + " ** Trace: ");
}
oForm.Freeze(false);
}
public override void etAfterClick(ref SAPbouiCOM.ItemEvent pVal, ref bool BubbleEvent)
{
base.etAfterClick(ref pVal, ref BubbleEvent);
if (pVal.ItemUID.Contains("mt"))
{
try
{
if (chSO.Checked)
{
oForm.Settings.MatrixUID = pVal.ItemUID;
oForm.Settings.Enabled = true;
}
}
catch { }
}
if (pVal.ItemUID == "1")
{
}
if (pVal.ItemUID == "43")
{
RefreshForm();
}
if (pVal.ItemUID == "btCreate")
{
oApplication.MessageBox("Creating Sp ");
createProductionOrder();
fillAnimals();
getReport();
}
if (pVal.ItemUID == "34")
{
int poResult = createTypePurchaseOrder();
if (poResult != 0)
{
int createProduction = oApplication.MessageBox("PO not created for a supplier. Do you still want to add production order?(Y/N)", 2, "Yes", "No");
if (createProduction == 2)
{
return;
}
}
createTypeProductionOrder();
// createSPProductionOrder();
// createProductionOrder();
dtHead.SetValue("TodayQty", 0, "0");
fillAnimals();
getReport();
fillPO();
oApplication.StatusBar.SetText("Operation Completed Successfully!", SAPbouiCOM.BoMessageTime.bmt_Short, SAPbouiCOM.BoStatusBarMessageType.smt_Success);
}
if (pVal.ItemUID == "btCalcT")
{
CalcToday();
}
}
private void fillAddons()
{
dtHead.Rows.Clear();
string strSql = "Select * from [@DEM_MODULES]";
System.Data.DataTable dtModules = Program.objHrmsUI.getDataTable(strSql, "Filling Module");
int i = 0;
foreach (System.Data.DataRow dr in dtModules.Rows)
{
dtHead.Rows.Add(1);
dtHead.SetValue("Id", i, (i + 1).ToString());
dtHead.SetValue("AC", i, dr["CODE"].ToString());
dtHead.SetValue("AN", i, dr["NAME"].ToString());
dtHead.SetValue("LK", i, dr["U_LicenseKey"].ToString());
dtHead.SetValue("Active", i, dr["U_Enabled"].ToString());
i++;
}
mtAddon.LoadFromDataSource();
}
private void ApplySearch()
{
int i = 0;
string searchString = txSAtt.Value.ToString(); // Convert.ToString(dtHeads.GetValue("Search", 0));
System.Data.DataRow[] rows = AllRules.Select("RULE like '" + searchString + "*'", "VisOrder Asc");
if (rows.Count() > 0)
{
dtAtrr.Rows.Clear();
foreach (System.Data.DataRow dr in rows)
{
i++;
dtAtrr.Rows.Add(1);
dtAtrr.SetValue("Id", i - 1, i.ToString());
dtAtrr.SetValue("Code", i - 1, dr["RULE"].ToString());
dtAtrr.SetValue("Name", i - 1, dr["Descr"].ToString());
}
mtAttr.LoadFromDataSource();
// ini_controls();
}
}
private void fillLavels()
{
dtCA.Rows.Add(1);
dtCA.SetValue("Code", dtCA.Rows.Count - 1, rootGroup);
dtCA.SetValue("Name", dtCA.Rows.Count - 1, rootGroupName);
fillChilds(rootGroup, ". ");
//System.Data.DataTable dtRoot = Program.objHrmsUI.getDataTable("Select * from [@B1_ITB] where U_Father='" + rootGroup + "'", "Fill Root");
//if (dtRoot.Rows.Count > 0)
//{
// foreach (System.Data.DataRow dr in dtRoot.Rows)
// {
// dtCA.Rows.Add(1);
// dtCA.SetValue("Code", dtCA.Rows.Count - 1, dr["Code"].ToString());
// fillChilds(dr["Code"].ToString(), ". ");
// }
//}
}
private void ApplySearch()
{
int i = 0;
SAPbouiCOM.EditText txSearch = (SAPbouiCOM.EditText)oForm.Items.Item("19").Specific;
string searchString = txSearch.Value.ToString(); // Convert.ToString(dtHeads.GetValue("Search", 0));
System.Data.DataRow[] rows = AllRules.Select("RULE like '" + searchString + "*'");
if (rows.Count() > 0)
{
dtRM.Rows.Clear();
foreach (System.Data.DataRow dr in rows)
{
i++;
dtRM.Rows.Add(1);
dtRM.SetValue("Id", i - 1, i.ToString());
dtRM.SetValue("RN", i - 1, dr["RULE"].ToString());
}
mtR.LoadFromDataSource();
// ini_controls();
}
}
private void getSchedule()
{
string strGet = "Select * from [@B1_CONFIG] where [Code]='0001'";
System.Data.DataTable dtSch = Program.objHrmsUI.getDataTable(strGet, "Loading Data");
foreach (System.Data.DataRow dr in dtSch.Rows)
{
dtHead.SetValue("SchDays", 0, dr["U_SchDays"].ToString());
dtHead.SetValue("LNOrdr", 0, dr["U_NLastOrdr"].ToString());
dtHead.SetValue("MSOrdr", 0, dr["U_NMSI"].ToString());
dtHead.SetValue("DCHistory", 0, dr["U_NDTH"].ToString());
dtHead.SetValue("NRP", 0, dr["U_NRP"].ToString());
dtHead.SetValue("SDD", 0, dr["U_SED"].ToString());
dtHead.SetValue("dbPath", 0, dr["U_DBPATH"].ToString());
dtHead.SetValue("CP", 0, dr["U_AlwPriceCh"].ToString());
}
}
public SAPbouiCOM.DataTable GenerarArchivoDT(SAPbouiCOM.DataTable DT_HEAD, SAPbouiCOM.DataTable DT_ROWS, SAPbouiCOM.DataTable DT_TXT)
{
try
{
for (int j = 0; j <= DT_ROWS.Rows.Count - 1; j++)
{
string Linea = Convert.ToString(DT_ROWS.GetValue(0, j));
DT_HEAD.Rows.Add();
DT_HEAD.SetValue(0, DT_HEAD.Rows.Count - 1, DT_ROWS.GetValue(0, j).ToString());
//Linea = Convert.ToString(DT_HEAD.GetValue(0, DT_HEAD.Rows.Count - 1));
}
DT_TXT.CopyFrom(DT_HEAD);
}
catch (Exception) { }
return(DT_TXT);
}
private void ConvertListIntoDataTable(List <Nomina> pLstNomina)
{
// var timer = Stopwatch.StartNew();
ProgressBarManager lObjProgressBar = null;
SAPbouiCOM.DataTable lObjDataTable = this.UIAPIRawForm.DataSources.DataTables.Item("DT_0");
try
{
Parallel.For(0, pLstNomina.Count, _ =>
{
lObjDataTable.Rows.Add();
});
lObjProgressBar = new ProgressBarManager(Application.SBO_Application, "Cargando", pLstNomina.Count);
Parallel.ForEach(Partitioner.Create(0, pLstNomina.Count), (range, state) =>
{
for (int i = range.Item1; i < range.Item2; i++)
{
Parallel.ForEach(pLstNomina[0].GetType().GetProperties(), property =>
{
if (property.Name != "NNOM" && property.Name != "NRFC")
{
lObjDataTable.SetValue(property.Name, i, pLstNomina[i].GetType().GetProperty(property.Name).GetValue(pLstNomina[i], null));
}
});
}
lObjProgressBar.NextPosition();
});
}
catch (Exception lObjException)
{
throw lObjException;
}
finally
{
if (lObjProgressBar != null)
{
lObjProgressBar.Stop();
lObjProgressBar.Dispose();
}
}
}
private void PopulateDocumentsDatatable(List <BatchRow> batchesList, SAPbouiCOM.DataTable control)
{
foreach (BatchRow br in batchesList)
{
control.Rows.Add(1);
var rowIndex = control.Rows.Count - 1;
control.SetValue("ItemCode", rowIndex, br.ItemCode);
control.SetValue("WhsCode", rowIndex, br.WhsCode);
control.SetValue("Quantity", rowIndex, br.Quantity);
control.SetValue("TotalNeeded", rowIndex, br.Quantity);
control.SetValue("AvgPrice", rowIndex, br.AvgPrice);
control.SetValue("AddAmount", rowIndex, br.AddAmount);
}
}
private void gvRecBatches_ValidateBefore(object sboObject, SAPbouiCOM.SBOItemEventArg pVal, out bool BubbleEvent)
{
var bubbleEventResult = true;
var enteredValue = dtRecBatches.GetValue(pVal.ColUID, pVal.Row).ToString();
var totalQuantityNeeded = Convert.ToDouble(dtRecDocuments.GetValue("TotalNeeded", currentRecDocumentIndex));
double totalSelectedValue = 0;
if (pVal.ColUID.Equals("Selected Qty"))
{
if (enteredValue == string.Empty || !Utilities.IsNumber(enteredValue))
{
Application.SBO_Application.MessageBox("Only numbers allowed");
bubbleEventResult = false;
}
else
{
for (int i = 0; i < dtRecBatches.Rows.Count; i++)
{
var selectedQuantity = (string)dtRecBatches.GetValue("Selected Qty", i) == string.Empty ? 0 : Convert.ToDouble(dtRecBatches.GetValue("Selected Qty", i));
totalSelectedValue += selectedQuantity;
}
if (totalSelectedValue > totalQuantityNeeded)
{
bubbleEventResult = false;
Application.SBO_Application.MessageBox("Quantity is over needed.");
}
else
{
dtRecDocuments.SetValue("TotalSelected", currentRecDocumentIndex, totalSelectedValue);
}
}
}
else
{
bubbleEventResult = true;
}
BubbleEvent = bubbleEventResult;
}
private void fillReport()
{
SAPbouiCOM.StaticText lblLoading = (SAPbouiCOM.StaticText)oForm.Items.Item("lblLoad").Specific;
int GoldenColor = 0xFFC908;// System.Drawing.Color.DarkGoldenrod.ToArgb() - 255;
int redColor = System.Drawing.Color.Red.R | (System.Drawing.Color.Red.G << 8) | (System.Drawing.Color.Red.B << 16);
int greenColor = System.Drawing.Color.Green.R | (System.Drawing.Color.Green.G << 8) | (System.Drawing.Color.Green.B << 16);
lblLoading.Item.Visible = true;
lblLoading.Item.FontSize = 14;
lblLoading.Item.BackColor = GoldenColor;
lblLoading.Item.ForeColor = greenColor;
oForm.Freeze(true);
dtRpt.Rows.Clear();
string strCritaria = " Where (owor.status <> 'L' and owor.status <> 'C') ";
// strCritaria = " Where 'Y' = 'Y' ";
string dtField = "owor.postDate";
if (opDd.Selected)
{
dtField = "owor.DueDate";
}
if (txFrom.Value != "" || txTo.Value == "")
{
if (txFrom.Value != "")
{
strCritaria += " And " + dtField + " >= '" + txFrom.Value + "'";
}
if (txTo.Value != "")
{
strCritaria += " And " + dtField + " <= '" + txTo.Value + "'";
}
}
if (cbPL.Value.ToString().Trim() != "0")
{
strCritaria += " And isnull(U_PMX_PLCD,'') = '" + cbPL.Value.ToString() + "'";
}
if (txProduct.Value != "")
{
strCritaria += " And isnull(owor.itemcode,'') Like '" + txProduct.Value.ToString() + "%'";
}
else
{
}
if (opREL.Selected)
{
strCritaria += " and owor.status = 'R' ";
}
if (opPL.Selected)
{
strCritaria += " and owor.status = 'P' ";
}
string strSelect = "Select owor.DocNum as DocNum, case owor.type when 'S' then 'Standard' when 'P' then 'Special' when 'D' then 'Disassembly' else 'UD' end as Type , case owor.status when 'P' then 'Planned' when 'R' then 'Released' else 'Closed' end as Status,owor.itemcode,oitm.itemname ";
strSelect += " , owor.postdate, owor.duedate , owor.plannedQty , U_PMX_PLCD , U_B1_Label,U_B1_SEQ, U_B1_FrTxt,isnull(U_B1_DispPos,owor.docentry) as Pos, owor.DocEntry ";
strSelect += " from owor inner join oitm on oitm.itemcode = owor.itemcode ";
string strOrderBy = " order by case isnull(U_PMX_PLCD,'') when '' then '999' else U_PMX_PLCD end , convert(int, case isnull(U_B1_SEQ,'') when '' then '99' else U_B1_SEQ end)";
System.Data.DataTable sboDtRpt = Program.objHrmsUI.getDataTable(strSelect + strCritaria + strOrderBy, "Open POS");
int i = 0;
int rowCnt = sboDtRpt.Rows.Count;
if (rowCnt > 0)
{
dtRpt.Rows.Add(rowCnt);
}
foreach (System.Data.DataRow dr in sboDtRpt.Rows)
{
i++;
string seq = "";
if (dr["U_B1_SEQ"].ToString() != "")
{
seq = dr["U_B1_SEQ"].ToString();
}
dtRpt.SetValue("Id", i - 1, i.ToString());
dtRpt.SetValue("Type", i - 1, dr["type"].ToString());
dtRpt.SetValue("DocNum", i - 1, dr["DocNum"].ToString());
dtRpt.SetValue("OD", i - 1, Convert.ToDateTime(dr["postdate"]));
dtRpt.SetValue("DueDate", i - 1, Convert.ToDateTime(dr["DueDate"]));
dtRpt.SetValue("PlannedQty", i - 1, Convert.ToString(dr["PlannedQty"]));
dtRpt.SetValue("Status", i - 1, dr["Status"].ToString());
dtRpt.SetValue("ItemCode", i - 1, dr["ItemCode"].ToString());
dtRpt.SetValue("ItemName", i - 1, dr["ItemName"].ToString());
dtRpt.SetValue("ProdLine", i - 1, dr["U_PMX_PLCD"].ToString());
dtRpt.SetValue("Label", i - 1, dr["U_B1_Label"].ToString());
dtRpt.SetValue("Seq", i - 1, seq);
dtRpt.SetValue("FreeText", i - 1, dr["U_B1_FrTxt"].ToString());
dtRpt.SetValue("Pos", i - 1, dr["Pos"].ToString());
dtRpt.SetValue("DocEntry", i - 1, dr["DocEntry"].ToString());
}
mtReport.LoadFromDataSource();
chApply();
oForm.Freeze(false);
lblLoading.Item.Visible = false;
if (mtReport.RowCount > 0)
{
mtReport.SelectRow(1, true, false);
}
}
public SAPbouiCOM.DataTable ObtenerParametrosTXT(SAPbouiCOM.DataTable DT_PARAM)
{
SAPbobsCOM.GeneralService oGeneralService;
SAPbobsCOM.GeneralData oGeneralData = null;
SAPbobsCOM.GeneralDataParams oGeneralParams;
SAPbobsCOM.CompanyService oCmpSrv;
SAPbobsCOM.Company oCompany = Conexion.oCompany;
try
{
//get company service
if (!oCompany.Connected)
{
Funciones.Conectar_Aplicacion();
}
oCmpSrv = oCompany.GetCompanyService();
//Get GeneralService - Main UDO - Retrieve the relevant service
oGeneralService = oCmpSrv.GetGeneralService("Z_MIN_TXTPAGOS");
//GetByKey
oGeneralParams = (SAPbobsCOM.GeneralDataParams)oGeneralService.GetDataInterface(SAPbobsCOM.GeneralServiceDataInterfaces.gsGeneralDataParams);
oGeneralParams.SetProperty("Code", "1");
oGeneralData = oGeneralService.GetByParams(oGeneralParams);
DT_PARAM.Clear();
DT_PARAM.Columns.Add("Info", SAPbouiCOM.BoFieldsType.ft_Text);
DT_PARAM.Rows.Add(13);
DT_PARAM.SetValue("Info", 0, oGeneralData.GetProperty("U_TipoRegistro"));
DT_PARAM.SetValue("Info", 1, oGeneralData.GetProperty("U_Multifecha"));
DT_PARAM.SetValue("Info", 2, oGeneralData.GetProperty("U_Modalidad"));
DT_PARAM.SetValue("Info", 3, oGeneralData.GetProperty("U_Convenio"));
DT_PARAM.SetValue("Info", 4, oGeneralData.GetProperty("U_TipoPago"));
DT_PARAM.SetValue("Info", 5, oGeneralData.GetProperty("U_CodigoPlantilla"));
DT_PARAM.SetValue("Info", 6, oGeneralData.GetProperty("U_RUTEmpresa"));
DT_PARAM.SetValue("Info", 7, oGeneralData.GetProperty("U_RUTFilial"));
DT_PARAM.SetValue("Info", 8, oGeneralData.GetProperty("U_CorreoEmp"));
DT_PARAM.SetValue("Info", 9, oGeneralData.GetProperty("U_PlantillaRendici"));
DT_PARAM.SetValue("Info", 10, oGeneralData.GetProperty("U_DirectorioBanco"));
DT_PARAM.SetValue("Info", 11, oGeneralData.GetProperty("U_DirectorioRespaldo"));
DT_PARAM.SetValue("Info", 12, oGeneralData.GetProperty("U_FlujoActivo"));
}
catch (Exception) {}
return(DT_PARAM);
}
public SAPbouiCOM.DataTable GenerarRegistros(SAPbouiCOM.DataTable DT_SQL, SAPbouiCOM.DataTable DT_DATOS, SAPbouiCOM.DataTable DT_ROWS)
{
try
{
oCompany = Program.oCompany;
SAPbobsCOM.Recordset recordset = (SAPbobsCOM.Recordset)oCompany.GetBusinessObject(SAPbobsCOM.BoObjectTypes.BoRecordset);
string sql = "";
string sNumPago = "";
int iNumAviso = 0;
DT_SQL.Clear();
DT_ROWS.Clear();
DT_ROWS.Columns.Add("Info", SAPbouiCOM.BoFieldsType.ft_Text);
for (int i = 0; i <= DT_DATOS.Rows.Count - 1; i++)
{
string val = DT_DATOS.GetValue(0, i).ToString();
if (DT_DATOS.GetValue(0, i).ToString() == "Y") //Registros Seleccionados
{
iNumAviso += 1;
sNumPago = DT_DATOS.GetValue(2, i).ToString();
//sql = @"EXEC [dbo].[Min_Bancos_Generar_Detalle_Pagos_Archivo_PagoTXT_Formato610]
// @NumPago = N'" + sNumPago + @"'
// ,@NumeroAviso = '" + iNumAviso.ToString() + "'";
//DT_SQL.ExecuteQuery(sql);
//recordset.DoQuery(sql);
//recordset.MoveFirst();
//if (!DT_SQL.IsEmpty)
//{
// for (int j = 0; j <= DT_SQL.Rows.Count - 1; j++)
// {
// var Linea = DT_SQL.GetValue(0, j);
// var Linea2 = recordset.Fields.Item(0).Value;
// recordset.MoveNext();
// DT_ROWS.Rows.Add();
// DT_ROWS.SetValue(0, DT_ROWS.Rows.Count - 1, DT_SQL.GetValue(0, j).ToString());
// //Linea = Convert.ToString(DT_ROWS.GetValue(0, DT_ROWS.Rows.Count - 1));
// }
//}
// SE DEBIO USAR System.Dat.DataTable porque el DT de SAP truncaba los resultado del SP
DataTable DtResultado = new DataTable();
SqlConnection SlqCon = new SqlConnection();
try
{
string sp = @"EXEC [" + oCompany.CompanyDB + @"].[dbo].[Min_Bancos_Generar_Detalle_Pagos_Archivo_PagoTXT_Formato610]
@NumPago = N'" + sNumPago + @"'
,@NumeroAviso = '" + iNumAviso.ToString() + "'";
SlqCon.ConnectionString = Conexion.CnSQL;
SqlCommand SqlCmd = new SqlCommand(sp, SlqCon);
SlqCon.Open();
//SqlCmd.CommandType = CommandType.Text;
//SqlCmd.Parameters.AddWithValue("@NumPago", sNumPago);
//SqlCmd.Parameters.AddWithValue("@NumeroAviso", iNumAviso.ToString());
SqlDataAdapter SqlDat = new SqlDataAdapter(SqlCmd);
SqlDat.Fill(DtResultado);
}
catch
{
DtResultado = null;
}
finally
{
if (SlqCon.State == ConnectionState.Open)
{
SlqCon.Close();
}
}
if (DtResultado.Rows.Count > 0)
{
for (int j = 0; j <= DtResultado.Rows.Count - 1; j++)
{
var Linea = DtResultado.Rows[j][0];
DT_ROWS.Rows.Add();
DT_ROWS.SetValue(0, DT_ROWS.Rows.Count - 1, Linea);
//Linea = Convert.ToString(DT_ROWS.GetValue(0, DT_ROWS.Rows.Count - 1));
}
}
}
}
}
catch (Exception) { }
return(DT_ROWS);
}
private void btnSelect_ClickAfter(object sboObject, SAPbouiCOM.SBOItemEventArg pVal)
{
try
{
var quantityNeeded = Convert.ToDouble(dtDocuments.GetValue("TotalNeeded", currentDocumentIndex));
//var selectedRows = gvBatches.Rows.SelectedRows.Cast<SAPbouiCOM.GridRows>().AsQueryable();
for (int i = 0; i < dtBatches.Rows.Count; i++)
{
var requestedBatchesQuantity = Convert.ToDouble(dtBatches.GetValue("Selected Qty", i));
var availableBatchesQuantity = Convert.ToDouble(dtBatches.GetValue("Quantity", i));
double selectedQuantity = 0;
if (gvBatches.Rows.IsSelected(i))
{
bool isAvailable = false;
for (int t = 0; t < dtSelected.Rows.Count; t++)
{
selectedQuantity = Convert.ToDouble(dtSelected.GetValue("Selected Qty", t));
if (dtSelected.GetValue("Batch", t).ToString().Equals(dtBatches.GetValue("DistNumber", i).ToString()))
{
if (availableBatchesQuantity >= requestedBatchesQuantity)
{
if (requestedBatchesQuantity > 0)
{
if (requestedBatchesQuantity < quantityNeeded)
{
dtSelected.SetValue("Selected Qty", t, Convert.ToDouble(selectedQuantity) + Convert.ToDouble(requestedBatchesQuantity));
dtBatches.SetValue("Quantity", i, availableBatchesQuantity - requestedBatchesQuantity);
dtDocuments.SetValue("TotalNeeded", currentDocumentIndex, quantityNeeded - requestedBatchesQuantity);
}
else
{
dtSelected.SetValue("Selected Qty", t, quantityNeeded + selectedQuantity);
dtBatches.SetValue("Quantity", i, availableBatchesQuantity - quantityNeeded);
dtDocuments.SetValue("TotalNeeded", currentDocumentIndex, 0);
}
}
}
isAvailable = true;
}
}
if (!isAvailable)
{
if (requestedBatchesQuantity <= availableBatchesQuantity)
{
if (requestedBatchesQuantity > 0)
{
dtSelected.Rows.Add(1);
dtSelected.SetValue("Batch", dtSelected.Rows.Count - 1, dtBatches.GetValue("DistNumber", i));
if (requestedBatchesQuantity < quantityNeeded)
{
dtSelected.SetValue("Selected Qty", dtSelected.Rows.Count - 1, dtBatches.GetValue("Selected Qty", i));
dtBatches.SetValue("Quantity", i, availableBatchesQuantity - requestedBatchesQuantity);
dtDocuments.SetValue("TotalNeeded", currentDocumentIndex, quantityNeeded - requestedBatchesQuantity);
}
else
{
dtSelected.SetValue("Selected Qty", dtSelected.Rows.Count - 1, quantityNeeded);
dtBatches.SetValue("Quantity", i, availableBatchesQuantity - quantityNeeded);
dtDocuments.SetValue("TotalNeeded", currentDocumentIndex, 0);
}
}
}
else
{
Application.SBO_Application.MessageBox("The quantity selected is large.");
}
}
}
}
}
catch (Exception ex)
{
}
}
private SAPbouiCOM.DataTable Convert_SAP_DataTable(System.Data.DataTable pDataTable)
{
SAPbouiCOM.DataTable oDT = null;
SAPbouiCOM.Form oForm = oApp.Forms.ActiveForm;
if (CheckExistUniqueID(oForm, "DT_BALS"))
{
oDT = oForm.DataSources.DataTables.Item("DT_BALS");
oDT.Clear();
}
else
{
oDT = oForm.DataSources.DataTables.Add("DT_BALS");
}
//Add column to DataTable
foreach (System.Data.DataColumn c in pDataTable.Columns)
{
try
{
if (c.DataType.ToString() == "System.DateTime")
{
oDT.Columns.Add(c.ColumnName, SAPbouiCOM.BoFieldsType.ft_Date);
}
//else if (c.DataType.ToString() == "System.Int16")
//{
// oDT.Columns.Add(c.ColumnName, SAPbouiCOM.BoFieldsType.ft_Integer);
//}
//else if (c.DataType.ToString() == "System.Decimal")
//{
// oDT.Columns.Add(c.ColumnName, SAPbouiCOM.BoFieldsType.ft_Sum);
//}
else
{
oDT.Columns.Add(c.ColumnName, SAPbouiCOM.BoFieldsType.ft_Text);
}
}
catch
{ }
}
//Add row to DataTable
foreach (System.Data.DataRow r in pDataTable.Rows)
{
oDT.Rows.Add();
//foreach (System.Data.DataColumn c in pDataTable.Columns)
for (int i = 0; i < pDataTable.Columns.Count; i++)
{
//oDT.SetValue( c.ColumnName, oDT.Rows.Count - 1, r[c.ColumnName].ToString());
string Col_Name = pDataTable.Columns[i].ColumnName;
if (i > 3)
{
decimal tmp = 0;
decimal.TryParse(r[Col_Name].ToString(), out tmp);
if (tmp != 0)
{
oDT.SetValue(Col_Name, oDT.Rows.Count - 1, tmp.ToString("N0").Replace(',', '.'));
}
}
else
{
oDT.SetValue(Col_Name, oDT.Rows.Count - 1, r[Col_Name].ToString());
}
}
}
return(oDT);
}
private void SearchChecks()
{
try
{
IList <CheckDTO> lLstChecks = mCheckDAO.GetChecks();
int i = 0;
mDtChecks.Rows.Clear();
string lStrSelected = mCmbMvType.Value;
DateTime lStartDate = this.GetDataSourceValue <DateTime>("UD_DtStr");
DateTime lEndDate = this.GetDataSourceValue <DateTime>("UD_DtFnl");
foreach (CheckDTO lObjCheck in lLstChecks)
{
if (mEdtCheckNum.Value != "" && mEdtCheckNum.Value != lObjCheck.CheckNum.ToString())
{
continue;
}
// Skip checks that are not deposited
if (lStrSelected == "Y" && lObjCheck.Deposited != "C")
{
continue;
}
// Skip checks taht are deposited
if (lStrSelected == "N" && lObjCheck.Deposited == "C")
{
continue;
}
// Filter checks newer than start date
if (lStartDate > lObjCheck.CheckDate)
{
continue;
}
// Filter older than end date
if (lEndDate < lObjCheck.CheckDate && lEndDate != default(DateTime))
{
continue;
}
mDtChecks.Rows.Add();
mDtChecks.SetValue("#", i, i + 1);
mDtChecks.SetValue("C_CheckNum", i, lObjCheck.CheckNum);
mDtChecks.SetValue("C_CheckSum", i, lObjCheck.CheckSum);
mDtChecks.SetValue("C_CardName", i, lObjCheck.CardName);
mDtChecks.SetValue("C_CheckDt", i, lObjCheck.CheckDate);
mDtChecks.SetValue("C_CheckCur", i, lObjCheck.Currency);
// Not visible
mDtChecks.SetValue("C_CheckKey", i, lObjCheck.CheckKey);
mDtChecks.SetValue("C_CardCode", i, lObjCheck.CardCode);
mDtChecks.SetValue("C_BankAcc", i, lObjCheck.BankAcct);
if (lObjCheck.Deposited == "C")
{
mDtChecks.SetValue("C_Status", i, "Depositado");
}
else
{
mDtChecks.SetValue("C_Status", i, "Ventanilla");
}
i++;
}
mMtxChecks.LoadFromDataSource();
mMtxChecks.AutoResizeColumns();
}
catch (Exception lObjException)
{
LogUtility.WriteError(string.Format("[BouncedChecks - SearchChecks] Error: {0}", lObjException.Message));
throw lObjException;
}
}
public override void etAfterCfl(ref SAPbouiCOM.ItemEvent pVal, ref bool BubbleEvent)
{
base.etAfterCfl(ref pVal, ref BubbleEvent);
SAPbouiCOM.IChooseFromListEvent oCFLEvento = (SAPbouiCOM.IChooseFromListEvent)pVal;
SAPbouiCOM.DataTable dtSel = oCFLEvento.SelectedObjects;
if (pVal.ItemUID == txCode.Item.UniqueID)
{
if (dtSel.Rows.Count > 0)
{
string strCode = dtSel.GetValue("Code", 0).ToString();
string strName = dtSel.GetValue("Name", 0).ToString();
string Remarks = dtSel.GetValue("U_Remarks", 0).ToString();
string AllocationRule = dtSel.GetValue("U_AR", 0).ToString();
BOQH.SetValue("ItemCode", 0, strCode);
BOQH.SetValue("ItemName", 0, strName);
BOQH.SetValue("Remarks", 0, Remarks);
BOQH.SetValue("AR", 0, AllocationRule);
fillDetails(strCode);
addEmptyRow(mtDC, BOQD, "CostCode");
}
}
if (pVal.ItemUID == mtDC.Item.UniqueID && pVal.ColUID == "cCode")
{
if (dtSel.Rows.Count > 0)
{
SAPbouiCOM.ComboBox cbColType = (SAPbouiCOM.ComboBox)mtDC.Columns.Item("cType").Cells.Item(pVal.Row).Specific;
if (cbColType.Selected.Value == "I")
{
string strCode = dtSel.GetValue("ItemCode", 0).ToString();
string strName = dtSel.GetValue("ItemName", 0).ToString();
BOQD.SetValue("Code", pVal.Row - 1, strCode);
BOQD.SetValue("Name", pVal.Row - 1, strName);
}
if (cbColType.Selected.Value == "S")
{
string strCode = dtSel.GetValue("AcctCode", 0).ToString();
string strName = dtSel.GetValue("AcctName", 0).ToString();
BOQD.SetValue("Code", pVal.Row - 1, strCode);
BOQD.SetValue("Name", pVal.Row - 1, strName);
}
mtDC.LoadFromDataSource();
}
}
}
private void dtToMtProcess(System.Data.DataTable dtReportTwo)
{
SAPbouiCOM.Matrix mt = mtNote;
System.Data.DataTable dt = dtReportTwo;
int OldColCnt = mt.Columns.Count;
dtNote.Rows.Clear();
mt.LoadFromDataSource();
oForm.Freeze(true);
for (int i = 0; i < OldColCnt; i++)
{
mt.Columns.Remove(0);
dtNote.Columns.Remove(0);
}
// add new colum with all dt Cols
string colId = "col0";
SAPbouiCOM.DataColumn sboDc = dtNote.Columns.Add(colId, SAPbouiCOM.BoFieldsType.ft_Integer, 100);
SAPbouiCOM.Column mCol = mt.Columns.Add(colId, SAPbouiCOM.BoFormItemTypes.it_EDIT);
mCol.TitleObject.Caption = "#";
mCol.DataBind.Bind(dtNote.UniqueID, colId);
mCol.Width = 20;
mCol.Editable = false;
mCol.RightJustified = true;
// mCol.ColumnSetting.SumValue = "T";
int j = 1;
foreach (System.Data.DataColumn dc in dt.Columns)
{
colId = "col" + j.ToString();
sboDc = dtNote.Columns.Add(colId, SAPbouiCOM.BoFieldsType.ft_AlphaNumeric, 100);
mCol = mt.Columns.Add(colId, SAPbouiCOM.BoFormItemTypes.it_EDIT);
mCol.TitleObject.Caption = dc.ColumnName;
if (j == 1)
{
mCol.Width = 150;
}
else
{
mCol.Width = 80;
}
mCol.TitleObject.Sortable = true;
mCol.Editable = false;
mCol.DataBind.Bind(dtNote.UniqueID, colId);
j++;
}
int row = 0;
int col = 0;
foreach (System.Data.DataRow dr in dt.Rows)
{
dtNote.Rows.Add(1);
dtNote.SetValue("col0", row, (row + 1).ToString());
col = 1;
foreach (System.Data.DataColumn dc in dt.Columns)
{
dtNote.SetValue("col" + col.ToString(), row, dr[dc.ColumnName]);
col++;
}
row++;
}
int m = 1;
// mt.LoadFromDataSource();
oForm.Freeze(false);
// mt.LoadFromDataSource();
mt.LoadFromDataSource();
}