Ejemplo n.º 1
0
       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);
           }
       }
Ejemplo n.º 2
0
 public string UpdateStats_ET(EdmTemplateQuery query)  // add by yachao1120j 2015-9-22
 {
     string josn;
     string sql = "";
     try
     {
         if (query.enabled == 0)
         {
             query.enabled = 1;
         }
         else
         {
             query.enabled = 0;
         }
         sql = _edmtemplatedao.UpdateStats_ET(query);
         if (_dbAccess.execCommand(sql) > 0)
         {
             josn = "{success:true}";
         }
         else
         {
             josn = "{success:false}";
         }
         return josn;
     }
     catch (Exception ex)
     {
         throw new Exception("EdmTemplateMgr-->UpdateStats_ET-->" + ex.Message + sql, ex);
     }
 }
Ejemplo n.º 3
0
       //判断是新增 还是 编辑 
       public int SaveEdmTemplateAdd(EdmTemplateQuery query) // add by yachao1120j 2015-9-22
       {
           if (query.template_id == 0)//新增
           {

               return _edmtemplatedao.EdmTemplateInsert(query);
           }
           else//編輯
           {
               return _edmtemplatedao.EdmTemplateUpdate(query);
           }
       }
Ejemplo n.º 4
0
 public List<EdmTemplateQuery> GetEdmTemplateList(EdmTemplateQuery query, out int totalCount) // add by yachao1120j 2015-9-22
 {
     try
     {
         List<EdmTemplateQuery> store = new List<EdmTemplateQuery>();
         store = _edmtemplatedao.GetEdmTemplateList(query, out totalCount);
         return store;
     }
     catch (Exception ex)
     {
         throw new Exception("EdmTemplateMgr->GetEdmTemplateList" + ex.Message);
     }
 }
Ejemplo n.º 5
0
 public string UpdateStats_ET(EdmTemplateQuery query)  // add by yachao1120j 2015-9-22
 {
     StringBuilder strSql = new StringBuilder();
     try
     {
         strSql.AppendFormat(@"Update edm_template set enabled='{0}' WHERE template_id='{1}'", query.enabled, query.template_id);
         return strSql.ToString();
     }
     catch (Exception ex)
     {
         throw new Exception("EdmTemplateDao-->UpdateStats_ET-->" + ex.Message + strSql.ToString(), ex);
     }
 }
Ejemplo n.º 6
0
       //插入信息
       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);
           }
       }
Ejemplo n.º 7
0
        public HttpResponseBase SaveEdmTemplateAdd() //add by yachao1120j 2015-9-22
        {
            string json = string.Empty;
            try
            {
                EdmTemplateQuery query = new EdmTemplateQuery();
                edmtemplatemgr = new EdmTemplateMgr(mySqlConnectionString);

                if (!string.IsNullOrEmpty(Request.Params["template_id"]))
                {
                    query.template_id = Convert.ToInt32(Request.Params["template_id"]);
                }
                if (!string.IsNullOrEmpty(Request.Params["template_name"]))
                {
                    query.template_name = Request.Params["template_name"];
                }
                if (!string.IsNullOrEmpty(Request.Params["edit_url"]))
                {
                    query.edit_url = Request.Params["edit_url"];
                }
                if (!string.IsNullOrEmpty(Request.Params["content_url"]))
                {
                    query.content_url = Request.Params["content_url"];
                }
                if (!string.IsNullOrEmpty(Request.Params["static_template"]))
                {
                    if (Request.Params["static_template"] == "true")
                    {
                        query.static_template = 1;
                    }
                    else
                    {
                        query.static_template = 0;
                    }
                }
                query.template_update_userid = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id;
                query.template_create_userid = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id;


                int _dt = edmtemplatemgr.SaveEdmTemplateAdd(query);

                if (_dt > 0)
                {
                    json = "{success:true}";
                }
                else
                {
                    json = "{success:false}";
                }
            }
            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 Response;

        }
Ejemplo n.º 8
0
        //EdmTemplate 中的狀態啟用
        public HttpResponseBase UpdateStats_ET()
        {
            string json = string.Empty;
            try
            {
                edmtemplatemgr = new EdmTemplateMgr(mySqlConnectionString);
                EdmTemplateQuery query = new EdmTemplateQuery();

                if (!string.IsNullOrEmpty(Request.Params["id"]))
                {
                    query.template_id = Convert.ToInt32(Request.Params["id"]);
                }
                if (!string.IsNullOrEmpty(Request.Params["active"]))
                {
                    query.enabled = Convert.ToInt32(Request.Params["active"]);
                }
                json = edmtemplatemgr.UpdateStats_ET(query);
            }
            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;
        }
Ejemplo n.º 9
0
        public HttpResponseBase GetEdmTemplateList() //add by yachao1120j 2015-9-22
        {
            string json = string.Empty;
            int totalcount = 0;
            try
            {
                EdmTemplateQuery query = new EdmTemplateQuery();
                query.Start = Convert.ToInt32(Request.Params["start"] ?? "0");
                query.Limit = Convert.ToInt32(Request.Params["limit"] ?? "25");
                edmtemplatemgr = new EdmTemplateMgr(mySqlConnectionString);
                List<EdmTemplateQuery> list = edmtemplatemgr.GetEdmTemplateList(query, out totalcount);
                IsoDateTimeConverter timeConverter = new IsoDateTimeConverter();
                timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
                // timeConverter.DateTimeFormat = "yyyy-MM-dd ";
                json = "{success:true,totalCount:" + totalcount + ",data:" + JsonConvert.SerializeObject(list, 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 Response;

        }
Ejemplo n.º 10
0
 //更新信息
 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);
     }
 }