/// <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); }
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)); }