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

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

                string cmdText = "proc_k_ModelcommonFieldGroupSave";

                SqlParameter[] paras = new SqlParameter[] {
                    new SqlParameter("tranType", tranType),
                    new SqlParameter("ID", paramsModel.ID),
                    new SqlParameter("Name", paramsModel.Name),
                    new SqlParameter("Orders", paramsModel.Orders),
                    new SqlParameter("AddMan", paramsModel.AddMan),
                    new SqlParameter("IsDel", paramsModel.IsDel),

                    returnValue
                };

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

            return(isOk);
        }
Ejemplo n.º 2
0
        protected void CommonFieldGroup_Edit(object sender, EventArgs e)
        {
            KingTop.Model.Content.ModelcommonFieldGroup mCommonFieldGroup;
            string tranType;    // 操作类型
            string effectRow;   // 更新结果
            string listUrl;     // 返回路径

            tranType                 = "NEW";
            listUrl                  = "CommonFieldGroupList.aspx";
            mCommonFieldGroup        = new KingTop.Model.Content.ModelcommonFieldGroup();
            mCommonFieldGroup.Name   = txtName.Text.Trim();
            mCommonFieldGroup.Orders = Utils.ParseInt(txtOrders.Text.Trim(), 200);
            mCommonFieldGroup.AddMan = UserNo;

            if (string.Equals(Action.ToLower(), "edit")) // 更新
            {
                tranType             = "EDIT";
                mCommonFieldGroup.ID = ID;
            }
            else
            {
                mCommonFieldGroup.ID = Guid.NewGuid().ToString();
            }

            effectRow = commonFieldGroup.Save(tranType, mCommonFieldGroup);

            if (string.Equals(Action.ToLower(), "edit")) // 更新
            {
                if (string.Equals(effectRow, "1"))
                {
                    jsMessage = "type=1;title=\"" + mCommonFieldGroup.Name + " \";id=\"" + mCommonFieldGroup.ID + "\"";
                    WriteLog("公用字段分组" + mCommonFieldGroup.Name + " 更新成功。", null, 2);
                }
                else // 失败
                {
                    jsMessage = "errmsg=\"对不起,更新失败。\";type=2;id=\"" + mCommonFieldGroup.ID + "\";";
                    WriteLog("公用字段分组" + mCommonFieldGroup.Name + " 更新失败。", effectRow, 3);
                }
            }
            else
            {
                if (string.Equals(effectRow, "1")) // 添加成功
                {
                    jsMessage = "type=0;title=\"" + mCommonFieldGroup.Name + " \";id=\"" + mCommonFieldGroup.ID + "\"";
                    WriteLog("添加公用字段分组" + mCommonFieldGroup.Name + " 成功。", null, 2);
                }
                else  // 失败
                {
                    jsMessage = "errmsg=\"对不起,添加失败。\";type=2;id=\"" + mCommonFieldGroup.ID + "\";";
                    WriteLog("添加公用字段分组" + mCommonFieldGroup.Name + " 失败。", effectRow, 3);
                }
            }

            PageInit(); // 重新加载数据
        }
 /// <summary>
 /// 增、改k_ModelcommonFieldGroup表
 /// </summary>
 /// <param name="tranType">操作类型,NEW=增,EDIT=改</param>
 /// <param name="ModModel"></param>
 /// <returns>返回大于0的数字操作正常,返回非数字表示操作错误,返回的是系统错误说明</returns>
 public string Save(string trantype, KingTop.Model.Content.ModelcommonFieldGroup modModel)
 {
     return(dal.Save(trantype, modModel));
 }