/// <summary> /// 获得数据列表 /// </summary> public List <RELAYTEST.Model.ModelLIMS_DOWNLOAD_SAM> DataTableToList(DataTable dt) { List <RELAYTEST.Model.ModelLIMS_DOWNLOAD_SAM> modelList = new List <RELAYTEST.Model.ModelLIMS_DOWNLOAD_SAM>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { RELAYTEST.Model.ModelLIMS_DOWNLOAD_SAM model; for (int n = 0; n < rowsCount; n++) { model = new RELAYTEST.Model.ModelLIMS_DOWNLOAD_SAM(); if (dt.Rows[n]["样品号"].ToString() != "") { model.样品号 = int.Parse(dt.Rows[n]["样品号"].ToString()); } model.组别 = dt.Rows[n]["组别"].ToString(); model.任务号 = dt.Rows[n]["任务号"].ToString(); if (dt.Rows[n]["检测号"].ToString() != "") { model.检测号 = int.Parse(dt.Rows[n]["检测号"].ToString()); } if (dt.Rows[n]["排程号"].ToString() != "") { model.排程号 = int.Parse(dt.Rows[n]["排程号"].ToString()); } model.分析名称 = dt.Rows[n]["分析名称"].ToString(); if (dt.Rows[n]["排程开始时间"].ToString() != "") { model.排程开始时间 = DateTime.Parse(dt.Rows[n]["排程开始时间"].ToString()); } modelList.Add(model); } } return(modelList); }
/// <summary> /// 增加一条数据 /// </summary> public void Add(RELAYTEST.Model.ModelLIMS_DOWNLOAD_SAM model) { StringBuilder strSql = new StringBuilder(); StringBuilder strSql1 = new StringBuilder(); StringBuilder strSql2 = new StringBuilder(); if (model.样品号 != null) { strSql1.Append("样品号,"); strSql2.Append("" + model.样品号 + ","); } if (model.组别 != null) { strSql1.Append("组别,"); strSql2.Append("'" + model.组别 + "',"); } if (model.任务号 != null) { strSql1.Append("任务号,"); strSql2.Append("'" + model.任务号 + "',"); } if (model.检测号 != null) { strSql1.Append("检测号,"); strSql2.Append("" + model.检测号 + ","); } if (model.排程号 != null) { strSql1.Append("排程号,"); strSql2.Append("" + model.排程号 + ","); } if (model.分析名称 != null) { strSql1.Append("分析名称,"); strSql2.Append("'" + model.分析名称 + "',"); } if (model.排程开始时间 != null) { strSql1.Append("排程开始时间,"); strSql2.Append("to_date('" + model.排程开始时间.ToString() + "','YYYY-MM-DD HH24:MI:SS'),"); } strSql.Append("insert into LIMS_DOWNLOAD_SAM("); strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1)); strSql.Append(")"); strSql.Append(" values ("); strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1)); strSql.Append(")"); ExecuteSql(strSql.ToString()); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(RELAYTEST.Model.ModelLIMS_DOWNLOAD_SAM model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update LIMS_DOWNLOAD_SAM set "); if (model.样品号 != null) { strSql.Append("样品号=" + model.样品号 + ","); } if (model.组别 != null) { strSql.Append("组别='" + model.组别 + "',"); } if (model.任务号 != null) { strSql.Append("任务号='" + model.任务号 + "',"); } if (model.检测号 != null) { strSql.Append("检测号=" + model.检测号 + ","); } if (model.排程号 != null) { strSql.Append("排程号=" + model.排程号 + ","); } if (model.分析名称 != null) { strSql.Append("分析名称='" + model.分析名称 + "',"); } if (model.排程开始时间 != null) { strSql.Append("排程开始时间=to_date('" + model.排程开始时间.ToString() + "','YYYY-MM-DD HH24:MI:SS'),"); } int n = strSql.ToString().LastIndexOf(","); strSql.Remove(n, 1); strSql.Append(" where "); int rowsAffected = ExecuteSql(strSql.ToString()); if (rowsAffected > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public RELAYTEST.Model.ModelLIMS_DOWNLOAD_SAM GetModel() { StringBuilder strSql = new StringBuilder(); strSql.Append("select "); strSql.Append(" 样品号,组别,任务号,检测号,排程号,分析名称,排程开始时间 "); strSql.Append(" from LIMS_DOWNLOAD_SAM "); strSql.Append(" where "); RELAYTEST.Model.ModelLIMS_DOWNLOAD_SAM model = new RELAYTEST.Model.ModelLIMS_DOWNLOAD_SAM(); DataSet ds = Query(strSql.ToString()); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["样品号"].ToString() != "") { model.样品号 = int.Parse(ds.Tables[0].Rows[0]["样品号"].ToString()); } model.组别 = ds.Tables[0].Rows[0]["组别"].ToString(); model.任务号 = ds.Tables[0].Rows[0]["任务号"].ToString(); if (ds.Tables[0].Rows[0]["检测号"].ToString() != "") { model.检测号 = int.Parse(ds.Tables[0].Rows[0]["检测号"].ToString()); } if (ds.Tables[0].Rows[0]["排程号"].ToString() != "") { model.排程号 = int.Parse(ds.Tables[0].Rows[0]["排程号"].ToString()); } model.分析名称 = ds.Tables[0].Rows[0]["分析名称"].ToString(); if (ds.Tables[0].Rows[0]["排程开始时间"].ToString() != "") { model.排程开始时间 = DateTime.Parse(ds.Tables[0].Rows[0]["排程开始时间"].ToString()); } return(model); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(RELAYTEST.Model.ModelLIMS_DOWNLOAD_SAM model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public void Add(RELAYTEST.Model.ModelLIMS_DOWNLOAD_SAM model) { dal.Add(model); }