HYTOS

{

    public class DocumentController : BaseController

    {

        {

            using (DocumentRepository rep = new DocumentRepository(this._DbConnectionStr))

            {

            }

        }

    {

        public DocumentRepository(string connectionStr) : base(connectionStr) { }

        {

            StringBuilder sbWhere = new StringBuilder();

            var parameters = new Dictionary<string, object>();

            {

            }

            if (!string.IsNullOrEmpty(personIncharge))

            {

     [DocID]

    ,[DocumentNo]

    ,[RevisonNo]

    ,[DocFilePath]

    ,[DocFileName]

    ,[Place]

     lower(newid())

    ,@DocumentNo

    ,@RevisonNo

    ,@DocFilePath

    ,@DocFileName

    ,@Place

update dbo.Documents

set    [DocumentNo]=@DocumentNo

      ,[RevisonNo]=@RevisonNo

      ,[DocFilePath]=@DocFilePath

      ,[DocFileName]=@DocFileName

      ,[Place]=@Place

        [DataMember]

        public string RevisonNo { get; set; }

        [DataMember]

        [DataMember]

        public bool IsLatest { get; set; }

        [DataMember]

            gridViewCommandColumn24.Name = "AVEVALink";

            gridViewCommandColumn24.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText;

            gridViewCommandColumn24.Width = 70;

            gridViewComboBoxColumn41.TextAlignment = System.Drawing.ContentAlignment.MiddleCenter;

            gridViewComboBoxColumn41.Width = 150;

            gridViewTextBoxColumn21.FieldName = "DocumentNo";

            informations.ProjectList.Where(x => x.GroupID.Equals(informations.ActiveProject.ProjectID)).ToList()

                                    .ForEach(x =>

                                    {

                                    });

            var allProject = new RadListDataItem("== 전체 ==", string.Empty);

            this.radDropDownListProject.Items.Insert(0, allProject);

        {

            if (this.radDropDownListProject.SelectedValue != null)

            {

                string personIncharge = this.radDropDownListPersonInCharge.SelectedValue.ToString();

                string jobLevel = this.radDropDownListJobLevel.SelectedValue.ToString();//

                string documentNo = this.radTextBoxDocumentNo.Text.Trim();

                string prodIsResult = this.radDropDownListProdIsResult.SelectedValue.ToString();//

                string clientIsResult = this.radDropDownListClientIsResult.SelectedValue.ToString();//

                this.orgDocuments = JsonConvert.DeserializeObject<List<Documents>>(JsonConvert.SerializeObject(this.documents));

            }

        }

        public void DocumentListBinding()

        {

            ColProjects.DataSource = informations.ProjectList.Where(x => x.GroupID.Equals(informations.ActiveProject.ProjectID)).ToList();

            ColProjects.DisplayMember = "Name";

            var workUsers = informations.UserList.Where(x => (new string[] { "Manager", "User" }).Contains(x.Role) && string.IsNullOrEmpty(x.RefProjectID));

            var clientUsers = informations.UserList.Where(x => !string.IsNullOrEmpty(x.RefProjectID));

                        {

                            if (e.Row.DataBoundItem is Documents doc)

                            {

                                {

                                }

                            }

                        }

                               //NPS = ws.Rows[p.Row.Index].Cells[0].Value == null ? 0 : Convert.ToSingle(ws.Rows[p.Row.Index].Cells[0].Value),

                               //Thickness = p.Value == null ? 0 : Convert.ToSingle(p.Value)

                               //Place = ws.Rows[p.Index].Cells[5].Value == null ? string.Empty : ws.Rows[p.Index].Cells[5].Value.ToString(),

                               DocumentNo = ws.Rows[p.Index].Cells[6].Value == null ? string.Empty : ws.Rows[p.Index].Cells[6].Value.ToString(),

                               PersonInCharge = ws.Rows[p.Index].Cells[7].Value == null ? string.Empty : this.GetUser(ws.Rows[p.Index].Cells[7].Value.ToString()).ID,

                            //templateWorksheet.Cells[rowIndex, 3].Value = doc.DocumentNo;

                            //templateWorksheet.Cells[rowIndex, 4].Value = doc.DocumentNo;

                            //templateWorksheet.Cells[rowIndex, 5].Value = doc.Place;

                            templateWorksheet.Cells[rowIndex, 6].Value = doc.DocumentNo;

                            templateWorksheet.Cells[rowIndex, 8].Value = doc.JobLevel;

                            templateWorksheet.Cells[rowIndex, 9].Value = doc.IsTypical;

                            templateWorksheet.Cells[rowIndex, 10].Value = doc.RevisonNo;

            ColumnGroupsViewDefinition columnGroupsView = new ColumnGroupsViewDefinition();

            List<string> docLinkColNames = new List<string>() { "AutoCADLink", "PDFLink", "MarkupLink", "AVEVALink" };

            List<string> rvToColNames = new List<string>() { "ToIsDiscussion", "ToRemarks", "ToModifier", "ToCapturePath", "ToIsMarkup" };

            List<string> rvFrColNames = new List<string>() { "FrReviewStatus", "FrRemarks", "FrModifier", "FrCapturePath", "FrIsMarkup" };

            List<string> rvEtcColNames = new List<string>() { "IsID2Work" };