Ext MVC 增删改 【公司用】

在上一篇博客的基础上继续写

增

//1） Controller 
    public string Add()//add添加方法
        {
            Models.CCC item = JsonTool.JsonToObject<Models.CCC>(this.RequestParam());
            string Message = "";
            if (CCCBLL.Create.Add(item, out Message))
            {
                return "{"success":true}";
            }
            else
            {
                return "{"success":false,"error":"添加失败:" + Message.Replace(""", "") + ""}";
            }
        }

//2） CCCDAL
    public bool Add(Models.CCC item, out BaseClass.Message.MSG Message)
        {
            string sql = "insert into CCC (Name,Number,Country,Configure,Price,Time,Note) values

(@Name,@Number,@Country,@Configure,@Price,@Time,@Note)";

            DBParameter[] param ={
                                     DBParameter.Create("Name",DbType.String,item.Name),
                                     DBParameter.Create("Number",DbType.String,item.Number),
                                     DBParameter.Create("Country",DbType.String,item.Country),
                                     DBParameter.Create("Configure",DbType.String,item.Configure),
                                     DBParameter.Create("Price",DbType.String,item.Price),
                                     DBParameter.Create("Time",DbType.String,item.Time),
                                     DBParameter.Create("Note",DbType.String,item.Note)
                                };
            bool result = sop.ReturnExecuteCount(sql, false, param) > 0 ? true : false;
            Message = sop.Parent.Parent.msg;
            return result;
        }
//3） CCCBLL
      public bool Add(Models.CCC item, out string Message)
        {
            bool result = DAL.Add(item, out OpMessage);
            Message = OpMessage.MessageError;
            //日志
            AddSysLog(OpMessage, "车车车添加", "飞车");
            return result;
        }

删

//1） Controller 
    public string Delete()//删除方法
        {
            Models.CCC item = JsonTool.JsonToObject<Models.CCC>(this.RequestParam());
            string Message = "";
            if (CCCBLL.Create.Delete(out Message, item.Ids.ToString()))
            {
                return "{"success":true}";
            }
            else
            {
                return "{"success":false,"error:":"删除失败：" + Message.Replace(""", "") + ""}";
            }
        }

//2） CCCDAL
    public bool Delete(out BaseClass.Message.MSG Message, params object[] PrimaryKey)
        {
            List<IDbCommand> mycmds = new List<IDbCommand>();
            string sql = "";
            foreach (object o in PrimaryKey)
            {
                sql = "delete CCC where Ids = @Ids";
                mycmds.Add(sop.ReturnCommand(sql, false, DBParameter.Create("Ids", DbType.Int32, o)));
            }
            bool result = sop.RunTrans(mycmds);

            Message = sop.Parent.Parent.msg;
            return result;
        }
//3） CCCBLL
      public bool Delete(out string Message, string Ids)
        {
            bool result = false;
            //是否删除
            bool temp = false;
            if (temp)
            {
                Message = "订单{0}正在使用中，无法删除";
            }
            else
            {
                Ids = Ids.Replace(" ", "");
                result = DAL.Delete(out OpMessage, Ids.Split(','));
                Message = OpMessage.MessageError;
            }
            //日志
            AddSysLog(OpMessage, "车车车删除", "飞车");
            return result;
        }

改

//1） Controller 
    public string Edit()//修改方法
        {
            Models.CCC item = JsonTool.JsonToObject<Models.CCC>(this.RequestParam());
            string Message = "";

            if (CCCBLL.Create.Edit(item, out Message))
            {
                return "{"success":true}";
            }
            else
            {
                return "{"success":false,"error":"编辑失败：" + Message.Replace(""", "") + ""}";
            }
        }

//2） CCCDAL
     public bool Edit(Models.CCC item, out BaseClass.Message.MSG Message)
        {
            string sql = " update  CCC set 

Name=@Name,Number=@Number,Country=@Country,Configure=@Configure,Price=@Price,Time=@Time,Note=@Note where Ids=@Ids";
            DBParameter[] param ={
                                DBParameter.Create("Ids",DbType.Int32,item.Ids),
                                DBParameter.Create("Name",DbType.String,item.Name),
                                DBParameter.Create("Number",DbType.String,item.Number),
                                DBParameter.Create("Country",DbType.String,item.Country),
                                DBParameter.Create("Configure",DbType.String,item.Configure),
                                DBParameter.Create("Price",DbType.String,item.Price),
                                DBParameter.Create("Time",DbType.String,item.Time),
                                DBParameter.Create("Note",DbType.String,item.Note)
                                };
            bool result = sop.ReturnExecuteCount(sql, false, param) > 0 ? true : false;
            Message = sop.Parent.Parent.msg;
            return result;
        }
//3） CCCBLL
      public bool Edit(Models.CCC item, out string Message)
        {
            bool result = DAL.Edit(item, out OpMessage);
            Message = OpMessage.MessageError;
            //日志
            AddSysLog(OpMessage, "车车车编辑", "飞车");
            return result;
        }