private void RefreshGrid(ASPxGridView gv)
{
GridViewDataComboBoxColumn c = (GridViewDataComboBoxColumn)gv.Columns["IdentifTecno"];
c.PropertiesComboBox.TextField = "Name";
c.PropertiesComboBox.ValueField = "IdentifTecno";
c.PropertiesComboBox.DataSource = Business.TecnologiaSoporte.ReadAll("");
gv.DataSource = Business.MediosPublicitarios.ReadAllTipo("");
gv.DataBind();
}
protected void grid_Event_HtmlEditFormCreated(object sender, ASPxGridViewEditFormEventArgs e)
{
//string Port = System.Configuration.ConfigurationManager.AppSettings["LocalPort"];
//string where = string.Format("(isnull(EventCode,'')='' or EventCode='gateout') AND EventPort='{0}' AND EventDateTime in(select MAX(EventDateTime) from Cont_AssetEvent where isnull(EventCode,'')='' or EventCode='gateout' group by ContainerNo)",Port);
string Port = btn_Port.Text;
//string where = string.Format(" Id in(select id from Cont_AssetEvent as aEvent left outer join (select containerno,MAX(EventDateTime) as EventDateTime from Cont_AssetEvent group by containerno) as ass on ass.ContainerNo=aEvent.ContainerNo and ass.EventDateTime=aEvent.EventDateTime where (isnull(EventCode,'')='' or EventCode='gateout') and aEvent.EventPort='{0}' and ass.EventDateTime is not null and len(replace(isnull(aEvent.DocNo,''),' ',''))=0 and len(isnull(DocType,''))=0 )", Port);
//dsRefCont.FilterExpression = where;
string sql = string.Format(@"select aEvent.ContainerType,aEvent.ContainerNo from Cont_AssetEvent as aEvent left outer join (select containerno,MAX(EventDateTime) as EventDateTime from Cont_AssetEvent group by containerno) as ass on ass.ContainerNo=aEvent.ContainerNo and ass.EventDateTime=aEvent.EventDateTime left outer join Ref_Container as Cont on aEvent.ContainerNo=Cont.ContainerNo where (isnull(EventCode,'')='' or EventCode='gateout') and aEvent.EventPort='{0}' and ass.EventDateTime is not null and len(replace(isnull(aEvent.DocNo,''),' ',''))=0 and isnull(DocType,'')<>'SO' and Cont.StatusCode='Use' union all select ContainerType,ContainerNo from Ref_Container where ContainerNo not in( select distinct isnull(ContainerNo,'') from Cont_AssetEvent) and StatusCode='Use' ", Port);
ASPxGridView grid = sender as ASPxGridView;
ASPxDropDownEdit d = grid.FindEditFormTemplateControl("DropDownEdit") as ASPxDropDownEdit;
ASPxGridView gvlist = d.FindControl("gridPopCont") as ASPxGridView;
gvlist.DataSource = C2.Manager.ORManager.GetDataSet(sql);
gvlist.DataBind();
}
private void CreateDetailGrid()
{
detailGrid = new ASPxGridView();
detailGrid.ID = "detailGrid";
detailGrid.AutoGenerateColumns = false;
parent.Controls.Add(detailGrid);
CreateDetailColumns(detailGrid);
detailGrid.KeyFieldName = "ProductID";
detailGrid.DataSource = GetDetailDataSource();
detailGrid.DataBind();
detailGrid.RowInserting += new DevExpress.Web.Data.ASPxDataInsertingEventHandler(detailGrid_RowInserting);
detailGrid.RowUpdating += new DevExpress.Web.Data.ASPxDataUpdatingEventHandler(detailGrid_RowUpdating);
detailGrid.RowDeleting += new DevExpress.Web.Data.ASPxDataDeletingEventHandler(detailGrid_RowDeleting);
}
private object[] FindGroupValues(ASPxGridView grid)
{
grid.DataBind();
string column = grid.GetGroupedColumns()[0].FieldName;
ArrayList list = new ArrayList();
for (int i = 0; i < grid.VisibleRowCount; i++)
{
if (grid.GetRowLevel(i) == 0)
{
list.Add(grid.GetRowValues(i, column));
}
}
return(list.ToArray());
}
/// </summary>
/// <param name="companyID"></param>
protected void bind_contacts(int companyid)
{
ASPxGridView _grid = (ASPxGridView)this.fmvAddressBook.FindControl("dxgridCompanyContacts");
//ASPxGridView _grid = (ASPxGridView)this.dxpnlContacts.FindControl("dxgridCompanyContacts");
if (_grid != null)
{
SubSonic.Query _q = new SubSonic.Query(Tables.ContactTable, "WWIProv").WHERE("CompanyID", Comparison.Equals, companyid);
DataSet _ds = _q.ExecuteDataSet();
//IDataReader _dr = _q.ExecuteReader(); can't use datareder it's a read only structure!
_grid.KeyFieldName = "ContactID";
_grid.DataSource = _ds;
_grid.DataBind();
}
}
protected void grid_Init(object sender, EventArgs e)
{
ASPxGridView grid = sender as ASPxGridView;
if (Session["GridCurrentPageSize"] != null)
{
grid.SettingsPager.PageSize = (int)Session["GridCurrentPageSize"];
}
else
{
Session["GridCurrentPageSize"] = grid.SettingsPager.PageSize;
}
grid.DataBind();
}
protected void ASPxGridView1_CustomCallback(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewCustomCallbackEventArgs e)
{
nwndDataSet ds = new nwndDataSet();
nwndDataSetTableAdapters.ProductsTableAdapter pta = new nwndDataSetTableAdapters.ProductsTableAdapter();
ASPxGridView gridView = sender as ASPxGridView;
pta.FillBy(ds.Products, Convert.ToInt32(e.Parameters));
gridView.DataSource = ds.Products;
Session["gridDataSource"] = gridView.DataSource;
gridView.DataBind();
gridView.PageIndex = 0;
}
protected void gridBarCode_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
{
data = new dataHangHoa();
ASPxGridView gridBarCode = sender as ASPxGridView;
int ID = Int32.Parse(e.Keys["ID"].ToString());
object IDHangHoa = gridBarCode.GetMasterRowKeyValue();
string BarCode = e.NewValues["Barcode"] != null ? e.NewValues["Barcode"].ToString() : "";
data.CapNhatBarCode(ID, IDHangHoa, BarCode);
e.Cancel = true;
gridBarCode.CancelEdit();
gridBarCode.DataSource = data.GetListBarCode(IDHangHoa);
gridBarCode.DataBind();
}
private void RefreshGrid(ASPxGridView gridView)
{
if (gridView.ID == "gv")
{
gridView.DataSource = Business.Costos.ReadAll("");
}
else
if (pnlVersiones.Attributes["RecId"] != null)
{
gvVersiones.DataSource = Business.Costos.ReadAllVersiones(Business.Costos.Read(Convert.ToInt32(pnlVersiones.Attributes["RecId"])));
}
gridView.DataBind();
}
protected void grid_RowDeleting(object sender, DevExpress.Web.Data.ASPxDataDeletingEventArgs e)
{
ASPxGridView grid = sender as ASPxGridView;
DataTable table = new DataTable();
table = GetTable();
DataRow found = table.Rows.Find(e.Keys[0]);
table.Rows.Remove(found);
Session["Table"] = table;
grid.DataSource = table;
grid.DataBind();
e.Cancel = true;
}
protected void grid_Event_HtmlEditFormCreated(object sender, ASPxGridViewEditFormEventArgs e)
{
//string Port = System.Configuration.ConfigurationManager.AppSettings["LocalPort"];
//ASPxButtonEdit btnPort = this.grid_Transport.FindEditFormTemplateControl("btn_Port") as ASPxButtonEdit;
string Port = btn_Port.Text;
//string where = string.Format("EventCode='depotin' AND EventPort='{0}' AND EventDateTime in(select MAX(EventDateTime) from Cont_AssetEvent where EventCode='depotin' group by ContainerNo)", Port);
//dsRefCont.FilterExpression = where;
string sql = "select aEvent.id,aEvent.ContainerNo,aEvent.ContainerType from Cont_AssetEvent as aEvent left outer join (select ContainerNo,MAX(eventDateTime) as maxEventDateTime from Cont_AssetEvent group by ContainerNo) as ass on aEvent.ContainerNo=ass.ContainerNo and aEvent.EventDateTime=ass.maxEventDateTime left outer join Ref_Container as Cont on aEvent.ContainerNo=Cont.ContainerNo where aEvent.EventCode='depotin' and ass.maxEventDateTime is not null and Cont.StatusCode='Use' and aEvent.EventPort='" + Port + "'";
ASPxGridView grid = sender as ASPxGridView;
ASPxDropDownEdit d = grid.FindEditFormTemplateControl("DropDownEdit") as ASPxDropDownEdit;
ASPxGridView gvlist = d.FindControl("gridPopCont") as ASPxGridView;
gvlist.DataSource = C2.Manager.ORManager.GetDataSet(sql);
gvlist.DataBind();
}
private void CreateDetailGrid()
{
detailGrid = new ASPxGridView();
detailGrid.ID = "detailGrid";
detailGrid.AutoGenerateColumns = false;
detailGrid.SettingsDetail.ShowDetailRow = true;
parent.Controls.Add(detailGrid);
CreateDetailColumns(detailGrid);
detailGrid.KeyFieldName = "ProductID";
detailGrid.DataSource = GetDetailDataSource();
detailGrid.DataBind();
detailGrid.Templates.DetailRow = new OrderDetailsDetailGridTemplate();
}
protected void ASPxGridView1_CustomCallback(object sender, DevExpress.Web.ASPxGridViewCustomCallbackEventArgs e)
{
AccessDataSource1.UpdateParameters["EmployeeID"].DefaultValue = ASPxTextBoxEmployeeID.Value.ToString();
AccessDataSource1.UpdateParameters["LastName"].DefaultValue = ASPxTextBoxLastName.Value.ToString();
AccessDataSource1.UpdateParameters["FirstName"].DefaultValue = ASPxTextBoxFirstName.Value.ToString();
AccessDataSource1.UpdateParameters["BirthDate"].DefaultValue = Convert.ToDateTime(ASPxDateEditBirthDate.Value).ToShortDateString();
//for example purpose only, because online editing is not supported
throw new Exception("Editing in online example is not supported"); //remove this line when testing the project
AccessDataSource1.Update(); //Uncomment this line
ASPxGridView gridView = (ASPxGridView)sender;
gridView.DataBind();
}
//end session reset all
/// <summary>
/// call back panel to force update of datagridview on login /timer?
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void callBack1_Callback(object sender, DevExpress.Web.ASPxClasses.CallbackEventArgsBase e)
{
//if (!sessionTimedOut())
//{
ASPxGridView _grid = (ASPxGridView)this.ContentPlaceHolderM1.FindControl("gridOrder");
if (_grid != null)
{
_grid.DataBind();
}
//}
//else
//{
// Page.Response.Redirect("Session_Sys_Login.aspx", true);
//}
}
//初始化流水号列表
protected void ASPxGridView1_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e)
{
string[] param = e.Parameters.Split(',');
string plineCode = param[0]; //生产线
string planCode = param[1]; //计划代码
string sql = "select a.SN from DATA_PRODUCT a where a.PLINE_CODE='" + plineCode + "' and a.PLAN_CODE='" + planCode + "' "
+ " and NOT EXISTS(SELECT * FROM data_sn_temp C WHERE C.sn=A.sn ) order by a.SN";
//select ghtm from sjsxb where gzdd='" + gSite + "' and jhdm='" + thisJh + "' order by ghtm-------------VB
DataTable dt = dc.GetTable(sql);
ASPxGridView gridview1 = sender as ASPxGridView;
gridview1.DataSource = dt;
gridview1.DataBind();
gridview1.Selection.UnselectAll();
}
protected void grid_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
{
ASPxGridView grid = sender as ASPxGridView;
DataTable table = new DataTable();
table = GetTable();
table.Rows.Add(new Object[] { e.NewValues["ID"], e.NewValues["ItemName"], e.NewValues["ItemOrder"] });
// sumAmount +=Convert.ToDouble(e.NewValues["Amount"].ToString());
Session["Table"] = table;
e.Cancel = true;
grid.DataSource = table;
grid.DataBind();
grid.CancelEdit();
}
protected void grid_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
{
ASPxGridView gv = (ASPxGridView)sender;
//Get and Process the list of selected records in order to populate the list of pkvals
#region process selected records
var selected_keys = gv.GetSelectedFieldValues("valdocID");
List <int> pkvals = new List <int>();
foreach (object key in e.Keys.Values)
{
int ikey;
bool isint = int.TryParse(key.ToString(), out ikey);
if (isint)
{
pkvals.Add(ikey);
}
}
//Add the other selected rows to the update if the user has selected the "Update All" checkbox
if (selected_keys.Count > 0)
{
foreach (object k in selected_keys)
{
int ikey;
bool isint = int.TryParse(k.ToString(), out ikey);
if (!pkvals.Contains(ikey))
{
pkvals.Add(ikey);
}
}
}
#endregion
string result = dataops.dxGrid_UpdateData("valdocID", pkvals, e.NewValues, "ValantTJ", "dbo", "valantdocdump");
gv.CancelEdit();
e.Cancel = true;
//ViewState["needBind"] = "true";
gv.DataBind();
}
protected void gvProducts_CustomCallback(object sender, DevExpress.Web.ASPxGridViewCustomCallbackEventArgs e)
{
ASPxGridView gridView = sender as ASPxGridView;
string[] parameters = e.Parameters.Split('|');
string command = parameters[0];
if (command == "MOVEUP" || command == "MOVEDOWN")
{
int focusedRowKey = GetGridViewKeyByVisibleIndex(gridView, gridView.FocusedRowIndex);
int index = (int)gridView.GetRowValues(gridView.FocusedRowIndex, "DisplayOrder");
int newIndex = index;
if (command == "MOVEUP")
{
newIndex = (index == 0) ? index : index - 1;
}
if (command == "MOVEDOWN")
{
newIndex = (index == gridView.VisibleRowCount) ? index : index + 1;
}
int rowKey = GetKeyIDBySortIndex(gridView, newIndex);
UpdateSortIndex(focusedRowKey, newIndex);
UpdateSortIndex(rowKey, index);
gridView.FocusedRowIndex = gridView.FindVisibleIndexByKeyValue(rowKey);
}
if (command == "DRAGROW")
{
int draggingIndex = int.Parse(parameters[1]);
int targetIndex = int.Parse(parameters[2]);
int draggingRowKey = GetKeyIDBySortIndex(gridView, draggingIndex);
int targetRowKey = GetKeyIDBySortIndex(gridView, targetIndex);
int draggingDirection = (targetIndex < draggingIndex) ? 1 : -1;
for (int rowIndex = 0; rowIndex < gridView.VisibleRowCount; rowIndex++)
{
int rowKey = GetGridViewKeyByVisibleIndex(gridView, rowIndex);
int index = (int)gridView.GetRowValuesByKeyValue(rowKey, "DisplayOrder");
if ((index > Math.Min(targetIndex, draggingIndex)) && (index < Math.Max(targetIndex, draggingIndex)))
{
UpdateSortIndex(rowKey, index + draggingDirection);
}
}
UpdateSortIndex(draggingRowKey, targetIndex);
UpdateSortIndex(targetRowKey, targetIndex + draggingDirection);
}
gridView.DataBind();
}
protected void ASPxGridView1_CustomCallback1(object sender, ASPxGridViewCustomCallbackEventArgs e)
{
string alineCode = e.Parameters;
//初始化GRIDVIEW
string sql = "select a.RMES_ID,a.LOCATION_CODE,a.PROCESS_CODE,a.process_id, "
+ " a.process_name,a.location_name "
+ " from ATPU_ACROSS_DATA a "
+ " where a.ALINE_CODE='" + alineCode + "' and a.pline_id_new is null "
+ " and a.process_id not in (select process_id from ATPU_ACROSS_DATA_TEMP) order by a.input_time desc nulls last, a.PROCESS_CODE";
DataTable dt = dc.GetTable(sql);
ASPxGridView gridview1 = sender as ASPxGridView;
gridview1.DataSource = dt;
gridview1.DataBind();
gridview1.Selection.UnselectAll();
}
protected void g_relatedProducts_BeforePerformDataSelect(object sender, System.EventArgs e)
{
ASPxGridView gridView = (ASPxGridView)sender;
if (gridView.DataSource != null)
{
return;
}
if (Session[gridView.GetMasterRowKeyValue().ToString()] != null)
{
string selectCommand = (string)Session[gridView.GetMasterRowKeyValue().ToString()];
AccessDataSource2.SelectCommand = selectCommand;
DataView view = (DataView)AccessDataSource2.Select(DataSourceSelectArguments.Empty);
gridView.DataSource = view;
gridView.DataBind();
}
}
protected void tabela(int nrTabeli, ASPxGridView kontrolka)
{
string idDzialu = (string)Session["id_dzialu"];
if (cl.debug(int.Parse(idDzialu)))
{
cm.log.Info(tenPlik + ": rozpoczęcie tworzenia tabeli 1");
}
DataTable tabelka01 = DevExpressXXL.zLicznikiemKolumn(dr.konwertujNaPrzecinek(dr.generuj_dane_do_tabeli_sedziowskiej_2019(int.Parse(idDzialu), nrTabeli, Date1.Date, Date2.Date, 240, tenPlik)));
DataTable naglowki = dr.generuj_naglowki_do_tabeli_sedziowskiej_2019(int.Parse(idDzialu), nrTabeli, Date1.Date, Date2.Date, 240, tenPlik);
if (tabelka01 == null)
{
cm.log.Error(tenPlik + ": brak danych do tabeli " + nrTabeli.ToString());
}
Session["tabelka001"] = tabelka01;
kontrolka.DataSource = null;
kontrolka.DataSourceID = null;
kontrolka.AutoGenerateColumns = true;
kontrolka.DataSource = tabelka01;
kontrolka.DataBind();
kontrolka.KeyFieldName = "id_sedziego";
kontrolka.Columns.Clear();
int szerokoscKolumny = 80;
kontrolka.Width = Panel1.Width;
kontrolka.Columns.Add(DevExpressXXL.kolumnaDoTabeli("L.p.", "id", nrTabeli.ToString(), "", true, 36));
kontrolka.Columns.Add(DevExpressXXL.kolumnaDoTabeli("Imie i nazwisko", "Imienazwisko", nrTabeli.ToString(), "", true, 250));
int iloscKolumn = dr.iloscKolumn(nrTabeli, int.Parse(idDzialu), tenPlik);
for (int i = 1; i < iloscKolumn; i++)
{
kontrolka.Columns.Add(DevExpressXXL.kolumnaDoTabeli(tekstNaglowka(naglowki, i), "d_" + i.ToString("D2"), nrTabeli.ToString(), "", false, szerokoscKolumny));
}
kontrolka.TotalSummary.Clear();
kontrolka.TotalSummary.Add(DevExpressXXL.komorkaSumujaca("Ogółem"));
for (int i = 1; i < iloscKolumn; i++)
{
kontrolka.TotalSummary.Add(DevExpressXXL.komorkaSumujaca(i));
}
}
protected void grvEmpleados_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e)
{
try
{
ASPxGridView grid = (sender as ASPxGridView);
//Switch the grid to edit mode for the last selected row
if (e.Parameters == "StartEditing")
{
object lastSelectedRowKeyValue = grid.GetSelectedFieldValues(Constantes.ColumnaInfoAdicUserId)[grid.Selection.Count - 1];
int lastSelectedRowVisibleIndex = grid.FindVisibleIndexByKeyValue(lastSelectedRowKeyValue);
grid.StartEdit(lastSelectedRowVisibleIndex);
}
else
{
string strKey = "";
List <TreeListNode> lstSelectedNodes = trlDepartamentos.GetSelectedNodes();
if (lstSelectedNodes.Count > 0)
{
foreach (TreeListNode Node in lstSelectedNodes)
{
strKey += Node.Key + ",";
}
strKey = strKey.Substring(0, strKey.Length - 1);
Session["DepartamentoSelected"] = strKey;
DataTable dtbEmpleados = (DataTable)Session[Constantes.SessionTblInfoAdicional];
String strFilter = Constantes.ColumnaInfoAdicUserId + " in (" + strKey + ")";
DataRow[] dtrFilter = dtbEmpleados.Select(strFilter);
DataTable dtbFilter = dtbEmpleados.Clone();
foreach (DataRow row in dtrFilter)
{
dtbFilter.ImportRow(row);
}
Session[Constantes.SessionTblInfoAdicional1] = dtbFilter;
grid.DataSource = dtbFilter;
grid.DataBind();
}
}
}
catch (Exception)
{
throw;
}
}
protected void grid_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
{
ASPxGridView grid = sender as ASPxGridView;
DataTable table = new DataTable();
table = GetTable();
// sumAmount +=Convert.ToDouble(e.NewValues["Amount"].ToString());
///Check the account balance
GLAccount acc = new GLAccount();
acc.get(int.Parse(e.NewValues["GLAccountID"].ToString()));
if (acc.AcctType == 1 || acc.AcctType == 5)//depit acount (asset and expenses)
{
if (e.NewValues["Credit"] != null && e.NewValues["Credit"].ToString() != "")
{
if (acc.Balance < decimal.Parse(e.NewValues["Credit"].ToString()))
{
throw new Exception("Account Balance(" + acc.Balance.ToString() + ") not enough");
}
}
}
else
{
if (e.NewValues["Depit"] != null && e.NewValues["Depit"].ToString() != "")
{
if (acc.Balance < decimal.Parse(e.NewValues["Depit"].ToString()))
{
throw new Exception("Account Balance(" + acc.Balance.ToString() + ") not enough");
}
}
}
/////////////////////////////
table.Rows.Add(new Object[] { e.NewValues["ID"], e.NewValues["GLAccountID"], e.NewValues["Depit"], e.NewValues["Credit"], e.NewValues["Memo"], int.Parse(e.NewValues["GLAccountID"].ToString()) < 0 ? 1 : 0 });
Session["Table"] = table;
e.Cancel = true;
grid.DataSource = table;
grid.DataBind();
grid.CancelEdit();
}
protected void grid_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
{
ASPxGridView grid = sender as ASPxGridView;
DataTable table = new DataTable();
table = GetTable();
DataRow found = table.Rows.Find(e.Keys[0]);
found["KPI"] = e.NewValues["KPI"];
found["Rate"] = e.NewValues["Rate"];
Session["Table101"] = table;
grid.DataSource = table;
grid.DataBind();
e.Cancel = true;
grid.CancelEdit();
}
private void RefreshGrid(ASPxGridView gv)
{
GridViewDataComboBoxColumn c;
c = (GridViewDataComboBoxColumn)gv.Columns["IdentifTipo"];
c.PropertiesComboBox.TextField = "Name";
c.PropertiesComboBox.ValueField = "IdentifTipo";
c.PropertiesComboBox.DataSource = Business.MediosPublicitarios.ReadAllTipo("");
c = (GridViewDataComboBoxColumn)gv.Columns["IdentifGrupo"];
c.PropertiesComboBox.TextField = "Name";
c.PropertiesComboBox.ValueField = "IdentifGrupo";
c.PropertiesComboBox.DataSource = Business.MediosPublicitarios.ReadAllGrupo("");
gv.DataSource = Business.MediosPublicitarios.ReadAll("");
gv.DataBind();
}
protected void relatedProducts_CustomCallback(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewCustomCallbackEventArgs e)
{
ASPxGridView g_relatedProducts = (ASPxGridView)sender;
int visibleIndex = int.Parse(e.Parameters);
ASPxPageControl pc = (ASPxPageControl)grid.FindDetailRowTemplateControl(visibleIndex, "ASPxPageControl1");
HtmlInputText editor = (HtmlInputText)pc.TabPages[0].FindControl("SearchString");
string searchString = editor.Value;
string selectCommand = "select * from [Products] where (([CategoryID]=" + g_relatedProducts.GetMasterRowKeyValue().ToString() + ") and ([ProductName] Like '%" + searchString + "%'))";
Session[g_relatedProducts.GetMasterRowKeyValue().ToString()] = selectCommand;
AccessDataSource2.SelectCommand = selectCommand;
DataView view = (DataView)AccessDataSource2.Select(DataSourceSelectArguments.Empty);
g_relatedProducts.DataSource = view;
g_relatedProducts.DataBind();
}
protected void grid_dmorder_HtmlRowCreated(object sender, ASPxGridViewTableRowEventArgs e)
{
if (e.RowType == GridViewRowType.Detail)
{
ASPxGridView master = sender as ASPxGridView;
ASPxGridView grd_selectproduct = master.FindDetailRowTemplateControl(e.VisibleIndex, "grd_selectproduct") as ASPxGridView;
grd_selectproduct.HtmlRowPrepared += new ASPxGridViewTableRowEventHandler(grd_addproduct_HtmlDataCellPrepared);
grd_selectproduct.DataSource = new[] {
new{ stt = 1, productid = "SP00001", productname = "Hàng hóa 1", unit = "Hộp", number = 500, priceunit = "5.000", total = "2.500.000", lotid = "SL0001", duedate = "01/07/2015", note = "Hàng mới" },
new{ stt = 2, productid = "SP00002", productname = "Hàng hóa 2", unit = "Hộp", number = 50, priceunit = "5.000", total = "2.500.000", lotid = "SL0002", duedate = "01/08/2014", note = "Note" },
new{ stt = 3, productid = "SP00003", productname = "Hàng hóa 3", unit = "Thùng", number = 70, priceunit = "5.000", total = "2.500.000", lotid = "SL0002", duedate = "01/09/2016", note = "Ví dụ" }
};
grd_selectproduct.DataBind();
}
}
protected void GridPlanningJournal_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
{
e.Cancel = true;
ASPxGridView gridview = sender as ASPxGridView;
gridview.CancelEdit();
Guid transactionId = Guid.Parse(gridview.JSProperties["cpInventoryTransactionId"].ToString());
Guid itemUnitId = Guid.Parse(e.NewValues["ItemUnitId!Key"].ToString());
double amount = (double)e.NewValues["Credit"];
Guid lotId = Guid.Parse(e.NewValues["LotId!Key"].ToString());
Guid inventoryId = Guid.Parse(e.NewValues["InventoryId!Key"].ToString());
InventoryJournalBO inventoryJournalBO = new InventoryJournalBO();
inventoryJournalBO.CreateInventoryPlanningJournal(session, transactionId, itemUnitId, amount, lotId, inventoryId, (string)e.NewValues["Description"]);
gridview.DataSource = inventoryJournalBO.GetDeliveryPlanningJournalForTransaction(session, Guid.Parse(gridview.GetMasterRowKeyValue().ToString()));
gridview.DataBind();
}
protected void ASPxGridView1_RowUpdating1(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
{
ASPxGridView grid = sender as ASPxGridView;
string userid = Convert.ToString(e.Keys["UserID"]).Trim();
try
{
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["IOSWeb_TestConnectionString"].ConnectionString))
{
conn.Open();
SqlCommand cmdInsertUser = new SqlCommand("TestGrid_UpdateUser", conn)
{
CommandType = System.Data.CommandType.StoredProcedure
};
cmdInsertUser.Parameters.Clear();
SqlParameter paramUserID = new SqlParameter("@UserID", userid);
SqlParameter User_Name = new SqlParameter("@UserName", e.NewValues["UserName"]);
SqlParameter User_Desc = new SqlParameter("@UserDesc", e.NewValues["UserDesc"]);
SqlParameter Password = new SqlParameter("@Password", e.NewValues["Password"]);
SqlParameter ModifiedBy = new SqlParameter("@ModifiedBy", e.NewValues["ModifiedBy"]);
cmdInsertUser.Parameters.Add(paramUserID);
cmdInsertUser.Parameters.Add(User_Name);
cmdInsertUser.Parameters.Add(User_Desc);
cmdInsertUser.Parameters.Add(Password);
cmdInsertUser.Parameters.Add(ModifiedBy);
cmdInsertUser.ExecuteNonQuery();
cmdInsertUser.Parameters.Clear();
cmdInsertUser.Dispose();
e.Cancel = true;
ASPxGridView1.CancelEdit();
ASPxGridView1.DataBind();
}
}
catch (Exception ex)
{
}
e.Cancel = true;
grid.CancelEdit();
grid.DataBind();
}
/// <summary>
/// Xử lý khi Save Callback kết thúc
/// </summary>
/// <param name="result">kết quả trả về khi callback xong</param>
/// <param name="param">tham số e.Parameter của Callback Event</param>
/// <param name="tblTemp">Tên bảng cần xóa dữ liệu tạm sau khi callback xong. Chỉ dành cho trường hợp lưu thành công</param>
/// <param name="sessionname">Tên session lưu giữ sessionkey của bảng temp</param>
///
public static void gridProductDetailsAddInCallback(string parameter, ASPxGridView gv)
{
object tempID = -1;
if (parameter.StartsWith("reorderlevel"))
{
object typeReorder = parameter.Split(';')[1];
tempID = parameter.Split(';')[2];
if (tempID != null)
{
EU.SALE_temp_reorderLevel(tempID, typeReorder);
//LogAction(4, tempID + ";ReorderLevel :" + parameter);
//throw new Exception("gridProductDetailsAddInCallback;" + tempID + ";param:" + parameter);
}
}
gv.DataBind();
}
protected void grid_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
{
ASPxGridView grid = sender as ASPxGridView;
DataTable table = new DataTable();
table = GetTable();
DataRow found = table.Rows.Find(e.Keys[0]);
//found["Day"] = e.NewValues["Day"];
decimal tot = 0;
for (int i = 0; i < table.Columns.Count; i++)
{
if (!table.Columns[i].ReadOnly && e.NewValues[table.Columns[i].ToString()] != null)
{
found[table.Columns[i].ToString()] = e.NewValues[table.Columns[i].ToString()];
if (table.Columns[i].ToString() != "ID" && table.Columns[i].ToString() != "StudentName" && table.Columns[i].ToString() != "Total" && table.Columns[i].ToString() != "ExamCourseID")
{
tot += decimal.Parse(e.NewValues[table.Columns[i].ToString()].ToString());
}
}
}
found["Total"] = tot.ToString();
/* found["Lecture1"] = e.NewValues["Lecture1"];
* found["Lecture2"] = e.NewValues["Lecture2"];
* found["Lecture3"] = e.NewValues["Lecture3"];
* found["Lecture4"] = e.NewValues["Lecture4"];
* found["Lecture5"] = e.NewValues["Lecture5"];
* found["Lecture6"] = e.NewValues["Lecture6"];
* found["Lecture7"] = e.NewValues["Lecture7"];
* found["Lecture8"] = e.NewValues["Lecture8"];
* found["Lecture9"] = e.NewValues["Lecture9"];
* found["Lecture10"] = e.NewValues["Lecture10"];
*/
Session["TableDegree"] = table;
grid.DataSource = table;
grid.DataBind();
e.Cancel = true;
grid.CancelEdit();
}
protected void grid_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
{
ASPxGridView grid = sender as ASPxGridView;
DataTable table = new DataTable();
if (Convert.ToInt32(Request.QueryString["id"].ToString()) > 0)
{
ProductPriceItems PPI = new ProductPriceItems();
table = PPI.getByProductID(Convert.ToInt32(Request.QueryString["id"].ToString()));
if (table.Rows.Count > 0)
{
if (Session["Table"] == null)
{
DataColumn colid = table.Columns[0];
table.PrimaryKey = new DataColumn[] { colid };
}
else
{
table = GetTable();
}
}
else
{
table = GetTable();
}
}
else
{
table = GetTable();
}
DataRow found = table.Rows.Find(e.Keys[0]);
found["Description"] = e.NewValues["Description"];
found["Amount"] = e.NewValues["Amount"];
found["Seq"] = e.NewValues["Seq"];
found["GLAccountID"] = e.NewValues["GLAccountID"];
Session["Table"] = table;
grid.DataSource = table;
grid.DataBind();
e.Cancel = true;
grid.CancelEdit();
}
private void RefreshGrid(ASPxGridView gv)
{
gv.DataSource = CRUDHelper.ReadAll("", DAO);
gv.DataBind();
}
public void gridCallBackOption(ASPxGridView grid, string param, string KeyFieldName, SqlDataSource ds)
{
try
{
HttpCookie myCookie = Request.Cookies[CU.getuserid().ToString()];
switch (param)
{
case "isShowFiltertrue":
grid.Settings.ShowFilterBar = GridViewStatusBarMode.Visible;
if (myCookie != null) myCookie["GroupFilter"] = "true";
break;
case "isShowFilterfalse":
grid.Settings.ShowFilterBar = GridViewStatusBarMode.Hidden;
if (myCookie != null) myCookie["GroupFilter"] = "false";
break;
case "isShowHScrolltrue":
grid.Settings.HorizontalScrollBarMode = DevExpress.Web.ASPxClasses.ScrollBarMode.Visible;
if (myCookie != null) myCookie["HScroll"] = "true";
break;
case "isShowHScrollfalse":
grid.Settings.HorizontalScrollBarMode = DevExpress.Web.ASPxClasses.ScrollBarMode.Hidden;
if (myCookie != null) myCookie["HScroll"] = "false";
break;
case "isShowHypColtrue":
grid.AccessibilityCompliant = true;
if (myCookie != null) myCookie["HypCol"] = "true";
break;
case "isShowHypColfalse":
grid.AccessibilityCompliant = false;
if (myCookie != null) myCookie["HypCol"] = "false";
break;
case "isShowGrouptrue":
grid.Settings.ShowGroupPanel = true;
if (myCookie != null) myCookie["Grouptrue"] = "true";
break;
case "isShowGroupfalse":
grid.Settings.ShowGroupPanel = false;
if (myCookie != null) myCookie["Grouptrue"] = "false";
break;
}
List<object> listKeyValueOK = new List<object>();
if (param.IndexOf("focus") >= 0)
{
int id = 0;
Int32.TryParse(param.Replace("focus", ""), out id);
if (id > 0)
grid.FocusedRowIndex = grid.FindVisibleIndexByKeyValue(param.Replace("focus", ""));
}
else if (param.IndexOf("action") >= 0)
{
int action = int.Parse(param.Replace("action", ""));
List<object> listkeyvalue = grid.GetSelectedFieldValues(grid.KeyFieldName);
SiAuto.Main.LogColored(System.Drawing.Color.Purple, grid.KeyFieldName + "Số dòng :" + listkeyvalue.Count);
if (listkeyvalue.Count > 0)
{
for (int i = 0; i < listkeyvalue.Count; i++)
{
SiAuto.Main.LogColored(System.Drawing.Color.Purple, "key so :" + i.ToString() + "----" + listkeyvalue[i]);
string currentCode = "isApproved=" + action + " AND " + grid.KeyFieldName + "=" + listkeyvalue[i];
bool check = EU.CheckByModuleD(globalModuleID, currentCode);
if (check == true)
{
var values = new Dictionary<string, object>
{
{"isApproved",action},
{grid.KeyFieldName,listkeyvalue[i]}
};
EU.updateTblScript(globalModuleID, values);
listKeyValueOK.Add(listkeyvalue[i]);
}
}
if (listKeyValueOK.Count > 0)
{
if (action == 1)
{
WorkFlowManager.BuildTaskByWhenExecute(globalModuleID, "APPROVED", string.Join(";", listKeyValueOK));
UserUtils.Log(CU.getLoginID(), globalModuleID, -1, string.Join(";", listKeyValueOK), "", "Duyệt thành công !", "APPROVED");
}
else
{
WorkFlowManager.BuildTaskByWhenExecute(globalModuleID, "NOTAPPROVED", string.Join(";", listKeyValueOK));
UserUtils.Log(CU.getLoginID(), globalModuleID, -1, string.Join(";", listKeyValueOK), "", "Bỏ duyệt thành công !", "NOTAPPROVED");
}
listKeyValueOK.Clear();
}
}
else
{
object currentFocused = grid.GetRowValues(grid.FocusedRowIndex, grid.KeyFieldName);
string currentCode = "isApproved=" + action + " AND " + grid.KeyFieldName + "=" + currentFocused.ToString();
bool check = EU.CheckByModuleD(globalModuleID, currentCode);
if (check == true)
{
if (currentFocused != null)
{
var values = new Dictionary<string, object>{
{"isApproved",action},
{grid.KeyFieldName,currentFocused}
};
EU.updateTblScript(globalModuleID, values);
if (action == 1)
{
SiAuto.Main.LogColored(Color.Green, "Chuan bi workflow APPROVED");
WorkFlowManager.BuildTaskByWhenExecute(globalModuleID, "APPROVED", currentFocused.ToString());
SiAuto.Main.LogColored(Color.Green, "End workflow APPROVED");
SiAuto.Main.LogColored(Color.Green, "ghi vao tray - bảng SY_audit_trail APPROVED");
//UserUtils.Log(CU.getLoginID(), globalModuleID, -1, currentFocused.ToString(), "", "Duyệt thành công !", "APPROVED");
SiAuto.Main.LogColored(Color.Green, "end tray ");
}
else
{
SiAuto.Main.LogColored(Color.Green, "Chuan bi workflow NOTAPPROVED");
WorkFlowManager.BuildTaskByWhenExecute(globalModuleID, "NOTAPPROVED", currentFocused.ToString());
SiAuto.Main.LogColored(Color.Green, "End workflow NOTAPPROVED");
SiAuto.Main.LogColored(Color.Green, "ghi vao tray - bảng SY_audit_trail NOTAPPROVED");
//UserUtils.Log(CU.getLoginID(), globalModuleID, -1, currentFocused.ToString(), "", "Bỏ duyệt thành công !", "NOTAPPROVED");
SiAuto.Main.LogColored(Color.Green, "end tray NOTAPPROVED");
}
}
}
}
UserUtils.Log(CU.getLoginID(), globalModuleID, -1, -1, listkeyvalue.ToString(), "", "APPROVED :" + action);
}
else if (param.IndexOf("delselect") >= 0)
{
List<object> listid = grid.GetSelectedFieldValues(new string[] { grid.KeyFieldName });
if (listid.Count > 0)
{
for (int i = 0; i < listid.Count; i++)
{
SiAuto.Main.LogColored(System.Drawing.Color.Purple, "key so :" + i.ToString() + "----" + listid[i]);
string currentCode = "isDeleted=1 AND " + grid.KeyFieldName + "=" + listid[i];
bool check = EU.CheckByModuleD(globalModuleID, currentCode);
if (check == true)
{
string rowDeleted = EU.deleteMultiTblScript(globalModuleID, grid.KeyFieldName, string.Join(",", listid));
listKeyValueOK.Add(listid[i]);
}
}
if (listKeyValueOK.Count > 0)
{
WorkFlowManager.BuildTaskByWhenExecute(globalModuleID, "DELETED", string.Join(";", listKeyValueOK));
listKeyValueOK.Clear();
}
}
else
{
object currentFocused = grid.GetRowValues(grid.FocusedRowIndex, grid.KeyFieldName);
if (currentFocused != null)
{
string currentCode = "isDeleted=1 AND " + grid.KeyFieldName + "=" + currentFocused.ToString();
bool check = EU.CheckByModuleD(globalModuleID, currentCode);
if (check == true)
{
string rowDeleted = EU.deleteMultiTblScript(globalModuleID, grid.KeyFieldName, string.Join(",", currentFocused.ToString()));
if (int.Parse(rowDeleted) > 0)
{
SiAuto.Main.LogColored(Color.Green, "Chuan bi workflow DELETED");
WorkFlowManager.BuildTaskByWhenExecute(globalModuleID, "DELETED", currentFocused.ToString());
SiAuto.Main.LogColored(Color.Green, "End workflow DELETED");
SiAuto.Main.LogColored(Color.Green, "ghi vao tray - bảng SY_audit_trail DELETED");
UserUtils.Log(CU.getLoginID(), globalModuleID, -1, int.Parse(currentFocused.ToString()), "", "Xóa thành công !", "DELETED");
SiAuto.Main.LogColored(Color.Green, "end tray DELETED");
}
}
}
}
}
else if (param.IndexOf("RestoreSelect") >= 0)
{
List<object> listid = grid.GetSelectedFieldValues(new string[] { grid.KeyFieldName });
if (listid.Count > 0)
{
for (int i = 0; i < listid.Count; i++)
{
SiAuto.Main.LogColored(System.Drawing.Color.Purple, "key so :" + i.ToString() + "----" + listid[i]);
string currentCode = "isDeleted=0 AND " + grid.KeyFieldName + "=" + listid[i];
bool check = EU.CheckByModuleD(globalModuleID, currentCode);
if (check == true)
{
string rowDeleted = EU.restoreMultiTblScript(globalModuleID, grid.KeyFieldName, string.Join(",", listid));
listKeyValueOK.Add(listid[i]);
}
}
if (listKeyValueOK.Count > 0)
{
WorkFlowManager.BuildTaskByWhenExecute(globalModuleID, "RESTORED", string.Join(";", listKeyValueOK));
listKeyValueOK.Clear();
}
}
else
{
object currentFocused = grid.GetRowValues(grid.FocusedRowIndex, grid.KeyFieldName);
if (currentFocused != null)
{
string currentCode = "isDeleted=0 AND " + grid.KeyFieldName + "=" + currentFocused.ToString();
bool check = EU.CheckByModuleD(globalModuleID, currentCode);
if (check == true)
{
string rowDeleted = EU.restoreMultiTblScript(globalModuleID, grid.KeyFieldName, string.Join(",", currentFocused.ToString()));
if (int.Parse(rowDeleted) > 0)
{
SiAuto.Main.LogColored(Color.Green, "Chuan bi workflow RESTORED");
WorkFlowManager.BuildTaskByWhenExecute(globalModuleID, "RESTORED", currentFocused.ToString());
SiAuto.Main.LogColored(Color.Green, "End workflow RESTORED");
SiAuto.Main.LogColored(Color.Green, "ghi vao tray - bảng SY_audit_trail RESTORED");
UserUtils.Log(CU.getLoginID(), globalModuleID, -1, int.Parse(currentFocused.ToString()), "", "Phục hồi thành công !", "RESTORED");
SiAuto.Main.LogColored(Color.Green, "end tray RESTORED");
}
}
}
}
}
grid.DataBind();
if (myCookie != null) Response.Cookies.Set(myCookie);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
private void RefreshAbmGrid(ASPxGridView gvABM)
{
gvABM.DataSource = Productos;
gvABM.DataBind();
}
public void Setup(ASPxGridView gridView, DataTable table)
{
if (table == null) return;
gridView.DataSource = table;
gridView.DataBind();
}
private void RefreshGrid(ASPxGridView gv)
{
gv.DataSource = CRUDHelper.ReadAll("", BusinessMapper.GetDaoByEntity(BusinessMapper.eEntities.IdentAtencion));
gv.DataBind();
}
private void RefreshGrid(ASPxGridView gridView)
{
if (gridView.ID == "gv")
gridView.DataSource = Business.Costos.ReadAll("");
else
if (pnlVersiones.Attributes["RecId"] != null)
gvVersiones.DataSource = Business.Costos.ReadAllVersiones(Business.Costos.Read(Convert.ToInt32(pnlVersiones.Attributes["RecId"])));
gridView.DataBind();
}
protected void CancelEditingFromEditing(ASPxGridView gridView, CancelEventArgs e)
{
e.Cancel = true;
gridView.CancelEdit();
gridView.DataBind(gridView.DataSource as XPCollection);
}
private void RefreshAbmGrid(ASPxGridView gvABM)
{
List<MiEstimadoDetDTO> miLista = new List<MiEstimadoDetDTO>();
AgregarCodigoAviso(miLista);
//reordena la lista
gvABM.DataSource = miLista;
gvABM.SortBy(gv.Columns["Fecha"] , DevExpress.Data.ColumnSortOrder.Ascending);
gvABM.SortBy(gv.Columns["Dia"] , DevExpress.Data.ColumnSortOrder.Ascending);
gvABM.SortBy(gv.Columns["Hora"] , DevExpress.Data.ColumnSortOrder.Ascending);
gvABM.SortBy(gv.Columns["Salida"], DevExpress.Data.ColumnSortOrder.Ascending);
gvABM.DataBind();
}
/// <summary>
/// Refresh grid moi khi delete item
/// Phai thuc hien nhieu buoc la vi khi thuc hien ham bind o 1 trang > 0 thi bi loi
/// </summary>
/// <param name="grid"></param>
public static void RefreshGrid(ASPxGridView grid)
{
int page = grid.PageIndex;
grid.PageIndex = 0;
grid.DataBind();
grid.PageIndex = page;
}
private void FillGridView(ASPxGridView gv, int taskClassType)
{
try
{
IQueryable<TaskStruct> test = GetTableLookFromSession(taskClassType).AsQueryable();
gv.DataSource = from t in test
select new { f1 = t.Description, f2 = t.Value };
gv.DataBind();
}
catch { }
}
protected void AgregarTotales()
{
try {
int suma = 0;
decimal suma2 = 0;
decimal suma3 = 0;
ASPxGridView aux = new ASPxGridView();
string Titulo = string.Empty;
Tabla.Rows[Tabla.Rows.Count - 1][0] = "TOTALES";
aux.DataSource = Tabla;
aux.DataBind();
gv.DataSource = Tabla;
gv.DataBind();
for (int x = 5; x <= Tabla.Columns.Count - 1; x++)
{
Titulo = aux.Columns[x].ToString();
if (Titulo.Substring(Titulo.Length - 1) == "1")
{
Titulo = Titulo.Substring(0, Titulo.Length - 1);
aux.Columns[Titulo + "1"].Caption = Titulo + " - Costo";
}
if (aux.Columns[x].Index > 6 && aux.Columns[x].ToString().Substring(aux.Columns[x].ToString().Length - 1) != "1" && aux.Columns[x].ToString().Substring(aux.Columns[x].ToString().Length - 7) != "Salidas")
{
Titulo = aux.Columns[x].ToString() + " - Salidas";
aux.Columns[aux.Columns[x].Index].Caption = Titulo;
}
aux.Columns[x].HeaderStyle.Wrap = DevExpress.Utils.DefaultBoolean.True;
gv = aux;
suma = 0;
suma2 = 0;
suma3 = 0;
for (int y = 0; y <= Tabla.Rows.Count - 2; y++)
{
if (Tabla.Rows[y][x] != System.DBNull.Value)
{
if (Titulo.Substring(Titulo.Length - 7) == "Salidas")
{
suma += Convert.ToInt32(Tabla.Rows[y][x]);
}
else
{
if (Titulo.Substring(Titulo.Length - 5) == "Costo")
{
suma2 += Convert.ToDecimal(Tabla.Rows[y][x]);
}
else
{
suma3 += Convert.ToDecimal(Tabla.Rows[y][x]);
}
}
}
}
if (Titulo.Substring(Titulo.Length - 7) == "Salidas")
{
Tabla.Rows[Tabla.Rows.Count - 1][x] = suma;
}
else
{
if (Titulo.Substring(Titulo.Length - 5) == "Costo")
{
Tabla.Rows[Tabla.Rows.Count - 1][x] = suma2;
}
else
{
if (Titulo.Substring(Titulo.Length - 9) == "INVERSION")
{
Tabla.Rows[Tabla.Rows.Count - 1][x] = suma3;
}
else
{
Tabla.Rows[Tabla.Rows.Count - 1][x] = Convert.ToInt32(suma3);
}
}
}
}
}
catch(Exception ex)
{
}
}
private void RefreshAbmGrid(ASPxGridView gvABM)
{
gvABM.DataSource = TipoCambio;
gvABM.DataBind();
}
private void RefreshAbmGrid(ASPxGridView gvABM)
{
gvABM.DataSource = Detalles;
gvABM.DataBind();
}
protected override void EndEditing(ASPxGridView gridView, System.ComponentModel.CancelEventArgs e)
{
e.Cancel = true;
gridView.CancelEdit();
gridView.DataBind(gridView.DataSource as XPCollection);
}
private void LoadSearch(int _type, int _status, ASPxGridView grv)
{
try
{
if (idGroup != 1 && idGroup != 2 && idGroup != 4 && idGroup != 10 && idGroup != 14)
{
var listPlus = (from a in db.PROFILE_NEWs where a.USER_ID == idUser select a)
.Union(from a in db.PROFILE_NEWs
join b in db.WORKFLOW_USERs on a.ID equals b.PROF_ID
where b.USER_ID == idUser
select a).OrderByDescending(n => n.PROF_DATE);
if (listPlus.Count() > 0)
{
if (_status == 0)
{
var listNew = listPlus.Where(n => n.PROF_TYPE == _type && n.PROF_STATUS != 12 );
grv.DataSource = listNew;
grv.DataBind();
Session["DangTienHanh"] = Utils.CIntDef(Session["DangTienHanh"]) + listNew.Count(n => n.PROF_STATUS != 12);
Session["DaHoanThanh"] = Utils.CIntDef(Session["DaHoanThanh"]) + listNew.Count(n => n.PROF_STATUS == 12);
}
else
{
var listNew = listPlus.Where(n => n.PROF_TYPE == _type && n.PROF_STATUS == 12 );
grv.DataSource = listNew;
grv.DataBind();
Session["DangTienHanh"] = Utils.CIntDef(Session["DangTienHanh"]) + listNew.Count(n => n.PROF_STATUS != 12);
Session["DaHoanThanh"] = Utils.CIntDef(Session["DaHoanThanh"]) + listNew.Count(n => n.PROF_STATUS == 12);
}
}
else
{
if (_status == 0)
{
var listDom = db.PROFILE_NEWs.Where(n => n.USER_ID == idUser && n.PROF_TYPE == _type && n.PROF_STATUS != 12).OrderByDescending(n => n.PROF_DATE);
grv.DataSource = listDom;
grv.DataBind();
Session["DangTienHanh"] = Utils.CIntDef(Session["DangTienHanh"]) + listDom.Count(n => n.PROF_STATUS != 12);
Session["DaHoanThanh"] = Utils.CIntDef(Session["DaHoanThanh"]) + listDom.Count(n => n.PROF_STATUS == 12);
}
else
{
var listDom = db.PROFILE_NEWs.Where(n => n.USER_ID == idUser && n.PROF_TYPE == _type && n.PROF_STATUS == 12).OrderByDescending(n => n.PROF_DATE);
grv.DataSource = listDom;
grv.DataBind();
Session["DangTienHanh"] = Utils.CIntDef(Session["DangTienHanh"]) + listDom.Count(n => n.PROF_STATUS != 12);
Session["DaHoanThanh"] = Utils.CIntDef(Session["DaHoanThanh"]) + listDom.Count(n => n.PROF_STATUS == 12);
}
}
}
else
{
if (_status == 0)
{
var list = db.PROFILE_NEWs.Where(n => n.PROF_TYPE == _type && n.PROF_STATUS != 12).OrderByDescending(n => n.PROF_DATE);
grv.DataSource = list;
grv.DataBind();
Session["DangTienHanh"] = Utils.CIntDef(Session["DangTienHanh"]) + list.Count(n => n.PROF_STATUS != 12);
Session["DaHoanThanh"] = Utils.CIntDef(Session["DaHoanThanh"]) + list.Count(n => n.PROF_STATUS == 12);
}
else
{
var list = db.PROFILE_NEWs.Where(n => n.PROF_TYPE == _type && n.PROF_STATUS == 12).OrderByDescending(n => n.PROF_DATE);
grv.DataSource = list;
grv.DataBind();
Session["DangTienHanh"] = Utils.CIntDef(Session["DangTienHanh"]) + list.Count(n => n.PROF_STATUS != 12);
Session["DaHoanThanh"] = Utils.CIntDef(Session["DaHoanThanh"]) + list.Count(n => n.PROF_STATUS == 12);
}
}
}
catch //(Exception)
{
//throw;
}
}
private void RefreshAbmGrid(ASPxGridView gvABM)
{
gvABM.DataSource = Atencion;
gvABM.DataBind();
}
private void RefreshAbmGrid(ASPxGridView gv)
{
var lineas = new List<CertificadoDetDTO>();
if (mycert != null)
{
mycert = mycert.OrderBy(t => t.Dia).ThenBy(u => u.Hora).ThenBy(v => v.Salida).ToList();
}
lineas = mycert;
lineas = lineas.OrderBy(t => t.Dia).ThenBy(u => u.Hora).ThenBy(v => v.Salida).ToList();
gv.DataSource = lineas;
gv.DataBind();
}
private void RefreshGrid(ASPxGridView gv)
{
gv.DataSource = CRUDHelper.ReadAll("", BusinessMapper.GetDaoByEntity(Entity));
gv.DataBind();
}
private void RefreshAbmGridUnsorted(ASPxGridView gv)
{
gv.DataSource = mycert;
gv.DataBind();
}
private void RefreshAbmGrid(ASPxGridView gvABM)
{
if (gvABM.ID == "gvABMFrecuencia")
gvABM.DataSource = CostosFrecuencia;
else
gvABM.DataSource = CostosProveedor;
gvABM.DataBind();
}
private void RefreshHomeGrid(ASPxGridView gvHome)
{
//cargar con pautas
gvHome.DataSource = mycert;
gvHome.DataBind();
}
private void RefreshGrid(ASPxGridView gv)
{
gv.DataSource = Business.TecnologiaSoporte.ReadAll("");
gv.DataBind();
}
private void RefreshSKUGrid(ASPxGridView gvSKU)
{
decimal total = 0;
var dt = Certificados.BuildAllSKU(mycert);
gvSKU.DataSource = dt;
gvSKU.DataBind();
foreach (System.Data.DataRow dr in dt.Rows)
total += Convert.ToDecimal(dr["CantSalidas"]);
lblSKUTotalSalidas.Text = "Total de Salidas: " + total.ToString();
}
private void RefreshGrid(ASPxGridView gv)
{
gv.DataSource = Business.Monedas.ReadAll("");
gv.DataBind();
}
private void RefreshAbmGrid(ASPxGridView gv)
{
var lineas = Lineas;
lineas = lineas.OrderBy(p => p.Dia).ThenBy(r => r.Hora).ThenBy(s => s.Salida).ToList();
gv.DataSource = lineas;
gv.DataBind();
}
