/// <summary> /// 得到一个对象实体 /// </summary> public RelayTest.Model.ModelTEST_INFO GetModel(string F_TEST_TASK_ID) { try { Log.Info("DalTEST_INFO->GetModel---START"); StringBuilder strSql = new StringBuilder(); strSql.Append("select "); //试验任务编号 strSql.Append("F_TEST_TASK_ID, "); //检测项目 strSql.Append("F_TEST_ITEM, "); //规格型号 strSql.Append("F_TEST_MODEL, "); //检测标准 strSql.Append("F_TEST_STANDARD, "); //检测性质 strSql.Append("F_TEST_PROPERTY, "); //检测目的 strSql.Append("F_TEST_AIM, "); //委托单位 strSql.Append("F_TASK_DEPUTE_UNIT, "); //联系人 strSql.Append("F_CONTACT, "); //电话 strSql.Append("F_PHONE, "); //email strSql.Append("F_EMAIL, "); //项目负责人 strSql.Append("F_TEST_CHARGE, "); //委托日期 strSql.Append("F_TASK_DEPUTE_DATE, "); //样品系列 strSql.Append("F_TEST_SERIES, "); //样品类别 strSql.Append("F_SAMPLE_TYPE, "); //序列试验 strSql.Append("F_SEQUENCE_TEST, "); //试验状态 strSql.Append("F_TEST_STATUS, "); //创建时间 strSql.Append("F_CREATE_TIME, "); //操作员 strSql.Append("F_OPERATOR_ID, "); //操作时间 strSql.Append("F_OPERATIONTIME, "); //是否删除 strSql.Append("F_DEL "); strSql.Append(" from T_TEST_INFO "); strSql.Append(" where 1=1 AND F_TEST_TASK_ID=:F_TEST_TASK_ID "); OracleParameter[] parameters = { new OracleParameter(":F_TEST_TASK_ID", OracleType.VarChar, 20) }; parameters[0].Value = F_TEST_TASK_ID; RelayTest.Model.ModelTEST_INFO model = new RelayTest.Model.ModelTEST_INFO(); DataSet ds = Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { model.F_TEST_TASK_ID = ds.Tables[0].Rows[0]["F_TEST_TASK_ID"].ToString(); model.F_TEST_ITEM = ds.Tables[0].Rows[0]["F_TEST_ITEM"].ToString(); model.F_TEST_MODEL = ds.Tables[0].Rows[0]["F_TEST_MODEL"].ToString(); model.F_TEST_STANDARD = ds.Tables[0].Rows[0]["F_TEST_STANDARD"].ToString(); model.F_TEST_PROPERTY = ds.Tables[0].Rows[0]["F_TEST_PROPERTY"].ToString(); model.F_TEST_AIM = ds.Tables[0].Rows[0]["F_TEST_AIM"].ToString(); model.F_TASK_DEPUTE_UNIT = ds.Tables[0].Rows[0]["F_TASK_DEPUTE_UNIT"].ToString(); model.F_CONTACT = ds.Tables[0].Rows[0]["F_CONTACT"].ToString(); model.F_PHONE = ds.Tables[0].Rows[0]["F_PHONE"].ToString(); model.F_EMAIL = ds.Tables[0].Rows[0]["F_EMAIL"].ToString(); model.F_TEST_CHARGE = ds.Tables[0].Rows[0]["F_TEST_CHARGE"].ToString(); if (ds.Tables[0].Rows[0]["F_TASK_DEPUTE_DATE"].ToString() != "") { model.F_TASK_DEPUTE_DATE = DateTime.Parse(ds.Tables[0].Rows[0]["F_TASK_DEPUTE_DATE"].ToString()); } model.F_TEST_SERIES = ds.Tables[0].Rows[0]["F_TEST_SERIES"].ToString(); model.F_SAMPLE_TYPE = ds.Tables[0].Rows[0]["F_SAMPLE_TYPE"].ToString(); if (ds.Tables[0].Rows[0]["F_SEQUENCE_TEST"].ToString() != "") { model.F_SEQUENCE_TEST = decimal.Parse(ds.Tables[0].Rows[0]["F_SEQUENCE_TEST"].ToString()); } if (ds.Tables[0].Rows[0]["F_TEST_STATUS"].ToString() != "") { model.F_TEST_STATUS = decimal.Parse(ds.Tables[0].Rows[0]["F_TEST_STATUS"].ToString()); } if (ds.Tables[0].Rows[0]["F_CREATE_TIME"].ToString() != "") { model.F_CREATE_TIME = DateTime.Parse(ds.Tables[0].Rows[0]["F_CREATE_TIME"].ToString()); } model.F_OPERATOR_ID = ds.Tables[0].Rows[0]["F_OPERATOR_ID"].ToString(); if (ds.Tables[0].Rows[0]["F_OPERATIONTIME"].ToString() != "") { model.F_OPERATIONTIME = DateTime.Parse(ds.Tables[0].Rows[0]["F_OPERATIONTIME"].ToString()); } if (ds.Tables[0].Rows[0]["F_DEL"].ToString() != "") { model.F_DEL = decimal.Parse(ds.Tables[0].Rows[0]["F_DEL"].ToString()); } return(model); } else { return(null); } } catch (Exception ex) { Log.Error("DalTEST_INFO->GetModel---FAILED", ex); throw ex; } }
/// <summary> /// 增加一条数据 /// </summary> public void Add(RelayTest.Model.ModelTEST_INFO model) { try { Log.Info("DalTEST_INFO->Add---START"); StringBuilder strSql = new StringBuilder(); strSql.Append("insert into T_TEST_INFO("); //试验任务编号 strSql.Append(" F_TEST_TASK_ID,"); //检测项目 strSql.Append(" F_TEST_ITEM,"); //规格型号 strSql.Append(" F_TEST_MODEL,"); //检测标准 strSql.Append(" F_TEST_STANDARD,"); //检测性质 strSql.Append(" F_TEST_PROPERTY,"); //检测目的 strSql.Append(" F_TEST_AIM,"); //委托单位 strSql.Append(" F_TASK_DEPUTE_UNIT,"); //联系人 strSql.Append(" F_CONTACT,"); //电话 strSql.Append(" F_PHONE,"); //email strSql.Append(" F_EMAIL,"); //项目负责人 strSql.Append(" F_TEST_CHARGE,"); //委托日期 strSql.Append(" F_TASK_DEPUTE_DATE,"); //样品系列 strSql.Append(" F_TEST_SERIES,"); //样品类别 strSql.Append(" F_SAMPLE_TYPE,"); //序列试验 strSql.Append(" F_SEQUENCE_TEST,"); //试验状态 strSql.Append(" F_TEST_STATUS,"); //创建时间 strSql.Append(" F_CREATE_TIME,"); //操作员 strSql.Append(" F_OPERATOR_ID,"); //操作时间 strSql.Append(" F_OPERATIONTIME,"); //是否删除 strSql.Append(" F_DEL"); strSql.Append(") values ("); strSql.Append(" :F_TEST_TASK_ID,"); strSql.Append(" :F_TEST_ITEM,"); strSql.Append(" :F_TEST_MODEL,"); strSql.Append(" :F_TEST_STANDARD,"); strSql.Append(" :F_TEST_PROPERTY,"); strSql.Append(" :F_TEST_AIM,"); strSql.Append(" :F_TASK_DEPUTE_UNIT,"); strSql.Append(" :F_CONTACT,"); strSql.Append(" :F_PHONE,"); strSql.Append(" :F_EMAIL,"); strSql.Append(" :F_TEST_CHARGE,"); strSql.Append(" :F_TASK_DEPUTE_DATE,"); strSql.Append(" :F_TEST_SERIES,"); strSql.Append(" :F_SAMPLE_TYPE,"); strSql.Append(" :F_SEQUENCE_TEST,"); strSql.Append(" :F_TEST_STATUS,"); strSql.Append(" :F_CREATE_TIME,"); strSql.Append(" :F_OPERATOR_ID,"); strSql.Append(" :F_OPERATIONTIME,"); strSql.Append(" :F_DEL"); strSql.Append(") "); OracleParameter[] parameters = { new OracleParameter(":F_TEST_TASK_ID", OracleType.VarChar, 20), new OracleParameter(":F_TEST_ITEM", OracleType.VarChar, 50), new OracleParameter(":F_TEST_MODEL", OracleType.VarChar, 50), new OracleParameter(":F_TEST_STANDARD", OracleType.VarChar, 50), new OracleParameter(":F_TEST_PROPERTY", OracleType.VarChar, 50), new OracleParameter(":F_TEST_AIM", OracleType.VarChar, 50), new OracleParameter(":F_TASK_DEPUTE_UNIT", OracleType.VarChar, 100), new OracleParameter(":F_CONTACT", OracleType.VarChar, 10), new OracleParameter(":F_PHONE", OracleType.VarChar, 20), new OracleParameter(":F_EMAIL", OracleType.VarChar, 50), new OracleParameter(":F_TEST_CHARGE", OracleType.VarChar, 20), new OracleParameter(":F_TASK_DEPUTE_DATE", OracleType.DateTime), new OracleParameter(":F_TEST_SERIES", OracleType.VarChar, 50), new OracleParameter(":F_SAMPLE_TYPE", OracleType.VarChar, 50), new OracleParameter(":F_SEQUENCE_TEST", OracleType.Number, 4), new OracleParameter(":F_TEST_STATUS", OracleType.Number, 4), new OracleParameter(":F_CREATE_TIME", OracleType.DateTime), new OracleParameter(":F_OPERATOR_ID", OracleType.VarChar, 10), new OracleParameter(":F_OPERATIONTIME", OracleType.DateTime), new OracleParameter(":F_DEL", OracleType.Number, 4) }; //试验任务编号 if (model.F_TEST_TASK_ID == null) { parameters[0].Value = DBNull.Value; } else { parameters[0].Value = model.F_TEST_TASK_ID; } //检测项目 if (model.F_TEST_ITEM == null) { parameters[1].Value = DBNull.Value; } else { parameters[1].Value = model.F_TEST_ITEM; } //规格型号 if (model.F_TEST_MODEL == null) { parameters[2].Value = DBNull.Value; } else { parameters[2].Value = model.F_TEST_MODEL; } //检测标准 if (model.F_TEST_STANDARD == null) { parameters[3].Value = DBNull.Value; } else { parameters[3].Value = model.F_TEST_STANDARD; } //检测性质 if (model.F_TEST_PROPERTY == null) { parameters[4].Value = DBNull.Value; } else { parameters[4].Value = model.F_TEST_PROPERTY; } //检测目的 if (model.F_TEST_AIM == null) { parameters[5].Value = DBNull.Value; } else { parameters[5].Value = model.F_TEST_AIM; } //委托单位 if (model.F_TASK_DEPUTE_UNIT == null) { parameters[6].Value = DBNull.Value; } else { parameters[6].Value = model.F_TASK_DEPUTE_UNIT; } //联系人 if (model.F_CONTACT == null) { parameters[7].Value = DBNull.Value; } else { parameters[7].Value = model.F_CONTACT; } //电话 if (model.F_PHONE == null) { parameters[8].Value = DBNull.Value; } else { parameters[8].Value = model.F_PHONE; } //email if (model.F_EMAIL == null) { parameters[9].Value = DBNull.Value; } else { parameters[9].Value = model.F_EMAIL; } //项目负责人 if (model.F_TEST_CHARGE == null) { parameters[10].Value = DBNull.Value; } else { parameters[10].Value = model.F_TEST_CHARGE; } //委托日期 if (model.F_TASK_DEPUTE_DATE == null) { parameters[11].Value = DBNull.Value; } else { parameters[11].Value = model.F_TASK_DEPUTE_DATE; } //样品系列 if (model.F_TEST_SERIES == null) { parameters[12].Value = DBNull.Value; } else { parameters[12].Value = model.F_TEST_SERIES; } //样品类别 if (model.F_SAMPLE_TYPE == null) { parameters[13].Value = DBNull.Value; } else { parameters[13].Value = model.F_SAMPLE_TYPE; } //序列试验 if (model.F_SEQUENCE_TEST == null) { parameters[14].Value = DBNull.Value; } else { parameters[14].Value = model.F_SEQUENCE_TEST; } //试验状态 if (model.F_TEST_STATUS == null) { parameters[15].Value = DBNull.Value; } else { parameters[15].Value = model.F_TEST_STATUS; } //创建时间 if (model.F_CREATE_TIME == null) { parameters[16].Value = DBNull.Value; } else { parameters[16].Value = model.F_CREATE_TIME; } //操作员 if (model.F_OPERATOR_ID == null) { parameters[17].Value = DBNull.Value; } else { parameters[17].Value = model.F_OPERATOR_ID; } //操作时间 if (model.F_OPERATIONTIME == null) { parameters[18].Value = DBNull.Value; } else { parameters[18].Value = model.F_OPERATIONTIME; } //是否删除 if (model.F_DEL == null) { parameters[19].Value = DBNull.Value; } else { parameters[19].Value = model.F_DEL; } ExecuteSql(strSql.ToString(), parameters); } catch (Exception ex) { Log.Error("DalTEST_INFO->Add---FAILED", ex); throw ex; } }