private static string BuildInsertSQL(ReposityMeta rm, NameValueCollection collection) { string sql = "INSERT INTO " + rm.Table1 + " VALUES("; return(null); }
public static ReposityMeta GetMeta(int mid) { ReposityMeta rm = CacheService.Get("MID_" + mid) as ReposityMeta; if (rm == null) { string sql = "SELECT * FROM meta_reposity WHERE id=@id;" + "SELECT * FROM meta_reposity_map WHERE rid=@id ORDER BY id"; using (IDataReader dr = DBH.ExecuteReader(QA.DBCS_MAIN, CommandType.Text, sql, new SqlParameter("@id", mid))) { if (dr != null) { if (dr.Read()) { rm = new ReposityMeta(); rm.Id = dr.GetInt32(dr.GetOrdinal("id")); rm.OP = dr.GetByte(dr.GetOrdinal("op")); rm.Total = dr.GetInt32(dr.GetOrdinal("total")); rm.Name = dr.GetString(dr.GetOrdinal("name")); rm.Table1 = dr.GetString(dr.GetOrdinal("table1")); rm.Table2 = (dr["table2"] is DBNull) ? null : dr.GetString(dr.GetOrdinal("table2")); rm.Table3 = (dr["table3"] is DBNull) ? null : dr.GetString(dr.GetOrdinal("table3")); if (dr.NextResult()) { rm.Maps = new List <ReposityMap>(); while (dr.Read()) { ReposityMap map = new ReposityMap(); map.Id = dr.GetInt32(dr.GetOrdinal("id")); map.RId = dr.GetInt32(dr.GetOrdinal("rid")); map.Name = dr.GetString(dr.GetOrdinal("name")); map.Field = dr.GetString(dr.GetOrdinal("field")); map.TableIndex = dr.GetInt32(dr.GetOrdinal("tableindex")); map.PK = dr.GetBoolean(dr.GetOrdinal("pk")); map.AutoId = dr.GetBoolean(dr.GetOrdinal("autoid")); rm.Maps.Add(map); } } } } }//using } return(rm); }
public static int Operate(int mid, NameValueCollection collection) { int rtn = 0; //get reposity_meta ReposityMeta rm = GetMeta(mid); string sql = null; IList <SqlParameter> spList = new List <SqlParameter>(); if (rm.OP == 0) { rtn = DBH.GetInt32(QA.DBCS_MAIN, CommandType.Text, sql, spList.ToArray <SqlParameter>()); } else if (rm.OP == 2) { rtn = DBH.ExecuteText(QA.DBCS_MAIN, sql, spList.ToArray <SqlParameter>()); } return(rtn); }
private static string BuildUpdateSQL(ReposityMeta rm, NameValueCollection collection) { return(string.Empty); }