string CreateHTMLForAYear(DataRowView row, int count, ref bool fFirst)
{
string s = "";
string u = "'Months.aspx?ay=" + row["AlbumYear"] + "'";
string img = (string)row["AlbumPhoto"];
string alignleft = "";
string fontsz = "x-large";
string fontsz1 = "x-small";
if (fFirst)
{
img = img.Replace("_s.jpg", ".jpg");
fFirst = false;
alignleft = "float:left; width:500; ";
fontsz = "xx-large";
fontsz1 = "small";
}
s += "<table style='cursor:pointer; display:inline; vertical-align:top; " + alignleft + "margin:10px' onclick=donavigate(" + u + ")><tr><td>";
s += "<span style='background:green; display:inline'><img style='margin:0px' src='" + img + "'></span> ";
s += "</td></tr><tr><td style='text-align:right; font-size:" + fontsz + "'>";
s += row["AlbumYear"];
s += "<br><span style='font-size:" + fontsz1 + "'>(" + count + ")</span>";
s += "</td></tr></table>";
return s;
}
/// <summary>
/// Handles the RowDataBound event of the LeadMarketing control.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="System.Web.UI.WebControls.GridViewRowEventArgs"/> instance containing the event data.</param>
protected void LeadMarketing_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
LinkButton deleteCommand = (LinkButton)e.Row.Cells[2].Controls[0];
LinkButton removeCommand = (LinkButton)e.Row.Cells[3].Controls[0];
System.Data.DataRowView row = (System.Data.DataRowView)e.Row.DataItem;
deleteCommand.Enabled = !String.IsNullOrEmpty(row["ResponseId"].ToString());
if (deleteCommand.Enabled)
{
deleteCommand.Attributes.Add("onclick",
"javascript: return confirm('" +
GetLocalResourceObject("ConfirmMessage_DeleteResponse") + "');");
}
else
{
e.Row.Cells[2].ForeColor = System.Drawing.Color.Gray;
}
removeCommand.Enabled = !row["Status"].ToString().Equals(GetLocalResourceObject("TargetStatus_Removed").ToString());
if (removeCommand.Enabled)
{
removeCommand.Attributes.Add("onclick",
"javascript: return confirm('" +
String.Format(
GetLocalResourceObject("ConfirmMessage_RemoveTargetAssociation").
ToString(), e.Row.Cells[4].Text) + "');");
}
else
{
e.Row.Cells[3].ForeColor = System.Drawing.Color.Gray;
}
}
}
/// <summary>
/// 设置单据编号
/// </summary>
/// <param name="formid"></param>
/// <param name="drv"></param>
public static void GetBillNo(int formid, DataRowView drv)
{
try
{
string tablename = "";
string fieldname = "";
string prefix = "";
string datetype = "";
string serialtype = "";
string sSQL = "SELECT * FROM sysBillNoSet WHERE iFormID=" + formid.ToString();
DataTable dtTemp = BWS.ERP.DataAccess.DbHelperSQL.Query(sSQL).Tables[0];
if (dtTemp != null && dtTemp.Rows.Count > 0)
{
tablename = dtTemp.Rows[0]["sTableName"].ToString();
fieldname = dtTemp.Rows[0]["sFieldName"].ToString();
prefix = dtTemp.Rows[0]["sPrefix"].ToString();
datetype = dtTemp.Rows[0]["sDateType"].ToString();
serialtype = dtTemp.Rows[0]["sSerialType"].ToString();
}
if (tablename != "" && fieldname != "" && datetype != "" && serialtype != "")
{
drv[fieldname] = GetBillNo(tablename, fieldname, prefix, datetype, serialtype);
}
}
catch (Exception)
{
throw;
}
}
public DataValidator(DataRowView rv)
{
Debug.Assert(rv != null);
m_rv = rv;
m_tables = new List<DataTable>();
Hook(rv);
}
//----------------------------------------
protected override void OnRowValidating(DataRowView row)
{
if (m_trainingLayer > 0)
row.Row[NetworkDatabase.ColumnTrainingLayerId] = m_trainingLayer;
base.OnRowValidating(row);
}
public bool Find(DateTime frDate, DateTime toDate, bool ShowSelectionIfNotFound)
{
try
{
selectedDataRow = null;
InvoiceSource.Filter = "";
this.invoiceTableAdapter.FilByDateRange(this.myMasterDataSet.Invoice, frDate, toDate);
if (this.myMasterDataSet.Invoice.Rows.Count == 1)
{
selectedDataRow = ((DataRowView)InvoiceSource.Current);
return true;
}
if (!ShowSelectionIfNotFound) return false;
LoadDataOnShow = false;
LoadData(); DoFilter();
this.ShowDialog();
LoadDataOnShow = true;
return (this.selectedDataRow != null);
}
catch (Exception er)
{
commonLibs.sysLibs.ShowErrorMessage(er.Message);
}
return false;
}
private void button2_Click(object sender, RoutedEventArgs e)
{//버튼1
//if btn.content == 문서1 이라면 안하고
//else 실행
if (!tb1Text.Text.Equals(""))
{
string qeury = "select * from dbo.secmem_board_extra_ssm_project where ex_pr_name =N'" + tb1Text.Text + "'";
SqlDataAdapter adapter = new SqlDataAdapter(qeury, App.scon);
SqlCommandBuilder builder = new SqlCommandBuilder(adapter);
adapter.Fill(dt);
DataView view = new DataView(dt);
foreach (DataRowView drv in view)
{
d = drv;
break;
}
AssignmentPage newRPpage1 = new AssignmentPage(d);
Main.pageNavigation.preClear();
Main.pageNavigation.backClear();
Main.ft.Send("CLIENT_TECHNOLOGY\a" + d.Row[0]);
Main.pageFade.ShowPage(newRPpage1);
}
}
public void ChangeTableType(DataRowView rowView,int type)
{
systemDataSetTableAdapters.tablesTableAdapter tables = new systemDataSetTableAdapters.tablesTableAdapter();
DataRow row = rowView.Row;
row["type_id"] = type;
tables.Update(row);
}
private static void SerializeRow(DataTable dataTable, DataRowView row, Dictionary<string, object> owner)
{
foreach (DataColumn column in dataTable.Columns)
{
owner.Add(column.ColumnName, row.Row.Field<object>(column.ColumnName));
}
}
public Listare( DataRowView[] candidats )
{
InitializeComponent();
_destPath = null;
currentDoc.Name = null;
currentDoc.Path = null;
_candidats = candidats;
_docs = new Dictionary<string, string>();
DataTable dt = new DataTable();
try
{
dt = DAL.getInstance().select(DAL.baseQuerys.SDOCUMENT);
if (dt != null)
{
_docs = dt.AsEnumerable()
.ToDictionary<DataRow, string, string>(row => row.Field<string>(1),
row => row.Field<string>(2));
foreach(string key in _docs.Keys){
Console.WriteLine(key);
comboDocument.Items.Add(key);
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
protected void nextButton_Click(object sender, EventArgs e)
{
System.Data.DataRowView dr = (System.Data.DataRowView)questionDetails.DataItem;
Answer a = new Answer();
a.QuestionID = dr["QuestionOrder"].ToString();
a.CorrectAnswer = dr["CorrectAnswer"].ToString();
a.UserAnswer = ddlAnswer.SelectedValue.ToString();
ArrayList al = (ArrayList)Session["AnswerList"];
al.Add(a);
Session.Add("AnswerList", al);
if (questionDetails.PageIndex == questionDetails.PageCount - 1)
{
Response.Redirect("Results.aspx");
}
else
{
questionDetails.PageIndex++;
}
if (questionDetails.PageIndex == questionDetails.PageCount - 1)
{
btnNext.Text = "Finished";
}
}
public bool Find(string code, bool ShowSelectionIfNotFound)
{
try
{
selectedDataRow = null;
projectsSource.Filter = "";
code = code.Trim();
bool haveMarker = common.system.HaveFindMarker(ref code);
if (!haveMarker && code != "")
{
this.myBaseDS.emProject.Clear();
application.dataLibs.LoadData(this.myBaseDS.emProject, code);
if (this.myBaseDS.emProject.Count > 0)
{
selectedDataRow = ((DataRowView)projectsSource.Current);
return true;
}
if (!ShowSelectionIfNotFound) return false;
}
LoadData();
this.ShowDialog();
return (this.selectedDataRow != null);
}
catch (Exception er)
{
common.system.ShowErrorMessage(er.Message);
}
return false;
}
public RelatedView(DataRowView parentRowView, DataKey parentKey, DataColumn[] childKeyColumns) : base(childKeyColumns[0].Table, false) {
this.filterValues = null;
this.parentRowView = parentRowView;
this.parentKey = parentKey;
this.childKey = new DataKey(childKeyColumns, true);
Debug.Assert (this.Table == childKey.Table, "Key.Table Must be equal to Current Table");
base.ResetRowViewCache();
}
/// <summary>
/// Sets all DataRow values to document values
/// </summary>
/// <param name="dataRowView">data row containing the document values</param>
/// <param name="prefix">add prefix to name</param>
public void SetDataRowValuesToDocumentValues(DataRowView dataRowView, string prefix)
{
if (prefix == null) prefix = "";
foreach (DataColumn column in dataRowView.Row.Table.Columns)
{
_reportDocumentValues[prefix + column.ColumnName] = dataRowView.Row[column];
}
}
public static void EditarDT(DataRowView vistaFilaActual, Ventas entidad)
{
vistaFilaActual.BeginEdit();
vistaFilaActual["IdPCVEN"] = entidad.IdPc.ToString();
vistaFilaActual["FechaMSTK"] = entidad.Fecha.ToString();
vistaFilaActual["IdClienteVEN"] = entidad.IdCliente.ToString();
vistaFilaActual.EndEdit();
}
public static DataRowView FindRelatedRow(DataRowView rv, String relatedName, String column, String relatedColumn)
{
DataView relatedView = rv.DataView.Table.DataSet.Tables[relatedName].DefaultView;
Debug.Assert(relatedView != null);
PropertyDescriptor relatedProperty = GetProperty(relatedView, relatedColumn);
Debug.Assert(relatedProperty != null);
return BindingListUtils.FindItem<DataRowView>(relatedView, relatedProperty, rv[column]);
}
public static DataRowView[] FindRelatedRows(DataRowView rv, String relatedName, String propertyParent, String propertyChild)
{
DataView relatedView = rv.DataView.Table.DataSet.Tables[relatedName].DefaultView;
Debug.Assert(relatedView != null);
PropertyDescriptor property = GetProperty(relatedView, propertyChild);
Debug.Assert(property != null);
return BindingListUtils.FindItems<DataRowView>(relatedView, property, rv[propertyParent]);
}
public MeaningValidator(DataRowView rv)
: base(rv)
{
Hook(AdoUtils.GetDataView(rv, Strings.TRANSLATIONS));
Hook(AdoUtils.GetDataView(rv, Strings.SYNONYMS));
Hook(AdoUtils.GetDataView(rv, Strings.ANTONYMS));
Validate();
}
/// <summary>
/// указан текст Входы для отслеживания состояния сетке данных.
/// Это должно позволить пользователю редактировать записи.
/// сбрасывает DataBindings и BackColor.
/// необходимо сбросить управления, так как мы повторно использовать их.
/// </summary>
/// <param name="rowview"></param>
public void ReBindControlsToDataRow(DataRowView rowview)
{
var columns = rowview.DataView.Table.Columns;
for (int i = 0; i < TextInputs.Count; i++)
{
TextInputs[i].UnbindFromData();
TextInputs[i].BindToDataRowView(rowview, columns[i].ColumnName);
}
}
protected string FormatMessage(DataRowView row)
{
string msg = row["Message"].ToString();
if(msg.IndexOf('<')>=0)
return msg;
return FormatMsg.ForumCodeToHtml(this,row["Message"].ToString());
}
private void StreamDG_CellEditEnding(object sender, DataGridCellEditEndingEventArgs e)
{
DataRowView rowView = e.Row.Item as DataRowView;
rowBeingEdited = rowView;
if (e.Column is DataGridTemplateColumn)
{
BindingOperations.ClearAllBindings(e.EditingElement as ContentPresenter);
}
}
public Incident(DataRowView data)
{
this.CustomerID = Int32.Parse(data[1].ToString());
this.IncidentID = Int32.Parse(data[0].ToString());
this.TechId = Int32.Parse(data[3].ToString());
this.DateOpened = DateTime.Parse(data[5].ToString());
this.DateClosed= DateTime.Parse(data[4].ToString());
this.ProductCode = data[2].ToString();
this.Title = data[6].ToString();
}
public Wizard(Form form, String fileName, String yearMonth, DataRowView excelRow)
{
FileName = fileName;
YearMonth = yearMonth;
ExcelRow = excelRow;
ImportErrors = new List<string>();
currentImportState = ImportState.None;
validator = Validator.GetInstance();
validator.clear();
}
protected string PrintForumName(DataRowView row)
{
string ForumName = (string)row["ForumName"];
string html = "";
if(ForumName!=LastForumName) {
html = String.Format("<tr><td class=header2 colspan=6><a href=\"{1}\">{0}</a></td></tr>",ForumName,Forum.GetLink(Pages.topics,"f={0}",row["ForumID"]));
LastForumName = ForumName;
}
return html;
}
public static string Eval(DataRowView row, string field, string format)
{
if (row == null)
return null;
object val = row[field];
if (val is DBNull)
return null;
else
return String.Format(PluggableFormatProvider.Instance, format, val);
}
public static string Eval(DataRowView row, string field)
{
if (row == null)
return null;
object val = row[field];
if (val is DBNull)
return null;
else
return Convert.ToString(val);
}
private int FindRow (DataRowView aRow)
{
int i=0;
foreach (DataRowView r in Items) {
if (r == aRow)
return (i);
i++;
}
return (-1);
}
public Barcode(DataRowView product)
{
InitializeComponent();
Product = product;
PD = new PrintDocument();
PD.DefaultPageSettings.Margins = new Margins(6, 2, 2, 0);
PD.DefaultPageSettings.PaperSize = new PaperSize("User Defined", 150, 100);
PD.PrintPage += new PrintPageEventHandler(PD_PrintPage);
Amount_TB.Text = Product["pro_limit"].ToString().Split('.')[0];
}
public void sbfile()
{
try
{
SqlConnection conns = new SqlConnection(strcon);
conns.Open();
string querys = "select HText,TText,zz,SenderID,ReceiverID,VersionNo,fType,MessageID from tbl_FileDetails";
SqlDataAdapter sda = new SqlDataAdapter(querys, conns);
sda.Fill(dsrun, "running");
conns.Close();
if (dsrun.Tables["running"].Rows.Count != 0)
{
dvrun = dsrun.Tables["running"].DefaultView[0];
}
string jno = ddlJobNo.SelectedValue;//(string)Session["JobNo"];
string HText = dvrun["HText"].ToString();
string TText = dvrun["TText"].ToString();
string zz = dvrun["zz"].ToString();
string SenderID = dvrun["SenderID"].ToString();
sbrunfile.AppendLine("Sender ID : " + SenderID);
string ReceiverID = dvrun["ReceiverID"].ToString();
sbrunfile.AppendLine("Receiver ID : " + ReceiverID);
string VersionNo = dvrun["VersionNo"].ToString();
sbrunfile.AppendLine("Version No : " + VersionNo);
string fType = dvrun["fType"].ToString();
string MessageID = dvrun["MessageID"].ToString();
string SequenceId = jno;//jno.Substring(13, 6);
sbrunfile.AppendLine("Job No : " + SequenceId);
string jdate = DateTime.Now.Date.ToString("dd/MM/yyyy");
sbrunfile.AppendLine("Job Date : " + jdate);
string jTime = DateTime.Now.ToString("HH:mm");
sbrunfile.AppendLine("Job Time : " + jTime);
txtBeFile.Text = sbrunfile.ToString();
GetFSIO(jno, SenderID, ReceiverID, VersionNo, fType, MessageID, SequenceId, HText, TText, zz);
sbrunfile.AppendLine("Successfully Created SB File.");
txtBeFile.Text = sbrunfile.ToString();
}
catch
{
}
}
public RowEditorWindow(ImportStagingService service, int rowId, List<ImportFieldMapping> mappings, DataRowView row)
{
InitializeComponent();
this.Service = service;
this.RowID = rowId;
this.Row = row;
this.Mappings = mappings;
int rowIndex = 0;
foreach (ImportFieldMapping mapping in mappings) {
gridFields.RowDefinitions.Add(CreateRowDefinition());
var lbl = new Label();
lbl.SetValue(Grid.RowProperty, rowIndex);
lbl.Content = mapping.SourceColumn;
gridFields.Children.Add(lbl);
var txt = new Extensibility.TextBox();
txt.SetValue(Grid.ColumnProperty, 1);
txt.SetValue(Grid.RowProperty, rowIndex);
txt.Height = 23;
var objValue = row[mapping.SourceColumn];
var strValue = (objValue == null ? "" : objValue.ToString());
var value = new FieldValue(mapping.TargetColumn, strValue);
var binding = new Binding("Value");
binding.Source = value;
binding.ValidatesOnDataErrors = true;
txt.SetBinding(TextBox.TextProperty, binding);
// txt.Text = strValue;
var fieldMapping = mapping; // need to keep a copy of this mapping so its captured in the closure
txt.TextChanged += new TextChangedEventHandler((source, e) => {
var textbox = source as TextBox;
if (textbox.Text != strValue) {
_changeMap[fieldMapping.SourceColumn] = textbox.Text;
} else {
if (_changeMap.ContainsKey(fieldMapping.SourceColumn)) {
_changeMap.Remove(fieldMapping.SourceColumn);
}
}
});
gridFields.Children.Add(txt);
rowIndex++;
}
}
private static void CompareAndUpdateUserExtendData(DataRowView drv, DataRow dr)
{
//比较并修改原来的记录
if (CompareUserExtendIsDifferent(drv, dr))
{
AD2DBHelper.CopyDataRow(drv.Row, dr,
"MOBILE",
"OFFICE_TEL",
"IM_ADDRESS");
}
}
private void cboAssignmentTypes_SelectedValueChanged(object sender, EventArgs e)
{
this.Cursor = Cursors.WaitCursor;
drv = cboAssignmentTypes.SelectedItem as DataRowView;
if (!drv.Row["Name"].ToString().Equals(String.Empty))
{
dsSourceObjects = BrokerConnection.InstanceOf().Request("GetReferenceData", drv.Row["TableName1"].ToString()) as DataSet;
if (dsSourceObjects.Tables.Count > 0 && dsSourceObjects.Tables[0].Rows.Count > 0)
{
lblSource.Text = drv.Row["Label1"].ToString();
dvcSourceObjects = new DataViewerCtl("Source", dsSourceObjects, drv.Row["TableName1"].ToString(), false, rbBriefDisplay.Checked, null);
dvcSourceObjects.BriefDisplayFields.Add(drv.Row["DisplayName1"].ToString());
dvcSourceObjects.Dock = DockStyle.Fill;
dvcSourceObjects.gridDataBoundGrid1.RowEnter += new Syncfusion.Windows.Forms.Grid.GridRowEventHandler(this.SourceObject_RowEnter);
this.panelObjects.Controls.Clear();
this.panelObjects.Controls.Add(dvcSourceObjects);
RefreshSourceObjects();
}
dsAvailableObjects = BrokerConnection.InstanceOf().Request("GetReferenceData", drv.Row["TableName2"].ToString()) as DataSet;
if (dsAvailableObjects.Tables.Count > 0 && dsAvailableObjects.Tables[0].Rows.Count > 0)
{
//lblAvailable.Text = drv.Row["Label2"].ToString() + " Available";
dvcAvailableObjects = new DataViewerCtl("Target", dsAvailableObjects, drv.Row["TableName2"].ToString(), false, rbBriefDisplay.Checked, null);
dvcAvailableObjects.BriefDisplayFields.Add(drv.Row["DisplayName2"].ToString());
dvcAvailableObjects.Dock = DockStyle.Fill;
this.panelAvailable.Controls.Clear();
this.panelAvailable.Controls.Add(dvcAvailableObjects);
RefreshAvailableObjects();
}
#region prepare assigned table
DataTable dt = new DataTable();
dt.Columns.Add(drv.Row["FieldName2"].ToString());
dt.Columns.Add(drv.Row["DisplayName2"].ToString());
dsAssignedObjects.Tables.Add(dt);
DataRow dr = dt.NewRow();
dt.Rows.Add(dr);
dt.AcceptChanges();
#endregion
lblAssigned.Text = drv.Row["Label2"].ToString() + " Assigned";
dvcAssignedObjects = new DataViewerCtl("Assigned", dsAssignedObjects, drv.Row["TableName2"].ToString(), false, rbBriefDisplay.Checked, null);
dvcAssignedObjects.BriefDisplayFields.Add(drv.Row["DisplayName2"].ToString());
dvcAssignedObjects.Dock = DockStyle.Fill;
this.panelAssigned.Controls.Clear();
this.panelAssigned.Controls.Add(dvcAssignedObjects);
RefreshAssignedObjects(1);
}
this.Cursor = Cursors.Arrow;
}
protected void rptPO_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
System.Data.DataRowView drv = e.Item.DataItem as System.Data.DataRowView;
if (drv == null)
{
return;
}
POStatus status = Cast.Enum <POStatus>(drv["Status"]);
if (status != POStatus.New)
{
HtmlInputCheckBox chk = e.Item.FindControl("checkbox") as HtmlInputCheckBox;
chk.Visible = false;
}
}
protected void rptSDHead_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
System.Data.DataRowView drv = e.Item.DataItem as System.Data.DataRowView;
if (drv == null)
{
return;
}
INVCheckStatus status = Cast.Enum <INVCheckStatus>(drv["Status"]);
if (status != INVCheckStatus.New)
{
HtmlInputCheckBox chk = e.Item.FindControl("checkbox") as HtmlInputCheckBox;
if (chk == null)
{
return;
}
chk.Visible = false;
}
HtmlAnchor cmd = e.Item.FindControl("cmdDetail") as HtmlAnchor;
if (status == INVCheckStatus.New)
{
cmd.Visible = false;
}
else
{
cmd.HRef = "javascript:ondetail('" + Cast.String(drv["OrderNumber"]) + "');";
}
Label lblApprStatus = e.Item.FindControl("lblApprStatus") as Label;
ApproveStatus apprStatus = Cast.Enum <ApproveStatus>(drv["ApproveResult"]);
lblApprStatus.Text = ERPUtil.EnumText <ApproveStatus>(apprStatus);
switch (apprStatus)
{
case ApproveStatus.UnApprove:
lblApprStatus.Text = "";
break;
case ApproveStatus.Approve:
lblApprStatus.ForeColor = System.Drawing.Color.Blue;
break;
case ApproveStatus.Reject:
lblApprStatus.ForeColor = System.Drawing.Color.Red;
break;
}
}
protected void menuList_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
System.Data.DataRowView record = (System.Data.DataRowView)e.Item.DataItem;
int userId = int.Parse(record["Id"].ToString());
if (userId != id)
{
((Panel)e.Item.FindControl("plItem")).Visible = true;
((Panel)e.Item.FindControl("plEdit")).Visible = false;
}
else
{
((Panel)e.Item.FindControl("plItem")).Visible = false;
((Panel)e.Item.FindControl("plEdit")).Visible = true;
}
}
}
protected void Repeater1_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
System.Web.UI.WebControls.ListItemType lit = e.Item.ItemType;
if (lit == System.Web.UI.WebControls.ListItemType.Item || lit == System.Web.UI.WebControls.ListItemType.AlternatingItem)
{
System.Data.DataRowView drv = (System.Data.DataRowView)e.Item.DataItem;
Label labPingBi = (Label)e.Item.FindControl("labPingBi");
if (nRowIndex % 2 == 0)
{
labPingBi.Text = "<tr class='odd'><td>" + Get_StoreName(drv["DictionaryKey"].ToString()) + "</td><td>第 " + drv["StoreStatisticsOrder"].ToString() + " 名</td><td>" + Get_StoreName(drv["StoreDictionaryKey"].ToString()) + "</td><td>" + Convert_DateTime(drv["PublishDate"].ToString()) + "</td></tr>";
}
else
{
labPingBi.Text = "<tr><td>" + Get_StoreName(drv["DictionaryKey"].ToString()) + "</td><td>第 " + drv["StoreStatisticsOrder"].ToString() + " 名</td><td>" + Get_StoreName(drv["StoreDictionaryKey"].ToString()) + "</td><td>" + Convert_DateTime(drv["PublishDate"].ToString()) + "</td></tr>";
}
nRowIndex++;
}
}
private void UpdateButton_Click(object sender, RoutedEventArgs e)
{
if (TableView.SelectedIndex == -1)
{
Error.Text = "Не выбрана строка!";
return;
}
Error.Text = "";
System.Data.DataRowView selectedRow = (System.Data.DataRowView)TableView.SelectedItems[0];
int landId = (int)selectedRow.Row[0];
AddLand edit = new AddLand(this, 2, landId);
edit.Show();
}
private void dgCat_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
try
{
System.Data.DataRowView drv = (System.Data.DataRowView) this.dgCat.SelectedItem;
string s1 = (drv[2].ToString()).Trim();
subCatTable = s1;
try
{
getSubCats(s1);
}
catch
{
MessageBox.Show("Could not find the Sub-Category table");
}
}
catch { }
}
protected void DataList1_OnRenderCell(object sender, System.Data.DataRowView rs, SmoothEnterprise.Web.UI.WebControl.DataColumn column, SmoothEnterprise.Web.UI.WebControl.DataCell cell, System.EventArgs e)
{
if (Utility.MIS_Manager(CurrentUser.LogonID))
{
cell.OutputHTML = List_Default(column.ID, rs["id"].ToString(), true);
}
else
{
bool isEdit = rs["create_user"].ToString().ToUpper() == CurrentUser.LogonID.ToUpper();
cell.OutputHTML = List_Default(column.ID, rs["id"].ToString(), isEdit);
}
if (column.ID.ToUpper() == "STATUS")
{
cell.Value = tranfer_status(rs["status"].ToString());
}
}
protected void gvJobHistory_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
Label lblJobHistoryRemaks = (Label)e.Row.FindControl("lblRemarks");
Label lblFullJobHistoryRemaks = (Label)e.Row.FindControl("lblFullRemarks");
Label lblCMS_H = (Label)e.Row.FindControl("lblCMS_H");
Label lblCritical_H = (Label)e.Row.FindControl("lblCritical_H");
System.Data.DataRowView gvrow = (System.Data.DataRowView)e.Row.DataItem;
ImageButton ImgSpareUsed = (ImageButton)e.Row.FindControl("ImgSpareUsed");
ImgSpareUsed.Attributes.Add("onclick", "document.getElementById('iFrmJobsDetails').src ='/" + System.Configuration.ConfigurationManager.AppSettings["APP_NAME"].ToString() + "/Technical/PMS/PMS_SparesUsed.aspx?JobID=" + gvrow["JOB_ID"].ToString() + "&Vessel_ID=" + gvrow["Vessel_ID"].ToString() + "';showModal('dvJobsDetails');return false;");
if (lblFullJobHistoryRemaks.Text != "")
{
lblJobHistoryRemaks.Attributes.Add("Title", "cssbody=[dvbdy1] cssheader=[dvhdr1] header=[Remarks] body=[" + lblFullJobHistoryRemaks.Text + "]");
}
ImgSpareUsed.Attributes.Add("Title", "cssbody=[dvbdy1] cssheader=[dvhdr1] header=[Remarks] body=[Spare Item Used]");
if (lblCMS_H.Text == "Y")
{
e.Row.Cells[10].BackColor = System.Drawing.Color.LightGreen;
e.Row.Cells[10].ForeColor = System.Drawing.Color.Black;
}
if (lblCritical_H.Text == "Y")
{
e.Row.Cells[11].BackColor = System.Drawing.Color.Salmon;
e.Row.Cells[11].ForeColor = System.Drawing.Color.Black;
}
}
if (e.Row.RowType == DataControlRowType.Header)
{
//MergeGridviewHeader.SetProperty(mergeheadgvJobHistory);
//e.Row.SetRenderMethodDelegate(MergeGridviewHeader.RenderHeader);
}
}
protected void DataList1_OnRenderCell(object sender, System.Data.DataRowView rs, SmoothEnterprise.Web.UI.WebControl.DataColumn column, SmoothEnterprise.Web.UI.WebControl.DataCell cell, System.EventArgs e)
{
try
{
if (column.ID == "DataList1_edit")
{
cell.LinkURL = "APMT420Edit.aspx?id=" + rs["id"].ToString();
}
if (column.ID == "DataList1_view")
{
cell.LinkURL = "APMT420View.aspx?id=" + rs["id"].ToString();
}
}
catch (Exception ex)
{
this.AddError(this, "DataList1_OnRenderCell()", "", ex.Message);
}
}
private void gdvCompanyMain_DoubleClick(object sender, EventArgs e)
{
try
{
System.Data.DataRowView dv = (DataRowView)gdvCompanyDetails.GetRow(gdvCompanyDetails.FocusedRowHandle);
// Author.AuthorId = lstAuthors.Author_Id;
string compId = dv.Row["SerialNo"].ToString();
SessionVariables.DBName = "dbipca_" + Convert.ToString(Convert.ToDecimal(compId));
frmLogin frmLoginObj = new frmLogin();
frmLogin.companyname = dv.Row["Company"].ToString();
//frmLoginObj.CallFromSelectCompany(this);
frmLoginObj.ShowDialog();
foreach (Form form in Application.OpenForms)
{
if (form.GetType() == typeof(Menu.CompanyMenu))
{
form.Close();
break;
}
}
XtraForm1.MDIObj.MenuSettings(true);
this.Close();
//if (gdvCompanyDetails.CurrentRow.Index == e.RowIndex)
//{
// SessionVariables.DBName = "dbipca" + Convert.ToString(Convert.ToDecimal(dgvSelectCompany.Rows[e.RowIndex].Cells["dgvtxtCompanyId"].Value.ToString()));
// CurrentDate();
// frmLogin frmLoginObj = new frmLogin();
// frmLoginObj.MdiParent = formMDI.MDIObj;
// frmLoginObj.CallFromSelectCompany(this);
//}
}
catch (Exception ex)
{
// formMDI.infoError.ErrorString = "SELCMPNY : 5" + ex.Message;
}
}
protected void Repeater1_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
System.Web.UI.WebControls.ListItemType lit = e.Item.ItemType;
if (lit == System.Web.UI.WebControls.ListItemType.Item || lit == System.Web.UI.WebControls.ListItemType.AlternatingItem)
{
System.Data.DataRowView drv = (System.Data.DataRowView)e.Item.DataItem;
Label labJobTitle = (Label)e.Item.FindControl("labJobTitle");
Label labPublishDate = (Label)e.Item.FindControl("labPublishDate");
Label labResponsibilities = (Label)e.Item.FindControl("labResponsibilities");
Label labQualifications = (Label)e.Item.FindControl("labQualifications");
Label labCheck = (Label)e.Item.FindControl("labCheck");
labJobTitle.Text = drv["DepartmentName"].ToString() + " " + drv["CareersTitle"].ToString() + " " + "人数: " + drv["CareersCount"].ToString() + "人";
labPublishDate.Text = DateTime.Parse(drv["PublishDate"].ToString()).ToString("yyyy年MM月dd日");
labResponsibilities.Text = drv["Responsibilities"].ToString();
labQualifications.Text = drv["Qualifications"].ToString();
labCheck.Text = "<a href='CareersInfo.aspx?id=" + drv["CareersGUID"].ToString() + "' style='color:#F26200; font-weight:bold;'>查看职位详情</a>";
}
}
private void lstEvents_SelectedIndexChanged(object sender, EventArgs e)
{
string parts = "", user = "";
if (lstEvents.SelectedIndex > -1)
{
if (lstEvents.Items.Count > 0)
{
System.Data.DataRowView myRow = (System.Data.DataRowView)lstEvents.SelectedItem;
txtEventName.Text = myRow[8].ToString();
lblCreatedDate.Text = myLogHangle.covertDateStringToString(myRow[3].ToString());
bb_userTableAdapter1.FillByUserID(bBLABSDataSet.bb_user, (int)myRow[1]);
lblCreator.Text = bBLABSDataSet.bb_user.Rows[0]["USERNAME"].ToString();
bb_userTableAdapter1.FillByUserID(bBLABSDataSet.bb_user, (int)myRow[7]);
lblRespPerson.Text = bBLABSDataSet.bb_user.Rows[0]["USERNAME"].ToString();
dateEvent.Value = Convert.ToDateTime(myRow[4].ToString());
//calendarEvent.SetDate(Convert.ToDateTime(myRow[4].ToString()));
if ((int)myRow[6] == 1)
{
chkOpen.Checked = false;
}
else
{
chkOpen.Checked = true;
}
chkParticipants.Items.Clear();
parts = myRow[5].ToString();
while (parts.Contains(','))
{
user = parts.Substring(0, parts.IndexOf(','));
parts = parts.Remove(0, parts.IndexOf(',') + 1);
chkParticipants.Items.Add(user);
}
//lblCount.Text = chkParticipants.Items.Count.ToString();
redSummary.Text = myRow[2].ToString();
txtVenue.Text = myRow[9].ToString();
}
}
}
protected void RadTreeList1_ItemDataBound(object sender, Telerik.Web.UI.TreeListItemDataBoundEventArgs e)
{
if (e.Item is Telerik.Web.UI.TreeListDataItem)
{
Telerik.Web.UI.TreeListDataItem item = (Telerik.Web.UI.TreeListDataItem)e.Item;
System.Data.DataRowView row = (System.Data.DataRowView)item.DataItem;
string cssClass = "";
int width = 160;
if (row.Row["LVL_UNIT"].ToString() == "LV3")
{
cssClass = "item-level2"; width = 180;
}
if (row.Row["LVL_UNIT"].ToString() == "LV2" || row.Row["KD_PARENT"] == "")
{
cssClass = "item-level1"; width = 200;
}
if (cssClass != "")
{
item.CssClass += cssClass;
}
Telerik.Web.UI.RadProgressBar rpb = (Telerik.Web.UI.RadProgressBar)item["PROGRESSBAR"].FindControl("ProgressBar1");
if (rpb != null)
{
int angka1 = Convert.ToInt32(row.Row["TOTAL_RKP"]);
int angka2 = Convert.ToInt32(row.Row["TOTAL_EMPLOYEE"]);
float persentase = 0;
if (angka2 != 0)
{
persentase = ((float)angka1 / (float)angka2) * 100;
}
rpb.Value = persentase;
rpb.Label = ((int)persentase).ToString() + "%";
int groupClass = (int)System.Math.Floor(persentase / 20) * 20;
rpb.CssClass = "ProgressBar" + groupClass.ToString();
rpb.Width = Unit.Pixel(width);
}
}
}
protected void rptParent_OnItemDataBound(object source, RepeaterItemEventArgs e)
{
try
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
System.Data.DataRowView drv = (System.Data.DataRowView)e.Item.DataItem;
string strName = drv.Row["quotedate"].ToString();
cmbCurrency.SelectedValue = drv.Row["currency"].ToString();
if (!String.IsNullOrEmpty(strName))
{
if (Convert.ToString(ViewState["CurrentStatus"]) == "APPROVED" && Convert.ToInt32(ViewState["ApprovedQuoteID"]) == Convert.ToInt32(drv.Row["id"].ToString()))
{
((Button)e.Item.FindControl("cmdSendQuote")).Text = "Quote approved, Please issue ticket";
((Button)e.Item.FindControl("cmdSendQuote")).Enabled = false;
}
else
{
((Button)e.Item.FindControl("cmdSendQuote")).Text = "Quote Sent on " + strName;
((Button)e.Item.FindControl("cmdSendQuote")).Enabled = false;
}
if (Convert.ToString(ViewState["CurrentStatus"]) == "TICKET ISSUED" || Convert.ToString(ViewState["CurrentStatus"]) == "ISSUED" || Convert.ToString(ViewState["CurrentStatus"]) == "CLOSED" || Convert.ToString(ViewState["CurrentStatus"]) == "CANCELLED" || Convert.ToString(ViewState["CurrentStatus"]) == "REFUND")
{
((Button)e.Item.FindControl("cmdSendQuote")).Text = "Request Status - " + Convert.ToString(ViewState["CurrentStatus"]);
((Button)e.Item.FindControl("cmdSendQuote")).Enabled = false;
}
}
if (String.IsNullOrEmpty(strName) && (Convert.ToString(ViewState["CurrentStatus"]) == "QUOTE RECEIVED" || Convert.ToString(ViewState["CurrentStatus"]) == "NEW" || Convert.ToString(ViewState["CurrentStatus"]) == "RFQ SENT"))
{
((Button)e.Item.FindControl("cmdSendQuote")).Enabled = true;
}
else
{
((Button)e.Item.FindControl("cmdSendQuote")).Enabled = false;
}
}
}
catch { }
}
private void DeleteButton_Click(object sender, RoutedEventArgs e)
{
if (Table.SelectedIndex == -1)
{
Error.IsEnabled = true;
Error.Text = "Ошибка! Строка не выбрана!";
return;
}
Error.Text = "";
System.Data.DataRowView selectedRow = (System.Data.DataRowView)Table.SelectedItems[0];
string oldValue = selectedRow.Row[0].ToString();
oldValue = string.Concat("'", oldValue, "'");
string Query = "";
switch (DictionaryType)
{
case 1:
{
Query = "DELETE FROM город WHERE Город = " + oldValue + ";";
break;
}
case 2:
{
Query = "DELETE FROM назначение_здания WHERE Назначение_Здания = " + oldValue + ";";
break;
}
case 3:
{
Query = "DELETE FROM назначение_помещения WHERE Назначение_Помещения = " + oldValue + ";";
break;
}
}
updateTable(Query, true);
}
protected void GVDisplayHallDetails_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
Label lblHallName = (Label)e.Row.FindControl("lblHallName");
System.Data.DataRowView rv1 = e.Row.DataItem as System.Data.DataRowView;
lblHallName.Text = Convert.ToString(rv1.Row.ItemArray[0]);
Label lblSeatingCapacity = (Label)e.Row.FindControl("lblSeatingCapacity");
System.Data.DataRowView rv2 = e.Row.DataItem as System.Data.DataRowView;
lblSeatingCapacity.Text = rv2.Row.ItemArray[1].ToString();
Label lblEventType = (Label)e.Row.FindControl("lblEventType");
System.Data.DataRowView rv3 = e.Row.DataItem as System.Data.DataRowView;
lblEventType.Text = rv3.Row.ItemArray[2].ToString();
Label lblNoOfWorkers = (Label)e.Row.FindControl("lblNoOfWorkers");
System.Data.DataRowView rv4 = e.Row.DataItem as System.Data.DataRowView;
lblNoOfWorkers.Text = rv4.Row.ItemArray[3].ToString();
//Label lblCity = (Label)e.Row.FindControl("lblCity");
//System.Data.DataRowView rv2 = e.Row.DataItem as System.Data.DataRowView;
//lblCity.Text = rv2.Row.ItemArray[1].ToString();
//Label lblPlace = (Label)e.Row.FindControl("lblPlace");
//System.Data.DataRowView rv3 = e.Row.DataItem as System.Data.DataRowView;
//lblPlace.Text = rv3.Row.ItemArray[2].ToString();
//Label lblSeatingCapacity = (Label)e.Row.FindControl("lblSeatingCapacity");
//System.Data.DataRowView rv4 = e.Row.DataItem as System.Data.DataRowView;
//lblSeatingCapacity.Text = rv4.Row.ItemArray[3].ToString();
//Label lblEventType = (Label)e.Row.FindControl("lblEventType");
//System.Data.DataRowView rv5 = e.Row.DataItem as System.Data.DataRowView;
//lblEventType.Text = rv5.Row.ItemArray[4].ToString();
//Label lblNoOfWorkers = (Label)e.Row.FindControl("lblNoOfWorkers");
//System.Data.DataRowView rv6 = e.Row.DataItem as System.Data.DataRowView;
//lblNoOfWorkers.Text = rv6.Row.ItemArray[5].ToString();
}
}
protected void DataList1_OnRenderCell(object sender, System.Data.DataRowView rs, SmoothEnterprise.Web.UI.WebControl.DataColumn column, SmoothEnterprise.Web.UI.WebControl.DataCell cell, System.EventArgs e)
{
try
{
if (column.ID == "DataList1_edit")
{
if (rs["inituser"].ToString().ToUpper().Contains(this.CurrentUser.ID.ToUpper().Replace("{", "").Replace("}", "")) || ismanergement(this.CurrentUser.ID))
{
cell.OutputHTML = "<a href=\"IPQCEdit.aspx?ROWNO=" + rs["ROWNO"].ToString() + "\"><img src=\"/PManagement/images/Edit.gif\" border=\"0\" Alt=修改></a>";
}
if (Utility.MIS_Manager(CurrentUser.LogonID))
{
cell.OutputHTML = "<a href=\"IPQCEdit.aspx?ROWNO=" + rs["ROWNO"].ToString() + "\"><img src=\"/PManagement/images/Edit.gif\" border=\"0\" Alt=修改></a>";
}
}
if (column.ID == "DataList1_view")
{
cell.LinkURL = "IPQCView.aspx?ROWNO=" + rs["ROWNO"].ToString();
}
if (column.ID == "DataList1_isState")
{
//Start = 0, Run = 1, End = 2, Stop = 3, Origin = 4
try
{
int istatus = Convert.ToInt16(rs["isState"]);
cell.Value = Utility.chnageStatus(istatus.ToString(), CurrLang);
}
catch (Exception ex)
{
cell.Value = rs["isState"].ToString();
}
}
}
catch (Exception ex)
{
this.AddError(this, "DataList1_OnRenderCell()", "", ex.Message);
}
}
protected void DataList1_OnRenderCell(object sender, System.Data.DataRowView rs, SmoothEnterprise.Web.UI.WebControl.DataColumn column, SmoothEnterprise.Web.UI.WebControl.DataCell cell, System.EventArgs e)
{
try
{
if (column.ID == "edit")
{
string html = string.Format("<a href='StandardEdit.aspx?rowid={0}'><img src='/Lib/img/icon-edit.gif' border='0'></a>", rs["rowid"]);
cell.OutputHTML = html;
}
if (column.ID == "del")
{
cell.OutputHTML = "<input type=\"checkbox\" name=\"del_" + rs["rowid"].ToString() + "\" value=\"" + rs["rowid"].ToString() + "\" />";
}
}
catch (Exception ex)
{
this.AddError(this, "DataList1_OnRenderCell()", "", ex.Message);
}
}
protected void Dbg_item_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowIndex != -1)
{
e.Row.Cells[0].Text = Convert.ToString(Convert.ToInt32(e.Row.RowIndex) + 1);
System.Data.DataRowView dataRowView = (System.Data.DataRowView)e.Row.DataItem;
e.Row.Attributes["onclick"] = string.Concat(new object[]
{
"OnRecord(this);NewsId('",
e.Row.Cells[1].Text,
"','",
dataRowView["i_xw_id"],
"')"
});
e.Row.Attributes["onmouseover"] = "OnMouseOverRecord(this)";
HyperLink hyperLink = (HyperLink)e.Row.Cells[1].Controls[0];
hyperLink.NavigateUrl = "javascript:window.open('/WEB/WebSel.aspx?nid=" + dataRowView["i_xw_id"].ToString() + "&cd=99','_self','left=150,top=150,width=600,height=400,status=0,toolbar=0,menubar=0,location=0,scrollbars=1,resizable=1',false)";
hyperLink.Target = "#";
}
}
private void cambiarFiltro()
{
DataTable dt = (DataTable)dgvPlatos.DataSource;
string nombre = tbNombrePlato.Text.Trim().Replace("'", "''");
bool tacc = cbTACC.Checked;
System.Data.DataRowView cat = (System.Data.DataRowView)cboCategoriaPlato.SelectedValue;
string categoria = cat["Nombre"].ToString();
if (categoria == "Todas" || categoria == "")
{
categoria = "NOT LIKE 'Todas'";
}
else
{
categoria = string.Format("like '{0}'", categoria);
}
dt.DefaultView.RowFilter = string.Format("Nombre like '%{0}%' AND TACC= '{1}' AND Categoria {2} ", nombre, tacc, categoria);
dgvPlatos.Refresh();
}
private void btnDeleteEvent_Click(object sender, EventArgs e)
{
System.Data.DataRowView myRow = (System.Data.DataRowView)lstEvents.SelectedItem;
if (lstEvents.SelectedIndex > -1)
{
if (lstEvents.Items.Count > 0)
{
String querytString = "DELETE FROM event WHERE EVENT_ID =" + (int)lstEvents.SelectedValue;
if (myLogHangle.doQuery(querytString))
{
myLogHangle.insertChange(UserID, "Removed event: " + myRow[8].ToString());
eventTableAdapter.Fill(bBLABSDataSet._event);
}
else
{
MessageBox.Show("Could not remove event", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
}
/// <summary>
/// Elimina un producto en el detalle de la promoción.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void eliminarProductoDePromocion_ItemClick_1(object sender, DevExpress.Xpf.Bars.ItemClickEventArgs e)
{
System.Data.DataRowView seleccion = (System.Data.DataRowView)tblProductos.SelectedItem;
if (seleccion != null)
{
MessageBoxResult dialogResult = MessageBox.Show("¿ESTÁ SEGURO DE ELIMINAR EL PRODUCTO '" + seleccion.Row.ItemArray[1] + "' DE LA PROMOCIÓN?", "ELIMINACIÓN DE PRODUCTO DE ELIMINACIÓN", MessageBoxButton.YesNo);
if (dialogResult == MessageBoxResult.Yes)
{
ProductoPromocion detalle = new ProductoPromocion();
detalle.id = Convert.ToInt32(seleccion.Row.ItemArray[0].ToString());
detalle.eliminar(detalle);
cargarDetallePromocion();
clearFieldDetalle();
}
}
else
{
MessageBox.Show("EN NECESARIO QUE SELECCIONE EL PRODUCTO QUE DESEA ELIMINAR");
}
}
/// <summary>
/// Elimina la promoción seleccionada.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void eliminarPromocion_ItemClick(object sender, DevExpress.Xpf.Bars.ItemClickEventArgs e)
{
System.Data.DataRowView seleccion = (System.Data.DataRowView)tblPromociones.SelectedItem;
if (seleccion != null)
{
MessageBoxResult dialogResult = MessageBox.Show("¿ESTÁ SEGURO DE ELIMINAR LA PROMOCIÓN '" + seleccion.Row.ItemArray[1] + "'?", "ELIMINACIÓN DE PROMOCIÓN", MessageBoxButton.YesNo);
if (dialogResult == MessageBoxResult.Yes)
{
Promocion promocion = new Promocion();
promocion.id = Convert.ToInt32(seleccion.Row.ItemArray[0].ToString());
promocion.eliminar(promocion);
cargarPromociones();
clearFieldsPromo();
}
}
else
{
MessageBox.Show("EN NECESARIO QUE SELECCIONE LA PROMOCIÓN QUE DESEA ELIMINAR");
}
}
//设置映射例的空值
private void setMappingColumnNullValue()
{
Control ctl = this.Parent;
DevExpress.XtraGrid.GridControl grdCtl = ctl as DevExpress.XtraGrid.GridControl;
if (grdCtl == null)
{
return;
}
DevExpress.XtraGrid.Views.Grid.GridView gridView = grdCtl.DefaultView as DevExpress.XtraGrid.Views.Grid.GridView;
if (gridView.FocusedRowHandle < 0)
{
return;
}
object mainEntity = gridView.GetRow(gridView.FocusedRowHandle);
bool isEntity = string.Compare(mainEntity.GetType().Name, "DataRowView", true) != 0;
foreach (MB.WinBase.Common.EditCtlDataMappingInfo info in _ColumnEditCfgInfo.EditCtlDataMappings)
{
if (isEntity)
{
if (MB.Util.MyReflection.Instance.CheckObjectExistsProperty(mainEntity, info.ColumnName))
{
MB.Util.MyReflection.Instance.InvokePropertyForSet(mainEntity, info.ColumnName, null);
}
}
else
{
System.Data.DataRowView drRow = mainEntity as System.Data.DataRowView;
DataColumn dc = drRow.DataView.Table.Columns[info.ColumnName];
if (dc != null && dc.AllowDBNull)
{
drRow[info.ColumnName] = System.DBNull.Value;
}
}
}
this.Text = string.Empty;
}
protected void SaveNext_Click(object sender, EventArgs e)
{
System.Data.DataRowView dr = (System.Data.DataRowView)questionDetails.DataItem;
Answer a = new Answer();
int ExamId = Convert.ToInt16(Request.QueryString["ExamId"].ToString());
a.QuestionID = dr["q_id"].ToString();
a.CorrectAnswer = dr["correct_ans"].ToString();
a.MarksOfQuestion = Convert.ToInt16(dr["marks"].ToString());
a.UserAnswer = ddlAnswer.SelectedValue.ToString();
ArrayList al = (ArrayList)Session["AnswerList"];
al.Add(a);
Session.Add("AnswerList", al);
if (questionDetails.PageIndex == questionDetails.PageCount - 1)
{
//Response.Redirect("TestPage.aspx");
Response.Redirect("Results.aspx");
}
else
{
questionDetails.PageIndex++;
AddAnsewerToDb(Convert.ToInt16(dr["q_id"].ToString()), ExamId, Convert.ToInt16(dr["correct_ans"].ToString()), Convert.ToInt16(ddlAnswer.SelectedValue.ToString()));
if (ddlAnswer.SelectedItem.Value != "NA")
{
ScriptManager.RegisterStartupScript(Page, typeof(Page), "somekey4", "MarkForAnswered();", true);
}
}
if (questionDetails.PageIndex == questionDetails.PageCount - 1)
{
SaveNext.Text = "Finished";
if (ddlAnswer.SelectedItem.Value != "NA")
{
ScriptManager.RegisterStartupScript(Page, typeof(Page), "somekey4", "MarkForAnswered();", true);
}
}
}
public static System.Data.DataRow AddRowView(System.Data.DataRowView vDrv_Source, ref System.Data.DataTable rDtt_Destination)
{
System.Data.DataRow lDtr_Destination = null;
System.Data.DataColumn lDtc_Temp = null;
bool lBln_Ok = false;
// cria uma estrutura para nova linha no destino
lDtr_Destination = rDtt_Destination.NewRow();
// percorre as colunas da origem
foreach (DataColumn lDtc_Temp_loopVariable in vDrv_Source.DataView.Table.Columns)
{
lDtc_Temp = lDtc_Temp_loopVariable;
// tem no destino?
if ((rDtt_Destination.Columns.Contains(lDtc_Temp.ColumnName) == true))
{
// marca flag para indicar que pelo menos uma coluna foi copiada
lBln_Ok = true;
// copia
lDtr_Destination[lDtc_Temp.ColumnName] = vDrv_Source[lDtc_Temp.ColumnName];
}
}
// nova linha valida?
if ((lBln_Ok == true))
{
// passa para o destino
rDtt_Destination.Rows.Add(lDtr_Destination);
// retorna a linha incluida
return(lDtr_Destination);
}
else
{
return(null);
}
}
/// <summary>
/// Method signature for bind event format combobox.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
public static void ComboBox_Format(object sender, System.Windows.Forms.ListControlConvertEventArgs e)
{
System.Windows.Forms.ComboBox combo = sender as System.Windows.Forms.ComboBox;
if (combo == null)
{
return;
}
System.Data.DataRowView view = e.ListItem as System.Data.DataRowView;
if (view != null)
{
if ("".Equals(view[combo.DisplayMember]) || DBNull.Value.Equals(view[combo.DisplayMember]))
{
e.Value = view[combo.ValueMember];
}
else
{
e.Value = String.Format("{0}{1}{2}", view[combo.ValueMember], COMBOBOX_SEPERATOR_SYMBOL, view[combo.DisplayMember]);
}
}
}
protected void Repeater1_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
System.Web.UI.WebControls.ListItemType lit = e.Item.ItemType;
if (lit == System.Web.UI.WebControls.ListItemType.Item || lit == System.Web.UI.WebControls.ListItemType.AlternatingItem)
{
System.Data.DataRowView drv = (System.Data.DataRowView)e.Item.DataItem;
Label labPublishUserName = (Label)e.Item.FindControl("labPublishUserName");
Label labPublishDate = (Label)e.Item.FindControl("labPublishDate");
Label labPublishContent = (Label)e.Item.FindControl("labPublishContent");
Label labReplyUser = (Label)e.Item.FindControl("labReplyUser");
Label labReplyDate = (Label)e.Item.FindControl("labReplyDate");
Label labReplyContent = (Label)e.Item.FindControl("labReplyContent");
labPublishUserName.Text = drv["PublishUserName"].ToString(); //发布人姓名
labPublishDate.Text = DateTime.Parse(drv["PublishDate"].ToString()).ToString("yyyy年MM月dd日"); //发布日期
labPublishContent.Text = drv["PublishContent"].ToString(); //发布内容
labReplyUser.Text = Get_ReplyName(drv["ReplyUserGUID"].ToString()); //回复人
labReplyDate.Text = DateTime.Parse(drv["ReplyDate"].ToString()).ToString("yyyy年MM月dd日"); //回复日期
labReplyContent.Text = drv["ReplyContent"].ToString(); //回复内容
}
}
