public void UnvalidKey5()
{
MaterialMatrix avaiMat = new MaterialMatrix(100);
string[] obj = new string[50];
for (int cnt = 0; cnt < obj.Length; cnt++)
{
obj[cnt] = "testStr_" + cnt;
}
obj[0] = "D";
obj[7] = "HK";
obj[8] = "R";
obj[9] = "14";
obj[10] = "A7";
obj[11] = "RKP";
obj[12] = "063";
obj[13] = "H";
obj[14] = "M";
obj[15] = "35";
obj[16] = "D1";
obj[17] = "Z";
obj[18] = "00";
obj[19] = "RKP";
obj[20] = "019";
obj[21] = "H";
obj[22] = "M";
obj[23] = "35";
obj[24] = "D3";
obj[25] = "Z";
obj[26] = "00";
obj[27] = "";
Assert.IsFalse(AvailabilityCheck.IsAvailable(obj, avaiMat));
}
public void SetMaterialMatrix()
{
var excelWrapper = new MySQLArticleClient(host);
MaterialMatrix mat = MaterialMatrix.ReadFromFile(path_lagerVorlage);
excelWrapper.SetAvailibilityMatrix(mat);
}
static int Main(string[] args)
{
if (args.Length != 3)
{
Console.Error.WriteLine("Wrong number of Arguments");
Console.Error.WriteLine("Usage: RkpCli <sql_host> <depmatrix_csv_file> <article_num>");
return(1);
}
else
{
try
{
var sql = new MySQLArticleClient(args[0]);
var mat = MaterialMatrix.ReadFromFile(args[1]);
// todo get productkey
string[] productkey = sql.GetProductkey(args[2]);
if (productkey == null)
{
Console.Error.WriteLine("Article not found");
return(2);
}
Console.WriteLine((AvailabilityCheck.IsAvailable(productkey, mat) ? 1 : 0));
return(0);
}
catch (Exception exc)
{
Console.Error.WriteLine(exc);
return(3);
}
}
}
public void GehauseDS1NichtDa()
{
MaterialMatrix avaiMat = new MaterialMatrix(100);
avaiMat[1, 1] = 0;
string[] obj = new string[50];
for (int cnt = 0; cnt < obj.Length; cnt++)
{
obj[cnt] = "testStr_" + cnt;
}
obj[0] = "D";
obj[7] = "HK";
obj[8] = "R";
obj[9] = "14";
obj[10] = "A7";
obj[11] = "RKP";
obj[12] = "032";
obj[13] = "H";
obj[14] = "M";
obj[15] = "35";
obj[16] = "D1";
obj[17] = "Z";
obj[18] = "00";
obj[19] = "DS1";
obj[20] = "";
Assert.IsFalse(AvailabilityCheck.IsAvailable(obj, avaiMat));
}
public void ReglerS2NichtDa()
{
MaterialMatrix avaiMat = new MaterialMatrix(100);
avaiMat[3, 38] = 0;
string[] obj = new string[20];
for (int cnt = 0; cnt < obj.Length; cnt++)
{
obj[cnt] = "testStr_" + cnt;
}
obj[0] = "D";
obj[7] = "HP";
obj[8] = "R";
obj[9] = "15";
obj[10] = "A7";
obj[11] = "RKP";
obj[12] = "063";
obj[13] = "K";
obj[14] = "M";
obj[15] = "18";
obj[16] = "S2";
obj[17] = "Z";
obj[18] = "11";
obj[19] = "";
Assert.IsFalse(AvailabilityCheck.IsAvailable(obj, avaiMat));
}
public void HasNoPump()
{
MaterialMatrix avaiMat = new MaterialMatrix();
var stat = Statistics.CalcStatistics(new EDRExcelWrapper(kennliste_path), avaiMat);
Assert.AreEqual(null, stat);
}
public void HasAllPumps()
{
MaterialMatrix avaiMat = new MaterialMatrix(3);
var stat = Statistics.CalcStatistics(new EDRExcelWrapper(kennliste_path), avaiMat);
Assert.AreEqual(stat.resolvable, stat.countAllAvai);
}
public void DeckelHFCB1Da()
{
MaterialMatrix avaiMat = new MaterialMatrix();
avaiMat[3, 1] = 1;
avaiMat[3, 19] = 1;
avaiMat[3, 40] = 1;
string[] obj = new string[50];
for (int cnt = 0; cnt < obj.Length; cnt++)
{
obj[cnt] = "testStr_" + cnt;
}
obj[0] = "D";
obj[7] = "HK";
obj[8] = "R";
obj[9] = "14";
obj[10] = "B1";
obj[11] = "RKP";
obj[12] = "063";
obj[13] = "H";
obj[14] = "C";
obj[15] = "35";
obj[16] = "S1";
obj[17] = "Z";
obj[18] = "00";
obj[19] = "DS1";
obj[20] = "";
Assert.IsTrue(AvailabilityCheck.IsAvailable(obj, avaiMat));
}
public void NoExcept()
{
MaterialMatrix avaiMat = new MaterialMatrix();
avaiMat[3, 0] = 1;
avaiMat[3, 13] = 1;
avaiMat[3, 38] = 1;
var stat = Statistics.CalcStatistics(new EDRExcelWrapper(kennliste_path), avaiMat);
}
public void HasLess3Mat()
{
MaterialMatrix avaiMat = new MaterialMatrix();
avaiMat[3, 0] = 1;
avaiMat[3, 13] = 1;
var stat = Statistics.CalcStatistics(new EDRExcelWrapper(kennliste_path), avaiMat);
Assert.AreEqual(null, stat);
}
public void TestIsNegative1()
{
MaterialMatrix mat = new MaterialMatrix(1);
Assert.IsTrue(mat.IsNotNegativ());
mat = new MaterialMatrix();
Assert.IsTrue(mat.IsNotNegativ());
mat = new MaterialMatrix(-1);
Assert.IsFalse(mat.IsNotNegativ());
}
public void TestDeserialization()
{
MaterialMatrix mat = MaterialMatrix.ReadFromFile(path_lagerVorlage);
Assert.AreEqual(6, mat[0, 0]);
Assert.AreEqual(1, mat[0, 38]);
Assert.AreEqual(3, mat[6, 38]);
Assert.AreEqual(0, mat[6, 39]);
Assert.AreEqual(0, mat[6, 40]);
}
public void MaterialMatrixValues()
{
var excelWrapper = new MySQLArticleClient(host);
MaterialMatrix mat = MaterialMatrix.ReadFromFile(path_lagerVorlage);
excelWrapper.SetAvailibilityMatrix(mat);
var res = excelWrapper.GetAvailibilityMatrix();
Assert.IsNotNull(res);
Assert.AreEqual(mat, res);
}
public void HasResults()
{
MaterialMatrix avaiMat = new MaterialMatrix();
avaiMat[3, 0] = 1;
avaiMat[3, 13] = 1;
avaiMat[3, 38] = 1;
var stat = Statistics.CalcStatistics(new EDRExcelWrapper(kennliste_path), avaiMat);
Assert.AreEqual(3, stat.countAllAvai);
}
public void TestInactive37()
{
MaterialMatrix mat = new MaterialMatrix();
Assert.IsFalse(mat.IsInactive(0, 37));
Assert.IsTrue(mat.IsInactive(1, 37));
Assert.IsTrue(mat.IsInactive(2, 37));
Assert.IsFalse(mat.IsInactive(3, 37));
Assert.IsTrue(mat.IsInactive(4, 37));
Assert.IsTrue(mat.IsInactive(5, 37));
Assert.IsFalse(mat.IsInactive(6, 37));
mat[0, 37] = 455;
Assert.AreEqual(mat[0, 37], 455);
Assert.AreEqual(mat[1, 37], 455);
Assert.AreEqual(mat[2, 37], 455);
Assert.AreNotEqual(mat[3, 37], 455);
Assert.AreNotEqual(mat[4, 37], 455);
Assert.AreNotEqual(mat[5, 37], 455);
Assert.AreNotEqual(mat[6, 37], 455);
mat[2, 37] = 32;
Assert.AreEqual(mat[0, 37], 32);
Assert.AreEqual(mat[1, 37], 32);
Assert.AreEqual(mat[2, 37], 32);
Assert.AreNotEqual(mat[3, 37], 32);
Assert.AreNotEqual(mat[4, 37], 32);
Assert.AreNotEqual(mat[5, 37], 32);
Assert.AreNotEqual(mat[6, 37], 32);
mat[5, 37] = 55;
Assert.AreEqual(mat[0, 37], 32);
Assert.AreEqual(mat[1, 37], 32);
Assert.AreEqual(mat[2, 37], 32);
Assert.AreEqual(mat[3, 37], 55);
Assert.AreEqual(mat[4, 37], 55);
Assert.AreEqual(mat[5, 37], 55);
Assert.AreNotEqual(mat[6, 37], 55);
mat[6, 37] = 67;
Assert.AreEqual(mat[0, 37], 32);
Assert.AreEqual(mat[1, 37], 32);
Assert.AreEqual(mat[2, 37], 32);
Assert.AreEqual(mat[3, 37], 55);
Assert.AreEqual(mat[4, 37], 55);
Assert.AreEqual(mat[5, 37], 55);
Assert.AreEqual(mat[6, 37], 67);
mat[3, 37] = -43;
Assert.AreEqual(mat[0, 37], 32);
Assert.AreEqual(mat[1, 37], 32);
Assert.AreEqual(mat[2, 37], 32);
Assert.AreEqual(mat[3, 37], -43);
Assert.AreEqual(mat[4, 37], -43);
Assert.AreEqual(mat[5, 37], -43);
Assert.AreEqual(mat[6, 37], 67);
}
public void TestAddition1()
{
MaterialMatrix mat = new MaterialMatrix();
mat[5, 14] = 5;
Assert.AreEqual(mat[5, 14], 5);
MaterialMatrix mat2 = new MaterialMatrix();
mat2[5, 14] = -40;
Assert.AreEqual(mat2[5, 14], -40);
mat = mat + mat2;
Assert.AreEqual(mat[5, 14], -35);
}
public void TestAddition2()
{
MaterialMatrix mat = new MaterialMatrix(1);
mat[3, 26] = 5;
Assert.AreEqual(mat[3, 26], 5);
Assert.AreEqual(mat[2, 26], 1);
MaterialMatrix mat2 = new MaterialMatrix(23);
mat2[3, 26] = -40;
Assert.AreEqual(mat2[3, 26], -40);
Assert.AreEqual(mat2[2, 26], 23);
mat = mat + mat2;
Assert.AreEqual(mat[3, 26], -35);
Assert.AreEqual(mat[2, 26], 24);
}
public void SaveNonCalculateablePumps()
{
MaterialMatrix avaiMat = new MaterialMatrix(100);
var stat = Statistics.CalcStatistics(new EDRExcelWrapper(kennliste_path), avaiMat);
List <string[]> nonCalculatable = new List <string[]>();
for (int cnt = 0; cnt < stat.allPumps.Count; cnt++)
{
var pump = stat.allPumps[cnt];
if (string.IsNullOrWhiteSpace(pump[0]))
{
throw new Exception();
}
if (stat.allAvaiPumps.Contains(pump))
{
}
else
{
nonCalculatable.Add(pump);
}
}
Assert.AreEqual(stat.countAll - stat.resolvable, nonCalculatable.Count);
StringBuilder str = new StringBuilder();
for (int cnt = 0; cnt < nonCalculatable.Count; cnt++)
{
var pump = nonCalculatable[cnt];
if (string.IsNullOrWhiteSpace(pump[0]))
{
throw new Exception();
}
for (int x = 0; x < pump.Length; x++)
{
str.Append(pump[x].Replace(';', ' ').Replace('\n', ' ').Replace('\r', ' '));
str.Append(";");
}
str.AppendLine();
}
File.WriteAllText("notCalculatable.csv", str.ToString());
}
public void Lagerdeckel1DoppelDa()
{
MaterialMatrix avaiMat = new MaterialMatrix();
avaiMat[3, 1] = 1;
avaiMat[3, 14] = 1;
avaiMat[3, 33] = 1;
avaiMat[0, 0] = 1;
avaiMat[0, 16] = 1;
avaiMat[0, 30] = 1;
string[] obj = new string[50];
for (int cnt = 0; cnt < obj.Length; cnt++)
{
obj[cnt] = "testStr_" + cnt;
}
obj[0] = "D";
obj[7] = "HK";
obj[8] = "R";
obj[9] = "14";
obj[10] = "A7";
obj[11] = "RKP";
obj[12] = "063";
obj[13] = "H";
obj[14] = "M";
obj[15] = "35";
obj[16] = "D1";
obj[17] = "Z";
obj[18] = "00";
obj[19] = "RKP";
obj[20] = "019";
obj[21] = "H";
obj[22] = "M";
obj[23] = "35";
obj[24] = "C1";
obj[25] = "Z";
obj[26] = "00";
obj[27] = "";
Assert.IsTrue(AvailabilityCheck.IsAvailable(obj, avaiMat));
}