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(); //回复内容 } }