/// <summary> /// Return a display version of the value. /// String = as is /// Bool = yes/no /// Date = formatted /// Foreign key = lookup field and get name using GetName() /// </summary> /// <returns></returns> public string ToStringNice() { string displayText = ""; if (IsForeignKey) { var lookup = GetForeignRecord(); if (lookup != null) { displayText = lookup.GetName(); } } else if (IsBooleanField) { displayText = Fmt.YesNo(ValueObject.ToBool()); } else if (IsNumericField) { displayText = Fmt.Number(ValueObject, DecimalPlaces ?? -1, true); } else { displayText = ToString(); } return(displayText); }
public static void ExportToExcel(Sql sql, string filename) { StringBuilder allData = new StringBuilder(); var reader = sql.GetReader(); if (!reader.HasRows) { allData.AppendLine("No records"); } else { // write field titles string str = ""; for (int scan = 0; scan < reader.VisibleFieldCount; scan++) { str += "\t" + Fmt.SplitTitleCase(reader.GetName(scan)); } allData.AppendLine(str.Trim()); foreach (DbDataRecord row in reader) { // write field values str = ""; for (int scan = 0; scan < reader.VisibleFieldCount; scan++) { string val = ""; var datatype = reader.GetDataTypeName(scan).ToLower(); if (datatype == "datetime") { if (row[scan].ToString().IsNotBlank()) { val = Fmt.DateTime((DateTime)row[scan]); } } else if (datatype == "bit") { if (row[scan].ToString().IsNotBlank()) { val = Fmt.YesNo(("" + row[scan]).ToLower()); } } else { val = row[scan].ToString(); } str += "\t" + TsvCleanup(val); } allData.AppendLine(str.Trim()); } } reader.Close(); reader.Dispose(); ExportToExcel(allData.ToString(), filename); }
public string OriginalValueToStringNice() { string displayText = ""; if (IsForeignKey) { displayText = null; } else if (IsBooleanField) { displayText = Fmt.YesNo(OriginalValueObject.ToBool()); } else if (IsNumericField) { displayText = Fmt.Number(OriginalValueObject, DecimalPlaces ?? -1, true); } else { displayText = OriginalValueToString(); } return(displayText); }
protected void GetData(int Rno, int iCol) { string Sql = string.Format( "Select c.* " + "From Customers c " + "Where CustomerRno = {0}", Rno); try { DataRow dr = db.DataRow(Sql); if (dr != null) { switch (iCol) { case 1: hfRno1.Value = Rno.ToString(); lblRno1.Text = Rno.ToString(); rdoName1.Text = DB.Str(dr["Name"]); rdoTaxExempt1.Text = Fmt.YesNo(DB.Bool(dr["TaxExemptFlg"])); rdoCompany1.Text = Fmt.YesNo(DB.Bool(dr["CompanyFlg"])); rdoOnlineOrder1.Text = Fmt.YesNo(DB.Bool(dr["OnlineOrderFlg"])); rdoEmailConf1.Text = Fmt.YesNo(DB.Bool(dr["EmailConfirmationsFlg"])); rdoSignedBy1.Text = Fmt.YesNo(DB.Bool(dr["AnnualContractSignedName"])); rdoSigned1.Text = Fmt.YesNo(DB.Bool(dr["AnnualContractSignedDtTm"])); txtCreatedDt1.Text = Fmt.DtTm(DB.DtTm(dr["CreatedDtTm"])); txtCreatedUser1.Text = DB.Str(dr["CreatedUser"]); txtUpdatedDt1.Text = Fmt.DtTm(DB.DtTm(dr["UpdatedDtTm"])); txtUpdatedUser1.Text = DB.Str(dr["UpdatedUser"]); rdoName1.Checked = rdoTaxExempt1.Checked = rdoCompany1.Checked = rdoOnlineOrder1.Checked = rdoEmailConf1.Checked = rdoSignedBy1.Checked = rdoSigned1.Checked = true; FocusField = "rdoName1"; break; case 2: if (Rno.ToString() != lblRno1.Text) { hfRno2.Value = Rno.ToString(); lblRno2.Text = Rno.ToString(); rdoName2.Text = DB.Str(dr["Name"]); rdoTaxExempt1.Text = Fmt.YesNo(DB.Bool(dr["TaxExemptFlg"])); rdoCompany1.Text = Fmt.YesNo(DB.Bool(dr["CompanyFlg"])); rdoOnlineOrder1.Text = Fmt.YesNo(DB.Bool(dr["OnlineOrderFlg"])); rdoEmailConf1.Text = Fmt.YesNo(DB.Bool(dr["EmailConfirmationsFlg"])); rdoSignedBy1.Text = Fmt.YesNo(DB.Bool(dr["AnnualContractSignedName"])); rdoSigned1.Text = Fmt.YesNo(DB.Bool(dr["AnnualContractSignedDtTm"])); txtCreatedDt2.Text = Fmt.DtTm(DB.DtTm(dr["CreatedDtTm"])); txtCreatedUser2.Text = DB.Str(dr["CreatedUser"]); txtUpdatedDt2.Text = Fmt.DtTm(DB.DtTm(dr["UpdatedDtTm"])); txtUpdatedUser2.Text = DB.Str(dr["UpdatedUser"]); if (rdoName1.Text.Length == 0 && rdoName2.Text.Length > 0) { rdoName2.Checked = true; } if (rdoTaxExempt1.Text.Length == 0 && rdoTaxExempt2.Text.Length > 0) { rdoTaxExempt2.Checked = true; } if (rdoCompany1.Text.Length == 0 && rdoCompany2.Text.Length > 0) { rdoCompany2.Checked = true; } if (rdoOnlineOrder1.Text.Length == 0 && rdoOnlineOrder2.Text.Length > 0) { rdoOnlineOrder1.Checked = true; } if (rdoEmailConf1.Text.Length == 0 && rdoEmailConf2.Text.Length > 0) { rdoEmailConf2.Checked = true; } if (rdoSignedBy1.Text.Length == 0 && rdoSignedBy2.Text.Length > 0) { rdoSignedBy2.Checked = true; } if (rdoSigned1.Text.Length == 0 && rdoSigned2.Text.Length > 0) { rdoSigned2.Checked = true; } FocusField = "rdoName2"; } break; } } } catch (Exception Ex) { Err Err = new Err(Ex, Sql); Response.Write(Err.Html()); } }