Exemple #1
0
        protected override string btnAdd_Click()
        {
            Sys_BankInfo         obj     = null;
            IList <Sys_BankInfo> list    = GetDetailModelList();
            IList <Sys_BankInfo> listNew = new List <Sys_BankInfo>();

            foreach (Sys_BankInfo objNew in list)
            {
                Sys_BankInfo sq = objNew;
                if (objNew.Id == 0)
                {
                    sq.CreatedBy   = TModel.MID;
                    sq.CreatedTime = DateTime.Now;
                    sq.IsDeleted   = false;
                    sq.Status      = true;
                }
                else
                {
                    sq             = new Sys_BankInfoBLL().GetModel(objNew.Id);
                    sq.Code        = objNew.Code;
                    sq.LinkUrl     = objNew.LinkUrl;
                    sq.Name        = objNew.Name;
                    sq.PicUrl      = objNew.PicUrl;
                    sq.Remark      = objNew.Remark;
                    sq.UpdatedBy   = TModel.MID;
                    sq.UpdatedTime = DateTime.Now;
                }
                listNew.Add(sq);
            }
            //删除需要删除的
            string deleteId = Request.Form["hidDelIds"];

            if (!string.IsNullOrEmpty(deleteId))
            {
                string[] arr = deleteId.Split(',');
                foreach (string str in arr)
                {
                    if (!string.IsNullOrEmpty(str))
                    {
                        Sys_BankInfo sq = new Sys_BankInfoBLL().GetModel(str);
                        sq.IsDeleted   = true;
                        sq.UpdatedBy   = TModel.MID;
                        sq.UpdatedTime = DateTime.Now;
                        // new BLL.Sys_SecurityQuestion().Delete(str);
                        listNew.Add(sq);
                        //new Sys_BankInfoBLL().Delete(str);
                    }
                }
            }
            //更新或新增
            if (new Sys_BankInfoBLL().SaveOrUpdate(listNew))
            {
                return("操作成功");
            }
            else
            {
                return("操作失败");
            }
        }
Exemple #2
0
 protected IList <Sys_BankInfo> AddToTotalModel(IList <Sys_BankInfo> toAdd, IList <Sys_BankInfo> origin)
 {
     foreach (Sys_BankInfo obj in origin)
     {
         Sys_BankInfo newObj = obj;
         toAdd.Add(newObj);
     }
     return(toAdd);
 }
        protected Sys_BankInfo GetBank(string id)
        {
            Sys_BankInfoBLL BLL   = new Sys_BankInfoBLL();
            Sys_BankInfo    model = BLL.GetModel(id);

            if (model != null)
            {
                return(model);
            }
            return(new Sys_BankInfo());
        }
Exemple #4
0
        private Sys_BankInfo NewEntity(object id, string code, string name, string picUrl, string link, string remark)
        {
            Sys_BankInfo obj = null;

            if (!string.IsNullOrEmpty(name))
            {
                obj = new Sys_BankInfo {
                    Id = ToNullLong(id), Name = name, Code = code, PicUrl = picUrl, LinkUrl = link, Remark = remark
                };
            }
            return(obj);
        }
Exemple #5
0
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public static Hashtable Update(Sys_BankInfo model, Hashtable MyHs)
        {
            string        guid   = Guid.NewGuid().ToString();
            StringBuilder strSql = new StringBuilder();

            strSql.Append("update Sys_BankInfo set ");

            strSql.Append(" Status = @Status , ");
            strSql.Append(" Code = @Code , ");
            strSql.Append(" Name = @Name , ");
            strSql.Append(" PicUrl = @PicUrl , ");
            strSql.Append(" CreatedTime = @CreatedTime , ");
            strSql.Append(" CreatedBy = @CreatedBy , ");
            strSql.Append(" UpdatedTime = @UpdatedTime , ");
            strSql.Append(" UpdatedBy = @UpdatedBy , ");
            strSql.Append(" IsDeleted = @IsDeleted,  ");
            strSql.Append(" LinkUrl = @LinkUrl , ");
            strSql.Append(" Remark = @Remark  ");
            strSql.Append(" where Id=@Id ");
            strSql.AppendFormat(" ;select '{0}'", guid);

            SqlParameter[] parameters =
            {
                new SqlParameter("@Id",          SqlDbType.BigInt,      8),
                new SqlParameter("@Status",      SqlDbType.Bit,         1),
                new SqlParameter("@Code",        SqlDbType.VarChar,    40),
                new SqlParameter("@Name",        SqlDbType.VarChar,    40),
                new SqlParameter("@PicUrl",      SqlDbType.VarChar,   100),
                new SqlParameter("@CreatedTime", SqlDbType.DateTime),
                new SqlParameter("@CreatedBy",   SqlDbType.VarChar,    40),
                new SqlParameter("@UpdatedTime", SqlDbType.DateTime),
                new SqlParameter("@UpdatedBy",   SqlDbType.VarChar,    40),
                new SqlParameter("@IsDeleted",   SqlDbType.Bit,         1),
                new SqlParameter("@LinkUrl",     SqlDbType.VarChar,   100),
                new SqlParameter("@Remark",      SqlDbType.VarChar, 1000)
            };

            parameters[0].Value  = model.Id;
            parameters[1].Value  = model.Status;
            parameters[2].Value  = model.Code;
            parameters[3].Value  = model.Name;
            parameters[4].Value  = model.PicUrl;
            parameters[5].Value  = model.CreatedTime;
            parameters[6].Value  = model.CreatedBy;
            parameters[7].Value  = model.UpdatedTime;
            parameters[8].Value  = model.UpdatedBy;
            parameters[9].Value  = model.IsDeleted;
            parameters[10].Value = model.LinkUrl;
            parameters[11].Value = model.Remark;
            MyHs.Add(strSql.ToString(), parameters);
            return(MyHs);
        }
Exemple #6
0
        /// <summary>
        ///  实体转换
        /// <summary>
        private static Sys_BankInfo TranEntity(DataRow dr)
        {
            if (dr != null)
            {
                Sys_BankInfo model = new Sys_BankInfo();

                if (!string.IsNullOrEmpty(dr["Id"].ToString()))
                {
                    model.Id = long.Parse(dr["Id"].ToString());
                }
                if (!string.IsNullOrEmpty(dr["Status"].ToString()))
                {
                    model.Status = bool.Parse(dr["Status"].ToString());
                }
                model.Code    = dr["Code"].ToString();
                model.Name    = dr["Name"].ToString();
                model.PicUrl  = dr["PicUrl"].ToString();
                model.LinkUrl = dr["LinkUrl"].ToString();
                model.Remark  = dr["Remark"].ToString();
                if (!string.IsNullOrEmpty(dr["CreatedTime"].ToString()))
                {
                    model.CreatedTime = DateTime.Parse(dr["CreatedTime"].ToString());
                }

                model.CreatedBy = dr["CreatedBy"].ToString();

                if (!string.IsNullOrEmpty(dr["UpdatedTime"].ToString()))
                {
                    model.UpdatedTime = DateTime.Parse(dr["UpdatedTime"].ToString());
                }

                model.UpdatedBy = dr["UpdatedBy"].ToString();

                if (!string.IsNullOrEmpty(dr["IsDeleted"].ToString()))
                {
                    model.IsDeleted = bool.Parse(dr["IsDeleted"].ToString());
                }


                return(model);
            }
            else
            {
                return(null);
            }
        }
Exemple #7
0
        public bool SaveOrUpdate(IList <Sys_BankInfo> list)
        {
            Hashtable MyHs = new Hashtable();//以事务方式

            foreach (Sys_BankInfo obj in list)
            {
                if (obj.Id == 0) //需要插入的
                {
                    Sys_BankInfoDAL.Insert(obj, MyHs);
                }
                else
                {
                    //需要更新的
                    Sys_BankInfo objUpdate = obj;
                    Sys_BankInfoDAL.Update(obj, MyHs);
                }
            }
            return(CommonBase.RunHashtable(MyHs));
        }
Exemple #8
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public static Hashtable Insert(Sys_BankInfo model, Hashtable MyHs)
        {
            string        guid   = Guid.NewGuid().ToString();
            StringBuilder strSql = new StringBuilder();

            strSql.Append("insert into Sys_BankInfo(");
            strSql.Append("Status,Code,Name,PicUrl,CreatedTime,CreatedBy,UpdatedTime,UpdatedBy,IsDeleted,LinkUrl,Remark");
            strSql.Append(") values (");
            strSql.Append("@Status,@Code,@Name,@PicUrl,@CreatedTime,@CreatedBy,@UpdatedTime,@UpdatedBy,@IsDeleted,@LinkUrl,@Remark");
            strSql.Append(") ");
            strSql.AppendFormat(";select '{0}'", guid);
            SqlParameter[] parameters =
            {
                new SqlParameter("@Status",      SqlDbType.Bit,         1),
                new SqlParameter("@Code",        SqlDbType.VarChar,    40),
                new SqlParameter("@Name",        SqlDbType.VarChar,    40),
                new SqlParameter("@PicUrl",      SqlDbType.VarChar,   100),
                new SqlParameter("@CreatedTime", SqlDbType.DateTime),
                new SqlParameter("@CreatedBy",   SqlDbType.VarChar,    40),
                new SqlParameter("@UpdatedTime", SqlDbType.DateTime),
                new SqlParameter("@UpdatedBy",   SqlDbType.VarChar,    40),
                new SqlParameter("@IsDeleted",   SqlDbType.Bit,         1),
                new SqlParameter("@LinkUrl",     SqlDbType.VarChar,   100),
                new SqlParameter("@Remark",      SqlDbType.VarChar, 1000)
            };

            parameters[0].Value  = model.Status;
            parameters[1].Value  = model.Code;
            parameters[2].Value  = model.Name;
            parameters[3].Value  = model.PicUrl;
            parameters[4].Value  = model.CreatedTime;
            parameters[5].Value  = model.CreatedBy;
            parameters[6].Value  = model.UpdatedTime;
            parameters[7].Value  = model.UpdatedBy;
            parameters[8].Value  = model.IsDeleted;
            parameters[9].Value  = model.LinkUrl;
            parameters[10].Value = model.Remark;
            MyHs.Add(strSql.ToString(), parameters);
            return(MyHs);
        }
Exemple #9
0
 /// <summary>
 /// 增加一条数据
 /// </summary>
 public static bool Insert(Sys_BankInfo model)
 {
     return(CommonBase.RunHashtable(Insert(model, new Hashtable())));
 }
Exemple #10
0
 /// <summary>
 /// 更新一条数据
 /// </summary>
 public static bool Update(Sys_BankInfo model)
 {
     return(CommonBase.RunHashtable(Update(model, new Hashtable())));
 }
Exemple #11
0
 public bool Update(Sys_BankInfo model)
 {
     return(Sys_BankInfoDAL.Update(model));
 }
Exemple #12
0
 public Hashtable Update(Sys_BankInfo model, Hashtable MyHs)
 {
     return(Sys_BankInfoDAL.Update(model, MyHs));
 }
Exemple #13
0
 public bool Insert(Sys_BankInfo model)
 {
     return(Sys_BankInfoDAL.Insert(model));
 }
Exemple #14
0
 public Hashtable Insert(Sys_BankInfo model, Hashtable MyHs)
 {
     return(Sys_BankInfoDAL.Insert(model, MyHs));
 }