コード例 #1
0
        public Boolean insertDocument(documentuc doc)
        {
            Boolean status   = true;
            string  utString = "";

            try
            {
                DocumentDB dc = new DocumentDB();

                DateTime cdt       = DateTime.Now;
                string   updateSQL = "insert into DocumentUC (UserID,Status,CreateTime,CreateUser)" +
                                     "values (" +
                                     "'" + doc.UserID + "'," +
                                     doc.Status + "," +
                                     "GETDATE()" + "," +
                                     "'" + Login.userLoggedIn + "'" + ")";
                utString = utString + updateSQL + Main.QueryDelimiter;
                utString = utString +
                           ActivityLogDB.PrepareActivityLogQquerString("insert", "DocumentUC", "", updateSQL) +
                           Main.QueryDelimiter;
                if (!UpdateTable.UT(utString))
                {
                    status = false;
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error");
                status = false;
            }
            return(status);
        }
コード例 #2
0
ファイル: MenuItemDB.cs プロジェクト: suhasrake/CSLERP
 public static void fillMenuItemCombo(System.Windows.Forms.ComboBox cmb)
 {
     cmb.Items.Clear();
     try
     {
         DocumentDB      dbrecord = new DocumentDB();
         List <document> DocItems = dbrecord.getDocuments();
         foreach (document doc in DocItems)
         {
             cmb.Items.Add(doc.DocumentID + "-" + doc.DocumentName);
         }
     }
     catch (Exception ex)
     {
         MessageBox.Show("fillMenuItemCombo() : Error");
     }
 }
コード例 #3
0
        public DataGridView getDocumentlistGrid()
        {
            DataGridView empGgrid = new DataGridView();

            try
            {
                DataGridViewCheckBoxColumn colChk = new DataGridViewCheckBoxColumn();
                colChk.Width      = 50;
                colChk.Name       = "Select";
                colChk.HeaderText = "Select";
                colChk.ReadOnly   = false;

                DataGridViewCellStyle dataGridViewCellStyle1 = new DataGridViewCellStyle();
                dataGridViewCellStyle1.Alignment          = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;
                dataGridViewCellStyle1.BackColor          = System.Drawing.Color.LightSeaGreen;
                dataGridViewCellStyle1.Font               = new System.Drawing.Font("Arial", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
                dataGridViewCellStyle1.ForeColor          = System.Drawing.SystemColors.WindowText;
                dataGridViewCellStyle1.SelectionBackColor = System.Drawing.SystemColors.Highlight;
                dataGridViewCellStyle1.SelectionForeColor = System.Drawing.SystemColors.HighlightText;
                dataGridViewCellStyle1.WrapMode           = System.Windows.Forms.DataGridViewTriState.True;

                empGgrid.EnableHeadersVisualStyles = false;

                empGgrid.AllowUserToAddRows            = false;
                empGgrid.AllowUserToDeleteRows         = false;
                empGgrid.BackgroundColor               = System.Drawing.SystemColors.GradientActiveCaption;
                empGgrid.BorderStyle                   = System.Windows.Forms.BorderStyle.None;
                empGgrid.ColumnHeadersDefaultCellStyle = dataGridViewCellStyle1;
                empGgrid.EditMode            = System.Windows.Forms.DataGridViewEditMode.EditOnEnter;
                empGgrid.ColumnHeadersHeight = 27;
                empGgrid.RowHeadersVisible   = false;
                empGgrid.Columns.Add(colChk);

                DocumentDB      dbrecord = new DocumentDB();
                List <document> DocItems = dbrecord.getDocuments();
                empGgrid.DataSource = DocItems;
            }
            catch (Exception ex)
            {
            }

            return(empGgrid);
        }
コード例 #4
0
ファイル: MenuItemDB.cs プロジェクト: suhasrake/CSLERP
 public static void fillMenuItemComboNew(System.Windows.Forms.ComboBox cmb)
 {
     cmb.Items.Clear();
     try
     {
         DocumentDB      dbrecord = new DocumentDB();
         List <document> DocItems = dbrecord.getDocuments();
         foreach (document doc in DocItems)
         {
             Structures.ComboBoxItem cbitem =
                 new Structures.ComboBoxItem(doc.DocumentName, doc.DocumentID);
             cmb.Items.Add(cbitem);
         }
     }
     catch (Exception ex)
     {
         MessageBox.Show("fillMenuItemComboNew() : Error");
     }
 }
コード例 #5
0
 public static void fillDocumentIDCumbo(System.Windows.Forms.ComboBox cmb)
 {
     cmb.Items.Clear();
     try
     {
         DocumentDB      docdb   = new DocumentDB();
         List <document> DocList = docdb.getDocuments();
         foreach (document doc in DocList)
         {
             if (doc.DocumentStatus == 1)
             {
                 cmb.Items.Add(doc.DocumentID);
             }
         }
     }
     catch (Exception ex)
     {
         MessageBox.Show(System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error");
     }
 }
コード例 #6
0
        public static void fillCatalogValueComboNew2(System.Windows.Forms.ComboBox cmb, System.Windows.Forms.ComboBox cmb2, System.Windows.Forms.ComboBox cmb3, System.Windows.Forms.Label Label)
        {
            cmb.Items.Clear();
            cmb2.Items.Clear();
            cmb3.Items.Clear();
            try
            {
                CatalogueValueDB        dbrecord        = new CatalogueValueDB();
                List <cataloguevalue>   CatalogueValues = dbrecord.getCatalogueValues().Where(W => W.catalogueID == "POType").ToList();
                List <documentreceiver> ListL2          = new List <documentreceiver>();
                List <documentreceiver> ListL3          = new List <documentreceiver>();
                List <documentreceiver> ListL           = Main.DocumentReceivers.Where(W => W.Status == 1).ToList();
                OfficeDB   obj2    = new OfficeDB();
                DocumentDB obj3    = new DocumentDB();
                var        Ofices  = obj2.getOffices().Where(W => W.status == 1).ToList();
                string     DocName = "";
                foreach (var itm in ListL)
                {
                    documentreceiver obj = new documentreceiver();
                    DocName          = itm.DocumentID;
                    DocName          = DocName.Replace("POSERVICEINWARD", "Service PO");
                    DocName          = DocName.Replace("PAFSERVICEINWARD", "ServicePAF");
                    DocName          = DocName.Replace("POPRODUCTINWARD", "Product PO");
                    DocName          = DocName.Replace("PAFPRODUCTINWARD", "ProductPAF");
                    obj.DocumentName = DocName;
                    obj.OfficeID     = itm.OfficeID;
                    obj.OfficeName   = itm.OfficeName;
                    obj.DocumentID   = itm.DocumentID;
                    ListL2.Add(obj);
                }
                string[] Str = new string[4];
                ////int i = 0;
                foreach (var itm in CatalogueValues)
                {
                    documentreceiver obj = new documentreceiver();
                    DocName          = itm.description;
                    DocName          = DocName.Replace("Service PO", "POSERVICEINWARD");
                    DocName          = DocName.Replace("ServicePAF", "PAFSERVICEINWARD");
                    DocName          = DocName.Replace("Product PO", "POPRODUCTINWARD");
                    DocName          = DocName.Replace("ProductPAF", "PAFPRODUCTINWARD");
                    obj.DocumentID   = DocName;
                    obj.DocumentName = itm.description;
                    ListL3.Add(obj);
                }
                var abcsd = from Ca in CatalogueValues
                            join Ll in ListL2 on Ca.description equals Ll.DocumentName
                            select new
                {
                    DocumentName = Ca.description,
                    DocumentID   = Ll.DocumentID,
                    Ofice        = Ll.OfficeID,
                    OficeName    = Ll.OfficeName
                };
                var Off = from Ca in Ofices
                          join Ll in abcsd on Ca.OfficeID equals Ll.Ofice
                          select Ca;


                // cmb.Items.AddRange(ListL.ToArray());
                foreach (var itm in abcsd.GroupBy(x => x.DocumentName).Select(y => y.FirstOrDefault()).ToList())
                {
                    Structures.ComboBoxItem cbitem =
                        new Structures.ComboBoxItem(itm.DocumentName, itm.DocumentID);
                    cmb.Items.Add(cbitem);
                }
                var Abcd2 = abcsd.GroupBy(x => x.Ofice).Select(y => y.FirstOrDefault()).ToList();
                foreach (var itm in Abcd2)
                {
                    Structures.ComboBoxItem cbitem2 =
                        new Structures.ComboBoxItem(itm.OficeName, itm.Ofice);
                    cmb2.Items.Add(cbitem2);
                }
                foreach (var itm in Ofices.GroupBy(G => G.RegionID))
                {
                    Structures.ComboBoxItem cbitem =
                        new Structures.ComboBoxItem(itm.Key, itm.Select(s => s.RegionName).FirstOrDefault());
                    cmb3.Items.Add(cbitem);
                }

                if (ListL.Count <= 0)
                {
                    Label.Text = "1";
                    var Documents = obj3.getDocuments().Where(W => W.DocumentStatus == 1).ToList();
                    var results   = from x in Documents
                                    join Ll in ListL3 on x.DocumentID equals Ll.DocumentID
                                    select new
                    {
                        DocumntId   = x.DocumentID,
                        documntname = Ll.DocumentName
                    };
                    foreach (var itm in results)
                    {
                        Structures.ComboBoxItem cbitem =
                            new Structures.ComboBoxItem(itm.documntname, itm.DocumntId);
                        cmb.Items.Add(cbitem);
                    }
                    foreach (var itm in Ofices)
                    {
                        Structures.ComboBoxItem cbitem =
                            new Structures.ComboBoxItem(itm.name, itm.OfficeID);
                        cmb2.Items.Add(cbitem);
                    }
                    // offli = Ofices.ToList();
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error");
            }
        }