62,073
社区成员
发帖
与我相关
我的任务
分享
public void ExcelInsertSQL(DataTable dtExcel)
{
using (CourseHospitalDataContext chdc = new CourseHospitalDataContext())
{
var query = from q in dtExcel.AsEnumerable()
select new
{
CityID = q["所属城市"].ToString().Trim(),
Name = q["医院名称"].ToString().Trim(),
Level = q["卫生部级别"].ToString().Trim(),
DoctorNumber = Convert.ToInt32(q["医生数"].ToString().Trim()),
DepartmentNumber = Convert.ToInt32(q["科室数"].ToString().Trim()),
Remarts = q["备注"].ToString().Trim(),
Potential = Convert.ToInt32(q["处方潜力"].ToString().Trim())
};
List<CourseHospital> listEntity = new List<CourseHospital>();
foreach (var q in query)
{
CourseHospital Entity = new CourseHospital();
Entity.CityID = q.CityID;
Entity.Name = q.Name;
Entity.Level = q.Level;
Entity.DoctorNumber = q.DoctorNumber;
Entity.DepartmentNumber = q.DepartmentNumber;
Entity.Remarts = q.Remarts;
Entity.Potential = q.Potential;
Entity.IsDeleted = false;
listEntity.Add(Entity);
}
chdc.CourseHospitals.InsertAllOnSubmit(listEntity);
chdc.SubmitChanges();
}