/// <summary> /// 得到一个对象实体 /// </summary> public EDRS.Model.XT_DZJZ_SSLB DataRowToModel(DataRow row) { EDRS.Model.XT_DZJZ_SSLB model = new EDRS.Model.XT_DZJZ_SSLB(); if (row != null) { if (row["SSLBBM"] != null) { model.SSLBBM = row["SSLBBM"].ToString(); } if (row["FSSLBBM"] != null) { model.FSSLBBM = row["FSSLBBM"].ToString(); } if (row["SSLBLX"] != null) { model.SSLBLX = row["SSLBLX"].ToString(); } if (row["SSLBMC"] != null) { model.SSLBMC = row["SSLBMC"].ToString(); } if (row["SSLBSX"] != null && row["SSLBSX"].ToString() != "") { model.SSLBSX = decimal.Parse(row["SSLBSX"].ToString()); } if (row["SSLBSM"] != null) { model.SSLBSM = row["SSLBSM"].ToString(); } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public EDRS.Model.XT_DZJZ_SSLB GetModel(string SSLBBM) { StringBuilder strSql = new StringBuilder(); strSql.Append("select SSLBBM,FSSLBBM,SSLBLX,SSLBMC,SSLBSX,SSLBSM from XT_DZJZ_SSLB "); strSql.Append(" where SSLBBM=:SSLBBM "); OracleParameter[] parameters = { new OracleParameter(":SSLBBM", OracleType.Char, 13) }; parameters[0].Value = SSLBBM; EDRS.Model.XT_DZJZ_SSLB model = new EDRS.Model.XT_DZJZ_SSLB(); try { DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } } catch (Exception ex) { EDRS.Common.LogHelper.LogError(this.context, "Exception", ex.Message, "public EDRS.Model.XT_DZJZ_SSLB GetModel(string SSLBBM)", "EDRS.OracleDAL.XT_DZJZ_SSLB", strSql.ToString()); } return(null); }
/// <summary> /// 修改类别 /// </summary> /// <returns></returns> private string UpData() { string ajlbbm = Request.Form.Get("key_hidd").Trim(); if (string.IsNullOrEmpty(ajlbbm)) { return(ReturnString.JsonToString(Prompt.error, "未找到需要修改信息", null)); } string msg = string.Empty; if (!ProvingFrom(ref msg)) { return(ReturnString.JsonToString(Prompt.error, msg, null)); } XT_DZJZ_SSLB bll = new XT_DZJZ_SSLB(this.Request); EDRS.Model.XT_DZJZ_SSLB model = bll.GetModel(ajlbbm); string lbbm = string.Empty; if (model != null) { lbbm = model.SSLBBM; model.SSLBMC = Request.Form.Get("txt_name"); model.SSLBSX = Convert.ToDecimal(Request.Form.Get("txt_sx")); model.SSLBSM = Request.Form.Get("txt_sm"); if (bll.Update(model)) { System.Collections.Hashtable hssql = new System.Collections.Hashtable(); hssql.Add(string.Format("update xy_dzjz_mbpzb set sslbmc='{0}',DossierTypeDisplayMember='{0}' where sslbbm='{1}'", model.SSLBMC, lbbm), null); XY_DZJZ_MBPZB bllmb = new XY_DZJZ_MBPZB(this.Request); bllmb.Update(hssql); //数据日志 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> public bool Update(EDRS.Model.XT_DZJZ_SSLB model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update XT_DZJZ_SSLB set "); strSql.Append("FSSLBBM=:FSSLBBM,"); strSql.Append("SSLBLX=:SSLBLX,"); strSql.Append("SSLBMC=:SSLBMC,"); strSql.Append("SSLBSX=:SSLBSX,"); strSql.Append("SSLBSM=:SSLBSM"); strSql.Append(" where SSLBBM=:SSLBBM "); OracleParameter[] parameters = { new OracleParameter(":FSSLBBM", OracleType.Char, 13), new OracleParameter(":SSLBLX", OracleType.Char, 1), new OracleParameter(":SSLBMC", OracleType.VarChar, 300), new OracleParameter(":SSLBSX", OracleType.Number, 8), new OracleParameter(":SSLBSM", OracleType.VarChar, 4000), new OracleParameter(":SSLBBM", OracleType.Char, 13) }; parameters[0].Value = model.FSSLBBM; parameters[1].Value = model.SSLBLX; parameters[2].Value = model.SSLBMC; parameters[3].Value = model.SSLBSX; parameters[4].Value = model.SSLBSM; parameters[5].Value = model.SSLBBM; try { int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } } catch (Exception ex) { EDRS.Common.LogHelper.LogError(this.context, "Exception", ex.Message, "public bool Update(EDRS.Model.XT_DZJZ_SSLB model)", "EDRS.OracleDAL.XT_DZJZ_SSLB", strSql.ToString(), parameters); } return(false); }
/// <summary> /// 根据类别编号获取数据 /// </summary> /// <param name="DWBM"></param> /// <returns></returns> private string GetModel(string sslbbm) { if (string.IsNullOrEmpty(sslbbm)) { sslbbm = Request.Form.Get("id"); if (string.IsNullOrEmpty(sslbbm)) { return(ReturnString.JsonToString(Prompt.error, "参数错误", null)); } } XT_DZJZ_SSLB bll = new XT_DZJZ_SSLB(this.Request); EDRS.Model.XT_DZJZ_SSLB model = bll.GetModel(sslbbm); 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)); }
/// <summary> /// 添加类别 /// </summary> /// <returns></returns> private string AddData() { string msg = string.Empty; if (!ProvingFrom(ref msg)) { return(ReturnString.JsonToString(Prompt.error, msg, null)); } string whereValue = String.Empty; string lx = Request.Form.Get("slct_type_val"); if (lx == "1") { whereValue = "000000-"; } else if (lx == "2") { whereValue = "000001-"; } else if (lx == "3") { whereValue = "000002-"; } else { return(ReturnString.JsonToString(Prompt.error, "类型选择错误,请刷新页面重试!", null)); } XT_DZJZ_SSLB bll = new XT_DZJZ_SSLB(this.Request); DataSet ds = bll.GetListByPage(" and sslbbm like '" + whereValue + "%' ", "sslbbm desc", 1, 1, null); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { //0101 000000-000000 int num = int.Parse(ds.Tables[0].Rows[0]["SSLBBM"].ToString().Substring(7, 6)); num++; whereValue += num.ToString().PadLeft(6, '0'); } else { whereValue += "000000"; } EDRS.Model.XT_DZJZ_SSLB model = new EDRS.Model.XT_DZJZ_SSLB(); model.SSLBBM = whereValue; model.SSLBLX = lx; model.SSLBMC = Request.Form["txt_name"]; model.SSLBSX = Convert.ToDecimal(Request.Form["txt_sx"]); model.SSLBSM = Request.Form["txt_sm"]; model.FSSLBBM = Request.Form["key_fhidd"]; //LogHelper.LogError(Request, "id:" + model.SSLBBM + ",Fid:" + model.FSSLBBM, " 1", "测试1"); 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)); }