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;
        }

 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 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;
        }

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

 public void ChangeTableType(DataRowView rowView,int type)
 {
     systemDataSetTableAdapters.tablesTableAdapter tables = new systemDataSetTableAdapters.tablesTableAdapter();
     DataRow row = rowView.Row;
     row["type_id"] = type;
     tables.Update(row);
 }

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

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

 public DataValidator(DataRowView rv)
 {
     Debug.Assert(rv != null);
     m_rv = rv;
     m_tables = new List<DataTable>();
     Hook(rv);
 }

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

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

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

 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]);
 }

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

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