public int TrialRecordSave(TrialShareQuery query)
{
try
{
return _ITrialRecordDao.TrialRecordSave(query);
}
catch (Exception ex)
{
throw new Exception("TrialRecordMgr-->TrialRecordSave-->" + ex.Message, ex);
}
}
public DataTable GetShareList(TrialShareQuery query, out int totalCount)
{
StringBuilder sql = new StringBuilder();
StringBuilder sqlWhere = new StringBuilder();
StringBuilder sqlCount = new StringBuilder();
StringBuilder sqlFrom = new StringBuilder();
totalCount = 0;
try
{
sqlCount.Append("select count(ts.share_id) as totalCount ");
sql.Append(" select ts.share_id,ts.trial_id,pat.`name` as event_name ,ts.user_id,u.user_name as real_name, ts.is_show_name,ts.user_name,ts.user_name as after_name,case when ts.user_gender=0 then '小姐' else '先生' end as gender,ts.content,ts.share_time,ts.`status` ");
sqlFrom.Append(" from trial_share ts ");
sqlFrom.Append(" LEFT JOIN users u on u.user_id=ts.user_id ");
sqlFrom.Append(" LEFT JOIN promotions_amount_trial pat on pat.id = ts.trial_id ");
sqlWhere.AppendFormat(" where 1 =1 ");
sqlWhere.AppendFormat(" and ts.trial_id='{0}' ", query.trial_id);
if (query.share_id != 0)
{
sqlWhere.AppendFormat(" and ts.share_id='{0}' ", query.share_id);
}
if (query.IsPage)
{
DataTable _dt = _access.getDataTable(sqlCount.ToString() + sqlFrom.ToString() + sqlWhere.ToString());
if (_dt != null && _dt.Rows.Count > 0)
{
totalCount = Convert.ToInt32(_dt.Rows[0]["totalCount"]);
}
}
sqlWhere.AppendFormat(" order by ts.share_id desc limit {0},{1};", query.Start, query.Limit);
return _access.getDataTable(sql.ToString() + sqlFrom.ToString() + sqlWhere.ToString());
// return _access.getDataTableForObj<TrialShareQuery>(sql.ToString() + sqlFrom.ToString() + sqlWhere.ToString());
}
catch (Exception ex)
{
throw new Exception("TrialRecordDao-->GetShareList-->" + ex.Message + sql.ToString() + sqlFrom.ToString() + sqlWhere.ToString(), ex);
}
}
public HttpResponseBase TrialRecordSave()
{
string json = string.Empty;
string jsonStr = string.Empty;
TrialShareQuery query = new TrialShareQuery();
TrialPictureQuery trialP = new TrialPictureQuery();
List<TrialPictureQuery> trialPList = new List<TrialPictureQuery>();
_ITrialPictureMgr = new TrialPictureMgr(mySqlConnectionString);
try
{
query.share_id = Convert.ToInt32(Request["share_id"]);
#region 處理圖片
try
{
if (!string.IsNullOrEmpty(Request.Params["picInfo"]))
{
string[] picInfo = Request.Params["picInfo"].Split(';');
for (int i = 0; i < picInfo.Length - 1; i++)
{
string[] perValue = picInfo[i].Split(',');
trialP = new TrialPictureQuery();
if (!string.IsNullOrEmpty(perValue[0])) { trialP.share_id = query.share_id; }
if (!string.IsNullOrEmpty(perValue[1])) { trialP.image_filename = perValue[1]; }
if (!string.IsNullOrEmpty(perValue[2])) { trialP.image_sort = Convert.ToUInt32(perValue[2]); }
if (!string.IsNullOrEmpty(perValue[3])) { trialP.image_state = Convert.ToUInt32(perValue[3]); }
trialPList.Add(trialP);
}
_ITrialPictureMgr = new TrialPictureMgr(mySqlConnectionString);
_ITrialPictureMgr.SavePic(trialPList, trialP);
}
else
{
_ITrialPictureMgr.DeleteAllPic(trialP);
}
}
catch (Exception ex)
{
Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
log.Error(logMessage);
json = "{failure:true}";
}
#endregion
_ITrialRecordMgr = new TrialRecordMgr(mySqlConnectionString);
if (!string.IsNullOrEmpty(Request.Params["trial_id"]))
{
query.trial_id = Convert.ToInt32(Request.Params["trial_id"].ToString());
}
if (!string.IsNullOrEmpty(Request.Params["user_name"]))
{
query.user_name = Request.Params["user_name"].ToString();
}
if (!string.IsNullOrEmpty(Request.Params["user_gender"]))
{
query.user_gender = Convert.ToInt32(Request.Params["user_gender"].ToString());
}
if (!string.IsNullOrEmpty(Request.Params["niming"]))
{
if (Request.Params["niming"] == "on")
{
query.is_show_name = 0;//匿名
}
else
{
query.is_show_name = 1;//不匿名
}
}
if (!string.IsNullOrEmpty(Request.Params["content"]))
{
query.content = Request.Params["content"].ToString();
}
if (!string.IsNullOrEmpty(Request.Params["status"]))
{
query.status = Convert.ToInt32(Request.Params["status"].ToString());
}
int j = _ITrialRecordMgr.TrialRecordSave(query);
if (j > 0)
{
json = "{success:true}";
}
else
{
json = "{failure:true}";
}
}
catch (Exception ex)
{
Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
log.Error(logMessage);
json = "{failure:true}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
public HttpResponseBase GetShareRecordList()
{
string json = string.Empty;
TrialShareQuery query = new TrialShareQuery();
// List<TrialShareQuery> store = new List<TrialShareQuery>();
int totalCount = 0;
_ITrialRecordMgr = new TrialRecordMgr(mySqlConnectionString);
try
{
query.Start = Convert.ToInt32(Request.Params["start"] ?? "0");//用於分頁的變量
query.Limit = Convert.ToInt32(Request.Params["limit"] ?? "25");//用於分頁的變量
if (!string.IsNullOrEmpty(Request.Params["trial_id"]))
{
query.trial_id = Convert.ToInt32(Request.Params["trial_id"].ToString());
}
if (!string.IsNullOrEmpty(Request.Params["relation_id"]))
{
query.share_id = Convert.ToInt32(Request.Params["relation_id"]);
}
DataTable _dt = _ITrialRecordMgr.GetShareList(query, out totalCount);
//foreach (var item in store)
//{
// item.gender = item.user_gender == 0 ? "小姐" : "先生";
//}
if (Convert.ToBoolean(Request.Params["isSecret"]))
{
foreach (DataRow item in _dt.Rows)
{
if (!string.IsNullOrEmpty(item["user_name"].ToString()))
{
item["user_name"] = item["user_name"].ToString().Substring(0, 1) + "**";
}
if (!string.IsNullOrEmpty(item["real_name"].ToString()))
{
item["real_name"] = item["real_name"].ToString().Substring(0, 1) + "**";
}
if (!string.IsNullOrEmpty(item["after_name"].ToString()))
{
item["after_name"] = item["after_name"].ToString().Substring(0, 1) + "**";
}
}
}
IsoDateTimeConverter timeConverter = new IsoDateTimeConverter();
timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
json = "{success:true,totalCount:" + totalCount + ",data:" + JsonConvert.SerializeObject(_dt, Formatting.Indented, timeConverter) + "}";
}
catch (Exception ex)
{
Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
log.Error(logMessage);
json = "{success:false,totalCount:0,data:[]}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
/// <summary>
/// 保存試用分享信息
/// </summary>
/// <param name="cq"></param>
/// <returns></returns>
public int TrialRecordSave(TrialShareQuery query)
{
StringBuilder strSql = new StringBuilder();
try
{
strSql.AppendFormat("update trial_share set ");
strSql.AppendFormat("user_name='{0}',content='{1}',is_show_name={2},status={3},user_gender={4} ", query.user_name, query.content, query.is_show_name, query.status, query.user_gender);
strSql.AppendFormat(" where share_id='{0}'", query.share_id);
return _access.execCommand(strSql.ToString());
}
catch (Exception ex)
{
throw new Exception("TrialRecordDao-->TrialRecordSave-->" + strSql.ToString() + ex.Message, ex);
}
}
