public List<EdmTemplateQuery> GetEdmTemplateList(EdmTemplateQuery query, out int totalCount) { query.Replace4MySQL(); StringBuilder str = new StringBuilder(); StringBuilder strcont = new StringBuilder(); totalCount = 0; try { str.AppendFormat(" select et.template_id,et.template_name,et.edit_url,et.content_url,et.enabled,et.static_template, mu1.user_username as template_create_user,mu2.user_username as template_update_user,et.template_createdate,et.template_updatedate from edm_template et "); str.Append(" LEFT JOIN manage_user mu1 on mu1.user_id=et.template_create_userid "); str.Append(" LEFT JOIN manage_user mu2 on mu2.user_id=et.template_update_userid "); str.Append(" order by enabled desc, template_name "); str.Append(strcont); if (query.IsPage) { StringBuilder strpage = new StringBuilder(); StringBuilder strcontpage = new StringBuilder(); strpage.AppendFormat(" SELECT count(biao.template_id) as totalCount FROM(select et.template_id from edm_template et "); strpage.Append(strcont); strpage.AppendFormat(")as biao "); DataTable _dt = _access.getDataTable(strpage.Append(strcontpage).ToString()); if (_dt.Rows.Count > 0) { totalCount = Convert.ToInt32(_dt.Rows[0]["totalCount"]); str.AppendFormat(" limit {0},{1}", query.Start, query.Limit); } } return _access.getDataTableForObj<EdmTemplateQuery>(str.ToString());// 獲取查詢記錄 } catch (Exception ex) { throw new Exception("EdmTemplateDao-->GetEdmTemplateList-->" + ex.Message); } }
//插入信息 public int EdmTemplateInsert(EdmTemplateQuery query) { StringBuilder sql = new StringBuilder(); query.Replace4MySQL(); try { sql.Append("insert into edm_template (template_name, edit_url, content_url,template_create_userid,template_update_userid,template_createdate,static_template)values "); sql.AppendFormat("('{0}','{1}','{2}','{3}','{4}',NOW(),{5})", query.template_name, query.edit_url, query.content_url, query.template_create_userid, query.template_update_userid,query.static_template); return _access.execCommand(sql.ToString()); } catch (Exception ex) { throw new Exception("EdmTemplateDao-->EdmTemplateInsert-->" + sql.ToString() + ex.Message); } }
//更新信息 public int EdmTemplateUpdate(EdmTemplateQuery query) { StringBuilder sql = new StringBuilder(); query.Replace4MySQL(); try { sql.AppendFormat("update edm_template set template_name = '{0}', edit_url = '{1}', content_url = '{2}',template_update_userid='{3}',static_template={4} where template_id='{5}' ", query.template_name, query.edit_url, query.content_url, query.template_update_userid, query.static_template,query.template_id); return _access.execCommand(sql.ToString()); } catch (Exception ex) { throw new Exception("EdmTemplateDao-->EdmTemplateUpdate-->" + sql.ToString() + ex.Message); } }