/// <summary> /// 得到一个对象实体 /// </summary> public EDRS.Model.YX_DZJZ_JZAJXX GetModel(string BMSAH) { StringBuilder strSql = new StringBuilder(); strSql.Append("select BMSAH,TYSAH,AJMC,AJLB_BM,AJLB_MC,CBDWBM,CBDWMC,CBBMBM,CBBMMC,CBRGH,CBR,ZZSJ,JZSL,JZWJS,JZYS,JZSZKJ,FQL,ZJYCXGSJ,ZJYCXGRGH,ZJYCXGRXM,SFSC from YX_DZJZ_JZAJXX "); strSql.Append(ConfigHelper.GetConfigString("OrcDBLinq")); strSql.Append(" where BMSAH=:BMSAH "); OracleParameter[] parameters = { new OracleParameter(":BMSAH", OracleType.VarChar, 100) }; parameters[0].Value = BMSAH; EDRS.Model.YX_DZJZ_JZAJXX model = new EDRS.Model.YX_DZJZ_JZAJXX(); 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_JZAJXX GetModel(string BMSAH)", "EDRS.OracleDAL.YX_DZJZ_JZAJXX", 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_JZAJXX model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into YX_DZJZ_JZAJXX("); strSql.Append("BMSAH,TYSAH,AJMC,AJLB_BM,AJLB_MC,CBDWBM,CBDWMC,CBBMBM,CBBMMC,CBRGH,CBR,ZZSJ,JZSL,JZWJS,JZYS,JZSZKJ,FQL,ZJYCXGSJ,ZJYCXGRGH,ZJYCXGRXM,SFSC)"); strSql.Append(" values ("); strSql.Append(":BMSAH,:TYSAH,:AJMC,:AJLB_BM,:AJLB_MC,:CBDWBM,:CBDWMC,:CBBMBM,:CBBMMC,:CBRGH,:CBR,:ZZSJ,:JZSL,:JZWJS,:JZYS,:JZSZKJ,:FQL,:ZJYCXGSJ,:ZJYCXGRGH,:ZJYCXGRXM,:SFSC)"); OracleParameter[] parameters = { new OracleParameter(":BMSAH", OracleType.VarChar, 100), new OracleParameter(":TYSAH", OracleType.VarChar, 100), new OracleParameter(":AJMC", OracleType.VarChar, 300), new OracleParameter(":AJLB_BM", OracleType.VarChar, 50), new OracleParameter(":AJLB_MC", OracleType.VarChar, 300), new OracleParameter(":CBDWBM", OracleType.VarChar, 50), new OracleParameter(":CBDWMC", OracleType.VarChar, 300), new OracleParameter(":CBBMBM", OracleType.Char, 4), new OracleParameter(":CBBMMC", OracleType.VarChar, 300), new OracleParameter(":CBRGH", OracleType.Char, 4), new OracleParameter(":CBR", OracleType.VarChar, 60), new OracleParameter(":ZZSJ", OracleType.DateTime), new OracleParameter(":JZSL", OracleType.Number, 4), new OracleParameter(":JZWJS", OracleType.Number, 4), new OracleParameter(":JZYS", OracleType.Number, 4), new OracleParameter(":JZSZKJ", OracleType.Number, 12), new OracleParameter(":FQL", OracleType.Char, 4), new OracleParameter(":ZJYCXGSJ", OracleType.DateTime), new OracleParameter(":ZJYCXGRGH", OracleType.Char, 4), new OracleParameter(":ZJYCXGRXM", OracleType.VarChar, 60), new OracleParameter(":SFSC", OracleType.Char, 1) }; parameters[0].Value = model.BMSAH ?? ""; parameters[1].Value = model.TYSAH ?? ""; parameters[2].Value = model.AJMC ?? ""; parameters[3].Value = model.AJLB_BM ?? ""; parameters[4].Value = model.AJLB_MC ?? ""; parameters[5].Value = model.CBDWBM ?? ""; parameters[6].Value = model.CBDWMC ?? ""; parameters[7].Value = model.CBBMBM ?? ""; parameters[8].Value = model.CBBMMC ?? ""; parameters[9].Value = model.CBRGH ?? ""; parameters[10].Value = model.CBR ?? ""; parameters[11].Value = model.ZZSJ ?? DateTime.Now; parameters[12].Value = model.JZSL ?? 0; parameters[13].Value = model.JZWJS ?? 0; parameters[14].Value = model.JZYS ?? 0; parameters[15].Value = model.JZSZKJ ?? 0; parameters[16].Value = model.FQL; parameters[17].Value = model.ZJYCXGSJ ?? DateTime.Now; parameters[18].Value = model.ZJYCXGRGH ?? ""; parameters[19].Value = model.ZJYCXGRXM ?? ""; parameters[20].Value = model.SFSC ?? ""; 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_JZAJXX model)", "EDRS.OracleDAL.YX_DZJZ_JZAJXX", strSql.ToString(), parameters); } if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public EDRS.Model.YX_DZJZ_JZAJXX DataRowToModel(DataRow row) { EDRS.Model.YX_DZJZ_JZAJXX model = new EDRS.Model.YX_DZJZ_JZAJXX(); if (row != null) { if (row["BMSAH"] != null) { model.BMSAH = row["BMSAH"].ToString(); } if (row["TYSAH"] != null) { model.TYSAH = row["TYSAH"].ToString(); } if (row["AJMC"] != null) { model.AJMC = row["AJMC"].ToString(); } if (row["AJLB_BM"] != null) { model.AJLB_BM = row["AJLB_BM"].ToString(); } if (row["AJLB_MC"] != null) { model.AJLB_MC = row["AJLB_MC"].ToString(); } if (row["CBDWBM"] != null) { model.CBDWBM = row["CBDWBM"].ToString(); } if (row["CBDWMC"] != null) { model.CBDWMC = row["CBDWMC"].ToString(); } if (row["CBBMBM"] != null) { model.CBBMBM = row["CBBMBM"].ToString(); } if (row["CBBMMC"] != null) { model.CBBMMC = row["CBBMMC"].ToString(); } if (row["CBRGH"] != null) { model.CBRGH = row["CBRGH"].ToString(); } if (row["CBR"] != null) { model.CBR = row["CBR"].ToString(); } if (row["ZZSJ"] != null && row["ZZSJ"].ToString() != "") { model.ZZSJ = DateTime.Parse(row["ZZSJ"].ToString()); } if (row["JZSL"] != null && row["JZSL"].ToString() != "") { model.JZSL = decimal.Parse(row["JZSL"].ToString()); } if (row["JZWJS"] != null && row["JZWJS"].ToString() != "") { model.JZWJS = decimal.Parse(row["JZWJS"].ToString()); } if (row["JZYS"] != null && row["JZYS"].ToString() != "") { model.JZYS = decimal.Parse(row["JZYS"].ToString()); } if (row["JZSZKJ"] != null && row["JZSZKJ"].ToString() != "") { model.JZSZKJ = decimal.Parse(row["JZSZKJ"].ToString()); } if (row["FQL"] != null) { model.FQL = row["FQL"].ToString(); } if (row["ZJYCXGSJ"] != null && row["ZJYCXGSJ"].ToString() != "") { model.ZJYCXGSJ = DateTime.Parse(row["ZJYCXGSJ"].ToString()); } if (row["ZJYCXGRGH"] != null) { model.ZJYCXGRGH = row["ZJYCXGRGH"].ToString(); } if (row["ZJYCXGRXM"] != null) { model.ZJYCXGRXM = row["ZJYCXGRXM"].ToString(); } if (row["SFSC"] != null) { model.SFSC = row["SFSC"].ToString(); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(EDRS.Model.YX_DZJZ_JZAJXX model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update YX_DZJZ_JZAJXX set "); strSql.Append("TYSAH=:TYSAH,"); strSql.Append("AJMC=:AJMC,"); strSql.Append("AJLB_BM=:AJLB_BM,"); strSql.Append("AJLB_MC=:AJLB_MC,"); strSql.Append("CBDWBM=:CBDWBM,"); strSql.Append("CBDWMC=:CBDWMC,"); strSql.Append("CBBMBM=:CBBMBM,"); strSql.Append("CBBMMC=:CBBMMC,"); strSql.Append("CBRGH=:CBRGH,"); strSql.Append("CBR=:CBR,"); strSql.Append("ZZSJ=:ZZSJ,"); strSql.Append("JZSL=:JZSL,"); strSql.Append("JZWJS=:JZWJS,"); strSql.Append("JZYS=:JZYS,"); strSql.Append("JZSZKJ=:JZSZKJ,"); strSql.Append("FQL=:FQL,"); strSql.Append("ZJYCXGSJ=:ZJYCXGSJ,"); strSql.Append("ZJYCXGRGH=:ZJYCXGRGH,"); strSql.Append("ZJYCXGRXM=:ZJYCXGRXM,"); strSql.Append("SFSC=:SFSC"); strSql.Append(" where BMSAH=:BMSAH "); OracleParameter[] parameters = { new OracleParameter(":TYSAH", OracleType.VarChar, 100), new OracleParameter(":AJMC", OracleType.VarChar, 300), new OracleParameter(":AJLB_BM", OracleType.VarChar, 50), new OracleParameter(":AJLB_MC", OracleType.VarChar, 300), new OracleParameter(":CBDWBM", OracleType.VarChar, 50), new OracleParameter(":CBDWMC", OracleType.VarChar, 300), new OracleParameter(":CBBMBM", OracleType.Char, 4), new OracleParameter(":CBBMMC", OracleType.VarChar, 300), new OracleParameter(":CBRGH", OracleType.Char, 4), new OracleParameter(":CBR", OracleType.VarChar, 60), new OracleParameter(":ZZSJ", OracleType.DateTime), new OracleParameter(":JZSL", OracleType.Number, 4), new OracleParameter(":JZWJS", OracleType.Number, 4), new OracleParameter(":JZYS", OracleType.Number, 4), new OracleParameter(":JZSZKJ", OracleType.Number, 12), new OracleParameter(":FQL", OracleType.Char, 4), new OracleParameter(":ZJYCXGSJ", OracleType.DateTime), new OracleParameter(":ZJYCXGRGH", OracleType.Char, 4), new OracleParameter(":ZJYCXGRXM", OracleType.VarChar, 60), new OracleParameter(":SFSC", OracleType.Char, 1), new OracleParameter(":BMSAH", OracleType.VarChar, 100) }; parameters[0].Value = model.TYSAH; parameters[1].Value = model.AJMC; parameters[2].Value = model.AJLB_BM; parameters[3].Value = model.AJLB_MC; parameters[4].Value = model.CBDWBM; parameters[5].Value = model.CBDWMC; parameters[6].Value = model.CBBMBM; parameters[7].Value = model.CBBMMC; parameters[8].Value = model.CBRGH; parameters[9].Value = model.CBR; parameters[10].Value = model.ZZSJ; parameters[11].Value = model.JZSL; parameters[12].Value = model.JZWJS; parameters[13].Value = model.JZYS; parameters[14].Value = model.JZSZKJ; parameters[15].Value = model.FQL; parameters[16].Value = model.ZJYCXGSJ; parameters[17].Value = model.ZJYCXGRGH; parameters[18].Value = model.ZJYCXGRXM; parameters[19].Value = model.SFSC; parameters[20].Value = model.BMSAH; 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_JZAJXX model)", "EDRS.OracleDAL.YX_DZJZ_JZAJXX", strSql.ToString(), parameters); } if (rows > 0) { return(true); } else { return(false); } }