/// <summary> /// 增加一条数据 /// </summary> public bool Add(EDRS.Model.XT_QX_ANDY model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into XT_QX_ANDY("); strSql.Append("ANBH,YMMC,ANMC)"); strSql.Append(" values ("); strSql.Append(":ANBH,:YMMC,:ANMC)"); OracleParameter[] parameters = { new OracleParameter(":ANBH", OracleType.VarChar, 50), new OracleParameter(":YMMC", OracleType.VarChar, 200), new OracleParameter(":ANMC", OracleType.VarChar, 100) }; parameters[0].Value = model.ANBH; parameters[1].Value = model.YMMC; parameters[2].Value = model.ANMC; int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(EDRS.Model.XT_QX_ANDY model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update XT_QX_ANDY set "); strSql.Append("ANBH=:ANBH,"); strSql.Append("YMMC=:YMMC,"); strSql.Append("ANMC=:ANMC"); strSql.Append(" where ANBM=:ANBM "); OracleParameter[] parameters = { new OracleParameter(":ANBM", OracleType.VarChar, 50), new OracleParameter(":ANBH", OracleType.VarChar, 50), new OracleParameter(":YMMC", OracleType.VarChar, 200), new OracleParameter(":ANMC", OracleType.VarChar, 100) }; parameters[0].Value = model.ANBM; parameters[1].Value = model.ANBH; parameters[2].Value = model.YMMC; parameters[3].Value = model.ANMC; int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 添加配置数据 /// </summary> /// <returns></returns> private string AddData() { string msg = string.Empty; if (!ProvingFrom(ref msg)) { return(ReturnString.JsonToString(Prompt.error, msg, null)); } EDRS.BLL.XT_QX_ANDY bll = new EDRS.BLL.XT_QX_ANDY(this.Request); int count = bll.GetRecordCount(" and ANBH = :ANBH", new object[] { Request.Form.Get("txt_xh").Trim() }); if (count > 0) { return(ReturnString.JsonToString(Prompt.error, "按钮编号已存在", null)); } EDRS.Model.XT_QX_ANDY model = new EDRS.Model.XT_QX_ANDY(); model.ANBH = Request.Form.Get("txt_xh").Trim(); model.ANMC = Request.Form.Get("txt_mc").Trim(); model.YMMC = Request.Form.Get("txt_ymmc_val").Trim(); if (bll.Add(model)) { //数据日志 //OperateLog.AddLog(OperateLog.LogType.功能分类管理Web, "添加功能分类成功", model.FLMC, UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.win, "保存成功", null)); } //数据日志 //OperateLog.AddLog(OperateLog.LogType.功能分类管理Web, "添加功能分类失败", model.FLMC, UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.error, "保存失败", null)); }
/// <summary> /// 修改配置数据 /// </summary> /// <returns></returns> private string UpData() { string anbh = Request.Form.Get("key_hidd").Trim(); if (string.IsNullOrEmpty(anbh)) { //数据日志 //OperateLog.AddLog(OperateLog.LogType.功能分类管理Web, "修改功能分类的参数错误", UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.error, "未找到需要修改信息", null)); } string msg = string.Empty; if (!ProvingFrom(ref msg)) { //数据日志 //OperateLog.AddLog(OperateLog.LogType.功能分类管理Web, "修改功能分类验证失败:" + msg, Request.Form.Get("txt_mc"), UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.error, msg, null)); } EDRS.BLL.XT_QX_ANDY bll = new EDRS.BLL.XT_QX_ANDY(this.Request); int count = bll.GetRecordCount(" and ANBH = :ANBH", new object[] { Request.Form.Get("txt_xh").Trim() }); if (count > 0) { return(ReturnString.JsonToString(Prompt.error, "按钮编号已存在", null)); } EDRS.Model.XT_QX_ANDY model = bll.GetModel(anbh); if (model != null) { model.ANBH = Request.Form.Get("txt_xh").Trim(); model.ANMC = Request.Form.Get("txt_mc").Trim(); model.YMMC = Request.Form.Get("txt_ymmc_val").Trim(); if (bll.Update(model)) { //数据日志 //OperateLog.AddLog(OperateLog.LogType.功能分类管理Web, "修改功能分类成功", model.FLMC, UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.win, "保存成功", null)); } //数据日志 //OperateLog.AddLog(OperateLog.LogType.功能分类管理Web, "修改功能分类失败", model.FLMC, UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.error, "保存失败", null)); } //数据日志 //OperateLog.AddLog(OperateLog.LogType.功能分类管理Web, "修改功能分类未找到信息", Request.Form.Get("txt_mc"), UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.error, "未找到需要修改信息", null)); }
/// <summary> /// 得到一个对象实体 /// </summary> public EDRS.Model.XT_QX_ANDY DataRowToModel(DataRow row) { EDRS.Model.XT_QX_ANDY model = new EDRS.Model.XT_QX_ANDY(); if (row != null) { if (row["ANBM"] != null) { model.ANBM = row["ANBM"].ToString(); } if (row["ANBH"] != null) { model.ANBH = row["ANBH"].ToString(); } if (row["YMMC"] != null) { model.YMMC = row["YMMC"].ToString(); } if (row["ANMC"] != null) { model.ANMC = row["ANMC"].ToString(); } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public EDRS.Model.XT_QX_ANDY GetModel(string ANBM) { StringBuilder strSql = new StringBuilder(); strSql.Append("select ANBM,ANBH,YMMC,ANMC from XT_QX_ANDY "); strSql.Append(" where ANBM=:ANBM "); OracleParameter[] parameters = { new OracleParameter(":ANBM", OracleType.VarChar, 50) }; parameters[0].Value = ANBM; EDRS.Model.XT_QX_ANDY model = new EDRS.Model.XT_QX_ANDY(); DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 根据单位获取配置数据 /// </summary> /// <param name="DWBM"></param> /// <returns></returns> private string GetModel(string anbm) { if (string.IsNullOrEmpty(anbm)) { anbm = Request.Form["id"]; if (string.IsNullOrEmpty(anbm)) { //数据日志 //OperateLog.AddLog(OperateLog.LogType.功能分类管理Web, "根据编号获取功能分类信息参数错误", UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.error, "参数错误", null)); } } EDRS.BLL.XT_QX_ANDY bll = new EDRS.BLL.XT_QX_ANDY(this.Request); EDRS.Model.XT_QX_ANDY model = bll.GetModel(anbm); if (model != null) { //数据日志 //OperateLog.AddLog(OperateLog.LogType.功能分类管理Web, "根据编号获取功能分类信息成功", model.FLMC, UserInfo, UserRole, this.Request); return(JsonHelper.JsonString(model)); } //数据日志 //OperateLog.AddLog(OperateLog.LogType.功能分类管理Web, "根据编号获取功能分类信息参数失败", Request["mc"], UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.error, "获取数据失败", null)); }