/// <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);//保存到数据库
}
