/// <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());
}
}
