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