/// <summary>
/// 添加病理结果
/// </summary>
/// <param name="SQLlist"></param>
private void InsertPathologyResult(SortedList SQLlist, DataTable dt, DataRow dr)
{
SQLlist.Add(new Hashtable()
{
{ "DELETE", "DeleteDAPathologyresultByRequestCode" }
}, dr["RequestCode"]);
if (dt == null)
{
return;
}
for (int i = 0; i < dt.Rows.Count; i++)
{
DataRow drpathology = dt.Rows[i];
DAPathologyresult _pathologyresult = new DAPathologyresult();
_pathologyresult.Requestcode = dr["RequestCode"].ToString();
if (dr["HospSampleID"] != DBNull.Value && dr["HospSampleID"].ToString() != string.Empty)
{
_pathologyresult.Hospsampleid = dr["HospSampleID"].ToString();
}
else if (dr["HospSampleNumber"] != DBNull.Value && dr["HospSampleNumber"].ToString() != string.Empty)
{
_pathologyresult.Hospsamplenumber = dr["HospSampleNumber"].ToString();
}
if (dt.Columns.Contains("TestID") && drpathology["TestID"] != DBNull.Value)
{
_pathologyresult.Testid = Convert.ToDecimal(drpathology["TestID"]);
}
if (dt.Columns.Contains("parentid") && drpathology["parentid"] != DBNull.Value)
{
_pathologyresult.Parentid = Convert.ToDecimal(drpathology["parentid"]);
}
if (dt.Columns.Contains("treelevel") && drpathology["treelevel"] != DBNull.Value)
{
_pathologyresult.Treelevel = Convert.ToDecimal(drpathology["treelevel"]);
}
if (dt.Columns.Contains("itemname") && drpathology["itemname"] != DBNull.Value)
{
_pathologyresult.Itemname = drpathology["itemname"].ToString();
}
if (dt.Columns.Contains("result") && drpathology["result"] != DBNull.Value)
{
_pathologyresult.Result = drpathology["result"].ToString();
}
if (dt.Columns.Contains("displayorder") && drpathology["displayorder"] != DBNull.Value)
{
_pathologyresult.Displayorder = Convert.ToDecimal(drpathology["displayorder"]);
}
SQLlist.Add(new Hashtable()
{
{ "INSERT", "InsertDAPathologyresult" }
}, _pathologyresult);
}
#region >>>> qianz 修改病理标本DA
DAResult _result = new DAResult();
if (dr["RequestCode"] != DBNull.Value)
{
_result.Requestcode = dr["RequestCode"].ToString();//更新条件
_result.Testresult = dt.Rows[0]["result"].ToString();
if (dt.Columns.Contains("ReleaseDate") && dt.Rows[0]["ReleaseDate"] != DBNull.Value)
{
_result.Releasedate = Convert.ToDateTime(dt.Rows[0]["ReleaseDate"]);
}
if (dt.Columns.Contains("ReleaseByName") && dt.Rows[0]["ReleaseByName"] != DBNull.Value)
{
_result.Releasebyname = dt.Rows[0]["ReleaseByName"].ToString();
}
if (dt.Columns.Contains("authorizedate") && dt.Rows[0]["authorizedate"] != DBNull.Value)
{
_result.Authorizedate = Convert.ToDateTime(dt.Rows[0]["authorizedate"]);
}
if (dt.Columns.Contains("AuthorizeByName") && dt.Rows[0]["AuthorizeByName"] != DBNull.Value)
{
_result.Authorizebyname = dt.Rows[0]["AuthorizeByName"].ToString();
}
if (dt.Columns.Contains("resultflag") && dt.Rows[0]["resultflag"] != DBNull.Value)
{
_result.Resultflag = dt.Rows[0]["resultflag"].ToString();
}
}
SQLlist.Add(new Hashtable()
{
{ "UPDATE", "UpdateDAResultByRequestcodeBl" }
}, _result);
#endregion
}
/// <summary>
/// 修改病理结果记录
/// </summary>
/// <param name="user"></param>
/// <returns></returns>
public int UpdateDAPathologyresultInfo(DAPathologyresult config)
{
return(service.update("UpdateDAPathologyresult", config));
}
/// <summary>
/// 删除病理结果记录
/// </summary>
/// <param name="user"></param>
/// <returns></returns>
public object DeleteDAPathologyresult(DAPathologyresult config)
{
return(service.insert("DeleteDAPathologyresult", config));
}
/// <summary>
/// 添加病理结果记录
/// </summary>
/// <param name="user"></param>
/// <returns></returns>
public object InsertDAPathologyresultInfo(DAPathologyresult config)
{
return(service.insert("InsertDAPathologyresult", config));
}
