protected void init_form(string ctrID)
{
if (!string.IsNullOrEmpty(ctrID))
{
_WG_ActivitiesEntity = DataProvider.GetInstance().GetWG_ActivitiesEntity(int.Parse(ctrID));
TextBox_Title.Text = _WG_ActivitiesEntity.Title.ToString();
TextBox_PromoterID.Text = _WG_ActivitiesEntity.PromoterID.ToString();
TextBox_LinkMan.Text = _WG_ActivitiesEntity.LinkMan.ToString();
TextBox_LinkPhone.Text = _WG_ActivitiesEntity.LinkPhone.ToString();
TextBox_ActivityType.Text = _WG_ActivitiesEntity.ActivityType.ToString();
TextBox_Region.Text = _WG_ActivitiesEntity.Region.ToString();
TextBox_Address.Text = _WG_ActivitiesEntity.Address.ToString();
TextBox_NeedMenberCount.Text = _WG_ActivitiesEntity.NeedMenberCount.ToString();
TextBox_BeginTime.Text = _WG_ActivitiesEntity.BeginTime.ToString();
TextBox_Detail.Text = _WG_ActivitiesEntity.Detail.ToString();
TextBox_Status.Text = _WG_ActivitiesEntity.Status.ToString();
}
}
private MideFrameWork.Data.Entity.WG_ActivitiesEntity GetWG_Activities(DataRow dr)
{
MideFrameWork.Data.Entity.WG_ActivitiesEntity info = new MideFrameWork.Data.Entity.WG_ActivitiesEntity();
if(DBNull.Value==dr["ID"])
info.ID=0;
else
info.ID=int.Parse(dr["ID"].ToString());
if(DBNull.Value==dr["Title"])
info.Title= string.Empty;
else
info.Title= dr["Title"].ToString();
if(DBNull.Value==dr["PromoterID"])
info.PromoterID=0;
else
info.PromoterID=int.Parse(dr["PromoterID"].ToString());
if(DBNull.Value==dr["LinkMan"])
info.LinkMan= string.Empty;
else
info.LinkMan= dr["LinkMan"].ToString();
if(DBNull.Value==dr["LinkPhone"])
info.LinkPhone= string.Empty;
else
info.LinkPhone= dr["LinkPhone"].ToString();
if(DBNull.Value==dr["ActivityType"])
info.ActivityType= string.Empty;
else
info.ActivityType= dr["ActivityType"].ToString();
if(DBNull.Value==dr["Region"])
info.Region= string.Empty;
else
info.Region= dr["Region"].ToString();
if(DBNull.Value==dr["Address"])
info.Address= string.Empty;
else
info.Address= dr["Address"].ToString();
if(DBNull.Value==dr["NeedMenberCount"])
info.NeedMenberCount=0;
else
info.NeedMenberCount=int.Parse(dr["NeedMenberCount"].ToString());
if(DBNull.Value==dr["BeginTime"])
info.BeginTime=DateTime.Now;
else
info.BeginTime=DateTime.Parse(dr["BeginTime"].ToString());
if(DBNull.Value==dr["Detail"])
info.Detail= string.Empty;
else
info.Detail= dr["Detail"].ToString();
if(DBNull.Value==dr["Status"])
info.Status=0;
else
info.Status=int.Parse(dr["Status"].ToString());
if(DBNull.Value==dr["CreateDate"])
info.CreateDate=DateTime.Now;
else
info.CreateDate=DateTime.Parse(dr["CreateDate"].ToString());
if(DBNull.Value==dr["UpdateDate"])
info.UpdateDate=DateTime.Now;
else
info.UpdateDate=DateTime.Parse(dr["UpdateDate"].ToString());
return info;
}
protected void WG_ActivitiesAdd()
{
#region 判断是否可空
var _Title = Request.Form["TextBox_Title"];
if (string.IsNullOrEmpty(_Title))
{
Alert("[ 活动标题 ]不能为空");
return;
}
var _PromoterID = Request.Form["TextBox_PromoterID"];
if (string.IsNullOrEmpty(_PromoterID))
{
Alert("[ 发起人ID ]不能为空");
return;
}
var _LinkMan = Request.Form["TextBox_LinkMan"];
if (string.IsNullOrEmpty(_LinkMan))
{
Alert("[ 联系人ID ]不能为空");
return;
}
var _LinkPhone = Request.Form["TextBox_LinkPhone"];
if (string.IsNullOrEmpty(_LinkPhone))
{
Alert("[ LinkPhone ]不能为空");
return;
}
var _ActivityType = Request.Form["TextBox_ActivityType"];
if (string.IsNullOrEmpty(_ActivityType))
{
Alert("[ 活动类型ID ]不能为空");
return;
}
var _Region = Request.Form["TextBox_Region"];
if (string.IsNullOrEmpty(_Region))
{
Alert("[ 区域ID ]不能为空");
return;
}
var _Address = Request.Form["TextBox_Address"];
if (string.IsNullOrEmpty(_Address))
{
Alert("[ 联系地址 ]不能为空");
return;
}
var _NeedMenberCount = Request.Form["TextBox_NeedMenberCount"];
if (string.IsNullOrEmpty(_NeedMenberCount))
{
Alert("[ 人员数量 ]不能为空");
return;
}
var _BeginTime = Request.Form["TextBox_BeginTime"];
if (string.IsNullOrEmpty(_BeginTime))
{
Alert("[ 活动日期 ]不能为空");
return;
}
var _Detail = Request.Form["TextBox_Detail"];
if (string.IsNullOrEmpty(_Detail))
{
Alert("[ 活动明细 ]不能为空");
return;
}
var _Status = Request.Form["TextBox_Status"];
if (string.IsNullOrEmpty(_Status))
{
Alert("[ 当前状态 ]不能为空");
return;
}
#endregion
#region 获取数据
WG_ActivitiesEntity _WG_ActivitiesEntity = new WG_ActivitiesEntity();
_WG_ActivitiesEntity.Title =Convert.ToString(_Title.ToString());
_WG_ActivitiesEntity.PromoterID =Convert.ToInt32(_PromoterID.ToString());
_WG_ActivitiesEntity.LinkMan =Convert.ToString(_LinkMan.ToString());
_WG_ActivitiesEntity.LinkPhone =Convert.ToString(_LinkPhone.ToString());
_WG_ActivitiesEntity.ActivityType =Convert.ToString(_ActivityType.ToString());
_WG_ActivitiesEntity.Region =Convert.ToString(_Region.ToString());
_WG_ActivitiesEntity.Address =Convert.ToString(_Address.ToString());
_WG_ActivitiesEntity.NeedMenberCount =Convert.ToInt32(_NeedMenberCount.ToString());
_WG_ActivitiesEntity.BeginTime = Convert.ToDateTime(_BeginTime.ToString());
_WG_ActivitiesEntity.Detail =Convert.ToString(_Detail.ToString());
_WG_ActivitiesEntity.Status =Convert.ToInt32(_Status.ToString());
_WG_ActivitiesEntity.CreateDate =DateTime.Now;
_WG_ActivitiesEntity.UpdateDate =DateTime.Now;
try
{
DataProvider.GetInstance().AddWG_Activities(_WG_ActivitiesEntity);
}
catch
{
WriteLog("WG_ActivitiesAdd", "添加WG_Activities", "插入数据库时出错", Common.DailyUtility.MideSmsType.LogType.SystemLog);
Alert("添加数据时出错，请重试");
return;
}
Alert("添加WG_Activities成功");
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
// todo: [KnownType(typeof(List<WG_ActivitiesEntity>))]
//todo:加入跨域允许语句
context.Response.AddHeader("Access-Control-Allow-Origin", "*");
context.Response.AddHeader("Access-Control-Allow-Methods", "POST");
context.Response.AddHeader("Access-Control-Allow-Headers", "x-requested-with,content-type");
JsonBaseObject jbo = new JsonBaseObject();
string resultStr = string.Empty;
try
{
string menberID = context.Request["menberID"];
string activityID = context.Request["activityID"];
string opc = context.Request["opc"];//1参加活动，2退出活动，3完成活动（发起人权利),4撤销活动,5.获取活动参与者列表，6发布活动
if (string.IsNullOrEmpty(menberID)
|| string.IsNullOrEmpty(activityID)
|| string.IsNullOrEmpty(opc))
{
//参数空
jbo.code = -1;
jbo.data = null;
jbo.message = "用户ID/活动ID/状态都不能为空";
jbo.success = false;
}
else
{
//当前活动，ae.Status，0等待报名...，1活动正在进行(禁止报名),2,活动已结束
WG_ActivitiesEntity ae = new WG_ActivitiesEntity();
if (!string.IsNullOrEmpty(activityID))
ae = DataProvider.GetInstance().GetWG_ActivitiesEntity(int.Parse(activityID));
if (opc == "6")
{
//发布活动，需要权限
string title = context.Request["title"];
string promoterid = context.Request["promoterid"];
string linkman = context.Request["linkman"];
string linkphone = context.Request["linkphone"];
string linkaddress = context.Request["linkaddress"];
string activitytype = context.Request["activitytype"];
string region = context.Request["region"];
string begintime = context.Request["begintime"];
string needmenbercount = context.Request["needmenbercount"];
string detail = context.Request["detail"];
if (!string.IsNullOrEmpty(title)
&& !string.IsNullOrEmpty(linkman)
&& !string.IsNullOrEmpty(linkphone))
{
WG_ActivitiesEntity aee = new WG_ActivitiesEntity();
aee.Title = title;
aee.PromoterID = int.Parse(menberID);
aee.LinkMan = linkman;
aee.LinkPhone = linkphone;
aee.Address = linkaddress;
aee.ActivityType = activitytype;
aee.Region = region;
aee.NeedMenberCount = int.Parse(needmenbercount);
aee.Detail = detail;
aee.BeginTime = Convert.ToDateTime(begintime);
aee.Status = 0;//正在报名中
aee.CreateDate = DateTime.Now;
aee.UpdateDate = DateTime.Now;
DataProvider.GetInstance().AddWG_Activities(aee);
//成功
jbo.code = 0;
jbo.data = null;
jbo.message = "创建活动成功";
jbo.success = false;
}
else
{
//信息不够，不能创建
jbo.code = -1;
jbo.data = null;
jbo.message = "标题，联系人、联系电话不能为空";
jbo.success = false;
}
}
else if (null == ae)
{
//活动不存在
jbo.code = -1;
jbo.data = null;
jbo.message = "活动不存在";
jbo.success = false;
}
else if (opc == "5")
{
#region 获取活动参与者列表
string whereStr = " activityID=" + activityID;
IList<WG_OnGoingActivitiesEntity> ogaeList = DataProvider.GetInstance().GetWG_OnGoingActivitiesList(whereStr);
IList<WG_MenberEntity> meList = new List<WG_MenberEntity>();
if (ogaeList != null && ogaeList.Count > 0)
{
foreach (WG_OnGoingActivitiesEntity item in ogaeList)
{
WG_MenberEntity me = DataProvider.GetInstance().GetWG_MenberEntity(item.MenberID);
meList.Add(me);
}
}
jbo.code = 0;
jbo.data = meList;
jbo.message = "成功获取活动参与者列表";
jbo.success = true;
#endregion
}
else if (ae.Status == 2)
{
//活动已经结束
jbo.code = -1;
jbo.data = null;
jbo.message = "活动已经结束";
jbo.success = false;
}
else if (ae.Status == 1 && opc != "3")
{
//活动已经开始
jbo.code = -1;
jbo.data = null;
jbo.message = "活动已经开始了";
jbo.success = false;
}
else if (ae.Status == 0 && opc == "4" && ae.PromoterID == int.Parse(menberID))
{
//只有在等待报名的活动才可以撤销，已经开始或者已经结束的都不可以撤销
//1.删除这个活动
DataProvider.GetInstance().DeleteWG_Activities(int.Parse(activityID));
//2.删除报名列表
string whereStr = " 1=1 AND activityID=" + activityID;
IList<WG_OnGoingActivitiesEntity> ogae = DataProvider.GetInstance().GetWG_OnGoingActivitiesList(whereStr);
if (ogae != null && ogae.Count > 0)
{
foreach (WG_OnGoingActivitiesEntity item in ogae)
{
DataProvider.GetInstance().DeleteWG_OnGoingActivities(item.ID);
}
}
//活动已经开始
jbo.code = 0;
jbo.data = null;
jbo.message = "撤销活动成功";
jbo.success = true;
}
else
{
//判断是否已经参加
string whereStr = " status= 0 " + " AND menberID= " + menberID + " AND activityID= " + activityID;
IList<WG_OnGoingActivitiesEntity> ogaeList = DataProvider.GetInstance().GetWG_OnGoingActivitiesList(whereStr);
if ("1" == opc)
{
#region 1参加活动
if (null != ogaeList && ogaeList.Count > 0)
{
//已经参加
jbo.code = -1;
jbo.data = null;
jbo.message = "您已参加了活动，无需重复";
jbo.success = false;
}
else
{
//判断参加活动的人数是否已经满了
string sql = " select * from dbo.WG_OnGoingActivities where ActivityID=" + activityID + " and Status=0 ";
DataSet ds = DbHelperSQL.Query(sql);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count >= ae.NeedMenberCount)
{
//人已经满了
jbo.code = -1;
jbo.data = null;
jbo.message = "活动人数已满";
jbo.success = false;
}
else
{
//在WG_OnGoingActivitiesEntity新增一条记录
WG_OnGoingActivitiesEntity ogae = new WG_OnGoingActivitiesEntity();
ogae.ActivityID = int.Parse(activityID);
ogae.MenberID = int.Parse(menberID);
ogae.Status = 0;
ogae.CreateDate = DateTime.Now;
DataProvider.GetInstance().AddWG_OnGoingActivities(ogae);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count + 1 == ae.NeedMenberCount)
{
//人满了
ae.Status = 1;//活动被激活
DataProvider.GetInstance().UpdateWG_Activities(ae);
}
AddNoticeToWG("您发布的活动有新成员参加", "您发布的活动：[ "+ae.Title+" ] 有新成员加入，请知悉。", ae.PromoterID.ToString(),2,ae.ID);
jbo.code = 0;
jbo.data = null;
jbo.message = "成功参加活动";
jbo.success = true;
}
}
#endregion
}
else if ("2" == opc)
{
//2只能是退出活动，如果是激活活动，是不能人工的，需要自动人数到了触发活动
#region 退出活动
if (null != ogaeList && ogaeList.Count > 0)
{
foreach (WG_OnGoingActivitiesEntity item in ogaeList)
{
DataProvider.GetInstance().DeleteWG_OnGoingActivities(item.ID);
AddNoticeToWG("有成员退出了您发布的活动", "您发布的活动：[ " + ae.Title + " ] 有成员退出，请知悉。", ae.PromoterID.ToString(), 2, ae.ID);
}
jbo.code = 0;
jbo.data = null;
jbo.message = "成功退出活动";
jbo.success = true;
}
else
{
//活动不存在
jbo.code = -1;
jbo.data = null;
jbo.message = "你并未参加活动";
jbo.success = false;
}
#endregion
}
else if ("3" == opc)
{
//3活动完成,发起人有权限
ae.Status = 2;
DataProvider.GetInstance().UpdateWG_Activities(ae);
jbo.code = 0;
jbo.data = null;
jbo.message = "完成活动成功";
jbo.success = true;
}
else
{
//非法操作
jbo.code = -1;
jbo.data = null;
jbo.message = "非法操作";
jbo.success = false;
}
}
}
}
catch (Exception ex)
{
//失败
jbo.code = -1;
jbo.data = null;
jbo.message = "接口调用过程中出现其他错误";
jbo.success = false;
}
resultStr = JsonSerializer<JsonBaseObject>(jbo);
context.Response.Write(resultStr);
}