/// <summary> /// 创建插入命令对象 /// </summary> /// <returns></returns> protected StockCmd CreateInsertCmd(IDvTable Table) { StockCmd isert = new InsertCmd(); isert.CreateCmd(Table); return(isert); }
public override void Close() { started = false; while (finished == false) { if (sleeping == true) { started = false; logEvent.Set(); } Thread.Sleep(100); } if (InsertCmd != null) { InsertCmd.Dispose(); InsertCmd = null; } if (Sql != null) { Sql.Close(); Sql = null; } if (FileWriter != null) { FileWriter.Close(); FileWriter = null; } Th = null; initialized = false; }
/// <summary> /// /// </summary> /// <param name="cmdStr"></param> /// <returns></returns> internal static ICmd ParseSqlCmdString(string cmdStr, CoreEA.ICoreEAHander dbe) { ICmd curCmd = null; if (string.IsNullOrEmpty(cmdStr)) { ProcessException.DisplayErrors(new Exception("Empty Command")); return(null); } try { cmdStr = cmdStr.TrimStart(); cmdStr = cmdStr.TrimEnd(); //Can't to lower , otherwise the insert data will never 大写 //cmdText = cmdText.ToLower(); string tempCmdText = cmdStr.ToLower(); if (tempCmdText.StartsWith("select")) { curCmd = new SelectCmd(dbe); } else if (tempCmdText.StartsWith("insert")) { curCmd = new InsertCmd(dbe); } else if (tempCmdText.StartsWith("update")) { curCmd = new UpdateCmd(dbe); } else if (tempCmdText.StartsWith("delete")) { curCmd = new DeleteCmd(dbe); } else if (tempCmdText.StartsWith("alter") || (tempCmdText.StartsWith("drop"))) { curCmd = new SpecialCmd(dbe); } else if (tempCmdText.StartsWith("create")) { curCmd = new CreateCmd(dbe); } else if (tempCmdText.StartsWith("sp_rename")) { curCmd = new SpecialCmd(dbe); } else { curCmd = null; //throw new Exception("ErrorMsg_CannotParseSqlCmd".GetFromResourece()); } } catch (Exception ee) { ProcessException.DisplayErrors(ee); } return(curCmd); }
/// <summary> /// Adds the given Lemma to the repository. The Id of the lemma is autogenerated. /// </summary> /// <param name="val"></param> public void Add(T val) { InsertCmd.Parameters.Add(Database.CreateParameter("@word", val.Word, InsertCmd)); object[] rec = ConstructRecordFrom(val); for (int i = 0; i < ColumNames.Count(); ++i) { InsertCmd.Parameters.Add(Database.CreateParameter("@" + ColumNames[i], rec[i], InsertCmd)); } int id = InsertCmd.ExecuteNonQuery(); val.Id = id; }
public int InsertBySql(string _insertSql) { this.InsertCmd = InitSqlCommand(_insertSql, this.InsertCmd); try { InsertCmd.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.Message); return(4); } return(0); }
public async Task <ActionResult <Movie> > PostMovie(InsertCmd comando) { this._notificationContext.Clear(); if (!comando.IsValid()) { this._notificationContext.AddNotifications(comando.ValidationResult); return(CreatedAtAction("GetMovie", comando)); } Movie movie = null; comando.Aplicar(ref movie); _context.Address.Add(movie.Address); _context.Movie.Add(movie); await _context.SaveChangesAsync(); return(CreatedAtAction("GetMovie", new { id = movie.Id }, _movieDesv.Completo(movie))); }
public LemmaRepository(LemmaDatabase db, string tableName, string[] columnNames) { Database = db; TableName = tableName; ColumNames = columnNames; InsertCmd = db.CreateCommand("insert into " + TableName + "(word," + string.Join(",", columnNames) + ") values(@word, @" + string.Join(", @", columnNames) + ")"); InsertCmd.Prepare(); string[] columnSetters = columnNames.Select(x => x + "=@" + x).ToArray(); // x=@x UpdateCmd = db.CreateCommand("update " + TableName + " set word=@word, " + string.Join(", ", columnSetters) + " where id=@id"); UpdateCmd.Prepare(); DeleteCmd = db.CreateCommand("delete from " + TableName + " where id=@id"); DeleteCmd.Prepare(); CountCmd = db.CreateCommand("select count(*) from " + TableName); CountCmd.Prepare(); SelectByIdCmd = db.CreateCommand("select * from " + TableName + " where id=@id"); SelectByIdCmd.Prepare(); SelectPageOfDataCmd = db.CreateCommand("select * from " + TableName + " limit @pageSize offset @offset"); SelectPageOfDataCmd.Prepare(); }
public Category Insert(InsertCmd command) { Category result = null; if (command.IsValid()) { command.Apply(ref result); _categoryRepository.Add(result); if (_categoryRepository.Notification.HasNotifications) { Notification.AddNotifications(_categoryRepository.Notification.Notifications); } } else { command.Undo(ref result); Notification.AddNotifications(command.Validation); } return(result); }
protected override void Init() { initialized = false; if (FileWriter == null) { FileWriter = new FileWriter(workingFolder); } try { Sql = new SQL(SQLClientType.MSSQL); Sql.ConnectionString = connectionString; //Check database for errors and recreate Db if get reoubles with connection if (Sql.DbObjectExist(enmDbObjectType.Table, loggingTableName) == false) { CreateLogTable(Sql, loggingTableName, Log.StaticDataColumns); } Action <SqlException> vCurrentErrorHandler = Sql.ErrorHandler; Sql.ErrorHandler = null; try { string vStrSqlSelect = string.Format("SELECT COUNT(*) FROM [{0}] ;", loggingTableName); Sql.Value(vStrSqlSelect); } catch { Sql.Connection.Close(); Sql.ConnectionString = connectionString; CreateLogTable(Sql, loggingTableName, Log.StaticDataColumns); } finally { Sql.ErrorHandler = vCurrentErrorHandler; } if (InsertCmd != null) { InsertCmd.Dispose(); InsertCmd = null; } InsertCmd = GetInsertCommand(Sql, Log.StaticDataColumns); if (queue == null) { queue = new List <LogData>(); } if (logEvent == null) { logEvent = new ManualResetEvent(false); } if (Th == null) { Th = new Thread(new ThreadStart(this.Writer)); Th.Name = this.GetType().FullName + ".Writer"; Th.Start(); } initialized = true; } catch (Exception Ex) { FileWriter.Write(new SysLogData(this.GetType().FullName, "New", Ex)); initialized = false; } }
static void Main(string[] args) { // CUser user = (CUser)(Assembly.Load(filepath).CreateInstance(filepath + ".DBClass." + "CUser")); // if (user != null) // { // System.Console.WriteLine(user.ToString()); // System.Console.ReadLine(); // } InsertCmd icmd = new InsertCmd(); LoadCmd lcmd = new LoadCmd(); SelectCmd scmd = new SelectCmd(); UpdateCmd ucmd = new UpdateCmd(); DeleteCmd dcmd = new DeleteCmd(); ClearCmd ccmd = new ClearCmd(); #region test TUser // UserRev userrev = new UserRev(); // CUser u = new CUser(); // u.UserName = "******"; // u.UserType = 1; // u.PassWord = "******"; // List<CUser> listuser = new List<CUser>(); // listuser.Add(u); // userrev.ListUser = listuser; // icmd.SetReceiver(userrev); // icmd.Execute(); // lcmd.SetReceiver(userrev); // lcmd.Execute(); // System.Console.WriteLine("Element number:{0}", userrev.ListUser.Count); // userrev.UserName = "******"; // scmd.SetReceiver(userrev); // scmd.Execute(); // System.Console.WriteLine("Element number:{0}", userrev.ListUser.Count); // userrev.ListUser.ElementAt(0).PassWord = "******"; // ucmd.SetReceiver(userrev); // ucmd.Execute(); // dcmd.SetReceiver(userrev); // dcmd.Execute(); // ccmd.SetReceiver(userrev); // ccmd.Execute(); #endregion #region test TSystemBase SystemRev sysrev = new SystemRev(); // CSystemBase sysbase = new CSystemBase(); // sysbase.SystemID = "2014722002"; // sysbase.SysName = "test system name"; // List<CSystemBase> list = new List<CSystemBase>(); // list.Add(sysbase); // sysrev.SysList = list; // icmd.SetReceiver(sysrev); // icmd.Execute(); // lcmd.SetReceiver(sysrev); // lcmd.Execute(); // System.Console.WriteLine(sysrev.SysList.Count); // // dcmd.SetReceiver(sysrev); // dcmd.Execute(); #endregion #region test PumpRev PumpRev prev = new PumpRev(); // CPumpStationInfo pump = new CPumpStationInfo(); // pump.PumpName = "testpum"; // List<CPumpStationInfo> list = new List<CPumpStationInfo>(); // list.Add(pump); // prev.ListPump = list; // icmd.SetReceiver(prev); // icmd.Execute(); // lcmd.SetReceiver(prev); // lcmd.Execute(); // System.Console.WriteLine(prev.ListPump.Count); // prev.PumpName = "testpum"; // scmd.SetReceiver(prev); // scmd.Execute(); // System.Console.WriteLine(prev.ListPump.Count); // prev.ListPump.ElementAt(0).PumpName = "Newname"; // ucmd.SetReceiver(prev); // ucmd.Execute(); // dcmd.SetReceiver(prev); // dcmd.Execute(); // ccmd.SetReceiver(prev); // ccmd.Execute(); #endregion #region test OutFallinfo OutFallRev orev = new OutFallRev(); // COutFallInfo outfall = new COutFallInfo(); // COutFallExtInfo outext = new COutFallExtInfo(); // List<COutFallInfo> listoutfall = new List<COutFallInfo>(); // List<COutFallExtInfo> listoutext = new List<COutFallExtInfo>(); // outfall.Category = 1; // outfall.SystemID = "2014722001"; // listoutfall.Add(outfall); // outext.OutFallName = "outfallname"; // listoutext.Add(outext); // orev.OutList = listoutfall; // orev.OutExtList = listoutext; // icmd.SetReceiver(orev); // icmd.Execute(); // lcmd.SetReceiver(orev); // lcmd.Execute(); // System.Console.WriteLine("OutList Number: {0},OutlistExt NUmber : {1}",orev.OutList.Count,orev.OutExtList.Count); // orev.OutExtList.ElementAt(0).OutFallName = "New Name"; // orev.OutList.ElementAt(0).ReportDept = "adasda"; // ucmd.SetReceiver(orev); // ucmd.Execute(); // dcmd.SetReceiver(orev); // dcmd.Execute(); #endregion #region test junction JuncRev jrev = new JuncRev(); //lcmd.SetReceiver(jrev); //lcmd.Execute(); //Console.WriteLine(jrev.ListJunc.Count); //CJuncInfo junc = new CJuncInfo(); //CJuncExtInfo junext = new CJuncExtInfo(); //List<CJuncInfo> listjunc = new List<CJuncInfo>(); //List<CJuncExtInfo> listjuncext = new List<CJuncExtInfo>(); //junc.Junc_Style = 1; //junc.X_Coor = 119.1232443; //junc.Y_Coor = 21.123023123; //junext.Lane_Way = "way name"; //listjuncext.Add(junext); //listjunc.Add(junc); //listjuncext.Add(junext); //jrev.ListJunc = listjunc; //icmd.SetReceiver(jrev); //icmd.Execute(); jrev.JuncName = "ShiN-W1 / LongQ-W1"; scmd.SetReceiver(jrev); scmd.Execute(); System.Console.WriteLine(jrev.ListJunc.Count); //jrev.ListJunc.ElementAt(0).SystemID = "2102323"; //jrev.ListJuncExt.ElementAt(0).Junc_Class = 2; //ucmd.SetReceiver(jrev); //ucmd.Execute(); //dcmd.SetReceiver(jrev); //dcmd.Execute(); //ccmd.SetReceiver(jrev); //ccmd.Execute(); #endregion #region test pipe PipeRev piperev = new PipeRev(); // lcmd.SetReceiver(piperev); // lcmd.Execute(); // System.Console.WriteLine(piperev.ListPipe.Count); // CPipeInfo pipe = new CPipeInfo(); // pipe.PipeName = "Y2-Y3"; // List<CPipeInfo> listpipe = new List<CPipeInfo>(); // listpipe.Add(pipe); // piperev.ListPipe = listpipe; // icmd.SetReceiver(piperev); // icmd.Execute(); //piperev.PipeName = "Y1-Y2"; //scmd.SetReceiver(piperev); //scmd.Execute(); //System.Console.WriteLine(piperev.ListPipe.Count); //System.Console.WriteLine(piperev.ListPipeExt.Count); //System.Console.WriteLine(piperev.ListUS.Count); //System.Console.WriteLine(piperev.ListLog.Count); //System.Console.WriteLine(piperev.ListVideo.Count); // ucmd.SetReceiver(piperev); // ucmd.Execute(); //piperev.ListLog.Clear(); //piperev.ListPipeExt.Clear(); //dcmd.SetReceiver(piperev); //dcmd.Execute(); #endregion System.Console.WriteLine("Done"); System.Console.ReadLine(); }