public string handsUp(string post)
{
HandsUpPostData postData = post.FromJsonTo <HandsUpPostData>();
HandsUpRecord newItem = new HandsUpRecord()
{
UserId = postData.UserId,
PetitionId = postData.PetitionId
};
if (postData.Type == 1)
{
if (!this.Lazy_HandsUpRecordBLL.CheckIsHandsUp(newItem))
{
if (this.Lazy_HandsUpRecordBLL.InsertHandsUpRecord(newItem))
{
return(new Result()
{
Code = 0, Data = null
}.ToJSON());
}
else
{
return(new Result()
{
Code = 100, Data = null, Message = "发生错误"
}.ToJSON());
}
}
else
{
return(new Result()
{
Code = 101, Data = null, Message = "已举手"
}.ToJSON());
}
}
else
{
if (this.Lazy_HandsUpRecordBLL.DeleteHandsUpRecord(newItem))
{
return(new Result()
{
Code = 0, Data = null
}.ToJSON());
}
else
{
return(new Result()
{
Code = 100, Data = null, Message = "发生错误"
}.ToJSON());
}
}
}
public bool CheckIsHandsUp(HandsUpRecord handsUpRecord)
{
string sql = string.Format(sqlSelectHandsUpRecord, "@userId", "@petitionId");
SqlParameter[] parms =
{
new SqlParameter("@userId", handsUpRecord.UserId),
new SqlParameter("@petitionId", handsUpRecord.PetitionId)
};
return(DAO.CheckExists(sql, parms) != null);
}
public bool DeleteHandsUpRecord(HandsUpRecord handsUpRecord)
{
Dictionary <SqlParameter[], string> deleteSqls = new Dictionary <SqlParameter[], string>();
string sql = string.Format(sqlDeleteHandsUpRecord, "@userId", "@petitionId");
SqlParameter[] parms =
{
new SqlParameter("@userId", handsUpRecord.UserId),
new SqlParameter("@petitionId", handsUpRecord.PetitionId)
};
deleteSqls.Add(parms, sql);
return(DAO.ExecuteSqlTran(deleteSqls));
}
public bool CheckIsHandsUp(HandsUpRecord handsUpRecord)
{
return(dal.CheckIsHandsUp(handsUpRecord));
}
public bool DeleteHandsUpRecord(HandsUpRecord handsUpRecord)
{
return(dal.DeleteHandsUpRecord(handsUpRecord));
}
public bool InsertHandsUpRecord(HandsUpRecord handsUpRecord)
{
return(dal.InsertHandsUpRecord(handsUpRecord));
}
