private void AnswerQA()
{
List <Performance.Error> errors = new List <Performance.Error>();
try
{
WorkTaskQA workTaskQA =
BllInstance.WorkTaskBllInstance.GetWorkTaskQA(Convert.ToInt32(_Context.Request.Params["Pkid"]));
workTaskQA.AAccount = _Operator;
workTaskQA.Answer = _Context.Request.Params["info_Answer"];
using (TransactionScope ts = new TransactionScope(TransactionScopeOption.Required))
{
BllInstance.WorkTaskBllInstance.AnswerWorkTask(workTaskQA,
Convert.ToBoolean(
_Context.Request.Params["info_IfQAEmail"]));
ts.Complete();
}
}
catch (Exception e)
{
errors.Add(new Performance.Error("dialoglblMessage", e.Message));
}
_ResponseString = string.Format("{{\"error\":{0}}}", JsonConvert.SerializeObject(errors));
}
internal static string BuildQuestionWorkTaskMailBody(WorkTaskQA workTaskQA)
{
StringBuilder body = new StringBuilder();
body.Append(workTaskQA.AAccount.Name + "对你的工作计划[" + workTaskQA.WorkTask.Title + "]留言。<br/>");
body.Append("留言内容：" + workTaskQA.Question + "<br/>");
return(body.ToString());
}
internal static string BuildAnswerWorkTaskMailBody(WorkTaskQA workTaskQA)
{
StringBuilder body = new StringBuilder();
body.Append(workTaskQA.QAccount.Name + "回复了你对他的工作计划[" + workTaskQA.WorkTask.Title + "]的留言。<br/>");
body.Append("留言内容：" + workTaskQA.Question);
body.Append("<br/>回复内容：" + workTaskQA.Answer + "<br/>");
return(body.ToString());
}
public void UpdateWorkTaskQA(WorkTaskQA model)
{
using (TransactionScope ts = new TransactionScope(TransactionScopeOption.Required))
{
SqlCommand cm = new SqlCommand();
AddInsertParameters(cm, model);
SqlHelper.ExecuteNonQuery("UpdateWorkTaskQA", cm);
ts.Complete();
}
}
private static void FetchObject(IDataRecord dr, WorkTaskQA workTask)
{
workTask.Pkid = (int)dr["PKID"];
workTask.WorkTask.Pkid = (int)dr["WorkTaskID"];
workTask.QAccount = new Account((int)dr["QAccount"], "", dr["QAccountName"].ToString());
workTask.Question = dr["Question"].ToString();
workTask.QuestionDate = (DateTime)dr["QuestionDate"];
workTask.AAccount = new Account((int)dr["AAccount"], "", dr["AAccountName"].ToString());
workTask.Answer = dr["Answer"].ToString();
workTask.AnswerDate = (DateTime)dr["AnswerDate"];
}
private static void AddInsertParameters(SqlCommand cm, WorkTaskQA model)
{
cm.Parameters.AddWithValue("@WorkTaskID", model.WorkTask.Pkid);
cm.Parameters.AddWithValue("@QAccount", model.QAccount.Id);
cm.Parameters.AddWithValue("@AAccount", model.AAccount.Id);
cm.Parameters.AddWithValue("@Question", model.Question);
cm.Parameters.AddWithValue("@Answer", model.Answer);
cm.Parameters.AddWithValue("@QuestionDate", model.QuestionDate);
cm.Parameters.AddWithValue("@AnswerDate", model.AnswerDate);
cm.Parameters.AddWithValue("@PKID", model.Pkid);
}
public void AddWorkTaskQA(WorkTaskQA model)
{
using (TransactionScope ts = new TransactionScope(TransactionScopeOption.Required))
{
SqlCommand cm = new SqlCommand();
AddInsertParameters(cm, model);
cm.Parameters["@PKID"].Direction = ParameterDirection.Output;
int pkid;
SqlHelper.ExecuteNonQueryReturnPKID("AddWorkTaskQA", cm, out pkid);
model.Pkid = pkid;
ts.Complete();
}
}
public WorkTaskQA GetWorkTaskQAByPKID(int PKID)
{
WorkTaskQA workTaskQA = new WorkTaskQA();
SqlCommand cmd = new SqlCommand();
cmd.Parameters.Add("PKID", SqlDbType.Int).Value = PKID;
using (SqlDataReader dr = SqlHelper.ExecuteReader("GetWorkTaskQA", cmd))
{
while (dr.Read())
{
FetchObject(dr, workTaskQA);
}
}
return(workTaskQA);
}
private void AddWorkTaskQA()
{
List <Performance.Error> errors = new List <Performance.Error>();
try
{
WorkTaskQA workTaskQA = new WorkTaskQA();
workTaskQA.WorkTask.Pkid = Convert.ToInt32(_Context.Request.Params["Pkid"]);
workTaskQA.QAccount = _Operator;
workTaskQA.Question = _Context.Request.Params["info_Question"];
BllInstance.WorkTaskBllInstance.QuestionWorkTask(workTaskQA,
Convert.ToBoolean(
_Context.Request.Params["info_IfQAEmail"]));
}
catch (Exception e)
{
errors.Add(new Performance.Error("dialoglblMessage", e.Message));
}
_ResponseString = string.Format("{{\"error\":{0}}}", JsonConvert.SerializeObject(errors));
}
private static void FetchChildren(IDataReader dr, WorkTask workTask)
{
dr.NextResult();
while (dr.Read())
{
workTask.Responsibles.Add(new Account((int)dr["AccountID"], "", dr["AccountName"].ToString()));
}
dr.NextResult();
while (dr.Read())
{
WorkTaskQA workTaskQA = new WorkTaskQA((int)dr["PKID"], dr["QAccountName"].ToString(),
dr["AAccountName"].ToString(), dr["Question"].ToString(),
dr["Answer"].ToString(), (DateTime)dr["QuestionDate"],
(DateTime)dr["AnswerDate"]);
workTaskQA.WorkTask.Pkid = (int)dr["WorkTaskID"];
workTaskQA.QAccount.Id = (int)dr["QAccount"];
workTaskQA.AAccount.Id = (int)dr["AAccount"];
workTask.WorkTaskQAs.Add(workTaskQA);
}
}
public void AnswerWorkTask(WorkTaskQA workTaskQA, bool ifEmail)
{
AnswerWorkTask answerWorkTask = new AnswerWorkTask(workTaskQA, ifEmail);
answerWorkTask.Excute();
}
public void QuestionWorkTask(WorkTaskQA workTaskQA, bool ifEmail)
{
QuestionWorkTask questionWorkTask = new QuestionWorkTask(workTaskQA, ifEmail);
questionWorkTask.Excute();
}
public WorkTaskViewModelQA(WorkTaskQA workTaskQA)
{
_WorkTaskQA = workTaskQA;
}
public QuestionWorkTask(WorkTaskQA workTaskQA, bool ifEmail)
{
_WorkTaskQA = workTaskQA;
_IfEmail = ifEmail;
}
public AnswerWorkTask(WorkTaskQA workTaskQA, bool ifEmail)
{
_WorkTaskQA = workTaskQA;
_IfEmail = ifEmail;
}
