/// <summary>
/// 添加不定项选择题子选择题
/// </summary>
public ServiceInvokeDTO AddUncertainSubChoice(UncertainSubChoice uncertainSubChoice)
{
log.Debug(Constant.DEBUG_START);
ServiceInvokeDTO result = null;
try
{
// 叠加题目序号
uncertainSubChoice.ItemIndex = uncertainSubChoiceDAL.GetLastItemIndex(uncertainSubChoice.UncertainItemID) + 1;
uncertainSubChoiceDAL.Insert(uncertainSubChoice);
result = new ServiceInvokeDTO(InvokeCode.SYS_INVOKE_SUCCESS);
}
catch (Exception ex)
{
log.Error(ex);
throw ex;
}
log.Debug(Constant.DEBUG_END);
return result;
}
/// <summary>
/// 更新不定项选择题子选择题
/// </summary>
public ServiceInvokeDTO UpdateUncertainSubChoice(UncertainSubChoice uncertainSubChoice)
{
log.Debug(Constant.DEBUG_START);
ServiceInvokeDTO result = null;
try
{
UncertainSubChoice dbSubChoice = uncertainSubChoiceDAL.GetByID(uncertainSubChoice.ID);
if (dbSubChoice != null)
{
uncertainSubChoiceDAL.Update(uncertainSubChoice);
result = new ServiceInvokeDTO(InvokeCode.SYS_INVOKE_SUCCESS);
}
else
{
result = new ServiceInvokeDTO(InvokeCode.SYS_OBJECT_NOT_EXIST_ERROR);
}
}
catch (Exception ex)
{
log.Error(ex);
throw ex;
}
log.Debug(Constant.DEBUG_END);
return result;
}
public ActionResult AddUncertainSubChoice()
{
log.Debug(Constant.DEBUG_START);
string uncertainIDString = ApiQueryUtil.QueryArgByPost("uncertain_id");
string title = ApiQueryUtil.QueryArgByPost("title");
HttpPostedFileBase imageFile = Request.Files["image"];
string a = ApiQueryUtil.QueryArgByPost("a");
string b = ApiQueryUtil.QueryArgByPost("b");
string c = ApiQueryUtil.QueryArgByPost("c");
string d = ApiQueryUtil.QueryArgByPost("d");
string answer = ApiQueryUtil.QueryArgByPost("answer");
string annotation = ApiQueryUtil.QueryArgByPost("annotation");
ServiceInvokeDTO result = null;
try
{
UncertainSubChoice subchoice = new UncertainSubChoice();
subchoice.UncertainItemID = Convert.ToInt32(uncertainIDString);
subchoice.Title = title;
subchoice.A = a;
subchoice.B = b;
subchoice.C = c;
subchoice.D = d;
subchoice.Answer = answer;
subchoice.Annotation = annotation;
subchoice.AddPerson = (Session[Constant.SESSION_KEY_ADMIN] as AgencyAdminDTO).ChineseName;
if (imageFile != null)
{
byte[] imageBytes = null;
using (Stream inputStream = imageFile.InputStream)
{
MemoryStream memoryStream = inputStream as MemoryStream;
if (memoryStream == null)
{
memoryStream = new MemoryStream();
inputStream.CopyTo(memoryStream);
}
imageBytes = memoryStream.ToArray();
}
subchoice.Image = imageBytes;
}
result = itemDataService.AddUncertainSubChoice(subchoice);
}
catch (Exception ex)
{
log.Error(ex);
result = new ServiceInvokeDTO(InvokeCode.SYS_INNER_ERROR);
}
string json = JsonConvert.SerializeObject(result, Formatting.Indented, Constant.TIME_CONVERTER);
log.Debug(Constant.DEBUG_END);
return Content(json, Constant.JSON_MIME_TYPE);
}
public ActionResult UpdateUncertainSubChoice()
{
log.Debug(Constant.DEBUG_START);
string idString = ApiQueryUtil.QueryArgByPost("id");
string title = ApiQueryUtil.QueryArgByPost("title");
HttpPostedFileBase imageFile = Request.Files["image"];
string a = ApiQueryUtil.QueryArgByPost("a");
string b = ApiQueryUtil.QueryArgByPost("b");
string c = ApiQueryUtil.QueryArgByPost("c");
string d = ApiQueryUtil.QueryArgByPost("d");
string answer = ApiQueryUtil.QueryArgByPost("answer");
string annotation = ApiQueryUtil.QueryArgByPost("annotation");
ServiceInvokeDTO result = null;
try
{
UncertainSubChoice subchoice = new UncertainSubChoice();
subchoice.ID = Convert.ToInt32(idString);
subchoice.Title = title;
subchoice.A = a;
subchoice.B = b;
subchoice.C = c;
subchoice.D = d;
subchoice.Answer = answer;
subchoice.Annotation = annotation;
if (imageFile != null)
{
byte[] imageBytes = null;
using (Stream inputStream = imageFile.InputStream)
{
MemoryStream memoryStream = inputStream as MemoryStream;
if (memoryStream == null)
{
memoryStream = new MemoryStream();
inputStream.CopyTo(memoryStream);
}
imageBytes = memoryStream.ToArray();
}
subchoice.Image = imageBytes;
}
AgencyAdminDTO currentAdmin = Session[Constant.SESSION_KEY_ADMIN] as AgencyAdminDTO;
ServiceInvokeDTO checkResult = permissionService.CheckPermission(DoActionType.UpdateUncertainSubChoice, currentAdmin.Agency.ID, subchoice.ID);
if (checkResult.Code == InvokeCode.SYS_INVOKE_SUCCESS)
{
result = itemDataService.UpdateUncertainSubChoice(subchoice);
}
else
{
result = checkResult;
}
}
catch (Exception ex)
{
log.Error(ex);
result = new ServiceInvokeDTO(InvokeCode.SYS_INNER_ERROR);
}
string json = JsonConvert.SerializeObject(result, Formatting.Indented, Constant.TIME_CONVERTER);
log.Debug(Constant.DEBUG_END);
return Content(json, Constant.JSON_MIME_TYPE);
}
/// <summary>
/// 更新实体信息
/// </summary>
public void Update(UncertainSubChoice subchoice)
{
const string sql = @"UPDATE UncertainSubChoice SET Title= @Title, Image = @Image, A = @A, B= @B, C = @C, D = @D,
Answer = @Answer, Annotation = @Annotation WHERE IsDeleted = 0 AND ID = @ID";
using (DbConnection connection = ConnectionManager.OpenConnection)
{
connection.Execute(sql, subchoice);
}
}
/// <summary>
/// 添加实体信息,返回添加成功后的主键ID
/// </summary>
public int Insert(UncertainSubChoice subchoice)
{
int id = 0;
const string sql = @"INSERT INTO UncertainSubChoice(UncertainItemID, ItemIndex, Title, Image, A, B, C, D, Answer, Annotation, AddPerson)
VALUES (@UncertainItemID, @ItemIndex, @Title, @Image, @A, @B, @C, @D, @Answer, @Annotation, @AddPerson);
SELECT LAST_INSERT_ID();";
using (DbConnection connection = ConnectionManager.OpenConnection)
{
id = connection.Query<int>(sql, subchoice).SingleOrDefault<int>();
}
return id;
}