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(); }