public void Insert(StaffProfileInfo info)
{
db.Open();
string query = "INSERT INTO [dbo].[StaffProfile] ( [StaffNo] "
+ ",[StaffName] "
+ ",[Password] "
+ ",[Role] "
+ ",[CreateUser] "
+ ",[CreateDate] "
+ ",[LastUpdateUser] "
+ ",[LastUpdateDate] "
+ ") "
+ "VALUES ( @StaffNo "
+ ",@StaffName "
+ ",@Password "
+ ",@Role "
+ ",@CreateUser "
+ ",@CreateDate "
+ ",@LastUpdateUser "
+ ",@LastUpdateDate "
+ ") ";
db.Execute(query, info);
db.Close();
}
public bool IsExisted(StaffProfileInfo info)
{
db.Open();
String query = "select count(*) from StaffProfile "
+ " where StaffNo = @StaffNo ";
var obj = (List <int>)db.Query <int>(query, info);
db.Close();
return(obj[0] > 0);
}
public void Save(StaffProfileInfo info)
{
if (this.IsExisted(info))
{
this.Update(info);
}
else
{
this.Insert(info);
}
}
public void Update(StaffProfileInfo info)
{
db.Open();
string query = " UPDATE [dbo].[StaffProfile] SET "
+ " [StaffName] = @StaffName "
+ ", [Password] = @Password "
+ ", [Role] = @Role "
+ ", [CreateUser] = @CreateUser "
+ ", [CreateDate] = @CreateDate "
+ ", [LastUpdateUser] = @LastUpdateUser "
+ ", [LastUpdateDate] = @LastUpdateDate "
+ " where StaffNo = @StaffNo ";
db.Execute(query, info);
db.Close();
}
