/// <summary> /// 스케줄 데이터 Insert /// </summary> /// <param name="phone">핸드폰번호</param> /// <param name="wageData">입력할 데이터 구조체</param> /// <returns>영양받은 행수</returns> public int Insert(string phone, WageData wageData) { int result = -1; string sql = "values(\"" + wageData.Date + "\", \"" + wageData.OnTime + "\", \"" + wageData.OffTime + "\", \"" + wageData.Time + "\", \"" + wageData.RestTime + "\", \"" + wageData.ExtensionTime + "\", \"" + wageData.NightTime + "\", \"" + wageData.TotalTime + "\", \"" + wageData.Wage + "\", \"" + wageData.RestWage + "\", \"" + wageData.ExtensionWage + "\", \"" + wageData.NightWage + "\", \"" + wageData.TotalWage + "\")"; string year = SplitString(wageData.Date, '-')[0]; sqlliteManager.DBOpen(); sqlliteManager.Insert(phone + year, sql); sqlliteManager.DBClose(); sql = "values(\"" + phone + "\", \"" + wageData.Date + "\", \"" + wageData.OnTime + "\", \"" + wageData.OffTime + "\", \"" + wageData.Time + "\", \"" + wageData.RestTime + "\", \"" + wageData.ExtensionTime + "\", \"" + wageData.NightTime + "\", \"" + wageData.TotalTime + "\", \"" + wageData.Wage + "\", \"" + wageData.RestWage + "\", \"" + wageData.ExtensionWage + "\", \"" + wageData.NightWage + "\", \"" + wageData.TotalWage + "\")"; Thread thread = new Thread(() => MainWindow.runThread(4, MySQLData.TableWage, sql)); thread.Start(); return(result); }
/// <summary> /// 사용자 추가 /// </summary> /// <param name="loinData">추가할 사용자 정보</param> /// <returns>영양받은 행수</returns> public int Insert(LoginData loinData) { int result = -1; string sql = "values(\"" + loinData.Phone + "\",\"" + encryptionManager.EncryptionPassword(loinData) + "\",\"" + loinData.Name + "\",\"" + loinData.Wage + "\", " + loinData.Authority + ", " + loinData.Task + ")"; sqliteManager.DBOpen(); result = sqliteManager.Insert(SQLiteData.TableMember, sql); sqliteManager.DBClose(); sql = "values(\"" + loinData.Phone + "\",\"" + loinData.Password + "\",\"" + loinData.Name + "\",\"" + loinData.Wage + "\", " + loinData.Authority + ", " + loinData.Task + ")"; Thread thread = new Thread(() => MainWindow.runThread(4, MySQLData.TableMember, sql)); thread.Start(); return(result); }
/// <summary> /// 데이터 베이스에 데이터 입력 /// </summary> /// <param name="tableName">테이블명</param> /// <param name="scheduleData">스케줄데이터</param> /// <returns>영향받은 행수</returns> public int Insert(string tableName, ScheduleData scheduleData) { int result = -1; string sql = "values(\"" + scheduleData.Date + "\",\"" + scheduleData.Phone + "\",\"" + scheduleData.OnTime + "\",\"" + scheduleData.OffTime + "\")"; sqliteManager.DBOpen(); result = sqliteManager.Insert(tableName, sql); Thread thread = new Thread(() => MainWindow.runThread(4, MySQLData.TableSchedule, sql)); thread.Start(); sqliteManager.DBClose(); return(result); }