コード例 #1
0
        public List <DocCancel> getDocCancelValues()
        {
            DocCancel        Docval;
            List <DocCancel> DocValues = new List <DocCancel>();

            try
            {
                SqlConnection conn       = new SqlConnection(Login.connString);
                string        empLogedin = Login.userLoggedIn;
                string        query      = "select distinct a.DocumentID,a.DocumentName,a.TableName  from Document a , DocEmpMapping b ,DocumentUC c" +
                                           " where a.DocumentID = b.DocumentID and" +
                                           " a.IsReversible = 1 and b.SeniorEmployeeID = '" + Login.empLoggedIn + "' or " +
                                           "c.UserID = (select distinct UserID from ViewUserEmployeeList a where a.EmployeeID = '" + Login.empLoggedIn + "' )" +
                                           "and c.Status = 1 and a.TableName != 'NULL'and a.IsReversible = 1 order by a.DocumentName";
                SqlCommand cmd = new SqlCommand(query, conn);
                conn.Open();
                SqlDataReader reader = cmd.ExecuteReader();
                while (reader.Read())
                {
                    Docval              = new DocCancel();
                    Docval.DocumentID   = reader.GetString(0);
                    Docval.DocumentName = reader.GetString(1);
                    Docval.TableName    = reader.GetString(2);
                    DocValues.Add(Docval);
                }
                conn.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error");
            }
            return(DocValues);
        }
コード例 #2
0
ファイル: DocumentCancelDB.cs プロジェクト: suhasrake/CSLERP
        public Boolean updateReceiptVoucherForCancel(DocCancel du)
        {
            Boolean status   = true;
            string  utString = "";

            try
            {
                string updateSQL = "update " + du.TableName + " set Status= 98 where RowID = " + du.RowID + "";
                utString = utString + updateSQL + Main.QueryDelimiter;
                utString = utString + ActivityLogDB.PrepareActivityLogQquerString("update", du.TableName, "", updateSQL) + Main.QueryDelimiter;

                updateSQL = "Delete from InvoiceOutReceipts where RVTemporaryNo='" + du.TemporaryNo + "'" +
                            " and RVTemporaryDate='" + du.TemporaryDate.ToString("yyyy-MM-dd") + "' and RVDocumentID = '" + du.DocumentID + "'";
                utString = utString + updateSQL + Main.QueryDelimiter;
                utString = utString +
                           ActivityLogDB.PrepareActivityLogQquerString("delete", "InvoiceOutReceipts", "", 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);
        }
コード例 #3
0
        public Boolean updateDocForCancel(DocCancel du)
        {
            Boolean status   = true;
            string  utString = "";

            try
            {
                string updateSQL = "update " + du.TableName + " set Status= 98 where RowID = " + du.RowID + "";
                utString = utString + updateSQL + Main.QueryDelimiter;
                utString = utString + ActivityLogDB.PrepareActivityLogQquerString("update", du.TableName, "", 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);
        }
コード例 #4
0
        public List <DocCancel> getDocumentInfo(string tablename, string documentID)
        {
            DocCancel        tb;
            DocumentUnlockDB dbrecord = new DocumentUnlockDB();
            List <DocCancel> tbdata   = new List <DocCancel>();

            try
            {
                SqlConnection conn       = new SqlConnection(Login.connString);
                string        empLogedin = Login.userLoggedIn;
                string        query      = "select DocumentID,TemporaryNo,TemporaryDate,ForwardUser,ForwarderList,RowID from " + tablename +
                                           " where DocumentID = '" + documentID + "' and DocumentStatus BETWEEN 1 AND 98 and Status in (0,96) order by TemporaryNo desc, TemporaryDate desc";
                SqlCommand cmd = new SqlCommand(query, conn);
                conn.Open();
                SqlDataReader reader = cmd.ExecuteReader();
                while (reader.Read())
                {
                    tb               = new DocCancel();
                    tb.DocumentID    = reader.IsDBNull(0) ? "" : reader.GetString(0);
                    tb.TemporaryNo   = reader.GetInt32(1);
                    tb.TemporaryDate = reader.GetDateTime(2);
                    tb.TableName     = tablename;
                    tb.ForwardUser   = reader.IsDBNull(3) ? "" : reader.GetString(3);
                    tb.forwarderlist = reader.IsDBNull(4) ? "" : reader.GetString(4);
                    tb.RowID         = reader.IsDBNull(5) ? 0 : reader.GetInt32(5);

                    tbdata.Add(tb);
                }
                conn.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error");
            }
            return(tbdata);
        }