/// <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);
}