/// <summary> /// 添加配置数据 /// </summary> /// <returns></returns> private string AddData() { string msg = string.Empty; //if (!ProvingFrom(ref msg)) //{ // return ReturnString.JsonToString(Prompt.error, msg, null); //} YX_DZJZ_FMDYMB bll = new YX_DZJZ_FMDYMB(this.Request); EDRS.Model.YX_DZJZ_FMDYMB model = new EDRS.Model.YX_DZJZ_FMDYMB(); model.BT = Request.Form.Get("title"); model.NR = Request.Form.Get("value"); model.CZRGH = ""; model.CZR = ""; model.CZSJ = DateTime.Now; model.CZIP = Request.ServerVariables["REMOTE_ADDR"]; 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> public bool Update(EDRS.Model.YX_DZJZ_FMDYMB model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update YX_DZJZ_FMDYMB set "); strSql.Append("BT=:BT,"); strSql.Append("SFMR=:SFMR,"); strSql.Append("CZRGH=:CZRGH,"); strSql.Append("CZR=:CZR,"); strSql.Append("CZSJ=:CZSJ,"); strSql.Append("CZIP=:CZIP,"); strSql.Append("SFSC=:SFSC,"); strSql.Append("NR=:NR"); strSql.Append(" where BM=:BM "); OracleParameter[] parameters = { new OracleParameter(":BT", OracleType.VarChar, 500), new OracleParameter(":SFMR", OracleType.Char, 1), new OracleParameter(":CZRGH", OracleType.Char, 4), new OracleParameter(":CZR", OracleType.VarChar, 60), new OracleParameter(":CZSJ", OracleType.DateTime), new OracleParameter(":CZIP", OracleType.VarChar, 20), new OracleParameter(":SFSC", OracleType.Char, 1), new OracleParameter(":BM", OracleType.NVarChar), new OracleParameter(":NR", OracleType.VarChar, 4000) }; parameters[0].Value = model.BT; parameters[1].Value = model.SFMR; parameters[2].Value = model.CZRGH; parameters[3].Value = model.CZR; parameters[4].Value = model.CZSJ; parameters[5].Value = model.CZIP; parameters[6].Value = model.SFSC; parameters[7].Value = model.BM; parameters[8].Value = model.NR; int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public EDRS.Model.YX_DZJZ_FMDYMB DataRowToModel(DataRow row) { EDRS.Model.YX_DZJZ_FMDYMB model = new EDRS.Model.YX_DZJZ_FMDYMB(); if (row != null) { if (row["BM"] != null) { model.BM = row["BM"].ToString(); } if (row["BT"] != null) { model.BT = row["BT"].ToString(); } if (row["NR"] != null) { model.NR = row["NR"].ToString(); } if (row["SFMR"] != null) { model.SFMR = row["SFMR"].ToString(); } if (row["CZRGH"] != null) { model.CZRGH = row["CZRGH"].ToString(); } if (row["CZR"] != null) { model.CZR = row["CZR"].ToString(); } if (row["CZSJ"] != null && row["CZSJ"].ToString() != "") { model.CZSJ = DateTime.Parse(row["CZSJ"].ToString()); } if (row["CZIP"] != null) { model.CZIP = row["CZIP"].ToString(); } if (row["SFSC"] != null) { model.SFSC = row["SFSC"].ToString(); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(EDRS.Model.YX_DZJZ_FMDYMB model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into YX_DZJZ_FMDYMB("); strSql.Append("BT,SFMR,CZRGH,CZR,CZSJ,CZIP,SFSC,NR)"); strSql.Append(" values ("); strSql.Append(":BT,:SFMR,:CZRGH,:CZR,:CZSJ,:CZIP,:SFSC,:NR)"); OracleParameter[] parameters = { new OracleParameter(":BT", OracleType.VarChar, 500), new OracleParameter(":SFMR", OracleType.Char, 1), new OracleParameter(":CZRGH", OracleType.Char, 4), new OracleParameter(":CZR", OracleType.VarChar, 60), new OracleParameter(":CZSJ", OracleType.DateTime), new OracleParameter(":CZIP", OracleType.VarChar, 20), new OracleParameter(":SFSC", OracleType.Char, 1), new OracleParameter(":NR", OracleType.VarChar, 4000) }; parameters[0].Value = model.BT; parameters[1].Value = model.SFMR; parameters[2].Value = model.CZRGH; parameters[3].Value = model.CZR; parameters[4].Value = model.CZSJ; parameters[5].Value = model.CZIP; parameters[6].Value = model.SFSC; parameters[7].Value = model.NR; int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public EDRS.Model.YX_DZJZ_FMDYMB GetModel(string BM) { StringBuilder strSql = new StringBuilder(); strSql.Append("select BM,BT,SFMR,CZRGH,CZR,CZSJ,CZIP,SFSC,NR from YX_DZJZ_FMDYMB "); strSql.Append(" where BM=:BM "); OracleParameter[] parameters = { new OracleParameter(":BM", OracleType.NVarChar) }; parameters[0].Value = BM; EDRS.Model.YX_DZJZ_FMDYMB model = new EDRS.Model.YX_DZJZ_FMDYMB(); DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }