Ejemplo n.º 1
0
        /// <summary>
        /// 新增颜色
        /// lx 2017-06-22
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public static int AddColor(mg_PropertyModel model)
        {
            string        maxid  = @"declare @i int;
                                SELECT @i=max([prop_id])  FROM [mg_Property];
                                if @i is null
                                    begin
                                        set @i=1
                                    end
                                else
                                    begin
                                        set @i=@i+1
                                    end;
                                ";
            StringBuilder strSql = new StringBuilder();

            strSql.Append("insert into mg_Property(");
            strSql.Append("prop_id,Prop_type,prop_name)");
            strSql.Append(" values (");
            strSql.Append("@i,@Prop_type,@prop_name);");
            SqlParameter[] parameters =
            {
                new SqlParameter("@Prop_type", SqlDbType.Int),
                new SqlParameter("@prop_name", SqlDbType.NVarChar)
            };
            parameters[0].Value = model.Prop_type;
            parameters[1].Value = model.prop_name;

            int rows = SqlHelper.ExecuteNonQuery(SqlHelper.SqlConnString, System.Data.CommandType.Text, maxid + strSql, parameters);

            return(rows);
        }
Ejemplo n.º 2
0
        ///陈名兴
        ///增加下拉类型
        ///
        public static List <mg_PropertyModel> QueryPropertyFlowlingForEditing(string type)
        {
            List <mg_PropertyModel> list = null;
            string    sql = @"SELECT [prop_id]
                                  ,[Prop_Type]
                                  ,[prop_name]
                              FROM [Mg_Property]
                              where [Prop_type]=" + type + " order by prop_id";
            DataTable dt  = SqlHelper.GetDataDataTable(SqlHelper.SqlConnString, System.Data.CommandType.Text, sql, null);

            if (DataHelper.HasData(dt))
            {
                list = new List <mg_PropertyModel>();
                foreach (DataRow row in dt.Rows)
                {
                    mg_PropertyModel model = new mg_PropertyModel();
                    model.prop_id   = NumericParse.StringToInt(DataHelper.GetCellDataToStr(row, "prop_id"));
                    model.prop_name = DataHelper.GetCellDataToStr(row, "prop_name");
                    model.Prop_type = NumericParse.StringToInt(DataHelper.GetCellDataToStr(row, "Prop_type"));
                    list.Add(model);
                }
                mg_PropertyModel firstmodel = new mg_PropertyModel();
                firstmodel.prop_id   = 0;
                firstmodel.prop_name = "-- 请选择类型 --";
                list.Insert(0, firstmodel);
            }

            return(list);
        }
Ejemplo n.º 3
0
        /// <summary>
        /// 保存颜色
        /// </summary>
        void SaveColor()
        {
            try
            {
                string prop_id   = Request.Params["prop_id"];
                string prop_name = Request.Params["prop_name"];
                string prop_type = Request.Params["prop_type"];

                mg_PropertyModel model = new mg_PropertyModel();
                model.prop_name = prop_name;
                model.Prop_type = NumericParse.StringToInt(prop_type);
                if (!string.IsNullOrWhiteSpace(prop_id))
                {
                    model.prop_id = Convert.ToInt32(prop_id);
                }
                else
                {
                    model.prop_id = 0;
                }

                string json = mg_PropertyBLL.SaveColor(model);
                Response.Write(json);
                Response.End();
            }
            catch (Exception ex)
            {
            }
        }
Ejemplo n.º 4
0
        /// <summary>
        /// 更新颜色
        /// lx 2017-06-22
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public static int UpdateColor(mg_PropertyModel model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("update mg_Property set ");
            strSql.Append("prop_name=@prop_name");
            strSql.Append(" where prop_id=@prop_id  ");
            SqlParameter[] parameters =
            {
                new SqlParameter("@prop_id",   SqlDbType.Int),
                new SqlParameter("@prop_name", SqlDbType.NVarChar)
            };
            parameters[0].Value = model.prop_id;
            parameters[1].Value = model.prop_name;

            int rows = SqlHelper.ExecuteNonQuery(SqlHelper.SqlConnString, System.Data.CommandType.Text, strSql.ToString(), parameters);

            return(rows);
        }
Ejemplo n.º 5
0
        public static List <mg_PropertyModel> queryJSONStringByPropertyType(mg_PropertyEnum propEnum)
        {
            List <mg_PropertyModel> list = null;
            string    sql = @"SELECT [prop_id]
                                      ,[Prop_type]
                                      ,[prop_name]
                                  FROM [mg_Property] where Prop_type=" + (int)propEnum + @" order by prop_name";
            DataTable dt  = SqlHelper.GetDataDataTable(SqlHelper.SqlConnString, System.Data.CommandType.Text, sql, null);

            if (DataHelper.HasData(dt))
            {
                list = new List <mg_PropertyModel>();
                foreach (DataRow row in dt.Rows)
                {
                    mg_PropertyModel model = new mg_PropertyModel();
                    model.prop_id   = NumericParse.StringToInt(DataHelper.GetCellDataToStr(row, "prop_id"));
                    model.prop_name = DataHelper.GetCellDataToStr(row, "prop_name");
                    list.Add(model);
                }
            }
            return(list);
        }
Ejemplo n.º 6
0
        /// <summary>
        /// 新增颜色
        /// lx 2017-06-22
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public static string AddColor(mg_PropertyModel model)
        {
            int count = mg_PropertyDAL.AddColor(model);

            return(count > 0 ? "true" : "false");
        }
Ejemplo n.º 7
0
 /// <summary>
 /// 保存颜色
 /// lx 2017-06-22
 /// </summary>
 /// <param name="model"></param>
 /// <returns></returns>
 public static string SaveColor(mg_PropertyModel model)
 {
     return(model.prop_id == 0 ? AddColor(model) : UpdateColor(model));
 }