public void insertGongHuoFang(DataTable dt)
{
using (nemanpingEntities3 can = new nemanpingEntities3())
{
foreach (DataRow dr in dt.Rows)
{
if (dr[0] is DBNull || Convert.ToInt32(dr[0]) == 0)
{
GongHuoFang insets = new GongHuoFang()
{
PingMing = dr[1].ToString(),
HuoHao = dr[2].ToString(),
Guige = dr[3].ToString(),
SeHao = dr[4].ToString(),
Yanse = dr[5].ToString(),
DanJia = dr[6].ToString(),
GongHuoFangA = dr[7].ToString(),
GongHuoFangB = dr[8].ToString(),
BeiZhu = dr[9].ToString()
};
can.GongHuoFang.Add(insets);
}
else
{
int id = Convert.ToInt32(dr[0]);
var select = from sc in can.GongHuoFang where sc.Id == id select sc;
var target = select.FirstOrDefault <GongHuoFang>();
target.PingMing = dr[1].ToString();
target.HuoHao = dr[2].ToString();
target.Guige = dr[3].ToString();
target.SeHao = dr[4].ToString();
target.Yanse = dr[5].ToString();
target.DanJia = dr[6].ToString();
target.GongHuoFangA = dr[7].ToString();
target.GongHuoFangB = dr[8].ToString();
target.BeiZhu = dr[9].ToString();
}
}
can.SaveChanges();
}
}
public List <GongHuoFang> selectGongHuoFang()
{
using (nemanpingEntities3 can = new nemanpingEntities3())
{
List <GongHuoFang> GongHuoFang = new List <GongHuoFang>();
var select = from s in can.GongHuoFang select s;
foreach (var item in select)
{
GongHuoFang s = new GongHuoFang();
s.Id = item.Id;
s.PingMing = item.PingMing;
s.HuoHao = item.HuoHao;
s.Guige = item.Guige;
s.SeHao = item.SeHao;
s.Yanse = item.Yanse;
s.DanJia = item.DanJia;
s.GongHuoFangA = item.GongHuoFangA;
s.GongHuoFangB = item.GongHuoFangB;
s.BeiZhu = item.BeiZhu;
GongHuoFang.Add(s);
}
return(GongHuoFang);
}
}
public List <GongHuoFang> readerGongHuoFangExcel(string fileName)
{
List <GongHuoFang> list = new List <GongHuoFang>();
using (SpreadsheetDocument document = SpreadsheetDocument.Open(fileName, false))
{
WorkbookPart wbPart = document.WorkbookPart;
List <Sheet> sheets = wbPart.Workbook.Descendants <Sheet>().ToList();
var versionSheet = wbPart.Workbook.Descendants <Sheet>().FirstOrDefault();
WorksheetPart worksheetPart = (WorksheetPart)wbPart.GetPartById(versionSheet.Id);
int rowindex = 0;
foreach (Row row in worksheetPart.Worksheet.Descendants <Row>())
{
if (rowindex < 1)
{
rowindex++;
continue;
}
GongHuoFang s = new GongHuoFang();
foreach (Cell cell in row)
{
string rev = cell.CellReference.Value;
if (rev.StartsWith("A"))
{
s.PingMing = GetCellValue(wbPart, cell);
}
if (rev.StartsWith("B"))
{
s.HuoHao = GetCellValue(wbPart, cell);
}
if (rev.StartsWith("C"))
{
s.Guige = GetCellValue(wbPart, cell);
}
if (rev.StartsWith("D"))
{
s.SeHao = GetCellValue(wbPart, cell);
}
if (rev.StartsWith("E"))
{
s.Yanse = GetCellValue(wbPart, cell);
}
if (rev.StartsWith("F"))
{
s.DanJia = GetCellValue(wbPart, cell);
}
if (rev.StartsWith("G"))
{
s.GongHuoFangA = GetCellValue(wbPart, cell);
}
if (rev.StartsWith("H"))
{
s.GongHuoFangB = GetCellValue(wbPart, cell);
}
if (rev.StartsWith("I"))
{
s.BeiZhu = GetCellValue(wbPart, cell);
}
}
list.Add(s);
}
return(list);
}
}
