/// <summary>
/// init repeater
/// </summary>
private void InitRpt()
{
pageIndex = UtilsCommons.GetPadingIndex();
var chaXun = GetChaXunInfo();
var items = new EyouSoft.BLL.GysStructure.BGys().GetDiJieShes(SiteUserInfo.CompanyId, pageSize, pageIndex, ref recordCount, chaXun);
if (items != null && items.Count > 0)
{
rptList.DataSource = items;
rptList.DataBind();
this.ExporPageInfoSelect1.PageLinkURL = Request.ServerVariables["SCRIPT_NAME"].ToString() + "?";
this.ExporPageInfoSelect1.UrlParams = Request.QueryString;
this.ExporPageInfoSelect1.intPageSize = pageSize;
this.ExporPageInfoSelect1.CurrencyPage = pageIndex;
this.ExporPageInfoSelect1.intRecordCount = recordCount;
}
else
{
this.lbMsg.Visible = true;
this.lbMsg.Text = "<tr class=\"odd\"><td height=\"30px\" colspan=\"11\" align=\"center\">暂无数据!</td></tr>";
ExporPageInfoSelect1.Visible = false;
}
}
/// <summary>
/// to xls
/// </summary>
void ToXls()
{
int toXlsRecordCount = UtilsCommons.GetToXlsRecordCount();
if (toXlsRecordCount < 1)
{
ResponseToXls(string.Empty);
}
int _recordCount = 0;
var chaXun = GetChaXunInfo();
var items = new EyouSoft.BLL.GysStructure.BGys().GetQiTas(SiteUserInfo.CompanyId, toXlsRecordCount, 1, ref _recordCount, chaXun);
if (items == null || items.Count == 0)
{
ResponseToXls(string.Empty);
}
var s = new StringBuilder();
s.Append("所在地\t单位名称\t联系人\t交易次数\t交易人数\t结算金额\t未付金额\t质检均分\n");
foreach (var item in items)
{
s.Append(item.CPCD.ProvinceName + "-" + item.CPCD.CityName + "\t");
s.Append(item.GysName + "\t");
s.Append(item.LxrName + "\t");
s.Append(item.JiaoYiXX.JiaoYiCiShu + "\t");
s.Append(item.JiaoYiXX.JiaoYiShuLiang + "\t");
s.Append(item.JiaoYiXX.JieSuanJinE + "\t");
s.Append(item.JiaoYiXX.WeiZhiFuJinE + "\t");
s.Append(item.JiaoYiXX.ZhiJianJunFen + "\n");
}
ResponseToXls(s.ToString());
}
/// <summary>
///to xls
/// </summary>
private void ToXls()
{
int toXlsRecordCount = UtilsCommons.GetToXlsRecordCount();
if (toXlsRecordCount < 1)
{
ResponseToXls(string.Empty);
}
int _recordCount = 0;
var chaXun = GetChaXunInfo();
var items = new EyouSoft.BLL.GysStructure.BGys().GetGouWus(SiteUserInfo.CompanyId, toXlsRecordCount, 1, ref _recordCount, chaXun);
if (items == null || items.Count == 0)
{
ResponseToXls(string.Empty);
}
var s = new StringBuilder();
s.Append("所在地\t商店名称\t商品类别\t联系人\t交易次数\t进店人数\n");
foreach (var item in items)
{
s.Append(item.CPCD.ProvinceName + "-" + item.CPCD.CityName + "\t");
s.Append(item.GysName + "\t");
s.Append(item.ShangPinLeiBie.Replace("\t", " ").Replace("\r\n", " ") + "\t");
s.Append(item.LxrName + "\t");
s.Append(item.JiaoYiXX.JiaoYiCiShu + "\t");
s.Append(item.JiaoYiXX.JiaoYiShuLiang + "\n");
}
ResponseToXls(s.ToString());
}
void Rpt_List()
{
pageIndex = UtilsCommons.GetPadingIndex();
var chaXun = new EyouSoft.Model.GysStructure.MXuanYongChaXunInfo();
chaXun.CountryId = Utils.GetIntNull(Utils.GetQueryStringValue("ddlCountry"));
chaXun.ProvinceId = Utils.GetIntNull(Utils.GetQueryStringValue("ddlProvice"));
chaXun.CityId = Utils.GetIntNull(Utils.GetQueryStringValue("ddlCity"));
chaXun.DistrictId = Utils.GetIntNull(Utils.GetQueryStringValue("ddlArea"));
chaXun.JingDianName = Utils.GetQueryStringValue("textfield");
var items = new EyouSoft.BLL.GysStructure.BGys().GetXuanYongJingDians(SiteUserInfo.CompanyId, pageSize, pageIndex, ref recordCount, chaXun);
if (items != null && items.Count > 0)
{
listCount = items.Count;
rpt_ScenicList.DataSource = items;
rpt_ScenicList.DataBind();
ExporPageInfoSelect1.PageLinkURL = ExporPageInfoSelect1.PageLinkURL = Request.ServerVariables["SCRIPT_NAME"].ToString() + "?";
ExporPageInfoSelect1.UrlParams = Request.QueryString;
ExporPageInfoSelect1.intPageSize = pageSize;
ExporPageInfoSelect1.CurrencyPage = pageIndex;
ExporPageInfoSelect1.intRecordCount = recordCount;
}
else
{
litMsg.Text = "<tr class='old'><td colspan='11' align='center'>没有相关数据</td></tr>";
ExporPageInfoSelect1.Visible = false;
}
}
/// <summary>
/// init repeater
/// </summary>
void InitRpt()
{
int pageSize = 48;
int pageIndex = UtilsCommons.GetPadingIndex();
int recordCount = 0;
var chaXun = new EyouSoft.Model.GysStructure.MXuanYongChaXunInfo();
chaXun.GysName = Utils.GetQueryStringValue("txtName");
chaXun.GysLeiXing = (EyouSoft.Model.EnumType.SourceStructure.SourceType?)Utils.GetEnumValueNull(typeof(EyouSoft.Model.EnumType.SourceStructure.SourceType), Utils.GetQueryStringValue("txtLeiXing"));
chaXun.ProvinceId = Utils.GetIntNull(Utils.GetQueryStringValue("txtProvinceId"));
chaXun.CityId = Utils.GetIntNull(Utils.GetQueryStringValue("txtCityId"));
var items = new EyouSoft.BLL.GysStructure.BGys().GetXuanYongs(CurrentUserCompanyID, pageSize, pageIndex, ref recordCount, chaXun);
if (items != null && items.Count > 0)
{
rpt.DataSource = items;
rpt.DataBind();
}
else
{
}
paging.UrlParams = Request.QueryString;
paging.intPageSize = pageSize;
paging.CurrencyPage = pageIndex;
paging.intRecordCount = recordCount;
paging.Visible = paging.intRecordCount > paging.intPageSize;
//phEmpty.Visible = paging.intRecordCount == 0;
}
/// <summary>
/// to xls
/// </summary>
void ToXls()
{
int toXlsRecordCount = UtilsCommons.GetToXlsRecordCount();
if (toXlsRecordCount < 1)
{
ResponseToXls(string.Empty);
}
if (toXlsRecordCount >= 2000)
{
Utils.RCWE("当前导出数据量较大(一次最多可导出2000个交易明细)，请分批次导出。<a href=\"javascript:history.go(-1)\">点击这里返回</a>");
}
var chaXun = GetChaXunInfo();
object[] heJi;
int _recordCount = 0;
var items = new EyouSoft.BLL.GysStructure.BGys().GetJiaoYiMingXis(SiteUserInfo.CompanyId, GysId, toXlsRecordCount, 1, ref _recordCount, chaXun, out heJi);
if (items == null || items.Count == 0)
{
ResponseToXls(string.Empty);
}
var s = new StringBuilder();
s.Append("团号\t线路名称\t销售员\t计调\t导游\t供应商\t数量\t费用明细\t结算金额\t未付金额\t支付方式\n");
foreach (var item in items)
{
s.Append(item.TourCode + "\t");
s.Append(item.RouteName + "\t");
s.Append(item.XiaoShouYuanName + "\t");
s.Append(item.JiDiaoYuanName + "\t");
s.Append(item.DaoYouname + "\t");
s.Append(item.GysName + "\t");
if (item.AnPaiLeiXing == EyouSoft.Model.EnumType.PlanStructure.PlanProject.国内游轮 || item.AnPaiLeiXing == EyouSoft.Model.EnumType.PlanStructure.PlanProject.涉外游轮)
{
s.Append(item.DShuLiang.ToString("F2") + "\t");
}
else
{
s.Append(item.ShuLiang + "\t");
}
s.Append(item.FeiYongMingXi.Replace("\t", " ").Replace("\r\n", " ").Replace("\r", " ").Replace("\n", " ") + "\t");
s.Append(item.JinE.ToString("F2") + "\t");
s.Append(item.WeiZhiFuJinE.ToString("F2") + "\t");
s.Append(item.ZhiFuFangShi + "\n");
}
ResponseToXls(s.ToString());
}
/// <summary>
/// 初始化供应商账号信息
/// </summary>
private void InitInfo()
{
if (string.IsNullOrEmpty(GysId))
{
return;
}
var info = new EyouSoft.BLL.GysStructure.BGys().GetGysUserInfo(GysId);
if (info == null)
{
return;
}
this.txtAccount.ReadOnly = true;
this.txtAccount.Attributes["style"] = "background-color: #dadada";
txtAccount.Text = info.Username;
txtPwd.Attributes.Add("value", info.Pwd);
txtEdit.Value = "1";
string areaid = string.Empty;
string areaname = string.Empty;
if (info.Areas != null && info.Areas.Count > 0)
{
foreach (var item in info.Areas)
{
areaid += item.AreaId + ",";
areaname += item.AreaName + ",";
}
if (!string.IsNullOrEmpty(areaid))
{
areaid = areaid.TrimEnd(',');
}
if (!string.IsNullOrEmpty(areaname))
{
areaname = areaname.TrimEnd(',');
}
}
LineAreaSelect1.LineAreaSelectID = areaid;
LineAreaSelect1.LineAreaSelectName = areaname;
}
/// <summary>
/// to xls
/// </summary>
void ToXls()
{
int toXlsRecordCount = UtilsCommons.GetToXlsRecordCount();
if (toXlsRecordCount < 1)
{
ResponseToXls(string.Empty);
}
var chaXun = GetChaXunInfo();
object[] heJi;
int _recordCount = 0;
var items = new EyouSoft.BLL.GysStructure.BGys().GetJiaoYiMingXis(SiteUserInfo.CompanyId, GysId, toXlsRecordCount, 1, ref _recordCount, chaXun, out heJi);
if (items == null || items.Count == 0)
{
ResponseToXls(string.Empty);
}
var s = new StringBuilder();
s.Append("团号\t线路名称\t销售员\t计调\t导游\t数量\n");
foreach (var item in items)
{
s.Append(item.TourCode + "\t");
s.Append(item.RouteName + "\t");
s.Append(item.XiaoShouYuanName + "\t");
s.Append(item.JiDiaoYuanName + "\t");
s.Append(item.DaoYouname + "\t");
if (item.AnPaiLeiXing == EyouSoft.Model.EnumType.PlanStructure.PlanProject.国内游轮 || item.AnPaiLeiXing == EyouSoft.Model.EnumType.PlanStructure.PlanProject.涉外游轮)
{
s.Append(item.DShuLiang.ToString("F2") + "\n");
}
else
{
s.Append(item.ShuLiang + "\n");
}
}
ResponseToXls(s.ToString());
}
/// <summary>
/// 初始化
/// </summary>
void InitRpt()
{
pageIndex = UtilsCommons.GetPadingIndex();
var chaXun = GetChaXunInfo();
object[] heJi;
var items = new EyouSoft.BLL.GysStructure.BGys().GetJiaoYiMingXis(SiteUserInfo.CompanyId, GysId, pageSize, pageIndex, ref recordCount, chaXun, out heJi);
if (items != null && items.Count > 0)
{
rptList.DataSource = items;
rptList.DataBind();
if (items[0].AnPaiLeiXing == EyouSoft.Model.EnumType.PlanStructure.PlanProject.国内游轮 || items[0].AnPaiLeiXing == EyouSoft.Model.EnumType.PlanStructure.PlanProject.涉外游轮)
{
ltrShuLiangHeJi.Text = ((decimal)heJi[1]).ToString("F2");
}
else
{
ltrShuLiangHeJi.Text = heJi[0].ToString();
}
ltrJinEHeJi.Text = UtilsCommons.GetMoneyString(heJi[2], ProviderToMoney);
ltrWeiZhiFuJinEHeJi.Text = UtilsCommons.GetMoneyString((decimal)heJi[2] - (decimal)heJi[3], ProviderToMoney);
phEmpty.Visible = false;
phHeJi.Visible = true;
paging.PageLinkURL = Request.ServerVariables["SCRIPT_NAME"].ToString() + "?";
paging.UrlParams = Request.QueryString;
paging.intPageSize = pageSize;
paging.CurrencyPage = pageIndex;
paging.intRecordCount = recordCount;
}
else
{
paging.Visible = false;
phEmpty.Visible = true;
phHeJi.Visible = false;
}
}
/// <summary>
/// 获取线路区域
/// </summary>
/// <returns></returns>
public string GetArea(int routeAreaId)
{
System.Text.StringBuilder area = new System.Text.StringBuilder();
area.Append("<option value=''>-请选择线路区域-</option>");
var info = new EyouSoft.BLL.GysStructure.BGys().GetGysUserInfo(SiteUserInfo.SourceCompanyInfo.CompanyId);
if (info != null && info.Areas != null && info.Areas.Count > 0)
{
foreach (var item in info.Areas)
{
if (routeAreaId == item.AreaId)
{
area.AppendFormat("<option value='{0}' selected='selected'>{1}</option>", item.AreaId, item.AreaName);
}
else
{
area.AppendFormat("<option value='{0}' >{1}</option>", item.AreaId, item.AreaName);
}
}
}
return(area.ToString());
}
/// <summary>
/// init repeater
/// </summary>
void InitRpt()
{
string gysLeiXing = Utils.GetQueryStringValue("type");
var chaXun = GetChaXunInfo();
pageIndex = UtilsCommons.GetPadingIndex();
var items = new EyouSoft.BLL.GysStructure.BGys().GetXuanYongs(SiteUserInfo.CompanyId, pageSize, pageIndex, ref recordCount, chaXun);
if (items != null && items.Count > 0)
{
listCount = items.Count;
RepList.DataSource = items;
RepList.DataBind();
BindPage(Utils.GetQueryStringValue("urltype"));
}
else
{
NodataMsg = "<tr class='old'><td colspan='11' align='center'>没有相关数据</td></tr>";
ExporPageInfoSelect1.Visible = false;
}
}
/// <summary>
/// to xls
/// </summary>
void ToXls()
{
int toXlsRecordCount = UtilsCommons.GetToXlsRecordCount();
if (toXlsRecordCount < 1)
{
ResponseToXls(string.Empty);
}
int _recordCount = 0;
var s = new StringBuilder();
s.Append("所在地\t单位名称\t联系人\t交易次数\t交易人数\t结算金额\t未付金额\t质检均分\t账号分配\t账号状态\n");
var chaXun = GetChaXunInfo();
var items = new EyouSoft.BLL.GysStructure.BGys().GetDiJieShes(SiteUserInfo.CompanyId, toXlsRecordCount, 1, ref _recordCount, chaXun);
if (items != null && items.Count > 0)
{
foreach (var t in items)
{
s.AppendFormat(
"{0}\t{1}\t{2}\t{3}\t{4}\t{5}\t{6}\t{7}\t{8}\t{9}\n",
t.CPCD.ProvinceName + "-" + t.CPCD.CityName,
t.GysName,
t.LxrName,
t.JiaoYiXX.JiaoYiCiShu,
t.JiaoYiXX.JiaoYiShuLiang,
t.JiaoYiXX.JieSuanJinE,
t.JiaoYiXX.WeiZhiFuJinE,
t.JiaoYiXX.ZhiJianJunFen,
string.IsNullOrEmpty(t.UserInfo.UserId) ? "未分配帐号" : t.UserInfo.Username,
t.UserInfo.Status.ToString());
}
}
ResponseToXls(s.ToString());
}
/// <summary>
/// init repeater
/// </summary>
void InitRpt()
{
pageIndex = UtilsCommons.GetPadingIndex();
var chaXun = GetChaXunInfo();
var items = new EyouSoft.BLL.GysStructure.BGys().GetQiTas(SiteUserInfo.CompanyId, pageSize, pageIndex, ref recordCount, chaXun);
if (items != null && items.Count > 0)
{
rptList.DataSource = items;
rptList.DataBind();
this.ExporPageInfoSelect2.PageLinkURL = Request.ServerVariables["SCRIPT_NAME"].ToString() + "?";
this.ExporPageInfoSelect2.UrlParams = Request.QueryString;
this.ExporPageInfoSelect2.intPageSize = pageSize;
this.ExporPageInfoSelect2.CurrencyPage = pageIndex;
this.ExporPageInfoSelect2.intRecordCount = recordCount;
}
else
{
NodataMsg = "<tr class='old'><td colspan='10' align='center'>没有相关数据</td></tr>";
ExporPageInfoSelect2.Visible = false;
}
}
/// <summary>
/// 分配帐号
/// </summary>
/// <returns></returns>
void FenPei()
{
var info = new EyouSoft.BLL.GysStructure.BGys().GetGysUserInfo(GysId);
bool IsAdd = info == null;
string account = Utils.GetFormValue(this.txtAccount.UniqueID);
string pwd = Utils.GetFormValue(this.txtPwd.UniqueID);
if (string.IsNullOrEmpty(account))
{
RCWE(UtilsCommons.AjaxReturnJson("0", "帐号不能为空!"));
}
if (string.IsNullOrEmpty(pwd))
{
RCWE(UtilsCommons.AjaxReturnJson("0", "密码不能为空!"));
}
IList <EyouSoft.Model.SourceStructure.MSourceTravelRouteArea> TravelRouteArea = new List <EyouSoft.Model.SourceStructure.MSourceTravelRouteArea>();
string[] routeAreaList = Utils.GetFormValue(this.LineAreaSelect1.LineAreaSelectIDClient).Split(',');
string[] routeAreaName = Utils.GetFormValue(this.LineAreaSelect1.LineAreaSelectNameClient).Split(',');
if (routeAreaName.Length > 0 && routeAreaList.Length > 0)
{
for (int i = 0; i < routeAreaList.Length; i++)
{
TravelRouteArea.Add(new EyouSoft.Model.SourceStructure.MSourceTravelRouteArea {
RouteAreaId = Utils.GetInt(routeAreaList[i].ToString()), SourceId = GysId, RouteAreaName = routeAreaName[i].ToString().Trim()
});
}
}
EyouSoft.BLL.SourceStructure.BSource bll = new EyouSoft.BLL.SourceStructure.BSource();
int result = 0;
if (IsAdd)
{
result = bll.AddAccountToTravel(GysId, this.SiteUserInfo.CompanyId, account, pwd, this.SiteUserInfo.UserId, this.SiteUserInfo.Username, this.SiteUserInfo.DeptId, TravelRouteArea);
}
else
{
result = bll.UpdateTravelAccountStatus(GysId, EyouSoft.Model.EnumType.ComStructure.UserStatus.正常, pwd, TravelRouteArea, true);
}
if (result == 1)
{
if (IsAdd)
{
RCWE(EyouSoft.Common.UtilsCommons.AjaxReturnJson("1", "分配成功"));
}
else
{
RCWE(EyouSoft.Common.UtilsCommons.AjaxReturnJson("1", "修改成功"));
}
}
else if (result == -1)
{
RCWE(EyouSoft.Common.UtilsCommons.AjaxReturnJson("0", "此帐号已存在,请重新分配!"));
}
else
{
RCWE(EyouSoft.Common.UtilsCommons.AjaxReturnJson("0", "分配失败，请重试!"));
}
}
/// <summary>
/// 删除供应商信息
/// </summary>
void DeleteGys()
{
string s = Utils.GetQueryStringValue("deletegysids");
if (string.IsNullOrEmpty(s))
{
Utils.RCWE(UtilsCommons.AjaxReturnJson("0", "请求异常！"));
}
string[] items = s.Split(',');
if (items == null || items.Length == 0)
{
Utils.RCWE(UtilsCommons.AjaxReturnJson("0", "请求异常！"));
}
EyouSoft.Model.SSOStructure.MUserInfo uinfo = null;
bool isLogin = EyouSoft.Security.Membership.UserProvider.IsLogin(out uinfo);
if (!isLogin)
{
Utils.RCWE(UtilsCommons.AjaxReturnJson("0", "请求异常！"));
}
int privs = -9;
var gysLeXing = new EyouSoft.BLL.GysStructure.BGys().GetGysLeiXing(items[0]);
if (!gysLeXing.HasValue)
{
Utils.RCWE(UtilsCommons.AjaxReturnJson("0", "请求异常！"));
}
switch (gysLeXing.Value)
{
case EyouSoft.Model.EnumType.SourceStructure.SourceType.餐馆: privs = (int)EyouSoft.Model.EnumType.PrivsStructure.Privs.资源管理_餐馆_删除; break;
case EyouSoft.Model.EnumType.SourceStructure.SourceType.车队: privs = (int)EyouSoft.Model.EnumType.PrivsStructure.Privs.资源管理_车队_删除; break;
case EyouSoft.Model.EnumType.SourceStructure.SourceType.地接社: privs = (int)EyouSoft.Model.EnumType.PrivsStructure.Privs.资源管理_地接社_删除; break;
case EyouSoft.Model.EnumType.SourceStructure.SourceType.购物: privs = (int)EyouSoft.Model.EnumType.PrivsStructure.Privs.资源管理_购物_删除; break;
case EyouSoft.Model.EnumType.SourceStructure.SourceType.景点: privs = (int)EyouSoft.Model.EnumType.PrivsStructure.Privs.资源管理_景点_删除; break;
case EyouSoft.Model.EnumType.SourceStructure.SourceType.酒店: privs = (int)EyouSoft.Model.EnumType.PrivsStructure.Privs.资源管理_酒店_删除; break;
case EyouSoft.Model.EnumType.SourceStructure.SourceType.票务: privs = (int)EyouSoft.Model.EnumType.PrivsStructure.Privs.资源管理_票务_删除; break;
case EyouSoft.Model.EnumType.SourceStructure.SourceType.其他: privs = (int)EyouSoft.Model.EnumType.PrivsStructure.Privs.资源管理_其它_删除; break;
case EyouSoft.Model.EnumType.SourceStructure.SourceType.游轮: privs = (int)EyouSoft.Model.EnumType.PrivsStructure.Privs.资源管理_游轮_删除; break;
default: break;
}
if (privs == -9)
{
Utils.RCWE(UtilsCommons.AjaxReturnJson("0", "请求异常！"));
}
if (!EyouSoft.Security.Membership.UserProvider.IsGrant(uinfo.Privs, privs))
{
Utils.RCWE(UtilsCommons.AjaxReturnJson("0", "没有删除权限！"));
}
int f1 = 0;
int f2 = 0;
var bll = new EyouSoft.BLL.GysStructure.BGys();
foreach (var item in items)
{
if (bll.Delete(uinfo.CompanyId, item) == 1)
{
f1++;
}
else
{
f2++;
}
}
bll = null;
if (f1 > 0 && f2 == 0)
{
Utils.RCWE(UtilsCommons.AjaxReturnJson("1", "删除成功！"));
}
if (f1 > 0 && f2 > 0)
{
Utils.RCWE(UtilsCommons.AjaxReturnJson("1", f1 + "个信息删除成功，" + f2 + "个信息不允许删除。"));
}
if (f1 == 0 && f2 > 0)
{
Utils.RCWE(UtilsCommons.AjaxReturnJson("0", f2 + "个信息不允许删除。"));
}
Utils.RCWE(UtilsCommons.AjaxReturnJson("0", "删除失败"));
}
