private bool IsExsitAckAntCVResult(string type, AckAntCVResult data)
{
bool hasData = false;
using (var con = new SqlConnection(this.GetDbCon(type.ToUpper())))
{
var queryparams = new SqlParameter[] { new SqlParameter("@StudyNo", data.StudyNo) };
var datalist = SqlHelper.ExecuteReader(con, CommandType.Text, "select 1 from TB_AckAntCVResult where StudyNo=@StudyNo", queryparams);
if (datalist.Read())
{
hasData = true;
}
datalist.Close();
}
return(hasData);
}
public AckAntCVResult loadAckAntCVResultXml(string xml)
{
var data = new AckAntCVResult();
var doc = new XmlDocument();
doc.LoadXml(xml);
var root = doc.SelectSingleNode("//AckAntCVResult");
if (root != null)
{
data.AntCVResultID = (root.SelectSingleNode("AntCVResultID")).InnerText;
data.ReportType = (root.SelectSingleNode("ReportType")).InnerText;
data.ExecDocCode = (root.SelectSingleNode("ExecDocCode")).InnerText;
data.ExecDocName = (root.SelectSingleNode("ExecDocName")).InnerText;
data.ExecDate = (root.SelectSingleNode("ExecDate")).InnerText;
data.ExecTime = root.SelectSingleNode("ExecTime").InnerText;
string checknum = data.AntCVResultID.Split("_".ToCharArray())[1];
data.StudyNo = checknum;
}
return(data);
}
public void SaveOrUpdateAckAntCVResult(string type, AckAntCVResult data)
{
using (var con = new SqlConnection(this.GetDbCon(type.ToUpper())))
{
if (this.IsExsitAckAntCVResult(type, data))
{
var sqlparams = new SqlParameter[] { new SqlParameter("AntCVResultID", data.AntCVResultID),
new SqlParameter("@ReportType", data.ReportType),
new SqlParameter("@ExecDocCode", data.ExecDocCode),
new SqlParameter("@ExecDocName", data.ExecDocName),
new SqlParameter("@ExecDate", data.ExecDate),
new SqlParameter("@ExecTime", data.ExecTime),
new SqlParameter("@StudyNo", data.StudyNo),
new SqlParameter("@LastUpateTime", DateTime.Now),
new SqlParameter("@Status", 2) };
SqlHelper.ExecuteNonQuery(con, CommandType.Text, @"Update TB_AckAntCVResult
set ReportType=@ReportType,ExecDocCode=@ExecDocCode,ExecDocName=@ExecDocName,
ExecDate=@ExecDate,ExecTime=@ExecTime,StudyNo=@StudyNo,LastUpateTime=@LastUpateTime,Status=@Status
where AntCVResultID=@AntCVResultID", sqlparams);
}
else
{
var sqlparams = new SqlParameter[] { new SqlParameter("AntCVResultID", data.AntCVResultID),
new SqlParameter("@ReportType", data.ReportType),
new SqlParameter("@ExecDocCode", data.ExecDocCode),
new SqlParameter("@ExecDocName", data.ExecDocName),
new SqlParameter("@ExecDate", data.ExecDate),
new SqlParameter("@ExecTime", data.ExecTime),
new SqlParameter("@StudyNo", data.StudyNo),
new SqlParameter("@Status", 2),
new SqlParameter("@LastUpateTime", DateTime.Now) };
SqlHelper.ExecuteNonQuery(con, CommandType.Text, @"Insert into TB_AckAntCVResult (AntCVResultID,ReportType,ExecDocCode,ExecDocName,ExecDate,ExecTime,StudyNo,LastUpateTime,Status)
VALUES (@AntCVResultID,@ReportType,@ExecDocCode,@ExecDocName,@ExecDate,@ExecTime,@StudyNo,@LastUpateTime,@Status)", sqlparams);
}
con.Close();
}
}
