Example #1
0
        /// <summary>
        /// 增、改K_SysWebSite表

        /// </summary>
        /// <param Name="tranType">操作类型,NEW=增,EDIT=改</param>
        /// <param Name="paramsModel"></param>
        /// <returns>返回大于0的数字操作正常,返回非数字表示操作错误,返回的是系统错误说明</returns>
        public string Save(string tranType, KingTop.Model.SysManage.SysWebSite paramsModel)
        {
            string isOk = "";

            try
            {
                SqlParameter returnValue = new SqlParameter("@ReturnValue", SqlDbType.Int, 4);
                returnValue.Direction = ParameterDirection.Output;

                string cmdText = "proc_K_SysWebSiteSave";

                SqlParameter[] paras = new SqlParameter[] {
                    new SqlParameter("tranType", tranType),
                    new SqlParameter("SiteID", paramsModel.SiteID),
                    new SqlParameter("SiteName", paramsModel.SiteName),
                    new SqlParameter("Directory", paramsModel.Directory),
                    new SqlParameter("SiteUrl", paramsModel.SiteUrl),
                    new SqlParameter("IsMainSite", paramsModel.IsMainSite),
                    new SqlParameter("SettingsXML", paramsModel.SettingsXML),

                    returnValue
                };

                SQLHelper.ExecuteNonQuery(SQLHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, cmdText, paras);
                isOk = returnValue.Value.ToString();
            }
            catch (Exception ex)
            {
                isOk = "Error:" + ex.Message;
            }

            return(isOk);
        }
Example #2
0
        /// <summary>
        /// 增、改K_SysWebSite表

        /// </summary>
        /// <param name="tranType">操作类型,NEW=增,EDIT=改</param>
        /// <param name="SysModel"></param>
        /// <returns>返回大于0的数字操作正常,返回非数字表示操作错误,返回的是系统错误说明</returns>
        public string Save(string trantype, KingTop.Model.SysManage.SysWebSite sysModel)
        {
            return(dal.Save(trantype, sysModel));
        }