示例#1
0
        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+"!'}";
             }*/
        }
示例#2
0
文件: BaseDAL.cs 项目: coodream/cms
        public DataSet GetDataSet(SqlQuery sqlEnt)
        {
            DataSet ds = this.db.GetDataSet(sqlEnt);
            //db.CloseConn();
            return ds;

        }
示例#3
0
文件: BaseDAL.cs 项目: coodream/cms
 protected void ExecuteReader(SqlQuery sql, DataReaderFunc func)
 {
     this.db.ExecuteReader(sql, func);
    // db.CloseConn();
 }
示例#4
0
文件: BaseDAL.cs 项目: coodream/cms
 protected object ExecuteScalar(SqlQuery sqlEnt)
 {
     object result = db.ExecuteScalar(sqlEnt);
     //db.CloseConn();
     return result;
 }
示例#5
0
文件: LinkDAL.cs 项目: coodream/cms
        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);
        }
示例#6
0
        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);
        }