private void showTourStatusData() { TourStatus tourStatus = new TourStatus(); tourStatus = TourStatusManager.GetTourStatusByTourStatusID(Int32.Parse(Request.QueryString["ID"])); txtTourStatusName.Text = tourStatus.TourStatusName.ToString(); }
public static TourStatus GetTourStatusByTourStatusID(int TourStatusID) { TourStatus tourStatus = new TourStatus(); SqlTourStatusProvider sqlTourStatusProvider = new SqlTourStatusProvider(); tourStatus = sqlTourStatusProvider.GetTourStatusByTourStatusID(TourStatusID); return tourStatus; }
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)); }
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)); }
public static TourStatus GetTourStatusByTourStatusID(int TourStatusID) { TourStatus tourStatus = new TourStatus(); SqlTourStatusProvider sqlTourStatusProvider = new SqlTourStatusProvider(); tourStatus = sqlTourStatusProvider.GetTourStatusByTourStatusID(TourStatusID); return(tourStatus); }
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"); }
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"); }
public IHttpActionResult GetTourStatus(int id) { TourStatus tourStatus = db.TourStatuses.Find(id); if (tourStatus == null) { return(NotFound()); } return(Ok(tourStatus)); }
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; } }
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; } }
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)); }
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; } }
public static bool UpdateTourStatus(TourStatus tourStatus) { SqlTourStatusProvider sqlTourStatusProvider = new SqlTourStatusProvider(); return sqlTourStatusProvider.UpdateTourStatus(tourStatus); }
public static int InsertTourStatus(TourStatus tourStatus) { SqlTourStatusProvider sqlTourStatusProvider = new SqlTourStatusProvider(); return sqlTourStatusProvider.InsertTourStatus(tourStatus); }
/// <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); }
public static bool UpdateTourStatus(TourStatus tourStatus) { SqlTourStatusProvider sqlTourStatusProvider = new SqlTourStatusProvider(); return(sqlTourStatusProvider.UpdateTourStatus(tourStatus)); }
public static int InsertTourStatus(TourStatus tourStatus) { SqlTourStatusProvider sqlTourStatusProvider = new SqlTourStatusProvider(); return(sqlTourStatusProvider.InsertTourStatus(tourStatus)); }
/// <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; } }
/// <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 }