private void button2_Click(object sender, EventArgs e)
{
int count = int.Parse(textBox1.Text);
using (MB.Orm.Persistence.DatabaseConfigurationScope scope = new MB.Orm.Persistence.DatabaseConfigurationScope("SQL SERVER")) {
using (MB.Util.MethodTraceWithTime t = new MB.Util.MethodTraceWithTime("BLUCK", count)) {
IList lstData = null;
if (chkDataTable.Checked)
{
DataTable dt = getDataTable(count, 1);
lstData = dt.Select();
}
else
{
lstData = getListData(count, 1);
}
using (MB.RuleBase.BulkCopy.IDbBulkExecute bulk = MB.RuleBase.BulkCopy.DbBulkExecuteFactory.CreateDbBulkExecute()) {
bulk.WriteToServer("MbfsFucDtl", "AddObject", lstData);
}
MessageBox.Show(string.Format("总共执行的时间有{0} 毫秒", t.GetExecutedTimes()));
}
}
}
private void button8_Click(object sender, EventArgs e)
{
string name = "@Name";
string name2 = "@Name";
using (MB.Util.MethodTraceWithTime trace = new MB.Util.MethodTraceWithTime("")) {
Microsoft.Practices.EnterpriseLibrary.Data.Database db = MB.Orm.Persistence.DatabaseHelper.CreateDatabase();
if (db is Microsoft.Practices.EnterpriseLibrary.Data.Oracle.OracleDatabase)
{
name = ":" + name.Substring(1, name.Length - 1);
}
double d1 = trace.GetExecutedTimes();
}
using (MB.Util.MethodTraceWithTime trace = new MB.Util.MethodTraceWithTime("")) {
using (MB.Orm.Persistence.DatabaseConfigurationScope scop = new MB.Orm.Persistence.DatabaseConfigurationScope("SQL SERVER")) {
Microsoft.Practices.EnterpriseLibrary.Data.Database db2 = MB.Orm.Persistence.DatabaseHelper.CreateDatabase();
if (db2 is Microsoft.Practices.EnterpriseLibrary.Data.Oracle.OracleDatabase)
{
name = ":" + name.Substring(1, name.Length - 1);
}
else if (db2 is Microsoft.Practices.EnterpriseLibrary.Data.Sql.SqlDatabase)
{
name = "@" + name.Substring(1, name.Length - 1);
}
else
{
}
}
double d2 = trace.GetExecutedTimes();
}
}
private void button6_Click(object sender, EventArgs e)
{
int count = int.Parse(textBox1.Text);
List <MY_TABLE_MAINInfo> myEntitys = new List <MY_TABLE_MAINInfo>();
int beginID = 1;
for (int i = 0; i < 1000; i++)
{
myEntitys.Add(new MY_TABLE_MAINInfo()
{
ID = beginID++, NAME = "CCCC", CODE = "BB", ADDRESS = "PPP"
});
}
using (MB.Orm.Persistence.DatabaseConfigurationScope scope = new MB.Orm.Persistence.DatabaseConfigurationScope("MB.MBFS")) {
Database db = MB.Orm.Persistence.DatabaseHelper.CreateDatabase();
using (MB.Util.MethodTraceWithTime t = new MB.Util.MethodTraceWithTime("BLUCK", count)) {
//using (SqlConnection cn = new SqlConnection(db.ConnectionString)) {
// cn.Open();
// using (SqlTransaction tran = cn.BeginTransaction()) {
// try {
using (TransactionScope scopeTran = new TransactionScope()) {
using (MB.RuleBase.BulkCopy.IDbBulkExecute bulk = MB.RuleBase.BulkCopy.DbBulkExecuteFactory.CreateDbBulkExecute()) {
bulk.WriteToServer("MY_TABLE_MAIN", "UpdateObject", myEntitys);
}
// string data = MB.RuleBase.Common.DatabaseExcuteByXmlHelper.NewInstance.ExecuteScalar<string>("MY_TABLE_MAIN", "SelectObject", 10);
scopeTran.Complete();
// throw new Exception("ERROR");
}
// tran.Commit();
// // throw new Exception();
// }
// catch {
// tran.Rollback();
// }
//}
MessageBox.Show(string.Format("总共执行的时间有{0} 毫秒", t.GetExecutedTimes()));
}
}
}
private void button4_Click(object sender, EventArgs e)
{
int count = int.Parse(textBox1.Text);
using (MB.Orm.Persistence.DatabaseConfigurationScope scope = new MB.Orm.Persistence.DatabaseConfigurationScope("SQL SERVER")) {
Database db = MB.Orm.Persistence.DatabaseHelper.CreateDatabase();
using (MB.Util.MethodTraceWithTime t = new MB.Util.MethodTraceWithTime("BLUCK", count)) {
using (SqlConnection cn = new SqlConnection(db.ConnectionString)) {
cn.Open();
using (SqlTransaction tran = cn.BeginTransaction()) {
try {
IList lstData = null;
if (chkDataTable.Checked)
{
DataTable dt = getDataTable(count, 1);
lstData = dt.Select();
}
else
{
lstData = getListData(count, 1);
}
using (MB.RuleBase.BulkCopy.IDbBulkExecute bulk = MB.RuleBase.BulkCopy.DbBulkExecuteFactory.CreateDbBulkExecute(tran)) {
bulk.WriteToServer("MbfsFucDtl", "AddObject", lstData);
}
tran.Commit();
// throw new Exception();
}
catch {
tran.Rollback();
}
}
}
MessageBox.Show(string.Format("总共执行的时间有{0} 毫秒", t.GetExecutedTimes()));
}
}
}
private void button1_Click(object sender, EventArgs e)
{
int count = int.Parse(textBox1.Text);
using (MB.Util.MethodTraceWithTime t = new MB.Util.MethodTraceWithTime("BLUCK", count)) {
int idC = MB.Orm.Persistence.EntityIdentityHelper.NewInstance.GetEntityIdentity("MBFS_FUC_DTL", count);
IList lstData = null;
if (chkDataTable.Checked)
{
DataTable dt = getDataTable(count, idC);
lstData = dt.Select();
}
else
{
lstData = getListData(count, idC);
}
using (MB.RuleBase.BulkCopy.IDbBulkExecute bulk = MB.RuleBase.BulkCopy.DbBulkExecuteFactory.CreateDbBulkExecute()) {
bulk.WriteToServer("MbfsFucDtl", "AddObject", lstData);
}
MessageBox.Show(string.Format("总共执行的时间有{0} 毫秒", t.GetExecutedTimes()));
}
}
/// <summary>
/// 根据查询条件获取数据。
/// </summary>
/// <param name="dataInDocType"></param>
/// <param name="filterParameters"></param>
/// <returns></returns>
public System.Collections.IList GetFilterObjects(int dataInDocType, List <MB.Util.Model.QueryParameterInfo> filterParameters)
{
if (_InvokeFilterParentFormHoster != null)
{
InvokeDataAssistantHosterEventArgs arg = new InvokeDataAssistantHosterEventArgs(_ClientRule, _ClumnEditCfgInfo, _CurrentEditObject, filterParameters);
_InvokeFilterParentFormHoster.BeforeGetFilterData(_InvokeParentControl, arg);
if (arg.Cancel)
{
return(null);
}
}
try
{
if (_QueryObject != null)
{
return(_QueryObject.GetFilterObjects(filterParameters.ToArray()));
}
if (_InvokeDataSourceDesc == null)
{
IList lstDatas = null;
try
{
using (MB.Util.MethodTraceWithTime timeTrack = new MB.Util.MethodTraceWithTime(null))
{
lstDatas = _ClientRule.GetObjects((int)_ClientRule.MainDataTypeInDoc, filterParameters.ToArray());
var msg = string.Format("查询花费:{0} 毫秒,返回 {1} 记录", timeTrack.GetExecutedTimes(), lstDatas.Count);
MB.WinBase.AppMessenger.DefaultMessenger.Publish(QUERY_REFRESH_MSG_ID, msg);
};
}
catch (Exception ex)
{
throw MB.Util.APPExceptionHandlerHelper.PromoteException(ex, " GetObjects 出错！");
}
return(lstDatas);
}
string[] desc = _InvokeDataSourceDesc.Method.Split(',');
ArrayList pars = new ArrayList();
if (desc.Length > 1)
{
string[] ss = desc[1].Split(';');
foreach (var s in ss)
{
//判断是否为
pars.Add(MB.WinBase.AppEnvironmentSetting.Instance.ConvertSystemParamValue(s));
}
}
if (filterParameters != null && filterParameters.Count > 0)
{
pars.Add(filterParameters.ToArray());
}
else
{
if (_InvokeDataSourceDesc.ExistsFilterParams)
{
//判断调用的方法是否存在过滤的参数,如果存在需要进行特殊的处理（默认情况下存在）
List <MB.Util.Model.QueryParameterInfo> filterParam = new List <MB.Util.Model.QueryParameterInfo>();
filterParam.Add(new MB.Util.Model.QueryParameterInfo("1", "1", MB.Util.DataFilterConditions.Special));
pars.Add(filterParam.ToArray());
}
}
//object val = MB.Util.MyReflection.Instance.InvokeMethod(_ClientRule, desc[0], pars.ToArray());
// object val = MB.Util.MyReflection.Instance.InvokeMethodByName(_ClientRule, desc[0], pars.ToArray());
object val = null;
try
{
using (MB.Util.MethodTraceWithTime timeTrack = new MB.Util.MethodTraceWithTime(null))
{
val = MB.Util.MyReflection.Instance.InvokeMethod(_ClientRule, desc[0], pars.ToArray());
var msg = string.Format("查询花费:{0} 毫秒,返回 {1} 记录", timeTrack.GetExecutedTimes(), (val as IList).Count);
MB.WinBase.AppMessenger.DefaultMessenger.Publish(QUERY_REFRESH_MSG_ID, msg);
};
}
catch (Exception ex)
{
throw MB.Util.APPExceptionHandlerHelper.PromoteException(ex, desc[0] + " 出错！");
}
return(val as IList);
}
catch (Exception ex)
{
throw MB.Util.APPExceptionHandlerHelper.PromoteException(ex, "调用方法 MB.WinClientDefault.QueryFilter.FrmGetObjectDataAssistant::GetFilterObjects 获取数据有误");
}
return(null);
}