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