public string Export_Import_post(HttpContext context) { // try // { FileInfo file = new FileInfo(AppDomain.CurrentDomain.BaseDirectory + context.Request["file"]); DataTable dt = NPOIHelper.ImportFromExcel(file.FullName).Tables[0]; //DataView dv = dt.DefaultView; //dv.Sort = "财务编号 ASC"; SqlQuery[] querys = new SqlQuery[dt.Rows.Count]; int i = 0; DateTime importTime = DateTime.Now; foreach (DataRow dr in dt.Rows) { const string insertSql = @" "; } int rows = IocObject.GetDao().ExecuteNonQuery(querys); if (rows < 0) rows = 0; return "{result:true,message:'导入完成,共导入" + rows.ToString() + "条!'}"; /* } catch (Exception exc) { return "{result:false,message:'"+exc.Message+"!'}"; }*/ }
public DataSet GetDataSet(SqlQuery sqlEnt) { DataSet ds = this.db.GetDataSet(sqlEnt); //db.CloseConn(); return ds; }
protected void ExecuteReader(SqlQuery sql, DataReaderFunc func) { this.db.ExecuteReader(sql, func); // db.CloseConn(); }
protected object ExecuteScalar(SqlQuery sqlEnt) { object result = db.ExecuteScalar(sqlEnt); //db.CloseConn(); return result; }
public void SaveLinksOfContent(string typeIndent, int relatedId, IList<ILink> list) { if (list.Count == 0) return; SqlQuery[] querys = new SqlQuery[list.Count]; int i = 0; foreach (ILink link in list) { querys[i++] = SqlQueryHelper.Format( (link.LinkId <= 0 ? DbSql.Link_InsertRelatedLink:DbSql.Link_UpdateRelatedLink), new object[,]{ {"@typeIndent",typeIndent}, {"@relatedId",relatedId}, {"@id",link.LinkId}, {"@name",link.LinkName}, {"@uri",link.LinkUri}, {"@title",link.LinkTitle}, {"@enabled",link.Enabled} }); } base.ExecuteNonQuery(querys); }
public void UpdateCategoryExtendsBind(int categoryId, int[] extendIds) { SqlQuery[] querys = new SqlQuery[extendIds.Length + 1]; const string insertSql = "INSERT INTO $PREFIX_categoryExtend (categoryId,extendId,enabled) VALUES (@categoryId, @extendId,1)"; const string delSql = "DELETE FROM $PREFIX_categoryExtend WHERE categoryId=@categoryId"; querys[0] = SqlQueryHelper.Format(delSql, new object[,]{ {"@categoryId",categoryId} }); for (int i = 0; i < extendIds.Length; i++) { querys[i + 1] = SqlQueryHelper.Format(insertSql, new object[,]{ {"@categoryId",categoryId}, {"@extendId",extendIds[i]} } ); } base.ExecuteNonQuery(querys); }