public bool Update(SystemSmsTemplate model, List <string> fileds, string sqlWhere)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.AppendFormat("update {0} set ", model.GetType().Name);
            List <string>       filedsList   = new List <string>();
            List <SqlParameter> sqlParameter = new List <SqlParameter>();
            SqlParameter        Param        = new SqlParameter("@Id", SqlDbType.Int, 4);

            if (string.IsNullOrEmpty(sqlWhere))
            {
                Param.Value = model.Id;
                sqlParameter.Add(Param);
            }
            foreach (string filed in fileds)
            {
                filedsList.Add(string.Format("{0}=@{0}", filed));
                Param = new SqlParameter(string.Format("@{0}", filed), model.GetType().GetProperty(filed).GetValue(model, null));
                sqlParameter.Add(Param);
            }
            strSql.AppendFormat("{0}", string.Join(",", filedsList.ToArray()));
            if (string.IsNullOrEmpty(sqlWhere))
            {
                strSql.Append(" where Id=@Id ");
            }
            else
            {
                strSql.AppendFormat(" where 1=1 and {0} ", sqlWhere);
            }
            SqlParameter[] parameters = sqlParameter.ToArray();
            return(sqlhelper.ExecNon(strSql.ToString(), parameters) > 0 ? true : false);
        }
Ejemplo n.º 2
0
        public JsonResult AddEditSmsTemplte(SystemSmsTemplate tempate)
        {
            JsonResult result = null;

            try
            {
                BaseResultDto <string> resultDto = new BaseResultDto <string>();
                if (tempate.Id > 0)
                {
                    //编辑
                    resultDto = HttpHelper.CreatHelper().DoPostObject <BaseResultDto <string> >(string.Format("{0}Sms/Update", this.WebApiUrl), tempate);
                }
                else
                {
                    //添加
                    resultDto = HttpHelper.CreatHelper().DoPostObject <BaseResultDto <string> >(string.Format("{0}Sms/Add", this.WebApiUrl), tempate);
                }
                result = Json(new { status = resultDto.ErrorCode, message = resultDto.ErrorMsg }, JsonRequestBehavior.AllowGet);
            }
            catch (Exception ex)
            {
                result = Json(new { status = -1, message = ex.Message }, JsonRequestBehavior.AllowGet);
            }
            return(result);
        }
Ejemplo n.º 3
0
        public BaseResultDto <string> Update(SystemSmsTemplate model)
        {
            BaseResultDto <string> resultDto = new BaseResultDto <string>();

            try
            {
                resultDto.ErrorCode = helper.Update <SystemSmsTemplate>(model) ? 1 : 0;
                resultDto.ErrorMsg  = "修改成功";
            }
            catch (Exception ex)
            {
                resultDto.ErrorCode = -1;
                resultDto.ErrorMsg  = ex.Message;
            }
            return(resultDto);
        }
        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public SystemSmsTemplate GetModel(string where)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select top 1 Id, TemplateName, TemplateContent ");
            strSql.Append("  from SystemSmsTemplate ");
            strSql.Append(" where ");
            strSql.Append(where);

            var dt = sqlhelper.GetTable(strSql.ToString());
            SystemSmsTemplate model = null;

            if (dt.Rows.Count > 0)
            {
                model = Mapper.DynamicMap <IDataReader, List <SystemSmsTemplate> >(dt.CreateDataReader()).FirstOrDefault();
            }
            return(model);
        }
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(SystemSmsTemplate model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("insert into SystemSmsTemplate(");
            strSql.Append("TemplateName,TemplateContent ");
            strSql.Append(") values (");
            strSql.Append("@TemplateName,@TemplateContent ");
            strSql.Append(") ");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters =
            {
                new SqlParameter("@TemplateName",    SqlDbType.VarChar, 100),
                new SqlParameter("@TemplateContent", SqlDbType.VarChar, 500)
            };
            parameters[0].Value = model.TemplateName;
            parameters[1].Value = model.TemplateContent;
            return(sqlhelper.ExecNon(strSql.ToString(), parameters));
        }
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public bool Update(SystemSmsTemplate model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("update SystemSmsTemplate set ");

            strSql.Append(" TemplateName = @TemplateName , ");
            strSql.Append(" TemplateContent = @TemplateContent  ");
            strSql.Append(" where Id=@Id ");

            SqlParameter[] parameters =
            {
                new SqlParameter("@Id",              SqlDbType.Int,       4),
                new SqlParameter("@TemplateName",    SqlDbType.VarChar, 100),
                new SqlParameter("@TemplateContent", SqlDbType.VarChar, 500)
            };

            parameters[0].Value = model.Id;
            parameters[1].Value = model.TemplateName;
            parameters[2].Value = model.TemplateContent;
            return(sqlhelper.ExecNon(strSql.ToString(), parameters) > 0 ? true : false);
        }