protected void ApprovalLine1_OnLoad(object sender, EventArgs e) { LinqDataSource LinqDataSourceApprovalList = ApprovalLine1.GetSqlDataSourceApprovalList(); if (LinqDataSourceApprovalList != null) { LinqDataSourceApprovalList.WhereParameters.Clear(); LinqDataSourceApprovalList.WhereParameters.Add("MenuSeqId", DbType.Int32, Id.ToString()); LinqDataSourceApprovalList.WhereParameters.Add("ApproveType", DbType.Int32, ((int)CConstValue.Approval.Hire).ToString()); LinqDataSourceApprovalList.Where = "MenuSeqId == @MenuSeqId AND ApproveType == @ApproveType"; } }
private void SetApprovalList() { LinqDataSource LinqDataSourceApprovalList = ApprovalLine1.GetSqlDataSourceApprovalList(); if (LinqDataSourceApprovalList != null) { LinqDataSourceApprovalList.WhereParameters.Clear(); if (RadGridAgency.SelectedValue != null) { LinqDataSourceApprovalList.WhereParameters.Add("MenuSeqId", DbType.Int32, RadGridAgency.SelectedValue.ToString()); } else { LinqDataSourceApprovalList.WhereParameters.Add("MenuSeqId", DbType.Int32, "0"); } LinqDataSourceApprovalList.WhereParameters.Add("ApproveType", DbType.Int32, ((int)CConstValue.Approval.Agency).ToString()); LinqDataSourceApprovalList.Where = "ApproveType == @ApproveType and MenuSeqId == @MenuSeqId"; } }
private void RefreshApprovalList() { LinqDataSource LinqDataSourceApprovalList = ApprovalLine1.GetSqlDataSourceApprovalList(); if (LinqDataSourceApprovalList != null) { LinqDataSourceApprovalList.WhereParameters.Clear(); if (RadGridRefund.SelectedValue == null) { LinqDataSourceApprovalList.WhereParameters.Add("MenuSeqId", DbType.Int32, "0"); } else { LinqDataSourceApprovalList.WhereParameters.Add("MenuSeqId", DbType.Int32, RadGridRefund.SelectedValue.ToString()); } LinqDataSourceApprovalList.WhereParameters.Add("ApproveType", DbType.Int32, ((int)CConstValue.Approval.Refund).ToString()); LinqDataSourceApprovalList.Where = "MenuSeqId == @MenuSeqId AND ApproveType == @ApproveType"; } }