public bool SaveToDB()
{
try
{
List <SqlWrapper> lstSqlWrapper = new List <SqlWrapper>();
SqlWrapper sqlWrapper = new SqlWrapper();
string strSQL = String.Format("Insert into T_PrintImage" +
@"([FilmUID],[ImageUID],[DcmFilePath]) Values" +
@"(@filmUID,@imageUID,@dcmfilePath)");
List <SqlParameter> lstParas = new List <SqlParameter>();
SqlParameter param = new SqlParameter();
param.ParameterName = "@filmUID";
param.Value = this.FilmUID;
param.SqlDbType = SqlDbType.NVarChar;
lstParas.Add(param);
param = new SqlParameter();
param.ParameterName = "@imageUID";
param.Value = this.ImageBoxPosition;
param.SqlDbType = SqlDbType.NVarChar;
lstParas.Add(param);
param = new SqlParameter();
param.ParameterName = "@dcmfilePath";
param.Value = this.DicomFilePath;
param.SqlDbType = SqlDbType.NVarChar;
lstParas.Add(param);
sqlWrapper.SqlString = strSQL;
sqlWrapper.Parameter = lstParas.ToArray();
lstSqlWrapper.Add(sqlWrapper);
int iRet = SQLServerHelper.ExecuteNonQuery(lstSqlWrapper, QCConnectionType.PrintSystem);
if (iRet > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
return(false);
}
}
/// <summary>
/// 数据上传
/// </summary>
/// <param name="obj"></param>
public void Upload_Timer()
{
if (!canUse_Upload)
{
return;
}
else
{
lock (olock_Upload)
{
if (canUse_Upload)
{
canUse_Upload = false;
}
else
{
return;
}
}
}
try
{
string localSql = "select * from T_Result where uploadsign=0";
DataTable dt = PostgresHelper.ExecuteDataTable(this.ConnectionString, CommandType.Text, localSql);
foreach (DataRow item in dt.Rows)
{
//上传数据
string sql = string.Format("INSERT INTO T_Upload_TcuData(cartype, conditioncode, crc1, crc2, softwareversion, softwarecode, testtime) VALUES ('{0}','{1}','{2}','{3}','{4}','{5}','{6}');", item["CarType"].ToString(), item["ConditionCode"].ToString(), item["CRC1"].ToString(), item["CRC2"].ToString(), item["SoftWareVersion"].ToString(), item["SoftWareCode"].ToString(), item["testtime"].ToString());
int result = SQLServerHelper.ExecuteNonQuery(this.MESCnnStr, CommandType.Text, sql);
//把上传标识uploadsign改为1
if (result > 0)
{
string updateSql = string.Format("update T_Result set UploadSign = 1 where id ={0}", Convert.ToInt32(item["id"]));
PostgresHelper.ExecuteNonQuery(this.connectionString, CommandType.Text, updateSql);
}
}
}
catch (Exception ex)
{
logger.Error(ex.Message + "***" + ex.StackTrace);
}
}
public bool SaveToDB()
{
try
{
List <SqlWrapper> lstSqlWrapper = new List <SqlWrapper>();
SqlWrapper sqlWrapper = new SqlWrapper();
string strSQL = String.Format("Insert into T_PrintTask" +
@"([FilmUID],[PrintUID],[CallingIP],[CallingAE],[CalledAE],[BorderDensity],[DisplayFormat],[EmptyImageDensity]
,[Copies]
,[FilmSize]
,[FilmOrientation]
,[MagnificationType]
,[MaxDensity]
,[MinDensity]
,[SmoothingType]
,[Trim]
,[MediumType]
,[PresentationLUT]
,[JpgFilmPath]) Values" +
@"(@autoID,@printUID,@callingIP,@callingAE,@calledAE,@borderDensity,@displayFormat,@emptyImageDensity,@copies,
@filmSize,@filmOrientation,@magnificationType,@maxDensity,@minDensity,@smoothingType,@trim,@mediumType,@presentationLUT,@filePath)");
List <SqlParameter> lstParas = new List <SqlParameter>();
SqlParameter param = new SqlParameter();
param.ParameterName = "@autoID";
param.Value = this.FilmUID;
param.SqlDbType = SqlDbType.NVarChar;
lstParas.Add(param);
param = new SqlParameter();
param.ParameterName = "@printUID";
param.Value = this.printUID;
param.SqlDbType = SqlDbType.NVarChar;
lstParas.Add(param);
//param = new SqlParameter();
//param.ParameterName = "@imageUID";
//param.Value = this.ImageBoxPosition;
//param.SqlDbType = SqlDbType.TinyInt;
//param.Size = 8;
//lstParas.Add(param);
param = new SqlParameter();
param.ParameterName = "@callingIP";
param.Value = this.CallingIPAddress.ToString();
param.SqlDbType = SqlDbType.NVarChar;
param.Size = 16;
lstParas.Add(param);
param = new SqlParameter();
param.ParameterName = "@callingAE";
param.Value = this.CallingAE;
param.SqlDbType = SqlDbType.NVarChar;
lstParas.Add(param);
param = new SqlParameter();
param.ParameterName = "@calledAE";
param.Value = this.CalledAE;
param.SqlDbType = SqlDbType.NVarChar;
lstParas.Add(param);
param = new SqlParameter();
param.ParameterName = "@borderDensity";
param.Value = this.BorderDensity;
param.SqlDbType = SqlDbType.NVarChar;
lstParas.Add(param);
param = new SqlParameter();
param.ParameterName = "@displayFormat";
param.Value = this.ImageDisplayFormat;
param.SqlDbType = SqlDbType.NVarChar;
lstParas.Add(param);
param = new SqlParameter();
param.ParameterName = "@emptyImageDensity";
param.Value = this.EmptyImageDensity;
param.SqlDbType = SqlDbType.NVarChar;
lstParas.Add(param);
param = new SqlParameter();
param.ParameterName = "@copies";
param.Value = this.NumberOfCopies;
param.SqlDbType = SqlDbType.TinyInt;
param.Size = 8;
lstParas.Add(param);
param = new SqlParameter();
param.ParameterName = "@filmSize";
param.Value = this.FilmSizeID;
param.SqlDbType = SqlDbType.NVarChar;
lstParas.Add(param);
param = new SqlParameter();
param.ParameterName = "@filmOrientation";
param.Value = this.FilmOrienation;
param.SqlDbType = SqlDbType.NVarChar;
lstParas.Add(param);
param = new SqlParameter();
param.ParameterName = "@magnificationType";
param.Value = this.MagnificationType;
param.SqlDbType = SqlDbType.NVarChar;
lstParas.Add(param);
param = new SqlParameter();
param.ParameterName = "@maxDensity";
param.Value = this.MaxDensity;
param.SqlDbType = SqlDbType.Int;
param.Size = 16;
lstParas.Add(param);
param = new SqlParameter();
param.ParameterName = "@minDensity";
param.Value = this.MinDensity;
param.SqlDbType = SqlDbType.Int;
param.Size = 16;
lstParas.Add(param);
param = new SqlParameter();
param.ParameterName = "@smoothingType";
param.Value = this.SmoothingType;
param.SqlDbType = SqlDbType.NVarChar;
lstParas.Add(param);
param = new SqlParameter();
param.ParameterName = "@trim";
param.Value = this.Trim;
param.SqlDbType = SqlDbType.NVarChar;
lstParas.Add(param);
param = new SqlParameter();
param.ParameterName = "@mediumType";
param.Value = this.MediumType;
param.SqlDbType = SqlDbType.NVarChar;
lstParas.Add(param);
param = new SqlParameter();
param.ParameterName = "@presentationLUT";
param.Value = this.PresentationLut;
param.SqlDbType = SqlDbType.NVarChar;
lstParas.Add(param);
param = new SqlParameter();
param.ParameterName = "@filePath";
param.Value = this.JpgFilmPath;
param.SqlDbType = SqlDbType.NVarChar;
lstParas.Add(param);
sqlWrapper.SqlString = strSQL;
sqlWrapper.Parameter = lstParas.ToArray();
lstSqlWrapper.Add(sqlWrapper);
int iRet = SQLServerHelper.ExecuteNonQuery(lstSqlWrapper, QCConnectionType.PrintSystem);
if (iRet > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
return(false);
}
}