public void UpdateProjList()
{
ProjList.ItemsSource = DocumentManager.CurrentDocument.Projects.Select(x =>
{
var paper = new ThumbnailControl { Width = 90, Height = 60 };
paper.Paper.Children.Add(new TextBlock { Text = x.P1A, FontSize = 11, TextWrapping = TextWrapping.Wrap, HorizontalAlignment = HorizontalAlignment.Center, VerticalAlignment = VerticalAlignment.Center, Margin = new Thickness(5) });
paper.MouseLeftButtonUp += (sender, e) =>
{
var id = DocumentManager.CurrentDocument.Projects.IndexOf(x);
NavigationManager.Navigate("RichProjectPage.xaml", "id=" + id);
if (RichProjectPage.Current != null)
{
RichProjectPage.Current.SetProj(id);
}
};
paper.MouseRightButtonUp += (sender, e) =>
{
paper.ContextMenu = BuildContextMenu(new Dictionary<string, Action>
{
{ "删除项目", () =>
{
if (MessageBox.Show("确实要删除该项目吗？", "确认删除", MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.Yes)
{
DocumentManager.CurrentDocument.Projects.RemoveAt(DocumentManager.CurrentDocument.Projects.IndexOf(x));
UpdateProjList();
}
}
}
});
};
return paper;
});
ProjList.ReadyAnimation();
}
public void SetupPunchTypes()
{
IsolatedStorageSettings appSet = IsolatedStorageSettings.ApplicationSettings;
ObservableCollection <PunchType> ptc = new ObservableCollection <PunchType>();
AddStartPunchTypes(ptc);
String BreakList;
if (appSet.TryGetValue <String>("Breaks", out BreakList))
{
foreach (String BreakName in BreakList.Split(','))
{
if (BreakName.Trim().Length != 0)
{
ptc.Add(new PunchType("Start " + BreakName, StartEnd.Start, Category.Break));
}
}
}
String ProjList;
if (appSet.TryGetValue <String>("Projects", out ProjList))
{
foreach (String ProjName in ProjList.Split(','))
{
if (ProjName.Trim().Length != 0)
{
ptc.Add(new PunchType("Start " + ProjName, StartEnd.Start, Category.Project));
}
}
}
AddEndPunchTypes(ptc);
App.Inst.PunchList = ptc;
}
private void button4_Click(object sender, EventArgs e)
{
var filePath = textBox1.Text;
if (filePath == null || filePath == "")
{
MessageBox.Show("Please select file first!", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
try
{
var fileName = Path.GetFileName(filePath);
var excelFile = new FileInfo(filePath);
using (var p = new ExcelPackage(excelFile))
{
var ws = p.Workbook.Worksheets.FirstOrDefault();
var endrow = ws.Dimension.End.Row;
var endcol = 14;
for (int row = 2; row <= endrow; row++)
{
List <string> kind = new List <string>();
for (int col = 1; col <= endcol; col++)
{
if (ws.Cells[row, col].Value != null)
{
kind.Add(ws.Cells[row, col].Value.ToString());
}
else
{
kind.Add("");
}
}
ProjList pl = new ProjList()
{
System = kind[0],
ErrKind = kind[1],
Desc = kind[2],
Applicant = kind[3],
PIC = kind[4],
ReqFormNo = kind[5],
ReqFormDesc = kind[6],
Stage = kind[7],
UserExpectedDate = kind[8],
StageEstimateFinish = kind[9],
StageActualFinish = kind[10],
TestDateEstimate = kind[11],
ApplyDate = kind[12],
Memo = kind[13],
FileName = fileName,
CreatedAt = DateTime.Now,
UpdatedAt = DateTime.Now
};
DbContext.GetInstance().GetCollection <ProjList>().Insert(pl);
kind.Clear();
Thread.Sleep(1); //avoid same time insert
if (ws.Cells[row + 1, 7].Value == null)
{
break;
}
}
}
MessageBox.Show("File " + fileName + " has been uploaded", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex)
{
MessageBox.Show("Detail: " + ex, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
