public void CanGetRecordsOutput()
{
info = new StatisticalInfo(10, 10);
var result = info.RecordsOutput;
Assert.AreEqual(10, result);
}
internal static StatisticalInfo Create()
{
var inf = new StatisticalInfo();
inf.mean = 0.0;
inf.stdDev = CrossEntropyAlgorithm.MaxStdDev;
return inf;
}
public IEnumerable getAllStatisticalInfoArray()
{
List <StatisticalInfo> result = new List <StatisticalInfo>();
try
{
DataTable datatable = maintainaceDal.getStatisticInfo();
foreach (DataRow dr in datatable.Rows)
{
StatisticalInfo statisticalInfo = new StatisticalInfo()
{
Id = (int)dr["编号"],
TableName = dr["表名称"].ToString(),
Operation = dr["操作"].ToString()
};
result.Add(statisticalInfo);
}
return(result);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
public void CanCreateStatisticalInfo()
{
Assert.DoesNotThrow(() =>
{
info = new StatisticalInfo(10, 10);
});
}
public void CanGetBlocksAccessed()
{
info = new StatisticalInfo(10, 10);
var result = info.BlocksAccessed;
Assert.AreEqual(10, result);
}
public void TestAddStatisticalInfo()
{
Tools.UserCaseHandle userCaseHandle = new Tools.UserCaseHandle(@"C:\Users\73473\Desktop\软件工程\用例\Add_StatisticalInfo.xls");
IEnumerable addStatisticalInfo = userCaseHandle.GetUserCases();
List <string> errorList = new List <string>();
foreach (var i in addStatisticalInfo)
{
Assert.AreEqual(false, maintainaceBll.AddStatisticalInfo((StatisticalInfo)i, ref errorList));
}
//int maxId = -1;
//foreach (DictionaryBookSeller i in maintainaceBll.getAllDicBookSellerArry())
//{
// if (i.Id > maxId)
// {
// maxId = i.Id;
// }
//}
StatisticalInfo statisticalInfo = new StatisticalInfo()
{
Id = -1,
TableName = "PeriodicalOrder",
Operation = "select * from tb_PeriodicalOrder;",
};
Assert.AreEqual(true, maintainaceBll.AddStatisticalInfo(statisticalInfo, ref errorList));
}
public void TestUpdateStatisticalInfo()
{
Tools.UserCaseHandle userCaseHandle = new Tools.UserCaseHandle(@"C:\Users\73473\Desktop\软件工程\用例\Update_StatisticalInfo.xls");
IEnumerable updateStatisticalInfo = userCaseHandle.GetUserCases();
List <string> errorList = new List <string>();
foreach (var i in updateStatisticalInfo)
{
Assert.AreEqual(false, maintainaceBll.UpdateStatisticalInfo((StatisticalInfo)i, ref errorList));
}
int maxId = -1;
foreach (StatisticalInfo i in maintainaceBll.getAllStatisticalInfoArray())
{
if (i.Id > maxId)
{
maxId = i.Id;
}
}
StatisticalInfo statisticalInfo = new StatisticalInfo()
{
Id = maxId,
TableName = "PeriodicalOrder",
Operation = "select * from tb_PeriodicalOrder;",
};
Assert.AreEqual(true, maintainaceBll.UpdateStatisticalInfo(statisticalInfo, ref errorList));
}
private void btn_Add_Click(object sender, EventArgs e)
{
try
{
List <string> errorList = new List <string>(); //创建一个错误列表
//获取根据当前页面内容生成的订单（若有错误会被添加到错误列表中）
StatisticalInfo statisticalInfo = GetStatisticalInfo(ref errorList);
//判断是否添加订单成功
if (maintainaceBll.AddStatisticalInfo(statisticalInfo, ref errorList))
{
MessageBox.Show("添加成功");
}
else
{
MessageBox.Show("添加失败");
foreach (var i in errorList)
{
MessageBox.Show(i);//逐条显示错误信息
}
}
ChangeBtnState();
DataBind();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btn_Delete_Click(object sender, EventArgs e)
{
try
{
List <string> errorList = new List <string>();
StatisticalInfo statisticalInfo = GetStatisticalInfo(ref errorList);
DialogResult dialogResult = MessageBox.Show("是否删除该条记录", "删除确认", MessageBoxButtons.YesNoCancel);//设置弹出窗体的格式
if (dialogResult == DialogResult.Yes)
{
if (maintainaceBll.DeleteStatisticalInfo(statisticalInfo.Id))
{
MessageBox.Show("删除成功");
}
else
{
MessageBox.Show("删除失败");
}
}
DataBind();
}
catch (Exception ex)
{
Console.WriteLine(ex);
throw ex;
}
}
/// <summary>
/// 增添统计格式
/// </summary>
/// <param name="statisticalInfo"></param>
/// <returns></returns>
public bool AddStatisticalInfo(StatisticalInfo statisticalInfo)
{
string sqlStr = "INSERT INTO tb_StatisticalFormat ( " +
" TableName ," +
" Operation" +
" )" +
" VALUES ( " +
" @TableName ," +
" @Operation " +
" ) ;";
MySqlParameter[] para = new MySqlParameter[]
{
new MySqlParameter("@TableName", statisticalInfo.TableName),
new MySqlParameter("@Operation", statisticalInfo.Operation),
};
int count = helper.ExecuteNonQuery(sqlStr, para, CommandType.Text);
if (count > 0)
{
return(true);
}
else
{
return(false);
}
}
public void CanGetDistinctValuesCount()
{
info = new StatisticalInfo(6, 6);
var result = info.DistinctValues("file");
Assert.AreEqual(3, result);
}
private StatisticalInfo GetStatisticalInfo(ref List <string> error)
{
List <string> errorList = new List <string>();//错误列表
StatisticalInfo statisticalInfo = new StatisticalInfo()
{
Id = currentId,
TableName = comboBox_TableName.Text.ToString().Trim(),
Operation = textBox_Option.Text.ToString()
};
error = errorList;
return(statisticalInfo);
}
public void CanGetStatisticsInfo()
{
metadataManager = new MetadataManager(_fileManager, tableManager, viewManager, indexManager, statisticsManager);
StatisticalInfo info = null;
Assert.DoesNotThrow(() =>
{
info = metadataManager.GetStatisticsInfo(tableName, _transaction);
});
Assert.IsNotNull(info);
Assert.AreEqual(1, info.BlocksAccessed);
Assert.AreEqual(0, info.RecordsOutput);
}
public IndexInfo(string indexName,
string tableName,
string fieldName,
ITableManager tableManager,
IStatisticsManager statisticsManager,
Transaction transaction,
int blockSize = 1024)
{
_indexName = indexName;
_fieldName = fieldName;
_transaction = transaction;
_blockSize = blockSize;
_tableInfo = tableManager.GetTableInfo(tableName, transaction);
_statInfo = statisticsManager.GetStatisticalInfo(tableName, transaction);
}
public DataTable getStatisticInfoByName(StatisticalInfo statisticalInfo)
{
string sqlStr = "Select " +
" tb_StatisticalFormat.Id as 编号 ," +
" tb_StatisticalFormat.TableName as 表名称 ," +
" tb_StatisticalFormat.Operation as 操作 " +
" from tb_StatisticalFormat " +
" Where TableName =@TableName ;";
MySqlParameter[] para = new MySqlParameter[]
{
new MySqlParameter("@TableName", statisticalInfo.TableName),
};
DataTable dataTable = helper.ExecuteQuery(sqlStr, para, CommandType.Text);
return(dataTable);
}
public void Run(string casename, int users, string config)
{
if (Session != null)
{
this.StatisticalInfo = new StatisticalInfo();
Network.RunTestcase run = new Network.RunTestcase();
run.UnitTest = Name;
run.TestCase = casename;
run.Users = users;
run.Config = config;
Session.Send(run);
}
else
{
Loger.Process(LogType.ERROR, "{0} network session notfound", Name);
}
}
public bool UpdateCaseNameCheckSI(StatisticalInfo statisticalInfo)
{
DataTable result = null;
try
{
result = maintainaceDal.getStatisticInfoByName(statisticalInfo);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
if (result.Rows.Count <= 1)
{
return(true);
}
else
{
return(false);
}
}
public bool UpdateStatisticalInfo(StatisticalInfo statisticalInfo, ref List <string> errorMsg)
{
bool result = false;
try
{
if (!StatisticalInfo.isNull(statisticalInfo))
{
if (!StatisticalInfo.isNormative(statisticalInfo, ref errorMsg))
{
if (this.UpdateCaseNameCheckSI(statisticalInfo))
{
result = maintainaceDal.UpdateStatisticalInfo(statisticalInfo);
}
}
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
return(result);
}
/// <summary>
/// 更新统计格式
/// </summary>
/// <param name="statisticalInfo"></param>
/// <returns></returns>
public bool UpdateStatisticalInfo(StatisticalInfo statisticalInfo)
{
string sqlStr = "Update tb_StatisticalFormat SET " +
" TableName =@TableName ," +
" Operation = @Operation " +
" WHERE Id= @Id ;";
MySqlParameter[] para = new MySqlParameter[]
{
new MySqlParameter("@TableName", statisticalInfo.TableName),
new MySqlParameter("@Operation", statisticalInfo.Operation),
new MySqlParameter("@Id", statisticalInfo.Id),
};
int count = helper.ExecuteNonQuery(sqlStr, para, CommandType.Text);
if (count > 0)
{
return(true);
}
else
{
return(false);
}
}
private void UpdateInfos()
{
for (int idx = 0; idx < infos.Length; idx++)
{
if (rule.DistributionType == DistributionType.Gaussian)
{
double mean, stdDev;
Statistics.CalculateMeanAndStdDev(GetEvaluatedEliteWeights(idx), out mean, out stdDev);
//if (stdDev < rule.MutationStrength && rule.MutationChance)
//{
// stdDev += rule.MutationStrength;
//}
// Range checking:
mean = MeanRange.Cut(mean);
if (double.IsNaN(stdDev) || stdDev < Epsilon)
{
stdDev = Epsilon;
}
else if (stdDev > MaxStdDev)
{
stdDev = MaxStdDev;
}
infos[idx] = new StatisticalInfo(mean, stdDev);
}
else
{
double min, max;
CalculateMinMax(GetEvaluatedEliteWeights(idx), out min, out max);
double d = (max - min) / 2.0;
if (d < rule.MutationStrength && rule.MutationChance)
{
double d2 = (d + rule.MutationStrength) / 2.0;
min -= d2;
max += d2;
d = (max - min) / 2.0;
}
min = MeanRange.Cut(min);
max = MeanRange.Cut(max);
infos[idx] = new StatisticalInfo(min + d, d);
}
}
}
public TablePlan(string tableName, IMetadataManager metadataManager, Transaction transaction)
{
_transaction = transaction;
_tableInfo = metadataManager.GetTableInfo(tableName, transaction);
_statisticalInfo = metadataManager.GetStatisticsInfo(tableName, transaction);
}
private OperationReturn GetStatisticalInfoList(SessionInfo session, List <string> listParams)
{
OperationReturn optReturn = new OperationReturn();
optReturn.Result = true;
optReturn.Code = 0;
try
{
if (listParams.Count < 1)
{
optReturn.Result = false;
optReturn.Code = Defines.RET_PARAM_INVALID;
optReturn.Message = string.Format("Param count invalid");
return(optReturn);
}
//ListParams
//0 UserID
string rentToken = session.RentInfo.Token;
int dbType = session.DBType;
string strCon = session.DBConnectionString;
string strSql;
DataSet objDataSet;
switch (dbType)
{
case 2:
strSql = string.Format("SELECT A.C001 AS AC001,A.C002 AS AC002,A.C003 AS AC003, ");
strSql += string.Format("B.C001 AS BC001,B.C002 AS BC002,B.C003 AS BC003, ");
strSql += string.Format("C.C001 AS CC001,C.C002 AS CC002 ");
strSql += string.Format("FROM T_31_052_00000 A,T_31_050_00000 B,T_11_006_00000 C ");
strSql += string.Format("WHERE A.C002 = B.C001 AND A.C003=C.C001 ");
optReturn = MssqlOperation.GetDataSet(strCon, strSql);
if (!optReturn.Result)
{
optReturn.Message += string.Format("\r\n{0}", strSql);
return(optReturn);
}
break;
case 3:
strSql = string.Format("SELECT A.C001 AS AC001,A.C002 AS AC002,A.C003 AS AC003, ");
strSql += string.Format("B.C001 AS BC001,B.C002 AS BC002,B.C003 AS BC003, ");
strSql += string.Format("C.C001 AS CC001,C.C002 AS CC002 ");
strSql += string.Format("FROM T_31_052_00000 A,T_31_050_00000 B,T_11_006_00000 C ");
strSql += string.Format("WHERE A.C002 = B.C001 AND A.C003=C.C001 ");
optReturn = OracleOperation.GetDataSet(strCon, strSql);
if (!optReturn.Result)
{
optReturn.Message += string.Format("\r\n{0}", strSql);
return(optReturn);
}
break;
default:
optReturn.Result = false;
optReturn.Code = Defines.RET_PARAM_INVALID;
optReturn.Message = string.Format("DBType invalid.\t{0}", dbType);
return(optReturn);
}
objDataSet = optReturn.Data as DataSet;
if (objDataSet == null ||
objDataSet.Tables.Count <= 0)
{
optReturn.Result = false;
optReturn.Code = Defines.RET_OBJECT_NULL;
optReturn.Message = string.Format("DataSet is null or table not exist.");
return(optReturn);
}
List <string> listReturn = new List <string>();
for (int i = 0; i < objDataSet.Tables[0].Rows.Count; i++)
{
DataRow dr = objDataSet.Tables[0].Rows[i];
StatisticalInfo item = new StatisticalInfo();
item.ID = Convert.ToInt64(dr["AC001"]);
item.ParamID = Convert.ToInt64(dr["AC002"]);
item.OwnerID = Convert.ToInt64(dr["AC003"]);
string paramName = dr["BC002"].ToString();
string orgName = dr["CC002"].ToString();
orgName = DecryptFromDB(orgName);
item.OwnerName = orgName;
item.Name = string.Format("{0}[{1}]", paramName, orgName);
optReturn = XMLHelper.SeriallizeObject(item);
if (!optReturn.Result)
{
return(optReturn);
}
listReturn.Add(optReturn.Data.ToString());
}
optReturn.Data = listReturn;
}
catch (Exception ex)
{
optReturn.Result = false;
optReturn.Code = Defines.RET_FAIL;
optReturn.Message = ex.Message;
}
return(optReturn);
}
