Ejemplo n.º 1
0
        public static InvoiceEntity InvoiceListSelect(InvoiceEntity invoiceEntity)
        {
            invoiceEntity.LogMessages.MsgType = MessageType.INFO;
            invoiceEntity.LogMessages.Content = _nameSpaceClass + "InvoiceListSelect";
            LoggerHelper.LogWriter(invoiceEntity.LogMessages);

            try
            {
                return InvoiceDA.InvoiceListSelect(invoiceEntity);
            }
            catch (Exception ex)
            {
                invoiceEntity.LogMessages.MsgType = MessageType.ERROR;
                invoiceEntity.LogMessages.Content = _nameSpaceClass + "InvoiceListSelect  Error: " + ex.Message;
                LoggerHelper.LogWriter(invoiceEntity.LogMessages);
                throw ex;
            }
        }
Ejemplo n.º 2
0
        public static InvoiceEntity InvoiceDetailSelect(InvoiceEntity invoiceEntity)
        {
            OracleParameter[] parm ={
                                    new OracleParameter("ID",OracleType.VarChar)
                                };
            InvoiceDBEntity dbParm = (invoiceEntity.InvoiceDBEntity.Count > 0) ? invoiceEntity.InvoiceDBEntity[0] : new InvoiceDBEntity();

            if (String.IsNullOrEmpty(dbParm.InvoiceID))
            {
                parm[0].Value = DBNull.Value;
            }
            else
            {
                parm[0].Value = dbParm.InvoiceID;
            }

            invoiceEntity.QueryResult = HotelVp.Common.DBUtility.DbManager.Query("Invoice", "t_lm_Invoice_detail", false, parm);
            return invoiceEntity;
        }
Ejemplo n.º 3
0
        public static InvoiceEntity InvoiceListExcelSelect(InvoiceEntity invoiceEntity)
        {
            OracleParameter[] parm ={
                                    new OracleParameter("USERID",OracleType.VarChar),
                                    new OracleParameter("CNFNUM",OracleType.VarChar),
                                    new OracleParameter("SENDCODE",OracleType.VarChar),
                                    new OracleParameter("INVSTATUS",OracleType.VarChar),
                                    new OracleParameter("APPLYCHANEL",OracleType.VarChar),
                                    new OracleParameter("APPLYBEGINDATE",OracleType.VarChar),
                                    new OracleParameter("APPLYENDDATE",OracleType.VarChar),
                                    new OracleParameter("SENDBEGINDATE",OracleType.VarChar),
                                    new OracleParameter("SENDENDDATE",OracleType.VarChar),
                                };
            InvoiceDBEntity dbParm = (invoiceEntity.InvoiceDBEntity.Count > 0) ? invoiceEntity.InvoiceDBEntity[0] : new InvoiceDBEntity();

            if (String.IsNullOrEmpty(dbParm.USERID))
            {
                parm[0].Value = DBNull.Value;
            }
            else
            {
                parm[0].Value = dbParm.USERID;
            }

            if (String.IsNullOrEmpty(dbParm.CNFNUM))
            {
                parm[1].Value = DBNull.Value;
            }
            else
            {
                parm[1].Value = dbParm.CNFNUM;
            }

            if (String.IsNullOrEmpty(dbParm.SENDCODE))
            {
                parm[2].Value = DBNull.Value;
            }
            else
            {
                parm[2].Value = dbParm.SENDCODE;
            }

            if (String.IsNullOrEmpty(dbParm.Status))
            {
                parm[3].Value = DBNull.Value;
            }
            else
            {
                parm[3].Value = dbParm.Status;
            }

            if (String.IsNullOrEmpty(dbParm.APPLYCHANEL))
            {
                parm[4].Value = DBNull.Value;
            }
            else
            {
                parm[4].Value = dbParm.APPLYCHANEL;
            }

            if (String.IsNullOrEmpty(dbParm.APPLYBEGINDATE))
            {
                parm[5].Value = DBNull.Value;
            }
            else
            {
                parm[5].Value = dbParm.APPLYBEGINDATE;
            }

            if (String.IsNullOrEmpty(dbParm.APPLYENDDATE))
            {
                parm[6].Value = DBNull.Value;
            }
            else
            {
                parm[6].Value = dbParm.APPLYENDDATE;
            }

            if (String.IsNullOrEmpty(dbParm.SENDBEGINDATE))
            {
                parm[7].Value = DBNull.Value;
            }
            else
            {
                parm[7].Value = dbParm.SENDBEGINDATE;
            }

            if (String.IsNullOrEmpty(dbParm.SENDENDDATE))
            {
                parm[8].Value = DBNull.Value;
            }
            else
            {
                parm[8].Value = dbParm.SENDENDDATE;
            }

            string strSql = "";
            if ("0".Equals(dbParm.SelectType))
            {
                strSql = "t_lm_Invoice_all_excel_top";
            }
            else
            {
                strSql = "t_lm_Invoice_all_excel";
            }

            invoiceEntity.QueryResult = HotelVp.Common.DBUtility.DbManager.Query("Invoice", strSql, false, parm);
            return invoiceEntity;
        }
Ejemplo n.º 4
0
        private static bool CheckInvoiceUpdate(InvoiceEntity invoiceEntity)
        {
            InvoiceDBEntity dbParm = (invoiceEntity.InvoiceDBEntity.Count > 0) ? invoiceEntity.InvoiceDBEntity[0] : new InvoiceDBEntity();
            OracleParameter[] lmchkParm ={
                                    new OracleParameter("ID",OracleType.Number),
                                    new OracleParameter("INVOICENUM",OracleType.VarChar)
                                };

            lmchkParm[0].Value = dbParm.InvoiceID;
            lmchkParm[1].Value = dbParm.INVOICENUM;
            DataSet dsResult = DbManager.Query("Invoice", "t_lm_b_Invoice_update_invoicenum_check", false, lmchkParm);

            if (dsResult.Tables.Count > 0 && dsResult.Tables[0].Rows.Count > 0)
            {
                return false;
            }
            else
            {
                return true;
            }
        }
Ejemplo n.º 5
0
        public static int InvoiceUpdate(InvoiceEntity invoiceEntity)
        {
            if (invoiceEntity.InvoiceDBEntity.Count == 0)
            {
                return 0;
            }

            if (invoiceEntity.LogMessages == null)
            {
                return 0;
            }

            InvoiceDBEntity dbParm = (invoiceEntity.InvoiceDBEntity.Count > 0) ? invoiceEntity.InvoiceDBEntity[0] : new InvoiceDBEntity();
            string onStatus = dbParm.OnlineStatus;
            string ActionType = dbParm.ActionType.ToString();
            if ("0".Equals(ActionType))
            {
                string strSQL = "";
                if ("3".Equals(onStatus))
                {
                    onStatus = "2";
                    strSQL = "t_lm_b_Invoice_update_back_send";
                }
                else if ("2".Equals(onStatus))
                {
                    onStatus = "1";
                    strSQL = "t_lm_b_Invoice_update_back_invoice";
                }

                OracleParameter[] lmBackParm ={
                                    new OracleParameter("ID",OracleType.Number),
                                    new OracleParameter("ONLINESTATUS",OracleType.VarChar),
                                    new OracleParameter("OPERATOR",OracleType.VarChar),
                                    new OracleParameter("REMARK",OracleType.VarChar)

                                };

                lmBackParm[0].Value = dbParm.InvoiceID;
                lmBackParm[1].Value = onStatus;
                lmBackParm[2].Value = invoiceEntity.LogMessages.Username;
                lmBackParm[3].Value = dbParm.Remark;
                DbManager.ExecuteSql("Invoice", strSQL, lmBackParm);
            }
            else
            {
                if ("1".Equals(onStatus))
                {
                    if (!CheckInvoiceUpdate(invoiceEntity))
                    {
                        return 2;
                    }

                    OracleParameter[] lmSaveParm ={
                                    new OracleParameter("ID",OracleType.Number),
                                    new OracleParameter("INVOICENUM",OracleType.VarChar),
                                    new OracleParameter("OPERATOR",OracleType.VarChar),
                                    new OracleParameter("REMARK",OracleType.VarChar)
                                };

                    lmSaveParm[0].Value = dbParm.InvoiceID;
                    lmSaveParm[1].Value = dbParm.INVOICENUM;
                    lmSaveParm[2].Value = invoiceEntity.LogMessages.Username;
                    lmSaveParm[3].Value = dbParm.Remark;
                    DbManager.ExecuteSql("Invoice", "t_lm_b_Invoice_update_invoicenum", lmSaveParm);
                }
                else
                {
                    OracleParameter[] lmSendParm ={
                                    new OracleParameter("ID",OracleType.Number),
                                    new OracleParameter("SENDCODE",OracleType.VarChar),
                                    new OracleParameter("SENDNAME",OracleType.VarChar),
                                    new OracleParameter("OPERATOR",OracleType.VarChar),
                                    new OracleParameter("REMARK",OracleType.VarChar)
                                };

                    lmSendParm[0].Value = dbParm.InvoiceID;
                    lmSendParm[1].Value = dbParm.SENDCODE;
                    lmSendParm[2].Value = dbParm.SENDNAME;
                    lmSendParm[3].Value = invoiceEntity.LogMessages.Username;
                    lmSendParm[4].Value = dbParm.Remark;
                    DbManager.ExecuteSql("Invoice", "t_lm_b_Invoice_update_send", lmSendParm);
                }
            }
            return 1;
        }
Ejemplo n.º 6
0
 public static InvoiceEntity CommonTypeSelect(InvoiceEntity invoiceEntity)
 {
     invoiceEntity.QueryResult = HotelVp.Common.DBUtility.DbManager.Query("Invoice", "t_lm_b_Invoice_type", false);
     return invoiceEntity;
 }