コード例 #1
0
        /// <summary>
        /// 增、改K_ReviewFlow表

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

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

                string cmdText = "proc_K_ReviewFlowSave";

                SqlParameter[] paras = new SqlParameter[] {
                    new SqlParameter("tranType", tranType),
                    new SqlParameter("ID", paramsModel.ID),
                    new SqlParameter("Orders", paramsModel.Orders),
                    new SqlParameter("AddMan", paramsModel.AddMan),
                    new SqlParameter("IsEnable", paramsModel.IsEnable),
                    new SqlParameter("Name", paramsModel.Name),
                    new SqlParameter("Desc", paramsModel.Desc),
                    new SqlParameter("SiteId", paramsModel.SiteId),
                    new SqlParameter("NodeId", paramsModel.NodeId),
                    new SqlParameter("NodeCode", paramsModel.NodeCode),
                    returnValue
                };

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

            return(isOk);
        }
コード例 #2
0
        /// <summary>
        /// 增、改K_ReviewFlow表

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