/// <summary> /// 得到一个对象实体 /// </summary> public EDRS.Model.YX_DZJZ_JZML GetModel(string JZBH, string MLBH) { StringBuilder strSql = new StringBuilder(); strSql.Append("select JZBH,MLBH,SFSC,CJSJ,ZHXGSJ,FQDWBM,FQL,DWBM,BMSAH,FMLBH,MLXSMC,MLXX,MLSXH,MLBM,MLLX,SSLBBM,SSLBMC,SFSM from YX_DZJZ_JZML "); strSql.Append(ConfigHelper.GetConfigString("OrcDBLinq")); strSql.Append(" where JZBH=:JZBH and MLBH=:MLBH "); OracleParameter[] parameters = { new OracleParameter(":JZBH", OracleType.Char, 14), new OracleParameter(":MLBH", OracleType.VarChar, 100) }; parameters[0].Value = JZBH; parameters[1].Value = MLBH; EDRS.Model.YX_DZJZ_JZML model = new EDRS.Model.YX_DZJZ_JZML(); 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.YX_DZJZ_JZML GetModel(string JZBH,string MLBH)", "EDRS.OracleDAL.YX_DZJZ_JZML", 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.YX_DZJZ_JZML model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into YX_DZJZ_JZML("); strSql.Append("JZBH,MLBH,SFSC,CJSJ,ZHXGSJ,FQDWBM,FQL,DWBM,BMSAH,FMLBH,MLXSMC,MLXX,MLSXH,MLBM,MLLX,SSLBBM,SSLBMC,SFSM)"); strSql.Append(" values ("); strSql.Append(":JZBH,:MLBH,:SFSC,:CJSJ,:ZHXGSJ,:FQDWBM,:FQL,:DWBM,:BMSAH,:FMLBH,:MLXSMC,:MLXX,:MLSXH,:MLBM,:MLLX,:SSLBBM,:SSLBMC,:SFSM)"); OracleParameter[] parameters = { new OracleParameter(":JZBH", OracleType.Char, 14), new OracleParameter(":MLBH", OracleType.VarChar, 100), new OracleParameter(":SFSC", OracleType.Char, 1), new OracleParameter(":CJSJ", OracleType.DateTime), new OracleParameter(":ZHXGSJ", OracleType.DateTime), new OracleParameter(":FQDWBM", OracleType.VarChar, 50), new OracleParameter(":FQL", OracleType.VarChar, 6), new OracleParameter(":DWBM", OracleType.VarChar, 50), new OracleParameter(":BMSAH", OracleType.VarChar, 100), new OracleParameter(":FMLBH", OracleType.VarChar, 100), new OracleParameter(":MLXSMC", OracleType.VarChar, 300), new OracleParameter(":MLXX", OracleType.VarChar, 500), new OracleParameter(":MLSXH", OracleType.Number, 4), new OracleParameter(":MLBM", OracleType.VarChar, 300), new OracleParameter(":MLLX", OracleType.Char, 1), new OracleParameter(":SSLBBM", OracleType.Char, 13), new OracleParameter(":SSLBMC", OracleType.VarChar, 1000), new OracleParameter(":SFSM", OracleType.Char, 1) }; parameters[0].Value = model.JZBH; parameters[1].Value = model.MLBH; parameters[2].Value = model.SFSC; parameters[3].Value = model.CJSJ; parameters[4].Value = model.ZHXGSJ; parameters[5].Value = model.FQDWBM; parameters[6].Value = model.FQL; parameters[7].Value = model.DWBM; parameters[8].Value = model.BMSAH; parameters[9].Value = model.FMLBH; parameters[10].Value = model.MLXSMC; parameters[11].Value = model.MLXX; parameters[12].Value = model.MLSXH; parameters[13].Value = model.MLBM; parameters[14].Value = model.MLLX; parameters[15].Value = model.SSLBBM; parameters[16].Value = model.SSLBMC; parameters[17].Value = model.SFSM; 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.YX_DZJZ_JZML model)", "EDRS.OracleDAL.YX_DZJZ_JZML", strSql.ToString(), parameters); } if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public EDRS.Model.YX_DZJZ_JZML DataRowToModel(DataRow row) { EDRS.Model.YX_DZJZ_JZML model = new EDRS.Model.YX_DZJZ_JZML(); if (row != null) { if (row["JZBH"] != null) { model.JZBH = row["JZBH"].ToString(); } if (row["MLBH"] != null) { model.MLBH = row["MLBH"].ToString(); } if (row["SFSC"] != null) { model.SFSC = row["SFSC"].ToString(); } if (row["CJSJ"] != null && row["CJSJ"].ToString() != "") { model.CJSJ = DateTime.Parse(row["CJSJ"].ToString()); } if (row["ZHXGSJ"] != null && row["ZHXGSJ"].ToString() != "") { model.ZHXGSJ = DateTime.Parse(row["ZHXGSJ"].ToString()); } if (row["FQDWBM"] != null && row["FQDWBM"].ToString() != "") { model.FQDWBM = decimal.Parse(row["FQDWBM"].ToString()); } if (row["FQL"] != null) { model.FQL = row["FQL"].ToString(); } if (row["DWBM"] != null) { model.DWBM = row["DWBM"].ToString(); } if (row["BMSAH"] != null) { model.BMSAH = row["BMSAH"].ToString(); } if (row["FMLBH"] != null) { model.FMLBH = row["FMLBH"].ToString(); } if (row["MLXSMC"] != null) { model.MLXSMC = row["MLXSMC"].ToString(); } if (row["MLXX"] != null) { model.MLXX = row["MLXX"].ToString(); } if (row["MLSXH"] != null && row["MLSXH"].ToString() != "") { model.MLSXH = decimal.Parse(row["MLSXH"].ToString()); } if (row["MLBM"] != null) { model.MLBM = row["MLBM"].ToString(); } if (row["MLLX"] != null) { model.MLLX = row["MLLX"].ToString(); } if (row["SSLBBM"] != null) { model.SSLBBM = row["SSLBBM"].ToString(); } if (row["SSLBMC"] != null) { model.SSLBMC = row["SSLBMC"].ToString(); } if (row["SFSM"] != null) { model.SFSM = row["SFSM"].ToString(); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(EDRS.Model.YX_DZJZ_JZML model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update YX_DZJZ_JZML set "); strSql.Append("SFSC=:SFSC,"); strSql.Append("CJSJ=:CJSJ,"); strSql.Append("ZHXGSJ=:ZHXGSJ,"); strSql.Append("FQDWBM=:FQDWBM,"); strSql.Append("FQL=:FQL,"); strSql.Append("DWBM=:DWBM,"); strSql.Append("BMSAH=:BMSAH,"); strSql.Append("FMLBH=:FMLBH,"); strSql.Append("MLXSMC=:MLXSMC,"); strSql.Append("MLXX=:MLXX,"); strSql.Append("MLSXH=:MLSXH,"); strSql.Append("MLBM=:MLBM,"); strSql.Append("MLLX=:MLLX,"); strSql.Append("SSLBBM=:SSLBBM,"); strSql.Append("SSLBMC=:SSLBMC,"); strSql.Append("SFSM=:SFSM"); strSql.Append(" where JZBH=:JZBH and MLBH=:MLBH "); OracleParameter[] parameters = { new OracleParameter(":SFSC", OracleType.Char, 1), new OracleParameter(":CJSJ", OracleType.DateTime), new OracleParameter(":ZHXGSJ", OracleType.DateTime), new OracleParameter(":FQDWBM", OracleType.VarChar, 50), new OracleParameter(":FQL", OracleType.VarChar, 6), new OracleParameter(":DWBM", OracleType.VarChar, 50), new OracleParameter(":BMSAH", OracleType.VarChar, 100), new OracleParameter(":FMLBH", OracleType.VarChar, 100), new OracleParameter(":MLXSMC", OracleType.VarChar, 300), new OracleParameter(":MLXX", OracleType.VarChar, 500), new OracleParameter(":MLSXH", OracleType.Number, 4), new OracleParameter(":MLBM", OracleType.VarChar, 300), new OracleParameter(":MLLX", OracleType.Char, 1), new OracleParameter(":SSLBBM", OracleType.Char, 13), new OracleParameter(":SSLBMC", OracleType.VarChar, 1000), new OracleParameter(":SFSM", OracleType.Char, 1), new OracleParameter(":JZBH", OracleType.Char, 14), new OracleParameter(":MLBH", OracleType.VarChar, 100) }; parameters[0].Value = model.SFSC; parameters[1].Value = model.CJSJ; parameters[2].Value = model.ZHXGSJ; parameters[3].Value = model.FQDWBM; parameters[4].Value = model.FQL; parameters[5].Value = model.DWBM; parameters[6].Value = model.BMSAH; parameters[7].Value = model.FMLBH; parameters[8].Value = model.MLXSMC; parameters[9].Value = model.MLXX; parameters[10].Value = model.MLSXH; parameters[11].Value = model.MLBM; parameters[12].Value = model.MLLX; parameters[13].Value = model.SSLBBM; parameters[14].Value = model.SSLBMC; parameters[15].Value = model.SFSM; parameters[16].Value = model.JZBH; parameters[17].Value = model.MLBH; int rows = 0; try { rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters); } catch (Exception ex) { EDRS.Common.LogHelper.LogError(this.context, "Exception", ex.Message, "public bool Update(EDRS.Model.YX_DZJZ_JZML model)", "EDRS.OracleDAL.YX_DZJZ_JZML", strSql.ToString(), parameters); } if (rows > 0) { return(true); } else { return(false); } }