static UnitTestBase()
{
FileInfo file = new FileInfo(Assembly.GetExecutingAssembly().Location);
_currentAssemblyLocation = file.DirectoryName;
Trace.WriteLine(string.Format("_currentAssemblyCodebase={0}", _currentAssemblyLocation));
_coreDb = DBOperatorBase.GetDBOperatorObject(DBOperatorType.OleDBOperator,
string.Format(ConfigurationManager.ConnectionStrings[CONST_CONNECTION_KEY].ConnectionString, _currentAssemblyLocation + @"\..\..\..\BusWeb.UnitTest\Database\"));
}
/// <summary>
/// 现场分析数据保存：样品状态为可领用状态；分析状态为分析完成；数据状态为完成
/// </summary>
/// <param name="db"></param>
/// <param name="trans"></param>
/// <param name="entity"></param>
/// <returns></returns>
public int AddDrawSampleTrans(DBOperatorBase db, IDbTransaction trans, Entity.Draw entity)
{
int iReturn = 0;
//DBOperatorBase db = new DataBase();
IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory();
//SqlTransactionHelper thelper = new SqlTransactionHelper(Config.constr);
//IDbTransaction trans = thelper.StartTransaction();
try
{
IDbDataParameter[] prams =
{
dbFactory.MakeInParam("@ID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.ID.GetType().ToString()), entity.ID, 4),
dbFactory.MakeInParam("@SampleID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.SampleID.GetType().ToString()), entity.SampleID, 50),
dbFactory.MakeInParam("@fxtime", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.CreateDate.GetType().ToString()), entity.CreateDate, 50),
dbFactory.MakeInParam("@LyDate", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.LyDate.GetType().ToString()), entity.LyDate, 50),
dbFactory.MakeInParam("@type", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.type.GetType().ToString()), entity.type, 4),
dbFactory.MakeInParam("@UserID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.UserID.GetType().ToString()), entity.UserID, 50),
dbFactory.MakeInParam("@ItemList", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.ItemList.GetType().ToString()), entity.ItemList, 50),
dbFactory.MakeInParam("@ItemValueList", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.ItemValueList.GetType().ToString()), entity.ItemValueList, 50),
dbFactory.MakeInParam("@fxman", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.UserID.GetType().ToString()), entity.UserID, 50),
dbFactory.MakeInParam("@finishdate", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.finishdate.GetType().ToString()), entity.finishdate, 4),
dbFactory.MakeOutReturnParam()
};
if (entity.type == 1)//现场分析
{
iReturn = db.ExecuteNonQueryTrans(trans, CommandType.StoredProcedure, "[proc_Draw_Add_xc]", prams);
}
else
{
iReturn = db.ExecuteNonQueryTrans(trans, CommandType.StoredProcedure, "[proc_Draw_Add_fxc]", prams);
}
if (iReturn <= 0)
{
throw new Exception("样品领用保存失败！");
}
int recordid = int.Parse(prams[10].Value.ToString());
if (recordid > 0)
{
entity.ID = recordid;
}
iReturn = db.ExecuteNonQueryTrans(trans, CommandType.Text, "delete from t_DrawSampleDetail where DrawID='" + entity.ID + "'", prams);
prams = null;
IDbDataParameter[] itemprams =
{
};
foreach (Entity.SampleItem item in entity.SampleItemList)
{
iReturn = db.ExecuteNonQueryTrans(trans, CommandType.Text, String.Format("Insert into t_DrawSampleDetail (DrawID,ItemID,method,value,fxDate,fxuser)values('" + entity.ID + "','" + item.MonitorID + "','" + item.Method + "','" + item.Value + "','" + item.CreateDate + "','" + entity.UserID + "')"), itemprams);
if (iReturn <= 0)
{
throw new Exception("领用样品分析项目更新失败！");
}
else
{
IDbDataParameter[] itemprams2 =
{
dbFactory.MakeInParam("@SampleID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.SampleID.GetType().ToString()), entity.SampleID, 50),
dbFactory.MakeInParam("@MonitorID", DBTypeConverter.ConvertCsTypeToOriginDBType(item.MonitorID.GetType().ToString()), item.MonitorID, 4),
dbFactory.MakeInParam("@CreateDate", DBTypeConverter.ConvertCsTypeToOriginDBType(item.CreateDate.GetType().ToString()), item.CreateDate, 50),
dbFactory.MakeInParam("@UserID", DBTypeConverter.ConvertCsTypeToOriginDBType(item.UserID.GetType().ToString()), item.UserID, 50),
dbFactory.MakeInParam("@ckflag", DBTypeConverter.ConvertCsTypeToOriginDBType(item.ckflag.GetType().ToString()), item.ckflag, 4),
dbFactory.MakeInParam("@AnalysisUserID", DBTypeConverter.ConvertCsTypeToOriginDBType(item.AnalysisUserID.GetType().ToString()), item.AnalysisUserID, 50),
dbFactory.MakeInParam("@AnalysisDate", DBTypeConverter.ConvertCsTypeToOriginDBType(item.AnalysisDate.GetType().ToString()), item.AnalysisDate, 8),
dbFactory.MakeInParam("@Value", DBTypeConverter.ConvertCsTypeToOriginDBType(item.Value.GetType().ToString()), item.Value, 50),
dbFactory.MakeInParam("@method", DBTypeConverter.ConvertCsTypeToOriginDBType(item.Method.GetType().ToString()), item.Method, 50),
dbFactory.MakeInParam("@statusID", DBTypeConverter.ConvertCsTypeToOriginDBType(item.statusID.GetType().ToString()), item.statusID, 4),
dbFactory.MakeInParam("@fxDanID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.ID.GetType().ToString()), entity.ID, 4)
};
iReturn = db.ExecuteNonQueryTrans(trans, CommandType.StoredProcedure, "proc_Monitor_Add_xc", itemprams2);
itemprams = null;
if (iReturn < 0)
{
throw new Exception("分析项目保存失败！");
}
}
}
itemprams = null;
iReturn = 1;
}
catch (Exception ex)
{
iReturn = 0;
}
finally
{
}
return(iReturn);
}
