Exemplo n.º 1
0
    private void showTourStatusData()
    {
        TourStatus tourStatus = new TourStatus();

        tourStatus             = TourStatusManager.GetTourStatusByTourStatusID(Int32.Parse(Request.QueryString["ID"]));
        txtTourStatusName.Text = tourStatus.TourStatusName.ToString();
    }
Exemplo n.º 2
0
 public static TourStatus GetTourStatusByTourStatusID(int TourStatusID)
 {
     TourStatus tourStatus = new TourStatus();
     SqlTourStatusProvider sqlTourStatusProvider = new SqlTourStatusProvider();
     tourStatus = sqlTourStatusProvider.GetTourStatusByTourStatusID(TourStatusID);
     return tourStatus;
 }
Exemplo n.º 3
0
        public IHttpActionResult PostTourStatus(TourStatus tourStatus)
        {
            var existed = db.TourStatuses.Find(tourStatus.TourStatusId);

            if (existed != null)
            {
                existed.DateStart      = tourStatus.DateStart;
                existed.DateFinish     = tourStatus.DateFinish;
                existed.AirportFromId  = tourStatus.AirportFromId;
                existed.AirportToId    = tourStatus.AirportToId;
                existed.TourStatusType = tourStatus.TourStatusType;

                db.Entry(existed).State = EntityState.Modified;
                db.SaveChanges();
            }
            else
            {
                db.TourStatuses.Add(new TourStatus()
                {
                    DateStart      = tourStatus.DateStart,
                    DateFinish     = tourStatus.DateFinish,
                    AirportToId    = tourStatus.AirportToId,
                    TourStatusId   = tourStatus.TourStatusId,
                    AirportFromId  = tourStatus.TourStatusId,
                    TourId         = tourStatus.TourId,
                    TourStatusType = tourStatus.TourStatusType
                });
                db.SaveChanges();
            }

            return(CreatedAtRoute("DefaultApi", new { id = tourStatus.TourStatusId }, tourStatus));
        }
Exemplo n.º 4
0
        public IHttpActionResult PutTourStatus(int id, TourStatus tourStatus)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            if (id != tourStatus.TourStatusId)
            {
                return(BadRequest());
            }

            db.Entry(tourStatus).State = EntityState.Modified;

            try
            {
                db.SaveChanges();
            }
            catch (DbUpdateConcurrencyException)
            {
                if (!TourStatusExists(id))
                {
                    return(NotFound());
                }
                else
                {
                    throw;
                }
            }

            return(StatusCode(HttpStatusCode.NoContent));
        }
Exemplo n.º 5
0
    public static TourStatus GetTourStatusByTourStatusID(int TourStatusID)
    {
        TourStatus            tourStatus            = new TourStatus();
        SqlTourStatusProvider sqlTourStatusProvider = new SqlTourStatusProvider();

        tourStatus = sqlTourStatusProvider.GetTourStatusByTourStatusID(TourStatusID);
        return(tourStatus);
    }
Exemplo n.º 6
0
    protected void btnUpdate_Click(object sender, EventArgs e)
    {
        TourStatus tourStatus = new TourStatus();

        tourStatus.TourStatusID   = int.Parse(Request.QueryString["ID"].ToString());
        tourStatus.TourStatusName = txtTourStatusName.Text;
        bool resutl = TourStatusManager.UpdateTourStatus(tourStatus);

        Response.Redirect("AdminDisplayTourStatus.aspx");
    }
Exemplo n.º 7
0
    protected void btnAdd_Click(object sender, EventArgs e)
    {
        TourStatus tourStatus = new TourStatus();

//	tourStatus.TourStatusID=  int.Parse(ddlTourStatusID.SelectedValue);
        tourStatus.TourStatusName = txtTourStatusName.Text;
        int resutl = TourStatusManager.InsertTourStatus(tourStatus);

        Response.Redirect("AdminDisplayTourStatus.aspx");
    }
Exemplo n.º 8
0
        public IHttpActionResult GetTourStatus(int id)
        {
            TourStatus tourStatus = db.TourStatuses.Find(id);

            if (tourStatus == null)
            {
                return(NotFound());
            }

            return(Ok(tourStatus));
        }
Exemplo n.º 9
0
    public int InsertTourStatus(TourStatus tourStatus)
    {
        using (SqlConnection connection = new SqlConnection(this.ConnectionString))
        {
            SqlCommand cmd = new SqlCommand("InsertTourStatus", connection);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add("@TourStatusID", SqlDbType.Int).Direction = ParameterDirection.Output;
            cmd.Parameters.Add("@TourStatusName", SqlDbType.NVarChar).Value = tourStatus.TourStatusName;
            connection.Open();

            int result = cmd.ExecuteNonQuery();
            return (int)cmd.Parameters["@TourStatusID"].Value;
        }
    }
Exemplo n.º 10
0
    public bool UpdateTourStatus(TourStatus tourStatus)
    {
        using (SqlConnection connection = new SqlConnection(this.ConnectionString))
        {
            SqlCommand cmd = new SqlCommand("UpdateTourStatus", connection);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add("@TourStatusID", SqlDbType.Int).Value = tourStatus.TourStatusID;
            cmd.Parameters.Add("@TourStatusName", SqlDbType.NVarChar).Value = tourStatus.TourStatusName;
            connection.Open();

            int result = cmd.ExecuteNonQuery();
            return result == 1;
        }
    }
Exemplo n.º 11
0
        public IHttpActionResult DeleteTourStatus(int id)
        {
            TourStatus tourStatus = db.TourStatuses.Find(id);

            if (tourStatus == null)
            {
                return(NotFound());
            }

            db.TourStatuses.Remove(tourStatus);
            db.SaveChanges();

            return(Ok(tourStatus));
        }
Exemplo n.º 12
0
    public TourStatus GetTourStatusFromReader(IDataReader reader)
    {
        try
        {
            TourStatus tourStatus = new TourStatus
                (

                     DataAccessObject.IsNULL<int>(reader["TourStatusID"]),
                     DataAccessObject.IsNULL<string>(reader["TourStatusName"])
                );
             return tourStatus;
        }
        catch(Exception ex)
        {
            return null;
        }
    }
Exemplo n.º 13
0
    public int InsertTourStatus(TourStatus tourStatus)
    {
        using (SqlConnection connection = new SqlConnection(this.ConnectionString))
        {
            SqlCommand cmd = new SqlCommand("InsertTourStatus", connection);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add("@TourStatusID", SqlDbType.Int).Direction = ParameterDirection.Output;
            cmd.Parameters.Add("@TourStatusName", SqlDbType.NVarChar).Value = tourStatus.TourStatusName;
            connection.Open();

            int result = cmd.ExecuteNonQuery();
            return (int)cmd.Parameters["@TourStatusID"].Value;
        }
    }
Exemplo n.º 14
0
 public static bool UpdateTourStatus(TourStatus tourStatus)
 {
     SqlTourStatusProvider sqlTourStatusProvider = new SqlTourStatusProvider();
     return sqlTourStatusProvider.UpdateTourStatus(tourStatus);
 }
Exemplo n.º 15
0
 public static int InsertTourStatus(TourStatus tourStatus)
 {
     SqlTourStatusProvider sqlTourStatusProvider = new SqlTourStatusProvider();
     return sqlTourStatusProvider.InsertTourStatus(tourStatus);
 }
Exemplo n.º 16
0
        /// <summary>
        /// 销售报账报账权限控制,返回是否允许销售报账
        /// </summary>
        /// <param name="caoZuoDaoYouShouZhi">是否允许操作导游收入、支出</param>
        bool Privs_XiaoShouBaoZhang(out bool caoZuoDaoYouShouZhi)
        {
            caoZuoDaoYouShouZhi = false;

            //无权限 不可报账
            if (!CheckGrant(Privs.销售中心_销售报账_销售报账操作))
            {
                return(false);
            }

            var tourinfo = new EyouSoft.BLL.TourStructure.BTour().GetTourInfo(Utils.GetQueryStringValue("tourId"));

            if (tourinfo == null)
            {
                return(false);
            }
            if (tourinfo.SaleInfo == null)
            {
                return(false);
            }

            //非本团销售员 不可报账
            if (tourinfo.SaleInfo.SellerId != SiteUserInfo.UserId)
            {
                return(false);
            }

            //合同金额未确认 不可报账
            if (!new EyouSoft.BLL.TourStructure.BTour().GetConfirmMoneyStatus(Utils.GetQueryStringValue("tourId")))
            {
                return(false);
            }

            bool tiaoGuoDaoYouBaoZhang = false;
            var  setting = new EyouSoft.BLL.ComStructure.BComSetting().GetModel(SiteUserInfo.CompanyId);

            if (setting != null)
            {
                tiaoGuoDaoYouBaoZhang = setting.SkipGuide;
            }

            TourStatus[] status = { TourStatus.销售待审 };
            if (tiaoGuoDaoYouBaoZhang)
            {
                status = new TourStatus[] { TourStatus.导游带团, TourStatus.导游报帐, TourStatus.销售待审 }
            }
            ;

            //团队状态判断
            if (!status.Contains(tourinfo.TourStatus))
            {
                return(false);
            }

            if (tiaoGuoDaoYouBaoZhang)
            {
                caoZuoDaoYouShouZhi = true;
            }

            return(true);
        }

        /// <summary>
        /// 计调报账报账权限控制,返回是否允许计调报账
        /// </summary>
        /// <param name="caoZuoDaoYouShouZhi">是否允许操作导游收入、支出</param>
        bool Privs_JiDiaoBaoZhang(out bool caoZuoDaoYouShouZhi)
        {
            caoZuoDaoYouShouZhi = false;

            //无权限 不可报账
            if (!CheckGrant(Privs.计调中心_计调报账_计调报账操作))
            {
                return(false);
            }

            var tourinfo = new EyouSoft.BLL.TourStructure.BTour().GetTourInfo(Utils.GetQueryStringValue("tourId"));

            if (tourinfo == null)
            {
                return(false);
            }
            if (tourinfo.TourPlaner == null || tourinfo.TourPlaner.Count == 0)
            {
                return(false);
            }

            //非本团计调不可报账
            var jidiao = tourinfo.TourPlaner.FirstOrDefault(item => item.PlanerId == SiteUserInfo.UserId);

            if (jidiao == null)
            {
                return(false);
            }

            //合同金额未确认 不可报账
            if (!new EyouSoft.BLL.TourStructure.BTour().GetConfirmMoneyStatus(Utils.GetQueryStringValue("tourId")))
            {
                return(false);
            }

            bool tiaoGuoDaoYouBaoZhang   = false;
            bool tiaoGuoXiaoShouBaoZhang = false;
            var  setting = new EyouSoft.BLL.ComStructure.BComSetting().GetModel(SiteUserInfo.CompanyId);

            if (setting != null)
            {
                tiaoGuoDaoYouBaoZhang   = setting.SkipGuide;
                tiaoGuoXiaoShouBaoZhang = setting.SkipGuide;
            }

            TourStatus[] status = { TourStatus.计调待审 };

            if (tiaoGuoDaoYouBaoZhang)
            {
                if (tiaoGuoXiaoShouBaoZhang)
                {
                    status = new TourStatus[] { TourStatus.导游带团, TourStatus.导游报帐, TourStatus.销售待审, TourStatus.计调待审 };
                }
                else
                {
                    //status = new TourStatus[] { TourStatus.计调待审 };
                }
            }
            else
            {
                if (tiaoGuoXiaoShouBaoZhang)
                {
                    status = new TourStatus[] { TourStatus.销售待审, TourStatus.计调待审 };
                }
                else
                {
                    //status = new TourStatus[] { TourStatus.计调待审 };
                }
            }

            //团队状态判断
            if (!status.Contains(tourinfo.TourStatus))
            {
                return(false);
            }

            //if (tiaoGuoDaoYouBaoZhang && tiaoGuoXiaoShouBaoZhang) caoZuoDaoYouShouZhi = true;
            if (tiaoGuoDaoYouBaoZhang)
            {
                caoZuoDaoYouShouZhi = true;
            }

            return(true);
        }
Exemplo n.º 17
0
    public static bool UpdateTourStatus(TourStatus tourStatus)
    {
        SqlTourStatusProvider sqlTourStatusProvider = new SqlTourStatusProvider();

        return(sqlTourStatusProvider.UpdateTourStatus(tourStatus));
    }
Exemplo n.º 18
0
    public static int InsertTourStatus(TourStatus tourStatus)
    {
        SqlTourStatusProvider sqlTourStatusProvider = new SqlTourStatusProvider();

        return(sqlTourStatusProvider.InsertTourStatus(tourStatus));
    }
Exemplo n.º 19
0
        /// <summary>
        /// 权限判断
        /// </summary>
        private void PowerControl(string tourId)
        {
            int source = Utils.GetInt(Utils.GetQueryStringValue("source"));

            TourMoneyOut.ParentType = (PlanChangeChangeClass?)Utils.GetEnumValueNull(typeof(PlanChangeChangeClass), Utils.GetQueryStringValue("source"));
            if (source == 4)
            {
                TourMoneyOut.IsPlanChangeChange = false;
            }
            //团队实体
            MTourBaseInfo       model      = new BTour().GetTourInfo(tourId) ?? new MTourBaseInfo();
            IList <MGuidInfo>   guideList  = (model.GuideList ?? new List <MGuidInfo>()).Where(item => item.GuidId == SiteUserInfo.UserId).ToList();
            IList <MTourPlaner> tourPlaner = (model.TourPlaner ?? new List <MTourPlaner>()).Where(item => item.PlanerId == SiteUserInfo.UserId).ToList();
            //系统配置实体
            MComSetting comModel = new BComSetting().GetModel(CurrentUserCompanyID) ?? new MComSetting();

            status = model.TourStatus;

            this.pan_OperaterExamineV.Visible = pan_OperaterCheck.Visible = pan_SellsExamineV.Visible = false;

            #region 修改删除权限控制
            //导游报账
            if (source == 1)
            {
                IsSubmit = IsChangeDaoYou = pan_SellsExamineV.Visible = TourMoneyOut.IsChangeDaoYou = TourMoneyOut.IsPlanChangeChange = Privs_DaoYouBaoZhang();
            }

            if (source == 3) //销售报账
            {
                //团队状态
                GetTourType();
                //显示操作
                GetOrderListByTourId(tourId);
                IsSubmit = pan_OperaterExamineV.Visible = TourMoneyOut.IsPlanChangeChange = Privs_XiaoShouBaoZhang(out IsChangeDaoYou);
                TourMoneyOut.IsChangeDaoYou = IsChangeDaoYou;
            }

            //计调报账
            if (source == 2)
            {
                //团队收入
                GetOrderListByTourId(tourId);
                //团队状态
                GetTourType();
                pan_OperaterCheck.Visible   = IsSubmit = TourMoneyOut.IsPlanChangeChange = Privs_JiDiaoBaoZhang(out IsChangeDaoYou);
                TourMoneyOut.IsChangeDaoYou = IsChangeDaoYou;
            }

            #endregion

            /*
             * 财务提交-报销完成
             */
            if (source == 4 && CheckGrant(Privs.财务管理_报销报账_报销完成))
            {
                TourStatus[] status1 = { TourStatus.销售未结算, TourStatus.销售待审, TourStatus.计调待审, TourStatus.待终审, TourStatus.财务核算 };

                if (comModel.SkipGuide)
                {
                    status1 = new TourStatus[] { TourStatus.待终审, TourStatus.财务核算 };
                }

                //报销完成
                pan_ApplyOver.Visible = status1.Contains(model.TourStatus) && (!model.IsSubmit);
                //财务入账
                pan_InAccount.Visible = comModel.IsEnableKis && model.IsSubmit;
            }
            else
            {
                pan_ApplyOver.Visible = false;
                pan_InAccount.Visible = false;
            }
        }
Exemplo n.º 20
0
    public bool UpdateTourStatus(TourStatus tourStatus)
    {
        using (SqlConnection connection = new SqlConnection(this.ConnectionString))
        {
            SqlCommand cmd = new SqlCommand("UpdateTourStatus", connection);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add("@TourStatusID", SqlDbType.Int).Value = tourStatus.TourStatusID;
            cmd.Parameters.Add("@TourStatusName", SqlDbType.NVarChar).Value = tourStatus.TourStatusName;
            connection.Open();

            int result = cmd.ExecuteNonQuery();
            return result == 1;
        }
    }
Exemplo n.º 21
0
    public TourStatus GetTourStatusFromReader(IDataReader reader)
    {
        try
        {
            TourStatus tourStatus = new TourStatus
                (

                     DataAccessObject.IsNULL<int>(reader["TourStatusID"]),
                     DataAccessObject.IsNULL<string>(reader["TourStatusName"])
                );
             return tourStatus;
        }
        catch(Exception ex)
        {
            return null;
        }
    }
Exemplo n.º 22
0
        /// <summary>
        /// 初始化销售报账操作
        /// </summary>
        void InitXiaoShouBaoZhangCaoZuo()
        {
            if (BianGengLeiXing != "xiaoshou")
            {
                return;
            }
            if (!Privs_XiaoShouBaoZhang)
            {
                ltrOperatorHtml.Text = "你没有销售报账权限,不可销售报账。";
                return;
            }

            if (EditXgInfo.TourXiaShouYuanId != SiteUserInfo.UserId)
            {
                ltrOperatorHtml.Text = "非本团销售员,不可销售报账。";
                return;
            }
            //合同金额未确认 不可报账
            if (!new EyouSoft.BLL.TourStructure.BTour().GetConfirmMoneyStatus(EditXgInfo.TourId))
            {
                ltrOperatorHtml.Text = "本团下有未确认的合同,不可销售报账";
                return;
            }

            TourStatus[] status = { TourStatus.销售待审 };
            if (IsTiaoGuoDaoYouBaoZhang)
            {
                status = new TourStatus[] { TourStatus.导游带团, TourStatus.导游报帐, TourStatus.销售待审 }
            }
            ;

            //团队状态判断
            if (!status.Contains(EditXgInfo.TourStatus))
            {
                ltrOperatorHtml.Text = "当前团队状态为" + EditXgInfo.TourStatus + ",不可销售报账。";
                return;
            }
            if (IsTiaoGuoDaoYouBaoZhang)
            {
                IsCaoZuoDaoYouShouZhi = true;
            }
            if (!IsCaoZuoDaoYouShouZhi && EditXgInfo.ZhiFuFangShi == EyouSoft.Model.EnumType.PlanStructure.Payment.导游现付)
            {
                ltrOperatorHtml.Text = "当前安排项为导游现付项,不可变更。";
                return;
            }

            ltrOperatorHtml.Text = "<a id=\"i_a_submit\" href=\"javascript:void(0);\" style=\"text-indent:0px;\">保存</a>";
        }

        /// <summary>
        /// 初始化计调报账操作
        /// </summary>
        void InitJiDiaoBaoZhangCaoZuo()
        {
            if (BianGengLeiXing != "jidiao")
            {
                return;
            }
            if (!Privs_JiDiaoBaoZhang)
            {
                ltrOperatorHtml.Text = "你没有计调报账权限,不可计调报账。";
                return;
            }

            //非本团计调不可报账
            if (!EditXgInfo.TourJiDiaos.Contains(SiteUserInfo.UserId))
            {
                ltrOperatorHtml.Text = "非本团指定计调,不可计调报账。";
                return;
            }

            //合同金额未确认 不可报账
            if (!new EyouSoft.BLL.TourStructure.BTour().GetConfirmMoneyStatus(EditXgInfo.TourId))
            {
                ltrOperatorHtml.Text = "本团下有未确认的合同,不可计调报账";
                return;
            }

            TourStatus[] status = { TourStatus.计调待审 };

            if (IsTiaoGuoDaoYouBaoZhang)
            {
                if (IsTiaoGuoXiaoShouBaoZhang)
                {
                    status = new TourStatus[] { TourStatus.导游带团, TourStatus.导游报帐, TourStatus.销售待审, TourStatus.计调待审 };
                }
                else
                {
                    //status = new TourStatus[] { TourStatus.计调待审 };
                }
            }
            else
            {
                if (IsTiaoGuoXiaoShouBaoZhang)
                {
                    status = new TourStatus[] { TourStatus.销售待审, TourStatus.计调待审 };
                }
                else
                {
                    //status = new TourStatus[] { TourStatus.计调待审 };
                }
            }

            //团队状态判断
            if (!status.Contains(EditXgInfo.TourStatus))
            {
                ltrOperatorHtml.Text = "当前团队状态为" + EditXgInfo.TourStatus + ",不可计调报账。";
                return;
            }
            if (IsTiaoGuoDaoYouBaoZhang)
            {
                IsCaoZuoDaoYouShouZhi = true;
            }
            if (!IsCaoZuoDaoYouShouZhi && EditXgInfo.ZhiFuFangShi == EyouSoft.Model.EnumType.PlanStructure.Payment.导游现付)
            {
                ltrOperatorHtml.Text = "当前安排项为导游现付项,不可变更。";
                return;
            }

            ltrOperatorHtml.Text = "<a id=\"i_a_submit\" href=\"javascript:void(0);\" style=\"text-indent:0px;\">保存</a>";
        }

        /// <summary>
        /// 保存变更信息
        /// </summary>
        void BaoCun()
        {
            var anPaiLeiXing = Utils.GetEnumValue <EyouSoft.Model.EnumType.PlanStructure.PlanProject>(Utils.GetFormValue(txtAnPaiLeiXing.UniqueID), EyouSoft.Model.EnumType.PlanStructure.PlanProject.其它);
            var info         = new EyouSoft.Model.PlanStructure.MPlanCostChange();


            info.ChangeCost = Utils.GetDecimal(Utils.GetFormValue(txtJinE.UniqueID));
            info.ChangeType = EyouSoft.Model.EnumType.PlanStructure.PlanChangeChangeClass.导游报账;

            if (BianGengLeiXing == "xiaoshou")
            {
                info.ChangeType = EyouSoft.Model.EnumType.PlanStructure.PlanChangeChangeClass.销售报账;
            }
            if (BianGengLeiXing == "jidiao")
            {
                info.ChangeType = EyouSoft.Model.EnumType.PlanStructure.PlanChangeChangeClass.计调报账;
            }

            info.IssueTime = DateTime.Now;
            if (anPaiLeiXing == EyouSoft.Model.EnumType.PlanStructure.PlanProject.国内游轮 || anPaiLeiXing == EyouSoft.Model.EnumType.PlanStructure.PlanProject.涉外游轮)
            {
                info.DNum         = Utils.GetDecimal(Utils.GetFormValue(txtRenShu.UniqueID));
                info.PeopleNumber = Convert.ToInt32(info.DNum);
            }
            else
            {
                info.PeopleNumber = Utils.GetInt(Utils.GetFormValue(txtRenShu.UniqueID));
                info.DNum         = info.PeopleNumber;
            }
            info.PlanId        = AnPaiId;
            info.Remark        = Utils.GetFormValue(txtBeiZhu.UniqueID);
            info.Type          = JiaJianLeiXing == "jia";
            info.FeiYongMingXi = Utils.GetFormValue(txtFeiYongMingXi.UniqueID);

            bool bllRetCode = new EyouSoft.BLL.PlanStructure.BPlan().AddOrUpdPlanCostChange(info);

            if (bllRetCode)
            {
                RCWE(UtilsCommons.AjaxReturnJson("1", "操作成功"));
            }
            else
            {
                RCWE(UtilsCommons.AjaxReturnJson("0", "操作失败"));
            }
        }

        #endregion
    }