public static void Delete(string constructionCode)
{
var sql = @"DELETE FROM RimokonNicheDetails WHERE ConstructionCode = '" + constructionCode + "'";
var db = RimokonNicheDetail.GetDatabase();
db.ExecuteNonQuery(sql);
}
public static List <RimokonNicheDetail> Get(string constructionCode, int seqNo)
{
var sql = @"
SELECT *
FROM RimokonNicheDetails
WHERE
ConstructionCode = '" + constructionCode + @"' AND
SeqNo = " + seqNo;
var db = RimokonNicheDetail.GetDatabase();
return(db.ExecuteQuery <RimokonNicheDetail>(sql));
}
/// <summary>重複してる図面表示を消す</summary>
public static void DistinctSwitches(List <RimokonNicheDetail> details)
{
var switches = details.FindAll(p => p.Equipment.IsSwitch);
if (switches.Count == 0 || switches.Count == 1)
{
return;
}
RimokonNicheDetail sw1 = switches.Find(p => p.PositionNo == "1");
RimokonNicheDetail sw2 = switches.Find(p => p.PositionNo == "2");
//if(2 <= switches.Count && switches.Count <= 6)
//{
// sw1 = switches[0];
//}
//else if(7 <= switches.Count)
//{
// sw1 = switches.Find(p => p.PositionNo == 1);
// sw2 = switches.Find(p => p.PositionNo == 2);
//}
details.RemoveAll(p => p.Equipment.IsSwitch);
var index = 0;
if (sw1 != null)
{
details.Insert(index, sw1);
index++;
}
if (sw2 != null)
{
details.Insert(index, sw2);
index++;
}
}
