/// <summary> /// 支持自定义字段单表查询(可带语句和指定字段值) /// </summary> public static DataTable SelWithField(string tbname, string fields, string where = "", string order = "", List <SqlParameter> sp = null) { tbname = tbname + " A "; SqlModel model = new SqlModel() { cmd = SqlCmd.Select, fields = fields, tbName = tbname }; if (!string.IsNullOrEmpty(where)) { model.where = where; } if (!string.IsNullOrEmpty(order)) { model.order = order; } model.spList = sp; return(DB.ExecuteTable(model)); }
//根据csv或xlsx,将数据导入数据库 public void ContentManage_Import() { HttpPostedFileBase file = Request.Files["fileImp"]; if (file == null) { function.WriteErrMsg("没有上传数据文件"); return; } string exName = Path.GetExtension(file.FileName).ToLower(); if (!exName.Equals(".csv") && !exName.Equals(".xls") && !exName.Equals(".xlsx"))//判断扩展名 { function.WriteErrMsg("上传的文件不是符合扩展名csv,请重新选择!"); return; } string vpath = SafeSC.SaveFile(ZLHelper.GetUploadDir_System("Content", "Import", "yyyyMMdd"), function.GetRandomString(6) + exName, IOHelper.StreamToBytes(file.InputStream)); //导入文件到数据集对象 DataTable dt = null; if (exName.Equals(".csv")) { OfficeHelper office = new OfficeHelper(); dt = office.OpenCSV(vpath); } else { SqlBase excel = SqlBase.CreateHelper("excel"); excel.ConnectionString = vpath; dt = excel.ExecuteTable(new SqlModel() { tbName = excel.Table_List().Rows[0]["name"].ToString() }); } SafeSC.DelFile(vpath); DataSet newDs = Import_CreateTable(dt); Import_SaveDB(newDs);//保存到数据库 }