public int Insert(ActivitySubjectNewInfo model)
{
StringBuilder sb = new StringBuilder(250);
sb.Append(@"insert into ActivitySubjectNew (Title,ContentText,StartDate,EndDate,SignUpRule,MaxVoteCount,VoteMultiple,MaxSignUpCount,SignUpCount,ViewCount,VirtualSignUpCount,Sort,HiddenAttribute,IsPrize,PrizeRule,PrizeProbability,Remark,IsDisable,LastUpdatedDate)
values
(@Title,@ContentText,@StartDate,@EndDate,@SignUpRule,@MaxVoteCount,@VoteMultiple,@MaxSignUpCount,@SignUpCount,@ViewCount,@VirtualSignUpCount,@Sort,@HiddenAttribute,@IsPrize,@PrizeRule,@PrizeProbability,@Remark,@IsDisable,@LastUpdatedDate)
" );
SqlParameter[] parms =
{
new SqlParameter("@Title", SqlDbType.NVarChar, 100),
new SqlParameter("@ContentText", SqlDbType.NVarChar, 4000),
new SqlParameter("@StartDate", SqlDbType.DateTime),
new SqlParameter("@EndDate", SqlDbType.DateTime),
new SqlParameter("@SignUpRule", SqlDbType.NVarChar, 2000),
new SqlParameter("@MaxVoteCount", SqlDbType.Int),
new SqlParameter("@VoteMultiple", SqlDbType.Int),
new SqlParameter("@MaxSignUpCount", SqlDbType.Int),
new SqlParameter("@SignUpCount", SqlDbType.Int),
new SqlParameter("@ViewCount", SqlDbType.BigInt),
new SqlParameter("@VirtualSignUpCount", SqlDbType.Int),
new SqlParameter("@Sort", SqlDbType.Int),
new SqlParameter("@HiddenAttribute", SqlDbType.NVarChar, 300),
new SqlParameter("@IsPrize", SqlDbType.Bit),
new SqlParameter("@PrizeRule", SqlDbType.NVarChar, 2000),
new SqlParameter("@PrizeProbability", SqlDbType.Int),
new SqlParameter("@Remark", SqlDbType.NVarChar, 300),
new SqlParameter("@IsDisable", SqlDbType.Bit),
new SqlParameter("@InsertDate", SqlDbType.DateTime),
new SqlParameter("@LastUpdatedDate", SqlDbType.DateTime)
};
parms[0].Value = model.Title;
parms[1].Value = model.ContentText;
parms[2].Value = model.StartDate;
parms[3].Value = model.EndDate;
parms[4].Value = model.SignUpRule;
parms[5].Value = model.MaxVoteCount;
parms[6].Value = model.VoteMultiple;
parms[7].Value = model.MaxSignUpCount;
parms[8].Value = model.SignUpCount;
parms[9].Value = model.ViewCount;
parms[10].Value = model.VirtualSignUpCount;
parms[11].Value = model.Sort;
parms[12].Value = model.HiddenAttribute;
parms[13].Value = model.IsPrize;
parms[14].Value = model.PrizeRule;
parms[15].Value = model.PrizeProbability;
parms[16].Value = model.Remark;
parms[17].Value = model.IsDisable;
parms[18].Value = model.InsertDate;
parms[19].Value = model.LastUpdatedDate;
return(SqlHelper.ExecuteNonQuery(SqlHelper.HnztcTeamDbConnString, CommandType.Text, sb.ToString(), parms));
}
public IList <ActivitySubjectNewInfo> GetList(int pageIndex, int pageSize, string sqlWhere, params SqlParameter[] cmdParms)
{
StringBuilder sb = new StringBuilder(250);
int startIndex = (pageIndex - 1) * pageSize + 1;
int endIndex = pageIndex * pageSize;
sb.Append(@"select * from(select row_number() over(order by LastUpdatedDate desc) as RowNumber,
Id,Title,ContentText,StartDate,EndDate,SignUpRule,MaxVoteCount,VoteMultiple,MaxSignUpCount,SignUpCount,ViewCount,VirtualSignUpCount,Sort,HiddenAttribute,Remark,IsDisable,InsertDate,LastUpdatedDate
from ActivitySubjectNew " );
if (!string.IsNullOrEmpty(sqlWhere))
{
sb.AppendFormat(" where 1=1 {0} ", sqlWhere);
}
sb.AppendFormat(@")as objTable where RowNumber between {0} and {1} ", startIndex, endIndex);
IList <ActivitySubjectNewInfo> list = new List <ActivitySubjectNewInfo>();
using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.HnztcTeamDbConnString, CommandType.Text, sb.ToString(), cmdParms))
{
if (reader != null && reader.HasRows)
{
while (reader.Read())
{
ActivitySubjectNewInfo model = new ActivitySubjectNewInfo();
model.Id = reader.GetGuid(1);
model.Title = reader.GetString(2);
model.ContentText = reader.GetString(3);
model.StartDate = reader.GetDateTime(4);
model.EndDate = reader.GetDateTime(5);
model.SignUpRule = reader.GetString(6);
model.MaxVoteCount = reader.GetInt32(7);
model.VoteMultiple = reader.GetInt32(8);
model.MaxSignUpCount = reader.GetInt32(9);
model.SignUpCount = reader.GetInt32(10);
model.ViewCount = reader.GetInt64(11);
model.VirtualSignUpCount = reader.GetInt32(12);
model.Sort = reader.GetInt32(13);
model.HiddenAttribute = reader.GetString(14);
model.Remark = reader.GetString(15);
model.IsDisable = reader.GetBoolean(16);
model.InsertDate = reader.GetDateTime(17);
model.LastUpdatedDate = reader.GetDateTime(18);
list.Add(model);
}
}
}
return(list);
}
public ActivitySubjectNewInfo GetModel(object Id)
{
ActivitySubjectNewInfo model = null;
StringBuilder sb = new StringBuilder(300);
sb.Append(@"select top 1 Id,Title,ContentText,StartDate,EndDate,SignUpRule,MaxVoteCount,VoteMultiple,MaxSignUpCount,SignUpCount,ViewCount,VirtualSignUpCount,Sort,HiddenAttribute,Remark,IsDisable,InsertDate,LastUpdatedDate
from ActivitySubjectNew
where Id = @Id " );
SqlParameter parm = new SqlParameter("@Id", SqlDbType.UniqueIdentifier);
parm.Value = Guid.Parse(Id.ToString());
using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.HnztcTeamDbConnString, CommandType.Text, sb.ToString(), parm))
{
if (reader != null)
{
while (reader.Read())
{
model = new ActivitySubjectNewInfo();
model.Id = reader.GetGuid(0);
model.Title = reader.GetString(1);
model.ContentText = reader.GetString(2);
model.StartDate = reader.GetDateTime(3);
model.EndDate = reader.GetDateTime(4);
model.SignUpRule = reader.GetString(5);
model.MaxVoteCount = reader.GetInt32(6);
model.VoteMultiple = reader.GetInt32(7);
model.MaxSignUpCount = reader.GetInt32(8);
model.SignUpCount = reader.GetInt32(9);
model.ViewCount = reader.GetInt64(10);
model.VirtualSignUpCount = reader.GetInt32(11);
model.Sort = reader.GetInt32(12);
model.HiddenAttribute = reader.GetString(13);
model.Remark = reader.GetString(14);
model.IsDisable = reader.GetBoolean(15);
model.InsertDate = reader.GetDateTime(16);
model.LastUpdatedDate = reader.GetDateTime(17);
}
}
}
return(model);
}
public IList <ActivitySubjectNewInfo> GetList()
{
StringBuilder sb = new StringBuilder(250);
sb.Append(@"select Id,Title,ContentText,StartDate,EndDate,SignUpRule,MaxVoteCount,VoteMultiple,MaxSignUpCount,SignUpCount,ViewCount,VirtualSignUpCount,Sort,HiddenAttribute,Remark,IsDisable,InsertDate,LastUpdatedDate
from ActivitySubjectNew
order by LastUpdatedDate desc " );
IList <ActivitySubjectNewInfo> list = new List <ActivitySubjectNewInfo>();
using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.HnztcTeamDbConnString, CommandType.Text, sb.ToString()))
{
if (reader != null && reader.HasRows)
{
while (reader.Read())
{
ActivitySubjectNewInfo model = new ActivitySubjectNewInfo();
model.Id = reader.GetGuid(0);
model.Title = reader.GetString(1);
model.ContentText = reader.GetString(2);
model.StartDate = reader.GetDateTime(3);
model.EndDate = reader.GetDateTime(4);
model.SignUpRule = reader.GetString(5);
model.MaxVoteCount = reader.GetInt32(6);
model.VoteMultiple = reader.GetInt32(7);
model.MaxSignUpCount = reader.GetInt32(8);
model.SignUpCount = reader.GetInt32(9);
model.ViewCount = reader.GetInt64(10);
model.VirtualSignUpCount = reader.GetInt32(11);
model.Sort = reader.GetInt32(12);
model.HiddenAttribute = reader.GetString(13);
model.Remark = reader.GetString(14);
model.IsDisable = reader.GetBoolean(15);
model.InsertDate = reader.GetDateTime(16);
model.LastUpdatedDate = reader.GetDateTime(17);
list.Add(model);
}
}
}
return(list);
}
public void SaveActivitySubject(HttpContext context)
{
try
{
string id = context.Request.Form["ctl00$cphMain$hId"].Trim();
string sTitle = context.Request.Form["ctl00$cphMain$txtTitle"].Trim();
string sContent = context.Request.Form["content"].Trim();
string sPictureId = context.Request.Form["pictureId"].Trim();
string startDate = context.Request.Form["ctl00$cphMain$startDate"].Trim();
string endDate = context.Request.Form["ctl00$cphMain$endDate"].Trim();
string sSort = context.Request.Form["ctl00$cphMain$txtSort"].Trim();
string sMaxVoteCount = context.Request.Form["ctl00$cphMain$txtMaxVoteCount"].Trim();
sMaxVoteCount = sMaxVoteCount == "" ? "0" : sMaxVoteCount;
string sMaxSignUpCount = context.Request.Form["ctl00$cphMain$txtMaxSignUpCount"].Trim();
sMaxSignUpCount = sMaxSignUpCount == "" ? "0" : sMaxSignUpCount;
string sActualSignUpCount = context.Request.Form["ctl00$cphMain$txtActualSignUpCount"].Trim();
sActualSignUpCount = sActualSignUpCount == "" ? "0" : sActualSignUpCount;
string sUpdateSignUpCount = context.Request.Form["ctl00$cphMain$txtUpdateSignUpCount"].Trim();
sUpdateSignUpCount = sUpdateSignUpCount == "" ? "0" : sUpdateSignUpCount;
string sViewCount = context.Request.Form["ctl00$cphMain$txtViewCount"].Trim();
sViewCount = sViewCount == "" ? "0" : sViewCount;
string sSignUpRule = context.Request.Form["signUpRule"].Trim();
string sHideAttr = context.Request.Form["hideAttr"].Trim();
string sIsPrize = context.Request.Form["isPrize"].Trim();
string sPrizeProbability = context.Request.Form["ctl00$cphMain$txtPrizeProbability"].Trim();
sPrizeProbability = sPrizeProbability == "" ? "0" : sPrizeProbability;
string sPrizeRule = context.Request.Form["PrizeRule"].Trim();
string sIsDisable = context.Request.Form["isDisable"].Trim();
bool isPush = bool.Parse(context.Request.Form["isPush"].Trim());
sContent = HttpUtility.HtmlDecode(sContent);
sSignUpRule = HttpUtility.HtmlDecode(sSignUpRule);
sPrizeRule = HttpUtility.HtmlDecode(sPrizeRule);
Guid gId = Guid.Empty;
if (id != "")
{
Guid.TryParse(id, out gId);
}
Guid pictureId = Guid.Empty;
Guid.TryParse(sPictureId, out pictureId);
ActivitySubjectNewInfo model = new ActivitySubjectNewInfo();
model.LastUpdatedDate = DateTime.Now;
model.Remark = "";
model.Id = gId;
model.Title = sTitle;
model.ContentText = sContent;
model.StartDate = DateTime.Parse(startDate);
model.EndDate = DateTime.Parse(endDate);
model.Sort = int.Parse(sSort);
model.MaxVoteCount = int.Parse(sMaxVoteCount);
model.MaxSignUpCount = int.Parse(sMaxSignUpCount);
model.SignUpCount = int.Parse(sActualSignUpCount);
model.VirtualSignUpCount = int.Parse(sUpdateSignUpCount);
model.ViewCount = int.Parse(sViewCount);
model.SignUpRule = sSignUpRule;
model.HiddenAttribute = sHideAttr.Length > 0 ? sHideAttr.TrimEnd(',') : sHideAttr;
model.IsPrize = bool.Parse(sIsPrize);
model.PrizeProbability = int.Parse(sPrizeProbability);
model.PrizeRule = sPrizeRule;
model.IsDisable = bool.Parse(sIsDisable);
if (string.IsNullOrWhiteSpace(model.ContentText))
{
context.Response.Write("{\"success\": false,\"message\": \"" + MessageContent.Submit_Params_InvalidError + "\"}");
return;
}
if (string.IsNullOrWhiteSpace(model.SignUpRule))
{
context.Response.Write("{\"success\": false,\"message\": \"" + MessageContent.Submit_Params_InvalidError + "\"}");
return;
}
ActivitySubjectNew bll = new ActivitySubjectNew();
ActivityPictureNew bllAP = new ActivityPictureNew();
ActivityPictureNewInfo infoAP = new ActivityPictureNewInfo();
int effect = -1;
if (!gId.Equals(Guid.Empty))
{
effect = bll.Update(model);
if (effect > 0)
{
infoAP.ActivityId = model.Id;
infoAP.PictureId = pictureId;
bllAP.Delete(model.Id);
bllAP.Insert(infoAP);
}
}
else
{
model.InsertDate = DateTime.Now;
Guid activityId = bll.InsertByOutput(model);
if (!activityId.Equals(Guid.Empty))
{
effect = 1;
if (!pictureId.Equals(Guid.Empty))
{
infoAP.ActivityId = activityId;
infoAP.PictureId = pictureId;
bllAP.Insert(infoAP);
}
}
}
if (effect == 110)
{
context.Response.Write("{\"success\": false,\"message\": \"" + MessageContent.Submit_Exist + "\"}");
return;
}
if (effect < 1)
{
context.Response.Write("{\"success\": false,\"message\": \"" + MessageContent.Submit_Error + "\"}");
return;
}
if (isPush)
{
#region 推送信息到推送服务系统
try
{
PushContentService pushProxy = new PushContentService();
if (System.Configuration.ConfigurationManager.AppSettings["PushServiceUrl"] != null)
{
pushProxy.Url = System.Configuration.ConfigurationManager.AppSettings["PushServiceUrl"].ToString();
}
string sxml = "";
sxml = string.Format(@"<XmlParameters><ReceivePushContent><PushType>{0}</PushType><PushContent>{1}</PushContent><Title>{2}</Title><PushParam>{3}</PushParam></ReceivePushContent></XmlParameters>",
"hd", "", model.Title, "1##" + model.Id);
//string rt = pushProxy.ReceivePushContent(sxml);
pushProxy.ReceivePushContentAsync(sxml);
}
catch
{
}
#endregion
}
context.Response.Write("{\"success\": true,\"message\": \"" + MessageContent.Submit_Success + "\"}");
}
catch (Exception ex)
{
context.Response.Write("{\"success\": false,\"message\": \"" + MessageContent.AlertTitle_Ex_Error + "：" + ex.Message + "\"}");
}
}
public void SaveActivityPlayerNew(HttpContext context)
{
try
{
string id = context.Request.Form["ctl00$cphMain$hId"].Trim();
string sActivityId = context.Request.Form["ctl00$cphMain$asId"].Trim();
string sName = context.Request.Form["ctl00$cphMain$txtName"].Trim();
string sAge = context.Request.Form["ctl00$cphMain$txtAge"].Trim();
string sOccupation = context.Request.Form["ctl00$cphMain$txtOccupation"].Trim();
string sPhone = context.Request.Form["ctl00$cphMain$txtPhone"].Trim();
string sLocation = context.Request.Form["ctl00$cphMain$txtLocation"].Trim();
string sProfessional = context.Request.Form["ctl00$cphMain$txtProfessional"].Trim();
string sDescr = context.Request.Form["ctl00$cphMain$txtDescr"].Trim();
string sPictureIdList = context.Request.Form["pictureId"].TrimEnd(',');
string sVoteCount = context.Request.Form["ctl00$cphMain$txtActualVoteCount"].Trim();
sVoteCount = sVoteCount == "" ? "0" : sVoteCount;
string sVirtualVoteCount = context.Request.Form["ctl00$cphMain$txtUpdateVoteCount"].Trim();
sVirtualVoteCount = sVirtualVoteCount == "" ? "0" : sVirtualVoteCount;
string sIsDisable = context.Request.Form["isDisable"].Trim();
ActivitySubjectNew bllAS = new ActivitySubjectNew();
ActivitySubjectNewInfo info = new ActivitySubjectNewInfo();
info = bllAS.GetModel(sActivityId);
if (info.SignUpCount >= info.MaxVoteCount)
{
context.Response.Write("{\"success\": false,\"message\": \"报名数已达上限\"}");
return;
}
Guid gId = Guid.Empty;
if (id != "")
{
Guid.TryParse(id, out gId);
}
Guid activityId = Guid.Empty;
Guid.TryParse(sActivityId, out activityId);
ActivityPlayerNewInfo model = new ActivityPlayerNewInfo();
model.LastUpdatedDate = DateTime.Now;
model.Remark = "";
model.Id = gId;
model.ActivityId = activityId;
model.UserId = WebCommon.GetUserId();
model.Named = sName;
model.Age = int.Parse(sAge);
model.Occupation = sOccupation;
model.Phone = sPhone;
model.Location = sLocation;
model.Professional = sProfessional;
model.Descr = sDescr;
model.VoteCount = int.Parse(sVoteCount);
model.VirtualVoteCount = int.Parse(sVirtualVoteCount);
model.IsDisable = bool.Parse(sIsDisable);
ActivityPlayerNew bll = new ActivityPlayerNew();
PlayerPictureNew bllPP = new PlayerPictureNew();
int effect = -1;
if (!gId.Equals(Guid.Empty))
{
effect = bll.Update(model);
if (effect > 0)
{
bllPP.Delete(model.Id);
int index = 1;
foreach (string sPictureId in sPictureIdList.Split(','))
{
PlayerPictureNewInfo infoPP = new PlayerPictureNewInfo();
Guid pictureId = Guid.Empty;
Guid.TryParse(sPictureId, out pictureId);
infoPP.PlayerId = model.Id;
infoPP.PictureId = pictureId;
infoPP.Sort = index;
infoPP.IsHeadImg = index == 1 ? true : false;
bllPP.Insert(infoPP);
index++;
}
}
}
else
{
Guid playerId = bll.InsertByOutput(model);
if (!playerId.Equals(Guid.Empty))
{
effect = 1;
int index = 1;
foreach (string sPictureId in sPictureIdList.Split(','))
{
PlayerPictureNewInfo infoPP = new PlayerPictureNewInfo();
Guid pictureId = Guid.Empty;
Guid.TryParse(sPictureId, out pictureId);
infoPP.PlayerId = playerId;
infoPP.PictureId = pictureId;
infoPP.Sort = index;
infoPP.IsHeadImg = index == 1 ? true : false;
bllPP.Insert(infoPP);
index++;
}
}
}
if (effect == 110)
{
context.Response.Write("{\"success\": false,\"message\": \"" + MessageContent.Submit_Exist + "\"}");
return;
}
if (effect < 1)
{
context.Response.Write("{\"success\": false,\"message\": \"" + MessageContent.Submit_Error + "\"}");
return;
}
context.Response.Write("{\"success\": true,\"message\": \"" + MessageContent.Submit_Success + "\"}");
}
catch (Exception ex)
{
context.Response.Write("{\"success\": false,\"message\": \"" + MessageContent.AlertTitle_Ex_Error + "：" + ex.Message + "\"}");
}
}
/// <summary>
/// 修改数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Update(ActivitySubjectNewInfo model)
{
return(dal.Update(model));
}
/// <summary>
/// 添加数据到数据库
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Insert(ActivitySubjectNewInfo model)
{
return(dal.Insert(model));
}
/// <summary>
/// 添加数据到数据库
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public Guid InsertByOutput(ActivitySubjectNewInfo model)
{
return(dal.InsertByOutput(model));
}