protected bool SaveToDB(string path, string tablename)
{
try
{
DataTable dt = ExcelManage.InputFromExcel(path, tablename);
if (dt != null && dt.Rows.Count > 0)
{
WsSystem wbi = new WsSystem();
for (int i = 0; i < dt.Rows.Count; i++)
{
if (!string.IsNullOrEmpty(dt.Rows[i][0].ToString()))
{
BasEquipment bb = new BasEquipment();
bb.CODE = dt.Rows[i][0].ToString();
bb.COMPANY = dt.Rows[i][1].ToString();
bb.MachineName = dt.Rows[i][2].ToString();
bb.MachineType = dt.Rows[i][3].ToString();
bb.AxisNumber = dt.Rows[i][4].ToString();
bb.MODEL = dt.Rows[i][5].ToString();
bb.POWER = dt.Rows[i][6].ToString();
bb.LOCATION = dt.Rows[i][7].ToString();
bb.STATUS = dt.Rows[i][8].ToString();
bb.OutCode = dt.Rows[i][9].ToString();
bb.UseDate = Convert.ToDateTime(string.IsNullOrEmpty(dt.Rows[i][10].ToString())?DateTime.Now.ToShortDateString(): dt.Rows[i][10].ToString());
wbi.SaveEquipmentInfo(bb);
}
}
return(true);
}
else
{
Label1.Text = "上传完毕，但数据为空，保存失败";
}
return(true);
}
catch (Exception ex)
{
Label1.Text = ex.ToString();
return(false);
}
}
