public void PublishGroup(string jsondata, string version, string equType, string equName)
{
string json_result = string.Empty;
//解析jsondata
if (string.IsNullOrEmpty(jsondata))
{
json_result = "{\"status\":\"false\",\"data\":\"参数不能为空！\"}";
Context.Response.Write(json_result);
HttpContext.Current.ApplicationInstance.CompleteRequest();
return;
}
try
{
JavaScriptSerializer serializer = new JavaScriptSerializer();
Dictionary<string, object> json = (Dictionary<string, object>)serializer.DeserializeObject(jsondata);
Model.tourgroup model = new Model.tourgroup();
BLL.tourgroup bll = new BLL.tourgroup();
int manager_id = 0;
int.TryParse(json["groupteamid"].ToString(), out manager_id);
//验证旅行社的有效性
BLL.manager bll_manager = new BLL.manager();
Model.manager managerModel = bll_manager.GetModel(manager_id);
if (managerModel == null || managerModel.is_lock != 0 || DateTime.Parse(managerModel.end_date) < DateTime.Now)
{
json_result = "{\"status\":\"false\",\"data\":\"此旅行社现不能发团，请联系管理员！\"}";
Context.Response.Write(json_result);
HttpContext.Current.ApplicationInstance.CompleteRequest();
return;
}
model.manager_id = manager_id;
model.channel_id = (int)DTEnums.ChannelEnum.lvtuan;
model.title = json["title"].ToString();
model.category_id = int.Parse(json["category"].ToString());
model.content = "";
model.book_require = json["bookrequire"].ToString();
#region 类别处理
//处理类别，根据名称与标识转为类别ID
int languagetype = 0;
int accounttype = 0;
int linecity = 0;
int property = 0;
int restauranttype = 0;
int tickettype = 0;
int fromplaceid = 0;
int toplaceid = 0;
//将省级名称转为ID
if (json.ContainsKey("fromplace") && !string.IsNullOrEmpty(json["fromplace"].ToString()))
{
fromplaceid = bll_city.GetParentIdByName(json["fromplace"].ToString(), 1);
if (fromplaceid == 0)
{
json_result = "{\"status\":\"false\",\"data\":\"客源地不存在，请重新选择！\"}";
Context.Response.Write(json_result);
HttpContext.Current.ApplicationInstance.CompleteRequest();
return;
}
}
if (json.ContainsKey("toplace") && !string.IsNullOrEmpty(json["toplace"].ToString()))
{
toplaceid = bll_city.GetParentIdByName(json["toplace"].ToString(), 1);
if (toplaceid == 0)
{
json_result = "{\"status\":\"false\",\"data\":\"目的地不存在，请重新选择！\"}";
Context.Response.Write(json_result);
HttpContext.Current.ApplicationInstance.CompleteRequest();
return;
}
}
if (json.ContainsKey("languagetype") && !string.IsNullOrEmpty(json["languagetype"].ToString()))
{
languagetype = bll_category.GetCategoryIdByName(json["languagetype"].ToString(), DTEnums.CategoryEnum.language.ToString());
if (languagetype == 0)
{
json_result = "{\"status\":\"false\",\"data\":\"语种类型不存在，请重新选择！\"}";
Context.Response.Write(json_result);
HttpContext.Current.ApplicationInstance.CompleteRequest();
return;
}
}
if (json.ContainsKey("accounttype") && !string.IsNullOrEmpty(json["accounttype"].ToString()))
{
accounttype = bll_category.GetCategoryIdByName(json["accounttype"].ToString(), DTEnums.CategoryEnum.period.ToString());
if (accounttype == 0)
{
json_result = "{\"status\":\"false\",\"data\":\"账单周期不存在，请重新选择！\"}";
Context.Response.Write(json_result);
HttpContext.Current.ApplicationInstance.CompleteRequest();
return;
}
}
if (json.ContainsKey("linecity") && !string.IsNullOrEmpty(json["linecity"].ToString()))
{
linecity = bll_category.GetCategoryIdByName(json["linecity"].ToString(), DTEnums.CategoryEnum.world.ToString());
if (linecity == 0)
{
json_result = "{\"status\":\"false\",\"data\":\"国际线路不存在，请重新选择！\"}";
Context.Response.Write(json_result);
HttpContext.Current.ApplicationInstance.CompleteRequest();
return;
}
}
if (json.ContainsKey("property") && !string.IsNullOrEmpty(json["property"].ToString()))
{
property = bll_category.GetCategoryIdByName(json["property"].ToString(), DTEnums.CategoryEnum.groupteam.ToString());
if (property == 0)
{
json_result = "{\"status\":\"false\",\"data\":\"团属类型不存在，请重新选择！\"}";
Context.Response.Write(json_result);
HttpContext.Current.ApplicationInstance.CompleteRequest();
return;
}
}
if (json.ContainsKey("restauranttype") && !string.IsNullOrEmpty(json["restauranttype"].ToString()))
{
restauranttype = bll_category.GetCategoryIdByName(json["restauranttype"].ToString(), DTEnums.CategoryEnum.pay.ToString());
if (restauranttype == 0)
{
json_result = "{\"status\":\"false\",\"data\":\"餐厅支付类型不存在，请重新选择！\"}";
Context.Response.Write(json_result);
HttpContext.Current.ApplicationInstance.CompleteRequest();
return;
}
}
if (json.ContainsKey("tickettype") && !string.IsNullOrEmpty(json["tickettype"].ToString()))
{
tickettype = bll_category.GetCategoryIdByName(json["tickettype"].ToString(), DTEnums.CategoryEnum.pay.ToString());
if (tickettype == 0)
{
json_result = "{\"status\":\"false\",\"data\":\"门票支付类型不存在，请重新选择！\"}";
Context.Response.Write(json_result);
HttpContext.Current.ApplicationInstance.CompleteRequest();
return;
}
}
#endregion
model.fromplace_id = fromplaceid;
model.toplace_id = toplaceid;
model.account_type = accounttype;
model.language_type = languagetype;
model.linecity_id = linecity;
model.group_property = property;
model.restaurant_type = restauranttype;
model.ticket_type = tickettype;
model.sex = int.Parse(json["sex"].ToString());
model.is_stay = string.IsNullOrEmpty(json["isstay"].ToString()) ? 0 : int.Parse(json["isstay"].ToString());
model.is_red = 0;
model.is_slide = 0;
model.is_top = 0;
model.people_count = int.Parse(json["peoplecount"].ToString());
model.total_count = int.Parse(json["totalcount"].ToString());
model.service_price = decimal.Parse(json["serviceprice"].ToString());
model.status = 1; //0申请 1正常 2过期
model.sort_id = 99;
model.start_date = json["startdate"].ToString();
model.end_date = json["enddate"].ToString();
model.add_time = DateTime.Now;
model.remark1 = "";
model.remark2 = 0;
model.albums = null;
if (bll.Add(model) < 1)
{
json_result = "{\"status\":\"false\",\"data\":\"发布失败！\"}";
}
else
{
json_result = "{\"status\":\"true\",\"data\":\"发布成功！\"}";
}
}
catch (Exception ex)
{
json_result = "{\"status\":\"false\",\"data\":\"" + ex.Message + "\"}";
}
WriteWebServiceLog(version, equType, equName, "PublishGroup", "");
Context.Response.Write(json_result);
Context.Response.End();
}
/// <summary>
/// 获取实体
/// </summary>
public Model.tourgroup GetTourGroupModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select TOP 1 [id],[channel_id],[manager_id],[category_id],[title],[group_property],[sex],[people_count],[start_date],[end_date],[total_count]");
strSql.Append(" ,(case when f.book_count is null then '0' else f.book_count end) as book_count , ");
strSql.Append(" [is_stay],[book_require],[language_type],[ticket_type],[restaurant_type],[account_type],[linecity_id],[fromplace_id],[toplace_id],[service_price],[status],[content],[add_time],[description],[is_top],[is_slide],[is_red],[remark1],[remark2],[sort_id] ");
strSql.Append(" FROM [dbo].[dt_group] a ");
strSql.Append(" left join (select COUNT(*) as book_count,group_id from dbo.dt_group_guid t group by t.group_id) f on a.id=f.group_id ");
strSql.Append(" where id=@id ");
SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) };
parameters[0].Value = id;
Model.tourgroup model = new Model.tourgroup();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
#region DATA
if (ds.Tables[0].Rows[0]["sort_id"] != null && ds.Tables[0].Rows[0]["sort_id"].ToString() != "")
{
model.sort_id = int.Parse(ds.Tables[0].Rows[0]["sort_id"].ToString());
}
if (ds.Tables[0].Rows[0]["id"] != null && ds.Tables[0].Rows[0]["id"].ToString() != "")
{
model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString());
}
if (ds.Tables[0].Rows[0]["channel_id"] != null && ds.Tables[0].Rows[0]["channel_id"].ToString() != "")
{
model.channel_id = int.Parse(ds.Tables[0].Rows[0]["channel_id"].ToString());
}
if (ds.Tables[0].Rows[0]["manager_id"] != null && ds.Tables[0].Rows[0]["manager_id"].ToString() != "")
{
model.manager_id = int.Parse(ds.Tables[0].Rows[0]["manager_id"].ToString());
}
if (ds.Tables[0].Rows[0]["category_id"] != null && ds.Tables[0].Rows[0]["category_id"].ToString() != "")
{
model.category_id = int.Parse(ds.Tables[0].Rows[0]["category_id"].ToString());
}
if (ds.Tables[0].Rows[0]["title"] != null && ds.Tables[0].Rows[0]["title"].ToString() != "")
{
model.title = ds.Tables[0].Rows[0]["title"].ToString();
}
if (ds.Tables[0].Rows[0]["group_property"] != null && ds.Tables[0].Rows[0]["group_property"].ToString() != "")
{
model.group_property = int.Parse(ds.Tables[0].Rows[0]["group_property"].ToString());
}
if (ds.Tables[0].Rows[0]["sex"] != null && ds.Tables[0].Rows[0]["sex"].ToString() != "")
{
model.sex = int.Parse(ds.Tables[0].Rows[0]["sex"].ToString());
}
if (ds.Tables[0].Rows[0]["people_count"] != null && ds.Tables[0].Rows[0]["people_count"].ToString() != "")
{
model.people_count = int.Parse(ds.Tables[0].Rows[0]["people_count"].ToString());
}
if (ds.Tables[0].Rows[0]["start_date"] != null && ds.Tables[0].Rows[0]["start_date"].ToString() != "")
{
model.start_date = ds.Tables[0].Rows[0]["start_date"].ToString();
}
if (ds.Tables[0].Rows[0]["end_date"] != null && ds.Tables[0].Rows[0]["end_date"].ToString() != "")
{
model.end_date = ds.Tables[0].Rows[0]["end_date"].ToString();
}
if (ds.Tables[0].Rows[0]["total_count"] != null && ds.Tables[0].Rows[0]["total_count"].ToString() != "")
{
model.total_count = int.Parse(ds.Tables[0].Rows[0]["total_count"].ToString());
}
if (ds.Tables[0].Rows[0]["book_count"] != null && ds.Tables[0].Rows[0]["book_count"].ToString() != "")
{
model.book_count = int.Parse(ds.Tables[0].Rows[0]["book_count"].ToString());
}
if (ds.Tables[0].Rows[0]["is_stay"] != null && ds.Tables[0].Rows[0]["is_stay"].ToString() != "")
{
model.is_stay = int.Parse(ds.Tables[0].Rows[0]["is_stay"].ToString());
}
if (ds.Tables[0].Rows[0]["book_require"] != null && ds.Tables[0].Rows[0]["book_require"].ToString() != "")
{
model.book_require = ds.Tables[0].Rows[0]["book_require"].ToString();
}
if (ds.Tables[0].Rows[0]["language_type"] != null && ds.Tables[0].Rows[0]["language_type"].ToString() != "")
{
model.language_type = int.Parse(ds.Tables[0].Rows[0]["language_type"].ToString());
}
if (ds.Tables[0].Rows[0]["ticket_type"] != null && ds.Tables[0].Rows[0]["ticket_type"].ToString() != "")
{
model.ticket_type = int.Parse(ds.Tables[0].Rows[0]["ticket_type"].ToString());
}
if (ds.Tables[0].Rows[0]["restaurant_type"] != null && ds.Tables[0].Rows[0]["restaurant_type"].ToString() != "")
{
model.restaurant_type = int.Parse(ds.Tables[0].Rows[0]["restaurant_type"].ToString());
}
if (ds.Tables[0].Rows[0]["account_type"] != null && ds.Tables[0].Rows[0]["account_type"].ToString() != "")
{
model.account_type = int.Parse(ds.Tables[0].Rows[0]["account_type"].ToString());
}
if (ds.Tables[0].Rows[0]["linecity_id"] != null && ds.Tables[0].Rows[0]["linecity_id"].ToString() != "")
{
model.linecity_id = int.Parse(ds.Tables[0].Rows[0]["linecity_id"].ToString());
}
if (ds.Tables[0].Rows[0]["fromplace_id"] != null && ds.Tables[0].Rows[0]["fromplace_id"].ToString() != "")
{
model.fromplace_id = int.Parse(ds.Tables[0].Rows[0]["fromplace_id"].ToString());
}
if (ds.Tables[0].Rows[0]["toplace_id"] != null && ds.Tables[0].Rows[0]["toplace_id"].ToString() != "")
{
model.toplace_id = int.Parse(ds.Tables[0].Rows[0]["toplace_id"].ToString());
}
if (ds.Tables[0].Rows[0]["service_price"] != null && ds.Tables[0].Rows[0]["service_price"].ToString() != "")
{
model.service_price = decimal.Parse(ds.Tables[0].Rows[0]["service_price"].ToString());
}
if (ds.Tables[0].Rows[0]["status"] != null && ds.Tables[0].Rows[0]["status"].ToString() != "")
{
model.status = int.Parse(ds.Tables[0].Rows[0]["status"].ToString());
}
if (ds.Tables[0].Rows[0]["content"] != null && ds.Tables[0].Rows[0]["content"].ToString() != "")
{
model.content = ds.Tables[0].Rows[0]["content"].ToString();
}
if (ds.Tables[0].Rows[0]["add_time"] != null && ds.Tables[0].Rows[0]["add_time"].ToString() != "")
{
model.add_time = DateTime.Parse(ds.Tables[0].Rows[0]["add_time"].ToString());
}
if (ds.Tables[0].Rows[0]["description"] != null && ds.Tables[0].Rows[0]["description"].ToString() != "")
{
model.description = ds.Tables[0].Rows[0]["description"].ToString();
}
if (ds.Tables[0].Rows[0]["is_top"] != null && ds.Tables[0].Rows[0]["is_top"].ToString() != "")
{
model.is_top = int.Parse(ds.Tables[0].Rows[0]["is_top"].ToString());
}
if (ds.Tables[0].Rows[0]["is_slide"] != null && ds.Tables[0].Rows[0]["is_slide"].ToString() != "")
{
model.is_slide = int.Parse(ds.Tables[0].Rows[0]["is_slide"].ToString());
}
if (ds.Tables[0].Rows[0]["is_red"] != null && ds.Tables[0].Rows[0]["is_red"].ToString() != "")
{
model.is_red = int.Parse(ds.Tables[0].Rows[0]["is_red"].ToString());
}
if (ds.Tables[0].Rows[0]["remark1"] != null && ds.Tables[0].Rows[0]["remark1"].ToString() != "")
{
model.remark1 = ds.Tables[0].Rows[0]["remark1"].ToString();
}
if (ds.Tables[0].Rows[0]["remark2"] != null && ds.Tables[0].Rows[0]["remark2"].ToString() != "")
{
model.remark2 = int.Parse(ds.Tables[0].Rows[0]["remark2"].ToString());
}
#endregion
model.albums = new article_albums().GetList(id);
return model;
}
else
{
return null;
}
}
private bool DoAdd()
{
bool result = true;
Model.tourgroup model = new Model.tourgroup();
BLL.tourgroup bll = new BLL.tourgroup();
Model.manager managerModel = GetAdminInfo();
if (managerModel != null)
{
model.manager_id = managerModel.id;
}
else
{
Response.Redirect("../login.aspx");
}
model.channel_id = this.channel_id;
model.title = txtTitle.Text.Trim();
model.category_id = int.Parse(ddlGroupType.SelectedValue);
model.content ="";
model.book_require = txtContent.Text.Trim();
model.account_type = string.IsNullOrEmpty(ddlAccount.SelectedValue) ? 0 : int.Parse(ddlAccount.SelectedValue);
model.fromplace_id = string.IsNullOrEmpty(ddlFromCity.SelectedValue) ? 0 : int.Parse(ddlFromCity.SelectedValue);
model.language_type = string.IsNullOrEmpty(ddlLanguage.SelectedValue) ? 0 : int.Parse(ddlLanguage.SelectedValue);
model.linecity_id = string.IsNullOrEmpty(ddlLineCity.SelectedValue) ? 0 : int.Parse(ddlLineCity.SelectedValue);
model.group_property = string.IsNullOrEmpty(ddlProperty.SelectedValue) ? 0 : int.Parse(ddlProperty.SelectedValue);
model.restaurant_type = string.IsNullOrEmpty(ddlRestaurant.SelectedValue) ? 0 : int.Parse(ddlRestaurant.SelectedValue);
model.ticket_type = string.IsNullOrEmpty(ddlTicketType.SelectedValue) ? 0 : int.Parse(ddlTicketType.SelectedValue);
model.toplace_id = string.IsNullOrEmpty(ddlToCity.SelectedValue) ? 0 : int.Parse(ddlToCity.SelectedValue);
model.sex = int.Parse(rdoSex.SelectedValue);
model.is_stay = string.IsNullOrEmpty(rdoStayType.SelectedValue) ? 0 : int.Parse(rdoStayType.SelectedValue);
model.is_red = 0;
model.is_slide = 0;
model.is_top = 0;
if (cblItem.Items[0].Selected == true)
{
model.is_top = 1;
}
if ( cblItem.Items[1].Selected == true)
{
model.is_red = 1;
}
model.people_count = int.Parse(txtPeople.Text.Trim());
model.total_count = int.Parse(txtTotal.Text.Trim());
model.service_price = decimal.Parse(txtServicePrice.Text.Trim());
model.status = 1; //0申请 1正常 2过期
model.sort_id = int.Parse(txtSortId.Text.Trim());
model.start_date = txtStartDate.Text.Trim();
model.end_date = txtEndDate.Text.Trim();
model.add_time = DateTime.Now;
model.remark1 = "";
model.remark2 = 0;
model.albums = null;
if (bll.Add(model) < 1)
{
result = false;
}
return result;
}