public DataTable GetAllPerson2()
{
int recCount = 0;
DataTable dt = MyBatis.QueryForDataTable("SelectAllPerson2", new Person {
FirstName = "kilo"
}, 10, 1, out recCount);
return(dt);
}
/// <summary>
/// 运行脚本导入的SQL数据
/// </summary>
void RunScriptImportSQLData()
{
mybatis = new MyBatis();
StreamReader sr = new StreamReader(this.SQLFile);
String line;
int i = 0;
sr = new StreamReader(this.SQLFile);
while ((line = sr.ReadLine()) != null)
{
i++;
line = EncryptionText.DecryptDES(line, KeyManager.DataKey);
//new DBService().ExecSQL(line.Trim());
mybatis.SaveReagentProjectParamInfo(line.Trim());
}
splashScreenManager1.CloseWaitForm();
}
static void Main(string[] args)
{
MyBatis myBatis = new MyBatis();
//Hashtable hashTable = new Hashtable();
//hashTable.Add("proName", "1");
//hashTable.Add("proType", "2");
//myBatis.ism_SqlMap.QueryForObject("AssayProjectInfo.DeleteAssayProject", null);
// <statement id="QueryQCResultForQCGraphics" parameterClass="QCResultForUIInfo" resultClass="QCResultForUIInfo">
// select t2.HorizonLevel,t1.StartTime,t1.ConcResult,t3.TargetMean,t3.TargetSD
// from QualityControlResultTb t1
// left join QualityControlTb t2 on t1.QCID = t2.QCID
// left join QCRelationProjectTb t3 on t1.QCID = t3.QCID and t1.ProjectName = t3.ProjectName and t1.SampleType = t3.SampleType
// where t2.QCName=#QCName# and t3.ProjectName=#ProjectName# and t2.LotNum=#LotNum# and t1.IsLogicalDelete=0 and t1.IsLogicalEdit=0 and t1.StartTime between #QCTimeStartTS# and #QCTimeEndTS#
// union
// select t2.HorizonLevel,t1.StartTime,t1.ConcResult,t3.TargetMean,t3TargetSD
// from QualityControlResultForUserTb t1
// left join QualityControlTb t2 on t1.QCID = t2.QCID
// left join QCRelationProjectTb t3 on t1.QCID = t3.QCID and t1.ProjectName = t3.ProjectName and t1.SampleType = t3.SampleType
// where t2.QCName=#QCName# and t3.ProjectName=#ProjectName# and t2.LotNum=#LotNum# and t1.IsLogicalDelete=0 and t1.IsLogicalEdit=0 and t1.StartTime between #QCTimeStartTS# and #QCTimeEndTS#
//</statement>
}
public DataTable GetAllPerson3()
{
return(MyBatis.QueryForDataTable("SelectAllPerson2", new Person {
FirstName = "kilo"
}));
}
static void Main(string[] args)
{
MyBatis myBatis = new MyBatis();
}
