Beispiel #1
0
        /// <summary>
        /// 获得数据列表
        /// </summary>
        public List <tdps.Model.SBXML> DataTableToList(DataTable dt)
        {
            List <tdps.Model.SBXML> modelList = new List <tdps.Model.SBXML>();
            int rowsCount = dt.Rows.Count;

            if (rowsCount > 0)
            {
                tdps.Model.SBXML model;
                for (int n = 0; n < rowsCount; n++)
                {
                    model = new tdps.Model.SBXML();
                    if (dt.Rows[n]["SBXXID"].ToString() != "")
                    {
                        model.SBXXID = int.Parse(dt.Rows[n]["SBXXID"].ToString());
                    }
                    model.FileName  = dt.Rows[n]["FileName"].ToString();
                    model.SBXMLData = dt.Rows[n]["SBXMLData"].ToString();
                    modelList.Add(model);
                }
            }
            return(modelList);
        }
Beispiel #2
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public void Add(tdps.Model.SBXML model, object trans)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("insert into SBXML(");
            strSql.Append("SBXXID,FileName,SBXMLData)");
            strSql.Append(" values (");
            strSql.Append("@SBXXID,@FileName,@SBXMLData)");
            SQLiteParameter[] parameters =
            {
                new SQLiteParameter("@SBXXID",    DbType.Int32,    4),
                new SQLiteParameter("@FileName",  DbType.String, 200),
                new SQLiteParameter("@SBXMLData", DbType.String)
            };
            parameters[0].Value = model.SBXXID;
            parameters[1].Value = model.FileName;
            parameters[2].Value = RefactoringXMLData(model.SBXMLData, model.FileName);
            //var tag = new object();
            //RefactoringXMLData(tag);
            //string xmlPath = string.Format("{0}\\xml\\{0}", "");
            //CreateXMLFile(tag, xmlPath);
            SQLiteHelper.ExecuteNonQueryByTransaction(strSql.ToString(), (SQLiteTransaction)trans, parameters);
        }
Beispiel #3
0
 /// <summary>
 /// 更新一条数据
 /// </summary>
 public void Update(tdps.Model.SBXML model)
 {
     dal.Update(model);
 }
Beispiel #4
0
 /// <summary>
 /// 增加一条数据
 /// </summary>
 public void Add(tdps.Model.SBXML model)
 {
     dal.Add(model);
 }
Beispiel #5
0
 /// <summary>
 /// 增加一条数据
 /// </summary>
 public void Add(tdps.Model.SBXML model, object trans)
 {
     dal.Add(model, trans);
 }