protected void Page_Load(object sender, EventArgs e) { SetPageTitle(Translation.GetTranslation.Term(m_sMODULE + ".LBL_LIST_FORM_TITLE")); var oQuery = new InlineQueryDBManager(); string innerSql = " from vwPRODUCTS_List" + ControlChars.CrLf; oQuery.CommandText = innerSql; CRMSecurity.Filter(oQuery, m_sMODULE, "list"); grdMain.OrderByClause("NAME", "asc"); ctlSearchView.SqlSearchClause(oQuery); Guid gACCOUNT_ID = CommonTypeConvert.ToGuid(Request["ACCOUNT_ID"]); if (!CommonTypeConvert.IsEmptyGuid(gACCOUNT_ID)) { TypeConvert.AppendParameter(oQuery, gACCOUNT_ID, "ACCOUNT_ID"); } oQuery.CommandText = "select " + CommonTypeConvert.FormatSelectFields(arrSelectFields) + oQuery.CommandText + grdMain.OrderByClause(); DataTable dt = oQuery.GetTable(); vwMain = dt.DefaultView; grdMain.DataSource = vwMain; if (!IsPostBack) { grdMain.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { SetPageTitle(Translation.GetTranslation.Term("ProductTemplates.LBL_LIST_FORM_TITLE")); var oQuery = new InlineQueryDBManager(); string innerSql = " from vwPRODUCT_TEMPLATES_List" + ControlChars.CrLf + " where 1 = 1 " + ControlChars.CrLf; oQuery.CommandText = innerSql; if (!IsPostBack) { new DynamicControl(ctlSearchView, "NAME").Text = CommonTypeConvert.ToString(Request["NAME"]); } grdMain.OrderByClause("NAME", "asc"); ctlSearchView.SqlSearchClause(oQuery); oQuery.CommandText = "select " + CommonTypeConvert.FormatSelectFields(arrSelectFields) + oQuery.CommandText + grdMain.OrderByClause(); DataTable dt = oQuery.GetTable(); vwMain = dt.DefaultView; grdMain.DataSource = vwMain; if (!IsPostBack) { grdMain.DataBind(); } }
protected void BindGrid() { string innerSql = "select " + CommonTypeConvert.FormatSelectFields(arrSelectFields) + " from vwINVOICES_ACTIVITIES" + ControlChars.CrLf; var oQuery = new InlineQueryDBManager(); oQuery.CommandText = innerSql; CRMSecurity.Filter(oQuery, m_sMODULE, "list", "ACTIVITY_ASSIGNED_USER_ID"); TypeConvert.AppendParameter(oQuery, gID, "INVOICE_ID"); TypeConvert.AppendParameter(oQuery, true, "IS_OPEN", false); oQuery.CommandText += grdOpen.OrderByClause("DATE_DUE", "desc"); using (DataTable dt = oQuery.GetTable()) { foreach (DataRow row in dt.Rows) { switch (CommonTypeConvert.ToString(row["ACTIVITY_TYPE"])) { case "Calls": row["STATUS"] = Translation.GetTranslation.Term(".call_direction_dom.", row["DIRECTION"]) + " " + Translation.GetTranslation.Term(".call_status_dom.", row["STATUS"]); break; } } vwOpen = new DataView(dt); grdOpen.DataSource = vwOpen; grdOpen.DataBind(); } oQuery.CommandText = innerSql; CRMSecurity.Filter(oQuery, m_sMODULE, "list", "ACTIVITY_ASSIGNED_USER_ID"); TypeConvert.AppendParameter(oQuery, gID, "INVOICE_ID"); TypeConvert.AppendParameter(oQuery, false, "IS_OPEN", false); oQuery.CommandText += grdHistory.OrderByClause("DATE_MODIFIED", "desc"); using (DataTable dt = oQuery.GetTable()) { foreach (DataRow row in dt.Rows) { switch (CommonTypeConvert.ToString(row["ACTIVITY_TYPE"])) { case "Calls": row["STATUS"] = Translation.GetTranslation.Term(".call_direction_dom.", row["DIRECTION"]) + " " + Translation.GetTranslation.Term(".call_status_dom.", row["STATUS"]); break; } } vwHistory = new DataView(dt); grdHistory.DataSource = vwHistory; grdHistory.DataBind(); } }
protected void BindGrid() { var oQuery = new InlineQueryDBManager(); string innerSql = "select " + CommonTypeConvert.FormatSelectFields(arrSelectFields) + " from vwPRODUCT_TEMPLATES_PRODUCT_TEMPLATES" + ControlChars.CrLf + " where 1 = 1 " + ControlChars.CrLf; oQuery.CommandText = innerSql; TypeConvert.AppendParameter(oQuery, gID, "PRODUCT_TEMPLATE_ID"); oQuery.CommandText += grdMain.OrderByClause("DATE_ENTERED", "desc"); DataTable dt = oQuery.GetTable(); vwMain = dt.DefaultView; grdMain.DataSource = vwMain; grdMain.DataBind(); }
protected void BindGrid() { string innerSql = "select " + CommonTypeConvert.FormatSelectFields(arrSelectFields) + " from vwINVOICES_PAYMENTS" + ControlChars.CrLf; var oQuery = new InlineQueryDBManager(); oQuery.CommandText = innerSql; CRMSecurity.Filter(oQuery, m_sMODULE, "list"); TypeConvert.AppendParameter(oQuery, gID, "INVOICE_ID"); oQuery.CommandText += grdMain.OrderByClause("DATE_ENTERED", "desc"); using (DataTable dt = oQuery.GetTable()) { vwMain = dt.DefaultView; grdMain.DataSource = vwMain; grdMain.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { SetPageTitle(Translation.GetTranslation.Term(m_sMODULE + ".LBL_LIST_FORM_TITLE")); string innerSql = " from vwPAYMENTS_List" + ControlChars.CrLf; var oQuery = new InlineQueryDBManager(); oQuery.CommandText = innerSql; CRMSecurity.Filter(oQuery, m_sMODULE, "list"); grdMain.OrderByClause("PAYMENT_DATE", "desc"); ctlSearchView.SqlSearchClause(oQuery); oQuery.CommandText = "select " + CommonTypeConvert.FormatSelectFields(arrSelectFields) + oQuery.CommandText + grdMain.OrderByClause(); DataTable dt = oQuery.GetTable(); vwMain = dt.DefaultView; grdMain.DataSource = vwMain; if (!IsPostBack) { grdMain.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { SetPageTitle(Translation.GetTranslation.Term(m_sMODULE + ".LBL_LIST_FORM_TITLE")); Visible = (Security.GetUserAccess(m_sMODULE, "list") >= 0); if (!Visible) { return; } if (IsMobile && grdMain.Columns.Count > 0) { grdMain.Columns[0].Visible = false; } string innerSql = " from vwINVOICES_List" + ControlChars.CrLf; var oQuery = new InlineQueryDBManager(); oQuery.CommandText = innerSql; CRMSecurity.Filter(oQuery, m_sMODULE, "list"); grdMain.OrderByClause("NAME", "asc"); ctlSearchView.SqlSearchClause(oQuery); oQuery.CommandText = "select " + (Request.Form[ctlExportHeader.ExportUniqueID] != null ? "*" : CommonTypeConvert.FormatSelectFields(arrSelectFields)) + oQuery.CommandText + grdMain.OrderByClause(); using (DataTable dt = oQuery.GetTable()) { vwMain = dt.DefaultView; grdMain.DataSource = vwMain; if (!IsPostBack) { grdMain.DataBind(); } } }
protected void BindGrid() { var oQuery = new InlineQueryDBManager(); string innerSql = ApplicationSQL.SQL["Products_relatedProducts_58"].ToString(); oQuery.CommandText = innerSql; oQuery.Add("@ID", SqlDbType.UniqueIdentifier, gID); gACCOUNT_ID = CommonTypeConvert.ToGuid(oQuery.ExecuteScalar()); innerSql = "select " + CommonTypeConvert.FormatSelectFields(arrSelectFields) + " from vwPRODUCTS_RELATED_PRODUCTS" + ControlChars.CrLf + " where 1 = 1 " + ControlChars.CrLf; oQuery.CommandText = innerSql; TypeConvert.AppendParameter(oQuery, gID, "PARENT_ID"); oQuery.CommandText += grdMain.OrderByClause("DATE_ENTERED", "desc"); DataTable dt = oQuery.GetTable(); vwMain = dt.DefaultView; grdMain.DataSource = vwMain; grdMain.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { SetPageTitle(Translation.GetTranslation.Term(m_sMODULE + ".LBL_LIST_FORM_TITLE")); Visible = (Security.GetUserAccess(m_sMODULE, "list") >= 0); if (!Visible) { return; } var oQuery = new InlineQueryDBManager(); string innerSql = " from vwPRODUCT_TEMPLATES_List" + ControlChars.CrLf + " where 1 = 1 " + ControlChars.CrLf; oQuery.CommandText = innerSql; int nACLACCESS = Security.GetUserAccess(m_sMODULE, "list"); if (nACLACCESS == ACL_ACCESS.OWNER) { TypeConvert.AppendParameter(oQuery, Security.USER_ID, "ASSIGNED_USER_ID", false); } grdMain.OrderByClause("NAME", "asc"); ctlSearchView.SqlSearchClause(oQuery); oQuery.CommandText = "select " + (Request.Form[ctlExportHeader.ExportUniqueID] != null ? "*" : CommonTypeConvert.FormatSelectFields(arrSelectFields)) + oQuery.CommandText + grdMain.OrderByClause(); DataTable dt = oQuery.GetTable(); vwMain = dt.DefaultView; grdMain.DataSource = vwMain; if (!IsPostBack) { grdMain.DataBind(); } }