Exemplo n.º 1
0
        //更新信息
        public string UpdGameInfo(string svstr, string id)
        {
            string[] svarr = svstr.Split('@');
            string   mSql  = string.Format("update tb_game set console = @console,name=@name,price=@price,buydate=@buydate,remark=@remark where id=@id;");

            SqlParameter[] sp = new SqlParameter[svarr.Length + 3];
            for (int i = 0; i < svarr.Length; i++)
            {
                sp[i] = new SqlParameter("@" + svarr[i].Split('|')[0], svarr[i].Split('|')[1]);
            }

            sp[svarr.Length]     = new SqlParameter("@userid", "MguliN");
            sp[svarr.Length + 1] = new SqlParameter("@remark", "");
            sp[svarr.Length + 2] = new SqlParameter("@id", id);

            return(sh.getNonQuery(mSql, sp).ToString());
        }