//把excel 数据导入DataTable中
string conStr=@" Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source = "+fileAddress+";Password=;User ID=Admin;Extended Properties=Excel 8.0" ;
string cmdText="select * from [Sheet1$]";
OleDbDataAdapter da = new OleDbDataAdapter(cmdText,conStr);
DataSet ds = new DataSet();
da.Fill(ds);
dt = ds.Tables[0].Copy();
//把DataTable中的数据导入数据库
private void InputTaskInfo(int rowId)
{
ITASK_INFOService task_infoService = ServiceLocator.GetService(typeof (ITASK_INFOService)) as ITASK_INFOService;
TbTASK_INFO o=new TbTASK_INFO();
System.DateTime SDate = Convert.ToDateTime(Convert.ToDateTime(this.dt.Rows[rowId][3].ToString()).ToShortDateString());
//Excel 必须要的字段 --------begin
o.TASK_ID = task_infoService.generate_task_id(SDate); o.STATION = this.dt.Rows[rowId][1].ToString();
o.DEVICE_NAME = this.dt.Rows[rowId][2].ToString();
o.START_DATE = SDate;
o.END_DATE = Convert.ToDateTime(Convert.ToDateTime(this.dt.Rows[rowId] [4].ToString()).ToShortDateString());
o.TASK_TIME = this.dt.Rows[rowId][5].ToString();
o.JOB_GUT = this.dt.Rows[rowId][6].ToString();
o.STOP_STATUS = this.dt.Rows[rowId][7].ToString();
o.REMARK = this.dt.Rows[rowId][8].ToString();
//Excel 必须要的字段 --------end
o.APPLY_MAN = AppContext.EmpName;//用登陆用户(姓名)
o.EXE_STATUS = "";
o.PROJ_ID = "";
o.APPROVE_MAN = "";
o.APPLY_DATE = System.DateTime.Now.Date;
o.APPROVE_DATE=DateTime.Now.Date; //need get rid of
o.TASK_SOURCE = "99"; //任务来源 :其它
o.APPROVE_STATUS="10";
o.EXE_STATUS = "正常";
object valueList=task_infoService.insert_task_info(o);
}