public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
UserInfo userInfo = null;
bool _IsLogin = EyouSoft.Security.Membership.UserProvider.IsUserLogin(out userInfo);
if (!_IsLogin)
{
return;
}
int areaId = Utils.GetInt(Utils.GetQueryStringValue("areaId"));
if (areaId > 0)
{
EyouSoft.BLL.CompanyStructure.Area bll = new EyouSoft.BLL.CompanyStructure.Area(userInfo);
EyouSoft.Model.CompanyStructure.Area model = bll.GetModel(areaId);
IList <EyouSoft.Model.CompanyStructure.UserArea> list = new
List <EyouSoft.Model.CompanyStructure.UserArea>();
if (model != null)
{
list = model.AreaUserList;
}
context.Response.Write(JsonConvert.SerializeObject(list));
}
}
/// <summary>
/// 根据当前登录用户获取同级及下级部门人员的线路区域信息集合
/// </summary>
/// <param name="us">用户信息集合</param>
/// <returns></returns>
public IList <EyouSoft.Model.CompanyStructure.Area> GetAreas(string us)
{
IList <EyouSoft.Model.CompanyStructure.Area> ls = new List <EyouSoft.Model.CompanyStructure.Area>();
EyouSoft.Model.CompanyStructure.Area model = null;
string sql = string.Format("select * from tbl_Area where Id in (select AreaId from tbl_UserArea where UserId in ({0}))", us);
DbCommand cmd = _db.GetSqlStringCommand(sql);
using (IDataReader rdr = EyouSoft.Toolkit.DAL.DbHelper.ExecuteReader(cmd, this._db))
{
while (rdr.Read())
{
model = new EyouSoft.Model.CompanyStructure.Area();
model.Id = rdr.GetInt32(rdr.GetOrdinal("Id"));
model.AreaName = rdr.GetString(rdr.GetOrdinal("AreaName"));
model.CompanyId = rdr.GetInt32(rdr.GetOrdinal("CompanyId"));
model.OperatorId = rdr.GetInt32(rdr.GetOrdinal("OperatorId"));
model.IssueTime = rdr.GetDateTime(rdr.GetOrdinal("IssueTime"));
model.IsDelete = Convert.ToBoolean(rdr.GetOrdinal("IsDelete"));
ls.Add(model);
}
}
return(ls);
}
/// <summary>
/// 获取线路区域集合
/// </summary>
/// <param name="userId">用户ID</param>
/// <returns></returns>
public IList <EyouSoft.Model.CompanyStructure.Area> GetAreaList(int userId)
{
IList <EyouSoft.Model.CompanyStructure.Area> lsArea = new List <EyouSoft.Model.CompanyStructure.Area>();
EyouSoft.Model.CompanyStructure.Area areaModel = null;
DbCommand cmd = this._db.GetSqlStringCommand(SQL_GetAreaList);
this._db.AddInParameter(cmd, "UserId", DbType.Int32, userId);
using (IDataReader rdr = EyouSoft.Toolkit.DAL.DbHelper.ExecuteReader(cmd, this._db))
{
while (rdr.Read())
{
areaModel = new EyouSoft.Model.CompanyStructure.Area();
areaModel.Id = rdr.GetInt32(rdr.GetOrdinal("Id"));
areaModel.AreaName = rdr.GetString(rdr.GetOrdinal("AreaName"));
areaModel.CompanyId = rdr.GetInt32(rdr.GetOrdinal("CompanyId"));
areaModel.OperatorId = rdr.GetInt32(rdr.GetOrdinal("OperatorId"));
areaModel.IssueTime = rdr.GetDateTime(rdr.GetOrdinal("IssueTime"));
areaModel.IsDelete = Convert.ToBoolean(rdr.GetOrdinal("IsDelete"));
lsArea.Add(areaModel);
}
}
return(lsArea);
}
/// <summary>
/// 修改
/// </summary>
/// <param name="model">线路区域实体</param>
/// <returns>true:成功 false:失败</returns>
public bool Update(EyouSoft.Model.CompanyStructure.Area model, string[] userIds)
{
bool result = false;
result = Dal.Update(model, userIds);
handleLogsBll.Add(AddLogs("修改", result));
return(result);
}
protected void BindAreaInfo()
{
//计划中心业务逻辑类
EyouSoft.BLL.TourStructure.Tour bll = new EyouSoft.BLL.TourStructure.Tour();
//计划团队信息实体类
string TourId = Utils.GetQueryStringValue("tourId");
if (TourId != null && TourId != "")
{
model = (EyouSoft.Model.TourStructure.TourInfo)bll.GetTourInfo(TourId);
if (model != null)
{
this.lt_xianluName.Text = model.RouteName;
this.lt_teamCode.Text = model.TourCode;
this.lt_startDate.Text = model.LDate.ToShortDateString();
this.lt_shengyu.Text = (model.PlanPeopleNumber - model.VirtualPeopleNumber).ToString();
//计调员
this.litCoordinatorId.Text = model.Coordinator.Name.ToString();
//计调员编号
this.hidCoordinatorId.Value = model.Coordinator.CoordinatorId.ToString();
#region 线路区域
int Areaid = model.AreaId;
EyouSoft.BLL.CompanyStructure.Area AreaBll = new EyouSoft.BLL.CompanyStructure.Area();
EyouSoft.Model.CompanyStructure.Area Area = new EyouSoft.Model.CompanyStructure.Area();
Area = AreaBll.GetModel(Areaid);
//计调员
if (Area != null)
{
this.Area.Text = Area.AreaName;
}
#endregion
//销售员
EyouSoft.Model.CompanyStructure.CustomerInfo Customer = new EyouSoft.BLL.CompanyStructure.Customer().GetCustomerModel(SiteUserInfo.TourCompany.TourCompanyId);
if (Customer != null)
{
this.litseller.Text = Customer.Saler;
}
}
}
//初始化联系人
this.txtContactName.Text = SiteUserInfo.ContactInfo.ContactName;
//电话
this.txtContactPhone.Text = SiteUserInfo.ContactInfo.ContactTel;
//手机
this.txtContactMobile.Text = SiteUserInfo.ContactInfo.ContactMobile;
//传真
this.txtContactFax.Text = SiteUserInfo.ContactInfo.ContactFax;
}
/// <summary>
/// 修改
/// </summary>
/// <param name="model">线路区域实体</param>
/// <returns>true:成功 false:失败</returns>
public bool Update(EyouSoft.Model.CompanyStructure.Area model, string[] userIds)
{
DbCommand cmd = this._db.GetStoredProcCommand("proc_UserArea_Update");
this._db.AddInParameter(cmd, "Id", DbType.Int32, model.Id);
this._db.AddInParameter(cmd, "AreaName", DbType.String, model.AreaName);
this._db.AddInParameter(cmd, "UserAreaXml", DbType.String, this.CreateAreaUserXML(model.AreaUserList));
this._db.AddOutParameter(cmd, "Result", DbType.Int32, 4);
_db.AddInParameter(cmd, "SortId", DbType.Int32, model.SortId);
EyouSoft.Toolkit.DAL.DbHelper.RunProcedure(cmd, this._db);
object obj = this._db.GetParameterValue(cmd, "Result");
return(Convert.ToInt32(obj) > 0 ? true : false);
}
protected string GetAreaName(string AreaID)
{
EyouSoft.BLL.CompanyStructure.Area Area = new EyouSoft.BLL.CompanyStructure.Area();
EyouSoft.Model.CompanyStructure.Area AreaM = new EyouSoft.Model.CompanyStructure.Area();
AreaM = Area.GetModel(Convert.ToInt32(AreaID));
if (AreaM != null)
{
return(AreaM.AreaName.ToString());
}
else
{
return("");
}
}
/// <summary>
/// 获取线路区域实体
/// </summary>
/// <param name="Id">主键编号</param>
/// <returns></returns>
public EyouSoft.Model.CompanyStructure.Area GetModel(int Id)
{
EyouSoft.Model.CompanyStructure.Area areaModel = null;
DbCommand cmd = this._db.GetStoredProcCommand("proc_Area_GetAreaInfo");
this._db.AddInParameter(cmd, "Id", DbType.Int32, Id);
using (IDataReader rdr = EyouSoft.Toolkit.DAL.DbHelper.ExecuteReader(cmd, this._db))
{
if (rdr.Read())
{
#region 线路区域信息
areaModel = new EyouSoft.Model.CompanyStructure.Area();
areaModel.Id = rdr.GetInt32(rdr.GetOrdinal("Id"));
areaModel.AreaName = rdr.GetString(rdr.GetOrdinal("AreaName"));
areaModel.CompanyId = rdr.GetInt32(rdr.GetOrdinal("CompanyId"));
areaModel.OperatorId = rdr.GetInt32(rdr.GetOrdinal("OperatorId"));
areaModel.IssueTime = rdr.GetDateTime(rdr.GetOrdinal("IssueTime"));
areaModel.IsDelete = Convert.ToBoolean(rdr.GetOrdinal("IsDelete"));
areaModel.SortId = rdr.GetInt32(rdr.GetOrdinal("SortId"));
#endregion
#region 计调员信息
rdr.NextResult();
IList <EyouSoft.Model.CompanyStructure.UserArea> lsUserArea = new List <EyouSoft.Model.CompanyStructure.UserArea>();
while (rdr.Read())
{
EyouSoft.Model.CompanyStructure.UserArea userAreaModel = new EyouSoft.Model.CompanyStructure.UserArea();
userAreaModel.AreaId = rdr.GetInt32(rdr.GetOrdinal("AreaId"));
userAreaModel.UserId = rdr.GetInt32(rdr.GetOrdinal("UserId"));
userAreaModel.ContactName = rdr.IsDBNull(rdr.GetOrdinal("ContactName")) ? "" : rdr.GetString(rdr.GetOrdinal("ContactName"));
lsUserArea.Add(userAreaModel);
userAreaModel = null;
}
#endregion
areaModel.AreaUserList = lsUserArea;
}
}
return(areaModel);
}
/// <summary>
/// 添加
/// </summary>
/// <param name="model">线路区域实体</param>
/// <param name="userIds">用户编号</param>
/// <returns>true:成功 false:失败</returns>
public bool Add(EyouSoft.Model.CompanyStructure.Area model, string[] userIds)
{
DbCommand cmd = this._db.GetSqlStringCommand(SQL_INSERT_Area);
StringBuilder SQL_INSERT_AreaUser = new StringBuilder();
this._db.AddInParameter(cmd, "AreaName", DbType.String, model.AreaName);
this._db.AddInParameter(cmd, "CompanyId", DbType.Int32, model.CompanyId);
this._db.AddInParameter(cmd, "OperatorId", DbType.Int32, model.OperatorId);
this._db.AddInParameter(cmd, "IsDelete", DbType.String, model.IsDelete == true ? "1" : "0");
_db.AddInParameter(cmd, "SortId", DbType.Int32, model.SortId);
object obj = EyouSoft.Toolkit.DAL.DbHelper.GetSingle(cmd, this._db);
foreach (string str in userIds)
{
SQL_INSERT_AreaUser.AppendFormat("insert into tbl_UserArea (UserId,AreaId) values({0},{1});", Convert.ToInt32(str), Convert.ToInt32(obj));
}
DbCommand cmdUserArea = this._db.GetSqlStringCommand(SQL_INSERT_AreaUser.ToString());
return(EyouSoft.Toolkit.DAL.DbHelper.ExecuteSqlTrans(cmdUserArea, this._db) > 0 ? true : false);
}
/// <summary>
/// 绑定线路专线
/// </summary>
protected void InitBindLine()
{
TourDisplayType = new EyouSoft.BLL.CompanyStructure.CompanySetting().GetSiteTourDisplayType(SiteUserInfo.CompanyID);
tBll = new EyouSoft.BLL.TourStructure.Tour(SiteUserInfo, true);
aBll = new EyouSoft.BLL.CompanyStructure.Area(SiteUserInfo);
for (int i = 0; i < SiteUserInfo.Areas.Length; i++)
{
EyouSoft.Model.CompanyStructure.Area aModel = aBll.GetModel(SiteUserInfo.Areas[i]);
if (aModel != null)
{
IList <EyouSoft.Model.TourStructure.LBZTTours> li = tBll.GetToursZTDSY(SiteUserInfo.CompanyID, SiteUserInfo.Areas[i], 4, TourDisplayType);
if (li != null)
{
arealist.Add(li);
areaname.Add(aModel.AreaName);
areaIdList.Add(aModel.Id.ToString());
}
}
}
}
/// <summary>
/// 获取当前公司的所有线路区域信息
/// </summary>
/// <param name="companyId">公司ID</param>
/// <returns></returns>
public IList <EyouSoft.Model.CompanyStructure.Area> GetAreaByCompanyId(int companyId)
{
IList <EyouSoft.Model.CompanyStructure.Area> lsArea = new List <EyouSoft.Model.CompanyStructure.Area>();
EyouSoft.Model.CompanyStructure.Area areaModel = null;
DbCommand cmd = this._db.GetSqlStringCommand(SQL_GetAreaByCompanyId);
this._db.AddInParameter(cmd, "CompanyId", DbType.Int32, companyId);
using (IDataReader rdr = EyouSoft.Toolkit.DAL.DbHelper.ExecuteReader(cmd, this._db))
{
while (rdr.Read())
{
areaModel = new EyouSoft.Model.CompanyStructure.Area();
areaModel.Id = rdr.GetInt32(rdr.GetOrdinal("Id"));
areaModel.AreaName = rdr.GetString(rdr.GetOrdinal("AreaName"));
lsArea.Add(areaModel);
}
}
return(lsArea);
}
/// <summary>
/// 分页获取公司线路区域集合
/// </summary>
/// <param name="PageSize">每页显示条数</param>
/// <param name="PageIndex">当前页码</param>
/// <param name="RecordCount">总记录数</param>
/// <param name="CompanyId">公司编号</param>
/// <returns>公司线路区域集合</returns>
public IList <EyouSoft.Model.CompanyStructure.Area> GetList(int PageSize, int PageIndex, ref int RecordCount, int CompanyId)
{
IList <EyouSoft.Model.CompanyStructure.Area> totals = new List <EyouSoft.Model.CompanyStructure.Area>();
string tableName = "tbl_Area";
string primaryKey = "Id";
string orderByString = "SortId ASC,IssueTime desc";
StringBuilder fields = new StringBuilder();
fields.Append(" Id, AreaName, CompanyId, OperatorId, IssueTime,IsDelete,");
fields.Append(" (select UserId,AreaId,ContactName from tbl_UserArea a left join tbl_CompanyUser b on a.UserId = b.Id where a.AreaId = tbl_Area.Id and b.IsDelete = '0' and b.IsEnable = '1' and b.UserType = 2 for xml raw,root('root')) as UserAreaXML");
fields.Append(" ,SortId ");
StringBuilder cmdQuery = new StringBuilder(" IsDelete='0' ");
cmdQuery.AppendFormat(" and CompanyId='{0}' ", CompanyId);
using (IDataReader rdr = EyouSoft.Toolkit.DAL.DbHelper.ExecuteReader(this._db, PageSize, PageIndex, ref RecordCount, tableName, primaryKey, fields.ToString(), cmdQuery.ToString(), orderByString))
{
while (rdr.Read())
{
EyouSoft.Model.CompanyStructure.Area areaInfo = new EyouSoft.Model.CompanyStructure.Area();
areaInfo.Id = rdr.GetInt32(rdr.GetOrdinal("Id"));
areaInfo.AreaName = rdr.GetString(rdr.GetOrdinal("AreaName"));
areaInfo.CompanyId = rdr.GetInt32(rdr.GetOrdinal("CompanyId"));
areaInfo.OperatorId = rdr.GetInt32(rdr.GetOrdinal("OperatorId"));
areaInfo.IssueTime = rdr.GetDateTime(rdr.GetOrdinal("IssueTime"));
areaInfo.IsDelete = Convert.ToBoolean(rdr.GetOrdinal("IsDelete"));
areaInfo.AreaUserList = GetUserAreaList(rdr.IsDBNull(rdr.GetOrdinal("UserAreaXML")) ? "" : rdr.GetString(rdr.GetOrdinal("UserAreaXML")));
areaInfo.SortId = rdr.GetInt32(rdr.GetOrdinal("SortId"));
totals.Add(areaInfo);
}
}
return(totals);
}
protected void Page_Load(object sender, EventArgs e)
{
#region 除报价信息
string action = Utils.GetQueryStringValue("action");
if (action == "delete")
{
string QuoteID = Utils.GetQueryStringValue("Majorid");
if (!string.IsNullOrEmpty(QuoteID) && Utils.GetInt(QuoteID) > 0)
{
this.DelQouteList(Utils.GetInt(QuoteID));
}
}
#endregion
#region 初始化报价信息
if (action == "update")
{
this.InitBindQuoteList();
this.hideType.Value = "update";
string QuoteID = Utils.GetQueryStringValue("QuoteID");
if (!string.IsNullOrEmpty(QuoteID) && Utils.GetInt(QuoteID) > 0)
{
BllQuote = new EyouSoft.BLL.RouteStructure.Quote();
ModelRouteTeaminfo = new EyouSoft.Model.RouteStructure.QuoteTeamInfo();
ModelRouteTeaminfo = BllQuote.GetQuoteInfo(Utils.GetInt(QuoteID));
if (ModelRouteTeaminfo != null)
{
//询价单位编号
this.hidCustId.Value = ModelRouteTeaminfo.QuoteUnitsId.ToString();
//询价单位
this.Txt_Inquiry.Value = ModelRouteTeaminfo.QuoteUnitsName;
//联系人
this.Txt_Contact.Value = ModelRouteTeaminfo.ContactName;
//联系电话
this.Txt_TelPhone.Value = ModelRouteTeaminfo.ContactTel;
//预计出团时间
this.Txt_GroupStarTime.Value = ModelRouteTeaminfo.TmpLeaveDate.ToString("yyyy-MM-dd");
//人数
this.Txt_Numbers.Value = ModelRouteTeaminfo.PeopleNum.ToString();
//客人要求
this.ProjectControl.SetList = ModelRouteTeaminfo.Requirements;
this.ProjectControl.SetDataList();
//价格组成
this.PriceControl1.SetList = ModelRouteTeaminfo.Services;
this.PriceControl1.TotalAmount = ModelRouteTeaminfo.SelfQuoteSum;
//备注
this.Txt_RemarksBottom.Value = ModelRouteTeaminfo.Remark;
}
}
ModelRouteTeaminfo = null;
BllQuote = null;
}
if (!this.Page.IsPostBack)
{
this.InitBindQuoteList();
#region 计调员
int areaid = Utils.GetInt(Utils.GetQueryStringValue("areaid"));
if (areaid > 0)
{
EyouSoft.BLL.CompanyStructure.Area area = new EyouSoft.BLL.CompanyStructure.Area();
EyouSoft.Model.CompanyStructure.Area marea = area.GetModel(areaid);
if (marea != null)
{
ddl_Oprator.DataSource = marea.AreaUserList;
ddl_Oprator.DataTextField = "ContactName";
ddl_Oprator.DataValueField = "userid";
ddl_Oprator.DataBind();
}
}
#endregion
}
#endregion
}
protected void Page_Load(object sender, EventArgs e)
{
if (!CheckGrant(global::Common.Enum.TravelPermission.系统设置_基础设置_线路区域栏目))
{
Utils.ResponseNoPermit(global::Common.Enum.TravelPermission.系统设置_基础设置_线路区域栏目, false);
return;
}
int areaId = Utils.GetInt(Utils.GetQueryStringValue("areaId")); //区域Id
string method = Utils.GetFormValue("hidMethod"); //获取当前操作(保存/继续)
string showMess = "数据保存成功"; //提示消息
EyouSoft.Model.CompanyStructure.Area areaModel = null; //线路区域实体
EyouSoft.BLL.CompanyStructure.Area areaBll = new EyouSoft.BLL.CompanyStructure.Area(); //初始化areaBll
areaBll.GetAreaSortId(CurrentUserCompanyID, out MinSortId, out MaxSortId);
//城市Id不为空则添加,否则视为保存
if (method == "")
{
txtOperatorName = selOperator.FindControl("txt_op_Name").ClientID;
txtHidOperatorId = selOperator.FindControl("hd_op_id").ClientID;
#region 初次加载数据
if (areaId != 0)
{
areaModel = areaBll.GetModel(areaId);
if (areaModel != null)
{
areaName = areaModel.AreaName;
AreaSortId = areaModel.SortId;
IList <EyouSoft.Model.CompanyStructure.UserArea> userAreaList = areaModel.AreaUserList;
if (userAreaList != null && userAreaList.Count > 0)
{
StringBuilder operIds = new StringBuilder();
StringBuilder operNames = new StringBuilder();
foreach (var userArea in userAreaList)
{
operIds.AppendFormat("{0},", userArea.UserId);
operNames.AppendFormat("{0},", userArea.ContactName);
}
selOperator.OperId = operIds.ToString().TrimEnd(','); //计调人编号
selOperator.OperName = operNames.ToString().TrimEnd(','); //计调人姓名
}
}
return;
}
#endregion
}
else
{
#region 保存数据
bool result = false;
//构造区域实体
areaModel = new EyouSoft.Model.CompanyStructure.Area();
areaModel.OperatorId = SiteUserInfo.ID;
areaModel.CompanyId = CurrentUserCompanyID;
areaModel.AreaName = Utils.GetFormValue("txtAreaName");//修改线路区域
areaModel.SortId = Utils.GetIntSign(Utils.GetFormValue("txtSortId"));
if (areaModel.AreaName == "")
{
MessageBox.Show(this, "线路区域不为空！");
return;
}
if (!string.IsNullOrEmpty(selOperator.OperId))
{ //赋值责任计调
IList <EyouSoft.Model.CompanyStructure.UserArea> userAreaList = new List <EyouSoft.Model.CompanyStructure.UserArea>();
userAreaList = selOperator.OperId.Split(',').Select(u => new EyouSoft.Model.CompanyStructure.UserArea {
AreaId = areaId, UserId = Utils.GetInt(u)
}).ToList();
areaModel.AreaUserList = userAreaList;
}
if (areaId != 0)
{
areaModel.Id = areaId;
result = areaBll.Update(areaModel, selOperator.OperId.Split(','));//修改线路区域
}
else
{
areaModel.IssueTime = DateTime.Now;
result = areaBll.Add(areaModel, selOperator.OperId.Split(',').ToArray());//添加线路区域
}
if (!result)
{
showMess = "数据保存失败！";
}
//继续添加则刷新页面,否则关闭当前窗口
if (method == "continue")
{
MessageBox.ShowAndRedirect(this, showMess, "EditRouteArea.aspx");
}
else
{
MessageBox.ResponseScript(this, string.Format(";alert('{0}');window.parent.location='/systemset/basicinfo/RouteArea.aspx';window.parent.Boxy.getIframeDialog('{1}').hide()", showMess, Utils.GetQueryStringValue("iframeId")));
}
#endregion
}
}
