/// <summary> /// 得到一个对象实体 /// </summary> public EDRS.Model.XT_DM_YWBM DataRowToModel(DataRow row) { EDRS.Model.XT_DM_YWBM model = new EDRS.Model.XT_DM_YWBM(); if (row != null) { if (row["YWBM"] != null) { model.YWBM = row["YWBM"].ToString(); } if (row["YWMC"] != null) { model.YWMC = row["YWMC"].ToString(); } if (row["YWJC"] != null) { model.YWJC = row["YWJC"].ToString(); } if (row["BZ"] != null) { model.BZ = row["BZ"].ToString(); } if (row["SFSC"] != null && row["SFSC"].ToString() != "") { model.SFSC = row["SFSC"].ToString(); } if (row["XH"] != null) { model.XH = int.Parse(row["XH"].ToString()); } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public EDRS.Model.XT_DM_YWBM GetModel(string YWBM) { StringBuilder strSql = new StringBuilder(); strSql.Append("select YWBM,YWMC,YWJC,BZ,SFSC,XH from XT_DM_YWBM "); strSql.Append(ConfigHelper.GetConfigString("OrcDBLinq")); strSql.Append(" where YWBM=:YWBM "); OracleParameter[] parameters = { new OracleParameter(":YWBM", OracleType.Char, 4) }; parameters[0].Value = YWBM; EDRS.Model.XT_DM_YWBM model = new EDRS.Model.XT_DM_YWBM(); DataSet ds = null; try { ds = DbHelperOra.Query(strSql.ToString(), parameters); } catch (Exception ex) { EDRS.Common.LogHelper.LogError(this.context, "Exception", ex.Message, "public EDRS.Model.XT_DM_YWBM GetModel(string YWBM)", "EDRS.OracleDAL.XT_DM_YWBM", strSql.ToString(), parameters); } if (ds != null && ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(EDRS.Model.XT_DM_YWBM model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into XT_DM_YWBM("); strSql.Append("YWBM,YWMC,YWJC,BZ,SFSC,XH)"); strSql.Append(" values ("); strSql.Append(":YWBM,:YWMC,:YWJC,:BZ,:SFSC,:XH)"); OracleParameter[] parameters = { new OracleParameter(":YWBM", OracleType.VarChar, 2), new OracleParameter(":YWMC", OracleType.VarChar, 60), new OracleParameter(":YWJC", OracleType.VarChar, 60), new OracleParameter(":BZ", OracleType.VarChar, 900), new OracleParameter(":SFSC", OracleType.Char, 1), new OracleParameter(":XH", OracleType.Number) }; parameters[0].Value = model.YWBM; parameters[1].Value = model.YWMC; parameters[2].Value = model.YWJC; parameters[3].Value = model.BZ; parameters[4].Value = model.SFSC; parameters[5].Value = model.XH; int rows = 0; try { rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters); } catch (Exception ex) { EDRS.Common.LogHelper.LogError(this.context, "Exception", ex.Message, "public bool Add(EDRS.Model.XT_DM_YWBM model)", "EDRS.OracleDAL.XT_DM_YWBM", 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)); } string ywbm = "01"; XT_DM_YWBM bll = new XT_DM_YWBM(this.Request); DataSet ds = bll.GetListByPage("", "ywbm desc", 1, 1, null); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { int num = int.Parse(ds.Tables[0].Rows[0]["YWBM"].ToString()); num++; ywbm = num.ToString().PadLeft(2, '0'); } EDRS.Model.XT_DM_YWBM model = new EDRS.Model.XT_DM_YWBM(); model.YWBM = ywbm; model.YWMC = Request.Form["txt_name"]; model.YWJC = Request.Form["txt_namejc"]; model.BZ = Request.Form["txt_bz"]; model.SFSC = "N"; if (bll.Add(model)) { //数据日志 OperateLog.AddLog(OperateLog.LogType.参数配置Web, "添加业务编码成功", "", UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.win, "保存成功", null)); } //数据日志 OperateLog.AddLog(OperateLog.LogType.参数配置Web, "添加业务编码失败", "", UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.error, "保存失败", null)); }
/// <summary> /// 修改类别 /// </summary> /// <returns></returns> private string UpData() { string ywbm = Request.Form.Get("key_hidd").Trim(); if (string.IsNullOrEmpty(ywbm)) { return(ReturnString.JsonToString(Prompt.error, "未找到需要修改信息", null)); } string msg = string.Empty; if (!ProvingFrom(ref msg)) { return(ReturnString.JsonToString(Prompt.error, msg, null)); } XT_DM_YWBM bll = new XT_DM_YWBM(this.Request); EDRS.Model.XT_DM_YWBM model = bll.GetModel(ywbm); if (model != null) { model.YWMC = Request.Form["txt_name"]; model.YWJC = Request.Form["txt_namejc"]; model.BZ = Request.Form["txt_bz"]; if (bll.Update(model)) { //数据日志 OperateLog.AddLog(OperateLog.LogType.参数配置Web, "修改业务编码成功", "", UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.win, "保存成功", null)); } //数据日志 OperateLog.AddLog(OperateLog.LogType.参数配置Web, "修改业务编码失败", "", UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.error, "保存失败", null)); } //数据日志 OperateLog.AddLog(OperateLog.LogType.参数配置Web, "修改业务编码未找到信息", "", UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.error, "未找到需要修改信息", null)); }
/// <summary> /// 根据类别编号获取数据 /// </summary> /// <param name="DWBM"></param> /// <returns></returns> private string GetModel(string ywbm) { if (string.IsNullOrEmpty(ywbm)) { ywbm = Request.Form.Get("id"); if (string.IsNullOrEmpty(ywbm)) { return(ReturnString.JsonToString(Prompt.error, "参数错误", null)); } } XT_DM_YWBM bll = new XT_DM_YWBM(this.Request); EDRS.Model.XT_DM_YWBM model = bll.GetModel(ywbm); if (model != null) { //数据日志 OperateLog.AddLog(OperateLog.LogType.参数配置Web, "根据编号获取业务编码信息成功", "", UserInfo, UserRole, this.Request); return(JsonHelper.JsonString(model)); } //数据日志 OperateLog.AddLog(OperateLog.LogType.参数配置Web, "根据编号获取业务编码信息失败", "", UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.error, "获取数据失败", null)); }