public DataForm(String Title, List <String> Values, SuperItem item, ItemTypes types)
{
this.types = types;
this.Title = Title;
this.Values = Values;
this.item = item;
InitializeComponent();
}
public void DecreaseQualityIfNotSulfuras(SuperItem item)
{
if (item.Quality > 0)
{
item.Quality -= 1;
item.ConjuredItem.DegradeQuality(item);
}
}
public void IncreaseQualityWhenQualityIsMax()
{
var SuperItem = new SuperItem {
Name = "Test", SellIn = Max_Quality, Quality = 50
};
SuperItem.IncreaseQuality();
Assert.Equal(50, SuperItem.Quality);
}
public void IncreaseQualityIncludingBackstagePasses_CloseToExpiry()
{
var SuperItem = new SuperItem {
Name = Backstage_Passes, SellIn = Close_To_Expiry - 1, Quality = 15
};
SuperItem.IncreaseQualityIncludingBackstagePasses();
Assert.Equal(18, SuperItem.Quality);
}
public void IncreaseQualityIncludingBackstagePasses_ReachingExpiry()
{
var SuperItem = new SuperItem {
Name = Backstage_Passes, SellIn = Reaching_Expiry_Date - 1, Quality = 15
};
SuperItem.IncreaseQualityIncludingBackstagePasses();
Assert.Equal(17, SuperItem.Quality);
}
public void DecreaseSellIn_BackstagePasses()
{
var SuperItem = new SuperItem {
Name = Backstage_Passes, SellIn = 14, Quality = 11
};
SuperItem.Sulfuras.DecreaseSellInIfNotSulfuras(SuperItem);
Assert.Equal(Backstage_Passes, SuperItem.Name);
Assert.Equal(13, SuperItem.SellIn);
Assert.Equal(11, SuperItem.Quality);
}
public void DecreaseSellIn_AgedBrie()
{
var SuperItem = new SuperItem {
Name = Aged_Brie, SellIn = 14, Quality = 11
};
SuperItem.Sulfuras.DecreaseSellInIfNotSulfuras(SuperItem);
Assert.Equal(Aged_Brie, SuperItem.Name);
Assert.Equal(13, SuperItem.SellIn);
Assert.Equal(11, SuperItem.Quality);
}
public void DecreaseSellIn_Sulfuras()
{
var SuperItem = new SuperItem {
Name = Sulfuras_Hand_Of_Ragnaros, SellIn = 14, Quality = 11
};
SuperItem.Sulfuras.DecreaseSellInIfNotSulfuras(SuperItem);
Assert.Equal(Sulfuras_Hand_Of_Ragnaros, SuperItem.Name);
Assert.Equal(14, SuperItem.SellIn);
Assert.Equal(11, SuperItem.Quality);
}
public void DecreaseSellIn_NormalItem()
{
var SuperItem = new SuperItem {
Name = "test", SellIn = 14, Quality = 11
};
SuperItem.Sulfuras.DecreaseSellInIfNotSulfuras(SuperItem);
Assert.Equal("test", SuperItem.Name);
Assert.Equal(13, SuperItem.SellIn);
Assert.Equal(11, SuperItem.Quality);
}
public void HandleSellInExpired_BackstagePasses()
{
var SuperItem = new SuperItem {
Name = Backstage_Passes, SellIn = -1, Quality = 25
};
SuperItem.HandleSellInExpired();
Assert.Equal(Backstage_Passes, SuperItem.Name);
Assert.Equal(-1, SuperItem.SellIn);
Assert.Equal(0, SuperItem.Quality);
}
public void HandleSellInExpired_AgedBrie()
{
var SuperItem = new SuperItem {
Name = Aged_Brie, SellIn = -1, Quality = 25
};
SuperItem.HandleSellInExpired();
Assert.Equal(Aged_Brie, SuperItem.Name);
Assert.Equal(-1, SuperItem.SellIn);
Assert.Equal(26, SuperItem.Quality);
}
public void HandleSellInExpired_Sulfuras()
{
var SuperItem = new SuperItem {
Name = Sulfuras_Hand_Of_Ragnaros, SellIn = -1, Quality = 25
};
SuperItem.HandleSellInExpired();
Assert.Equal(Sulfuras_Hand_Of_Ragnaros, SuperItem.Name);
Assert.Equal(-1, SuperItem.SellIn);
Assert.Equal(25, SuperItem.Quality);
}
public void HandleSellInExpired_Expired()
{
var SuperItem = new SuperItem {
Name = "test", SellIn = -1, Quality = 11
};
SuperItem.HandleSellInExpired();
Assert.Equal("test", SuperItem.Name);
Assert.Equal(-1, SuperItem.SellIn);
Assert.Equal(10, SuperItem.Quality);
}
public void DecreaseSellIn_ConjuredItem()
{
var SuperItem = new SuperItem {
Name = Conjured_Item, SellIn = 14, Quality = 11
};
SuperItem.Sulfuras.DecreaseSellInIfNotSulfuras(SuperItem);
Assert.Equal(Conjured_Item, SuperItem.Name);
Assert.Equal(13, SuperItem.SellIn);
Assert.Equal(11, SuperItem.Quality);
}
/// <summary>
/// 更新颗粒数据
/// </summary>
/// <param name="row"></param>
/// <param name="station"></param>
/// <param name="type"></param>
private static void UpdateVarDb(DataRow row, string station, string type, string city)
{
DateTime start = Convert.ToDateTime(row[0]);
DateTime end = Convert.ToDateTime(row[0]);
int superstationCount =
Convert.ToInt32(m_Database.GetFirstValue(
"if exists (SELECT TOP 1 1 FROM T_SuperStation where StartTime = '" + start +
"' and Type ='" + type + "' and Station='" + station + "' ) SELECT 1 ELSE SELECT 0"));
if (superstationCount != 0)
{
m_Database.Execute("delete T_SuperStation where StartTime = '" + start +
"' and Type ='" + type + "' and Station='" + station + "'");
}
Dictionary <string, SuperItem> Items = new Dictionary <string, SuperItem>();
DataTable Table_Item = m_Database.GetDataset("select * from D_ItemCode").Tables[0];
int maxdm = Convert.ToInt32(m_Database.GetFirstValue(" select MAX(DM) from D_ItemCode"));
for (int i = 1; i < row.Table.Columns.Count; i++)
{
string colummname = row.Table.Columns[i].ColumnName;
double value = Convert.ToDouble(row[i].ToString() != "" ? row[i].ToString() : "999");
if (colummname.Contains("Column"))
{
continue;
}
int itemcode = -1;
if (value == 999)
{
value = -99;
}
try
{
itemcode = int.Parse(Table_Item.Select("MC = '" + colummname + "'")[0]["DM"].ToString());
}
catch
{
maxdm = maxdm + 1;
string insertsql = " insert into D_ItemCode ([DM],[MC] ,[Type]) values (" + maxdm + ",'" + colummname + "','" + type + "') ; insert into D_ModelAnalysis_Item ([DM],[MC] ,[DP]) values (" + maxdm + ",'" + colummname + "','" + type + "')";
m_Database.Execute(insertsql);
itemcode = maxdm;
}
SuperItem item = new SuperItem("", value, itemcode, "");
Items.Add(colummname, item);
}
string sqlinsert = "";
foreach (SuperItem item in Items.Values)
{
sqlinsert = sqlinsert + string.Format("insert into T_SuperStation (StartTime,EndTime,City,Station,Item,Value,Quality,Type,DValue) values('{0}','{1}','{2}','{3}',{4},{5},'{6}','{7}',{8});", start, end, city, station, item.Item, item.Value, item.Quality, type, item.Value);
}
m_Database.Execute(sqlinsert);
}
public void UpdateQualityIfBackstagePasses()
{
var SuperItem = new SuperItem {
Name = Backstage_Passes, SellIn = 15, Quality = 12
};
SuperItem.UpdateQuality();
Assert.Equal(Backstage_Passes, SuperItem.Name);
Assert.Equal(13, SuperItem.Quality);
Assert.Equal(15, SuperItem.SellIn);
}
public void UpdateQuality_IfConjuredItem()
{
var SuperItem = new SuperItem {
Name = Conjured_Item, SellIn = 25, Quality = 25
};
SuperItem.UpdateQuality();
Assert.Equal(Conjured_Item, SuperItem.Name);
Assert.Equal(23, SuperItem.Quality);
Assert.Equal(25, SuperItem.SellIn);
}
public void UpdateQualityIfSulfuras()
{
var SuperItem = new SuperItem {
Name = Sulfuras_Hand_Of_Ragnaros, SellIn = 15, Quality = 48
};
SuperItem.UpdateQuality();
Assert.Equal(Sulfuras_Hand_Of_Ragnaros, SuperItem.Name);
Assert.Equal(48, SuperItem.Quality);
Assert.Equal(15, SuperItem.SellIn);
}
public void UpdateQualityIfAgedBrie()
{
var SuperItem = new SuperItem {
Name = Aged_Brie, SellIn = -1, Quality = 48
};
SuperItem.UpdateQuality();
Assert.Equal(Aged_Brie, SuperItem.Name);
Assert.Equal(49, SuperItem.Quality);
Assert.Equal(-1, SuperItem.SellIn);
}
public void UpdateQuality()
{
var SuperItem = new SuperItem {
Name = "test", SellIn = 30, Quality = 50
};
SuperItem.UpdateQuality();
Assert.Equal("test", SuperItem.Name);
Assert.Equal(49, SuperItem.Quality);
Assert.Equal(30, SuperItem.SellIn);
}
public void UpdateQuality_IfSellInExpired()
{
var SuperItem = new SuperItem {
Name = "test", SellIn = -1, Quality = 50
};
SuperItem.UpdateQuality();
SuperItem.HandleSellInExpired();
Assert.Equal("test", SuperItem.Name);
Assert.Equal(48, SuperItem.Quality);
Assert.Equal(-1, SuperItem.SellIn);
}
public void UpdateQuality_IfSellInExpired_ConjuredItem()
{
var SuperItem = new SuperItem {
Name = Conjured_Item, SellIn = -1, Quality = 50
};
SuperItem.UpdateQuality();
SuperItem.HandleSellInExpired();
Assert.Equal(Conjured_Item, SuperItem.Name);
Assert.Equal(46, SuperItem.Quality);
Assert.Equal(-1, SuperItem.SellIn);
}
/// <summary>
/// 更外部数据
/// </summary>
/// <param name="row"></param>
/// <param name="station"></param>
/// <param name="type"></param>
private static void UpdateVarDb(DataTable sources, string station, string type, DateTime time, string tablename)
{
Dictionary <string, SuperItem> Items = new Dictionary <string, SuperItem>();
DataTable Table_Item = m_Database.GetDataset("select * from D_ItemCode").Tables[0];
DataTable Table_Parameter = m_Database.GetDataset("select * from [parameter]").Tables[0];
int maxdm = Convert.ToInt32(m_Database.GetFirstValue(" select MAX(DM) from D_ItemCode"));
foreach (DataRow row in sources.Rows)
{
double value = Convert.ToDouble(row["value"].ToString());
int parameterid = Convert.ToInt32(row["parameterid"].ToString());
string opcode = row["opcode"].ToString();
int itemcode = -1;
if (value == 999)
{
value = -99;
}
string mc = Table_Parameter.Select("parameterid = " + parameterid + "")[0]["name"].ToString();
try
{
itemcode = int.Parse(Table_Item.Select("MC = '" + mc + "'")[0]["DM"].ToString());
}
catch
{
maxdm = maxdm + 1;
string insertsql = " insert into D_ItemCode ([DM],[MC] ,[Type]) values (" + maxdm + ",'" + mc + "','" + type + "') ";
m_Database.Execute(insertsql);
itemcode = maxdm;
}
SuperItem item = new SuperItem("", value, itemcode, opcode);
Items.Add(mc, item);
}
string sqlinsert = "";
foreach (SuperItem item in Items.Values)
{
sqlinsert = sqlinsert + string.Format("insert into {10} (StartTime,EndTime,City,Station,Item,Value,Quality,Type,OPCode,DValue) values('{0}','{1}','{2}','{3}',{4},{5},'{6}','{7}','{8}',{9});", time, time.AddHours(1), "上海", station, item.Item, item.Value, item.Quality, type, item.Opcode, item.Value, tablename);
}
m_Database.Execute(string.Format("delete {0} where StartTime='{1}' and Type='{2}'", tablename, time, type));
m_Database.Execute(sqlinsert);
}
/// <summary>
/// 直接判断并添加组件
/// </summary>
/// <param name="Title"></param>
/// <param name="Values"></param>
/// <param name="item"></param>
void SetDatas(String Title, List <String> Values, SuperItem item)
{
int Width = this.Width - 20;
//传进来的item和当前窗体的差距
if (types == ItemTypes.MainImageFormItem)
{
item = ((MainImageFormItem)item);
}
TextBox t = new TextBox();
t.Width = Width - t.Margin.Right - 10;
t.Height = Height;
FlowLayoutPanel flp = To_Help.Create_FlowLayoutPanel_TextBox(Title, Values, t);
flp.Width = Width;
flp.Height = Convert.ToInt32(Form.Height);
Form.Controls.Add(item);
Form.Controls.Add(flp);
}
public void DecreaseQualityIfNotAgedBrie(SuperItem item)
{
item.BackStagePasses.DecreaseQualityIfNotBackStagePasses(item);
}
public void IncreaseIfBackStagePasses(SuperItem item)
{
item.IncreaseIfReachingExpiry();
item.IncreaseIfCloseToExpiry();
}
public void DecreaseQualityIfNotBackStagePasses(SuperItem item)
{
item.Quality = 0;
}
public void IncreaseIfBackStagePasses(SuperItem item)
{
}
public void DecreaseQualityIfNotBackStagePasses(SuperItem item)
{
item.Sulfuras.DecreaseQualityIfNotSulfuras(item);
}
public void DecreaseQualityIfNotAgedBrie(SuperItem item)
{
item.IncreaseQuality();
}
public void DeepClone_MultiLayeredBaseCollection_AsReference(TypeModel model)
{
var superItem = new SuperItem() { Message = "Yellow" };
var obj = new BaseCollectionWrapper()
{
MultiLayerCollections = new SuperItems()
{
superItem,
superItem,
null
}
};
var clone = (BaseCollectionWrapper)model.DeepClone(obj);
Assert.AreEqual(3, clone.MultiLayerCollections.Count);
Assert.AreEqual(obj.MultiLayerCollections[0].Message, clone.MultiLayerCollections[0].Message);
Assert.AreEqual(obj.MultiLayerCollections[1].Message, clone.MultiLayerCollections[1].Message);
Assert.IsNull(clone.MultiLayerCollections[2]);
Assert.IsTrue(object.ReferenceEquals(obj.MultiLayerCollections[0], obj.MultiLayerCollections[1]), "Original Reference failed");
Assert.IsTrue(object.ReferenceEquals(clone.MultiLayerCollections[0], clone.MultiLayerCollections[1]), "Clone Reference failed");
}
