public static List <OptionPickingItemsEx> Get(string constructionCode)
{
string sql = @"
SELECT * FROM OptionPickingItemsEx
WHERE
ConstructionCode = '" + constructionCode + "'";
var db = OptionPickingItemsEx.GetDatabase();
return(db.ExecuteQuery <OptionPickingItemsEx>(sql));
}
public static void Update(List <OptionPickingItemsEx> items, string constructionCode)
{
OptionPickingItemsEx.Delete(constructionCode);
var now = DateTime.Now;
int seq = 1;
foreach (var item in items)
{
item.Seq = seq;
item.UpdatedDateTime = now;
item.Store();
seq++;
}
}
