private BestRow NewRow()
{
BestRow brow = new BestRow();
brow.bestTable = this;
brow.IsNew = true;
brow.Fields = CopyFields();
return brow;
}
private void ConstructRow(BestRow brow, OleDbDataReader objDataReader)
{
brow.IsNew = false;
for (int i = 0; i < brow.Fields.Count; i++ )
{
if (brow.Fields[i].fieldType.Equals("System.Byte"))
{
brow.Fields[i].fieldValue = objDataReader[brow.Fields[i].fieldName].ToString().Equals("True")?"1":"0";
brow.Fields[i].OldValue = brow.Fields[i].fieldValue;
}
else
{
brow.Fields[i].fieldValue = objDataReader[brow.Fields[i].fieldName].ToString();
brow.Fields[i].OldValue = brow.Fields[i].fieldValue;
}
}
}
/* 4. Make Data Rows */
private string RowHTML(int rownum, BestRow brow, string srclass)
{
StringBuilder sb = new StringBuilder();
sb.Append("<tr" + srclass + ">");
for (int i = 0; i < brow.Fields.Count; i++)
{
if (brow.Fields[i].displayField)
{
sb.Append("<td>");
if (brow.Fields[i].displayFormatFunc != null)
{
sb.Append(brow.Fields[i].displayFormatFunc.Invoke(brow));
}
else
{
sb.Append(HttpUtility.HtmlEncode(brow.Fields[i].fieldValue));
}
string htmlname = "Field" + rownum.ToString() + "_" + i.ToString();
/*
* sb.Append("<input type=\"hidden\" id=\"" + htmlname + "\" name=\"" + htmlname + "\" value=\"" + HttpUtility.HtmlEncode(brow.Fields[i].fieldValue) + "\" />");
*/
sb.Append("</td>" + '\n');
}
}
sb.Append("<td>");
if (GridTable.allowEdit && this.allowEdit)
{
sb.Append("<a href=\"javascript:void(0);\" onclick=\"editForm('" + rownum.ToString() + "');\"><img alt=\"edit\" style=\"border:0px;\" src=\"images/gridedit.png\" title=\"edit the record\" /></a> ");
}
if (GridTable.allowDelete && this.allowDelete)
{
sb.Append("<a href=\"javascript:void(0);\" onclick=\"BestJSGrid.deleteRec('" + brow.Fields["guidfield"].fieldValue + "');\"><img src=\"images/cancel.png\" style=\"border:0px;\" alt=\"delete\" title=\"delete the record\" /></a></td>");
}
if (!string.IsNullOrEmpty(this.extraRowHTML))
{
string replExtraHTML = extraRowHTML.Replace("[paramGuid]", HttpUtility.UrlEncode(brow.Fields["guidfield"].fieldValue));
replExtraHTML = replExtraHTML.Replace("[paramCID]", HttpUtility.UrlEncode(brow.Fields["CenterId"].fieldValue));
replExtraHTML = replExtraHTML.Replace("[paramSID]", HttpUtility.UrlEncode(brow.Fields["StudentId"].fieldValue));
replExtraHTML = replExtraHTML.Replace("[paramRowNum]", HttpUtility.UrlEncode(rownum.ToString()));
sb.Append("<td>" + replExtraHTML + "</td>");
}
sb.Append("</tr>");
return sb.ToString();
}
public void Add(BestRow field)
{
Rows.Add(field);
}
private string ReplaceSchedule(BestRow bs, string sample, int idx, int schId)
{
string result = sample;
result = result.Replace("[paramSchGuid]", bs.Fields["guidfield"].fieldValue);
result = result.Replace("[paramStuGuid1]", bs.Fields["stuGuid1"].fieldValue??"");
result = result.Replace("[paramStuGuid2]", bs.Fields["stuGuid2"].fieldValue??"");
result = result.Replace("[paramStuGuid3]", bs.Fields["stuGuid3"].fieldValue??"");
result = result.Replace("[paramStuGuid4]", bs.Fields["stuGuid4"].fieldValue??"");
result = result.Replace("[paramStuGuid5]", bs.Fields["stuGuid5"].fieldValue??"");
result = result.Replace("[paramTutGuid]", bs.Fields["tutGuid"].fieldValue??"");
result = result.Replace("[paramSchDate]", bs.Fields["schDate"].fieldValue ?? "");
result = result.Replace("[paramSchFrom]", bs.Fields["schFrom"].fieldValue ?? "");
result = result.Replace("[paramSchTo]", bs.Fields["schTo"].fieldValue ?? "");
result = result.Replace("[paramIndex]", idx.ToString());
string isdeleted = bs.Fields["isDeleted"].fieldValue??"";
result = result.Replace("[paramIsDel]", isdeleted);
result = result.Replace("[paramSchId]", schId.ToString());
result = result.Replace("[paramAttend0]", bs.Fields["attended1"].fieldValue);
result = result.Replace("[paramAttend1]", bs.Fields["attended2"].fieldValue);
result = result.Replace("[paramAttend2]", bs.Fields["attended3"].fieldValue);
result = result.Replace("[paramAttend3]", bs.Fields["attended4"].fieldValue);
result = result.Replace("[paramAttend4]", bs.Fields["attended5"].fieldValue);
result = result.Replace("[paramNote0]", bs.Fields["note1"].fieldValue ?? "");
result = result.Replace("[paramNote1]", bs.Fields["note2"].fieldValue ?? "");
result = result.Replace("[paramNote2]", bs.Fields["note3"].fieldValue ?? "");
result = result.Replace("[paramNote3]", bs.Fields["note4"].fieldValue ?? "");
result = result.Replace("[paramNote4]", bs.Fields["note5"].fieldValue ?? "");
result = result.Replace("[paramprogGuid1]", bs.Fields["progGuid1"].fieldValue ?? "");
result = result.Replace("[paramprogGuid2]", bs.Fields["progGuid2"].fieldValue ?? "");
result = result.Replace("[paramprogGuid3]", bs.Fields["progGuid3"].fieldValue ?? "");
result = result.Replace("[paramprogGuid4]", bs.Fields["progGuid4"].fieldValue ?? "");
result = result.Replace("[paramprogGuid5]", bs.Fields["progGuid5"].fieldValue ?? "");
return result;
}
