Esempio n. 1
0
        public bool updateMenuInfo(Tz888.Model.ManageSystem.MenuTabModel model)
        {
            SqlParameter[] parms = new SqlParameter[]
            {
                new SqlParameter("@MName", SqlDbType.NVarChar, 100),
                new SqlParameter("@MCheck", SqlDbType.Int, 4),
                new SqlParameter("@Murl", SqlDbType.NVarChar, 300),
                new SqlParameter("@IsActive", SqlDbType.Int, 4),
                new SqlParameter("@MparentCode", SqlDbType.Int),
                new SqlParameter("@MCode", SqlDbType.NVarChar, 200),
                new SqlParameter("@target", SqlDbType.NVarChar, 50),
                new SqlParameter("@MDate", SqlDbType.DateTime, 8),
                new SqlParameter("@MID", SqlDbType.Int),
                new SqlParameter("@Sort", SqlDbType.NVarChar, 100)
            };
            parms[0].Value = model.MName;
            parms[1].Value = model.MCheck;
            parms[2].Value = model.Murl;
            parms[3].Value = model.MIsActive.ToString();
            parms[4].Value = model.MparentCode;
            parms[5].Value = model.MCode;
            parms[6].Value = model.Target;
            parms[7].Value = model.MDate.ToShortDateString();
            parms[8].Value = model.Mid.ToString();
            parms[9].Value = model.Sort.ToString();
            bool isOK = DbHelperSQL.RunProcLob("proc_updateMenuTabInfo", parms);

            return(isOK);
        }
Esempio n. 2
0
 public bool addMenuInfo(Tz888.Model.ManageSystem.MenuTabModel model)
 {
     return(MenuDal.addMenuInfo(model));
 }