private void UserColumn(GridView gridView) { bool defaultValue = false; LPWeb.Model.UserPipelineColumns modUPC = null; try { if (_curLoginUser != null) { modUPC = _bllUPC.GetModel(_curLoginUser.iUserID); } } catch (Exception exception) { LPLog.LogMessage(exception.Message); } gridView.Columns[3].Visible = modUPC == null ? !defaultValue : modUPC.PercentCompl; gridView.Columns[4].Visible = modUPC == null ? !defaultValue : modUPC.EstimatedClose; //5 alert icon gridView.Columns[6].Visible = modUPC == null ? !defaultValue : modUPC.LoanOfficer; gridView.Columns[7].Visible = modUPC == null ? !defaultValue : modUPC.Amount; gridView.Columns[8].Visible = modUPC == null ? !defaultValue : modUPC.Lien; gridView.Columns[9].Visible = modUPC == null ? !defaultValue : modUPC.Rate; gridView.Columns[10].Visible = modUPC == null ? defaultValue : modUPC.Lender; gridView.Columns[11].Visible = modUPC == null ? defaultValue : modUPC.LockExp; gridView.Columns[12].Visible = modUPC == null ? defaultValue : modUPC.Branch; gridView.Columns[13].Visible = modUPC == null ? defaultValue : modUPC.Processor; gridView.Columns[14].Visible = modUPC == null ? defaultValue : modUPC.TaskCount; gridView.Columns[15].Visible = modUPC == null ? defaultValue : modUPC.PointFolder; gridView.Columns[16].Visible = modUPC == null ? defaultValue : modUPC.PointFileName; }
/// <summary> /// 更新一条数据 /// </summary> public void Update(LPWeb.Model.UserPipelineColumns model) { dal.Update(model); }
/// <summary> /// 获得数据列表 /// </summary> public List <LPWeb.Model.UserPipelineColumns> DataTableToList(DataTable dt) { List <LPWeb.Model.UserPipelineColumns> modelList = new List <LPWeb.Model.UserPipelineColumns>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { LPWeb.Model.UserPipelineColumns model; for (int n = 0; n < rowsCount; n++) { model = new LPWeb.Model.UserPipelineColumns(); if (dt.Rows[n]["UserId"].ToString() != "") { model.UserId = int.Parse(dt.Rows[n]["UserId"].ToString()); } if (dt.Rows[n]["PointFolder"].ToString() != "") { if ((dt.Rows[n]["PointFolder"].ToString() == "1") || (dt.Rows[n]["PointFolder"].ToString().ToLower() == "true")) { model.PointFolder = true; } else { model.PointFolder = false; } } if (dt.Rows[n]["Stage"].ToString() != "") { if ((dt.Rows[n]["Stage"].ToString() == "1") || (dt.Rows[n]["Stage"].ToString().ToLower() == "true")) { model.Stage = true; } else { model.Stage = false; } } if (dt.Rows[n]["Branch"].ToString() != "") { if ((dt.Rows[n]["Branch"].ToString() == "1") || (dt.Rows[n]["Branch"].ToString().ToLower() == "true")) { model.Branch = true; } else { model.Branch = false; } } if (dt.Rows[n]["EstimatedClose"].ToString() != "") { if ((dt.Rows[n]["EstimatedClose"].ToString() == "1") || (dt.Rows[n]["EstimatedClose"].ToString().ToLower() == "true")) { model.EstimatedClose = true; } else { model.EstimatedClose = false; } } if (dt.Rows[n]["Alerts"].ToString() != "") { if ((dt.Rows[n]["Alerts"].ToString() == "1") || (dt.Rows[n]["Alerts"].ToString().ToLower() == "true")) { model.Alerts = true; } else { model.Alerts = false; } } if (dt.Rows[n]["LoanOfficer"].ToString() != "") { if ((dt.Rows[n]["LoanOfficer"].ToString() == "1") || (dt.Rows[n]["LoanOfficer"].ToString().ToLower() == "true")) { model.LoanOfficer = true; } else { model.LoanOfficer = false; } } if (dt.Rows[n]["Amount"].ToString() != "") { if ((dt.Rows[n]["Amount"].ToString() == "1") || (dt.Rows[n]["Amount"].ToString().ToLower() == "true")) { model.Amount = true; } else { model.Amount = false; } } if (dt.Rows[n]["Lien"].ToString() != "") { if ((dt.Rows[n]["Lien"].ToString() == "1") || (dt.Rows[n]["Lien"].ToString().ToLower() == "true")) { model.Lien = true; } else { model.Lien = false; } } if (dt.Rows[n]["Rate"].ToString() != "") { if ((dt.Rows[n]["Rate"].ToString() == "1") || (dt.Rows[n]["Rate"].ToString().ToLower() == "true")) { model.Rate = true; } else { model.Rate = false; } } if (dt.Rows[n]["Lender"].ToString() != "") { if ((dt.Rows[n]["Lender"].ToString() == "1") || (dt.Rows[n]["Lender"].ToString().ToLower() == "true")) { model.Lender = true; } else { model.Lender = false; } } if (dt.Rows[n]["LockExp"].ToString() != "") { if ((dt.Rows[n]["LockExp"].ToString() == "1") || (dt.Rows[n]["LockExp"].ToString().ToLower() == "true")) { model.LockExp = true; } else { model.LockExp = false; } } if (dt.Rows[n]["PercentCompl"].ToString() != "") { if ((dt.Rows[n]["PercentCompl"].ToString() == "1") || (dt.Rows[n]["PercentCompl"].ToString().ToLower() == "true")) { model.PercentCompl = true; } else { model.PercentCompl = false; } } if (dt.Rows[n]["Processor"].ToString() != "") { if ((dt.Rows[n]["Processor"].ToString() == "1") || (dt.Rows[n]["Processor"].ToString().ToLower() == "true")) { model.Processor = true; } else { model.Processor = false; } } if (dt.Rows[n]["TaskCount"].ToString() != "") { if ((dt.Rows[n]["TaskCount"].ToString() == "1") || (dt.Rows[n]["TaskCount"].ToString().ToLower() == "true")) { model.TaskCount = true; } else { model.TaskCount = false; } } if (dt.Rows[n]["PointFileName"].ToString() != "") { if ((dt.Rows[n]["PointFileName"].ToString() == "1") || (dt.Rows[n]["PointFileName"].ToString().ToLower() == "true")) { model.PointFileName = true; } else { model.PointFileName = false; } } //model.LastLoanNote = false; //if (dt.Rows[n]["LastLoanNote"].ToString() != "") //{ // if ((dt.Rows[n]["LastLoanNote"].ToString() == "1") || (dt.Rows[n]["LastLoanNote"].ToString().ToLower() == "true")) // { // model.PointFileName = true; // } // else // { // model.PointFileName = false; // } //} modelList.Add(model); } } return(modelList); }
/// <summary> /// 增加一条数据 /// </summary> public void Add(LPWeb.Model.UserPipelineColumns model) { dal.Add(model); }