public int updataemployee(DataRow Employee)
{
string sql = @" UPDATE [dbo].[T_employee]
SET
[passportNumber] = '" + Employee["passportNumber"].ToString() + @"'
,[deptID] = " + Employee["deptID"].ToString() + @"
,[subID] = '" + Employee["subID"].ToString() + @"'
,[workID] = '" + Employee["workID"].ToString() + @"'
,[userName] = '" + Employee["userName"].ToString() + @"'
,[userNameEN] = '" + Employee["userNameEN"].ToString() + @"'
,[userSexID] = " + Employee["userSexID"].ToString() + @"
,[birthday] = '" + Employee["birthday"].ToString() + @"'
,[educationID] = " + Employee["educationID"].ToString() + @"
,[hometown] = '" + Employee["hometown"].ToString() + @"'
,[phoneNumber] = '" + Employee["phoneNumber"].ToString() + @"'
,[positionID] = " + Employee["positionID"].ToString() + @"
,[entryDate] = '" + Employee["entryDate"].ToString() + @"'
,[jobChange] = '" + Employee["jobChange"].ToString() + @"'
,[assessDate] = '" + Employee["assessDate"].ToString() + @"'
,[contractFinishDate] = '" + Employee["contractFinishDate"].ToString() + @"'
,[tryFinishDate] = '" + Employee["tryFinishDate"].ToString() + @"'
,[planResignDate] = '" + Employee["planResignDate"].ToString() + @"'
,[resignDate] = '" + Employee["resignDate"].ToString() + @"'
,[resignNote] = '" + Employee["resignNote"].ToString() + @"'
,[resigned] = " + Employee["resigned"].ToString() + @"
WHERE passportNumber = '" + Employee["passportNumber"].ToString() + "'";
int i = SabrinaVisa_SqlHelper.ExecuteNonQuery(sql);
return(i);
}
public int insetCertified(DataRow CertifiedRow)
{
string VALUES = "";
VALUES = VALUES + "'" + CertifiedRow["passportNumber"].ToString() + @"','"
+ CertifiedRow["passportIssueDate"].ToString() + @"','"
+ CertifiedRow["passportFinishDate"].ToString() + @"','"
+ CertifiedRow["passportSignArea"].ToString() + @"','"
+ CertifiedRow["passportVisaNumber"].ToString() + @"','"
+ CertifiedRow["passportVisaArea"].ToString() + @"','"
+ CertifiedRow["passportVisaTimeLimit"].ToString() + @"','"
+ CertifiedRow["passportVisaFinshDate"].ToString() + @"','"
+ CertifiedRow["entryVisaDate"].ToString() + @"',"
+ CertifiedRow["workerCard"].ToString() + @",'"
+ CertifiedRow["workerCardID"].ToString() + @"',"
+ CertifiedRow["healthCard"].ToString();
string sql = @" INSERT INTO [dbo].[T_certified]
([passportNumber]
,[passportIssueDate]
,[passportFinishDate]
,[passportSignArea]
,[passportVisaNumber]
,[passportVisaArea]
,[passportVisaTimeLimit]
,[passportVisaFinshDate]
,[entryVisaDate]
,[workerCard]
,[workerCardID]
,[healthCard])
VALUES (" + VALUES + ")";
int i = SabrinaVisa_SqlHelper.ExecuteNonQuery(sql);
return(i);
}
public int updatamsg(DataRow mesRow)
{
string sql = @" UPDATE [dbo].[T_msg]
SET
[workID] = '" + mesRow["workID"].ToString() + @"'
,[msgTxt] = '" + mesRow["msgTxt"].ToString() + @"'
,[msgCheck] = " + mesRow["msgCheck"].ToString() + @"
WHERE id = '" + mesRow["id"].ToString() + "'";
int i = SabrinaVisa_SqlHelper.ExecuteNonQuery(sql);
return(i);
}
public int insetemployee(DataRow Employee)
{
string VALUES = "";
VALUES = VALUES + "'" + Employee["passportNumber"].ToString() + @"',"
+ Employee["deptID"].ToString() + @",'"
+ Employee["subID"].ToString() + @"','"
+ Employee["workID"].ToString() + @"','"
+ Employee["userName"].ToString() + @"','"
+ Employee["userNameEN"].ToString() + @"',"
+ Employee["userSexID"].ToString() + @",'"
+ Employee["birthday"].ToString() + @"',"
+ Employee["educationID"].ToString() + @",'"
+ Employee["hometown"].ToString() + @"','"
+ Employee["phoneNumber"].ToString() + @"',"
+ Employee["positionID"].ToString() + @",'"
+ Employee["entryDate"].ToString() + @"','"
+ Employee["jobChange"].ToString() + @"','"
+ Employee["assessDate"].ToString() + @"','"
+ Employee["contractFinishDate"].ToString() + @"','"
+ Employee["tryFinishDate"].ToString() + @"','"
+ Employee["planResignDate"].ToString() + @"','"
+ Employee["resignDate"].ToString() + @"','"
+ Employee["resignNote"].ToString() + @"',"
+ Employee["resigned"].ToString();
string sql = @" INSERT INTO [dbo].[T_employee]
([passportNumber]
,[deptID]
,[subID]
,[workID]
,[userName]
,[userNameEN]
,[userSexID]
,[birthday]
,[educationID]
,[hometown]
,[phoneNumber]
,[positionID]
,[entryDate]
,[jobChange]
,[assessDate]
,[contractFinishDate]
,[tryFinishDate]
,[planResignDate]
,[resignDate]
,[resignNote]
,[resigned])
VALUES (" + VALUES + ")";
int i = SabrinaVisa_SqlHelper.ExecuteNonQuery(sql);
return(i);
}
public int addJobs(string jobsName, string jobsNameEN, string org)
{
string sql = @" INSERT INTO [dbo].[T_Position]
([positionName]
,[positionNameEN]
,[Org])
VALUES
('" + jobsName + @"'
,'" + jobsNameEN + @"'
,'" + org + @"')";
int i = SabrinaVisa_SqlHelper.ExecuteNonQuery(sql);
return(i);
}
public int insetemsg(DataRow mesRow)
{
string VALUES = "";
VALUES = VALUES + "'" + mesRow["workID"].ToString() + @"','"
+ mesRow["msgTxt"].ToString() + @"',"
+ mesRow["msgCheck"].ToString();
string sql = @" INSERT INTO [dbo].[T_msg]
([workID]
,[msgTxt]
,[msgCheck])
VALUES (" + VALUES + ")";
int i = SabrinaVisa_SqlHelper.ExecuteNonQuery(sql);
return(i);
}
public int updataCertified(DataRow CertifiedRow)
{
string sql = @" UPDATE [dbo].[T_certified]
SET
[passportIssueDate] = '" + CertifiedRow["passportIssueDate"].ToString() + @"'
,[passportNumber] = '" + CertifiedRow["passportNumber"].ToString() + @"'
,[passportFinishDate] = '" + CertifiedRow["passportFinishDate"].ToString() + @"'
,[passportSignArea] = '" + CertifiedRow["passportSignArea"].ToString() + @"'
,[passportVisaNumber] = '" + CertifiedRow["passportVisaNumber"].ToString() + @"'
,[passportVisaArea] = '" + CertifiedRow["passportVisaArea"].ToString() + @"'
,[passportVisaTimeLimit] = '" + CertifiedRow["passportVisaTimeLimit"].ToString() + @"'
,[passportVisaFinshDate] = '" + CertifiedRow["passportVisaFinshDate"].ToString() + @"'
,[entryVisaDate] = '" + CertifiedRow["entryVisaDate"].ToString() + @"'
,[workerCard] = " + CertifiedRow["workerCard"].ToString() + @"
,[workerCardID] = '" + CertifiedRow["workerCardID"].ToString() + @"'
,[healthCard] = " + CertifiedRow["healthCard"].ToString() + @"
WHERE passportNumber = '" + CertifiedRow["passportNumber"].ToString() + "'";
int i = SabrinaVisa_SqlHelper.ExecuteNonQuery(sql);
return(i);
}
