/// <summary> /// 增加一条数据 /// </summary> public bool Add(EDRS.Model.YX_DZJZ_FMDY model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into YX_DZJZ_FMDY("); strSql.Append("BT,FBT,AJMC,AJBH,FZXYR,LASJ,JASJ,LJDW,LJR,SHR,BAGJ,DJJ,GJY,CZRGH,CZR,CZSJ,CZIP,CZLX)"); strSql.Append(" values ("); strSql.Append(":BT,:FBT,:AJMC,:AJBH,:FZXYR,:LASJ,:JASJ,:LJDW,:LJR,:SHR,:BAGJ,:DJJ,:GJY,:CZRGH,:CZR,:CZSJ,:CZIP,:CZLX)"); OracleParameter[] parameters = { new OracleParameter(":BT", OracleType.VarChar, 500), new OracleParameter(":FBT", OracleType.VarChar, 500), new OracleParameter(":AJMC", OracleType.VarChar, 500), new OracleParameter(":AJBH", OracleType.VarChar, 500), new OracleParameter(":FZXYR", OracleType.VarChar, 2000), new OracleParameter(":LASJ", OracleType.DateTime), new OracleParameter(":JASJ", OracleType.DateTime), new OracleParameter(":LJDW", OracleType.VarChar, 300), new OracleParameter(":LJR", OracleType.VarChar, 300), new OracleParameter(":SHR", OracleType.VarChar, 300), new OracleParameter(":BAGJ", OracleType.Number, 18), new OracleParameter(":DJJ", OracleType.VarChar, 50), new OracleParameter(":GJY", OracleType.Number, 18), 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(":CZLX", OracleType.VarChar, 2) }; parameters[0].Value = model.BT; parameters[1].Value = model.FBT; parameters[2].Value = model.AJMC; parameters[3].Value = model.AJBH; parameters[4].Value = model.FZXYR; parameters[5].Value = model.LASJ ?? (object)DBNull.Value; parameters[6].Value = model.JASJ ?? (object)DBNull.Value; parameters[7].Value = model.LJDW; parameters[8].Value = model.LJR; parameters[9].Value = model.SHR; parameters[10].Value = model.BAGJ; parameters[11].Value = model.DJJ; parameters[12].Value = model.GJY; parameters[13].Value = model.CZRGH; parameters[14].Value = model.CZR; parameters[15].Value = model.CZSJ; parameters[16].Value = model.CZIP; parameters[17].Value = model.CZLX; int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 修改配置数据 /// </summary> /// <returns></returns> private string UpData() { string pzbm = Request.Form.Get("key_hidd").Trim(); if (string.IsNullOrEmpty(pzbm)) { return(ReturnString.JsonToString(Prompt.error, "未找到需要修改信息", null)); } string msg = string.Empty; if (!ProvingFrom(ref msg)) { return(ReturnString.JsonToString(Prompt.error, msg, null)); } YX_DZJZ_FMDY bll = new YX_DZJZ_FMDY(this.Request); EDRS.Model.YX_DZJZ_FMDY model = bll.GetModel(pzbm); if (model != null) { model.BT = Request.Form.Get("txt_bt"); model.FBT = Request.Form.Get("txt_fbt"); model.AJMC = Request.Form.Get("txt_ajmc"); model.AJBH = Request.Form.Get("txt_ajbh"); model.FZXYR = Request.Form.Get("txt_fzxyr"); if (!string.IsNullOrEmpty(Request.Form.Get("txt_lasj"))) { model.LASJ = Convert.ToDateTime(Request.Form.Get("txt_lasj")); } if (!string.IsNullOrEmpty(Request.Form.Get("txt_jasj"))) { model.JASJ = Convert.ToDateTime(Request.Form.Get("txt_jasj")); } model.LJDW = Request.Form.Get("txt_ljdw"); model.LJR = Request.Form.Get("txt_ljr"); model.SHR = Request.Form.Get("txt_shr"); model.BAGJ = string.IsNullOrEmpty(Request.Form.Get("txt_bagj")) ? 0 : int.Parse(Request.Form.Get("txt_bagj")); model.DJJ = Request.Form.Get("txt_djj"); model.GJY = string.IsNullOrEmpty(Request.Form.Get("txt_gjy")) ? 0 : int.Parse(Request.Form.Get("txt_gjy")); model.CZRGH = UserInfo.GH; model.CZR = UserInfo.MC; model.CZSJ = DateTime.Now; model.CZIP = Request.ServerVariables["REMOTE_ADDR"]; model.CZLX = ""; 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, "修改方面打印未找到信息", Request.Form.Get("txt_cs"), 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); //} YX_DZJZ_FMDY bll = new YX_DZJZ_FMDY(this.Request); EDRS.Model.YX_DZJZ_FMDY model = new EDRS.Model.YX_DZJZ_FMDY(); model.BT = Request.Form.Get("txt_bt"); model.FBT = Request.Form.Get("txt_fbt"); model.AJMC = Request.Form.Get("txt_ajmc"); model.AJBH = Request.Form.Get("txt_ajbh"); model.FZXYR = Request.Form.Get("txt_fzxyr"); model.LASJ = Convert.ToDateTime(Request.Form.Get("txt_lasj")); model.JASJ = Convert.ToDateTime(Request.Form.Get("txt_jasj")); model.LJDW = Request.Form.Get("txt_ljdw"); model.LJR = Request.Form.Get("txt_ljr"); model.SHR = Request.Form.Get("txt_shr"); model.BAGJ = int.Parse(Request.Form.Get("txt_bagj")); model.DJJ = Request.Form.Get("txt_djj"); model.GJY = int.Parse(Request.Form.Get("txt_gjy")); model.CZRGH = UserInfo.GH; model.CZR = UserInfo.MC; model.CZSJ = DateTime.Now; model.CZIP = ""; model.CZLX = ""; 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> /// <param name="DWBM"></param> /// <returns></returns> private string GetModel(string PZBM) { if (string.IsNullOrEmpty(PZBM)) { PZBM = Request["id"]; if (string.IsNullOrEmpty(PZBM)) { return(ReturnString.JsonToString(Prompt.error, "参数错误", null)); } } YX_DZJZ_FMDY bll = new YX_DZJZ_FMDY(this.Request); EDRS.Model.YX_DZJZ_FMDY model = bll.GetModel(PZBM); if (model != null) { //数据日志 OperateLog.AddLog(OperateLog.LogType.案件卷宗制作Web, "根据编号获取方面打印信息成功", "", UserInfo, UserRole, this.Request); return(JsonHelper.JsonString(model)); } //数据日志 OperateLog.AddLog(OperateLog.LogType.案件卷宗制作Web, "根据编号获取方面打印信息参数失败", Request["cs"], UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.error, "获取数据失败", null)); }
/// <summary> /// 得到一个对象实体 /// </summary> public EDRS.Model.YX_DZJZ_FMDY GetModel(string BM) { StringBuilder strSql = new StringBuilder(); strSql.Append("select BM,BT,FBT,AJMC,AJBH,FZXYR,LASJ,JASJ,LJDW,LJR,SHR,BAGJ,DJJ,GJY,CZRGH,CZR,CZSJ,CZIP,CZLX from YX_DZJZ_FMDY "); strSql.Append(" where BM=:BM "); OracleParameter[] parameters = { new OracleParameter(":BM", OracleType.NVarChar) }; parameters[0].Value = BM; EDRS.Model.YX_DZJZ_FMDY model = new EDRS.Model.YX_DZJZ_FMDY(); 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> public EDRS.Model.YX_DZJZ_FMDY DataRowToModel(DataRow row) { EDRS.Model.YX_DZJZ_FMDY model = new EDRS.Model.YX_DZJZ_FMDY(); if (row != null) { if (row["BM"] != null) { model.BM = row["BM"].ToString(); } if (row["BT"] != null) { model.BT = row["BT"].ToString(); } if (row["FBT"] != null) { model.FBT = row["FBT"].ToString(); } if (row["AJMC"] != null) { model.AJMC = row["AJMC"].ToString(); } if (row["AJBH"] != null) { model.AJBH = row["AJBH"].ToString(); } if (row["FZXYR"] != null) { model.FZXYR = row["FZXYR"].ToString(); } if (row["LASJ"] != null && row["LASJ"].ToString() != "") { model.LASJ = DateTime.Parse(row["LASJ"].ToString()); } if (row["JASJ"] != null && row["JASJ"].ToString() != "") { model.JASJ = DateTime.Parse(row["JASJ"].ToString()); } if (row["LJDW"] != null) { model.LJDW = row["LJDW"].ToString(); } if (row["LJR"] != null) { model.LJR = row["LJR"].ToString(); } if (row["SHR"] != null) { model.SHR = row["SHR"].ToString(); } if (row["BAGJ"] != null && row["BAGJ"].ToString() != "") { model.BAGJ = decimal.Parse(row["BAGJ"].ToString()); } if (row["DJJ"] != null) { model.DJJ = row["DJJ"].ToString(); } if (row["GJY"] != null && row["GJY"].ToString() != "") { model.GJY = decimal.Parse(row["GJY"].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["CZLX"] != null) { model.CZLX = row["CZLX"].ToString(); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(EDRS.Model.YX_DZJZ_FMDY model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update YX_DZJZ_FMDY set "); strSql.Append("BT=:BT,"); strSql.Append("FBT=:FBT,"); strSql.Append("AJMC=:AJMC,"); strSql.Append("AJBH=:AJBH,"); strSql.Append("FZXYR=:FZXYR,"); strSql.Append("LASJ=:LASJ,"); strSql.Append("JASJ=:JASJ,"); strSql.Append("LJDW=:LJDW,"); strSql.Append("LJR=:LJR,"); strSql.Append("SHR=:SHR,"); strSql.Append("BAGJ=:BAGJ,"); strSql.Append("DJJ=:DJJ,"); strSql.Append("GJY=:GJY,"); strSql.Append("CZRGH=:CZRGH,"); strSql.Append("CZR=:CZR,"); strSql.Append("CZSJ=:CZSJ,"); strSql.Append("CZIP=:CZIP,"); strSql.Append("CZLX=:CZLX"); strSql.Append(" where BM=:BM "); OracleParameter[] parameters = { new OracleParameter(":BT", OracleType.VarChar, 500), new OracleParameter(":FBT", OracleType.VarChar, 500), new OracleParameter(":AJMC", OracleType.VarChar, 500), new OracleParameter(":AJBH", OracleType.VarChar, 500), new OracleParameter(":FZXYR", OracleType.VarChar, 2000), new OracleParameter(":LASJ", OracleType.DateTime), new OracleParameter(":JASJ", OracleType.DateTime), new OracleParameter(":LJDW", OracleType.VarChar, 300), new OracleParameter(":LJR", OracleType.VarChar, 300), new OracleParameter(":SHR", OracleType.VarChar, 300), new OracleParameter(":BAGJ", OracleType.Number, 18), new OracleParameter(":DJJ", OracleType.VarChar, 50), new OracleParameter(":GJY", OracleType.Number, 18), 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(":CZLX", OracleType.VarChar, 2), new OracleParameter(":BM", OracleType.NVarChar) }; parameters[0].Value = model.BT; parameters[1].Value = model.FBT; parameters[2].Value = model.AJMC; parameters[3].Value = model.AJBH; parameters[4].Value = model.FZXYR; parameters[5].Value = model.LASJ; parameters[6].Value = model.JASJ; parameters[7].Value = model.LJDW; parameters[8].Value = model.LJR; parameters[9].Value = model.SHR; parameters[10].Value = model.BAGJ; parameters[11].Value = model.DJJ; parameters[12].Value = model.GJY; parameters[13].Value = model.CZRGH; parameters[14].Value = model.CZR; parameters[15].Value = model.CZSJ; parameters[16].Value = model.CZIP; parameters[17].Value = model.CZLX; parameters[18].Value = model.BM; int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }