/// <summary>
/// 스케줄 테이터 Update
/// </summary>
/// <param name="phone">입력할 테이블이름</param>
/// <param name="wageData">입력할 데이터 구조체</param>
/// <returns>영양받은 행수</returns>
public int Update(string phone, WageData wageData)
{
int result = -1;
string sql = "OnTime = \"" + wageData.OnTime + "\", OffTime = \"" + wageData.OffTime + "\", Time = \"" + wageData.Time + "\", RestTime = \"" + wageData.RestTime +
"\", ExtensionTime = \"" + wageData.ExtensionTime + "\", NightTime = \"" + wageData.NightTime + "\", TotalTime = \"" + wageData.TotalTime + "\", Wage = \""
+ wageData.Wage + "\", RestWage = \"" + wageData.RestWage + "\", " + "ExtensionWage = \"" + wageData.ExtensionWage + "\", NightWage = \"" + wageData.NightWage +
"\", TotalWage = \"" + wageData.TotalWage + "\" where Date = \"" + wageData.Date + "\"";
string year = SplitString(wageData.Date, '-')[0];
sqlliteManager.DBOpen();
result = sqlliteManager.Update(phone + year, sql);
sqlliteManager.DBClose();
sql = "OnTime = \"" + wageData.OnTime + "\", OffTime = \"" + wageData.OffTime + "\", Time = \"" + wageData.Time + "\", RestTime = \"" + wageData.RestTime +
"\", ExtensionTime = \"" + wageData.ExtensionTime + "\", NightTime = \"" + wageData.NightTime + "\", TotalTime = \"" + wageData.TotalTime + "\", Wage = \""
+ wageData.Wage + "\", RestWage = \"" + wageData.RestWage + "\", " + "ExtensionWage = \"" + wageData.ExtensionWage + "\", NightWage = \"" + wageData.NightWage +
"\", TotalWage = \"" + wageData.TotalWage + "\" where Date = \"" + wageData.Date + "\" and Phone=\"" + phone + "\"";
Thread thread = new Thread(() => MainWindow.runThread(2, MySQLData.TableWage, sql));
thread.Start();
return(result);
}
/// <summary>
/// 데이터 베이스에 데이터 변경
/// </summary>
/// <param name="tableName">테이블명</param>
/// <param name="scheduleData">스케줄데이터</param>
/// <returns>영향받은 행수</returns>
public int Update(string tableName, ScheduleData scheduleData)
{
int result = -1;
string sql = "OnTime = \"" + scheduleData.OnTime + "\", OffTime =\"" + scheduleData.OffTime + "\" where Phone = \"" + scheduleData.Phone + "\" and Date = \"" + scheduleData.Date + "\"";
sqliteManager.DBOpen();
result = sqliteManager.Update(tableName, sql);
sqliteManager.DBClose();
Thread thread = new Thread(() => MainWindow.runThread(2, MySQLData.TableSchedule, sql));
thread.Start();
return(result);
}
