本文整理汇总了C#中DowntimeCollection_Demo.DB.AddToDowntimeReasonSet方法的典型用法代码示例。如果您正苦于以下问题：C# DB.AddToDowntimeReasonSet方法的具体用法？C# DB.AddToDowntimeReasonSet怎么用？C# DB.AddToDowntimeReasonSet使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类DowntimeCollection_Demo.DB的用法示例。
在下文中一共展示了DB.AddToDowntimeReasonSet方法的1个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: saveAllPostRows
private string saveAllPostRows()
{
List<PostRowData> dd = getPostRowDatas();
if (dd == null) return "no data";
using (DB db = new DB(DBHelper.GetConnectionString(_currentClient)))
{
DowntimeReason dr;
foreach (var item in dd)
{
var levels = item.Path.Split('>');
if (levels.Length < 3) Array.Resize(ref levels, 3);
if (string.IsNullOrEmpty(levels[0]) && string.IsNullOrEmpty(levels[1]) && string.IsNullOrEmpty(levels[2])) continue;
if (item.Id <= 0)
{
dr = new DowntimeReason
{
Level1 = levels[0],
Level2 = levels[1],
Level3 = levels[2],
Duration = item.Duration,
Client = _currentClient,
HideReasonInReports = item.HideReasonInReports,
Line = (!string.IsNullOrEmpty(Line) ? Line : "company-demo"),
IsChangeOver = item.IsChangeOver
};
db.AddToDowntimeReasonSet(dr);
}
else
{
var q = from o in db.DowntimeReasonSet
where o.ID == item.Id
&& o.Client == _currentClient
select o;
dr = q.FirstOrDefault();
if (dr == null) continue;
if ((string.IsNullOrEmpty(dr.Line) || dr.Line == "company-demo") && (!string.IsNullOrEmpty(Line) && Line != "company-demo"))//assumes it is a global reason code and they're adding a Line specific
{
DowntimeReason reason = new DowntimeReason
{
Level1 = levels[0],
Level2 = levels[1],
Level3 = levels[2],
Duration = item.Duration,
HideReasonInReports = item.HideReasonInReports,
Line = (!string.IsNullOrEmpty(Line) ? Line : "company-demo"),
IsChangeOver = item.IsChangeOver,
Client = _currentClient
};
db.AddToDowntimeReasonSet(reason);
}
else
{
dr.Level1 = levels[0];
dr.Level2 = levels[1];
dr.Level3 = levels[2];
dr.Duration = item.Duration;
dr.HideReasonInReports = item.HideReasonInReports;
dr.Line = (!string.IsNullOrEmpty(Line) ? Line : "company-demo");
dr.IsChangeOver = item.IsChangeOver;
}
}
}
//delete rows
foreach (var item in getPostRowDatasDeleteRows())
{
var q = from o in db.DowntimeReasonSet
where o.ID == item
&& o.Client == _currentClient
select o;
dr = q.FirstOrDefault();
if (dr == null) continue;
if(dr.Line == Line)//Don't want to accidently delete another Line's reason code
db.DeleteObject(dr);
}
db.SaveChanges();
return "true";
}
}